Version 10.2.3

Modifications in Infor Expense Management 10.2.3


CREATE TABLE albr_parameter (
br_parameter_id	int	NOT NULL
br_instance_id	int
param_order	int
param_type	nchar(2),
param_name	nvarchar(255),
string_value	nvarchar(1500),
int_value	int,
float_value	float,
date_value	datetime,
money_value	numeric(28,10),
money_value_id	int
corp_data_name	nvarchar(65),
active_status	smallint NOT NULL,	NOT NULL
hours_value	numeric(14,4),
change_timestamp	datetime,
gmt_date_value	datetime,
CONSTRAINT PK__alb1CF15040 PRIMARY KEY CLUSTERED ( br_parameter_id ) )


CREATE TABLE albr_parameter_template (
br_parameter_template_id	int	NOT NULL
template_id	int
param_order	int,
param_type	nchar(2),
param_name	nvarchar(255),
string_value	nvarchar(1500),
int_value	int,
float_value	float,
date_value	datetime,
money_value	numeric(28,10),
money_value_id	int,
hours_value	numeric(14,4),
corp_data_name	nvarchar(65),
control_id	int,
active_status	smallint	NOT NULL
change_timestamp	datetime,
gmt_date_value	datetime,
CONSTRAINT PK__alb20C1E124 PRIMARY KEY CLUSTERED ( br_parameter_template_id ) )


CREATE TABLE alcc_card (
ccard_id	int	NOT NULL
cc_processor_id	int,
user_id	int	NOT NULL
ccard_account	nvarchar(255)
ccard_name1	nvarchar(255),
ccard_name2	nvarchar(255),
ccard_address1	nvarchar(255),
ccard_address2	nvarchar(255),
is_paid_by_company	smallint	DEFAULT 0 NOT NULL
ccard_limit_id	int,
ccard_limit	numeric(28,10),
ccard_issuer	nvarchar(255),
payment_type_id	int,
ccard_active_status	smallint
ccard_deactive_date	datetime,
pr_payment_type_id	int,
is_pr_card	smallint	DEFAULT 0 NOT NULL
card_type	nvarchar(255),
cost_center_id	int
project_number_id	int
glcode	nvarchar(255),
change_timestamp	datetime,
cardholder_id	nvarchar(255),
pci_token	nvarchar(255),
per_transaction_limit_id	int,
per_transaction_limit	numeric(28,10),
CONSTRAINT PK__alc24927208 PRIMARY KEY CLUSTERED ( ccard_id ) )


CREATE TABLE alcc_level3_detail (
cc_level3_detail_id	int	NOT NULL,
cc_transaction_id	int,
charge_date	datetime	NOT NULL,
native_amount	numeric(28,10)	NOT NULL,
native_amount_id	int	NOT NULL,
level3_code_id	int,
description	nvarchar(255),
sequence_number	int,
level3_identifier	nvarchar(255),
change_timestamp	datetime,
cct_reference	nvarchar(255),
CONSTRAINT PK478 PRIMARY KEY CLUSTERED ( cc_level3_detail_id ) )


CREATE TABLE alcc_transaction (
cc_transaction_id	int	NOT NULL,
ccard_id	int	NOT NULL,
merchant_id	int,	NOT NULL
currency_fmt_defn_id	int,
cct_reference	nvarchar(255),
cct_type	smallint	NOT NULL,
cct_amt_us_id	int,
cct_amt_us	numeric(28,10)	NOT NULL,
cct_posting_date	datetime	NOT NULL,
cct_date	datetime,
vat_amt_native_id	int,
vat_amt_native	numeric(28,10),
cct_amt_native_id	int,
cct_amt_native	numeric(28,10),
cct_currency_code	nchar(3),
cct_active_status	smallint	NOT NULL,
cct_import_timestamp	datetime,
external_system_id	nvarchar(255),
offline_user_id	int,
doc_date_offlined	datetime,
er_doc_id	int,
location_id	int,
expense_type_id	int,
cct_description	nvarchar(255),
cc_transaction_detail_id	int,
change_timestamp	datetime,
cct_status_int	int,
cct_sequence_number	int,
cct_statement_date	datetime,
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id ) )


CREATE TABLE alcc_transaction_detail (
cc_transaction_detail_id	int	NOT NULL,
airline_departure_date	datetime,
airline_routing	nvarchar(255),
airline_class_of_service	nvarchar(20),
airline_travel_agency_name	nvarchar(45),
airline_ticket_number	nvarchar(20),
car_rental_agreement_number	nvarchar(30),
hotel_arrival_date	datetime,
hotel_departure_date	datetime,
hotel_stay_duration	int,
hotel_folio_ref_number	nvarchar(30),
hotel_room_type	nvarchar(30),
hotel_room_amount	numeric(28,10),
hotel_room_amount_id	int,
hotel_room_tax_1	numeric(28,10),
hotel_room_tax_1_id	int,
hotel_room_tax_2	numeric(28,10),
hotel_room_tax_2_id	int,
hotel_phone_amount	numeric(28,10),
hotel_phone_amount_id	int,
hotel_phone_tax_1	numeric(28,10),
hotel_phone_tax_1_id	int,
hotel_phone_tax_2	numeric(28,10),
hotel_phone_tax_2_id	int,
hotel_restaurant_amount	numeric(28,10),
hotel_restaurant_amount_id	int,
hotel_restaurant_tax_1	numeric(28,10),
hotel_restaurant_tax_1_id	int,
hotel_restaurant_tax_2	numeric(28,10),
hotel_restaurant_tax_2_id	int,
hotel_room_service_amount	numeric(28,10),
hotel_room_service_amount_id	int,
hotel_room_service_tax_1	numeric(28,10),
hotel_room_service_tax_1_id	int,
hotel_room_service_tax_2	numeric(28,10),
hotel_room_service_tax_2_id	int,
hotel_tip_amount_1	numeric(28,10),
hotel_tip_amount_1_id	int,
hotel_tip_amount_2	numeric(28,10),
hotel_tip_amount_2_id	int,
hotel_others_amount	numeric(28,10),
hotel_others_amount_id	int,
hotel_others_tax_1	numeric(28,10),
hotel_others_tax_1_id	int,
hotel_others_tax_2	numeric(28,10),
hotel_others_tax_2_id	int,
hotel_room_rate	numeric(28,10),
hotel_room_rate_id	int,
hotel_room_tax_daily	numeric(28,10),
hotel_room_tax_daily_id	int,
hotel_laundry_amount	numeric(28,10),
hotel_laundry_amount_id	int,
hotel_gift_shop_amount	numeric(28,10),
hotel_gift_shop_amount_id	int,
hotel_movie_amount	numeric(28,10),
hotel_movie_amount_id	int,
hotel_bus_center_amount	numeric(28,10),
hotel_bus_center_amount_id	int,
hotel_health_club_amount	numeric(28,10),
hotel_health_club_amount_id	int,
hotel_total_tax	numeric(28,10),
hotel_total_tax_id	int,
origin_airport	nvarchar(10),
dest_airport	nvarchar(10),
booking_agent_id	int,
airline_class_of_service_id	int,
car_class_of_service_id	int,
hotel_class_of_service_id	int,
airline_domestic_or_intl	int,
passenger_name	nvarchar(255),
CONSTRAINT PK415 PRIMARY KEY CLUSTERED ( cc_transaction_detail_id ) )


CREATE TABLE alco_budget_history (
budget_history_id	int	NOT NULL
doc_type	int	NOT NULL
doc_id	int	NOT NULL
budget_id	int	NOT NULL
budget_line_id	int	NOT NULL
amount	numeric(28,10)	NOT NULL
amount_id	int	NOT NULL
action	int	NOT NULL
released	smallint
change_timestamp	datetime
CONSTRAINT PK563 PRIMARY KEY CLUSTERED ( budget_history_id ) )


CREATE TABLE alco_budget_line (
budget_line_id	int	NOT NULL
budget_id	int	NOT NULL
budget_account_id	int	NOT NULL
cost_center_id	int
project_id	int
budgeted_amount	numeric(28,10)	NOT NULL
budgeted_amount_id	int	NOT NULL
adjusted_amount	numeric(28,10)	NOT NULL
adjusted_amount_id	int	NOT NULL
allocated_amount	numeric(28,10)	NOT NULL
allocated_amount_id	int	NOT NULL
committed_amount	numeric(28,10)	NOT NULL
committed_amount_id	int	NOT NULL
change_timestamp	datetime
active_status	smallint	NOT NULL
CONSTRAINT PK562 PRIMARY KEY CLUSTERED ( budget_line_id )


CREATE TABLE alco_euro_rates (
euro_rates_id	int	NOT NULL
currency_fmt_defn_id	int	NOT NULL
exchange_rate	numeric(28,10)	NOT NULL
change_timestamp	datetime
CONSTRAINT PK__alc656C112C PRIMARY KEY CLUSTERED ( euro_rates_id ) )


CREATE TABLE alco_expense_type (
expense_type_id	int	NOT NULL
user_id	int
expense_type_label	nvarchar(255)	NOT NULL
category_label	nvarchar(255)
gl_code	nchar(20)
tax_deductable_percent	smallint	NOT NULL
itemization_only	smallint	DEFAULT 0 NOT NULL
field_disp_control	smallint
category_class	smallint
expense_special_code_id	int
expense_active_status	smallint	NOT NULL
major_account	nchar(10)
travel_category_id	int
external_system_id	nvarchar(255)
default_offline_perdiem_amt_id	int
default_offline_perdiem_amt	numeric(28,10)
change_timestamp	datetime
currency_fmt_defn_id	int
short_label	nvarchar(255)
perdiem_subtype	smallint
pd_definition_id	int
description	nvarchar(max)
not_selectable	int	DEFAULT 0 NOT NULL
image_name	nvarchar(255)
CONSTRAINT PK__alc6D0D32F4 PRIMARY KEY CLUSTERED ( expense_type_id ) )


CREATE TABLE alco_fx_rate (
fx_rate_id	int	NOT NULL
currency_fmt_defn_id	int
valid_date	datetime	NOT NULL
fx_rate	numeric(28,10)
change_timestamp	datetime
CONSTRAINT PK__alc787EE5A0 PRIMARY KEY CLUSTERED ( fx_rate_id ) )


CREATE TABLE alco_guest_wrapper (
guest_wrapper_id	int	NOT NULL
parent_id	int	NOT NULL
guest_id	int	NOT NULL
change_timestamp	datetime
native_amount	numeric(28,10)
native_amount_id	int
paid_in_amount	numeric(28,10)
paid_in_amount_id	int
adc1	nvarchar(255)
adc2	nvarchar(255)
adc3	nvarchar(255)
adc4	nvarchar(255)
adc5	nvarchar(255)
adc6	nvarchar(255)
combo_adc1	int
combo_adc2	int
combo_adc3	int
combo_adc4	int
combo_adc5	int
combo_adc6	int
address_id	int
CONSTRAINT PK__alc7C4F7684 PRIMARY KEY CLUSTERED ( guest_wrapper_id ) )


CREATE TABLE alco_mileage_rate (
mileage_rate_id	int	NOT NULL
reimburs_rate	float
take_effect_date	datetime	NOT NULL
mileage_active_status	smallint
expense_type_id	int
change_timestamp	datetime
description	nvarchar(40)	NOT NULL
expiration_date	datetime
per_passenger_rate	numeric(28,10)
distance_low	int
distance_high	int
mileage_threshold	int
rate_above_threshold	numeric(28,10)
distance_unit	nchar(3)	NOT NULL
CONSTRAINT PK__alc0E6E26BF PRIMARY KEY CLUSTERED ( mileage_rate_id ) )


CREATE TABLE alco_report_fx_rate (
report_fx_rate_id	int	NOT NULL
from_currency_fmt_id	int	NOT NULL
to_currency_fmt_id	int	NOT NULL
from_valid_date	datetime
to_valid_date	datetime	NOT NULL
fx_rate	numeric(28,10)
change_timestamp datetime
CONSTRAINT PK544 PRIMARY KEY CLUSTERED ( report_fx_rate_id ) )


CREATE TABLE alco_user (
user_id	int	NOT NULL
cost_center_id	int
user_full_name	nvarchar(255)	NOT NULL
user_first_name	nvarchar(255)
user_middle_initial	nchar(1)
user_last_name	nvarchar(255)
employee_number	nvarchar(255)
user_password	nvarchar(255)	NOT NULL
user_title	nvarchar(255)
user_location	nvarchar(255)
user_telephone	nvarchar(255)
user_mailstop	nvarchar(255)
user_email_address	nvarchar(255)
email_product	nvarchar(255)
user_login	nvarchar(255)
user_dept_code	nchar(10)
user_company_code	nchar(10)
user_fax_number	nvarchar(255)
payroll_system_code	nvarchar(255)
active_status	smallint	NOT NULL
ssn	nvarchar(255)
creation_time	datetime	NOT NULL
currency_fmt_defn_id	int	NOT NULL
country_id	int
has_credit_cards	smallint
cc_expiration_date	datetime
pso_data	int
external_data	nvarchar(255)
set_of_books_id	int
remote_access_device_id	nvarchar(255)
auth_amount	numeric(28,10)
auth_amount_id	int
pr_auth_amount	numeric(28,10)
pr_auth_amount_id	int
system_code_1	nvarchar(255)
system_code_2	nvarchar(255)
system_code_3	nvarchar(255)
system_code_4	nvarchar(255)
system_code_5	nvarchar(255)
system_code_6	nvarchar(255)
system_code_7	nvarchar(255)
system_code_8	nvarchar(255)
start_date	datetime
end_date	datetime
system_date_1	datetime
system_date_2	datetime
office_id	int
out_of_office	smallint	DEFAULT 0 NOT NULL
change_timestamp	datetime
audit_group_id	int
default_mileage_rate_id	int
is_thin_client_user	smallint	NOT NULL
preferred_locale	nvarchar(32)
second_currency_id	int
user_email_address_2	nvarchar(255)
user_email_address_3	nvarchar(255)
commute_miles	numeric(26,16)
validation_id	nvarchar(255)
identity2	nvarchar(36)
lc_user_login AS ( lower(user_login) )
preferred_timezone	nvarchar(255)	NULL
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED ( user_id ) )


CREATE TABLE alco_vat_account (
vat_account_id	int	NOT NULL
set_of_books_id	int	NOT NULL
parent_id	int
vat_account_name	nvarchar(255)	NOT NULL
vat_account_description	nvarchar(255)
vatd_gl_account	nvarchar(255)
vatd_gl_subaccount	nvarchar(255)
vat_percent	float
claimed_percent	float
vat_deductible_percent	float
vat_deductible_constant	numeric(28,10)
vat_deductible_constant_id	int
vat_deductible_per_mile	numeric(28,10)
vat_deductible_per_mile_id	int
vat_deductible_per_guest	numeric(28,10)
vat_deductible_per_guest_id	int
spending_locale_id	int
active_status	int	NOT NULL
vatdsub0	nvarchar(18)
vatdsub1	nvarchar(18)
vatdsub2	nvarchar(18)
vatdsub3	nvarchar(18)
vatdsub4	nvarchar(18)
vatdsub5	nvarchar(18)
vatdsub6	nvarchar(18)
vatdsub7	nvarchar(18)
vatdsub8	nvarchar(18)
vatdsub9	nvarchar(18)
change_timestamp	datetime
vat_rate_per_mile	numeric(28,10)
vat_rate_per_mile_id	int
pst_percent	float
pst_claimed_percent	float
include_gst_in_pst	int	DEFAULT 0 NOT NULL
pst_gl_account	nvarchar(255)
pst_gl_subaccount	nvarchar(255)
pstsub0	nvarchar(18)
pstsub1	nvarchar(18)
pstsub2	nvarchar(18)
pstsub3	nvarchar(18)
pstsub4	nvarchar(18)
pstsub5	nvarchar(18)
pstsub6	nvarchar(18)
pstsub7	nvarchar(18)
pstsub8	nvarchar(18)
pstsub9	nvarchar(18)
vat_unclaimed_gl_account	nvarchar(255)
vat_unclaimed_gl_subaccount	nvarchar(255)
vat_unclaimed_sub0	nvarchar(18)
vat_unclaimed_sub1	nvarchar(18)
vat_unclaimed_sub2	nvarchar(18)
vat_unclaimed_sub3	nvarchar(18)
vat_unclaimed_sub4	nvarchar(18)
vat_unclaimed_sub5	nvarchar(18)
vat_unclaimed_sub6	nvarchar(18)
vat_unclaimed_sub7	nvarchar(18)
vat_unclaimed_sub8	nvarchar(18)
vat_unclaimed_sub9	nvarchar(18)
pst_unclaimed_gl_account	nvarchar(255)
pst_unclaimed_gl_subaccount	nvarchar(255)
pst_unclaimed_sub0	nvarchar(18)
pst_unclaimed_sub1	nvarchar(18)
pst_unclaimed_sub2	nvarchar(18)
pst_unclaimed_sub3	nvarchar(18)
pst_unclaimed_sub4	nvarchar(18)
pst_unclaimed_sub5	nvarchar(18)
pst_unclaimed_sub6	nvarchar(18)
pst_unclaimed_sub7	nvarchar(18)
pst_unclaimed_sub8	nvarchar(18)
pst_unclaimed_sub9	nvarchar(18)
tax_deduction_method	int
vat_on_personal_expenses	int	DEFAULT 0 NOT NULL
vat_javascript_id	int
expense_account_list	nvarchar(255)
effective_date	datetime
until_date	datetime
CONSTRAINT PK__alc58D1301D PRIMARY KEY CLUSTERED ( vat_account_id ) )


CREATE TABLE alct_name_value_pair (
name_value_pair_id	int	NOT NULL
parent_id	int
name	nvarchar(255)	NOT NULL
display_string	nvarchar(255)	NOT NULL
type	nchar(1)	NOT NULL
int_value	int
float_value	float
date_value	datetime
string_value	nvarchar(255)
hours_value	numeric(14,4)
currency_value	numeric(28,10)
currency_value_id	int
bobref_value_type	int
bobref_value	int
CONSTRAINT PK__alc04AFB25B PRIMARY KEY CLUSTERED ( name_value_pair_id ) )


CREATE TABLE aler_expense_line_adjustment (
adjustment_id	int	NOT NULL
exp_line_item_id	int
sequence_number	int	NOT NULL
change_timestamp	datetime
amount	numeric(28,10)	NOT NULL
amount_id	int	NOT NULL
new_balance	numeric(28,10)	NOT NULL
new_balance_id	int	NOT NULL
adjuster_id	int
CONSTRAINT PK__ale1B9317B3 PRIMARY KEY CLUSTERED ( adjustment_id ) )


CREATE TABLE aler_expense_line_item (
exp_line_item_id	int	NOT NULL
parent_id	int
payment_type_id	int
expense_type_id	int
vendor_id	int
currency_fmt_defn_id	int
cc_transaction_id	int
cct_reference	nvarchar(255)
expense_item_date	datetime
expense_description	nvarchar(255)
erli_amt_paid_id	int
erli_amt_paid	numeric(28,10)
erli_native_amt_id	int
erli_native_amt	numeric(28,10)
purpose_id	int
odometer_start	numeric(15,5)
odometer_end	numeric(15,5)
miles	numeric(15,5)
reimburs_rate	float
erli_exch_rate	numeric(26,16)
exp_item_note	nchar(5)
item_gl_code	nchar(20)
erli_amt_approv_id	int
erli_amt_approv	numeric(28,10)
item_overridden	smallint
has_receipt	smallint
receipt_checked	smallint
is_approved	smallint
tr_number	nvarchar(255)
location_id	int
chg_allocation_option	smallint
chg_balancing_option	smallint
is_personal	smallint
is_itemized	smallint
is_itemization	smallint
has_notes	smallint
use_euro	smallint
doc_based_allocation	smallint
perdiem_amount_id	int
perdiem_amount	numeric(28,10)
hh_transaction_id	int
recurring_id	int
recurring_count	int
exch_rate_default	numeric(26,16)
expense_account_id	int
vat_account_id	int
td_amount_id	int
td_amount	numeric(28,10)
ntd_amount_id	int
ntd_amount	numeric(28,10)
vat_amount_id	int
vat_amount	numeric(28,10)
approved_exchange_rate	numeric(26,16)
vat_amount_override	numeric(28,10)
vat_amount_override_id	int
vat_miles_override	numeric(15,5)
vat_guests_override	int
expense_item_depart_date	datetime
origin_airport	nvarchar(10)
dest_airport	nvarchar(10)
booking_agent	int
ticket_status	int
ticket_number	nvarchar(50)
car_rental_agreement	nvarchar(50)
airline_class_of_service	int
car_class_of_service	int
hotel_class_of_service	int
is_vat_receipt	smallint
mileage_rate_id	int
mileage_passenger_num	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
pst_amount	numeric(28,10)
pst_amount_id	int
pst_amount_override	numeric(28,10)
pst_amount_override_id	int
vat_unclaimed_amount	numeric(28,10)
vat_unclaimed_amount_id	int
pst_unclaimed_amount	numeric(28,10)
pst_unclaimed_amount_id	int
guest_count	int
flex_field_string_1	nvarchar(255)
flex_field_string_2	nvarchar(255)
flex_field_string_3	nvarchar(255)
flex_field_string_4	nvarchar(255)
flex_field_integer_1	int
flex_field_integer_2	int
flex_field_date_1	datetime
flex_field_date_2	datetime
flex_field_amount_1	numeric(28,10)
flex_field_amount_1_id	int
flex_field_amount_2	numeric(28,10)
flex_field_amount_2_id	int
flex_field_location_1_id	int
flex_field_ddlb_1_id	int
flex_field_ddlb_2_id	int
flex_field_ddlb_3_id	int
flex_field_ddlb_4_id	int
flex_field_ddlb_5_id	int
is_quick_item	smallint
quick_item_error	smallint
mileage_route_id	int
original_vat_account_id	int
commute_miles	numeric(26,16)
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
airline_domestic_or_intl	int
guest_no_show_count	int
passenger_name	nvarchar(255)
creator_client_type	int
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id ) )


CREATE TABLE aler_expense_report (
exp_rep_data_id	int	NOT NULL
user_id	int
cash_adv_amount_id	int
cash_adv_amount	numeric(28,10)
company_charges_id	int
company_charges	numeric(28,10)
amount_due_emp_id	int
amount_due_emp	numeric(28,10)
amount_due_co_id	int
amount_due_co	numeric(28,10)
auth_amt_id	int
auth_amt	numeric(28,10)
total_expense_id	int
total_expense	numeric(28,10)
exp_rep_date_created	datetime
exp_rep_date_filed	datetime
er_date_from	datetime
er_date_to	datetime
show_currency	smallint
show_bill_to	smallint
separate_bill	smallint
per_diem	nchar(6)
doc_status	int
exp_rep_is_approved	nchar(6)
er_paid_on	datetime
er_amt_paid	numeric(28,10)
er_amt_paid_id	int
er_payment_number	nvarchar(255)
exp_rep_title	nvarchar(255)
envelope_id	nvarchar(255)
purpose_id	int
exp_emp_dept	nvarchar(255)
exp_emp_company	nvarchar(255)
applied_lcf_id	int
applied_lcf	numeric(28,10)
applied_adj_id	int
applied_adj	numeric(28,10)
corp_charge_total_id	int
corp_charge_total	numeric(28,10)
remaining_lcf_id	int
remaining_lcf	numeric(28,10)
corp_charge_date	datetime
corp_charge_amt_paid_id	int
corp_charge_amt_paid	numeric(28,10)
exp_note	nvarchar(5)
chg_allocation_option	smallint
chg_balancing_option	smallint
corp_card_type	smallint
business_model	smallint
company_pays_cards	numeric(28,10)
company_pays_cards_id	int
generated_lcf_id	int
generated_lcf	numeric(28,10)
receipt_received	datetime
date_approved	datetime
payment_made	numeric(28,10)
payment_made_id	int
receipt_packet_expected	smallint
receipt_email_deadline_date	datetime
receipt_hitlist_deadline_date	datetime
create_location_id	int
flex_field_string_1	nvarchar(255)
flex_field_string_2	nvarchar(255)
flex_field_string_3	nvarchar(255)
flex_field_string_4	nvarchar(255)
flex_field_integer_1	int
flex_field_integer_2	int
flex_field_date_1	datetime
flex_field_date_2	datetime
flex_field_amount_1	numeric(28,10)
flex_field_amount_1_id	int
flex_field_amount_2	numeric(28,10)
flex_field_amount_2_id	int
flex_field_location_1_id	int
flex_field_ddlb_1_id	int
flex_field_ddlb_2_id	int
flex_field_ddlb_3_id	int
flex_field_ddlb_4_id	int
flex_field_ddlb_5_id	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK__ale1F63A897 PRIMARY KEY CLUSTERED ( exp_rep_data_id ) )


CREATE TABLE aler_line_allocation (
line_allocation_id	int	NOT NULL
exp_line_item_id	int	NOT NULL
percent_allotted	numeric(26,16)
base_amount_id	int
base_amount	numeric(28,10)
native_amount_id	int
native_amount	numeric(28,10)
is_approved	smallint
cost_center_id	int
project_number_id	int
is_billable	smallint
CONSTRAINT PK__ale251C81ED PRIMARY KEY CLUSTERED ( line_allocation_id ) )


CREATE TABLE aler_overage (
overage_id	int	NOT NULL
parent_id	int	NOT NULL
overage_date	datetime	NOT NULL
total_actual_amount	numeric(28,10)
total_actual_amount_id	int
total_perdiem_amount	numeric(28,10)
total_perdiem_amount_id	int
gl_account	nvarchar(255)
overage_group_id	int	NOT NULL
total_personal_amount	numeric(28,10)
total_personal_amount_id	int
overage_end_date	datetime
CONSTRAINT PK307 PRIMARY KEY CLUSTERED ( overage_id ) )


CREATE TABLE aler_overage_lines (
overage_lines_id	int	NOT NULL
overage_id	int	NOT NULL
overage_line_type	int	NOT NULL
exp_line_item_id	int
perdiem_expense_type	int
perdiem_amount	numeric(28,10)
perdiem_amount_id	int
CONSTRAINT PK308 PRIMARY KEY CLUSTERED ( overage_lines_id ) )


CREATE TABLE aler_review_policies (
review_policy_id	int	NOT NULL
expense_type_id	int	NOT NULL
amount	numeric(28,10)	NOT NULL
amount_id	int
currency_fmt_defn_id	int	NOT NULL
change_timestamp	datetime
rule_title	nvarchar(255)
rule_policy	nvarchar(max)
rule_interact_message	nvarchar(510)
rule_report_message	nvarchar(510)
rule_severity	int
rule_notify	int
locale	int
active_status	int
routing_type_id	int
CONSTRAINT PK1 PRIMARY KEY CLUSTERED ( review_policy_id ) )


CREATE TABLE aler_user_balance_history (
user_bal_hist_id	int	NOT NULL
er_user_pref_id	int
user_causing_change_id	int	NOT NULL
history_sequence_number	int	NOT NULL
history_timestamp	datetime	NOT NULL
transaction_type_code	int	NOT NULL
lcf_change_amount	numeric(28,10)
lcf_change_amount_id	int
lcf_new_balance	numeric(28,10)
lcf_new_balance_id	int
pa_change_amount	numeric(28,10)
pa_change_amount_id	int
pa_new_balance	numeric(28,10)
pa_new_balance_id	int
doc_tracking_id	nvarchar(255)
exp_rep_data_id	int
CONSTRAINT PK__ale2CBDA3B5 PRIMARY KEY CLUSTERED ( user_bal_hist_id )


CREATE TABLE aler_user_preference (
er_user_pref_id	int	NOT NULL
user_id	int	NOT NULL
unfiled_days_thresh	int
alert_on_br_violation	smallint
display_doc_number	smallint
display_hist_thresh	int
wf_initial_view	int
cost_center_id	int
lcf_total_id	int
lcf_total	numeric(28,10)
pending_adj_total_id	int
pending_adj_total	numeric(28,10)
project_number_id	int
cur_balance_hist_seq	int
change_timestamp	datetime
CONSTRAINT PK__ale2EA5EC27 PRIMARY KEY CLUSTERED ( er_user_pref_id )


CREATE TABLE alhh_transaction (
hh_transaction_id	int	NOT NULL
user_id	int	NOT NULL
hh_device_id	int
hht_date	datetime	NOT NULL
hh_exp_type_map_id	int	NOT NULL
hht_amount_id	int
hht_amount	numeric(28,10)	NOT NULL
payment_type_id	int
vendor_id	int
location_id	int
hht_attendees	nvarchar(255)
hht_note	nvarchar(255)
hht_document_id	int
hht_import_timestamp	datetime
hht_active_status	smallint	NOT NULL
hht_miles	numeric(15,5)
hht_palm_internal_id	int
CONSTRAINT PK__alh3CF40B7E PRIMARY KEY CLUSTERED ( hh_transaction_id )


CREATE TABLE almt_extension (
extension_id	int
name	nvarchar(255)	NOT NULL
type	int	NOT NULL
value_int	int
value_float	float
value_date	datetime
value_string	nvarchar(5,10)
value_hours	numeric(14,4)
value_currency_id	int
value_currency	numeric(28,10)
value_bobref_type	int
value_bobref	int
parent_id	int	NOT NULL


CREATE TABLE alpd_conus_oconus_deduction (
conus_oconus_deduction_id	int	NOT NULL
locale	smallint
effective_date	datetime
active_status	int	NOT NULL
change_timestamp	datetime
perdiem_rate_id	int
perdiem_rate	numeric(28,10)	NOT NULL
breakfast_deduction_amt_id	int
breakfast_deduction_amt	numeric(28,10)
lunch_deduction_amt_id	int
lunch_deduction_amt	numeric(28 ,10)
dinner_deduction_amt_id	int
dinner_deduction_amt	numeric(28,10)
incidentals_deduction_amt_id	int
incidentals_deduction_amt	numeric(28,10)
CONSTRAINT PK441 PRIMARY KEY CLUSTERED ( conus_oconus_deduction_id )


CREATE TABLE alpd_conus_oconus_perdiem (
conus_oconus_perdiem_id	int	NOT NULL
location_id	int
max_lodging_amt_id	int
max_lodging_amt	numeric(28,10)
non_govt_meals_amt_id	int
non_govt_meals_amt	numeric(28,10)
proportional_meals_amt_id	int
proportional_meals_amt	numeric(28,10)
incidental_amt_id	int
incidental_amt	numeric(28,10)
footnote_amt_id	int
footnote_amt	numeric(28,10)
footnote_rate_amt_id	int
footnote_rate_amt	numeric(28,10)
per_diem_amt_id	int
per_diem_amt	numeric(28,10)
effective_date	datetime
active_status	int	NOT NULL
change_timestamp	datetime
CONSTRAINT PK440 PRIMARY KEY CLUSTERED ( conus_oconus_perdiem_id )


CREATE TABLE alpd_eur_deduction (
pd_deduction_id	int	NOT NULL
pd_definition_id	int	NOT NULL
locale	smallint
long_term_stay	smallint
breakfast	smallint
lunch	smallint
dinner	smallint
deduction_type	smallint
deduction_amount	numeric(28,10)
deduction_amount_id	int
deduction_percentage	float
effective_date	datetime
active_status	smallint	NOT NULL
change_timestamp	datetime
CONSTRAINT PK__alpddeductions PRIMARY KEY CLUSTERED ( pd_deduction_id )


CREATE TABLE alpd_eur_rate (
pd_rate_id	int	NOT NULL
pd_definition_id	int	NOT NULL
location_id	int
min_time_at_location	smallint
per_hour	smallint
overnight_stay	smallint
first_day_of_trip	smallint
last_day_of_trip	smallint
rate_value	numeric(28,10)	NOT NULL
rate_value_id	int	NOT NULL
effective_date	datetime
active_status	smallint	NOT NULL
change_timestamp	datetime
CONSTRAINT PK__alpdrates PRIMARY KEY CLUSTERED ( pd_rate_id )


CREATE TABLE alpd_generic_rate (
rate_id	int	NOT NULL
pd_definition_id	int	NOT NULL
location_id	int
rate_value	numeric(28 ,10)	NOT NULL
rate_value_id	int
flex_string_1	nvarchar(255)
flex_string_2	nvarchar(255)
flex_string_3	nvarchar(255)
flex_string_4	nvarchar(255)
flex_string_5	nvarchar(255)
effective_date	datetime
active_status	smallint	NOT NULL
change_timestamp	datetime
CONSTRAINT PK566 PRIMARY KEY CLUSTERED ( rate_id )


CREATE TABLE alpd_perdiem_line_data (
pd_line_data_id	int	NOT NULL
exp_line_item_id	int	NOT NULL
private_nightstay_address	nvarchar(255)
first_day_of_trip	smallint
last_day_of_trip	smallint
change_timestamp	datetime
time_at_location	smallint
start_time	datetime
end_time	datetime
overnight_stay	smallint
long_term_stay	smallint
breakfast	smallint
lunch	smallint
dinner	smallint
meal_amount	numeric(28,10)
meal_amount_id	int
CONSTRAINT PK__alpdli PRIMARY KEY CLUSTERED ( pd_line_data_id )


CREATE TABLE alpr_invoice (
invoice_id	int	NOT NULL
title	nvarchar(255)
date_created	datetime
date_submitted	datetime
date_approved	datetime
invoice_number	nvarchar(255)
invoice_date	datetime
invoice_due_date	datetime
total_amount	numeric(28,10)
total_amount_id	int
total_calculated_amount	numeric(28,10)
total_calculated_amount_id	int
total_discounted_amount	numeric(28,10)
total_discounted_amount_id	int
is_approved	smallint
envelope_id	nvarchar(255)
paid_date	datetime
paid_amount	numeric(28,10)
paid_amount_id	int
payment_number	nvarchar(255)
chg_allocation_option	smallint
chg_balancing_option	smallint
pr_vendor_id	int
send_to_id	smallint	NOT NULL
discount_pay_by_date	datetime
pr_purpose_id	int
invoice_received	datetime
invoice_packet_expected	smallint
inv_recpt_email_deadline	datetime
inv_recpt_hitlist_deadline	datetime
requested_payment_date	datetime
voucher_number	nvarchar(255)
special_handling	nvarchar(255)
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK456 PRIMARY KEY CLUSTERED ( invoice_id )


CREATE TABLE alpr_invoice_line_item (
invoice_line_item_id	int	NOT NULL
invoice_id	int	NOT NULL
item_number	nvarchar(255)
item_description	nvarchar(255)
invoiced_quantity	int
unit_of_measure_id	int
unit_price_amount	numeric(28,10)
unit_price_amount_id	int
total_price_amount	numeric(28,10)
total_price_amount_id	int
check_request_type_id	int
chg_allocation_option	smallint
chg_balancing_option	smallint
doc_based_allocation	smallint
is_approved	smallint
expense_account_id	int
vat_account_id	int
guest_count	int
td_gl_account_override	nvarchar(255)
td_gl_subaccount_override	nvarchar(255)
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
guest_no_show_count	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK457 PRIMARY KEY CLUSTERED ( invoice_line_item_id )


CREATE TABLE alpr_line_item (
pr_line_item_id	int	NOT NULL
pr_document_id	int
pr_payment_type_id	int
item_id	int
prli_description	nvarchar(255)
prli_is_capital_expenditure	int
prli_quantity	int
prli_quantity_approved	int
prli_is_taxable	int
pr_category_id	int
item_description	nvarchar(255)
unit_of_measure_id	int
prli_unit_price	numeric(28,10)
prli_unit_price_id	int
prli_total_price	numeric(28,10)
prli_total_price_id	int
pr_vendor_id	int
prli_reason_for_purchase	nvarchar(255)
prli_recipient	nvarchar(255)
prli_deliver_by	datetime
prli_chg_alloc_option	smallint
prli_chg_alloc_bal_option	smallint
prli_note	nvarchar(max)
manufacturer_id	int
item_status	nvarchar(255)
item_number	nvarchar(255)
imported_from_template	smallint
manager	nvarchar(255)
room_number	nvarchar(255)
location	nvarchar(255)
start_date	datetime
end_date	datetime
op_sys_id	int
promised_by_date	datetime
ext_po_pr_number	nvarchar(255)
user_message_name	nvarchar(255)
variance_qty	int
po_create_timestamp	datetime
internal_status	int
old_unit_price_id	int
old_unit_price	numeric(28,10)
old_uom	int
partnum_ext	nvarchar(255)
available_qty	int
real_time_check_timestamp	datetime
max_back_order_qty	int
max_received_qty	int
purchase_order_id	int
item_source	int
cbr_approved	smallint
CONSTRAINT PK__alp7EC1CEDB PRIMARY KEY CLUSTERED ( pr_line_item_id )


CREATE TABLE alpr_purchase_order (
purchase_order_id	int	NOT NULL
pr_document_id	int
po_number	nvarchar(255)
document_id	nvarchar(255)
create_date	datetime
pr_vendor_id	int
total_cost	numeric(28,10)
total_cost_id	int
status	nvarchar(255)
total_costoutstanding	numeric(28,10)
total_costoutstanding_id	int
pr_payment_type_id	int
first_receive_by_date	datetime
last_receive_by_date	datetime
address_id	int
pastduenotified	smallint
all_received_status	smallint
CONSTRAINT PK__alp0A338187 PRIMARY KEY CLUSTERED ( purchase_order_id )


CREATE TABLE alpr_purchase_requisition (
pr_document_id	int	NOT NULL
user_id	int
pr_title	nvarchar(255)
pr_purpose_id	int
date_created	datetime
date_submitted	datetime
date_approved	datetime
pr_tax_total	numeric(28,10)
pr_tax_total_id	int
pr_shipping_cost	numeric(28,10)
pr_shipping_cost_id	int
total_expense	numeric(28,10)
total_expense_id	int
pr_is_sourcing_request	smallint
pr_vendor_id	int
manufacturer_id	int
ship_to_id	int
pr_chg_alloc_option	smallint
pr_chg_balancing_option	smallint
doc_note	nvarchar(5)
po_number	nvarchar(255)
payment_terms	nvarchar(255)
professional_buyer_id	int
is_required	smallint
envelope_id	nvarchar(255)
bill_to_id	int
shopping_cart_xml	nvarchar(max)
CONSTRAINT PK__alp0C1BC9F9 PRIMARY KEY CLUSTERED ( pr_document_id )


CREATE TABLE alpr_vendor_terms (
vendor_terms_id	int	NOT NULL
name	nvarchar(255)	NOT NULL
term_name	nvarchar(255)
term_days	int
discount_amount_type	smallint
discount_amount_percentage	numeric(20,10)
discount_amount	numeric(28,10)
discount_amount_id	int
discount_term_days	int
is_global_default	smallint	DEFAULT 0 NOT NULL
active_status	smallint
change_timestamp	datetime
CONSTRAINT PK459 PRIMARY KEY CLUSTERED ( vendor_terms_id )


CREATE TABLE altr_line_item (
tr_line_item_id	int	NOT NULL
tr_document_id	int	NOT NULL
tr_item_type_id	int	NOT NULL
cost_id	int
cost	numeric(28,10)
tax_cost_id	int
tax_cost	numeric(28,10)
note	nvarchar(max)
purpose	int
vendor	int
from_location	int
from_date	datetime
from_time	datetime
to_location	int
to_date	datetime
to_time	datetime
class_of_service	int
daily_rate_id	int
daily_rate	numeric(28,10)
cust_def_1	nvarchar(255)
cust_def_2	nvarchar(255)
cust_def_3	nvarchar(255)
daily_rate_native_id	int
daily_rate_native	numeric(28,10)
currency_fmt_defn_id	int
exch_rate	numeric(26,16)
use_euro	smallint
miles	numeric(15,5)
reimburse_rate	float
has_notes	smallint
average_cost_id	int
average_cost	numeric(28,10)
is_imported	smallint
description1	nvarchar(255)
description2	nvarchar(255)
ext_booking_key	nvarchar(255)
exch_rate_default	numeric(26,16)
trip_type	nchar(2)
from_airport_code	nchar(3)
to_airport_code	nchar(3)
lowest_airfare	numeric(28,10)
lowest_airfare_id	int
lowest_hotel_rate	numeric(28,10)
lowest_hotel_rate_id	int
booking_source	nchar(2)
agency_name	nvarchar(40)
guest_count	int
guest_entry_mode	smallint	DEFAULT 0 NOT NULL
guest_amounts_equal	smallint	DEFAULT 1 NOT NULL
guest_no_show_count	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_id )


CREATE TABLE altr_travel_item (
tr_item_type_id	int	NOT NULL
expense_type_id	int	NOT NULL
tr_item_label	nvarchar(255)	NOT NULL
tr_item_icon	nvarchar(255)
travel_category_id	int	NOT NULL
daily_rate_based	smallint	NOT NULL
taxable	smallint	NOT NULL
use_average_cost	smallint
active_status	smallint	NOT NULL
short_label	nvarchar(255)
default_offline_perdiem_amt_id	int
default_offline_perdiem_amt	numeric(28,10)
perdiem_subtype	smallint
pd_definition_id	int
include_last_day	smallint	DEFAULT 0 NOT NULL
instructions	nvarchar(max)
CONSTRAINT PK__alt370627FE PRIMARY KEY CLUSTERED ( tr_item_type_id )


CREATE TABLE altr_travel_request (
tr_document_id	int	NOT NULL
user_id	int	NOT NULL
tr_title	nvarchar(255)
tr_purpose	int
tr_num_going	int
tr_date_created	datetime
tr_date_filed	datetime
tr_date_from	datetime
tr_date_to	datetime
tr_tot_air_id	int
tr_tot_air	numeric(28,10)
tr_tot_hotel_id	int
tr_tot_hotel	numeric(28,10)
tr_tot_htax_id	int
tr_tot_htax	numeric(28,10)
tr_tot_car_id	int
tr_tot_car	numeric(28,10)
tr_tot_ctax_id	int
tr_tot_ctax	numeric(28,10)
tr_tot_meals_id	int
tr_tot_meals	numeric(28,10)
tr_tot_other_id	int
tr_tot_other	numeric(28,10)
tr_total_cost_id	int
tr_total_cost	numeric(28,10)
tr_emp_comp	nvarchar(255)
tr_emp_dept	nvarchar(255)
tr_tracking_num	nvarchar(255)
doc_note	nvarchar(5)
trip_type_id	int
tr_date_approved	datetime
chg_allocation_option	smallint
chg_balancing_option	smallint
ord_key	nvarchar(255)
integration_partner_id	int
max_air_ticket_amt_id	int
max_air_ticket_amt	numeric(28,10)
itinerary_state	int
create_location_id	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK__alt3CBF0154 PRIMARY KEY CLUSTERED ( tr_document_id )


CREATE TABLE alts_line_item (
ts_line_item_id	int	NOT NULL
ts_document_id	int	NOT NULL
project_number_id	int
ts_date	datetime	NOT NULL
ts_hours	numeric(14,4)
hourly_charge_type_id	int
charge_type_id	int
ts_start_time	datetime
ts_end_time	datetime
location_id	int
charge_role_id	int
ts_note	nchar(5)
pa_export_status	int
app_ts_hours	numeric(14,4)
app_hourly_charge_type_id	int
ts_billable_rate	numeric(28,10)
ts_billable_rate_id	int
currency_fmt_defn_id	int
cost_center_id	int
change_timestamp	datetime
description	nvarchar(255)
attd_in1	datetime
attd_out1	datetime
attd_in2	datetime
attd_out2	datetime
attd_in3	datetime
attd_out3	datetime
attd_in4	datetime
attd_out4	datetime
attd_in5	datetime
attd_out5	datetime
attd_in6	datetime
attd_out6	datetime
attd_absence_hours	numeric(14,4)
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK__alt51BA1E3A PRIMARY KEY CLUSTERED ( ts_line_item_id )


CREATE TABLE alts_timesheet (
ts_document_id	int	NOT NULL
user_id	int	NOT NULL
ts_title	nvarchar(255)
period_start	datetime
period_end	datetime
date_created	datetime
date_submitted	datetime
date_approved	datetime
total_hours	numeric(14,4)
report_period_id	int
work_sched_id	int
holiday_sched_id	int
labor_status_id	int
emp_status_id	int
emp_comp	nvarchar(255)
emp_dept	nvarchar(255)
ts_tracking_num	nvarchar(255)
doc_note	nvarchar(5)
pa_export_status	int
ts_billable_rate	numeric(28,10)
ts_billable_rate_id	int
ts_overrides_trail	nvarchar(max)
ts_attendance_overtime	numeric(7,2)
ts_attendance_double_time	numeric(7,2)
ts_project_overtime	numeric(7,2)
ts_project_double_time	numeric(7,2)
mgr_preapproved_ot	smallint
ts_attendance_triple_time	numeric(7,2)
ts_project_triple_time	numeric(7,2)
change_timestamp	datetime
ts_profile_id	int
creator_total	numeric(14,4)
create_location_id	int
job_class_id	int
weekend_schedule_id	int
is_incomplete	smallint	DEFAULT 0 NOT NULL
creator_client_type	int
CONSTRAINT PK__alt5F141958 PRIMARY KEY CLUSTERED ( ts_document_id )


CREATE TABLE alts_user_billable_rate (
ts_user_billable_rate_id	int	NOT NULL
user_id	int
project_number_id	int
charge_role_id	int
currency_fmt_defn_id	int	NOT NULL
ts_billable_rate	numeric(28,10)	NOT NULL
ts_billable_rate_id	int	NOT NULL
effective_date	datetime
expiration_date	datetime
create_user_id	int
create_timestamp	datetime
update_user_id	int
change_timestamp	datetime
CONSTRAINT PK__alt62E4AA3C PRIMARY KEY CLUSTERED ( ts_user_billable_rate_id )


CREATE TABLE alwf_work_item (
work_item_id	int	NOT NULL
parent_work_item_id	int
business_object_id	int	NOT NULL
document_id	nvarchar(255)	NOT NULL
activity_id	int	NOT NULL
doc_priority	int
doc_is_locked	smallint	NOT NULL
session_num	int
is_suspended	smallint	NOT NULL
appl_exceptions	smallint	DEFAULT 0 NOT NULL
overrides	smallint	DEFAULT 0 NOT NULL
doc_specific	nvarchar(255)
post_label	nvarchar(255)
doc_date_created	datetime
doc_date_modified	datetime
time_entered_queue	datetime
creator_user_id	int
owner_user_id	int
locked_by_user_id	int
suspended_by_user_id	int
released_by_user_id	int
proxy_user_id	int
project_number_id	int
doc_description	nvarchar(255)
bus_obj_type_id	int
offline_user_id	int
activity_number	int
doc_date_offlined	datetime
offline_special_code	int
split_count	int
recall_state	int
last_transition	int
audit_indicator	nvarchar(255)
doc_specific_indicator	datetime
change_timestamp	datetime
rejected_exceptions	int	DEFAULT 0 NOT NULL
only_one_reviewer_needed	smallint	DEFAULT 0 NOT NULL
is_exported	smallint	DEFAULT 0 NOT NULL
doc_date_submitted	datetime
audit_log	int	DEFAULT 0 NOT NULL
doc_specific_amount_id	int
doc_specific_amount	numeric(28,10)
doc_purpose	nvarchar(255)
doc_approved_amount_id	int
doc_approved_amount	numeric(28,10)
CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED ( work_item_id )