Views - Intergraph Smart Materials - 2017 R2 (2.2) - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration 2017 R2 (2.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
EcoSys Integration
Search by Category
Administration & Configuration
Version Smart Materials Web API
2017 R2 (2.2)

Two views are available with columns specified in the spread sheets. You can add or remove any attributes in the views after adding or deleting the corresponding column in the exposed spread sheet of EcoSys. The views created have some additional columns which are used for internal purpose by Smart Materials to transfer Agreements to EcoSys.

  • MVW_ECO_PO_HEADERS: Retrieves the agreement headers whose line items are mapped with EcoSys account codes. You can add or remove columns from this view based on the spreadsheet configuration in EcoSys. The columns POH_ID, PROJECT, COMMITMENTID, SUPPLEMENT and TYPEID must not be removed as these columns are used for processing the data from Smart Materials to EcoSys. The values for PROGRESS and CREATEDBY columns are provided as CIP.

  • MVW_ECO_PO_LINE_ITEMS: Retrieves the agreement line items. You can add or remove the columns from this view based on the spreadsheet configuration in EcoSys. The columns JS_CODE, POH_ID, POLI_ID, APPROVEDDATE, PROJECT, COMMITMENTID, LINEID, SUPPLEMENT, QUANTITY, COST and OTHERCOST, KEYID, LINEID, OTHERCOST, ACTUALQUANTITY, ACTUALCOST, RECTYPE must not be removed as these columns are also used for processing the data from Smart Materials to EcoSys. The values for COST column is provided as CIP.