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 Requisitions with EcoSys Commitments is shown below.

Requisition Header

Smart Materials Column

EcoSys Column

Comment

m_reqs.r_code||'REQ'||m_reqs.r_id

COMMITMENTID

The Commitment Id is a combination of first 23 characters of r_code appended with static
keyword REQ along with R_ID at supplement 0.

m_req_nls.description

COMMITMENTNAME

It holds the first 119 characters of the requisition header description.

m_reqs.r_supp

SUPPLEMENT

Custom Column. This column holds the requisition supplement number.

m_reqs.creation_date

SUPPLEMENTDATE

Custom Column. This column holds the requisition supplement creation date.

'PR'

TYPEID

Source is not available in Smart Materials. This column holds the
static value 'PR'.
It is required to differentiate Smart Materials requisitions
or agreements
with EcoSys commitments.

m_origins.origin_code

ORIGIN

Custom Column. This column holds the origin code
of the Smart Materials requisition.

Requisition Line Items

Smart Materials Requisition Line Item Columns

EcoSys Commitment Line Item Columns

Comments

m_reqs.r_code||'REQ'||m_reqs.
r_id

COMMITMENTID

The Commitment Id is a combination of first
23 characters of r_code appended with static keyword REQ
along with r_id at supplement 0

m_jobs.field1

WBSPATHID

Holds EcoSys WbspathID

m_jobs.field2

COSTACCOUNTID

Holds EcoSys CostAccountID

m_req_line_items.rli_pos||'-'||m_req_line_items.rli_sub_pos

LINEID

Holds combination of Requisition Position and Subposition

ReqLi Ident Description

DESCRIPTION

Holds the first 119 characters of
Requisition Line Item Ident Description

m_reqs.r_supp

SUPPLEMENT

Custom Column. The column holds the
supplement number of Requisition

m_reqs.creation_date

SUPPLEMENTDATE

Custom Column.
The column holds the Requisition Supplement Creation Date

m_req_line_items.total_release_qty

QUANTITY

Holds the total release quantity present at the requisition Line Item

m_units.unit_code of REQLI Quantity

UOM

Holds the unit code of total release
quantity Unit code
present at the requisition Line Item

m_units.unit_code of REQLI currency

CURRENCY

Holds the Unit code of Requisition Budge
Currency Code

m_req_line_items.budget

COST

Holds the budget
present at the
Requisition Line Item

m_commodity_codes.commodity_code

COMMODITYCODE

Custom Column

m_req_line_items.tag_number

TAGNUMBER

Custom Column

m_req_line_items.estimated_ros_date

REQUIREDONSITE

Custom Column