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 )