BI Enquiry - Enquiries

Business Intelligence Enquiries provides a comprehensive set of standard reports.

As the BI Enquiries work similarly across all Vision applications that utilise it, we have placed all information for all applications in a central area in the General Wiki.
You will find details for all the BI Enquiries within Vision Commerce (plus you have access to see which Enquiries are available in other Vision applications)
Click on the following link to go to the general BI Enquiries page.

The following table has listed all the BI Enquiries available in the Vision Business Intelligence window of Vision Warehouse:

1 Goods Inwards

Sub Option	Column Names

Sub Option	Column Names
100 Pre Advice Status - Unreceipted	PreAdviceID CustomerCode SiteCode OrderID CustPONumber CustomerPODate POStatusDescription UnReceiptedLines ReceiptedLines DeliveryType UBCode MovementType HMRCMovement BookingRef BookingStart
101 Pre Advice Booking Details - Future Bookings	PreAdviceID CustomerCode Site OverId POStatusDescription BookedDateTime BookedWindow DriverReg DeliveryType UBCode MovementType HMRCMovement ExpectedDelivery ExpectedLines ExpectedPallets ExpectedCases IsOnPallets TransporterEmailSent
102 Transfers Outstanding	OrderID CustomerCode SiteCode CustomerName PreAdviceID DestCustomerCode DestSiteCode DestCustomerName CustomerPONumber CustomerPODate POStatusDescription PutAwayNotePrinted
103 Goods In - RFC	Code Description OWC DS FC Product Cost Freight Cost Insurance Cost PO Number Customer Code Site Code Type Of Receipt Quantity In Singles PL TS Cases Sing;es PO Entered Date Landed date Movement Date Supplier Name Rotation Number Rotation Line No Brand Pack Code Year SS SPC
104 Goods In - RET	Code Description OWC DS FC Product Cost Freight Cost PO Number Customer Code Site Code Type Of Receipt Quantity In Singles PL TS Cases Singles PO Entered Date Landed date Movement Date Supplier Name Rotation Number Rotation Line No Brand Pack Code Year SS SPC
105 Goods In - UNS	Code Description OWC DS FC Product Cost Freight Cost Insurance Cost PO Number Customer Code Site Code Type Of Receipt Quantity In Singles PL TS Cases Singles PO Entered Date Landed date Movement Date Supplier Name Rotation Number Rotation Line No Brand Pack Code Year SS SPC
106 Goods In - RW_	Code Description OWC DS FC Product Cost Freight Cost Insurance Cost PO Number Customer Code Site Code Type Of Receipt Quantity In Singles PL TS Cases Singles PO Entered Date Landed date Movement Date Supplier Name Rotation Number Rotation Line No Brand Pack Code Year SS SPC
107 Receipts with Sundries	SiteCode CustomerCode Inwards_UID Receipt_Date
108 Receipts without Sundries	SiteCode CustomerCode Inwards_UID Receipt_Date
109 HMRC PUR Inwards (pst 14d)	SystemReceiptDate CustomerName WOWGRRegistration CustomerCode ARC UID RotationNumber ProductDescription ActualPallets ActualUnits ActualSingles WareHouseName HaulierCompany DriverRegistration ContainerNumber OtherDetails
110 Inbound ARCs	PO_UID PO_Status Date_Booking Date_Arrived Days_Ago Booking_Ref Booking_Status CustCode Site SupplierName SupplierCountry ARC
111 Goods In Detailed	Pre Advice UID Customer Code Site Code PO Number Supplier Name Type Of Receipt Code Brand Description Year SPC SS Rotation Number Rotation Line No Quantity In Singles Pallets Cases Singles OWC FC DP DS Owner Changed in UK PCost/Case PCost Curr ICost/Case ICost Curr FCost/Case FCost Curr Pack Code Tax Code VAT Status ARC Rent Commences User PO Entered Date Landed Date Movement Date

2 Stock Holding

Sub Option	Column Names
200 Stock By Location (Recd Last 30)	SiteCode CustomerCode ResCustCode ProductCode Brand ProductDescription NonEnglishDescription Year SS RotationNumber RotationLineNo LocationName DateReceipted PreAdviceID Supplier SPC CPP ABV PsReceived CsReceived SsReceived TSsReceived PsInStock CsInStock SsInStock TSsInStock SellByDate ProductCostPerCase PCostCurrency DP DS FC OCInUK CWC TaxCode CommodityCode PackagingType
201 Duty Stamp Removal Processed	SiteCode CustomerCode ProductCode ProductDescription RotationNumber TaxCode CommodityCode CPP SPC TStamps Removed Pallets Cases Singles UserName Initiated
202 Stock By Rotation	SiteCode CustomerCode ResCustCode ProductCode BrandName ProductDescription NonEnglishDescription Year SS RotationNumber RotationLineNo DateReceipted PreAdviceID Supplier SPC CPP ABV PsReceived CsReceived SsReceived TSsReceived PsInStock CsInStock SsInStock TSsInStock SellByDate ProductCostPerCase PCostCurrency DP DS FC OCInUK CWC TaxCode CommodityCode PackagingType
203 Stock By Product	SiteCode CustomerCode ProductCode BrandName ProductDescription NonEnglishDescription Year SS SPC CPP ABV PsReceived CsReceived SsReceived TSsReceived PsInStock CsInStock SsInStock TSsInStock
204 Stock Movements In The Last Week	SiteCode CustomerCode ProductCode RotationNumber RotationLineNo LocationName MovementDate MovementType UBType PsMoved CsMoved SsMoved TSsMoved Username
205 Condition Reports Completed (>-1y)	ReportID RequestID SiteCode CustomerCode ProductCode ProductDescription RotationNumber RotationLineNo ConditionReportCompletedDate ConditionReportCompletedBy PsInStock CsInStock SsInStock TSsInStock
206 Stock with Quote/ Pref	SiteCode CustomerCode ProductCode ProductDescription RotationNumber RotationLineNo DateReceipted PreAdviceID SupplierCode SinglesPerCase CasesPerPallet SingleSize StrengthABV TotalSinglesReceived TotalSingles ProductCostPerCase PCostCurrency DutyStampsApplied CWC TaxCode CommodityCode QuotaNumber
207 Stock with BBD	SiteCode CustomerCode ProductCode ProductDescription AltLang_Description Year Type Group Rotation RLn Batch PONumber DateReceived SPC CPP SS TSingles_Recd BBD TSingles_Locn Locn_Name Pallets Cases Singles
208 Stock with Short BBD (<90d)	StockID ProductCode ProductDescription Year StrengthABV SinglesPerCase SingleSize RotationNumber RotationLineNo DateReceipted BestBeforeDate IsDutyPaid DutyStampsApplied IsInFreeCirculation CustomerBatchNo RotationNotes
209 Frozen Stock	FrozenID LocationID StockID ProductCode ProductDescription Year StrengthABV SinglesPerCase SingleSize RotationNumber RotationLineNo DateReceipted BestBeforeDate IsDutyPaid DutyStampsApplied IsInFreeCirculation CustomerBatchNo RotationNotes DateFrozen LocationName PalletsFrozen UnitsFrozen SinglesFrozen TotalConvertedSinglesFrozen AutoUnfreezeAfter FrozenReasonCode Notes Date FrozenBy
210 BBD Product Summary	SiteCode CustomerCode ProductCode ProductDescription AltLang_Description Year Type Group SPC SS BBD TSingles_Locn TCases BBD_Year BBD_Month
211 Product Pallet Stock	SiteCode CustomerCode ProductCode ProductDescription SPC CPP TSingles Plts Cses Sgls Rtn Count
212 Single Site Stock Available	SiteCode LocationName CustomerCode ResCustCode ProductCode Brand ProductDescription NonEnglishDescription Year RotationNumber RotationLineNo DateReceipted SPC SS CPP ABV PsInStock CsInStock SsInStock TSsInStock BestBeforeDate DP DS FC OCInUK CWC PackagingType TSinglesFrozen
213 Stock Available	StockID LocnID SiteCode CustomerCode CustomerName ReserveCustomerCode ProductCode RotationNumber RotationLineNo Prod_Description SPC SS Vintage Location Ltrs_per_case Stock_Cases Stock_Singles Stock_TSingles ProductCostPerCase PCostCurrency TaxCode CommodityCode ABV CommodityGroup COO ProductGroupCode
214 Frozen Stocks	StockID LocnID Rotation Rotn_Ln LocationName Frz_Cases FRz_Singles FRz_TSingles FrozenReasonCode FrozenReason SPC PCode PDesc Vint SS ABV CCode CName Site
215 Picked Stocks	StockID LocnID LocationName IsConfirmed Site CCode CName PCode PDescription Rotn RotnLn SPC SS Pick_Case Pick_Sgl Pick_TSgl FKOrderStatus
216 Allocated Stocks	StockID LocnID LocationName IsConfirmed Site CCode CName PCode PDescription Rotn RotnLn SPC SS Pick_Case Pick_Sgl Pick_TSgl FKOrderStatus
217 Combi Report 213-216	SiteCode CustomerCode CustomerName ReserveCustomerCode ProductCode RotationNumber RotationLineNo Prod_Description SPC SS Vintage Location Ltrs_per_case O_Av_Cse O_Av_Sgl Stock_Cases Stock_Singles ProductCostPerCase PCostCurrency TaxCode CommodityCode ABV CommodityGroup COO ProductGroupCode Alloc_Cse Alloc_Sgl Pick_Cse Pick_Sgl Frz_Cse Frz_Sgl Frozen_Code Frozen_Reason
218 Organic Stock Summary	SiteCode CustomerCode TSingles

3 Goods Out

Sub Option	Column Names

Sub Option	Column Names
300 Duty Unpaid Orders_W1 Cat 14_Last 7 Days	Move_Type SiteCode CustomerCode UID DocRef OrderDate DeliveryName DeliveryAddress1 DeliveryAddress2 DeliveryAddress3 DeliveryTownOrCountry DeliveryPostCode CountryCode C426No C185No IsEDIOrder IsVCISOrder UserName
301 Orders - Duty Details - Last Week	OrderID DocumentRef CustomerCode SiteCode CustomsDefermentNumber ExciseDefermentNumber OrderTypeUBCode OrderTypeDescription OrderTypeHMRC OrderDate
302 Orders - Delivery Details - Last Week	OrderID DocumentRef CustomerCode SiteCode OrderType DeliveryCategory DeliveryDepot DeliveryArea AreaBand OverrideChargeArea DeliveryName DeliveryAddress1 DeliveryAddress2 DeliveryAddress3 DeliveryPostcode CountryName OrderDate
303 Orders Picked - Pallets Used - Last Week	OrderID PickID PalletTypeCode PalletTypeDescription Qty
304 Orders - Unconfirmed Lines	SiteCode CustomerCode CustomerName OrderID DocumentRef OrderDate SavedDate ReceivingCustomerCode OrderTypeHMRC OrderLineStatus IsOnHold OnHoldReason
305 Deferment Last Used	DefermentAccount DefermentNumber Name EmailAddress DefermentLastUsed
307 Diplomatic Orders - Last Year	Site CustomerCode HMRC_Type C185No C426No OrderUID Doc Ref Name Address BeerLitres CigSticks PerfumeSgls TobaccoKg CigarStk SpiritLitres WineLitres OrderDate IsOnHold OrderStatus
308 Orders Despatched	Cust_Anal1 OrderID CustomerName BookedDeliveryDate OrderSavedDate EarliestTime LatestTime EarliestTime2 LatestTime2 Pickup Site Delivery To Quantity Ss Packs Vehicle Reg VFDownloaded VFDownloadedBy PickCompleted PickCompletedBy
309 Live Orders RFPD	OrderID DocumentRef Pickup Site Sending_Account OrderSavedDate Delivery To RequestedDate EarliestTime LatestTime EarliestTime2 LatestTime2 Quantity Ss Packs OrderLineStatus
310 HMRC ARC Outwards (past 14d)	UID OrderDate Document Ref CustomerName CustomerName CustomerCode WarehousekeeperCode HMRCArcEMCSRef RotationNumber ProductDescription Plt Cse Sgl DeliveryName ExciseNo ConsigneeName TransportName VehicleRegistration Seals GuaranteeNo
311 Last Wk Product Outbound	ProductCode CustomerCode SiteCode TSingles SPC CPP IP_Pallet IP_Cases IP_Singles IC_Cases IC_Singles ProductDescription
312 NI or BT postcode type Orders	Customer Code SiteCode Pick UID PickedDate Doc Ref Under Bond Type OrderSaved Delivery Name Address 1 Address 2 Address 3 Town or County Postcode Customer EORI Order Line ID Post Code Description SPC SS COO Commodity Code ABV Qty per line singles Sales Price
313 Batch Movements	SM_UID O_UID Batch Site CCode PCode PDesc Rotn RtLn_No Recd_Date Recd_Tsingle Recd_Plt Recd_Cs Recd_Ss SPC CPP Type Move_Date DeliveryName DocRef O_Date Move_TSingles Move_Plt Move_Cs Move_Ss
314 Movement Audit	SiteCode CustomerCode CustomerName MovementType MovementDate Pallets Cases Singles TotalSingles ProductCode ProductDescription PackageDescription ProductGroup Year RotationNumber SinglesPerCase SingleSize CaseLOL CasesPerPallet ABV DutyPaid FreeCirculation TaxCode CommodityCode ExciseCode BestBeforeDate OriginalWoodenCase DateReceived ReceiptDeliveryType ReserveCustomer Details1 Details2 Details3 RotationNotes InBondValue IBVCurrency PickUID OrderUID DocRef OrderDate BookedDate PODLineNumber DlyDate DlyLines DlyPhsCs DlyInvCs DlyInvPS DlyChgPerCs DlyChgPerPt DlyHandlingChg DlyAdtnChg DlyAdtnChgRsn DlyAdtnChgDt DlyAdtnChgUsr DlyAddressCode DlyName DlyAdr1 DlyAdr2 DlyAdr3 DlyAdr4 DlyPostcode DlyInst ARC ExciseDutyValue ValueForVAT VATType
315 Despatch Waste by Customer	Customer Site Total Singles COO Gross KG PrimaryWasteKG SecondaryWasteKG TertiaryWasteKG
316 Despatch Waste by Product	Customer Site Product Code Brand Description Alt Lang Desc Year SPC SS Total Singles COO Product Additional Information 4 Gross KG PrimaryWasteKG SecondaryWasteKG TertiaryWasteKG

4 Maintenance

Sub Option	Column Names
400 Product Storage Profile This shows customer products and the charge which has been associated with the product.	SiteCode CustomerCode Product Code SPC SS ChargeDescription ActiveAgainstProductProfile CustomerProfileIsDeleted StorageType StorageChargePeriod Charge Multiplier MinCharge IsBandCharge IsLowerRateApplicable
401 Customer Address Details A simple list of all customers.	CustomerCode SiteCode CustomerName DefaultLocation AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Telephone Fax Email CompanyWebsiteURL CustomerContact CreatedDateTime
402 Customer Analysis Customer analysis settings	CustomerCode Site Analysis1 Analysis2 Analysis3 Analysis4 Analysis5 Analysis6 Analysis7 Analysis8 Analysis9 Analysis10
403 Customer Contacts Contacts associated with each of the customers.	CustomerCode SiteCode CustomerName CustomerContact AddressLine1 AddressLine2 AddressLine3 Town Postcode DefaultLocation Title FirstName LastName EmailAddress Phone EmailGoodsInInvoices EmailGoodsOutInvoices EmailStockChargeInvoices EmailStockStorageInvoices EmailStockStorageInvoices EmailTransportInvoices
404 Customer Settings Other customer account settings.	SiteCode CustomerCode IsVATRegistered VATNumber EORI ExciseDefNo CustomsDefNo WOWGR AccountsCode TMCustomer TMSite IsBonded CanStoreNFC BulkPick UseMasterProducts FixedProductDimension AutoReceiptTfrsToMyself ReserveCustomers UseCertificates UnallocatedOrders UsesPallets CustomerFrozen AccountsFrozen
405 Products A basic product list for the customers.	CustomerCode SiteCode ProductCode BrandName ProductDescription ProductDescription2 Year COO UOM SPC CPP SS StrengthABV ProductTypeCode ProductGroupCode TaxCode CommodityCode TransportAdjustmentSign TransportAdjustment
406 Suppliers A supplier list for each customer	CustomerCode SiteCode SupplierCode SupplierName AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Email Telephone Fax IsArchive
407 Transport The list of transporters.	TransportCode TransportName Inbound Outbound AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Email Telephone Fax VATNumber ExciseID GuaranteeNo GuaranteeDate MeansOfTransportID MeansOfTransport MeansOfTransportCountry TransportAtBorder ModeOfTransportID IsArchive
408 Transport Contacts List of transport contacts	TransportCode TransportName ContactName ContactEmail ContactPhone
409 Customer Goods In Profile Which rates are active against each customer, the rates are all from the master list of rates and only those selected on the customer record are shown.	CustomerCode SiteCode ActiveInCustomerProfile ChargeDescription ReceiptType Charge MinCharge IsBandCharge LowerRateApplicable ReducedRateDiscount DiscountQty NoOfProducts
410 Customer Storage Profiles Which rates are active against each customer, the rates are all from the master list of rates and only those selected on the customer record are shown	CustomerCode SiteCode ActiveInCustomerProfile ChargeDescription StorageType StorageChargePeriod Charge MinCharge IsBandCharge IsLowerRateApplicable NoOfProducts
411 Customer Rates Summary A list of each customer and how many active rates they have selected on the customer record.	CustomerCode SiteCode TotalSinglesInStock NoOfGoodsInProfileRates NoOfGoodsInProfileZeroRates NoOfStorageProfileRates NoOfStorageProfileZeroRates
412 Product Goods In Profiles A list of all customer products and the goods in rates which have been assigned to each product, these rates are those selected at the customer level.	SiteCode CustomerCode ProductCode SPC SS ChargeDescription IsDefaultCharge ActiveAgainstProductProfile CustomerProfileIsDeleted ReceiptType Charge Multiplier MinCharge IsBandCharge LowerRateApplicable ReducedRateDiscount DiscountQty
413 VCIS Accounts List of VCIS accounts.	FirstName LastName EmailAddress
414 WOWGR Check List	WOWGRRegistration CustomerName AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName
415 Tax Certificate Expiry	Type Type Description Issued To Email Address Valid To Hecto-litres Per Annum
416 Tax Certificate Products
417 Commodity Codes	CommodityCode Description Category TaxCode DutyCategory Colour MinStrength MaxStrength Archived Products UnarchivedProducts InStockProducts
418 Product Commodity Codes	SiteCode CustomerCode Name ProductCode Brand Description AltLangDesc Year SPC SS Strength Archived InStock COOCode COOName COOEU ProductType TaxCode TaxCodeDescription CommodityCode CommodityDescription
419 Products with Certificates	SiteCode CustomerCode CustomerName ProductCode BrandName ProductDescription IssuedTo ValidTo SBHectolitresPerAnnum EmailAddress

5 Manufacturing

Sub Option	Column Names

Sub Option	Column Names
500 Manufacturing Receipts - Last 120 Days	Site Customer Code Brand Description Rotation Rot_Ln Date_Recd SPC CPP SS Strength Tsingles TotalLitres Rotation_Origin Packaging_Type Order_UID DocumentRef
501 Manufacturing Receipts ADV - 100 Days	PKStockInwardsDetail CustomerCode SiteCode RotationNumber Orig_Rotation Inbound_Ref SinglesPerUnit UnitsPerPallet SingleSize FreeRent SystemReceiptDate FirstDateReceivedToStore RentStartDate TSingles TCase TPallet Charge StorageTypeDescription StorageChargePeriodDescription PeriodOfFreeTime PKStock
502 Manufacturing Receipts Adv - Withdrawals	CustomerCode SiteCode RotationNumber Orig_Rotation Inbound_Ref FirstDateReceivedToStore SinglesPerUnit UnitsPerPallet SingleSize MovementDate TotalConvertedSinglesMoved DeliveryName DeliveryAddress1 Charge StorageTypeDescription StorageChargePeriodDescription PeriodOfFreeTime

BI Enquiry - Enquiries

1 Goods Inwards

Sub Option

Sub Option

100 Pre Advice Status - Unreceipted

101 Pre Advice Booking Details - Future Bookings

102 Transfers Outstanding

103 Goods In - RFC

104 Goods In - RET

105 Goods In - UNS

106 Goods In - RW_

107 Receipts with Sundries

108 Receipts without Sundries

109 HMRC PUR Inwards (pst 14d)

110 Inbound ARCs

111 Goods In Detailed

2 Stock Holding

200 Stock By Location (Recd Last 30)

201 Duty Stamp Removal Processed

202 Stock By Rotation

203 Stock By Product

204 Stock Movements In The Last Week

205 Condition Reports Completed (>-1y)

206 Stock with Quote/ Pref

207 Stock with BBD

208 Stock with Short BBD (<90d)

209 Frozen Stock

210 BBD Product Summary

211 Product Pallet Stock

212 Single Site Stock Available

213 Stock Available

214 Frozen Stocks

215 Picked Stocks

216 Allocated Stocks

217 Combi Report 213-216

218 Organic Stock Summary

3 Goods Out

300 Duty Unpaid Orders_W1 Cat 14_Last 7 Days

301 Orders - Duty Details - Last Week

302 Orders - Delivery Details - Last Week

303 Orders Picked - Pallets Used - Last Week

304 Orders - Unconfirmed Lines

305 Deferment Last Used

307 Diplomatic Orders - Last Year

308 Orders Despatched

309 Live Orders RFPD

310 HMRC ARC Outwards (past 14d)

311 Last Wk Product Outbound

312 NI or BT postcode type Orders

313 Batch Movements

314 Movement Audit

315 Despatch Waste by Customer

316 Despatch Waste by Product

400 Product Storage Profile

401 Customer Address Details

402 Customer Analysis

403 Customer Contacts

404 Customer Settings

405 Products

406 Suppliers

407 Transport

408 Transport Contacts

409 Customer Goods In Profile

410 Customer Storage Profiles

411 Customer Rates Summary

412 Product Goods In Profiles

413 VCIS Accounts

414 WOWGR Check List

415 Tax Certificate Expiry

416 Tax Certificate Products

417 Commodity Codes

418 Product Commodity Codes

419 Products with Certificates

5 Manufacturing

500 Manufacturing Receipts - Last 120 Days

501 Manufacturing Receipts ADV - 100 Days

502 Manufacturing Receipts Adv - Withdrawals

6 Audit