Bank Returns File Format

This section provides the bank returns file format.

This table lists the field names, their meanings and formats available for use:

Name of Field	Meaning	Format
FILE_CONTROL	Bank Control File number received from Bank	X(20)
ENTRY SEQUENTIAL NUMBER	Register sequence number on electronic file received from the bank.	NUMERIC
REGISTER_TYPE	Identifier for header, detail and trailer records in electronic file received from the bank.	NUMERIC
TRADE_NOTE_AMOUNT	Amount due remaining on collection document received from the bank.	NUMERIC
FILE_GENERATION_NUMBER	Oracle internal use only.	NUMERIC
COMPANY_CODE	Company code provided by the bank at the time of contract for services associated with the remittance and return of a collection document.	NUMERIC
COMPANY_NAME	Company name of the first party associated with the company code provided by the bank.	X(80)
GENERATION_DATE	Date on which the interface records were generated. Date Format: MM/DD/YYYY	DATE
REMITTANCE_CODE	Bank remittance code in electronic file from the original line sent by the company.	NUMERIC
BANK_NUMBER	Unique numeric identifier for a bank.	X(30)
BANK_OCCURRENCE_CODE	Occurrence code returned by the bank related to a bank occurrence.	X(30)
OCCURRENCE_DATE	Correction date for a bank occurrence received from the bank. Date Format: MM/DD/YYYY	DATE
INSCRIPTION_NUMBER	Company registration number in electronic file received from the bank.	X(50)
COMPANY_USE	Collection document unique identifier for matching purposes.	NUMERIC
OUR_NUMBER	Collection document identifier generated by the bank or the company responsible for the collection document printing.	X(20)
PORTFOLIO_CODE	Portfolio code in electronic file received from the bank.	NUMERIC
YOUR_NUMBER	Collection document number related to the document given by the company.	X(46)
DUE_DATE	Due date for a collection document received from the bank. Date Format: MM/DD/YYYY	DATE
COLLECTOR_BANK_NUMBER	Numeric identifier for collecting bank.	X(30)
COLLECTOR_BRANCH_NUMBER	Numeric identifier for collecting bank branch.	X(25)
TRADE_NOTE_TYPE	Oracle internal use only.	X(3)
BANK_CHARGE_AMOUNT	No longer used	NUMERIC
ABATEMENT_AMOUNT	Abatement amount for a bank collection document received from the bank.	NUMERIC
DISCOUNT_AMOUNT	Discount amount for a bank collection document received from the bank.	NUMERIC
CREDIT_AMOUNT	Credit amount for a collection document received from the bank.	NUMERIC
INTEREST_AMOUNT_RECEIVED	Paid interest amount for a collection document received from the bank.	NUMERIC
CUSTOMER_NAME	Customer name on a collection document received from the bank.	X(50)
RETURN_INFO	Return information comment on a bank occurrence on a collection document received from the bank.	X(50)
BANK_USE	Operation identifier by bank on electronic file received from the bank.	X(25)