Name: Invoice

Display Field: VerifiedUsername

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ae2d807b2a544b85bbc269044a63d425

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TotalExclVat ( type: esriFieldTypeDouble, alias: TotalExclVat, editable: true, nullable: true, defaultValue: null, modelName: TotalExclVat )
• TotalInclVAT ( type: esriFieldTypeDouble, alias: TotalInclVAT, editable: true, nullable: true, defaultValue: null, modelName: TotalInclVAT )
• InvoiceID ( type: esriFieldTypeInteger, alias: InvoiceID, editable: true, nullable: true, defaultValue: null, modelName: InvoiceID )
• InvoiceDate ( type: esriFieldTypeDate, alias: InvoiceDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InvoiceDate )
• AppID ( type: esriFieldTypeInteger, alias: AppID, editable: true, nullable: false, defaultValue: null, modelName: AppID )
• PaymentReceived ( type: esriFieldTypeString, alias: PaymentReceived, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaymentReceived )
• Verified ( type: esriFieldTypeString, alias: Verified, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Verified )
• VerifiedUsername ( type: esriFieldTypeString, alias: VerifiedUsername, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VerifiedUsername )
• ContactPersonID ( type: esriFieldTypeInteger, alias: ContactPersonID, editable: true, nullable: true, defaultValue: null, modelName: ContactPersonID )
• CreatedUsername ( type: esriFieldTypeString, alias: CreatedUsername, editable: true, nullable: true, length: 200, defaultValue: null, modelName: CreatedUsername )
• PaymentDue ( type: esriFieldTypeDate, alias: PaymentDue, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PaymentDue )
• SystemModuleID ( type: esriFieldTypeInteger, alias: SystemModuleID, editable: true, nullable: true, defaultValue: null, modelName: SystemModuleID )
• PersonResponsibleID ( type: esriFieldTypeInteger, alias: PersonResponsibleID, editable: true, nullable: true, defaultValue: null, modelName: PersonResponsibleID )

Templates:

• Name: Invoice
  Description:
  Prototype:
  SystemModuleID: null
  PersonResponsibleID: null
  TotalExclVat: null
  TotalInclVAT: null
  InvoiceID: null
  InvoiceDate: null
  AppID: 0
  PaymentReceived: null
  Verified: null
  VerifiedUsername: null
  ContactPersonID: null
  CreatedUsername: null
  PaymentDue: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata