TM 00102 AFC User Manual SAU
User Manual:
Open the PDF directly: View PDF 
.
Page Count: 342
| Download | |
| Open PDF In Browser | View PDF |
AvaTax for Communications Sales and Use User Manual Release: 9.19.1807.1 Document: TM_00102_0055 Date: 06/25/2018 Avalara for Communications - Contact Information Address Avalara, Inc. 512 South Mangum Street, Suite 100 Durham, North Carolina, 27701 Toll Free 800-525-8175 Corporate Site http://communications.avalara.com/ Comms Platform Site https://communications.avalara.net Email communicationsupport@avalara.com All trade names referenced herein are either trademarks or registered trademarks of their respective companies. © Avalara, Inc. 2018. CONFIDENTIAL Document Revision History The Revision History log lists the date and description of the most recent revisions or versions of the document. Date Version Description 03/25/2016 0028 04/25/2016 0029 05/25/2016 0030 06/24/2016 0031 07/25/2016 08/25/2016 09/23/2016 0032 0033 0034 10/25/2016 0035 11/23/2016 0036 12/22/2016 0037 01/27/2017 0038 02/24/2017 0039 03/24/2017 0040 04/25/2017 0041 05/25/2017 0042 06/27/2017 0043 07/27/2017 0044 Avalara branding updates to reflect the transition to the new company and product names have been incorporated into this document. Please see Appendix H – Avalara Product Names for specific changes in product references and descriptions. Updated with table of Tax Categories in Section 2.3. Additional release number and version updates throughout Section 8. Addition of 64, 160 and 172 as new tax types in Section 4.5 Tax Types. Additional release number and version updates throughout Section 8. Updates in Section 5.5.7 Customsort.exe to command line and arguments; Release number, version and header file updates throughout Section 8. Release number, version and header file updates throughout Section 8. Release number and version updates on cover and in Section 8.2 Release number, version and header file updates on the cover and throughout Section 8. Updated description in Section 3.1.4 Incorp. Release number, version and header file updates on the cover and throughout Section 8. Added new tax type 469 in Section 4.5 Tax Types. All references to ‘reverse’ tax calculations in the AFC engine have been updated and renamed to reflect the current naming convention which is ‘tax inclusive’ calculations. As a result, 6 APIs in Section 7.8.1 API Listings have been updated and renamed. Release number, version and header file updates on the cover and throughout Section 8. Added new tax types 470-472 in Section 4.5 Tax Types. Release number, version and header file updates throughout Section 8. Release number, version and header file updates on the cover and throughout Section 8. Also updated copyright year. Added new tax types 24 and 281 in Section 4.5 Tax Types. Release number, version and header file updates on the cover and throughout Section 8. Release number, version and header file updates on the cover and throughout Section 8. Updates to Section 4.7 Exclusions, Section 6.3 Federal or State Exclusion and Section 7.8.57 EZtaxSetStateExclusions. Release number, version and header file updates on the cover and throughout Section 8. Updated Section 6.2.3.1 Sales/Resale Flag. Release number, version and header file updates on the cover and throughout Section 8. All references to ‘Customer Mode’ in the AFC engine have been updated and renamed to reflect the current naming convention which is ‘Invoice Mode.’ As a result, 2 APIs in Section 7.8 API Listings have been updated and renamed. Also, added 2 new APIs, EZTaxJTTypeEx and EZTaxPTTypeEx, to support JCodes. Release number, version and header file updates on the cover and throughout Section 8. Added note related to timestamp/invoice date passed in Section 6.2.3.5 Invoice Date. Removed deprecated API, EZTaxJTType in Section 7.8 API Listings. Release number, version and header file updates on the cover and throughout Section 8. All trade names referenced herein are either trademarks or registered trademarks of their respective companies. © Avalara, Inc. 2018. CONFIDENTIAL Date Version Description 08/25/2017 0045 09/25/2017 0046 10/25/2017 0047 11/22/2017 0048 12/21/2017 0049 01/25/2018 0050 02/23/2018 0051 3/27/2018 0052 4/25/2018 0053 5/25/2018 0054 6/25/2018 0055 Release number, version and header file updates on the cover and throughout Section 8. Updated name and description for tax type 220, added 2 new tax types 488 and 489 in Section 4.3.5 Tax Types. Added new APIS, EZTaxGetCountry ID and EZTaxGetStateID in Section 7.8 API Listings. Release number, version and header file updates on the cover and throughout Section 8. Updated references to support site web site address in Section 8.7 Monthly Update Procedures. Updated Avalara contact information (address and support site). Removed Appendix H – Avalara Product Names. Release number, version and header file updates on the cover and throughout Section 8. Added tax type 492 in Section 4.5 Tax Types. Release number, version and header file updates on the cover and throughout Section 8. Release number, version and header file updates on the cover and throughout Section 8. Release number, version and header file updates on the cover and throughout Section 8. Updated the definition for surcharge in the table of Section 4.3.2 Returned Tax Information. Release number, version and header file updates on the cover and throughout Section 8. Added tax type 493 in Section 4.5 Tax Types. Release number, version and header file updates on the cover and throughout Section 8. Added new tax types (494 through 517) in Section 4.5 Tax Types. Release number, version and header file updates on the cover and throughout Section 8. Updates to transiaction specifications throughout Section 3. Release number, version and header file updates on the cover and in Section 8. Added new tax types (518 through 520) in Section 4.5 Tax Types. Release number, version and header file updates on the cover and in Section 8. All trade names referenced herein are either trademarks or registered trademarks of their respective companies. © Avalara, Inc. 2018. CONFIDENTIAL Table of Contents Introduction ....................................................................................................................................... 1 Installation .................................................................................................................................. 1 Getting Started............................................................................................................................ 1 The AFC Manual .......................................................................................................................... 1 Mapping ................................................................................................................................ 1 Transactions .......................................................................................................................... 2 Tax Calculations ..................................................................................................................... 2 Utilities .................................................................................................................................. 2 The Advantage of Using Functions ........................................................................................ 2 General Product Information ................................................................................................ 4 Mapping............................................................................................................................................. 6 Transaction and Service Types .................................................................................................... 6 Valid Transaction/Service Pairings .............................................................................................. 6 File transervdescsau.txt ......................................................................................................... 6 Tax Categories ............................................................................................................................. 7 Transactions....................................................................................................................................... 7 Customer Information................................................................................................................. 8 Customer Number ................................................................................................................. 9 Customer Type ...................................................................................................................... 9 Exemption Levels ................................................................................................................... 9 Incorp .................................................................................................................................. 10 Invoice Number ................................................................................................................... 10 JCode Exemption Levels ...................................................................................................... 10 Tax Type Exemptions ........................................................................................................... 10 Optional Fields ..................................................................................................................... 11 Company Information ............................................................................................................... 13 Company Identifier .............................................................................................................. 13 Transaction Data ....................................................................................................................... 13 Attribute .............................................................................................................................. 13 Properties ............................................................................................................................ 13 A F C S a l e s a n d U s e U s e r M a n u a l |i Copyright 2018 Avalara, Inc. Charge ................................................................................................................................. 14 Date ..................................................................................................................................... 14 Count ................................................................................................................................... 14 Sale Type ............................................................................................................................. 14 Service Type ........................................................................................................................ 15 Transaction Type ................................................................................................................. 15 Taxing Jurisdiction Identification Information ........................................................................... 15 The JCode Jurisdiction Identification ................................................................................... 15 Zip Codes ............................................................................................................................. 18 Zip Plus 4 ............................................................................................................................. 18 Canadian Postal Codes ........................................................................................................ 19 FIPS Codes ........................................................................................................................... 19 Support for India ................................................................................................................. 20 Jurisdiction Identification Details .............................................................................................. 22 Determining the Correct Taxing Jurisdiction for Wireline Long Distance ............................ 22 AFC Calculations............................................................................................................................... 24 Meeting the Requirements of Specific Tax Issues ..................................................................... 24 Tax Type Exemptions ........................................................................................................... 24 Tax Adjustments .................................................................................................................. 25 Tax Overrides....................................................................................................................... 26 Tax Rate Brackets ................................................................................................................ 32 Surcharges ........................................................................................................................... 33 Discount Adjustment ........................................................................................................... 33 Tier at Transactions ............................................................................................................. 36 Tax on Tax Until no Effect .................................................................................................... 36 Historical Tax Rates ............................................................................................................. 36 Taxed Taxes ......................................................................................................................... 36 Tax Logging ............................................................................................................................... 37 Returned Taxes ......................................................................................................................... 38 Returned Tax Information ................................................................................................... 38 Returned Tax Information Using Invoice Mode ................................................................... 39 A F C S a l e s a n d U s e U s e r M a n u a l | ii Copyright 2018 Avalara, Inc. Tax Grouping ....................................................................................................................... 39 Sales and Use ............................................................................................................................ 42 Sales Transaction Data Attributes and Properties ............................................................... 42 Freight On Board (FOB) Transaction Details ........................................................................ 42 Tax Data Structure ............................................................................................................... 44 Transaction and Service Types (Sales and Use) ................................................................... 45 Tax Types................................................................................................................................... 77 Nexus ........................................................................................................................................ 86 Exclusions .................................................................................................................................. 87 Utilities............................................................................................................................................. 89 Utility Selection ......................................................................................................................... 90 Reporting Utilities ................................................................................................................ 90 File Management Utilities ................................................................................................... 91 Specifying a Log File at Run Time .............................................................................................. 91 Log.sum File .............................................................................................................................. 92 General Tips When Using Utilities ............................................................................................. 92 AFC Utilities ............................................................................................................................... 94 asciilog.exe .......................................................................................................................... 96 batch_sau.exe ..................................................................................................................... 96 commerge.exe..................................................................................................................... 97 comptnum.exe .................................................................................................................... 98 comrpt.exe ........................................................................................................................ 101 csf20.exe ........................................................................................................................... 102 customsort.exe .................................................................................................................. 103 ezcomprep.exe .................................................................................................................. 104 ezlog_ns.exe ...................................................................................................................... 106 ezlogcust.exe ..................................................................................................................... 108 ezlogcustios.exe ................................................................................................................ 110 ezlogcustpts.exe ................................................................................................................ 112 ezlogcustptslnl.exe ............................................................................................................ 114 EZTaxappend.exe............................................................................................................... 116 A F C S a l e s a n d U s e U s e r M a n u a l | iii Copyright 2018 Avalara, Inc. EZTaxappendf.exe ............................................................................................................. 117 log no tax transactions ...................................................................................................... 118 srtcdf20.exe ....................................................................................................................... 121 srtcdf20p.exe..................................................................................................................... 123 srtcomcust20.exe .............................................................................................................. 125 srtcomma20.exe ................................................................................................................ 126 srtcomma20l.exe ............................................................................................................... 129 srtcomma20ld.exe ............................................................................................................. 132 srtcommadetail.exe ........................................................................................................... 135 srtrev20l.exe...................................................................................................................... 137 strg.exe .............................................................................................................................. 140 upsize_log.exe ................................................................................................................... 142 BATCH FILE PROCESSING................................................................................................................ 143 Batch Processing Description .................................................................................................. 143 AFC CDS Input File Specifications ............................................................................................ 145 Taxing Jurisdiction Identification Information ................................................................... 147 Customer Information ....................................................................................................... 148 Transaction Information .................................................................................................... 151 Federal or State Exclusion ....................................................................................................... 152 Accumulating the Log.............................................................................................................. 153 batch_sau Utility Specification ................................................................................................ 154 The C/C++ API ................................................................................................................................ 155 Language Interfaces for AFC ................................................................................................... 155 Configuration .......................................................................................................................... 156 Filelocs.txt File ................................................................................................................... 156 Filelocs.sta File................................................................................................................... 157 General Overview of AFC API Integration ............................................................................... 158 Detailed Discussion of AFC API Integration ............................................................................. 159 Tax Adjustments ................................................................................................................ 159 Obtaining Jurisdiction and Address Information From JCodes and PCodes ...................... 159 Obtaining Tax Information From Transactions .................................................................. 159 A F C S a l e s a n d U s e U s e r M a n u a l | iv Copyright 2018 Avalara, Inc. Preparing the AFC Application Programmer Interface (API) Interface .................................... 161 AFC API Function Calls ............................................................................................................. 162 Retrieving Taxes ................................................................................................................ 162 Multi-Threading ................................................................................................................. 164 Multiple Sessions ............................................................................................................... 166 Session Management ........................................................................................................ 166 Session Pooling .................................................................................................................. 168 Sample Coding ........................................................................................................................ 169 Using EZTaxGetRates to Build an Override ........................................................................ 169 EZTaxSetNexus .................................................................................................................. 170 Enhanced Override Structure Date Table and Rate Table Considerations ........................ 172 API Listings .............................................................................................................................. 173 EZTaxClearTSR ................................................................................................................... 174 EZTaxCountryToPCode ...................................................................................................... 175 EZTaxDBVersion................................................................................................................. 176 EZTaxDLLVersion ............................................................................................................... 177 EZTaxExitSessionEx ............................................................................................................ 178 EZTaxFlushToLogEx............................................................................................................ 179 EZTaxFreeRates ................................................................................................................. 180 EZTaxFtoPCodeEx .............................................................................................................. 181 EZTaxGetAddressEx ........................................................................................................... 182 EZTaxGetCountryID ........................................................................................................... 183 EZTaxGetCustomLog.......................................................................................................... 184 EZTaxGetCustomLogCount ................................................................................................ 185 EZTaxGetLogName ............................................................................................................ 186 EZTaxGetLogV914.............................................................................................................. 187 EZTaxGetLogV914Count .................................................................................................... 188 EZTaxGetNoTaxTrans......................................................................................................... 189 EZTaxGetStateID ................................................................................................................ 190 EZTaxGetRates................................................................................................................... 191 EZTaxGetTaxCatV98 .......................................................................................................... 192 A F C S a l e s a n d U s e U s e r M a n u a l |v Copyright 2018 Avalara, Inc. EZTaxGetTaxDescription .................................................................................................... 193 EZTaxGetTSR...................................................................................................................... 194 EZTaxGroupResults ............................................................................................................ 195 EZTaxInitEx ........................................................................................................................ 196 EZTaxInitExMt .................................................................................................................... 197 EZTaxInitV914 .................................................................................................................... 198 EZTaxInitV98 ...................................................................................................................... 199 EZTaxJtoPCodeEx ............................................................................................................... 200 EZTaxJTTypeEx (EZTaxJTType deprecated) ........................................................................ 201 EZTaxMaxTaxCount ........................................................................................................... 202 EZTaxNextAddressEx ......................................................................................................... 203 EZTaxNextCustomerEx....................................................................................................... 204 EZTaxOvrJCodeEx .............................................................................................................. 205 EZTaxOvrPCodeEx.............................................................................................................. 206 EZTaxOvrZipEx ................................................................................................................... 207 EZTaxPtoFipsEx .................................................................................................................. 208 EZTaxPtoJCodeEx ............................................................................................................... 209 EZTaxPTTypeEx .................................................................................................................. 210 EZTaxRestoreEx ................................................................................................................. 211 EZTaxSAUAdjFips ............................................................................................................... 212 EZTaxSAUAdjJCode ............................................................................................................ 213 EZTaxSAUAdjPCode ........................................................................................................... 214 EZTaxSAUAdjTaxInclusiveJCode (EZTaxSAUAdjRevJCode deprecated) ............................. 215 EZTaxSAUAdjTaxInclusivePCode (EZTaxSAUAdjRevPCode deprecated) ............................ 217 EZTaxSAUAdjTaxInclusiveZip (EZTaxSAUAdjRevZip deprecated) ...................................... 219 EZTaxSAUAdjZip................................................................................................................. 221 EZTaxSAUDRAdjFips........................................................................................................... 222 EZTaxSAUDRAdjJCode ....................................................................................................... 223 EZTaxSAUDRAdjPCode....................................................................................................... 224 EZTaxSAUDRAdjZip ............................................................................................................ 225 EZTaxSAUFips .................................................................................................................... 226 A F C S a l e s a n d U s e U s e r M a n u a l | vi Copyright 2018 Avalara, Inc. EZTaxSAUJCode ................................................................................................................. 227 EZTaxSAUPCode ................................................................................................................ 228 EZTaxSAUTaxInclusiveJCode (EZTaxSAURevJCode deprecated) ........................................ 229 EZTaxSAUTaxInclusivePCode (EZTaxSAURevPCode deprecated)....................................... 231 EZTaxSAUTaxInclusiveZip (EZTaxSAURevZip deprecated).................................................. 233 EZTaxSAUZip ...................................................................................................................... 235 EZTaxSessionDbVersion ..................................................................................................... 236 EZTaxSetInvoiceModeEx.................................................................................................... 237 EZTaxSetInvoiceModeV98 ................................................................................................. 238 EZTaxSetNexus .................................................................................................................. 239 EZTaxSetStateExclusions.................................................................................................... 240 EZTaxSetStateNexus .......................................................................................................... 241 EZTaxWriteToLogEx ........................................................................................................... 242 EZTaxWriteToLogV914 ...................................................................................................... 243 EZTaxZtoJCodeEx ............................................................................................................... 244 EZTaxZtoPCodeEx .............................................................................................................. 245 Appendices A - G ............................................................................................................................ 246 Appendix A EZTaxStruct.h ....................................................................................................... 247 Appendix B EZTaxDefine.h ...................................................................................................... 261 Appendix C EZTaxProto.h ........................................................................................................ 310 Appendix D EZTaxSauStruct.h ................................................................................................. 315 Appendix E EZTaxSauDefine.h ................................................................................................. 318 Appendix F EZTaxSauProto.h................................................................................................... 321 Appendix G Monthly Update Procedure ................................................................................. 325 Download the Monthly Update ......................................................................................... 325 Important Files in Update .................................................................................................. 328 Monthly Maintenance ....................................................................................................... 328 Help Guide .............................................................................................................................. 330 Troubleshooting ................................................................................................................ 330 FAQ’s ................................................................................................................................. 331 A F C S a l e s a n d U s e U s e r M a n u a l | vii Copyright 2018 Avalara, Inc. Introduction Installation Refer to the AvaTax for Communications (AFC) Installation Manual for complete instructions regarding the installation of AFC on your specific platform. Getting Started There are several AFC integration methods available, each allowing for its use based on the client’s needs. • AFC SaaS Standard: This method is provided for lower transaction-count customers, allowing for the use of AFC to obtain tax calculations without having to maintain the program on their systems. • On-Site Options: AFC's API interface: provides the user complete control over access to tax calculations and the data returned, along with the flexibility supported by the report utilities. • AFC SaaS Pro: AFC SaaS Pro is an XML web service used to calculate taxes. Applications send a single transaction to the AFC SaaS web service over the Internet. The taxes are calculated and immediately returned to the client application. Users have the capability of sending and receiving transactions 24 hours a day, 7 days a week. This service is ideal for adding the ability to tax purchases made from online stores and AFC SaaS Pro customers are provided with reports for tax compliance filing. The AFC Manual The AFC Manual has been configured to provide an easy and logical progression for learning AFC and its features, as well as a quick reference (fully linked on the electronic version of the manual). From the initial step of mapping to the final creation of reports based on the processed information, the conceptual simplicity of AFC is fully explained. Mapping Prior to performing tax calculations, client transactions and services must be matched, or “mapped,” to the Valid Transaction and Service Pairings defined in AFC. Refer to Section 2 Mapping for the full explanation of how this is accomplished. A F C S a l e s a n d U s e U s e r M a n u a l | 1 of 329 Copyright 2018 Avalara, Inc. Transactions Once the transactions and services have been mapped, transaction records can be passed to AFC. Section 3 Transactions explains what AFC expects for each part (or field) contained in a transaction record and provides the definitions and reasons for selecting one of the valid options to use. Tax Calculations The AFC Engine accepts the transaction record(s) and performs the tax calculations based upon the information within the record. Utilities Once the taxation has been performed, Utilities can be used to provide the tax information in selected formats that meet specific requirements and perform file management functions. The many options available are detailed in the Utilities section of this document. The Advantage of Using Functions Section 7 provides specific details of the expanded capabilities provided to users that integrate AFC to the billing system using functions. Refer to the figure shown below. The billing system passes information to AFC, as calls are being rated for billing. AFC calculates all required taxes and returns the tax information to the billing system per transaction. In addition, AFC stores all tax data generated in its databases and provides reports that facilitate tax filing and provide insight to the rating, billing and taxing processes. A F C S a l e s a n d U s e U s e r M a n u a l | 2 of 329 Copyright 2018 Avalara, Inc. Figure 1-1 AFC Operation Diagram Adjustment information is returned to the billing system and is utilized to update tax data for report generation and compliance filing. AFC also provides facilities that allow users to insert tax overrides and exempt a transaction from taxes at federal, state, county and local authority levels. AFC also provides the capability to limit exemptions to a specific jurisdiction and to exempt specific taxes. Using the AFC API is the most efficient method available for interfacing with the AFC system. Due to the superior performance of AFC, there is very little performance difference between a system running without taxation and one running with taxation generation by AFC. A F C S a l e s a n d U s e U s e r M a n u a l | 3 of 329 Copyright 2018 Avalara, Inc. General Product Information Enhanced Flexibility for Users User reporting and organizational activities have been enhanced with the addition of user defined fields. This empowers the user to include additional user specific information within transaction records, thereby enhancing reports and data files once processed by the AFC Engine. Note that the Batch Processing utility takes full advantage of the additional transaction fields. Enhanced Capabilities for Processing Specialized Taxes AFC maintains tax rate histories and applies them according to the transaction date. This allows for tax calculations to process transactions that require dated tax information. Billable Flag – Allows for the identification of a compliance only tax or fee that is used for filing and not passed on to the user. It is noted as a non-billable item in the tax log. Compliance Flag – Allows for the identification of a tax or fee that is a tax compliant item and that the tax or fee should be sent to the log. The reporting utilities can identify and generate compliance and billing reports. All existing taxes currently in AFC are compliance taxes or fees. A charge with the compliance set to false in logic is billable but the charge would not be place into the log for compliance or reported in compliance reports. This flag provides EZdata users with the ability to pass non-tax charges to the customer through AFC. Rate at Final - Allows for a specialized application of tax brackets. Each bracket specifies the tax rate for the “Total Tax” range that it spans. The culmination of all of the brackets results in a tax rate “look-up” table for total transaction amounts. Tier At Transaction - This logic flag indicates that tax will be calculated using graduated tax brackets on a transaction basis instead of a customer invoice basis. Tax On Tax Until No Effect - Configuration settings in EZTax.cfg determine one of two methods to calculate Tax on Tax. If the configuration setting is left unchanged, AFC will perform a single iteration of the tax on tax calculation. Additional Functions to Support New Capabilities The Get Rates function has been added to retrieve all possible taxes when given a location by PCode. The structure of the returned tax information is compatible with the new override structure, so that specific changes can be applied to the existing tax data to create override entries. A F C S a l e s a n d U s e U s e r M a n u a l | 4 of 329 Copyright 2018 Avalara, Inc. New Version Tracking A version number has been embedded into the AFC database to ensure database compatibility between the AFC software and the AFC database. The AFC Engine compares version numbers on session initialization. If incompatible version numbers are detected, a message is written to the status file and AFC system will not return a valid session handle. Additional Tax Types AFC now supports over 450 Tax Types to allow for highly specific tax type designation. Increased Accuracy The Tax Amount calculations have been modified to increase accuracy and further reduce rounding errors. A F C S a l e s a n d U s e U s e r M a n u a l | 5 of 329 Copyright 2018 Avalara, Inc. Mapping The AFC software provides an extensive selection of Transaction and Service Types to meet your taxation requirements with a single taxation package. The correct matching, or “mapping,” of your company products and services to the Valid Transaction and Service Pairings defined in AFC is an essential process that must be completed accurately for taxation to be calculated and applied properly to all transactions. If an incorrect pairing is passed to the AFC engine then no tax is usually returned. Avalara support is available to assist should any questions arise in determining the correct Transaction and Service pair to use. Transaction and Service Types AFC stipulates a unique pair of numbers for each Transaction and Service Type. The first number defines the Transaction Type and the second number defines the Service Type. Transaction Types and Service Types are combined (or “paired”) to uniquely describe a Valid Transaction / Service Pair for a transaction. Valid Transaction/Service Pairings Section 4.4.6 describes valid transaction/service pairings. Avalara continuously evaluates products and services offered by companies and may add Transaction and Service Type combinations to accommodate products and services offered. For the most current list of Transaction Types, refer to the Transaction Mapping Guidelines.pdf file located on your most recent Distribution/Update. File transervdescsau.txt A file named transervdescsau.txt is present in the database directory in each month’s update. This file contains all of the valid transaction type/service type pairs, with the description of those types and of the pairing. It is a fixed format file, though there are spaces and commas between some of the fields for readability. It is described in the table below. transervdesc.txt File Format Key Description Alternate Flag Market Number Market Name Columns 1-1 3-4 6-35 A F C S a l e s a n d U s e U s e r M a n u a l | 6 of 329 Copyright 2018 Avalara, Inc. transervdesc.txt File Format Key Description Transaction Type Number Transaction Type Description Service Type Number Service Type Description Long Description Columns 38-39 41-90 93-95 97-146 148-end of line Tax Categories Please reference the table below for a current list of Tax Categories. Tax Categories Category ID 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Name No Category Description Sales and Use Taxes Business Taxes Gross Receipts Taxes Excise Taxes Connectivity Charges Regulatory Charges E-911 Charges Utility User Taxes Right of Way Fees Communications Services Tax Cable Regulatory Fees Reserved Value Added Taxes Transactions AFC accepts transaction records from the user and returns calculated taxes. For AFC to return the correct taxation the information in the transaction records must be correct and in the format that AFC requires. Each Transaction contains the following information: 1. Customer Transaction Information a. Customer Information b. Company Information c. Transaction Data 2. Taxing Jurisdiction Information A F C S a l e s a n d U s e U s e r M a n u a l | 7 of 329 Copyright 2018 Avalara, Inc. The Customer Transaction Information has been divided into three sections as suggested above for the purpose of this discussion (see the table below). Customer Transaction Information Customer Information County Exempt County Exemption JCode Customer Number Customer Type Exemption Type Federal Exempt Federal Exemption JCode Incorp Invoice Number Local Exempt Locality Exemption JCode Tax Type Exemptions State Exempt State Exemption JCode Optional fields Company Information Company Identifier Transaction Data Attribute Charge Count Properties Sale/Resale Service Type Transaction Bill Date Transaction Type Customer Information Refer to the table below. The following customer information is contained in fields found in the transaction record. Customer Information Description Customer Number Customer Type Federal Exempt State Exempt County Exempt Locality Exempt Incorp Invoice Number Federal Exemption JCode State Exemption JCode County Exemption JCode Locality Exemption JCode Tax Type Exemptions Count Tax Type Exemptions Exempt Type Optional Fields: Optional Optional Alpha Valid Entry Customer number, user defined 0=residential, 1=business customer 2=Senior Citizen, 3=Industrial If TRUE, transaction exempt from Federal Tax If TRUE, transaction exempt from State Tax If TRUE, transaction exempt from County Tax If TRUE, transaction exempt from local tax TRUE indicates within incorporated area Invoice number (user defined) Jurisdiction for Federal exemption Jurisdiction for state exemption Jurisdiction for County exemption Jurisdiction for local exemption 0 indicates no of specific exempts, other value indicates number of specific exempts Pointer to tax exempt structure that contains the specific tax exemptions specified in tax type exemptions Reason for exemption User defined value for reporting Optional alpha field A F C S a l e s a n d U s e U s e r M a n u a l | 8 of 329 Copyright 2018 Avalara, Inc. Customer Information Description Optional 4 Optional 5 Optional 6 Optional 7 Optional 8 Optional 9 Optional 10 Valid Entry Optional Numeric field Optional Numeric field Optional Numeric field Optional Numeric field Optional Numeric field Optional Numeric field Optional Numeric field Customer Number The Customer Number is a 20-character null terminated string field stored in the tax log and used as the Primary Output Key for the AFC billing reports. Customer Type This field is used to specify the type of customer involved in the transaction. The customer type is selected from one of the following four Customer Types. Customer Type ID 0 1 2 Value Residential Business Senior Citizen 3 Industrial Description When transactions are made by a customer for home use. When transactions are made at a place of business When transactions are made by a customer who meets the jurisdiction requirements to be considered a senior citizen and qualify for senior citizen tax breaks. When transactions are made at an industrial business. Exemption Levels The exemption level is the jurisdictional level of the taxing authority that defines the tax. It is used to exempt taxes at specific state, county and/or local taxes. State Exempt The State Exempt field is used to specify a State level tax exemption. County Exempt The County Exempt field is used to specify a County level tax exemption. Local Exempt The Local Exempt field is used to specify a Local level tax exemption. A F C S a l e s a n d U s e U s e r M a n u a l | 9 of 329 Copyright 2018 Avalara, Inc. Incorp The Incorp field is used to specify whether the customer involved in this transaction is inside or outside of the Local level designated as their location. The tax may or may not be affected by this designator depending upon whether or not the local level has taxes which would apply to the transaction/service type pair. Invoice Number The Invoice Number is an optional field used to aid users in uniquely identifying a billing record for a specific customer within their system. JCode Exemption Levels The exemption JCode is the JCode associated with the jurisdictional level of the taxing authority that defines the tax. It is used to exempt all federal, state, county and / or local taxes. If the exemption JCode fields are not specified then all taxes are exempt at that level. To pass an individual tax exemption using the JCode Exemption, use the Tax Exempt structure to specify the tax type, tax level and the JCode for the jurisdiction. Refer to Section 4.1.1.2. NOTE: JCodes are an internal intermediate Jurisdiction Code that can change monthly. The JCode can be obtained from a PCode or an address using like functions. Tax Type Exemptions Two fields are provided for entering the quantity of tax type exemptions and the pointers to the tax exemption structures. Tax Type Exemptions Field The Tax Type Exemption indicator specifies the number of tax type exemptions that are included. These are tax type and transaction specific exemptions. Tax Type Exemption Pointer Tax type exemption(s) are specified with a pointer to one or more tax exempt structures. The user should supply a pointer to the first tax type exemption and all exemptions must be contained in a contiguous block of memory. A F C S a l e s a n d U s e U s e r M a n u a l | 10 of 329 Copyright 2018 Avalara, Inc. Exemption Type The reason for the exemption. This value is passed directly on to the log. Optional Fields Optional Fields are provided to allow clients to enhance reporting and billing utilities with information beyond the scope of that which is generated to support AFC activities. The Customer Number is a 20-character text field that is not manipulated during processing and stored as part of the log file record. It can be used as part of the sorting key (see Figure 3-1) when using some utilities, allowing for the combining of records based upon this and other fields. It is useful when it is desired to have like taxes from different transactions combined, to have taxes from each transaction detailed individually in a report or to have each transaction detailed at the customer level. A F C S a l e s a n d U s e U s e r M a n u a l | 11 of 329 Copyright 2018 Avalara, Inc. Figure 3-1 Primary Output Key Uniquekey.csf Combined taxes If you would want like taxes combined at the customer level, then you specify a like Primary Output Key for the records you want combined. Samekey.csf A F C S a l e s a n d U s e U s e r M a n u a l | 12 of 329 Copyright 2018 Avalara, Inc. Company Information Refer to Table 3-3. The following company information is contained in fields found in the transaction record. Table 3-1 Company Information Description Company Identifier Valid Entry Company Identifier, optional Company Identifier The Company Identifier field is an optional field made available for alpha information, such as the name of a subsidiary company. This information is passed thru to the tax log so that reporting utilities can sort or summarize by this field. Transaction Data Refer to Table 3-4. The following transaction information is contained in fields found in the transaction record. Table 3-2 Transaction Data Information Description Attribute Properties Charge Date Count Sale/Resale Service Type Transaction Type Valid Entry Freight, deposits, etc. Parameters describing the attribute. amount charged to customer for transaction Transaction bill date. This field is provided to allow rating and taxing to occur on a date other than the billing date. Number of items TRUE = Sale, FALSE = Resale Refer to Transaction and Service Types (Sales & Use) for valid Transaction / Service Type entries Refer to Transaction and Service Types (Sales & Use) for valid Transaction / Service Type entries Attribute The Attribute field refers to ancillary transactions related to the actual sale – freight, discounts, financing, installation, shipping/handling, maintenance and service contracts, and warranties. Properties Properties specify the details of the transaction’s Attribute. A F C S a l e s a n d U s e U s e r M a n u a l | 13 of 329 Copyright 2018 Avalara, Inc. Charge The Charge field specifies the amount of the transaction to be taxed. This amount will be passed through AFC to rate the tax based on the specified transaction/service pair. Date The Date field is normally populated with the bill date. Generally accepted accounting principles dictate that liabilities should be recorded when revenues are recorded. In most cases, neither of these is recorded (or even known) until billing occurs. However, companies with a high call volume that record revenue daily as it occurs should record the tax on the same basis (i.e. the call date should be used). AFC compares this date to the effective date of each tax that applies to the transaction. Historical rates and effective dates are maintained and updated within the AFC Engine and AFC will return the correct tax information based upon the transaction date. The monthly updates assure that the rates and effective dates are current. WARNING: All transaction data Date fields must be formatted as CCYYMMDD. Failure to do so will cause incorrect results when the transaction is processed. Count Number of items in the sale. Sale Type The following options are available as sales type: Sales Type ID 0 Value Wholesale 1 2 3 Retail Consumed Vendor Use Description Specifies that the transaction is a sale to another company that will resell the product or service to a consumer. Specifies that the transaction is a sale to an end user. Specifies that the transaction is for an item that is consumed directly. Specifies that the transaction is for an item that is subject to vendor use tax. A F C S a l e s a n d U s e U s e r M a n u a l | 14 of 329 Copyright 2018 Avalara, Inc. Service Type Refer to Transaction and Service Types for details of this field. Transaction Type Refer to Transaction and Service Types for details of this field. To have exempt taxes available for reporting, exemption type 3 (Sales For Resale) should be used in combination with Resale. Taxing Jurisdiction Identification Information The tax jurisdiction that can claim nexus for the transaction must be obtained in order for the proper taxes to be applied. Assigning the correct jurisdiction to the transaction is crucial in obtaining and returning the correct tax to the billing system. Jurisdiction information can be supplied to the AFC Engine in several ways. It can be supplied using a Jurisdiction Code (JCode), Permanent (location) Code (PCode), Zip Code with address information or FIPS Codes. The JCode Jurisdiction Identification Avalara has assigned each jurisdiction with a proprietary “JCode” (Jurisdiction Code) that identifies its specific territorial boundaries. A jurisdiction fairly claiming nexus on a transaction within this boundary will apply taxes accordingly. The AFC Engine uses this “jurisdiction bound” JCode to associate the jurisdiction specific taxes to the transaction as it is processed. However, any alterations in the jurisdictional boundaries, such as an expansion of a city limit, will be reflected in the JCode of locations that are situated within the expanded jurisdiction area. The Avalara tax research staff monitors jurisdiction taxation activity to maintain current and accurate taxation information. The results of this research is applied to the Monthly updates which are provided to ensure the most accurate taxation is applied to the records processed by the AFC Engine. The JCodes will be changed at this time. It is the user’s responsibility to re-populate their database tables with the new JCodes every time an AFC update is provided. If this task is not performed, the AFC Engine will return incorrect tax calculations for jurisdictions that have been updated. However, when a transaction is submitted with the stable and location sensitive PCode, the AFC Engine can use internal functions to obtain the correct jurisdiction. Since the AFC Engine is updated with the remapped jurisdiction information monthly, tax calculations are always performed with the most current jurisdiction taxation information that applies to the address defined by the PCode. A F C S a l e s a n d U s e U s e r M a n u a l | 15 of 329 Copyright 2018 Avalara, Inc. Figure 3-2 JCode and PCode Changes During Annexation MOM'S HOUSE PCODE = 8 JCODE = 2000 MY HOUSE PCODE = 7 JCODE = 1000 MY TOWN CITY LIMIT JCode and PCode Prior to Annexation MY HOUSE PCODE = 8 JCODE = 2000 MOM'S HOUSE PCODE = 8 JCODE = 2000 MY TOWN CITY LIMIT JCode and PCode After Annexation All that is required to make use of this recommended option is to cross reference or “map” the customer locations with its correct PCode. The time invested in incorporating PCodes into your database records will be quickly offset by the reduced processing time and the increased accuracy and reliability of your tax reporting will be evident. Mapping Customer Locations to PCodes Avalara markets Avalara Geo for Communications to assist in mapping customer locations to PCodes when populating the client customer database. It quickly obtains the current PCode for a specific geographical location. When performing this task without the aid of EZgeo®, refer to the all_adr.txt file to look up the PCode that should be used to populate the client database with customer information. This comma delimited ASCII file is supplied for use during AFC setup and when adding new customers to the client database. The file is replaced with a current version when monthly updates are performed (refer to Section 8.6). all_adr.txt is a comma-delimited text file that contains a cross reference of PCodes to taxing jurisdictions. The format is PCode, Primary / Alternate Location, Country, State, County, Locality, Beginning ZIP Code, Ending ZIP Code. These fields are self-explanatory with the exception of the Primary / Alternate Location (refer to 3.4.1.1.1). Primary / Alternate Location The Primary / Alternate location flag is set to '0' to indicate that the location associated with the PCode is a "Primary" location or '1' to indicate that it is an "Alternate" location. A F C S a l e s a n d U s e U s e r M a n u a l | 16 of 329 Copyright 2018 Avalara, Inc. Secondary locations are original city names that remain in use even though the areas within them have since been divided and given different names. For example, the city of Overland Park, KS is a primary location. The first post office to serve the area was established at the Shawnee Methodist Mission in the early nineteenth century, the extents of which encompassed the then non-existent city of Overland Park as well as nearly a dozen other cities (primary locations) which appeared over time. The post office still recognizes the Shawnee Methodist Mission area as Shawnee Mission, KS, and continues to deliver to a primary location when the “Alternate Location” address is provided. Data Entry Modification Procedure Use the following procedure to acquire the correct information to enter. 1. Have the customer data entry software request the zip code of the customer from the data entry associate. 2. Query the "all_adr" file/database to obtain the associated PCodes. 3. If matching PCodes are found, populate the customer data record with the associated address from the "all_adr" file and request verification from the customer data entry associate. 4. If the PCodes do not match or if the customer data entry associate rejects the automated selection, display all addresses associated with both PCodes and the zip code entered. 5. Allow the customer data entry associate to select the appropriate address from the list. 6. In the unlikely event that the customer address is not displayed, allow the customer data entry person to enter the address supplied by the customer. Store the address with a "special key" as instructed by Avalara. Return the address and key to Avalara via E-mail. Avalara will research the missing address and include it in the next monthly update. Avalara will also provide you with a cross reference of the "special key" and the correct "PCode" to allow the customer record to be properly installed. NOTE: Avalara subscribes to the United States Postal Database which should preclude this event. Nonetheless, it does occur on occasion and this process has been established for that reason. 7. Use the PCode from the customer record for the service address when interfacing with AFC. A F C S a l e s a n d U s e U s e r M a n u a l | 17 of 329 Copyright 2018 Avalara, Inc. Resources such as the USPS or the U.S. Census Department web sites can also be helpful in pinpointing a customer location. AFC functions can also be used to obtain PCodes (see Section 7.8 API Listings). For detailed information about determining the tax jurisdiction which can claim nexus on a transaction, refer to Section 3.1.3 for details on exemption levels. Zip Codes This method of providing jurisdiction information is the least efficient method provided. A record submitted using this method will compromise the accuracy of correct jurisdiction identification, the degree of which would depend upon the amount of data provided for the address and the user’s ability to select the correct taxing jurisdiction zip code and address. AFC databases necessarily contain numerous duplicate zip codes that cross taxing jurisdiction and locality boundaries. Providing a complete address with zip code will provide the best possible match. If the address information is not provided, AFC will return taxes based upon the first match of the input record information. If the jurisdiction is positively identified by the billing system it would be appropriate to use the zip code for transactions. For instance, this would apply if the transaction is the sale of a product at a business that has just one location or in the case of internet usage from a residence. AFC currently has Zip Code information for U.S. and Canadian jurisdictions. Use the Zip Code Plus 4 Interface to use the 6 character Canadian postal codes. Zip Plus 4 Just as with the Zip Code method (see Section 3.4.2), AFC’s jurisdiction determination will depend on the address information provided. However, it is useful (and more accurate than the 5-digit zip code) because this 9-digit zip code uniquely identifies a location, which can then be used to determine the tax jurisdiction. There is no need to supply the additional city and county information and information in these fields are ignored. NOTE: Supplying ZIP Code Plus 4 information where the plus 4 is all zeros will function like the ZIP Code Interface since the United States Postal Service has no valid plus 4 code assigned with all zeros. The default will retrieve the first jurisdiction with the supplied 5-digit zip code. A F C S a l e s a n d U s e U s e r M a n u a l | 18 of 329 Copyright 2018 Avalara, Inc. Canadian Postal Codes Canadian postal codes need to be specified using the ZIP Plus 4 to retrieve a tax jurisdiction code. Place the first three characters go in the zip code field and the last three characters go in the plus 4 field. In addition, the country ISO field must be set to the Canadian ISO Code. FIPS Codes AFC has functions allowing the use of FIPS codes to retrieve tax jurisdiction codes. The US Census Bureau provides the following description of the FIPS Codes and associated reference tables. “The Federal Information Processing Standards codes (FIPS codes) are a standardized set of numeric or alphabetic codes issued by the National Institute of Standards and Technology (NIST) to ensure uniform identification of geographic entities through all federal government agencies. The entities covered include: states and statistically equivalent entities, counties and statistically equivalent entities, named populated and related location entities (such as, places and county subdivisions), and American Indian and Alaska Native areas”. A FIPS Code is a 10-digit numeric code with the following format: Table 3-3 FIPS CODE FORMAT SS CCC PPPPP SSCCCPPPPP FIPS State Code FIPS County Code FIPS Place Code Figure 3-3 FIPS State Codes for the States and the District of Columbia Name Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana FIPS State Numeric Code 1 2 4 5 6 8 9 10 11 12 13 15 16 17 18 19 20 21 22 FIPS State Alpha Code AL AK AZ AR CA CO CT DE DC FL GA HI ID IL IN IA KS KY LA Name Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah FIPS State Numeric Code 30 31 32 33 34 35 36 37 38 39 40 41 42 44 45 46 47 48 49 FIPS State Alpha Code MT NE NV NH NJ NM NY NC ND OH OK OR PA RI SC SD TN TX UT A F C S a l e s a n d U s e U s e r M a n u a l | 19 of 329 Copyright 2018 Avalara, Inc. Figure 3-3 FIPS State Codes for the States and the District of Columbia FIPS State Numeric Code 23 24 25 26 27 28 29 Name Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri FIPS State Alpha Code ME MD MA MI MN MS MO FIPS State Numeric Code 50 51 53 54 55 56 Name Vermont Virginia Washington West Virginia Wisconsin Wyoming FIPS State Alpha Code VT VA WA WV WI WY Figure 3-4 FIPS State Codes for the Outlying Areas of the United States, the Freely Associated States and Trust Territory FIPS State Numeric Code 60 FIPS State Alpha Code AS Federated States of Micronesia 64 FM 3 Guam 66 GU 1 Marshall Islands 68 MH 3 Northern Mariana Islands 69 MP 1 Palau 70 PW 4 Puerto Rico 72 PR 1 Virgin Islands of the U.S. 78 VI 1 Area Name American Samoa Status 1 Support for India Processing tax calculations in the the country of India includes support for all the states. Please reference the table below for the appropriate IDs, abbreviations and PCodes for each state. Note: This only applies to telecom support for India; however, it is visible to SAU clients. States in India Ctry Code ISO State Id Abbv State PCODE 356 IND 1 AP Andhra Pradesh 5148401 356 IND 2 AR Arunachal Pradesh 5148402 356 IND 3 AS Assam 5148403 356 IND 4 BR Bihar 5148404 356 IND 5 CT Chhattisgarh 5148405 A F C S a l e s a n d U s e U s e r M a n u a l | 20 of 329 Copyright 2018 Avalara, Inc. States in India Ctry Code ISO State Id Abbv State PCODE 356 IND 6 GA Goa 5148406 356 IND 7 GJ Gujarat 5148407 356 IND 8 HR Haryana 5148408 356 IND 9 HP Himachal Pradesh 5148409 356 IND 10 JK Jammu and Kashmir 5148410 356 IND 11 JH Jharkhand 5148411 356 IND 12 KA Karnataka 5148412 356 IND 13 KL Kerala 5148413 356 IND 14 MP Madhya Pradesh 5148414 356 IND 15 MH Maharashtra 5148415 356 IND 16 MN Manipur 5148416 356 IND 17 ML Meghalaya 5148417 356 IND 18 MZ Mizoram 5148418 356 IND 19 NL Nagaland 5148419 356 IND 20 OR Odisha 5148420 356 IND 21 PB Punjab 5148421 356 IND 22 RJ Rajasthan 5148422 356 IND 23 SK Sikkim 5148423 356 IND 24 TN Tamil Nadu 5148424 356 IND 25 TG Telangana 5148425 356 IND 26 TR Tripura 5148426 356 IND 27 UP Uttar Pradesh 5148427 356 IND 28 UT Uttarakhand 5148428 356 IND 29 WB West Bengal 5148429 A F C S a l e s a n d U s e U s e r M a n u a l | 21 of 329 Copyright 2018 Avalara, Inc. States in India Ctry Code ISO State Id Abbv State PCODE 356 IND 30 AN Andaman and Nicobar 5148430 356 IND 31 CH Chandigarh 5148431 356 IND 32 DN Dadra Nagar Haveli 5148432 356 IND 33 DD Daman and Diu 5148433 356 IND 34 DL Delhi 5148434 356 IND 35 LD Lakshadweep 5148435 356 IND 36 PY Puducherry 5148436 Jurisdiction Identification Details Obtaining the correct user’s location is critical in calculating the local taxation. Determining the Correct Taxing Jurisdiction for Wireline Long Distance AFC applies taxes to transactions based on the statutes that dictate specific taxes per jurisdiction. Each jurisdiction from the state level down to the local level establishes jurisdiction rules to determine if their tax will apply to a specific call transaction. These jurisdiction rules (also known as sourcing rules) for determining the correct jurisdiction arose from a United States Supreme Court ruling that established the minimum requirements necessary for a taxing jurisdiction to claim “nexus”. Incorrect Jurisdiction Assignment A customer may be assigned an incorrect jurisdiction if the geographical information is not thoroughly researched. In the example shown in Figure 3-6, the customer (marked by an X) resides in a rural area located in Pawnee County, Nebraska, just outside the city limits of Summerfield, Kansas. Figure 3-5 Geographical Anomaly A F C S a l e s a n d U s e U s e r M a n u a l | 22 of 329 Copyright 2018 Avalara, Inc. However, in all likelihood this customer’s mail service is provided by the Summerfield, Kansas Post Office and therefore has a Summerfield, Kansas mailing address. This geographical anomaly will cause an incorrect assessment of taxation if not researched properly. If the AFC user enters the customers Service Address information into the transaction records, the customer will be incorrectly assessed taxes according to those of the Summerfield, Kansas jurisdiction instead of those for the unincorporated area of Pawnee County, Nebraska jurisdiction. A F C S a l e s a n d U s e U s e r M a n u a l | 23 of 329 Copyright 2018 Avalara, Inc. AFC Calculations The AFC Engine accepts the transaction record, processes the information provided and creates a table containing the generated tax information. Additional methods to process specialized taxes are available through the use of AFC functions. Meeting the Requirements of Specific Tax Issues Many tax issues are resolved within the AFC Engine, thereby relieving the user from making changes to account for them. Additional functions are provided to meet other special taxation issues. Table 4-1 Specific Tax Issues Category Specific Tax Exemptions Tax Adjustments Tax Overrides Tax Rate Brackets Rate at Final Discount Adjustment Tier on Transaction Tax on Tax Until no Effect Taxed Taxes Get Rates Description Specifies tax type at specific tax level for exemption Allow for adjustment activities such as refunds, changing a customer’s bill or when terminating un-collectable accounts. Allows for a change of a tax rate. Tax rate that changes as the taxable amount of the transaction increases. A specialized case of tax brackets. Allows for entry of different discount adjustment types. Allows for tax to be determined using graduated tax brackets. Option to control calculation of tax on tax Allows for processing when one tax includes in its base the tax calculated from another tax. Retrieves current tax information in a form suitable for overrides. Tax Type Exemptions Tax type exemptions are used to specify a specific Tax Type at a specific Tax Level to be exempted for the current transaction. The exemption jurisdiction code specifies the jurisdiction for the tax exemption. If the jurisdiction code is not specified (i.e. set to zero), then all taxes of the Tax Type and Tax Level specified are considered exempt regardless of the jurisdiction they are calculated for. Typically the JCode should be specified as specific tax exemptions are normally only effective for specific jurisdictions. Another option allows the tax type to be set to zero, to indicate that all taxes of a specific tax level are exempt in the specific jurisdiction. Declaring Tax Type Tax Exemptions within a Transaction Record When setting up the AFC transaction record, there are fields that specify either exempt at a tax level or a specific tax. For more information, refer to Sections 3.1.3 for exemption levels, 3.1.6 for JCode exemption levels and 3.1.7 for tax type exemption levels. A F C S a l e s a n d U s e U s e r M a n u a l | 24 of 329 Copyright 2018 Avalara, Inc. Declaring Tax Type Exemptions Using Functions Alternatively, tax type exemptions can be applied using functions (such as APIs). The following fields are required for this. Table 4-2 Tax Exempt Record Tax Type Tax Level JCode for Exemption Tax Type identifier Tax Level identifier Jurisdiction for exemption In addition, the transaction contains a pointer set to the tax exempt to exempt a specific tax. Table 4-3 Tax Exemption Fields tax_exempt *s_exempt Identifies the number of exemption records Pointer to the Tax Exempt record (see Table 4-2) or Array of Tax Exempt records. If no records are setup, this value should be null. General Tips When Declaring Tax Exemptions 1. The JCode is used to specify tax exemptions because exemptions are normally only effective for specific jurisdictions. 2. Some taxes are non-exemptible. Non-exemptible taxes may be overridden to exempt taxes that are normally not exemptible. Refer to Section 4.1.3 for more information on Tax Overrides. 3. It is easy to evaluate the exemptions passed through AFC because they are tracked separately and stored in the tax log by type of exemption. Tax Adjustments Tax adjustment functions provide for adjustment activities such as refunds, changing a customer’s bill or writing off un-collectable accounts. The AFC engine allows adjustments to be passed by the user. Note that these adjustments must be accounted for to provide an audit trail. Tax adjustments are made using the Adjustment functions. The tax amount entered should be a positive number for credit adjustments as the adjustment functions will appropriately sign the charges, lines or locations for computation purposes. The adjustments are logged in the EZTax.log along with the rest of the tax and transaction data associated with the tax run. The information is returned to the billing system and is utilized to update tax data for report generation and compliance filing. Adjustments may be declared as ‘default’ in which case they are processed exactly like a similar charge transaction with negative tax results. They may be declared as least or most favorable. This declaration is only useful for taxes which have multiple tiers or brackets and should be used with caution. The rate will be determined separately for each tax returned within the tax table. AFC software will search the tiers or brackets and select the tier which has either the highest rate (for most favorable) or lowest rate (for least favorable) and apply that rate to the number of lines or charge amount as appropriate. A F C S a l e s a n d U s e U s e r M a n u a l | 25 of 329 Copyright 2018 Avalara, Inc. NOTE: Debit and credit transactions will generate different taxes if otherwise identical transactions are processed with the same least/most favorable flag. To reverse a most favorable credit adjustment the exact transaction should be sent as a debit adjustment with a least favorable flag. General Tips When Making Tax Adjustments 1. To calculate adjustments accurately, AFC requires the following activity: a. Call AFC using an adjustment API. (Please refer to the APIs provided in Section 7.8 API Listings). b. Send positive values for change, line, and locations. c. Set the adjustment method (see the Adjustment Method Table below). d. Set the discount type (see the Discount Type Table in Section 4.1.6). 2. If logging is turned on, adjustments are stored in the eztax.log file with the other transactions. Adjustment Method Table Name Default LeastFavorableRate MostFavorableRate Description Tax brackets applied normally. Tax brackets applied to produce smallest tax refund. Tax brackets applied to produce largest tax refund. Tax Overrides Overrides allow the client to change the rate of a tax in the AFC Engine. Avalara markets the AFC Manager - Rate and Logic Modifier (a Graphic User Interface based Windows program that is sold separately) to support this activity. It steps the user through the process of creating an EZTax.ovr file. Alternatively, overrides can be achieved using the Override functions (such as APIs). WARNING: An override to exempt taxes OVERRIDES the tax information in Avalara’s tax research database. This is not recommended for those that do not possess a full understanding of the tax ramifications and liabilities when doing so. Although all clients can use Tax Overrides, the method to make use of them depends upon the client type. 1. AFC SaaS Standard clients must use the AFC Manager - Rate and Logic Modifier to create an EZTax.ovr file that contains the overrides to insert. The file is then uploaded to the service bureau inside the FTP.zip file that carries the CDS file for processing. The overrides are then used during that processing and for subsequent processing until a new or empty override file is uploaded. 2. Avalara clients that submit records in Batch fashion must use the AFC Manager - Rate and Logic Modifier to create an EZTax.ovr file that contains the overrides to insert. Filelocs.txt is then modified to point to this file. When the data file is processed, the overrides are inserted automatically. A F C S a l e s a n d U s e U s e r M a n u a l | 26 of 329 Copyright 2018 Avalara, Inc. 3. Avalara clients that integrate with the AFC Engine using functions (such as APIs) can use the Override utility as an easy way to create overrides in the same manner that batch mode and online clients do, modify filelocs.txt to point to the EZTax.ovr file or use the file path to point to the EZTax.ovr file. The following functions use a session and a tax override record to override the tax rates used by AFC to calculate taxes. Table 4-4 Tax Override Names and Descriptions Function Name EZTaxOvrJCodeEx** Override Description **This is the override JCode function for the most current version of AFC. EZTaxOvrPCodeEx EZTaxOvrZipEx Performs tax override using a JCode to designate the Jurisdiction. Performs tax override using a PCode to designate the Jurisdiction. Performs tax override using zip code and address information to designate the Jurisdiction. Tax Override Fields AFC functions can be used to override a specific tax rate used by AFC. Table 4-5 Tax Override Fields Field Scope Type Level Exempt Level Limit Date Tax Rate Previous Tax Rate Maximum Base Excess Tax State Override County Override Replace State Tax Replace County Tax Description Scope of override Tax type identifier Tax level identifier Level of Exemption Maximum lines or charge to apply tax to Effective date of Tax Rate Tax Rate Previous tax rate Maximum amount to apply tax Rate for amount above the Maximum Base Override state rate if present Override county tax if present Tax replaces state tax Tax replaces county tax Scope Refer to Table 4-6. The term Scope is used to indicate the magnitude of the override. A F C S a l e s a n d U s e U s e r M a n u a l | 27 of 329 Copyright 2018 Avalara, Inc. Table 4-6 Tax Level Effect of Exemption Tax Level Federal Federal Federal Federal State State State County County County Locality Locality Locality Scope Federal State County Locality State County Locality State County Locality State County Locality Effect of Exemption Exempt all defined Federal taxes Exempt entire State for the specific Federal taxes Exempt the Federal taxes within a specified County Exempt the Federal taxes within a specified Locality Exempt all Defined State taxes within a State Exempt the State taxes within a specified County Exempt the State taxes within a specified Locality Exempt all County taxes within a specified State Exempt all County taxes within a specified County Exempt the County taxes within a specified Locality Exempt all Locality taxes within a specified State Exempt all Locality taxes within a specified County Exempt all Locality taxes within a specified Locality As an example, specifying a gross receipts tax at the Local level with a scope of State level will cause all jurisdictions in the state identified by the jurisdiction to be passed to the AFC Engine with the specified tax overridden. The County level affects all taxes in the County and Local level affects only the jurisdiction specified. The specification of Federal level is only valid with federal taxes which will always be overridden at the Federal level. Type The Tax type identifier is used to define the type of tax for which the override will apply. Refer to Table 419 for a complete list of Tax Types supported in AFC. Level The Tax level identifier is used to define the level for which the override will apply. Exempt Level Refer to Table 4-6. The Exempt Level indicator is used to define whether a tax can be exempted by an exemption for all taxes at the same level as this tax. TRUE indicates that the tax can be exempted while FALSE indicates that it cannot be exempted. Note that the tax can still be exempted by a specific tax exemption. For instance, a state level universal service fund will be exempt if this field is set TRUE and a state level tax exemption flag is passed to AFC. If the flag is set TRUE an exemption at the level of the tax will exempt the tax. If the flag is set FALSE an exemption at the level of the tax will have no effect on that specific tax. A F C S a l e s a n d U s e U s e r M a n u a l | 28 of 329 Copyright 2018 Avalara, Inc. Limit The limit indicator is only used for taxes applied per line or location. When this field is set to zero it indicates no limits are in effect for the specified tax. When the limit is not zero, AFC will apply the tax based upon the number of lines or locations up to, but never exceeding, the limit amount. This has no effect on sales taxes Date The Date field is used to define the effective date that the tax rate is active. The transaction date is compared to the effective date to determine if the current tax rate or the previous tax rate is to be applied. Tax Rate If the taxes are computed as a percentage of the charge then the Tax Rate field is used to indicate the tax rate. For example, if a 5% sales tax were applied then the tax rate would be entered as .05. For all other taxes such as per line, fixed, per minute and per location, the dollar amount should be entered for the tax. Previous Tax Rate The Previous Tax Rate field is supplied for use when a previous tax is to be used for the tax rate. Maximum Base The Maximum Base defines the maximum charge that the tax is applied to. Any charge above the maximum base is charged at the excess tax rate. Excess Tax If the tax only caps the charge that the tax is applied to then set the excess tax to zero. State Override The Locality or County sales tax record can override the state sales tax rate. This is useful where localities or counties have a special agreement with the state to collect the state tax at a different rate. If the tax is zero then no override will be in effect. County Override The Locality sales tax record can override a County sales tax rate. This is useful where localities have a special agreement with the County to collect the County tax at a different rate. If the tax is zero then no override will be in effect. A F C S a l e s a n d U s e U s e r M a n u a l | 29 of 329 Copyright 2018 Avalara, Inc. Replace State Tax This option is made available for the rare occasion when a Locality or County sales tax replaces the state sales tax completely. Replace County Tax This option is made available for the rare occasion when a Locality sales tax replaces a county sales tax completely. Tax Override Options The Enhanced Override is used to override taxes. Table 4-7 Tax Override Options Name Enhanced Override Enhanced Date Override Enhanced Rate Override Description Required fields for the Enhanced Override. Required fields for Date Override. Required fields for Rate Override. Enhanced Override The Enhanced Override requires the following fields. Table 4-8 Enhanced Override Fields Scope Type Level Date Count Date Table Scope of override Tax Type identifier Tax Level identifier Number of date records (normally 2) Address of array of date records Enhanced Date Override The Enhanced Date override requires the following fields. Table 4-9 Enhanced Date Override Fields Override Date Rate Count Level Exempt Rate Table Starting (effective) date for this set of tax rates Number of rate records for this date (normally 1) Indicates if tax can be exempted by an exemption for all taxes at the same level as this tax. Tax can still be exempted by specific tax exemption. address of array of rate records Enhanced Rate Override The Enhanced Rate Override requires the following fields and rate entries in rate table for taxes. Table 4-10 Sales Rate Override Fields Tax Maximum Base Replace State State Override Replacement County Tax Amount (rate) Max amount subject to this tax(end of bracket) Tax replaces the state tax Overrides the state rate if present Tax replaces the county tax A F C S a l e s a n d U s e U s e r M a n u a l | 30 of 329 Copyright 2018 Avalara, Inc. Table 4-10 Sales Rate Override Fields County Override Overrides the county tax if present Get Rates The AFC Get Rates function can be used to build the current tax information into the override structure. Specific changes can be made to returned tax entries to create custom overrides. Table 4-11 Get Rates Override Fields PCode Tax Count *Taxes Table Jurisdiction PCode Count of all taxes for this jurisdiction Table of all taxes for this jurisdiction in override format NOTE: The scope value will be set to the tax level. General Tips When Using Overrides 1. Overrides are not permanent. When an AFC session is exited the created overrides are removed and no longer available. They can also be removed without exiting a session using the EZTaxRestore function. 2. AFC cannot override a tax that does not exist. If an existing tax is a rate, it is necessary to override the tax as a rate, not a per line or fixed amount. Failure to do so will result in incorrect and high tax amounts. 3. Non-exemptible taxes may be overridden to exempt taxes that are normally not exemptible. 4. The AFC Override functions can be used to override the rates, but they will not affect the rules that determine what taxes are applied to different transaction/service pairs. General Rules for Configuring Override File 1. The override file path must be listed in filelocs.txt. 2. The override file must be the last item in filelocs.txt. 3. There cannot be any blank lines in filelocs.txt. Also, in order to verify that an override file is in the process of being loaded, the user must go to the AFC Directory and locate the .sta or status file which indicates that an override file has been successfully loaded. A F C S a l e s a n d U s e U s e r M a n u a l | 31 of 329 Copyright 2018 Avalara, Inc. Tax Rate Brackets Some jurisdictions will dictate a tax rate that changes as the taxable amount of the transaction increases. These break points at which the changes occur define the brackets (or steps) and are most commonly based on dollar amount ranges although other units of measure exist. The rate may increase or decrease according to usage levels. AFC supports these transactions with an unlimited number of tax brackets. The Avalara Tax Research department continually researches jurisdictions for specific tax practices, such as tax rate brackets, updating the AFC Engine monthly. These updates occur automatically and the user is not required to make changes to account for this. An example of this is illustrated in Figure 4-1Figure 4-1. If a jurisdiction has a general sales tax set at 2% for the first $500 of a single transaction and set at 1% for that which is over $500, the tax for a $1200 sale would be calculated as shown in Figure 4-1. Figure 4-1 Example of Sale with Tax Brackets First $500 of Sale Remaining Amount of Sale (Over $500) $500 $700 @ @ 2% 1% = = $10.00 7.00 $17.00 Total Tax Rate Final Rate at Final is a variation of the typical tax bracket. Basically a lookup table, each bracket is defined by the break points at which a rate change occurs and contains the rate to be charged for the total transaction amount falling within the range. For example, suppose a state establishes a sales tax with a tax rate dependent on the total sale amount as shown in Figure 4-2Figure 4-2. Figure 4-2 Example of Tax Brackets Total Rate $0.00 - $500.00 7.65% $500.01 - $1000.00 9.00% $1000.01 - $5000.00 7.65% $5000.01 up 7.50% A F C S a l e s a n d U s e U s e r M a n u a l | 32 of 329 Copyright 2018 Avalara, Inc. If the sale is $200, the tax rate of 7.65% will apply for a total tax of $15.30. If the sale is $700, the tax rate of 9.00% will apply for a total tax of $63.00. If the sale is $1500, the tax rate of 7.65% will apply for a total tax of $114.75. If the sale is $6000, the tax rate of 7.50% will apply for a total tax of $450.00. Limits Some jurisdictions have established tax rates that either take effect or cease to take effect at a threshold, a specific currency value. The point at which this occurs is referred to as a cap or limit. AFC supports these transactions and the user is not required to make changes to account for it. As an example, if a jurisdiction charges a 10% sales tax on only the first $10 of an invoice, the tax for a $20 invoice would “cap” at the $10 threshold, resulting in a ($10 x 10% =) $1 sales tax. As an example of the converse, if a jurisdiction does NOT tax the first $25 of a purchase, a $35 charge would be reduced by the $25 threshold “limit,” resulting in a ($35 - $25 = ) $10 taxed amount. Surcharges The returned tax table shows which tax entries are considered surcharges. Discount Adjustment AFC has an additional table that stores discount types by state with an “allow ability” indicator. The adjustment functions have arguments for the discount type which look up the discount type from the table to determine whether to apply taxes or not. Discounts may or may not be taxed within each state. When a discount is taxed, the customer receives a tax benefit commensurate with the amount of the discount (i.e., if the customer gets $5 off on a transaction subject to a 5% tax, the customer pays $0.25 less in tax than they would have). When a discount is not taxed, the customer receives no tax benefit from the discount. Whether a discount is taxed or not depends on the type of discount and the rules in a particular tax jurisdiction. AFC provides five discount types to use in defining the particular discount to be applied and are fully described with supporting example in the following sub-sections. Discount Type ID 0 1 2 Value None (Default) Retail Product Manufacturer Product Description Discount Type not applicable. An amount subtracted from the original price to arrive at a lower price. A credit applied to the total amount reimbursed to either the retailer or the customer by the manufacturer. A F C S a l e s a n d U s e U s e r M a n u a l | 33 of 329 Copyright 2018 Avalara, Inc. Discount Type ID 3 Value Account Level 4 Subsidized 5 Goodwill Description A stand-alone discount that is not applied against any service but instead as a stand-alone product. A credit for telephone service where the telephone provider provides a service to a lifeline eligible customer. The credit will be applied to the subscriber line charge. A credit applied to customer invoices for the purpose of engendering customer goodwill. For example, compensation for a service outage. Account Level Especially prevalent in large accounts, this discount is a stand-alone discount that is not applied against any service but instead as a stand-alone product. Example Description of Account Level A Kansas customer spends significant amounts on a wide range of services including local exchange, intrastate toll, and interstate toll. The customer’s purchasing activity occurs in several states and across multiple accounts. The customer’s spending levels earn it a $1,000.00 discount that is not applied to any particular product or service, but will be applied at an account level. The Corporate Tax Department has determined that account level discounts in Kansas will receive full tax credit, so the discount is mapped to a Tax Category created to represent generic account level discounts and the customer gets a $53.00 credit of Kansas state sales tax along with the $1,000.00 discount. The application of Kansas sales tax to the discount, rather than other state's sales taxes (i.e., states in which there was purchasing activity that helped to earn the discount), is a consequence of the discount being applied to a Kansas account and SBC Corporate Tax has determined that the related tax risk is acceptable. Goodwill A credit applied to customer invoices for the purpose of engendering customer goodwill. For example, compensation for a service outage. Example Description of Goodwill A Kansas customer buys a second line and gets voice mail free for a month ($6.00 value). The free voice mail is a Goodwill Discount because, although it is offered by the retailer and applied to a particular product or service, the terms of the promotion provide that the discount will not be taxed. To accomplish this, the billing system will make separate calls to the taxing engine of $6.00 for the monthly recurring voice mail charge and -$6.00 for the Goodwill Discount. Both transactions will be represented by the same tax category, but the billing system will send an additional value on the discount A F C S a l e s a n d U s e U s e r M a n u a l | 34 of 329 Copyright 2018 Avalara, Inc. transaction indicating that it is a Goodwill Discount. The $6.00 charge for voice mail generates $0.32 in Kansas state sales tax. When the -$6.00 discount is processed for tax applications, the taxing engine determines that a Goodwill Discount is not taxed and generates -$0.00 in Kansas state sales tax. The offsetting tax amounts are presumably netted together in the tax summary on the customer’s bill. Whether the charge and discount amounts are netted on the customer’s bill is up to the billing system, and does not affect the tax calculation or the presentation of tax on the bill. Manufacturer Product A credit applied to the total amount reimbursed to either the retailer or the customer by the manufacturer. Example Description of Manufacturer Product A Kansas customer buys a satellite dish for $300.00 and receives a $50.00 rebate (discount) from the satellite company. The billing system will make separate calls to the taxing engine for the dish charge of $300.00 and the discount of -$50.00. Both transactions will be represented by the same tax category, but the billing system will send an additional value on the discount transaction indicating that it is a Manufacturer Discount. The $300.00 charge for the satellite dish generates $15.90 in Kansas state sales tax. For the -$50.00 discount, the tax engine determines that Kansas does not allow any tax credit on Manufacturer Discounts and generates $0.00 in Kansas state sales tax. The offsetting tax amounts are presumably netted together in the tax summary on the customer’s bill. Whether the charge and discount amounts are netted on the customer’s bill is up to the billing system, and does not affect the tax calculation or the presentation of tax on the bill. Retail Product A retail product discount is an amount subtracted from the original price to arrive at a lower price. Example Description of Retail Product A Kansas customer has voice mail and is charged a monthly recurring charge of $6.00/month. The customer buys a second line and gets voice mail free for a month. The billing system will make separate calls to the taxing engine for the monthly recurring charge of $6.00 and the discount of -$6.00. Both transactions will be represented by the same tax category, but the billing system will send an additional value on the discount transaction indicating that it is a Retailer Discount. The $6.00 charge for voice mail generates $0.32 in Kansas state sales tax. For the -$6.00 discount, the tax engine determines that Kansas allows a full tax credit on Retailer Discounts and generates -$0.32 in Kansas state sales tax. The offsetting tax amounts are presumably netted together in the tax summary on the customer’s bill. Whether the charge and discount amounts are netted on the customer’s bill is up to the billing system, and does not affect the tax calculation or the presentation of tax on the bill. A F C S a l e s a n d U s e U s e r M a n u a l | 35 of 329 Copyright 2018 Avalara, Inc. Subsidized A credit for telephone service where the telephone provider provides a service to a lifeline eligible customer. The credit will be applied to the subscriber line charge. Example Description of Subsidized A Kansas Lifeline customer purchases local exchange service. Local exchange service is normally $24.00, but Lifeline customers are charged $20.50 and the balance of $3.50 is drawn from a federal government fund for the subsidization of local exchange service to Lifeline customers. The company still has $24.00 in revenue and will owe Kansas state sales tax on the entire $24.00 in revenue. The company is prohibited from drawing on the federal government fund to pay for the tax on the $3.50, so the customer must pay all of the applicable tax. Tier at Transactions In some states, the sales tax on a product has tier taxing logic. When tax is calculated using Tier at Transactions the tax is determined using graduated tax brackets on each transaction separately rather than the amount of the customer invoice. The tax applies tax brackets based on the single product transaction. Tier at Transaction is not the default setting in AFC. Tax on Tax Until no Effect The default application of tax on tax is to make one pass through the calculation of each tax, adding the appropriate taxes to the base amount to be taxed. If the tax on tax until no effect option is selected, AFC will continue to recalculate tax on tax until the amount added is less than 0.005 (one half of a cent). Historical Tax Rates AFC maintains an unlimited number of past tax rates. The tax rate history tables contain the tax rates and effective dates and are referenced when tax calculations are performed on date other than the current date. Taxed Taxes Taxed taxes are instances in which one tax includes in its base the tax calculated from another tax. The scope of this document prohibits a discussion of the many examples of taxed taxes. A F C S a l e s a n d U s e U s e r M a n u a l | 36 of 329 Copyright 2018 Avalara, Inc. Refer to Figure 4-3.Figure 4-3. In the case where two taxes are returned for a transaction (tax A and tax B in this example), tax A might be included in the base of tax B. If both taxes are returned for a $100 charge, the taxes would be calculated as follows: Figure 4-3 Taxed Taxes Example (tax rate of 3% is used in this example) Tax A Charge Rate Tax Amount x = FET $100.00 3% $3.00 Charge Tax A Tax B base Rate Tax Amount $100.00 + = x = $3.00 $103.00 3% $3.09 Tax Logging Once the tax calculations are complete, the EZTax.log is created. The log is a binary database containing all of the taxes generated during the tax run. Information in the log includes the jurisdictional data, tax types, tax levels, sale amounts, tax rates, tax amounts, exemptions, adjustments, customer number, etc. Once AFC performs a graceful exit, the EZTax.log is available for use. This file is commonly used to create tax returns, provide audit trails and internal tracking, and used when making projections. The options available for reporting the tax information vary based on the integration method that the client has chosen to use. 1. Batch mode clients – The EZTax.log is automatically produced when processing the .CDS file. Several utilities are available for use to produce files to be imported into the billing system. Refer to Section 5.1 for utility selection assistance. 2. AFC SaaS Standard clients - The EZTax.log is automatically produced and the sorting and reporting activities are performed automatically. 3. On-site clients - The EZTax.log is automatically produced. Many sorting and reporting utilities are available for use to produce the desired output file. Refer to Section 5.1 for utility selection assistance. 4. APIs - Clients who use the functions (such as APIs) must turn logging on to gain the benefit of sorting utilities. All of the information used for billing is returned real time during taxation. A F C S a l e s a n d U s e U s e r M a n u a l | 37 of 329 Copyright 2018 Avalara, Inc. Returned Taxes Once the tax calculations are completed, the tax information is placed in the Tax Table, available to be returned to the user from the AFC engine. An additional Tax Table will be returned if using Invoice Mode. Taxes Table The AFC Table is dynamically allocated during AFC session initialization. This table is used to store tax information as AFC processes transaction records. The size of this table is dependent upon the maximum taxes that can be generated for a single transaction. As such, the size of this table can change from month to month as new taxes are generated or removed from taxing jurisdictions. It is always safe to access from 0 (zero) to [tax_count_returned -1] locations of the table. The user is cautioned to treat this as a read only area. Attempting to access locations that do not exist will result in access violations on most operating systems. Each function that performs tax calculations or tax exceptions returns a count of taxes generated for the specified transaction. The transaction tax data can be retrieved for use in a billing system by accessing the Tax Table pointer which indicates the location of the tax amount in the AFC Table array. Returned Tax Information Tax information can be returned using the P Code, J Code, Zip or FIPS functions. A value is returned to indicate the number of taxes returned and included in the Tax Table. Each tax calculated is returned as a record in the tax table. Taxes are retrieved by looping through the table by the number of taxes, which is then returned by the taxation API call. Each row in the Tax Table will contain the information shown in Table 4-12. Table 4-12 Enhanced Taxes Table Fields PCode PCode for tax jurisdiction Tax Type Tax Type Tax Level Tax Level** Calculation Type Calculation Type (i.e. Rate, Fixed, Per Minute, Per Line) Rate Tax Rate or amount applied Tax Amount Calculated tax amount Taxable Measure Amount of charge plus any taxed taxes Exempt Sale Amount Amount of the charge exempt from taxes *Desc Tax description string Billable Billable flag from tax logic Compliance Compliance flag from tax logic Surcharge Flag FET taxable flag from tax record **Country taxes within any US territory will be returned at a state level versus a federal level. A F C S a l e s a n d U s e U s e r M a n u a l | 38 of 329 Copyright 2018 Avalara, Inc. Returned Tax Information Using Invoice Mode AFC applies Steps, Brackets and/or Limits on a per transaction basis unless operating in Invoice Mode. Invoice Mode is used to group transactions that apply to the same customer. AFC maintains a history of the transactions and applies the Steps, Brackets and/or Limits to entire group of transactions. For example, suppose a jurisdiction charges a 10% sales on just the first $10 of an invoice. If two separate $6 transactions on the invoice are passed while not in Invoice Mode, two $0.60 tax charges would be erroneously totaled and a $1.20 tax would be generated. However, if these same transactions are passed while in Invoice Mode, the total tax charge would be correctly totaled and a $1.00 tax would be generated. Table 4-13 Invoice Mode Tax Table Fields PCode Tax Type Tax Level Calculation Type Rate Tax Amount Exempt Sale Amount *Desc PCode for tax Tax Type Tax Level** Calculation Type (i.e. Rate, Fixed, Per Minute, Per Line) Tax Rate or amount applied. Calculated tax amount. Amount of the charge exempt from taxes. Tax description string For tax calculations based on line counts, it is the number of lines used in the Lines calculation to produce the tax. For Federal taxes, the line count always matches the lines input. For all other taxes, it is 0. For tax calculations based on minutes, it is the number of minutes used in the Minutes calculation to produce the tax. For all other taxes, it is 0. Maximum amount to which tax is applied amounts above this will be taxed at a Max Base higher bracketed rate (if applicable). Minimum amount to which tax is applied amounts below this will be taxed at a Min Base lower bracketed rate (if applicable). Excess Tax Rate for amount above Max Base returned as part of county tax. Total Charge Sum of charges calculated on a per customer basis. **Country taxes within any US territory will be returned at a state level versus a federal level. Tax Grouping AFC allows a client application to group the tax calculation results returned in the tax table based on tax level and tax type criteria. This may be accomplished by setting the appropriate group mode option in the configuration file (see TM_00548_AFC Configuration Guide). The option specified in the configuration file will automatically be applied to every AFC session as it is initialized. However, this option may be overridden by calling the EZTaxGroupResults API function. NOTE: This option will not modify the way that tax calculation results are logged into the EZtax log file. Only the tax calculation results returned by either A F C S a l e s a n d U s e U s e r M a n u a l | 39 of 329 Copyright 2018 Avalara, Inc. one of the tax calculation API will be group according to the values set for this option. General Rules The following rules apply when using any value for this option: Federal taxes may not be grouped. Each Federal tax will be returned individually. Non-billable taxes may not be grouped. Only rate-based taxes may be grouped. Taxes with a different calculation type (for example, fixed, per line, etc) will be returned individually. Use taxes may be grouped with other use taxes only (for example, state and local use tax). Use taxes will not be grouped with other tax types. When grouping taxes for different tax levels (for example, state and local taxes) the jurisdiction code for the lowest level jurisdiction will be returned. Unincorporated taxes will be considered as County taxes when grouping taxes by tax level, and will be grouped accordingly. The tax rates for all taxes being grouped into a single record will be added together. Options: AFC provides the following options in order to group the taxes in the tax table by tax level: Group taxes at the same level. When using this option, taxes at the same level will be grouped together. Group state, group county and local. By using this option, all state level taxes will be grouped into a single record, and all county and local taxes will be grouped together into a separate record. Group state, county, and local. If this option is specified, all state, county, and local taxes will be grouped together. In addition to grouping taxes by tax level, AFC allows you to separate sales taxes from other tax types. The following options may be used in conjunction to the tax level options specified above. 1. Group sales taxes. This option indicates that Sales Taxes (tax type 1) and Use Taxes should be grouped separately from other taxes. 2. Group taxes in the sales category. All taxes that are in the sales category (such as some District and Transit taxes, in addition to Sales Taxes) will be grouped together separately from other taxes. A F C S a l e s a n d U s e U s e r M a n u a l | 40 of 329 Copyright 2018 Avalara, Inc. If the group mode is being specified within the EZTax.cfg file, the sales tax option may be combined with the tax level option by inserting the option in the line following the tax level option. For example: groupstatecountyandlocal groupsalescategory When calling the API function, a sales tax option may be combined with a tax level option by using the bitwise OR operator in the group mode parameter. For example: EZTaxGroupResults(session, GROUP_ST_CO_LOCAL | GROUP_SALES_CATEGORY); By using the default option in the configuration file or the API function, this feature will be disabled, and all taxes will be returned in an individual record. Tax Return Table When grouping taxes together, the fields in the tax return table will contain the following values: Jurisdiction Code. Jurisdiction Code (PCode or JCode depending on the API call and interface being used) for the lowest level jurisdiction. For example, if Kansas state taxes and Overland Park local taxes were grouped together, the tax record will contain the jurisdiction code for Overland Park. Tax level. When grouping State, County and Local taxes together, the tax record will contain a value of 6 in the tax level. When grouping only County and Local taxes together, the tax record will contain a value of 7 in the tax record. Constants are provided for these values in the appropriate file. Tax type. When grouping different taxes together, the tax type in the tax record will contain a value of 0. If only Sales Taxes (tax type 1) or Use Taxes (tax type 49) are being grouped together, the tax record will contain the corresponding tax type. Tax amount. This field will contain the sum of the tax amount for all taxes being grouped together. Tax rate. This field will contain the sum of the tax rates for all taxes being grouped together. NOTE: The remaining fields in the tax table will not contain any meaningful value. Grouping tax calculation results may serve as a way to simplify the tax information for display purposes only. If further detail is required for each tax being returned by AFC, this feature should not be used. A F C S a l e s a n d U s e U s e r M a n u a l | 41 of 329 Copyright 2018 Avalara, Inc. Sales and Use The AFC Sales and Use feature allows API users access to an expanded set of Transaction and Service Type pairs. A Sales and Use transaction requires not only the valid Transaction and Service Type pair but must also include one or more attribute(s). The attributes are used to further specify details of a transaction, such as the freight costs or the purchase of an extended warranty. Sales and Use contains a comprehensive list of transactions to handle your taxation needs. In addition to the products/services, other items such as Shipping, Discounts, Installation, etc. may or may not be taxable depending on the underlying transaction. AFC Sales and Use provides the ability to pass these items with each transaction. The system automatically determines the taxability of these items based upon the jurisdiction. AFC Sales and Use contains sourcing tables to determine where the taxable event took place based upon the order entry information entered into the API. The tables contain sourcing information for both SSTP and non-SSTP states. The transactions are designed with a one-to-one relationship with SSTP definitions and also include definitions for non-SSTP states. Sales Transaction Data Attributes and Properties Sales and Use attributes are used to specify the sales transaction data of a transaction. The Default attribute is included by “default” in most transactions as it is used for the sale of the product or service itself. However, it is possible for a transaction to occur that does not include the Default attribute, such as when the purchase of a service contract for a product occurs sometime after the sale of a product. In most cases a Sales and Use transaction will include more than one attribute in order to completely define it. Properties are included within some attributes to further define options within the attribute. Please refer to TM_00506 AFC Sales and Use Mapping Guidelines for definitions of each attribute and associated properties. Freight On Board (FOB) Transaction Details The table below provides a detailed breakdown of freight transactions specific to FOB. Please reference TM_00506 AFC Sales and Use Mapping Guidelines for additional details, descriptions and examples for all of the possible freight transaction combinations or properties. A F C S a l e s a n d U s e U s e r M a n u a l | 42 of 329 Copyright 2018 Avalara, Inc. Table 4-14 FOB Transaction Attributes Attribute Property FALSE = FOB Shipping Point FOB using FIPS Codes TRUE = FOB Destination ship_from_fips_code; ship_to_fips_code; sau_tax_data FALSE = FOB Shipping Point FOB using JCodes TRUE = FOB Destination ship_from_j_code; ship_to_j_code; sau_tax_data FALSE = FOB Shipping Point FOB using PCodes TRUE = FOB Destination ship_from_p_code; ship_to_p_code; sau_tax_data FOB using ZIP P4 Codes FALSE = FOB Shipping Point Description A term that signifies that the freight being shipped is the responsibility of the buyer after it leaves the point where it is shipped from. A term that signifies that the freight being shipped is the responsibility of the seller until the item being shipped is received by the buyer. Ship from Fips Code Ship to Fips Code Transaction data A term that signifies that the freight being shipped is the responsibility of the buyer after it leaves the point where it is shipped from. A term that signifies that the freight being shipped is the responsibility of the seller until the item being shipped is received by the buyer. Ship from JCode Ship to JCode Transaction data A term that signifies that the freight being shipped is the responsibility of the buyer after it leaves the point where it is shipped from. A term that signifies that the freight being shipped is the responsibility of the seller until the item being shipped is received by the buyer. Ship from PCode Ship to PCode Transaction data A term that signifies that the freight being shipped is the responsibility of the buyer after it leaves the point where it is shipped from. Example Company A ships an item from its docks in New York to Los Angeles. Company A would be liable only while the property is in their possession at their docks in New York. Company A ships an item from its docks in New York to Los Angeles. Company A would be liable up until the item is received in Los Angeles Company A ships an item from its docks in New York to Los Angeles. Company A would be liable only while the property is in their possession at their docks in New York. Company A ships an item from its docks in New York to Los Angeles. Company A would be liable up until the item is received in Los Angeles Company A ships an item from its docks in New York to Los Angeles. Company A would be liable only while the property is in their possession at their docks in New York. Company A ships an item from its docks in New York to Los Angeles. Company A would be liable up until the item is received in Los Angeles Company A ships an item from its docks in New York to Los Angeles. Company A would be liable only while the property is in their possession at their docks in New York. A F C S a l e s a n d U s e U s e r M a n u a l | 43 of 329 Copyright 2018 Avalara, Inc. Table 4-14 FOB Transaction Attributes Attribute Property TRUE = FOB Destination ship_from_zip_address_P4; ship_to_zip_address_P4; Description Example A term that signifies that the Company A ships an item from freight being shipped is the its docks in New York to Los responsibility of the seller until the Angeles. Company A would be item being shipped is received by liable up until the item is the buyer. received in Los Angeles Ship from ZIP Code+4 and address information Ship to ZIP Code+4 and address information Tax Data Structure Table 4-17 Tax Data Structure customer_type; sale; trans_type; srv_type; attr; sau_freight_properties freight; sau_discount_properties discount; sau_finance_properties finance; sau_installation_properties installation; sau_shipandhandling_properties shipandhandle; sau_softwaremaint_properties softwaremaint; sau_svc_contract_properties svccontract; sau_maint_agreement_properties maintagreement; sau_factory_warranty_properties facwarranty; sau_extended_warranty; date; charge; count; incorp; FED_exempt; st_exempt; co_exempt; loc_exempt; FED_J_Code; st_J_Code; co_J_Code; loc_J_Code; spc_exempt; sau_exempt *sau_exemptions; exempt_type; 0=residential, 1=business customer, 2=Senior Citizen, 3=Industrial flag - retail/sale or wholesale/resale see the programmer user's manual for valid transaction service type pairs SAU_FREIGHT, SAU_DEMURRAGE, SAU_DEPOSITS, ... properties for freight properties for discounts properties for finance properties for installation properties for shipping and handling properties for software maintenance properties for service contracts properties for maintenance agreements properties for factory warranty Properties for extended warranty transaction bill date amount charged to customer number of items incorporated or unincorporated area If TRUE, transaction exempt from Federal Tax If TRUE, transaction exempt from State Tax If TRUE, transaction exempt from County Tax If TRUE, transaction exempt from local tax Jurisdiction for Federal exemption Jurisdiction for state exemption Jurisdiction for county exemption Jurisdiction for local exemption 0 indicates no of specific exempts, other value indicates number of specific exempts array of exemptions reason for exemption A F C S a l e s a n d U s e U s e r M a n u a l | 44 of 329 Copyright 2018 Avalara, Inc. Table 4-17 Tax Data Structure inv_no; srv_lvl_no; optional; cust_no[CUST_NO_SIZE]; company_identifier[CO_IDENTIFIER_SIZE]; opt_alpha_1[CUST_NO_SIZE]; opt_4; opt_5; opt_6; opt_7; opt_8; opt_9; opt_10; Invoice number, user defined Service level number, user defined user defined value for reporting user defined customer number company identifier optional alpha field optional numeric field optional numeric field optional numeric field optional numeric field optional numeric field optional numeric field optional numeric field Transaction and Service Types (Sales and Use) The transaction/service types to be used are identified here. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 24 491 Software/Canned Software 24 492 Software/Modified Charges 24 493 Software/Modified Software 24 494 Software/Custom Software 24 495 Software/Canned Software-Load and Leave 24 496 Software/Custom Software-Load and Leave 24 497 Software/Licensed Software-Load and Leave Software written for multiple users. Transferable to the computer by physical means which the customer retains. Charges to modify canned software for a specific user. Software modified for a specific purpose for a specific user. Transferable to the computer by physical means, which the customer retains Software written for a specific purpose for a specific user. Transferable to the computer by physical means which the customer retains Software written for multiple users. Transferable to the computer by physical means which the software provider retains after installation. Software written for a specific purpose for a specific user. Transferable to the computer by physical means which the software provider retains after installation. An agreement for the use of software for a specified period. Transferable to the computer by physical means which the software provider retains after installation. A F C S a l e s a n d U s e U s e r M a n u a l | 45 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 24 498 Software/Modified Software-Load and Leave 24 499 Software/Downloaded Custom Software 24 500 Software/Downloaded Canned Software 24 501 Software/Licensed SoftwareDownload 24 502 Software/Modified SoftwareDownload 24 503 Software/Software Set Up-OptionalCanned 24 504 Software/Software Set Up-OptionalCustom 24 505 Software/Software Set Up-OptionalDownloaded 24 506 Software/Software Set Up-OptionalLoad and Leave Software modified for a specific purpose for a specific user. Transferable to the computer by physical means which the software provider retains after installation. Software written for a specific purpose for a specific user. Transferable to the computer by electronic means. Software written for multiple users. Transferable to the computer by electronic means. An agreement for the use of software for a specified period. Transferable to the computer by electronic means. Software modified for a specific purpose for a specific user. Transferable to the computer by electronic means. Charges for the set up and installation of software into the purchaser’s equipment. Covering pre-written software transferred by physical means that is retained by the user. The user has the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. This covers custom software no matter the means transferred. The user has the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. Covering pre-written software transferred by electronic means. The user has the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. Covering pre-written software transferred by physical means that is retained by the seller. The user has the option of installing the software themselves. A F C S a l e s a n d U s e U s e r M a n u a l | 46 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 24 507 Software/Software Set Up-OptionalModified 24 508 Software/Software Set UpMandatory-Canned 24 509 Software/Software Set UpMandatory-Custom 24 510 Software/Software Set UpMandatory-Downloaded 24 511 Software/Software Set UpMandatory-Load and Leave 24 512 Software/Software Set UpMandatory-Modified 24 513 Software/Computer ConsultingOptional-Canned 24 514 Software/Computer ConsultingMandatory-Canned Charges for the set up and installation of software into the purchaser’s equipment. Covering modified software transferred by physical means that is retained by the user. The user has the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. Covering pre-written software transferred by physical means that is retained by the user. The user does not have the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. This covers custom software no matter the means transferred. The user does not have the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. Covering pre-written software transferred by electronic means. The user does not have the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. Covering pre-written software transferred by physical means that is retained by the seller. The user does not have the option of installing the software themselves. Charges for the set up and installation of software into the purchaser’s equipment. Covering modified software transferred by physical means that is retained by the user. The user does not have the option of installing the software themselves. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. A F C S a l e s a n d U s e U s e r M a n u a l | 47 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 24 515 Software/Computer ConsultingOptional-Custom 24 516 Software/Computer ConsultingMandatory-Custom 24 517 Software/Computer ConsultingOptional-Downloaded 24 518 Software/Computer ConsultingMandatory-Downloaded 24 519 Software/Computer ConsultingOptional-Load and Leave 24 520 Software/Computer ConsultingMandatory-Load and Leave 24 521 Software/Computer ConsultingOptional-Modified 24 522 Software/Computer ConsultingMandatory-Modified 24 523 Software/Computer TrainingOptional-Canned 24 524 Software/Computer TrainingMandatory-Canned 24 525 Software/Computer TrainingOptional-Custom 24 526 Software/Computer TrainingMandatory-Custom 24 527 Software/Computer TrainingOptional-Downloaded Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges often considered design and planning for software but not to include actual training. Charges for training the purchaser on the use of new software. The training is for canned software and the customer has a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for canned software and the customer does not have a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for custom software and the customer has a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for custom software and the customer does not have a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for pre-written software transferred electronically and the customer has a choice on whether to take the course. A F C S a l e s a n d U s e U s e r M a n u a l | 48 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 24 528 Software/Computer TrainingMandatory-Downloaded 24 529 Software/Computer TrainingOptional-Load and Leave 24 530 Software/Computer TrainingMandatory-Load and Leave 24 531 Software/Computer TrainingOptional-Modified 24 532 Software/Computer TrainingMandatory-Modified 24 556 Software/Licensed Software-Physical Transmission 24 558 Software/Report-Physical Transmission 24 637 Software/Remote Access of Software 25 533 Timesharing/Timesharing - Off-Site Use of CPU - General Rule 25 534 Timesharing/CPU Located out of State 25 559 Timesharing/Remote Information Retrieval 25 647 Timesharing/Remote Information Retrieval (Provider Data) Charges for training the purchaser on the use of new software. The training is for pre-written software transferred electronically and the customer does not have a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for pre-written software transferred by a medium kept by the purchaser and the customer has a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for pre-written software transferred by a medium kept by the purchaser and the customer does not have a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for modified software and the customer has a choice on whether to take the course. Charges for training the purchaser on the use of new software. The training is for modified software and the customer does not have a choice on whether to take the course. An agreement for the use of software for a specific period. A report generated and provided to the end user delivered on CD or paper. A service that provides access and use of software that remains in the possession of the seller and is remotely accessed by a customer. If data is manipulated by the software, it is user created data. Access to computer through a remote terminal that allows computations. Access to computer through a remote terminal that allows computations. Access to a computer through a remote terminal that allows retrieval of stored data created by the user. Access to a computer through a remote terminal that allows retrieval of stored data created by the service provider. A F C S a l e s a n d U s e U s e r M a n u a l | 49 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 27 106 Alcohol/General Rule 27 107 Alcohol/Beverage Above 7% Content by Weight 27 108 Alcohol/Beverage Below 7% Content by Weight 27 109 Alcohol/Mixed Beverage above 7% Content By Weight 27 110 Alcohol/Mixed Beverage below 7% Content By Weight 27 111 Alcohol/Non Mixed Served in Restaurant Above 7% 27 112 Alcohol/Non Mixed Served in Restaurant Below 7% 28 106 Beverages/General Rule 28 113 Beverages/Carbonated Beverages 28 114 28 115 28 116 28 117 28 118 28 119 28 120 28 121 28 122 28 123 Beverages/Sweetened Carbonated Beverages Beverages/Bottled Water Beverages/Bottled Water Carbonated and/or Flavored Beverages/Bottled Water-Carbonated and/or Sweetened Beverages/Soft Drinks Beverages/Natural Fruit or Vegetable Juices Beverages/Natural Contents Between 0%-24% Beverages/Natural Contents Between 25%-49% Beverages/Natural Contents Between 50%-69% Beverages/Natural Contents Between 70%-100% A fermented drink or a packaged beverage containing alcohol. A fermented drink or a packaged beverage containing alcohol with alcoholic content above 7% by weight. A fermented drink or a packaged beverage containing alcohol with alcoholic content below 7% by weight. A beverage mixed with a beverage containing alcohol with alcoholic content by volume of 7% or more. A beverage mixed with a beverage containing alcohol with alcoholic content by volume of 7% or less. A fermented drink or a packaged beverage containing alcohol with alcoholic content above 7% by weight served in a restaurant. A fermented drink or a packaged beverage containing alcohol with alcoholic content below 7% by weight served in a restaurant. Covers all beverages not otherwise specified in this transaction type/service type. Non-alcoholic beverage containing carbonation. Non-alcoholic beverage containing carbonation and sweeteners. Packaged beverage consisting of filtered. Packaged water to which carbonation. Packaged water to which carbonation. A ready-to-use non-alcoholic packaged drink that may or may not be carbonated. Fruit or vegetable juices. Beverage containing between 0-24% natural fruit or vegetable juice. Beverage containing less than 25-49% natural fruit or vegetable juice. Beverage containing less than 50-69% natural fruit or vegetable juice. Beverage containing less than 70-100% natural fruit or vegetable juice. A F C S a l e s a n d U s e U s e r M a n u a l | 50 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 28 124 Beverages/Bottled Tea 28 125 Beverages/Coffee 29 106 Books/General Rule 29 126 Books/Religious 29 127 29 128 30 129 Clothing/Everyday 30 130 Clothing/Sporting Activities 30 131 Clothing/Sporting Equipment 30 132 Clothing/Protective 30 133 Clothing/Protective/Manufacturing 30 134 Clothing/Furs 30 135 Clothing/Uniforms 30 136 Clothing/Formal or Special Occasion Wear 30 137 Clothing/Costumes 30 138 Clothing/Accessories 30 139 Clothing/Display Samples 30 140 Clothing/Cloth Diapers 30 141 Clothing/Clean Room 30 142 Clothing/Bathing Caps 30 143 Clothing/Belt Buckles Books/Educational-Kindergarten Through 12th Grade Books/Educational-College & Trade School Beverage generally classified or explicitly presented as tea on the package. Beverage produced from the coffee bean plant. Books not covered by any other rule. Books containing religious doctrine and study guides for religious topics. Books used specifically for students of kindergarten through the 12th grade Books used specifically for students of college and trade school. Clothing that is not specialized in use or purpose. Clothing specialized for sports that would not ordinarily be worn in daily activity not including items such as cleats and sporting equipment. Items not generally considered clothing but is worn on the person for a sporting activity. Clothing designed to offer protection in a hazardous environment or activity such as work gloves. Clothing designed to offer protection in a hazardous environment or activity such as work gloves. Clothing which contains natural animal hides. Regulated and required clothing for an organized event i.e. school dress code Clothing worn to formal events. Clothing of a decorative nature worn for special events or holidays. Decorative items such as jewelry Clothing used to clothe various store displays for promotional purposes. It may be sold later. Clothing made of cotton used as undergarments. Clothing specifically designed to assist with a germ free environment in a clean room. Caps normally worn for shower or bathing. A buckle. A F C S a l e s a n d U s e U s e r M a n u a l | 51 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 30 144 Clothing/Bowling Shoes 30 145 Clothing/Ski Boots 30 146 Clothing/Waders 30 147 Clothing/Shoe Laces 31 106 Drugs/General Rule 31 148 Drugs/Prescription - Legend 31 149 31 150 31 151 31 152 31 153 Drugs/Cough Drops 31 154 Drugs/Prescription - Insulin - Human Use 31 155 Drugs/Nonprescription - Insulin Human Use 31 156 Drugs/Prescription - Insulin - Animal Use 31 157 Drugs/Nonprescription - Insulin Animal Use 31 158 Drugs/Prescription - Oxygen-Human Use Drugs/Prescription - Over the Counter-Human Drugs/Nonprescription - Over the Counter-Human Drugs/Prescription - Over the Counter-Animal Drugs/Nonprescription - Over the Counter-Animal Shoes used for the sport of bowling and normally only used for that purpose. Boots or shoes used for skiing. Hip long pants used to stand in a body of water. Laces purchased independently of the shoes Drugs not fitting any of the service types listed below. Commonly referred to as non-prescription drugs not sold over the counter. Does not include drugs for animal use. Drugs that when dispensed are required to contain a label specifying the drug can only be dispensed by a licensed pharmacist based on a prescription from a physician or health professional. Does not include drugs for animal use. Drugs Drugs Drugs Drugs Drugs commonly referred to as drops used to treat a cold or cold symptoms. Insulin dispensed by a licensed pharmacist for human use based on a prescription from a physician or health professional for human use. Insulin that may be purchased for human use over-the-counter or without a physician's prescription for human use. Insulin dispensed by a licensed pharmacist for animal use based on a prescription from a physician or health professional for animal use. Insulin that may be purchased for animal use over-the-counter or without a physician's prescription for animal use. Oxygen obtained from a licensed pharmacist based on a prescription from a physician or health professional for human use. A F C S a l e s a n d U s e U s e r M a n u a l | 52 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 31 159 Drugs/Nonprescription - OxygenMedicinal-Human Use 31 160 Drugs/Prescription - Oxygen-Animal Use 31 161 Drugs/Nonprescription-OxygenMedicinal-Animal Use 31 162 Drugs/Enemas and Suppositories 31 163 Drugs/Prescription-Animal Consumption 31 164 Drugs/Nonprescription-Animal Consumption 31 165 Drugs/Non-Presc Sold to HospitalsHuman 31 166 Drugs/Presc Sold to Hospitals-Human 31 167 Drugs/Non-Presc Sold to HospitalsAnimals 31 168 Drugs/Presc Sold to Hospitals-Animals 31 169 Drugs/Taxable and Nontaxable Bundled Together 31 170 Drugs/Free Sample-Human Use 31 171 Drugs/Free Sample- Presc-Human Use 31 172 Drugs/Free Sample-Animal Use Oxygen that may be purchased over-thecounter or without a physician's prescription for human use. Oxygen obtained from a licensed pharmacist based on a prescription from a physician or health professional for animal use. Oxygen that may be purchased over-thecounter or without a physician's prescription for animal use. Drug meant for rectal insertion meant for treatment of ailments in that area of the body. Drugs that when dispensed are required to contain a label specifying the drug can only be dispensed by a licensed pharmacist based on a prescription from a physician or health professional for animal use. Drugs Drugs that when dispensed are required to contain a label specifying the drug can only be dispensed by a licensed pharmacist based on a prescription from a physician or health professional for human use purchased for use in a hospital. Drugs Drugs that when dispensed are required to contain a label specifying the drug can only be dispensed by a licensed pharmacist based on a prescription from a physician or health professional for animal use purchased for use in a hospital. Drugs Drugs sold as a package consisting of both taxable and non taxable drugs. The drugs cannot be taxed separately. Drugs Drugs that when dispensed are required to contain a label specifying the drug can only be dispensed by a licensed pharmacist based on a prescription from a physician or health professional for human use given away for no cost. Drugs A F C S a l e s a n d U s e U s e r M a n u a l | 53 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 31 173 Drugs/Free Sample-Presc-Animal Use 32 106 Electronic Equipment & Computer Hardware/General Rule 32 174 32 175 32 176 32 177 33 178 Fuel/Unleaded Fuel w/o Excise Tax 33 179 Fuel/Diesel Fuel w/o Excise Tax 33 180 Fuel/Gasohol w/o Excise Tax 33 181 Fuel/Fuel to Common Carriers w/o Excise Tax 33 182 Fuel/Fuel-Passenger Common Carrier w/o Excise Tax 33 183 Fuel/Unleaded Fuel w/Excise Tax 33 184 Fuel/Diesel Fuel w/Excise Tax 33 185 Fuel/Gasohol w/Excise Tax 33 186 Fuel/Fuel to Common Carriers w/Excise Tax 33 187 Fuel/Fuel-Passenger Common Carrier w/ Excise Tax Electronic Equipment & Computer Hardware/Monitors Less Than 4 Inches Electronic Equipment & Computer Hardware/Monitors Between 5-14 inches Electronic Equipment & Computer Hardware/Monitors Between Than 15-34 Inches Electronic Equipment & Computer Hardware/Monitors Greater Than 35 Inches Drugs that when dispensed are required to contain a label specifying the drug can only be dispensed by a licensed pharmacist based on a prescription from a physician or health professional for animal use given away for no cost. Covers any electronic equipment or computer hardware not otherwise mentioned. Monitors or Device and Monitors with a viewing screen of less than 4 inches. Monitors or Device and Monitors with a viewing screen of between 5-14 inches. Monitors or Device and Monitors with a viewing screen of between 15-34 inches. Monitors or Device and Monitors with a viewing screen of greater than 35 inches. Fuel used for motor vehicles that does not contain lead w/o excise tax being paid. Fuel used for motor vehicles that is classified as a diesel fuel w/o excise tax being paid. Fuel used for motor vehicles that contains substances commonly known as gasohol w/o excise tax being paid. Fuel used for motor vehicles that is sold to common carriers w/o excise tax paid. Fuel used for motor vehicles that is sold to common carriers who haul 10 or more passengers w/o excise tax paid. Fuel used for motor vehicles that does not contain lead w/ excise tax being paid. Fuel used for motor vehicles that is classified as a diesel fuel w/ excise tax being paid. Fuel used for motor vehicles that contains substances commonly known as gasohol w/ excise tax being paid. Fuel used for motor vehicles that is sold to common carriers w/ excise tax paid. Fuel used for motor vehicles that is sold to common carriers who haul 10 or more passengers w/ excise tax paid. A F C S a l e s a n d U s e U s e r M a n u a l | 54 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 33 188 Fuel/Fuel For Off Road Purposes 33 189 Fuel/Jet Fuel 33 190 Fuel/Jet Fuel--Common Carriers 34 106 General Merchandise/General Rule 34 191 General Merchandise/Appliances 34 192 General Merchandise/Baby Oil 34 193 General Merchandise/US Flag 34 194 General Merchandise/Coins-Work of Art-Pure Metal 34 195 General Merchandise/Coins-Foreign Currency-Pure Metal 34 196 34 197 34 198 General Merchandise/Coins-Work of Art-90% or Greater 34 199 General Merchandise/Coins-Foreign Currency-90% or Greater 34 200 General Merchandise/CoinsCollectible-90% or Greater 34 201 General Merchandise/CoinsInvestment Purposes-90% or Greater 34 202 General Merchandise/Coins-Work of Art-Between 80-90% 34 203 General Merchandise/Coins-Foreign Currency-Between 80-90% 34 204 General Merchandise/CoinsCollectible-Between 80-90% General Merchandise/CoinsCollectible-Pure Metal General Merchandise/CoinsInvestment Purposes-Pure Metal Fuel used for motor vehicle that are not normally driven on the highway. Fuel used for a machine or device relying on jet propulsion. Fuel used for a machine or device relying on jet propulsion used for interstate transport. Any tangible personal property not otherwise considered in any other transaction type/service type. Items generally considered to be white goods. Mineral Oil generally classified as baby oil. A piece of cloth of distinctive color and designed as the official flag of the United States. Coins consisting of 100% pure bullion. Sold expressly for the artistic value of the medallion or coin. Coins consisting of 100% pure bullion. Sold expressly as foreign currency on the exchange market. Coins consisting of 100% pure bullion. Sold expressly as a coin collectible. Coins consisting of 100% pure bullion. Sold expressly for investment purposes. Coins consisting of 90% or greater bullion but is not pure. Sold expressly for the artistic value of the medallion or coin. Coins consisting of 90% or greater bullion but is not pure. Sold expressly as foreign currency on the exchange market Coins consisting of 90% or greater bullion but is not pure. Sold expressly as a coin collectible. Coins consisting of 90% or greater bullion but is not pure. Sold expressly for investment purposes. Coins consisting between 80-90% bullion. Sold expressly for the artistic value of the medallion or coin. Coins consisting between 80-90% bullion. Sold expressly as foreign currency on the exchange market Coins consisting between 80-90% bullion. Sold expressly as a coin collectible. A F C S a l e s a n d U s e U s e r M a n u a l | 55 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION 205 General Merchandise/CoinsInvestment Purposes-Between 8090% 34 206 General Merchandise/Coins-Work of Art-Less Than 80% 34 207 General Merchandise/Coins-Foreign Currency-Less Than 80% 34 208 34 209 34 210 General Merchandise/Uncancelled Stamps-For Collectible Purposes 34 211 General Merchandise/Cancelled Stamps 34 212 34 213 34 214 General Merchandise/Burial VaultsFor Human Remains 34 215 General Merchandise/Caskets-For All Other Remains 34 216 General Merchandise/Burial VaultsFor All Other Remains 34 217 General Merchandise/Headstone/Burial Marker-w/o Installation 34 218 General Merchandise/Headstone/Burial Marker-w/ Installation 34 219 General Merchandise/Sanitary Napkins or Tampons 34 220 General Merchandise/Other State Flag Coins consisting between 80-90% bullion. Sold expressly for investment purposes Coins consisting less than 80% bullion. Sold expressly for the artistic value of the medallion or coin. Coins consisting less than 80% bullion. Sold expressly as foreign currency on the exchange market. Coins consisting less than 80% bullion. Sold expressly as a coin collectible. Coins consisting less than 80% bullion. Sold expressly for investment purposes. Stamps not otherwise used for postage purposes sold for the express intention of becoming a collectible for the purchaser. Stamps already used for postage purposes that are resold for their collectible value. Stamps expressly used for the delivery of the United States Mail. Box or Urn used to hold the remains of a departed human individual. A vault used to hold and protect the casket or urn from the elements. This vault is designed exclusively for containing human remains. Box or Urn used to hold the remains of any being other than a human. A vault used to hold and protect the casket or urn from the elements. The vault's casket or urn does not contain human remains. A headstone or marker to be placed at the burial site of the decedent. The transaction did not include the actual placement of the marker in the ground. A headstone or marker to be placed at the burial site of the decedent. The transaction included the actual placement of the marker in the ground. Items used to absorb menstrual flow during a menstrual cycle. A piece of cloth of distinctive color and designed as a flag of any state other than the home based state where the instance of tax occurs. Trans Type Svc Type 34 General Merchandise/CoinsCollectible-Less Than 80% General Merchandise/CoinsInvestment Purposes-Less Than 80% General Merchandise/Uncancelled Stamps-For Postage Purposes General Merchandise/Caskets-For Human Remains A F C S a l e s a n d U s e U s e r M a n u a l | 56 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 34 221 General Merchandise/Home State Flag 34 222 General Merchandise/POW Flag 34 223 34 224 34 225 General Merchandise/Grooming and Hygiene Products for Human Use General Merchandise/Grooming and Hygiene Products for Animal Use General Merchandise/Toothpaste, Toothbrush, Dental Floss 34 226 General Merchandise/Gaming CoinsMetal Content is Greater than 80% 34 227 General Merchandise/Gaming CoinsMetal Content is Less than 80% 34 228 General Merchandise/Marine Equipment 34 229 General Merchandise/Charcoal 34 230 General Merchandise/Coupon Books 34 231 General Merchandise/Supplies and Food for Seeing Eye Dog 34 232 General Merchandise/Non-Lead Based Batteries 34 574 General Merchandise/Fixture 34 616 34 617 34 618 34 619 General Merchandise/Hurricane Supplies General Merchandise/School Supplies General Merchandise/AppliancesEnergy Star General Merchandise/Hunting Supplies A piece of cloth of distinctive color and designed as the official flag of the home based state where the instance of tax occurs. A piece of cloth of distinctive color and designed as the official flag of the POW movement. Soaps and cleaning solutions. Soaps and cleaning solutions. Toothbrush Coins consisting greater than 80% bullion. Sold expressly for using in gaming machines for the purposes of gambling. Coins consisting less than 80% bullion. Sold expressly for using in gaming machines for the purposes of gambling. Equipment expressly used for the purposes of use in or directly associated with water. A black porous material containing 85 to 98 percent carbon provided by the destructive distillation of wood and used as a fuel. Books that have coupons enclosed to use as discounts at various establishments. Supplies and food used exclusively by a seeing eye dog. This animal is used to aid the visually impaired with normal life functions. Batteries Tangible personal property that is installed in real property and qualifies as a fixture of the real property. Supplies used for Hurricane preparedness. Supplies used for school. Appliances rated as Energy Star for efficiency. Supplies for Hunting. A F C S a l e s a n d U s e U s e r M a n u a l | 57 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 34 640 General Merchandise/ Restocking Fee 35 106 Groceries/General Rule 35 233 Groceries/Candy 35 234 Groceries/Chewing Gum 35 235 Groceries/Food Additives 35 35 236 237 35 238 35 239 Groceries/Confectionary Items Groceries/Ice Groceries/Dietary SupplementsQualify Groceries/Dietary Supplements-Non Qualify 35 621 Groceries/Bulk Items 36 240 Magazines/Retail - Published Monthly 36 241 Magazines/Retail - Published Annually 36 242 Magazines/Retail - Published SemiMonthly 36 243 Magazines/Retail - Published SemiAnnually 36 244 Magazines/Retail - Published Quarterly 36 245 Magazines/Retail - Published Weekly 36 246 Magazines/Subscription-Monthly-US Mail Fee charged to reimburse the cost of restocking a purchased item. The returned item cannot be modified in any way. Items obtained from a grocery store that may be comprised of items for human consumption. Items that do not require additional preparation before consumption such as sweets and confections and are generally high in sugar content. Chewing gum is a type of confectionery which is designed to be chewed rather than swallowed. An additive meant to preserve food or extend its shelf life. Baked goods and items used in baking. Ice for human consumption. Preparations in liquid. Preparations in liquid. Multi-serving bakery items and single serving bakery items in quantities of three or more. A publication with a soft cover and indexed articles published monthly sold at a newsstand. A publication with a soft cover and indexed articles published once a year sold at a newsstand. A publication with a soft cover and indexed articles published twice per month sold at a newsstand. A publication with a soft cover and indexed articles published twice per year sold at a newsstand. A publication with a soft cover and indexed articles published every three months sold at a newsstand. A publication with a soft cover and indexed articles published each week sold at a newsstand. A publication with a soft cover and indexed articles published monthly delivered by Second Class Mail or below. A F C S a l e s a n d U s e U s e r M a n u a l | 58 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 36 247 Magazines/Subscription-AnnuallyDelivered by US Mail 36 248 Magazines/Subscription-SemiMonthly-Delivered by US Mail 36 249 Magazines/Subscription-SemiAnnually-Delivered by US Mail 36 250 Magazines/Subscription-QuarterlyDelivered by US Mail 36 251 Magazines/Subscription-WeeklyDelivered by US Mail 36 252 Magazines/Subscription-Monthly-Not Delivered by US Mail 36 253 Magazines/Subscription-Annually-Not Delivered by US Mail 36 254 Magazines/Subscription-SemiMonthly-Not Delivered by US Mail 36 255 Magazines/Subscription-SemiAnnually-Not Delivered by US Mail 36 256 Magazines/Subscription-QuarterlyNot Delivered by US Mail 36 257 Magazines/Subscription-Weekly-Not Delivered by US Mail A publication with a soft cover and indexed articles published once a year delivered by Second Class Mail or below. A publication with a soft cover and indexed articles published twice per month delivered by Second Class Mail or below. A publication with a soft cover and indexed articles published twice per year delivered by Second Class Mail or below. A publication with a soft cover and indexed articles published every three months delivered by Second Class Mail or below. A publication with a soft cover and indexed articles published each week delivered by Second Class Mail or below. A publication with a soft cover and indexed articles published monthly delivered by means other than Second Class Mail or below. This does not include door to door delivery. A publication with a soft cover and indexed articles published once a year delivered by means other than Second Class Mail or below. This does not include door to door delivery. A publication with a soft cover and indexed articles published twice per month delivered by means other than Second Class Mail or below. This does not include door to door delivery. A publication with a soft cover and indexed articles published twice per year delivered by means other than Second Class Mail or below. This does not include door to door delivery. A publication with a soft cover and indexed articles published every three months delivered by means other than Second Class Mail or below. This does not include door to door delivery. A publication with a soft cover and indexed articles published each week delivered by means other than Second Class Mail or below. This does not include door to door delivery. A F C S a l e s a n d U s e U s e r M a n u a l | 59 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 36 258 Magazines/Subscription-MonthlyDoor to Door Delivery 36 259 Magazines/Subscription-AnnuallyDoor to Door Delivery 36 260 Magazines/Subscription-SemiMonthly-Door to Door Delivery 36 261 Magazines/Subscription-SemiAnnually-Door to Door Delivery 36 262 Magazines/Subscription-QuarterlyDoor to Door Delivery 36 263 Magazines/Subscription-Weekly-Door to Door Delivery 36 361 Magazines/Digital Product – Retail 36 362 Magazines/Digital Product – Subscription 37 264 Manufacturing/Equipment-Existing Facilities 37 265 Manufacturing/Equipment-Economic Expansion of Facilities 37 266 Manufacturing/Equipment-Physical Expansion of Facilities 37 267 Manufacturing/Equipment-New Facilities A publication with a soft cover and indexed articles published monthly delivered by hand delivery. A publication with a soft cover and indexed articles published once a year delivered by hand delivery. A publication with a soft cover and indexed articles published twice per month delivered by hand delivery. A publication with a soft cover and indexed articles published twice per year delivered by hand delivery. A publication with a soft cover and indexed articles published every three months delivered by hand delivery. A publication with a soft cover and indexed articles published each week delivered by hand delivery. A magazine publication transveyed electronically and sold online on a per copy basis. A magazine publication transveyed electronically and sold online as part of a subscription to the magazine. Machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed at an existing plant or facility. This is usually a like-kind replacement of existing equipment. Machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed at an existing plant or facility. The additional equipment is used to increase output or to produce a new product. Machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed due to an enlargement of an existing plant or facility. Machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed at a new plant or facility. A F C S a l e s a n d U s e U s e r M a n u a l | 60 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 37 268 Manufacturing/Repair parts-Existing Facilities 37 269 Manufacturing/Repair Parts-Economic Expansion 37 270 Manufacturing/Repair Parts-Physical Expansion 37 271 Manufacturing/Repair Parts-New Facilities 37 272 Manufacturing/Repair LaborSeparately Stated 37 273 Manufacturing/Repair Labor-Not Separately Stated 37 274 Manufacturing/Installation LaborEquipment-Separately Stated 37 275 Manufacturing/Installation LaborEquipment-Not Separately Stated 37 276 Manufacturing/Automobile Specific Equipment-Separately Stated Repair parts for machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed at an existing plant or facility. The parts are used to maintain existing equipment. Repair or replacement parts acquired at the time machinery and equipment used to manufacture items that will ultimately be sold at retail is purchased and installed at an existing plant or facility. The additional equipment is used to increase output or to produce a new product. Repair or replacement parts acquired at the time machinery and equipment used to manufacture items that will ultimately be sold at retail that is acquired and installed due to an enlargement of an existing plant or facility. Repair or replacement parts acquired at the time machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed at a new plant or facility. Labor charge for the repair of manufacturing machinery and equipment that is listed as a separate line item on the bill or invoice. Labor charge for the repair of manufacturing machinery and equipment that is not listed separately from the repair parts and supplies on the bill or invoice. Labor charge for the installation of manufacturing machinery and equipment that is listed as a separate line item on the bill or invoice. Labor charge for the installation of manufacturing machinery and equipment specific to automotive manufacturing that is listed separately from the repair parts and supplies on the bill or invoice. Machinery and equipment used to manufacture automobiles that will ultimately be sold at retail that are installed at a new plant or facility. A F C S a l e s a n d U s e U s e r M a n u a l | 61 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 37 277 Manufacturing/Outside Installation Labor-Equip-Separately Stated 37 278 Manufacturing/Repair EquipmentSeparately Stated 37 279 Manufacturing/Replacement Equipment-Separately Stated 37 280 Manufacturing/Clean room Equipment 37 281 Manufacturing/Environmental Control Equip 37 282 Manufacturing/Safety Equip 37 283 Manufacturing/Packing & Shipping Equip 37 284 Manufacturing/Intraplant Equip 37 285 Manufacturing/Hand Tools 37 286 Manufacturing/Warehouse Equipment 38 287 Medical Durable Equipment/Not Home Use-Without A Prescription 38 288 Medical Durable Equipment/Not Home Use-With A Prescription 38 289 Medical Durable Equipment/Not Home Use-Paid For By Medicare Labor charge for the installation of manufacturing machinery and equipment by a third party that is listed as a separate line item on the bill or invoice. Equipment used to repair manufacturing machinery and equipment. Equipment used to replace machinery and equipment used to manufacture items that will ultimately be sold at retail that are installed at an existing plant or facility. Machinery and equipment used to manufacture items that will ultimately be sold at retail that is installed in a clean room environment. Machinery and equipment used to control environmental harm done by the manufacturing process. Machinery and equipment used to enhance the safety of the plant workers encountered by the manufacturing process. Machinery and equipment used to package the finished manufactured product. Machinery and equipment used to take materials from various points in the plant. Tools operated by hand used in the manufacturer of products. Equipment used in the storage of items to be withdrawn later for sale. Medical Equipment that can withstand repeated use and is sold without a prescription. The equipment is not for use in the home by the patient. Medical Equipment that can withstand repeated use and is sold with a prescription. The equipment is not for use in the home by the patient. Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is not for use in the home by the patient. The equipment is paid for directly but Medicare. A F C S a l e s a n d U s e U s e r M a n u a l | 62 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 38 290 Medical Durable Equipment/Not Home Use-Reimbursed By Medicare 38 291 Medical Durable Equipment/Not Home Use-Paid For By Medicaid 38 292 Medical Durable Equipment/Not Home Use-Reimbursed By Medicaid 38 293 Medical Durable Equipment/Home Use-Without A Prescription 38 294 Medical Durable Equipment/Home Use-With A Prescription 38 295 Medical Durable Equipment/Home Use-Paid For By Medicare 38 296 Medical Durable Equipment/Home Use-Reimbursed By Medicare 38 297 Medical Durable Equipment/Home Use-Paid For By Medicaid Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is not for use in the home by the patient. The price of the equipment is reimbursed to the purchaser but Medicare. Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is not for use in the home by the patient. The equipment is paid for directly but Medicaid. Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is not for use in the home by the patient. The price of the equipment is reimbursed to the purchaser but Medicaid. Medical Equipment that can withstand repeated use and is sold without a prescription. The equipment is for use in the home by the patient. Medical Equipment that can withstand repeated use and is sold with a prescription. The equipment is for use in the home by the patient. Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is for use in the home by the patient. The equipment is paid for directly by Medicare. Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is for use in the home by the patient. The price of the equipment is reimbursed to the purchaser by Medicare. Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is for use in the home by the patient. The equipment is paid for directly by Medicaid. A F C S a l e s a n d U s e U s e r M a n u a l | 63 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 38 298 Medical-DurableEquipment-Home Use-Reimbursed By Medicaid 39 299 Medical Mobility Enhancing Equipment/Equip Without a Prescription 39 300 Medical Mobility Enhancing Equipment/Equip With a Prescription 39 301 Medical Mobility Enhancing Equipment/Equip Paid for by Medicare 39 302 Medical Mobility Enhancing Equipment/Equip Reimbursed by Medicare 39 303 Medical Mobility Enhancing Equipment/Equip Paid for by Medicaid 39 304 Medical Mobility Enhancing Equipment/Equip Reimbursed by Medicaid 40 305 40 306 40 307 40 308 40 309 Medical Prosthetic Devices/GeneralWithout a Prescription Medical Prosthetic Devices/GeneralWith a Prescription Medical Prosthetic Devices/GeneralPaid for by Medicare Medical Prosthetic Devices/GeneralReimbursed by Medicare Medical Prosthetic Devices/GeneralPaid for by Medicaid Medical Equipment that can withstand repeated use and is sold without a prescription but is medically necessary. The equipment is for use in the home by the patient. The price of the equipment is reimbursed to the purchaser by Medicaid. Equipment used to enhance the mobility of the patient using the device. The equipment is used without a prescription but is medically necessary. Equipment used to enhance the mobility of the patient using the device. The equipment is used with a prescription. Equipment used to enhance the mobility of the patient using the device. The equipment is used without a prescription but is medically necessary. The equipment is paid for directly by Medicare to the vendor. Equipment used to enhance the mobility of the patient using the device. The equipment is used without a prescription but is medically necessary. The equipment price is reimbursed to the user by Medicare for the purchase. Equipment used to enhance the mobility of the patient using the device. The equipment is used without a prescription but is medically necessary. The equipment is paid for directly by Medicaid to the vendor. Equipment used to enhance the mobility of the patient using the device. The equipment is used without a prescription but is medically necessary. The equipment price is reimbursed to the user by Medicaid for the purchase. A device to replace. A device to replace. A device to replace. A device to replace. A device to replace. A F C S a l e s a n d U s e U s e r M a n u a l | 64 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 40 310 40 311 40 312 40 313 40 314 40 315 40 316 40 317 Medical Prosthetic Devices/Contact Lenses-Without a prescription 40 318 Medical Prosthetic Devices/Contact Lenses-With a prescription 40 319 Medical Prosthetic Devices/Contact Lenses-Paid for by Medicare 40 320 Medical Prosthetic Devices/Contact Lenses-Reimbursed by Medicare 40 321 Medical Prosthetic Devices/Contact Lenses-Paid for by Medicaid 40 322 Medical Prosthetic Devices/Contact Lenses-Reimbursed by Medicaid 40 323 Medical Prosthetic Devices/Hearing Aids-Without a Prescription 40 324 Medical Prosthetic Devices/Hearing Aids-With a Prescription 40 325 Medical Prosthetic Devices/Hearing Aids-Paid for by Medicare Medical Prosthetic Devices/GeneralReimbursed by Medicaid Medical Prosthetic Devices/Corrective Eyeglasses-Without a Prescription Medical Prosthetic Devices/Corrective Eyeglasses-With a Prescription Medical Prosthetic Devices/Corrective Eyeglasses-Paid for by Medicare Medical Prosthetic Devices/Corrective Eyeglasses-Reimbursed by Medicare Medical Prosthetic Devices/Corrective Eyeglasses-Paid for by Medicaid Medical Prosthetic Devices/Corrective Eyeglasses-Reimbursed by Medicaid A device to replace. Corrective eyeglasses. Corrective eyeglasses. Corrective eyeglasses. Corrective eyeglasses. Corrective eyeglasses. Corrective eyeglasses. Contact lenses that enhance ones vision. Purchased without a prescription but is medically necessary. Contact lenses that enhance ones vision. Purchased with a prescription. Contact lenses that enhance ones vision. Purchased without a prescription but is medically necessary. Item is directly paid by Medicare. Contact lenses that enhance ones vision. Purchased without a prescription but is medically necessary. Patient is reimbursed by Medicare for the cost of the item. Contact lenses that enhance ones vision. Purchased without a prescription but is medically necessary. Item is directly paid by Medicaid. Contact lenses that enhance ones vision. Purchased without a prescription but is medically necessary. Patient is reimbursed by Medicaid for the cost of the item. Aids that enhance one’s ability to decipher sound. Purchased without a prescription but is medically necessary. Aids that enhance one’s ability to decipher sound. Purchased with a prescription. Aids that enhance one’s ability to decipher sound. Purchased without a prescription but is medically necessary. Item is directly paid by Medicare. A F C S a l e s a n d U s e U s e r M a n u a l | 65 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 40 326 Medical Prosthetic Devices/Hearing Aids-Reimbursed by Medicare 40 327 Medical Prosthetic Devices/Hearing Aids-Paid for by Medicaid 40 328 Medical Prosthetic Devices/Hearing Aids-Reimbursed by Medicaid 40 329 40 330 40 331 40 332 40 333 40 334 41 106 Motor Vehicles/General Rule 41 335 Motor Vehicles/Low Emission Vehicle exceeding 10,000 lbs 41 336 41 337 41 338 41 339 Motor Vehicles/Sale to Non-Residents 41 340 Motor Vehicles/Trucks - General Rule 41 341 Motor Vehicles/Used in Interstate Commerce Medical Prosthetic Devices/Dental Prosthesis-Without a prescription Medical Prosthetic Devices/Dental Prosthesis-With a prescription Medical Prosthetic Devices/Dental Prosthesis-Paid for by Medicare Medical Prosthetic Devices/Dental Prosthesis-Reimbursed by Medicare Medical Prosthetic Devices/Dental Prosthesis-Paid for by Medicaid Medical Prosthetic Devices/Dental Prosthesis-Reimbursed by Medicaid Motor Vehicles/Vehicles sold to Native Americans Motor Vehicles/Motor Vehicles using Alternative Fuels Motor Vehicles/Low Speed Electrical Vehicles Aids that enhance one’s ability to decipher sound. Purchased without a prescription but is medically necessary. Patient is reimbursed by Medicare for the cost of the item. Aids that enhance one’s ability to decipher sound. Purchased without a prescription but is medically necessary. Item is directly paid by Medicaid. Aids that enhance one’s ability to decipher sound. Purchased without a prescription but is medically necessary. Patient is reimbursed by Medicaid for the cost of the item. A dental device to replace. A dental device to replace. A dental device to replace. A dental device to replace. A dental device to replace. A dental device to replace. Motorized vehicles used to transport people or product on roadways. Motorized vehicles used to transport people or product on roadways, waterways, railways or airspace. Vehicles are over 10,000 lbs and exceed EPA low emission standard. Motorized vehicles used to transport people or product on roadways. Motorized vehicles used to transport people or product on roadways. Motor vehicles not designed for highway use that cannot exceed 35 MPH. Motorized vehicles used to transport people or product on roadways Motorized vehicles used to transport product on roadways. Can be a single chassis or a tractor/trailer rig. Vehicles used to transport people or product to more than one state. A F C S a l e s a n d U s e U s e r M a n u a l | 66 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 41 342 Motor Vehicles/Trailer 13-16.5 TonsInterstate Commerce 41 343 Motor Vehicles/Tractor Exceeds 16.5 Tons-Interstate Commerce 41 344 Motor Vehicles/Used as a Contact Carrier 41 345 Motor Vehicles/Trailer Exceeds 13 Tons-Contract Carrier 41 346 Motor Vehicles/Tractor Exceeds 16.5 Tons-Contract Carrier 41 347 Motor Vehicles/Motor Boats 41 348 Motor Vehicles/Aircraft 41 349 Motor Vehicles/Aircraft for Interstate Transport 41 350 41 351 41 352 Motor Vehicles/Motorcycles 41 353 Motor Vehicles/Mopeds 41 354 Motor Vehicles/Off-Road Vehicles 41 355 Motor Vehicles/Snowmobiles 41 356 Motor Vehicles/Motor Oil 41 357 Motor Vehicles/Antifreeze 41 358 Motor Vehicles/Boat Motor 42 359 Newspaper/Retail Motor Vehicles/Batteries Less than 12 Volts--Lead Based Motor Vehicles/Batteries Greater than 12 Volts--Lead Based A motor vehicle whose laden gross vehicle weight is between 13 and 16.5 tons and is used to transport people or product to more than one state. A motor vehicle whose laden gross vehicle weight exceeds 16.5 tons and is used to transport people or product to more than one state. A motor vehicle that is used to transport product for the general public (common carrier) or only for specific entities (contract carrier) and is not classified for interstate commerce. A motor vehicle whose laden gross vehicle weight is between 13 and 16.5 tons. Does not cover those classified as common carriers. A motor vehicle whose laden gross vehicle weight exceeds 16.5 tons. Does not cover those classified as common carriers. A boat propelled by an internal combustion engine. A machine or device capable of atmospheric flight. A machine or device capable of atmospheric flight used for interstate transport. Batteries with 12 volts or less of electrical output. Batteries with 12 volts or greater of electrical output. A two-wheeled motorized vehicle classified as a motorcycle. A two-wheeled motorized vehicle classified as a moped. Motor vehicles not designed are intended for driving on the highway. A motor vehicle with ski runners used to navigate in the snow. Oil meant to lubricate the moving parts of a motor. A substance mixed with another liquid to lower that liquids freezing point. A motor used by a boat propelled by an internal combustion engine. A newsprint publication sold at a newsstand. A F C S a l e s a n d U s e U s e r M a n u a l | 67 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 42 360 Newspaper/CD ROM Microfiche 42 361 Newspaper/Digital Product - Retail 42 362 Newspaper/Digital Product Subscription 42 363 Newspaper/Subscription Mail 42 364 Newspaper/Subscription Delivery 43 106 Prepared Food/General Rule 43 365 Prepared Food/Food sold by a Food Manufacturer 43 366 Prepared Food/Food sold in an unheated state 43 367 Prepared Food/Bakery items 43 368 Prepared Food/Employee Meals--Full Price 43 369 Prepared Food-Employee Meals-Reduced Price 43 370 Prepared Food/Employee Meals--Free to Employees 43 43 371 372 Prepared Food/Tips - Voluntary Prepared Food/Tips - Mandatory 43 373 Prepared Food/Non-Tip Based Service Charge 43 620 Prepared Food/Take and Bake Pizza 44 106 Rentals & Leasing/General Rule A newsprint publication sold as microfiche or CD ROM generally for reference purposes. A newsprint publication transveyed electronically and sold online on a per copy basis. A newsprint publication transveyed electronically and sold online as part of a subscription to the newspaper. A newsprint publication physically delivered to the subscriber by second class or lower mail. A newsprint publication physically delivered to the subscriber not by second class or lower mail. Food and drink ready for consumption without further preparation. Food Sold by a seller whose proper primary NAICS classification is manufacturing in sector 311. Food for on-site consumption that was presented in an unheated state. Items commonly referred to as confectionary items that are sold for the purposes of on-site consumption. Meals furnished for employees by their employer. Meals are priced at retail Meals furnished for employees by their employer. Meals are priced below retail or at cost. Meals furnished for employees by their employer. Meals are provided free of charge. Tax measure if needed would be cost Voluntary Mandatory Charge imposed by the restaurant beyond the remuneration to either the wait staff directly or the payment for food provided. Pizza that is not fully baked by the restaurant, but is instead packaged and must be fully baked by the customer outside the Restaurant. Items rented from a vendor not otherwise mentioned. A F C S a l e s a n d U s e U s e r M a n u a l | 68 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 44 374 Rentals & Leasing/Uniform Rental Service 44 375 Rentals & Leasing/Automotive Rental-30 Days or Less 44 376 Rentals & Leasing/Automotive Rental-30-180 Days 44 377 Rentals & Leasing/Automotive Rental-180 Days to 1 Year 44 378 Rentals & Leasing/Automotive Rental-1 Year or Greater 44 379 Rentals & Leasing/Automotive Rental0-30 Days-Tax Paid 44 380 Rentals & Leasing/Automotive Rental31-180 Days-Tax Paid 44 381 Rentals & Leasing/Automotive Rental180 Days-1 Year-Tax Paid 44 382 Rentals & Leasing/Automotive RentalGreater than 1 Year-Tax Paid 44 383 Rentals & Leasing/Lease of Automobile to be registered by lessee 44 384 Rentals & Leasing/Amusement Related Property 44 385 Rentals & Leasing/Rentals Incidental to Service 44 386 Rentals & Leasing/Movie Rentals-Private Use--Physical Medium 44 387 44 388 44 389 Rentals & Leasing/Movie Rentals-Private Use--Digital Download Rentals & Leasing/Movie Rentals--As part of exhibition to public Rentals & Leasing/Movie Rentals--To a Television Station The rental of commercial uniforms. Uniforms are generally cleaned by the linen service and reused. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 30 days or less. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 30 to 180 days. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 180 days to 1 year. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 1 year or greater. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 30 days or less. Tax is paid at the purchase of the asset. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 30 to 180 days. Tax is paid at the purchase of the asset. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 180 days to 1 year. Tax is paid at the purchase of the asset. Rental of an automotive vehicle to use as a motor vehicle. The rental period is for 1 year or greater. Tax is paid at the purchase of the asset. Lease of an automobile to someone who will register the car as if they own it. Items rented from a vendor meant to be used along with a service meant for the amusement of the vendee Items that form only a minor part in the performance of the overall service being sold. Movies rented for private viewing transveyed by DVD or other physical means. Movies rented for private viewing transveyed by electronic means Movies rented to movie theatres and the like for exhibition to the public for a fee. Movies rented to television stations and networks for exhibition to the public. A F C S a l e s a n d U s e U s e r M a n u a l | 69 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type 45 390 45 391 45 392 45 393 45 394 45 395 NAME DESCRIPTION Services Cleaning/Dry CleaningClothing Services Cleaning/Dry Cleaning-Non Clothing Services Cleaning/Cleaning Services Services Cleaning/Laundry & Clothing Care-Other Items Services Cleaning/Laundry & Clothing Care-Cloth Diapers Services Cleaning/Laundry & Clothing Care-Coin Operated 45 396 Services Cleaning/Rug Cleaning off customer premises 45 397 Services Cleaning/Rug Cleaning on customer premises 45 398 45 399 45 400 45 401 45 571 46 402 46 403 46 404 46 405 46 406 46 407 46 408 46 409 47 410 Services Cleaning/Washing Motor Vehicles Services Cleaning/Washing Motor Vehicles-Coin Operated Device Services Cleaning/Solid Waste Disposal Services Cleaning/Swimming Pool Services Services-Cleaning - Recycling Services Lodging/Hotel Rooms Less than 28 Days Services Lodging/Hotel Rooms 28-29 Days Services Lodging/Hotel Rooms 30-31 Days Services Lodging/Hotel Rooms 32-60 Days Services Lodging/Hotel Rooms 61-90 Days Services Lodging/Hotel Rooms-91-120 Days Services Lodging/Hotel Rooms 121180 Days Services Lodging/Hotel Rooms Greater than 180 Days Services Printing/Photography Services-Labor Only The cleansing of clothing by means of a nonaqueous substance. The cleansing of non clothing items by means of a nonaqueous substance. A fee paid for the service of cleaning a dwelling. The washing The washing The washing Covering the off-site cleaning of rugs that are not affixed to real property. The service must not include any other type of cleaning. Covering the on-site cleaning of rugs that are not affixed to real property. The service must not include any other type of cleaning. The washing The washing A charge for the disposal of refuge. Charges for cleaning Charges for recycling A charge for lodging not to exceed 28 days. A charge for lodging to cover a stay between 28 and 30 consecutive days. A charge for lodging to cover a stay between 30 and 31 consecutive days. A charge for lodging to cover a stay between 31 and 60 consecutive days. A charge for lodging to cover a stay between 60 and 90 consecutive days. A charge for lodging to cover a stay between 90 and 120 consecutive days. A charge for lodging to cover a stay between 120 and 180 consecutive days. A charge for lodging to cover a stay greater than 180 consecutive days. A fee for photography. A F C S a l e s a n d U s e U s e r M a n u a l | 70 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 47 411 Services Printing/Photography Services-Labor with pictures 47 412 Services Printing/Negative to Standard Sized Pictures-Labor Only 47 413 Services Printing/Negative to Enlargement Sized Pictures-Labor Only 47 414 Services Printing/Printing Services 47 415 Services Printing/Copying Services 48 416 Services Professional/Credit Card Processing Fee-Part of Sale 48 417 Services Professional/Credit Card Processing Fee-Separate Sale 48 418 Services Professional/Professional Services 48 419 Services Professional/Investigative Services 48 420 Services Professional/Protection & Security Services 48 421 Services Professional/Pest Control 48 422 48 423 48 424 48 425 48 426 Services Professional/Interior Design Services Services Professional/Skin Alteration & Care Services Professional/Manicure & Pedicure Services Professional/Funeral Services Services Professional/Cosmetic Medical Procedures A fee for photography. Labor to develop standard sized pictures from negatives. The negatives are provided by the customer. Labor to enlarge pictures from negatives. The negatives are provided by the customer. Charges for printing or imprinting items unto tangible personal property provided directly or indirectly by the customer. Charges for duplicating customer provided materials to another document. A fee charged by the vendor to recover credit card processing cost. The fee is charged as part of the sale. A fee charged by the vendor to recover credit card processing cost. The fee is charged as a separate sale. A service rendered for a fee in one of the learned professions. This is a default classification and meant to cover any fee not covered in another service type. A fee paid for the service of tracking or closely examining another individual. A fee paid for the service of protecting or securing real or tangible personal property. A fee paid for the service of eradicating insects or other animals classified as pests in a dwelling. A fee paid for consulting on changing the interior appearance of a building. A fee paid for the process of altering or maintaining the skin of a human A fee paid for cleaning. Fees A service rendered for a fee in one of the learned professions. This classification covers any procedure involving exterior non-life threatening external procedures mainly done to enhance a person's appearance. A F C S a l e s a n d U s e U s e r M a n u a l | 71 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 48 427 Services Professional/Professional Medical Services 48 428 Services Professional/Title 48 429 Services Professional/Dating Service 48 430 Services Professional/Escrow 48 431 Services Professional/Massages 48 432 Services Professional/Gift Wrapping 48 433 Services Professional/Floral Services 48 434 Services Professional/Advertising 48 435 Services Professional/Credit and Reporting Services 48 436 48 437 48 438 48 439 Services Professional/Background Music Services 48 440 Services Professional/Locksmith Services 48 441 Services Professional/Lobbying 48 442 48 443 Services Professional/Personnel Services Services Professional/Lettering Services Services Professional/Collection Services Services Professional/Flight Instruction Services Professional/Investment Counseling A service rendered for a fee in one of the learned professions. This classification covers any medical procedure not otherwise covered as a cosmetic medical procedure. A fee charged to register ownership of real property. A service used to facilitate potential personal relationships. A deposit rendered in good faith to ensure future business transactions. Manipulation of tissues with the hand or an instrument for therapeutic purposes. The process of wrapping tangible personal property in order to further conceal its true nature. Non-Delivery type services covering the arrangement and consultation concerning floral arrangements and bouquets. This does not cover the floral items themselves. Fees paid for the services used generally to advertise a company's message in printed form. Fees paid for the right to obtain and use results from the credit history of individuals and businesses. A service used to facilitate the match of a employer with a suitable employee. Fees paid to attach to signage or a permanent surface letters. A service used to help recover back debts due to the collector. Services that provide music for a fee to various businesses to create further ambiance. Any lock or key related service. Services that help facilitate further relationships between their customers and government officials. Any service covering the instruction on how to fly an airplane. Services that assist customers in their financial and investment decisions. A F C S a l e s a n d U s e U s e r M a n u a l | 72 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 48 444 Services Professional/Service Chg. Financial Institution 48 445 Services Professional/Tow Service 48 446 Services Professional/Taxidermy 48 447 Services Professional/Telephone Answering Service 48 448 Services Professional/Limousine Service 48 449 Services Professional/Architecture 48 450 Services Professional/Tanning Services 48 451 48 452 48 453 Services Professional/Engraving 48 454 Services Professional/House Moving 48 455 Services Professional/Counseling 48 456 48 457 48 557 Services-Professional/Information Systems Services 48 458 Services Professional/Sale of Insurance 49 459 Services Recreation/Sporting Event with Food or Property Services Professional/Pet Grooming-Not done in medical setting Services Professional/Pet Grooming-Done in Medical Setting Services Professional/Day Care Services Services Professional/Investment Commissions Fees charged by banks to their customers for services performed by the bank. These fees are generally bank account and ATM charges. Service that removes a motor vehicle and relocates that vehicle to another site. A fee charged to prepare. Fee charged to answer phones and take messages on behalf of an individual or business. Rental of a driver and automobile used at the discretion of the customer with the driver retaining the control of the physical asset. A service rendered for a fee in the learned profession of architecture. Generally this service is used for designing and conceptualizing a future building or expanse. Services used to enhance the physical appearance of an individual through exposure to artificial light. Services covering the cleansing Services covering the cleansing Fees paid to etch letters or numbers into tangible personal property. Labor used to physically move a building intended to become real property from one location to another. Fee charged for professional mental health counseling. Fee charged for taking care of individuals during the day. Commissions earned for assisting with direct investment decisions. Charge for the manipulation of user’s data. This is not to be confused with the transmission of data. Premiums for insuring individuals for a specified purpose. An event generally classified as involving sports with food or property sold on the premises. This does not include boxing A F C S a l e s a n d U s e U s e r M a n u a l | 73 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 49 460 Services Recreation/Sporting Event without Food or Property 49 461 Services Recreation/Amusement Park Entry with Food or Property 49 462 Services Recreation/Amusement Park Entry without Food or Property 49 463 Services Recreation/Other Amusement Entry with Food or Property 49 464 Services Recreation/Other Amusement Entry without Food or Property 49 465 Services Recreation/Admission to Boxing and Wrestling 49 466 Services Recreation/Admission to Horse Racing 49 467 49 468 49 469 49 470 49 471 49 472 50 473 50 474 Services Repair/Repair and Labor Combined 50 475 Services Repair/Parts used in Clothing or Shoes Services Recreation/Admission to a Motion Picture Services Recreation/Tours for 8-25 people Services Recreation/Tours for more than 25 people Services Recreation/Tours for 8-25 people--Commissions Services Recreation/Tours for more than 25 people--Commissions Services Recreation/Sport -Fitness & Recreation Club Services Repair/Repair Parts - General Rule An event generally classified as involving sports without food sold on the premises. This does not include boxing Generally a place with rides and games of chance with food or property sold on the premises Generally a place with rides and games of chance without food or property sold on the premises Amusement Events that do not fit the definition of either a sporting event or an amusement park. There is food and/or property sold on the premises. This does not include a fee for admittance to a motion picture. Amusement Events that do not fit the definition of either a sporting event or an amusement park. There is not food and/or property sold on the premises. This does not include a fee for admittance to a motion picture. A fee for an event generally considered to contain boxing and/or wrestling matches sanctioned by the state athletic commission. A fee for an event generally considered to contain horse races sanctioned by the state athletic commission. A fee for admission to view a motion picture. A fee. A fee. A sales commission for selling a tour of no less than 8 but no more than 25 people. A sales commission for selling a tour for more than 25 people. Fitness & Recreation Club Parts used to regain the function of or extend the operational life of an item. Transaction combining labor and parts used to regain the function of or extend the operational life of an item. Items used to repair clothing or shoes. A F C S a l e s a n d U s e U s e r M a n u a l | 74 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 50 476 50 477 50 478 50 479 50 480 50 481 50 482 50 483 50 484 50 485 50 486 50 487 Services Repair/Repair of Commercial Jet Aircraft 50 488 Services Repair/Jewelry Repair 51 489 Services Storage/Storage 51 490 Services Storage/Parking 52 106 Tires/General Rule 53 106 Tobacco/General Rule 53 535 Tobacco/Cigarettes 54 536 Tooling/Useful Life Between 12 Months and 3 years 54 537 Tooling-Useful Life Between 6-12 /Months Services Repair/Parts used in repair of Commercial Airplanes Services Repair/Extended Warranty Repair Parts Used Services Repair/Extended Warranty Service Repairs Used Services Repair/Repair Labor General Rule Services Repair/Repairs of Clothing Services Repair/Repair of Railroad Rolling Stock and Engines Services Repair/Repair of Motor Vehicle Services Repair/Shoe Repair and Cleaning Services Repair/Automotive Painting Services Repair/Landscaping & Lawn Care Services Repair/Snow Removal Parts used to regain the function of or extend the operational life of an airplane. Repair parts provided under an extended warranty. Repair services provided under an extended warranty. Labor used to regain the function of or extend the operational life of an item. Labor used in repairing clothing. Repair of railcars and locomotive engines. Repair of motorized vehicles used to transport people or product on roadways Cleaning and/or repair of items normally worn on the feet of the user. Administering paint unto a motor vehicle classified as an automobile. A fee paid for the alteration or maintenance of any plants. Labor to remove snow from property. Labor used to regain the function of or extend the operational life of an airplane. Labor used to repair jewelry. A charge for storing tangible personal property. Charge for the service of providing parking or storage of automobiles. To account for pneumatic devices commonly known as tires. Products made from tobacco leaves and processed for uses other than cigarettes. A slender roll of cut tobacco meant to be smoked. Classified generally as cigarettes as packaged. Machining tools with a useful life between twelve months and three years that are used on equipment. Examples are cutting bits and dies. Machining tools with a useful life of six to twelve months that are used on equipment. Examples are cutting bits and dies. A F C S a l e s a n d U s e U s e r M a n u a l | 75 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER Trans Type Svc Type NAME DESCRIPTION 54 538 Tooling/Useful Life Exceeds 3 years 54 539 Tooling/Useful Life Less Than 6 Months 55 106 Vending/General Rule 55 237 Vending/Ice 55 540 55 541 55 542 55 543 55 544 55 545 55 546 55 547 55 548 55 549 55 55 550 551 56 552 56 553 Information Services/Public-Electronic Transmission 56 554 Information Services/Private-Physical Transmission 56 555 Information Services/PrivateElectronic Transmission 56 645 Information Services/Public-Elec Trans (Financial & Securities) Vending/Candy Sold For $0.76 or More Vending/Candy Sold For $0.50 or Less Vending/Candy Between $0.51 and $0.75 Vending/Chewing Gum Sold For $0.76 or More Vending/Chewing Gum Sold For $0.50 or Less Vending/Chewing Gum Between $0.51 and $0.75 Vending/Hot Prepared Food Vending/Carbonated Beverages For $0.76 or More Vending/Carbonated Beverages For $0.51 to $0.75 Vending/Carbonated Beverages For $0.50 or Less Vending/Non-Carbonated Beverages Vending/Hot Beverages Information Services/Public-Physical Transmission Machining tools with a useful life of three years or more that are used on equipment. Examples are cutting bits and dies. Machining tools with a useful life of less than six months that are used on equipment. Examples are cutting bits and dies. A machine that is operated by coin. Ice for human consumption sold from a vending machine. Items including chocolate. Items including chocolate. Items including chocolate. Chewing gum selling for $0.76 or more. Chewing gum selling for $0.50 or less. Chewing gum selling between $.51 and $.75. A machine that is operated by coin. A machine that is operated by coin. A machine that is operated by coin. A machine that is operated by coin. A machine that is operated by coin. A machine that is operated by coin. Information Services that is public and making a physical transmission. A service providing the passive receipt of information other than financial account or securities trading data to the public by electronic means. Information Services that is private and making a physical transmission. Information Services that is private and making an electronic transmission. A service providing the passive receipt of financial account or securities information to the public by electronic means. A F C S a l e s a n d U s e U s e r M a n u a l | 76 of 329 Copyright 2018 Avalara, Inc. Table 4-18 Transaction and Service Types IDENTIFIER NAME DESCRIPTION Trans Type Svc Type 57 560 Digital Goods/Download from Internet 57 561 Digital Goods/Download to Phone 57 609 Digital Goods/Streaming Video 57 633 Digital Goods/Downloaded Video The purchase of goods such as music, books, or phone ringtones downloaded from the internet. The purchase of goods such as ringtones downloaded to a cell phone. The purchase of video via the internet. The purchaser does not retain possession of the video. The purchase of video via the internet. Tax Types When a transaction is processed through the AFC Engine, a Tax Type is assigned based on the results. The Tax Type is determined by the transaction location and transaction/service pairs provided in the transaction record and is used to accurately describe the exact nature of the tax applied (refer to Table 419 ). With over 170 Tax Types available, highly detailed and specific tax descriptions are provided for use in taxation disclosure. This is useful in billing and customer service, and simplifies tax compliance filing. Users can only control the tax types with the Avalara EZdata product (sold separately). AFC allows for a change, referred to as an override (see section 4.1.3), of the rate for a specific tax type and tax level in a specific jurisdiction. When overriding a tax type, the tax type must exist in the jurisdiction where for the override is to be made. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 1 NAME Sales Tax 4 District Tax 11 Service Tax 12 Special Tax 17 Sales Web Hosting 24 Telecommunications Infrastructure Maintenance Fee 32 District Tax (Residential) 33 Transit Tax DESCRIPTION This is a tax on the privilege of purchasing goods and services. District taxes are taxes associated with a particular district. This is typically this is a school district; however it could be a redevelopment, sports entertainment or some other type of district. This tax is used to fund a service such as the telecommunications relay service for the deaf. Used to specify a tax that does not fit into a typical category. Similar to tax type 1 (Sales Tax) but applies only to web hosting services. Fee used to fund the maintenance of telecommunications infrastructure (network, switches, etc.). Similar to tax type 4 (District Tax) but applies only to a residential customer. A specific state, county, district or local tax used to support a transportation district or program. If this is a district program, the boundaries can overlap county and local jurisdictions. A F C S a l e s a n d U s e U s e r M a n u a l | 77 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID NAME 42 Sales Tax (Business) 49 Use Tax 50 Sales Tax (Data) 57 Sales Tax (Interstate) 64 Communications Services Tax 65 Value Added Tax (VAT) 66 67 68 69 94 Goods and Services Tax (GST) Harmonized Sales Tax (HST) Provincial Sales Tax (PST) Quebec Sales Tax (QST) Crime Control District Tax 95 Library District Tax 96 Hospital District Tax 97 98 Health Services District Tax Emergency Services District Tax 99 Improvement District Tax 100 Development District Tax 102 Ambulance District Tax 103 Fire District Tax 104 Police District Tax 105 Football District Tax 106 Baseball District Tax 119 Educational Sales Tax 120 Educational Use Tax 124 Convention Center Tax 126 School Board Tax A DESCRIPTION Similar to tax type 1 (Sales Tax) but applies only to a business customer. An ad Val Orem tax on the use, consumption, or storage of tangible property and usually assessed at the same rate as the sales tax of the applicable jurisdiction. Similar to tax type 1 (Sales Tax) but applies only on data services. Similar to tax type 1 (Sales Tax) but applies only on interstate telecom services. A tax on end users who consume communication services. International based tax on the final consumption of certain goods and services. National Canadian VAT on the consumption of goods and services. Provincial sales tax applied in specific Canadian provinces. Rate is a combination of the provincial sales tax and the national GST. Sales tax applied in various Canadian provinces. Specific sales tax applied only in the province of Quebec, Canada. A specific district tax that supports a crime control program. This district can overlap county and local jurisdictions. A specific district tax that supports a library program. This district can overlap county and local jurisdictions. A specific district tax that supports hospital program. This district can overlap county and local jurisdictions. A specific district tax that supports a health services program. This district can overlap county and local jurisdictions. A specific district tax that supports an emergency services program. This district can overlap county and local jurisdictions. A specific district tax that supports a public improvement program. This district can overlap county and local jurisdictions. A specific district tax that supports a development program. This district can overlap county and local jurisdictions. A specific district tax that supports an ambulance program. This district can overlap county and local jurisdictions. A specific district tax that supports a fire district. This district can overlap county and local jurisdictions. A specific district tax that supports a police district. This district can overlap county and local jurisdictions. A specific district tax that supports a football program. This district can overlap county and local jurisdictions. A specific district tax that supports a baseball program. This district can overlap county and local jurisdictions. Sales tax designated specifically for education and reported apart from the general sales tax. Use tax designated specifically for education and reported apart from the general use tax. Sales Tax designated for convention or conference centers. Tax to fund School Board. This is typically a Sales Tax. The letter designation is used in compliance reporting. A F C S a l e s a n d U s e U s e r M a n u a l | 78 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID NAME 127 School Board Tax B 128 School Board Tax C 129 School Board Tax D 130 School Board Tax E 131 School Board Tax F 132 School District Tax 133 Police Jury Tax B 134 Police Jury Tax C 135 Police Jury Tax E 139 Advanced Transit Tax 145 Tribal Sales Tax Sales Tax (Data Processing) 146 160 Statutory Gross Receipts (Business) 172 Statutory Gross Receipts (Video) 176 Sales Tax - Senior Citizen 184 Sales Tax-Manufacturing 185 Use Tax-Manufacturing 186 187 Sales Tax-Motor Vehicles Use Tax-Motor Vehicles 188 Rental Tax 189 Rental Tax-Linen 190 Sales Tax-Vending 191 192 193 194 195 Rental Tax-Motor Vehicles Sales Tax-Wholesale Sales Tax-Food and Drugs Sales Tax-Food Fur Tax DESCRIPTION Tax to fund School Board. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund School Board. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund School Board. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund School Board. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund School Board. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund a School District. This is typically a Sales Tax. Tax to fund Police jurisdictions. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund Police jurisdictions. This is typically a Sales Tax. The letter designation is used in compliance reporting. Tax to fund Police jurisdictions. This is typically a Sales Tax. The letter designation is used in compliance reporting. A specific state, county, district or local tax used to support a transportation district or program. If this is a district program, the boundaries can overlap county and local jurisdictions. Sales tax imposed by an Indian Tribe. This is a tax imposed on the sale of data processing services. Tax based upon the gross receipts of one or more transaction and service type combinations. This tax type is returned when there is a difference between the business rate and other rates. Tax based upon the gross receipts of video services such as cable or satellite. Similar to tax type 1 (Sales Tax) but only applies to Senior Citizens who meet certain age requirements. Refers to a sales tax rate charged on the sale of manufacturing machinery and other manufacturing related items. Refers to a use tax rate charged on the sale of manufacturing machinery and other manufacturing related items. Refers to a sales tax rate charged on the sale of motor vehicles. Refers to a use tax rate charged on the sale of motor vehicles. Tax exclusively on the rental of any item not specifically taxed by another rental tax. Tax covering the rental of linen based supplies. Sales tax that applies to the retail sale of items sold through vending machines. Tax covering the rental of motor vehicles. Sales Tax applying to wholesale transactions. Refers to a rate charged on the sale of food, drugs or beverages. Refers to a rate charged on the sale of food or beverages. Tax charged on the sale of furs. A F C S a l e s a n d U s e U s e r M a n u a l | 79 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID NAME 197 Lead Acid Battery Fee 198 200 202 Sales Tax-Motor Fuel Lead Acid Battery FeeLarger Battery Sales Tax-Parking Dry Cleaning Fee 203 White Goods Tax 199 204 205 206 207 Sales Tax-Medical Equipment Electronic Waste Recycling Fee-Small Electronic Waste Recycling Fee-Medium Electronic Waste Recycling Fee-Large 208 Alcoholic Beverage Tax 209 Sales Tax-Alcohol 210 Liquor Drink Tax 243 Solid Waste Collection Tax 273 Sales Tax – Other 279 Education Cess Secondary and Higher Education Cess 280 281 Utility Users Tax (Video) 294 Oklahoma Sales Tax 296 Premier Resort Area Tax 313 314 315 318 NY Sales Tax NY Local Transit Tax NY Local District Tax Food and Beverage Tax 321 Vendor Use Tax 322 District Vendor Use Tax 323 Special Vendor Use Tax 324 Transit Vendor Use Tax DESCRIPTION Fee charged to cover the cost involved in the disposing of lead based batteries. Refers to a sales tax rate charged on the sale of motor fuel. Fee charged for batteries over a certain pre-described voltage to cover the cost involved in disposing lead based batteries. Tax on the fee charged for the parking of motor vehicles. Fee charged on the sale of dry cleaning services. A fee applied to the sale of certain appliance and appliance type items to cover the disposal of such items. Sales Tax that applies exclusively to the sale of medical equipment. A fee charged for smaller monitors to cover the disposal of such items. A fee charged for certain sized monitors fitting between certain dimensions to cover the disposal of such items. A fee charged for larger monitors to cover the disposal of such items. Alcoholic Beverages taxed under a different tax in lieu or in addition to sales tax. Refers to a sales tax rate charged on the sale of alcohol. Applies where there is a distinct rate on the sale of mixed drinks ready for on-site consumption. Tax on the service of removing solid waste. Refers to a separate sales tax rate charged on transactions that do not fall into another existing category A tax levied to collect funds for education. A tax levied to collect funds for secondary and higher education. Similar to Tax Type 16 (Utility Users Tax) but applies only on Video services. Similar to Tax Type 1 (Sales Tax) but applies only in Oklahoma. Similar to Sales Tax (Tax Type 1) , but applied only in Premier Resort Areas. Similar to Tax Type 1 (Sales Tax) but applied only in New York. Similar to Tax Type 33 (Transit Tax) but applied only in New York. Similar to Tax Type 4 (District Tax) but applied only in New York. A rate charged on the sale of food or beverages. An ad valorem tax on the use, consumption, or storage of tangible property and usually assessed at the same rate as the sales tax of the applicable jurisdiction. District taxes are taxes associated with a particular district. Typically this is a school district, however, it could be a redevelopment, sports, entertainment or some other type of district. Used to specify a tax that does not fit into a typical category. A specific state, county, district or local tax used to support a transportation district or program. If this is a district program, the boundaries can overlap county and local jurisdictions. A F C S a l e s a n d U s e U s e r M a n u a l | 80 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 NAME Crime Control District Vendor Use Tax Library District Vendor Use Tax Hospital District Vendor Use Tax Health Services District Vendor Use Tax Emergency Services District Vendor Use Tax Improvement District Vendor Use Tax Development District Vendor Use Tax Ambulance District Vendor Use Tax Fire District Vendor Use Tax Football District Vendor Use Tax Baseball District Vendor Use Tax Educational Vendor Use Tax School District Vendor Use Tax Advanced Transit Vendor Use Tax Tribal Vendor Use Tax Vendor Use Tax-Senior Citizen Vendor Use TaxManufacturing Vendor Use Tax- Motor Vehicles Vendor Use Tax-Vending Vendor Use Tax- Food and Drugs Vendor Use TaxFood Vendor Use Tax-Motor Fuel Vendor Use Tax-Parking Vendor Use Tax-Medical Equipment Alcoholic Beverage Vendor Use Tax DESCRIPTION A specific district tax that supports a crime control program. This district can overlap county and local jurisdictions. A specific district tax that supports a library program. This district can overlap county and local jurisdictions. A specific district tax that supports hospital program. This district can overlap county and local jurisdictions. A specific district tax that supports a health services program. This district can overlap county and local jurisdictions. A specific district tax that supports an emergency services program. This district can overlap county and local jurisdictions. A specific district tax that supports a public improvement program. This district can overlap county and local jurisdictions. A specific district tax that supports a development program. This district can overlap county and local jurisdictions. A specific district tax that supports an ambulance program. This district can overlap county and local jurisdictions. A specific district tax that supports a fire district. This district can overlap county and local jurisdictions. A specific district tax that supports a football program. This district can overlap county and local jurisdictions. A specific district tax that supports a baseball program. This district can overlap county and local jurisdictions. Use tax designated specifically for education and reported apart from the general use tax. Tax to fund a School District. A specific state, county, district or local tax used to support a transportation district or program. If this is a district program, the boundaries can overlap county and local jurisdictions. Use tax imposed by an Indian Tribe. Similar to tax type 321 (Vendor Use Tax) but only applies to Senior Citizens who meet certain age requirements. Refers to a use tax rate charged on the sale of manufacturing machinery and other manufacturing related items. Refers to a use tax rate charged on the sale of motor vehicles. Use Tax that applies to the retail sale of items sold through vending machines. Refers to a rate charged on the sale of food, drugs or beverages. Refers to a rate charged on the sale of food or beverages. Refers to a tax rate charged on the sale of motor fuel. Tax on the fee charged for the parking of motor vehicles. Tax that applies exclusively to the sale of medical equipment. Alcoholic Beverages taxed under a different tax in lieu of or in addition to sales tax. A F C S a l e s a n d U s e U s e r M a n u a l | 81 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 350 351 352 353 354 355 356 NAME Vendor Use Tax-Alcohol Liquor Drink Vendor Use Tax Vendor Use Tax-Video Premier Resort Area Vendor Use Tax NY Transit Vendor Use Tax NY District Vendor Use Tax Vendor Use Tax-Food and Beverage 357 Consumer Use Tax 358 District Consumer Use Tax 359 Special Consumer Use Tax 360 Transit Consumer Use Tax 361 362 363 364 365 366 367 368 369 370 371 372 Crime Control District Consumer Use Tax Library District Consumer Use Tax Hospital District Consumer Use Tax Health Services District Consumer Use Tax Emergency Services District Consumer Use Tax Improvement District Consumer Use Tax Development District Consumer Use Tax Ambulance District Consumer Use Tax Fire District Consumer Use Tax Football District Consumer Use Tax Baseball District Consumer Use Tax Educational Consumer Use Tax DESCRIPTION Refers to a sales tax rate charged on the sale of alcohol. Applies where there is a distinct rate on the sale of mixed drinks ready for on-site consumption. A tax charged on the provision of video services. Similar to Use Tax (Tax Type 49), but applied only in Premier Resort Areas. Similar to Tax Type 33 (Transit Tax), but applied only in New York. Similar to Tax Type 4 (District Tax), but applied only in New York. A rate charged on the sale of food or beverages. An ad valorem tax on the use, consumption, or storage of tangible property and usually assessed at the same rate as the sales tax of the applicable jurisdiction. District taxes are taxes associated with a particular district. Typically this is a school district, however, it could be a redevelopment, sports, entertainment or some other type of district. Used to specify a tax that does not fit into a typical category. A specific state, county, district or local tax used to support a transportation district or program. If this is a district program, the boundaries can overlap county and local jurisdictions. A specific district tax that supports a crime control program. This district can overlap county and local jurisdictions. A specific district tax that supports a library program. This district can overlap county and local jurisdictions. A specific district tax that supports hospital program. This district can overlap county and local jurisdictions. A specific district tax that supports a health services program. This district can overlap county and local jurisdictions. A specific district tax that supports an emergency services program. This district can overlap county and local jurisdictions. A specific district tax that supports a public improvement program. This district can overlap county and local jurisdictions. A specific district tax that supports a development program. This district can overlap county and local jurisdictions. A specific district tax that supports an ambulance program. This district can overlap county and local jurisdictions. A specific district tax that supports a fire district. This district can overlap county and local jurisdictions. A specific district tax that supports a football program. This district can overlap county and local jurisdictions. A specific district tax that supports a baseball program. This district can overlap county and local jurisdictions. Use tax designated specifically for education and reported apart from the general use tax. A F C S a l e s a n d U s e U s e r M a n u a l | 82 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 NAME School District Consumer Use Tax Advanced Transit Consumer Use Tax Tribal Consumer Use Tax Consumer Use TaxSenior Citizen Consumer Use TaxManufacturing Consumer Use TaxMotor Vehicles Consumer Use TaxVending Consumer Use Tax-Food and Drugs Consumer Use Tax-Food Consumer Use TaxMotor Fuel Consumer Use TaxParking Consumer Use TaxMedical Equipment Alcoholic Beverage Consumer Use Tax Consumer Use TaxAlcohol Liquor Drink Consumer Use Tax Consumer Use Tax-Video Premier Resort Area Consumer Use Tax NY Local Transit Consumer Use Tax NY Local District Consumer Use Tax Consumer Use Tax- Food and Beverage 395 Business & Occupation Tax-Rent and Royalty 396 Business & Occupation Tax-Other Services 398 Rural Transportation Authority District Tax 399 MHA District Tax DESCRIPTION Tax to fund a School District. A specific state, county, district or local tax used to support a transportation district or program. If this is a district program, the boundaries can overlap county and local jurisdictions. Use tax imposed by an Indian Tribe. Similar to tax type 321 (Vendor Use Tax) but only applies to Senior Citizens who meet certain age requirements. Refers to a use tax rate charged on the sale of manufacturing machinery and other manufacturing related items. Refers to a use tax rate charged on the sale of motor vehicles. Use Tax that applies to the retail sale of items sold through vending machines. Refers to a rate charged on the sale of food, drugs or beverages. Refers to a rate charged on the sale of food or beverages. Refers to a tax rate charged on the sale of motor fuel. Tax on the fee charged for the parking of motor vehicles. Tax that applies exclusively to the sale of medical equipment. Alcoholic Beverages taxed under a different tax in lieu of or in addition to sales tax. Refers to a sales tax rate charged on the sale of alcohol. Applies where there is a distinct rate on the sale of mixed drinks ready for on-site consumption. A tax charged on the provision of video services. Similar to Use Tax (Tax Type 49), but applied only in Premier Resort Areas. Similar to Tax Type 33 (Transit Tax), but applied only in New York. Similar to Tax Type 4 (District Tax), but applied only in New York. A rate charged on the sale of food or beverages. Similar to Business & Occupation Tax (Tax Type 2) but only applied on Rents and Royalties. Similar to Business & Occupation Tax (Tax Type 2) but only applied to Services. A specific district tax that supports a Rural Transportation Authority. A specific district tax that supports a Multi-jurisdictional Housing Authority. A F C S a l e s a n d U s e U s e r M a n u a l | 83 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 401 402 403 404 NAME Public Safety Improvements District Tax Mass Transit District Tax Metropolitan District Tax RTA Consumer Use Tax RTA Vendor Use Tax 405 MHA Consumer Use Tax 406 MHA Vendor Use Tax 400 407 408 412 Mass Transit District Consumer Use Tax Mass Transit District Vendor Use Tax Education Sales-Vending 431 441 Education Sales-Motor Vehicles Education Use-Motor Vehicles Education Consumer Use-Motor Vehicles Education Vendor UseMotor Vehicles Education SalesManufacturing Education UseManufacturing Education Consumer Use - Manufacturing Education Vendor Use – Manufacturing Rental Use Tax - Motor Vehicles Consumer Use Rental Tax - Motor Vehicles Vendor Use Rental Tax Motor Vehicles Commerce Tax PIS 442 443 449 COFINS ICMS Rental Tax (Lower Rate) 469 Use Tax (Rental) 413 414 415 416 417 418 419 420 421 422 423 DESCRIPTION A specific district tax that supports public safety improvements. A specific district tax that supports Mass Transit. A specific district tax that supports a Metropolitan district. A specific district tax that supports a Rural Transportation Authority. A specific district tax that supports a Rural Transportation Authority. A specific district tax that supports a Multi-jurisdictional Housing Authority. A specific district tax that supports a Multi-jurisdictional Housing Authority. A specific district tax that supports Mass Transit. A specific district tax that supports Mass Transit. An educational sales tax rate that applies to the retail sale of items sold through vending machines. An educational sales tax rate charged on the sale of motor vehicles. An educational use tax rate charged on the sale of motor vehicles. An educational use tax rate charged on the sale of motor vehicles. An educational use tax rate charged on the sale of motor vehicles. An educational sales tax rate charged on the sale of manufacturing machinery and other manufacturing related items. An educational use tax rate charged on the sale of manufacturing machinery and other manufacturing related items. An educational use tax rate charged on the sale of manufacturing machinery and other manufacturing related items. An educational use tax rate charged on the sale of manufacturing machinery and other manufacturing related items. Refers to a use tax rate charged on the rental of motor vehicles. Refers to a use tax rate charged on the rental of motor vehicles. Refers to a use tax rate charged on the rental of motor vehicles. Tax on Gross Revenue for the privilege of engaging in business. A social contribution tax targeted to finance unemployment insurance and allowance for low paid workers. A contribution levied to finance social security, health and social care. State tax for goods and services. Similar to Rental Tax (Tax Type 188) but only applied to certain items at a reduced rate. Similar to Tax Type 49 (Use Tax) but only applied to rental services. A F C S a l e s a n d U s e U s e r M a n u a l | 84 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 470 NAME Use Tax (Other) 471 Consumer Use Tax (Other) 472 Vendor Use Tax (Other) 492 Statutory Gross Receipts NF PUC Franchise Fee (Video) NF 493 494 Sales Tax NF 495 District Tax NF 496 Hospital District Tax NF 497 Improvement District Tax NF Mass Transit District Tax NF Metropolitan District Tax NF MHA District Tax NF 498 499 500 501 502 Public Safety Improvement District Tax NF Rural Transportation Authority District Tax NF 503 Transit Tax NF 504 District Consumer Use Tax NF Hospital District Consumer Use Tax NF Improvement District Consumer Use Tax NF 505 506 507 508 Mass Transit District Consumer Use Tax NF MHA Consumer Use Tax NF DESCRIPTION Similar to Tax Type 49 (Use Tax) but only applied to transactions that do not fall into another existing tax type. Generally transactions return this tax type if a distinct use tax rate applies in a specific jurisdiction or on a temporary basis. Similar to Tax Type 357 (Consumer Use Tax) but only applied to transactions that do not fall into another existing tax type. Generally transactions return this tax type if a distinct consumer use tax rate applies in a specific jurisdiction or on a temporary basis. Similar to Tax Type 321 (Vendor Use Tax) but only applied to transactions that do not fall into another existing tax type. Generally transactions return this tax type if a distinct vendor use tax rate applies in a specific jurisdiction or on a temporary basis. Similar to Tax Type 14 (Statutory Gross Receipts), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 9 (P.U.C. Fee) but only applied to video services. This tax does not include Federal USF or Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 1 (Sales Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 4 (District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 96 (Hospital District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 99 (Improvement District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 401 (Mass Transit District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 402 (Metropolitan District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 399 (MHA District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 400 (Public Safety Improvements District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 398 (Rural Transportation Authority District Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 33 (Transit Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 358 (District Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 363 (Hospital District Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 366 (Improvement District Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 407 (Mass Transit District Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 405 (MHA Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. A F C S a l e s a n d U s e U s e r M a n u a l | 85 of 329 Copyright 2018 Avalara, Inc. Table 4-19 Tax Types Supported by AFC TAX TYPE ID 509 515 NAME RTA Consumer Use Tax NF Transit Consumer Use Tax NF District Vendor Use Tax NF Hospital District Vendor Use Tax NF Improvement District Vendor Use Tax NF Mass Transit District Vendor Use Tax NF MHA Vendor Use Tax NF 516 RTA Vendor Use Tax NF 517 Transit Vendor Use Tax NF 518 State USF (VoIP Alternate) NF 519 E-rate Broadband Program (VoIP Alternate) ConnectME Fund (VoIP Alternate) 510 511 512 513 514 520 DESCRIPTION Similar to Tax Type 403 (RTA Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 360 (Transit Consumer Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 322 (District Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 327 (Hospital District Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 330 (Improvement District Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 408 (Mass Transit District Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 406 (MHA Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 404 (RTA Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 321 (Transit Vendor Use Tax), but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 282 (State USF (VoIP Alternate)) but does not include Federal USF and Federal FCC Regulatory Fees in the assessment base. Similar to Tax Type 478 (E-rate Broadband Program) but gives the user the ability to report VoIP usage based on actual usage rather than using the Safe Harbor percentage. Similar to Tax Type 215 (ConnectME Fund (VoIP) but gives the user the ability to report VoIP usage based on actual usage rather than using the Safe Harbor percentage. For the most current list of Tax Types, refer to the EZTaxTaxType.h file located on the most recent Distribution/Update. For .NET users, the tax types are also available in EZTaxConstants.cs. For Java users, the tax types are also available in TaxType.java. Nexus AFC allows a client application to set the nexus information in multiple methods. • • • • Set the appropriate nexus option in the configuration file (see TM_00548_AFC Configuration Guide). The option specified in the configuration file will automatically be applied to every AFC session as it is initialized. However, this option may be overridden by calling the EZTaxSetNexus API function. By EZTaxSetNexus API function. By using a nexus_table at the transaction level. By EZTaxSetStateNexus API function. General Usage A F C S a l e s a n d U s e U s e r M a n u a l | 86 of 329 Copyright 2018 Avalara, Inc. When the engine determines there is no nexus for the taxing jurisdiction of the transaction, no taxes will be returned. If the nexus information has been set by either configuration file or by API call, the transaction level nexus will take precedence. EZTaxSetNexus allows one call to set all nexus information whereas EZTaxSetStateNexus allows the client application to set each state individually. By using EZTaxSetNexus with a null pointer and a nexus count of zero, it will reset the AFC engine to default value of nexus in every state. Nexus is only used within the United States. Exclusions AFC allows a client application to exclude states or countries (and all lower level jurisdictions) from taxation. By using the exclusion option, the client is informing AFC that the specified state or country and all lower jurisdictions are to return no taxes. An excluded state will exempt all state and lower level jurisdiction taxes; however, it will continue to return federal level taxes. An excluded country will exempt all federal and lower level jurisdiction taxes. Exclusions may be accomplished using several methods, such as those listed below: • • • Set the appropriate exclusion option in the configuration file (see TM_00548_AFC Configuration Guide). The option specified in the configuration file will automatically be applied to every AFC session as it is initialized. However, this option may be overridden with other API functions. Use the EZTaxSetStateExclusion API function. Use the EZTaxClearExclusion API function. General Usage When the engine determines that taxes are excluded at the state level for a transaction, only federal level taxes are returned. When the engine determines that taxes are excluded at the federal level, no taxes are returned. EZTaxClearExclusion will clear all exclusion information and return taxes at every level. US Territories US Territory exclusions function like state exclusions and are set and cleared when the federal level USA country code is used without a state or territory. When specified as a state jurisdiction using the two letter state code, ex. ‘USA,VI’, the exclusion behaves like any other state jurisdiction. A F C S a l e s a n d U s e U s e r M a n u a l | 87 of 329 Copyright 2018 Avalara, Inc. Country codes for US Territories are deprecated. A F C S a l e s a n d U s e U s e r M a n u a l | 88 of 329 Copyright 2018 Avalara, Inc. Utilities Refer to Figure 5-1. While tax results are typically returned to the billing system using functions, the primary output mechanism of the AFC Engine employs the EZtax Log. The EZTax.log is the link to the outside world. There are twenty-four utilities to choose from, one of which will almost certainly suit your need. When an AFC session is started with the AFC Initialization Function, the Tax Log is opened if the Tax Log parameter is set to true. This allows the AFC Log to capture the binary formatted transaction and tax data generated by the AFC Engine. After exiting the AFC session, the AFC Log becomes available for use. This file should be archived by the user for reruns, recovery and auditing purposes. This is accomplished by simply copying the EZTax.log file to a local storage location (refer to Figure 5-1). In most cases this binary file will be used in the future and nearly all of the utilities will delete the contents of the AFC Log upon job completion. Figure 5-1 AFC Log Data Path If the Billing System is configured to use the AFC Functions and does not require the logging of data, set the first parameter of the AFC Initialization Function to FALSE to disable transaction logging. For instance, if your program is saving or using the tax data returned to it by the tax calculation functions, you would have no need to use the data in the log file for later processing. NOTE: When running AFC in batch fashion the EZTax.log file is always generated. A F C S a l e s a n d U s e U s e r M a n u a l | 89 of 329 Copyright 2018 Avalara, Inc. It is imperative that rigid backup practices are established and followed to avoid losing the transaction and data information created during a session. Most utilities will delete the inputted log file when the utility is finished and backups would be required should reruns be needed. Utility Selection AFC provides utilities for reporting and file management. The latest utilities, along with their file formats, are located on the most current update. AFC has conversion utilities available for converting the tax log file to formats used by compliance services. Contact Avalara for information on converting to specific services. Reporting Utilities The reporting utilities are used for customer billing and compliance reporting. They extract specific data from the content rich binary AFC Log file, commonly sorting the data into a logical and orderly format. The resulting output is a flat file containing just the information required for the specific report, compatible with common software such as spreadsheets and databases. The most common use of this information is to file tax returns. However, other uses may include audit trails, internal tracking and projections. Reporting File Extensions Refer to Table 5-1. The reporting utility output file extensions are customized to indicate the type of information provided within the file. Note that some utilities may produce more than one type of output file. Table 5-1 File Extension Definitions Log File Extension .csf Log File Type Customer Billable amounts File Format .csf .ssf Tax Compliance amounts .ssf .nba Non-billable amounts for compliance .ssf .nca Non-compliance amounts that were billed .ssf .scl Billable amounts combined with non-billable amounts .ssf Note This file is not generated when the [–cl] command line option is used. This file is not generated when the [–cl] command line option is used. If there are no non-billable amounts, this file is not created. This file is generated only if there are transactions in the AFC log that do not require compliance with a jurisdiction. This file is generated when the [-cl] command line option is used. The .scl file is created instead of the .ssf and .nba files. A F C S a l e s a n d U s e U s e r M a n u a l | 90 of 329 Copyright 2018 Avalara, Inc. The report file generated by the utility will be formatted as a comma delimited file or fixed field length file depending on the utility used. Refer to the specific utility documentation to determine which formatting will be provided. Some report utilities provide specialized reports with the file name log.rpt. These comma delimited files are modifications of .csf and .ssf report formats. Refer to Figure 5-2. For example, the EZLog_NS.exe utility produces a comma-delimited flat file report with an .ssf extension. When this file is copied into a preformatted (headings and column widths preset) MS Excel spreadsheet the following output is displayed. If the spreadsheet had not been preformatted the titles would not be present and the field widths might vary. Figure 5-2 Sample EZLog_NS spreadsheet Country State USA USA USA USA USA USA USA USA USA USA AL AZ AZ AZ AZ AZ AZ County APACHE APACHE APACHE Locality Tax type Tax level Tax rate Tax amount SPRINGERVILLE 6 7 18 16 1 10 12 1 1 1 0 0 0 1 1 1 1 1 2 1 0.0300 0.0076 0.0314 0.0670 0.0500 0.0125 0.0110 0.0500 0.0270 0.0500 29,881.87 10,116.13 11,145.49 969.97 0.81 9.07 7.98 0.81 0.44 0.71 Gross sales Exempt 996,062.25 1,331,070.00 354,952.00 14,477.20 16.12 725.47 725.47 16.12 16.12 14.11 0 0 0 0 0 0 0 0 0 0 Adj. 0 0 0 0 0 0 0 0 0 0 Taxable Measure 996,062.25 1,331,070.00 354,952.00 14,477.20 16.12 725.47 725.47 16.12 16.12 14.11 Minutes 14,859,213 20,410,578 5,446,827 220,239 245 11,038 11,038 245 245 215 File Management Utilities File management utilities are provided for maintenance purposes, such as combining one or more archived AFC log files or appending one log file to another. Note that AFC provides the asciilog.exe utility for maintenance of AFC log files. It allows the user to view the unsorted log file as readable ASCII text without deleting the file. Specifying a Log File at Run Time The AFC Log file to be submitted to a utility is specified by the log file name in the Filelocs.txt file (EZTax.log by default). However, this file name will be ignored if a different file name is provided in the AFC Initialization Function at session startup. The Filelocs.txt contains the file locations for text file contains all of paths to the AFC Data Base files. Each file in the AFC Data base is represented by one line. The lines in the text file must be in the defined order and all files must be represented. A F C S a l e s a n d U s e U s e r M a n u a l | 91 of 329 Copyright 2018 Avalara, Inc. NOTE Batch utility clients can only use the filelocs.txt file as they will not be using the function programming method. Log.sum File The Log.sum file accumulates tax compliance totals over multiple runs to generate a compilation of the tax totals. It contains a summary of the EZTax.log(s) with the data organized by taxing jurisdictions. Only the EZ* prefix report utilities can be used to generate the log.sum file, which can then be passed as the input to most of the report utilities. This is a turnaround file used for maintaining one smaller log file rather than multiple log files in cases where the customer billing cycle occurs more frequently than the tax compliance cycle. It carries tax compliance information forward until the report is produced. The srt* utilities use this file for input only. WARNING The customer information is lost in the summation of the log.sum. Remember to delete or move this file before running a utility that uses it, if a combined report is not desired. General Tips When Using Utilities AFC is designed to provide optimum flexibility in creating reports. The following tips have been accumulated to assist in making the best use of available options. 1. Combining Log Files 2. If an AFC log file exists when AFC is run, new tax data will be appended to the end of an existing log file (i.e. not placed into a new log file). Also, log files can be combined prior to passing to a utility, although they cannot be split apart after they are merged. 3. The criteria for deciding to combine files is based on how often AFC is run, how big the created log files are and the date cycles of your billing and tax compliance system. Note that most transactions will generate many tax records and that each tax record is either 100 or 168 bytes long, depending on the configuration. 4. Many clients use a new log file for each run of AFC to reduce the complexity introduced when a rerun or restart is required. 5. Most clients will do all of their customer billing processing within their Function programs and use the log file to process only tax compliance data at a later date. 6. Utilities are provided to merge two or more log files into a single log file. This is useful when running reports that reflect the combined data of the individual log files. 7. Primarily the srt* utilities will produce files sorted by the jurisdictional level. A F C S a l e s a n d U s e U s e r M a n u a l | 92 of 329 Copyright 2018 Avalara, Inc. 8. AFC provides the asciilog.exe utility for maintenance of AFC log files, allowing the user to create an ASCII version of the log file. 9. Many utilities produce a log.sum file that accumulates tax compliance totals over multiple runs to generate a compilation of the tax totals. 10. The pkzip executable option listed with some utilities is only available with the windows platform. A F C S a l e s a n d U s e U s e r M a n u a l | 93 of 329 Copyright 2018 Avalara, Inc. AFC Utilities Table 5-2 Utility Summary Utility Name Function asciilog.exe File Management batch_sau.exe File Management commerge.exe File Management comrp.exe Reporting comptnum.exe Reporting csf20.exe Processing customsort.exe Reporting ezcomprep.exe Reporting ezlog_ns.exe Reporting ezlogcust.exe Reporting ezlogcustios.exe Reporting ezlogcustpts.exe Reporting ezlogcustptslnl.exe Reporting EZTax_20.exe Processing EZTaxappend.exe File Management EZTaxappendf.exe log no tax transactions File Management srtcdf20.exe Reporting srtcdf20p.exe Reporting srtcomcust20.exe Reporting Short Description Dumps the contents of the logfilename.log to an ASCII version of the log file File Management Combines the log file with the log.sum (if present) then sorts and combines the data. Combines the log file with the log.sum (if present) then sorts and combines the data. Data formatted to produce a customer information file called ComRPT.ssf. Reads the log file specified in filelocs.txt and produces comma delimited text files outputfilename.ssf, outputfilename.nca, and outputfilename.nba (or a unified file outputfilename.scl) for tax compliance filing. Reads the log file specified in filelocs.txt. Uses a CDF filename from the command line to name the output files. Produces a comma-delimited file for compliance filing. User selects sort criteria and preferences. Refer to the AFC Custom Sort Utility User Manual for more information on this utility. Produces a comma-delimited file for compliance filing. Sorting and combining is performed at the jurisdictional level. Produces a comma-delimited file for compliance filing. Produces a comma-delimited file for customer billing. Sorting and reporting is done at the customer level. Produces a comma-delimited file for customer billing. Sorting and reporting is done at the customer level. Produces a comma-delimited file for customer billing. Sorting and reporting is done at the customer level. The sort key also contains PCode, optional, and Service Level Number fields. Produces a comma-delimited file for customer billing. Sorting and reporting is done at the customer level. In addition to the PCode, optional, and Service Level Number fields and the number of lines are also included. Refer to batchfile processing for details on the Batch processing method. Combines two log files. Combines multiple log files. This is an option in the EZTax.cfg file, placed here as it may effect the output. Produces a fixed length text file logfilename.ssf for tax compliance filing and a fixed length text file filename.csf for customer billing. Produces a fixed length text file EZTaxlogfilename.ssf for tax compliance filing and a fixed length text file logfilename.csf for customer billing. Produces a comma delimited text file logfilename.ssf for tax compliance filing and a fixed length text file logfilename.csf for customer billing. A F C S a l e s a n d U s e U s e r M a n u a l | 94 of 329 Copyright 2018 Avalara, Inc. Table 5-2 Utility Summary Utility Name Function srtcomma20.exe Reporting srtcomma20l.exe Reporting srtcomma20ld.exe Reporting srtrev20l.exe Reporting strg.exe Reporting upsize_log.exe File Management Short Description Produces a comma delimited text file logfilename.ssf for tax compliance filing and a fixed length text file logfilename.csf for customer billing. Produces a comma delimited text file logfilename.ssf for tax compliance filing and a fixed length text file logfilename.csf for customer billing, separating adjustments. The .csf file is used for import into the billing system to populate customer bills. The comma-delimited .ssf file is sorted at the jurisdictional level. The .ssf file also contains the number of lines. Produces a comma delimited text file logfilename.ssf for tax compliance filing and a fixed length text file logfilename.csf for customer billing. Produces a comma delimited text file logfilename.ssf for tax compliance filing and a fixed length text file logfilename.csf for customer billing, separating adjustments. The .csf file is used for import into the billing system to populate customer bills. The comma-delimited .ssf file is sorted at the jurisdictional level. The .ssf file also contains the number of lines and the base sale amount. The base sale amount can be included in the csf by command-line option. Produces a fixed length text file logfilename.ssf for tax compliance filing. If the extra logfilename is specified, it is used for appending instead of the log.sum. Converts the short format logfilename1 to a long format log logfilename1. A F C S a l e s a n d U s e U s e r M a n u a l | 95 of 329 Copyright 2018 Avalara, Inc. asciilog.exe COMMAND LINE asciilog logfilename.log <+p> <+tc> <+a> <+h> <-csv> <-?> DESCRIPTION The asciilog.exe command dumps the contents of the logfilename.log to an ASCII version of the log file. It does not sort or combine records. It produces a file named logfilename.txt which is a legible version of the logfilename.log data. INPUT Log file: logfilename.log file as defined in the command line and is NOT deleted at end of job. OUTPUT Comma delimited logfilename.txt or logfilename.csv file. FILE FORMAT KEY The contents of the file are highly dependent upon the command line arguments. Use the +h argument to prepend the output with a header row that defines each column. ARGUMENTS (in any order) +p option adds the P-Code to the output, located before the Country for each record +tc option adds the tax category description to the end of each record +a option outputs all available fields +h option prepends the output with a header record -csv option uses .csv as the extension for easier import to other applications -? option displays usage screen and exits NOTES: AFC log is NOT deleted. Also, to have valid values for transaction type and service type, the AFC session that generated the log must have logtransserv=true (ref 7.2.3.8 Log Transaction / Service Types). batch_sau.exe batch_sau is a Processing Utility used to pass Sales and Use transaction records through the AFC Engine in Batch fashion. Refer to batch file processing for details on the Batch processing method. A F C S a l e s a n d U s e U s e r M a n u a l | 96 of 329 Copyright 2018 Avalara, Inc. commerge.exe COMMAND LINE commerge DESCRIPTION The commerge.exe command reads the log file specified in filelocs.txt, combines the log file with the log.sum (if present) then sorts and combines the data. INPUT Reads the log file as defined by filelocs.txt or AFC Initialization Function. log.sum – optional input from previous run OUTPUT No output file is produced as this is a log manipulation utility. FILE FORMAT KEY The output file produced is a log file with no format key as this is a log manipulation utility. ARGUMENTS None. NOTES: The log.sum file is created WARNING - EZTax.log is DELETED. Make backups in case reruns are needed. SAMPLE DATA No output file is produced as this is a log manipulation utility. A F C S a l e s a n d U s e U s e r M a n u a l | 97 of 329 Copyright 2018 Avalara, Inc. comptnum.exe COMMAND LINE comptnum [-z] outputfilename [-cl] DESCRIPTION The comptnum.exe command reads the log file specified in filelocs.txt and produces comma delimited text files outputfilename.ssf, outputfilename.nca, and outputfilename.nba (or a unified file outputfilename.scl) for tax compliance filing. INPUT Reads the logfilename.log file as defined by filelocs.txt or AFC Initialization Function. log.sum – optional input from previous run. OUTPUT Comma Delimited outputfilename.ssf (nca, nba, scl) file for tax compliance filing. Sorted and condensed by PCode, Tax Type, Tax Level, Tax Rate FILE FORMAT KEY Country, State, County, Locality, PCode, Tax type, Tax Type Description, Tax level, Tax Level Description, Tax rate, Tax amount, Gross Sale, Exempt, Adjustments, Taxable measure, Minutes Figure 5-3 comptnum SSF File Format Key Description Country State County Locality PCode Tax Type Tax Type Description Tax Level Tax Level Description Tax Rate Tax Amount Gross Sale Exempt Adjustments Taxable Measure Minutes Customer number Type Alpha Alpha Alpha Alpha Numeric Numeric Alpha Numeric Alpha Numeric Numeric Numeric Numeric Numeric Numeric Numeric Alpha A F C S a l e s a n d U s e U s e r M a n u a l | 98 of 329 Copyright 2018 Avalara, Inc. ARGUMENTS -z - path to zip executable file*
Source Exif Data:
File Type : PDF File Type Extension : pdf MIME Type : application/pdf PDF Version : 1.5 Linearized : Yes Author : Alicia Combs Company : Avalara, Inc. Create Date : 2018:06:25 10:21:59-04:00 Modify Date : 2018:06:25 10:25:16-04:00 Source Modified : D:20180625142051 Language : EN-US Tagged PDF : Yes XMP Toolkit : Adobe XMP Core 5.6-c015 84.159810, 2016/09/10-02:41:30 Metadata Date : 2018:06:25 10:25:16-04:00 Creator Tool : Acrobat PDFMaker 18 for Word Document ID : uuid:66b16e75-69a8-4ccc-8b29-8f3a127f98ce Instance ID : uuid:991c3c22-d710-459b-8589-66ada9ac47df Subject : 38 Format : application/pdf Title : Creator : Alicia Combs Producer : Adobe PDF Library 15.0 Page Layout : OneColumn Page Count : 342EXIF Metadata provided by EXIF.tools