[Info]
FieldCount=53
FormCaption=Field Selector - ComBack
Version=8
SortColumn=0
SortDirection=ASC
[Field0]
SectionNum=0
FieldID=shi_ID
UserText=ID Shipment
Selected=0
IndexField=1
Order=0
Width=25
SortOrder=0
SortIndex=-1
[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=0
IndexField=0
Order=2
Width=186
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=0
IndexField=0
Order=4
Width=51
SortIndex=-1
SortOrder=0
[Field5]
SectionNum=5
FieldID=streetaddress1_Receiver
UserText=Address1 Receiver
Selected=0
IndexField=0
Order=3
Width=138
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=0
IndexField=0
Order=5
Width=109
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=1
IndexField=0
Order=3
Width=135
SortIndex=-1
SortOrder=0
[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=1
IndexField=0
Order=5
Width=88
SortIndex=-1
SortOrder=0
[Field20]
SectionNum=20
FieldID=sea_streetAddress1
UserText=Address1 Sender
Selected=1
IndexField=0
Order=4
Width=128
SortIndex=-1
SortOrder=0
[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=1
IndexField=0
Order=6
Width=99
SortIndex=-1
SortOrder=0
[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=shi_carrierVolumeMM3
UserText=Volume (mm3) Shipment
Selected=0
IndexField=0
Order=28
Width=25
[Field29]
SectionNum=29
FieldID=shi_carrierWeightG
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=7
Width=133
SortIndex=-1
SortOrder=0
[Field31]
SectionNum=31
FieldID=act_name
UserText=Actor
Selected=0
IndexField=0
Order=31
Width=25
[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=81
SortIndex=0
SortOrder=1
[Field35]
SectionNum=36
FieldID=number_Price1
UserText=Price 1
Selected=0
IndexField=0
Order=36
Width=25
[Field36]
SectionNum=37
FieldID=number_Price2
UserText=Price 2
Selected=0
IndexField=0
Order=37
Width=25
[Field37]
SectionNum=38
FieldID=number_Price3
UserText=Price 3
Selected=0
IndexField=0
Order=38
Width=25
[Field38]
SectionNum=39
FieldID=number_CODAmount
UserText=Amount COD
Selected=0
IndexField=0
Order=39
Width=25
[Field39]
SectionNum=40
FieldID=number_InsuranceValue
UserText=Amount Insurance
Selected=0
IndexField=0
Order=40
Width=25
[Field40]
SectionNum=41
FieldID=refKID
UserText=KID
Selected=0
IndexField=0
Order=41
Width=25
[Field41]
SectionNum=42
FieldID=refProjectName
UserText=Project Name
Selected=0
IndexField=0
Order=42
Width=25
[Field42]
SectionNum=43
FieldID=refGoodsKind
UserText=Goods Kind
Selected=0
IndexField=0
Order=43
Width=25
[Field43]
SectionNum=44
FieldID=shi_ref_SenderAccountNumber
UserText=Senders Account Number
Selected=0
IndexField=0
Order=44
Width=25
[Field44]
SectionNum=45
FieldID=shi_number
UserText=Number Shipment
Selected=0
IndexField=0
Order=45
Width=25
[Field45]
SectionNum=46
FieldID=sub_name
UserText=SubCarrier
Selected=0
IndexField=0
Order=8
Width=64
SortIndex=-1
SortOrder=0
[Field46]
SectionNum=47
FieldID=car_fullName
UserText=Carrier
Selected=1
IndexField=0
Order=8
Width=87
SortIndex=-1
SortOrder=0
[Field47]
SectionNum=48
FieldID=shi_ref_OrderNumber
UserText=Ordernumber
Selected=1
IndexField=0
Order=1
Width=81
SortIndex=-1
SortOrder=0
[Field48]
SectionNum=49
FieldID=shi_dateImported
UserText=Import Date
Selected=0
IndexField=0
Order=46
Width=89
[Field49]
SectionNum=50
FieldID=countryIsoA2_receiver
UserText=Country Receiver 
Selected=0
IndexField=0
Order=50
Width=90
[Field50]
SectionNum=50
FieldID=countryIsoA2_receiver
UserText=countryIsoA2_receiver
Selected=0
IndexField=0
Order=50
Width=90
[Field51]
SectionNum=51
FieldID=number_FixedPrice
UserText=Fixed Price
Selected=0
IndexField=0
Order=51
Width=25
[Field52]
SectionNum=52
FieldID=dbo.fnGetServiceNameList(shi_ID) as services
UserText=Services
Selected=0
IndexField=0
Order=52
Width=255
SortIndex=-1
SortOrder=0
[Query]
Select=SELECT DISTINCT shi_ID, sea_name1, sea_postCode, sea_streetAddress1, sea_city, pro_name, shi_dateTransmit, car_fullName, shi_ref_OrderNumber
From=FROM Shipment INNER JOIN fnFilterComebackShipment('$$FROMDATE$$','$$TODATE$$', $$ACTORID$$) ON shi_ID_Filter = 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=shi_ID LEFT JOIN SenderAddress ON Shipment.shi_fk_sea = SenderAddress.sea_ID
Where=
Values=