Table idempiere11.adempiere.pp_order_node
Manufacturing Order Activity

 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
name varchar 60 Alphanumeric identifier of the entity
ad_column_id numeric 10  √  null
ad_column
Column in the table
ad_form_id numeric 10  √  null
ad_form
Special Form
ad_image_id numeric 10  √  null
ad_image
Image or Icon
ad_org_id numeric 10 Organizational entity within tenant
ad_process_id numeric 10  √  null
ad_process
Process or Report
ad_task_id numeric 10  √  null
ad_task
Operation System Task
ad_wf_block_id numeric 10  √  null
ad_wf_block
Workflow Transaction Execution Block
ad_wf_node_id numeric 10
ad_wf_node
Workflow Node (activity), step or process
ad_wf_responsible_id numeric 10  √  null
ad_wf_responsible
Responsible for Workflow Execution
ad_window_id numeric 10  √  null
ad_window
Data entry or display window
ad_workflow_id numeric 10
ad_workflow
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
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
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
Manufacturing Order
pp_order_node_id numeric 10
pp_cost_collector
pp_order_node_asset
pp_order_node_product
pp_order_node_trl
pp_order_nodenext
pp_order_nodenext
pp_order_workflow
Workflow Node (activity), step or process
pp_order_workflow_id numeric 10
pp_order_workflow
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
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
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
pp_order_node_id Primary key Asc
pp_order_node_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.