Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkInvoiceItemID | int identity | 4 | √ | null |
|
|
Primary key - InvoiceItem unique identifier for each record |
||||
| fkAgencyID | int | 4 | √ | null |
|
|
Agency reference - Reference to the agency being billed |
||||
| fkItemID | int | 4 | √ | null |
|
|
Item reference - Reference to the billable item or service |
||||
| MM | int | 4 | √ | null |
|
|
Month - Billing month for the item |
||||
| YY | int | 4 | √ | null |
|
|
Year - Billing year for the item |
||||
| Quantity | numeric | 20,3 | √ | null |
|
|
Quantity - Number of units being billed |
||||
| Included | numeric | 20,3 | √ | null |
|
|
Included quantity - Number of units included in base contract |
||||
| Rate | money | 21,4 | √ | null |
|
|
Rate - Per-unit rate for the billable item |
||||
| Notes | varchar | 2000 | √ | null |
|
|
Text field - Notes text information for InvoiceItem records |
||||
| DateEntered | smalldatetime | 16 | √ | (getdate()) |
|
|
Entry date - Date when the invoice item was created |
||||
| InvoiceID | int | 4 | √ | null |
|
|
Invoice reference - Reference to the parent invoice |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_InvoiceItem | Primary key | Asc | pkInvoiceItemID |