[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_LOCKBOXES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_LOCKBOXES_ALL
|
| Subobject Name: | |
| Status: | VALID |
The AR_LOCKBOXES_ALL table stores information about your Lockboxes. AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. An AutoLockbox operation can process
millions of transactions a month.
.
AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. You specify how you want this information transmitted and Receivables ensures that the data is valid before creating QuickCash receipt batches. AutoLockbox uses your Lockbox definitions when transferring receipts from your bank file into Oracle Receivables.
.
The primary key for this table is LOCKBOX_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_LOCKBOXES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LOCKBOX_NUMBER
BANK_ORIGINATION_NUMBER
ORG_ID
|
| AR_LOCKBOXES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
LOCKBOX_ID
|
| AR_LOCKBOXES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOCKBOX_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOCKBOX_ID | NUMBER | (15) | Yes | Lockbox identifier |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LOCKBOX_NUMBER | VARCHAR2 | (30) | Yes | Number of the lockbox within the bank |
| STATUS | VARCHAR2 | (1) | Yes | Status of the lockbox, active or inactive |
| BATCH_SOURCE_ID | NUMBER | (15) | Yes | Identifier of the batch source that is associated with this lockbox |
| BANK_ORIGINATION_NUMBER | VARCHAR2 | (30) | Yes | Uniquely identifies the bank branch that sends the lockbox information |
| BATCH_SIZE | NUMBER | (15) | Number of records in the batch | |
| CONTACT_NAME | VARCHAR2 | (30) | Name of the contact person | |
| 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| 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 | (15) | Indicates the default receipt method for the receipts in the lockbox | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| 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) | Y or N indicates if AutoLockbox should ignore invalid transaction numbers | |
| CREATE_CLAIMS_FLAG | VARCHAR2 | (1) | Determines if receipts/remittances should be considered for claim creation | |
| LINE_LEVEL_CASH_APP_RULE | VARCHAR2 | (1) | Line Level Cash Application Rule |
Cut, paste (and edit) the following text to query this object:
SELECT LOCKBOX_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LOCKBOX_NUMBER
, STATUS
, BATCH_SOURCE_ID
, BANK_ORIGINATION_NUMBER
, BATCH_SIZE
, CONTACT_NAME
, TELEPHONE
, GL_DATE_SOURCE
, AUTO_ASSOCIATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUIRE_BILLING_LOCATION_FLAG
, EXCHANGE_RATE_TYPE
, RECEIPT_METHOD_ID
, ORG_ID
, LOCKBOX_MATCHING_OPTION
, USE_MATCHING_DATE
, ALLOW_INVALID_TXN_NUM
, CREATE_CLAIMS_FLAG
, LINE_LEVEL_CASH_APP_RULE
FROM AR.AR_LOCKBOXES_ALL;
AR.AR_LOCKBOXES_ALL does not reference any database object
AR.AR_LOCKBOXES_ALL is referenced by following:
APPS
AR_LOCKBOXES
AR_LOCKBOXES_ALL
|
|
|
|