The default column mapping of Smart Materials Invoices with EcoSys Actuals is shown below.
|
Smart Materials Invoice Column |
EcoSys Actual Column |
Comment |
|---|---|---|
|
m_invoices.ivc_number |
INVOICENUMBER |
Holds the invoice number |
|
m_invoices.invoice_paid_date |
INVOICEPAIDDATE |
Holds the invoice paid date |
|
m_invoices.invoice_paid_date |
DATE |
Holds the invoice paid date |
|
m_po_headers.po_number||'AGR'||mpo_headers.base_poh_id |
COMMITMENTID |
The Commitment Id is a combination of first 23 |
|
m_po_line_items.pos||'-'||m_po_line_items.sub_pos |
LINEID |
Holds combination of Agreement Position and Subposition |
|
m_jobs.field1 |
WBSPATHID |
Holds EcoSys WbspathID |
|
m_jobs.field2 |
COSTACCOUNTID |
Holds EcoSys CostAccountID |
|
m_invoices.invoice_amount |
COST |
|
|
Agreement Line Item (Poli) Ident Description |
DESCRIPTION |
Holds the first 119 characters of Agreement Line Item Ident Description |
|
m_invoices.invoice_qty |
QUANTITY |
Holds the invoice quantity. |
|
unit_code of invoice qty |
UOM |
Holds the unit code of invoice quantity. |
|
unit_code of invoice currency |
CURRENCY |
Holds the unit code of invoice currency. |
|
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 |
|
m_suppliers.sup_code |
SUPPLIER |
Custom Column. Holds supplier code of Invoice |