...
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 Enquiriespage.
...
The following table has listed all the BI Enquiry Reports Enquiries available in the Vision Business Intelligence window of Vision Warehouse:
1 Goods Inwards
| Expand |
|---|
| title | 1. Goods Inwards.........expand for details |
|---|
|
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
| Expand |
|---|
| title | 2. Stock Holding.........expand for details |
|---|
|
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
| Expand |
|---|
| title | 3. Goods Out.........expand for details |
|---|
|
|
...
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
...
| . Maintenance.........expand for details |
|
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 TransportThe 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
...
DiscountQty
NoOfProducts
| 410 Customer Storage ProfilesWhich 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 |
|
...
5 Manufacturing
| Expand |
|---|
| title | 5. Manufaturing.........expand for details |
|---|
|
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
| Expand |
|---|
| title | 6. Audit.........expand for details |
|---|
|
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
Email
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 |
|