Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkInvoiceItemID | int | 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 - Unique invoice identifier for billing and payment tracking |
|
| ItemName | varchar | 200 | √ | null |
|
|
Item name - Description of the billable service or product |
|
| MM | int | 4 | √ | null |
|
|
Month - Numeric month for the billing period |
|
| YY | int | 4 | √ | null |
|
|
Year - Year for the billing period |
|
| Quantity | numeric | 20,3 | √ | null |
|
|
Quantity - Total quantity of services or units provided |
|
| Included | numeric | 20,3 | √ | null |
|
|
Included quantity - Quantity included in the contract at no additional charge |
|
| Rate | money | 21,4 | √ | null |
|
|
Rate - Per-unit billing rate for this service or product |
|
| DateEntered | smalldatetime | 16 | √ | null |
|
|
Entry date - Date when this invoice item was entered into the system |
|
| ActualQuantity | numeric | 21,3 | √ | null |
|
|
Actual billable quantity - Calculated quantity after subtracting included amounts |
|
| AmountDue | numeric | 40,6 | √ | null |
|
|
Amount due - Total amount owed for this line item after contract inclusions |
|
| UserDesc | nvarchar | 238 | √ | null |
|
|
User description - Human-readable description of the billing item for user display |
|
| Description | nvarchar | 206 | √ | null |
|
|
Item description - Detailed description of the billable item including calculations |
|
| Terms | varchar | 21 | √ | null |
|
|
Payment terms - Payment terms and conditions (e.g., NET 30 Days) |
|
| DueDate | varchar | 30 | √ | null |
|
|
Due date - Date when payment is due for this invoice |
|
| CustomerID | varchar | 20 | √ | null |
|
|
Customer identifier - Customer reference number for billing systems |
|
| InvoiceName | varchar | 100 | √ | null |
|
|
Invoice name - Descriptive name or title for the invoice |
|
| InvoiceID | int | 4 | √ | null |
|
|
Invoice reference - Reference to the main invoice record |
|
| ZipCode | varchar | 15 | √ | null |
|
|
ZIP code - Agency ZIP code for billing |
|
| ContactName | varchar | 100 | √ | null |
|
|
Contact name - Primary contact for billing |
|
| Telephone | varchar | 15 | √ | null |
|
|
Phone number - Agency contact phone number |
|
| Fax | varchar | 15 | √ | null |
|
|
Fax number - Agency fax number for billing communications |
|
| varchar | 100 | √ | null |
|
|
Email address - Agency contact email |
||
| CompanyId | varchar | 15 | null |
|
|
Company identifier - Unique identifier for the agency in external systems |
||
| CompanyWebsite | nvarchar | 4000 | √ | null |
|
|
Company website - Agency website URL for reference |
|
| TaxID | nvarchar | 1073741823 | √ | null |
|
|
Tax identification - Agency tax ID number for tax reporting |
|
| Address1 | varchar | 50 | √ | null |
|
|
Address line 1 - Primary street address for the agency |
|
| Address2 | varchar | 20 | √ | null |
|
|
Address line 2 - Secondary address information (suite, apartment, etc.) |
|
| City | varchar | 20 | √ | null |
|
|
City - City for the agency’s primary address |
|
| State | varchar | 20 | √ | null |
|
|
State - State or province for the agency’s primary address |
|
| BillingEmail1 | varchar | 50 | √ | null |
|
|
Primary billing email - Primary email address for billing communications |
|
| BillingEmail2 | varchar | 50 | √ | null |
|
|
Secondary billing email - Secondary email address for billing communications |
|
| BillingAddress1 | varchar | 1000 | √ | null |
|
|
Billing address line 1 - Primary billing address |
|
| BillingAddress2 | varchar | 1000 | √ | null |
|
|
Billing address line 2 - Secondary billing address information |
|
| BillingCity | varchar | 100 | √ | null |
|
|
Billing city - City for billing address |
|
| BillingState | varchar | 100 | √ | null |
|
|
Billing state - State for billing address |
|
| BillingZip | varchar | 50 | √ | null |
|
|
Billing ZIP code - ZIP code for the billing address |
|
| SalesTaxExemption | varchar | 3 | null |
|
|
Sales tax exemption - Whether agency is exempt from sales tax |