Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each invoice payment record |
|
| fkCasePayID | int | 4 | √ | null |
|
|
Case payment reference - Links to case-level payment information |
|
| fkInvoiceID | int | 4 | √ | null |
|
|
Invoice reference - Links to the invoice receiving this payment |
|
| fkPaymentType | int | 4 | √ | null |
|
|
Payment type reference - Links to payment type classification (Check, EFT, Credit Card, etc.) |
|
| DatePaid | datetime | 16,3 | √ | null |
|
|
Payment date - Date when payment was received or processed |
|
| AmountPaid | money | 21,4 | √ | null |
|
|
Payment amount - Monetary amount of the payment applied to the invoice |
|
| StatusID | int | 4 | √ | null |
|
|
Payment status reference - Links to iCS2.dbo.StatusType for centralized payment status management and classification |
|
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive date - Date when payment record was archived |
|
| Voucher | varchar | 30 | √ | null |
|
|
Voucher number - Payment voucher or reference number for tracking |
|
| ActionBy | int | 4 | √ | null |
|
|
Action user reference - Links to AccessUser table for the user who processed the payment |
|
| PresentID | varchar | 20 | √ | null |
|
|
Presentation identifier - Display or presentation ID for payment tracking |
|
| ActionID | int | 4 | √ | null |
|
|
Action reference - Links to specific action taken on the payment |
|
| fkCheckLogID | int | 4 | √ | null |
|
|
Check log reference - Links to check log for check payments |
|
| ArchiveType | varchar | 30 | √ | null |
|
|
Archive type - Classification of archive type for the payment record |
|
| comments | text | 2147483647 | √ | null |
|
|
Payment comments - Additional comments or notes related to the payment |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_InvoicePayment | Primary key | Asc | PayID |
Relationships
Close relationships within degrees of separation
