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

    <tablebrowser
        autoResizeMode="AUTO_RESIZE_NEXT_COLUMN"
        table="erpCountries"
        where="sStatus!='L'"
        orderBy="erpCountries.sCountry"
    >
        <column title="Country" field="sCountry" 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="Country:"
            constraints="0 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
        />
        <textField
            id="idCountry"
            name="Country"
            toolTipText="Country"
            constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 5 0 0"
            obligatory="true"
            size="200 21"
            field="sCountry"
            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 2 1 10.0 0.0 EAST HORIZONTAL 0 0 0 0 0 0"
        />
    </panel>
</xmlpanel>