{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 42, "name": "ProductInventory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 51, "name": "ProductInventoryTransactions", "relatedTableId": 43, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{3272C523-A5A3-48A6-85B3-44D2222B3CAD}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1618022199000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "INVLOC", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "INVLOC", "type": "esriFieldTypeString", "alias": "Inventory Location", "domain": { "type": "codedValue", "name": "InventoryLocation", "description": "Location for inventory", "codedValues": [ { "name": "AC710", "code": "AC710" }, { "name": "AC720", "code": "AC720" }, { "name": "AC730", "code": "AC730" }, { "name": "AC740", "code": "AC740" }, { "name": "Example", "code": "Example" }, { "name": "Example2", "code": "Example2" }, { "name": "OS-CARRIE", "code": "OS-CARRIE" }, { "name": "OS-COREY", "code": "OS-COREY" }, { "name": "OS-JOHN", "code": "OS-JOHN" }, { "name": "OS-JOLLEY", "code": "OS-JOLLEY" }, { "name": "OS-SARAH", "code": "OS-SARAH" }, { "name": "OS-WEEKS", "code": "OS-WEEKS" }, { "name": "TK001", "code": "TK001" }, { "name": "TK002", "code": "TK002" }, { "name": "TK003", "code": "TK003" }, { "name": "TK004", "code": "TK004" }, { "name": "TK005", "code": "TK005" }, { "name": "TK006", "code": "TK006" }, { "name": "TK007", "code": "TK007" }, { "name": "TK008", "code": "TK008" }, { "name": "TK009", "code": "TK009" }, { "name": "TK010", "code": "TK010" }, { "name": "TK011", "code": "TK011" }, { "name": "TK012", "code": "TK012" }, { "name": "TK013", "code": "TK013" }, { "name": "TK014", "code": "TK014" }, { "name": "TK015", "code": "TK015" }, { "name": "TK022", "code": "TK022" }, { "name": "TK023", "code": "TK023" }, { "name": "TK024", "code": "TK024" }, { "name": "TK025", "code": "TK025" }, { "name": "TK026", "code": "TK026" }, { "name": "TK027", "code": "TK027" }, { "name": "TK028", "code": "TK028" }, { "name": "TK029", "code": "TK029" }, { "name": "TK030", "code": "TK030" }, { "name": "TK031", "code": "TK031" }, { "name": "TK286", "code": "TK286" }, { "name": "TK314", "code": "TK314" }, { "name": "TK353", "code": "TK353" }, { "name": "TK380", "code": "TK380" }, { "name": "TK381", "code": "TK381" }, { "name": "TK394", "code": "TK394" }, { "name": "TK395", "code": "TK395" }, { "name": "TK396", "code": "TK396" }, { "name": "TK397", "code": "TK397" }, { "name": "TK398", "code": "TK398" }, { "name": "TK400", "code": "TK400" }, { "name": "TK402", "code": "TK402" }, { "name": "TK403", "code": "TK403" }, { "name": "TK405", "code": "TK405" }, { "name": "TK406", "code": "TK406" }, { "name": "TK407", "code": "TK407" }, { "name": "TK408", "code": "TK408" }, { "name": "TK409", "code": "TK409" }, { "name": "TK410", "code": "TK410" }, { "name": "TK412", "code": "TK412" }, { "name": "TK414", "code": "TK414" }, { "name": "TK417", "code": "TK417" }, { "name": "TK419", "code": "TK419" }, { "name": "TK421", "code": "TK421" }, { "name": "TK423", "code": "TK423" }, { "name": "TK424", "code": "TK424" }, { "name": "TK425", "code": "TK425" }, { "name": "TK426", "code": "TK426" }, { "name": "TK427", "code": "TK427" }, { "name": "TK429", "code": "TK429" }, { "name": "TK430", "code": "TK430" }, { "name": "TK431", "code": "TK431" }, { "name": "TK434", "code": "TK434" }, { "name": "TK435", "code": "TK435" }, { "name": "TK436", "code": "TK436" }, { "name": "TK438", "code": "TK438" }, { "name": "TK442", "code": "TK442" }, { "name": "TK443", "code": "TK443" }, { "name": "TK451", "code": "TK451" }, { "name": "TK454", "code": "TK454" }, { "name": "TK455", "code": "TK455" }, { "name": "TK456", "code": "TK456" }, { "name": "TK457", "code": "TK457" }, { "name": "TK458", "code": "TK458" }, { "name": "TK462", "code": "TK462" }, { "name": "TK464", "code": "TK464" }, { "name": "TK465", "code": "TK465" }, { "name": "TK466", "code": "TK466" }, { "name": "TK467", "code": "TK467" }, { "name": "TK468", "code": "TK468" }, { "name": "TK469", "code": "TK469" }, { "name": "TK470", "code": "TK470" }, { "name": "TK472", "code": "TK472" }, { "name": "TK473", "code": "TK473" }, { "name": "TK474", "code": "TK474" }, { "name": "TK475", "code": "TK475" }, { "name": "TK476", "code": "TK476" }, { "name": "TK477", "code": "TK477" }, { "name": "TK478", "code": "TK478" }, { "name": "TK479", "code": "TK479" }, { "name": "TK480", "code": "TK480" }, { "name": "TK481", "code": "TK481" }, { "name": "TK482", "code": "TK482" }, { "name": "TK486", "code": "TK486" }, { "name": "TK487", "code": "TK487" }, { "name": "TK491", "code": "TK491" }, { "name": "TK493", "code": "TK493" }, { "name": "TK494", "code": "TK494" }, { "name": "TK495", "code": "TK495" }, { "name": "TK496", "code": "TK496" }, { "name": "TK497", "code": "TK497" }, { "name": "TK498", "code": "TK498" }, { "name": "TK499", "code": "TK499" }, { "name": "TK500", "code": "TK500" }, { "name": "TK501", "code": "TK501" }, { "name": "TK502", "code": "TK502" }, { "name": "TK503", "code": "TK503" }, { "name": "TK504", "code": "TK504" }, { "name": "TK505", "code": "TK505" }, { "name": "TK506", "code": "TK506" }, { "name": "TK507", "code": "TK507" }, { "name": "TK508", "code": "TK508" }, { "name": "TK509", "code": "TK509" }, { "name": "TK510", "code": "TK510" }, { "name": "TK511", "code": "TK511" }, { "name": "TK512", "code": "TK512" }, { "name": "TK513", "code": "TK513" }, { "name": "TK514", "code": "TK514" }, { "name": "TK515", "code": "TK515" }, { "name": "TRLR312", "code": "TRLR312" }, { "name": "TRLR440", "code": "TRLR440" }, { "name": "TRLR444", "code": "TRLR444" }, { "name": "TRLR476", "code": "TRLR476" }, { "name": "KEY LARGO", "code": "WH-KEY LARGO" }, { "name": "KEY WEST", "code": "WH-KEY WEST" }, { "name": "MAP", "code": "WH-MAP" }, { "name": "MAP AVIATION", "code": "WH-MAP AVIATION" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "INVLOC" }, { "name": "PRODUCT", "type": "esriFieldTypeString", "alias": "Product", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PRODUCT" }, { "name": "QTY", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "QTY" }, { "name": "QTYUNIT", "type": "esriFieldTypeString", "alias": "Quantity Unit", "domain": { "type": "codedValue", "name": "MosquitoProductMeasureUnit", "description": "Measurement unit for products", "codedValues": [ { "name": "briquet", "code": "briquet" }, { "name": "dry oz", "code": "dry oz" }, { "name": "each", "code": "each" }, { "name": "fl oz", "code": "fl oz" }, { "name": "gal", "code": "gal" }, { "name": "lb", "code": "lb" }, { "name": "packet", "code": "packet" }, { "name": "pouch", "code": "pouch" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "QTYUNIT" }, { "name": "LASTMODDATE", "type": "esriFieldTypeDate", "alias": "Last Modified Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTMODDATE" }, { "name": "LASTMODBY", "type": "esriFieldTypeString", "alias": "Last Modified By", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "LASTMODBY" }, { "name": "EXTERNALID", "type": "esriFieldTypeString", "alias": "External ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTERNALID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "UUID_115", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_115", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "ProductInventory", "description": "", "prototype": { "attributes": { "EXTERNALID": null, "INVLOC": null, "PRODUCT": null, "QTY": null, "QTYUNIT": null, "LASTMODDATE": null, "LASTMODBY": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1, "serviceItemId": "f5536cda0c614cd2ab9d5206d9f92e7e" }