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.AR_CONS_INV_TRX_ALL

Object Details

Object Name:	AR_CONS_INV_TRX_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_CONS_INV_TRX_ALL
Subobject Name:
Status:	VALID

The AR_CONS_INV_TRX_ALL table contains header-level information about transactions that are included on a consolidated billing invoice. Transactions include invoices, credit memos, cash receipts, invoice cancellations, cash receipt reversals, cross-site cash receipt applications, and adjustments.
.
Rows are created when you run the Consolidated Billing Invoice program to create a consolidated billing invoice. These rows are deleted when a consolidated billing invoice is rejected.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CONS_INV_TRX_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONS_INV_ID CONS_INV_LINE_NUMBER
AR_CONS_INV_TRX_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJ_PS_ID TRANSACTION_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CONS_INV_ID	NUMBER	(15)	Yes	Consolidated billing invoice identifier
CONS_INV_LINE_NUMBER	NUMBER	(15)		Line number assigned to each row related to an invoice or credit memo transaction
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Consolidated invoice transaction type lookup code in AR_LOOKUPS
TRX_NUMBER	VARCHAR2	(30)		Invoice, credit memo, or receipt number
TRANSACTION_DATE	DATE		Yes	Transaction date
AMOUNT_ORIGINAL	NUMBER			Original balance due for this transaction
TAX_ORIGINAL	NUMBER			Original amount of tax for this transaction
ADJ_PS_ID	NUMBER	(15)		Depending on transaction type, PAYMENT_SCHEDULE_ID, ADJUSTMENT_ID, or RECEIVABLE_APPLICATION_ID
ORG_ID	NUMBER	(15)		Organization identifier
CUSTOMER_TRX_ID	NUMBER	(15)		Transaction identifier
JUSTIFICATION	VARCHAR2	(200)		Indicates reason this transaction is included in this balance forward bill
UNPAID_REASON	VARCHAR2	(30)		Reason why bill is not paid
SHIP_TO_SITE_ID	NUMBER	(15)		Ship-to site identifier
TRX_DESCRIPTION	VARCHAR2	(30)		Transaction description

Query Text

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


SELECT CONS_INV_ID
,      CONS_INV_LINE_NUMBER
,      TRANSACTION_TYPE
,      TRX_NUMBER
,      TRANSACTION_DATE
,      AMOUNT_ORIGINAL
,      TAX_ORIGINAL
,      ADJ_PS_ID
,      ORG_ID
,      CUSTOMER_TRX_ID
,      JUSTIFICATION
,      UNPAID_REASON
,      SHIP_TO_SITE_ID
,      TRX_DESCRIPTION
FROM AR.AR_CONS_INV_TRX_ALL;

Dependencies

[top of page]

AR.AR_CONS_INV_TRX_ALL does not reference any database object

AR.AR_CONS_INV_TRX_ALL is referenced by following:

APPS: AR_CONS_INV_TRX; AR_CONS_INV_TRX_ALL