Concurrent Update Control (TStamp)

You can add the SQL Server time stamp column to a table to make MYOB Acumatica Framework able to handle concurrent updates. The corresponding time stamp data field should be declared in the data access class. If the time stamp data field is declared, MYOB Acumatica Framework handles the time stamp column automatically. MYOB Acumatica Framework checks the row version every time the row is modified. We recommend that you add the time stamp column, with the parameters shown in the following table, to all tables of your application.

Table 1. The Time Stamp Column
Database Column Name Data Type (SQL Server) Data Type (MySQL) Type Attribute on the Data Field
TStamp timestamp; not null TIMESTAMP(6); not null [PXDBTimestamp]