IntelliTrack Package Track - Manual (Page 221)

Appendix A
Data Structures
207
Packages
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
Table Indexes
Name Field
CarrierID CarrierID (Ascending)
DeliverUserID DeliveredUserID (Ascending)
LocationID LocationID (Ascending)
MailRoomID MailRoomID (Ascending)
PackageID TrackingNo (Ascending)
PackageID1 PackageID (Ascending)
PackagesDeliveryStatusID DeliveryStatusID
(Ascending)
PackageTypeID PackageTypeID (Ascending)
PrimaryKey PackageID (Ascending)
ReceiveUserID ReceivedUserID (Ascending)
RecipientID RecipientID (Ascending)