DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.RA_BATCH_SOURCES_ALL

Object Details
Object Name: RA_BATCH_SOURCES_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.RA_BATCH_SOURCES_ALL
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_BATCH_SOURCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnORG_ID
ColumnZD_EDITION_NAME
RA_BATCH_SOURCES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_SOURCE_ID
ColumnORG_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
BATCH_SOURCE_ID NUMBER (15) Yes Batch source identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NAME VARCHAR2 (50) Yes Batch source name
ORG_ID NUMBER (15)
Organization identifier
DESCRIPTION VARCHAR2 (240)
Batch source description
STATUS VARCHAR2 (1)
Batch source status flag. Lookup code for CODE_STATUS
LAST_BATCH_NUM NUMBER (15)
Last batch number that was automatically generated
DEFAULT_INV_TRX_TYPE NUMBER (15)
Default transaction type identifier
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
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
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
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 (15)
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 (15)
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_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
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 Transactions window. Replaces the AR: Transaction Flexfield QuickPick Attribute profile option.
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 (15)
Default legal entity assigned to transactions using this batch source.
GEN_LINE_LEVEL_BAL_FLAG VARCHAR2 (1)
Line level balance flag
PAYMENT_DET_DEF_HIERARCHY VARCHAR2 (20)
Payment Details Default Heirarchy
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_SOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      ORG_ID
,      DESCRIPTION
,      STATUS
,      LAST_BATCH_NUM
,      DEFAULT_INV_TRX_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ACCOUNTING_FLEXFIELD_RULE
,      ACCOUNTING_RULE_RULE
,      AGREEMENT_RULE
,      AUTO_BATCH_NUMBERING_FLAG
,      AUTO_TRX_NUMBERING_FLAG
,      BATCH_SOURCE_TYPE
,      BILL_ADDRESS_RULE
,      BILL_CONTACT_RULE
,      BILL_CUSTOMER_RULE
,      CREATE_CLEARING_FLAG
,      CUST_TRX_TYPE_RULE
,      DERIVE_DATE_FLAG
,      END_DATE
,      FOB_POINT_RULE
,      GL_DATE_PERIOD_RULE
,      INVALID_LINES_RULE
,      INVALID_TAX_RATE_RULE
,      INVENTORY_ITEM_RULE
,      INVOICING_RULE_RULE
,      MEMO_REASON_RULE
,      REV_ACC_ALLOCATION_RULE
,      SALESPERSON_RULE
,      SALES_CREDIT_RULE
,      SALES_CREDIT_TYPE_RULE
,      SALES_TERRITORY_RULE
,      SHIP_ADDRESS_RULE
,      SHIP_CONTACT_RULE
,      SHIP_CUSTOMER_RULE
,      SHIP_VIA_RULE
,      SOLD_CUSTOMER_RULE
,      START_DATE
,      TERM_RULE
,      UNIT_OF_MEASURE_RULE
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CUSTOMER_BANK_ACCOUNT_RULE
,      MEMO_LINE_RULE
,      RECEIPT_METHOD_RULE
,      RELATED_DOCUMENT_RULE
,      ALLOW_SALES_CREDIT_FLAG
,      GROUPING_RULE_ID
,      CREDIT_MEMO_BATCH_SOURCE_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      COPY_DOC_NUMBER_FLAG
,      DEFAULT_REFERENCE
,      COPY_INV_TIDFF_TO_CM_FLAG
,      RECEIPT_HANDLING_OPTION
,      ALLOW_DUPLICATE_TRX_NUM_FLAG
,      LEGAL_ENTITY_ID
,      GEN_LINE_LEVEL_BAL_FLAG
,      PAYMENT_DET_DEF_HIERARCHY
,      ZD_EDITION_NAME
FROM AR.RA_BATCH_SOURCES_ALL;

Dependencies

[top of page]

AR.RA_BATCH_SOURCES_ALL does not reference any database object

AR.RA_BATCH_SOURCES_ALL is referenced by following:

SchemaAR
ViewRA_BATCH_SOURCES_ALL#