| Table | Queue | Reports |
| REF_CUST_ACTION_LGCY_CD | SETUP | All Orders by Status.bqy, Closed AR History.bqy, Merchandising Performance Analysis.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy |
| REF_CUST_STA_LGCY_CD | SETUP | All Orders by Status.bqy, Closed AR History.bqy, Merchandising Performance Analysis.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy |
| REF_CUST_TYPE_LGCY_CD | SETUP | All Orders by Status.bqy, Closed AR History.bqy, Merchandising Performance Analysis.bqy, Pending Refunds.bqy, Returns Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy |
| REF_FOP_TYPE_LGCY_CD | SETUP | All Orders by Status.bqy, Merchandising Performance Analysis.bqy, Open Orders by Item.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy Un-Shipped Orders by Status.bqy |
| REF_ITM_STA_LGCY_CD | SETUP | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Items Changed to Discontinued.bqy, Item Demand Analysis.bqy, Merchandising Performance Analysis.bqy, Open Orders by Item.bqy, Receiving Staffing Requirements.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy |
| REF_MAJ_CAT_LGCY_CD | SETUP | All Orders by Status.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.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, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy, Vendor Expenditures by Year and Category.bqy, Vendor Performance Analysis.bqy, Vendor Returns Analysis.bqy |
| REF_ORD_ITM_HP_LGCY_CD | SETUP | Un-Shipped Orders by Status.bqy |
| REF_ORD_ITM_POR_LGCY_CD | SETUP | All Orders by Status.bqy, Price Overrides.bqy Un-Shipped Orders by Status.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, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy |
| REF_ORD_ITM_TYPE_LGCY_CD | SETUP | All Orders by Status.bqy, Merchandising Performance Analysis.bqy, Pick Velocity.bqy, Price Overrides.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.bqy |
| REF_ORD_SUB_STA_LGCY_CD | SETUP | Aged orders in the warehouse.bqy, All Orders by Status.bqy, Price Overrides.bqy Un-Shipped Orders by Status.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, 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, Un-Shipped 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 Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bq, Un-Shipped Orders by Status.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, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped Orders by Status.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, Closed AR History.bqy, GL Trans.bqy, Inventory Value.bqy, Item Analysis.bqy, Item Demand Analysis.bqy, Items Changed to Discontinued.bqy, Merchandise Performance Analysis.bqy, Offer PNL.bqy, Open Purchase Orders.bqy, Orders in the Warehouse.bqy, Pending Refunds.bqy, Price Range Analysis.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, 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_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, Items Changed to Discontinued.bqy, Merchandise Performance 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, Un-Shipped 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 | 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, Merchandise Performance 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, Un-Shipped Orders by Status.bqy |
| SV_MACORD_CUSTOMER_COMP | CUST | Aged Open AR.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, Open RAs.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Spread Performance Analysis.bqy, Top X Customers.bqy, Un-Shipped 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, Pending Refunds.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Spread Performance Analysis.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 | Aged Open AR.bqy, Aged Orders in the Warehouse.bqy, All Orders by Status.bqy, Closed AR History.bqy, Merchandise Performance Analysis.bqy, Pending Refunds.bqy, Price Range Analysis.bqy, Repeat Buyer Analysis.bqy, Spread Performance Analysis.bqy, Un-Shipped 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, Un-Shipped Orders by Status.bqy |
| SV_MACORD_PROCESS_ORDER_HDR | ORD | All 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, Merchandise Performance 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, 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, Un-Shipped 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, Merchandise Performance 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, 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 | 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, Merchandise Performance 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, Merchandise Performance 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 | 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, Shipping Charge Analysis.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 | GL Trans.bqy, Item Demand Analysis.bqy, Merchandise Performance Analysis.bqy, Price Range Analysis.bqy, Sales by Product ID.bqy, Spread Performance Analysis.bqy | |
| REF_PROCESS_ACTION_SEARCH | All Orders by Status.bqy, Open Orders by Item.bqy, Pending Refunds.bqy, Un-Shipped Orders by Status.bqy | |
| REF_PROCESS_ACTION_SRCH_HDR | All Orders by Status.bqy |