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 | |
$CurrInvoiceDistLink | Outermosttag | getAll | Outermosttag | ||||||
links | $CurrInvoiceDistLink | Group | Connectivity Properties | getAll | Group | ||||
RestAPI | Connectivity Properties | 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 | |
onEvent | Outermosttag | get | Outermosttag | ||||||
ApPaymentVoidedInfo | onEvent | Group | Template Parameters | get | Group | ||||
CheckId | ApPayment VoidedInfo | String | id | Template Parameters | String | ||||
QueryParameters | get | Group | |||||||
expand | QueryParameters | String | concat ("relatedInvoices,", "SupplierSiteVVO" ) | ||||||
onlyData | QueryParameters | Boolean | Hardcoded as 'true' | ||||||
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.externalsystem | Value: wacs.externalsystem.error | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
$GetInvoice_GV | Group | ||||||||
getResponse | $GetInvoice_GV | Group | |||||||
Invoices | getResponse | Group | |||||||
InvoiceId | Invoices | Int | externalReference Id | input | String | ||||
invoice | input | Group | |||||||
header | invoice | Group | |||||||
InvoiceId | Invoices | Int | invoiceHeader ExternalId | header | String | ||||
InvoiceNumber | Invoices | String | invoiceNumber | header | String | ||||
$GetRelatedInvoicePayment_GV | Group | ||||||||
getResponse | $GetRelatedInvoicePayment_GV | Group | |||||||
PayablesPayments | getResponse | Group | |||||||
SupplierSiteVVO[1] | PayablesPayments | Group | |||||||
VendorSiteId | SupplierSiteVVO[1] | Int | vendorLocation ExternalId | header | String | ||||
VendorSiteId | SupplierSiteVVO[1] | Int | payToVendorLocationExternalId | header | String | ||||
$GetInvoice_GV | Group | ||||||||
getResponse | $GetInvoice_GV | Group | |||||||
PaymentTerms | Invoices | String | paymentTerms | header | String | OUTL-BRT-WACS_FPRC_PaymentTerm | FPRC_Payment Term | WACS_ PaymentTerm | 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_CurrencyCode | WACS_CurrencyCode | Maps Currency code between Oracle Procurement Cloud(FPRC) and Work and Asset Cloud Service (WACS) |
ConversionRate | Invoices | Field | exchangeRate | header | Decimal | "When ($GetInvoice_GV/nsmpr1:getResponse/nsmpr1:Invoices/ns26:ConversionRate != """") Function : number (fn:format-number (number ($GetInvoice_GV/nsmpr1:getResponse/nsmpr1:Invoices/ns26:ConversionRate ), ""#.#######"" ) )" | |||
"1" | Field | Otherwise Function : number ("1" ) | |||||||
onEvent | Group | ||||||||
ApPaymentVoidedInfo | onEvent | Group | |||||||
CheckDate | ApPaymentVoidedInfo | String | paymentDate | header | Date | Function : substring-before (/nssrcmpr:onEvent/nssrcdfl:ApPaymentVoidedInfo/nssrcdfl:CheckDate, "T" ) | |||
CheckNumber | ApPaymentVoidedInfo | String | paymentNumber | header | String | ||||
PaymentTypeFlag | ApPaymentVoidedInfo | String | paymentType | header | Paymenttype | 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/ns26:relatedInvoices/ns39:AmountPaidPaymentCurrency ) ), "#.###" ) ) | |||
lines | invoice | Group | |||||||
_data | lines | Group | |||||||
invoiceLineExternalId | _data | String | concat ("V-", $CurrentRelatedInv/ns26:relatedInvoices/ns39:InvoicePaymentId ) | ||||||
description | _data | String | Hardcoded as 'Discount Voided' | ||||||
itemType | _data | Itemtype | Hardcoded as 'W1DS' | ||||||
"1" | Field | quantity | _data | Decimal | Only if (number ($CurrentRelatedInv/ns26:relatedInvoices/ns39:DiscountTaken ) != 0) Function : number ("1" ) | ||||
DiscountTaken | relatedInvoices | Field | unitPrice | _data | Decimal | Only if (number ($CurrentRelatedInv/ns26:relatedInvoices/ns39:DiscountTaken ) != 0) Function : number (fn:format-number (number ($CurrentRelatedInv/ns26:relatedInvoices/ns39:DiscountTaken ), "#.###" ) ) | |||
DiscountTaken | relatedInvoices | Field | lineAmount | _data | Decimal | Only if (number ($CurrentRelatedInv/ns26:relatedInvoices/ns39:DiscountTaken ) != 0) Function : number (fn:format-number (number ($CurrentRelatedInv/ns26:relatedInvoices/ns39:DiscountTaken ), "#.###" ) ) | |||
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 | |
$CurrentRelatedInv | Outermosttag | get | Outermosttag | ||||||
relatedInvoices | $CurrentRelated Inv | Group | Template Parameters | get | Group | ||||
InvoiceId | relatedInvoices | Field | id | Template Parameters | String | ||||
QueryParameters | get | Group | |||||||
expand | QueryParameters | String | Hardcoded as "invoiceLines.invoiceDistributions" | ||||||
onlyData | QueryParameters | Boolean | "Set Default value to "" """ | ||||||