Sub Option | Column Names |
400 Product Storage ProfileThis 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 DetailsA simple list of all customers. | CustomerCode SiteCode CustomerName DefaultLocation AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Telephone Fax Email CompanyWebsiteURL CustomerContact CreatedDateTime |
402 Customer AnalysisCustomer analysis settings | CustomerCode Site Analysis1 Analysis2 Analysis3 Analysis4 Analysis5 Analysis6 Analysis7 Analysis8 Analysis9 Analysis10 |
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 SettingsOther 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 ProductsA 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 SuppliersA supplier list for each customer | CustomerCode SiteCode SupplierCode SupplierName AddressLine1 AddressLine2 AddressLine3 Town Postcode CountryName Email Telephone Fax IsArchive |
407 TransportTransportCodeThe 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 |
List of transport contacts | TransportCode TransportName ContactName ContactEmail ContactPhone |
409 Customer Goods In ProfileWhich 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 ProfilesCustomerCode SiteCode ActiveInCustomerProfile ChargeDescription StorageType 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 SummaryA 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 ProfilesA 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 AccountsList 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 |