You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

CMK Load AR Extension Attributes for XML Transactions - How to update Customized SQL script

Summary:

CMK Load AR Extension Attributes for XML Transactions - How to update Customized SQL script

Content (please ensure you mask any confidential information):

Require help on how to update sample script provided to meet our requirement for adding 1) Customer Account DFFs but also 2) additional data to appear as new elements in the CMK Original XML message

For example for 1) I want to include these attributes.
SELECT hzp.party_unique_name
,hzca.attribute4 AS einvoiceid
,hzca.attribute5 AS supplierid
,CASE
WHEN hzca.attribute_category = 'India'
THEN hzca.attribute3
WHEN hzca.attribute_category = 'Spain'
THEN hzca.attribute7
WHEN hzca.attribute_category = 'Italy'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!