ddefth_raw
Core Schemas
>
Silverlake
>
ddefth_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 | |
| efhrid | Record ID | CHAR(1) | NULLABLE | STRING | 1 |
| efhcod | EFT Code | CHAR(3) | NULLABLE | STRING | 3 |
| efhkey | Record Key | DEC(13,0) | NULLABLE | INTEGER | 13 |
| efhds1 | Description 1 | CHAR(30) | NULLABLE | STRING | 30 |
| efhds2 | Description 2 | CHAR(30) | NULLABLE | STRING | 30 |
| efhact | Account Number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| efhtyp | Account Type | CHAR(1) | NULLABLE | STRING | 1 |
| efhtc | Transaction Code | DEC(5,0) | NULLABLE | INTEGER | 5 |
| efhamt | Transaction Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| efhrowid | Unique Row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| efhrowcrt | Row Create Timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| efhrowmnt | Row Last Maint Timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024