cdhist_raw
Pipelined Data Sets
>
SilverLake
>
cdhist_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 | |
| chacct | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| chatyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| chtran | Transaction code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| chdorc | Dr/Cr code | CHAR(1) | NULLABLE | STRING | 1 |
| chafft | Affects code | CHAR(1) | NULLABLE | STRING | 1 |
| chpstd | Date posted | DEC(7,0) | NULLABLE | INTEGER | 7 |
| chpst6 | Date posted | DEC(6,0) | NULLABLE | INTEGER | 6 |
| chefdt | Effective date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| chefd6 | Effective date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| chamt | Transaction amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| chbat_num_ | Batch number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| chseq_num_ | Sequence number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| chserl | Check number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| chsrc | Source of funds | CHAR(2) | NULLABLE | STRING | 2 |
| chisrc | Input source | CHAR(2) | NULLABLE | STRING | 2 |
| chorat | Old rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| chnrat | New rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| 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 |
| chuser | User ID | CHAR(24) | NULLABLE | STRING | 24 |
| chjxpd | jXchange product | CHAR(15) | NULLABLE | STRING | 15 |
| chjxvd | jXchange vendor | CHAR(15) | NULLABLE | STRING | 15 |
| trclosedrs | Withdrawl reason code | CHAR(2) | NULLABLE | STRING | 2 |
| ac5ced | Company entry desc | CHAR(10) | NULLABLE | STRING | 10 |
| ac5com | Company name | CHAR(16) | NULLABLE | STRING | 16 |
| chmrem | Memo/remarks | CHAR(60) | NULLABLE | STRING | 60 |
| guidrowid | Global Unique Identifier Row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| tdhrowid | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| tdhrowcrt | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| tdhrowmnt | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on StackOverflow.
- Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026