Payment Tender Staging
You must create at least one payment tender staging record for each payment associated with the tender control staging record. The name of this table is CI_PAY_TNDR_ST . The following table describes each column on this table.
| Column Name | Length | Req'd | Data Type | Comments |
|---|---|---|---|---|
| EXT_SOURCE_ID | 30 | Y | A/N | This must correspond with the external source ID on the parent deposit control staging record. |
| EXT_TRANSMIT_ID | 30 | Y | A/N | This must correspond with the external transmission ID on the parent tender control staging record. |
| EXT_BATCH_ID | 30 | Y | A/N | This must correspond with the external batch ID on the parent tender control staging record. |
| EXT_REFERENCE_ID | 30 | Y | A/N | This is the unique identifier of the payment in respect of the external batch ID. |
| PAY_TND_STG_ST_FLG | 2 | Y | A/N | This must be set to 10 (10 is the translate value that corresponds with the Pending state) |
| PAY_TENDER_ID | 12 | N | N | Leave this column blank. It will be assigned by the system when it creates a tender record. |
| TENDER_AMT | 13.2 | Y | N | The amount tendered (i.e., the payment amount). |
| ACCOUNTING_DT | 10 | Y | Date | This is the date that should be used for accounting purposes. This should correspond with an open accounting period. |
| TENDER_TYPE_CD | 4 | Y | A/N | This must correspond with the prime key of one of your tender types. Refer to Setting Up Tender Types for more information. |
| CUST_ID | 15 | Y | A/N | This is the account ID or old account number of the customer tendering the payment. If the system cannot find an account ID or old account number that matches this value, the account ID of the tender source's suspense contract will be used on the corresponding tender and payment. |
| MICR_ID | 30 | N | A/N | This is the MICR ID associated with the payment. |
| NAME1 | 40 | N | A/N | This is the customer name on the payment. |
| CHECK_NBR | 10 | N | A/N | This is the check number on the payment. |