Name: Inventory history

Display Field: item_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• inventory_history_identity ( type: esriFieldTypeInteger, alias: inventory_history_identity )
• item_code ( type: esriFieldTypeString, alias: item_code, length: 30 )
• item_abbrev ( type: esriFieldTypeString, alias: item_abbrev, length: 13 )
• item_name ( type: esriFieldTypeString, alias: item_name, length: 50 )
• item_class ( type: esriFieldTypeString, alias: item_class, length: 10 )
• item_type ( type: esriFieldTypeString, alias: item_type, length: 10 )
• upc ( type: esriFieldTypeString, alias: upc, length: 15 )
• dept ( type: esriFieldTypeString, alias: dept, length: 10 )
• account_code ( type: esriFieldTypeString, alias: account_code, length: 50 )
• dea_code ( type: esriFieldTypeString, alias: dea_code, length: 10 )
• manufacturer_code ( type: esriFieldTypeString, alias: manufacturer_code, length: 10 )
• dispense_dose ( type: esriFieldTypeSingle, alias: dispense_dose )
• dispense_unit ( type: esriFieldTypeString, alias: dispense_unit, length: 10 )
• item_unit ( type: esriFieldTypeString, alias: item_unit, length: 10 )
• current_cost ( type: esriFieldTypeDouble, alias: current_cost )
• dispense_price ( type: esriFieldTypeDouble, alias: dispense_price )
• tax_type ( type: esriFieldTypeString, alias: tax_type, length: 5 )
• quant_on_hand ( type: esriFieldTypeDouble, alias: quant_on_hand )
• order_point ( type: esriFieldTypeDouble, alias: order_point )
• item_location ( type: esriFieldTypeString, alias: item_location, length: 8 )
• item_stat ( type: esriFieldTypeString, alias: item_stat, length: 10 )
• location ( type: esriFieldTypeString, alias: location, length: 8 )
• userid ( type: esriFieldTypeString, alias: userid, length: 8 )
• stamp ( type: esriFieldTypeDate, alias: stamp, length: 8 )
• account_code2 ( type: esriFieldTypeString, alias: account_code2, length: 50 )
• extra1 ( type: esriFieldTypeString, alias: extra1, length: 26 )
• extra2 ( type: esriFieldTypeString, alias: extra2, length: 26 )
• extra3 ( type: esriFieldTypeString, alias: extra3, length: 26 )
• extra4 ( type: esriFieldTypeString, alias: extra4, length: 26 )
• extra5 ( type: esriFieldTypeString, alias: extra5, length: 26 )
• hide_receipt_f4 ( type: esriFieldTypeString, alias: hide_receipt_f4, length: 1 )
• inventory_identity ( type: esriFieldTypeInteger, alias: inventory_identity )
• jurisdiction ( type: esriFieldTypeString, alias: jurisdiction, length: 15 )
• processing_type ( type: esriFieldTypeString, alias: processing_type, length: 50 )
• tag_term ( type: esriFieldTypeInteger, alias: tag_term )
• tag_term_avail ( type: esriFieldTypeInteger, alias: tag_term_avail )
• controlled ( type: esriFieldTypeString, alias: controlled, length: 1 )
• organization_id ( type: esriFieldTypeInteger, alias: organization_id )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata