ddhist_raw
Core Schemas
>
Silverlake
>
ddhist_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 |
| tracct | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| tratyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| trancd | Transaction code | DEC(5,0) | NULLABLE | INTEGER | 5 |
| trdate | Transaction date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| treffd | Effective date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| trrate | Old rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| amt | Transaction amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| serial | Check number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| run_num_ | Run number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| batch | Batch number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| seq | Sequence number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| retday | Expiration date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| atmcod | ACH code | DEC(13,0) | NULLABLE | INTEGER | 13 |
| chgflg | Charge flag | CHAR(1) | NULLABLE | STRING | 1 |
| nobook | No book flag | CHAR(1) | NULLABLE | STRING | 1 |
| trdat6 | Transaction date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| treff6 | Effective date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| source | Input source | CHAR(2) | NULLABLE | STRING | 2 |
| dorc | Debit/Credit code | CHAR(1) | NULLABLE | STRING | 1 |
| bori | Affects balance/interest | CHAR(1) | NULLABLE | STRING | 1 |
| desstm | Print desc on stmt | CHAR(1) | NULLABLE | STRING | 1 |
| pstsq_num_ | Posted sequence | DEC(7,0) | NULLABLE | INTEGER | 7 |
| image_num_ | Image item # | DEC(15,0) | NULLABLE | INTEGER | 15 |
| acfilk | ACH file key | CHAR(25) | NULLABLE | STRING | 25 |
| acbatn | ACH batch | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acseqn | ACH seq | DEC(6,0) | NULLABLE | INTEGER | 6 |
| achsec | ACH standard entry class | CHAR(3) | NULLABLE | STRING | 3 |
| ktrescode | Kite reason codes | CHAR(35) | NULLABLE | STRING | 35 |
| paspnt | Passport history pointer | DEC(20,0) | NULLABLE | STRING | 20 |
| pdck21m | Check 21 micr flag | CHAR(1) | NULLABLE | STRING | 1 |
| pdimsrc | Image source | CHAR(2) | NULLABLE | STRING | 2 |
| ddusrid | User ID | CHAR(24) | NULLABLE | STRING | 24 |
| achcon | ACH company name | CHAR(16) | NULLABLE | STRING | 16 |
| route | Routing no | DEC(8,0) | NULLABLE | INTEGER | 8 |
| achcoi | ACH company ID | CHAR(10) | NULLABLE | STRING | 10 |
| ckpayee | Check payee | CHAR(50) | NULLABLE | STRING | 50 |
| jxprod | jXchange product | CHAR(15) | NULLABLE | STRING | 15 |
| jxvend | jXchange vendor | CHAR(15) | NULLABLE | STRING | 15 |
| pdpayee | Captured payee | CHAR(80) | NULLABLE | STRING | 80 |
| psttmstmp | Post time yyyymmddhhmmss | DEC(14,0) | NULLABLE | INTEGER | 14 |
| jhtranid | JH transaction ID | CHAR(10) | NULLABLE | STRING | 10 |
| ddhrnbal | Running balance | DEC(15,2) | NULLABLE | FLOAT | 15.2 |
| ddhrnseq | Running balance sequence | DEC(7,0) | NULLABLE | INTEGER | 7 |
| guidrowid | Global Unique Identifier Row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| ddhrowid | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| ddhrowcrt | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| ddhrowmnt | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Last updated Thu Dec 12 2024