AP: Populating Supplier Bank Account Import by using FBDI Template

Supplier Bank Account Import Through FBDI Template by using "Supplier Bank Account Import Template"

Data to be populated in IBY_TEMP_EXT_PAYEES Sheet

FBDI Columns	Populating data in FBDI Template	Mandatory
*Import Batch Identifier	Unique Identifier for Loading
*Payee Identifier	Unique number that identifies a supplier payee for an import batch. This number, along with the Import Batch ID, is used as a unique identifier for the supplier payee
Business Unit Name	Name of the Business Unit
*Supplier Number	Supplier Number same as the supplier extract
Supplier Site	Supplier Site same as the Supplier Sites Extracts
*Pay Each Document Alone	Indicates whether multiple documents payable can be combined into a single payment. Default value 'N'
Payment Method Code	DEFAULT_PAYMENT_METHOD_CODE as per configuration
Delivery Channel Code	Text that is included on an electronic payment that tells the bank how to execute the payment.
Settlement Priority	Instruction to a bank that indicates the priority for executing a payment. Valid values are NORMAL, EXPRESS, or Null.
Remit Delivery Method	Communication method used to deliver remittance advice to suppliers.
Remit Advice Email	E-Mail address used to send remittance advice to a supplier.
Remit Advice Fax	Fax number used to send remittance advice to a supplier.
Bank Instructions 1	Text that is included on an electronic payment that tells the bank how to deliver the payment to the payee.
Bank Instructions 2
Bank Instruction Details	Additional payment processing details for the bank that are provided by the deploying company for use in all electronic payment files using a specific payment process profile.
Payment Reason Code	PAYMENT_REASON_CODE based on Configuration
Payment Reason Comments
Payment Message1
Payment Message2
Payment Message3
Bank Charge Bearer Code	lookup type IBY_BANK_CHARGE_BEARER based on Configuration

Data to be populated in IBY_TEMP_EXT_BANK_ACCTS Sheet

FBDI Columns	Populating Data in FBDI Template	Mandatory
*Import Batch Identifier	Unique identifier for the batch created to load
*Payee Identifier	Unique number that identifies a supplier payee for an import batch. This number, along with the Import Batch ID, is used as a unique identifier for the supplier payee
*Payee Bank Account Identifier	Unique number by which a payee bank account is identified for an import batch. This number, along with an import batch identifier and payee identifier, is used to identify the supplier payee's bank account information
**Bank Name	Name of the bank. Information in this column must be provided
**Branch Name	Name of the bank branch. Information in this column must be provided
*Account Country Code	Country code of the supplier bank account.
Account Name	Name of the supplier's bank account.
*Account Number	Bank account number of the supplier.
Account Currency Code	Currency code of the bank account.
Allow International Payments	Indicates whether international payments are allowed from this bank account
Account Start Date	Date when the bank account becomes active.
Account End Date	Date when the bank account becomes inactive.
IBAN	identifying an international bank account number.
Check Digits
Account Alternate Name	Internal alternate name of the supplier's bank account.
Account Type Code	Specifies the type of supplier bank account. Examples of supplier bank account types are SAVINGS and CHECKING. Configuration in system accordingly
Account Suffix
Account Description
Agency Location Code
Exchange Rate Agreement Number
Exchange Rate Agreement Type
Exchange Rate
Secondary Account Reference
Attribute Category
Attribute 1
Attribute 2
Attribute 3
Attribute 4
Attribute 5
Attribute 6
Attribute 7
Attribute 8
Attribute 9
Attribute 10
Attribute 11
Attribute 12
Attribute 13
Attribute 14
Attribute 15