Interface Table (Bank Transfer)


	Previous	Next		Contents	Index	Glossary	Library

Interface Table (Bank Transfer)

The JL_BR_AR_RET_INTERFACE_ALL table stores successfully validated bank return occurrences. The Import Bank Return program transfers these bank return occurrences from the JL_BR_AR_RET_INTERFACE_ALL table to the JL_BR_AR_BANK_RETURNS_ALL table. Invalid occurrences in the JL_BR_AR_RET_INTERFACE_ALL table are transferred to the JL_BR_AR_RET_INTERFACE_EXT_ALL table. If a bank return file does not have a header or a trailer record or if the sequence numbers for all bank return occurrences in a file are not in sequence, the Import Bank Return program does not transfer any occurrence to the JL_BR_AR_BANK_RETURNS_ALL table or the JL_BR_AR_RET_INTERFACE_EXT_ALL table.

You use SQL*Loader to store the Bank Return file in the interface table.

This section describes the columns in the JL_BR_AR_RET_INTERFACE_ALL interface table for Oracle Financials for Brazil.

In this column
Oracle Receivables stores
FILE_CONTROL
The name that uniquely identifies a bank return file
ENTRY_SEQUENTIAL_
NUMBER
The sequence number that uniquely identifies each bank return occurrence. The number must be 1 for the header record, followed by sequentially incremented numbers starting from 2 for each bank return occurrence.
REGISTER_TYPE
A number that identifies the header record, trailer record, and bank return occurrences records in the Bank Return File:
0 Header Record
1 Bank return occurrences
9 Trailer record
COMPANY_CODE
Your company’s code that the bank uses
COMPANY_NAME
Your company’s name
GENERATION_DATE
The date that the bank generated the Bank Return file
REMITTANCE_CODE
This code must be 2 for all bank return occurrences
BANK_NUMBER
The number of the bank that is sending the Bank Return file
BANK_OCCURRENCE_
CODE
The return occurrence’s code
OCCURRENCE_DATE
The return occurrence’s date
INSCRIPTION_NUMBER
Your company’s inscription number
COMPANY_USE
A value that identifies the collection document in the JL_BR_AR_COLLECTION_DOCS table
OUR_NUMBER
A number that identifies the collection document in the bank
PORTFOLIO_CODE
The portfolio code that is assigned to the collection document
YOUR_NUMBER
The trade note number that identifies a payment schedule in your system
DUE_DATE
The due date of the payment schedule that is in your system
TRADE_NOTE_AMOUNT
The collection document amount
COMPANY_USE
A value that identifies the collection document in the JL_BR_AR_COLLECTION_DOCS table
COLLECTOR_BANK_
NUMBER
The bank number of the bank that collected the collection document
COLLECTOR_BRANCH_
NUMBER
The branch number of the bank that collected the collection document
BANK_CHARGE_AMOUNT
The bank’s charges for the collection
ABATEMENT_AMOUNT
The abatement for the trade note amount for the collection document
DISCOUNT_AMOUNT
The discount for the trade note amount for the collection document
CREDIT_AMOUNT
The net amount that the bank credits to the company’s account
INTEREST_AMOUNT_
RECEIVED
The interest amount received for the collection document
CUSTOMER_NAME
The name of the billed-to customer
RETURN_INFO
The comment/note field for the bank’s use
BANK_USE
The comment/note field for the bank’s use

Contents

Index

Glossary

Library

In this column	Oracle Receivables stores
FILE_CONTROL	The name that uniquely identifies a bank return file
ENTRY_SEQUENTIAL_ NUMBER	The sequence number that uniquely identifies each bank return occurrence. The number must be 1 for the header record, followed by sequentially incremented numbers starting from 2 for each bank return occurrence.
REGISTER_TYPE	A number that identifies the header record, trailer record, and bank return occurrences records in the Bank Return File: 0 Header Record 1 Bank return occurrences 9 Trailer record
COMPANY_CODE	Your company’s code that the bank uses
COMPANY_NAME	Your company’s name
GENERATION_DATE	The date that the bank generated the Bank Return file
REMITTANCE_CODE	This code must be 2 for all bank return occurrences
BANK_NUMBER	The number of the bank that is sending the Bank Return file
BANK_OCCURRENCE_ CODE	The return occurrence’s code
OCCURRENCE_DATE	The return occurrence’s date
INSCRIPTION_NUMBER	Your company’s inscription number
COMPANY_USE	A value that identifies the collection document in the JL_BR_AR_COLLECTION_DOCS table
OUR_NUMBER	A number that identifies the collection document in the bank
PORTFOLIO_CODE	The portfolio code that is assigned to the collection document
YOUR_NUMBER	The trade note number that identifies a payment schedule in your system
DUE_DATE	The due date of the payment schedule that is in your system
TRADE_NOTE_AMOUNT	The collection document amount
COMPANY_USE	A value that identifies the collection document in the JL_BR_AR_COLLECTION_DOCS table
COLLECTOR_BANK_ NUMBER	The bank number of the bank that collected the collection document
COLLECTOR_BRANCH_ NUMBER	The branch number of the bank that collected the collection document
BANK_CHARGE_AMOUNT	The bank’s charges for the collection
ABATEMENT_AMOUNT	The abatement for the trade note amount for the collection document
DISCOUNT_AMOUNT	The discount for the trade note amount for the collection document
CREDIT_AMOUNT	The net amount that the bank credits to the company’s account
INTEREST_AMOUNT_ RECEIVED	The interest amount received for the collection document
CUSTOMER_NAME	The name of the billed-to customer
RETURN_INFO	The comment/note field for the bank’s use
BANK_USE	The comment/note field for the bank’s use