View In:   ArcGIS Online Map Viewer

Name: DBO.master_tblItem

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: f75bf806ba25405bb72f718735afa199

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [155, 49, 63, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SysID ( type: esriFieldTypeInteger, alias: SysID, editable: true, nullable: false, defaultValue: null, modelName: SysID )
• ItemCode ( type: esriFieldTypeString, alias: ItemCode, editable: true, nullable: false, length: 30, defaultValue: null, modelName: ItemCode )
• ItemShortDescription ( type: esriFieldTypeString, alias: ItemShortDescription, editable: true, nullable: false, length: 30, defaultValue: null, modelName: ItemShortDescription )
• ItemDescription ( type: esriFieldTypeString, alias: ItemDescription, editable: true, nullable: false, length: 240, defaultValue: null, modelName: ItemDescription )
• OrgCode ( type: esriFieldTypeString, alias: OrgCode, editable: true, nullable: false, length: 10, defaultValue: null, modelName: OrgCode )
• CommodityCode ( type: esriFieldTypeString, alias: CommodityCode, editable: true, nullable: false, length: 10, defaultValue: null, modelName: CommodityCode )
• VarietyCode ( type: esriFieldTypeString, alias: VarietyCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VarietyCode )
• ColorCode ( type: esriFieldTypeString, alias: ColorCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ColorCode )
• PackType ( type: esriFieldTypeString, alias: PackType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PackType )
• TypeCode ( type: esriFieldTypeString, alias: TypeCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TypeCode )
• BrandCode ( type: esriFieldTypeString, alias: BrandCode, editable: true, nullable: false, length: 10, defaultValue: null, modelName: BrandCode )
• GradeCode ( type: esriFieldTypeString, alias: GradeCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GradeCode )
• SizeCode ( type: esriFieldTypeString, alias: SizeCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SizeCode )
• CountCode ( type: esriFieldTypeString, alias: CountCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CountCode )
• NetWeightCode ( type: esriFieldTypeString, alias: NetWeightCode, editable: true, nullable: false, length: 10, defaultValue: null, modelName: NetWeightCode )
• PackTypeCode ( type: esriFieldTypeString, alias: PackTypeCode, editable: true, nullable: false, length: 10, defaultValue: null, modelName: PackTypeCode )
• SubPackTypeCode ( type: esriFieldTypeString, alias: SubPackTypeCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SubPackTypeCode )
• GrowingMethodCode ( type: esriFieldTypeString, alias: GrowingMethodCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GrowingMethodCode )
• NoInventoryCost ( type: esriFieldTypeSmallInteger, alias: NoInventoryCost, editable: true, nullable: false, defaultValue: null, modelName: NoInventoryCost )
• OracleCode ( type: esriFieldTypeString, alias: OracleCode, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OracleCode )
• SAPItemCode ( type: esriFieldTypeString, alias: SAPItemCode, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SAPItemCode )
• SAPUOM ( type: esriFieldTypeString, alias: SAPUOM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SAPUOM )
• EnteredBy ( type: esriFieldTypeString, alias: EnteredBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EnteredBy )
• DateEntered ( type: esriFieldTypeDate, alias: DateEntered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateEntered )
• ValueBox ( type: esriFieldTypeDouble, alias: ValueBox, editable: true, nullable: true, defaultValue: null, modelName: ValueBox )
• CuMtr ( type: esriFieldTypeDouble, alias: CuMtr, editable: true, nullable: true, defaultValue: null, modelName: CuMtr )
• GrossWtBox ( type: esriFieldTypeDouble, alias: GrossWtBox, editable: true, nullable: true, defaultValue: null, modelName: GrossWtBox )
• ProductLine ( type: esriFieldTypeString, alias: ProductLine, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProductLine )
• PackMatType ( type: esriFieldTypeString, alias: PackMatType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PackMatType )
• PackOutDtls ( type: esriFieldTypeString, alias: PackOutDtls, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PackOutDtls )
• QualityGrade ( type: esriFieldTypeString, alias: QualityGrade, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QualityGrade )
• CrownCondition ( type: esriFieldTypeString, alias: CrownCondition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CrownCondition )
• NetWt ( type: esriFieldTypeDouble, alias: NetWt, editable: true, nullable: true, defaultValue: null, modelName: NetWt )

Templates:

• Name: DBO.master_tblItem
  Description:
  Prototype:
  CrownCondition: null
  NetWt: null
  SysID: 0
  ItemCode:
  ItemShortDescription:
  ItemDescription:
  OrgCode:
  CommodityCode:
  VarietyCode: null
  ColorCode: null
  PackType: null
  TypeCode: null
  BrandCode:
  GradeCode: null
  SizeCode: null
  CountCode: null
  NetWeightCode:
  PackTypeCode:
  SubPackTypeCode: null
  GrowingMethodCode: null
  NoInventoryCost: 0
  OracleCode: null
  SAPItemCode: null
  SAPUOM: null
  EnteredBy: null
  DateEntered: null
  ValueBox: null
  CuMtr: null
  GrossWtBox: null
  ProductLine: null
  PackMatType: null
  PackOutDtls: null
  QualityGrade: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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