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

View Definition