Name: WWT_Vendors

Display Field: Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Id (type: esriFieldTypeInteger, alias: Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• StreetAddress (type: esriFieldTypeString, alias: StreetAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: ZipCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContactNumber1 (type: esriFieldTypeString, alias: ContactNumber1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContactNumber2 (type: esriFieldTypeString, alias: ContactNumber2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PrimaryContact (type: esriFieldTypeString, alias: PrimaryContact, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SecondaryContact (type: esriFieldTypeString, alias: SecondaryContact, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ModuleId (type: esriFieldTypeString, alias: ModuleId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LastUpdatedOn (type: esriFieldTypeDate, alias: LastUpdatedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LastUpdatedBy (type: esriFieldTypeString, alias: LastUpdatedBy, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IsEnabled (type: esriFieldTypeInteger, alias: IsEnabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreatedOn (type: esriFieldTypeDate, alias: CreatedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RegistrationCounter (type: esriFieldTypeInteger, alias: RegistrationCounter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RegistrationID (type: esriFieldTypeInteger, alias: RegistrationID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RegistrationType (type: esriFieldTypeString, alias: RegistrationType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PaymentDate (type: esriFieldTypeString, alias: PaymentDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PaymentAmount (type: esriFieldTypeString, alias: PaymentAmount, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CertOfInsurance (type: esriFieldTypeString, alias: CertOfInsurance, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WorkersComp (type: esriFieldTypeString, alias: WorkersComp, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• StateRegNumber (type: esriFieldTypeString, alias: StateRegNumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RegExpDate (type: esriFieldTypeString, alias: RegExpDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• InsExpDate (type: esriFieldTypeString, alias: InsExpDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• StateExpDate (type: esriFieldTypeString, alias: StateExpDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WorkersExpdate (type: esriFieldTypeString, alias: WorkersExpdate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContactEmail (type: esriFieldTypeString, alias: ContactEmail, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ContactFax (type: esriFieldTypeString, alias: ContactFax, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Fed_StateID (type: esriFieldTypeString, alias: Fed_StateID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RegisteredAs (type: esriFieldTypeString, alias: RegisteredAs, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CheckNo (type: esriFieldTypeString, alias: CheckNo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OriginalVendorId (type: esriFieldTypeString, alias: OriginalVendorId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Violator (type: esriFieldTypeInteger, alias: Violator, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PaymentMethod (type: esriFieldTypeString, alias: PaymentMethod, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CompanyName (type: esriFieldTypeString, alias: CompanyName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VendorTypeId (type: esriFieldTypeInteger, alias: VendorTypeId, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MailingStreetAddress (type: esriFieldTypeString, alias: MailingStreetAddress, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingCity (type: esriFieldTypeString, alias: MailingCity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingState (type: esriFieldTypeString, alias: MailingState, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MailingZipCode (type: esriFieldTypeString, alias: MailingZipCode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• StatusId (type: esriFieldTypeString, alias: StatusId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• InsertedFrom (type: esriFieldTypeString, alias: InsertedFrom, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HICNumber (type: esriFieldTypeString, alias: HICNumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HICExpDate (type: esriFieldTypeString, alias: HICExpDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NumberOfEmployees (type: esriFieldTypeString, alias: NumberOfEmployees, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NumberOfYearsInBusiness (type: esriFieldTypeString, alias: NumberOfYearsInBusiness, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Suite (type: esriFieldTypeString, alias: Suite, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• JobName (type: esriFieldTypeString, alias: JobName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IsResidental (type: esriFieldTypeInteger, alias: IsResidental, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QuestionnaireId (type: esriFieldTypeString, alias: QuestionnaireId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IsDeleted (type: esriFieldTypeString, alias: IsDeleted, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BalanceAmount (type: esriFieldTypeDouble, alias: BalanceAmount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsBillingAccount (type: esriFieldTypeInteger, alias: IsBillingAccount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsCommercial (type: esriFieldTypeInteger, alias: IsCommercial, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeStart (type: esriFieldTypeDate, alias: TimeStart, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TimeEnd (type: esriFieldTypeDate, alias: TimeEnd, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InsuranceCompany (type: esriFieldTypeString, alias: InsuranceCompany, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ChildOrganizationId (type: esriFieldTypeString, alias: ChildOrganizationId, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IsPersonInCharge (type: esriFieldTypeInteger, alias: IsPersonInCharge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsPropertyManager (type: esriFieldTypeInteger, alias: IsPropertyManager, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsRequestPayment (type: esriFieldTypeInteger, alias: IsRequestPayment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RequestPaymentEmailLastSentOn (type: esriFieldTypeString, alias: RequestPaymentEmailLastSentOn, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: WWT_Vendors
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/27/2025 5:51:33 PM

Schema Last Edit Date: 1/27/2025 5:51:33 PM

Data Last Edit Date: 1/26/2024 3:28:13 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat