Workflow Type Table (WF100001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WF100001

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Workflow Type Table
Physical Name: WF100001
Technical Name: Workflow_Type

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Workflow_Type_Name SearchWorkflow Type NameSTR50_LBAString50
2WF_Type_Description SearchWorkflow Type DescriptionSTR100String100
3FormID SearchFormIDINT5_RU0Integer5
4DICTID SearchDictIDID_INTInteger4
5SERIES SearchSeriesDDL_SeriesInteger0
6Workflow_Class SearchWorkflow ClassSTR30String30
7WINNAME SearchWindow NameSTR79String79
8Workflow_Managers SearchWorkflow ManagersGUIDStringString36
9FieldsListGuid SearchFieldsListGuidGUIDStringString36
10WfTypeBusObjKey SearchWorkflow Type Business Object KeySTR200String200
11WfTypeHistBusObjKey SearchWorkflow Type Hist Business Object KeySTR200String200
12NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Workflow Type Table'].NOTEINDX AS 'Workflow Type Table-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WF100001 AS ['Workflow Type Table']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Workflow Type Table'].NOTEINDX = ['Record Notes Master'].NOTEINDX
13DocAttachBusObjKeyFuncti SearchDocAttachBusObjKeyFunctionSTR100String100
14DocumentDrillDownFunctio SearchDocumentDrillDownFunctionSTR100String100
15DEX_ROW_TS Searchdatetimedatetime3
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
16DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *