Table idempiere9.adempiere.pp_product_planning
Product Planning

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 (0)::numeric Organizational entity within client
ad_workflow_id numeric 10  √  null
ad_workflow
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
Product, Service, Item
m_warehouse_id numeric 10  √  null
m_warehouse
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
BOM & Formula
pp_product_planning_id numeric 10
i_productplanning
Product Planning
planner_id numeric 10  √  null
ad_user
Planner
s_resource_id numeric 10  √  null
s_resource
Resource
timefence numeric 0  √  null Time Fence
transferttime numeric 0  √  null Transfert 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
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 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort
pp_product_planning_id Primary key Asc
pp_product_planning_uu Must be unique Asc


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.