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 )
)