Name: Receipt

Display Field: receipt_no

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:

• receipt_no ( type: esriFieldTypeString, alias: receipt_no, length: 10 )
• receipt_date ( type: esriFieldTypeDate, alias: receipt_date, length: 8 )
• person_id ( type: esriFieldTypeString, alias: person_id, length: 10 )
• paid_by ( type: esriFieldTypeString, alias: paid_by, length: 81 )
• card_no ( type: esriFieldTypeString, alias: card_no, length: 20 )
• card_exp ( type: esriFieldTypeString, alias: card_exp, length: 5 )
• cash_amt ( type: esriFieldTypeDouble, alias: cash_amt )
• check_amt ( type: esriFieldTypeDouble, alias: check_amt )
• credit_amt ( type: esriFieldTypeDouble, alias: credit_amt )
• total_amt ( type: esriFieldTypeDouble, alias: total_amt )
• tendered_amt ( type: esriFieldTypeDouble, alias: tendered_amt )
• change_amt ( type: esriFieldTypeDouble, alias: change_amt )
• balance_amt ( type: esriFieldTypeDouble, alias: balance_amt )
• location ( type: esriFieldTypeString, alias: location, length: 8 )
• userid ( type: esriFieldTypeString, alias: userid, length: 8 )
• stamp ( type: esriFieldTypeDate, alias: stamp, length: 8 )
• receipt_identity ( type: esriFieldTypeInteger, alias: receipt_identity )
• receipt_stat ( type: esriFieldTypeString, alias: receipt_stat, length: 10 )
• transaction_id ( type: esriFieldTypeString, alias: transaction_id, length: 50 )
• authorization_code ( type: esriFieldTypeString, alias: authorization_code, length: 50 )
• jurisdiction ( type: esriFieldTypeString, alias: jurisdiction, length: 15 )
• receipt_comment ( type: esriFieldTypeString, alias: receipt_comment, length: 240 )
• extra1 ( type: esriFieldTypeString, alias: extra1, length: 26 )
• extra2 ( type: esriFieldTypeString, alias: extra2, length: 26 )
• reference_no ( type: esriFieldTypeString, alias: reference_no, length: 50 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata