Modifications in Infor Expense Management 2022.01
| CREATE TABLE alcc_processor ( |
| cc_processor_id |
int |
NOT NULL |
| cc_processor_name |
nvarchar(255) |
|
| cc_processor_type |
smallint |
|
| cc_processor_flags |
int |
|
| cc_default_card_name |
nvarchar(255) |
NOT NULL |
| payment_type_id |
int |
|
| change_timestamp |
datetime |
|
| is_card_number_masked |
smallint
|
DEFAULT 0 NOT NULL |
| CONSTRAINT PK__alc2C3393D0 PRIMARY KEY CLUSTERED ( cc_processor_id ) |
|
|
| ) |
|
|
| CREATE TABLE alco_cost_center_config ( |
| cost_center_config_id |
int |
NOT NULL |
| segment_count |
int |
NOT NULL |
| segment_separator |
nvarchar(10) |
NOT NULL |
| active_status |
int |
|
| review_segment_label |
nvarchar(255) |
|
| review_segment_display_element |
nvarchar(80) |
|
| segment1_code |
nvarchar(60) |
|
| segment1_label |
nvarchar(255) |
|
| segment1_display_element |
nvarchar(80) |
|
| segment2_label |
nvarchar(255) |
|
| segment2_display_element |
nvarchar(80) |
|
| segment2_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment3_label |
nvarchar(255) |
|
| segment3_display_element |
nvarchar(80) |
|
| segment3_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment4_label |
nvarchar(255) |
|
| segment4_display_element |
nvarchar(80) |
|
| segment4_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment5_label |
nvarchar(255) |
|
| segment5_display_element |
nvarchar(80) |
|
| segment5_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment6_label |
nvarchar(255) |
|
| segment6_display_element |
nvarchar(80) |
|
| segment6_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment7_label |
nvarchar(255) |
|
| segment7_display_element |
nvarchar(80) |
|
| segment7_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment8_label |
nvarchar(255) |
|
| segment8_display_element |
nvarchar(80) |
|
| segment8_optional |
smallint |
DEFAULT 0 NOT NULL |
| segment9_label |
nvarchar(255) |
|
| segment9_display_element |
nvarchar(80) |
|
| segment9_optional |
smallint |
DEFAULT 0 NOT NULL |
| change_timestamp |
datetime |
|
| segment2_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment3_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment4_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment5_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment6_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment7_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment8_hidden |
smallint |
DEFAULT 0 NOT NULL |
| segment9_hidden |
smallint |
DEFAULT 0 NOT NULL |
|
none_text
|
nvarchar(50)
|
|
| CONSTRAINT PK536 PRIMARY KEY CLUSTERED ( cost_center_config_id ) |
|
|
| ) |
|
|
| CREATE TABLE alco_cumulative_miles ( |
| cumulative_mileage_id |
int |
NOT NULL |
| user_id |
int |
NOT NULL |
| period_id |
int |
NOT NULL |
| cumulative_miles |
numeric(15,5) |
|
| change_timestamp |
datetime |
|
| expense_type_id |
int |
|
| initial_cumulative_miles |
numeric(28,10)
|
|
| CONSTRAINT PK446 PRIMARY KEY CLUSTERED ( cumulative_mileage_id ) |
|
|
| ) |
|
|
| CREATE TABLE alco_mileage_rate ( |
| mileage_rate_id |
int |
NOT NULL |
| reimburs_rate |
numeric(18,7)
|
|
| 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 |
| currency_id |
int |
|
| CONSTRAINT PK__alc0E6E26BF PRIMARY KEY CLUSTERED ( mileage_rate_id ) |
|
|
| ) |
|
|
| CREATE TABLE alco_xmdbtool_pgp_keys ( |
| xmdbtool_pgp_keys_id |
int |
NOT NULL |
| key_data |
nvarchar(max) |
NOT NULL |
| key_type |
nvarchar(255) |
NOT NULL |
| key_pass |
nvarchar(max) |
NOT NULL |
| is_active |
int |
NOT NULL |
| key_status |
nvarchar(max) |
NOT NULL |
| change_timestamp |
datetime |
|
| is_kms |
int |
NOT NULL |
| encrypted_key |
varbinary(max) |
|
| kms_cipher |
varbinary(max) |
|
| random_number |
varbinary(max) |
|
|
recipient |
nvarchar(255) |
|
| CONSTRAINT PK598 PRIMARY KEY CLUSTERED ( xmdbtool_pgp_keys_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 |
numeric(18,7) | |
| 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 | |
| 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 |
| export_date | datetime | |
| imported_read_only | smallint | |
|
tax1 | numeric(28,10)
| |
|
tax1_id
|
int | |
|
tax2 |
numeric(28,10)
| |
|
tax2_id
|
int | |
| CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_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 |
numeric(18,7)
| |
| 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 | |
| mileage_route_id | int | |
| export_status | int | |
| void_status | int | |
| reversal_line_item_id | int | |
| export_date | datetime | |
| imported_read_only | smallint | |
| CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_id ) | | |
| ) | | |
| CREATE TABLE alwf_wi_history ( |
| wi_history_id | int | NOT NULL |
| work_item_id | int | |
| activity_id | int | |
| author_user_id | int | |
| action_name | nvarchar(255) | |
| description | nvarchar(255) | |
| post_label | nvarchar(255) | |
| time_modified | datetime | |
| proxy | nvarchar(255) | |
| transition_id | int | |
|
creator_client_type
|
int
| |
| CONSTRAINT PK267PK267 PRIMARY KEY CLUSTERED ( wi_history_id ) | | |
| ) | | |