sql server - GeneralDetailReportQuery key field -
we use generaldetailreportquery customer "transactions" quickbooks desktop , save them mssql table. query called passing from/to date filter params changes only. try report changes each day , keep our table in sync qb data. tranid, customer listid , trantype seem fields can uniquely identify each record returned report query. problem starts happen when users change 1 of key fields, customer listid example. must have been change of customer in transaction... ? anyway, how keep data in sync, report have kind of primary key field, not changed , can use track changes ? thanks, slava