SVC_ExtPricing_PriceLevel (SVC00110)

azurecurveProductsFieldService (949)ProjectSVC_ExtPricing_PriceLevel (SVC00110)

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

Product: FieldService (949)
Series: Project

Display Name: SVC_ExtPricing_PriceLevel
Physical Name: SVC00110
Technical Name: SVC_ExtPricing_PriceLevel

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PRICELVL SearchPrice LevelSTR15_LBAUString1615
2RTRNABLE SearchReturnableCBBoolean20
3SVC_Standard_Percent SearchSVC Standard PercentDLR5_%2Currency108
4SVC_Overtime_Percent SearchSVC Overtime PercentDLR5_%2Currency108
5SVC_Double_Percent SearchSVC Double PercentDLR5_%2Currency108
6SVC_Hotline_Percent SearchSVC Hotline PercentDLR5_%2Currency108
7SVC_Travel_Percent SearchSVC Travel PercentDLR5_%2Currency108
8SVC_Return_Percent SearchSVC Return PercentDLR5_%2Currency108
9DEX_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)ProjectSVC_ExtPricing_PriceLevel (SVC00110)

Leave a Reply

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