Version 10.2.15

Modifications in Infor Expense Management 10.2.15

CREATE TABLE alco_mileage_waypoint (
waypoint_id	int	NOT NULL
mileage_route_id	int	NOT NULL
address	nvarchar(255)
sequence	int	NOT NULL
latitude	numeric(38,16)
longitude	numeric(38,16)
locale_string	nvarchar(10)
distance	numeric(15,5)
change_timestamp	datetime
is_via_waypoint	int
user_address	nvarchar(255)
CONSTRAINT PK548 PRIMARY KEY CLUSTERED ( waypoint_id ) )

CREATE TABLE alco_attachment_status (
attachment_status_id	int	NOT NULL
work_item_id	int	NOT NULL
attached_to_bob_type	int	NOT NULL
attached_to_all_docs	int
last_attached_work_item_id	int
CONSTRAINT PK__alc3B75D760 PRIMARY KEY CLUSTERED (attachment_status_id ) )

CREATE TABLE alco_notification_tracking (
notification_tracking_id	int	NOT NULL
notification_type	int	NOT NULL
work_item_id	int
user_id	int
notice_trigger_id	int
date_notification_sent	datetime	NOT NULL
notification_sent_count	int
date_notification_first_sent	datetime
CONSTRAINT PK437 PRIMARY KEY CLUSTERED ( notification_tracking_id ) )

CREATE TABLE alcc_card (
ccard_id	int	NOT NULL
cc_processor_id	int
user_id	int
ccard_account	nvarchar(255)	NOT NULL
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 NOT NULL
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)
is_reassignable	int
source_card_id	int
CONSTRAINT PK__alc24927208 PRIMARY KEY CLUSTERED ( ccard_id )
)

CREATE TABLE alcc_transaction (
cc_transaction_id	int	NOT NULL
ccard_id	int	NOT NULL
merchant_id	int
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
primary_iso_currency_code	nchar(3)
market_code	nvarchar(50)
global_client_origin_id	nvarchar(50)
local_country_iso_code	nchar(3)
transaction_type_code	nvarchar(10)
tax1	numeric(28,10)
tax1_id	int
tax2	numeric(28,10)
tax2_id	int
tax1_included	smallint
tax2_included	smallint
source_transaction_id	int
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id )
)

CREATE TABLE alpr_vendor_type (
vendor_type_id	int	NOT NULL
user_id	int
vendor_type_name	nvarchar(255)
vendor_type_active_status	smallint	NOT NULL
is_pcard_supported	smallint
ccard_id	int
external_sys_id	nvarchar(255)
marketsite_participant_id	nvarchar(255)
agreement_number	nvarchar(255)
delivery_date_constant	int
payment_term_id	int
response_date_constant	int
punch_out_identity	nvarchar(100)
punch_out_user_id	nvarchar(100)
punch_out_pwd	nvarchar(100)
punch_out_url	nvarchar(250)
order_request_url	nvarchar(250)
change_timestamp	datetime
app_type	int	NOT NULL
vendor_terms_id	int
vendor_id	nvarchar(255)
is_payment_taxable	smallint	DEFAULT 0 NOT NULL
tax_code	nvarchar(255)
tax_id	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)
is_one_time_only	smallint	DEFAULT 0 NOT NULL
CONSTRAINT PK__alp27C3E46E PRIMARY KEY CLUSTERED ( vendor_type_id )
)

CREATE TABLE alcc_merchant (
merchant_id	int	NOT NULL
sic_code_id	int
country_id	int
merchant_name	nvarchar(255)	NOT NULL
merchant_city	nvarchar(255)	NOT NULL
merchant_state	nvarchar(50)
merchant_country	nvarchar(30)
merchant_postal_code	nvarchar(20)	NOT NULL
merchant_std_sic_code	nvarchar(20)
merchant_given_sic_code	nvarchar(20)
merchant_vat_number	nchar(20)	NOT NULL
vendor_id	int
change_timestamp	datetime
merchant_legal_name	nvarchar(255)
merchant_address	nvarchar(255)
merchant_phone_number	nvarchar(255)
CONSTRAINT PK__alc2A4B4B5E PRIMARY KEY CLUSTERED ( merchant_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)
do_not_auto_itemize	int	DEFAULT 0 NOT NULL
CONSTRAINT PK__alc6D0D32F4 PRIMARY KEY CLUSTERED ( expense_type_id )
)