| Table | Queue | Reports |
| SV_MACITM_COMP_DIV_MASTER | SETUP | Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Top X Customers.bqy, Repeat Buyer Analysis.bqy, RFM Analysis.bqy, Aged Open AR.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Inventory Value.bqy |
| SV_MACITM_VEND_ORD_FROM | SETUP | Open purchase orders.bqy, Expected weekly po receipts.bqy, Vendor expeditures by year and category.bqy, Vendor performance analysis.bqy, Vendor return analysis.bqy, Inventory receiving analysis.bqy |
| SV_MACITM_VEND_ORD_TEL | SETUP | Vendor performance analysis.bqy, Inventory receiving analysis.bqy |
| SV_MACITM_WHSE_LOCS | SETUP | Receiving staffing requirements.bqy, Pick velocity.bqy |
| SV_MACITM_ITEM_MAST | ITEM | Back orders by vendor and buyer.bqy,Sales by Product ID.bqy, Sales versus Return Analysis.bqy, RFM Analysis.bqy, Forecast to Buy.bqy, Back orders.bqy, Future Orders.bqy, Item by category.bqy, Obsolete Inventory.bqy, Open order by item.bqy, Open purchase orders.bqy, Orders at the dropshipper.bqy, Price overrides.bqy, Expected Weekly PO Receipts.bqy, Receiving staff requirements.bqy, Vendor expenditures by year and category.bqy, Vendor performance analysis.bqy, Vendor return analysis.bqy, Inventory Adjustments.bqy, Inventory Receiving Analysis.bqy, Pick Velocity.bqy, Return analysis.bqy, Aged Orders in the Warehouse.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Inventory Value.bqy |
| SV_MACITM_ITEM_MAST_WH | ITEM | Item by category.bqy, Items changed to discontinued.bqy, Receiving staffing requirements.bqy |
| SV_MACITM_VENDOR_ITEMS | ITEM | Back orders by vendor and buyer.bqy, Forecast to buy.bqy, Item by category.bqy, Open purchase orders.bqy, Expected Weekly po receipts.bqy, Receiving Staffing Requirements.bqy, Vendor performance analysis.bqy, Vendor return analysis.bqy, Inventory adjustments.bqy, Inventory Value.bqy |
| SV_MACITM_STYLE_ITEM_DATA | ITEM | Sales by Product ID.bqy |
| SV_MACITM_STYLE_HEADER | ITEM | Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACITM_SOURCES | OFFER | Avg orders items and dollars by source.bqy, RFM Analysis.bqy |
| SV_MACITM_SOURCES_FOP | OFFER | Avg orders items and dollars by source.bqy |
| SV_MACITM_OFFERS | OFFER | Avg orders items and dollars by source.bqy, RFM Analysis.bqy, Obsolete Inventory.bqy, sales revenue per catalog mailed.bqy, Sales revenue per page.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACITM_OFFER_ITEMS | OFFER | RFM Analysis.bqy, Forecast to buy.bqy, Obsolete Inventory.bqy, Price overrides.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_CUSTOMERS | CUST | Aged orders in the warehouse.bqy, Back orders by vendor and buyer.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Repeat Buyer Analysis.bqy, RFM Analysis.bqy, Back orders.bqy, Future Orders.bqy, Open orders by item.bqy, Orders at the dropshipper.bqy, Orders in the warehouse.bqy, Price overrides.bqy, Return analysis.bqy, Aged Open AR.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_CUSTOMER_COMP | CUST | Top x Customers.bqy, Repeat Buyer Analysis.bqy, Open orders by Item.bqy, Aged Open AR.bqy |
| SV_MACORD_CUSTOMER_ADDL | CUST | Top x Customers.bqy, Repeat Buyer Analysis.bqy, Future Orders.bqy, Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_CUST_TEL | CUST | Repeat Buyer Analysis.bqy, Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_CREDIT_APPROVAL | CUST | Aged Open AR.bqy |
| SV_MACORD_CUST_EMAIL | CSTX | Repeat Buyer Analysis.bqy, Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_PROCESS_ORDER | ORD | Aged orders in the warehouse.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 |
| SV_MACORD_ORDER_HEADER | ORD | Aged orders in the warehouse.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Top X Customers.bqy, Repeat Buyer Analysis.bqy, RFM Analysis.bqy, Forecast to Buy.bqy, Back orders.bqy, Future orders.bqy, Obsolete Inventory.bqy, Open orders by item.bqy, Orders at the dropshipper.bqy, Orders in the warehouse.bqy, Price Overrides.bqy, Return Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_SALES_ORD_LINES | ORD | Aged orders in the warehouse.bqy, Back orders by vendor and buyer.bqy, Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Top X customers.bqy, Repeat Buyer Analysis.bqy, RFM Analysis.bqy, Forecast to Buy.bqy, Back orders.bqy, Future orders.bqy, Obsolete Inventory.bqy, Open orders by item.bqy, Orders at the dropshipper.bqy, Orders in the warehouse.bqy, Price overrides.bqy, Return analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_OPEN_AR | ORD | Aged Open AR.bqy |
| SV_MACORD_OA_ORD_OTH | OA | Future Orders.bqy, P and H overrides.bqy |
| SV_MACORD_BACK_ORDER | ORDO | Back orders by vendor and buyer.bqy, Back orders.bqy |
| SV_MACORD_RETURNS | ORDO | Sales versus Returns Analysis.bqy, Vendor return analysis.bqy, Return analysis.bqy, Merchandise Performance Analysis.bqy, Spread Performance Analysis.bqy |
| SV_MACORD_PROC_RETURN | ORDO | Sales versus Returns Analysis.bqy, Vendor return analysis.bqy, Return analysis.bqy, Merchandise Performance Analysis.bqy,Spread Performance Analysis.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 |
| SV_MACITM_INV_DETAILS | INV | Forecast to buy.bqy, Obsolete Inventory.bqy, Inventory Value.bqy |
| SV_MACITM_INVENTORY_TRANS | INV | Vendor expeditures by year and category.bqy, Inventory adjustments.bqy, Inventory receiving analysis.bqy |
| SV_MACITM_INV_TRANS_POR | INV | Vendor expeditures by year and category.bqy |
| SV_MACITM_PO_HEADER | PO | Open purchase orders.bqy, Receiving Staffing Requirements.bqy, Vendor expeditures by year and category.bqy, Vendor performance analysis.bqy, Inventory receiving analysis.bqy |
| SV_MACITM_PO_DETAILS | PO | Back orders.bqy, Forecast to buy.bqy, Open purchase orders.bqy, Expected weekly po receipts.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_SHIP | FIN | Shipping charge analysis.bqy |
| SV_MACORD_FT_SHIP_AMT | FIN | Shipping charge analysis.bqy |
| SV_MACORD_FT_SALES_ORD | FIN | P and H Overrides.bqy |
| SV_MACORD_FT_SALES_ORD_AMT | FIN | P and H Overrides.bqy |
| REF_PERIOD_TABLE | Sales by Product ID.bqy, Price overrides.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy | |
| REF_PROCESS_ACTION_SEARCH | Open Orders by item.bqy | |
| REF_MAJ_CAT_LGCY_CD | SETUP | Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| REF_SUB_MAJ_CAT_LGCY_CD | SETUP | Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| REF_MIN_CAT_LGCY_CD | SETUP | Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |
| REF_SUB_MIN_CAT_LGCY_CD | SETUP | Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy |