Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Is "TxnDate" the same field as "date the form was created"?

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

Last post 02-02-2012 9:18 AM by Anonymous. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 02-01-2012 1:25 PM

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

    Reply Contact

    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.

  • 02-02-2012 9:18 AM In reply to

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

    Answer
    Reply Contact

    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

     
Page 1 of 1 (2 items)