1. Tables and Views for Financials
  2. AR_LOCKBOXES_ALL

AR_LOCKBOXES_ALL

The AR_LOCKBOXES_ALL table contains information about your Lockboxes. Lockbox is a service commercial banks offer corporate customers outsourcing their accounts receivable payment processing. Lockbox eliminates manual data entry by automatically processing receipts sent directly to your bank. You specify how you want this information transmitted and Oracle Fusion Receivables ensures that the data is valid before creating receipt batches using Lockbox definitions when transferring receipts from your bank file into Receivables. The primary key for this table is LOCKBOX_ID.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

AR_LOCKBOXES_PK

LOCKBOX_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
LOCKBOX_ID NUMBER 18 Yes Lockbox identifier
BATCH_SOURCE_ID NUMBER 18 Batch source identifier - Obsolete
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LOCKBOX_NUMBER VARCHAR2 30 Yes Number of the lockbox within the bank
STATUS VARCHAR2 1 Yes Status of the lockbox, active or inactive
BANK_ORIGINATION_NUMBER VARCHAR2 30 Yes Uniquely identifies the bank branch that sends the lockbox information
BATCH_SIZE NUMBER 18 Number of records in the batch
CONTACT_NAME VARCHAR2 30 Contact person name.
TELEPHONE VARCHAR2 20 Telephone number of the contact person
GL_DATE_SOURCE VARCHAR2 30 Source of the accounting date
AUTO_ASSOCIATE VARCHAR2 1 Y or N indicates if AUTO_ASSOCIATE is on or off
BEP_ACCOUNT_ID NUMBER 18 Identifier of the payment system account that contains details for retrieving the funds capture process profile. Foreign Key to IBY_BEPKEYS.
START_DATE DATE Date and time the automatically scheduled lockbox process begins.
END_DATE DATE Date and time the automatically scheduled lockbox process ends.
LOCKBOX_REQUEST_ID NUMBER 18 Identifier of the schedule that is automatically created for the parent lockbox process.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Lockbox (AR_LOCKBOXES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
REQUIRE_BILLING_LOCATION_FLAG VARCHAR2 1 Yes Y or N indicates if a billing location is required for receipts
EXCHANGE_RATE_TYPE VARCHAR2 30 Indicates the default exchange rate type for foreign currencies
RECEIPT_METHOD_ID NUMBER 18 Indicates the default receipt method for the receipts in the lockbox
SET_ID NUMBER 18 Yes Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
LOCKBOX_MATCHING_OPTION VARCHAR2 20 Lockbox matching option, typically INVOICE, SALES_ORDER, or PURCHASE_ORDER
USE_MATCHING_DATE VARCHAR2 20 Use matching date for matching in lockbox, value can be NEVER, ALWAYS, or FOR_DUPLICATES
ALLOW_INVALID_TXN_NUM VARCHAR2 1 Yes or No flag that indicates if the lockbox should ignore the invalid transaction numbers.
CREATE_CLAIMS_FLAG VARCHAR2 1 Determines if receipts/remittances should be considered for claim creation
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
BATCH_SOURCE_SEQ_ID NUMBER 18 Yes Lockbox batch source sequence identifier.
AUTOMATCH_RULE_ID NUMBER 18 Automatch Rule Identifier
AUTOAPPLY_FLAG VARCHAR2 1 Autoapply Flag
PRIMARY_REFERENCE VARCHAR2 10 Says which is the primary reference, customer or transaction, in case customer reference is invalid
EXCEPTION_RULE_ID NUMBER 18 Under/Over Payment Exception Rule Identifier
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
AR_LOCKBOXES_ALL ar_batch_sources_all BATCH_SOURCE_SEQ_ID
AR_LOCKBOXES_ALL ar_receipt_methods RECEIPT_METHOD_ID
AR_LOCKBOXES_ALL gl_daily_conversion_types EXCHANGE_RATE_TYPE
AR_LOCKBOXES_ALL ar_automatch_rules AUTOMATCH_RULE_ID
AR_LOCKBOXES_ALL ar_app_exception_rules EXCEPTION_RULE_ID
ar_batches_all ar_lockboxes_all LOCKBOX_ID
ar_transmissions_all ar_lockboxes_all REQUESTED_LOCKBOX_ID

Indexes

Index Uniqueness Tablespace Columns Status
AR_LOCKBOXES_N1 Non Unique Default LOCKBOX_NUMBER Obsolete
AR_LOCKBOXES_N2 Non Unique Default UPPER("LOCKBOX_NUMBER")
AR_LOCKBOXES_U1 Unique Default LOCKBOX_NUMBER, BANK_ORIGINATION_NUMBER, SET_ID
AR_LOCKBOXES_U2 Unique Default LOCKBOX_ID