| 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, Pending Refunds.bqy, Closed AR History.bqy, Offer PNL.bqy, GL Trans.bqy |
| SV_MACITM_STYLE_HEADER | SETUP | Sales by Product ID.bqy, Sales versus Returns Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.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 |
| 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 |
| REF_ORD_ITM_STA_LGCY_CD | SETUP | Open RAs.bqy |
| REF_RTN_REAS_LGCY_CD | SETUP | Open RAs.bqy |
| REF_CUST_STA_LGCY_CD | SETUP | Pending Refunds.bqy |
| REF_CUST_TYPE_LGCY_CD | SETUP | Pending Refunds.bqy |
| REF_CUST_ACTION_LGCY_CD | SETUP | Pending Refunds.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, Open RAs.bqy, Un-Shipped Orders by Status.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_SOURCES | OFFER | Avg orders items and dollars by source.bqy, RFM Analysis.bqy, Offer PNL.bqy |
| SV_MACITM_SOURCES_FOP | OFFER | Avg orders items and dollars by source.bqy, Offer PNL.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, Offer PNL,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, Open RAs.bqy, Pending Refunds.bqy, Closed AR History.bqy, Un-Shipped Orders by Status.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, Open RAs.bqy, Pending Refunds.bqy, Closed AR History.bqy, Un-Shipped Orders by Status.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, Pending Refunds.bqy, Closed AR History.bqy, Un-Shipped Orders by Status.bqy |
| SV_MACORD_CREDIT_APPROVAL | CUST | Aged Open AR.bqy, Closed AR History.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, Pending Refunds.bqy, Closed AR History.bqy, Un-Shipped Orders by Status.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, Un-Shipped Orders by Status.bqy |
| SV_MACORD_PROCESS_REFUND | ORD | Pending Refunds.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, Open RAs.bqy, Offer PNL.bqy, Un-Shipped Orders by Status.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, Un-Shipped 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 | 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, Open RAs.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_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 | 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_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 | P and H Overrides.bqy, GL Trans.bqy |
| SV_MACORD_FT_SALES_ORD_AMT | FIN | P and H Overrides.bqy, GL Trans.bqy |
| SV_MACORD_FT_SHIP | FIN | Shipping charge analysis.bqy, GL Trans.bqy |
| SV_MACORD_FT_SHIP_AMT | FIN | Shipping charge analysis.bqy, GL Trans.bqy |
| SV_MACORD_FT_SHIP_TO | FIN | GL Trans.bqy |
| SV_MACORD_FT_SHIP_TO_AMT | FIN | GL Trans.bqy |
| SV_MACACT_MACS_ACCOUNTS_DTL | FIN | GL Trans.bqy |
| REF_PERIOD_TABLE | Sales by Product ID.bqy, Price overrides.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, GL Trans.bqy | |
| REF_PROCESS_ACTION_SEARCH | Open Orders by item.bqy, Pending Refunds.bqy, Un-Shipped Orders by Status.bqy |