Version 10.2.21

Modifications in 10.2.21

CREATE TABLE alex_company (
external_key nvarchar(255) NOT NULL
company_code nvarchar( 60 ) NOT NULL
company_name nvarchar(255) NOT NULL
active_status smallint NOT NULL
CONSTRAINT pk__al09de7bcc PRIMARY KEY CLUSTERED ( external_key )
)
CREATE TABLE alex_department (
external_key nvarchar(255) NOT NULL
department_code nvarchar( 60 ) NOT NULL
department_name nvarchar(255) NOT NULL
division_ekey nvarchar(255) NOT NULL
active_status smallint NOT NULL
CONSTRAINT pk__al0daf0cb0 PRIMARY KEY CLUSTERED ( external_key )
)
CREATE TABLE alex_division (
external_key nvarchar(255) NOT NULL
division_code nvarchar( 60 ) NOT NULL
division_name nvarchar(255) NOT NULL
company_ekey nvarchar(255) NOT NULL
active_status smallint NOT NULL
CONSTRAINT pk__al0bc6c43e PRIMARY KEY CLUSTERED (external_key )
)
CREATE TABLE alex_user (
external_key nvarchar(255) NOT NULL
employee_number nvarchar(255)
cost_center_ekey nvarchar(255) NOT NULL
user_first_name nvarchar(255) NOT NULL
user_middle_initial nvarchar(1)
user_last_name nvarchar(255) NOT NULL
user_password nvarchar(255) NOT NULL
user_title nvarchar(255)
user_location_name nvarchar(255)
user_telephone nvarchar(255)
user_mailstop nvarchar(255)
user_email_address nvarchar(255)
user_email_product nvarchar(255)
user_login_name nvarchar(255) NOT NULL
fax_number nvarchar(255)
payroll_system_code nvarchar(255)
active_status smallint NOT NULL
user_ssn nvarchar(40)
currency_ekey nvarchar(255) NOT NULL
country_ekey nvarchar(255)
default_approver_user_ekey nvarchar(255)
creation_date datetime NOT NULL
credit_card_ekey nvarchar(255)
credit_card_number nvarchar(40)
cc_processor_ekey nvarchar(255)
cc_payment_type_ekey nvarchar(255)
set_of_books_ekey nvarchar(255)
auth_amount numeric(28,10)
auth_amount_currency_ekey nvarchar(255)
pr_auth_amount numeric(28,10)
pr_auth_amount_currency_ekey nvarchar(255)
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
out_of_office smallint NOT NULL
proxy_can_submit smallint
audit_group_ekey nvarchar(255)
is_html_client_user smallint NOT NULL
second_currency_ekey nvarchar(255)
proxy_reviewer_can_submit smallint
commute_miles numeric(26,16)
identity2 nvarchar(36)
preferred_timezone nvarchar(255)
user_email_address_2 nvarchar(255)
user_email_address_3 nvarchar(255)
preferred_locale nvarchar(255)
fx_source_ekey nvarchar(255)
long_user_id nvarchar(128)
security_bod_control nvarchar(16)
CONSTRAINT pk__al1367e606 PRIMARY KEY CLUSTERED ( external_key )
)