Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IC40100
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Intercompany Account Setup Group Display Name: Intercompany Setup
Physical Name: IC40100
Technical Name: IC_Account_SETP
Group Technical Name: Intercompany Setup
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ORCOMID  | Originating Company ID | String | STR5_IC_ID | 5 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['Intercompany Account Setup'].ORCOMID AS 'Intercompany Account Setup-Originating Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
IC40100 AS ['Intercompany Account Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Intercompany Account Setup'].ORCOMID = ['Company Master'].CMPANYID | ||||||
| 2 | DSTCOMID | Destination Company ID | String | STR5_IC_ID | 5 | |
| 3 | ORGFRIDX | Originating Due From Index | Long Integer | LI_14 | 14 | |
| 4 | ORGTOIDX | Originating Due To Index | Long Integer | LI_14 | 14 | |
| 5 | DSTFRIDX | Destination Due From Index | Long Integer | LI_14 | 14 | |
| 6 | DSTTOIDX | Destination Due To Index | Long Integer | LI_14 | 14 | |
| 7 | USER2ENT | User To Enter | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Intercompany Account Setup'].USER2ENT AS 'Intercompany Account Setup-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IC40100 AS ['Intercompany Account Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Intercompany Account Setup'].USER2ENT = ['Users Master'].USERID | ||||||
| 8 | CREATDDT | Created Date | Date | DT | 8 | |
| 9 | MODIFDT | Modified Date | Date | DT | 8 | |
| 10 | MDFUSRID | Modified User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Intercompany Account Setup'].MDFUSRID AS 'Intercompany Account Setup-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
IC40100 AS ['Intercompany Account Setup']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Intercompany Account Setup'].MDFUSRID = ['Users Master'].USERID | ||||||