Name: ProductInventory
Display Field: INVLOC
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- INVLOC (type: esriFieldTypeString, alias: Inventory Location, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [56250: 56250], [52487: 52487], [58145: 58145], ... 13 more ...)
- PRODUCT (type: esriFieldTypeString, alias: Product, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- QTY (type: esriFieldTypeDouble, alias: Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
- QTYUNIT (type: esriFieldTypeString, alias: Quantity Unit, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [briquet: briquet], [dry oz: dry oz], [each: each], ... 5 more ...)
- LASTMODDATE (type: esriFieldTypeDate, alias: Last Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LASTMODBY (type: esriFieldTypeString, alias: Last Modified By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- EXTERNALID (type: esriFieldTypeString, alias: External ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: ProductInventory
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/29/2026 9:30:46 PM
Schema Last Edit Date: 8/14/2026 2:05:52 PM
Data Last Edit Date: 8/30/2026 7:16:19 AM
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