Name: Purchase Orders
Display Field: VendorName
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: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- PO_No (type: esriFieldTypeString, alias: PO_No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PO_Date (type: esriFieldTypeDate, alias: PO_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- PO_ItemNo (type: esriFieldTypeString, alias: PO_ItemNo, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- Qty (type: esriFieldTypeDouble, alias: Qty, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UnitPrice (type: esriFieldTypeDouble, alias: UnitPrice, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UOM (type: esriFieldTypeString, alias: UOM, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- MaterialDescription (type: esriFieldTypeString, alias: MaterialDescription, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- VendorName (type: esriFieldTypeString, alias: VendorName, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- VendorAddress (type: esriFieldTypeString, alias: VendorAddress, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- VendorCity (type: esriFieldTypeString, alias: VendorCity, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- VendorState (type: esriFieldTypeString, alias: VendorState, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- VendorZip (type: esriFieldTypeString, alias: VendorZip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Templates:
Name: Purchase Orders
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/5/2025 5:22:21 AM
Schema Last Edit Date: 5/5/2025 5:22:21 AM
Data Last Edit Date: 5/5/2025 5:22:14 AM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat