site_cashordertype_raw
Pipelined Data Sets
>
Symitar
>
site_cashordertype_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| 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 | |
| sitecashordertypeuuid | This field stores a JH Platform unique identifier for a site cash order type | NULLABLE | STRING | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| sitecashordertypekey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sitekey | 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 | |
| cashordertypename | This field stores the descriptive name for the cash order type | NULLABLE | STRING | |
| activeflag | This field stores a code that indicates the state of this cash order type | NULLABLE | INTEGER | |
| vendornumber | This field stores the credit union defined number of the vendor from the Cash Order Vendor Parameters | NULLABLE | INTEGER | |
| orderlimiting | This field stores a code that indicates the maximum number of non-cancelled orders allowed per delivery date for this order type for a site | NULLABLE | INTEGER | |
| delfrequency | This field stores a code that defines how often a site receives delivery for this order type | NULLABLE | INTEGER | |
| locationcode | This field stores special vendor-specific information that identifies the site's location to this vendor | NULLABLE | STRING | |
| cashordertypeminorder | This field stores the minimum amount required for this order | NULLABLE | NUMERIC | |
| cashordertypemaxorder | This field stores the maximum amount required for this order | NULLABLE | NUMERIC | |
| cashordertypecomment_1 | These fields each store a default comment line on this cash order type | NULLABLE | STRING | |
| cashordertypecomment_2 | These fields each store a default comment line on this cash order type | NULLABLE | STRING | |
| cashordertypecomment_3 | These fields each store a default comment line on this cash order type | NULLABLE | STRING | |
| cashordertypecomment_4 | These fields each store a default comment line on this cash order type | NULLABLE | STRING | |
| cashordertypecurrfit_1 | This field stores the cash value of used hundred-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrfit_2 | This field stores the cash value of used fifty-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrfit_3 | This field stores the cash value of used twenty-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrfit_4 | This field stores the cash value of used ten-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrfit_5 | This field stores the cash value of used five-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrfit_6 | This field stores the cash value of used two-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrfit_7 | This field stores the cash value of used one-dollar bills (fit for circulation) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_1 | This field stores the cash value of new hundred-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_2 | This field stores the cash value of new fifty-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_3 | This field stores the cash value of new twenty-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_4 | This field stores the cash value of new ten-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_5 | This field stores the cash value of new five-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_6 | This field stores the cash value of new two-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecurrnew_7 | This field stores the cash value of new one-dollar bills (uncirculated) in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_1 | This field stores the cash value of rolled (Sacagawea) one-dollar coins in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_2 | This field stores the cash value of rolled Susan B. Anthony one-dollar coins in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_3 | This field stores the cash value of rolled half-dollar coins in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_4 | This field stores the cash value of rolled standard quarters in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_5 | This field stores the cash value of rolled dimes in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_6 | This field stores the cash value of rolled nickels in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_7 | This field stores the cash value of rolled pennies in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinroll_8 | This field stores the cash value of rolled state commemorative quarters in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_1 | This field stores the cash value of bagged (Sacagawea) one-dollar coins in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_2 | This field stores the cash value of bagged Susan B. Anthony one-dollar coins in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_3 | This field stores the cash value of bagged half-dollar coins in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_4 | This field stores the cash value of bagged quarters in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_5 | This field stores the cash value of bagged dimes in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_6 | This field stores the cash value of bagged nickels in this order type | NULLABLE | NUMERIC | |
| cashordertypecoinbag_7 | This field stores the cash value of bagged pennies in this order type | NULLABLE | NUMERIC | |
| cashordertypedelcharge | This field stores the amount the vendor charges for this order type for a normal delivery | NULLABLE | NUMERIC | |
| cashordertypespecdelcharge | This field stores the amount the vendor charges for this order type for a special delivery | NULLABLE | NUMERIC | |
| applyhandlingfee | This field stores a code that indicates whether this order type incurs a special handling fee (using the amount from the Special Handling Fee parameter in the Cash Order Vendor Parameters) | NULLABLE | INTEGER | |
| deliverydays_1 | This field stores a code that specifies whether the vendor delivers to this site on Sunday | NULLABLE | INTEGER | |
| deliverydays_2 | This field stores a code that specifies whether the vendor delivers to this site on Monday | NULLABLE | INTEGER | |
| deliverydays_3 | This field stores a code that specifies whether the vendor delivers to this site on Tuesday | NULLABLE | INTEGER | |
| deliverydays_4 | This field stores a code that specifies whether the vendor delivers to this site on Wednesday | NULLABLE | INTEGER | |
| deliverydays_5 | This field stores a code that specifies whether the vendor delivers to this site on Thursday | NULLABLE | INTEGER | |
| deliverydays_6 | This field stores a code that specifies whether the vendor delivers to this site on Friday | NULLABLE | INTEGER | |
| deliverydays_7 | This field stores a code that specifies whether the vendor delivers to this site on Saturday | NULLABLE | INTEGER | |
| closedate | This field stores the date you closed this Cash Order Type record | NULLABLE | DATE | |
| locator | This field stores a unique number within each Cash Order Type record set that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Cash Order Type record. Sometimes Symitar Quest updates this field because the record was saved, even though there may not be any actual changes in the 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.
Did this page help you?
Last updated Tue Sep 15 2026