Definition: apPaymentRequest.csv

This file contains the payment requests that are paid through Oracle ERP Cloud. The file provided here is an example, containing the minimum set of data required to load a payment request.

Prepare this file in the .csv format, using the following structure:

Parameter	Description
Transaction Identifier	Identifier that uniquely identifies a payment request line record.
Party Name	Name of the party to whom the payment is to be made.
Party Original System Reference	Party reference from the original system or external source.
Party Type	Type of party receiving the payment.
Location Original System Reference	Original system reference for the party site address.
Country	Location of the address by country.
Address Line 1	First line of the party address.
Address Line 2	Second line of the party address.
City	City of party to whom the payment is to be made.
State	State of party to whom the payment is to be made.
Province	Province of party to whom the payment is to be made.
County	County of party to whom the payment is to be made.
Postal Code	Postal code of party to whom the payment is to be made.
Postal Plus 4 code	Four-digit extension to postal code.
Addressee	Person or recipient located at the address.
Global Location Number	Number that uniquely identifies each global location in a trading-partner enterprise.
Language	Operating language of the party-site address.
Phone Country Code	Country code for the telephone number.
Phone Area Code	Area code for address phone number.
Phone	Phone number of the party receiving payment.
Phone Extension	Phone extension of the party receiving payment.
Payee E-Mail address	E-mail address of the payee to whom the payment is to be made.
Party Tax Registration Number	Unique identifier assigned to a party or party site by a tax authority.
Account Country Code	Country code of the bank account of payee.
Account Currency Code	Currency code of the bank account of payee.
Account Number	Bank account number of the payee.
IBAN	International Bank Account Number of payee.
Secondary Account Reference	Account number reference such as Building Society Roll Number.
Account Suffix	One to three digit number at the end of the account number that determines the kind of account.
Account Name	Name of the payee bank account.
Account Type Code	Type of bank account, such as SAVINGS and CHECKING.
Bank Name	Name of the payee bank to whom the payment is to be made.
Bank Number	Number of the payee bank to whom the payment is to be made.
Bank Branch Name	Name of the branch of the payee bank.
Bank Branch Number	Number of the bank branch. This is known as the routing transit number in US and Canada.
BIC	SWIFT or Bank Identification Code (BIC) of the bank branch.
Check Digits	One or more digits used to validate a bank account number.
Account Description	Description of the payee bank account.
Account Alternate Name	Alternate account name of the bank account of payee.
Business Unit	Sold-to business unit name for which the transaction is being created.
Source	Name of the external system from which a payment request is imported.
Invoice Number	Unique number for payment request.
Invoice Date	Date on which payment request is submitted.
Currency	Currency of the payment request.
Description	Information describing the invoice created for payment.
Import Set	Name or number assigned to the import set containing payment requests.
Legal Entity	The name of the legal entity that belongs to your own corporate structure (enterprise).
Payment Terms	Name of the payment terms used to create installments and to calculate due dates, discount dates, and discount amounts for each invoice.
Payment Method	Code identifying the payment method.
Pay Group	Used to group payment requests into a single pay run.
Liability Combination	Account to which liability is recorded in accrual basis of accounting.
Line Number	The number of the invoice line.
Amount	The invoice line amount to import for payment.
Line Description	Line description.
Distribution Combination	Account combination used for creating invoice distribution.