Table idempiere9.adempiere.ad_wf_node
Workflow Node (activity) step or process

 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
ad_wf_node_id numeric 10
ad_wf_activity.ad_wf_node_id adwfnode_adwfactivity C
ad_wf_eventaudit.ad_wf_node_id adwfnode_adwfeventaudit R
ad_wf_node_para.ad_wf_node_id adwfnode_adwfnodepara R
ad_wf_node_trl.ad_wf_node_id ad_wfnodetrl C
ad_wf_nodenext.ad_wf_next_id adwfnodenext_adwfnodenext C
ad_wf_nodenext.ad_wf_node_id adwfnode_adwfnodenext C
ad_wizardprocess.ad_wf_node_id adwfnode_adwizardprocess R
ad_workflow.ad_wf_node_id adwfnode_adworkflow R
asp_clientexception.ad_wf_node_id adwfnode_aspclientexception R
pp_order_node.ad_wf_node_id adwfnode_ppordernode R
pp_order_nodenext.ad_wf_next_id adwfnext_ppordernodenext R
pp_order_nodenext.ad_wf_node_id adwfnode_ppordernodenext R
pp_order_workflow.ad_wf_node_id adwfnode_pporderworkflow R
pp_wf_node_asset.ad_wf_node_id adwfnode_ppwfnodeasset R
pp_wf_node_product.ad_wf_node_id adwfnode_ppwfnodeproduct R
Workflow Node (activity), step or process
ad_client_id numeric 10
ad_client.ad_client_id wf_nodeclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id wf_nodeorg R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help text 2147483647  √  null Comment or Hint
ad_workflow_id numeric 10
ad_workflow.ad_workflow_id adworkflow_adwfnode C
Workflow or combination of tasks
iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
action bpchar 1 Indicates the Action to be performed
ad_window_id numeric 10  √  null
ad_window.ad_window_id adwindow_adwfnode R
Data entry or display window
workflow_id numeric 10  √  null
ad_workflow.ad_workflow_id adworkflow_adwfnodesubflow R
Workflow or tasks
ad_task_id numeric 10  √  null
ad_task.ad_task_id adtask_adwfnode R
Operation System Task
ad_process_id numeric 10  √  null
ad_process.ad_process_id adprocess_adwfnode R
Process or Report
ad_form_id numeric 10  √  null
ad_form.ad_form_id adform_adwfnode R
Special Form
entitytype varchar 40 'U'::character varying
ad_entitytype.entitytype entityt_adwfnode R
Dictionary Entity Type; Determines ownership and synchronization
xposition numeric 10 0 Absolute X (horizontal) position in 1/72 of an inch
yposition numeric 10 0 Absolute Y (vertical) position in 1/72 of an inch
ad_wf_block_id numeric 10  √  null
ad_wf_block.ad_wf_block_id adwfblock_adwfnode N
Workflow Transaction Execution Block
subflowexecution bpchar 1  √  null Mode how the sub-workflow is executed
startmode bpchar 1  √  null Workflow Activity Start Mode
finishmode bpchar 1  √  null Workflow Activity Finish Mode
limit numeric 10 0 Maximum Duration in Duration Unit
priority numeric 10  √  null Indicates if this request is of a high, medium or low priority.
duration numeric 10 0 Normal Duration in Duration Unit
cost numeric 0 0 Cost information
workingtime numeric 10  √  null Workflow Simulation Execution Time
waitingtime numeric 10 0 Workflow Simulation Waiting time
ad_wf_responsible_id numeric 10  √  null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_adwfnode R
Responsible for Workflow Execution
ad_image_id numeric 10  √  null
ad_image.ad_image_id adimage_adwfnode R
Image or Icon
joinelement bpchar 1 Semantics for multiple incoming Transitions
splitelement bpchar 1 Semantics for multiple outgoing Transitions
waittime numeric 10  √  null Time in minutes to wait (sleep)
ad_column_id numeric 10  √  null
ad_column.ad_column_id adcolumn_adwfnode R
Column in the table
attributename varchar 60  √  null Name of the Attribute
attributevalue varchar 60  √  null Value of the Attribute
docaction bpchar 2  √  null The targeted status of the document
value varchar 40 Search key for the record in the format required - must be unique
dynpriorityunit bpchar 1  √  null Change of priority when Activity is suspended waiting for user
dynprioritychange numeric 0  √  null Change of priority when Activity is suspended waiting for user
emailrecipient bpchar 1  √  null Recipient of the EMail
email varchar 60  √  null Electronic Mail Address
r_mailtext_id numeric 10  √  null
r_mailtext.r_mailtext_id rmailtext_adwfnode R
Text templates for mailings
validto timestamp 29,6  √  null Valid to including this date (last day)
ismilestone bpchar 1  √  'N'::bpchar Is Milestone
issubcontracting bpchar 1  √  'N'::bpchar Is Subcontracting
unitscycles numeric 0  √  (0)::numeric 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.
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
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_adwfnode R
Identifies a Business Partner
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_adwfnode R
Resource
setuptime numeric 10  √  null Setup time before starting Production
validfrom timestamp 29,6  √  null Valid from including this date (first day)
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
ad_wf_node_uu varchar 36  √  NULL::character varying AD_WF_Node_UU
ad_ctxhelp_id numeric 10  √  NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adwfnode R
Context Help
ad_infowindow_id numeric 10  √  NULL::numeric
ad_infowindow.ad_infowindow_id adinfowindow_adwfnode R
Info and search/select Window

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

Indexes:
Column(s) Type Sort Constraint Name
ad_wf_node_id Primary key Asc ad_wf_node_pkey
ad_wf_node_uu Must be unique Asc ad_wf_node_uu_idx
ad_workflow_id Performance Asc ad_wf_node_workflow


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.