[Info]
FieldCount=57
FormCaption=Field Selector - AutoPrint
Version=1
SortColumn=0
SortDirection=ASC
[Field0]
SectionNum=31
FieldID=act_name
UserText=Actor
Selected=0
IndexField=0
Order=31
Width=25
SortOrder=0
SortIndex=-1
[Field1]
SectionNum=5
FieldID=streetAddress1_receiver
UserText=Address1 Receiver
Selected=1
IndexField=0
Order=4
Width=194
SortIndex=-1
SortOrder=0
[Field2]
SectionNum=20
FieldID=sea_streetAddress1
UserText=Address1 Sender
Selected=0
IndexField=0
Order=20
Width=25
SortIndex=-1
SortOrder=0
[Field3]
SectionNum=6
FieldID=streetaddress2_Receiver
UserText=Address2 Receiver
Selected=0
IndexField=0
Order=6
Width=25
[Field4]
SectionNum=21
FieldID=sea_streetAddress2
UserText=Address2 Sender
Selected=0
IndexField=0
Order=21
Width=25
SortIndex=-1
SortOrder=0
[Field5]
SectionNum=39
FieldID=number_CODAmount
UserText=Amount COD
Selected=0
IndexField=0
Order=39
Width=25
SortIndex=-1
SortOrder=0
[Field6]
SectionNum=40
FieldID=number_InsuranceValue
UserText=Amount Insurance
Selected=0
IndexField=0
Order=40
Width=25
[Field7]
SectionNum=12
FieldID=refAttention
UserText=Attention
Selected=0
IndexField=0
Order=12
Width=200
SortIndex=-1
SortOrder=0
[Field8]
SectionNum=47
FieldID=car_fullName
UserText=Carrier
Selected=1
IndexField=0
Order=7
Width=132
SortIndex=-1
SortOrder=0
[Field9]
SectionNum=7
FieldID=city_receiver
UserText=City Receiver
Selected=1
IndexField=0
Order=6
Width=206
SortIndex=-1
SortOrder=0
[Field10]
SectionNum=22
FieldID=sea_city
UserText=City Sender
Selected=0
IndexField=0
Order=22
Width=25
[Field11]
SectionNum=50
FieldID=countryIsoA2_receiver
UserText=Country Receiver
Selected=1
IndexField=0
Order=9
Width=69
SortIndex=-1
SortOrder=0
[Field12]
SectionNum=27
FieldID=erpref_receiver
UserText=Customer No
Selected=0
IndexField=0
Order=27
Width=100
[Field13]
SectionNum=11
FieldID=email_Receiver
UserText=Email Receiver
Selected=0
IndexField=0
Order=11
Width=25
[Field14]
SectionNum=26
FieldID=sea_email
UserText=Email Sender
Selected=0
IndexField=0
Order=26
Width=25
[Field15]
SectionNum=9
FieldID=fax_Receiver
UserText=Fax Receiver
Selected=0
IndexField=0
Order=9
Width=25
[Field16]
SectionNum=24
FieldID=sea_fax
UserText=Fax Sender
Selected=0
IndexField=0
Order=24
Width=25
[Field17]
SectionNum=52
FieldID=FirstPackageNum
UserText=First Package Num Shipment
Selected=0
IndexField=0
Order=52
Width=90
[Field18]
SectionNum=53
FieldID=number_FixedPrice
UserText=Fixed Price
Selected=0
IndexField=0
Order=53
Width=25
[Field19]
SectionNum=43
FieldID=FirstGoodsType
UserText=Goods Type
Selected=0
IndexField=0
Order=43
Width=25
[Field20]
SectionNum=0
FieldID=shi_ID
UserText=ID Shipment
Selected=1
IndexField=1
Order=0
Width=116
SortOrder=0
SortIndex=-1
[Field21]
SectionNum=35
FieldID=shi_dateImported
UserText=Import Date
Selected=1
IndexField=0
Order=2
Width=116
SortIndex=-1
SortOrder=0
[Field22]
SectionNum=41
FieldID=refKID
UserText=KID
Selected=0
IndexField=0
Order=41
Width=25
[Field23]
SectionNum=33
FieldID=shi_dateLabelPrint
UserText=Label Print Date
Selected=0
IndexField=0
Order=33
Width=25
[Field24]
SectionNum=10
FieldID=mobile_Receiver
UserText=Mobile Receiver
Selected=0
IndexField=0
Order=10
Width=25
[Field25]
SectionNum=25
FieldID=sea_mobile
UserText=Mobile Sender
Selected=0
IndexField=0
Order=25
Width=25
[Field26]
SectionNum=2
FieldID=name1_receiver
UserText=Name1 Receiver
Selected=1
IndexField=0
Order=3
Width=120
SortIndex=0
SortOrder=2
[Field27]
SectionNum=17
FieldID=sea_name1
UserText=Name1 Sender
Selected=0
IndexField=0
Order=17
Width=25
[Field28]
SectionNum=3
FieldID=name2_Receiver
UserText=Name2 Receiver
Selected=0
IndexField=0
Order=3
Width=25
[Field29]
SectionNum=18
FieldID=sea_name2
UserText=Name2 Sender
Selected=0
IndexField=0
Order=18
Width=25
[Field30]
SectionNum=45
FieldID=shi_number
UserText=Number Shipment
Selected=0
IndexField=0
Order=45
Width=25
SortIndex=-1
SortOrder=0
[Field31]
SectionNum=51
FieldID=shi_ref_Operator
UserText=Operator
Selected=0
IndexField=0
Order=50
Width=90
[Field32]
SectionNum=48
FieldID=shi_ref_OrderNumber
UserText=Ordernumber
Selected=1
IndexField=0
Order=1
Width=111
SortIndex=-1
SortOrder=0
[Field33]
SectionNum=54
FieldID=ShipmentPackageCount
UserText=Package Count
Selected=0
IndexField=0
Order=54
Width=35
[Field34]
SectionNum=8
FieldID=phone_Receiver
UserText=Phone Receiver
Selected=0
IndexField=0
Order=8
Width=25
[Field35]
SectionNum=23
FieldID=sea_phone
UserText=Phone Sender
Selected=0
IndexField=0
Order=23
Width=25
SortIndex=-1
SortOrder=0
[Field36]
SectionNum=32
FieldID=shi_datePickup
UserText=Pickup Date
Selected=0
IndexField=0
Order=32
Width=25
[Field37]
SectionNum=4
FieldID=postCode_receiver
UserText=PostNo Receiver
Selected=1
IndexField=0
Order=5
Width=149
SortIndex=-1
SortOrder=0
[Field38]
SectionNum=19
FieldID=sea_postCode
UserText=PostNo Sender
Selected=0
IndexField=0
Order=19
Width=25
[Field39]
SectionNum=36
FieldID=number_Price1
UserText=Price 1
Selected=0
IndexField=0
Order=36
Width=25
[Field40]
SectionNum=37
FieldID=number_Price2
UserText=Price 2
Selected=0
IndexField=0
Order=37
Width=25
[Field41]
SectionNum=38
FieldID=number_Price3
UserText=Price 3
Selected=0
IndexField=0
Order=38
Width=25
[Field42]
SectionNum=30
FieldID=pro_name
UserText=Product
Selected=1
IndexField=0
Order=8
Width=195
SortIndex=-1
SortOrder=0
[Field43]
SectionNum=42
FieldID=refProjectName
UserText=Project Name
Selected=0
IndexField=0
Order=42
Width=25
[Field44]
SectionNum=15
FieldID=refReceiverCustNoCarrier
UserText=Receivers Account No at Carrier
Selected=0
IndexField=0
Order=15
Width=25
[Field45]
SectionNum=14
FieldID=refReceiverCustNoSender
UserText=Receivers Customer No at Sender
Selected=0
IndexField=0
Order=14
Width=25
[Field46]
SectionNum=13
FieldID=refReceiverReference
UserText=Receivers Reference
Selected=0
IndexField=0
Order=13
Width=25
SortIndex=-1
SortOrder=0
[Field47]
SectionNum=44
FieldID=shi_ref_SenderAccountNumber
UserText=Senders Account No at Bank
Selected=0
IndexField=0
Order=44
Width=25
SortIndex=-1
SortOrder=0
[Field48]
SectionNum=49
FieldID=shi_ref_SenderCustNoCarrier
UserText=Senders Account No at Carrier
Selected=0
IndexField=0
Order=49
Width=89
SortIndex=-1
SortOrder=0
[Field49]
SectionNum=16
FieldID=refSenderReference
UserText=Senders Reference
Selected=0
IndexField=0
Order=16
Width=25
[Field50]
SectionNum=46
FieldID=sub_name
UserText=SubCarrier
Selected=0
IndexField=0
Order=7
Width=80
[Field51]
SectionNum=1
FieldID=sub_id
UserText=SubCarrier ID
Selected=0
IndexField=0
Order=1
Width=25
[Field52]
SectionNum=34
FieldID=shi_dateTransmit
UserText=Transmit Date
Selected=0
IndexField=0
Order=34
Width=25
[Field53]
SectionNum=28
FieldID=SumShipmentVolume
UserText=Volume (dm3) Shipment
Selected=0
IndexField=0
Order=28
Width=25
[Field54]
SectionNum=29
FieldID=SumShipmentWeight
UserText=Weight (kg) Shipment
Selected=0
IndexField=0
Order=29
Width=25
[Field55]
SectionNum=55
FieldID=dbo.fnGetServiceNameList(shi_ID) as services
UserText=Services
Selected=0
IndexField=0
Order=55
Width=255
SortIndex=-1
SortOrder=0
[Field56]
SectionNum=56
FieldID=SumShipmentLoadmeter
UserText=Loadmeter (m) Shipment
Selected=0
IndexField=0
Order=56
Width=100
SortIndex=-1
SortOrder=0
[Query]
Select=SELECT DISTINCT streetAddress1_receiver, car_fullName, city_receiver, countryIsoA2_receiver, shi_ID, shi_dateImported, name1_receiver, shi_ref_OrderNumber, postCode_receiver, pro_name
From=FROM Shipment INNER JOIN fnFilterAutoPrint('$$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 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=
[GridOptions]
AllowFilter=0