Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: FII.FII_AR_REVENUE_F_DLOG

Object Details
Object Name: FII_AR_REVENUE_F_DLOG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AR_REVENUE_F_DLOG
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PROD_LINE_QTY_INVOICED NUMBER

Product line invoiced quantity
PROD_LINE_QTY_CREDITED NUMBER

Product line credited quantity
PROD_AMT_T NUMBER

Product amount of this record in the foreign currency
PROD_AMT_G NUMBER

Product amount of this record in the warehouse global currency
PROD_AMT_B NUMBER

Product amount of this record in the functional currency
SOLD_TO_CUSTOMER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
SHIP_TO_CUSTOMER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
BILL_TO_CUSTOMER_FK_KEY NUMBER

System generated foreign key to Trading Partner dimension
GL_PERIOD_FK_KEY NUMBER

System generated foreign key to Time dimension
SIC_CODE_FK_KEY NUMBER

System generated foreign key to Standard Industry Code dimension
REVENUE_SOURCE_FK_KEY NUMBER

System generated foreign key to Consolidated Revenue Sourcer dimension
PROJECT_FK_KEY NUMBER

System generated foreign key to Project dimension
ORGANIZATION_FK_KEY NUMBER

System generated foreign key to Internal Organization dimension
UOM_FK_KEY NUMBER

System generated foreign key to Unit of Measure dimension
PARENT_ITEM_FK_KEY NUMBER

System generated foreign key to Item dimension
ITEM_FK_KEY NUMBER

System generated foreign key to Item dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key to Instance dimension
SALESREP_FK_KEY NUMBER

System generated foreign key to Person dimension
GL_ACCT9_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT8_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT7_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT6_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT5_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT4_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT3_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT2_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT1_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_ACCT10_FK_KEY NUMBER

Foreign key to Accounting Flexfield Dimension
GL_SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to Set of Books dimension
SHIP_TO_SITE_FK_KEY NUMBER

System generated foreign key to Geography dimension
BILL_TO_SITE_FK_KEY NUMBER

System generated foreign key to Geography dimension
TRX_CURRENCY_FK_KEY NUMBER

System generated foreign key to Currency dimension
BASE_CURRENCY_FK_KEY NUMBER

System generated foreign key to Currency dimension
SALESCHANNEL_FK_KEY NUMBER

System generated foreign key to Sales Channel dimension
OFFER_INIT_FK_KEY NUMBER

System generated foreign key to Offer dimension
OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to Offer dimension
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to Market Segment dimension
MEDIA_INIT_FK_KEY NUMBER

System generated foreign key to Media Channel dimension
MEDIA_ACTL_FK_KEY NUMBER

System generated foreign key to Media Channel dimension
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to Source List dimension
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to Event dimension
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to Event dimension
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to Event dimension
CELL_INIT_FK_KEY NUMBER

System generated foreign key to Target Segment dimension
CELL_ACTL_FK_KEY NUMBER

System generated foreign key to Target Segment dimension
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to Campaign dimension
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to Campaign dimension
AR_TRX_TYPE_FK_KEY NUMBER

System generated foreign key to Receivables Transaction Type dimension
AR_DOC_NUM_FK_KEY NUMBER

System generated foreign key to Receivables Document Number dimension
PAYMENT_TERM_FK_KEY NUMBER

System generated foreign key to Payment Terms dimension
USER_MEASURE5 NUMBER

User measure identifier
USER_MEASURE4 NUMBER

User measure identifier
USER_MEASURE3 NUMBER

User measure identifier
USER_MEASURE2 NUMBER

User measure identifier
USER_MEASURE1 NUMBER

User measure identifier
USER_FK5_KEY NUMBER

System generated user defined foreign key
USER_FK4_KEY NUMBER

System generated user defined foreign key
USER_FK3_KEY NUMBER

System generated user defined foreign key
USER_FK2_KEY NUMBER

System generated user defined foreign key
USER_FK1_KEY NUMBER

System generated user defined foreign key
UNIT_STAN_PRICE NUMBER

List price per unit. Price is gross of inclusive taxes. There is no seperate gross standard price.
UNIT_SELLING_PRICE NUMBER

Selling price per unit for a transaction line
REVENUE_PK_KEY NUMBER

System generated unique identifier of the Revenue fact record
LINE_QTY_ORDERED NUMBER

Quantity ordered
LINE_QTY_INVOICED NUMBER

Quantity of invoice line
LINE_QTY_CREDITED NUMBER

Quantity credited
EXCHANGE_RATE NUMBER

Exchange rate
DOC_LINE_NUM NUMBER

Line number of the invoice
CUST_TRX_LINE_ID NUMBER

Invoice line identifier
CCID NUMBER

Account identifier
BATCH_ID NUMBER

Batch identifier
AMT_T NUMBER

Amount of thie record in the foreign currency
AMT_G NUMBER

Amount of thie record in the warehouse global currency
AMT_B NUMBER

Amount of thie record in the functional currency
AGREEMENT_ID NUMBER

Agreement identifier
PRIM_SALESREP_FK_KEY NUMBER

System generated key for Primary Sales Representative
SOLD_TO_SITE_FK_KEY VARCHAR2 (240)
System generated foreign key to Geography dimension
USER_ATTRIBUTE9 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE8 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE7 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE6 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE15 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE14 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE13 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE12 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE11 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE10 VARCHAR2 (240)
User attribute value
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute value
TRX_NUMBER VARCHAR2 (40)
Transaction number
REVENUE_PK VARCHAR2 (120)
Revenue identifier
REASON_CODE VARCHAR2 (40)
Reason Code identifier
ORDER_NUMBER VARCHAR2 (40)
Sales Order number
ORDER_LINE_ID VARCHAR2 (40)
Sales Order line
LINE_TYPE VARCHAR2 (40)
Receivables lookup code for STD_LINE_TYPE
JE_NAME VARCHAR2 (120)
Journal entry header name
JE_LINE_DESC VARCHAR2 (240)
Journal entry line description
JE_DESCRIPTION VARCHAR2 (240)
Journal entry description
INV_COMMENT VARCHAR2 (240)
Not currently used
INSTANCE VARCHAR2 (40)
Instance identifier
EX_RATE_TYPE VARCHAR2 (40)
Exchange rate type
EDI_PROC_FLAG VARCHAR2 (20)
Indicates whether this invoice was processed by EDI (Y or N)
DOC_REASON_CODE VARCHAR2 (40)
Reason code identifier
CREATED_FROM VARCHAR2 (30)
This column indicates where this record was created. It could have values like RAXTRX (AutoInvoice), RAXMATRX (Transactions window), ARXMAECM (Credit Memos window), EARLY_REL10 (pre-product version of r10), FORM_REL9 (r9form) etc..
AGREEMENT_TYPE VARCHAR2 (40)
Code used to groiup agreements for reporting
ACCOUNT_CLASS VARCHAR2 (40)
Account type
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
INVOICE_DATE DATE

Invoice date
GL_POSTED_DATE DATE

Date posted
EXCHANGE_DATE DATE

Date of exchange rate
CREATION_DATE DATE

Standard who column - date when this row was created.
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to campaign status
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to campaign status
Query Text

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


SELECT PROD_LINE_QTY_INVOICED
,      PROD_LINE_QTY_CREDITED
,      PROD_AMT_T
,      PROD_AMT_G
,      PROD_AMT_B
,      SOLD_TO_CUSTOMER_FK_KEY
,      SHIP_TO_CUSTOMER_FK_KEY
,      BILL_TO_CUSTOMER_FK_KEY
,      GL_PERIOD_FK_KEY
,      SIC_CODE_FK_KEY
,      REVENUE_SOURCE_FK_KEY
,      PROJECT_FK_KEY
,      ORGANIZATION_FK_KEY
,      UOM_FK_KEY
,      PARENT_ITEM_FK_KEY
,      ITEM_FK_KEY
,      INSTANCE_FK_KEY
,      SALESREP_FK_KEY
,      GL_ACCT9_FK_KEY
,      GL_ACCT8_FK_KEY
,      GL_ACCT7_FK_KEY
,      GL_ACCT6_FK_KEY
,      GL_ACCT5_FK_KEY
,      GL_ACCT4_FK_KEY
,      GL_ACCT3_FK_KEY
,      GL_ACCT2_FK_KEY
,      GL_ACCT1_FK_KEY
,      GL_ACCT10_FK_KEY
,      GL_SET_OF_BOOKS_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      TRX_CURRENCY_FK_KEY
,      BASE_CURRENCY_FK_KEY
,      SALESCHANNEL_FK_KEY
,      OFFER_INIT_FK_KEY
,      OFFER_ACTL_FK_KEY
,      MARKET_SEGMENT_FK_KEY
,      MEDIA_INIT_FK_KEY
,      MEDIA_ACTL_FK_KEY
,      SOURCE_LIST_FK_KEY
,      EVENT_OFFER_INIT_FK_KEY
,      EVENT_OFFER_REG_FK_KEY
,      EVENT_OFFER_ACTL_FK_KEY
,      CELL_INIT_FK_KEY
,      CELL_ACTL_FK_KEY
,      CAMPAIGN_INIT_FK_KEY
,      CAMPAIGN_ACTL_FK_KEY
,      AR_TRX_TYPE_FK_KEY
,      AR_DOC_NUM_FK_KEY
,      PAYMENT_TERM_FK_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      UNIT_STAN_PRICE
,      UNIT_SELLING_PRICE
,      REVENUE_PK_KEY
,      LINE_QTY_ORDERED
,      LINE_QTY_INVOICED
,      LINE_QTY_CREDITED
,      EXCHANGE_RATE
,      DOC_LINE_NUM
,      CUST_TRX_LINE_ID
,      CCID
,      BATCH_ID
,      AMT_T
,      AMT_G
,      AMT_B
,      AGREEMENT_ID
,      PRIM_SALESREP_FK_KEY
,      SOLD_TO_SITE_FK_KEY
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE1
,      TRX_NUMBER
,      REVENUE_PK
,      REASON_CODE
,      ORDER_NUMBER
,      ORDER_LINE_ID
,      LINE_TYPE
,      JE_NAME
,      JE_LINE_DESC
,      JE_DESCRIPTION
,      INV_COMMENT
,      INSTANCE
,      EX_RATE_TYPE
,      EDI_PROC_FLAG
,      DOC_REASON_CODE
,      CREATED_FROM
,      AGREEMENT_TYPE
,      ACCOUNT_CLASS
,      LAST_UPDATE_DATE
,      INVOICE_DATE
,      GL_POSTED_DATE
,      EXCHANGE_DATE
,      CREATION_DATE
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      CAMPAIGN_STATUS_INIT_FK_KEY
FROM FII.FII_AR_REVENUE_F_DLOG;

Dependencies

[top of page]

FII.FII_AR_REVENUE_F_DLOG does not reference any database object

FII.FII_AR_REVENUE_F_DLOG is referenced by following:

SchemaAPPS
SynonymFII_AR_REVENUE_F_DLOG