View In:   ArcGIS Online Map Viewer

Parent Layer: WBS Updates

Name: WBSPOItems

Display Field: VENDOR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 191046.8831
YMin: 0
XMax: 2426000.6744
YMax: 8402327.4632
Spatial Reference: 32643  (32643)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [25, 150, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

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 )
• VERSION ( type: esriFieldTypeString, alias: VERSION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VERSION )
• WBS_CODE ( type: esriFieldTypeString, alias: WBS CODE , editable: true, nullable: true, length: 20, defaultValue: null, modelName: WBS_CODE )
• PO_NO ( type: esriFieldTypeString, alias: PO NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PO_NO )
• PURCHASE_ORDER_VALUE ( type: esriFieldTypeDouble, alias: PURCHASE ORDER VALUE, editable: true, nullable: true, defaultValue: null, modelName: PURCHASE_ORDER_VALUE )
• VENDOR_NAME ( type: esriFieldTypeString, alias: VENDOR NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: VENDOR_NAME )
• PO_ITEM_NO ( type: esriFieldTypeString, alias: PO ITEM NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PO_ITEM_NO )
• PO_STATUS ( type: esriFieldTypeString, alias: PO STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PO_STATUS )
• PO_DESCRIPTION ( type: esriFieldTypeString, alias: PO DESCRIPTION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PO_DESCRIPTION )
• PO_UPDATED_BY ( type: esriFieldTypeString, alias: PO UPDATED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PO_UPDATED_BY )
• PO_UPDATE_DATE ( type: esriFieldTypeDate, alias: PO UPDATE DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PO_UPDATE_DATE )
• VER_WBS ( type: esriFieldTypeString, alias: VER_WBS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VER_WBS )
• SANCTIONED_BY ( type: esriFieldTypeString, alias: SANCTIONED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SANCTIONED_BY )
• WBS_ZSANCTION_NO ( type: esriFieldTypeString, alias: WBS ZSANCTION NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WBS_ZSANCTION_NO )
• WBS_SCN_NO ( type: esriFieldTypeString, alias: WBS SCN NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WBS_SCN_NO )
• SANCTIONED_AMOUNT ( type: esriFieldTypeDouble, alias: SANCTIONED AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: SANCTIONED_AMOUNT )
• PROJECT_TYPE_OF_WORK ( type: esriFieldTypeString, alias: PROJECT TYPE OF WORK, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROJECT_TYPE_OF_WORK )
• SANCTION_AUTHORITY_CODE ( type: esriFieldTypeString, alias: SANCTION AUTHORITY CODE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SANCTION_AUTHORITY_CODE )
• SANCTIONED_APPROVAL_DATE ( type: esriFieldTypeDate, alias: SANCTIONED APPROVAL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SANCTIONED_APPROVAL_DATE )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DEPARTMENT )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROJECT_NAME )
• PROJECT_START_DATE ( type: esriFieldTypeDate, alias: PROJECT START DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROJECT_START_DATE )
• PROJECT_FINISH_DATE ( type: esriFieldTypeDate, alias: PROJECT FINISH DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROJECT_FINISH_DATE )
• SAP_OTP ( type: esriFieldTypeString, alias: SAP OTP, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SAP_OTP )
• DLP_DURATION ( type: esriFieldTypeSmallInteger, alias: DLP DURATION, editable: true, nullable: true, defaultValue: null, modelName: DLP_DURATION )
• DLP_WAIVER_PO_NO ( type: esriFieldTypeString, alias: DLP WAIVER PO NO, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DLP_WAIVER_PO_NO )
• DLP_WAIVER_NOTIFICATION ( type: esriFieldTypeString, alias: DLP WAIVER NOTIFICATION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DLP_WAIVER_NOTIFICATION )
• WBS_CREATED_BY ( type: esriFieldTypeString, alias: WBS CREATED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WBS_CREATED_BY )
• WBS_CREATED_DATE ( type: esriFieldTypeDate, alias: WBS CREATED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WBS_CREATED_DATE )
• FUND ( type: esriFieldTypeDouble, alias: FUND, editable: true, nullable: true, defaultValue: null, modelName: FUND )
• FUNCTIONAL_AREA ( type: esriFieldTypeString, alias: FUNCTIONAL AREA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FUNCTIONAL_AREA )
• FUND_CENTER ( type: esriFieldTypeString, alias: FUND CENTER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FUND_CENTER )
• GL_ACCOUNT ( type: esriFieldTypeString, alias: GL ACCOUNT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GL_ACCOUNT )
• PLANT_AND_S_LOC ( type: esriFieldTypeString, alias: PLANT & S.LOC., editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLANT_AND_S_LOC )
• BUSINESS_AREA ( type: esriFieldTypeString, alias: BUSINESS AREA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BUSINESS_AREA )
• FUNDING_BY ( type: esriFieldTypeString, alias: FUNDING BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FUNDING_BY )
• FUNDING_DATE ( type: esriFieldTypeDate, alias: FUNDING DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FUNDING_DATE )
• ESTIMATED_AMOUNT ( type: esriFieldTypeDouble, alias: ESTIMATED AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: ESTIMATED_AMOUNT )
• TENDER_RATE_FOR_REBATE ( type: esriFieldTypeDouble, alias: TENDER RATE FOR REBATE, editable: true, nullable: true, defaultValue: null, modelName: TENDER_RATE_FOR_REBATE )
• ESTIMATION_DEVIATION_TYPE ( type: esriFieldTypeString, alias: ESTIMATION DEVIATION TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESTIMATION_DEVIATION_TYPE )
• ESTIMATION_DEVIATION_AMOUNT ( type: esriFieldTypeDouble, alias: ESTIMATION DEVIATION AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: ESTIMATION_DEVIATION_AMOUNT )
• ESTIMATION_NOTIFICATION_NO ( type: esriFieldTypeString, alias: ESTIMATION NOTIFICATION NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ESTIMATION_NOTIFICATION_NO )
• ESTIMETION_BY ( type: esriFieldTypeString, alias: ESTIMETION BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ESTIMETION_BY )
• ESTIMATION_DATE ( type: esriFieldTypeDate, alias: ESTIMATION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESTIMATION_DATE )
• BUDGET_AMOUNT ( type: esriFieldTypeDouble, alias: BUDGET AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: BUDGET_AMOUNT )
• BUDGETING_BY ( type: esriFieldTypeString, alias: BUDGETING BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BUDGETING_BY )
• BUDGET_DATE ( type: esriFieldTypeDate, alias: BUDGET DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BUDGET_DATE )
• PO_NUMBER ( type: esriFieldTypeString, alias: PO NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PO_NUMBER )
• CURRENT_PO_ITEM_NO ( type: esriFieldTypeString, alias: CURRENT PO ITEM NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CURRENT_PO_ITEM_NO )
• CURRENT_PO_STATUS ( type: esriFieldTypeString, alias: CURRENT PO STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CURRENT_PO_STATUS )
• PO_RELEASED_BY ( type: esriFieldTypeString, alias: PO RELEASED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PO_RELEASED_BY )
• PO_DATE ( type: esriFieldTypeDate, alias: PO DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PO_DATE )
• LAST_PO_UPDATED_BY ( type: esriFieldTypeString, alias: LAST PO UPDATED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_PO_UPDATED_BY )
• LAST_PO_UPDATE_DATE ( type: esriFieldTypeDate, alias: LAST PO UPDATE DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_PO_UPDATE_DATE )
• LAST_BILL_SES_NO ( type: esriFieldTypeString, alias: LAST BILL SES NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LAST_BILL_SES_NO )
• TOTAL_BILLED_AMOUNT ( type: esriFieldTypeDouble, alias: TOTAL BILLED AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_BILLED_AMOUNT )
• LAST_BILL_SES_POSTING_DATE ( type: esriFieldTypeDate, alias: LAST BILL SES POSTING DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_BILL_SES_POSTING_DATE )
• LAST_BILL_SES_BY ( type: esriFieldTypeString, alias: LAST BILL SES BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_BILL_SES_BY )
• LAST_BILL_SES_DATE ( type: esriFieldTypeDate, alias: LAST BILL SES DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_BILL_SES_DATE )
• WORK_COMPLETE_DATE ( type: esriFieldTypeDate, alias: WORK COMPLETE DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WORK_COMPLETE_DATE )
• DLP_END_DATE ( type: esriFieldTypeDate, alias: DLP END DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DLP_END_DATE )
• LAST_INVOICE_MIRO_DATE ( type: esriFieldTypeString, alias: LAST INVOICE MIRO DATE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LAST_INVOICE_MIRO_DATE )
• LAST_INVOICED_AMOUNT ( type: esriFieldTypeDouble, alias: LAST INVOICED AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: LAST_INVOICED_AMOUNT )
• LAST_INVOICE_VERIFIED_BY ( type: esriFieldTypeString, alias: LAST INVOICE VERIFIED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_INVOICE_VERIFIED_BY )
• LAST_INVOICE_VERIFCATION_DATE ( type: esriFieldTypeDate, alias: LAST INVOICE VERIFCATION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INVOICE_VERIFCATION_DATE )
• LAST_DEVIATION_NOTIFICATION_NO ( type: esriFieldTypeString, alias: LAST DEVIATION NOTIFICATION NO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LAST_DEVIATION_NOTIFICATION_NO )
• LAST_DEVIATION_TYPE ( type: esriFieldTypeString, alias: LAST DEVIATION TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_DEVIATION_TYPE )
• LAST_DEVIATION_STATUS ( type: esriFieldTypeString, alias: LAST DEVIATION STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_DEVIATION_STATUS )
• LAST_DEVIATION_RELEASED_BY ( type: esriFieldTypeString, alias: LAST DEVIATION RELEASED BY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LAST_DEVIATION_RELEASED_BY )
• LAST_DEVIATION_DATE ( type: esriFieldTypeDate, alias: LAST DEVIATION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_DEVIATION_DATE )
• WBS_ASSET_TYPE ( type: esriFieldTypeString, alias: WBS ASSET TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WBS_ASSET_TYPE )
• WBS_WORK_TYPE ( type: esriFieldTypeString, alias: WBS WORK TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WBS_WORK_TYPE )
• WBS_WORK_SUBTYPE ( type: esriFieldTypeString, alias: WBS WORK SUBTYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WBS_WORK_SUBTYPE )
• CURRENT_WORK_PROGRESS_STATUS ( type: esriFieldTypeString, alias: CURRENT WORK PROGRESS STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CURRENT_WORK_PROGRESS_STATUS )
• LAST_WORK_PROGRESS_UPDATE_DATE ( type: esriFieldTypeDate, alias: LAST WORK PROGRESS UPDATE DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_WORK_PROGRESS_UPDATE_DATE )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: REMARKS )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• PROJECT_START_DELAY ( type: esriFieldTypeSmallInteger, alias: PROJECT_START_DELAY, editable: true, nullable: true, defaultValue: null, modelName: PROJECT_START_DELAY )
• PROJECT_FINISH_DELAY ( type: esriFieldTypeSmallInteger, alias: PROJECT_FINISH_DELAY, editable: true, nullable: true, defaultValue: null, modelName: PROJECT_FINISH_DELAY )
• REST_BILLED_AMOUNT ( type: esriFieldTypeDouble, alias: REST_BILLED_AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: REST_BILLED_AMOUNT )
• REST_INVOICED_AMOUNT ( type: esriFieldTypeDouble, alias: REST_INVOICED_AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: REST_INVOICED_AMOUNT )
• TOTAL_WORK_PROGRESS ( type: esriFieldTypeSingle, alias: TOTAL WORK PROGRESS, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_WORK_PROGRESS )

Templates:

• Name: WBSPOItems
  Description:
  Prototype:
  REST_INVOICED_AMOUNT: null
  TOTAL_WORK_PROGRESS: null
  VERSION: null
  WBS_CODE: null
  PO_NO: null
  PURCHASE_ORDER_VALUE: null
  VENDOR_NAME: null
  PO_ITEM_NO: null
  PO_STATUS: null
  PO_DESCRIPTION: null
  PO_UPDATED_BY: null
  PO_UPDATE_DATE: null
  VER_WBS: null
  SANCTIONED_BY: null
  WBS_ZSANCTION_NO: null
  WBS_SCN_NO: null
  SANCTIONED_AMOUNT: null
  PROJECT_TYPE_OF_WORK: null
  SANCTION_AUTHORITY_CODE: null
  SANCTIONED_APPROVAL_DATE: null
  DEPARTMENT: null
  PROJECT_NAME: null
  PROJECT_START_DATE: null
  PROJECT_FINISH_DATE: null
  SAP_OTP: null
  DLP_DURATION: null
  DLP_WAIVER_PO_NO: null
  DLP_WAIVER_NOTIFICATION: null
  WBS_CREATED_BY: null
  WBS_CREATED_DATE: null
  FUND: null
  FUNCTIONAL_AREA: null
  FUND_CENTER: null
  GL_ACCOUNT: null
  PLANT_AND_S_LOC: null
  BUSINESS_AREA: null
  FUNDING_BY: null
  FUNDING_DATE: null
  ESTIMATED_AMOUNT: null
  TENDER_RATE_FOR_REBATE: null
  ESTIMATION_DEVIATION_TYPE: null
  ESTIMATION_DEVIATION_AMOUNT: null
  ESTIMATION_NOTIFICATION_NO: null
  ESTIMETION_BY: null
  ESTIMATION_DATE: null
  BUDGET_AMOUNT: null
  BUDGETING_BY: null
  BUDGET_DATE: null
  PO_NUMBER: null
  CURRENT_PO_ITEM_NO: null
  CURRENT_PO_STATUS: null
  PO_RELEASED_BY: null
  PO_DATE: null
  LAST_PO_UPDATED_BY: null
  LAST_PO_UPDATE_DATE: null
  LAST_BILL_SES_NO: null
  TOTAL_BILLED_AMOUNT: null
  LAST_BILL_SES_POSTING_DATE: null
  LAST_BILL_SES_BY: null
  LAST_BILL_SES_DATE: null
  WORK_COMPLETE_DATE: null
  DLP_END_DATE: null
  LAST_INVOICE_MIRO_DATE: null
  LAST_INVOICED_AMOUNT: null
  LAST_INVOICE_VERIFIED_BY: null
  LAST_INVOICE_VERIFCATION_DATE: null
  LAST_DEVIATION_NOTIFICATION_NO: null
  LAST_DEVIATION_TYPE: null
  LAST_DEVIATION_STATUS: null
  LAST_DEVIATION_RELEASED_BY: null
  LAST_DEVIATION_DATE: null
  WBS_ASSET_TYPE: null
  WBS_WORK_TYPE: null
  WBS_WORK_SUBTYPE: null
  CURRENT_WORK_PROGRESS_STATUS: null
  LAST_WORK_PROGRESS_UPDATE_DATE: null
  REMARKS: null
  REST_BILLED_AMOUNT: null
  PROJECT_FINISH_DELAY: null
  PROJECT_START_DELAY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata