Settings in Smart Materials - Intergraph Smart Materials - 2.3 - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration (2.3)

Language
English
Product
Intergraph Smart Materials
Subproduct
EcoSys Integration
Search by Category
Administration & Configuration
Version Smart Materials Web API
2.3

You must specify the following DBA settings and project defaults to enable the Smart Materials EcoSys integration.

The following general DBA settings are applicable for the entire integration.

DBA Settings

DBA Setting

Description

Default Value

ECO_PRODUCT_GROUP

Defines the Product Group, whose projects data you want to integrate with EcoSys.

-

ECO_UNIT_GROUP

Defines a unit group so that all the units present in the EcoSys gets integrated with Smart Materials.

For example, currency is a unit present in EcoSys, to have same
in Smart Materials, create a unit group and add units to it.

-

The following DBA settings and project defaults are applicable for the account code integration.

DBA Settings

DBA Setting

Description

Default Value

ECO_ACC_ATTR_SET

It defines an attribute set which must be defined at Product Group level in
Smart Materials. Attributes in the attribute set appear in Smart Materials Screen
J.10.02 Maintain Account Codes.

-

ECO_ACC_FREQ

It defines the frequency (in hours) in which a scheduler runs and integrates
all the Account Codes of EcoSys
into Smart Materials.

SHARED Tip To start the job, run “BEGIN m_pck_ecosys.import_ecosys_acc_codes; END;”.

24

ECO_ACC_UK

It defines an attribute set that must be defined at Product Group level in Smart Materials.
Attributes present in this set are mandatory and are used to
identify unique key columns of EcoSys
like WBSPath ID, CostAccount ID, and so on.

In a set,
first attribute should be WBSPath ID followed by CostAccount ID
and later other attributes.

This sequence helps in smooth integration of other modules at later stage.

-

Project Defaults

Project Default

Description

Default Value

ZI_E_ACAPI

Determines the EcoSys Account Codes resource name
that transfers Account Codes from EcoSys to Smart Materials.
If necessary parameters are present in API, then append them with
the Account Code resource name.

Sample format:

{EcoSys API name}/?{EcoSys parameter}={ZI_E_PROJ}

Example: ApprovedBudgetDetails/?Project={ZI_E_PROJ}

-

ZI_E_ACSER

Manages EcoSys Account Codes integration with Smart Materials.
If value is set to Y, Account Codes transfer from EcoSys to Smart Materials,
and if value is N, then no data is transferred.

Only logged in project data gets transferred from Smart Materials
to EcoSys Project ID that is assigned to ZI_E_PROJ default.

N

ZI_E_ACSTR

Determines the Smart Materials Account Code Structure name,
that consists of all the account codes that are transferred from EcoSys
to Smart Materials and appear on screen J.10.02 Account Code Structure.

You can assign an existing Account Code Structure name or define a new one.
If a new name is defined, then application automatically creates the same
account code structure name in screens J.10.01/J.10.02.

-

In the EcoSys spreadsheet you can find the parameters required for an API as shown in the picture below.

EcoSys01