Oracle Utilities Work and Asset Cloud Service | Oracle Fusion Procurement Cloud | DVM Mapping | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|
Element Name | Parent Element | Type | Element Name | Parent Element | Type | DVM Name | Oracle Utilities Work and Asset Cloud Service | Oracle Fusion Procurement Cloud | |
Outermosttag | syncPurchaseOrder | Outermosttag | |||||||
components.schemas.SYNCPURCHASEORDER_ request | syncPurchaseOrder | Group | |||||||
W1PurOrdSync | components.schemas.SYNCPURCHASEORDER_ request | Group | |||||||
input | W1PurOrdSync | Group | |||||||
externalSystem | input | String | OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: wacs.externalsystem | Value: | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
onEvent | Group | ||||||||
getPurchaseOrder Response | onEvent | Group | |||||||
result | getPurchase OrderResponse | Group | |||||||
Value | result | Group | |||||||
POHeaderId | Value | Long | externalReference Id | input | String | ||||
purchaseOrder | input | Group | |||||||
header | purchaseOrder | Group | |||||||
POHeaderId | Value | Long | purchaseOrderHeaderExternalId | header | String | ||||
DocumentStatusCode | Value | String | status | header | String | OUTL-BRT-WACS_FPRC_POStatus | FPRC_POStatusCode | WACS_POStatusCode | Maps PO Status Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
OrderNumber | Value | String | purchaseOrderNumber | header | String | ||||
OrderRevision | Value | Decimal | revisionNumber | header | Decimal | ||||
DocumentDescription | Value | String | description | header | String | ||||
CreationDate | Value | Datetime-times tamp | creationDateTime | header | Datetime | ||||
BuyerId | Value | Field | buyerEmployeeExternalId | header | String | ||||
issueDate | header | Date | Function: fn:current-date () | ||||||
PurchaseOrderLine | Value | Group | |||||||
PurchaseOrderSchedule | PurchaseOrder Line | Group | |||||||
PurchaseOrder Distribution | PurchaseOrderSchedule | Group | |||||||
DeliverToLocationCode | PurchaseOrder Distribution | String | shipToLocation | header | String | OUTL-BRT-WACS_FPRC_DeliverToLocation | FPRC_DeliverToLocationCode | WACS_ShipToLocation | Maps ERP Procurement Cloud Deliver To Location Code to WACS Ship To Location or vise versa. In WACS, Ship To Location is a storeroom. |
SupplierSiteId | Value | Long | vendorLocationExternalId | header | String | ||||
CurrencyCode | Value | String | currency | header | String | OUTL-BRT-WACS_FPRC_CurrencyCode | FPRC_CurrencyCode | WACS_CurrencyCode | Maps Currency code between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service (WACS) |
ConversionRate | Value | Field | exchangeRate | header | Decimal | Only if (/nssrcmpr:onEvent/inp1:getPurchaseOrderResponse/inp1:result/ns31:Value/ns31:ConversionRate != "") Function : number (fn:format-number (number (/nssrcmpr:onEvent/inp1:getPurchaseOrderResponse/inp1:result/ns31:Value/ns31:ConversionRate ), "#.#######" ) ) | |||
FOBCode | Value | String | freeOnBoard | header | String | OUTL-BRT-WACS_FPRC_FOB | FPRC_FOB | WACS_FOB | Only if (/nssrcmpr:onEvent/inp1:get PurchaseOrderResponse/inp1:result/ns31:Value/ns31:FOBCode) |
PaymentTermsId | Value | Long | paymentTerms | header | String | OUTL-BRT-WACS_FPRC_PaymentTerm | FPRC_PaymentTerm | WACS_PaymentTerm | Only if (/nssrcmpr:onEvent/inp1:getPurchaseOrderResponse/inp1:result/ns31:Value/ns31:PaymentTermsId) |
PurchaseOrderLine | Value | Purchaseorderline | lines | purchaseOrder | Lines | ||||
_data | lines | Group | |||||||
POLineId | Long | purchaseOrderLineExternalId | _data | String | |||||
LineStatusCode | String | status | _data | String | OUTL-BRT-WACS_FPRC_POLineStatus | FPRC_POLineStatus | WACS_POLineStatus | Maps PO Line Status Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS). | |
ItemDescription | String | description | _data | String | |||||
LineNumber | Decimal | lineNumber | _data | Decimal | |||||
xmlns.oracle.com | Group | ||||||||
apps | xmlns.oracle.com | Group | |||||||
prc | apps | Group | |||||||
po | prc | Group | |||||||
viewDocument | po | Group | |||||||
publicFlex | viewDocument | Group | |||||||
purchasingDocument Line | publicFlex | Group | |||||||
', 'Wacs | 'purchasingDocumentLine | Field | purchaseRequisitionLineId | _data | String | Function: ns31:LineFlexfield[(fn:resolve-QName(@xsi:type, .) = fn:QName('http://xmlns.oracle.com/apps/prc/po/viewDocument/publicFlex/purchasingDocumentLine/', 'Wacs'))]/ns30:wacsPrLineIdC | |||
SourceAgreement Number | String | blanketContractNumber | _data | String | |||||
SourceAgreementLine | Decimal | blanketContractLineNumber | _data | Decimal | |||||
LineType | String | itemType | _data | Itemtype | OUTL-BRT-WACS_FPRC_ItemTypeCode | FPRC_LineTypeCode | WACS_Item TypeCode | Maps ERP Line Type Code to WACS Item Type Code and vice versa | |
Quantity | Measuretype | quantity | _data | Decimal | Only if (ns31:Quantity != 0) | ||||
Price | Field | unitPrice | _data | Decimal | Function : number (fn:format-number (number (ns31:Price ), "#.#######" ) ) | ||||
UnitOfMeasure | String | unitOfPurchase | _data | String | OUTL-BRT-WACS_FPRC_UOM | FPRC_UOMName | WACS_UOMCode | Maps UOM Code between Oracle ERP Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) | |
PurchaseOrderSchedule [1] | Group | ||||||||
NeedByDate | PurchaseOrderSchedule[1] | Date-date | requiredDate | _data | Date | ||||
PromisedDate | PurchaseOrderSchedule[1] | Date-date | promiseDate | _data | Date | ||||
SupplierItem | String | vendorPartNumber | _data | String | |||||
OrderedAmount | Field | lineAmount | _data | Decimal | Only if (ns31:OrderedAmount != 0) Function : number (fn:format-number (number (ns31:OrderedAmount ), "#.###" ) ) |