EWalletPassTransaction
Name: EZ-Wallet Pass Transaction
Type: Application
Modules: Faring, EZ-Wallet, Client
Description: Stores transaction information for any purchases, refunds, or uses of EZ-Wallet passes.
| Field | Documentation |
|---|---|
| EWalletPassTransactionId | Primary key of the EWalletPassTransaction table. |
| TransactionId | Deprecated. |
| ClientId | Unique, numeric identifier for the client (from Clients.ClientId). |
| TransactionDate | Date the transaction occurred. |
| TransactionTime | Time the transaction occurred. Value is in seconds from midnight. |
| TransactionAmount | Transaction amount. |
| TransactionCode | Code that indicates the type of transaction (e.g., DEP for deposit, FAR for a fare). |
| ConfirmationNumber | Confirmation number from a third party (e.g., credit card company). |
| EWalletPassId | Link to (from EWalletTypes table). |
| LoginName | Deprecated. |
| Comments | Comments about the transaction. |
| Source | Payment method (Cash, Cheque, Credit Card). |
| ClientAccountAmount | Amount charged on client account. |
| EWalletLocationId | EWallet Location identifier (from the EWalletLocation table). |
| TransactionStatus | Hard-coded flag to identify the state of the transaction (0 = Pending, 1 = Active, 2 = Cancelled, 3 = Cannot Process) |
| EWalletReasonId | EWallet Reason identifier (from the EWalletReason table). |
| ChequeNumber | Cheque number of the cheque. |
| CashAmount | Amount charged to cash or to cheque. |
| BookingId | Numeric identifier of the booking scheduled to travel to the event (from the Bookings table). |
| PaymentMethodId | Numeric identifier of the payment method. |
| PaymentMethodReasonId | EWallet Payment Method Reason identifier. |
| ChequeDate | Date on the cheque used for the deposit. |
| PaymentTypeId | Numeric identifier of the payment type. |
| CardType | Type of credit card or debit card. |
| CardAmount | Amount charged to the credit card or to the debit card. |
| paymentId | Unique identifier for a single payment. |
| ValidFromDate | The date from which the pass is valid. |