cdhist_raw
Core Schemas
>
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 |
Last updated Thu Dec 12 2024