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 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 PeopleTools: 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 are included N = only cash is 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, then 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 & 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