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 | ||||||
ApInvoiceValidatedInfo | onEvent | Group | Template Parameters | get | Group | ||||
InvoiceId | ApInvoiceValidatedInfo | Group | |||||||
newValue | InvoiceId | Group | |||||||
@value | newValue | Field | id | Template Parameters | String | ||||
QueryParameters | get | Group | |||||||
expand | QueryParameters | String | Hardcoded as 'invoiceInstallments,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 | |
$CurrInvoiceDistributionLink | Outermosttag | getAll | Outermosttag | ||||||
links | $CurrInvoiceDistributionLink | Group | ConnectivityProperties | getAll | Group | ||||
RestAPI | ConnectivityProperties | Group | |||||||
href | links | Field | 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 | |
Outermosttag | getAll | Outermosttag | |||||||
QueryParameters | getAll | Group | |||||||
onlyData | QueryParameters | Boolean | Hardcoded as 'true' | ||||||
$GV_Limit_TaxLinesReturned | limit | QueryParameters | Int | ||||||
$Var_QueryParm_GetAllTaxLines | query | QueryParameters | String | ||||||
totalResults | 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 | |
$GetInvoiceTransTax Lines | Outermosttag | syncInvoice | Outermosttag | ||||||
getAllResponse | $GetInvoiceTransTaxLines | Group | components.schemas.SYNCINVOICE_request | syncInvoice | Group | ||||
W1InvoiceSyn | components.schemas.SYNCINVOICE_request | Group | |||||||
input | W1InvoiceSyn | Group | |||||||
invoice | input | Group | |||||||
items | getAllResponse | Transactiontaxlines | lines | invoice | Lines | ||||
_data | lines | Group | |||||||
Field | invoiceLineExternalId | _data | String | concat (ns42:TaxLineId, "-", ns42:TrxLineNumber ) | |||||
Field | purchaseOrderNumber | _data | String | Function : $GV_Invoice/nsmpr1:getResponse/nsmpr1:Invoices/ns42:invoiceLines[ns37:LineNumber=current()/ns42:TrxLineNumber]/ns37:PurchaseOrderNumber | |||||
purchaseOrderLineNumber | _data | Decimal | Function : $GV_Invoice/nsmpr1:getResponse/nsmpr1:Invoices/ns42:invoiceLines[ns37:LineNumber=current()/ns42:TrxLineNumber]/ns37:PurchaseOrderLineNumber | ||||||
description | _data | String | concat (ns42:Tax, "-", ns42:TaxRegimeName ) | ||||||
itemType | _data | Itemtype | Hardcoded as 'W1TX' | ||||||
1 | Field | quantity | _data | Decimal | |||||
TaxAmount, "#.#######" | Field | unitPrice | _data | Decimal | Function : number (fn:format-number (ns42:TaxAmount, "#.#######" ) ) | ||||
TaxAmount, "#.###" | Field | lineAmount | _data | Decimal | Function : number (fn:format-number (ns42:TaxAmount, "#.###" ) ) | ||||
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 | getAll | Outermosttag | |||||||
QueryParameters | getAll | Group | |||||||
onlyData | QueryParameters | Boolean | Hardcoded as 'true' | ||||||
$GV_Limit_TaxLinesReturned | Field | limit | QueryParameters | Int | |||||
$GV_Offset_TaxLines | Field | offset | QueryParameters | Int | |||||
$Var_QueryParm_GetAllTaxLines | Field | query | QueryParameters | String | |||||
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 | |
$GetInvoiceTransTax Lines2 | Outermosttag | syncInvoice | Outermosttag | ||||||
getAllResponse | $GetInvoiceTransTaxLines2 | Group | components.schemas.SYNCINVOICE_request | syncInvoice | Group | ||||
W1InvoiceSyn | components.schemas.SYNCINVOICE_request | Group | |||||||
input | W1InvoiceSyn | Group | |||||||
invoice | input | Group | |||||||
items | getAllResponse | Transactiontaxlines | lines | invoice | Lines | ||||
_data | lines | Group | |||||||
Field | invoiceLineExternalId | _data | String | concat (ns43:TaxLineId, "-", ns43:TrxLineNumber ) | |||||
Field | purchaseOrderNumber | _data | String | Only if (ns43:TaxAmount != 0) Function : $GV_Invoice/nsmpr1:getResponse/nsmpr1:Invoices/ns43:invoiceLines[ns38:LineNumber=current()/ns43:TrxLineNumber]/ns38:PurchaseOrderNumber | |||||
purchaseOrderLineNumber | _data | Decimal | Only if (ns43:TaxAmount != 0) Function : $GV_Invoice/nsmpr1:getResponse/nsmpr1:Invoices/ns43:invoiceLines[ns38:LineNumber=current()/ns43:TrxLineNumber]/ns38:PurchaseOrderLineNumber | ||||||
description | _data | String | concat (ns43:Tax, "-", ns43:TaxRegimeName ) | ||||||
itemType | _data | Itemtype | Hardcoded as 'W1TX' | ||||||
1 | Field | quantity | _data | Decimal | Only if (ns43:TaxAmount != 0) | ||||
TaxAmount, "#.#######" | Field | unitPrice | _data | Decimal | Only if (ns43:TaxAmount != 0) Function : number (fn:format-number (ns43:TaxAmount, "#.#######" ) ) | ||||
TaxAmount, "#.###" | Field | lineAmount | _data | Decimal | Only if (ns43:TaxAmount != 0) Function: number (fn:format-number (ns43:TaxAmount, "#.###" ) ) | ||||
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: | Maps PropertyName column to the respective Value Column. Do not change the values under PropertyName column. | |||
onEvent | Group | ||||||||
ApInvoiceValidatedInfo | onEvent | Group | |||||||
InvoiceId | ApInvoiceValidatedInfo | Group | |||||||
newValue | InvoiceId | Group | |||||||
@value | newValue | Field | externalReferenceId | input | String | ||||
invoice | input | Group | |||||||
header | invoice | Group | |||||||
@value | newValue | Field | invoiceHeaderExternalId | header | String | ||||
InvoiceNum | ApInvoiceValidatedInfo | Group | |||||||
newValue | InvoiceNum | Group | |||||||
@value | newValue | Field | invoiceNumber | header | String | ||||
$GV_Invoice | Group | ||||||||
getResponse | $GV_Invoice | Group | |||||||
Invoices | getResponse | Group | |||||||
Description | Invoices | String | description | header | String | ||||
VendorSiteId | ApInvoiceValidatedInfo | Group | |||||||
newValue | VendorSiteId | Group | |||||||
@value | newValue | Field | vendorLocationExternalId | header | String | ||||
@value | newValue | Field | payToVendorLocationExternalId | header | String | ||||
$GV_Invoice | Group | ||||||||
getResponse | $GV_Invoice | Group | |||||||
PaymentTerms | Invoices | String | paymentTerms | header | String | OUTL-BRT-WACS_FPRC_PaymentTerm | 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_PaymentTerm | FPRC_NumberOfDays | Maps Payment Term values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
InvoiceDate | Invoices | String | vendorDate | header | Date | ||||
invoiceInstallments[1] | Invoices | Group | |||||||
DueDate | invoiceInstallments[1] | String | invoiceDueDate | header | Date | ||||
InvoiceReceivedDate | Invoices | String | invoiceReceivedDate | header | Date | Only if ($GV_Invoice/nsmpr2: getResponse/nsmpr2:Invoices/ns46: InvoiceReceivedDate != "") | |||
CreationDate | Invoices | String | invoiceEnteredDate | header | Date | Function: substring-before ($GV_Invoice/nsmpr2: getResponse/nsmpr2:Invoices/ns46: CreationDate, "T" ) | |||
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 ($GV_Invoice/nsmpr2:getResponse/nsmpr2:Invoices/ns46:ConversionRate != """") Function : number (fn:format-number (number ($GV_Invoice/nsmpr2:getResponse/nsmpr2:Invoices/ns46:ConversionRate ), ""#.#######"" ) )" | |||
1 | Field | Otherwise | |||||||
invoiceLines | Invoices | Invoicelines | lines | invoice | Lines | ||||
_data | lines | Group | |||||||
invoiceLineExternalId | _data | String | concat ($GV_Invoice/nsmpr2:getResponse/nsmpr2:Invoices/ns46:InvoiceNumber, "-", ns40:LineNumber ) | ||||||
PurchaseOrderNumber | String | purchaseOrderNumber | _data | String | Only if (ns40:PurchaseOrderNumber != "" and ns40:LineType != "Tax") | ||||
PurchaseOrderLineNumber | Float | purchaseOrderLineNumber | _data | Decimal | Only if (ns40:PurchaseOrderLineNumber != "" and ns40:PurchaseOrderNumber != "") | ||||
Description | String | description | _data | String | Only if (ns40:PurchaseOrderLineNumber != "") | ||||
itemType | _data | Itemtype | Only if (ns40:PurchaseOrderLineNumber != "") Hardcoded as 'W1CR' | ||||||
LineType | String | OUTL-BRT-WACS_FPRC_InvoiceLineType | FPRC_InvoiceLineType | WACS_InvoiceItemType | Only if (ns40:PurchaseOrderLineNumber != "") | ||||
Quantity | Float | quantity | _data | Decimal | Only if (ns40:PurchaseOrderLineNumber != "") | ||||
1 | Field | Only if (ns40:PurchaseOrderLineNumber != "") | |||||||
UnitPrice | Field | unitPrice | _data | Decimal | Only if (ns40:PurchaseOrderLineNumber != "") Function : number (fn:format-number (number (ns40:UnitPrice ), "#.#### ###" ) ) | ||||
LineAmount | Field | Only if (ns40:PurchaseOrderLineNumber != "") Function : number (fn:format-number (number (ns40:LineAmount ), "#.#######" ) ) | |||||||
LineAmount | Field | lineAmount | _data | Decimal | Only if (ns40:PurchaseOrderLineNumber != "") Function : number (fn:format-number (number (ns40:LineAmount ), "#.###" ) ) | ||||