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 |