DTA10200 - MDA Transaction Codes
Stores individual transaction codes within MDA groups.
SQL Query Builder
13 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| DTASERIES | smallint 0 | |||
| DTAREF | char(25) '' | |||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | ||
| SEQNUMBR | int 0 | |||
| GROUPID | char(15) '' | |||
| CODEID | char(15) '' | |||
| DOCNUMBR | char(21) '' | |||
| RMDTYPAL | smallint 0 | |||
| POSTDESC | char(51) '' | |||
| DTAQNTY | numeric(19,5) 0.00 | |||
| CODEAMT | numeric(19,5) 0.00 | |||
| TRXDATE | datetime '1/1/1900' | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with DTA10200. Click "Join" to add to your query.
CODEID