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 |
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 |
m_origins.origin_code |
ORIGIN |
Custom Column. This column holds the origin code |
Requisition Line Items
Smart Materials Requisition Line Item Columns |
EcoSys Commitment Line Item Columns |
Comments |
---|---|---|
m_reqs.r_code||'REQ'||m_reqs. |
COMMITMENTID |
The Commitment Id is a combination of first |
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 |
m_reqs.r_supp |
SUPPLEMENT |
Custom Column. The column holds the |
m_reqs.creation_date |
SUPPLEMENTDATE |
Custom Column. |
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 |
m_units.unit_code of REQLI currency |
CURRENCY |
Holds the Unit code of Requisition Budge |
m_req_line_items.budget |
COST |
Holds the budget |
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 |