[Info]
FieldCount=18
FormCaption=Grid Setup - Customers
Version=6
SortColumn=0
SortDirection=ASC

[Field0]
SectionNum=9
FieldID=streetAddress1
UserText=Address1
Selected=1
IndexField=0
Order=3
Width=86
SortOrder=0
SortIndex=-1

[Field1]
SectionNum=20
FieldID=attention
UserText=Attention
Selected=0
IndexField=0
Order=20
Width=25

[Field2]
SectionNum=13
FieldID=city
UserText=City
Selected=1
IndexField=0
Order=5
Width=56
SortIndex=-1
SortOrder=0

[Field3]
SectionNum=21
FieldID=cou_identifier
UserText=Country
Selected=1
IndexField=0
Order=8
Width=174
SortIndex=-1
SortOrder=0

[Field4]
SectionNum=0
FieldID=cus_ID
UserText=Customer ID
Selected=0
IndexField=1
Order=0
Width=25
SortOrder=0
SortIndex=-1

[Field5]
SectionNum=3
FieldID=add_erpref
UserText=Customer No.
Selected=1
IndexField=0
Order=1
Width=146
SortIndex=-1
SortOrder=0

[Field6]
SectionNum=1
FieldID=cus_fk_cat
UserText=Category
Selected=0
IndexField=0
Order=1
Width=25

[Field7]
SectionNum=2
FieldID=A.add_openingHours
UserText=Opening Hours
Selected=0
IndexField=0
Order=2
Width=25
SortIndex=-1
SortOrder=0

[Field8]
SectionNum=19
FieldID=eMail
UserText=Email
Selected=1
IndexField=0
Order=8
Width=170
SortIndex=-1
SortOrder=0

[Field9]
SectionNum=17
FieldID=fax
UserText=Fax
Selected=0
IndexField=0
Order=17
Width=25
SortIndex=-1
SortOrder=0

[Field10]
SectionNum=18
FieldID=mobile
UserText=Mobile
Selected=1
IndexField=0
Order=7
Width=52
SortIndex=-1
SortOrder=0

[Field11]
SectionNum=4
FieldID=name1
UserText=Name1
Selected=1
IndexField=0
Order=2
Width=132
SortIndex=-1
SortOrder=0

[Field12]
SectionNum=5
FieldID=name2
UserText=Name2
Selected=0
IndexField=0
Order=5
Width=25
SortIndex=-1
SortOrder=0

[Field13]
SectionNum=16
FieldID=phone
UserText=Phone
Selected=1
IndexField=0
Order=6
Width=50
SortIndex=-1
SortOrder=0

[Field14]
SectionNum=12
FieldID=postCode
UserText=PostNo
Selected=1
IndexField=0
Order=4
Width=29
SortIndex=-1
SortOrder=0

[Field15]
SectionNum=11
FieldID=postOfficeBox
UserText=PostOfficeBox
Selected=0
IndexField=0
Order=11
Width=25
SortIndex=-1
SortOrder=0

[Field16]
SectionNum=14
FieldID=state
UserText=State
Selected=0
IndexField=0
Order=14
Width=25

[Field17]
SectionNum=10
FieldID=streetAddress2
UserText=Address2
Selected=0
IndexField=0
Order=10
SortIndex=-1
SortOrder=0
Width=25

[Query]
Select=SELECT DISTINCT streetAddress1, city, cou_identifier, cus_ID, add_erpref, eMail, mobile, name1, phone, postCode
From=FROM CustomerList INNER join Customer  on (cul_id = cus_fk_cul) INNER JOIN Address AS A ON ( cus_ID = add_fk_cus ) INNER JOIN vFullAddress AS B ON ( A.add_ID = B.add_ID ) INNER join ActorLinkCustomerList AS act ON ( alc_fk_cul = cul_id ) INNER join fnFilterActor($$ACTORID$$) on act_ID = alc_fk_act INNER JOIN Country ON (add_fk_cou = cou_ID)
Where=WHERE alc_id in (SELECT ActorLinkListKind.all_fk_alc FROM ActorLinkListKind INNER JOIN CustomerListKind ON ActorLinkListKind.all_fk_clk = CustomerListKind.clk_id WHERE clk_id=$$CONTACTLISTKIND$$)
Values=
[GridOptions]
AllowFilter=0