SVC_Station_Status_View (SVC6300V)

azurecurveProductsFieldService (949)ProjectSVC_Station_Status_View (SVC6300V)

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

Product: FieldService (949)
Series: Project

Display Name: SVC_Station_Status_View
Physical Name: SVC6300V
Technical Name: SVC_Station_Status_View

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1STATIONID SearchDepot Station IDSTR10_LBAUString10
2Status SearchStatusINTInteger0
3WOStatus SearchWO StatusSTR10String10
4SVC_Depot_Priority SearchSVC_Depot_PrioritySVC_Depot_PriorityCurrency7
5WORKORDNUM SearchWork Order NumberSTR10_LBAUString10
6TECHID SearchTech IDSTR10_LBAUString10
7NAME SearchNameSTR30String30
8OFFID SearchOffice IDSTR10_LBAUString10
9ETTR SearchETTRCURR_MTTRCurrency10
10ETADTE SearchETA DateDT_DateDate6
11ETATME SearchETA TimeTM6Time6
12ECOMPDT SearchEComp DateDT_DateDate6
13EComp_Time SearchEComp TimeTM6Time6
14ACTSTRTDTE SearchActual Strt DateDT_DateDate6
15ACTSTRTTME SearchActual Start TimeTM6Time6
16DEX_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)ProjectSVC_Station_Status_View (SVC6300V)

Leave a Reply

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