This section discusses the flow of data from Smart Materials to Jovix and Jovix to Smart Materials. The following information flow happens:
-
PO header (Smart Materials to Jovix)
-
PO line items (Smart Materials to Jovix)
-
Item shipments (both Smart Materials to Jovix and Jovix to Smart Materials)
-
Transfer of PO ownership (both Smart Materials to Jovix and Jovix to Smart Materials)
Only Purchase orders of projects that have the project default ZI_JX_PROJ defined
are integrated with the Jovix project.
Data Mapping
The following table lists the data integration between Smart Materials and Jovix.
|
Smart Materials |
Jovix |
Description |
|
1. PO Header |
||
|
POH_ID |
pohId |
Smart Materials PO header ID |
|
PO_NUMBER |
name |
PO name in Jovix. |
|
APPROVED_DATE |
approvedDate |
|
|
Expediter |
expediter |
|
|
PO_SUPP |
poRevision |
|
|
2. PO line items |
||
|
POH_ID |
pohId |
|
|
PO_NUMBER |
poNumber |
|
|
POLI_ID |
poliId |
|
|
POLI_POS |
purchaseOrderLineNumber |
|
|
POLI_SUB_POS |
purchaseOrderSubLineNumber |
|
|
POLI_QTY |
quantityOrdered |
|
|
POLI_UNIT_WEIGHT |
poliunitweight |
PO Line Item Weight |
|
WEIGHT_UNIT_ID |
weightunitid |
PO Line Item Weight Unit |
|
3. Item shipments |
||
|
POLI_ID |
poliId |
Smart Materials PO header ID. |
|
ITEM_SHIP_ID |
itemShipId |
Smart Materials item shipment ID. |
|
ITEM_SHIP_POS |
shipmentItemSubLineNumber |
|
|
ITEM_SHIP_SUB_POS |
shipmentItemSubSubLineNumber |
|
|
ITEM_SHIP_QTY |
quantity |
|
|
ITEM_SHIP_WEIGHT |
itemshipweight |
|
|
WEIGHT_UNIT_ID |
weightunitid |
itemshipment weight unit |
|
DD_CODE |
deliveryDesignation |
Specifies the delivery designation of PO line item. |
|
APPROVED_DATE |
srnApprovedDate |
|
|
PRED_ON_SITE_DATE |
targetDeliveryDate |
|
|
REQ_SITE_DATE |
requiredOnSiteDate |
|
|
IDENT_CODE [TAG_NUMBER] |
splitItemCode |
Identcode and tagnumber of child tags are sent to Jovix during split tag in Smart Materials Expediting. |
|
TAG_DESCRIPTION |
splitItemCodeDescription |
Child tag description. |