loan_checkorder_raw

Pipelined Data Sets > Symitar > loan_checkorder_raw

Column name	Description	Mode	Type
institutionid	This field stores the JH Platform institution identifier	REQUIRED	STRING
eventtime	Internal use only	NULLABLE	INTEGER
sourcetype	Internal use only; SSDB field	NULLABLE	STRING
operation	Internal use only; SSDB field	NULLABLE	STRING
extractdate	Internal use only	NULLABLE	DATE
processdatetime	Internal use only; SSDB field	NULLABLE	TIMESTAMP
loancheckorderuuid	This field stores a JH Platform unique identifier for a loan check order	NULLABLE	STRING
loanuuid	This field stores a JH Platform unique identifier for a loan	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
loanid	This field stores the 4 digit Loan ID	NULLABLE	STRING
loancheckorderkey	Internal use only; SSDB field	NULLABLE	INTEGER
loankey	Internal use only; SSDB field	NULLABLE	INTEGER
accountkey	Internal use only; SSDB field	NULLABLE	INTEGER
sortrank	Internal use only; SSDB field	NULLABLE	INTEGER
deleteid	This field stores a soft delete flag where 0=not deleted, 1=deleted	NULLABLE	INTEGER
symdate	Internal use only; SSDB field	NULLABLE	INTEGER
systemcreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
odscreatedatetime	Internal use only; SSDB field	NULLABLE	INTEGER
sym	Internal use only; SSDB field	NULLABLE	INTEGER
odsdeleteflag	Internal use only; SSDB field	NULLABLE	INTEGER
odskey	Internal use only; SSDB field	NULLABLE	INTEGER
processor	This field identifies the check order processor	NULLABLE	INTEGER
status	This field indicates the current status of the check order	NULLABLE	INTEGER
opendate	This field stores the date the Check Order record was created	NULLABLE	DATE
lastorderdate	This field stores the date a check order was last sent to the processor	NULLABLE	DATE
statusdate	This field stores the date when you changed the value in the Status field	NULLABLE	DATE
lastfmdate	This field stores the date of the last file maintenance of this Check Order record	NULLABLE	DATE
checktype	This field specifies the type of checks being ordered	NULLABLE	INTEGER
branch	This field stores a processor-assigned code that identifies your credit union	NULLABLE	INTEGER
startnumber	This fields stores either the starting check number for new orders or the starting reorder number	NULLABLE	INTEGER
quantity	This field specifies the number of checks being ordered	NULLABLE	INTEGER
checkstyle	This field specifies the style of checks being ordered	NULLABLE	STRING
coverstyle	This field specifies the style of the checkbook cover	NULLABLE	STRING
cutnumber	This field is used by Clarke American, Harland, and Deluxe only, and it specifies the style of the cut (insignia) on the checks	NULLABLE	STRING
billingcode	This field specifies how the check order should be billed	NULLABLE	INTEGER
shipmethod	This field specifies how the check order should be shipped	NULLABLE	INTEGER
shipto	This field is used by Clarke American, Deluxe, and Liberty only, and it specifies to whom the check order should be shipped	NULLABLE	INTEGER
imprintfont	This field specifies the font for the imprint lines	NULLABLE	INTEGER
imprintjustify	This field is used by Clarke American, Harland, and Liberty only, and it specifies the justification (alignment) of the imprint lines	NULLABLE	INTEGER
imprintline_1	This field specifies the first line of name or address information to be imprinted on the checks	NULLABLE	STRING
imprintline_2	This field specifies the second line of name or address information to be imprinted on the checks	NULLABLE	STRING
imprintline_3	This field specifies the third line of name or address information to be imprinted on the checks	NULLABLE	STRING
imprintline_4	This field specifies the fourth line of name or address information to be imprinted on the checks	NULLABLE	STRING
imprintline_5	This field specifies the fifth line of name or address information to be imprinted on the checks	NULLABLE	STRING
imprintline_6	This field specifies the sixth line of name or address information to be imprinted on the checks	NULLABLE	STRING
imprintphone	This field is used by Clarke American and Deluxe only, and it specifies the telephone number to be imprinted on the checks	NULLABLE	STRING
imprintzipcode	This field is used by Clarke American and Deluxe only, and it specifies the ZIP Code to be imprinted on the checks	NULLABLE	STRING
mailaddress_1	These fields specify the mailing address for the check order	NULLABLE	STRING
mailaddress_2	These fields specify the mailing address for the check order	NULLABLE	STRING
mailaddress_3	These fields specify the mailing address for the check order	NULLABLE	STRING
mailaddress_4	These fields specify the mailing address for the check order	NULLABLE	STRING
mailaddress_5	These fields specify the mailing address for the check order	NULLABLE	STRING
mailaddress_6	These fields specify the mailing address for the check order	NULLABLE	STRING
mailzipcode	This field is used by Clarke American and Harland only, and it specifies the ZIP Code the check order should be mailed to	NULLABLE	STRING
oversigline_1	This field specifies the information to be imprinted on the first line of text, over the signature line (or signature lines)	NULLABLE	STRING
oversigline_2	This field specifies the information to be imprinted on the second line of text, over the signature line (or signature lines)	NULLABLE	STRING
oversigfont	This field is used by Clarke American, Harland, and Liberty only, and it specifies the font style for the Over Signature Line 1 and Over Signature Line 2 fields	NULLABLE	INTEGER
numbersiglines	This field specifies the number of signature lines to be included on the checks	NULLABLE	INTEGER
coverinitials	This field is used by Clarke American and Harland only, and it specifies the initials, if any, to be imprinted on the checkbook cover	NULLABLE	STRING
specialinstr_1	This field stores a line of special instructions for the processor	NULLABLE	STRING
specialinstr_2	This field is used by Clarke American, Deluxe, and Liberty only, and it stores a second line of special instructions	NULLABLE	STRING
specialinstr_3	These fields are used by Deluxe only, and they store the third through eighth lines of special instructions	NULLABLE	STRING
specialinstr_4	This field stores a line of special instructions for the processor	NULLABLE	STRING
specialinstr_5	This field stores a line of special instructions for the processor	NULLABLE	STRING
specialinstr_6	This field stores a line of special instructions for the processor	NULLABLE	STRING
specialinstr_7	This field stores a line of special instructions for the processor	NULLABLE	STRING
specialinstr_8	These fields are used by Deluxe only, and they store the third through eighth lines of special instructions	NULLABLE	STRING
ssn_1	This field is used by Deluxe only, and it specifies the Social Security Number or individual Taxpayer Identification Number to be imprinted on checks	NULLABLE	STRING
ssn_2	This field is used by Deluxe only, and it specifies the second Social Security Number or individual Taxpayer Identification Number to be imprinted on checks	NULLABLE	STRING
license_1	This field is used by Deluxe only, and it specifies the license number to imprint on the checks	NULLABLE	STRING
license_2	This field is used by Deluxe only, and it specifies a second license number to be imprinted on the checks	NULLABLE	STRING
binding	This field is not currently used	NULLABLE	STRING
design	This field is not currently used	NULLABLE	STRING
businessserial	This field is used by Deluxe only, and it specifies the serial letters to be imprinted after the check number on the business checks	NULLABLE	STRING
busnumcopies	This field is used by Deluxe only, and it indicates the number of carbonless check copies required (in addition to the original check) for business checks	NULLABLE	INTEGER
busbindingstyle	This field is used by Deluxe only, and it specifies the binding style of the checkbook for business checks	NULLABLE	INTEGER
busvouchernumber	This field is used by Deluxe only, and it indicates the voucher number that designates the purpose of the checks	NULLABLE	STRING
buscaptions_1	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_2	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_3	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_4	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_5	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_6	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_7	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
buscaptions_8	These fields are used by Deluxe only, and they specify a deduction caption to be imprinted on business checks	NULLABLE	STRING
promonumber	This field is used by Clarke America, Harland, and Deluxe only, and it stores a promo number	NULLABLE	STRING
acctaddrinkcolor	This field is used by Deluxe only, and it specifies the ink color for the account and address information imprinted on the business checks	NULLABLE	INTEGER
titleinkcolor	This field is used by Deluxe only, and it specifies the ink color used for the title plate for business checks	NULLABLE	INTEGER
cutinkcolor	This field is used by Deluxe only, and it specifies the ink color used for the cut (insignia) for business checks	NULLABLE	INTEGER
taxexemptcode	This field is used by Harland only, and it specifies whether the check order is tax-exempt	NULLABLE	INTEGER
rerunreason	This field is used by Harland only, and it specifies the reason a check order must be rerun	NULLABLE	INTEGER
imprintlinesize_1	These fields are used by Harland only, and they specify the font size for each imprint line	NULLABLE	INTEGER
imprintlinesize_2	These fields are used by Harland only, and they specify the font size for each imprint line	NULLABLE	INTEGER
imprintlinesize_3	These fields are used by Harland only, and they specify the font size for each imprint line	NULLABLE	INTEGER
imprintlinesize_4	These fields are used by Harland only, and they specify the font size for each imprint line	NULLABLE	INTEGER
imprintlinesize_5	These fields are used by Harland only, and they specify the font size for each imprint line	NULLABLE	INTEGER
imprintlinesize_6	These fields are used by Harland only, and they specify the font size for each imprint line	NULLABLE	INTEGER
oversigjustify	This field is used by Clarke American and Harland only, and it specifies the alignment for the over signature lines	NULLABLE	INTEGER
oversiglinesize	This field is used by Harland only, and it specifies the font size for the over signature lines	NULLABLE	INTEGER
ponumber	This field is used by Harland only, and it stores the purchase number for the check order	NULLABLE	STRING
chargeshipping	This field is used by Liberty only, and it specifies whom to charge the shipping costs to	NULLABLE	INTEGER
imprintusage_1	These fields are used by Liberty only, and they specifies how each imprint line is used	NULLABLE	INTEGER
imprintusage_2	These fields are used by Liberty only, and they specifies how each imprint line is used	NULLABLE	INTEGER
imprintusage_3	These fields are used by Liberty only, and they specifies how each imprint line is used	NULLABLE	INTEGER
imprintusage_4	These fields are used by Liberty only, and they specifies how each imprint line is used	NULLABLE	INTEGER
imprintusage_5	These fields are used by Liberty only, and they specifies how each imprint line is used	NULLABLE	INTEGER
imprintusage_6	These fields are used by Liberty only, and they specifies how each imprint line is used	NULLABLE	INTEGER
accent	This field is used by Liberty only, and it specifies the accent figure printed to the left of the name	NULLABLE	STRING
phantom	This field is used by Liberty only, and it specifies the phantom figure printed in the center of the checks	NULLABLE	STRING
sigfigure	This field is used by Liberty only, and it specifies the signature figure printed next to the signature line	NULLABLE	STRING
checkinitials	This field is used by Clarke American only, and it specifies the initials, if any, to be imprinted on the checks	NULLABLE	STRING
imprintcity	This field is used by Clarke American only, and it specifies the name of the city to be imprinted on the checks	NULLABLE	STRING
imprintstate	This field is used by Clarke American only, and it specifies the two-character U.S. Postal Service state code to be imprinted on the checks	NULLABLE	STRING
mailcity	This field is used by Clarke American only, and it specifies the name of the city to which the check order should be mailed	NULLABLE	STRING
mailstate	This field is used by Clarke American only, and it specifies the two-character U.S. Postal Code for the state to which the check order should be mailed	NULLABLE	STRING
micrline	This field stores the information to be imprinted magnetically on the MICR line at the bottom of the check	NULLABLE	STRING
userid	This field stores the user number of the person who creates the Check Order record	NULLABLE	INTEGER
lastfreeorder	This field records the date for a free or promotional check order	NULLABLE	DATE
locator	This field value in each record is unique for each member account	NULLABLE	INTEGER
recordchangedate	This field stores the system date when you create, change, or save the Check Order record	NULLABLE	DATE

Have a Question?

Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026