...
Main Option | Sub Option | Column Names |
|---|---|---|
1 Goods Inwards | 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 | 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 | 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 | 400 Product Storage Profile | SiteCode CustomerCode Product Code SPC SS ChargeDescription ActiveAgainstProductProfile CustomerProfileIsDeleted StorageType StorageChargePeriod Charge Multiplier MinCharge IsBandCharge IsLowerRateApplicable |
401 Customer Address Details | CustomerCode SiteCode CustomerName DefaultLocation AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Telephone Fax CompanyWebsiteURL CustomerContact CreatedDateTime | |
402 Customer Analysis | CustomerCode Site Analysis1 Analysis2 Analysis3 Analysis4 Analysis5 Analysis6 Analysis7 Analysis8 Analysis9 Analysis10 | |
403 Customer Contacts | CustomerCode SiteCode CustomerName CustomerContact AddressLine1 AddressLine2 AddressLine3 Town Postcode DefaultLocation Title FirstName LastName EmailAddress Phone EmailGoodsInInvoices EmailGoodsOutInvoices EmailStockChargeInvoices EmailStockStorageInvoices EmailStockStorageInvoices EmailTransportInvoices | |
404 Customer 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 | CustomerCode SiteCode ProductCode BrandName ProductDescription ProductDescription2 Year COO UOM SPC CPP SS StrengthABV ProductTypeCode ProductGroupCode TaxCode CommodityCode TransportAdjustmentSign TransportAdjustment | |
406 Suppliers | CustomerCode SiteCode SupplierCode SupplierName AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Telephone Fax IsArchive | |
407 Transport | TransportCode TransportName Inbound Outbound AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Telephone Fax VATNumber ExciseID GuaranteeNo GuaranteeDate MeansOfTransportID MeansOfTransport MeansOfTransportCountry TransportAtBorder ModeOfTransportID IsArchive | |
408 Transport Contacts | TransportCode TransportName ContactName ContactEmail ContactPhone | |
409 Customer Goods In Profile | CustomerCode SiteCode ActiveInCustomerProfile ChargeDescription ReceiptType Charge MinCharge IsBandCharge LowerRateApplicable ReducedRateDiscount DiscountQty NoOfProducts | |
410 Customer Storage Profiles | CustomerCode SiteCode ActiveInCustomerProfile ChargeDescription StorageType StorageChargePeriod Charge MinCharge IsBandCharge IsLowerRateApplicable NoOfProducts | |
411 Customer Rates Summary | CustomerCode SiteCode TotalSinglesInStock NoOfGoodsInProfileRates NoOfGoodsInProfileZeroRates NoOfStorageProfileRates NoOfStorageProfileZeroRates | |
412 Product Goods In Profiles | SiteCode CustomerCode ProductCode SPC SS ChargeDescription IsDefaultCharge ActiveAgainstProductProfile CustomerProfileIsDeleted ReceiptType Charge Multiplier MinCharge IsBandCharge LowerRateApplicable ReducedRateDiscount DiscountQty | |
413 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 | 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 | 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 |