<?xml version="1.0" encoding="UTF-8"?>
<xmlpanel>
    <configuration
        table="erpStorageLocations"
        deleteField="sStatus"
        deleteValue="L"
    >
        <primaryKey>
            <column name="nNr" type="INT" source="AUTO" />
        </primaryKey>
    </configuration>

    <tablebrowser
        autoResizeMode="AUTO_RESIZE_NEXT_COLUMN"
        table="erpStorageLocations"
        where="sStatus!='L'"
        orderBy="erpStorageLocations.nPosition"
    >
        <column title="Name"     field="sName"        width="200" minWidth="10" maxWidth="200" />
        <column title="Position" field="nPosition"    width="60"  minWidth="10" maxWidth="60" />
        <column title="City"     field="sCity"        width="150" minWidth="10" maxWidth="150" />
        <column title="Street"   field="sStreet"      width="150" minWidth="10" maxWidth="150" />
        <column title="H.nr."    field="sHouseNumber" width="40"  minWidth="10" maxWidth="50" />
        <column title="Type"     field="sType"        width="200" minWidth="10" maxWidth="200" />
        <column title="Status"   field="sStatus"      width="50"  minWidth="10" maxWidth="100">
            <replace value="A" text="active" />
            <replace value="I" text="inactive" />
        </column>
    </tablebrowser>
    
    <panel id="editor" widgetGroupID="">
        <label
            text="Name:"
            constraints="0 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idName"
            name="Name"
            toolTipText="Name"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            obligatory="true"
            size="200 21"
            field="sName"
            type="STRING"
        />

        <label
            text="Position:"
            constraints="2 +0 1 1 0.0 0.0 EAST NONE 5 10 0 0 0 0"
        />
        <numberField
            id="idPosition"
            name="Position"
            toolTipText="Position"
            constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            defaultValue="0"
            size="50 21"
            field="nPosition"
            type="INT"
        />

        <label
            text="City:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idCity"
            name="City"
            toolTipText="City"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="200 21"
            field="sCity"
            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="200 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 5 0 0 0 0"
            size="40 21"
            field="sHouseNumber"
            type="STRING"
        />

        <label
            text="Type:"
            constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idType"
            name="Type"
            toolTipText="Type"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
            size="200 21"
            field="sType"
            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 3 1 10.0 0.0 WEST HORIZONTAL 5 5 0 5 0 0"
            size="150 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>
    </panel>
</xmlpanel>