WorldLink Xi Database Schema

Topic Contents ShowHide

Tables Listing

#	Table Name	Table Type	Primary Key	No. Columns
1	BOLs	Independent	Id	72
2	CarrierAccounts	Independent	Id	53
3	Consolidation	Independent	Id	12
4	Countries	Independent	Id	4
5	Departments	Independent	Id	9
6	Manifests	Independent	Id	23
7	Organizations	Independent	Id	49
8	PackageDetails	Independent	Id	66
9	Packages	Independent	Id	98
10	ReturnAddress	Independent	Id	13
11	Services	Independent	Id	11
12	Shipments	Independent	Id	156
13	ShipVias	Independent	Id	19
14	Sites	Independent	Id	22
15	Users	Independent	Id	29

Table ‘BOLs’

Table Name	BOLs
Primary Key	PK_BOLs

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	YES	NO	NO	NO
2		CarrierAccountId		Integer	YES	NO	NO	NO
3		RatingServer		NVarChar 10	YES	NO	NO	NO
4		Address1		NVarChar 50	YES	NO	NO	NO
5		Address2		NVarChar 50	YES	NO	NO	NO
6		Address3		NVarChar 50	YES	NO	NO	NO
7		City		NVarChar 40	YES	NO	NO	NO
8		State		NVarChar 40	YES	NO	NO	NO
9		Zip		NVarChar 10	YES	NO	NO	NO
10		Country		NVarChar 4	YES	NO	NO	NO
11		BOLNumber		NVarChar 50	YES	NO	NO	NO
12		ShipViaId		Integer	YES	NO	NO	NO
13		ServiceId		Integer	YES	NO	NO	NO
14		DepartmentId		Integer	YES	NO	NO	NO
15		OrganizationId		Integer	YES	NO	NO	NO
16		SiteId		Integer	YES	NO	NO	NO
17		PaymentType		Integer	YES	NO	NO	NO
18		Company		NVarChar 50	YES	NO	NO	NO
19		Contact		NVarChar 50	YES	NO	NO	NO
20		CustomerCode		NVarChar 30	YES	NO	NO	NO
21		IntlCompany		NVarChar 50	YES	NO	NO	NO
22		IntlContact		NVarChar 50	YES	NO	NO	NO
23		IntlAddress1		NVarChar 50	YES	NO	NO	NO
24		IntlAddress2		NVarChar 50	YES	NO	NO	NO
25		IntlAddress3		NVarChar 50	YES	NO	NO	NO
26		IntlCity		NVarChar 40	YES	NO	NO	NO
27		IntlState		NVarChar 40	YES	NO	NO	NO
28		IntlZip		NVarChar 10	YES	NO	NO	NO
29		IntlCountry		NVarChar 4	YES	NO	NO	NO
30		FreightTerms		Integer	YES	NO	NO	NO
31		TPCompany		NVarChar 50	YES	NO	NO	NO
32		TPContact		NVarChar 50	YES	NO	NO	NO
33		TPAddress1		NVarChar 50	YES	NO	NO	NO
34		TPAddress2		NVarChar 50	YES	NO	NO	NO
35		TPAddress3		NVarChar 50	YES	NO	NO	NO
36		TPCity		NVarChar 40	YES	NO	NO	NO
37		TPState		NVarChar 40	YES	NO	NO	NO
38		TPZip		NVarChar 10	YES	NO	NO	NO
39		TPCountry		NVarChar 4	YES	NO	NO	NO
40		Status		Integer	YES	NO	NO	NO
41		StopNumber		Integer	YES	NO	NO	NO
42		AnyText1		NVarChar 255	YES	NO	NO	NO
43		AnyText2		NVarChar 255	YES	NO	NO	NO
44		AnyText3		NVarChar 255	YES	NO	NO	NO
45		AnyText4		NVarChar 255	YES	NO	NO	NO
46		AnyText5		NVarChar 255	YES	NO	NO	NO
47		MasterBOLNumber		NVarChar 50	YES	NO	NO	NO
48		DeleteFlag		Integer	YES	NO	NO	NO
49		Phone		NVarChar 20	YES	NO	NO	NO
50		COD		Integer	YES	NO	NO	NO
51		Instructions		NVarChar 500	YES	NO	NO	NO
52		AccountNumber		NVarChar 20	YES	NO	NO	NO
53		TPPhone		NVarChar 20	YES	NO	NO	NO
54		CreatedBy		Integer	YES	NO	NO	NO
55		IntPhone		NVarChar 20	YES	NO	NO	NO
56		ShipmentCount		Integer	YES	NO	NO	NO
57		DiscountedBasefreight		Float	YES	NO	NO	YES
58		DiscountedSpecialServices		Float	YES	NO	NO	YES
59		DiscountedTotalFreight		Float	YES	NO	NO	YES
60		PublishedBasefreight		Float	YES	NO	NO	YES
61		PublishedSpecialServices		Float	YES	NO	NO	YES
62		PublishedTotalFreight		Float	YES	NO	NO	YES
63		CreateDateTime		Datetime	YES	NO	NO	YES
64		PackageCount		Integer	YES	NO	NO	YES
65		CustomerBasefreight		Float	YES	NO	NO	YES
66		CustomerSpecialServices		Float	YES	NO	NO	YES
67		CustomerTotalFreight		Float	YES	NO	NO	YES
68		UseAsMaster		Integer	YES	NO	NO	YES
69		PRO		NVarChar 50	YES	NO	NO	YES
70		ReferenceNumber		NVarChar 50	YES	NO	NO	YES
71		ReferenceNumber2		NVarChar 50	YES	NO	NO	YES
72		ReferenceNumber3		NVarChar 50	YES	NO	NO	YES

Indices

Index name	Columns	Unique	Descending	Clustered
IX_Index1	Status, DeleteFlag	No	No	No
IX_Index2	Status, MasterBOLNumber, DeleteFlag, PackageCount	No	No	No
IX_Index3	BOLNumber, DeleteFlag	No	No	No
IX_Index4	BOLNumber, Status, MasterBOLNumber	No	No	No
IX_Index5	CarrierAccountId, Status, MasterBOLNumber, DeleteFlag, PackageCount	No	No	No
IX_Index6	CarrierAccountId, Status, DeleteFlag, CreateDateTime	No	No	No
IX_Index7	CarrierAccountId, Address1, City, State, Zip, ShipViaId, SiteId, PaymentType, Company, CustomerCode, Status, AnyText1, AnyText2, AnyText3, AnyText4, AnyText5	No	No	No

Table ‘CarrierAccounts’

Table Name	CarrierAccounts
Primary Key	PK_CarrierAccounts

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		Code		NVarChar 10	Yes	No	No	No
3		CarrierId		Integer	Yes	No	No	No
4		RatingServer		Integer	Yes	No	No	No
5		RatingServerParameter		NVarChar 100	Yes	No	No	No
6		Description		NVarChar 50	Yes	No	No	No
7		AccountNumber		NVarChar 20	Yes	No	No	No
8		ManifestId		Integer	Yes	No	No	No
9		ContactName		NVarChar 50	Yes	No	No	No
10		ContactPhone		NVarChar 20	Yes	No	No	No
11		ContactEmail		NVarChar 50	Yes	No	No	No
12		DeleteFlag		Bit	Yes	No	No	No
13		RecordTimeStamp		Binary	No	No	No	No
14		UpdateDateTime		Datetime	Yes	No	No	No
15		LastUsedBy		NVarChar 30	Yes	No	No	No
16		MeterNumber		NVarChar 50	Yes	No	No	No
17		SCAC		NVarChar 10	Yes	No	No	Yes
18		EDIStatus		Integer	Yes	No	No	Yes
19		TrackingNumber		NVarChar 50	Yes	No	No	Yes
20		LabelName		NVarChar 20	Yes	No	No	Yes
21		ManifestName		NVarChar 20	Yes	No	No	Yes
22		TrackingForm		NVarChar 50	Yes	No	No	Yes
23		TrackingTo		NVarChar 50	Yes	No	No	Yes
24		ZipRange1		NVarChar 50	Yes	No	No	Yes
25		DivertLane1		NVarChar 20	Yes	No	No	Yes
26		ZipRange2		NVarChar 50	Yes	No	No	Yes
27		DivertLane2		NVarChar 20	Yes	No	No	Yes
28		ZipRange3		NVarChar 50	Yes	No	No	Yes
29		DivertLane3		NVarChar 20	Yes	No	No	Yes
30		ErrorDivertLane		NVarChar 20	Yes	No	No	Yes
31		Servicerange1		NVarChar 50	Yes	No	No	Yes
32		Servicerange2		NVarChar 50	Yes	No	No	Yes
33		Servicerange3		NVarChar 50	Yes	No	No	Yes
34		INTTrackingFrom		NVarChar 50	Yes	No	No	Yes
35		INTTrackingTo		NVarChar 50	Yes	No	No	Yes
36		INTTrackingNumber		NVarChar 50	Yes	No	No	Yes
37		FUTINTTrackingFrom		NVarChar 50	Yes	No	No	Yes
38		FUTINTTrackingTo		NVarChar 50	Yes	No	No	Yes
39		FUTTrackingFrom		NVarChar 50	Yes	No	No	Yes
40		FUTTrackingTo		NVarChar 50	Yes	No	No	Yes
41		SyncRates		Integer	Yes	No	No	Yes
42		StandardHoliday		Integer	Yes	No	No	Yes
43		OrganizationId		Integer	Yes	No	No	Yes
44		RatedCarrier		Integer	Yes	No	No	Yes
45		EODReportId		Integer	Yes	No	No	Yes
46		DisallowFreight		Integer	Yes	No	No	Yes
47		CSAllowPost		Integer	No	No	No	Yes
48		UseMMS		Integer	Yes	No	No	Yes
49		TrackingNoWarning		Integer	Yes	No	No	Yes
50		Threshold		Integer	Yes	No	No	Yes
51		ShipperCode		NVarChar 10	Yes	No	No	Yes
52		PostalFormFontSize		Float	Yes	Yes	No	Yes
53		FedExRetLaserPrinter		Integer	Yes	Yes	No	Yes

Table ‘Consolidation’

Table Name	Consolidation
Primary Key	PK_Consolidation

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		Code		NVarChar 20	Yes	No	No	No
3		ManifestIds		NVarChar 50	Yes	No	No	No
4		ManifestDate		Datetime	Yes	No	No	No
5		ShipViaId		Integer	Yes	No	No	No
6		PaymentType		Integer	Yes	No	No	No
7		CustomerCode		NVarChar 30	Yes	No	No	No
8		DeleteFlag		Integer	Yes	No	No	No
9		UpdateDateTime		Datetime	Yes	No	No	No
10		CarrierId		Integer	Yes	No	No	No
11		ParentCarrierId		Integer	Yes	No	No	No
12		TermOfSale		Integer	Yes	No	No	No

Table ‘Countries’

Table Name	Countries
Primary Key	PK_Countries

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		Code		NVarChar 10	Yes	No	No	No
3		Description		NVarChar 50	Yes	No	No	No
4		DeleteFlag		Bit	Yes	No	No	No

Table ‘Departments’

Table Name	Departments
Primary Key	PK_Departments

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		Code		NVarChar 10	Yes	No	No	No
3		Description		NVarChar 100	Yes	No	No	No
4		XRefCode		NVarChar 50	Yes	No	No	No
5		DeleteFlag		Bit	Yes	No	No	No
6		RecordTimeStamp		Timestamp	Yes	No	No	No
7		UpdateDateTime		Datetime	Yes	No	No	No
8		LastUsedBy		NVarChar 30	Yes	No	No	No
9		XRefGroupId		Integer	Yes	No	No	Yes

Indices

Index name	Columns	Unique	Descending	Clustered
IX_Code	Code, DeleteFlag	No	No	No

Table ‘Manifests’

Table Name	Manifests
Primary Key	PK_Manifests

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		ManifestType		Integer	Yes	No	No	No
3		CarrierId		Integer	Yes	No	No	No
4		Packages		Integer	Yes	No	No	No
5		ManifestDate		Datetime	Yes	No	No	No
6		ReferenceId		NVarChar 50	Yes	No	No	No
7		ExportData		NVarChar 1023	Yes	No	No	No
8		LaserPrintType		Integer	Yes	No	No	No
9		LaserPrintData		Text	Yes	No	No	No
10		LabelPrintType		NVarChar 20	Yes	No	No	No
11		LabelPrintData		NVarChar 50	Yes	No	No	No
12		DeleteFlag		Bit	Yes	No	No	No
13		RecordTimeStamp		Binary	No	No	No	No
14		CreateDateTime		Datetime	Yes	No	No	No
15		CreatedBy		NVarChar 50	Yes	No	No	No
16		UpdateDateTime		Datetime	Yes	No	No	No
17		LastUsedBy		NVarChar 30	Yes	No	No	No
18		ParentCarrierId		Integer	Yes	No	No	No
19		TransStatus		Integer	Yes	No	No	Yes
20		SyncStatus		Integer	Yes	No	No	Yes
21		ForcePost		Integer	No	No	No	Yes
22		EnginePackages		Integer	No	No	No	Yes(-1)
23		ReturnPackages		Integer	No	No	No	Yes

Indices

Index name	Columns	Unique	Descending	Clustered
IX_SendEOD2	ManifestType, ReferenceId, DeleteFlag	No	No	No

Table ‘Organizations’

Table Name	Organizations
Primary Key	PK_Organizations

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	No
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		CrossReference		NVarChar 50	Yes	No	No	No
3		CompanyName		NVarChar 50	Yes	No	No	No
4		Contact		NVarChar 50	Yes	No	No	No
5		Address1		NVarChar 50	Yes	No	No	No
6		Address2		NVarChar 50	Yes	No	No	No
7		Address3		NVarChar 50	Yes	No	No	No
8		City		NVarChar 50	Yes	No	No	No
9		State		NVarChar 10	Yes	No	No	No
10		Zip		NVarChar 10	Yes	No	No	No
11		Country		NVarChar 4	Yes	No	No	No
12		Email		NVarChar 50	Yes	No	No	No
13		Phone		NVarChar 20	No	No	No	No
14		Fax		NVarChar 20	Yes	No	No	No
15		CI		NVarChar 50	Yes	No	No	No
16		BOL		NVarChar 50	Yes	No	No	No
17		BOLCopies		Integer	Yes	No	No	No
18		DeleteFlag		Bit	Yes	No	No	No
19		RecordTimeStamp		Binary 8	No	No	No	No
20		UpdateDateTime		Datetime	Yes	No	No	No
21		LastUsedBy		NVarChar 30	Yes	No	No	No
22		EINType		NVarChar 1	Yes	No	No	Yes
23		EINNumber		NVarChar 15	Yes	No	No	Yes
24		CICopies		Integer	Yes	No	No	Yes
25		AutoManifest		Integer	Yes	No	No	No
26		NAFTA		NVarChar 50	Yes	No	No	Yes
27		NAFTACopies		Integer	Yes	No	No	Yes
28		SED		NVarChar 50	Yes	No	No	Yes
29		SEDCopies		Integer	Yes	No	No	Yes
30		CO		NVarChar 50	Yes	No	No	Yes
31		COCopies		Integer	Yes	No	No	Yes
32		SLI		NVarChar 50	Yes	No	No	Yes
33		SLICopies		Integer	Yes	No	No	Yes
34		UseAddVerification		Integer	Yes	No	No	Yes
35		AutoAddCorrect		Integer	Yes	No	No	Yes
36		IgnoreExceptions		Integer	Yes	No	No	Yes
37		AutoSelectManifest		Integer	Yes	No	No	Yes
38		DPV		Integer	Yes	No	No	Yes
39		RDI		Integer	Yes	No	No	Yes
40		DG		NVarChar 50	No	No	No	No
41		DGCopies		Integer	Yes	No	No	Yes
42		TNTDG		NVarChar 50	No	No	No	No
43		TNTDGCopies		Integer	Yes	No	No	Yes
44		USDataFiles		Integer	No	No	No	No
45		UKDataFiles		Integer	No	No	No	No
46		CanadaDataFiles		Integer	No	No	No	No
47		BOLReport		NVarChar 50	No	Yes	No	Yes
48		BOLReportCopies		Integer	Yes	Yes	No	No
49		SubBOLReport		NVarChar 50	No	Yes	No	Yes

Table ‘PackageDetails’

Table Name	PackageDetails
Primary Key	PK_PackageDetails

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	Yes
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		PackageId		Integer	Yes	No	No	Yes
3		ItemNumber		NVarChar 50	Yes	No	No	No
4		ItemDescription		NVarChar 50	Yes	No	No	No
5		Quantity		Integer	Yes	No	No	No
6		UnitPrice		Money	Yes	No	No	No
7		DeclaredValue		Money	Yes	No	No	No
8		CountryOfOrigin		NVarChar 50	Yes	No	No	No
9		ExportLicenseNumber		NVarChar 50	Yes	No	No	No
10		ECCN		NVarChar 50	Yes	No	No	No
11		LicenseExpdate		Datetime	No	No	No	No
12		UnitWeight		Float	Yes	No	No	No
13		Weight		Float	No	No	No	No
14		UOM		NVarChar 10	Yes	No	No	Yes
15		PurchaseOrder		NVarChar 20	Yes	No	No	No
16		POLineNumber		NVarChar 10	Yes	No	No	No
17		CommodityCode		NVarChar 50	Yes	No	No	No
18		AnyText1		NVarChar 255	Yes	No	No	No
19		AnyText2		NVarChar 255	Yes	No	No	No
20		AnyText3		NVarChar 255	Yes	No	No	No
21		AnyText4		NVarChar 255	Yes	No	No	No
22		AnyText5		NVarChar 255	Yes	No	No	No
23		DeleteFlag		Bit	Yes	No	No	No
24		RecordTimeStamp		Timestamp	Yes	No	No	No
25		UpdateDateTime		Datetime	Yes	No	No	No
26		LastUsedBy		NVarChar 30	Yes	No	No	No
27		DGFlag		Integer	Yes	No	No	Yes
28		DGUNNumber		NVarChar 50	Yes	No	No	Yes
29		DGPackaging		NVarChar 50	Yes	No	No	Yes
30		DGPackagingInstruction		NVarChar 50	Yes	No	No	Yes
31		DGEmergencyPhone		NVarChar 50	Yes	No	No	Yes
32		DGTitle		NVarChar 50	Yes	No	No	Yes
33		DGPackingGroup		NVarChar 50	Yes	No	No	Yes
34		DGSpecialProvision		Integer	Yes	No	No	Yes
35		DGSignatoryName		NVarChar 50	Yes	No	No	Yes
36		DGSignatoryPlace		NVarChar 50	Yes	No	No	Yes
37		DGProperShipName		NVarChar 50	Yes	No	No	Yes
38		HazardClass		NVarChar 100	Yes	No	No	Yes
39		HazardLabel		Integer	Yes	No	No	Yes
40		Weight_UOM		NVarChar 10	Yes	No	No	Yes
41		DGTechnicalName		NVarChar 50	Yes	No	No	Yes
42		AnyText6		NVarChar 255	No	No	No	Yes
43		AnyText7		NVarChar 255	No	No	No	Yes
44		AnyText8		NVarChar 255	No	No	No	Yes
45		AnyText9		NVarChar 255	No	No	No	Yes
46		AnyText10		NVarChar 255	No	No	No	Yes
47		AnyText11		NVarChar 255	No	No	No	Yes
48		AnyText12		NVarChar 255	No	No	No	Yes
49		AnyText13		NVarChar 255	No	No	No	Yes
50		AnyText14		NVarChar 255	No	No	No	Yes
51		AnyText15		NVarChar 255	No	No	No	Yes
52		AnyNumber1		NVarChar 100	No	No	No	Yes
53		AnyNumber2		NVarChar 100	No	No	No	Yes
54		AnyNumber3		NVarChar 100	No	No	No	Yes
55		AnyNumber4		NVarChar 100	No	No	No	Yes
56		AnyNumber5		NVarChar 100	No	No	No	Yes
57		AnyNumber6		NVarChar 100	No	No	No	Yes
58		AnyNumber7		NVarChar 100	No	No	No	Yes
59		AnyNumber8		NVarChar 100	No	No	No	Yes
60		AnyNumber9		NVarChar 100	No	No	No	Yes
61		AnyNumber10		NVarChar 100	No	No	No	Yes
62		AnyNumber11		NVarChar 100	No	No	No	Yes
63		AnyNumber12		NVarChar 100	No	No	No	Yes
64		AnyNumber13		NVarChar 100	No	No	No	Yes
65		AnyNumber14		NVarChar 100	No	No	No	Yes
66		AnyNumber15		NVarChar 100	No	No	No	Yes

Indices

Index name	Columns	Unique	Descending	Clustered
IX_PackageDetailsPackageId	PackageId	No	No	No
IX_ PackageDetailsItemNumber	ItemNumber	No	No	No

Table ‘Packages’

Table Name	Package
Primary Key	PK_Package

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	No
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		ShipmentId		Integer	Yes	No	No	No
3		PackageId		Integer	Yes	No	No	Yes
4		ActualWeight		Float	Yes	No	No	No
5		BilledWeight		Float	Yes	No	No	No
6		ExpectedWeight		Float	Yes	No	No	No
7		PackageType		Integer	Yes	No	No	Yes
8		Length		Float	Yes	No	No	No
9		Width		Float	Yes	No	No	No
10		Height		Float	Yes	No	No	No
11		DimUnits		NVarChar 50	No	No	No	No
12		DimWeightUsed		Bit	Yes	No	No	No
13		UOM		NVarChar 50	Yes	No	No	Yes
14		DeliveryDay		NVarChar 50	Yes	No	No	Yes
15		DeliveryDate		Datetime	Yes	No	No	No
16		RoutingCode		NVarChar 50	Yes	No	No	Yes
17		SpecialServices		NVarChar 100	Yes	No	No	No
18		TrackingNumber		NVarChar 50	Yes	No	No	Yes
19		DiscountedBaseFreight		Money	Yes	No	No	No
20		DiscountedSpecialServices		Money	Yes	No	No	No
21		DiscountedTotalFreight		Money	Yes	No	No	No
22		PublishedBaseFreight		Money	Yes	No	No	No
23		PublishedSpecialServices		Money	Yes	No	No	No
24		PublishedTotalFreight		Money	Yes	No	No	No
25		CustomerBaseFreight		Money	Yes	No	No	No
26		CustomerSpecialServices		Money	Yes	No	No	No
27		CustomerTotalFreight		Money	Yes	No	No	No
28		DeclaredValue		Money	Yes	No	No	No
29		LabelType		Integer	Yes	No	No	Yes
30		LabelData		Text	Yes	No	No	Yes
31		CartonType		NVarChar 50	Yes	No	No	No
32		REId		NVarChar 50	Yes	No	No	No
33		AnyText1		NVarChar 255	Yes	No	No	No
34		AnyText2		NVarChar 255	Yes	No	No	No
35		AnyText3		NVarChar 255	Yes	No	No	No
36		AnyText4		NVarChar 255	Yes	No	No	No
37		AnyText5		NVarChar 255	Yes	No	No	No
38		ErrorNumber		Integer	Yes	No	No	No
39		ErrorMessage		NVarChar 100	Yes	No	No	No
40		DeleteFlag		Bit	Yes	No	No	No
41		RecordTimeStamp		Timestamp	Yes	No	No	No
42		UpdateDateTime		Datetime	Yes	No	No	No
43		LastUsedBy		NVarChar 50	Yes	No	No	Yes
44		FXBCRevenueData		NVarChar 50	Yes	No	No	Yes
45		FXAirportCode		NVarChar 50	Yes	No	No	Yes
46		FXServiceCommitment		NVarChar 50	Yes	No	No	Yes
47		FXCODTrack		NVarChar 50	Yes	No	No	Yes
48		FXBCASTRA		NVarChar 50	Yes	No	No	Yes
49		FXRoutingCode		NVarChar 50	Yes	No	No	Yes
50		FXCODASTRA		NVarChar 50	Yes	No	No	Yes
51		PackageOrder		Integer	Yes	No	No	Yes
52		FXPDF417BC		NVarChar 150	Yes	No	No	Yes
53		FXUCCEANBC		NVarChar 50	Yes	No	No	Yes
54		UCC128		NVarChar 50	Yes	No	No	No
55		CustomLabelData		Text	Yes	No	No	Yes
56		LTLClass		NVarChar 50	Yes	No	No	Yes
57		CODAmount		NVarChar 50	Yes	No	No	Yes
58		ShipperId		Integer	Yes	No	No	Yes
59		BillAsPubBaseFreight		Money	Yes	No	No	Yes
60		BillAsPubSpecialServices		Money	Yes	No	No	Yes
61		BillAsPubTotalFreight		Money	Yes	No	No	Yes
62		BillAsDisBaseFreight		Money	Yes	No	No	Yes
63		BillAsDisSpecialServices		Money	Yes	No	No	Yes
64		BillAsDisTotalFreight		Money	Yes	No	No	Yes
65		ClientShipDateTime		NVarChar 50	Yes	No	No	Yes
66		CustomFreightDetails		NVarChar 50	Yes	No	No	Yes
67		NMFCCode		NVarChar 50	Yes	No	No	Yes
68		PackShipped		Integer	No	No	No	Yes
69		RMANumber		NVarChar 10	No	No	No	Yes
70		ReturnEmail		NVarChar 50	No	No	No	Yes
71		Descriptions		NVarChar 250	No	No	No	Yes
72		ReturnMethod		Integer	Yes	No	No	Yes
73		AnyText6		NVarChar 255	No	No	No	Yes
74		AnyText7		NVarChar 255	No	No	No	Yes
75		AnyText8		NVarChar 255	No	No	No	Yes
76		AnyText9		NVarChar 255	No	No	No	Yes
77		AnyText10		NVarChar 255	No	No	No	Yes
78		AnyText11		NVarChar 255	No	No	No	Yes
79		AnyText12		NVarChar 255	No	No	No	Yes
80		AnyText13		NVarChar 255	No	No	No	Yes
81		AnyText14		NVarChar 255	No	No	No	Yes
82		AnyText15		NVarChar 255	No	No	No	Yes
83		AnyNumber1		NVarChar 100	No	No	No	Yes
84		AnyNumber2		NVarChar 100	No	No	No	Yes
85		AnyNumber3		NVarChar 100	No	No	No	Yes
86		AnyNumber4		NVarChar 100	No	No	No	Yes
87		AnyNumber5		NVarChar 100	No	No	No	Yes
88		AnyNumber6		NVarChar 100	No	No	No	Yes
89		AnyNumber7		NVarChar 100	No	No	No	Yes
90		AnyNumber8		NVarChar 100	No	No	No	Yes
91		AnyNumber9		NVarChar 100	No	No	No	Yes
92		AnyNumber10		NVarChar 100	No	No	No	Yes
93		AnyNumber11		NVarChar 100	No	No	No	Yes
94		AnyNumber12		NVarChar 100	No	No	No	Yes
95		AnyNumber13		NVarChar 100	No	No	No	Yes
96		AnyNumber14		NVarChar 100	No	No	No	Yes
97		AnyNumber15		NVarChar 100	No	No	No	Yes
98		StationName		NVarChar 50	No	No	No	Yes

Indices

Index name	Columns	Unique	Descending	Clustered
IX_PackageShipmentId	ShipmentId	No	No	No
IX_ PackagesPackageId	PackageId	No	No	No
IX_ PackagesTrackingNumber	TrackingNumber	No	No	No
CS_Update	PackageType, REId	No	No	No

Table ‘ReturnAddress’

Table Name	ReturnAddress
Primary Key	PK_ReturnAddress

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	Yes	No	No
2		ShipmentId		Integer	Yes	No	No	No
3		RICompanyName		NVarChar 50	No	No	No	No
4		RIContact		NVarChar 50	No	No	No	No
5		RIAddress1		NVarChar 50	No	No	No	No
6		RIAddress2		NVarChar 50	No	No	No	No
7		RICity		NVarChar 40	No	No	No	No
8		RIState		NVarChar 40	No	No	No	No
9		RIZip		NVarChar 10	No	No	No	No
10		RIPhone		NVarChar 24	No	No	No	No
11		RICountry		NVarChar 4	No	No	No	No
12		RIType		Integer	Yes	No	No	Yes(0)
13		DeleteFlag	Flag	Bit	Yes	No	No	No

Table ‘Services’

Table Name	Services
Primary Key	PK_Services

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		HeaderId		Integer	Yes	No	No	No
3		Code		NVarChar 50	Yes	No	No	No
4		Description		NVarChar 100	Yes	No	No	No
5		CarrierId		Integer	Yes	No	No	No
6		SpecialServGroup		NVarChar 250	Yes	No	No	No
7		Enabled		Integer	Yes	No	No	No
8		Custom		Integer	Yes	No	No	No
9		DaysInTransit		Integer	Yes	No	No	Yes
10		ServiceScope		Integer	Yes	No	No	Yes
11		DeleteFlag		Integer	Yes	No	No	No

Table ‘Shipments’

Table Name	Shipments
Primary Key	PK_Shipments

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	No
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		OrganizationId		Integer	Yes	No	No	No
3		SiteId		Integer	Yes	No	No	No
4		ShipmentType		Integer	Yes	No	No	No
5		ShipmentSource		Integer	Yes	No	No	No
6		DateProcessed		Datetime	Yes	No	No	No
7		Company		NVarChar 50	Yes	No	No	No
8		Contact		NVarChar 50	Yes	No	No	No
9		Address1		NVarChar 50	Yes	No	No	No
10		Address2		NVarChar 50	Yes	No	No	No
11		Address3		NVarChar 50	Yes	No	No	No
12		City		NVarChar 40	Yes	No	No	No
13		State		NVarChar 40	Yes	No	No	No
14		Zip		NVarChar 10	Yes	No	No	No
15		Country		NVarChar 4	Yes	No	No	No
16		Phone		NVarChar 24	Yes	No	No	No
17		Fax		NVarChar 24	Yes	No	No	No
18		Email		NVarChar 250	Yes	No	No	No
19		TrackingNumber		NVarChar 50	Yes	No	No	No
20		PurchaseOrder		NVarChar 30	Yes	No	No	No
21		InvoiceNumber		NVarChar 30	Yes	No	No	No
22		ShipVia		Integer	Yes	No	No	No
23		CarrierId		Integer	Yes	No	No	No
24		ServiceId		Integer	Yes	No	No	No
25		Department		NVarChar 50	Yes	No	No	No
26		CurrencyType		NVarChar 3	Yes	No	No	No
27		PaymentType		NVarChar 1	Yes	No	No	Yes
28		DeclaredValue		Money	Yes	No	No	No
29		AccountNumber		NVarChar 20	Yes	No	No	No
30		DiscountedBaseFreight		Money	Yes	No	No	No
31		DiscountedSpecialServices		Money	Yes	No	No	No
32		DiscountedTotalFreight		Money	Yes	No	No	No
33		PublishedBaseFreight		Money	Yes	No	No	No
34		PublishedSpecialServices		Money	Yes	No	No	No
35		PublishedTotalFreight		Money	Yes	No	No	No
36		CustomerBaseFreight		Money	Yes	No	No	No
37		CustomerSpecialServices		Money	Yes	No	No	No
38		CustomerTotalFreight		Money	Yes	No	No	No
39		Serverid		Integer	Yes	No	No	No
40		ClientId		Integer	Yes	No	No	No
41		UserId		Integer	Yes	No	No	No
42		Manifested		Integer	Yes	No	No	No
43		PackageCount		Integer	Yes	No	No	No
44		ExpectedPackageCount		Integer	Yes	No	No	No
45		AnyText1		NVarChar 255	Yes	No	No	No
46		AnyText2		NVarChar 255	Yes	No	No	No
47		AnyText3		NVarChar 255	Yes	No	No	No
48		AnyText4		NVarChar 255	Yes	No	No	No
49		AnyText5		NVarChar 255	Yes	No	No	No
50		DeleteFlag		Bit	Yes	No	No	No
51		RecordTimeStamp		Timestamp	Yes	No	No	No
52		UpdatedateTime		Datetime	Yes	No	No	No
53		LastUsedBy		NVarChar 30	Yes	No	No	No
54		CIFlag		Bit	No	No	No	No
55		CIFreightChargeValue		Money	Yes	No	No	Yes
56		CIOtherCharge		Money	Yes	No	No	Yes
57		CIInsuranceCharge		Money	Yes	No	No	Yes
58		CICommentLine1		NVarChar 74	Yes	No	No	Yes
59		CICommentLine2		NVarChar 74	Yes	No	No	Yes
60		DutyTaxPaymentType		Integer	Yes	No	No	Yes
61		DutyTaxPaymentAccountNumber		NVarChar 20	Yes	No	No	Yes
62		DocumentShipmentFlag		Bit	No	No	No	No
63		AESFilingStatus		NVarChar 1	Yes	No	No	Yes
64		TermOfSale		Integer	Yes	No	No	Yes
65		MiscChargeType		Integer	Yes	No	No	Yes
66		BSOFlag		Bit	No	No	No	No
67		BrokerAccountNumber		NVarChar 10	Yes	No	No	Yes
68		BrokerId		NVarChar 15	Yes	No	No	Yes
69		BrokerCompany		NVarChar 35	Yes	No	No	Yes
70		BrokerContact		NVarChar 30	Yes	No	No	Yes
71		BrokerAddress1		NVarChar 30	Yes	No	No	Yes
72		BrokerAddress2		NVarChar 30	Yes	No	No	Yes
73		BrokerCity		NVarChar 20	Yes	No	No	Yes
74		BrokerState		NVarChar 14	Yes	No	No	Yes
75		BrokerZip		NVarChar 10	Yes	No	No	Yes
76		BrokerCountry		NVarChar 2	Yes	No	No	Yes
77		BrokerPhone		NVarChar 15	Yes	No	No	Yes
78		BrokerEmail		NVarChar 250	Yes	No	No	Yes
79		BrokerFax		NVarChar 15	Yes	No	No	Yes
80		FXSED		NVarChar 50	Yes	No	No	Yes
81		HostLink1		NVarChar 100	Yes	No	No	No
82		HostLink2		NVarChar 100	Yes	No	No	No
83		HostLink3		NVarChar 100	Yes	No	No	No
84		HostLink4		NVarChar 100	Yes	No	No	No
85		HostLink5		NVarChar 100	Yes	No	No	No
86		ShipmentZone		NVarChar 10	Yes	No	No	No
87		BatchId		Integer	Yes	No	No	No
88		CustomerCode		NVarChar 30	Yes	No	No	No
89		Address4		NVarChar 50	Yes	No	No	Yes
90		IntCompany		NVarChar 50	Yes	No	No	Yes
91		IntContact		NVarChar 50	Yes	No	No	Yes
92		IntAddr1		NVarChar 50	Yes	No	No	Yes
93		IntAddr2		NVarChar 50	Yes	No	No	Yes
94		IntAddr3		NVarChar 50	Yes	No	No	Yes
95		IntAddr4		NVarChar 50	Yes	No	No	Yes
96		IntCity		NVarChar 40	Yes	No	No	Yes
97		IntState		NVarChar 40	Yes	No	No	Yes
98		IntZip		NVarChar 10	Yes	No	No	No
99		IntCountry		NVarChar 4	Yes	No	No	Yes
100		HostError		Integer	Yes	No	No	Yes
101		TotalCODAmount		Money	Yes	No	No	Yes
102		BillAsPubBaseFreight		Money	Yes	No	No	Yes
103		BillAsPubSpecialServices		Money	Yes	No	No	Yes
104		BillAsPubTotalFreight		Money	Yes	No	No	Yes
105		BillAsDisBaseFreight		Money	Yes	No	No	Yes
106		BillAsDisSpecialServices		Money	Yes	No	No	Yes
107		BillAsDisTotalFreight		Money	Yes	No	No	Yes
108		BillAsId		Integer	Yes	No	No	Yes
109		ShipmentIntegrity		NVarChar 50	Yes	No	No	Yes
110		ReferenceNumber		NVarChar 50	Yes	No	No	Yes
111		ConsolidationId		Integer	Yes	No	No	Yes
112		XTNSuffix		NVarChar 50	Yes	No	No	Yes
113		FTSRExemption		NVarChar 50	Yes	No	No	Yes
114		RelatedParties		Integer	Yes	No	No	Yes
115		NeutralDelivery		Integer	Yes	No	No	Yes
116		ShipWith		NVarChar 30	Yes	No	No	Yes
117		SWOSGroupId		Integer	Yes	No	No	Yes
118		Origin		NVarChar 10	Yes	No	No	Yes
119		Destination		NVarChar 10	Yes	No	No	Yes
120		DecValCurrency		NVarChar 20	Yes	No	No	Yes
121		RequesterId		Integer	Yes	No	No	Yes
122		WorldEaseFlag		Integer	Yes	No	No	Yes
123		WorldEaseId		Integer	Yes	No	No	Yes
124		WorldEaseEUFlag		Integer	Yes	No	No	Yes
125		AddressCheck		Integer	Yes	No	No	Yes
126		UPSPaperLessInvoice		Integer	No	No	No	Yes
127		UPSHardCopyDocFlag		Integer	No	No	No	Yes
128		SplitDutyTax		Integer	Yes	No	No	Yes
129		ExportReason		NVarChar 50	No	No	No	Yes
130		BestWayViaId		Integer	No	No	No	Yes
131		AnyText6		NVarChar 255	No	No	No	Yes
132		AnyText7		NVarChar 255	No	No	No	Yes
133		AnyText8		NVarChar 255	No	No	No	Yes
134		AnyText9		NVarChar 255	No	No	No	Yes
135		AnyText10		NVarChar 255	No	No	No	Yes
136		AnyText11		NVarChar 255	No	No	No	Yes
137		AnyText12		NVarChar 255	No	No	No	Yes
138		AnyText13		NVarChar 255	No	No	No	Yes
139		AnyText14		NVarChar 255	No	No	No	Yes
140		AnyText15		NVarChar 255	No	No	No	Yes
141		AnyNumber1		NVarChar 100	No	No	No	Yes
142		AnyNumber2		NVarChar 100	No	No	No	Yes
143		AnyNumber3		NVarChar 100	No	No	No	Yes
144		AnyNumber4		NVarChar 100	No	No	No	Yes
145		AnyNumber5		NVarChar 100	No	No	No	Yes
146		AnyNumber6		NVarChar 100	No	No	No	Yes
147		AnyNumber7		NVarChar 100	No	No	No	Yes
148		AnyNumber8		NVarChar 100	No	No	No	Yes
149		AnyNumber90		NVarChar 100	No	No	No	Yes
150		AnyNumber1		NVarChar 100	No	No	No	Yes
151		AnyNumber11		NVarChar 100	No	No	No	Yes
152		AnyNumber12		NVarChar 100	No	No	No	Yes
153		AnyNumber13		NVarChar 100	No	No	No	Yes
154		AnyNumber14		NVarChar 100	No	No	No	Yes
155		AnyNumber15		NVarChar 100	No	No	No	Yes
156		ConsigneeTaxId		NVarChar 10	No	No	No	Yes

Indices

Index name	Columns	Unique	Descending	Clustered
IX_ShipmentsCompany	OrganizationId	No	No	No
IX_ ShipmentsInvoiceNumber	InvoiceNumber	No	No	No
IX_ ManifestId	ManifestId	No	No	No
Xi_WorldEase	ManifestId, PackageCount, WorldEaseFlag, WorldEaseId	No	No	No

Table ‘ShipVias’

Table Name	ShipVias
Primary Key	PK_ShipVias

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		XRefGroupId		Integer	Yes	No	No	No
3		CarrierId		Integer	Yes	No	No	No
4		Code		NVarChar 20	Yes	No	No	No
5		Description		NVarChar 100	Yes	No	No	No
6		Service		NVarChar 50	Yes	No	No	No
7		SpecialService		NVarChar 20	Yes	No	No	No
8		PaymentType		Integer	Yes	No	No	No
9		Enabled		Bit	Yes	No	No	No
10		DeleteFlag		Bit	Yes	No	No	No
11		RecordTimeStamp		Binary 8	No	No	No	No
12		UpdateDateTime		Datetime	Yes	No	No	No
13		LastUsedBy		NVarChar 30	Yes	No	No	No
14		PrintIIL		Integer	Yes	No	No	No
15		ShipViaType		Integer	Yes	No	No	No
16		BillAsId		Integer	Yes	No	No	Yes
17		ShipmentWeight		Float	Yes	No	No	Yes
18		Rate		Integer	Yes	No	No	Yes
19		BillDutyTaxToType		Integer	Yes	No	No	Yes(2)

Indices

Index name	Columns	Unique	Descending	Clustered
IX_Code	Code, DeleteFlag	No	No	No

Table ‘Sites’

Table Name	Sites
Primary Key	PK_Sites

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		CrossReference		NVarChar 50	Yes	No	No	No
3		CompanyName		NVarChar 50	Yes	No	No	No
4		Contact		NVarChar 50	Yes	No	No	No
5		Address1		NVarChar 50	Yes	No	No	No
6		Address2		NVarChar 50	Yes	No	No	No
7		Address3		NVarChar 50	Yes	No	No	No
8		City		NVarChar 50	Yes	No	No	No
9		State		NVarChar 10	Yes	No	No	No
10		Zip		NVarChar 10	Yes	No	No	No
11		Country		NVarChar 4	Yes	No	No	No
12		Email		NVarChar 50	Yes	No	No	No
13		Phone		NVarChar 20	No	No	No	NO
14		Fax		NVarChar 20	Yes	No	No	NO
15		DeleteFlag		Bit	Yes	No	No	NO
16		RecordTimeStamp		Timestamp	Yes	No	No	NO
17		UpdateDateTime		Datetime	Yes	No	No	Yes
18		LastUsedBy		NVarChar 30	Yes	No	No	Yes
19		GMTTime		Float	Yes	No	No	Yes
20		CurrencyCode		NChar 3	Yes	No	No	Yes
21		Enabled		Integer	Yes	No	No	Yes
22		Tier		Integer	Yes	Yes	No	No

Table ‘Users’

Table Name	Users
Primary Key	PK_Users

User-defined variables

Name	Value
Owner	dbo
Non-clustered primary key	no
Primary key fill factor
Filegroup for Table
Filegroup for Primary Key
Text Filegroup for Table (TEXTIMAGE_ON)

Primary key origin

Column Name	Type	Parent Table
Id	PK	Unique to this table

Columns

	Key	Column Name	Domain	Data Type	Not Null	Unique	Check	Default
1	PK	Id		Integer	Yes	No	No	No
2		Code		NVarChar 30	Yes	No	No	No
3		Password		NVarChar 30	Yes	No	No	No
4		UserName		NVarChar 30	Yes	No	No	No
5		Enabled		Bit	Yes	No	No	No
6		EmailAddress		NVarChar 100	Yes	No	No	No
7		ChangePasswordFlag		Bit	Yes	No	No	No
8		UserGroupId		Integer	Yes	No	No	No
9		DepartmentId		Integer	Yes	No	No	No
10		HomePageId		Integer	Yes	No	No	No
11		ShipViaId		Integer	Yes	No	No	No
12		OrgId		Integer	Yes	No	No	Yes
13		AnyText1		NVarChar 100	No	No	No	No
14		AnyText2		NVarChar 100	Yes	No	No	No
15		AnyText3		NVarChar 100	Yes	No	No	No
16		AnyText4		NVarChar 100	Yes	No	No	No
17		AnyText5		NVarChar 100	Yes	No	No	No
18		LastLogonDateTime		DateTime	Yes	No	No	No
19		RecordTimeStamp		TimeStamp	Yes	No	No	No
20		DeleteFlag		Bit	Yes	No	No	No
21		UpdateDateTime		DateTime	Yes	No	No	No
22		LastUsedBy		Integer	Yes	No	No	No
23		UserTitle		NVarChar 50	Yes	No	No	Yes
24		Phone		NVarChar 20	Yes	No	No	Yes
25		OfficeLocation		NVarChar 50	Yes	No	No	Yes
26		LastPasswordChanged		DateTime	Yes	No	No	Yes
27		UserEnabled		Integer	Yes	No	No	Yes
28		Agreed		Integer	Yes	No	No	No
29		UserType		Integer	Yes	No	No	No

Indices

Index name	Columns	Unique	Descending	Clustered
IX_Users	Code	No	No	No