IntelliTrack Package Track - Manual (Page 218)

I NTELLI T RACK DMS: P ACKAGE T RACK V 7.0
User Manual
202
Packages
Archive
Package
Types
Columns
Name Type Size
PackageID Long Integer 4
TrackingNo Text 60
RecipientID Long Integer 4
PackageTypeID Long Integer 4
LocationID Long Integer 4
CarrierID Long Integer 4
MailRoomID Long Integer 4
ReceivedUserID Long Integer 4
ReceivedDate Date/Time 8
DeliveredUserID Long Integer 4
DeliveredDate Date/Time 8
DeliveryStatusID Long Integer 4
RecipientSignatureID Text 20
Comments Text 255
LastUpdated Date/Time 8
OldPackageID Long Integer 4
PackageIDChangeDate Date/Time 8
Columns
Name Type Size
PackageTypeID Long Integer 4
TypeIdentifier Text 20
PackageType Text 50
Comments Text 50
Table Indexes
Name Field
PackageTypeID PackageTypeID (Ascending)
PrimaryKey PackageTypeID (Ascending)
TypeIdentifier TypeIdentifier (Ascending)