[Home] [Help] [Dependency Information]
Object Name: | FII_AR_REVENUE_STG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_REVENUE_STG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REVENUE_PK | VARCHAR2 | (80) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (10) | No longer used. | |
OPERATING_UNIT_ID | NUMBER | (15) | ||
PROD_CATEGORY_ID | NUMBER | |||
COMPANY_COST_CENTER_ORG_ID | NUMBER | (15) | No longer used | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | |||
INVOICE_ID | NUMBER | |||
INVOICE_LINE_ID | NUMBER | |||
TOP_MODEL_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ORDER_LINE_ID | NUMBER | |||
BILL_TO_PARTY_ID | NUMBER | |||
GL_DATE_ID | NUMBER | Yes | ||
GL_DATE | DATE | Yes | ||
SALES_CHANNEL | VARCHAR2 | (30) | ||
INVOICE_NUMBER | VARCHAR2 | (30) | Yes | |
ORDER_NUMBER | VARCHAR2 | (30) | ||
TRANSACTION_CLASS | VARCHAR2 | (3) | ||
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Yes | |
TRANSACTION_CURRENCY | VARCHAR2 | (15) | Yes | |
AMOUNT_T | NUMBER | |||
AMOUNT_B | NUMBER | |||
POSTED_FLAG | VARCHAR2 | (1) | Yes | |
EXCHANGE_DATE | DATE | |||
PRIM_CONVERSION_RATE | NUMBER | |||
SEC_CONVERSION_RATE | NUMBER | |||
INVOICE_DATE | DATE | Invoice Date | ||
FIN_CATEGORY_ID | NUMBER | (15) | Financial Category Identifier | |
COMPANY_ID | NUMBER | (15) | Company Identifier | |
COST_CENTER_ID | NUMBER | (15) | Cost Center Identifier | |
FIN_CAT_TYPE_CODE | VARCHAR2 | (30) | Financial Category Type Code | |
ITEM_ORGANIZATION_ID | NUMBER | (15) | Item Organization ID | |
OM_PRODUCT_REVENUE_FLAG | VARCHAR2 | (1) | OM product revenue flag | |
REV_BOOKED_DATE | DATE | Revenue Booked Date | ||
CHILD_ORDER_LINE_ID | VARCHAR2 | (30) | Child Order Line Identifier | |
LEDGER_ID | NUMBER | (10) | Ledger Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT REVENUE_PK
, SET_OF_BOOKS_ID
, OPERATING_UNIT_ID
, PROD_CATEGORY_ID
, COMPANY_COST_CENTER_ORG_ID
, CHART_OF_ACCOUNTS_ID
, ORGANIZATION_ID
, INVOICE_ID
, INVOICE_LINE_ID
, TOP_MODEL_ITEM_ID
, INVENTORY_ITEM_ID
, ORDER_LINE_ID
, BILL_TO_PARTY_ID
, GL_DATE_ID
, GL_DATE
, SALES_CHANNEL
, INVOICE_NUMBER
, ORDER_NUMBER
, TRANSACTION_CLASS
, FUNCTIONAL_CURRENCY
, TRANSACTION_CURRENCY
, AMOUNT_T
, AMOUNT_B
, POSTED_FLAG
, EXCHANGE_DATE
, PRIM_CONVERSION_RATE
, SEC_CONVERSION_RATE
, INVOICE_DATE
, FIN_CATEGORY_ID
, COMPANY_ID
, COST_CENTER_ID
, FIN_CAT_TYPE_CODE
, ITEM_ORGANIZATION_ID
, OM_PRODUCT_REVENUE_FLAG
, REV_BOOKED_DATE
, CHILD_ORDER_LINE_ID
, LEDGER_ID
FROM FII.FII_AR_REVENUE_STG;
FII.FII_AR_REVENUE_STG does not reference any database object
FII.FII_AR_REVENUE_STG is referenced by following:
|
|
|