| export_perdiem_line_data_id
|
|
int
|
N
|
PK - a unique ID for this table. Example:
1234567890
|
| export_expense_line_id
|
|
int
|
N
|
Foreign key to aler_expense_export_line
|
| time_at_location
|
alpd_perdiem_line_data - time_at_location
|
smallint
|
Y
|
The time spent at this location in minutes.
This is usually calculated from end_time - start_time but can be configured as
a dropdown.
|
| start_time
|
alpd_perdiem_line_data - start_time
|
datetime
|
Y
|
The time of day the traveller arrived at
this location. If the traveller arrived on a previous day, this should be set
to 0:00.
|
| end_time
|
alpd_perdiem_line_data - end_time
|
datetime
|
Y
|
The time of day the traveller departed from
this location. If the traveller will depart on a future day, this should be set
to 0:00.
|
| overnight_stay
|
alpd_perdiem_line_data - overnight_stay
|
smallint
|
Y
|
Set to 1 if the traveller had an overnight
stay.
|
| long_term_stay
|
alpd_perdiem_line_data - long_term_stay
|
smallint
|
Y
|
Set to 1 if this is part of a long term
stay.
|
| Breakfast
|
alpd_perdiem_line_data - breakfast
|
smallint
|
Y
|
Set to 1 if the traveller's breakfast was
paid for. This reduces the per diem.
|
| Lunch
|
alpd_perdiem_line_data - lunch
|
smallint
|
Y
|
Set to 1 if the traveller's lunch was paid
for. This reduces the per diem.
|
| Dinner
|
alpd_perdiem_line_data - dinner
|
smallint
|
Y
|
Set to 1 if the traveller's dinner was paid
for. This reduces the per diem.
|
| meal_amount
|
alpd_perdiem_line_data - meal_amount
|
numeric(20, 10)
|
Y
|
The amount to subtract from the per diem for
a meal that was paid for by another party.
|
| meal_amount_currency_ekey
|
alpd_perdiem_line_data - meal_amount_id
|
varchar(255)
|
Y
|
The currency of the meal amount. This should
always be the same as the per diem currency.
|
| private_nightstay_address
|
alpd_perdiem_line_data -
private_nightstay_address
|
varchar(255)
|
Y
|
If the traveller stayed at a friend's place,
the address is set here.
|
| first_day_of_trip
|
alpd_perdiem_line_data - first_day_of_trip
|
smallint
|
Y
|
Set to 1 if this is the first day of the
trip.
|
| last_day_of_trip
|
alpd_perdiem_line_data - last_day_of_trip
|
smallint
|
Y
|
Set to 1 if this is the last day of the
trip.
|
| optional_deduction_1
|
almt_extension - value_int
|
smallint
|
Y
|
Set to 1 if the traveller checked the
optional deduction 1 checkbox.
|
| optional_deduction_2
|
almt_extension - value_int
|
smallint
|
Y
|
Set to 1 if the traveller checked the
optional deduction 2 checkbox.
|
| optional_deduction_3
|
almt_extension - value_int
|
smallint
|
Y
|
Set to 1 if the traveller checked the
optional deduction 3 checkbox.
|
| optional_deduction_4
|
almt_extension - value_int
|
smallint
|
Y
|
Set to 1 if the traveller checked the
optional deduction 4 checkbox.
|
| optional_deduction_5
|
almt_extension - value_int
|
smallint
|
Y
|
Set to 1 if the traveller checked the
optional deduction 5 checkbox.
|