- Created by Sarah Stalley (Unlicensed), last modified by Alan Gilchrist on Mar 26, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 7 Next »
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 |
|---|---|
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 |
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 |
|---|---|
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 | SiteCode |
401 Customer Address Details | CustomerCode |
402 Customer Analysis | CustomerCode |
403 Customer Contacts | CustomerCode |
404 Customer Settings | SiteCode |
405 Products | CustomerCode
|
406 Suppliers | CustomerCode |
407 Transport | TransportCode |
408 Transport Contacts | TransportCode |
409 Customer Goods In Profile | CustomerCode |
410 Customer Storage Profiles | CustomerCode |
411 Customer Rates Summary | CustomerCode |
412 Product Goods In Profiles | SiteCode |
413 VCIS Accounts | FirstName |
414 WOWGR Check List | WOWGRRegistration |
415 Tax Certificate Expiry | Type |
416 Tax Certificate Products |
|
417 Commodity Codes | CommodityCode |
418 Product Commodity Codes | SiteCode 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 |
|---|---|
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
|
6 Audit
Sub Option | Column Names |
|---|---|
600 Stock Unpick | Order UID Pick UID Site Code Customer Code Document Ref User Full Name UnpickDateTime Reason Code Reason Description Notes Product Code Product Description Rotation No
|
601 SEED Address List | DPRef Type TypeDescription HMRC_ARC_Type Country DeliveryName Streetname BuildingName Locality Town Postcode ExciseNo VATNo CustomsGuarantee CustomsNo EORI WarehouseKeeperCode Export_DFType DeclarationType LastTimeUsed LastTimeCheckedByHMRC DateVerificationEmailSent FKDestinationTypeCode PlaceOfDeliveryOfficeReferenceNumber LastTimeCheckSentToHMRC
|
602 New Customers last 60d | SiteCode CustomerCode CustomerName CustomerContact AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryCode CountryName Telephone Fax VATNumber WOWGRRegistration CreatedDateTime
|
603 WOWGR Customers | Site CustCode Name Add1 Add2 Add3 Town Postcode CountryCode WOWGRRegistration VATNumber EORI CreatedDateTime DutyRepCat LegalType
|
604 Duty Stamp Usage last 365d | Stamp_Batch_ID DutyStampNumber Stamp_Issued Rotation Ln Stamp_Batch_LastNoUsed Stamp_Batch_Added ProductCode CustomerCode SiteCode
|
- No labels