DTA10100 - MDA Transaction Groups
Stores Miscellaneous Detail Account (MDA) transaction group definitions.
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) '' | ||||
| DTA_GL_Reference | char(25) '' | ||||
| DOCNUMBR | char(21) '' | ||||
| RMDTYPAL | smallint 0 | ||||
| GROUPAMT | numeric(19,5) 0.00 | ||||
| JRNENTRY | int 0 | ||||
| TRXDATE | datetime '1/1/1900' | ||||
| PSTGSTUS | smallint 0 | ||||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with DTA10100. Click "Join" to add to your query.