Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00010
Product: FieldService (949)
Series:
Display Name: SVC_Revision_Level Group Display Name: Service Table Group
Physical Name: SVC00010
Technical Name: SVC_Revision_Level
Group Technical Name: Service
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | INTERID  | Intercompany ID | String | STR5_IC_ID | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['SVC_Revision_Level'].INTERID AS 'SVC_Revision_Level-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
SVC00010 AS ['SVC_Revision_Level']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['SVC_Revision_Level'].INTERID = ['Company Master'].INTERID | ||||||
| 2 | SVC_Major_Release | SVC_Major_Release | Integer | INT | 0 | |
| 3 | SVC_Minor_Release | SVC_Minor_Release | Integer | INT | 0 | |
| 4 | SVC_Build_Release | SVC_Build_Release | String | STR3 | 3 | |
| 5 | SVC_Install_Date | SVC_Install_Date | Date | DATE | 6 | |
| 6 | SVC_Update_Date | SVC_Update_Date | Date | DATE | 6 | |
| 7 | SVC_ServerUpd | SVC ServerUpd | String | STR2 | 2 | |
| 8 | SVC_ClientUpd | SVC ClientUpd | String | STR2 | 2 | |