svcPayrollLaborLine (SVC00120)

azurecurveProductsFieldService (949)ProjectsvcPayrollLaborLine (SVC00120)

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

Product: FieldService (949)
Series: Project

Display Name: svcPayrollLaborLine
Physical Name: SVC00120
Technical Name: svcPayrollLaborLine

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SVC_Document_Type SearchSVC Document TypeSVC DDL Doc TypeInteger20
2RCRDTYPE SearchRecord TypeINT1Integer21
3DOCID SearchDocument IDSTR15_LBAUString1615
4EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer410
5LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
6TECHID SearchTech IDSTR10_LBAUString1210
7Work_Type SearchWork TypeSTR10_LBAUString1210
8STATIONID SearchDepot Station IDSTR10_LBAUString1210
9EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
10PayCode SearchPay CodeSTR6_Payroll_CodeString86
11DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
12JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
13STATECD SearchState CodeSTR2_State_CodeString42
14LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
15SUTASTAT SearchSuta StateSTR2_State_CodeString42
16WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
17SHFTCODE SearchShift CodeSTR6_Payroll_CodeString86
18TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
19STRTDATE SearchStart DateDTDate48
20STRTTIME SearchStart TimeTM6Time46
21ENDDATE SearchEnd DateDTDate48
22ENDTIME SearchEnd TimeTM6Time46
23POSTED SearchPostedTrue/FalseBoolean20
24DEX_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.

azurecurveProductsFieldService (949)ProjectsvcPayrollLaborLine (SVC00120)

Leave a Reply

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