Column Name | Length | Req'd | Data Type | Comments |
EXT_SOURCE_ID | 30 | Y | A/N | This must correspond with an external source ID on one of the defined tender sources. Refer to Setting Up Tender Sources for more information. |
EXT_TRANSMIT_ID | 50 | Y | A/N | This is the unique identifier of the transmission from the external source. This must be a unique value for each transmission from the source. |
PEVT_DTL_SEQ | 12 | Y | N | Unique identifier of the detail record within the transmission. The C1-PEPL1 process uses this field to organize the parallel threads. |
PEVT_STG_ST_FLG | 4 | Y | A/N | This must be set to 10 (10 is the lookup value that corresponds with the Incomplete state) |
DST_RULE_CD | 12 | Y | A/N | This must be a valid distribution rule. The distribution rule contains the set of algorithms designed to process the staging detail. |
DST_RULE_VALUE | 254 | Y | A/N | This must be a valid value for the characteristic type defined on the distribution rule. |
CURRENCY_CD | 3 | Y | A/N | This must be a valid currency code (this would be USD for United States dollars). |
TENDER_AMT | 13.2 | Y | N | The amount tendered (i.e., the payment amount). |
ACCOUNTING_DT | 10 | Y | Date | This is the payment 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 be a valid tender type. Refer to Setting Up Tender Types for more information. |
CHECK_NBR | 10 | N | A/N | This is the check number on the payment. |
MICR_ID | 30 | N | A/N | This is the MICR ID associated with the payment tender. |
CUST_ID | 15 | N | A/N | This field may be used to record customer information. |
NAME1 | 30 | N | A/N | This field may be used to capture additional payment tender information. |
EXT_REFERENCE_ID | 30 | N | A/N | This field may be used to capture external information associated with the payment tender. |
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 service agreement), MATCH_VALUE contains the ID of the restriction (e.g., the SA ID). If MATCH_TYPE_CD is specified, it must reference a valid Match Type. |
TNDR_CTL_ID | 10 | N | A/N | Leave this column blank. It will be assigned by the system when it creates a tender control record. |
ACCT_ID | 10 | N | A/N | This is the tender account. If left blank, the C1-PEPL1 process will populate this field by calling the Determine Tender Account algorithm defined on the distribution rule. Note that this Account ID is not necessarily unique as multiple staging details can reference the same tender account. |
PAY_EVENT_ID | 12 | N | A/N | Leave this column blank. It will be assigned by the system when it creates a payment event record. |
PEVT_PROCESS_ID | 10 | N | A/N | If left blank, the C1-PEPL1 process will set this field equal to the Tender Account ID. This field is used for grouping staging records and for organizing parallel threads (in the C1-PEPL2 process). Therefore, it is strongly encouraged that it bears a relationship to the tender account ID. |
APAY_SRC_CD | 12 | N | A/N | This must be a valid auto-pay source code. |
EXT_ACCT_ID | 50 | N | A/N | This is the customer's account number at the financial institution |
EXPIRE_DT | 10 | N | Date | This field is only needed if the Tender Type indicates that an expiration date is necessary (e.g., for a credit card payment) |
ENTITY_NAME | 64 | N | A/N | This is the customer's name in the financial institution's system |