Name: invoicing_repeat

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

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: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• InvoiceStatus (type: esriFieldTypeString, alias: Invoice Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InvoiceTypeName (type: esriFieldTypeString, alias: Invoice Type Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [private_detention: Private Detention Chapter 70.395 RCW])
• FeeName (type: esriFieldTypeString, alias: Fee Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [private_detention_adult: Violation Chapter 70.395 RCW - Private Detention Adult], [private_detention_juvenile: Violation Chapter 70.395 RCW - Private Detention Juvenile])
• InvoiceItemAmount (type: esriFieldTypeDouble, alias: Invoice Item Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InvoiceContactName (type: esriFieldTypeString, alias: Invoice Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InvoiceContactMailingAddress (type: esriFieldTypeString, alias: Invoice Contact Mailing Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DueDate (type: esriFieldTypeDate, alias: Payment Due Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comment (type: esriFieldTypeString, alias: Comment included on invoice, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UBI (type: esriFieldTypeString, alias: UBI, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BusinessName (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BusinessAddress (type: esriFieldTypeString, alias: Business Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DateTimeSubmitted (type: esriFieldTypeDate, alias: Submission date and time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• invoice_username (type: esriFieldTypeString, alias: User who submitted the invoice, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InvoiceId (type: esriFieldTypeString, alias: Invoice Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DueDate_EH (type: esriFieldTypeDate, alias: Due Date from EH Invoicing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InvoiceTotal (type: esriFieldTypeDouble, alias: Invoice Total from EH Invoicing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ScanCode (type: esriFieldTypeString, alias: Scan Code for Invoice Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• appeal (type: esriFieldTypeString, alias: Select if applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [appeal_requested: Appeal Requested])
• date_appeal_requested (type: esriFieldTypeDate, alias: Date appleal requested, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• Private_Detention_Facility_Complaints_invoicing_repeat (3) -- Related To: survey (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/19/2025 12:57:11 AM

Schema Last Edit Date: 7/23/2025 8:16:37 PM

Data Last Edit Date: 8/19/2025 1:08:58 AM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat