Table idempiere11.adempiere.pp_order_node
Manufacturing Order Activity

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
name varchar 60 Alphanumeric identifier of the entity
ad_column_id numeric 10  √  null
ad_column.ad_column_id adcolumn_ppordernode R
Column in the table
ad_form_id numeric 10  √  null
ad_form.ad_form_id adform_ppordernode R
Special Form
ad_image_id numeric 10  √  null
ad_image.ad_image_id adimage_ppordernode R
Image or Icon
ad_org_id numeric 10 Organizational entity within tenant
ad_process_id numeric 10  √  null
ad_process.ad_process_id adprocess_ppordernode R
Process or Report
ad_task_id numeric 10  √  null
ad_task.ad_task_id adtask_ppordernode R
Operation System Task
ad_wf_block_id numeric 10  √  null
ad_wf_block.ad_wf_block_id adwfblock_ppordernode R
Workflow Transaction Execution Block
ad_wf_node_id numeric 10
ad_wf_node.ad_wf_node_id adwfnode_ppordernode R
Workflow Node (activity), step or process
ad_wf_responsible_id numeric 10  √  null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_ppordernode R
Responsible for Workflow Execution
ad_window_id numeric 10  √  null
ad_window.ad_window_id adwindow_ppordernode R
Data entry or display window
ad_workflow_id numeric 10
ad_workflow.ad_workflow_id adworkflow_ppordernode R
Workflow or combination of tasks
action bpchar 1 'N'::bpchar Indicates the Action to be performed
attributename varchar 60  √  null Name of the Attribute
attributevalue varchar 60  √  null Value of the Attribute
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_ppordernode R
Identifies a Business Partner
cost numeric 0 Cost information
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
datefinish timestamp 29,6  √  null Finish or (planned) completion date
datefinishschedule timestamp 29,6  √  null Scheduled Finish date for this Order
datestart timestamp 29,6  √  null Date Start for this Order
datestartschedule timestamp 29,6  √  null Scheduled start date for this Order
description varchar 255  √  null Optional short description of the record
docaction bpchar 2  √  null The targeted status of the document
docstatus bpchar 2  √  null The current status of the document
duration numeric 10  √  (0)::numeric Normal Duration in Duration Unit
durationreal numeric 10  √  null Duration Real
durationrequiered numeric 10  √  null Duration Required
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entityt_ppordernode R
Dictionary Entity Type; Determines ownership and synchronization
finishmode bpchar 1  √  null Workflow Activity Finish Mode
help varchar 2000  √  null Comment or Hint
isactive bpchar 1 The record is active in the system
iscentrallymaintained bpchar 1 Information maintained in System Element table
ismilestone bpchar 1  √  null Is Milestone
issubcontracting bpchar 1  √  null Is Subcontracting
joinelement bpchar 1 'X'::bpchar Semantics for multiple incoming Transitions
limit numeric 10 Maximum Duration in Duration Unit
movingtime numeric 10  √  null Moving Time
overlapunits numeric 10  √  null Overlap Units are number of units that must be completed before they are moved the next activity
pp_order_id numeric 10
pp_order.pp_order_id pporder_ppordernode R
Manufacturing Order
pp_order_node_id numeric 10
pp_cost_collector.pp_order_node_id ppordernode_ppcostcollector R
pp_order_node_asset.pp_order_node_id ppordernode_ppordernodeasset R
pp_order_node_product.pp_order_node_id ppordernode_ppordernodeproduct R
pp_order_node_trl.pp_order_node_id ppordernode_ppordernodetrl R
pp_order_nodenext.pp_order_next_id ppordernext_ppordernodenext R
pp_order_nodenext.pp_order_node_id ppordernode_ppordernodenext R
pp_order_workflow.pp_order_node_id ppordernode_pporderworkflow R
Workflow Node (activity), step or process
pp_order_workflow_id numeric 10
pp_order_workflow.pp_order_workflow_id pporderworkflow_ppordernode R
Manufacturing Order Workflow
priority numeric 10 Indicates if this request is of a high, medium or low priority.
qtydelivered numeric 0  √  null Delivered Quantity
qtyreject numeric 0  √  null Qty Reject
qtyrequiered numeric 0  √  null Qty Required
qtyscrap numeric 0  √  null Scrap % Quantity for this component
queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
s_resource_id numeric 10  √  null
s_resource.s_resource_id sresource_ppordernode R
Resource
setuptime numeric 10  √  null Setup time before starting Production
setuptimereal numeric 10  √  null Setup Time Real
setuptimerequiered numeric 10  √  null Setup Time Required
splitelement bpchar 1 'X'::bpchar Semantics for multiple outgoing Transitions
startmode bpchar 1  √  null Workflow Activity Start Mode
subflowexecution bpchar 1  √  null Mode how the sub-workflow is executed
unitscycles numeric 10  √  null The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
validfrom timestamp 29,6  √  null Valid from including this date (first day)
validto timestamp 29,6  √  null Valid to including this date (last day)
value varchar 40 Search key for the record in the format required - must be unique
waitingtime numeric 10 Workflow Simulation Waiting time
workflow_id numeric 10  √  null
ad_workflow.ad_workflow_id workflow_ppordernode R
Workflow or tasks
workingtime numeric 10 Workflow Simulation Execution Time
xposition numeric 10 Absolute X (horizontal) position in 1/72 of an inch
ad_client_id numeric 10 Tenant for this installation.
yposition numeric 10 Absolute Y (vertical) position in 1/72 of an inch
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
pp_order_node_uu varchar 36  √  NULL::character varying PP_Order_Node_UU

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

Indexes:
Column(s) Type Sort Constraint Name
pp_order_node_id Primary key Asc pp_order_node_key
pp_order_node_uu Must be unique Asc pp_order_node_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.