jhmast_raw
Core Schemas
>
Silverlake
>
jhmast_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 | |
| branch | Branch number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acctno | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| actype | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| sname | Short name | CHAR(20) | NULLABLE | STRING | 20 |
| cifno | CIF number | CHAR(7) | NULLABLE | STRING | 7 |
| addnam | Additional Names | CHAR(1) | NULLABLE | STRING | 1 |
| altnam | Alternate name | CHAR(1) | NULLABLE | STRING | 1 |
| altadd | Alternate address | CHAR(1) | NULLABLE | STRING | 1 |
| malhld | Mailing instructions | CHAR(1) | NULLABLE | STRING | 1 |
| cbal | Current Balance | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| glcost | GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| glprod | GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| secure | Account Level Security | CHAR(1) | NULLABLE | STRING | 1 |
| jhbpas | Passport Intergration | CHAR(1) | NULLABLE | STRING | 1 |
| jhbdt1 | Date #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhbdt2 | Date #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhbdt3 | Date #3 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhbdt4 | Date #4 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhbdt5 | Date #5 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhbdt6 | Date #6 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhbd61 | Date #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhbd62 | Date #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhbd63 | Date #3 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhbd64 | Date #4 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhbd65 | Date #5 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhbd66 | Date #6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhbam1 | Amount #1 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| jhbam2 | Amount #2 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| jhbam3 | Amount #3 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| jhbam4 | Amount #4 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| jhbam5 | Amount #5 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| jhbam6 | Amount #6 | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| jhbds1 | Description #1 | CHAR(30) | NULLABLE | STRING | 30 |
| jhbds2 | Description #2 | CHAR(30) | NULLABLE | STRING | 30 |
| jhbds3 | Description #3 | CHAR(30) | NULLABLE | STRING | 30 |
| jhbds4 | Description #4 | CHAR(30) | NULLABLE | STRING | 30 |
| jhbds5 | Description #5 | CHAR(30) | NULLABLE | STRING | 30 |
| jhbds6 | Description #6 | CHAR(30) | NULLABLE | STRING | 30 |
| jhpic1 | Programmer use #1 | CHAR(1) | NULLABLE | STRING | 1 |
| jhpic2 | Programmer use #2 | CHAR(1) | NULLABLE | STRING | 1 |
| jhpdt1 | Programmer DATE #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhpd61 | Programmer DATE #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhpdt2 | Programmer DATE #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| jhpd62 | Programmer DATE #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| jhpam1 | Programmer AMT #1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| jhpam2 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| combin | Include Comb Stmt | CHAR(1) | NULLABLE | STRING | 1 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Thu Dec 12 2024