[Info]
FieldCount=58
FormCaption=Field Selector - Outbox
Version=14
SortColumn=0
SortDirection=ASC
[Field0]
SectionNum=0
FieldID=shi_ID
UserText=ShipmentID
Selected=0
IndexField=1
Order=0
Width=25
SortOrder=0
SortIndex=-1
[Field1]
SectionNum=1
FieldID=sub_ID
UserText=SubCarrierID
Selected=0
IndexField=0
Order=1
Width=25
[Field2]
SectionNum=2
FieldID=name1_receiver
UserText=Name1_R
Selected=1
IndexField=0
Order=1
Width=200
SortIndex=-1
SortOrder=0
[Field3]
SectionNum=3
FieldID=name2_receiver
UserText=Name2_R
Selected=0
IndexField=0
Order=3
Width=25
[Field4]
SectionNum=4
FieldID=postCode_receiver
UserText=Postcode_R
Selected=1
IndexField=0
Order=3
Width=48
SortIndex=-1
SortOrder=0
[Field5]
SectionNum=5
FieldID=streetAddress1_receiver
UserText=Streetaddress1_R
Selected=1
IndexField=0
Order=2
Width=160
SortIndex=-1
SortOrder=0
[Field6]
SectionNum=6
FieldID=streetAddress2_receiver
UserText=Streetaddress2_R
Selected=0
IndexField=0
Order=6
Width=25
[Field7]
SectionNum=7
FieldID=city_receiver
UserText=City_R
Selected=1
IndexField=0
Order=4
Width=145
SortIndex=-1
SortOrder=0
[Field8]
SectionNum=8
FieldID=phone_receiver
UserText=Phone_R
Selected=0
IndexField=0
Order=8
Width=25
[Field9]
SectionNum=9
FieldID=fax_receiver
UserText=Fax_R
Selected=0
IndexField=0
Order=9
Width=25
[Field10]
SectionNum=10
FieldID=mobile_receiver
UserText=Mobile_R
Selected=0
IndexField=0
Order=10
Width=25
[Field11]
SectionNum=11
FieldID=eMail_receiver
UserText=Email_R
Selected=0
IndexField=0
Order=11
Width=25
[Field12]
SectionNum=12
FieldID=refAttention
UserText=Attention
Selected=0
IndexField=0
Order=12
Width=100
[Field13]
SectionNum=13
FieldID=refReceiverReference
UserText=Reference_R
Selected=0
IndexField=0
Order=13
Width=25
[Field14]
SectionNum=14
FieldID=refReceiverCustNoSender
UserText=CustNoSender_R
Selected=0
IndexField=0
Order=14
Width=25
[Field15]
SectionNum=15
FieldID=refReceiverCustNoCarrier
UserText=Receiver_CustNo_Carrier
Selected=0
IndexField=0
Order=15
Width=25
[Field16]
SectionNum=16
FieldID=refSenderReference
UserText=Sender_Reference
Selected=0
IndexField=0
Order=16
Width=25
[Field17]
SectionNum=17
FieldID=sea_name1
UserText=Name1_S
Selected=0
IndexField=0
Order=17
Width=25
[Field18]
SectionNum=18
FieldID=sea_name2
UserText=Name2_S
Selected=0
IndexField=0
Order=18
Width=25
[Field19]
SectionNum=19
FieldID=sea_postCode
UserText=Postcode_S
Selected=0
IndexField=0
Order=19
Width=25
[Field20]
SectionNum=20
FieldID=sea_streetAddress1
UserText=Streetaddress1_S
Selected=0
IndexField=0
Order=20
Width=25
[Field21]
SectionNum=21
FieldID=sea_streetAddress2
UserText=Streetaddress2_S
Selected=0
IndexField=0
Order=21
Width=25
[Field22]
SectionNum=22
FieldID=sea_city
UserText=City_S
Selected=0
IndexField=0
Order=22
Width=25
[Field23]
SectionNum=23
FieldID=sea_phone
UserText=Phone_S
Selected=0
IndexField=0
Order=23
Width=25
[Field24]
SectionNum=24
FieldID=sea_fax
UserText=Fax_S
Selected=0
IndexField=0
Order=24
Width=25
[Field25]
SectionNum=25
FieldID=sea_mobile
UserText=Mobile_S
Selected=0
IndexField=0
Order=25
Width=25
[Field26]
SectionNum=26
FieldID=sea_email
UserText=Email_S
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
Selected=0
IndexField=0
Order=28
Width=25
[Field29]
SectionNum=29
FieldID=SumShipmentWeight
UserText=Weight_G
Selected=0
IndexField=0
Order=29
Width=25
[Field30]
SectionNum=30
FieldID=pro_name
UserText=Product
Selected=1
IndexField=0
Order=5
Width=150
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
Selected=0
IndexField=0
Order=32
Width=25
[Field33]
SectionNum=33
FieldID=shi_dateLabelPrint
UserText=LabelPrint
Selected=0
IndexField=0
Order=33
Width=25
[Field34]
SectionNum=34
FieldID=shi_dateTransmit
UserText=Transmit
Selected=0
IndexField=0
Order=34
Width=25
[Field35]
SectionNum=35
FieldID=shi_dateImported
UserText=Import
Selected=0
IndexField=0
Order=35
Width=25
[Field36]
SectionNum=36
FieldID=number_Price1
UserText=Price1
Selected=0
IndexField=0
Order=36
Width=25
[Field37]
SectionNum=37
FieldID=number_Price2
UserText=Price2
Selected=0
IndexField=0
Order=37
Width=25
[Field38]
SectionNum=38
FieldID=number_Price3
UserText=Price3
Selected=0
IndexField=0
Order=38
Width=25
[Field39]
SectionNum=39
FieldID=number_CODAmount
UserText=COD_Amount
Selected=0
IndexField=0
Order=39
Width=25
[Field40]
SectionNum=40
FieldID=number_InsuranceValue
UserText=Insurance_Value
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=SenderAccountNumber
Selected=0
IndexField=0
Order=44
Width=25
[Field45]
SectionNum=45
FieldID=shi_number
UserText=Shipment_Num
Selected=0
IndexField=0
Order=45
Width=25
[Field46]
SectionNum=46
FieldID=sub_name
UserText=SubCarrier
Selected=0
IndexField=0
Order=46
Width=25
[Field47]
SectionNum=47
FieldID=car_fullName
UserText=Carrier
Selected=0
IndexField=0
Order=47
Width=25
[Field48]
SectionNum=48
FieldID=shi_ref_OrderNumber
UserText=OrderNumber
Selected=0
IndexField=0
Order=46
Width=89
[Field49]
SectionNum=49
FieldID=countryIsoA2_receiver
UserText=countryIsoA2_receiver
Selected=0
IndexField=0
Order=49
Width=90
[Field50]
SectionNum=50
FieldID=shi_ref_Operator
UserText=shi_ref_Operator
Selected=0
IndexField=0
Order=50
Width=90
[Field51]
SectionNum=51
FieldID=FirstPackageNum
UserText=First Package Num
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=ShipmentPackageCount
UserText=Package Count
Selected=0
IndexField=0
Order=53
Width=35
[Field54]
SectionNum=54
FieldID=shi_dateSubmitted
UserText=Submit Date
Selected=0
IndexField=0
Order=54
Width=40
SortIndex=-1
SortOrder=0
[Field55]
SectionNum=55
FieldID=case isnull(shi_fk_bat_prebook, 0) when 0 then 'No' else 'Yes' end as prebooked
UserText=Prebooked
Selected=0
IndexField=0
Order=55
Width=255
SortIndex=-1
SortOrder=0
[Field56]
SectionNum=56
FieldID=dbo.fnGetServiceNameList(shi_ID) as services
UserText=Services
Selected=0
IndexField=0
Order=56
Width=255
SortIndex=-1
SortOrder=0
[Field57]
SectionNum=57
FieldID=SumShipmentLoadmeter
UserText=Loadmeter (m) Shipment
Selected=0
IndexField=0
Order=57
Width=100
SortIndex=-1
SortOrder=0
[Query]
Select=SELECT DISTINCT shi_ID, name1_receiver, postCode_receiver, streetAddress1_receiver, city_receiver, pro_name
From=FROM Shipment INNER JOIN fnFilterOutbox() 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 LEFT JOIN vFirstGoodsType ON fgt_fk_shi=shi_ID LEFT JOIN vSumWeightAndVolume ON swv_fk_shi=shi_ID LEFT JOIN vFirstPackageNumber ON fpn_fk_shi=shi_ID LEFT JOIN vSumShipmentPacages ON ssp_fk_shi=shi_ID LEFT JOIN vSumLoadmeter on vSumLoadmeter.slv_fk_shi = Shipment.shi_ID
Where=
Values=sta_ID