Account Management Site Control Panel Email FTP Frontpage Billing Maintenance Documentation ISAPI connection Database Shopping Pay Per Download Random Graphics Server Side Includes Visitor Forms Web File Transfer META Tags Fraction/Decimal Chart RGB Color Table HTML Entities E-Commerce Setup SSL Certificate SSL Renewal Merchant Account ASP Overview ADO Database SendMail File IO Include Files Transactions ISAPI/HTML-Basic Authentication SendMail Banner Rotator Random Graphics Random Pages ISAPI/HTML-Database dbSearch dbstore/SendMail dbdelete dbupdate Template Driven

FIELDNAME REFERENCE CHART

FIELDNAME DESCRIPTION TP_FIRSTNAME The buyer's first name. TP_LASTNAME The buyer's last name. TP_MIDDLE_INITIAL The buyer's middle initial. TP_COMPANYNAME The buyer's company name. TP_STREETADDRESS The buyer's street address. TP_CITY The buyer's city. TP_STATE The buyer's state. TP_ZIP The buyer's zip code (5). TP_COUNTRY The buyer's country. TP_PHONE The buyer's phone number. TP_FAX The buyer's fax number. TP_ORDERNUMBER The order number (also a record number). TP_ORDERID For merchant use. TP_CUSTID For merchant use. MerchantNumber Works out to be domain where transaction was accepted. TP_EMAIL The buyer's email address. TP_SHIPTOFIRSTNAME Ship to fields equate to if alternate destination is used. TP_SHIPTOLASTNAME Ship to fields equate to if alternate destination is used. TP_SHIPTOADDRESS Ship to fields equate to if alternate destination is used. TP_SHIPTOCITY Ship to fields equate to if alternate destination is used. TP_SHIPTOSTATE Ship to fields equate to if alternate destination is used. TP_SHIPTOCOMPANY Ship to fields equate to if alternate destination is used. TP_SHIPTOZIP Ship to fields equate to if alternate destination is used. TP_SHIPTOCOUNTRY Ship to fields equate to if alternate destination is used. TP_SHIPTOPHONE Ship to fields equate to if alternate destination is used. TP_SHIPTOFAX Ship to fields equate to if alternate destination is used. TP_EXTRADATA1 User data area 1-10. TP_EXTRADATA2 User data area 1-10. TP_EXTRADATA3 User data area 1-10. TP_EXTRADATA4 User data area 1-10. TP_EXTRADATA5 User data area 1-10. TP_EXTRADATA6 User data area 1-10. TP_EXTRADATA7 User data area 1-10. TP_EXTRADATA8 User data area 1-10. TP_EXTRADATA9 User data area 1-10. TP_EXTRADATA10 User data area 1-10. TP_DEALER For Merchant. TP_SALESREP For Merchant. TP_CUSTOMEMAIL Reserved. TP_PAYMENTMETHOD Payment Method. TP_BANKNAME The buyer's bank name. TP_BANKBRANCH The buyer's bank branch. TP_BANKCITY The buyer's bank city. TP_BANKSTATE The buyer's bank state. TP_BANKADDRESS The buyer's bank address. TP_BANKABA The buyer's bank Routing Number. TP_BANKACCOUNT The buyer's Bank Account Number. TP_BANKCHECKNUMBER The buyer's bank check number (serial number). TP_CUSTOMERNUMBER For Merchant use. TP_BANKZIP The buyer's bank zip code. TP_BANKPHONE The buyer's bank phone. TP_DRIVER Driver's Licence Number. TP_DRIVERS_EXP Reserved. TP_DATE Date of transaction. TP_ABA Can also be Routing Number (outdated). TP_DOB Date of birth. TP_FSS Social Security Number. DLCount PayPerDownload (reserved). ReceiptNumber Transaction Result. Amount Amount. CardNumber Credit Card Number. CardExp Credit Card Expiration Date. DateTime Date/Time of transaction. Subtotal   Tax   Shipping   Shipped Yes/No Flag. ShippedDate   ICheckCleared Yes/No Flag. ICheckClearedDate   ApprovalFlag Used to indicate status/result in numeric form. RevisedCCNumber Reserved. RevisedCCExpDate Reserved. TrackingNumber Tracking Number. ResellerNumber For Merchant use. CardHolderName Name of Credit Card Holder. Processed Reserved. Login Generated Login. Password Generated Password. ShipType Shipping Method. TaxableAmount Taxable Amount. StateTaxRate State Tax Rate used. StateTaxAmount State Tax Amount. CountyTaxRate County Tax Rate used. CountyTaxAmount County Tax Amount. CountyTaxCode County Tax Code used. CityTaxRate City Tax Rate. CityTaxAmount City Tax Amount. CityTaxCode City Tax Code. LocalOpRate Local Tax Rate. LocalOpAmount Local Tax Amount. LocalOpCode Local Tax Code. TotalTaxRate Total Tax Rate. Transaction_Type Transaction Type. DiscountName Discount Name. DiscountRate Discount Rate. DiscountAmount Discount Amount. DiscountCode Discount Code. AuthOnlyData Auth Only. PostAuthFlag Post Auth. CardType Card Type. IPAddress IP Address. Cookie Cookie Passed. Renewal Reserved. TotalDays Reserved. Expired Reserved. ValidUntil Reserved. TP_PAYEE Payee of check ICheckIndicator ACH Network Status. UPDATED Boolean Y/N if this record has been updated.