Exhibit 3.pdf

272 KB Posted

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

About this file

Written by GovTribe AI ·

This is an Exhibit file detailing the discount code file format specification 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 procurement. The exhibit establishes the technical requirements for submitting discount information related to alcoholic beverage pricing, specifying a batch file format with defined data fields and validation rules.

The discount file format requires 45 distinct data fields organized in a structured table, with mandatory fields including posting type, posting month and year, license serial number, and discount code. The specification allows for up to ten tiered discount levels per submission, with each tier accommodating quantity thresholds, unit type designations (bottle or case), discount amounts in decimal format, and discount type specifications (dollars or percentage). All quantity fields must contain discrete values rather than ranges, and discount unit fields must specify either bottle or case exclusively, not both, for any single item. The format accommodates both dollar-based and percentage-based discount structures, with discount amounts formatted as decimals up to six digits with two decimal places for precision in pricing calculations.

View the file

Other files

File Type Posted
Attachment 3 - Bidder Eligibility and Minimum Qualifications Form.pdf PDF
Attachment 4 - Contractor Certification of Covered Agency, ST-220-CA.pdf PDF
Attachment 6 - ITS Consultant Confidentiality & NDA Form.pdf PDF
Exhibit 1.pdf PDF
Exhibit 2.pdf PDF
Attachment 2 - Firm Offeror Letter & Conflict of Interest Disclosure.pdf PDF
Appendix C-AI.pdf PDF
Appendix C-1.pdf PDF
Appendix A.pdf PDF
Attachment 8 - Bidder Questions and Extraneous Terms Form.xlsx XLSX spreadsheet
Attachment 5 - FOIL & Litigation Disclosure.pdf PDF
Attachment 7 - Bid Checklist.pdf PDF
Appendix C-2.pdf PDF
IFB C001029 - Alcohol Price Posting and Delinquency Management.pdf PDF
Attachment 9 - Requirements Verification Traceability Matrix.xlsx XLSX spreadsheet
Appendix C.pdf PDF
Attachment 10 - Consultant Disclosure A & B Form.pdf PDF
Attachment 1 - Financial Response Form.xlsx XLSX spreadsheet
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 C001029 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 .