Traveling-Expenses Table

From EA-Geier

Database Config Table Clients Table ClientConfig Table Users Table UserConfig Table Session2 Table SimpleTest Table Cash-Book Table Assets-Book Table Purchase-Book Table Traveling-Expenses Table Balance Table

The traveling-expenses tables hold the traveling records of each client. Each client has its own traveling-expenses table named "travels" prefixed with the client ID.

The id value is provided by the system by means of auto increment. txtName is the name or description of the travel provided by the user.

txtPeriod holds the length or period of the travel, and txtVouchers references to travel costs already booked in the cash book.

numDay gives the daily allowances, numNight the costs for over-night stays. txtTax and numTax provide the tax rate and the actual VAT value of the travel costs. numAmount holds the net costs of the travel.

numDistance, numDistRate, and numDistAmount hold the distance, the mileage rate and the actual mileage allowance for the travel

year, month, and day provide the travel date.

who and lastModified provide a minimal log holding the email address and date of the last change.

<?xml version="1.0"?>
<schema version="0.3">
  <table name="travels">
	<field name="id" type="I" size="8">
	  <KEY/>
	  <AUTOINCREMENT/>
	  <UNSIGNED/>
	</field>
	<field name="txtName" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="txtPeriod" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="txtVouchers" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="numDay" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="numNight" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="txtTax" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="numTax" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="numAmount" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="numDistance" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="numDistRate" type="N" size="12.6">
	  <NOTNULL/>
	</field>
	<field name="numDistAmount" type="N" size="12.6">
	  <NOTNULL/>
	</field>

	<field name="year" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="month" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="day" type="C" size="32">
	  <NOTNULL/>
	</field>
	<field name="who" type="C" size="255">
	  <NOTNULL/>
	</field>
	<field name="lastModified" type="T">
	  <NOTNULL/>
	</field>
	<index name="year">
	  <col>year</col>
	</index>
	<index name="month">
	  <col>month</col>
	</index>
	<index name="day">
	  <col>day</col>
	</index>
  </table>
</schema>