dd_order_header_v

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
ad_language varchar 2147483647 √ null
dd_order_id numeric 10 √ null
dd_order.dd_order_id Implied Constraint R
c_order_id numeric 10 √ null
c_order.c_order_id Implied Constraint R
issotrx bpchar 1 √ null
documentno varchar 30 √ null
docstatus bpchar 2 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
bpvalue varchar 40 √ null
bptaxid varchar 20 √ null
naics varchar 6 √ null
duns varchar 11 √ null
org_location_id numeric 10 √ null
taxid varchar 20 √ null
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
warehouse_location_id numeric 10 √ null
documenttype varchar 60 √ null
documenttypenote varchar 2000 √ null
salesrep_id numeric 10 √ null
salesrep_name varchar 2147483647 √ null
character_entity.name Implied Constraint R
dateordered timestamp 29,6 √ null
datepromised timestamp 29,6 √ null
bpgreeting varchar 60 √ null
name varchar 120 √ null
name2 varchar 60 √ null
bpcontactgreeting varchar 60 √ null
title varchar 40 √ null
phone varchar 40 √ null
contactname text 2147483647 √ null
c_location_id numeric 10 √ null
c_location.c_location_id Implied Constraint R
postal text 2147483647 √ null
referenceno varchar 40 √ null
description varchar 255 √ null
poreference varchar 20 √ null
c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R
chargeamt numeric 0 √ null
volume numeric 0 √ null
weight numeric 0 √ null
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id Implied Constraint R
deliveryrule bpchar 1 √ null
deliveryviarule bpchar 1 √ null
priorityrule bpchar 1 √ null
logo_id numeric 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views