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_ALL

Object Details

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

The AR_CONS_INV_ALL table stores information about consolidated billing invoices, including invoice numbers, customer balances, and due dates. A consolidated billing invoice is a bill sent to a customer that contains all invoices created during a period that you define, for example, one month. When you run the Consolidated Billing Invoice program to create a consolidated billing invoice, the information about the consolidated billing invoice is stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CONS_INV_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONS_INV_ID
AR_CONS_INV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID SITE_USE_ID CUT_OFF_DATE
AR_CONS_INV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONS_BILLING_NUMBER
AR_CONS_INV_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SITE_USE_ID CUT_OFF_DATE CURRENCY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CONS_INV_ID	NUMBER	(15)	Yes	Consolidated billing invoice identifier determined by AR_CONS_INV_ALL sequence
CONS_BILLING_NUMBER	VARCHAR2	(30)	Yes	Consolidated billing invoice number
CUSTOMER_ID	NUMBER	(15)	Yes	Customer identifier
SITE_USE_ID	NUMBER	(15)	Yes	Customer bill-to site identifier
CONCURRENT_REQUEST_ID	NUMBER	(15)		Identifies concurrent request that generated consolidated billing invoice
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).
CONS_INV_TYPE	VARCHAR2	(30)	Yes	Lookup code for consolidated invoice type in AR_LOOKUPS, Summary or Detail
STATUS	VARCHAR2	(30)	Yes	Lookup code for consolidated billing invoice status in AR_LOOKUPS, Draft, Accepted, or Rejected
PRINT_STATUS	VARCHAR2	(30)	Yes	Lookup code for document print status in the AR_LOOKUPS table, Pending or Printed
TERM_ID	NUMBER	(15)		Payment terms code identifier
ISSUE_DATE	DATE		Yes	Date that consolidated billing invoice was generated
CUT_OFF_DATE	DATE			Consolidated billing invoice cut-off date
DUE_DATE	DATE			Consolidated billing invoice due date
CURRENCY_CODE	VARCHAR2	(15)		Currency code
BEGINNING_BALANCE	NUMBER			Customer balance due at beginning of period, or ending balance of prior consolidated billing invoice
ENDING_BALANCE	NUMBER			Customer balance at end of period
ORG_ID	NUMBER	(15)		Organization 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
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
START_DATE	DATE			Billing period start date for the consolidated billing invoice
BILLING_DATE	DATE			Billing date for balance forward transactions
BILL_LEVEL_FLAG	VARCHAR2	(1)		Indicates billing level: A for account, S for site
TOTAL_RECEIPTS_AMT	NUMBER			Sum of all receipts
TOTAL_ADJUSTMENTS_AMT	NUMBER			Sum of all adjustments
TOTAL_CREDITS_AMT	NUMBER			Sum of all credits
TOTAL_FINANCE_CHARGES_AMT	NUMBER			Sum of all finance charges
TOTAL_TRX_AMT	NUMBER			Sum of all transactions
TOTAL_TAX_AMT	NUMBER			Sum of all tax
UNPAID_REASON	VARCHAR2	(30)		Reason why bill is not paid
AGING_BUCKET1_AMT	NUMBER			Aging amount
AGING_BUCKET2_AMT	NUMBER			Aging amount
AGING_BUCKET3_AMT	NUMBER			Aging amount
AGING_BUCKET4_AMT	NUMBER			Aging amount
AGING_BUCKET5_AMT	NUMBER			Aging amount
AGING_BUCKET6_AMT	NUMBER			Aging amount
AGING_BUCKET7_AMT	NUMBER			Aging amount
LAST_BILLING_DATE	DATE			Previous billing date for balance forward
BILLING_CYCLE_ID	NUMBER	(15)		Billing cycle identifier
REMIT_TO_ADDRESS_ID	NUMBER	(15)		Remit-to address identifier
LAST_CHARGE_DATE	DATE			Last Date on which late charge was computed on this bill

Query Text

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


SELECT CONS_INV_ID
,      CONS_BILLING_NUMBER
,      CUSTOMER_ID
,      SITE_USE_ID
,      CONCURRENT_REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONS_INV_TYPE
,      STATUS
,      PRINT_STATUS
,      TERM_ID
,      ISSUE_DATE
,      CUT_OFF_DATE
,      DUE_DATE
,      CURRENCY_CODE
,      BEGINNING_BALANCE
,      ENDING_BALANCE
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      START_DATE
,      BILLING_DATE
,      BILL_LEVEL_FLAG
,      TOTAL_RECEIPTS_AMT
,      TOTAL_ADJUSTMENTS_AMT
,      TOTAL_CREDITS_AMT
,      TOTAL_FINANCE_CHARGES_AMT
,      TOTAL_TRX_AMT
,      TOTAL_TAX_AMT
,      UNPAID_REASON
,      AGING_BUCKET1_AMT
,      AGING_BUCKET2_AMT
,      AGING_BUCKET3_AMT
,      AGING_BUCKET4_AMT
,      AGING_BUCKET5_AMT
,      AGING_BUCKET6_AMT
,      AGING_BUCKET7_AMT
,      LAST_BILLING_DATE
,      BILLING_CYCLE_ID
,      REMIT_TO_ADDRESS_ID
,      LAST_CHARGE_DATE
FROM AR.AR_CONS_INV_ALL;

Dependencies

[top of page]

AR.AR_CONS_INV_ALL does not reference any database object

AR.AR_CONS_INV_ALL is referenced by following:

AR: AR_CONS_INV_ALL#