Table idempiere9.adempiere.pp_order
Manufacturing Order

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
documentno varchar 60 Document sequence number of the document
s_resource_id numeric 10
s_resource.s_resource_id sresource_pporder R
Resource
m_product_id numeric 10
m_product.m_product_id mproduct_pporder R
Product, Service, Item
m_warehouse_id numeric 10
m_warehouse.m_warehouse_id mwarehouse_pporder R
Storage Warehouse and Service Point
assay numeric 0  √  (0)::numeric Indicated the Quantity Assay to use into Quality Order
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_pporder R
Business Activity
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_pporder R
Marketing Campaign
c_doctypetarget_id numeric 10 (0)::numeric
c_doctype.c_doctype_id cdoctypetarget_pporder R
Target document type for conversing documents
c_doctype_id numeric 10  √  (0)::numeric
c_doctype.c_doctype_id cdoctype_pporder R
Document type or rules
c_orderline_id numeric 10  √  null
c_orderline.c_orderline_id corderline_pporder R
Sales Order Line
c_project_id numeric 10  √  null
c_project.c_project_id cproject_pporder R
Financial Project
c_uom_id numeric 10
c_uom.c_uom_id cuom_pporder R
Unit of Measure
copyfrom bpchar 1  √  null Copy From Record
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
dateconfirm timestamp 29,6  √  null Date Confirm of this Order
datedelivered timestamp 29,6  √  null Date when the product was delivered
datefinish timestamp 29,6  √  null Finish or (planned) completion date
datefinishschedule timestamp 29,6  √  null Scheduled Finish date for this Order
dateordered timestamp 29,6 Date of Order
datepromised timestamp 29,6 Date Order was promised
datestart timestamp 29,6  √  null Date Start for this Order
datestartschedule timestamp 29,6 Scheduled start date for this Order
description varchar 510  √  null Optional short description of the record
docaction bpchar 2 '--'::bpchar The targeted status of the document
docstatus bpchar 2 'DR'::bpchar The current status of the document
floatafter numeric 0  √  null Float After
floatbefored numeric 0  √  null Float Befored
isactive bpchar 1 The record is active in the system
isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
isqtypercentage bpchar 1  √  null Indicate that this component is based in % Quantity
issotrx bpchar 1 'N'::bpchar This is a Sales Transaction
isselected bpchar 1 'N'::bpchar Selected
line numeric 10 Unique line for this document
lot varchar 20  √  null Lot number (alphanumeric)
m_attributesetinstance_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_pporder R
Product Attribute Set Instance
ordertype varchar 1  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
pp_order_id numeric 10
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
Manufacturing Order
pp_product_bom_id numeric 10
pp_product_bom.pp_product_bom_id ppproductbom_pporder R
BOM & Formula
planner_id numeric 10  √  null
ad_user.ad_user_id planner_pporder R
Planner
posted bpchar 1  √  null Posting status
priorityrule bpchar 1 Priority of a document
processed bpchar 1 'N'::bpchar The document has been processed
processing bpchar 1  √  null Process Now
qtybatchsize numeric 0  √  (0)::numeric Qty Batch Size
qtybatchs numeric 0  √  (0)::numeric Qty Batchs
qtydelivered numeric 0 (0)::numeric Delivered Quantity
qtyentered numeric 0  √  (1)::numeric The Quantity Entered is based on the selected UoM
qtyordered numeric 0 (1)::numeric Ordered Quantity
qtyreject numeric 0 (0)::numeric Qty Reject
qtyreserved numeric 0  √  null Reserved Quantity
qtyscrap numeric 0 (0)::numeric Scrap % Quantity for this componet
scheduletype varchar 1  √  'D'::character varying Type of schedule
serno varchar 20  √  null Product Serial Number
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
user1_id numeric 10  √  null
c_elementvalue.c_elementvalue_id user1_pporder R
User defined list element #1
user2_id numeric 10  √  null
c_elementvalue.c_elementvalue_id user2_pporder R
User defined list element #2
ad_client_id numeric 10 Client/Tenant for this installation.
yield numeric 0 (100)::numeric The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_pporder R
Performing or initiating organization
ad_org_id numeric 10 Organizational entity within client
ad_workflow_id numeric 10
ad_workflow.ad_workflow_id adworkflow_pporder R
Workflow or combination of tasks
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
pp_order_uu varchar 36  √  NULL::character varying PP_Order_UU

Table contained 2 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.