CDX Pull job

(3) Share

Report

Posted on by jamesfrancis

102

Hi All,

How can I transfer the value of EXT_INVENTBATCHID from the EXT_RETAILTRANSACTIONSALESTRANS extension table to the INVENTBATCHID field in the RETAILTRANSACTIONSALESTRANS table during a CDX Pull job?

This is the CDX XML that I wrote

If anyone could kindly offer some guidance or assistance, it would be greatly appreciated.

Thank You 😇

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Muhammad Khurram 57 on at

Like (0)

Report

Please follow the XML format provided below for the resource file. Ensure that the channel database table EXT_RetailTransactionSalesTrans has the same primary key as the ax.RetailTransactionSalesTrans table. Create the DataAreaId column in the EXT_RetailTransactionSalesTrans table and remove the ReplicationCounterFromOrigin field from the EXT_RetailTransactionSalesTrans table.

Note : The ax.RETAILTRANSACTIONSALESTRANS table has the following primary key columns:
- [CHANNEL]
- [STORE]
- [TERMINALID]
- [TRANSACTIONID]
- [LINENUM]

<RetailCdxSeedData ChannelDBMajorVersion="7" ChannelDBSchema="ext" Name="AX7">
<Subjobs>
<Subjob Id="RetailTransactionSalesTrans" TargetTableName="EXT_RetailTransactionSalesTrans" TargetTableSchema="ext" OverrideTarget="false" >
<AxFields>
<Field Name="EXT_InventBatchId" ToName="InventBatchId"/>
</AxFields>
</Subjob>
</Subjobs>
</RetailCdxSeedData>

Was this reply helpful? Yes No