Item Sync |
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
ULTRIVA | Oracle PL/SQL Dataset | Notes |
|---|---|---|
ItemNo | Item | NA |
ItemDesc | NA | NA |
PlantCode | organization_code | NA |
PlantUserCode | buyer_sso | NA |
UsagePerDay | NA | NA |
SafetyTime | NA | NA |
QtyOnCard | NA | NA |
SupplierCode | vendor_number | if sourcing_rule_type <> Transfer then use both <vendor_number+vendor_site> |
LeadTime | NA | Calculated using Intrasit_Time - LeadTime set in Ultriva |
TransitTime | Intransit_time | This includes both lead time and transit time of the supplier. |
HandlingTime | NA | Post Processing Lead Time |
PricePerUOM | NA | Average cost |
BeginOnHandQty | NA | NA |
CurrentOrderQty | NA | NA |
ReorderPoint | NA | NA |
Item_Category | NA | NA |
UOM | uom | NA |
SupplierItemNo | NA | NA |
SupplierItemDesc | NA | NA |
ProductLine | NA | NA |
CommodityCode | Inventory Category | NA |
MinOrderCards | NA | NA |
SupplierPoNum | document_number or source_document | NA |
SupplierPoLineNum | doc_line_number | NA |
SupplierPoReleaseNum | NA | NA |
LocationCode | NA | NA |
Integration_HasPOReceipt | NA | NA |
Integration_HasPORelease | NA | NA |
IsVMI | NA | NA |
IsVirtualKanban | NA | Default Y |
InspectionRequired | NA | NA |
HasInventoryMovement | NA | NA |
HasIntermediateLoc | NA | NA |
NA | vendor_name | NA |
NA | vendor_site | NA |
NA | sourcing_rule_type | NA |
NA | source_org_code | NA |
EBJ_RTPARAMS.SUP_ALLOCATION | allocation | NA |
EBJ_RTPARAMS.SUP_RANK | rank | NA |
EBJ_RTPARAMS.CarrierCode | ship_method | NA |
REVISIONNO | item_revision | NA |
NA | buyer_name | NA |
EBJ_RTPARAMS.PO_TYPE | SOURCE_TYPE_MEANING | IR_ISO,BLANKET,QUOTATION |