<?xml version="1.0" encoding="UTF-8"?>
<xmlpanel>
    <configuration
        table="wwKunden"
        searchDialog="idKundenSuchDialog"
        recordControlPattern="{0}"
        bookmarks="true"
        bookmarkTitle="Firma: $idFirma Ort: $idOrt"
        history="true"
        historyTitle="Firma: $idFirma Ort: $idOrt"
    >
        <primaryKey>
            <column name="nNr" type="INT" source="AUTO" />
        </primaryKey>
    </configuration>

    <searchDialog
        id="idKundenSuchDialog"
        title="Kunden-Suche"
        autoResizeMode="AUTO_RESIZE_OFF"
        size="800 500"
        table="wwKunden"
        where="wwKunden.sStatus!='L'"
        orderBy="wwKunden.sName"
    >
        <primaryKey>
            <column name="nNr" type="INT" />
        </primaryKey>
        <column title="Firma"   field="sFirma"        width="128" minWidth="10" maxWidth="200"/>
        <column title="Name"    field="sName"         width="125" minWidth="10" maxWidth="200"/>
        <column title="Plz."    field="sPostleitzahl" width="50" minWidth="10" maxWidth="600"/>
        <column title="Ort"     field="sOrt"          width="120" minWidth="10" maxWidth="150"/>
        <column title="Straße"  field="sStrasse"      width="100" minWidth="10" maxWidth="150"/>
        <column title="H.Nr."   field="sHausnummer"   width="50"  minWidth="10" maxWidth="80"
            alignment="RIGHT"/>
        <column title="Land"    field="nLandNr"       width="100" minWidth="10" maxWidth="150"
            joinTable="wwLaender" joinKeyField="nNr" joinField="sLand"/>
        <column title="Telefon" field="sTelefon"      width="100" minWidth="10" maxWidth="150"/>
    </searchDialog>

    <panel id="main" widgetGroupID="">
        <label text="Firma:"
            constraints="0 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idFirma"
            name="Firma"
            toolTipText="Firma"
            constraints="1 +0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            size="192 21"
            field="sFirma"
            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="Straße/Hausnummer:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idStrasse"
            name="Straße"
            toolTipText="Straße"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="140 21"
            field="sStrasse"
            type="STRING"
        />

        <textField
            id="idHausnummer"
            name="Hausnummer"
            toolTipText="Hausnummer"
            constraints="2 +0 1 1 0.0 0.0 WEST NONE 5 2 0 0 0 0"
            size="50 21"
            field="sHausnummer"
            type="STRING"
        />

        <label text="Postleitzahl/Ort:"
            constraints="3 +0 1 1 0.0 0.0 EAST NONE 5 15 0 0 0 0"
        />
        <textField
            id="idPostleitzahl"
            name="Postleitzahl"
            toolTipText="Postleitzahl"
            constraints="4 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="45 21"
            field="sPostleitzahl"
            type="STRING"
        />
        <textField
            id="idOrt"
            name="Ort"
            toolTipText="Ort"
            constraints="5 +0 1 1 0.0 0.0 WEST NONE 5 2 0 0 0 0"
            size="180 21"
            field="sOrt"
            type="STRING"
        />

        <label text="Land:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <comboBox
            id="idLand"
            name="Land"
            toolTipText="Land"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            field="nLandNr"
            type="INT"
        >
            <dataSource
                table="wwLaender"
                itemField="sLand"
                where="sStatus='A'"
                orderBy="sLand"
            >
                <primaryKey type="SINGLE">
                    <column name="nNr" type="INT"/>
                </primaryKey>
            </dataSource>
        </comboBox>

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

        <label text="Fax:"
            constraints="3 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idFaxnummer"
            name="Faxnummer"
            toolTipText="Faxnummer"
            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="Bemerkungen:"
            constraints="0 +1 1 1 0.0 0.0 NORTHEAST NONE 5 5 0 0 0 0"
        />
        <textArea
            id="id"
            name="Bemerkungen"
            toolTipText="Bemerkungen"
            constraints="1 +0 5 1 10.0 0.0 WEST HORIZONTAL 5 5 0 0 0 0"
            size="300 80"
            field="sBemerkungen"
            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="aktiv" />
            <item value="I" text="inaktiv" />
        </comboBox>
        
        <label text=""
            constraints="0 +1 6 1 1.0 1.0 WEST BOTH 0 0 0 0 0 0"
        />
    </panel>
</xmlpanel>