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

TABLE: OZF.OZF_CUST_DAILY_FACTS

Object Details
Object Name: OZF_CUST_DAILY_FACTS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_CUST_DAILY_FACTS
Subobject Name:
Status: VALID


This table stores the Accounts and products information required by the Account Manager Dashboard.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_CUST_DAILY_FACTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_DAILY_FACT_ID
OZF_CUST_DAILY_FACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_DATE
ColumnSHIP_TO_SITE_USE_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
CUST_DAILY_FACT_ID NUMBER
Yes Unique Identifier
REPORT_DATE DATE

Date on which the Table is populated
CUST_ACCOUNT_ID NUMBER

Customer Account Identifier
SHIP_TO_SITE_USE_ID NUMBER

Site use id of the Ship To Site
BILL_TO_SITE_USE_ID NUMBER

Site use identifier of the bill to site
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
PRODUCT_ATTRIBUTE VARCHAR2 (30)
Product Attribute. Valid values are PRICING_ATTRIBUTE1 for Inventory Item and PRICING_ATTRIBIUTE2 for a category
PRODUCT_ATTR_VALUE VARCHAR2 (240)
Unique identifier of the Product Attribute
PTD_SALES NUMBER

Period To Date Sales
QTD_SALES NUMBER

Quarter to date sales
YTD_SALES NUMBER

Year to date sales
LYSP_SALES NUMBER

Last Year Same Period Sales
LYTD_SALES NUMBER

Last Year to date sales
PAST_DUE_ORDER_QTY NUMBER

Past Due Orders
CURRENT_PERIOD_ORDER_QTY NUMBER

Current period orders
BACKORDERED_QTY NUMBER

Backordered Quantity
BOOKED_FOR_FUTURE_QTY NUMBER

Order Booked for future
CURRENT_PERIOD_TARGET NUMBER

Current Period's Target
CURRENT_QTR_TARGET NUMBER

Current Quarter's target
CURRENT_YEAR_TARGET NUMBER

Current year's target
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
LYSQ_SALES NUMBER

Last Year Same Quarter Sales
LY_SALES NUMBER

Last Year Sales.
LPTD_SALES NUMBER

Last Period To Date Sales
LQTD_SALES NUMBER

Last Quarter to date sales
YTD_FUND_UTILIZED NUMBER

Year to Date Fund Utilized
YTD_FUND_EARNED NUMBER

Year to Date Fund Earned
YTD_FUND_PAID NUMBER

Year to Date Fund Paid
QTD_FUND_UTILIZED NUMBER

Quarter to Date Fund Utilized
QTD_FUND_EARNED NUMBER

Quarter to Date Fund Earned
QTD_FUND_PAID NUMBER

Quarter to Date Fund Paid
MTD_FUND_UTILIZED NUMBER

Month to Date Fund Utilized
MTD_FUND_EARNED NUMBER

Month to Date Fund Earned
MTD_FUND_PAID NUMBER

Month to Date Fund Paid
FUND_UNPAID NUMBER

Fund Unpaid
OPEN_CLAIMS NUMBER

Open Claims
MTD_BASESALES NUMBER

Month to Date Basesales
QTD_BASESALES NUMBER

Quarter to Date Basesales
YTD_BASESALES NUMBER

Year to Date Basesales
Query Text

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


SELECT CUST_DAILY_FACT_ID
,      REPORT_DATE
,      CUST_ACCOUNT_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PTD_SALES
,      QTD_SALES
,      YTD_SALES
,      LYSP_SALES
,      LYTD_SALES
,      PAST_DUE_ORDER_QTY
,      CURRENT_PERIOD_ORDER_QTY
,      BACKORDERED_QTY
,      BOOKED_FOR_FUTURE_QTY
,      CURRENT_PERIOD_TARGET
,      CURRENT_QTR_TARGET
,      CURRENT_YEAR_TARGET
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LYSQ_SALES
,      LY_SALES
,      LPTD_SALES
,      LQTD_SALES
,      YTD_FUND_UTILIZED
,      YTD_FUND_EARNED
,      YTD_FUND_PAID
,      QTD_FUND_UTILIZED
,      QTD_FUND_EARNED
,      QTD_FUND_PAID
,      MTD_FUND_UTILIZED
,      MTD_FUND_EARNED
,      MTD_FUND_PAID
,      FUND_UNPAID
,      OPEN_CLAIMS
,      MTD_BASESALES
,      QTD_BASESALES
,      YTD_BASESALES
FROM OZF.OZF_CUST_DAILY_FACTS;

Dependencies

[top of page]

OZF.OZF_CUST_DAILY_FACTS does not reference any database object

OZF.OZF_CUST_DAILY_FACTS is referenced by following:

SchemaOZF
ViewOZF_CUST_DAILY_FACTS#