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 |
- |
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.