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

    <tablebrowser
        autoResizeMode="AUTO_RESIZE_NEXT_COLUMN"
        table="erpArticleGroups"
        where="sStatus!='L'"
        orderBy="erpArticleGroups.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="Description" field="sDescription" width="400" minWidth="10" maxWidth="800" />
        <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 5 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 5 0 0"
            defaultValue="0"
            size="50 21"
            field="nPosition"
            type="INT"
        />

        <label
            text="Description:"
            constraints="0 +1 1 1 0.0 0.0 NORTHEAST NONE 5 5 0 0 0 0"
        />
        <textArea
            id="idDescription"
            name="Description"
            toolTipText="Description"
            constraints="1 +0 3 1 10.0 0.0 WEST HORIZONTAL 5 5 0 5 0 0"
            size="150 80"
            field="sDescription"
            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>