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 .