| erio_export_id
|
|
INT
|
N
|
A unique Bob ID to use as PK.
|
| Export_er_line_id
|
|
INT
|
Y
|
Currently not used.
|
| Erio_export_expense_line_id
|
aler_expense_line_item - exp_line_item_id
|
INT
|
Y
|
FK reference to the corresponding expense
line ID.
|
| Erio_other_name
|
aler_item_other - other_name
|
VARCHAR (255)
|
Y
|
Name of the guest. (Associated with line
item through alco_guest_ wrapper)
|
| erio_other_title
|
aler_item_other - other_title
|
VARCHAR (255)
|
Y
|
Title of the guest. (Associated with line
item through alco_guest_ wrapper)
|
| erio_other_company
|
aler_item_other - other_company
|
VARCHAR (255)
|
Y
|
Company of the guest. (Associated with line
item through alco_guest_ wrapper)
|
| export_er_hdr_id
|
aler_expense_export_ header -
export_er_hdr_id
|
INT
|
Y
|
Foreign key reference to the exported
expense report
|
| guest_ekey
|
aler_expense_export_ header - user_ekey
|
VARCHAR(255)
|
Y
|
Guest external key
|
| external_flag
|
alco_guest - external_flag
|
SMALLINT
|
Y
|
The external flag
|
| location_ekey
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location ekey
|
| external_id
|
alco_guest - external_id
|
VARCHAR(255)
|
Y
|
The external id.
|
| User_id
|
alco_guest - user_id
|
INT
|
Y
|
The user id.
|
| Street
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location element.
|
| Suburb
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location element.
|
| City
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location element.
|
| County
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location element.
|
| State
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location element.
|
| Country
|
alco_guest - location_id
|
VARCHAR(255)
|
Y
|
The location element.
|
| Adc1
|
alco_guest - adc1
|
VARCHAR(255)
|
Y
|
The adc field.
|
| Adc2
|
alco_guest - adc2
|
VARCHAR(255)
|
Y
|
The adc field.
|
| Adc3
|
alco_guest - adc3
|
VARCHAR(255)
|
Y
|
The adc field.
|
| Adc4
|
alco_guest - adc4
|
VARCHAR(255)
|
Y
|
The adc field.
|
| Adc5
|
alco_guest - adc5
|
VARCHAR(255)
|
Y
|
The adc field.
|
| Adc6
|
alco_guest - adc6
|
VARCHAR(255)
|
Y
|
The adc field.
|
| Combo_adc1_ekey
|
alco_guest - combo_adc1
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| Combo_adc1_value
|
alco_guest - combo_adc1
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| Combo_adc2_ekey
|
alco_guest - combo_adc2
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| Combo_adc2_value
|
alco_guest - combo_adc2
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| Combo_adc3_ekey
|
alco_guest - combo_adc3
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| Combo_adc3_value
|
alco_guest - combo_adc3
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| Combo_adc4_ekey
|
alco_guest - combo_adc4
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| Combo_adc4_value
|
alco_guest - combo_adc4
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| Combo_adc5_ekey
|
alco_guest - combo_adc5
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| Combo_adc5_value
|
alco_guest - combo_adc5
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| Combo_adc6_ekey
|
alco_guest - combo_adc6
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| Combo_adc6_value
|
alco_guest - combo_adc6
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| Guest_type_name
|
alco_guest_type - name
|
VARCHAR(255)
|
Y
|
The name of guest type
|
| primary_address_ekey
|
alco_guest - primary_address_id
|
VARCHAR(255)
|
Y
|
The guest's primary address ekey
|
| primary_address_value
|
alco_guest - primary_address_id
|
VARCHAR(255)
|
Y
|
The guest's primary address name
|
| occupation_ekey
|
alco_occuption - occupation_id
|
VARCHAR(255)
|
Y
|
The occupation ekey
|
| occupation_value
|
alco_occupation - name
|
VARCHAR(255)
|
Y
|
The occupation display value
|
| guest_wrapper_native_amount
|
alco_guest_wrapper - native_amount
|
NUMERIC(20, 10)
|
Y
|
The per-guest native amount
|
| guestwrap_native_currency_ekey
|
alco_guest_wrapper - native_amount_id
|
VARCHAR(255)
|
Y
|
The per-guest native amount currency
|
| guest_wrapper_paid_in_amount
|
alco_guest_wrapper - paid_in_amount
|
NUMBERIC(20, 10)
|
Y
|
The per-guest paid-in amount
|
| guestwrap_paidin_currency_ekey
|
alco_guest_wrapper - paid_in_amount_id
|
VARCHAR(255)
|
Y
|
The per-guest paid-in amount currency
|
| guest_wrapper_adc1
|
alco_guest_wrapper - adc1
|
VARCHAR(255)
|
Y
|
The text adc1
|
| guest_wrapper_adc2
|
alco_guest_wrapper - adc2
|
VARCHAR(255)
|
Y
|
The text adc2
|
| guest_wrapper_adc3
|
alco_guest_wrapper - adc3
|
VARCHAR(255)
|
Y
|
The text adc3
|
| guest_wrapper_adc4
|
alco_guest_wrapper - adc4
|
VARCHAR(255)
|
Y
|
The text adc4
|
| guest_wrapper_adc5
|
alco_guest_wrapper - adc5
|
VARCHAR(255)
|
Y
|
The text adc5
|
| guest_wrapper_adc6
|
alco_guest_wrapper - adc6
|
VARCHAR(255)
|
Y
|
The text adc6
|
| guest_wrapper_combo_adc1_ekey
|
alco_guest_wrapper - combo_adc1
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| guest_wrapper_combo_adc1_value
|
alco_guest_wrapper - combo_adc1
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| guest_wrapper_combo_adc2_ekey
|
alco_guest_wrapper - combo_adc2
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| guest_wrapper_combo_adc2_value
|
alco_guest_wrapper - combo_adc2
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| guest_wrapper_combo_adc3_ekey
|
alco_guest_wrapper - combo_adc3
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| guest_wrapper_combo_adc3_value
|
alco_guest_wrapper - combo_adc3
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| guest_wrapper_combo_adc4_ekey
|
alco_guest_wrapper - combo_adc4
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| guest_wrapper_combo_adc4_value
|
alco_guest_wrapper - combo_adc4
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| guest_wrapper_combo_adc5_ekey
|
alco_guest_wrapper - combo_adc5
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| guest_wrapper_combo_adc5_value
|
alco_guest_wrapper - combo_adc5
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| guest_wrapper_combo_adc6_ekey
|
alco_guest_wrapper - combo_adc6
|
VARCHAR(255)
|
Y
|
The combo adc ekey.
|
| guest_wrapper_combo_adc6_value
|
alco_guest_wrapper - combo_adc6
|
VARCHAR(255)
|
Y
|
The combo adc value.
|
| guest_wrapper_address_ekey
|
alco_guest_wrapper - address_id
|
VARCHAR(255)
|
Y
|
The address ekey
|
| guest_wrapper_address_value
|
alco_guest_wrapper - address_id
|
VARCHAR(255)
|
Y
|
The address value
|