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
<RetailCdxSeedData ChannelDBMajorVersion="7" ChannelDBSchema="ext" Name="AX7">
<Subjobs>
<Subjob Id="RetailTransactionSalesTrans" OverrideTarget="false" TargetTableName="EXT_RetailTransactionSalesTrans" AxTableName="RetailTransactionSalesTrans" ReplicationCounterFieldName="ReplicationCounterFromOrigin" TargetTableSchema="ext" IsUpload="true">
<ScheduledByJobs>
<ScheduledByJob>P-0001</ScheduledByJob>
</ScheduledByJobs>
<AxFields>
<Field Name="EXT_InventBatchId" ToName="InventBatchId"/>
<Field Name="ReplicationCounterFromOrigin" />
</AxFields>
</Subjob>
</Subjobs>
</RetailCdxSeedData>
If anyone could kindly offer some guidance or assistance, it would be greatly appreciated.
Thank You 😇