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 | |
$CurrentInvDistLink | Outermosttag | getAll | Outermosttag | ||||||
links | $CurrentInvDistLink | Group | Connectivity Properties | getAll | Group | ||||
RestAPI | ConnectivityProperties | Group | |||||||
href | links | String | AbsoluteEndpointURI | RestAPI | Anyuri |
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 | |
$CurrentRelated Inv | Outermosttag | get | Outermosttag | ||||||
relatedInvoices | $CurrentRelated Inv | Group | Template Parameters | get | Group | ||||
InvoiceId | relatedInvoices | Int | id | Template Parameters | String | ||||
QueryParameters | get | Group | |||||||
expand | QueryParameters | String | Hardcoded as "invoiceLines.invoiceDistributions" |
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 | syncInvoice | Outermosttag | |||||||
components.schemas.SYNCINVOICE_request | syncInvoice | Group | |||||||
W1InvoiceSyn | components.schemas.SYNCINVOICE_request | Group | |||||||
input | W1InvoiceSyn | Group | |||||||
externalSystem | input | String | OUTL-BRT-WACS_FPRC_ConfigProps | PropertyName: wacs.external system | Value: wacs.externalsystem.error | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
$GetInvoiceResp_GV | Group | ||||||||
getResponse | $GetInvoiceResp_GV | Group | |||||||
Invoices | getResponse | Group | |||||||
InvoiceId | Invoices | Int | externalReferenceId | input | String | ||||
invoice | input | Group | |||||||
header | invoice | Group | |||||||
InvoiceId | Invoices | Int | invoiceHeaderExternalId | header | String | ||||
InvoiceNumber | Invoices | String | invoiceNumber | header | String | ||||
$GetRelatedInvPymntResp_GV | Group | ||||||||
getResponse | $GetRelatedInvPymntResp_GV | Group | |||||||
PayablesPayments | getResponse | Group | |||||||
SupplierSiteVVO[1] | PayablesPayments | Group | |||||||
VendorSiteId | SupplierSiteVVO[1] | Int | vendorLocationExternalId | header | String | ||||
VendorSiteId | SupplierSiteVVO[1] | Int | payToVendorLocationExternalId | header | String | ||||
$GetInvoiceResp_GV | Group | ||||||||
getResponse | $GetInvoiceResp_GV | Group | |||||||
PaymentTerms | Invoices | String | paymentTerms | header | String | OUTL-BRT-WACS_FPRC_Payment Term | FPRC_ PaymentTerm | WACS_ PaymentTerm | Maps Payment Term values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
PaymentTerms | Invoices | String | numberOfDays | header | Decimal | OUTL-BRT-WACS_FPRC_PaymentTerm | FPRC_Payment Term | FPRC_NumberOfDays | Maps Payment Term values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
InvoiceDate | Invoices | String | vendorDate | header | Date | ||||
PaymentCurrency | Invoices | String | currency | header | String | OUTL-BRT-WACS_FPRC_CurrencyCode | FPRC_Currency Code | WACS_CurrencyCode | Maps Currency code between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service (WACS) |
ConversionRate | Invoices | Field | exchangeRate | header | Decimal | "When ($GetInvoiceResp_GV/nsmpr1:getResponse/nsmpr1:Invoices/ns40:ConversionRate != """") Function : number (fn:format-number (number ($GetInvoiceResp_GV/nsmpr1:getResponse/nsmpr1:Invoices/ns40:ConversionRate ), ""#.#######"" ) )" | |||
1 | Field | Otherwise | |||||||
onEvent | Group | ||||||||
ApPaymentCreatedInfo | onEvent | Group | |||||||
CheckDate | ApPaymentCreatedInfo | Group | |||||||
newValue | CheckDate | Group | |||||||
@value | newValue | Field | paymentDate | header | Date | Function : substring-before (/nssrcmpr:onEvent/nssrcdfl:ApPaymentCreatedInfo/nssrcdfl:CheckDate/nssrcdfl:newValue/@value, "T" ) | |||
CheckNumber | ApPaymentCreatedInfo | Group | |||||||
newValue | CheckNumber | Group | |||||||
@value | newValue | Field | paymentNumber | header | String | ||||
PaymentTypeFlag | ApPaymentCreatedInfo | Group | |||||||
newValue | PaymentTypeFlag | Group | |||||||
@value | newValue | Field | paymentType | header | Paymenttype | OUTL-BRT-WACS_FPRC_Payment Type | FPRC_Payment Type | WACS_CheckType | Maps ERP Payment type flag to WACS Check type and vice versa |
$CurrentRelatedInv | Group | ||||||||
relatedInvoices | $CurrentRelated Inv | Group | |||||||
AmountPaidPaymentCurrency | relatedInvoices | Field | paymentAmount | header | Decimal | Function : number (fn:format-number (number ($CurrentRelatedInv/ns40:relatedInvoices/ns48:AmountPaidPaymentCurrency ), "#.###" ) ) | |||
lines | invoice | Group | |||||||
_data | lines | Group | |||||||
InvoicePaymentId | relatedInvoices | Int | invoiceLineExternalId | _data | String | Only if ($CurrentRelatedInv/ns40:relatedInvoices/ns48:DiscountTaken != 0) | |||
description | _data | String | Hardcoded as 'Discount' | ||||||
itemType | _data | Itemtype | Hardcoded as 'W1DS' | ||||||
1 | Field | quantity | _data | Decimal | Only if ($CurrentRelatedInv/ns40:relatedInvoices/ns48:DiscountTaken != 0) | ||||
0 - $CurrentRelatedInv | Group | ||||||||
relatedInvoices | 0 - $CurrentRelated Inv | Group | |||||||
DiscountTaken | relatedInvoices | Float | unitPrice | _data | Decimal | Only if ($CurrentRelatedInv/ns40:relatedInvoices/ns48:DiscountTaken != 0) | |||
DiscountTaken | relatedInvoices | Float | lineAmount | _data | Decimal | Only if ($CurrentRelatedInv/ns40:relatedInvoices/ns48:DiscountTaken != 0) |
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 | |
onEvent | Outermosttag | get | Outermosttag | ||||||
ApPaymentCreatedInfo | onEvent | Group | Template Parameters | get | Group | ||||
CheckId | ApPaymentCreatedInfo | Group | |||||||
newValue | CheckId | Group | |||||||
@value | newValue | Field | id | Template Parameters | String | ||||
QueryParameters | get | Group | |||||||
expand | QueryParameters | String | Hardcoded as 'relatedInvoices,SupplierSiteVVO' | ||||||
onlyData | QueryParameters | Boolean | Hardcoded as 'true' |