[Infodust]
a=1
[Info]
FieldCount=17
FormCaption=Grid Setup - Customers
Version=11
SortColumn=0
SortDirection=ASC

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

[Field1]
SectionNum=1
FieldID=add_erpref
UserText=Customer No
Selected=1
IndexField=0
Order=1
Width=78
SortIndex=-1
SortOrder=0

[Field2]
SectionNum=2
FieldID=name1
UserText=Name1
Selected=1
IndexField=0
Order=2
Width=127
SortIndex=-1
SortOrder=0

[Field3]
SectionNum=3
FieldID=streetAddress1
UserText=Address1
Selected=1
IndexField=0
Order=3
Width=129
SortIndex=-1
SortOrder=0

[Field4]
SectionNum=4
FieldID=postCode
UserText=PostNo
Selected=0
IndexField=0
Order=4
Width=128
SortIndex=-1
SortOrder=0

[Field5]
SectionNum=5
FieldID=city
UserText=City
Selected=1
IndexField=0
Order=5
Width=127
SortIndex=-1
SortOrder=0

[Field6]
SectionNum=6
FieldID=phone
UserText=Phone
Selected=1
IndexField=0
Order=6
Width=129
SortIndex=-1
SortOrder=0

[Field7]
SectionNum=7
FieldID=mobile
UserText=Mobile
Selected=1
IndexField=0
Order=7
Width=128
SortIndex=-1
SortOrder=0

[Field8]
SectionNum=8
FieldID=cou_identifier
UserText=Country
Selected=1
IndexField=0
Order=8
Width=129
SortIndex=-1
SortOrder=0

[Field9]
SectionNum=9
FieldID=name2
UserText=Name2
Selected=0
IndexField=0
Order=9
Width=128
SortIndex=-1
SortOrder=0

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

[Field11]
SectionNum=11
FieldID=B.add_postOfficeBoxPostCode
UserText=PbxNo
Selected=0
IndexField=0
Order=11
Width=129
SortIndex=-1
SortOrder=0

[Field12]
SectionNum=12
FieldID=B.add_postOfficeBoxCity
UserText=PbxCity
Selected=0
IndexField=0
Order=12
Width=129
SortIndex=-1
SortOrder=0

[Field13]
SectionNum=13
FieldID=B.postOfficeBox
UserText=PostBox
Selected=0
IndexField=0
Order=13
Width=129
SortIndex=-1
SortOrder=0

[Field14]
SectionNum=14
FieldID=B.eMail
UserText=Email
Selected=0
IndexField=0
Order=14
Width=129
SortIndex=-1
SortOrder=0

[Field15]
SectionNum=15
FieldID=B.fax
UserText=Fax
Selected=0
IndexField=0
Order=15
Width=129
SortIndex=-1
SortOrder=0

[Field16]
SectionNum=16
FieldID=B.attention
UserText=Attention
Selected=0
IndexField=0
Order=16
Width=129
SortIndex=-1
SortOrder=0

[Query]
Select=SELECT DISTINCT cus_ID, add_erpref, name1, streetAddress1, city, phone, mobile, cou_identifier as country
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 Country ON (add_fk_cou = cou_ID)
where=
Values=