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 TypeSQL DB LengthKeyable Length
1Workflow_Type_Name SearchWorkflow Type NameSTR50_LBAString5250
2WF_Type_Description SearchWorkflow Type DescriptionSTR100String102100
3FormID SearchFormIDINT5_RU0Integer25
4DICTID SearchDictIDID_INTInteger24
5SERIES SearchSeriesDDL_SeriesInteger20
6Workflow_Class SearchWorkflow ClassSTR30String3230
7WINNAME SearchWindow NameSTR79String8079
8Workflow_Managers SearchWorkflow ManagersGUIDStringString3836
9FieldsListGuid SearchFieldsListGuidGUIDStringString3836
10WfTypeBusObjKey SearchWorkflow Type Business Object KeySTR200String202200
11WfTypeHistBusObjKey SearchWorkflow Type Hist Business Object KeySTR200String202200
12NOTEINDX SearchNote IndexDLR14Currency1014
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 SearchDocAttachBusObjKeyFunctionSTR100String102100
14DocumentDrillDownFunctio SearchDocumentDrillDownFunctionSTR100String102100
15DEX_ROW_TS Searchdatetimedatetime33
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 Searchintint1010

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 *