Name: Review

Display Field:

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

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• App_Name (type: esriFieldTypeString, alias: App_Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Authority_Name (type: esriFieldTypeString, alias: Authority_Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Application_Id (type: esriFieldTypeString, alias: Application_Id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Production_Title (type: esriFieldTypeString, alias: Production_Title, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Production_Company (type: esriFieldTypeString, alias: Production_Company, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ItemType (type: esriFieldTypeString, alias: ItemType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Item_Description (type: esriFieldTypeString, alias: Item_Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Amount (type: esriFieldTypeInteger, alias: Amount, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Tax_Amount (type: esriFieldTypeInteger, alias: Tax_Amount, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total (type: esriFieldTypeInteger, alias: Total, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Deleted_date (type: esriFieldTypeString, alias: Deleted_date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Payment_Method_Type (type: esriFieldTypeString, alias: Payment_Method_Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Payment_Received_Date (type: esriFieldTypeDateOnly, alias: Payment_Received_Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• Payment_Reference (type: esriFieldTypeInteger, alias: Payment_Reference, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Invoice_Type (type: esriFieldTypeString, alias: Invoice_Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoice_Number (type: esriFieldTypeString, alias: Invoice_Number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoice_Number_Sequential (type: esriFieldTypeInteger, alias: Invoice_Number_Sequential, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Invoice_Number_Job_Number (type: esriFieldTypeString, alias: Invoice_Number_Job_Number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoice_Number_Suffix (type: esriFieldTypeString, alias: Invoice_Number_Suffix, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoice_Created_Date (type: esriFieldTypeDateOnly, alias: Invoice_Created_Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• Invoice_Sent_Date (type: esriFieldTypeDateOnly, alias: Invoice_Sent_Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• Invoice_Cancelled_Date (type: esriFieldTypeString, alias: Invoice_Cancelled_Date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Purchase_Order_Number (type: esriFieldTypeString, alias: Purchase_Order_Number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoice_Notes (type: esriFieldTypeString, alias: Invoice_Notes, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Finance_Notes (type: esriFieldTypeString, alias: Finance_Notes, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• acct_email (type: esriFieldTypeString, alias: acct_email, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Acct_Name (type: esriFieldTypeString, alias: Acct_Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Acct_Phone (type: esriFieldTypeString, alias: Acct_Phone, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DeKalb_POC (type: esriFieldTypeString, alias: DeKalb_POC, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoicing_Address (type: esriFieldTypeString, alias: Invoicing_Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Invoice_City (type: esriFieldTypeString, alias: Invoice_City, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Prod_Address (type: esriFieldTypeString, alias: Prod_Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Prod_City (type: esriFieldTypeString, alias: Prod_City, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Prod_Zip (type: esriFieldTypeInteger, alias: Prod_Zip, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Amount2 (type: esriFieldTypeString, alias: Amount2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Cancelled (type: esriFieldTypeString, alias: Cancelled, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Reason (type: esriFieldTypeString, alias: Reason, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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