POS Payments Subcategory

POS > POS Payments

This subcategory details information about payments through POS.

Some report columns are derived from UDFs (user-defined fields) in DataTrak. Because UDFs are defined at the club level, those columns are omitted from this documentation.

Column Name	Column Description
ABC Collected	Displays "Yes" if ABC collected the invoice amount for this club account transaction.
Address	The member's address as it is entered on the member page.
Agreement #	The member's agreement number.
Agreement Misc	The Agreement Misc fields contain the text entered in the fields of the same name in the Miscellaneous section of the Agreement tab on the member page.
Agt Down Payment	The agreement down payment amount, as displayed in the Down Payment section of the Agreement tab on the member page.
Agt Sales Person	The sales person associated with the agreement, as displayed in the Miscellaneous section of the Agreement tab on the member page.
American Express	The total amount, if any, that was charged to an American Express card for this transaction.
Barcode	The member’s barcode.
Batch Number	This is an ADP setting.
Birth Date	The member's date of birth.
CC Number Last Four	The last four digits of the credit card number associated with the agreement.
Card Entry	The method by which the member's card information was received for this transaction: Keyed, On File, or Swiped.
Cell Phone	The member's mobile phone number, as listed in the Demographics section of the Personal tab on the member page.
City	The member’s city as it appears on the member page.
Club Name	The name of the club associated with the agreement.
Club Nbr	The number of the club associated with the agreement.
Country	The abbreviated name of the member’s country (ex. “US”).
Country Name	The full name of the member’s country (ex. “United States”).
Date Signed	The date the member's agreement was created, as listed in the Status section of the Agreement tab on the member page.
Debit Card	The total amount, if any, that was charged to a debit card for this transaction.
Discover	The total amount, if any, that was charged to a Discover card for this transaction.
Draft Date	The date ABC drafted the amount from the member's account.
Drawer Closed Date	The date the listed drawer was closed.
Drawer Closed Date/Time	The date and time the listed drawer was closed.
Drawer Closed Time	The time the listed drawer was closed.
Drawer Open	Displays "Yes" if the drawer associated with this transaction is still open or "No" if it has been closed.
Drawer Opened Date	The date the listed drawer was opened.
Drawer Opened Date/Time	The date and time the listed drawer was opened.
Drawer Opened Time	The time the listed drawer was opened.
Email	The member's email address, as listed in the Demographics section on the Personal tab of the member page.
Emergency Phone	The member's emergency phone number, as listed in the Demographics section on the Personal tab of the member page.
Employee Name	The name of the employee who was logged into DataTrak at the time of the transaction.
Fax	The fax number of the member, as listed in the Demographics section on the Personal tab of the member page.
First Payment Date	The due date for the member's first payment, as listed in the Dates section on the Agreement tab of the member page.
Gender	The member's gender.
Gift Card Auth	The authorization number for a transaction completed with a gift card.
Gift Card Number	The gift card number for transactions in which a gift card was used.
Group	The membership group to which the member belongs, if any. This group is listed on the Personal tab of the member page.
Income (Total)	The total income from the transaction, including taxes.
Interac	The total amount, if any, that was charged to an Interac card for this transaction. Interac is a Canadian debit card.
Join Status	Designates the purchaser as a member or a prospect.
Master Card	The total amount, if any, that was charged to a MasterCard for this transaction.
Member Misc	The Member Misc fields contain the text entered in the fields of the same name in the Personal section on the Personal tab of the member page.
Member Name	The member's name.
Member Since Date	The date that the member agreement was created.
Member Status	The member's current status (OK, Canceled, etc.).
Member Status Reason	The reason for the member's current status.
Month	The month in which the transaction took place.
Month #	This column can be used to filter data by month independently of year, but it will not display in the report itself. For example, setting the Month # filter to equal "08" will return data from every August in the selected year range.
Next Due Amount	The member's next amount due..
Ordinal Identifier	The ordinal identifier is the agreement number with an additional number called an ordinal. The primary member on an agreement has an Ordinal of 0, which will not be displayed in the ordinal identifier. For all secondary members on an agreement, the ordinal identifier will be the agreement number plus an additional digit indicating that this is a secondary member. For example, for agreement number 900312345, the primary member's ordinal identifier will be 900312345, while the first secondary member's ordinal identifier will be 90031234501.
Payment Method	The payment method used by the member for this transaction.
Payment Method Detail	The authorization number associated with the payment method. This authorization number can be manually populated on the Complete Sale page.
Pre-Pay Bal.	The member's current pre-pay balance, as listed in the Pre-Pay view on the Invoices tab of the member page. This does not relate directly to the listed transaction, but to the associated member.
Primary Phone	The member's primary phone number, as listed in the Demographics section on the Personal tab of the member page.
Receipt #	The receipt number for the listed transaction.
Receipt Comment	The Sale Note that appears on the receipt for the listed transaction.
Settlement Date	The settlement date for this listed transaction, as listed on the Settlement page in the Point of Sale section of the Main Menu.
Settlement Date/Time	The settlement date and time for this listed transaction, as listed on the Settlement page in the Point of Sale section of the Main Menu.
Settlement Time	The settlement time for this listed transaction, as listed on the Settlement page in the Point of Sale section of the Main Menu.
State	The state in which the member resides, as listed in the Demographics section on the Personal tab of the member page.
Station Group	The workstation group to which the workstation that performed the transaction belongs.
Station Name	The name of the workstation at which the transaction took place.
Status Date	The date the member's status was last changed, as listed in the Status section on the Agreement tab of the member page.
Term	The agreement term (Cash, Cash Open, Open, Installment).
Terminal Batch Number	The terminal name and batch number associated with the terminal that performed the transaction, as listed on the Settlement page in the Point of Sale section of the Main Menu.
Terminal Name	The name of the terminal that performed the transaction, as listed on the Settlement page in the Point of Sale section of the Main Menu.
Total	The total income from the transaction, including taxes. Note: This field will only populate if the payment method is a credit card.
Transaction Date	The date of the POS transaction.
Transaction Date/Time	The date and time of the POS transaction.
Transaction Time	The time of the listed POS transaction.
Visa	The total amount, if any, that was charged to a Visa card for this transaction.
Work Phone	The member's work phone number, as listed in the Demographics section on the Personal tab of the member page.
Year	The year in which the transaction took place.
Zip	The member’s zip code, as listed in the Demographics section of the Personal tab of the member page.