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'
0