AR_BATCHES_ALL
The AR_BATCHES_ALL table stores batch source information about each receipt and remittance batch. Each row includes specific batch information, such as batch source, status, batch type, control count, and control amount. The BATCH_APPLIED_STATUS column stores the status of each batch. Other status values are used for remittance batches. For receipt batch rows, valid values are IN_PROCESS, PROCESSED, and POSTBATCH_WAITING. The TYPE column has one of these values: MANUAL for manually created batches, CREATION for batches that contain automatic receipts, REMITTANCE for remittance batches, CLEARANCE for clearance batches, and BR_REMITTANCE for bills receivable remittance batches. The primary key for this table is BATCH_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_BATCHES_PK |
BATCH_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Identifier of the payment batch | ||
| 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. | |||
| 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. | |||
| NAME | VARCHAR2 | 20 | Yes | Payment batch name. | ||
| BATCH_DATE | DATE | Yes | Date for the payment batch | |||
| GL_DATE | DATE | Accounting date. | ||||
| STATUS | VARCHAR2 | 20 | Payment batch status | |||
| DEPOSIT_DATE | DATE | Deposit date for the payment batch | ||||
| CLOSED_DATE | DATE | Date the payment batch closed | ||||
| TYPE | VARCHAR2 | 30 | Yes | Type of the payment batch | ||
| CONTROL_COUNT | NUMBER | 18 | Control count of items in the payment batch | |||
| ACTUAL_COUNT | NUMBER | 18 | Number of receipts in this payment batch | |||
| ACTUAL_AMOUNT | NUMBER | Actual amount for this payment batch | ||||
| CONTROL_AMOUNT | NUMBER | Control amount for this payment batch | ||||
| BATCH_APPLIED_STATUS | VARCHAR2 | 30 | Yes | Indicates the actual stage of the payment batch | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code for the batch | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Used to define multiple currency exchange rates for the same date | |||
| EXCHANGE_DATE | DATE | Date for which rate is selected | ||||
| EXCHANGE_RATE | NUMBER | Exchange rate used to convert foreign currency amounts into functional currency | ||||
| TRANSMISSION_REQUEST_ID | NUMBER | 18 | Identifier of the lockbox transmission associated with this payment batch | |||
| LOCKBOX_ID | NUMBER | 18 | Identifier of the lockbox associated with this payment batch | |||
| LOCKBOX_BATCH_NAME | VARCHAR2 | 25 | Name of the lockbox associated with this payment batch | |||
| COMMENTS | VARCHAR2 | 240 | Comments | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| MEDIA_REFERENCE | VARCHAR2 | 80 | Name of the media that will be used for the transmission | |||
| OPERATION_REQUEST_ID | NUMBER | 18 | Concurrent request of the program which creates the payment batch | |||
| RECEIPT_METHOD_ID | NUMBER | 18 | Foreign key reference to the payment method in AR_RECEIPT_METHODS | |||
| REMITTANCE_BANK_ACCOUNT_ID | NUMBER | 18 | Foreign key reference to the remittance bank account in AP_BANK_ACCOUNTS | |||
| RECEIPT_CLASS_ID | NUMBER | 18 | Foreign key reference to RECEIPT_CLASS_ID from AR_RECEIPT_CLASSES | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Batch (AR_BATCHES) | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||||
| REMITTANCE_BANK_BRANCH_ID | NUMBER | 18 | Identifier of the default remittance bank branch of the payment batch | |||
| REMIT_METHOD_CODE | VARCHAR2 | 30 | Indicates the remittance method that will be used for remitting automatic receipts created with this payment batch | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifier of the General Ledger set of books associated with this payment batch | ||
| TRANSMISSION_ID | NUMBER | 18 | Identifies the transmission that processed the lockbox receipts | |||
| BANK_DEPOSIT_NUMBER | VARCHAR2 | 30 | An optional, user entered reference number | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| PURGED_CHILDREN_FLAG | VARCHAR2 | 1 | Value is Yes if some details have been purged; otherwise value is null | |||
| WITH_RECOURSE_FLAG | VARCHAR2 | 1 | Indicates whether the bank has the right of recourse if the drawee defaults on a factored bill receivable | |||
| AUTO_PRINT_PROGRAM_ID | NUMBER | 18 | Print program identifier to be used for the remittance. | |||
| AUTO_TRANS_PROGRAM_ID | NUMBER | 18 | Magnetic format print program identifier to be used for the remittance. | |||
| REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | The unique identifier of the remittance bank account use id to which the automatic receipt will be deposited | |||
| OLD_REMITTANCE_BANK_BRANCH_ID | NUMBER | 18 | Identifier of the old default remittance bank branch of the payment batch. | |||
| 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 | Batch source sequence identifier. | |||
| AUTOMATCH_REQUEST_ID | NUMBER | Automatch request identifier |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_BATCHES_ALL | ar_transmissions_all | TRANSMISSION_REQUEST_ID |
| AR_BATCHES_ALL | ar_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| AR_BATCHES_ALL | ce_bank_acct_uses_all | REMIT_BANK_ACCT_USE_ID |
| AR_BATCHES_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AR_BATCHES_ALL | ar_receipt_methods | RECEIPT_METHOD_ID |
| AR_BATCHES_ALL | ar_receipt_classes | RECEIPT_CLASS_ID |
| AR_BATCHES_ALL | ar_transmissions_all | TRANSMISSION_ID |
| AR_BATCHES_ALL | ar_lockboxes_all | LOCKBOX_ID |
| ra_customer_trx_all | ar_batches_all | REMITTANCE_BATCH_ID |
| ar_adjustments_all | ar_batches_all | BATCH_ID |
| ar_autorec_exceptions | ar_batches_all | BATCH_ID |
| ar_interim_cash_receipts_all | ar_batches_all | BATCH_ID |
| ar_cash_receipts_all | ar_batches_all | SELECTED_REMITTANCE_BATCH_ID |
| ar_payment_schedules_all | ar_batches_all | SELECTED_FOR_RECEIPT_BATCH_ID |
| ar_interim_cash_rcpt_lines_all | ar_batches_all | BATCH_ID |
| ar_cash_receipt_history_all | ar_batches_all | BATCH_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_BATCHES_N1 | Non Unique | Default | BATCH_DATE |
| AR_BATCHES_N10 | Non Unique | Default | STATUS |
| AR_BATCHES_N11 | Non Unique | Default | BATCH_APPLIED_STATUS |
| AR_BATCHES_N12 | Non Unique | Default | AUTOMATCH_REQUEST_ID |
| AR_BATCHES_N13 | Non Unique | Default | UPPER("NAME") |
| AR_BATCHES_N2 | Non Unique | Default | BATCH_SOURCE_SEQ_ID |
| AR_BATCHES_N3 | Non Unique | Default | CREATION_DATE |
| AR_BATCHES_N4 | Non Unique | Default | GL_DATE |
| AR_BATCHES_N5 | Non Unique | Default | NAME |
| AR_BATCHES_N6 | Non Unique | Default | REMIT_BANK_ACCT_USE_ID |
| AR_BATCHES_N7 | Non Unique | Default | TRANSMISSION_REQUEST_ID |
| AR_BATCHES_N8 | Non Unique | Default | DEPOSIT_DATE |
| AR_BATCHES_N9 | Non Unique | Default | TRANSMISSION_ID |
| AR_BATCHES_U1 | Unique | Default | BATCH_ID |