Information on the tables which has captured the reason code for Return and void sales

Information on the tables which has captured the reason code for Return and void sales

Version

6.5 and not the version-specific

Requirement

Need the information on the tables which has captured the reason code for Return and void sales.

Resolution

 Suggested customer to consider below tables:

Table name TrxTransctionAudit, wherein field (Columns):

1. "AuditType" will identify the activity on the POS

2.  "ReasonCodeKey": identifies Reason and references reason code.

The reason codes could be found in the table "cfgReasonCode".

These tables can be used to capture the return and void sales.