Table idempiere11.adempiere.pp_order_cost
Manufacturing Order Cost

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
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
ad_workflow_id numeric 10  √  null
ad_workflow.ad_workflow_id adworkflow_ppordercost R
Workflow or combination of tasks
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_ppordercost R
Rules for accounting
costingmethod bpchar 1  √  'x'::bpchar Indicates how Costs will be calculated
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
cumulatedamt numeric 0  √  null Total Amount
cumulatedamtpost numeric 0  √  null Cumulated Amt Post
cumulatedqty numeric 0  √  null Total Quantity
cumulatedqtypost numeric 0  √  null Cumulated Qty Post
currentcostprice numeric 0  √  null The currently used cost price
currentcostpricell numeric 0  √  null Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
currentqty numeric 0  √  null Current Quantity
isactive bpchar 1 The record is active in the system
m_attributesetinstance_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_pporderc R
Product Attribute Set Instance
m_costelement_id numeric 10  √  null
m_costelement.m_costelement_id mcostelement_ppordercost R
Product Cost Element
m_costtype_id numeric 10
m_costtype.m_costtype_id mcosttype_ppordercost R
Type of Cost (e.g. Current, Plan, Future)
m_product_id numeric 10
m_product.m_product_id mproduct_ppordercost R
Product, Service, Item
pp_order_cost_id numeric 10 Manufacturing Order Cost
pp_order_id numeric 10
pp_order.pp_order_id pporder_ppordercost R
Manufacturing Order
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
pp_order_cost_uu varchar 36  √  NULL::character varying PP_Order_Cost_UU

Table contained 0 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
pp_order_cost_id Primary key Asc pp_order_cost_key
pp_order_cost_uu Must be unique Asc pp_order_cost_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.