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 TypeLength
1SVC_Document_Type SearchSVC Document TypeSVC DDL Doc TypeInteger0
2RCRDTYPE SearchRecord TypeINT1Integer1
3DOCID SearchDocument IDSTR15_LBAUString15
4EQPLINE SearchEquipment Line Item SequenceLI_Sequence_NumberLong Integer10
5LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
6TECHID SearchTech IDSTR10_LBAUString10
7Work_Type SearchWork TypeSTR10_LBAUString10
8STATIONID SearchDepot Station IDSTR10_LBAUString10
9EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
10PayCode SearchPay CodeSTR6_Payroll_CodeString6
11DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
12JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
13STATECD SearchState CodeSTR2_State_CodeString2
14LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString6
15SUTASTAT SearchSuta StateSTR2_State_CodeString2
16WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
17SHFTCODE SearchShift CodeSTR6_Payroll_CodeString6
18TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
19STRTDATE SearchStart DateDTDate8
20STRTTIME SearchStart TimeTM6Time6
21ENDDATE SearchEnd DateDTDate8
22ENDTIME SearchEnd TimeTM6Time6
23POSTED SearchPostedTrue/FalseBoolean0
24DEX_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.

azurecurveProductsFieldService (949)ProjectsvcPayrollLaborLine (SVC00120)

Leave a Reply

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