Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR10302_Archive
Product: HRM Solution Series (1911)
Series:
Display Name: APR_TRX_Batch_Detail_COMP_Archive Group Display Name: HRM Solution Series
Physical Name: APR10302_Archive
Technical Name: APR_TRX_Batch_Detail_COMP_Archive
Group Technical Name: APR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | COMPTRNM  | Computer TRX Number | Long Integer | LI8_U0 | 8 | |
| 2 | INTERID | Intercompany ID | String | STR5_IC_ID | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['APR_TRX_Batch_Detail_COMP_Archive'].INTERID AS 'APR_TRX_Batch_Detail_COMP_Archive-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
APR10302_Archive AS ['APR_TRX_Batch_Detail_COMP_Archive']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['APR_TRX_Batch_Detail_COMP_Archive'].INTERID = ['Company Master'].INTERID | ||||||
| 3 | CB_Override_Pay_Rate | CB Override Pay Rate | Boolean | CB | 0 | |