VIEW: OZF.OZF_CUST_DAILY_FACTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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