You must specify the following DBA settings and project defaults to enable the Smart Materials EcoSys integration.
The following general DBA settings and project defaults 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 |
- |
Project Defaults
Project Default |
Description |
Default Value |
---|---|---|
ZI_E_PROJ |
Determines the EcoSys Project ID that must be mapped with Smart Materials, |
- |
ZI_E_PW |
Determines the Password to login EcoSys application. |
- |
ZI_E_SURL |
Determines the application server URL to connect EcoSys service. Sample format: http://{host}/ecosys/api/restxml/ |
- |
ZI_E_UN |
Determines the Username to login EcoSys application. |
- |
The Smart Materials projects which are in open status are only considered for integration. The project status can be verified from the A.20.01.02 Project Information screen in Smart Materials classic.
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 |
- |
ECO_ACC_FREQ |
It defines the frequency (in hours) in which a scheduler runs and integrates 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.
In a set, |
- |
Project Defaults
Project Default |
Description |
Default Value |
---|---|---|
ZI_E_ACAPI |
Determines the EcoSys Account Codes 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. Only logged in project data gets transferred from Smart Materials |
N |
ZI_E_ACSTR |
Determines the Smart Materials Account Code Structure name, You can assign an existing Account Code Structure name or define a new one. |
- |
In the EcoSys spreadsheet you can find the parameters required for an API as shown in the picture below.