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.

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:

  • 820: EDI 820 ANSI-X12 format

  • BST: Bank statement

  • CRX: EDI EDIFACT CREEXT format

  • LBX: Lockbox file

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:

  • CC: Credit card. (Not applicable for electronic deposits.)

  • CHK: Check.

  • DD: Direct debit. (Not applicable for electronic deposits.)

  • DR: Draft. (Not applicable for electronic deposits.)

  • EFT: Electronic fund transfer.

  • GE: Giro EFT.

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:

  • 820: EDI 820 ANSI-X12 format.

  • BST: Bank statement.

  • CRX: EDI EDIFACT CREEXT format.

  • LBX: Lockbox file.

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:

  • 820: EDI 820 ANSI-X12 format.

  • BST: Bank statement.

  • CRX: EDI EDIFACT CREEXT format.

  • LBX: Lockbox file.

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:

  • 820: EDI 820 ANSI-X12 format.

  • BST: Bank statement.

  • CRX: EDI EDIFACT CREEXT format.

  • LBX: Lockbox file.

PAYMENT_ID

ID of the payment associated with the reference.