Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
title4. Maintenance.........expand for details

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

TransportCodeThe 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

CustomerCode
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 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

...