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 | |
$CurrItemRecord | Outermosttag | create | Outermosttag | ||||||
Item | $CurrItemRecord | Group | UnitOfMeasureConversions | create | Group | ||||
PrimaryUOMValue | Item | Field | FromUOM | UnitOfMeasureConversions | String | ERPWACS_UOMCode | ERP_UOMName | ERP_UOMCode | Map UOM Codes between ERP and WACS |
UnitOfIssueValue | Item | Field | ToUOM | UnitOfMeasureConversions | String | ERPWACS_UOMCode | ERP_UOMName | ERP_UOMCode | Map UOM Codes between ERP and WACS |
$CurrItemRecord | Group | ||||||||
Item | $CurrItemRecord | Group | |||||||
ItemId | Item | Field | ItemID | UnitOfMeasureConversions | String |
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 | OutboundSOAPRequestDocument | Outermosttag | ||||||
PublicationJobCompletedInfo | onEvent | Group | Body | OutboundSOAPRequestDocument | Group | ||||
DocumentId | PublicationJobCompletedInfo | Group | GenericRequest | Body | Group | ||||
newValue | DocumentId | Group | Service | GenericRequest | Group | ||||
Document | Service | Group | |||||||
@value | newValue | Field | Field | Document | Field |
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 | |||
$CurrItemRecord | Group | ||||||||
Item | $CurrItemRecord | Group | |||||||
ItemId | Item | Field | externalReferenceId | input | String | ||||
initialLoad | input | String | Hardcoded as 'F1IL' | ||||||
stockItemInfo | input | Group | |||||||
ItemId | Item | Field | resourceTypeExternalId | stockItemInfo | String | ||||
$CurrItemRecord | Group | ||||||||
Item | $CurrItemRecord | Group | |||||||
ItemStatusValue | Item | Field | boStatus | stockItemInfo | String | ERPWACS_StockItemStatus | ERP_StockItemStatus | WACS_StockItemStatus | Map Stock Item Status between ERP and WACS |
Item | Field | description | stockItemInfo | String | |||||
Item | Field | longDescription | stockItemInfo | String | |||||
Item | Field | stockItem | stockItemInfo | String | |||||
usageExpenseCode | stockItemInfo | String | ERPWACS_ConfigProps | PropertyName : wacs.usageexpensecode.default | Value : | Configuration Properties for WACS-ERP Integrations | |||
AssetCategoryValue | Item | Field | propertyUnit | stockItemInfo | String | ERPWACS_ItemClass | ERP_ItemClass | WACS_StockCategory | Map ERP Asset Category to WACS Property Unit |
ListPrice | Item | Field | unitPrice | stockItemInfo | Decimal | ||||
ItemClass | Item | Field | stockCategory | stockItemInfo | Stockcategory | Map the ERP Item Class field to the WACS Stock Category field | |||
hazardous | stockItemInfo | Hazardous | When (string-length (normalize-space ($CurrItemRecord/nsmpr1:Item/nsmpr1:HazardClassValue ) ) > 0) Otherwise, hardcoded as 'W1NO' | ||||||
HazardClassValue | Item | Field | 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 | Item | Field | lotManaged | stockItemInfo | Stockiteminfo | ERPWACS_LotManagedFlag | ERP_LotControlFlag | WACS_LotManagedFlag | Map Lot Control Flag between ERP and WACS |
InventoryAssetFlag | Item | Field | capitalSpare | stockItemInfo | Capitalspare | ERPWACS_InventoryAssetFlag | ERP_InventoryAssetFlag | WACS_CapitalSpareFlag | Map ERP Inventory Asset Flag to WACS Capital Spare |
AssetTrackedFlag | Item | Field | trackable | stockItemInfo | Trackable | ERPWACS_AssetTrackedFlag | ERP_AssetTrackedFlag | WACS_TrackableFlag | Map Asset Tracked Flag between ERP and WACS |
repairable | stockItemInfo | Repairable | When ($CurrItemRecord/nsmpr1:Item/nsmpr1:UserItemTypeValue = $Var_ERP_AssetActivityUserItemType) Otherwise, hardcoded as 'W1NO' | ||||||
PrimaryUOMValue | Item | Field | 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 | Item | Field | purchaseToIssueRatio | stockItemInfo | Stockiteminfo | Only if ($Var_piRatio != "") Function : number ($Var_piRatio ) | |||
CategoryName | Field | purchaseCommodity | stockItemInfo | String | ERPWACS_PurchaseCommodity | ERP_PurchaseCategoryName | WACS_PurchaseCommodity | Only if (ns6:ItemCatalog = $Var_ERP_PurchaseItemCategory) | |
AllowSubstituteReceiptsFlag | Item | Field | doNotSubstitute | stockItemInfo | Donotsubstitute | ERPWACS_AllowSubstituteReceiptsFlag | ERP_AllowSubstituteReceiptsFlag | WACS_DoNotSubstituteFlag | Map Allow Substitute Receipt Flag between ERP and WACS |
defaultValueToActivity | stockItemInfo | Defaultvaluetoactivity | Hardcoded as 'W1YS' | ||||||
ItemSupplierAssociation | Item | Field | vendors | stockItemInfo | Vendors | ||||
vendorsList | vendors | Group | |||||||
SupplierSiteId | Field | vendorLocationExternalId | vendorsList | String | |||||
SupplierItemNumber | Field | vendorPartNumber | vendorsList | String | |||||
PrimaryFlag | Field | vendorPriority | vendorsList | Vendorpriority | ERPWACS_VendorPriority | ERP_SupplierPrimaryFlag | WACS_VendorPriority | Map Vendor Priority between ERP and WACS |