jhparsrc_raw
Core Schemas
>
Silverlake
>
jhparsrc_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 | |
| psapp | Application code | CHAR(2) | NULLABLE | STRING | 2 |
| pssrc | Source code | CHAR(2) | NULLABLE | STRING | 2 |
| psdesc | Description | CHAR(30) | NULLABLE | STRING | 30 |
| psifccr | GL interface number credit | DEC(5,0) | NULLABLE | INTEGER | 5 |
| psifcdr | GL interface number debit | DEC(5,0) | NULLABLE | INTEGER | 5 |
| psdspseq | Help display sequence | DEC(5,0) | NULLABLE | INTEGER | 5 |
| psonestep | One-Step transaction | CHAR(1) | NULLABLE | STRING | 1 |
| psrowid | Unique row Id | BIGINT(8) | NULLABLE | INTEGER | 8 |
| pscrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| psmntts | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024