Name: BhamBreweries$

Display Field: Company_Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Company_Name (type: esriFieldTypeString, alias: Company Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parent_Company_Name (type: esriFieldTypeString, alias: Parent Company Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_First_Name (type: esriFieldTypeString, alias: Executive First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Last_Name (type: esriFieldTypeString, alias: Executive Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Professional_Title (type: esriFieldTypeString, alias: Professional Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Title (type: esriFieldTypeString, alias: Executive Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Gender (type: esriFieldTypeString, alias: Executive Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ZIP_Code (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ZIP_Four (type: esriFieldTypeString, alias: ZIP Four, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Carrier_Route (type: esriFieldTypeString, alias: Carrier Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Delivery_Point_Barcode (type: esriFieldTypeString, alias: Delivery Point Barcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Metro_Area (type: esriFieldTypeString, alias: Metro Area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Phone_Number_Combined (type: esriFieldTypeString, alias: Phone Number Combined, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fax_Number_Combined (type: esriFieldTypeString, alias: Fax Number Combined, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Toll_Free_Number_Combined (type: esriFieldTypeString, alias: Toll Free Number Combined, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Company_Description (type: esriFieldTypeString, alias: Company Description, SQL Type: sqlTypeOther, length: 32767, nullable: true, editable: true)
• Primary_SIC_Code (type: esriFieldTypeString, alias: Primary SIC Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_SIC_Description (type: esriFieldTypeString, alias: Primary SIC Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_SIC_Ad_Size (type: esriFieldTypeString, alias: Primary SIC Ad Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_SIC_Year_Appeared (type: esriFieldTypeString, alias: Primary SIC Year Appeared, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_1 (type: esriFieldTypeString, alias: SIC Code 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_1_Description (type: esriFieldTypeString, alias: SIC Code 1 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_1_Ad_Size (type: esriFieldTypeString, alias: SIC Code 1 Ad Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_1_Year_Appeared (type: esriFieldTypeString, alias: SIC Code 1 Year Appeared, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_2 (type: esriFieldTypeString, alias: SIC Code 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_2_Description (type: esriFieldTypeString, alias: SIC Code 2 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_2_Ad_Size (type: esriFieldTypeString, alias: SIC Code 2 Ad Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_2_Year_Appeared (type: esriFieldTypeString, alias: SIC Code 2 Year Appeared, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_3 (type: esriFieldTypeString, alias: SIC Code 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC_Code_3_Description (type: esriFieldTypeString, alias: SIC Code 3 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_NAICS (type: esriFieldTypeString, alias: Primary NAICS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_NAICS_Description (type: esriFieldTypeString, alias: Primary NAICS Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_1 (type: esriFieldTypeString, alias: NAICS 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_1_Description (type: esriFieldTypeString, alias: NAICS 1 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_2 (type: esriFieldTypeString, alias: NAICS 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_2_Description (type: esriFieldTypeString, alias: NAICS 2 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_3 (type: esriFieldTypeString, alias: NAICS 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_3_Description (type: esriFieldTypeString, alias: NAICS 3 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cuisine_Code_Description (type: esriFieldTypeString, alias: Cuisine Code Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location_Employee_Size_Range (type: esriFieldTypeString, alias: Location Employee Size Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location_Employee_Size_Actual (type: esriFieldTypeString, alias: Location Employee Size Actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location_Sales_Volume_Range (type: esriFieldTypeString, alias: Location Sales Volume Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location_Sales_Volume_Actual (type: esriFieldTypeString, alias: Location Sales Volume Actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Corporate_Employee_Size_Range (type: esriFieldTypeString, alias: Corporate Employee Size Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Corporate_Employee_Size_Actual (type: esriFieldTypeString, alias: Corporate Employee Size Actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Corporate_Sales_Volume_Range (type: esriFieldTypeString, alias: Corporate Sales Volume Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Corporate_Sales_Volume_Actual (type: esriFieldTypeString, alias: Corporate Sales Volume Actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type_of_Business (type: esriFieldTypeString, alias: Type of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location_Type (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• IUSA_Number (type: esriFieldTypeString, alias: IUSA Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parent_IUSA_Number (type: esriFieldTypeString, alias: Parent IUSA Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Subsidiary_IUSA_Number (type: esriFieldTypeString, alias: Subsidiary IUSA Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Foreign_Parent_Flag (type: esriFieldTypeString, alias: Foreign Parent Flag, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EIN_1 (type: esriFieldTypeString, alias: EIN 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EIN_2 (type: esriFieldTypeString, alias: EIN 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EIN_3 (type: esriFieldTypeString, alias: EIN 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fortune_1000_Ranking (type: esriFieldTypeString, alias: Fortune 1000 Ranking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Credit_Cards_Accepted (type: esriFieldTypeString, alias: Credit Cards Accepted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Last_Updated_On (type: esriFieldTypeString, alias: Last Updated On, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Years_In_Database (type: esriFieldTypeString, alias: Years In Database, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Year_Established (type: esriFieldTypeString, alias: Year Established, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Square_Footage (type: esriFieldTypeString, alias: Square Footage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Home_Business (type: esriFieldTypeString, alias: Home Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Credit_Score_Alpha (type: esriFieldTypeString, alias: Credit Score Alpha, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Government_Office (type: esriFieldTypeString, alias: Government Office, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Location_Centerpoint (type: esriFieldTypeString, alias: Location Centerpoint, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Own_or_Lease (type: esriFieldTypeString, alias: Own or Lease, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Firm_or_Individual (type: esriFieldTypeString, alias: Firm or Individual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Monday_Open (type: esriFieldTypeString, alias: Monday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Monday_Close (type: esriFieldTypeString, alias: Monday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tuesday_Open (type: esriFieldTypeString, alias: Tuesday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tuesday_Close (type: esriFieldTypeString, alias: Tuesday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wednesday_Open (type: esriFieldTypeString, alias: Wednesday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wednesday_Close (type: esriFieldTypeString, alias: Wednesday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Thursday_Open (type: esriFieldTypeString, alias: Thursday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Thursday_Close (type: esriFieldTypeString, alias: Thursday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Friday_Open (type: esriFieldTypeString, alias: Friday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Friday_Close (type: esriFieldTypeString, alias: Friday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Saturday_Open (type: esriFieldTypeString, alias: Saturday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Saturday_Close (type: esriFieldTypeString, alias: Saturday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sunday_Open (type: esriFieldTypeString, alias: Sunday Open, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sunday_Close (type: esriFieldTypeString, alias: Sunday Close, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_First_Name_1 (type: esriFieldTypeString, alias: Executive First Name 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Last_Name_1 (type: esriFieldTypeString, alias: Executive Last Name 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Title_1 (type: esriFieldTypeString, alias: Executive Title 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Gender_1 (type: esriFieldTypeString, alias: Executive Gender 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_First_Name_2 (type: esriFieldTypeString, alias: Executive First Name 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Last_Name_2 (type: esriFieldTypeString, alias: Executive Last Name 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Title_2 (type: esriFieldTypeString, alias: Executive Title 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Gender_2 (type: esriFieldTypeString, alias: Executive Gender 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_First_Name_3 (type: esriFieldTypeString, alias: Executive First Name 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Last_Name_3 (type: esriFieldTypeString, alias: Executive Last Name 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Title_3 (type: esriFieldTypeString, alias: Executive Title 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Executive_Gender_3 (type: esriFieldTypeString, alias: Executive Gender 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Accounting_Expenses (type: esriFieldTypeString, alias: Accounting Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Advertising__Expenses (type: esriFieldTypeString, alias: Advertising Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Computer_Expenses (type: esriFieldTypeString, alias: Computer Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Contract_Labor_Expenses (type: esriFieldTypeString, alias: Contract Labor Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Insurance_Expenses (type: esriFieldTypeString, alias: Insurance Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Legal_Expenses (type: esriFieldTypeString, alias: Legal Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Office_Supplies_Expense (type: esriFieldTypeString, alias: Office Supplies Expense, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Management_Administration_Expen (type: esriFieldTypeString, alias: Management/Administration Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Package_Container_Expense (type: esriFieldTypeString, alias: Package Container Expense, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Payroll_and_Benefits_Expenses (type: esriFieldTypeString, alias: Payroll and Benefits Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Purchase_Print_Expenses (type: esriFieldTypeString, alias: Purchase Print Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Rent_Expenses (type: esriFieldTypeString, alias: Rent Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Telcom_Expenses (type: esriFieldTypeString, alias: Telcom Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Utilities_Expenses (type: esriFieldTypeString, alias: Utilities Expenses, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Twitter (type: esriFieldTypeString, alias: Twitter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Linked_In (type: esriFieldTypeString, alias: Linked-In, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Facebook (type: esriFieldTypeString, alias: Facebook, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Legal_Name (type: esriFieldTypeString, alias: Legal Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Record_Type (type: esriFieldTypeString, alias: Record Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• F125 (type: esriFieldTypeString, alias: F125, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: BhamBreweries$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/12/2025 9:17:54 PM

Schema Last Edit Date: 2/12/2025 9:17:54 PM

Data Last Edit Date: 2/12/2025 9:17:54 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat