Service Call Service Task History (SVC30240)

azurecurveProductsFieldService (949)ProjectService Call Service Task History (SVC30240)

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

Product: FieldService (949)
Series: Project

Display Name: Service Call Service Task History
Physical Name: SVC30240
Technical Name: SVC_Service_Call_Service_Task_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CALLNBR SearchService Call NumberSTR10_LBAUString1210
2SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger20
3SRVCCD SearchService CodeSTR10_LBAUString1210
4TASKCD SearchTask_CodeSTR10_LBAUString1210
5TASKREQ SearchTask_RequiredCBBoolean20
6TASKCOMP SearchTask_CompletedCBBoolean20
7TASKUSERID SearchTask_UserSTR15_User_IDString1615
8TASKDATE SearchTask_DateDTDate48
9TASKTIME SearchTask_TimeTM6Time46
10TASKETTC SearchTask_Est_Time_To_CompleteSTR_Bill_TimeString86
11TASKATTC SearchTask_Actual_Time_To_CompleteSTR_Bill_TimeString86
12TECHID SearchTech IDSTR10_LBAUString1210
13DEX_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)ProjectService Call Service Task History (SVC30240)

Leave a Reply

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