| external_key** | VARCHAR (255) | Yes* | No | alpd_perdiem_line_data. pd_line_data_id | The external key -- Primary Key |
| parent_ekey | VARCHAR(255) | Yes* | No | alpd_perdiem_line_data. exp_line_item_id | The external key of the parent line item |
| private_nightstay_address | VARCHAR(255) | No | No | alpd_perdiem_line_data.private_nightstay_address | If the traveller stayed at a friend's place, the address is set here. |
| first_day_of_trip | SMALLINT | No | No | alpd_perdiem_line_data.first_day_of_trip | Set to 1 if this is the first day of the trip. |
| last_day_of_trip | SMALLINT | No | No | alpd_perdiem_line_data.last_day_of_trip | Set to 1 if this is the last day of the trip |
| time_at_location | SMALLINT | No | No | alpd_perdiem_line_data.time_at_location | |
| start_time | DATETME | No | No | alpd_perdiem_line_data.start_time | |
| end_time | DATETIME | No | No | alpd_perdiem_line_data.end_time | |
| overnight_stay | SMALLINT | No | No | alpd_perdiem_line_data.overnight_stay | |
| long_term_stay | SMALLINT | No | No | alpd_perdiem_line_data.long_term_stay | |
| breakfast | SMALLINT | No | No | alpd_perdiem_line_data.breakfast | |
| lunch | SMALLINT | No | No | alpd_perdiem_line_data.lunch | |
| dinner | SMALLINT | No | No | alpd_perdiem_line_data.dinner | |
| meal_amount | NUMERIC(28,10) | No | No | alpd_perdiem_line_data.meal_amount | |
| meal_amount_ekey | VARCHAR(255) | No | No | alpd_perdiem_line_data.meal_amount_id | |