Payment Advice Staging
You need only populate rows on this table if any of the following conditions apply:
- If you need to distribute a payment tender to an account other than that defined with the CUST_ID on the payment tender staging record, you must create a payment staging record. You may distribute a tender to multiple accounts by creating multiple payment staging records. Note, if you want to distribute the payment tender to the same account, you do NOT need a payment staging record.
- If you want to restrict a payment to a specific contract, you must insert a row on this table to indicate the specific the contract in question. You do this by populating MATCH_TYPE_CD with a value that indicates that you are paying for a specific contract and MATCH_VALUE with the unique ID of the contract.
- If you practice open-item accounting, you must insert a row on this table for each to indicate the open-item to which the payment should be matched. Note, because open-item customer typically match payments to bills, you would populate MATCH_TYPE_CD with a value to indicate that you are matching by bill ID and MATCH_VALUE with the unique ID of the bill.
The name of this table is CI_PAY_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 payment tender staging record. |
| EXT_TRANSMIT_ID | 30 | Y | A/N | This must correspond with the external transmission ID on the parent payment tender staging record. |
| EXT_BATCH_ID | 30 | Y | A/N | This must correspond with the external batch ID on the parent payment tender staging record. |
| EXT_REFERENCE_ID | 30 | Y | A/N | This must correspond with the external reference ID on the parent payment tender staging record. |
| CUST_ID | 15 | Y | A/N | This is the account ID or old account number of the customer to which the payment should be distributed. If the system cannot find an account ID or old account number that matches this value, the account ID of the payor is used on the corresponding payment. If the payor's account ID is invalid, the tender source's suspense contract is used. |
| PAY_AMT | 13.2 | Y | N | The amount tendered (i.e., the payment amount). |
| MATCH_TYPE_CD | 8 | N | A/N | See the description of the MATCH_VALUE field below. Refer to Payments And Match Events for more information about the significance of this field. |
| MATCH_VALUE | 30 | N | A/N |
MATCH_VALUE and MATCH_TYPE_CD are used in conjunction to indicate that the distribution of the payment should be restricted in some way (i.e., the standard payment distribution algorithm should not be used). MATCH_TYPE_CD indicates how the payment should be distributed (e.g., only distribute to a specific contract), MATCH_VALUE contains the ID of the restriction (e.g., the contract ID). If MATCH_TYPE_CD is specified, it must reference a valid Match Type. |