Default Column Mapping - Intergraph Smart Materials - 2017 R1 (2.1) - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration 2017 R1 (2.1)

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

The default column mapping of Smart Materials Agreements with EcoSys Commitments is shown below.

Agreement Header

Smart Materials Agreement Header Column

EcoSys Commitment Header Column

Comment

m_po_headers.po_number||'AGR'||m_po_headers.base_poh_id 

 

COMMITMENTID 

The Commitment Id is a combination
of first 23
characters of po_number appended with static keyword
AGR along with BASE_POH_ID 

m_po_header_nls.description 

COMMITMENTNAME 

It holds the first 119 characters
of Agreement Header Description 

m_po_headers.po_supp 

SUPPLEMENT 

Custom Column.
The column holds the agreement supplement number. 

m_po_headers.creation_date 

SUPPLEMENTDATE 

Custom Column.
The column holds the agreement 
supplement creation date. 

‘PO’

TYPEID 

Source not available in Smart Materials.
The column holds the static value PO.
It is required to differentiate Smart Materials requisitions
and agreements with EcoSys commitments.

m_suppliers.sup_code 

SUPPLIERNAME 

Custom Column.
Holds the supplier names of the agreement. 

CIP 

PROGRESS 

Custom Column. 
Source is a CIP with poh_id as input.
Default value is NULL.

m_po_headers.payment_type 

PAYMENTTERMS 

Custom Column. 
Holds the payment type of 
the agreement header. 

m_po_headers.buyer 

BUYER 

Custom Column. 
Holds the buyer present 
at agreement header. 

CIP 

CREATEDBY 

Custom Column. 
Source is a CIP with poh_id 
as input.
Default value is NULL. 

Agreement Line Items

Smart Materials Agreement Line Item Column

EcoSys Commitment Line Item Column

Comments

m_po_headers.po_number||'AGR'||m_po_headers.base_poh_id  

 

COMMITMENTID 

The Commitment Id is a combination of first 23
characters of po_number appended
with static keyword 'AGR'
along with BASE_POH_ID 

m_jobs.field1 

WBSPATHID 

Holds EcoSys WbspathID  

m_jobs.field2 

COSTACCOUNTID 

Holds EcoSys CostAccountID 

m_po_line_items.poli_pos|| '-' || m_po_line_items.poli_sub_pos 

LINEID 

Holds combination
 of Agreement Position
and Subposition 

description of agreement line item (POLI) 

DESCRIPTION 

It holds the first 119 characters
of Agreement Line Item
Ident Description 

m_po_headers.po_supp 

SUPPLEMENT 

Custom Column.
The column holds the
supplement number of Agreement 

m_po_headers.creation_date 

SUPPLEMENTDATE 

Custom Column. 
The column holds the Agreement Supplement
Creation Date 

m_po_line_items.poli_qty 

QUANTITY 

Holds the total quantity present at the
 AHolds the unit code of total release quantity
Unit code present at the Agreement Line
Item greement Line Item 

unit_code of agreement line item (POLI) quantity 

UOM 

Holds the unit code of total release quantity
Unit code present at teh Agreement Line Item.

unit_code of agreement line item (POLI) currency 

CURRENCY 

Holds the Unit code 
of Agreement Line
Item Currency Code 

Discounted Price of agreement line item (POLI) 

COST 

Holds the budget
present at the 
Agreement Line Item  

m_commodity_codes.commodity_code 

COMMODITYCODE 

Custom Column. 
Holds Commodity code
of Agreement Line Item 

m_po_line_items.tag_number 

TAGNUMBER 

Custom Column.
 Holds tag number of
Agreement Line Item 

prom contract of POLI 

PROMISEDDATE 

Custom Column. 
Holds promised contract date of 
Agreement Line Item 

m_po_headers.creation_date 

DATE 

The column holds the
agreement supplement
creation date 

Not defined in Smart Materials 

INSERTREASON 

Custom Column;
Values: 'O', 'RA';
To identify reverse approved records 

N/A 

OTHERCOST 

Custom Column  

Not defined in Smart Materials

INTERNALID 

 Stores InternallId of
EcoSys record when an Agreement Line Item
is posted.