Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| DateBill | smalldatetime | 16 | √ | (getdate()) |
|
|
Billing date - Date when the billing cycle was processed |
|
| BillingTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Reference to the agency being billed |
|
| BilledStatus | varchar | 500 | √ | null |
|
|
Status indicator - Current operational status or state of BillingStatus records |
|
| BillingPeriod | Unknown | 0 | null |
|
|
Billing period - Time period covered by this billing cycle |
||
| DueDate | Unknown | 0 | null |
|
|
Due date - Date when payment is due |
||
| InvoiceNumber | Unknown | 0 | null |
|
|
Invoice number - Unique invoice identifier for tracking |
||
| PaymentStatus | Unknown | 0 | null |
|
|
Payment status - Current payment status (Pending, Paid, Overdue, etc.) |
||
| Totalclaim | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for BillingStatus records |
|
| TotalAmount | money | 21,4 | √ | null |
|
|
Total amount - Total amount billed for this period |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__BillingStatus__0C85DE4D | Primary key | Asc | BillID |