| Table | Queue | Reports |
| REF_CUST_ACTION_LGCY_CD | SETUP | Aged Open AR.bqy, All Orders by Status.bqy, Closed AR History.bqy, Merchandising Performance Analysis.bqy, P and H Overrides.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy |
| REF_CUST_STA_LGCY_CD | SETUP | Aged Open AR.bqy, All Orders by Status.bqy, Closed AR History.bqy, Merchandising Performance Analysis.bqy, P and H Overrides.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy |
| REF_CUST_TYPE_LGCY_CD | SETUP | Aged Open AR.bqy, All Orders by Status.bqy, Closed AR History.bqy, Merchandising Performance Analysis.bqy, P and H Overrides.bqy, Pending Refunds.bqy, Returns Analysis.bqy, Price Range Analysis.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy |
| REF_FOP_TYPE_LGCY_CD | SETUP | All Orders by Status.bqy, Merchandising Performance Analysis.bqy, Open Orders by Item.bqy, Orders at the Droppshipper.bqy, P and H Overrides.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| REF_ITM_STA_LGCY_CD | SETUP | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Future Orders.bqy, Inventory Receiving Analysis.bqy, Inventory Value.bqy, Item Analysis.bqy, Items Changed to Discontinued.bqy, Item Demand Analysis.bqy, Item Sales by Prod Id.bqy, Item Summary Sales.bqy, Merchandising Performance Analysis.bqy, Open Orders by Item.bqy, Orders at the Dropshipper.bqy, Receiving Staffing Requirements.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, |
| REF_MAJ_CAT_LGCY_CD | SETUP | All Orders by Status.bqy, Inventory Value.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| REF_MIN_CAT_LGCY_CD | SETUP | All Orders by Status.bqy, Inventory Value.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| REF_ORD_ITM_HP_LGCY_CD | SETUP | Top X Customers.bqy |
| REF_ORD_ITM_POR_LGCY_CD | SETUP | All Orders by Status.bqy, Price Overrides.bqy, Top X Customers.bqy |
| REF_ORD_ITM_STA_LGCY_CD | SETUP | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Back Orders.bqy, Item Demand Analysis.bqy, Open RAs.bqy, Merchandising Performance Analysis.bqy, Pick Velocity.bqy, Price Overrides.bqy, Price Range Analysis.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy |
| REF_ORD_SUB_STA_LGCY_CD | SETUP | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Price Overrides.bqy, Top X Customers.bqy |
| REF_PURCH_ORD_REAS_LGCY_CD | SETUP | Receiving staffing requirements.bqy, Vendor Performance Analysis.bqy |
| REF_RTN_REAS_LGCY_CD | SETUP | Open RAs.bqy, Sales Versus Returns Analysis.bqy, Vendor Returns Analysis.bqy |
| REF_SHIP_METH_LGCY_CD | SETUP | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Pick Velocity.bqy, Receiving Staffing Requirements.bqy, Unshipped Orders by Status.bqy, Vendor Performance Analysis.bqy |
| REF_SHIP_TO_LGCY_CD | SETUP | Receiving staffing requirements.bqy, Vendor Performance Analysis.bqy |
| REF_SUB_MAJ_CAT_LGCY_CD | SETUP | All Orders by Status.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bq, Top X Customers.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| REF_SUB_MIN_CAT_LGCY_CD | SETUP | All Orders by Status.bqy, Inventory Value.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| REF_UNIT_OF_MEAS_LGCY_CD | SETUP | Receiving staffing requirements.bqy |
| SV_MACITM_COMP_DIV_MASTER | SETUP | Aged Open AR.bqy, Aged orders in the warehouse.bqy, Back Orders.bqy, Back Orders by Vendor and Buyer.bqy, Closed AR History.bqy, Expected Weekly PO Receipts.bqy, Future Orders.bqy, GL Trans.bqy, Inventory Adjustments.bqy, Inventory Value.bqy, Inventory Receiving Analysis.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Items Changed to Discontinued.bqy, Item Sales by Prod Id.bqy, Item Summary Sales.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Offer PNL.bqy, Open Orders by Item.bqy, Open Purchase Orders.bqy, Open RAs.bqy, Orders at the Dropshipper.bqy, Orders in the Warehouse.bqy, P and H Overrides.bqy, Pending Refunds.bqy, Pick Velocity.bqy, Price Range Analysis.bqy, Receiving Staffing Requirements.bqy, Repeat Buyer Analysis.bqy, RFM Analysis.bqy, Sales by Product ID.bqy, Sales Revenue Per Catalog Mailed.bqy, Sales Revenue Per Page.bqy, Sales versus Returns Analysis.bqy, Shipping Charge Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| SV_MACITM_STYLE_HEADER | SETUP | Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Price Range Analysis.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACITM_VEND_ORD_FROM | SETUP | Expected Weekly PO Receipts.bqy, Inventory Receiving Analysis.bqy, Item Demand Analysis.bqy, Open Purchase Orders.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| SV_MACITM_VEND_ORD_TEL | SETUP | Vendor Performance Analysis.bqy, Inventory Receiving Analysis.bqy |
| SV_MACITM_WHSE_LOCS | SETUP | Pick Velocity.bqy, Receiving Staffing Requirements.bqy |
| SV_MACACT_MACS_ACCOUNTS_DTL | SETUP | GL Trans.bqy |
| SV_MACITM_ITEM_MAST | ITEM | Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Back Orders by Vendor and Buyer.bqy, Back Brders.bqy, Expected Weekly PO Receipts.bqy, Forecast to Buy.bqy, Future Orders.bqy, Inventory Adjustments.bqy, Inventory Receiving Analysis.bqy, Inventory Value.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Item Summary Sales.bqy, Items Changed to Discontinued.bqy, Item Sales by Prod Id.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Obsolete Inventory.bqy, Open Orders by Item.bqy, Open Purchase Orders.bqy, Open RAs.bqy, Orders at the Dropshipper.bqy, Pick Velocity.bqy, Price Overrides.bqy, Price Range Analysis.bqy, Receiving Staffing Requirements.bqy, Returns Analysis.bqy, RFM Analysis.bqy, Sales by Product ID.bqy, Sales versus Return Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Unshipped Orders by Status.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy, |
| SV_MACITM_ITEM_MAST_WH | ITEM | Item Analysis.bqy, Receiving staffing requirements.bqy |
| SV_MACITM_VENDOR_ITEMS | ITEM | Back Orders by Vendor and Buyer.bqy, Expected Weekly PO Receipts.bqy, Forecast to Buy.bqy, Inventory Adjustments.bqy, Inventory Value.bqy, Inventory Receiving Analysis.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Open Purchase Orders.bqy, Receiving Staffing Requirements.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| SV_MACITM_STYLE_ITEM_DATA | ITEM | Net Product Sales Analysis.bqy, Sales by Product ID.bqy |
| SV_MACITM_SOURCES | OFFER | Avg Orders Items and Dollars by Source.bqy, Offer PNL.bqy, RFM Analysis.bqy |
| SV_MACITM_SOURCES_FOP_TOT | OFFER | Avg Orders Items and Dollars by Source.bqy, Offer PNL.bqy |
| SV_MACITM_OFFERS | OFFER | Avg Orders Items and Dollars by Source.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Obsolete Inventory.bqy, Offer PNL,bqy, Price Range Analysis.bqy, RFM Analysis.bqy, Sales Revenue Per Catalog Mailed.bqy, Sales Revenue Per Page.bqy, Spread Performance Analysis.bqy |
| SV_MACITM_OFFER_ITEMS | OFFER | Forecast to Buy.bqy, Merchandise Performance Analysis.bqy, Obsolete Inventory.bqy, Price Overrides.bqy, RFM Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_CUSTOMERS | CUST | Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Back Orders by Vendor and Buyer.bqy, Back Orders.bqy, Closed AR History.bqy, Future Orders.bqy, Item Sales by Prod Id.bqy, Item Summary Sales.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Open Orders by Item.bqy, Open RAs.bqy, Orders at the Dropshipper.bqy, Orders in the Warehouse.bqy, Pending Refunds.bqy, Price Overrides.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Return Analysis.bqy, RFM Analysis.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_CUSTOMER_COMP | CUST | Aged Open AR.bqy, LTV Analysis.bqy, Repeat Buyer Analysis.bqy, Top x Customers.bqy |
| SV_MACORD_CUSTOMER_ADDL | CUST | Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Closed AR History.bqy, Future Orders.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Open RAs.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_CUST_TEL | CUST | Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Closed AR History.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Spread Performance Analysis.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_CREDIT_APPROVAL | CUST | Aged Open AR.bqy, Closed AR History.bqy |
| SV_MACORD_CUST_EMAIL | CSTX | Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Closed AR History.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Spread Performance Analysis.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_PROCESS_ORDER | ORD | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Back Orders by Vendor and Buyer.bqy, Future Orders.bqy, Open Orders by Item.bqy, Orders at the Dropshipper.bqy, Orders in the Warehouse.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_PROCESS_REFUND | ORD | Pending Refunds.bqy |
| SV_MACORD_ORDER_HEADER | ORD | Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Back Orders.bqy, Forecast to Buy.bqy, Future Orders.bqy, Item Demand Analysis.bqy, Item Sales by Prod Id.bqy, Item Summary Sales.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Obsolete Inventory.bqy, Offer PNL.bqy, Open Orders by Item.bqy, Open RAs.bqy, Orders at the Dropshipper.bqy, Orders in the Warehouse.bqy, P and H Overrides.bqy, Price Overrides.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Returns Analysis.bqy, RFM Analysis.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_SALES_ORD_LINES | ORD | Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Back Orders by Vendor and Buyer.bqy, Back Orders.bqy, Forecast to Buy.bqy, Future Orders.bqy, Item Demand Analysis.bqy, Item Sales by Prod Id.bqy, Item Sales Summary.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Obsolete Inventory.bqy, Open Orders by Item.bqy, Orders at the Dropshipper.bqy, Orders in the Warehouse.bqy, Price Overrides.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, RFM Analysis.bqy, Returns analysis.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Unshipped Orders by Status.bqy |
| SV_MACORD_CLOSED_AR | ORD | Closed AR History.bqy |
| SV_MACORD_OPEN_AR | ORD | Aged Open AR.bqy |
| SV_MACORD_OA_ORD_OTH | OA | Aged orders in the warehouse.bqy, Future Orders.bqy, P and H overrides.bqy |
| SV_MACORD_BACK_ORDER | ORDO | Back orders by vendor and buyer.bqy, Back orders.bqy, Item Demand Analysis.bqy |
| SV_MACORD_RETURNS | ORDO | Item Demand Analysis.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Open RAs.bqy, Returns Analysis.bqy, Sales versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| SV_MACORD_PROC_RETURN | ORDO | Item Demand Analysis.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Returns Analysis.bqy, Sales versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| SV_MACORD_RETURN_AUTH | ORDO | Open RAs.bqy |
| SV_MACMAN_MANIFEST_ENTRIES | ORDO | Shipping charge analysis.bqy |
| SV_MACMAN_MANI_PKG_SHIP | ORDO | Shipping charge analysis.bqy |
| SV_MACMAN_FEDEX_ENTRIES | ORDO | Shipping charge analysis.bqy |
| SV_MACMAN_FED_PKG_SHIP | ORDO | Shipping charge analysis.bqy |
| SV_MACMAN_AIRBOURNE_ENTRIES | ORDO | Shipping charge analysis.bqy |
| SV_MACMAN_AIRBOURNE_PKG_SHIP | ORDO | Shipping charge analysis.bqy |
| SV_MACITM_PICK_LOT_HEADER | ORDO | Pick Velocity.bqy |
| SV_MACITM_PICK_LOT_DETAIL | ORDO | Pick Velocity.bqy |
| SV_MACITM_PICK_LOT_DET_WH | ORDO | Pick Velocity.bqy |
| SV_MACORD_AR_COMMENTS | ORDS | Aged Open AR.bqy, Closed AR History.bqy |
| SV_MACITM_INV_DETAILS | INV | Expected Weekly PO Receipts.bqy, Forecast to buy.bqy, Inventory Value.bqy, Obsolete Inventory.bqy |
| SV_MACITM_INVENTORY_TRANS | INV | Inventory Adjustments.bqy, Inventory Receiving Analysis.bqy, Vendor Expenditures by Year and Category.bqy |
| SV_MACITM_INV_TRANS_POR | INV | Vendor Expenditures by Year and Category.bqy |
| SV_MACITM_PO_HEADER | PO | Inventory Receiving Analysis.bqy, Open Purchase Orders.bqy, Receiving Staffing Requirements.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy |
| SV_MACITM_PO_DETAILS | PO | Back Orders.bqy, Expected Weekly PO Receipts.bqy, Forecast to Buy.bqy, Open Purchase Orders.bqy, Receiving Staffing Requirements.bqy, Vendor Performance Analysis.bqy |
| SV_MACITM_PO_REC | PO | Receiving Staffing Requirements.bqy, Vendor Performance Analysis.bqy |
| SV_MACORD_FT_CUST | FIN | GL Trans.bqy |
| SV_MACORD_FT_CUST_AMT | FIN | GL Trans.bqy |
| SV_MACORD_FT_DOC | FIN | GL Trans.bqy |
| SV_MACORD_FT_DOC_AMT | FIN | GL Trans.bqy |
| SV_MACORD_FT_INV_TRANS | FIN | GL Trans.bqy |
| SV_MACORD_FT_INV_TRANS_AMT | FIN | GL Trans.bqy |
| SV_MACORD_FT_SALES_ORD | FIN | GL Trans.bqy, P and H Overrides.bqy |
| SV_MACORD_FT_SALES_ORD_AMT | FIN | GL Trans.bqy, P and H Overrides.bqy |
| SV_MACORD_FT_SHIP | FIN | GL Trans.bqy, Shipping Charge Analysis.bqy |
| SV_MACORD_FT_SHIP_AMT | FIN | GL Trans.bqy, Net Product Sales Analysis.bqy, Shipping Charge Analysis.bqy |
| SV_MACORD_FT_SHIP_TO | FIN | GL Trans.bqy |
| SV_MACORD_FT_SHIP_TO_AMT | FIN | GL Trans.bqy |
| SV_MACITM_MACS_SNAPSHOT | SUM | Current Snapshot Analysis.bqy, This Year to Last Year Snapshot Analysis.bqy |
| REF_PERIOD_TABLE | Current Snapshot Analysis.bqy, GL Trans.bqy, Item Demand Analysis.bqy, Item Sales by Prod Id.bqy, Item Summary Sales.bqy, LTV Analysis.bqy, Merchandise Performance Analysis.bqy, Net Product Sales Analysis.bqy, Price Range Analysis.bqy, Sales by Product ID.bqy, Spread Performance Analysis.bqy, This Year to Last Year Snapshot Analysis.bqy | |
| REF_PROCESS_ACTION_SEARCH | All Orders by Status.bqy, Open Orders by Item.bqy, Pending Refunds.bqy | |
| REF_ORD_ITM_TYPE_LGCY_CD | All Orders by Status.bqy, Merchandising Performance Analysis.bqy, Pick Velocity.bqy, Price Overrides.bqy, Sales Versus Returns Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy | |
| PROMOTION_HISTORY.xls | LTV Analysis.bqy |