InvoiceItemNew_vw


Description

Enhanced invoice item view - Extended business intelligence view that includes additional agency details, billing addresses, and tax information for comprehensive invoice processing.

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

Email 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

Relationships

View Definition


Possibly Referenced Tables/Views