Name: Business License Table
Display Field: bname
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
original
(
type: esriFieldTypeDate, alias: Original Issue Date, length: 8
)
-
renew
(
type: esriFieldTypeDate, alias: Renewal Date, length: 8
)
-
expire
(
type: esriFieldTypeDate, alias: Expiration Date, length: 8
)
-
discontdt
(
type: esriFieldTypeDate, alias: Discontinued Date, length: 8
)
-
PIN
(
type: esriFieldTypeString, alias: PIN, length: 11
)
-
VISIONPID
(
type: esriFieldTypeDouble, alias: VisionID
)
-
full_address
(
type: esriFieldTypeString, alias: Full Address of Business, length: 50
)
-
MSADD
(
type: esriFieldTypeString, alias: MSADD, length: 15
)
-
STREET
(
type: esriFieldTypeString, alias: STREET, length: 50
)
-
btype
(
type: esriFieldTypeString, alias: Business Type, length: 1073741822
)
-
status_1
(
type: esriFieldTypeInteger, alias: Status
)
-
status_str
(
type: esriFieldTypeString, alias: Status, length: 15
, Coded Values:
[Active: Active]
, [Inactive: Inactive]
)
-
certnum
(
type: esriFieldTypeInteger, alias: certnum
)
-
notes
(
type: esriFieldTypeString, alias: Notes, length: 1073741822
)
-
bname
(
type: esriFieldTypeString, alias: Business Name, length: 1073741822
)
-
bhousenum
(
type: esriFieldTypeString, alias: Business Address #, length: 1073741822
)
-
bstreetname
(
type: esriFieldTypeString, alias: Business Street Name, length: 1073741822
, Coded Values:
[Abbott Avenue: Abbott Avenue]
, [Abigail Lane: Abigail Lane]
, [Adrian Avenue: Adrian Avenue]
, ...534 more...
)
-
bapt
(
type: esriFieldTypeString, alias: Business Apt #, length: 1073741822
)
-
bcity
(
type: esriFieldTypeString, alias: Business City, length: 1073741822
)
-
bstate
(
type: esriFieldTypeString, alias: Business State, length: 1073741822
)
-
bzip
(
type: esriFieldTypeString, alias: Business Zip, length: 5
)
-
bphone
(
type: esriFieldTypeString, alias: Business Phone #, length: 1073741822
)
-
parentname
(
type: esriFieldTypeString, alias: Parent Company Name, length: 1073741822
)
-
paddr1
(
type: esriFieldTypeString, alias: Parent Company Address and Street, length: 1073741822
)
-
paddr2
(
type: esriFieldTypeString, alias: Parent Company Suite #, length: 1073741822
)
-
pcsz
(
type: esriFieldTypeString, alias: Parent Company City, State, Zip, length: 1073741822
)
-
lname1
(
type: esriFieldTypeString, alias: Owner 1 Last Name, length: 1073741822
)
-
fname1
(
type: esriFieldTypeString, alias: Owner 1 First Name, length: 1073741822
)
-
n1housenum
(
type: esriFieldTypeString, alias: Owner 1 Address #, length: 1073741822
)
-
n1streetname
(
type: esriFieldTypeString, alias: Owner 1 Street Name, length: 1073741822
)
-
n1apt
(
type: esriFieldTypeString, alias: Owner 1 Apt. #, length: 1073741822
)
-
n1city
(
type: esriFieldTypeString, alias: Owner 1 City, length: 1073741822
)
-
n1state
(
type: esriFieldTypeString, alias: Owner 1 State, length: 1073741822
)
-
n1zip
(
type: esriFieldTypeString, alias: Owner 1 Zip, length: 1073741822
)
-
n1phone
(
type: esriFieldTypeString, alias: Owner 1 Phone, length: 1073741822
)
-
lname2
(
type: esriFieldTypeString, alias: Owner 2 Last Name, length: 1073741822
)
-
fname2
(
type: esriFieldTypeString, alias: Owner 2 First Name, length: 1073741822
)
-
n2housenum
(
type: esriFieldTypeString, alias: Owner 2 Address #, length: 20
)
-
n2streetname
(
type: esriFieldTypeString, alias: Owner 2 Street Name, length: 1073741822
)
-
n2apt
(
type: esriFieldTypeString, alias: Owner 2 Apt #, length: 1073741822
)
-
n2city
(
type: esriFieldTypeString, alias: Owner 2 City, length: 1073741822
)
-
n2state
(
type: esriFieldTypeString, alias: Owner 2 State, length: 1073741822
)
-
n2zip
(
type: esriFieldTypeString, alias: Owner 2 Zip, length: 5
)
-
n2phone
(
type: esriFieldTypeString, alias: Owner 2 Phone, length: 1073741822
)
-
lname3
(
type: esriFieldTypeString, alias: Owner 3 Last Name, length: 1073741822
)
-
fname3
(
type: esriFieldTypeString, alias: Owner 3 First Name, length: 1073741822
)
-
n3housenum
(
type: esriFieldTypeInteger, alias: Owner 3 Address #
)
-
n3streetname
(
type: esriFieldTypeString, alias: Owner 3 Street Name, length: 1073741822
)
-
n3apt
(
type: esriFieldTypeString, alias: Owner 3 Apt #, length: 1073741822
)
-
n3city
(
type: esriFieldTypeString, alias: Owner 3 City, length: 1073741822
)
-
n3state
(
type: esriFieldTypeString, alias: Owner 3 State, length: 1073741822
)
-
n3zip
(
type: esriFieldTypeString, alias: Owner 3 Zip, length: 5
)
-
n3phone
(
type: esriFieldTypeString, alias: Owner 3 Phone, length: 1073741822
)
-
lname4
(
type: esriFieldTypeString, alias: Owner 4 Last Name, length: 1073741822
)
-
fname4
(
type: esriFieldTypeString, alias: Owner 4 First Name, length: 1073741822
)
-
n4housenum
(
type: esriFieldTypeString, alias: Owner 4 Address #, length: 20
)
-
n4streetname
(
type: esriFieldTypeString, alias: Owner 4 Street Name, length: 100
)
-
n4apt
(
type: esriFieldTypeString, alias: Owner 4 Apt #, length: 1073741822
)
-
n4city
(
type: esriFieldTypeString, alias: Owner 4 City, length: 1073741822
)
-
n4st
(
type: esriFieldTypeString, alias: Owner 4 State, length: 1073741822
)
-
n4zip
(
type: esriFieldTypeString, alias: Owner 4 Zip, length: 1073741822
)
-
n4phone
(
type: esriFieldTypeString, alias: Owner 4 Phone, length: 1073741822
)
-
id
(
type: esriFieldTypeString, alias: softright_id, length: 1073741822
)
-
check_address
(
type: esriFieldTypeString, alias: check_address, length: 50
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
mailing_label_address
(
type: esriFieldTypeString, alias: Send Mailing Label to, length: 255
, Coded Values:
[Business Address: Business Address]
, [Parent Company Address: Parent Company Address]
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
Relationships:
Supported Operations:
Query
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata