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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CONS_INV_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONS_INV_ID
AR_CONS_INV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_ID
ColumnSITE_USE_ID
ColumnCUT_OFF_DATE
AR_CONS_INV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONS_BILLING_NUMBER
AR_CONS_INV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_USE_ID
ColumnCUT_OFF_DATE
ColumnCURRENCY_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:

SchemaAPPS
SynonymAR_CONS_INV
SynonymAR_CONS_INV_ALL