Skip to main content

Prevent All Cigarette Trafficking (PACT) Act File Upload Layout

The PACT Act file must be saved and submitted as comma-separated values (CSV) file format.

  • Do not include commas in the data. Please remove commas from names and addresses before converting to CSV format.
  • Do not include slash or hyphen separators in date fields. (Example: MMDDYYYY)
  • If entering a negative number, include a negative symbol before the number. (Example: -125.00)
  • In number fields, the character maximum includes the hyphen or decimal point. (Example: ####.## is six characters)

Printable Format

PACT Act File Upload Layout Table

Column Field Name Character Length Field Format Upload Requirements Description of Field Contents
A Account Number 11 intentionally blank R = Required intentionally blank
B Reporting Period 8 MMDDYYYY R = Required Use last day of reporting period
C Invoice Number Max 20 intentionally blank R = Required  
D Date of Shipment 8 MMDDYYYY R = Required Must be month of reporting period
E Shipped to Type 1 intentionally blank R = Required M = Manufacturer
W = Wholesale
D = Distributor
C = Consumer
F Shipped to Name Max 70 intentionally blank R = Required intentionally blank
G Shipped to Address 1 Max 40 intentionally blank R = Required intentionally blank
H Shipped to Address 2 Max 40 intentionally blank R = Required intentionally blank
I Shipped to City Max 20 intentionally blank R = Required intentionally blank
J Shipped to State 2 intentionally blank R = Required intentionally blank
K Shipped to ZIP Min 5, Max 10 #####-#### R = Required intentionally blank
L Shipped to Phone # Max 13 ###-###-#### R = Required intentionally blank
M Delivery Sale 1 1 or 0 R = Required Yes = 1,
No = 0
N Del. Service Co. Name
 
Max 70 intentionally blank C = Conditional If Delivery Sale = 1
O Del. Service Address 1 Max 40 intentionally blank C = Conditional If Delivery Sale = 1
P Del. Service Address 2 Max 40 intentionally blank C = Conditional If Delivery Sale = 1
Q Del. Service City Max 20 intentionally blank C = Conditional If Delivery Sale = 1
R Del. Service State Max 2 intentionally blank C = Conditional If Delivery Sale = 1
S Del. Service ZIP Min 5, Max 10 ##### C = Conditional If Delivery Sale = 1
T Del. Service Phone # Max 13 ###-###-#### C = Conditional If Delivery Sale = 1
U Tobacco Type 1 C, R, or S R = Required C = Cigarettes 
R = Roll Your Own 
S = Smokeless
V Brand Name Max 40 intentionally blank R = Required Enter Brand Name; -1 = Other Brand Name
W Other Brand Name Max 30 intentionally blank C = Conditional If Brand Name = -1
X Cigarettes (Sticks)
 
Max 15 ##### C = Conditional intentionally blank
Y RYO (Ounces) Max 12 ####.## C = Conditional intentionally blank
Z Smokeless (Ounces) Max 12 ####.## C = Conditional intentionally blank
AA Extended Sale Price Max 12 ####.## C = Conditional intentionally blank
AB Vermont Tax Paid 1 1 or 0 R = Required Vermont stamped or tax paid to Vermont:
Yes = 1 
No = 0