gletrn_raw
Core Schemas
>
Silverlake
>
gletrn_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 | |
| trstat | Status | CHAR(1) | NULLABLE | STRING | 1 |
| bk1 | Bank Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acct1 | Account number | DEC(7,0) | NULLABLE | INTEGER | 7 |
| cost1 | Cost center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| prod1 | Product code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| bk2 | Bank Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acct2 | Account number | DEC(7,0) | NULLABLE | INTEGER | 7 |
| cost2 | Cost center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| prod2 | Product code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| trbat | Batch number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| trseq | Sequence no | DEC(10,0) | NULLABLE | INTEGER | 10 |
| trsrc | Source | CHAR(2) | NULLABLE | STRING | 2 |
| tramt | Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| trdesc | Description | CHAR(40) | NULLABLE | STRING | 40 |
| treff6 | Effective date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| treff7 | Effective date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| trmuid | User ID | CHAR(24) | NULLABLE | STRING | 24 |
| trmwid | Workstation ID | CHAR(24) | NULLABLE | STRING | 24 |
| trmtim | Time change made | DEC(6,0) | NULLABLE | INTEGER | 6 |
Last updated Thu Dec 12 2024