Web Extract CSV

Identifier

AN

12

Y

Y

ProductCode

AN

20

Y

Y

Y

Unique Product Identifier

EANCase

AN

18

N

Y

EAN Barcode Number - normally numerical only.

EANSubCase

AN

18

N

Y

EAN Barcode Number - normally numerical only.

ProductDescription

AN

50

Y

Y

ProductDescription2

AN

50

Y

N

This field is no longer being used for documents or any output layouts.

Vintage

AN

4

Y

Y

Will be either a 4 digit year YYYY or NA or NV

SPC

Integer

6

Y (BottlesperCase)

Y

Singles per Case

SS

Decimal

8.5

Y (BottleSize)

Y

Single Size in centiliters

ABV

Decimal

3.5

Y

Stength in %

TSinglesAvailable

Int

12

Y (TotalConvertedSingles)

Y

The total stock in bottles available to sell.

(Available to sell  = STOCK - Orders not yet completed  (orders held will be included))

TCaseAvailable

Int

12

Y (AvailableStock)

Y

This is the total available singles / Singles per case (rounded down)

OptionExclude

Bit

Y (ExcludefromWeb)

Y

Exclude from Web option

OptionSingles

Bit

Y (AllowSingles)

Y

Do you sell single bottles of this product

OptionSellZero

Bit

N

Y

Sell even if no stock (for EP)

OptionRetail

Bit

Y

Y

Is this a Retail Product

AvailableFrom

Date

dd/mm/yy When this product is available from.

Product_CaseDP

Decimal

8.5

Y (StdCaseSellPrice)

Y

Product Sales Price Duty Paid for a Case

Product_SingleDP

Decimal

8.5

N

Y

Product Sales Price Duty Paid for a Bottle

Producer

N

Y

Producer_Name

Y

Y

COO

AN

6

Y

COO_Name

Y

Region

Y

Region_Name

Y

Y

Group

Y

Group_Name

Y

Style

Y

Style_Name

Y

Y

Type

Y

Type_Name

Y

Y

ProdAnal6

Y

ProdAnal6_Name

Y

UDF_Prod_Anal1

Y

UDF_Prod_Anal1_Name

Y

Y

UDF_Prod_Anal2

Y

UDF_Prod_Anal2_Name

Y

UDF_Prod_Anal3

Y

UDF_Prod_Anal3_Name

Y

UDF_Prod_Anal4

Y

UDF_Prod_Anal4_Name

Y

UDF_Prod_Anal5

Y

UDF_Prod_Anal5_Name

Y

UDF_Prod_Anal6

Y

UDF_Prod_Anal6_Name

Y

DutyPerSingle

Decimal

8.5

Y

The duty amount per single bottle.

Weight

Decimal

8.5

Y

GrossWeight per case

Product_CaseUB

Decimal

8.5

Y

Product Sales Price Under Bond for a Case

Product_SingleUB 

Decimal

8.5

Y

Product Sales Price Under Bond for a Bottle

PKPriceList

Int

16

WebPriceGroupCode

AN

6

PriceGroupName

AN

30

IsLive

Bit

Will remain but will only contain lines which ARE live

IsEP

Bit

Is this an EnPrimeur Price list

IsPromo

Bit

StartDate

DateTime

EndDate

DateTime

Notes

AN

60

Any notes for this price list

PriceIncVAT

Bit

ProductCode

AN

20

Unique Product Code

QuantityFrom

Int

QuantityTo

Int

CasePrice

decimal

8.3

 Duty Paid Price per case

SinglePrice

decimal

8.3

Duty Paid price per single 

CasePriceUB

decimal

8.3

New feature coming soon

SinglePriceUB

decimal

8.3

New feature coming soon.

ProductCode

AN

20

Unique field which links to the product table

TastingNotes

HTML

NoteDate

datetime