Method Community

Just curious: what does the Txn part of the TxnDate field stand for? This field appears in every table related to a form, ie invoice, sales order, purchase order, etc. There aren't any other fields for the date the form was created, and it seems to match the QB field for the creation date.

I'm also curious as to the roles of the various other Txn*** fields, like TxnID and TxnMethodFlag, which appear in the same tables.

Hi smohyee,

The "Txn" part for the fields in those tables stands for "Transaction". 

In the invoice table, sales order table, and purchase order table:

TxnDate = Stands for the transaction date.

TxnMethodFlag = It is a field that allows you to flag additional data being added to the transaction for example notes that are being added to those transactions. 

TxnID = It is a transaction id # that is assigned to the transaction so that the transaction can be identified in QuickBooks. 

I hope that helps.

Ronen