[Info]
FieldCount=8
FormCaption=Field Selector - Trace View
Version=2
SortColumn=0
SortDirection=ASC
[Field0]
SectionNum=0
FieldID=shi_ID
UserText=shi_ID
Selected=0
IndexField=1
Order=0
Width=281
[Field1]
SectionNum=1
FieldID=shi_number
UserText=shi_number
Selected=1
IndexField=0
Order=1
Width=176
[Field2]
SectionNum=2
FieldID=sub_name
UserText=sub_name
Selected=1
IndexField=0
Order=2
Width=176
[Field3]
SectionNum=3
FieldID=car_fullName
UserText=car_fullName
Selected=1
IndexField=0
Order=3
Width=176
[Field4]
SectionNum=4
FieldID=Status
UserText=Status
Selected=1
IndexField=0
Order=4
Width=168
[Field5]
SectionNum=5
FieldID=StatusDate
UserText=StatusDate
Selected=1
IndexField=0
Order=5
Width=184
[Field6]
SectionNum=6
FieldID=CarrierStatus
UserText=CarrierStatus
Selected=1
IndexField=0
Order=6
Width=185
[Field7]
SectionNum=7
FieldID=Location
UserText=Location
Selected=1
IndexField=0
Order=7
Width=184
[Query]
Select=SELECT DISTINCT shi_ID, shi_number, sub_name, car_fullName, Status, StatusDate, CarrierStatus, Location
From=FROM Shipment INNER JOIN fnFilterTraceView($$ACTORID$$) ON shi_ID_Filter = shi_ID LEFT OUTER JOIN dbo.fnTraceViewStatus() on shi_ID=shs_fk_shi LEFT OUTER JOIN dbo.fnTraceViewStatusCarrier() on csm_fk_shi=shs_fk_shi LEFT OUTER JOIN Stack  ON shi_fk_sta = sta_ID LEFT OUTER JOIN Actor  ON sta_fk_act = act_ID LEFT OUTER JOIN Subcarrier ON sta_fk_sub=Subcarrier.sub_ID LEFT OUTER JOIN Carrier ON Subcarrier.sub_fk_car=Carrier.car_ID
Where=
Values=