eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	AR.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_BATCH_SOURCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME ORG_ID ZD_EDITION_NAME
RA_BATCH_SOURCES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_SOURCE_ID ORG_ID ZD_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:

AR: RA_BATCH_SOURCES_ALL#