Exhibit 2.pdf

PDF 591 KB Posted

Attached to
ALCOHOL PRICE POSTING AND DELINQUENCY MANAGEMENT
Solicitation number
2139589
Issued by
New York

About this file

This file is a technical specification document defining the batch file format and data field requirements for the New York State Liquor Authority's Division of Alcoholic Beverage Control (SLA/ABC) Wholesale Platform, which manages price postings for alcoholic beverages sold to wholesalers and retailers. The document outlines CSV format specifications for price posting submissions across four beverage categories: liquor to wholesale (LW), liquor to retail (LR), wine to wholesale (WW), and wine to retail (WR). The batch file structure includes 96 required and conditional data fields covering product identification, licensing information, pricing details, discounts, and combo pack configurations. Key required fields include posting type and month/year, license serial numbers, wholesaler item numbers, brand information, product descriptions, alcohol content classifications, pricing per bottle and case, and NYS supplier information for verification purposes. The file specifies that combo items require different field requirements, with certain fields not used for combo packs including brand registration numbers, TTB/BATF CoLA numbers, brand names, sizes, units of measurement, age/vintage, proof, and per-bottle pricing.

The pricing structure requires submission of lowest available prices on a free-on-board (FOB) basis prior to any discounts, with separate pricing fields for standard retail locations and New York City locations where applicable. The specification accommodates up to ten discount tiers, allowing discounts to be structured by quantity in either bottle or case units with amounts expressed in either dollars or percent. Limited availability items receive special designation with mandatory allocation methods selected from eight predefined options including past sales history, published third-party sources, first-come-first-served, or distributor-assembled combo packs. Combo pack items may be designated as retailer-disassembled (RD) or consumer-packaged (CP) and assembled by either the supplier or distributor, with distributor-assembled items automatically designated as limited availability with full-case purchase requirements and one-case-per-account limitations. The specification notes that certain fields marked "Cond. Required" are conditionally required based on product type, such as Brand Label Registration numbers for low-alcohol wines and TTB/BATF CoLA numbers for wines with 7-24% alcohol content.

View the file

Other files

Show all 18

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

1.5 File Format is CSV

In the batch file, each product should appear on one line, comma separated

The tables below describe the fields that will appear in the price posting batch files.

Batch File Format: Price Posting Info for Coding

Liquor to Wholesale Liquor to Retail Wine to Wholesale Wine to Retail

1 Posting Type Character (2) Y LW LR WW WR

2 Posting Month Integer (2 digits) Y 2 digit month (01 - 12) 2 digit month (01 - 12) 2 digit month (01 - 12) 2 digit month (01 - 12)

3 Posting Year Integer (4 digits) Y 4 digit year 4 digit year 4 digit year 4 digit year

4 License Serial Number Integer (7 digits) Y

5 NS for Neutral Spirits NS for Neutral Spirits S for Sparkling Wine/Champagne S for Sparkling Wine/Champagne

WH for Whiskey WH for Whiskey CW for Carbonated Wine CW for Carbonated Wine

G for Gin G for Gin L for Wine Low Alcohol L for Wine Low Alcohol

B for Brandy B for Brandy V for Vermouth V for Vermouth

R for Rum R for Rum TR for Table Red and Rose Wine TR for Table Red and Rose Wine

CL for Cordials & Liqueurs CL for Cordials & Liqueurs TW for Table White Wine TW for Table White Wine

CS for Cocktails & Specialties CS for Cocktails & Specialties TF for Table Fruit Wine TF for Table Fruit Wine

O for Other O for Other O for Other O for Other

Q for Tequila Q for Tequila TL for Table Flavored Wine TL for Table Flavored Wine

I for Imitations I for Imitations DL for Dessert Flavored Wine DL for Dessert Flavored Wine

DF for Dessert Fruit Wine DF for Dessert Fruit Wine

DP for Dessert Port/Sherry/(Cooking)

Wine

DP for Dessert Port/Sherry/(Cooking)

Wine

6 Wholesaler Item # Character (15) Y

7 Regular/Combo/VAP Character (1) Y R/C/V - R (regular), C (Combo

/Assorted - pice per bottle is not required), V (Value Added Pack)

R (regular), C (Combo / Assorted -pice per bottle is not required), V

(Value Added Pack)

R (regular), C (Combo / Assorted -pice per bottle is not required), V

(Value Added Pack)

R (regular), C (Combo / Assorted -pice per bottle is not required), V

(Value Added Pack)

Some fields are not used for Combos. See the list at the bottom of this column.

8 Brand Label Reg # Character (7) Cond. Required: 7 digit SLA Brand Label

Reg # (BRL #) or P for Pending

Required: 7 digit SLA Brand Label

Reg # (BRL #) or P for Pending, Required for low-alcohol wine

(beverage type "L"), not available for wines with 7 - 24% alcohol

Required for low-alcohol wine

(beverage type "L"), not available for wines with 7 - 24% alcohol

9 TTB / BATF CoLA # Character (14) Cond. Not Required: 14 digit CoLA # or P for

Pending

Not Required: 14 digit CoLA # or P for

Pending

14 digit CoLA # or P for Pending.

Required for wines with 7 - 24% alcohol. Not required for low-alcohol wine.

14 digit CoLA # or P for Pending.

Required for wines with 7 - 24% alcohol. Not required for low-alcohol wine.

10 Brand Name Character (100) Y

11 Product Name / Item Description Character (100) Y

12 Brand Agent / Owner Character (1) Y O (Brand Owner), A (Brand Agent) Not Applicable (ignored) O (Brand Owner), A (Brand Agent) Not Applicable (ignored) wholesale schedules: "A" links to Primary Source line, retail schedules: no longer required; NYS

Supplier's SLA license number line must be completed instead

13 Primary Source (Brand Owner)

Information

Character (150) Cond. Not Required: Brand Agent must list

Company Name, Address, & Phone # of Brand Owner of this product

Not Applicable (ignored) Not Required: Brand Agent must list

Company Name, Address, & Phone # of Brand Owner of this product

Not Applicable (ignored) This line needs to be optional right now with the ability to be required in the future.

14 Authorized NYS Distributors - wholesaler serial number(s)

Character (150) Y N (None) or list NYSLA serial number for each authorized distributor

N (None) or list NYSLA serial number for each authorized distributor

This line needs to accommodate multiple serial numbers. Only allow currently active serial numbers. For each distributor: 7-digit serial number, comma, followed by a space. Ex:

1234567, 1234568, 1234569

15 Size Decimal (6, 2) Y The size of the product, without the unit of measurement.

The size of the product, without the unit of measurement.

The size of the product, without the unit of measurement.

The size of the product, without the unit of measurement.

Ex: 750, 1.5

16 Unit of Measurement Character (10) Y Ex: ML, L

17 # of Bottles / Sleeves per Case Integer (3 digits) Y >= 1 >= 1 >= 1 >= 1

18 Bottles per Sleeve if applicable Integer ( 2 ) Cond. Limit 300

19 Age / Vintage Character (11) N N/A (None Available) or the year N/A (None Available) or the year VV (Various Vintage), NV (Non

Vintage), or the year

VV (Various Vintage), NV (Non

Vintage), or the year

Possible Values NOTESRef # Field Name Data Type Required

Type of Beverage Character (2) Y

Exhibit 2 - Batch File Format IFB C001029 Alcohol Price Posting and Delinquency Management

20 Alcohol Content Character(7) Y >= 0 >= 0 >= 0 OR A (Less than 7%), B (7% to

14%), C (over 14% to 21%), D (over

21% to 24%), E (over 24%)

>= 0 OR A (Less than 7%), B (7% to

14%), C (over 14% to 21%), D (over

21% to 24%), E (over 24%)

Ex: 20, 44.5, B, D

21 Proof Decimal (6, 2) N >= 0 >= 0 >= 0 >= 0 Ex: 40, 90, NA, NA

22 Price per Bottle / Sleeve Decimal (9, 2) Cond. > 0 (Price=FOB) > 0 > 0 (Price=FOB) > 0 NA if Combo, required if not. Lowest price that this product can be purchased for [prior to discounts]

23 Price per Case Decimal (9, 2) Y > 0 (Price=FOB) > 0 > 0 (Price=FOB) > 0 Lowest price that this product can be purchased for

[prior to discounts]

24 NYC Bottle / Sleeve Price Decimal (9, 2) Cond. Not Applicable > 0 , optional Not Applicable > 0 , optional

25 NYC Case Price Decimal (9, 2) Cond. Not Applicable > 0 , optional Not Applicable > 0 , optional

26 Full Case Purchase Only Character (1) Cond. Y (Yes) or N (No) Y (Yes) or N (No) Y (Yes) or N (No) Y (Yes) or N (No) "RD" must be Full Case Purchase Only

97 Split Case Charge Decimal (6,2) Cond. NA $ per bottle NA $ per bottle Required if split case charge.

27 FOB designation Character (150) N If applicable Not Applicable (ignored) If applicable Not Applicable (ignored) Ex: FOB Italy Net

28 NYS Supplier's NYSLA wholesale serial # Integer (7) Y Required Required Required Required used to assist with verification of posting on a wholesale schedule

29 NYS Supplier's Item # from their wholesale schedule

Character (15) Y Required Required Required Required this item # used to verify that item is on a wholesale schedule

30 Combos: Retailer Disassembly or

Consumer Packaging

Y RD (Retailer Disassembly) or CP

(Consumer Packaging)

RD (Retailer Disassembly) or CP

(Consumer Packaging)

RD (Retailer Disassembly) or CP

(Consumer Packaging)

RD (Retailer Disassembly) or CP

(Consumer Packaging)

"RD" is automatically Full Case Purchase Only AND

Limited Availability

31 Combos: Assembled by Supplier or NYS

Distributor ?

Y SA (Supplier Assembled) or DA

(Distributor Assembled) - "DA" automatically shows additional notation item is not sold as a package to the wholesaler but is assembled by the wholesaler from its own inventory

SA (Supplier Assembled) or DA

(Distributor Assembled -automatically designated as L/A)

SA (Supplier Assembled) or DA

(Distributor Assembled - "DA" automatically shows additional notation item is not sold as a package to the wholesaler but is assembled by the wholesaler from its own inventory

SA (Supplier Assembled) or DA

(Distributor Assembled -automatically designated as L/A)

"DA" is automatically "L" (limited availability) and

Full case only AND "one case per account, cannot be denied if retailer is eligible" in Allocation Detail line

32 Limited Availability Character (1) Cond. L (Limitied Availability) OR Blank L (Limitied Availability) OR Blank L (Limitied Availability) OR Blank L (Limitied Availability) OR Blank If "L" then no discounts permitted.

Select from list, plus narrative

01. Past sales history

02. published third party sources

03. Unsold accounts

04.First come first served

05. Advance interest

06. Closeout sales

07. Distributor Assembled (DA)

Combo pack narrative would be: limit 1 per account

08. Other with Prior SLA Approval

34 Allocation Description Character (100) N N/A Optional when "L" N/A Optional when "L" Explanatory text

35 NYS Product Character (1) N "Y" (Yes) or "N" (No) "Y" (Yes) or "N" (No) "Y" (Yes) or "N" (No) "Y" (Yes) or "N" (No)

36 Discount Code Character (10) N If entering codes instead of completing detail discount lines, the codes must be defined on the appropriate screen or in the batch discount code table submission.

If entering codes instead of completing detail discount lines, the codes must be defined on the appropriate screen or in the batch discount code table submission.

If entering codes instead of completing detail discount lines, the codes must be defined on the appropriate screen or in the batch discount code table submission.

If entering codes instead of completing detail discount lines, the codes must be defined on the appropriate screen or in the batch discount code table submission.

37 discountQty1 - Qty for Discount Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

All discounts N/A if "L" or "DA"

38 discountUnit1 - B or C Character (1) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

39 discountAmount1 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

40 discountType1 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

Allocation Method (for Limited Availability items)

Required when "L" in Limited

Availability designation.

Required when "L" in Limited

Availability designation. This line defaults to #7 when the "DA" designation is selected in the

Combos: Assembled By field.

Required when "L" in Limited

Availability designation.

Required when "L" in Limited

Availability designation. This line defaults to #7 when the "DA" designation is selected in the

Combos: Assembled By field.

Character (2) Cond.33

41 discountQty2 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

42 discountUnit2 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

43 discountAmount2 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

44 discountType2 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

45 discountQty3 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

46 discountUnit3 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

47 discountAmount3 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

48 discountType3 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

49 discountQty4 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

50 discountUnit4 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

51 discountAmount4 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

52 discountType4 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

53 discountQty5 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

54 discountUnit5 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

55 discountAmount5 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

56 discountType5 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

57 discountQty6 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

58 discountUnit6 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

59 discountAmount6 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

60 discountType6 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

61 discountQty7 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

62 discountUnit7 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

63 discountAmount7 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

64 discountType7 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

65 discountQty8 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

66 discountUnit8 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

67 discountAmount8 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

68 discountType8 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

69 discountQty9 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

70 discountUnit9 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

71 discountAmount9 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

72 discountType9 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

73 discountQty10 Integer N > 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

> 0 , List only the number required (ie -

5), not a range of numbers (ie - 1 to

5).

74 discountUnit10 Character (2) N "B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

"B" (bottle) or "C" (case). Use only

Bottle OR Case, not both for any one item.

75 discountAmount10 Decimal (9, 2) N >0.00 >0.00 >0.00 >0.00 Amount of discount applied off each (bottle or case)

76 discountType10 Character (1) N "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) "$" (dollars) or "%" (percent) Dollars or percent

77 ComboItem1 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

78 ComboQty1 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

79 ComboItem2 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

80 ComboQty2 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

81 ComboItem3 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

82 ComboQty3 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

83 ComboItem4 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

84 ComboQty4 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

85 ComboItem5 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

86 ComboQty5 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

87 ComboItem6 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

88 ComboQty6 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

89 ComboItem7 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

90 ComboQty7 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

91 ComboItem8 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

92 ComboQty8 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

93 ComboItem9 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

94 ComboQty9 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

95 ComboItem10 Character (15) N Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item # Wholesaler Item #

96 ComboQty10 Integer N Qty of Item Qty of Item Qty of Item Qty of Item Qty of Item

97 [See 97 between 26 and 27]

These fields are not required or used for

Combos:

5 (Type)

8 (BRL)

9 (TTB)

10 (Brand Name)

15 (Size)

16 (Unit of Measure)

19 (Age)

21 (Proof)

22 (Price per Bottle)

24 (NYC Price per Bottle)

35 (NYS Product/Label)

File details come from the government source that posted it. Updated .