Table idempiere11.adempiere.pp_order_workflow
Manufacturing Order Workflow

 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
workflowtype bpchar 1  √  'M'::bpchar Type of Workflow
name varchar 60 Alphanumeric identifier of the entity
ad_table_id numeric 10  √  null
ad_table.ad_table_id adtable_pporderworkflow R
Database Table information
ad_wf_node_id numeric 10  √  null
ad_wf_node.ad_wf_node_id adwfnode_pporderworkflow R
Workflow Node (activity), step or process
ad_wf_responsible_id numeric 10  √  null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_pporderworkflo R
Responsible for Workflow Execution
ad_workflowprocessor_id numeric 10  √  null
ad_workflowprocessor.ad_workflowprocessor_id adworkflowprocessor_pporderwor R
Workflow Processor Server
ad_workflow_id numeric 10
ad_workflow.ad_workflow_id adworkflow_pporderworkflow R
Workflow or combination of tasks
accesslevel bpchar 1 Access Level required
author varchar 20 Author/Creator of the Entity
cost numeric 0  √  null Cost information
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
description varchar 255  √  null Optional short description of the record
documentno varchar 32  √  null Document sequence number of the document
duration numeric 10 (0)::numeric Normal Duration in Duration Unit
durationunit bpchar 1 'h'::bpchar Unit of Duration
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entityt_pporderworkflow R
Dictionary Entity Type; Determines ownership and synchronization
help varchar 2000  √  null Comment or Hint
isactive bpchar 1 The record is active in the system
isdefault bpchar 1  √  null Default value
limit numeric 10 Maximum Duration in Duration Unit
movingtime numeric 10  √  null Moving Time
pp_order_id numeric 10
pp_order.pp_order_id pporder_pporderworkflow R
Manufacturing Order
pp_order_node_id numeric 10  √  null
pp_order_node.pp_order_node_id ppordernode_pporderworkflow R
Workflow Node (activity), step or process
pp_order_workflow_id numeric 10
pp_cost_collector.pp_order_workflow_id pporderworkflow_ppcostcollecto R
pp_order_node.pp_order_workflow_id pporderworkflow_ppordernode R
pp_order_node_asset.pp_order_workflow_id pporderworkflow_ppordernodeass R
pp_order_node_product.pp_order_workflow_id pporderworkflow_ppordernodepro R
pp_order_workflow_trl.pp_order_workflow_id pporderworkflow_pporderworkflo R
Manufacturing Order Workflow
priority numeric 10 Indicates if this request is of a high, medium or low priority.
processtype bpchar 2  √  null Process Type
publishstatus bpchar 1 'U'::bpchar Status of Publication
qtybatchsize numeric 0  √  (1)::numeric Qty Batch Size
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_pporderworkflow R
Resource
setuptime numeric 10  √  null Setup time before starting Production
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)
validateworkflow bpchar 1  √  null Validate Workflow
value varchar 240  √  null Search key for the record in the format required - must be unique
version numeric 10 Version of the table definition
waitingtime numeric 10 Workflow Simulation Waiting time
ad_client_id numeric 10 Tenant for this installation.
workingtime numeric 10  √  null Workflow Simulation Execution Time
ad_org_id numeric 10 Organizational entity within tenant
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
unitscycles numeric 0  √  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.
overlapunits numeric 0  √  null Overlap Units are number of units that must be completed before they are moved the next activity
pp_order_workflow_uu varchar 36  √  NULL::character varying PP_Order_Workflow_UU

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

Indexes:
Column(s) Type Sort Constraint Name
pp_order_workflow_id Primary key Asc pp_order_workflow_key
pp_order_workflow_uu Must be unique Asc pp_order_workflow_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.