Club Account Invoices Drafted Subcategory

This report subcategory displays information about members' club account invoices. The following columns can be added to non-default reports or used when creating a report in this subcategory.

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
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.
Amount	The invoice amount listed on the Invoices tab of the member page.
Amount Collected	The amount collected from the club account invoice.
Applied Date	The transaction date listed for the club account invoice on the Invoices tab of the member page.
Barcode	The member’s barcode.
Billed by ABC	This column indicates whether ABC billed for this amount.
Birth Date	The member’s birth date.
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.
CityStateZip	The member’s city, state, and zip code, as listed in the Demographics section of the Personal tab 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”).
Current Club Account Bank Account Number Last Four	The last four digits of the bank account number used for the member’s club account.
Current Club Account Bank Account Type	The type of bank account used for the member’s club account (checking or savings).
Current Club Account Bank Routing Number	The routing number of the bank account used for the member’s club account.
Current Club Account CC Number Last Four	The last four digits of the credit card number used for the member’s club account.
Current Club Account Card Holder	The name that appears on the credit card used for the member’s club account.
Current Club Account Credit Card Type	The type of credit card used for this member’s club account (Visa, MasterCard, etc.), as listed in the Payment Option field on the Club Account section of the Billing tab on the member page.
Current Club Account Payment Method	The payment method listed in the Club Account section of the Billing tab on the member page.
Description	The transaction description associated with the Payment Status (the reason for the payment status).
Draft Date	The date the amount was drafted from the member’s account.
Due Date	Due date for the listed club account invoice, as listed on the Invoices tab of the member page.
Email	The member’s email address as it appears in the Demographics section of the Personal tab on the member page.
Emergency Phone	The emergency phone number listed in the Demographics section of the Personal tab on the member page.
Fax	The fax number listed in the Demographics section of the Personal tab on the member page.
Group	The membership group listed in the Personal section of the Personal tab on the member page.
Historical Club Account Bank Account Number Last Four	The last four digits of a bank account number formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Club Account Bank Account Type	The type of bank account formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Club Account Bank Routing Number	The routing number of a bank account formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Club Account CC Exp Date	The expiration date of a credit card formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Club Account Card Holder	The name that appears on a card formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Club Account Credit Card Type	The type of credit card formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Club Account Number CC Last Four	The last four digits of a credit card formerly used by this member for club account. This information is listed in the Payment Options section of the Billing tab on the member page.
Historical Payment Method	The former payment method for the member’s club account (Credit card, EFT, or statement). This information is listed in the Payment Options section of the Billing tab on the member page.
Member Deleted	This column will display “Yes” if the member has been deleted, and “No” if the member has not been deleted.
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. There are up to four Member Name columns: Last name, first name; first name, last name; first name only; last name only.
Member Since Date	The date that the member agreement was created.
Membership Type	The membership type associated with this agreement, as it appears in the Personal section of the Personal tab on the member page.
Payment Status	The current state of the processed payment (ex. Pending ABC, Club Account Payment, etc.) as listed on the Club Account Billing page.
Primary Phone	The member's primary phone number, as listed in the Demographics section on the Personal tab of the member page.
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.
Submission Date	The date that the transaction was submitted, as listed on the Club Account Billing page.
Submission Date/Time	The date and time that the transaction was submitted.
Submission Time	The time that the transaction was submitted.
Term	The agreement term (Cash, Cash Open, Open, Installment).
Work Phone	The member's work phone number, as listed in the Demographics section on the Personal tab of the member page.
Zip	The member’s zip code, as listed in the Demographics section of the Personal tab of the member page.