Product Hub Event Create / Update Item or Publish Item File | WACS REST Service: W1-StockItemSync | DVM Mapping | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Oracle Utilities Work and Asset Cloud Service Column | Oracle ERP Product Hub Cloud Column | |
Outermosttag | sync | Outermosttag | |||||||
components.schemas.SYNC_ request | sync | Group | |||||||
W1AdStkItmSy | components.schemas.SYNC_ request | Group | |||||||
input | W1AdStkItmSyt | Group | |||||||
externalSystem | input | String | ERPWACS_ConfigProps | PropertyName : wacs.externalsystem | Value : | Configuration Properties for WACS-ERP Integrations | |||
onEvent | Group | ||||||||
findItemResponse | onEvent | Group | |||||||
result | findItemResponse | Group | |||||||
ItemId | result | Long | externalReferenceId | input | String | ||||
initialLoad | input | String | |||||||
stockItemInfo | input | Group | Hardcoded as 'F1IC' | ||||||
ItemId | result | Long | resourceTypeExternalId | stockItemInfo | String | ||||
ItemStatusValue | result | String | boStatus | stockItemInfo | String | ERPWACS_StockItemStatus | ERP_StockItemStatus | WACS_StockItemStatus | Map Stock Item Status between ERP and WACS |
ItemDescription | result | String | description | stockItemInfo | String | ||||
LongDescription | result | String | longDescription | stockItemInfo | String | ||||
ItemNumber | result | String | stockItem | stockItemInfo | String | ||||
usageExpenseCode | stockItemInfo | String | ERPWACS_ConfigProps | PropertyName : wacs.usageexpensecode.default | Value : | Configuration Properties for WACS-ERP Integrations | |||
AssetCategoryValue | result | String | propertyUnit | stockItemInfo | String | ERPWACS_AssetCategory | ERP_AssetCategory | WACS_PropertyUnit | Map ERP Asset Category to WACS Property Unit |
ListPrice | result | Amounttype | unitPrice | stockItemInfo | Decimal | ||||
ItemClass | result | String | stockCategory | stockItemInfo | Stockcategory | ERPWACS_ItemClass | ERP_ItemClass | WACS_StockCategory | Map ERP Item Class field to WACS Stock Category field |
hazardous | stockItemInfo | Hazardous | When (string-length (normalize-space (/nssrcmpr:onEvent/nssrcmpr:findItemResponse/inp1:result/ns32:HazardClassValue ) ) > 0) Otherwise, hardcoded as 'W1NO' | ||||||
HazardClassValue | result | String | hazardousType | stockItemInfo | Hazardoustype | ERPWACS_HazardousType | ERP_HazardousCode | WACS_HazardousType | Map Hazardous Type between ERP and WACS The WACS values can be obtained from Lookup: HAZARD_TYPE_FLG |
LotControlValue | result | String | lotManaged | stockItemInfo | Stockiteminfo | ERPWACS_LotManagedFlag | ERP_LotControlFlag | WACS_LotManagedFlag | Map Lot Control Flag between ERP and WACS |
InventoryAssetFlag | result | Boolean | capitalSpare | stockItemInfo | Capitalspare | ERPWACS_InventoryAssetFlag | ERP_InventoryAssetFlag | WACS_CapitalSpareFlag | Map ERP Inventory Asset Flag to WACS Capital Spare |
AssetTrackedFlag | result | Boolean | trackable | stockItemInfo | Trackable | ERPWACS_AssetTrackedFlag | ERP_AssetTrackedFlag | WACS_TrackableFlag | Map Asset Tracked Flag between ERP and WACS |
repairable | stockItemInfo | Repairable | When (/nssrcmpr:onEvent/nssrcmpr:findItemResponse/inp1:result/ns32:UserItemTypeValue = "Asset Activity") Otherwise, hardcoded as 'W1NO' | ||||||
PrimaryUOMValue | result | String | unitOfPurchase | stockItemInfo | String | ERPWACS_UOMCode | ERP_UOMName | WACS_UOMCode | Map UOM Codes between ERP and WACS |
$Var_unitOfIssue | Field | unitOfIssue | stockItemInfo | String | ERPWACS_UOMCode | ERP_UOMName | WACS_UOMCode | Map UOM Codes between ERP and WACS | |
ItemCategory | result | Itemcategory | purchaseToIssueRatio | stockItemInfo | Stockiteminfo | Only if ($Var_piRatio != "") Function : number ($Var_piRatio ) | |||
CategoryName | String | purchaseCommodity | stockItemInfo | String | ERPWACS_PurchaseCommodity | ERP_PurchaseCategoryName | WACS_PurchaseCommodity | Only if (ns32:ItemCatalog = $Var_ERP_PurchaseItemCategory) | |
AllowSubstituteReceiptsFlag | result | Boolean | doNotSubstitute | stockItemInfo | Donotsubstitute | ERPWACS_AllowSubstituteReceiptsFlag | ERP_AllowSubstituteReceiptsFlag | WACS_DoNotSubstituteFlag | Map Allow Substitute Receipt Flags between ERP and WACS |
defaultValueToActivity | stockItemInfo | Defaultvaluetoactivity | Hardcoded as 'W1YS' | ||||||
ItemSupplierAssociation | result | Itemsupplierassociation | vendors | stockItemInfo | Vendors | ||||
vendorsList | vendors | Group | |||||||
SupplierSiteId | Long | vendorLocationExternalId | vendorsList | String | |||||
SupplierItemNumber | String | vendorPartNumber | vendorsList | String | |||||
PrimaryFlag | Boolean | vendorPriority | vendorsList | Vendorpriority | ERPWACS_VendorPriority | ERP_SupplierPrimaryFlag | WACS_VendorPriority | Map Vendor priorities between ERP and WACS |
Product Hub Event Create / Update Item or Publish Item File | WACS REST Service: W1-StockItemSync | DVM Mapping | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM | Oracle Utilities Work and Asset Cloud Service Column | Oracle ERP Product Hub Cloud Column | |
onEvent | Outermosttag | create | Outermosttag | ||||||
findItemResponse | onEvent | Group | UnitOfMeasure Conversions | create | Group | ||||
result | findItemResponse | Group | |||||||
PrimaryUOMValue | result | String | FromUOM | UnitOfMeasureConversions | String | ERPWACS_UOM Code | ERP_ UOMName | ERP_ UOMCode | Map UOM Codes between ERP and WACS |
UnitOfIssueValue | result | String | ToUOM | UnitOfMeasureConversions | String | ERPWACS_UOM Code | ERP_ UOMName | ERP_ UOMCode | Map UOM Codes between ERP and WACS |
ItemId | result | Long | ItemId | UnitOfMeasureConversions | String |