Developer Programs

Learn

Docs

cdhist_raw

Core Schemas > Silverlake > cdhist_raw
Column nameDescriptionModeTypeLength
__opContains the operation type. Values are I for insert, U for update, D for delete.REQUIREDSTRING
__op_tsoperation timestamp added by export codeREQUIREDTIMESTAMP
__uidThe Unique ID of this entry. Data, UUID, or GUIDREQUIREDSTRING
__verMapping and Schema VersionREQUIREDINTEGER
chacctAccount number | DEC(16,0)NULLABLEINTEGER16
chatypAccount type | CHAR(1)NULLABLESTRING1
chtranTransaction code | DEC(3,0)NULLABLEINTEGER3
chdorcDr/Cr code | CHAR(1)NULLABLESTRING1
chafftAffects code | CHAR(1)NULLABLESTRING1
chpstdDate posted | DEC(7,0)NULLABLEINTEGER7
chpst6Date posted | DEC(6,0)NULLABLEINTEGER6
chefdtEffective date | DEC(7,0)NULLABLEINTEGER7
chefd6Effective date | DEC(6,0)NULLABLEINTEGER6
chamtTransaction amount | DEC(11,2)NULLABLEFLOAT11.2
chbat_num_Batch number | DEC(4,0)NULLABLEINTEGER4
chseq_num_Sequence number | DEC(10,0)NULLABLEINTEGER10
chserlCheck number | DEC(16,0)NULLABLEINTEGER16
chsrcSource of funds | CHAR(2)NULLABLESTRING2
chisrcInput source | CHAR(2)NULLABLESTRING2
choratOld rate | DEC(9,8)NULLABLEFLOAT9.8
chnratNew rate | DEC(9,8)NULLABLEFLOAT9.8
image_num_Image item # | DEC(15,0)NULLABLEINTEGER15
acfilkACH file key | CHAR(25)NULLABLESTRING25
acbatnACH batch | DEC(7,0)NULLABLEINTEGER7
acseqnACH seq | DEC(6,0)NULLABLEINTEGER6
chuserUser ID | CHAR(24)NULLABLESTRING24
chjxpdjXchange product | CHAR(15)NULLABLESTRING15
chjxvdjXchange vendor | CHAR(15)NULLABLESTRING15
trclosedrsWithdrawl reason code | CHAR(2)NULLABLESTRING2
ac5cedCompany entry desc | CHAR(10)NULLABLESTRING10
ac5comCompany name | CHAR(16)NULLABLESTRING16
chmremMemo/remarks | CHAR(60)NULLABLESTRING60
guidrowidGlobal Unique Identifier Row ID | BIGINT(8)NULLABLEINTEGER8
tdhrowidUnique row ID | BIGINT(8)NULLABLEINTEGER8
tdhrowcrtRow create timestamp | TIMESTAMP LEN(26)NULLABLESTRING26
tdhrowmntRow last maint timestamp | TIMESTAMP LEN(26)NULLABLESTRING26
Last updated Thu Dec 12 2024