RA_BATCH_SOURCES_ALL
The RA_BATCH_SOURCES_ALL table stores information about the sources of your invoices, credit memos, and commitments. Each row includes information about invoice, batch, and credit memo numbering. Oracle Receivables creates one row for each batch source that you define. Receivables uses batch sources to default a transaction type during invoice entry and to determine invoice, batch, and credit memo numbering. . The BATCH_SOURCE_TYPE column stores INV for manual batches or FOREIGN for imported batches. The STATUS, CREDIT_MEMO_BATCH_SOURCE_ID, AUTO_BATCH_NUMBERING, and AUTO_TRX_NUMBERING columns are required even though they are null allowed. . The primary key for this table is BATCH_SOURCE_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
RA_BATCH_SOURCES_PK |
BATCH_SOURCE_SEQ_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| BATCH_SOURCE_ID | NUMBER | 18 | Yes | Batch source 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 source name | ||
| 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. | ||
| DESCRIPTION | VARCHAR2 | 240 | Batch source description | |||
| STATUS | VARCHAR2 | 1 | Batch source status flag. Lookup code for CODE_STATUS | |||
| LAST_BATCH_NUM | NUMBER | 18 | Last batch number that was automatically generated | |||
| DEFAULT_INV_TRX_TYPE | NUMBER | 18 | Default transaction type identifier | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ACCOUNTING_FLEXFIELD_RULE | VARCHAR2 | 30 | Determines how accounting flexfield information is passed in when using AutoInvoice. Segment or ID. | |||
| ACCOUNTING_RULE_RULE | VARCHAR2 | 30 | Determines how accounting rule information is passed in when using AutoInvoice. Value, ID, or None. | |||
| AGREEMENT_RULE | VARCHAR2 | 30 | Determines how agreements information is passed in when using AutoInvoice. Value, ID, or None. | |||
| AUTO_BATCH_NUMBERING_FLAG | VARCHAR2 | 1 | Flag to indicate if batch numbering is automatic or manual. Y for automatic, N for manual. | |||
| AUTO_TRX_NUMBERING_FLAG | VARCHAR2 | 1 | Flag to indicate if transaction numbering is automatic or manual. Y for automatic, N for manual. | |||
| BATCH_SOURCE_TYPE | VARCHAR2 | 30 | Yes | Imported if used by AutoInvoice, Manual otherwise | ||
| BILL_ADDRESS_RULE | VARCHAR2 | 30 | Determines how bill-to address information is passed in when using AutoInvoice. Value or ID. | |||
| BILL_CONTACT_RULE | VARCHAR2 | 30 | Determines how bill-to contact information is passed in when using AutoInvoice. Value, ID, or None. | |||
| BILL_CUSTOMER_RULE | VARCHAR2 | 30 | Determines how bill-to customer information is passed in when using AutoInvoice. Value or ID. | |||
| CREATE_CLEARING_FLAG | VARCHAR2 | 1 | Y if AutoInvoice Clearing Account entries are allowed, N if not | |||
| CUST_TRX_TYPE_RULE | VARCHAR2 | 30 | Determines how transaction type information is passed in when using AutoInvoice (Value or ID) | |||
| DERIVE_DATE_FLAG | VARCHAR2 | 1 | Y if AutoInvoice should derive dates and N if not. | |||
| END_DATE | DATE | End date active for this batch source | ||||
| FOB_POINT_RULE | VARCHAR2 | 30 | Determines how FOB point information is passed in when using AutoInvoice. Code or None. | |||
| GL_DATE_PERIOD_RULE | VARCHAR2 | 30 | Determines what to do with a General Ledger date that is in a closed period. Reject or Adjust. | |||
| INVALID_LINES_RULE | VARCHAR2 | 30 | Determines whether an invoice is created or rejected if one of the lines is in error | |||
| INVALID_TAX_RATE_RULE | VARCHAR2 | 30 | Determines whether an invalid tax rate is rejected or corrected | |||
| INVENTORY_ITEM_RULE | VARCHAR2 | 30 | Determines how inventory item information is passed in when using AutoInvoice. Segment, ID, or None. | |||
| INVOICING_RULE_RULE | VARCHAR2 | 30 | Determines how invoicing rule information is passed in when using AutoInvoice. Value, ID, or None. | |||
| MEMO_REASON_RULE | VARCHAR2 | 30 | Determines how memo reason information is passed in when using AutoInvoice. Value or ID. | |||
| REV_ACC_ALLOCATION_RULE | VARCHAR2 | 30 | Determines how revenue account allocation is passed in when using AutoInvoice. Amount or Percent. | |||
| SALESPERSON_RULE | VARCHAR2 | 30 | Determines how salesperson information is passed in when using AutoInvoice. Number or ID. | |||
| SALES_CREDIT_RULE | VARCHAR2 | 30 | Determines how sales credit allocation is passed in when using AutoInvoice. Amount or Percent. | |||
| SALES_CREDIT_TYPE_RULE | VARCHAR2 | 30 | Determines how sales credit type information is passed in when using AutoInvoice. Value or ID. | |||
| SALES_TERRITORY_RULE | VARCHAR2 | 30 | Determines how sales territory information is passed in when using AutoInvoice. Segment, ID, or None. | |||
| SHIP_ADDRESS_RULE | VARCHAR2 | 30 | Determines how ship-to address information is passed in when using AutoInvoice. Value, ID, or None. | |||
| SHIP_CONTACT_RULE | VARCHAR2 | 30 | Determines how ship-to contact information is passed in when using AutoInvoice. Value, ID, or None. | |||
| SHIP_CUSTOMER_RULE | VARCHAR2 | 30 | Determines how ship-to customer information is passed in when using AutoInvoice. Value, ID, or None. | |||
| SHIP_VIA_RULE | VARCHAR2 | 30 | Determines how freight carrier information is passed in when using AutoInvoice. Code or None. | |||
| SOLD_CUSTOMER_RULE | VARCHAR2 | 30 | Determines how sold to customer information is passed in when using AutoInvoice. Value or ID. | |||
| START_DATE | DATE | The first date that this batch source is active | ||||
| TERM_RULE | VARCHAR2 | 30 | Determines how term information is passed in when using AutoInvoice. Value or ID. | |||
| UNIT_OF_MEASURE_RULE | VARCHAR2 | 30 | Determines how unit of measure information is passed in when using AutoInvoice. Value or ID. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Source (RA_BATCH_SOURCES) | ||
| CUSTOMER_BANK_ACCOUNT_RULE | VARCHAR2 | 30 | Determines how customer bank account information is passed in when using AutoInvoice (Value or ID) | |||
| MEMO_LINE_RULE | VARCHAR2 | 30 | Determines how memo line information is passed in when using AutoInvoice (Value or ID) | |||
| RECEIPT_METHOD_RULE | VARCHAR2 | 30 | Determines how payment rule information is passed in when using AutoInvoice (Value or ID) | |||
| RELATED_DOCUMENT_RULE | VARCHAR2 | 30 | Determines how related document information is passed in when using AutoInvoice (Number or ID or None) | |||
| ALLOW_SALES_CREDIT_FLAG | VARCHAR2 | 1 | Indicates if AutoInvoice passes in sales credit. Y for Yes, N otherwise. | |||
| GROUPING_RULE_ID | NUMBER | 18 | Foreign key to the grouping rules that you have defined. This is the grouping rule that AutoInvoice uses to group your lines into invoices. | |||
| CREDIT_MEMO_BATCH_SOURCE_ID | NUMBER | 18 | This points to the default credit memo batch source to use when you are creating a credit memo against a transaction that belongs to this batch source | |||
| 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_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. | ||||
| 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. | ||||
| COPY_DOC_NUMBER_FLAG | VARCHAR2 | 1 | Flag to indicate whether the document number and the transaction number are the same for transactions assigned to this source. | |||
| DEFAULT_REFERENCE | VARCHAR2 | 80 | Transaction flexfield attribute that is defaulted into the reference field in the transaction user interface. | |||
| COPY_INV_TIDFF_TO_CM_FLAG | VARCHAR2 | 1 | Indicates if the transaction information flexfield should be copied when creating a credit memo | |||
| RECEIPT_HANDLING_OPTION | VARCHAR2 | 30 | Receipt handling method for credits | |||
| ALLOW_DUPLICATE_TRX_NUM_FLAG | VARCHAR2 | 1 | Indicates if duplicate transaction numbers are permitted | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Default legal entity assigned to transactions using this batch source. | |||
| 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 | Batch source sequence identifier. | ||
| DEFAULT_INV_TRX_TYPE_SEQ_ID | NUMBER | 18 | Default invoice transaction type sequence identifier. | |||
| CM_BATCH_SOURCE_SEQ_ID | NUMBER | 18 | Credit memo batch source sequence identifier. | |||
| BM_ENDPOINT_KEY_NAME | VARCHAR2 | 500 | Mapping key that references the endpoint URL for the BigMachines. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Identifier of a source document type. | |||
| CONTROL_TRX_COMPLETION_FLAG | VARCHAR2 | 1 | Indicates whether control of transaction completion is enabled on the transaction source. | |||
| USAGE_CATEGORY_CODE | VARCHAR2 | 30 | Indicates the usage category assigned to this transaction source. Valid values are derived from the lookup type ORA_AR_USAGE_CATEGORY. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_BATCH_SOURCES_ALL | ra_cust_trx_types_all | DEFAULT_INV_TRX_TYPE_SEQ_ID |
| RA_BATCH_SOURCES_ALL | ra_grouping_rules | GROUPING_RULE_ID |
| RA_BATCH_SOURCES_ALL | ra_batch_sources_all | CM_BATCH_SOURCE_SEQ_ID |
| RA_BATCH_SOURCES_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
| ra_customer_trx_all | ra_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| ra_customer_trx_all | ra_batch_sources_all | RELATED_BATCH_SOURCE_SEQ_ID |
| hes_fee_types_b | ra_batch_sources_all | SYSTEM_BATCH_SOURCE_ID |
| hes_transaction_post_all | ra_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| ra_batch_sources_all | ra_batch_sources_all | CM_BATCH_SOURCE_SEQ_ID |
| vrm_new_ar_sources | ra_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| ar_system_parameters_all | ra_batch_sources_all | LATE_CHARGE_BAT_SOURCE_SEQ_ID |
| hes_fees_all_b | ra_batch_sources_all | USER_BATCH_SOURCE_ID |
| hes_credit_types_b | ra_batch_sources_all | SYSTEM_BATCH_SOURCE_ID |
| ra_batches_all | ra_batch_sources_all | BATCH_SOURCE_SEQ_ID |
| hes_default_source_all | ra_batch_sources_all | USER_BATCH_SOURCE_ID |
| okc_bu_impl_options_all | ra_batch_sources_all | CUST_INV_BATCH_SRC_ID |
| okc_bu_impl_options_all | ra_batch_sources_all | INT_INV_BATCH_SRC_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_BATCH_SOURCES_N1 | Non Unique | Default | UPPER("NAME") |
| RA_BATCH_SOURCES_U1 | Unique | Default | NAME, SET_ID, ORA_SEED_SET1 |
| RA_BATCH_SOURCES_U11 | Unique | Default | NAME, SET_ID, ORA_SEED_SET2 |
| RA_BATCH_SOURCES_U2 | Unique | Default | BATCH_SOURCE_ID, SET_ID, ORA_SEED_SET1 |
| RA_BATCH_SOURCES_U21 | Unique | Default | BATCH_SOURCE_ID, SET_ID, ORA_SEED_SET2 |
| RA_BATCH_SOURCES_U3 | Unique | Default | BATCH_SOURCE_SEQ_ID, ORA_SEED_SET1 |
| RA_BATCH_SOURCES_U31 | Unique | Default | BATCH_SOURCE_SEQ_ID, ORA_SEED_SET2 |