[Home] [Help] [Dependency Information]
Object Name: | FII_AR_REVENUE_B_V2 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FII_AR_REVENUE_B_V2 |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (10) | Set of Books identifier | |
COMPANY_COST_CENTER_ORG_ID | NUMBER | (15) | No longer used - Cost Center Org identifier | |
FIN_CATEGORY_ID | NUMBER | (15) | Financial Category Identifier | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Key flexfield structure defining column | |
BILL_TO_PARTY_ID | NUMBER | Bill to customer identifier | ||
INVOICE_NUMBER | VARCHAR2 | (30) | Invoice number. Populated only for revenue billed through the receivable system | |
INVOICE_DATE | DATE | Invoice Date | ||
GL_DATE | DATE | General ledger date | ||
ACTUAL_G | NUMBER | Revenue amount in secondary global currency | ||
POSTED_FLAG | VARCHAR2 | (1) | Indicate if the revenue has been posted to the general ledger | |
COMPANY_ID | NUMBER | (15) | Company Identifier | |
COST_CENTER_ID | NUMBER | (15) | Cost Center Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, COMPANY_COST_CENTER_ORG_ID
, FIN_CATEGORY_ID
, CHART_OF_ACCOUNTS_ID
, BILL_TO_PARTY_ID
, INVOICE_NUMBER
, INVOICE_DATE
, GL_DATE
, ACTUAL_G
, POSTED_FLAG
, COMPANY_ID
, COST_CENTER_ID
FROM APPS.FII_AR_REVENUE_B_V2;
APPS.FII_AR_REVENUE_B_V2 is not referenced by any database object
|
|
|