<?xml version="1.0" encoding="UTF-8"?>
<xmlpanel>
    <configuration
        table="erpClients"
        searchDialog="idClientsSearchDialog"
        recordControlPattern="{0}"
        bookmarks="true"
        bookmarkTitle="Company: $idCompany City: $idCity"
        history="true"
        historyTitle="Company: $idCompany City: $idCity"
    >
        <primaryKey>
            <column name="nNr" type="INT" source="AUTO" />
        </primaryKey>
    </configuration>

    <searchDialog
        id="idClientsSearchDialog"
        title="Clients search"
        autoResizeMode="AUTO_RESIZE_OFF"
        size="800 500"
        table="erpClients"
        where="erpClients.sStatus!='L'"
        orderBy="erpClients.sName"
    >
        <primaryKey>
            <column name="nNr" type="INT" />
        </primaryKey>
        <column title="Company"   field="sCompany"     width="128" minWidth="10" maxWidth="200"/>
        <column title="Name"      field="sName"        width="125" minWidth="10" maxWidth="200"/>
        <column title="Pos.Co."   field="sPostalCode"  width="50" minWidth="10" maxWidth="600"/>
        <column title="City"      field="sCity"        width="120" minWidth="10" maxWidth="150"/>
        <column title="Street"    field="sStreet"      width="100" minWidth="10" maxWidth="150"/>
        <column title="H.nr."     field="sHouseNumber" width="50"  minWidth="10" maxWidth="80"
            alignment="RIGHT"/>
        <column title="Country"   field="nCountryNr"   width="100" minWidth="10" maxWidth="150"
            type="COMBOBOX" joinTable="erpCountries" joinKeyField="nNr" joinField="sCountry"
            where="sStatus='A'" orderBy="sCountry"/>
        <column title="Telephone" field="sTelephone"   width="100" minWidth="10" maxWidth="150"/>
    </searchDialog>

    <panel id="main" widgetGroupID="">
        <label text="Company:"
            constraints="0 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idCompany"
            name="Company"
            toolTipText="Company"
            constraints="1 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            size="192 21"
            field="sCompany"
            type="STRING"
        />

        <label text="Name:"
            constraints="3 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idName"
            name="Name"
            toolTipText="Name"
            constraints="4 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            size="227 21"
            field="sName"
            type="STRING"
        />

        <label text="Street/House number:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idStreet"
            name="Street"
            toolTipText="Street"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="140 21"
            field="sStreet"
            type="STRING"
        />

        <textField
            id="idHouseNumber"
            name="House number"
            toolTipText="House number"
            constraints="2 +0 1 1 0.0 0.0 WEST NONE 5 2 0 0 0 0"
            size="50 21"
            field="sHouseNumber"
            type="STRING"
        />

        <label text="Postal code/City:"
            constraints="3 +0 1 1 0.0 0.0 EAST NONE 5 15 0 0 0 0"
        />
        <textField
            id="idPostalCode"
            name="Postal code"
            toolTipText="Postal code"
            constraints="4 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="45 21"
            field="sPostalCode"
            type="STRING"
        />
        <textField
            id="idCity"
            name="City"
            toolTipText="City"
            constraints="5 +0 1 1 0.0 0.0 WEST NONE 5 2 0 0 0 0"
            size="180 21"
            field="sCity"
            type="STRING"
        />

        <label text="Country:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <comboBox
            id="idCountry"
            name="Country"
            toolTipText="Country"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            field="nCountryNr"
            type="INT"
        >
            <dataSource
                table="erpCountries"
                itemField="sCountry"
                where="sStatus='A'"
                orderBy="sCountry"
            >
                <primaryKey type="SINGLE">
                    <column name="nNr" type="INT"/>
                </primaryKey>
            </dataSource>
        </comboBox>

        <label text="Telephone:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idTelephone"
            name="Telephone"
            toolTipText="Telephone"
            constraints="1 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="192 21"
            field="sTelephone"
            type="STRING"
        />

        <label text="Fax:"
            constraints="3 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idFax"
            name="Fax"
            toolTipText="Fax"
            constraints="4 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="227 21"
            field="sFax"
            type="STRING"
        />

        <label text="Email:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idEmail"
            name="Email"
            toolTipText="Email"
            constraints="1 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="192 21"
            field="sEmail"
            type="STRING"
        />

        <label text="Web:"
            constraints="3 +0 1 1 0.0 0.0 EAST NONE 5 15 0 0 0 0"
        />
        <textField
            id="idWeb"
            name="Web"
            toolTipText="Web"
            constraints="4 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="227 21"
            field="sWeb"
            type="STRING"
        />

        <label text="Remarks:"
            constraints="0 +1 1 1 0.0 0.0 NORTHEAST NONE 5 5 0 0 0 0"
        />
        <textArea
            id="idRemarks"
            name="Remarks"
            toolTipText="Remarks"
            constraints="1 +0 5 1 10.0 0.0 WEST HORIZONTAL 5 5 0 0 0 0"
            size="300 80"
            field="sRemarks"
            type="STRING"
        />

        <label
            text="Status:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 5 0 0 0"
        />
        <comboBox
            id="idStatus"
            name="Status"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 5 0 0 0"
            defaultValue="A"
            field="sStatus"
            type="STRING"
        >
            <item value="A" text="active" />
            <item value="I" text="inactive" />
        </comboBox>

        <label text=""
            constraints="0 +1 6 1 1.0 1.0 WEST BOTH 0 0 0 0 0 0"
        />
    </panel>
</xmlpanel>