Understanding Electronic Payment Processing
PeopleSoft Receivables enables you to receive electronic payments into payment staging tables from the following sources:
EDI transmissions
Lockboxes
Electronic bank statements
EFT (Electronic Funds Transfer) payment files
You load the files into payment staging tables, and the Payment Loader Application Engine process (AR_PAYLOAD) processes the payments and loads the data into the payment application tables. This table lists the staging tables:
Table Name |
Description |
---|---|
PS_AR_LOCKBOX_EC |
Contains lockbox header information and is used only for lockbox deposits. |
PS_AR_DEPOSIT_EC |
Contains deposit-level information. |
PS_AR_PAYMENT_EC |
Contains payment-level information. |
PS_AR_IDITEM_EC |
(Optional) Contains item reference information. |
PS_AR_IDCUST_EC |
(Optional) Contains customer reference information. |
This section discusses:
PS_AR_LOCKBOX_EC table
PS_AR_DEPOSIT_EC table
PS_AR_PAYMENT_EC table
PS_AR_IDITEM_EC table
PS_AR_IDCUST_EC table
PS_AR_LOCKBOX_EC Table
This table lists the fields that you must populate in the PS_AR_LOCKBOX_EC table. However, you may want to populate all the fields in this table. Use PeopleSoft Application Designer to review the other fields in the table.
Field Name |
Description |
---|---|
LB_BANK_TRANS_ID |
Bank transmission ID. |
LOCKBOX_ID |
Lockbox ID. |
PROCESS_INSTANCE |
Process instance ID. |
DEPOSIT_BU |
Business unit for the deposit. |
Note: LB_BANK_TRANS_ID and LOCKBOX_ID keys should be unique when processing multiple lockbox files, so that the process does not abend.
PS_AR_DEPOSIT_EC Table
This table lists the fields that you must populate in the PS_AR_DEPOSIT_EC table. However, you may want to populate the other fields based on your business requirements. Use PeopleSoft Application Designer to review the other fields in the table.
Field Name |
Description |
---|---|
LB_BANK_TRANS_ID |
Bank transmission ID (only for lockbox deposits). |
LOCKBOX_ID |
Lockbox ID (only for lockbox deposits). |
LOCKBOX_BATCH_ID |
Lockbox batch ID (only for lockbox deposits). |
DEPOSIT_BU |
Business unit for the deposit. |
BNK_ID_NBR |
External bank ID (where the payments are deposited). |
BANK_ACCOUNT_NUM |
Bank account number (where the payments are deposited). |
CONTROL_AMT |
Total amount of the payments in the deposit. |
CONTROL_CNT |
Total number of payments in the deposit. |
RECEIVED_DT |
Date that the deposit was received from the bank. |
ACCOUNTING_DT |
Accounting date for the payments. |
DATA_SOURCE |
Value that identifies the type of electronic payment. Options are:
|
PS_AR_PAYMENT_EC Table
This table lists the fields that you must populate in the PS_AR_PAYMENT_EC table. However, you may want to populate other fields based on your business requirements. Use PeopleSoft Application Designer to review the other fields in the table.
Field Name |
Description |
---|---|
EIP_CTL_ID |
EIP control ID (not used for lockbox deposits). |
LB_BANK_TRANS_ID |
Bank transmission ID (only for lockbox deposits). |
LOCKBOX_ID |
Lockbox ID (only for lockbox deposits). |
LOCKBOX_BATCH_ID |
Lockbox batch ID (only for lockbox deposits). |
DEPOSIT_BU |
Business unit for the deposit. |
PAYMENT_SEQ_NUM |
Sequence number for the payment in the deposit. |
PAYMENT_ID |
ID that identifies the payment. |
PAYMENT_AMT |
Amount of the payment. |
PAYMENT_METHOD |
Code that identifies the payment method. Options are:
|
ACCOUNTING_DT |
Accounting date for the payments. |
PAYMENT_CURRENCY |
Currency of the payment. |
BANK_ACCOUNT_NUM |
Bank account number (where the payments are deposited). |
BNK_ID_NBR |
External bank ID (where the payments are deposited). |
DATA_SOURCE |
Value that identifies the type of electronic payment. Options are:
|
RECEIVED_DT |
Date that the deposit was received from the bank. |
PS_AR_IDITEM_EC Table
This table lists the fields that you must populate in the PS_AR_IDITEM_EC table. However, you may want to populate other fields based on your business requirements. Use PeopleSoft Application Designer to review the other fields in the table.
Field Name |
Description |
---|---|
EIP_CTL_ID |
EIP control ID (not used for lockbox deposits). |
LB_BANK_TRANS_ID |
Bank transmission ID (only for lockbox deposits). |
LOCKBOX_ID |
Lockbox ID (only for lockbox deposits). |
LOCKBOX_BATCH_ID |
Lockbox batch ID (only for lockbox deposits). |
PAYMENT_SEQ_NUM |
Sequence number for the payment in the deposit. |
ID_SEQ_NUM |
Sequence number for the item identifier. |
DEPOSIT_BU |
Business unit for the deposit. |
ADJUSTMENT_REASON |
Reason code that you defined on the Adjustment Reason page. The code is mapped to entry types and reasons to determine what accounting entries to generate for adjustment items. |
REF_QUALIFIER_CODE |
Code that identifies the type of reference. Use one of the codes set up on the Reference Qualifier page. |
DATA_SOURCE |
Value that identifies the type of electronic payment. Options are:
|
RECEIVED_DT |
Date that the deposit was received from the bank. |
PAYMENT_ID |
ID of the payment associated with the reference. |
PS_AR_IDCUST_EC Table
This table lists the fields that you must populate in the PS_AR_IDCUST_EC table. However, you may want to populate other fields based on your business requirements. Use PeopleSoft Application Designer to review the other fields in the table.
Field Name |
Description |
---|---|
EIP_CTL_ID |
EIP control ID (not used for lockbox deposits). |
LB_BANK_TRANS_ID |
Bank transmission ID (only for lockbox deposits). |
LOCKBOX_ID |
Lockbox ID (only for lockbox deposits). |
LOCKBOX_BATCH_ID |
Lockbox batch ID (only for lockbox deposits). |
PAYMENT_SEQ_NUM |
Sequence number for the payment in the deposit. |
ID_SEQ_NUM |
Sequence number for the customer. |
DEPOSIT_BU |
Business unit for the deposit. |
CUST_ID |
Identification code for the bill to customer. |
DATA_SOURCE |
Value that identifies the type of electronic payment. Options are:
|
PAYMENT_ID |
ID of the payment associated with the reference. |