Exhibit 3.pdf
PDF 178 KB Posted
- Attached to
- ALCOHOL PRICE POSTING AND DELINQUENCY MANAGEMENT
- Solicitation number
- 2138493
- Issued by
- New York
About this file
This is an Exhibit file detailing the discount code table format specifications for the New York State Office of Information Technology Services and the New York State Liquor Authority's Division of Alcoholic Beverage Control (SLA/ABC) Wholesale Platform hosting procurement. The document establishes the data structure and field requirements that vendors must follow when submitting discount information related to alcoholic beverage pricing within the platform's batch file system. The exhibit specifies 45 distinct fields organized into a standardized format, with the first three fields capturing posting type, month, and year, followed by a license serial number and a primary discount code field.
The remaining fields define up to ten tiered discount structures (discountQty1 through discountQty10, paired with corresponding unit types, amounts, and discount type designations). Each discount tier requires specification of quantity thresholds, unit measurements designated as either bottle (B) or case (C), discount amounts formatted as decimals with up to six digits and two decimal places, and discount type indicators specified as either dollar ($) or percent (%) reductions. Most fields are optional with exceptions for posting type, posting month, posting year, license serial number, and discount code, which are mandatory. The specifications establish strict formatting requirements, including that quantities must be single values rather than ranges and that bottle and case units cannot be combined within individual line items, ensuring data consistency and interoperability within the SLA/ABC's regulatory reporting and pricing management system.
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
Batch File: Discount Code table format
Ref # Field Name Data Type Required Description
1 Posting Type Character (2) Y LW, LR, WW, WR
2 Posting Month Integer (2 digits) Y 2 digit month (01 - 12)
3 Posting Year Integer (4 digits) Y 4 digit year
4 License Serial Number Integer (7 digits) Y
5 Discount Code Character (10) Y Code for this discount Alphanumeric
6 discountQty1 - Qty for Discount Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
7 discountUnit1 - B or C Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
8 discountAmount1 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
9 discountType1 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
10 discountQty2 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
11 discountUnit2 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
12 discountAmount2 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
13 discountType2 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
14 discountQty3 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
15 discountUnit3 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
16 discountAmount3 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
17 discountType3 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
18 discountQty4 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
19 discountUnit4 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
20 discountAmount4 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
21 discountType4 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
22 discountQty5 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
23 discountUnit5 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
24 discountAmount5 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
25 discountType5 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
26 discountQty6 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
27 discountUnit6 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
28 discountAmount6 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
29 discountType6 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
30 discountQty7 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
31 discountUnit7 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
32 discountAmount7 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
33 discountType7 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
34 discountQty8 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
Exhibit 3 - Discount File Format IFB C000992 Alcohol Price Posting and Delinquency Management
35 discountUnit8 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
36 discountAmount8 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
37 discountType8 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
38 discountQty9 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
39 discountUnit9 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
40 discountAmount9 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
41 discountType9 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
42 discountQty10 Integer N > 0 , List only the number required (ie - 5), not a range of numbers (ie - 1 to 5).
43 discountUnit10 Character (2) N "B" (bottle) or "C" (case). Use only Bottle
OR Case, not both for any one item.
44 discountAmount10 Decimal (6, 2) N >0.00 Amount of discount applied off each
(bottle or case)
45 discountType10 Character (1) N "$" (dollars) or "%" (percent) Dollars or percent
File details come from the government source that posted it. Updated .