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 | OutboundSOAP RequestDocument | Outermosttag | |||||||
Body | OutboundSOAP RequestDocument | Group | |||||||
GenericRequest | Body | Group | |||||||
Service | GenericRequest | Group | |||||||
Document | Service | Group | |||||||
$docId | Field | Field[1] | Document | Field | |||||
$docName | Field | Field[2] | Document | Field | |||||
$updatedDocTitle | Field | Field[3] | Document | Field |
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 | Outermosttag |
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 | OutboundSOAPRequestDocument | Outermosttag | |||||||
Body | OutboundSOAPRequestDocument | Group | |||||||
GenericRequest | Body | Group | |||||||
Service | GenericRequest | Group | |||||||
Document | Service | Group | |||||||
$docId | Field | Field | Document | Field |
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 | OutboundSOAPRequestDocument | Outermosttag | |||||||
Body | OutboundSOAPRequestDocument | Group | |||||||
GenericRequest | Body | Group | |||||||
Service | GenericRequest | Group | |||||||
Document | Service | Group | |||||||
Field[1] | Document | Field | Hardcoded as 'dInDate' | ||||||
$searchQuery | Field | Field[2] | Document | Field | |||||
Field[3] | Document | Field | Hardcoded as 'Asc' |
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 | syncVendor Location | Outermosttag | |||||||
components.schemas.SYNCVENDORLOCATION_request | syncVendor Location | Group | |||||||
W1VndLocSyn | components.schemas.SYNCVENDORLOCATION_ request | Group | |||||||
input | W1VndLocSyn | Group | |||||||
$externalSystem | Field | externalSystem | input | String | |||||
$currentVendorLoc | Group | ||||||||
vendorLocation | $currentVendorLoc | Group | |||||||
VENDORSITEID | vendorLocation | String | externalReferenceId | input | String | ||||
initialLoad | input | String | Hardcoded as 'F1IC' | ||||||
vendorLocation | input | Group | |||||||
SUPPLIERVENDORID | vendorLocation | String | vendorExternalId | vendorLocation | String | ||||
SUPPLIERSEGMENT1 | vendorLocation | String | vendor | vendorLocation | String | ||||
SUPPPARTYPARTYNAME | vendorLocation | String | vendorName | vendorLocation | String | ||||
SUPPLIERCORPORATEWEBSITE | vendorLocation | String | website | vendorLocation | String | ||||
status | vendorLocation | String | "When (($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERENDDATEACTIVE = """") and ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERSITEINACTIVEDATE = """")) Hardcoded as 'ACTIVE'" | ||||||
Otherwise Hardcoded as 'INACTIVE' | |||||||||
VENDORSITEID | vendorLocation | String | vendorLocationExternalId | vendorLocation | String | ||||
SUPPLIERSITEVENDORSITECODE | vendorLocation | String | locationName | vendorLocation | String | ||||
creationDateTime | vendorLocation | Datetime | concat (substring-before ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERSITECREATIONDATE, " " ), "T", substring-after ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERSITECREATIONDATE, " " ) ) | ||||||
location | vendorLocation | Group | |||||||
LOCATIONADDRESS1 | vendorLocation | String | address1 | location | String | ||||
LOCATIONADDRESS2 | vendorLocation | String | address2 | location | String | ||||
LOCATIONADDRESS3 | vendorLocation | String | address3 | location | String | ||||
LOCATIONADDRESS4 | vendorLocation | String | address4 | location | String | ||||
LOCATIONCITY | vendorLocation | String | city | location | String | ||||
LOCATIONCOUNTY | vendorLocation | String | county | location | String | ||||
$currentVendorLoc | Group | ||||||||
vendorLocation | $currentVendorLoc | Group | |||||||
LOCATIONSTATE | vendorLocation | String | state | location | String | OUTL-BRT-WACS_FPRC_State | FPRC_State | WACS_State | "When ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:LOCATIONSTATE != """") " |
LOCATIONPROVINCE | vendorLocation | String | OUTL-BRT-WACS_FPRC_State | FPRC_State | WACS_State | Otherwise | |||
LOCATIONPOSTALCODE | vendorLocation | String | postal | location | String | ||||
LOCATIONCOUNTRY | vendorLocation | String | country | location | String | OUTL-BRT-WACS_FPRC_Country | FPRC_Country | WACS_ Country | Maps Country values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
orderFromFlag | vendorLocation | Orderfromflag | "When ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERSITEPURCHASINGSITEFLAG = ""Y"") Hardcoded as 'W1AL'" | ||||||
Otherwise Hardcoded as 'W1NA' | |||||||||
payToFlag | vendorLocation | Paytoflag | "When ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERSITEPAYSITEFLAG = ""Y"") Hardcoded as 'W1AL'" | ||||||
Otherwise Hardcoded as 'W1NA' | |||||||||
SUPPLIERSITEDEFAULTPAYSITEID | vendorLocation | String | payToVendorLocationExternalId | vendorLocation | String | ||||
SUPPLIERSITEINVOICECURRENCYCODE | vendorLocation | String | currency | vendorLocation | 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) |
SUPPLIERSITETERMSID | vendorLocation | String | paymentTerm | vendorLocation | 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) |
SUPPLIERMINORDERAMOUNT | vendorLocation | String | minimumOrderAmount | vendorLocation | Decimal | "When ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERMINORDERAMOUNT != """") " | |||
0 | Field | Otherwise | |||||||
$autoPayValue | Field | autoPay | vendorLocation | String | |||||
SUPPLIERSITEFOBLOOKUPCODE | vendorLocation | String | fob | vendorLocation | String | OUTL-BRT-WACS_FPRC_FOB | FPRC_FOB | WACS_FOB | Maps FOB values between Oracle Procurement Cloud (FPRC) and Work and Asset Cloud Service (WACS) |
emailPoFlag | vendorLocation | Emailpoflag | "When ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERSITESUPPLIERNOTIFMETHOD = ""EMAIL"") Hardcoded as 'W1AL'" | ||||||
Otherwise Hardcoded as 'W1NA' | |||||||||
SUPPLIERSITEEMAILADDRESS | vendorLocation | String | poEmailAddress | vendorLocation | String | ||||
payTaxToVendor | vendorLocation | Paytaxtovendor | "When ($currentVendorLoc/nsmpr2:vendorLocation/nsmpr2:SUPPLIERALLOWAWTFLAG = ""Y"") Hardcoded as 'W1NO'" | ||||||
Otherwise Hardcoded as 'W1YS' |