Version 10.2.10
These staging tables are added in Infor Expense Management 10.2.10:
| CREATE TABLE alex_import_er_document ( | ||
|---|---|---|
| external_key | nvarchar(255 | ) NOT NULL |
| user_ekey | nvarchar(255) | NOT NULL |
| import_status | smallint | DEFAULT 1NOT NULL |
| import_error_message | nvarchar(255) | |
| import_change_timestamp | datetime | |
| submit_status | smallint | DEFAULT 0 NOT NULL |
| submit_error_message | nvarchar(255) | |
| submit_change_timestamp | datetime | |
| er_paid_on | datetime | |
| er_amt_paid | numeric(28,10) | |
| er_amt_paid_id_ekey | nvarchar(255) | |
| er_payment_number | nvarchar(255) | |
| exp_rep_title | nvarchar(255) | |
| purpose_id_ekey | nvarchar(255) | |
| corp_charge_date | datetime | |
| corp_charge_amt_paid_id_ekey | nvarchar(255) | |
| corp_charge_amt_paid | numeric(28,10) | |
| create_location_id_ekey | nvarchar(255) | |
| 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_ekey | nvarchar(255) | |
| flex_field_amount_2 | numeric(28,10) | |
| flex_field_amount_2_id_ekey | nvarchar(255) | |
| flex_field_location_1_id_ekey | nvarchar(255) | |
| flex_field_ddlb_1_id_ekey | nvarchar(255) | |
| flex_field_ddlb_2_id_ekey | nvarchar(255) | |
| flex_field_ddlb_3_id_ekey | nvarchar(255) | |
| flex_field_ddlb_4_id_ekey | nvarchar(255) | |
| flex_field_ddlb_5_id_ekey | nvarchar(255) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK_alt3CBF0154ER PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_import_er_line_item ( | ||
|---|---|---|
| external_key | nvarchar(255) NOT NULL | |
| user_ekey | nvarchar(255) NOT NULL | |
| import_status | smallint | DEFAULT 1 NOT NULL |
| import_error_message | nvarchar(255) | |
| import_change_timestamp | datetime | |
| parent_type | smallint | DEFAULT 0 NOT NULL |
| parent_ekey | nvarchar(255) | |
| payment_type_id_ekey | nvarchar(255) | |
| expense_type_id_ekey | nvarchar(255) | |
| vendor_id_ekey | nvarchar(255) | |
| currency_fmt_defn_id_ekey | nvarchar(255) | |
| cc_transaction_id_ekey | nvarchar(255) | |
| expense_item_date | datetime | |
| expense_description | nvarchar(255) | |
| erli_native_amt_id_ekey | nvarchar(255) | |
| erli_native_amt | numeric(28,10) | |
| purpose_id_ekey | nvarchar(255) | |
| odometer_start | numeric(15,5) | |
| odometer_end | numeric(15,5) | |
| miles | numeric(15,5) | |
| reimburs_rate | float | |
| erli_exch_rate | numeric(26,16) | |
| item_gl_code | nchar(20) | |
| erli_amt_approv_id_ekey | nvarchar(255) | |
| erli_amt_approv | numeric(28,10) | |
| has_receipt | smallint | |
| receipt_checked | smallint | |
| location_id_ekey | nvarchar(255) | |
| is_personal | smallint | |
| approved_exchange_rate | numeric(26,16) | |
| vat_amount_override | numeric(28,10) | |
| vat_amount_override_id_ekey | nvarchar(255) | |
| 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_ekey | nvarchar(255) | |
| ticket_status_ekey | nvarchar(255) | |
| ticket_number | nvarchar(50) | |
| car_rental_agreement | nvarchar(50) | |
| airline_class_of_service_ekey | nvarchar(255) | |
| car_class_of_service_ekey | nvarchar(255) | |
| hotel_class_of_service_ekey | nvarchar(255) | |
| mileage_rate_id_ekey | nvarchar(255) | |
| mileage_passenger_num | int | |
| pst_amount_override | numeric(28,10) | |
| pst_amount_override_id_ekey | nvarchar(255) | |
| 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_ekey | nvarchar(255) | |
| flex_field_amount_2 | numeric(28,10) | |
| flex_field_amount_2_id_ekey | nvarchar(255) | |
| flex_field_location_1_id_ekey | nvarchar(255) | |
| flex_field_ddlb_1_id_ekey | nvarchar(255) | |
| flex_field_ddlb_2_id_ekey | nvarchar(255) | |
| flex_field_ddlb_3_id_ekey | nvarchar(255) | |
| flex_field_ddlb_4_id_ekey | nvarchar(255) | |
| flex_field_ddlb_5_id_ekey | nvarchar(255) | |
| mileage_route_id_ekey | nvarchar(255) | |
| 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) | |
| keyword_alloc_cost_center_ekey | nvarchar(255) | |
| keyword_alloc_project_num_ekey | nvarchar(255) | |
| keyword_guest_ekeys | nvarchar(max) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK_alt3CBF0154ERLI PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_import_pr_document ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| user_ekey | nvarchar(255) | NOT NULL |
| import_status | smallint | DEFAULT 1 NOT NULL |
| import_error_message | nvarchar(255) | |
| import_change_timestamp | datetime | |
| submit_status | smallint | DEFAULT 0 NOT NULL |
| submit_error_message | nvarchar(255) | |
| submit_change_timestamp | datetime | |
| title | nvarchar(255) | |
| invoice_number | nvarchar(255) | |
| invoice_date | datetime | |
| total_amount | numeric(28,10) | |
| total_amount_id_ekey | nvarchar(255) | |
| paid_date | datetime | |
| paid_amount | numeric(28,10) | |
| paid_amount_id_ekey | nvarchar(255) | |
| payment_number | nvarchar(255) | |
| pr_vendor_id_ekey | nvarchar(255) | |
| send_to_id | smallint | NOT NULL |
| pr_purpose_id_ekey | nvarchar(255) | |
| requested_payment_date | datetime | |
| voucher_number | nvarchar(255) | |
| special_handling | nvarchar(255) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK139 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_import_pr_line_item ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| user_ekey | nvarchar(255) | NOT NULL |
| import_status | smallint | DEFAULT 1 NOT NULL |
| import_error_message | nvarchar(255) | |
| import_change_timestamp | datetime | |
| parent_type | smallint | DEFAULT 0 NOT NULL |
| parent_ekey | nvarchar(255) | |
| item_number | nvarchar(255) | |
| item_description | nvarchar(255) | |
| invoiced_quantity | int | |
| unit_of_measure_id_ekey | nvarchar(255) | |
| unit_price_amount | numeric(28,10) | |
| unit_price_amount_id_ekey | nvarchar(255) | |
| check_request_type_id_ekey | nvarchar(255) | |
| guest_count | int | |
| td_gl_account_override | nvarchar(255) | |
| td_gl_subaccount_override | nvarchar(255) | |
| guest_entry_mode | smallint | DEFAULT 0 NOT NULL |
| guest_amounts_equal | smallint | DEFAULT 1 NOT NULL |
| guest_no_show_count | int | |
| keyword_alloc_cost_center_ekey | nvarchar(255) | |
| keyword_alloc_project_num_ekey | nvarchar(255) | |
| keyword_guest_ekeys | nvarchar(max) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK142 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_import_tp_document ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| user_ekey | nvarchar(255) | NOT NULL |
| import_status | smallint | DEFAULT 1 NOT NULL |
| import_error_message | nvarchar(255) | |
| import_change_timestamp | datetime | |
| submit_status | smallint | DEFAULT 0 NOT NULL |
| submit_error_message | nvarchar(255) | |
| submit_change_timestamp | datetime | |
| tr_title | nvarchar(255) | |
| tr_purpose_ekey | nvarchar(255) | |
| tr_num_going | int | |
| trip_type_id_ekey | nvarchar(255) | |
| create_location_id_ekey | nvarchar(255) | |
| keyword_alloc_cost_center_ekey | nvarchar(255) | |
| keyword_alloc_project_num_ekey | nvarchar(255) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK143 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_import_tp_line_item ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| user_ekey | nvarchar(255) | NOT NULL |
| import_status | smallint | DEFAULT 1 NOT NULL |
| import_error_message | nvarchar(255) | |
| import_change_timestamp | datetime | |
| parent_type | smallint | DEFAULT 0 NOT NULL |
| parent_ekey | nvarchar(255) | |
| tr_item_type_id_ekey | nvarchar(255) | NOT NULL |
| tax_cost_id_ekey | nvarchar(255) | |
| tax_cost | numeric(28,10) | |
| purpose_ekey | nvarchar(255) | |
| vendor_ekey | nvarchar(255) | |
| from_location_ekey | nvarchar(255) | |
| from_date | datetime | |
| from_time | datetime | |
| to_location_ekey | nvarchar(255) | |
| to_date | datetime | |
| to_time | datetime | |
| class_of_service_ekey | nvarchar(255) | |
| cust_def_1 | nvarchar(255) | |
| cust_def_2 | nvarchar(255) | |
| cust_def_3 | nvarchar(255) | |
| daily_rate_native_id_ekey | nvarchar(255) | |
| daily_rate_native | numeric(28,10) | |
| currency_fmt_defn_id_ekey | nvarchar(255) | |
| exch_rate | numeric(26,16) | |
| miles | numeric(15,5) | |
| reimburse_rate | float | |
| guest_count | int | |
| guest_entry_mode | smallint | DEFAULT 0 NOT NULL |
| guest_amounts_equal | smallint | DEFAULT 1 NOT NULL |
| guest_no_show_count | int | |
| keyword_guest_ekeys | nvarchar(max) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK144 PRIMARY KEY CLUSTERED ( external_key ) | ||
| ) | ||