[Info]
FieldCount=59
FormCaption=Field Selector - Freetext Search
Version=11
SortColumn=0
SortDirection=ASC

[Field0]
SectionNum=0
FieldID=Shipment.shi_ID
UserText=Shipment.shi_ID
Selected=0
IndexField=1
Order=0
Width=80
SortIndex=-1
SortOrder=0

[Field1]
SectionNum=1
FieldID=sub_ID
UserText=Subcarrier ID
Selected=0
IndexField=0
Order=1
Width=25

[Field2]
SectionNum=2
FieldID=name1_receiver
UserText=Name1 Receiver
Selected=1
IndexField=0
Order=3
Width=107
SortIndex=-1
SortOrder=0

[Field3]
SectionNum=3
FieldID=name2_Receiver
UserText=Name2 Receiver
Selected=0
IndexField=0
Order=3
Width=25

[Field4]
SectionNum=4
FieldID=postCode_receiver
UserText=PostNo Receiver
Selected=1
IndexField=0
Order=5
Width=41
SortIndex=-1
SortOrder=0

[Field5]
SectionNum=5
FieldID=streetAddress1_receiver
UserText=Address1 Receiver
Selected=1
IndexField=0
Order=4
Width=130
SortIndex=-1
SortOrder=0

[Field6]
SectionNum=6
FieldID=streetaddress2_Receiver
UserText=Address2 Receiver
Selected=0
IndexField=0
Order=6
Width=25

[Field7]
SectionNum=7
FieldID=city_receiver
UserText=City Receiver
Selected=1
IndexField=0
Order=6
Width=77
SortIndex=-1
SortOrder=0

[Field8]
SectionNum=8
FieldID=phone_Receiver
UserText=Phone Receiver
Selected=0
IndexField=0
Order=8
Width=25

[Field9]
SectionNum=9
FieldID=fax_Receiver
UserText=Fax Receiver
Selected=0
IndexField=0
Order=9
Width=25

[Field10]
SectionNum=10
FieldID=mobile_Receiver
UserText=Mobile Receiver
Selected=0
IndexField=0
Order=10
Width=25

[Field11]
SectionNum=11
FieldID=email_Receiver
UserText=Email Receiver
Selected=0
IndexField=0
Order=11
Width=25

[Field12]
SectionNum=12
FieldID=refAttention
UserText=Attention
Selected=0
IndexField=0
Order=12
Width=200

[Field13]
SectionNum=13
FieldID=refReceiverReference
UserText=Receivers Reference
Selected=0
IndexField=0
Order=13
Width=25

[Field14]
SectionNum=14
FieldID=refReceiverCustNoSender
UserText=Receivers Customer No at Sender
Selected=0
IndexField=0
Order=14
Width=25

[Field15]
SectionNum=15
FieldID=refReceiverCustNoCarrier
UserText=Receivers Customer No at Carrier
Selected=0
IndexField=0
Order=15
Width=25

[Field16]
SectionNum=16
FieldID=refSenderReference
UserText=Senders Reference
Selected=0
IndexField=0
Order=16
Width=25

[Field17]
SectionNum=17
FieldID=sea_name1
UserText=Name1 Sender
Selected=0
IndexField=0
Order=17
Width=25

[Field18]
SectionNum=18
FieldID=sea_name2
UserText=Name2 Sender
Selected=0
IndexField=0
Order=18
Width=25

[Field19]
SectionNum=19
FieldID=sea_postCode
UserText=PostNo Sender
Selected=0
IndexField=0
Order=19
Width=25

[Field20]
SectionNum=20
FieldID=sea_streetAddress1
UserText=Address1 Sender
Selected=0
IndexField=0
Order=20
Width=25

[Field21]
SectionNum=21
FieldID=sea_streetAddress2
UserText=Address2 Sender
Selected=0
IndexField=0
Order=21
Width=25

[Field22]
SectionNum=22
FieldID=sea_city
UserText=City Sender
Selected=0
IndexField=0
Order=22
Width=25

[Field23]
SectionNum=23
FieldID=sea_phone
UserText=Phone Sender
Selected=0
IndexField=0
Order=23
Width=25

[Field24]
SectionNum=24
FieldID=sea_fax
UserText=Fax Sender
Selected=0
IndexField=0
Order=24
Width=25

[Field25]
SectionNum=25
FieldID=sea_mobile
UserText=Mobile Sender
Selected=0
IndexField=0
Order=25
Width=25

[Field26]
SectionNum=26
FieldID=sea_email
UserText=Email Sender
Selected=0
IndexField=0
Order=26
Width=25

[Field27]
SectionNum=27
FieldID=erpref_receiver
UserText=Customer No
Selected=0
IndexField=0
Order=27
Width=100

[Field28]
SectionNum=28
FieldID=SumShipmentVolume
UserText=Volume (mm3) Shipment
Selected=0
IndexField=0
Order=28
Width=25

[Field29]
SectionNum=29
FieldID=SumShipmentWeight
UserText=Weight (g) Shipment
Selected=0
IndexField=0
Order=29
Width=25

[Field30]
SectionNum=30
FieldID=pro_name
UserText=Product
Selected=1
IndexField=0
Order=8
Width=159
SortIndex=-1
SortOrder=0

[Field31]
SectionNum=31
FieldID=act_name
UserText=Actor
Selected=0
IndexField=0
Order=9
Width=54
SortIndex=-1
SortOrder=0

[Field32]
SectionNum=32
FieldID=shi_datePickup
UserText=Pickup Date
Selected=0
IndexField=0
Order=32
Width=25

[Field33]
SectionNum=33
FieldID=shi_dateLabelPrint
UserText=Label Print Date
Selected=0
IndexField=0
Order=33
Width=25

[Field34]
SectionNum=34
FieldID=shi_dateTransmit
UserText=Transmit Date
Selected=1
IndexField=0
Order=2
Width=115
SortIndex=-1
SortOrder=0

[Field35]
SectionNum=35
FieldID=shi_dateImported
UserText=Import Date
Selected=0
IndexField=0
Order=35
Width=25

[Field36]
SectionNum=36
FieldID=number_Price1
UserText=Price 1
Selected=0
IndexField=0
Order=9
Width=23
SortIndex=-1
SortOrder=0

[Field37]
SectionNum=37
FieldID=number_Price2
UserText=Price 2
Selected=0
IndexField=0
Order=37
Width=25

[Field38]
SectionNum=38
FieldID=number_Price3
UserText=Price 3
Selected=0
IndexField=0
Order=38
Width=25

[Field39]
SectionNum=39
FieldID=number_CODAmount
UserText=Amount COD
Selected=0
IndexField=0
Order=39
Width=25

[Field40]
SectionNum=40
FieldID=number_InsuranceValue
UserText=Amount Insurance
Selected=0
IndexField=0
Order=40
Width=25

[Field41]
SectionNum=41
FieldID=refKID
UserText=KID
Selected=0
IndexField=0
Order=41
Width=25

[Field42]
SectionNum=42
FieldID=refProjectName
UserText=Project Name
Selected=0
IndexField=0
Order=42
Width=25

[Field43]
SectionNum=43
FieldID=FirstGoodsType
UserText=First Goods Type
Selected=0
IndexField=0
Order=43
Width=25

[Field44]
SectionNum=44
FieldID=shi_ref_SenderAccountNumber
UserText=Senders Account Number
Selected=0
IndexField=0
Order=44
Width=25

[Field45]
SectionNum=45
FieldID=shi_number
UserText=Number Shipment
Selected=0
IndexField=0
Order=45
Width=25

[Field46]
SectionNum=46
FieldID=sub_name
UserText=Subcarrier
Selected=0
IndexField=0
Order=8
Width=76
SortIndex=-1
SortOrder=0

[Field47]
SectionNum=47
FieldID=car_fullName
UserText=Carrier
Selected=1
IndexField=0
Order=7
Width=114
SortIndex=0
SortOrder=2

[Field48]
SectionNum=48
FieldID=shi_ref_OrderNumber
UserText=Ordernumber
Selected=1
IndexField=0
Order=1
Width=89
SortIndex=-1
SortOrder=0

[Field49]
SectionNum=49
FieldID=countryIsoA2_receiver
UserText=Country Receiver
Selected=0
IndexField=0
Order=50
Width=90

[Field50]
SectionNum=50
FieldID=shi_ref_Operator
UserText=Operator
Selected=0
IndexField=0
Order=50
Width=90

[Field51]
SectionNum=51
FieldID=FirstPackageNum
UserText=FirstPackageNum
Selected=0
IndexField=0
Order=51
Width=90

[Field52]
SectionNum=52
FieldID=number_FixedPrice
UserText=Fixed Price
Selected=0
IndexField=0
Order=52
Width=25

[Field53]
SectionNum=53
FieldID=shi_dateSubmitted
UserText=Submit Date
Selected=0
IndexField=0
Order=53
Width=25

[Field54]
SectionNum=54
FieldID=case isnull(shi_fk_bat_prebook, 0) when 0 then 'No' else 'Yes' end as prebooked
UserText=Prebooked
Selected=0
IndexField=0
Order=54
Width=61
SortIndex=-1
SortOrder=0

[Field55]
SectionNum=55
FieldID=dbo.fnGetShipmentLocation(Shipment.shi_ID)
UserText=Shipment location
Selected=0
IndexField=0
Order=54
Width=100
SortIndex=-1
SortOrder=0

[Field56]
SectionNum=56
FieldID=dbo.fnGetServiceNameList(Shipment.shi_ID) as services
UserText=Services
Selected=0
IndexField=0
Order=56
Width=255
SortIndex=-1
SortOrder=0

[Field57]
SectionNum=57
FieldID=ReceiverMessage
UserText=Receiver message
Selected=0
IndexField=0
Order=57
Width=100
SortIndex=-1
SortOrder=0

[Field58]
SectionNum=58
FieldID=SumShipmentLoadmeter
UserText=Loadmeter (m) Shipment
Selected=0
IndexField=0
Order=58
Width=100
SortIndex=-1
SortOrder=0

[Query]
Select=SELECT DISTINCT Shipment.shi_ID, name1_receiver, postCode_receiver, streetAddress1_receiver, city_receiver, pro_name, shi_dateTransmit, car_fullName, shi_ref_OrderNumber
From=FROM Shipment INNER JOIN fnTextSearch($$01$$) ts ON ts.shi_ID=Shipment.shi_ID LEFT JOIN Product ON Shipment.shi_fk_pro = Product.pro_ID  LEFT JOIN Subcarrier ON Product.pro_fk_sub = Subcarrier.sub_ID  LEFT JOIN Carrier ON Subcarrier.sub_fk_car = Carrier.car_ID  LEFT JOIN Stack ON shi_fk_sta = sta_ID  LEFT JOIN Actor ON sta_fk_act = act_ID  LEFT JOIN Location ON act_fk_loc = loc_ID  LEFT JOIN vShipmentReferences ON vShipmentReferences.ref_fk_shi = Shipment.shi_ID LEFT JOIN vShipmentAmounts ON vShipmentAmounts.number_fk_shi = Shipment.shi_ID  LEFT JOIN vFullAddressReceivers ON shi_ID_receiver=Shipment.shi_ID LEFT JOIN SenderAddress ON shi_fk_sea=sea_ID LEFT JOIN vFirstGoodsType ON fgt_fk_shi=Shipment.shi_ID LEFT JOIN vSumWeightAndVolume ON swv_fk_shi=Shipment.shi_ID LEFT JOIN vFirstPackageNumber ON fpn_fk_shi=Shipment.shi_ID LEFT JOIN vShipmentMessages on vShipmentMessages.shm_fk_shi = Shipment.shi_ID LEFT JOIN vSumLoadmeter on vSumLoadmeter.slv_fk_shi = Shipment.shi_ID
Where=
Values=