[Home] [Help] [Dependency Information]
Object Name: | OZF_CUST_DAILY_FACTS# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_DAILY_FACT_ID | NUMBER | Yes | ||
REPORT_DATE | DATE | |||
CUST_ACCOUNT_ID | NUMBER | |||
SHIP_TO_SITE_USE_ID | NUMBER | |||
BILL_TO_SITE_USE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
PRODUCT_ATTRIBUTE | VARCHAR2 | (30) | ||
PRODUCT_ATTR_VALUE | VARCHAR2 | (240) | ||
PTD_SALES | NUMBER | |||
QTD_SALES | NUMBER | |||
YTD_SALES | NUMBER | |||
LYSP_SALES | NUMBER | |||
LYTD_SALES | NUMBER | |||
PAST_DUE_ORDER_QTY | NUMBER | |||
CURRENT_PERIOD_ORDER_QTY | NUMBER | |||
BACKORDERED_QTY | NUMBER | |||
BOOKED_FOR_FUTURE_QTY | NUMBER | |||
CURRENT_PERIOD_TARGET | NUMBER | |||
CURRENT_QTR_TARGET | NUMBER | |||
CURRENT_YEAR_TARGET | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LYSQ_SALES | NUMBER | |||
LY_SALES | NUMBER | |||
LPTD_SALES | NUMBER | |||
LQTD_SALES | NUMBER | |||
YTD_FUND_UTILIZED | NUMBER | |||
YTD_FUND_EARNED | NUMBER | |||
YTD_FUND_PAID | NUMBER | |||
QTD_FUND_UTILIZED | NUMBER | |||
QTD_FUND_EARNED | NUMBER | |||
QTD_FUND_PAID | NUMBER | |||
MTD_FUND_UTILIZED | NUMBER | |||
MTD_FUND_EARNED | NUMBER | |||
MTD_FUND_PAID | NUMBER | |||
FUND_UNPAID | NUMBER | |||
OPEN_CLAIMS | NUMBER | |||
MTD_BASESALES | NUMBER | |||
QTD_BASESALES | NUMBER | |||
YTD_BASESALES | NUMBER |
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#;
|
|
|