The default column mapping of EcoSys Account Codes with Smart Materials is as following:
EcoSys Column |
Smart Materials Column |
Comment |
---|---|---|
WBSPATHID |
m_jobs.field1 |
Stores WBSPATHID retrieved from EcoSys |
COSTACCOUNTID |
m_jobs.field2 |
Stores COSTACCOUNTID retrieved from EcoSys |
UOM |
m_jobs.field3 |
Stores unit of measure retrieved from EcoSys |
COST in Project Currency |
m_jobs.original_budget |
Stores the initial cost retrieved from EcoSys |
COST in Project Currency |
m_jobs.budget |
Stores the revised cost retrieved from EcoSys |
Project Currency |
m_jobs.currency_id |
Stores the project currency retrieved from EcoSys |
Description |
m_job_nls.short_desc |
Stores the CostObject Description retrieved from EcoSys |
Description |
m_job_nls.description |
Stores the CostObject Description retrieved from EcoSys |