11 Appendix A — External System References used by the Accelerator
Mapping Structure
-
ERP Customer/Party : OPERA Company Profile
-
ERP (Table.Field) – HZ_PARTIES.PARTY_ID
-
OPERA – Company Profile ‘ProfileId’ to be extracted via a report from OPERA
-
-
ERP Account Site ID : AR Address ID
-
ERP (Table.Field) – HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID
-
OPERA – to extract AR Address ID from OPERA, use the Get Company Profile API.
-
URL Sample: GET {{OHIP-HostName}}/crm/v1/profiles/{{ProfileId}}?fetchInstructions=ADDRESS
-
Request headers: x-app-key, x-hotelid
-
profileDetails > addresses > address > id
-
-
-
ERP Account ID : Concatenated value of ERP BU ID, OPERA Account ID, and associated OPERA Property.
-
ERP (Table.Field) - HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID
-
OPERA – to extract AR Account ID from OPERA, use the Get AR Account API.
-
URL Sample: GET {{OHIP-HostName}}/crm/v0/profiles/{{ProfileId}}/accounts?idContext=OPERA&type=Profile
-
Request headers: x-app-key, x-hotelid
-
accounts > accountId > id
-
-
Note:
The Hotel-ID used in the request header retrieves the accounts under that specific hotel-id for a company profile from OPERA.
Creating External Reference in ERP (SOAP Service)
The Original System References are expected to follow a pattern. A sample request is shown below.
-
For Customer/Party:
-
<Orig System As created>
-
<OPERA ProfileId>
-
HZ_PARTIES
-
<ERP Party ID>
-
-
For Account Site:
-
<Orig System As created>
-
<OPERA Address ID>
-
HZ_CUST_ACCT_SITES_ALL
-
<ERP Account Site ID>
-
-
For Account:
-
<Orig System As created>
-
Concatenation of <ERP BU ID>-<OPERA AR Account ID>_<OPERA_HOTEL_ID>
-
HZ_CUST_ACCOUNTS
-
<ERP Account ID>
-
-
API Name: Create Original System Reference
-
SOAP service WSDL:
-
{{ERP-HostName}}/foundationParties/OriginalSystemReferenceService?WSDL
-
Operation: createOriginalSystemReference
-
Creating External Reference in OPERA
-
Add ERP PARTY_ID to Company Profile
-
API Name: Update Company Profile
-
URL Sample: {{OHIP-HostName}}/crm/v1/profiles/{{ProfileId}}
-
-
Request headers: x-app-key, x-hotelid
Note:
The request payload contents can be obtained using the “Get Company Profile” as mentioned in the Mapping Structure Point 2b of this Appendix. Add the “externalReferences” section to the payload per OHIP documentation for the API.