pp_order

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
documentno varchar 60 null
s_resource_id numeric 10 null
s_resource.s_resource_id sresource_pporder R
m_product_id numeric 10 null
m_product.m_product_id mproduct_pporder R
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_pporder R
assay numeric 0 √ (0)::numeric
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_pporder R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_pporder R
c_doctypetarget_id numeric 10 (0)::numeric
c_doctype.c_doctype_id cdoctypetarget_pporder R
c_doctype_id numeric 10 √ (0)::numeric
c_doctype.c_doctype_id cdoctype_pporder R
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_pporder R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_pporder R
c_uom_id numeric 10 null
c_uom.c_uom_id cuom_pporder R
copyfrom bpchar 1 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
dateconfirm timestamp 29,6 √ null
datedelivered timestamp 29,6 √ null
datefinish timestamp 29,6 √ null
datefinishschedule timestamp 29,6 √ null
dateordered timestamp 29,6 null
datepromised timestamp 29,6 null
datestart timestamp 29,6 √ null
datestartschedule timestamp 29,6 null
description varchar 510 √ null
docaction bpchar 2 '--'::bpchar
docstatus bpchar 2 'DR'::bpchar
floatafter numeric 0 √ null
floatbefored numeric 0 √ null
isactive bpchar 1 null
isapproved bpchar 1 'N'::bpchar
isprinted bpchar 1 'N'::bpchar
isqtypercentage bpchar 1 √ null
issotrx bpchar 1 'N'::bpchar
isselected bpchar 1 'N'::bpchar
line numeric 10 null
lot varchar 20 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_pporder R
ordertype varchar 1 √ null
pp_order_id numeric 10 null
pp_cost_collector.pp_order_id pporder_ppcostcollector R
pp_mrp.pp_order_id pporder_ppmrp R
pp_order_bom.pp_order_id pporder_pporderbom R
pp_order_bomline.pp_order_id pporder_pporderbomline R
pp_order_cost.pp_order_id pporder_ppordercost R
pp_order_node.pp_order_id pporder_ppordernode R
pp_order_node_asset.pp_order_id pporder_ppordernodeasset R
pp_order_node_product.pp_order_id pporder_ppordernodeproduct R
pp_order_nodenext.pp_order_id pporder_ppordernodenext R
pp_order_workflow.pp_order_id pporder_pporderworkflow R
pp_product_bom_id numeric 10 null
pp_product_bom.pp_product_bom_id ppproductbom_pporder R
planner_id numeric 10 √ null
ad_user.ad_user_id planner_pporder R
posted bpchar 1 √ null
priorityrule bpchar 1 null
processed bpchar 1 'N'::bpchar
processing bpchar 1 √ null
qtybatchsize numeric 0 √ (0)::numeric
qtybatchs numeric 0 √ (0)::numeric
qtydelivered numeric 0 (0)::numeric
qtyentered numeric 0 √ (1)::numeric
qtyordered numeric 0 (1)::numeric
qtyreject numeric 0 (0)::numeric
qtyreserved numeric 0 √ null
qtyscrap numeric 0 (0)::numeric
scheduletype varchar 1 √ 'D'::character varying
serno varchar 20 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id user1_pporder R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id user2_pporder R
ad_client_id numeric 10 null
yield numeric 0 (100)::numeric
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_pporder R
ad_org_id numeric 10 null
ad_workflow_id numeric 10 null
ad_workflow.ad_workflow_id adworkflow_pporder R
processedon numeric 0 √ null
pp_order_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
pp_order_key Primary key Asc pp_order_id
idxpp_order_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id
pp_order_c_orderline_id_idx Performance Asc c_orderline_id
pp_order_uu_idx Must be unique Asc pp_order_uu

Check Constraints

Constraint Name Constraint
pp_order_isselected_check ((isselected = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_order_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_order_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_order_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_order_isqtypercentage_check ((isqtypercentage = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_order_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pp_order_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation