dd_order

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
documentno varchar 30 null
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_ddorder R
ad_org_id numeric 10 null
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_ddorder R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_ddorder R
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_ddorder R
c_bpartner_location_id numeric 10 null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_ddorder R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_ddorder R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_ddorder R
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_ddorder R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_ddorder R
c_order_id numeric 10 √ null
c_order.c_order_id corder_ddorder R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_ddorder R
chargeamt numeric 0 √ null
createconfirm bpchar 1 √ null
createfrom bpchar 1 √ null
createpackage bpchar 1 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
dd_order_id numeric 10 null
dd_order_header_v.dd_order_id Implied Constraint R
dd_order_header_vt.dd_order_id Implied Constraint R
dd_orderline.dd_order_id ddorder_ddorderline R
m_movement.dd_order_id ddorder_mmovement R
m_movement_candidate_v.dd_order_id Implied Constraint R
pp_mrp.dd_order_id ddorder_ppmrp R
rv_dd_orderdetail.dd_order_id Implied Constraint R
dateordered timestamp 29,6 null
dateprinted timestamp 29,6 √ null
datepromised timestamp 29,6 null
datereceived timestamp 29,6 √ null
deliveryrule bpchar 1 'A'::bpchar
deliveryviarule bpchar 1 'P'::bpchar
description varchar 255 √ null
docaction bpchar 2 'CO'::bpchar
docstatus bpchar 2 'DR'::bpchar
freightamt numeric 0 √ null
freightcostrule bpchar 1 'I'::bpchar
generateto bpchar 1 √ null
isactive bpchar 1 'Y'::bpchar
isapproved bpchar 1 null
isdelivered bpchar 1 √ null
isdropship bpchar 1 √ null
isindispute bpchar 1 null
isintransit bpchar 1 null
isprinted bpchar 1 null
issotrx bpchar 1 null
isselected bpchar 1 √ null
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id mshipper_ddorder R
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_ddorder R
nopackages numeric 10 √ null
poreference varchar 20 √ null
pickdate timestamp 29,6 √ null
posted bpchar 1 null
priorityrule bpchar 1 '5'::bpchar
processed bpchar 1 null
processing bpchar 1 √ null
ref_order_id numeric 10 √ null
c_order.c_order_id reforder_ddorder R
salesrep_id numeric 10 √ null
ad_user.ad_user_id salesrep_ddorder R
sendemail bpchar 1 null
shipdate timestamp 29,6 √ null
trackingno varchar 60 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id user1_ddorder R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id user2_ddorder R
volume numeric 0 √ null
ad_client_id numeric 10 null
weight numeric 0 √ null
processedon numeric 0 √ null
dd_order_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
dd_order_key Primary key Asc dd_order_id
dd_order_uu_idx Must be unique Asc dd_order_uu
idxdd_order_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id

Check Constraints

Constraint Name Constraint
dd_order_sendemail_check ((sendemail = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isselected_check ((isselected = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isdropship_check ((isdropship = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isintransit_check ((isintransit = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isindispute_check ((isindispute = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
dd_order_isdelivered_check ((isdelivered = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation