glint1_raw
Core Schemas
>
Silverlake
>
glint1_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 | |
| gistat | Interface record status | CHAR(1) | NULLABLE | STRING | 1 |
| branch | Branch number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| appcde | Application code | CHAR(2) | NULLABLE | STRING | 2 |
| inter_num_ | Interface number | DEC(5,0) | NULLABLE | INTEGER | 5 |
| indorc | Interface entry | CHAR(1) | NULLABLE | STRING | 1 |
| grp | Group | DEC(3,0) | NULLABLE | INTEGER | 3 |
| pracct | Account number | DEC(7,0) | NULLABLE | INTEGER | 7 |
| prcost | Cost center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| prprdc | Product code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| gdesc | Transaction description | CHAR(40) | NULLABLE | STRING | 40 |
| forcbr | Force branch # | DEC(3,0) | NULLABLE | INTEGER | 3 |
| chgrec | Chgoff Item | CHAR(1) | NULLABLE | STRING | 1 |
| glint1_id | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| gi1crtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| gi1mntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024