SmartFusion Modules > Business License > Reports > Business License and Fees Export

Recent Changes:  
6.100 - Changed the default of Telephone - Business (field 21), Telephone - Home  (field 22), Contact Person - Name (field 25), and Contact Person - Phone (field 26). The modifications to the specification are listed below.

6.95 - Allowed the export to span multiple license years  
6.91 - Updated Municipal Business License Amount to not depend on Customer Id but to depend on License History payment transactions
6.89 - Add Application date, application completed by name and application completed by title  
6.85 - Updated fields and formats according to specification dated 14Jun19

https://revenue.alabama.gov/sales-use/local-government-forms/ (refer to Option 1 for Comma Separated Value file)
Per Act 2014-430, effective October 1, 2014 must include SSN or FEIN for all applicants

No Field Name Max Length Field Type Format Required? Description SF Field
1 Reporting Period 10 Date M/D/CCYY Yes Last day of the month of the reporting period. form entry
2 Master Locality Code of Municipality 4 Numeric 0000 Yes Four (4) digit Master Locality Code of Municipality Issuing License. organization setting for County
3 License Issued? 1 Alpha Y/N Yes Enter “N” to indicate that no licenses were issued for this locality and period. 'Y' if records exist
4 FEIN 10 Numeric 000000000 or 00-0000000 Federal Employer Identification Number of business. Blank If no FEIN. Dashes now OK. BusinessLicenseCustomer.cfedid
5 SSN 11 Numeric 000000000 or 000-00-0000 Social Security Number of sole proprietor. Blank if partnership or corporation. Dashes now OK. BusinessLicenseCustomer.SocialSecurityNumber
6 State Tax Number 10 Alphanumeric R000000000 or 0000 00000 State of Alabama Sales, Use, Rental or Lodgings Tax Number (if available). Omit 3 letter prefix. BusinessLicenseCustomer.cstateid
7 Form of Ownership 1 Alpha Yes S=Sole Proprietor, P=Partnership, C=Corporation, A=Professional Association, L=LLC or O=Other bl057.FormOfOwnership
8 Application Type 2 Alpha Yes NE=New, RE= Renewal, OC=Owner Change, NC=Name Change, LC=Location Change if LicenseHistory.EffectiveDate.Year = BusinessLicenseCustomer.OriginalLicenseDate.Year then NE, else RE
9 Business Legal Name 50 Alphanumeric Yes The Legal Name of the Business. Customer.Name
10 Business Trade Name (DBA) 50 Alphanumeric The DBA Name of the Business BusinessLicenseCustomer.AlternateName
11 NAICS Code 6 Numeric 000000 North American Industry Classification System (NAICS) Code bl052.cclass
12 Business Activities 45 Alphanumeric Brief description of the business. Example: Retail clothing sales, Wholesale food Sales, Rental of Equipment, etc. BusinessLicenseCustomer.Description
13 Physical Address - Street 75 Alphanumeric Yes Street address of where business is located. Customer.Address1
14 Physical Address - City 30 Alpha Yes Name of city where business is located. Customer.City
15 Physical Address - State 2 Alpha Yes Standard state abbreviation of business location. Customer.State
16 Physical Address - Zip 10 Numeric 000000000 or 00000 or 00000-0000 Yes Zip Code. If last four digits are unknown, zero fill. Ex.: 361040000. Dashes now OK. Customer.Zip
17 Mailing Address - Street 75 Alphanumeric Yes Mailing address for business - Street Customer.MailAddress1
18 Mailing Address - City 30 Alpha Yes Mailing address for business - State Customer.MailCity
19 Mailing Address - State 2 Alpha Yes Standard state abbreviation Customer.MailState
20 Mailing Address - Zip 10 Numeric 000000000 or 00000 or 00000-0000 Yes Zip Code. If last four digits are unknown, zero fill. Ex.: 361040000. Dashes now OK. Customer.MailCity
21 Telephone - Business 13 Numeric 0000000000 Telephone number of business. if unentered, will be replaced with blanks. Customer.Phone1
22 Telephone - Home 13 Numeric 0000000000 Owner's home telephone number. if unentered, will be replaced with blanks. Customer.Phone2
23 Fax Number 13 Numeric 0000000000 FAX number of business. Dashes & parentheses now OK. Customer.Fax
24 Email Address 45 Alphanumeric Email Address of business. Will need to add field to Cash Collections customer
25 Contact Person - Name 50 Alpha Yes Name of contact person for the business, if blank will be replaced with "Unknown". CustomerContact.Name if BLPrimary
26 Contact Person - Phone 13 Numeric 000000000 Yes Telephone number of contact person, if blank, or unentered, will be replaced with "999-999-9999". CustomerContact.Phone if BLPrimary
27 Owner, Partner or Officer 1 - Name 50 Alpha Name of Owner, Partner, or Officer. CustomerContact.Name if Responsible Person
28 Owner, Partner or Officer 1 - Address 75 Alphanumeric Street, City, State, Zip Street, City, State, Zip of Owner, Partner, or Officer. CustomerContact.Address if Responsible Person
29 Owner, Partner or Officer 1 - SSN 11 Numeric 000000000 or 000-00-0000 Social Security Number (If not publicly traded company)
30 Owner, Partner or Officer 1 - Title 25 Alphanumeric Title of Owner, Partner, or Officer. CustomerContact.Title if Responsible Person
31 Owner, Partner or Officer 2 - Name 50 Alpha Name of Owner, Partner, or Officer. CustomerContact.Name if Owner, Partner, Officer 2
32 Owner, Partner or Officer 2 - Address 75 Alphanumeric Street, City, State, Zip Street, City, State, Zip of Owner, Partner, or Officer. CustomerContact.Address if Owner, Partner, Officer 2
33 Owner, Partner or Officer 2 - SSN 11 Numeric 000000000 or 000-00-0000 Social Security Number (If not publicly traded company)
34 Owner, Partner or Officer 2 - Title 25 Alphanumeric Title of Owner, Partner, or Officer. CustomerContact.Title if Owner, Partner, Officer 2
35 Owner, Partner or Officer 3 - Name 50 Alpha Name of Owner, Partner, or Officer. CustomerContact.Name if Owner, Partner, Officer 3
36 Owner, Partner or Officer 3 - Address 75 Alphanumeric Street, City, State, Zip Street, City, State, Zip of Owner, Partner, or Officer. CustomerContact.Address if Owner, Partner, Officer 3
37 Owner, Partner or Officer 3 - SSN 11 Numeric 000000000 or 000-00-0000 Social Security Number (If not publicly traded company)
38 Owner, Partner or Officer 3 - Title 25 Alphanumeric Title of Owner, Partner, or Officer. CustomerContact.Title if Owner, Partner, Officer 3
39 Owner, Partner or Officer 4 - Name 50 Alphan Name of Owner, Partner, or Officer. CustomerContact.Name if Owner, Partner, Officer 4
40 Owner, Partner or Officer 4 - Address 75 Alphanumeric Street, City, State, Zip Street, City, State, Zip of Owner, Partner, or Officer. CustomerContact.Address if Owner, Partner, Officer 4
41 Owner, Partner or Officer 4 - SSN 11 Numeric 000000000 or 000-00-0000 Social Security Number (If not publicly traded company)
42 Owner, Partner or Officer 4 - Title 25 Alphanumeric Title of Owner, Partner, or Officer. CustomerContact.Title if Owner, Partner, Officer 4
43 Owner, Partner or Officer 5 - Name 50 Alpha Name of Owner, Partner, or Officer. Not included (Some older versions of SQL Server cannot handle the query logic for 5 Officers)
44 Owner, Partner or Officer 5 - Address 75 Alphanumeric Street, City, State, Zip Street, City, State, Zip of Owner, Partner, or Officer.
45 Owner, Partner or Officer 5 - SSN 11 Numeric 000000000 or 000-00-0000 Social Security Number (If not publicly traded company)
46 Owner, Partner or Officer 5 - Title 25 Alphanumeric Title of Owner, Partner, or Officer.
47 Business Start Date 10 Date M/D/CCYY Yes Date business activity started. BusinessLicenseCustomer.OriginalLicenseDate
48 Number of Employees 6 Numeric 000000 Number of employees. LicenseHistory.GrossReceipts if flag set to Number of Employees in System Settings
49 Gross Receipts/Gross Sales 11 Numeric 0.00 Yearly estimated Gross Receipts/Gross Sales amount. Example = 200000.00. No commas or dollar signs. LicenseHistory.GrossReceipts if flag set to Gross Receipts in System Settings
50 Date of Municipal License Application 10 Date M/D/CCYY Yes Date of municipal license application. LicenseHistory.ApplicationDate
51 Name of Person Completing Application 50 Alpha Yes Name of person completing the municipal license application LicenseHistory.ApplicationCompletedByName
52 Title of Person Completing Application 25 Alphanumeric Title of the person completing the municipal license application LicenseHistory.ApplicationCompletedByTitle
53 Municipal Business License Number 15 Alphanumeric Yes License number assigned to business by the municipality. License.LicenseNumber
54 Municipal Business License Year 4 Numeric CCYY Yes Municipal Business License Year LicenseHistory.EffectiveDate.Year
55 Municipal Business License Amount 11 Numeric 0.00 Cost of Municipal Business License. Example = 250.00. No commas or dollar signs Sum of ar012 payments for License History Id
56 Physical Location - In City Limits? (Y/N) 1 Alpha Y/N Yes Business is located within the city limits (Y = Yes N = No) bl058.PhysicalLocation
57 Physical Location - Outside City & Inside PJ? (Y/N) 1 Alpha Y/N Yes Business is located outside of the city limits but within the Police Jurisdiction (Y = Yes N = No) bl058.PhysicalLocation
58 Tax Type/Frequency - Sales Tax? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Sales Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
59 Tax Type/Frequency - Sellers Use? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Sellers Use Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
60 Tax Type/Frequency - Consumers Use? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Consumers Use Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
61 Tax Type/Frequency - Rental Tax? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Rental Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
62 Tax Type/Frequency - Lodgings Tax? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Lodgings Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
63 Tax Type Frequency - Alcohol? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Alcohol Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
64 Tax Type Frequency - Occupational? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Occupational Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
65 Tax Type Frequency - Tobacco? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Tobacco Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
66 Tax Type Frequency - Gas/Motor Fuel? (M, Q, B, A, O, N) 1 Alpha M, Q, B, A, O, N Gas/Motor Fuel Tax filing frequency. M=Monthly, Q=Quarterly, B=BiAnnually, A=Annually, O=Other, N=No Account. query hf046 for hf047.BusinessLicenseTaxType
67 Tax Type - Business License? (Y/N) 1 Alpha Y/N Business has a Business License. (Y=Yes N=No) 'Y' for all
68 Business Type - Retail? (Y/N) 1 Alpha Y/N Yes Business Type - Retail? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
69 Business Type - Wholesale? (Y/N) 1 Alpha Y/N Yes Business Type - Wholesale? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
70 Business Type - Building Contractor? (Y/N) 1 Alpha Y/N Yes Business Type - Building Contractor? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
71 Business Type - Service? (Y/N) 1 Alpha Y/N Yes Business Type - Service? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
72 Business Type - Professional? (Y/N) 1 Alpha Y/N Yes Business Type - Professional? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
73 Business Type - Manufacture? (Y/N) 1 Alpha Y/N Yes Business Type - Manufacture? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
74 Business Type - Rental? (Y/N) 1 Alpha Y/N Yes Business Type - Rental? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory
75 Business Type - Other? (Y/N) 1 Alpha Y/N Yes Business Type - Other? (Y=Yes N=No) BusinessLicenseCustomer.BusinessCategory