Table idempiere9.adempiere.i_productplanning
Import 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
i_productplanning_id numeric 10 Import Product Planning
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
isactive bpchar 1 'Y'::bpchar The record is active in the system
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
bpartner_value varchar 40  √  NULL::character varying The Key of the Business Partner
c_bpartner_id numeric 10  √  NULL::numeric
c_bpartner.c_bpartner_id cbpartner_iproductplanning R
Identifies a Business Partner
i_errormsg varchar 2000  √  NULL::character varying Messages generated from import process
i_isimported bpchar 1 Has this import been processed
processed bpchar 1  √  NULL::bpchar The document has been processed
processing bpchar 1  √  NULL::bpchar Process Now
ad_workflow_id numeric 10  √  NULL::numeric
ad_workflow.ad_workflow_id adworkflow_iproductplanning R
Workflow or combination of tasks
dd_networkdistribution_id numeric 10  √  NULL::numeric
dd_networkdistribution.dd_networkdistribution_id ddnetworkdistribution_iproduct R
Network Distribution
deliverytime_promised numeric 0  √  null Promised days between order and delivery
iscreateplan bpchar 1 Indicates whether planned orders will be generated by MRP
ismps bpchar 1  √  NULL::bpchar Is MPS
isphantom bpchar 1 Phantom Component
m_product_id numeric 10  √  NULL::numeric
m_product.m_product_id mproduct_iproductplanning R
Product, Service, Item
m_warehouse_id numeric 10  √  NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_iproductplanning 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::character varying Order Policy
order_qty numeric 0  √  null Order Qty
planner_id numeric 10  √  NULL::numeric
ad_user.ad_user_id planner_iproductplanning R
Planner
pp_product_bom_id numeric 10  √  NULL::numeric
pp_product_bom.pp_product_bom_id ppproductbom_iproductplanning R
BOM & Formula
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
s_resource_id numeric 10  √  NULL::numeric
s_resource.s_resource_id sresource_iproductplanning R
Resource
timefence numeric 0  √  null Time Fence
transferttime numeric 0  √  null Transfert Time
workingtime numeric 0  √  null Workflow Simulation Execution Time
yield numeric 10  √  NULL::numeric The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
datepromised timestamp 29,6  √  null Date Order was promised
m_forecast_id numeric 10  √  NULL::numeric
m_forecast.m_forecast_id mforecast_iproductplanning R
Material Forecast
qty numeric 0 Quantity
salesrep_id numeric 10  √  NULL::numeric
ad_user.ad_user_id salesrep_iproductplanning R
Sales Representative or Company Agent
productvalue varchar 40  √  NULL::character varying Key of the Product
warehousevalue varchar 40  √  NULL::character varying Key of the Warehouse
orgvalue varchar 40  √  NULL::character varying Key of the Organization
networkdistributionvalue varchar 40  √  NULL::character varying Key of the Network Distribution
product_bom_value varchar 40  √  NULL::character varying Key of Product BOM
forecastvalue varchar 40  √  NULL::character varying Key of the Forecast
resourcevalue varchar 40  √  NULL::character varying Key of the Resource
plannervalue varchar 40  √  NULL::character varying Search Key of the Planning
m_forecastline_id numeric 10  √  NULL::numeric
m_forecastline.m_forecastline_id mforecastline_iproductplanning R
Forecast Line
pp_product_planning_id numeric 10  √  NULL::numeric
pp_product_planning.pp_product_planning_id ppproductplanning_iproductplan R
Product Planning
vendorproductno varchar 30  √  NULL::character varying Product Key of the Business Partner
i_productplanning_uu varchar 36  √  NULL::character varying I_ProductPlanning_UU

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

Indexes:
Column(s) Type Sort Constraint Name
i_productplanning_id Primary key Asc i_productplanning_key
i_productplanning_uu Must be unique Asc i_productplanning_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.