ClientAccountTransaction
Name: Client Account Transaction
Type: Ancillary
Modules: Client, Booking, Faring
Description: Client account balances and transaction reporting (e.g., withdrawals, deposits).
| Field | Documentation |
|---|---|
| ClientId | Numeric identifier of the client that the transaction is about (from the Clients table). |
| TransactionAmount | Dollar amount of the transaction. |
| AccountBalance | Account balance for the client after the transaction. |
| TransactionDate | Date of the transaction. |
| TransactionTime | Time of the transaction. Value is in seconds from midnight. |
| TransactionTimestamp | System timestamp of the transaction. |
| LoginName | User account that triggered the transaction. |
| TransactionCode | Code that indicates the type of transaction (e.g., DEP for deposit, FAR for a fare). |
| BookingId | Booking ID of the trip related to the account transaction. |
| ScheduleDate | Date for which the trip is or was scheduled. |
| Comments | Comments about the record. |
| ReqTime | Requested time for the trip. Value is in seconds from midnight. |
| AuthorizeNetTransactionId | ID of the authorize.net transaction. |
| Source | Client's payment method (Cash, Cheque, or Credit Card). |
| Depositer | Flag to indicate who made the deposit (Client or Other). |
| DepositersName | Name of the depositor if the depositor is Other. |
| ChequeDate | Date on the cheque used for the deposit. |
| ChequeNumber | Cheque number of the deposited cheque. |
| EWalletPassId | Numeric identifier of the purchased pass (from the EWalletPass table). |
| EWalletReasonId | EWallet Reason identifier (from the EWalletReason table). |
| TransactionId | Unique identifier of the transaction record. |
| EWalletLocationId | EWallet Location identifier (from the EWalletLocation table). |
| ConfirmationNumber | Confirmation number from a third party (e.g., credit card company). |
| TransactionStatus | Hard-coded flag to identify the state of the transaction (0 = Pending, 1 = Active, 2 = Canceled, 3 = Cannot Process). |
| PaymentMethodId | Numeric identifier of the payment method. |
| SchedStatus | Numeric value that indicates the Schedule Status of the event (e.g., Unscheduled, Activated). |
| DirectDistance | Direct distance to the next event activity. |
| PUJurisPolyId | JurisPolyId for the pickup bookingLeg associated with this transaction (from the Polygons table in MmsMaps.dbd). |
| DOJurisPolyId | JurisPolyId for the dropoff bookingLeg associated with this transaction (from the Polygons table in MmsMaps.dbd). |
| PaymentMethodReasonId | EWallet Payment Method Reason identifier. |
| PaymentTypeId | Numeric identifier of the payment type. |
| CardType | Type of the debit card or credit card (e.g., Visa, MC, Interac). |
| paymentId | Unique identifier for a single payment. |