Name: SWSBU.dbo.GLMasterPositiveNumberViewQL

Display Field: a_account_type

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 52151c3406be4f47b6bfdf6edb58a65a

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• a_account_type ( type: esriFieldTypeString, alias: a_account_type, length: 1 )
• a_fund_seg1 ( type: esriFieldTypeString, alias: a_fund_seg1, length: 10 )
• a_remaining_orgseg ( type: esriFieldTypeString, alias: a_remaining_orgseg, length: 30 )
• a_object ( type: esriFieldTypeString, alias: a_object, length: 6 )
• a_project ( type: esriFieldTypeString, alias: a_project, length: 10 )
• a_org ( type: esriFieldTypeString, alias: a_org, length: 8 )
• a_entity_code ( type: esriFieldTypeString, alias: a_entity_code, length: 1 )
• a_account_desc ( type: esriFieldTypeString, alias: a_account_desc, length: 30 )
• a_account_desc_sh ( type: esriFieldTypeString, alias: a_account_desc_sh, length: 10 )
• a_bal_sheet_type ( type: esriFieldTypeString, alias: a_bal_sheet_type, length: 1 )
• a_account_status ( type: esriFieldTypeString, alias: a_account_status, length: 1 )
• d_encumb_bud_y_n ( type: esriFieldTypeString, alias: d_encumb_bud_y_n, length: 1 )
• a_budgetary_y_n ( type: esriFieldTypeString, alias: a_budgetary_y_n, length: 1 )
• a_grant_org ( type: esriFieldTypeString, alias: a_grant_org, length: 8 )
• a_grant_object ( type: esriFieldTypeString, alias: a_grant_object, length: 6 )
• a_grant_project ( type: esriFieldTypeString, alias: a_grant_project, length: 5 )
• a_last_update ( type: esriFieldTypeDate, alias: a_last_update, length: 8 )
• a_bal_sheet_sign ( type: esriFieldTypeString, alias: a_bal_sheet_sign, length: 1 )
• a_segment_2 ( type: esriFieldTypeString, alias: a_segment_2, length: 10 )
• a_segment_3 ( type: esriFieldTypeString, alias: a_segment_3, length: 10 )
• a_segment_4 ( type: esriFieldTypeString, alias: a_segment_4, length: 10 )
• a_segment_5 ( type: esriFieldTypeString, alias: a_segment_5, length: 10 )
• a_segment_6 ( type: esriFieldTypeString, alias: a_segment_6, length: 10 )
• a_segment_7 ( type: esriFieldTypeString, alias: a_segment_7, length: 10 )
• a_segment_8 ( type: esriFieldTypeString, alias: a_segment_8, length: 10 )
• a_bud_yr ( type: esriFieldTypeSmallInteger, alias: a_bud_yr )
• b_incept_bal ( type: esriFieldTypeDouble, alias: b_incept_bal )
• d_bud_in_5years ( type: esriFieldTypeDouble, alias: d_bud_in_5years )
• d_ny5_statistics ( type: esriFieldTypeDouble, alias: d_ny5_statistics )
• d_bud_in_4years ( type: esriFieldTypeDouble, alias: d_bud_in_4years )
• d_ny4_statistics ( type: esriFieldTypeDouble, alias: d_ny4_statistics )
• d_bud_in_3years ( type: esriFieldTypeDouble, alias: d_bud_in_3years )
• d_ny3_statistics ( type: esriFieldTypeDouble, alias: d_ny3_statistics )
• d_bud_in_2years ( type: esriFieldTypeDouble, alias: d_bud_in_2years )
• d_ny2_statistics ( type: esriFieldTypeDouble, alias: d_ny2_statistics )
• d_bud_ny_level1 ( type: esriFieldTypeDouble, alias: d_bud_ny_level1 )
• d_bud_ny_level2 ( type: esriFieldTypeDouble, alias: d_bud_ny_level2 )
• d_bud_ny_level3 ( type: esriFieldTypeDouble, alias: d_bud_ny_level3 )
• d_bud_ny_level4 ( type: esriFieldTypeDouble, alias: d_bud_ny_level4 )
• d_bud_ny_level5 ( type: esriFieldTypeDouble, alias: d_bud_ny_level5 )
• d_ny_stat_level1 ( type: esriFieldTypeDouble, alias: d_ny_stat_level1 )
• d_ny_stat_level2 ( type: esriFieldTypeDouble, alias: d_ny_stat_level2 )
• d_ny_stat_level3 ( type: esriFieldTypeDouble, alias: d_ny_stat_level3 )
• d_ny_stat_level4 ( type: esriFieldTypeDouble, alias: d_ny_stat_level4 )
• d_ny_stat_level5 ( type: esriFieldTypeDouble, alias: d_ny_stat_level5 )
• d_bud_cy_level1 ( type: esriFieldTypeDouble, alias: d_bud_cy_level1 )
• d_bud_cy_level2 ( type: esriFieldTypeDouble, alias: d_bud_cy_level2 )
• d_bud_cy_level3 ( type: esriFieldTypeDouble, alias: d_bud_cy_level3 )
• d_bud_cy_level4 ( type: esriFieldTypeDouble, alias: d_bud_cy_level4 )
• d_bud_cy_level5 ( type: esriFieldTypeDouble, alias: d_bud_cy_level5 )
• d_cy_orig_bud ( type: esriFieldTypeDouble, alias: d_cy_orig_bud )
• d_cy_xfr_bud_in ( type: esriFieldTypeDouble, alias: d_cy_xfr_bud_in )
• d_cy_xfr_bud_out ( type: esriFieldTypeDouble, alias: d_cy_xfr_bud_out )
• d_carry_fwrd_cy ( type: esriFieldTypeDouble, alias: d_carry_fwrd_cy )
• d_cary_fwrd_cy_xfr ( type: esriFieldTypeDouble, alias: d_cary_fwrd_cy_xfr )
• d_cy_revised_bud ( type: esriFieldTypeDouble, alias: d_cy_revised_bud )
• b_cy_memo_bal ( type: esriFieldTypeDouble, alias: b_cy_memo_bal )
• b_cy_actual_bal ( type: esriFieldTypeDouble, alias: b_cy_actual_bal )
• b_cy_actl_from_ly ( type: esriFieldTypeDouble, alias: b_cy_actl_from_ly )
• b_cy_est_actual ( type: esriFieldTypeDouble, alias: b_cy_est_actual )
• d_cy_statistics ( type: esriFieldTypeDouble, alias: d_cy_statistics )
• b_cy_encumb ( type: esriFieldTypeDouble, alias: b_cy_encumb )
• b_cy_encmb_frm_ly ( type: esriFieldTypeDouble, alias: b_cy_encmb_frm_ly )
• b_cy_req_balance ( type: esriFieldTypeDouble, alias: b_cy_req_balance )
• d_ly1_orig_bud ( type: esriFieldTypeDouble, alias: d_ly1_orig_bud )
• d_ly1_xfr_bud_in ( type: esriFieldTypeDouble, alias: d_ly1_xfr_bud_in )
• d_ly1_xfr_bud_out ( type: esriFieldTypeDouble, alias: d_ly1_xfr_bud_out )
• d_carry_fwrd_ly1 ( type: esriFieldTypeDouble, alias: d_carry_fwrd_ly1 )
• d_ly1_rev_bud ( type: esriFieldTypeDouble, alias: d_ly1_rev_bud )
• b_ly_memo_bal ( type: esriFieldTypeDouble, alias: b_ly_memo_bal )
• b_ly1_actual_bal ( type: esriFieldTypeDouble, alias: b_ly1_actual_bal )
• b_closed_yr_bal ( type: esriFieldTypeDouble, alias: b_closed_yr_bal )
• d_ly1_statistics ( type: esriFieldTypeDouble, alias: d_ly1_statistics )
• b_ly1_encumb ( type: esriFieldTypeDouble, alias: b_ly1_encumb )
• d_ly2_orig_bud ( type: esriFieldTypeDouble, alias: d_ly2_orig_bud )
• d_ly2_rev_bud ( type: esriFieldTypeDouble, alias: d_ly2_rev_bud )
• b_ly2_actual_bal ( type: esriFieldTypeDouble, alias: b_ly2_actual_bal )
• d_ly2_statistics ( type: esriFieldTypeDouble, alias: d_ly2_statistics )
• d_ly3_orig_bud ( type: esriFieldTypeDouble, alias: d_ly3_orig_bud )
• d_ly3_rev_bud ( type: esriFieldTypeDouble, alias: d_ly3_rev_bud )
• b_ly3_actual_bal ( type: esriFieldTypeDouble, alias: b_ly3_actual_bal )
• d_ly3_statistics ( type: esriFieldTypeDouble, alias: d_ly3_statistics )
• b_ly4_actual_bal ( type: esriFieldTypeDouble, alias: b_ly4_actual_bal )
• b_ly5_actual_bal ( type: esriFieldTypeDouble, alias: b_ly5_actual_bal )
• b_ly6_actual_bal ( type: esriFieldTypeDouble, alias: b_ly6_actual_bal )
• b_ly7_actual_bal ( type: esriFieldTypeDouble, alias: b_ly7_actual_bal )
• b_ly8_actual_bal ( type: esriFieldTypeDouble, alias: b_ly8_actual_bal )
• b_ly9_actual_bal ( type: esriFieldTypeDouble, alias: b_ly9_actual_bal )
• b_ly10_actual_bal ( type: esriFieldTypeDouble, alias: b_ly10_actual_bal )
• d_incp_orig_bud ( type: esriFieldTypeDouble, alias: d_incp_orig_bud )
• d_incp_rev_bud ( type: esriFieldTypeDouble, alias: d_incp_rev_bud )
• b_ny_memo_bal ( type: esriFieldTypeDouble, alias: b_ny_memo_bal )
• b_ny_encumb_bal ( type: esriFieldTypeDouble, alias: b_ny_encumb_bal )
• b_ny_req_bal ( type: esriFieldTypeDouble, alias: b_ny_req_bal )
• d_ny_rev_bud ( type: esriFieldTypeDouble, alias: d_ny_rev_bud )
• d_budget_factor ( type: esriFieldTypeSingle, alias: d_budget_factor )
• d_carry_fwd_unusd ( type: esriFieldTypeDouble, alias: d_carry_fwd_unusd )
• d_filler ( type: esriFieldTypeString, alias: d_filler, length: 50 )
• a_warn_level ( type: esriFieldTypeDouble, alias: a_warn_level )
• d_req_buddet ( type: esriFieldTypeString, alias: d_req_buddet, length: 1 )
• d_actual_from_ly2 ( type: esriFieldTypeDouble, alias: d_actual_from_ly2 )
• d_spend_plan ( type: esriFieldTypeString, alias: d_spend_plan, length: 4 )
• a_object_desc ( type: esriFieldTypeString, alias: a_object_desc, length: 30 )
• a_object_desc_sh ( type: esriFieldTypeString, alias: a_object_desc_sh, length: 10 )
• a_charcode ( type: esriFieldTypeString, alias: a_charcode, length: 2 )
• ob_object_status ( type: esriFieldTypeString, alias: ob_object_status, length: 1 )
• ob_budqty_label ( type: esriFieldTypeString, alias: ob_budqty_label, length: 10 )
• ob_filler ( type: esriFieldTypeString, alias: ob_filler, length: 50 )
• ob_status_label ( type: esriFieldTypeString, alias: ob_status_label, length: 5 )
• ob_sub_object ( type: esriFieldTypeSmallInteger, alias: ob_sub_object )
• a_charcode_desc ( type: esriFieldTypeString, alias: a_charcode_desc, length: 20 )
• a_org_description ( type: esriFieldTypeString, alias: a_org_description, length: 30 )
• a_org_desc_sh ( type: esriFieldTypeString, alias: a_org_desc_sh, length: 10 )
• gp_deflt_year ( type: esriFieldTypeSmallInteger, alias: gp_deflt_year )
• gp_deflt_period ( type: esriFieldTypeSmallInteger, alias: gp_deflt_period )
• gp_curr_year ( type: esriFieldTypeSmallInteger, alias: gp_curr_year )
• gp_curr_period ( type: esriFieldTypeSmallInteger, alias: gp_curr_period )
• b_cy_encmb_frm_ly2 ( type: esriFieldTypeDouble, alias: b_cy_encmb_frm_ly2 )
• b_desc_ny ( type: esriFieldTypeString, alias: b_desc_ny, length: 30 )
• b_ctl_acct ( type: esriFieldTypeString, alias: b_ctl_acct, length: 4 )
• b_contra ( type: esriFieldTypeString, alias: b_contra, length: 1 )
• b_close_bal ( type: esriFieldTypeString, alias: b_close_bal, length: 1 )
• b_bud_req5_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req5_ny2 )
• b_bud_req4_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req4_ny2 )
• b_bud_req3_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req3_ny2 )
• b_bud_req2_ny2 ( type: esriFieldTypeDouble, alias: b_bud_req2_ny2 )
• b_full_account ( type: esriFieldTypeString, alias: b_full_account, length: 55 )
• d_bud_ny6 ( type: esriFieldTypeDouble, alias: d_bud_ny6 )
• d_bud_ny7 ( type: esriFieldTypeDouble, alias: d_bud_ny7 )
• d_bud_ny8 ( type: esriFieldTypeDouble, alias: d_bud_ny8 )
• d_bud_ny9 ( type: esriFieldTypeDouble, alias: d_bud_ny9 )
• d_bud_ny10 ( type: esriFieldTypeDouble, alias: d_bud_ny10 )
• my_orig_bud_fy ( type: esriFieldTypeDouble, alias: my_orig_bud_fy )
• my_bud_xfr_in_fy ( type: esriFieldTypeDouble, alias: my_bud_xfr_in_fy )
• my_bud_xfr_out_fy ( type: esriFieldTypeDouble, alias: my_bud_xfr_out_fy )
• my_rev_bud_fy ( type: esriFieldTypeDouble, alias: my_rev_bud_fy )
• my_orig_bud_ltd ( type: esriFieldTypeDouble, alias: my_orig_bud_ltd )
• my_bud_xfr_in_ltd ( type: esriFieldTypeDouble, alias: my_bud_xfr_in_ltd )
• my_bud_xfr_out_ltd ( type: esriFieldTypeDouble, alias: my_bud_xfr_out_ltd )
• my_rev_bud_ltd ( type: esriFieldTypeDouble, alias: my_rev_bud_ltd )
• glma_stat2_ny2 ( type: esriFieldTypeDouble, alias: glma_stat2_ny2 )
• glma_stat3_ny2 ( type: esriFieldTypeDouble, alias: glma_stat3_ny2 )
• glma_stat4_ny2 ( type: esriFieldTypeDouble, alias: glma_stat4_ny2 )
• glma_stat5_ny2 ( type: esriFieldTypeDouble, alias: glma_stat5_ny2 )
• glma_stat_ny6 ( type: esriFieldTypeDouble, alias: glma_stat_ny6 )
• glma_stat_ny7 ( type: esriFieldTypeDouble, alias: glma_stat_ny7 )
• glma_stat_ny8 ( type: esriFieldTypeDouble, alias: glma_stat_ny8 )
• glma_stat_ny9 ( type: esriFieldTypeDouble, alias: glma_stat_ny9 )
• glma_stat_ny10 ( type: esriFieldTypeDouble, alias: glma_stat_ny10 )
• glma_charcode ( type: esriFieldTypeString, alias: glma_charcode, length: 2 )
• glma_salary ( type: esriFieldTypeString, alias: glma_salary, length: 1 )
• glma_beg_eff_dt ( type: esriFieldTypeDate, alias: glma_beg_eff_dt, length: 8 )
• glma_end_eff_dt ( type: esriFieldTypeDate, alias: glma_end_eff_dt, length: 8 )
• glma_orig_bud_ny ( type: esriFieldTypeDouble, alias: glma_orig_bud_ny )
• glma_pa_required ( type: esriFieldTypeString, alias: glma_pa_required, length: 1 )
• glma_grant_id ( type: esriFieldTypeString, alias: glma_grant_id, length: 10 )
• d_rollup_budget ( type: esriFieldTypeString, alias: d_rollup_budget, length: 1 )
• s_segment1_desc ( type: esriFieldTypeString, alias: s_segment1_desc, length: 30 )
• s_segment2_desc ( type: esriFieldTypeString, alias: s_segment2_desc, length: 30 )
• s_segment3_desc ( type: esriFieldTypeString, alias: s_segment3_desc, length: 30 )
• s_segment4_desc ( type: esriFieldTypeString, alias: s_segment4_desc, length: 30 )
• s_segment5_desc ( type: esriFieldTypeString, alias: s_segment5_desc, length: 30 )
• s_segment6_desc ( type: esriFieldTypeString, alias: s_segment6_desc, length: 30 )
• s_segment7_desc ( type: esriFieldTypeString, alias: s_segment7_desc, length: 30 )
• s_segment8_desc ( type: esriFieldTypeString, alias: s_segment8_desc, length: 30 )
• d_ny_xfr_bud_in ( type: esriFieldTypeDouble, alias: d_ny_xfr_bud_in )
• d_ny_xfr_bud_out ( type: esriFieldTypeDouble, alias: d_ny_xfr_bud_out )
• d_grant_id ( type: esriFieldTypeInteger, alias: d_grant_id )
• a_account_id ( type: esriFieldTypeInteger, alias: a_account_id )
• account_notes ( type: esriFieldTypeString, alias: account_notes, length: 1073741823 )
• PositiveActualBal ( type: esriFieldTypeDouble, alias: PositiveActualBal )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata