ad_workflow

59 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_workflow_id numeric 10 null
ad_menu.ad_workflow_id adworkflow_admenu R
ad_package_exp_common.ad_workflow_id adworkflow_adpackageexpcommon R
ad_package_exp_detail.ad_workflow_id adworkflow_adpackageexpdetail R
ad_process.ad_workflow_id adworkflow_adprocess R
ad_wf_activity.ad_workflow_id adworkflow_adwfactivity R
ad_wf_block.ad_workflow_id adworkflow_adwfblock C
ad_wf_node.ad_workflow_id adworkflow_adwfnode C
ad_wf_node.workflow_id adworkflow_adwfnodesubflow R
ad_wf_process.ad_workflow_id adworkflow_adwfprocess C
ad_workflow_access.ad_workflow_id adworkfow_workflowaccess C
ad_workflow_trl.ad_workflow_id ad_workflowtrl C
asp_clientexception.ad_workflow_id adworkflow_aspclientexception R
asp_workflow.ad_workflow_id adworkflow_aspworkflow R
hr_process.ad_workflow_id adworkflow_hrprocess R
i_productplanning.ad_workflow_id adworkflow_iproductplanning R
pp_order.ad_workflow_id adworkflow_pporder R
pp_order_cost.ad_workflow_id adworkflow_ppordercost R
pp_order_node.ad_workflow_id adworkflow_ppordernode R
pp_order_node.workflow_id workflow_ppordernode R
pp_order_workflow.ad_workflow_id adworkflow_pporderworkflow R
pp_product_planning.ad_workflow_id adworkflow_ppproductplanning R
qm_specification.ad_workflow_id adworkflow_qmspecification R
ad_client_id numeric 10 null
ad_client.ad_client_id workflowclient R
ad_org_id numeric 10 null
ad_org.ad_org_id workfloworg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help text 2147483647 √ null
accesslevel bpchar 1 null
ad_wf_node_id numeric 10 √ null
ad_wf_node.ad_wf_node_id adwfnode_adworkflow R
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adworkflow R
durationunit bpchar 1 √ null
author varchar 20 'ComPiere'::character varying
version numeric 10 0
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null
priority numeric 10 √ null
limit numeric 10 √ null
duration numeric 10 0
cost numeric 0 null
workingtime numeric 10 0
waitingtime numeric 10 0
ad_wf_responsible_id numeric 10 √ null
ad_wf_responsible.ad_wf_responsible_id adwfresponsible_adworkflow R
publishstatus bpchar 1 null
ad_workflowprocessor_id numeric 10 √ null
ad_workflowprocessor.ad_workflowprocessor_id adworkflowprocessor_adwf N
value varchar 40 null
isdefault bpchar 1 'N'::bpchar
ad_table_id numeric 10 √ null
ad_table.ad_table_id adtable_adworkflow R
validateworkflow bpchar 1 √ null
workflowtype bpchar 1 'G'::bpchar
docvaluelogic varchar 2000 √ null
isvalid bpchar 1 'N'::bpchar
s_resource_id numeric 10 √ null
s_resource.s_resource_id sresource_adworkflow R
setuptime numeric 10 √ null
movingtime numeric 10 √ null
processtype bpchar 2 √ null
documentno varchar 30 √ null
qtybatchsize numeric 0 √ (1)::numeric
queuingtime numeric 10 √ null
isbetafunctionality bpchar 1 'N'::bpchar
yield numeric 10 √ (100)::numeric
unitscycles numeric 0 √ null
overlapunits numeric 0 √ null
ad_workflow_uu varchar 36 √ NULL::character varying
ad_ctxhelp_id numeric 10 √ NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adworkflow R

Indexes

Constraint Name Type Sort Column(s)
ad_workflow_pkey Primary key Asc ad_workflow_id
ad_workflow_name Must be unique Asc/Asc ad_client_id + name
ad_workflow_uu_idx Must be unique Asc ad_workflow_uu

Check Constraints

Constraint Name Constraint
ad_workflow_isbetafunctionality_check ((isbetafunctionality = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_workflow_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation