Service Type Validation Codes (SVC00920)

azurecurveProductsFieldService (949)ProjectService Type Validation Codes (SVC00920)

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

Product: FieldService (949)
Series: Project

Display Name: Service Type Validation Codes
Physical Name: SVC00920
Technical Name: SVC_Codes_Service_Type

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SRVTYPE SearchService TypeSTR10_LBAUString1210
2DSCRIPTN SearchDescriptionSTR30String3230
3LABITMST SearchLabor Item StandardSTR30_Item_NumberString3230
4LABITMOV SearchLabor Item OvertimeSTR30_Item_NumberString3230
5LABITMDB SearchLabor Item DoubleTimeSTR30_Item_NumberString3230
6Hotline_Labor_Item SearchHotline Labor ItemSTR30_Item_NumberString3230
7Travel_Labor_Item SearchTravel Labor ItemSTR30_Item_NumberString3230
8TECHID SearchTech IDSTR10_LBAUString1210
9PMFLAG SearchPM FlagCBBoolean20
10CONTFLAG SearchContract FlagCBBoolean20
11SVC_Service_Batch_ID SearchSVC Service Batch IDSTR15_LBAUString1615
12SVC_Service_Document_ID SearchSVC Service Document IDSTR15_LBAUString1615
13SVC_Sales_Only SearchSVC Sales OnlyCBBoolean20
14SVC_S_Credit_Batch_ID SearchSVC S Credit Batch IDSTR15_LBAUString1615
15SVC_S_Credit_Document_ID SearchSVC S Credit Document IDSTR15_LBAUString1615
16SVC_Zero_Batch_ID SearchSVC Zero Batch IDSTR15_LBAUString1615
17SVC_Zero_Document_ID SearchSVC Zero Document IDSTR15_LBAUString1615
18SVC_Minimum_Labor SearchSVC Minimum LaborSTR_Bill_TimeString86
19SVC_Minimum_Travel SearchSVC Minimum TravelSTR_Bill_TimeString86
20SVC_Minimum_Hotline SearchSVC Minimum HotlineSTR_Bill_TimeString86
21SVC_Rounded_Labor SearchSVC Rounded LaborSTR_Bill_TimeString86
22SVC_Rounded_Travel SearchSVC Rounded TravelSTR_Bill_TimeString86
23SVC_Rounded_Hotline SearchSVC Rounded HotlineSTR_Bill_TimeString86
24SVC_Sales_Index_Part SearchSVC Sales Index PartLI_14Long Integer414
25SVC_Sales_Index_Labor SearchSVC Sales Index LaborLI_14Long Integer414
26SVC_Sales_Index_Misc SearchSVC Sales Index MiscLI_14Long Integer414
27SVC_Sales_Index_Expense SearchSVC Sales Index ExpenseLI_14Long Integer414
28SVC_COGS_Index_Part SearchSVC COGS Index PartLI_14Long Integer414
29SVC_COGS_Index_Labor SearchSVC COGS Index LaborLI_14Long Integer414
30SVC_COGS_Index_Misc SearchSVC COGS Index MiscLI_14Long Integer414
31SVC_COGS_Index_Expense SearchSVC COGS Index ExpenseLI_14Long Integer414
32SVC_Sales_Return_Index SearchSVC Sales Return IndexLI_14Long Integer414
33svcPayableBatchID SearchsvcPayableBatchIDSTR15_LBAUString1615
34svcSubcontractor SearchsvcSubcontractorCBBoolean20
35DEX_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 Type Validation Codes (SVC00920)

Leave a Reply

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