Owner's Manual

Reporting 203
PurchaseOrderNumber nvarchar 64 Yes The purchase order
number.
PurchaseDate nvarchar 64 Yes The date that the
system was purchased.
SigningAuthorityName nvarchar 64 Yes The signing authority
reference.
OriginalMachineConfiguration
Expensed
nvarchar 64 Yes The original system
configuration that was
expensed.
OriginalMachineConfigurationV
endorName
nvarchar 64 Yes The original system
configuration vendor
name.
CostCenterInformationVendor
Name
nvarchar 64 Yes The cost center
information vendor
name.
UserInformationUserName nvarchar 64 Yes The user name.
ExtendedWarrantyStartDate nvarchar 64 Yes The extended warranty
start date.
ExtendedWarrantyEndDate nvarchar 64 Yes The extended warranty
end date.
ExtendedWarrantyCost nvarchar 64 Yes The extended warranty
cost.
Exte ndedWarrantyProviderName nvarchar 64 Yes The extended warranty
provider name.
OwnershipCode nvarchar 64 Yes The ownership code.
CorporateOwnerName nvarchar 64 Yes The owner’s name.
HazardousWasteCodeName nvarchar 64 Yes The hazardous waste
code name.
DeploymentDateLength nvarchar 64 Yes The deployment date
length.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description