Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Amount | Unknown | 0 | null |
|
|
Transaction amount - Monetary amount of the transaction |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each transaction |
|
| ChargeTransactionId | int | 4 | √ | null |
|
|
Charge transaction reference - Reference to associated charge transaction |
|
| PaymentTransactionId | int | 4 | √ | null |
|
|
Payment transaction reference - Reference to associated payment transaction |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the transaction was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - User who processed the transaction |
|
| DateCreated | Unknown | 0 | null |
|
|
Creation timestamp - When the transaction was created |
||
| PaymentMethod | Unknown | 0 | null |
|
|
Payment method - Method used for payment transactions |
||
| ReferenceNumber | Unknown | 0 | null |
|
|
Reference number - External reference for transaction tracking |
||
| TransactionDate | Unknown | 0 | null |
|
|
Transaction date - Date when the transaction occurred |
||
| TransactionType | Unknown | 0 | null |
|
|
Transaction type - Type of transaction (Payment, Charge, Refund, Adjustment) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__PaymentA__3214EC2730592A6F | Primary key | Asc | ID |