Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DD40400
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Direct Deposit ACH Header Setup Group Display Name: Payroll Direct Deposit Setup
Physical Name: DD40400
Technical Name: ddACHHdrSetup
Group Technical Name: Payroll Direct Deposit Setup
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | CMPANYID | Company ID | Integer | INT5 | 4 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['Direct Deposit ACH Header Setup'].CMPANYID AS 'Direct Deposit ACH Header Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
DD40400 AS ['Direct Deposit ACH Header Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Direct Deposit ACH Header Setup'].CMPANYID = ['Company Master'].CMPANYID | ||||||
2 | DDDESC10 | DD DescriptionStr10 | String | DD_STR10 | 10 | |
3 | INDXLONG | IndexLong | Long Integer | Long Int | 8 | |
4 | DDLINE | DD Line | String | DD_STR255 | 255 |