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 |
m_po_header_nls.description |
COMMITMENTNAME |
It holds the first 119 characters |
m_po_headers.po_supp |
SUPPLEMENT |
Custom Column. |
m_po_headers.creation_date |
SUPPLEMENTDATE |
Custom Column. |
‘PO’ |
TYPEID |
Source not available in Smart Materials. |
m_suppliers.sup_code |
SUPPLIERNAME |
Custom Column. |
CIP |
PROGRESS |
Custom Column. |
m_po_headers.payment_type |
PAYMENTTERMS |
Custom Column. |
m_po_headers.buyer |
BUYER |
Custom Column. |
CIP |
CREATEDBY |
Custom Column. |
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 |
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 |
description of agreement line item (POLI) |
DESCRIPTION |
It holds the first 119 characters |
m_po_headers.po_supp |
SUPPLEMENT |
Custom Column. |
m_po_headers.creation_date |
SUPPLEMENTDATE |
Custom Column. |
m_po_line_items.poli_qty |
QUANTITY |
Holds the total quantity present at the |
unit_code of agreement line item (POLI) quantity |
UOM |
Holds the unit code of total release quantity |
unit_code of agreement line item (POLI) currency |
CURRENCY |
Holds the Unit code |
Discounted Price of agreement line item (POLI) |
COST |
Holds the budget |
m_commodity_codes.commodity_code |
COMMODITYCODE |
Custom Column. |
m_po_line_items.tag_number |
TAGNUMBER |
Custom Column. |
prom contract of POLI |
PROMISEDDATE |
Custom Column. |
m_po_headers.creation_date |
DATE |
The column holds the |
Not defined in Smart Materials |
INSERTREASON |
Custom Column; |
N/A |
OTHERCOST |
Custom Column |
Not defined in Smart Materials |
INTERNALID |
Stores InternallId of |