Re: Is "TxnDate" the same field as "date the form was created"?

Anonymous — Thu, 02 Feb 2012 15:18:43 GMT

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

Is "TxnDate" the same field as "date the form was created"?

smohyee — Wed, 01 Feb 2012 19:25:42 GMT

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.

Method:Classic General Q&A

Re: Is "TxnDate" the same field as "date the form was created"?

Is "TxnDate" the same field as "date the form was created"?