Field Name | Example | Requirement | Max Length | Notes |
FKCustomer | 56 | 12 | The unique code that you provided for the customer. | |
FKProductGroup | 1 | 6 | Lookup FKProductGroup Tab | |
FKVATCode | 2 | 1 | Enter Either | |
FKCommodityCode | 2204217900 | Mandatory | 10 | Use the commodity code, no spaces no dashes |
FKCountryWhenceConsigned | DE | Mandatory | 2 | The 2 digit country code where the goods would normally come from, this is generally the same as the Country of Origin |
FKCountryOfOrigin | CH | Mandatory | 2 | The 2 digit country code where the goods originate from. |
FKTaxCode | 777 | Mandatory | 3 | Excise Tax Code - Use 777 if not applicable. |
FKProductType | 2 | Mandatory | 2 | See reference tabl FKProductType |
ProductCode | 08071A | Mandatory | 20 | |
ProductDescription | SANTA TERESA GRAND | Mandatory | 50 | Product Description in English |
PackageDescription | 漢字 | Product Description NON English | ||
AlternativeCode |
| |||
AlternativeDescription |
| |||
KilogramsPerUnit | 0 | Conditional | For Tobacco products only | |
SinglesPerUnit | 6 | Mandatory | 5 | Must be less than 32000 |
SingleSize | 0.7 | Mandatory | 8.3 | Single size is 1.00 when there is no quantifiable quantity, otherwise in Litres |
UnitsPerPallet | 1 | Mandatory | 5 | Max 32000, use 1 if not known |
UnitsPerLayer | 1 | Mandatory | 5 | Max 256, use 1 if not known |
Height | 0 | 5.2 | ||
ContainerQuantity | 0 | 5 | Max 32000 | |
NetWeightKG | 4.2 | Mandatory | 5.2 | |
GrossWeightKG | 7.14 | Mandatory | 5.2 | Must be more or equal to netweightkg |
MinStockLevel | 0 | 5 | ||
MinPurchaseOrderQuantity | 0 | 5 | ||
MinSalesOrderQuantity | 0 | 5 | ||
TraderUnitCode | NULL | 20 | Barcode for the Case | |
SubUnitCode | NULL | 20 | Barcode for the Single Item | |
StrengthABV | 37.9 | Conditional | 8.2 | Mandatory for liquid alcoholic products otherwise blank |
LitresLiquidPerUnit | 4.2 | 8.2 | Mandatory for liquid alcoholic products otherwise blank | |
LitresAlcoholPerUnit | 1.68 | 8.2 | Mandatory for liquid alcoholic products otherwise blank | |
CigarettesPerUnit | 0 | 3 | Mandatory for cigarettes | |
CigarettesSellingPricePerUnit | 0 | 8.2 | Mandatory for cigarettes | |
ProductLife | 0 | 3 | No of days product should have on receipt into the warehouse | |
ShelfLifeDays | 0 | 3 | No of days for this product which must be on stock before it is despatched | |
ProductCostPerUnit | 17 | 8.2 | ||
ProductCostCurrency | GBP | 3 | ||
FKBrand | Brand Name or Producer | Mandatory | 50 | |
Vintage | 2007 | Mandatory | 4 | Use either a 4 digit year OR NA or NV |
SSCCMandatory | 0 | 1 | Requirement to collect SSCC on receipt (not advised - use Despatches need SSCC when possible) | |
TransportAdjustment | 50 | 3 | ||
TransportAdjustmentSign | - | 1 | ||
DegreePlato | 1 | Conditional | 2 | Mandatory for liquid alcoholic products otherwise blank |
FKTaxCodeAdditional | 777 | Conditional | 3 | Mandatory for liquid alcoholic products otherwise blank |
DoNotApplyTransportDiscount | 0 | 1 | New field introduction during 2019 replacing Transport Adjustment | |
DespatchesNeedSSCC | 0 | 1 | ||
FKUOM | 1 | Mandatory | 1 | Enter either 1 or 2 or 3 |
CubicMetres | NULL | 8.3 |
Manage space
Manage content
Integrations