Table idempiere11.adempiere.pp_product_planning
Product Planning

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 (0)::numeric Organizational entity within tenant
ad_workflow_id numeric 10  √  null
ad_workflow.ad_workflow_id adworkflow_ppproductplanning R
Workflow or combination of tasks
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
deliverytime_promised numeric 0  √  null Promised days between order and delivery
isactive bpchar 1 The record is active in the system
iscreateplan bpchar 1 'Y'::bpchar Indicates whether planned orders will be generated by MRP
isissue bpchar 1 'Y'::bpchar
ismps bpchar 1  √  null Is MPS
isphantom bpchar 1 Phantom Component
isrequiredmrp bpchar 1 Required Calculate MRP
m_product_id numeric 10
m_product.m_product_id mproduct_ppproductplanning R
Product, Service, Item
m_warehouse_id numeric 10  √  null
m_warehouse.m_warehouse_id mwarehouse_ppproductplanning R
Storage Warehouse and Service Point
order_max numeric 0  √  null Maximum order quantity in UOM
order_min numeric 0  √  null Minimum order quantity in UOM
order_pack numeric 0  √  null Package order size in UOM (e.g. order set of 5 units)
order_period numeric 0  √  null Order Period
order_policy varchar 3  √  null Order Policy
order_qty numeric 0  √  null Order Qty
pp_product_bom_id numeric 10  √  null
pp_product_bom.pp_product_bom_id ppproductbom_ppproductplanning R
BOM & Formula
pp_product_planning_id numeric 10
i_productplanning.pp_product_planning_id ppproductplanning_iproductplan R
Product Planning
planner_id numeric 10  √  null
ad_user.ad_user_id planner_ppproductplanning R
Planner
s_resource_id numeric 10  √  null
s_resource.s_resource_id sresource_ppproductplanning R
Resource
timefence numeric 0  √  null Time Fence
transferttime numeric 0  √  null Transfer Time
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
workingtime numeric 0  √  null Workflow Simulation Execution Time
yield numeric 10  √  (100)::numeric The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
dd_networkdistribution_id numeric 10  √  null
dd_networkdistribution.dd_networkdistribution_id ddnetworkdistribution_ppproduc R
Network Distribution
safetystock numeric 0  √  null Safety stock is a term used to describe a level of stock that is maintained below the cycle stock to buffer against stock-outs
isrequireddrp bpchar 1 'N'::bpchar Required Calculate DRP
pp_product_planning_uu varchar 36  √  NULL::character varying PP_Product_Planning_UU

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

Indexes:
Column(s) Type Sort Constraint Name
pp_product_planning_id Primary key Asc pp_product_planning_key
pp_product_planning_uu Must be unique Asc pp_product_planning_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.