ddfeesiw_raw
Core Schemas
>
Silverlake
>
ddfeesiw_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| __op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
| __op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
| __uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
| __ver | Mapping and Schema Version | REQUIRED | INTEGER | |
| tracct | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| tratyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| seq | Sequence number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| feecod | Fee code | CHAR(2) | NULLABLE | STRING | 2 |
| amt | Transaction amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| efhds1 | EFT Description 1 | CHAR(30) | NULLABLE | STRING | 30 |
| efhds2 | EFT Description 2 | CHAR(30) | NULLABLE | STRING | 30 |
| ddmuid | User ID | CHAR(24) | NULLABLE | STRING | 24 |
| ddmwid | Workstation ID | CHAR(24) | NULLABLE | STRING | 24 |
| ddmtim | Time change made | DEC(6,0) | NULLABLE | INTEGER | 6 |
| trcount | Fee item count | DEC(5,0) | NULLABLE | INTEGER | 5 |
| tramtfree | Amount free | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| trcntfree | Count free | DEC(5,0) | NULLABLE | INTEGER | 5 |
| orgchgdt6 | Original charge date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| orgchgdt7 | Original charge date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| nsfrvcd | NSF/OD Reversal code | CHAR(1) | NULLABLE | STRING | 1 |
| orgtc | Original Trancode | DEC(5,0) | NULLABLE | INTEGER | 5 |
| ovrcobal | Charge Off Bal affected | CHAR(1) | NULLABLE | STRING | 1 |
| feewavamt | Transaction waived amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| guidrowid | Global Unique Identifier Row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| ddfcolid | Unique row Id | BIGINT(8) | NULLABLE | INTEGER | 8 |
| ddfcrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| ddfmntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024