Understanding Electronic Payment Processing
This chapter provides an overview of electronic payment processing and discusses how to:
Receive information from a lockbox.
Receive payments in an electronic data interchange (EDI) file.
See Also
Receiving Payments Electronically
Understanding Electronic Payment Processing
Receivables enables you to receive electronic payments into payment staging tables from the following sources:
EDI transmissions
Lockboxes
Electronic bank statements
EFT 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 Enterprise 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 other the fields based on your business requirements. Use 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 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
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 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 that the reference is associated with. |
PS_AR_IDCUST_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 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 that the reference is associated with. |
Receiving Information from a LockboxThis section provides an overview of the lockbox interface and describes the following record layouts for the fixed-file format design of the lockbox processor:
Header record.
Service record.
Lockbox record.
Batch record.
(Optional) Payment Detail 2 (Check Information).
(Optional) Payment Detail 3 (Customer Information).
(Optional) Payment Detail 4 (Customer Information).
(Optional) Payment Detail 5 (Customer Information).
(Optional) Payment Detail 6 (Customer Information).
(Optional) Payment Detail 7 (Invoice Information).
(Optional) Payment Detail 8 (Invoice Information).
(Optional) Payment Detail 9 (Invoice Information).
Understanding the Lockbox Interface
The most important issue in implementing the lockbox interface is the record layout of the payment transactions that are received from the bank. The PeopleSoft interface record layout is extensive. However, you must use only the pieces of it that pertain to the implementation. The record layout is a version of the Bank Administration Institute standards, modified to contain all the information that the Receivables system accepts.
The record layout has a maximum total of 12 records for one payment, but only the first five records are required: four control records and the first payment record. If all the information that you need is contained on one or two of the optional customer and invoice records, the system processes only that amount of information. For example, you may need only the invoice number, MICR ID, and payment amount information to match payments with invoices. If this is the case, then only three of the 10 payment detail records must be sent from the bank.
The other records contain transmission information, such as the number of batches (or deposits) in the file, and the originating bank identifiers. Transmission information will probably be the same every time a lockbox file is sent. Also, batch information is sent to audit the record count. You can have multiple batches (or deposits) in one transmission.
The record layouts for the fixed file format design of our lockbox processor must be given to the banks that receive lockbox payments so that they can send information to you in a format that the system can read. PeopleSoft has written the Lockbox SQR process (AR25001) for you, but it works only if the incoming file follows this layout design.
A record group ID is part of the lockbox record layout. It identifies multiple lines of customer information or item information for a single payment. The governing principle in assigning record group IDs is the number of rows that are inserted into PAYMENT_ID_ITEM and into PAYMENT_ID_CUST, the two records that store item and customer information for payments.
For example, multiple lines of detail records 03, 04, 05, and 06 (the customer payment records) are assigned sequential numbers, beginning with 1, within a single payment. The same assignment occurs for multiple lines for detail records 07, 08, and 09 (the item payment records). So you might have a single payment with record group IDs 1, 2, 3, 4 of customer information (for detail records 03, 04, 05, and 06); for the same payment you might also have record group IDs 1, 2, 3, and 4 of item information (for detail records 07, 08, and 09).
Record group IDs assigned to customer and item rows in a sample lockbox file
Header RecordThis is the layout for the header record:
|
Description |
Type |
Size |
Column |
Database Record Field |
|
Record Type, 1 = Header |
Char |
1 |
1 |
Used during processing |
|
Destination ID / lockbox recipient |
Char |
20 |
2-21 |
Used during processing |
|
Total number of lockboxes |
Num |
5 |
22-26 |
Used during processing |
|
Total payment amount |
Num |
16 |
27-42 |
Used during processing |
|
Transmission Date (MMDDYYYY) |
Date |
8 |
43-50 |
LOCKBOX_RUN_LOG.LOCKBOX_TRANS_DT |
|
Transmission Time (HHMMSS) |
Time |
6 |
51-56 |
LOCKBOX_RUN_LOG.LOCKBOX_TRANS_TIME |
Service RecordThis is the layout for the service record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 2 = service |
Char |
1 |
1 |
Used during processing |
|
Destination ID / lockbox recipient |
Char |
20 |
2-21 |
Used during processing |
|
Bank Transmission ID |
Char |
20 |
22-41 |
Used during processing |
|
Service Type, 400 = lockbox |
Char |
3 |
42-44 |
Used during processing |
|
Record Length (102) |
Num |
3 |
45-47 |
Used during processing |
|
Characters per block (0102) |
Num |
4 |
48-51 |
Used during processing |
|
Format, 1 = Fixed Field Format |
Num |
1 |
52 |
Used during processing |
Lockbox RecordThis is the layout for the lockbox record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID, unique within batch |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Sequence Num, 0=lockbox record |
Num |
5 |
22-26 |
Used during processing |
|
Record Group ID (0000) |
Num |
4 |
27-30 |
Used during processing |
|
Detail Record Type (00) |
Char |
2 |
31-32 |
Used during processing |
|
Total number of batches |
Num |
6 |
33-38 |
LOCKBOX_RUN_LOG.CONTROL_BATCH_CNT |
|
Total payment amount |
Num |
16 |
39-54 |
LOCKBOX_RUN_LOG.CONTROL_PAY_AMT |
|
Total number of payments |
Num |
6 |
55-60 |
LOCKBOX_RUN_LOG.CONTROL_PAY_CNT |
|
Deposit Business Unit |
Char |
5 |
61-65 |
LOCKBOX_RUN_LOG.DEPOSIT_BU DEPOSIT_CONTROL.DEPOSIT_BU PAYMENT.DEPOSIT_BU PAYMENT_ID_ITEM.DEPOSIT_BU PAYMENT_ID_CUST.DEPOSIT_BU PAY_MISC_DST.DEPOSIT_BU |
|
Bank |
Char |
20 |
66-85 |
DEPOSIT_CONTROL.BNK_ID_NBR |
|
Bank Account |
Char |
17 |
86-102 |
DEPOSIT_CONTROL.BANK_ACCOUNT_NUM |
Batch Record (Record Type-1)This is the layout for the batch record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Sequence Number, 0 = batch record |
Num |
5 |
22-26 |
Used during processing |
|
Record Group ID (0000) |
Num |
4 |
27-30 |
Used during processing |
|
Detail Record Type (01) |
Char |
2 |
31-32 |
Used during processing |
|
Total Batch Amount |
Num |
15 |
33-47 |
DEPOSIT_CONTROL.CONTROL_AMT |
|
Total number of payments |
Num |
6 |
48-53 |
DEPOSIT_CONTROL.CONTROL_CNT |
|
Deposit Date (MMDDYYYY) |
Date |
8 |
54-61 |
DEPOSIT_CONTROL.ACCOUNTING_DT |
|
Payment Currency |
Char |
3 |
62-64 |
PAYMENT.PAYMENT_CURRENCY |
Payment Detail 2 (Check Information)This is the layout for the payment detail 2 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
Used during processing |
|
Detail Record Type (02) |
Char |
2 |
31-32 |
Used during processing |
|
Payment ID / Check Number |
Char |
15 |
33-47 |
PAYMENT.PAYMENT_ID |
|
Payment Amount |
Char |
14 |
48-61 |
PAYMENT.PAYMENT_AMT |
|
Payment Date (MMDDYYYY) |
Char |
8 |
62-69 |
PAYMENT.ACCOUNTING_DT |
|
Payment Method |
Char |
3 |
70-72 |
PAYMENT.PAYMENT_METHOD |
|
Payment Currency |
Char |
3 |
73-75 |
PAYMENT.PAYMENT_CURRENCY |
Payment Detail 3 (Customer Information)This is the layout for the payment detail 3 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_CUST.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (03) |
Char |
2 |
31-32 |
Used during processing |
|
Customer Business Unit |
Char |
5 |
33-37 |
PAYMENT_ID_CUST.BUSINESS_UNIT |
|
Customer ID |
Char |
13 |
38-50 |
PAYMENT_ID_CUST.CUST_ID |
|
MICR Number |
Char |
30 |
51-80 |
PAYMENT_ID_CUST.MICR_ID |
Payment Detail 4 (Customer Information)This is the layout for the payment detail 4 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_CUST.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (04) |
Char |
2 |
31-32 |
Used during processing |
|
Remit From setID |
Char |
5 |
33-37 |
PAYMENT_ID_CUST.REMIT_FROM_SETID |
|
Remit From Customer ID |
Char |
15 |
38-52 |
PAYMENT_ID_CUST.REMIT_FROM_CUST_ID |
|
Corporate setID |
Char |
5 |
53-57 |
PAYMENT_ID_CUST.CORPORATE_SETID |
|
Corporate Customer ID |
Char |
15 |
58-72 |
PAYMENT_ID_CUST.CORPORATE_CUST_ID |
Payment Detail 5 (Customer Information)This is the layout for the payment detail 5 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_CUST.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (05) |
Char |
2 |
31-32 |
Used during processing |
|
Remit From Customer Name |
Char |
39 |
33-71 |
PAYMENT_ID_CUST.NAME1 |
|
D&B Number |
Char |
9 |
72-80 |
PAYMENT_ID_CUST.DB_NUMBER |
Payment Detail 6 (Customer Information)This is the layout for the payment detail 6 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
2 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_CUST.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (06) |
Char |
2 |
31-32 |
Used during processing |
|
Customer City |
Char |
30 |
33-62 |
PAYMENT_ID_CUST.CITY |
|
Customer Postal |
Char |
12 |
63-74 |
PAYMENT_ID_CUST.POSTAL |
Payment Detail 7 (Invoice Information)This is the layout for the payment detail 7 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_ITEM.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (07) |
Char |
2 |
31-32 |
Used during processing |
|
Reference Qualifier |
Char |
2 |
33-34 |
PAYMENT_ID_ITEM.REF_QUALIFIER_CODE |
|
Reference Value |
Char |
30 |
35-64 |
PAYMENT_ID_ITEM.REF_VALUE |
|
Item Line |
Num |
6 |
65–70 |
PAYMENT_ID_ITEM.ITEM_LINE |
|
Entry Event |
Char |
10 |
71–80 |
PAYMENT_ID_ITEM.ENTRY_EVENT |
Payment Detail 8 (Invoice Information)This is the layout for the payment detail 8 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_ITEM.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (08) |
Char |
2 |
31-32 |
Used during processing |
|
Total Invoice Amt |
Num |
14 |
33-46 |
PAYMENT_ID_ITEM.ITEM_AMT |
|
Amount of Invoice Paid |
Num |
14 |
47-60 |
PAYMENT_ID_ITEM.PAY_AMT |
|
Discount Amount Taken |
Num |
12 |
61-72 |
PAYMENT_ID_ITEM.DISC_TAKEN |
|
Invoice Date (MMDDYYYY) |
Date |
8 |
73-80 |
PAYMENT_ID_ITEM.ITEM_DT |
Payment Detail 9 (Invoice Information)This is the layout for the payment detail 9 record:
|
Description |
Type |
Size |
Column |
Record Field |
|
Record Type, 3 = Detail |
Char |
1 |
1 |
Used during processing |
|
Lockbox ID |
Char |
15 |
2-16 |
LOCKBOX_RUN_LOG.LOCKBOX_ID |
|
Batch ID |
Char |
5 |
17-21 |
DEPOSIT_CONTROL.LOCKBOX_BATCH_ID |
|
Payment Sequence Number |
Num |
5 |
22-26 |
PAYMENT.PAYMENT_SEQ_NUM PAYMENT_ID_CUST.PAYMENT_SEQ_NUM |
|
Record Group ID |
Num |
4 |
27-30 |
PAYMENT_ID_ITEM.LOCKBOX_RECGRP_NUM |
|
Detail Record Type (09) |
Char |
2 |
31-32 |
Used during processing |
|
Adjustment Amount |
Num |
14 |
33-46 |
PAYMENT_ID_ITEM.ADJUSTMENT_AMT |
|
Adjustment Entry Reason |
Char |
2 |
47-48 |
PAYMENT_ID_ITEM.ADJUSTMENT_REASON |
|
Reference Customer ID |
Char |
15 |
49-63 |
PAYMENT_ID_ITEM.CUST_ID |
Receiving Payments in an EDI File
To receive payments in an EDI file, use a third-party translator to translate the file into a PeopleSoft business document, which is a layout that describes the files that comprise the electronic banking file, including file name, type, length, format, short name, and long name.
To load the EDI data into the staging tables to be processed by the payment interface, use PeopleSoft Enterprise Messaging. The data can be published directly in the Application Messaging queue from external systems. If you use EDI flat files, you can use the Flat File utility (EOP_PUBLISHF) to load or publish data. Use the PeopleSoft Enterprise Integration Broker to set up the EDI interface.
Use the PAYMENT_LOAD file layout to determine the format of the flat file. The following sections describe the records in the PAYMENT_LOAD file layout:
Payment record
Customer remittance record.
Item remittance record.
See Using EDI and Split Stream Processing.
See Enterprise PeopleTools PeopleBook: PeopleSoft Integration Broker
Payment Record
This table describes the Payment record:
|
Column |
Size |
Type |
Field Name |
Description |
|
1 |
3 |
CHAR |
ROW_ID |
Row ID (always set to 000) |
|
4 |
1 |
CHAR |
AUDIT_ACTN |
Action (always set to A) |
|
5 |
15 |
CHAR |
PAYMENT_ID |
Payment ID |
|
20 |
17 |
NUMBER |
PAYMENT_AMT |
Payment Amount |
|
37 |
3 |
CHAR |
PAYMENT_METHOD |
Payment Method |
|
40 |
10 |
DATE |
ACCOUNTING_DT |
Accounting Date |
|
50 |
3 |
CHAR |
PAYMENT_CURRENCY |
Payment Currency |
|
53 |
17 |
CHAR |
BANK_ACCOUNT_NUM |
Bank Account Number |
|
70 |
20 |
CHAR |
BNK_ID_NBR |
External Bank ID |
|
90 |
10 |
DATE |
STTLMENT_DT_EST |
Estimated Settlement Date |
|
100 |
2 |
CHAR |
DFI_ID_QUAL |
DFI Qualifier |
|
102 |
12 |
CHAR |
DFI_ID_NUM |
DFI ID |
|
114 |
10 |
NUMBER |
EDI_TRACE_NBR |
EDI Trace Number |
|
124 |
30 |
CHAR |
MICR_ID |
MICR ID |
|
154 |
3 |
CHAR |
DATA_SOURCE |
Data Source (set to CRX or 820) |
|
157 |
1 |
CHAR |
MATCH |
Match Flag Y = both cash and remittance included N = only cash included R = does not create payment for the payment record Note. The Payment record is required even if only remittance data is sent. If the value in the Match field is R, the system does not create a payment for the payment record. |
|
158 |
5 |
CHAR |
DEPOSIT_BU |
Deposit Business Unit |
Customer Remittance Record
This table describes the Customer Remittance record:
|
Column |
Size |
Type |
Field Name |
Description |
|
1 |
3 |
CHAR |
ROW_ID |
Row ID (always set to 010) |
|
4 |
1 |
CHAR |
AUDIT_ACTN |
Action (always set to A) |
|
5 |
5 |
CHAR |
REMIT_FROM_SETID |
SetID |
|
10 |
15 |
CHAR |
REMIT_FROM_CUST_ID |
Remit From Customer |
|
25 |
30 |
CHAR |
MICR_ID |
MICR ID |
|
55 |
9 |
NUMBER |
DB_NUMBER |
Dun and Bradstreet Number |
|
64 |
2 |
CHAR |
DFI_ID_QUAL |
DFI Qualifier |
|
66 |
12 |
CHAR |
DFI_ID_NUM |
DFI ID |
|
78 |
20 |
CHAR |
BNK_ID_NBR |
External Bank ID |
|
98 |
17 |
CHAR |
BANK_ACCOUNT_NUM |
Bank Account Number |
|
115 |
5 |
CHAR |
BUSINESS_UNIT |
Business Unit |
|
120 |
15 |
CHAR |
CUST_ID |
Bill To Customer ID |
Item Remittance Record
This table describes the Item Remittance record:
|
Column |
Size |
Type |
Field Name |
Description |
|
1 |
3 |
CHAR |
ROW_ID |
Row ID (always set to 020) |
|
4 |
1 |
CHAR |
AUDIT_ACTN |
Action (always set to A) |
|
5 |
17* |
NUMBER |
PAY_AMT |
Payment Amount |
|
22 |
17* |
NUMBER |
ITEM_AMT |
Amount |
|
39 |
10 |
DATE |
ITEM_DT |
Item Date |
|
49 |
17* |
NUMBER |
DISC_TAKEN |
Discount Taken |
|
66 |
17* |
NUMBER |
ADJUSTMENT_AMT |
Adjustment Amount |
|
83 |
2 |
CHAR |
ADJUSTMENT_REASON |
Adjustment Reason |
|
85 |
2 |
CHAR |
REF_QUALIFIER_CODE |
Reference Qualifier Code |
|
87 |
30 |
CHAR |
REF_VALUE |
Reference |
|
117 |
5 |
CHAR |
BUSINESS_UNIT |
Business Unit |
|
122 |
15 |
CHAR |
CUST_ID |
Bill To Customer ID |