{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ENDS Report","Instructions \"ENDS\" ","Table of Codes","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":17,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ENDS Report","index":0,"n_rows":3,"n_cols":26,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,3]]}
["ENDS"," File Creator \nfor CSV Upload\n "]
[" Enter company name or a unique identifer here ►►",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","Y"]
["Reporting Month/Period","Customer CT Reg","Customer FEIN","Code for FEIN, SSN, TIN","Type of Customer","Customer Name","Customer Address","Customer Address 2","Customer City","Customer State","Customer Zip/Postal Code","Fed Desc Code","Invoice Date","Invoice Number","Quantity","Item UPC*/SKU/Item Number","Sales Price ($)","Delivery Service Name","Delivery Address","Delivery Address 2","Delivery City","Delivery State","Delivery Zip/Postal Code","Delivery County","Delivery Phone Number","Delivery Email Address"]

{"sheet":"Instructions \"ENDS\" ","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[7,0,7,1]]}
[null,"Connecticut Department of Revenue Services"]
[null,"Comma Separated Value file layout"]
[null,"PA-3: State Electronic Nicotine delivery system, \"ENDS\" PACT Act Report"]
[]
[null,"Use this form to report electronic nicotine delivery systems or \"ENDS\" sales transactions other than Cigarettes or Tobacco Products (please refer to the Table of Codes for \"Type of Customer\" and \"Fed Desc\")"]
[]
[null,"Instructions for electronic nicotine delivery systems or \"ENDS\" Sales PA-3 "]
[]
["Item No.","Column","Field Name","Full Description","Maximum Field Length","Field Type","Validation Rules "]
[1,"Column A","Reporting Month/Period","Provide reporting month (MM/DD/YYYY)",10,"Date","Format \"MM/DD/YYY\""]
[2,"Column B","Customer CT Reg","Provided Customer CT TID Reg (10, 11 or 12 digits)",12,"Numeric","Must be 10, 11, or 12 digits, do not included spaces, dashes or special characters"]
[3,"Column C","Customer FEIN","Provide Customer FEIN or SSN (must be 9 digits)",9,"Text Field","Must be 9 digits, do not included spaces, dashes or special characters"]
[4,"Column D","Code for FEIN, SSN, TIN","Provide the appropriate code FEIN/SSN, TIN.  Refer to the electronic filing Table of Codes",6,"Text Field","Blanks ok"]
[5,"Column E","Type of Customer","Provide the appropriate code for the type of customer.  Refer to the electronic filing Table of Codes",20,"Text Field","Enter type of customer, "]
[6,"Column F","Customer Name","Provide your Customer's name.",30,"Text Field","Enter Customer Name"]
[7,"Column G","Customer Address","Provide the street address where the product was shipped to the Customer.",30,"Text Field","Enter customer address lines 1, blanks are ok"]
[8,"Column H","Customer Address 2","Provide Suite, Apt # etc.",30,"Text Field","Enter customer address lines 2, blanks are ok"]
[9,"Column I","Customer City","Provide the city where the product was shipped to the Customer.",20,"Text Field","Enter customer city, blanks are ok"]
[10,"Column J","Customer State","Provide the two digit State Code where the product was shipped to the Customer.",2,"Text Field","Enter customer state lines 1, blanks are ok"]
[11,"Column K","Customer Zip/Postal Code","Provide the Zip Code / Postal Code where the product was shipped to the Customer.",9,"Numeric","Enter recipient zip code, blanks are ok"]
[12,"Column L","Fed Desc Code","Provide  Federal Description Code. Refer to the electronic filing Table of Codes",20,"Text Field","Enter  blanks are ok"]
[13,"Column M","Invoice Date","Provide the invoice date. ",10,"Date","Format \"MM/DD/YYY\""]
[14,"Column N","Invoice Number","Provide the invoice number. ",20,"Text Field","Enter  blanks are ok"]
[15,"Column O","Quantity","Provide Quantity of sales",13,"Numeric no decimals","Required; If none, enter 0"]
[16,"Column P","Item UPC*/SKU/Item Number","Provided Item UPC/SKU/Item Number",12,"Text Field","Enter  blanks are ok"]
[17,"Column Q","Sales Price ($)","Provide sales price",13,"Numeric with decimals","Required; If none, enter 0"]
[18,"Column R","Delivery Service Name","Provide the delivery service name.",30,"Text Field","Enter delivery service name"]
[19,"Column S","Delivery Address","Provide the street address of the delivery service.",30,"Text Field","Enter recipient address lines 1, blanks are ok"]
[20,"Column T","Delivery Address 2","Provide Suite, Apt # etc.",30,"Text Field","Enter recipient address lines 2, blanks are ok"]
[21,"Column U","Delivery City","Provide the City of the delivery service.",20,"Text Field","Enter recipient city, blanks are ok"]
[22,"Column V","Delivery State","Provide the two digit State Code of the deliver service.",2,"Text Field","Enter recipient state lines 1, blanks are ok"]
[23,"Column W","Delivery Zip/Postal Code","Provide the Zip Code / Postal Code where the product was shipped to the Customer.",10,"Text Field","Enter recipient zip code, blanks are ok"]
[24,"Column X","Delivery County","Provide Delivery Services' County code",20,"Text Field","Enter  blanks are ok"]
[25,"Column Y","Delivery Phone Number","Provide Delivery phone number",10,"Text Field","Enter  blanks are ok"]
[26,"Column Z","Delivery Email Address","Provide Delivery Service email (if available)",30,"Text Field","Enter  blanks are ok"]
[]
["* The Universal Product Code (UPC; redundantly: UPC code) consists of 12 numeric digits that are uniquely assigned to each trade item / product brand you are reporting."]
["*Please note: File must be saved and submitted as a .CSV file format."]
["1. Do not include the header row in the submitted report."]
["2. No Commas can be included in the data. Please remove commas from the names and addresses before converting to .CSV format."]
["3. Date fields must include either a slash or dash as separators. MM/DD/YYYY or MM-DD-YYYY"]
["4. if entering a negative number place a negative symbol '-' at the beginning of the number. Ex.: -123"]
["5. Do not separate thousands with a comma in number fields."]
["6. Report the number of unit sales individual increments or Oz's of Nicotine."]

{"sheet":"Table of Codes","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
["Customer FEIN/SSN /TIN Description - Column C"]
["FEIN",null,"Federal Identification or EIN  (Required for all business to business transactions)"]
[null,null,"the customer should have a credit app on file with all appropriate exemption certificates and licenses"]
["SSN",null,"Social Security Number (Required for business to business to transactions)"]
[null,null,"the customer should have a credit app on file with all appropriate exemption certificates and licenses"]
["TIN",null,"Taxpayer Identification Number (Required for all business to business transactions)"]
[null,null,"the customer should have a credit app on file with all appropriate exemption certificates and licenses"]
["Unknown - Leave Blank",null,"Unknown - Leave Blank"]
[]
["Type of Customer - Column D"]
["Native American"]
["Delivery Seller"]
["InterBranch Transfer"]
["Wholesaler"]
["Military"]
["Government"]
["Distributor"]
["Manufacturer"]
["Retailer"]
["Sub Jobber"]
["Employee"]
["Distribution Center"]
["Customer"]
["Consumer"]
["Other"]
[]
[]
["Federal Description - Column L","PACT Form","Federal Description Meaning"]
["Cigarette","PA-1","- Any roll of tobacco wrapped in paper or in any substance not containing tobacco.\n- Any roll of tobacco wrapped in any substance containing tobacco which, because of its appearance, the type of tobacco used in the filler, or its packaging and labeling is likely to be offered to, or purchased by, consumers as a cigarette as described in the bullet above."]
["Snuff","PA-2","Any finely cut, ground, or powdered tobacco that is not intended to be smoked."]
["Chewing Tobacco","PA-2","Any leaf tobacco that is not intended to be smoked."]
["Roll Your Own","PA-2","Any tobacco which, because of its appearance, type, packaging, or labeling, is suitable for use and likely to be offered to, or purchased by, consumers as tobacco for making cigarettes or cigars, or for use as wrappers thereof."]
["ENDS","PA-3","An Electronic Nicotine Delivery System \"ENDS\", is any electronic device that, through an aerosolized solution, delivers nicotine, flavor, or any other substance to the user inhaling from the device; \nIncludes -\n(i) an e-cigarette; \n(ii) an e-hookah; \n(iii) an e-cigar; \n(iv) a vape pen; \n(v) an advanced refillable personal vaporizer; \n(vi) an electronic pipe; and \n(vii) any component, liquid, part, or accessory of a device described in above."]

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}