Modifications in Infor Expense Management 10.2.17
CREATE TABLE alco_signatures ( |
signature_id |
int |
NOT NULL |
doc_id |
int |
NOT NULL |
doc_type |
int |
|
user_id |
int |
|
for_whom |
int |
|
date_time |
datetime |
|
how |
int |
|
why |
nvarchar(255), |
|
change_timestamp |
datetime |
|
activity_id |
int |
|
CONSTRAINT PK__alc44CA3770 PRIMARY KEY CLUSTERED (
signature_id ) |
) |
CREATE TABLE alcc_transaction ( |
cc_transaction_id |
int |
NOT NULL |
ccard_id |
int |
NOT NULL |
merchant_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) |
|
tax1_included |
smallint |
|
tax2_included |
smallint |
|
source_transaction_id |
int |
|
marked_for_detach |
smallint |
DEFAULT 0 NOT NULL |
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED (
cc_transaction_id ) |
) |
CREATE TABLE alco_address ( |
address_id |
int |
NOT NULL |
user_id |
int |
|
address_name |
nvarchar(255) |
|
location_name |
nvarchar(255) |
|
addr_line_1 |
nvarchar(255) |
|
addr_line2 |
nvarchar(255) |
|
city_name |
nvarchar(255) |
|
state_id |
int |
|
zip_code |
nvarchar(20) |
|
country_id |
int |
|
phone_nbr |
nvarchar(255) |
|
url |
nvarchar(255) |
|
active_status |
smallint |
NOT NULL |
parent_id |
int |
|
contact_name |
nvarchar(255) |
|
contact_email_address |
nvarchar(255) |
|
contact_phone_number |
nvarchar(255) |
|
external_sys_id |
nvarchar(255) |
|
address_type |
smallint |
|
fax_phone_nbr |
nvarchar(40) |
|
change_timestamp |
datetime |
|
suggest_in_map |
smallint |
DEFAULT 0 NOT NULL |
CONSTRAINT PK__alc398D8EEE PRIMARY KEY CLUSTERED (
address_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(6,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 |
|
round_trip |
smallint |
|
end_date |
datetime |
|
export_status |
int |
|
void_status |
int |
|
reversal_line_item_id |
int |
|
original_location |
nvarchar(255) |
|
dest_location |
nvarchar(255) |
|
is_base_amount_adjusted |
smallint |
DEFAULT 0 NOT NULL |
CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED (
exp_line_item_id ) |
) |
CREATE TABLE aler_line_allocation ( |
line_allocation_id |
int |
|
exp_line_item_id |
int |
|
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 |
|
is_base_amount_adjusted |
smallint |
DEFAULT 0 NOT NULL |
CONSTRAINT PK__ale251C81ED PRIMARY KEY CLUSTERED (
line_allocation_id ) |
) |