DD40100 - Direct Deposit Setup
Dynamics GP table DD40100 (Direct Deposit Setup) contains 33 columns including DDSETPID, DDCOMPNM, DDCOIDEN....
SQL Query Builder
33 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| DDSETPID | DD Setup ID | String | 12 | |
| DDCOMPNM | DD Company Name | String | 18 | |
| DDCOIDEN | DD Company Identification | String | 12 | |
| DDIMDEST | DD Immediate Destination | String | 12 | |
| DDIMDENM | DD Immediate Destination Name | String | 24 | |
| DDIMORIG | DD Immediate Origin | String | 12 | |
| DDIMORNM | DD Immediate Origin Name | String | 24 | |
| DDORGDFI | DD Originating DFI | String | 10 | |
| DDTRANUM | DD Transit Number | String | 10 | |
| DDACTNUM | DD Account Number | String | 18 | |
| DDINDNAM | DD Individual Name | String | 24 | |
| DDTRANS | DD Transaction Code | String | 4 | |
| DDDISC20 | DD DiscretionaryStr20 | String | 22 | |
| DDDESC10 | DD DescriptionStr10 | String | 12 | |
| DDEMPINF | DD Employee Info Type | Integer | 2 | |
| DDDESTIN | DD Destination | String | 256 | |
| DDNXTACH | DD Next ACH File Name | String | 18 | |
| DDINCACH | DD Increment ACH Filename | Boolean | 2 | |
| DDHEAD | DD Headers | Integer | 2 | |
| DDFOOT | DD Footers | Integer | 2 | |
| DDAUTOST | DD Auto Settle On | Boolean | 2 | |
| DDHANDDEP | DD Handle Deposits | Integer | 2 | |
| DDDAYSPAY2POST | DD DaysPay2Post | Integer | 2 | |
| DDNEXTDEPNO | DD Next Deposit Number | String | 22 | |
| DDMASKDLR | DD Mask Dollar | Boolean | 2 | |
| DDVOIDED | DD Voided | Boolean | 2 | |
| DDPRECNT | DD Prenote Count | Integer | 2 | |
| DDEXCEPTLIST | DD Exception List | String | 12 | |
| DDPOPSET | DD Populate Setting | Integer | 2 | |
| DDACTIVI | DD Activity Type | Integer | 2 | |
| DDBANKRE | DD Bank Rec Type | Integer | 2 | |
| DDSERVICECODE | DD Service Class Code | Integer | 2 | |
| EFTPaymentMethod | EFTPaymentMethod | Integer | 2 |
Related Tables
Tables that share columns with DD40100. Click "Join" to add to your query.