remittance_raw
Pipelined Data Sets
>
Symitar
>
remittance_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 | |
| remittanceuuid | This field stores a JH Platform unique identifier for a remittance | NULLABLE | STRING | |
| remittancekey | 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 | |
| processorcode | This field specifies the loan processor associated with the Remittance record | NULLABLE | INTEGER | |
| processoracct | Enter the account number from the third-party loan processor system | NULLABLE | STRING | |
| trancode | Enter the type of payment transaction as shown on the third-party loan processor system. Valid values are defined by the third-party loan processor. See Available MP Transaction Codes for FICS for examples | NULLABLE | STRING | |
| fundtype | Choose one of the following as the type of payment transaction on the third-party loan processor system: | NULLABLE | INTEGER | |
| payer | This field identifies the person (or other source) remitting the funds for payment. Choose one of the following: | NULLABLE | INTEGER | |
| amount | Enter the amount of the remittance payment | NULLABLE | NUMERIC | |
| description | Enter a free-format description of the payment | NULLABLE | STRING | |
| memberaccount | Enter the member's credit union Account Number | NULLABLE | STRING | |
| status | Choose the option that describes the current state of the Remittance record: | NULLABLE | INTEGER | |
| postdate | This field stores the date the Remittance record was posted | NULLABLE | DATE | |
| sequence | This field stores the transaction sequence number the system assigned to the associated GL transactions on the posting date | NULLABLE | INTEGER | |
| glcode | Enter the credit union-defined code to which you are posting this remittance, or enter 000 to cause the system to post the remittance to the system-defined GL code for Miscellaneous Payment Clearing | NULLABLE | INTEGER | |
| remitdate | This field stores the date the remittance was posted | NULLABLE | DATE | |
| voiddate | This field stores the date the remittance was voided | NULLABLE | DATE | |
| recondate | This field stores the date the remittance was reconciled | NULLABLE | DATE | |
| user | This field stores the user number of the person who posted the remittance | NULLABLE | INTEGER | |
| consolenumber | This field stores the console number of the console from which the remittance was posted | NULLABLE | INTEGER | |
| globalsequence | This field contains a unique number for each global sequence date, and the system assigns this number automatically. You cannot change the value of this field | NULLABLE | INTEGER | |
| globalsequencedate | This field stores the date the record was created. You cannot change the value of this field | NULLABLE | DATE | |
| prevduedate | As soon as the system receives confirmation that the FICS database has been updated via the RTA Socket Service, it sets the associated Remittance record's Status field to (1) Remitted, the Remittance Date field to the system date, and updates the Previous Due Date field with the Previous Due Date value from FICS | NULLABLE | DATE | |
| recordchangedate | The system stores the system date in the Record Change Date field when you create, change, or save the Remittance record. There will be times when the system updates the Record Change Date field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE | |
| confirmationseq | This number is system-generated during posting or memo posting and provided to any SymConnect requesting it | NULLABLE | INTEGER | |
| trantype | NULLABLE | INTEGER |
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