Results for “gl_date_source”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_LOCKBOXES_ALL is an Oracle Receivables (AR) configuration table that stores the definition of each bank lockbox used by the AutoLockbox program. A lockbox is a post office box or bank-controlled receipt location to which customers remit payments; the bank transmits deposit and remittance data electronically, and AutoLockbox ingests that data to create receipts, apply cash, and, where enabled, create claims. Each row in this table represents one lockbox definition and supplies the control parameters that govern how transmitted data is processed — batch source, receipt method, matching rules, and cash application behavior.

The table is a core setup object rather than a transactional table. Transactions and batch records reference a lockbox definition through the LOCKBOX_ID primary key. Based on the foreign key topology provided in the metadata, AR_LOCKBOXES_ALL behaves as a satellite-leaning entity: it holds descriptive attributes keyed by a surrogate identifier and depends on other configuration tables (AR_BATCH_SOURCES_ALL, AR_RECEIPT_METHODS) for its business context. This classification is a heuristic modeling suggestion only and does not constrain the underlying relational design.

Key Information Stored

The documented physical schema contains 43 columns. The most significant are:

• LOCKBOX_ID — surrogate primary key (AR_LOCKBOXES_PK), a system-generated unique identifier. A separate unique index, AR_LOCKBOXES_U2, also covers this column.
• LOCKBOX_NUMBER — the lockbox number assigned by the bank; a business-key candidate, participating with BANK_ORIGINATION_NUMBER and ORG_ID in unique index AR_LOCKBOXES_U1.
• BANK_ORIGINATION_NUMBER — the bank's origination identifier for the lockbox transmission; the second component of the AR_LOCKBOXES_U1 business key.
• ORG_ID — operating unit identifier, enforcing multi-org partitioning; the third component of AR_LOCKBOXES_U1.
• STATUS — indicates whether the lockbox definition is active or inactive.
• BATCH_SOURCE_ID — foreign key to AR_BATCH_SOURCES_ALL, the batch source used to create receipts from the transmission.
• RECEIPT_METHOD_ID — foreign key to AR_RECEIPT_METHODS, the receipt method applied to AutoLockbox-created receipts.
• BATCH_SIZE — the number of receipts to create per AutoLockbox batch.
• GL_DATE_SOURCE — determines the source of the accounting date for created receipts.
• AUTO_ASSOCIATE — flag controlling whether the transmission automatically associates to the lockbox.
• LOCKBOX_MATCHING_OPTION and USE_MATCHING_DATE — control how incoming remittance records are matched to existing open items.
• ALLOW_INVALID_TXN_NUM — permits processing of transmissions containing invalid transaction numbers.
• CREATE_CLAIMS_FLAG — controls whether claims are created for unapplied or unmatched amounts.
• AUTOAPPLY_FLAG and AUTOCASH_FLAG — control whether AutoApply and AutoCash rules are applied to receipts generated from the lockbox.

The table also carries standard descriptor columns (ATTRIBUTE1 through ATTRIBUTE15, ATTRIBUTE_CATEGORY) and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical use cases include setup validation, multi-org configuration reporting, and troubleshooting AutoLockbox transmissions. A common query retrieves all active lockboxes for an operating unit, joined to the batch source and receipt method:

• Setup reporting: SELECT lb.LOCKBOX_NUMBER, lb.BANK_ORIGINATION_NUMBER, bs.NAME batch_source, rm.NAME receipt_method FROM AR_LOCKBOXES_ALL lb, AR_BATCH_SOURCES_ALL bs, AR_RECEIPT_METHODS rm WHERE lb.BATCH_SOURCE_ID = bs.BATCH_SOURCE_ID AND lb.RECEIPT_METHOD_ID = rm.RECEIPT_METHOD_ID AND lb.ORG_ID = :org_id;
• Locating a lockbox definition by business key using the LOCKBOX_NUMBER, BANK_ORIGINATION_NUMBER, ORG_ID combination (AR_LOCKBOXES_U1).
• Auditing AutoLockbox behavior configuration, filtering on CREATE_CLAIMS_FLAG, AUTOAPPLY_FLAG, and AUTOCASH_FLAG.
• Transmission reconciliation, joining AR_TRANSMISSIONS_ALL to resolve the REQUESTED_LOCKBOX_ID to a lockbox number.

Related Objects

• AR_BATCH_SOURCES_ALL — referenced via AR_LOCKBOXES_ALL.BATCH_SOURCE_ID; supplies batch source attributes for receipt creation.
• AR_RECEIPT_METHODS — referenced via AR_LOCKBOXES_ALL.RECEIPT_METHOD_ID; defines the receipt method used.
• AR_BATCHES_ALL — references this table via LOCKBOX_ID; holds AutoLockbox batches linked to the lockbox.
• AR_TRANSMISSIONS_ALL — references this table via REQUESTED_LOCKBOX_ID; tracks bank transmissions submitted for processing.
• AR_RECEIPTS and related receipt tables — downstream recipients of AutoLockbox-generated receipts sourced from lockbox definitions.
• AutoLockbox concurrent program — consumes AR_LOCKBOXES_ALL configuration at run time to create and apply receipts.