The Vendor Customer Modification Tracking (VCMT) table stores changes to Vendor/Customer records submitted by VSS and interfaces. This table does not store changes related to VCM transactions that are created by users within the application.
The Vendor Customer Modification Tracking table is used to create VCM transactions based on Prefix and Tracking Number. It shows the old value and new value of each change, in addition to tracking the status of changes once the corresponding VCM transactions are processed. Valid values for the Status field are: Pending Approval, Approved, and Rejected. The Status is set to Pending Approval when the record is first added to the VCM Tracking Table. The Status is set to Approved when the corresponding VCM transaction is submitted to Final and the Changes Rejected box is unchecked. The Status is set to Rejected when the VCM transaction is submitted to Final and the Changes Rejected flag is checked.
Additionally, if a VCM transaction is discarded from the Transaction Catalog, the following outcomes are possible based on the VCM Discard (VCM_DISCARD) parameter on the Application Parameters table and the setting of the VSS-Initiated flag on the VCM transaction:
If the VCM_DISCARD parameter on the Application Parameters table is set to True and the VSS-Initiated flag on the VCM is not selected, then the Status on the Vendor Customer Modification Tracking table will be set to Rejected whenever a draft VCM Transaction is deleted (discarded) from the Transaction Catalog. In addition, the VCM Transaction Code, Transaction ID and Transaction version fields will remain populated on the Vendor Customer Modification Tracking table.
If the VCM_DISCARD parameter is set to False and VSS-Initiated flag is not selected, then records are simply removed from the Vendor Customer Modification Tracking table when the VCM is deleted (discarded).
If the VSS-Initiated flag is selected (and the VCM_DISCARD parameter is set to either True or False), when a VCM transaction is deleted (discarded) the record remains on the Vendor Customer Modification Tracking table, but the Transaction Code, Transaction ID and Transaction Version fields are blanked out. In this case, a new VCM transaction will be generated the next time the Tracking Table to VCM batch job is run.
This table also provides detailed information used in emails sent to VSS users, informing them of the status of their account changes.
All fields on this table are protected and cannot be modified by an online user.