Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC05003
Product: FieldService (949)
Series:
Display Name: SVC_Codes_RTV_Type Group Display Name: Service Table Group
Physical Name: SVC05003
Technical Name: SVC_Codes_RTV_Type
Group Technical Name: Service
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | RTV_Type | RTV Type | String | STR10_LBAU | 10 | |
2 | DSCRIPTN | Description | String | STR30 | 30 | |
3 | ITLOCN | Intransit Location | String | STR10_Location_Code | 10 | |
4 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['SVC_Codes_RTV_Type'].LOCNCODE AS 'SVC_Codes_RTV_Type-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SVC05003 AS ['SVC_Codes_RTV_Type']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SVC_Codes_RTV_Type'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
5 | RTV_Return_Status | RTV Return Status | String | STR3_LBAU | 3 | |
6 | RTV_Shipping_Status | RTV Shipping Status | String | STR3_LBAU | 3 | |
7 | RTV_Received_Status | RTV Received Status | String | STR3_LBAU | 3 | |
8 | RTV_Closed_Status | RTV Closed Status | String | STR3_LBAU | 3 | |
9 | RTV_Routing | RTV Routing | Integer | INT | 0 | |
10 | SVC_Purchase_Index | SVC Purchase Index | Long Integer | LI_14 | 14 | |
11 | SVC_Cost_Index | SVC Cost Index | Long Integer | LI_14 | 14 | |
12 | SVC_Reimbursement_Index | SVC Reimbursement Index | Long Integer | LI_14 | 14 | |
13 | SVC_Ready_To_Ship_Status | SVC Ready To Ship Status | String | STR3_LBAU | 3 | |
14 | SVC_Partial_Shipped_Stat | SVC Partial Shipped Status | String | STR3_LBAU | 3 | |
15 | SVC_Partial_Received_Sta | SVC Partial Received Status | String | STR3_LBAU | 3 |