Interface Table (Collection Document)


	Previous	Next		Contents	Index	Glossary	Library

Interface Table (Collection Document)

The JL_BR_AP_INT_COLLECT_ALL interface table stores collection document information. You use SQL*Loader to load collection document information into the interface table for each collection document that you create. When you initiate importing collection documents, the Collection Document Import open interface validates all required collection document data in this table. After the open interface validates the information, the open interface either creates collection documents in the JL_BR_AP_COLLECTION_DOCS_ALL table, or creates a record in the JL_BR_AP_INT_COLLECT_EXT_ALL table to be corrected.

This section describes the columns in the JL_BR_AP_INT_COLLECT_ALL interface table for Oracle Financials for Brazil and shows where the values are stored.

In this column
Oracle Payables stores
For this location
FILE_CONTROL
The name of the file that is received from the bank. This name must be unique.
JL_BR_AP_
COLLECTION_DOCS_
ALL.FILE_CONTROL
JL_BR_AP_INT_COLLECT_EXT_
ALL.FILE_CONTROL
ENTRY_SEQUENTIAL_
NUMBER
The entry sequential number from the imported bank collection document. The values must be in a gapless sequential order.
JL_BR_AP_COLLECTION_DOCS_ALL.ENTRY_
SEQUENTIAL_NUMBER
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ENTRY_SEQUENTIAL_NUMBER
REGISTRY_CODE
Registry code
JL_BR_AP_INT_
COLLECT_EXT_ALL.
REGISTRY_CODE
RETURN_CODE
Return code
JL_BR_AP_INT_
COLLECT_EXT_ALL.
RETURN_CODE
SERVICE_CODE
Service code
JL_BR_AP_INT_
COLLECT_EXT_ALL.
SERVICE_CODE
RECORDING_DATE
The date that the bank collection document was recorded. This value must be in valid date format.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
RECORDING_DATE
ISSUE_DATE
The date that the bank collection document was issued. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.ISSUE_DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ISSUE_DATE
DOCUMENT_NUMBER
Bank collection document number
JL_BR_AP_
COLLECTION_DOCS_
ALL.DOCUMENT_
NUMBER
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DOCUMENT_NUMBER
DRAWER_GUARANTOR
Drawer or guarantor name
JL_BR_AP_
COLLECTION_DOCS_
ALL.DRAWER_
GUARANTOR
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWER_
GUARANTOR
INSTRUCTION_1
Bank instruction
JL_BR_AP_
COLLECTION_DOCS_
ALL.INSTRUCTION_1
JL_BR_AP_INT_
COLLECT_EXT_ALL.
INSTRUCTION_1
INSTRUCTION_2
Bank Instruction
JL_BR_AP_
COLLECTION_DOCS_
ALL.INSTRUCTION_2
JL_BR_AP_INT_
COLLECT_EXT_ALL.
INSTRUCTION_2
CNAB_CODE
CNAB code. This value must exist in the FND_CURRENCIES.GLOBAL_
ATTRIBUTE1 table or the error code is set to 01.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
CNAB_CODE
DUE_DATE
Due date
JL_BR_AP_
COLLECTION_DOCS_
ALL.DUE_DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DUE_DATE
AMOUNT
Bank collection document amount
JL_BR_AP_
COLLECTION_DOCS_
ALL.AMOUNT
JL_BR_AP_INT_
COLLECT_EXT_ALL.
AMOUNT
DISCOUNT_DATE
The date that the discount is available. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.DISCOUNT_DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DISCOUNT_DATE
DISCOUNT_AMOUNT
Discount amount at the discount date
JL_BR_AP_
COLLECTION_DOCS_
ALL.DISCOUNT_
AMOUNT
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DISCOUNT_AMOUNT
ARREARS_DATE
Arrears interest date. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.ARREARS_DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ARREARS_DATE
ARREARS_CODE
Arrears interest code. This value must exist in the FND_LOOKUPS.LOOKUP_
CODE table, where LOOKUP_TYPE = “JLBR_ARREARS_CODE,” or the error code is set to 02.
JL_BR_AP_
COLLECTION_DOCS_
ALL.ARREARS_CODE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ARREARS_CODE
ARREARS_INTEREST
Arrears interest amount
JL_BR_AP_
COLLECTION_DOCS_
ALL.ARREARS_
INTEREST
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ARREARS_INTEREST
ABATE_AMOUNT
Bank collection abate amount
JL_BR_AP_
COLLECTION_DOCS_
ALL.ABATE_AMOUNT
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ABATE_AMOUNT
PAID_AMOUNT
Amount paid
JL_BR_AP_
COLLECTION_DOCS_
ALL.PAID_AMOUNT
JL_BR_AP_INT_
COLLECT_EXT_ALL.
PAID_AMOUNT
PAYMENT_LOCATION
Payment location
JL_BR_AP_
COLLECTION_DOCS_
ALL.PAYMENT_
LOCATION
JL_BR_AP_INT_
COLLECT_EXT_ALL.
PAYMENT_LOCATION
DOCUMENT_TYPE
Bank collection document type
JL_BR_AP_
COLLECTION_DOCS_
ALL.DOCUMENT_TYPE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DOCUMENT_TYPE
ACCEPTANCE
Acceptance
JL_BR_AP_
COLLECTION_DOCS_
ALL.ACCEPTANCE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ACCEPTANCE
PROCESSING_DATE
The date that the bank collection document was processed. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.PROCESSING_
DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
PROCESSING_DATE
BANK_USE
Bank use
JL_BR_AP_
COLLECTION_DOCS_
ALL.BANK_USE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
BANK_USE
PORTFOLIO
The portfolio code in the bank
JL_BR_AP_
COLLECTION_DOCS_
ALL.PORTFOLIO
JL_BR_AP_INT_
COLLECT_EXT_ALL.
PORTFOLIO
PENALTY_FEE_
AMOUNT
Penalty fee amount
JL_BR_AP_
COLLECTION_DOCS_
ALL.PENALTY_FEE_
AMOUNT
JL_BR_AP_INT_
COLLECT_EXT_ALL.
PENALTY_FEE_
AMOUNT
PENALTY_FEE_DATE
Penalty fee date. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.PENALTY_FEE_
DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
PENALTY_FEE_DATE
OTHER_ACCRETIONS
Other accretions
JL_BR_AP_
COLLECTION_DOCS_
ALL.OTHER_
ACCRETIONS
JL_BR_AP_INT_
COLLECT_EXT_ALL.
OTHER_ACCRETIONS
OUR_NUMBER
Our number
JL_BR_AP_
COLLECTION_DOCS_
ALL.OUR_NUMBER
JL_BR_AP_INT_
COLLECT_EXT_ALL.
OUR_NUMBER
TRANSFEROR_CODE
Transferor code
JL_BR_AP_
COLLECTION_DOCS_
ALL.TRANSFEROR_
CODE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_CODE
OCCURRENCE
Occurrence
JL_BR_AP_INT_
COLLECT_EXT_ALL.
OCCURRENCE
OCCURRENCE_DATE
Occurrence date. This value must be in valid date format.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
OCCURRENCE
DRAWEE_NAME
Drawee name. This value must exist in the JL_BR_COMPANY_INFOS.
NAME table, or the error code is set to 04.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_NAME
DRAWEE_BANK_CODE
Drawee bank code. This value must exist in the AP_BANK_BRANCHES.
BANK_NUMBER table, or the error code is set to 07.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_BANK_CODE
DRAWEE_BANK_NAME
Drawee bank name
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_BANK_
NAME
DRAWEE_BRANCH_
CODE
Drawee branch code. This value must exist in the AP_BANK_BRANCHES.BANK_
NUM table, or the error code is set to 07.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_BRANCH_
CODE
DRAWEE_ACCOUNT_
NUMBER
Drawee account number. This value must exist in the AP_BANK_ACCOUNTS.
BANK_ACCOUNT_NUM table, or the error code is set to 08.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_ACCOUNT_NUMBER
DRAWEE_INSCRIPTION_
TYPE
Drawee inscription type. This value must exist in the JL_BR_COMPANY_INFOS.
REGISTER_TYPE table, or the error code is set to 05.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_
INSCRIPTION_TYPE
DRAWEE_INSCRIPTION_
NUMBER
Drawee inscription number. This value must exist in the JL_BR_COMPANY_INFOS.
REGISTER_NUMBER || REGISTER_SUBSIDIARY || REGISTER_DIGIT table, or the error code is set to 06.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
DRAWEE_
INSCRIPTION_
NUMBER
TRANSFEROR_NAME
Transferor name. This value must exist in the PO_VENDORS.VENDOR_
NAME table, or the error code is set to 11.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_NAME
TRANSFEROR_BANK_
CODE
Transferor bank code. This value must exist in the AP_BANK_BRANCHES.BANK_
NUMBER table, or the error code is set to 12.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_BANK_
CODE
TRANSFEROR_BRANCH
_CODE
Transferor branch code. This value must exist in the AP_BANK_BRANCHES.
BANK_NUM table, or the error code is set to 12.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_
BRANCH_CODE
TRANSFEROR_
ACCOUNT_NUMBER
Transferor account number
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_
ACCOUNT_NUMBER
TRANSFEROR_
INSCRIPTION_TYPE
Transferor inscription type. This value must exist in the PO_VENDOR_SITES.
GLOBAL_ATTRIBUTE9 table, or the error code is set to 09.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_
INSCRIPTION_TYPE
TRANSFEROR_
INSCRIPTION_NUMBER
Transferor inscription number. This value must exist in the PO_VENDOR_SITES.
GLOBAL_ATTRIBUTE10 || GLOBAL_ATTRIBUTE11 || GLOBAL_ATTRIBUTE12 table, or the error code is set to 10.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
TRANSFEROR_
INSCRIPTION_
NUMBER
ACCOUNTING_
BALANCING_SEGMENT
Accounting balancing segment. This value must exist in the JL_BR_COMPANY_INFOS.
ACCOUNTING_BALANCING_
SEGMENT table.
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ACCOUNTING_
BALANCING_
SEGMENT
SET_OF_BOOKS_ID
The set of books identifier. This value must exist in the JL_BR_COMPANY_INFOS.SET_
OF_BOOKS_ID table.
JL_BR_AP_
COLLECTION_DOCS_
ALL.SET_OF_BOOKS_ID
JL_BR_AP_INT_
COLLECT_EXT_ALL.
SET_OF_BOOKS_ID
ERROR_CODE
Error code
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ERROR_CODE
ORG_ID
Organization identifier. This value must exist in the HR_OPERATING_UNITS.
ORGANIZATION_ID table.
JL_BR_AP_
COLLECTION_DOCS_
ALL.ORG_ID
JL_BR_AP_INT_
COLLECT_EXT_ALL.
ORG_ID
LAST_UPDATE_DATE
Standard who column. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.LAST_UPDATE_
DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
LAST_UPDATE_DATE
LAST_UPDATED_BY
Standard who column
JL_BR_AP_
COLLECTION_DOCS_
ALL.LAST_UPDATED_
BY
JL_BR_AP_INT_
COLLECT_EXT_ALL.
LAST_UPDATED_BY
CREATION_DATE
Standard who column. This value must be in valid date format.
JL_BR_AP_
COLLECTION_DOCS_
ALL.CREATION_DATE
JL_BR_AP_INT_
COLLECT_EXT_ALL.
CREATION_DATE
CREATED_BY
Standard who column
JL_BR_AP_
COLLECTION_DOCS_
ALL.CREATED_BY
JL_BR_AP_INT_
COLLECT_EXT_ALL.
CREATED_BY
LAST_UPDATE_LOGIN
Standard who column
JL_BR_AP_
COLLECTION_DOCS_
ALL.LAST_UPDATE_
LOGIN
JL_BR_AP_INT_
COLLECT_EXT_ALL.
LAST_UPDATE_LOGIN

Contents

Index

Glossary

Library

In this column	Oracle Payables stores	For this location
FILE_CONTROL	The name of the file that is received from the bank. This name must be unique.	JL_BR_AP_ COLLECTION_DOCS_ ALL.FILE_CONTROL JL_BR_AP_INT_COLLECT_EXT_ ALL.FILE_CONTROL
ENTRY_SEQUENTIAL_ NUMBER	The entry sequential number from the imported bank collection document. The values must be in a gapless sequential order.	JL_BR_AP_COLLECTION_DOCS_ALL.ENTRY_ SEQUENTIAL_NUMBER JL_BR_AP_INT_ COLLECT_EXT_ALL. ENTRY_SEQUENTIAL_NUMBER
REGISTRY_CODE	Registry code	JL_BR_AP_INT_ COLLECT_EXT_ALL. REGISTRY_CODE
RETURN_CODE	Return code	JL_BR_AP_INT_ COLLECT_EXT_ALL. RETURN_CODE
SERVICE_CODE	Service code	JL_BR_AP_INT_ COLLECT_EXT_ALL. SERVICE_CODE
RECORDING_DATE	The date that the bank collection document was recorded. This value must be in valid date format.	JL_BR_AP_INT_ COLLECT_EXT_ALL. RECORDING_DATE
ISSUE_DATE	The date that the bank collection document was issued. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.ISSUE_DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. ISSUE_DATE
DOCUMENT_NUMBER	Bank collection document number	JL_BR_AP_ COLLECTION_DOCS_ ALL.DOCUMENT_ NUMBER JL_BR_AP_INT_ COLLECT_EXT_ALL. DOCUMENT_NUMBER
DRAWER_GUARANTOR	Drawer or guarantor name	JL_BR_AP_ COLLECTION_DOCS_ ALL.DRAWER_ GUARANTOR JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWER_ GUARANTOR
INSTRUCTION_1	Bank instruction	JL_BR_AP_ COLLECTION_DOCS_ ALL.INSTRUCTION_1 JL_BR_AP_INT_ COLLECT_EXT_ALL. INSTRUCTION_1
INSTRUCTION_2	Bank Instruction	JL_BR_AP_ COLLECTION_DOCS_ ALL.INSTRUCTION_2 JL_BR_AP_INT_ COLLECT_EXT_ALL. INSTRUCTION_2
CNAB_CODE	CNAB code. This value must exist in the FND_CURRENCIES.GLOBAL_ ATTRIBUTE1 table or the error code is set to 01.	JL_BR_AP_INT_ COLLECT_EXT_ALL. CNAB_CODE
DUE_DATE	Due date	JL_BR_AP_ COLLECTION_DOCS_ ALL.DUE_DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. DUE_DATE
AMOUNT	Bank collection document amount	JL_BR_AP_ COLLECTION_DOCS_ ALL.AMOUNT JL_BR_AP_INT_ COLLECT_EXT_ALL. AMOUNT
DISCOUNT_DATE	The date that the discount is available. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.DISCOUNT_DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. DISCOUNT_DATE
DISCOUNT_AMOUNT	Discount amount at the discount date	JL_BR_AP_ COLLECTION_DOCS_ ALL.DISCOUNT_ AMOUNT JL_BR_AP_INT_ COLLECT_EXT_ALL. DISCOUNT_AMOUNT
ARREARS_DATE	Arrears interest date. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.ARREARS_DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. ARREARS_DATE
ARREARS_CODE	Arrears interest code. This value must exist in the FND_LOOKUPS.LOOKUP_ CODE table, where LOOKUP_TYPE = “JLBR_ARREARS_CODE,” or the error code is set to 02.	JL_BR_AP_ COLLECTION_DOCS_ ALL.ARREARS_CODE JL_BR_AP_INT_ COLLECT_EXT_ALL. ARREARS_CODE
ARREARS_INTEREST	Arrears interest amount	JL_BR_AP_ COLLECTION_DOCS_ ALL.ARREARS_ INTEREST JL_BR_AP_INT_ COLLECT_EXT_ALL. ARREARS_INTEREST
ABATE_AMOUNT	Bank collection abate amount	JL_BR_AP_ COLLECTION_DOCS_ ALL.ABATE_AMOUNT JL_BR_AP_INT_ COLLECT_EXT_ALL. ABATE_AMOUNT
PAID_AMOUNT	Amount paid	JL_BR_AP_ COLLECTION_DOCS_ ALL.PAID_AMOUNT JL_BR_AP_INT_ COLLECT_EXT_ALL. PAID_AMOUNT
PAYMENT_LOCATION	Payment location	JL_BR_AP_ COLLECTION_DOCS_ ALL.PAYMENT_ LOCATION JL_BR_AP_INT_ COLLECT_EXT_ALL. PAYMENT_LOCATION
DOCUMENT_TYPE	Bank collection document type	JL_BR_AP_ COLLECTION_DOCS_ ALL.DOCUMENT_TYPE JL_BR_AP_INT_ COLLECT_EXT_ALL. DOCUMENT_TYPE
ACCEPTANCE	Acceptance	JL_BR_AP_ COLLECTION_DOCS_ ALL.ACCEPTANCE JL_BR_AP_INT_ COLLECT_EXT_ALL. ACCEPTANCE
PROCESSING_DATE	The date that the bank collection document was processed. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.PROCESSING_ DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. PROCESSING_DATE
BANK_USE	Bank use	JL_BR_AP_ COLLECTION_DOCS_ ALL.BANK_USE JL_BR_AP_INT_ COLLECT_EXT_ALL. BANK_USE
PORTFOLIO	The portfolio code in the bank	JL_BR_AP_ COLLECTION_DOCS_ ALL.PORTFOLIO JL_BR_AP_INT_ COLLECT_EXT_ALL. PORTFOLIO
PENALTY_FEE_ AMOUNT	Penalty fee amount	JL_BR_AP_ COLLECTION_DOCS_ ALL.PENALTY_FEE_ AMOUNT JL_BR_AP_INT_ COLLECT_EXT_ALL. PENALTY_FEE_ AMOUNT
PENALTY_FEE_DATE	Penalty fee date. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.PENALTY_FEE_ DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. PENALTY_FEE_DATE
OTHER_ACCRETIONS	Other accretions	JL_BR_AP_ COLLECTION_DOCS_ ALL.OTHER_ ACCRETIONS JL_BR_AP_INT_ COLLECT_EXT_ALL. OTHER_ACCRETIONS
OUR_NUMBER	Our number	JL_BR_AP_ COLLECTION_DOCS_ ALL.OUR_NUMBER JL_BR_AP_INT_ COLLECT_EXT_ALL. OUR_NUMBER
TRANSFEROR_CODE	Transferor code	JL_BR_AP_ COLLECTION_DOCS_ ALL.TRANSFEROR_ CODE JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_CODE
OCCURRENCE	Occurrence	JL_BR_AP_INT_ COLLECT_EXT_ALL. OCCURRENCE
OCCURRENCE_DATE	Occurrence date. This value must be in valid date format.	JL_BR_AP_INT_ COLLECT_EXT_ALL. OCCURRENCE
DRAWEE_NAME	Drawee name. This value must exist in the JL_BR_COMPANY_INFOS. NAME table, or the error code is set to 04.	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_NAME
DRAWEE_BANK_CODE	Drawee bank code. This value must exist in the AP_BANK_BRANCHES. BANK_NUMBER table, or the error code is set to 07.	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_BANK_CODE
DRAWEE_BANK_NAME	Drawee bank name	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_BANK_ NAME
DRAWEE_BRANCH_ CODE	Drawee branch code. This value must exist in the AP_BANK_BRANCHES.BANK_ NUM table, or the error code is set to 07.	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_BRANCH_ CODE
DRAWEE_ACCOUNT_ NUMBER	Drawee account number. This value must exist in the AP_BANK_ACCOUNTS. BANK_ACCOUNT_NUM table, or the error code is set to 08.	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_ACCOUNT_NUMBER
DRAWEE_INSCRIPTION_ TYPE	Drawee inscription type. This value must exist in the JL_BR_COMPANY_INFOS. REGISTER_TYPE table, or the error code is set to 05.	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_ INSCRIPTION_TYPE
DRAWEE_INSCRIPTION_ NUMBER	Drawee inscription number. This value must exist in the JL_BR_COMPANY_INFOS. REGISTER_NUMBER \|\| REGISTER_SUBSIDIARY \|\| REGISTER_DIGIT table, or the error code is set to 06.	JL_BR_AP_INT_ COLLECT_EXT_ALL. DRAWEE_ INSCRIPTION_ NUMBER
TRANSFEROR_NAME	Transferor name. This value must exist in the PO_VENDORS.VENDOR_ NAME table, or the error code is set to 11.	JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_NAME
TRANSFEROR_BANK_ CODE	Transferor bank code. This value must exist in the AP_BANK_BRANCHES.BANK_ NUMBER table, or the error code is set to 12.	JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_BANK_ CODE
TRANSFEROR_BRANCH _CODE	Transferor branch code. This value must exist in the AP_BANK_BRANCHES. BANK_NUM table, or the error code is set to 12.	JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_ BRANCH_CODE
TRANSFEROR_ ACCOUNT_NUMBER	Transferor account number	JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_ ACCOUNT_NUMBER
TRANSFEROR_ INSCRIPTION_TYPE	Transferor inscription type. This value must exist in the PO_VENDOR_SITES. GLOBAL_ATTRIBUTE9 table, or the error code is set to 09.	JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_ INSCRIPTION_TYPE
TRANSFEROR_ INSCRIPTION_NUMBER	Transferor inscription number. This value must exist in the PO_VENDOR_SITES. GLOBAL_ATTRIBUTE10 \|\| GLOBAL_ATTRIBUTE11 \|\| GLOBAL_ATTRIBUTE12 table, or the error code is set to 10.	JL_BR_AP_INT_ COLLECT_EXT_ALL. TRANSFEROR_ INSCRIPTION_ NUMBER
ACCOUNTING_ BALANCING_SEGMENT	Accounting balancing segment. This value must exist in the JL_BR_COMPANY_INFOS. ACCOUNTING_BALANCING_ SEGMENT table.	JL_BR_AP_INT_ COLLECT_EXT_ALL. ACCOUNTING_ BALANCING_ SEGMENT
SET_OF_BOOKS_ID	The set of books identifier. This value must exist in the JL_BR_COMPANY_INFOS.SET_ OF_BOOKS_ID table.	JL_BR_AP_ COLLECTION_DOCS_ ALL.SET_OF_BOOKS_ID JL_BR_AP_INT_ COLLECT_EXT_ALL. SET_OF_BOOKS_ID
ERROR_CODE	Error code	JL_BR_AP_INT_ COLLECT_EXT_ALL. ERROR_CODE
ORG_ID	Organization identifier. This value must exist in the HR_OPERATING_UNITS. ORGANIZATION_ID table.	JL_BR_AP_ COLLECTION_DOCS_ ALL.ORG_ID JL_BR_AP_INT_ COLLECT_EXT_ALL. ORG_ID
LAST_UPDATE_DATE	Standard who column. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.LAST_UPDATE_ DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. LAST_UPDATE_DATE
LAST_UPDATED_BY	Standard who column	JL_BR_AP_ COLLECTION_DOCS_ ALL.LAST_UPDATED_ BY JL_BR_AP_INT_ COLLECT_EXT_ALL. LAST_UPDATED_BY
CREATION_DATE	Standard who column. This value must be in valid date format.	JL_BR_AP_ COLLECTION_DOCS_ ALL.CREATION_DATE JL_BR_AP_INT_ COLLECT_EXT_ALL. CREATION_DATE
CREATED_BY	Standard who column	JL_BR_AP_ COLLECTION_DOCS_ ALL.CREATED_BY JL_BR_AP_INT_ COLLECT_EXT_ALL. CREATED_BY
LAST_UPDATE_LOGIN	Standard who column	JL_BR_AP_ COLLECTION_DOCS_ ALL.LAST_UPDATE_ LOGIN JL_BR_AP_INT_ COLLECT_EXT_ALL. LAST_UPDATE_LOGIN