Transaction fields

{TRANSACTION.ID}

{TRANSACTION.SHIPVIA}

{TRANSACTION.SHIPTYPE}

{TRANSACTION.TYPE}

{TRANSACTION.SUBTYPE}

{TRANSACTION.STATUS1}

{TRANSACTION.STATUS2}

{TRANSACTION.STATUS3}

{TRANSACTION.STATUS4}

{TRANSACTION.STATUS5}

{TRANSACTION.STATUS6}

{TRANSACTION.DATECREATED}

{TRANSACTION.TIMECREATED}

{TRANSACTION.SUBAMOUNT}

{TRANSACTION.AMOUNT}

{TRANSACTION.DISCOUNTRATE}

{TRANSACTION.DISCOUNTAMOUNT}

{TRANSACTION.TAXABLE}

{TRANSACTION.SALESTAXRATE}

{TRANSACTION.SALESTAX}

{TRANSACTION.SHIPPINGNHANDLING}

{TRANSACTION.ACTUALSHIPPINGCHARGE}

{TRANSACTION.BILLSHIPPINGTO}

{TRANSACTION.DOCUMENTNUM}

{TRANSACTION.MEMO}

{TRANSACTION.CUSTOMERMEMO}

{TRANSACTION.INVOICECOMPANYNAME}

{TRANSACTION.INVOICEPERSONNAME}

{TRANSACTION.INVOICEADDRESS1}

{TRANSACTION.INVOICEADDRESS2}

{TRANSACTION.SHIPPERSONNAME}

{TRANSACTION.SHIPDATE}

{TRANSACTION.SHIPCOMPANYNAME}

{TRANSACTION.SHIPADDRESS1}

{TRANSACTION.SHIPADDRESS2}

{TRANSACTION.SHIPCITY}

{TRANSACTION.SHIPSTATE}

{TRANSACTION.SHIPPOSTALCODE}

{TRANSACTION.SHIPPHONE}

{TRANSACTION.WEIGHT}

{TRANSACTION.RESIDENTIALADDRESS}

{TRANSACTION.EMAILADDRESS}

{TRANSACTION.TRACKINGCODE}

{TRANSACTION.INVOICECITY}

{TRANSACTION.INVOICESTATE}

{TRANSACTION.INVOICEPOSTALCODE}

{TRANSACTION.INVOICEPHONE}

{TRANSACTION.INVOICEEMAILADDR}

{TRANSACTION.STATETAXNAME}

{TRANSACTION.ISGIFT}

{TRANSACTION.GIFTNOTES}

{TRANSACTION.INVOICECOMPANYNAME}

{TRANSACTION.INVOICEFIRSTNAME}

{TRANSACTION.INVOICELASTNAME}

{TRANSACTION.SHIPFIRSTNAME}

{TRANSACTION.SHIPLASTNAME}

{TRANSACTION.SELLINGPRICE}

{TRANSACTION.GROUPNAME}

{TRANSACTION.PICKUPLOCATION}

{TRANSACTION.GROUPTYPE}

{TRANSACTION.SHIPBIRTHDATE}

{TRANSACTION.CASHDRAWERID}

{TRANSACTION.CHECKOUTREPNAME}

{TRANSACTION.TYTOTALPAYMENTAMOUNT}

{TRANSACTION.TYTOTALCREDITAMOUNT}

{TRANSACTION.TYBALANCE}

{TRANSACTION.SIGNATURE}

{TRANSACTION.CREDITCARDNUM}

{TRANSACTION.CREDITCARDTYPE}

{TRANSACTION.AUTHORIZATIONDATA}

{TRANSACTION.AVSADDRESS}

{TRANSACTION.AVSCITY}

{TRANSACTION.AVSSTATE}

{TRANSACTION.AVSPOSTALCODE}

{TRANSACTION.CUSTOMERFIRSTNAME}

{TRANSACTION.CUSTOMERLASTNAME}

{TRANSACTION.TRANSACTIONDATE}

{TRANSACTION.EXPIRATIONMONTH}

{TRANSACTION.EXPIRATIONYEAR}

{TRANSACTION.TRACKLINK}

{TRANSACTION.TRACKREPORTDATE}

{TRANSACTION.TRACKREPORTTIME}


Related topic:

Including database field references