<?xml version="1.0" encoding="UTF-8"?>
<xmlpanel>
<configuration
table="erpArticle"
searchDialog="idArticleSearchDialog"
recordControlPattern="{1}"
bookmarks="true"
bookmarkTitle="Article number: $idArticleNumber Name: $idName"
history="true"
historyTitle="Article number: $idArticleNumber"
>
<primaryKey>
<column name="nNr" type="INT" source="AUTO" />
</primaryKey>
</configuration>
<searchDialog
id="idArticleSearchDialog"
title="Article search"
autoResizeMode="AUTO_RESIZE_OFF"
size="750 500"
table="erpArticle"
where="erpArticle.sStatus!='L'"
orderBy="erpArticle.sArticleNumber"
>
<column title="Article number" field="sArticleNumber" width="100" minWidth="10" maxWidth="120"/>
<column title="Name" field="sName" width="140" minWidth="10" maxWidth="200"/>
<column title="Article group" field="nArticleGroupNr" width="100" minWidth="10" maxWidth="120"
type="COMBOBOX" joinTable="erpArticleGroups" joinKeyField="nNr" joinField="sName"
where="sStatus='A'" orderBy="nPosition" />
<column title="Storage location" field="nStorageLocationNr" width="100" minWidth="10" maxWidth="120"
type="COMBOBOX" joinTable="erpStorageLocations" joinKeyField="nNr" joinField="sName"
where="sStatus='A'" orderBy="nPosition"/>
<column title="Price" field="fPrice" width="60" minWidth="10" maxWidth="120"
type="NUMBER" alignment="RIGHT" pattern="#.00 €"/>
<column title="Inventory" field="fActualInventory" width="70" minWidth="10" maxWidth="120"
type="NUMBER" alignment="RIGHT" pattern="#.0"/>
<column title="Dimension" field="nDimensionNr" width="80" minWidth="10" maxWidth="120"
type="COMBOBOX" joinTable="erpDimensions" joinKeyField="nNr" joinField="sName"
where="sStatus='A'" orderBy="nPosition"/>
<column title="Admittance" field="dtAdmittance" width="70" minWidth="10" maxWidth="90"
type="DATE" pattern="MM-dd-yyyy"/>
</searchDialog>
<searchDialog
id="idVendorSearchDialog"
title="Vendor search"
autoResizeMode="AUTO_RESIZE_OFF"
size="420 500"
table="erpVendors"
where="erpVendors.sStatus='A'"
orderBy="erpVendors.sName"
>
<primaryKey>
<column name="nNr" type="INT" />
</primaryKey>
<column title="Name" field="sName" width="120" minWidth="10" maxWidth="200"/>
<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="100"/>
</searchDialog>
<panel id="main" widgetGroupID="">
<label text="Article number:"
constraints="0 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<textField
id="idArticleNumber"
name="Article number"
toolTipText="Article number"
constraints="1 0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
obligatory="true"
size="100 21"
field="sArticleNumber"
type="STRING"
/>
<label text="Name:"
constraints="2 0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<textField
id="idName"
name="Name"
toolTipText="Name of article"
constraints="3 0 2 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
obligatory="true"
size="230 21"
field="sName"
type="STRING"
/>
<label text="Article group:"
constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<comboBox
id="idArticleGroup"
name="Article group"
toolTipText="Article group"
constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
obligatory="true"
field="nArticleGroupNr"
type="INT"
>
<dataSource
table="erpArticleGroups"
itemField="sName"
where="sStatus='A'"
orderBy="nPosition"
>
<primaryKey type="SINGLE">
<column name="nNr" type="INT"/>
</primaryKey>
</dataSource>
</comboBox>
<label text="Storage location:"
constraints="2 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<comboBox
id="idStorageLocation"
name="Storage location"
toolTipText="Storage location"
constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
field="nStorageLocationNr"
type="INT"
>
<dataSource
table="erpStorageLocations"
itemField="sName"
where="sStatus='A'"
orderBy="nPosition"
>
<primaryKey type="SINGLE">
<column name="nNr" type="INT"/>
</primaryKey>
</dataSource>
</comboBox>
<label text="Price:"
constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<numberField
id="idPrice"
name="Price"
toolTipText="Price"
constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
pattern="#.00"
horizontalAlignment="RIGHT"
size="70 21"
field="fPrice"
type="FLOAT"
/>
<label text="Actual inventory:"
constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<numberField
id="idActualInventory"
name="Actual inventory"
toolTipText="Actual inventory"
constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
pattern="#.##"
horizontalAlignment="RIGHT"
size="70 21"
field="fActualInventory"
type="DOUBLE"
/>
<label text="Dimension:"
constraints="2 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<comboBox
id="idDimension"
name="Dimension"
toolTipText="Dimension"
constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
obligatory="true"
field="nDimensionNr"
type="INT"
>
<dataSource
table="erpDimensions"
itemField="sName"
where="sStatus='A'"
orderBy="nPosition"
>
<primaryKey type="SINGLE">
<column name="nNr" type="INT"/>
</primaryKey>
</dataSource>
</comboBox>
<label text="Order inventory:"
constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<numberField
id="idOrderInventory"
name="Order inventory"
toolTipText="Order inventory"
constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
pattern="#.##"
horizontalAlignment="RIGHT"
size="70 21"
field="fOrderInventory"
type="DOUBLE"
/>
<label text="Order quantity:"
constraints="2 +0 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<numberField
id="idOrderQuantity"
name="Order quantity"
toolTipText="Order quantity"
constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
pattern="#.##"
horizontalAlignment="RIGHT"
size="70 21"
field="fOrderQuantity"
type="DOUBLE"
/>
<label text="Admittance:"
constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<dateField
id="idAdmittance"
name="Admittance"
format="DATE"
toolTipText="Date when articles was admitted"
constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
size="75 21"
field="dtAdmittance"
type="DATE"
/>
<label text="Vendor:"
constraints="0 +1 1 1 0.0 0.0 EAST NONE 5 5 0 0 0 0"
/>
<textField
id="idVendor"
toolTipText="Vendor"
constraints="1 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
size="150 21"
searchDialog="idVendorSearchDialog"
field="nVendorNr"
type="INT"
>
<masterWidget
table="erpVendors"
showField="sCompany"
where=""
>
<primaryKey type="SINGLE">
<column name="nNr" type="INT"/>
</primaryKey>
<slaveWidget id="idVendorCity" mode="VALUE" field="sCity" type="STRING" />
<slaveWidget id="idVendorStreet" mode="VALUE" field="sStreet" type="STRING" />
<slaveWidget id="idVendorHouseNumber" mode="VALUE" field="sHouseNumber" type="STRING" />
</masterWidget>
</textField>
<textField
id="idVendorCity"
toolTipText="City of vendor"
constraints="2 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
locked="true"
size="150 21"
/>
<textField
id="idVendorStreet"
toolTipText="Street of vendor"
constraints="3 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
locked="true"
size="150 21"
/>
<textField
id="idVendorHouseNumber"
toolTipText="House number of vendor"
constraints="4 +0 1 1 0.0 0.0 WEST NONE 5 5 0 0 0 0"
locked="true"
size="50 21"
/>
<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 4 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 5 1 1.0 1.0 WEST BOTH 0 0 0 0 0 0"
/>
</panel>
</xmlpanel>