Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkInvoiceItemID | int identity | 4 | null |
|
|
Invoice item identifier - Reference to the invoice line item |
||
| CompanyName | varchar | 50 | √ | null |
|
|
Company name - Name of the agency being billed |
|
| Invoice | varchar | 20 | √ | null |
|
|
Invoice number - Invoice identifier or number |
|
| ItemName | varchar | 200 | √ | null |
|
|
Item name - Name of the billable item or service |
|
| MM | int | 4 | √ | null |
|
|
Month - Billing month |
|
| YY | int | 4 | √ | null |
|
|
Year - Billing year |
|
| Quantity | numeric | 20,3 | √ | null |
|
|
Quantity - Number of units billed |
|
| Included | numeric | 20,3 | √ | null |
|
|
Numeric field - Included precise numeric value for InvoiceItem_vw calculations |
|
| Rate | money | 21,4 | √ | null |
|
|
Rate - Per-unit billing rate |
|
| DateEntered | smalldatetime | 16 | √ | null |
|
|
Date/time field - Date and time when entered occurred or was recorded |
|
| ActualQuantity | numeric | 21,3 | √ | null |
|
|
Actual quantity - Billable quantity after contract inclusions |
|
| AmountDue | numeric | 40,6 | √ | null |
|
|
Amount due - Total amount owed for this line item |
|
| UserDesc | nvarchar | 238 | √ | null |
|
|
Description field - Detailed description or explanation of InvoiceItem_vw information |
|
| Description | nvarchar | 206 | √ | null |
|
|
Description field - Detailed description or explanation of InvoiceItem_vw information |
|
| Terms | varchar | 21 | √ | null |
|
|
Text field - Terms text information for InvoiceItem_vw records |
|
| DueDate | varchar | 30 | √ | null |
|
|
Date/time field - Date and time when due occurred or was recorded |
|
| CustomerID | varchar | 20 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| InvoiceName | varchar | 100 | √ | null |
|
|
Name field - Descriptive name or identifier for InvoiceItem_vw records |
|
| InvoiceID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |