RA_BATCHES_ALL
The RA_BATCHES_ALL table stores information about each invoice or bills receivable batch that you enter in Oracle Fusion Receivables. Each row in this table includes information about each batch that belongs to a batch source. The TYPE column contains values INV or BR. The STATUS and BATCH_SOURCE_ID columns are required even though they are null allowed. The primary key for this table is BATCH_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RA_BATCHES_PK |
BATCH_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch identifier | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| NAME | VARCHAR2 | 50 | Yes | Batch name | ||
| BATCH_DATE | DATE | Yes | Batch date | |||
| GL_DATE | DATE | Yes | Accounting date. | |||
| STATUS | VARCHAR2 | 20 | Batch status. Lookup code for BATCH_STATUS. This column is not updated automatically. | |||
| TYPE | VARCHAR2 | 30 | Lookup code for INV/CM. Always INV | |||
| BATCH_SOURCE_ID | NUMBER | 18 | Batch source identifier | |||
| CONTROL_COUNT | NUMBER | 18 | Control count of invoices associated with the batch | |||
| CONTROL_AMOUNT | NUMBER | Control sum of invoice amounts associated with the batch | ||||
| COMMENTS | VARCHAR2 | 240 | Comments of the batch | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| 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). | ||||
| CURRENCY_CODE | VARCHAR2 | 15 | Batch currency | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type. | |||
| EXCHANGE_DATE | DATE | Conversion rate date. | ||||
| EXCHANGE_RATE | NUMBER | Conversion rate type. | ||||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | Identifies the ledger associated with the batch. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Batch (RA_BATCHES) | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| PURGED_CHILDREN_FLAG | VARCHAR2 | 1 | Value is Y if some details have been purged. Otherwise, the value is null. | |||
| ISSUE_DATE | DATE | Date the bill receivable was issued | ||||
| MATURITY_DATE | DATE | Maturity date for the bill receivable | ||||
| SPECIAL_INSTRUCTIONS | VARCHAR2 | 240 | Special instructions that appear on the bill receivable | |||
| BATCH_PROCESS_STATUS | VARCHAR2 | 20 | Indicates the stage of the Bills Receivable batch. Possible values: DRAFT, CREATION_STARTED and CREATION_COMPLETED. | |||
| SELECTION_CRITERIA_ID | NUMBER | 18 | Foreign key to selection criteria defined for the Bills Receivable creation 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_BATCHES_ALL | ra_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| RA_BATCHES_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| zx_lines_det_factors | ra_batches_all | TRX_BATCH_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_BATCHES_N1 | Non Unique | RA_BATCHES_N1 | NAME |
| RA_BATCHES_N2 | Non Unique | RA_BATCHES_N2 | BATCH_SOURCE_SEQ_ID |
| RA_BATCHES_N3 | Non Unique | RA_BATCHES_N3 | BATCH_DATE |
| RA_BATCHES_N4 | Non Unique | RA_BATCHES_N4 | GL_DATE |
| RA_BATCHES_U1 | Unique | RA_BATCHES_U1 | BATCH_ID |