Version 10.2.14
Modifications in Infor Expense Management 10.2.14
| CREATE TABLE aler_expense_export_line ( | ||
|---|---|---|
| export_er_line_id | int | NOT NULL |
| export_er_hdr_id | int | NOT NULL |
| exli_exp_line_item_id | int | NOT NULL |
| export_er_line_status | smallint | |
| export_line_status_datetime | datetime | |
| exli_line_allocation_id | int | NOT NULL |
| exli_alloc_base_amt | numeric(28,10) | |
| exli_alloc_base_amt_currency | nvarchar(10) | |
| exli_alloc_native_amt | numeric(28,10) | |
| exli_alloc_native_amt_curr | nvarchar(10) | |
| exli_expense_item_date | datetime | |
| exli_erli_exch_rate | numeric(26,16) | |
| exli_alloc_percent_allotted | numeric(26,16) | |
| exli_alloc_cost_center_name | nvarchar(255) | |
| exli_alloc_cost_center_code | nvarchar(255) | |
| exli_alloc_project_code | nvarchar(255) | |
| exli_alloc_parent_proj_code | nvarchar(255) | |
| exli_alloc_top_project_code | nvarchar(255) | |
| exli_line_payment_method_code | int | |
| exli_line_is_personal_flag | smallint | |
| exli_expense_type_label | nvarchar(255) | |
| exli_expense_category_label | nvarchar(255) | |
| exli_expense_gl_code | nvarchar(255) | |
| exli_expense_category_class | smallint | |
| exli_expense_special_code | int | |
| exli_major_account | nvarchar(255) | |
| exli_expense_external_sysid | nvarchar(255) | |
| exli_erli_amt_paid | numeric(28 ,10) | |
| exli_erli_native_amt | numeric(28,10) | |
| exli_erli_amt_paid_currency | nvarchar(10) | |
| exli_erli_native_amt_currency | nvarchar(10) | |
| exli_vendor_name | nvarchar(255) | |
| exli_vendor_given_sic | nvarchar(255) | |
| exli_purpose | nvarchar(255) | |
| exli_expense_description | nvarchar(255) | |
| exli_city | nvarchar(255) | |
| exli_state | nvarchar(255) | |
| exli_country | nvarchar(255) | |
| exli_cc_card_number | nvarchar(255) | |
| exli_cc_issuer | nvarchar(255) | |
| exli_payment_type_label | nvarchar(255) | |
| exli_alloc_project_charge_code | nvarchar(255) | |
| exli_miles | numeric(15,5) | |
| exli_odometer_start | numeric(15,5) | |
| exli_odometer_end | numeric(15,5) | |
| exli_perdiem_amount | numeric(28,10) | |
| exli_perdiem_amount_currency | nvarchar(10) | |
| exli_cct_reference | nvarchar(255) | |
| exli_alloc_is_billable | smallint | |
| exli_county | nvarchar(255) | |
| exli_suburb | nvarchar(255) | |
| exli_street | nvarchar(255) | |
| alloc_base_currency_ekey | nvarchar(255) | |
| alloc_native_currency_ekey | nvarchar(255) | |
| alloc_cost_center_ekey | nvarchar(255) | |
| alloc_project_ekey | nvarchar(255) | |
| payment_type_ekey | nvarchar(255) | |
| expense_type_ekey | nvarchar(255) | |
| amt_paid_currency_ekey | nvarchar(255) | |
| native_amt_currency_ekey | nvarchar(255) | |
| vendor_ekey | nvarchar(255) | |
| purpose_ekey | nvarchar(255) | |
| location_ekey | nvarchar(255) | |
| perdiem_amount_currency_ekey | nvarchar(255) | |
| cc_transaction_id | int | |
| expense_item_depart_date | datetime | |
| origin_airport | nvarchar(10) | |
| dest_airport | nvarchar(10) | |
| booking_agent_name | nvarchar(50) | |
| booking_agent_description | nvarchar(255) | |
| booking_agent_ekey | nvarchar(255) | |
| ticket_status_name | nvarchar(255) | |
| ticket_status_ekey | nvarchar(255) | |
| ticket_number | nvarchar(50) | |
| car_rental_agreement | nvarchar(50) | |
| air_service_class_code | nvarchar(4) | |
| air_service_class_name | nvarchar(255) | |
| air_service_class_ekey | nvarchar(255) | |
| car_service_class_code | nvarchar(4) | |
| car_service_class_name | nvarchar(255) | |
| car_service_class_ekey | nvarchar(255) | |
| hotel_service_class_code | nvarchar(4) | |
| hotel_service_class_name | nvarchar(255) | |
| hotel_service_class_ekey | nvarchar(255) | |
| mileage_rate_name | nvarchar(40) | |
| mileage_rate_ekey | nvarchar(255) | |
| mileage_passenger_num | int | |
| alloc_department_name | nvarchar(255) | |
| alloc_department_code | nvarchar(255) | |
| alloc_division_name | nvarchar(255) | |
| alloc_division_code | nvarchar(255) | |
| alloc_company_name | nvarchar(255) | |
| alloc_company_code | nvarchar(255) | |
| cc_level3_detail_id | int | |
| guest_count | int | |
| paid_amount | numeric(28,10) | |
| paid_amount_currency | nvarchar(10) | |
| 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_amt_1 | numeric(28,10) | |
| flex_field_amt_1_currency | nvarchar(10) | |
| flex_field_amt_2 | numeric(28,10) | |
| flex_field_amt_2_currency | nvarchar(10) | |
| flex_field_loc_1_ekey | nvarchar(255) | |
| flex_field_loc_1_county | nvarchar(255) | |
| flex_field_loc_1_state | nvarchar(255) | |
| flex_field_loc_1_country | nvarchar(255) | |
| flex_field_loc_1_city | nvarchar(255) | |
| flex_field_loc_1_suburb | nvarchar(255) | |
| flex_field_loc_1_street | nvarchar(255) | |
| flex_field_ddlb_1_code | nvarchar(255) | |
| flex_field_ddlb_1_value | nvarchar(255) | |
| flex_field_ddlb_2_code | nvarchar(255) | |
| flex_field_ddlb_2_value | nvarchar(255) | |
| flex_field_ddlb_3_code | nvarchar(255) | |
| flex_field_ddlb_3_value | nvarchar(255) | |
| flex_field_ddlb_4_code | nvarchar(255) | |
| flex_field_ddlb_4_value | nvarchar(255) | |
| flex_field_ddlb_5_code | nvarchar(255) | |
| flex_field_ddlb_5_value | nvarchar(255) | |
| exli_pci_token | nvarchar(255) | |
| alloc_segment1_name | nvarchar(255) | |
| alloc_segment1_code | nvarchar(255) | |
| alloc_segment2_name | nvarchar(255) | |
| alloc_segment2_code | nvarchar(255) | |
| alloc_segment3_name | nvarchar(255) | |
| alloc_segment3_code | nvarchar(255) | |
| alloc_segment4_name | nvarchar(255) | |
| alloc_segment4_code | nvarchar(255) | |
| alloc_segment5_name | nvarchar(255) | |
| alloc_segment5_code | nvarchar(255) | |
| alloc_segment6_name | nvarchar(255) | |
| alloc_segment6_code | nvarchar(255) | |
| alloc_segment7_name | nvarchar(255) | |
| alloc_segment7_code | nvarchar(255) | |
| alloc_segment8_name | nvarchar(255) | |
| alloc_segment8_code | nvarchar(255) | |
| alloc_segment9_name | nvarchar(255) | |
| alloc_segment9_code | nvarchar(255) | |
| segment_count | int | |
| alloc_review_segment_name | nvarchar(255) | |
| alloc_review_segment_code | nvarchar(255) | |
| guest_entry_mode | smallint | |
| guest_amounts_equal | smallint | |
| guest_no_show_count | int | |
| passenger_name | nvarchar(255) | |
| CONSTRAINT pk__ale19aacf41 PRIMARY KEY CLUSTERED ( export_er_line_id ) ) | ||
| CREATE TABLE alex_invoice_export_line ( | ||
|---|---|---|
| export_invoice_line_id | int | NOT NULL |
| export_invoice_hdr_id | int | NOT NULL |
| invoice_line_item_id | int | NOT NULL |
| item_number | nvarchar(255) | |
| item_description | nvarchar(255) | |
| item_quantity | numeric(15,5) | |
| unit_of_measure_code | nvarchar(255) | |
| unit_of_measure_ekey | nvarchar(255) | |
| unit_price | numeric(28,10) | |
| total_price | numeric(28,10) | |
| check_request_type_name | nvarchar(255) | |
| check_request_type_ekey | nvarchar(255) | |
| check_request_type | ||
| guest_count | int | |
| guest_entry_mode | smallint | |
| guest_amounts_equal | smallint | |
| guest_no_show_count | int | |
| d | ||
| CONSTRAINT PK72 PRIMARY KEY CLUSTERED ( export_invoice_line_id ) ) | ||
| CREATE TABLE altr_travel_plan_export_line ( | ||
|---|---|---|
| export_tr_line_id | int | NOT NULL |
| export_tr_hdr_id | int | |
| extr_export_line_status | int | |
| extr_line_status_datetime | datetime | |
| extr_tr_line_item_id | int | |
| extrli_item_type | nvarchar(255) | |
| extrli_purpose | nvarchar(255) | |
| extrli_from_date | datetime | |
| extrli_from_time | datetime | |
| extrli_to_date | datetime | |
| extrli_to_time | datetime | |
| extrli_currency_iso | nchar(3) | |
| extrli_cost | numeric(28,10) | |
| extrli_tax_cost | numeric(28,10) | |
| extrli_daily_rate | numeric(28,10) | |
| extrli_native_currency_iso | nchar(3) | |
| extrli_daily_rate_native | numeric(28,10) | |
| extrli_exchange_rate | numeric(28,10) | |
| extrli_reimburse_rate | numeric(28,10) | |
| extrli_average_cost | numeric(28,10) | |
| extrli_miles | numeric(15,5) | |
| extrli_description_1 | nvarchar(255) | |
| extrli_description_2 | nvarchar(255) | |
| extrli_ext_booking_key | nvarchar(255) | |
| extrli_cust_def_1 | nvarchar(255) | |
| extrli_cust_def_2 | nvarchar(255) | |
| extrli_cust_def_3 | nvarchar(255) | |
| extrli_charge_to_string | nvarchar(255) | |
| extrli_charge_to_code | int | |
| extrli_alloc_base_amt | numeric(28,10) | |
| extrli_alloc_base_amt_iso | nvarchar(10) | |
| extrli_alloc_native_amt | numeric(28,10) | |
| extrli_alloc_native_amt_iso | nvarchar(10) | |
| extrli_alloc_exch_rate | numeric(28,10) | |
| extrli_alloc_percent_allotted | numeric(26,16) | |
| extrli_alloc_cost_center_name | nvarchar(255) | |
| extrli_alloc_cost_center_code | nvarchar(255) | |
| extrli_alloc_project_code | nvarchar(255) | |
| extrli_alloc_parent_project_cd | nvarchar(255) | |
| extrli_alloc_top_project_code | nvarchar(255) | |
| extrli_alloc_project_num_bobid | int | |
| extrli_aler_alloc_line_id | int | |
| extrli_exptype_special_code | int | |
| extrli_from_street | nvarchar(255) | |
| extrli_from_suburb | nvarchar(255) | |
| extrli_from_city | nvarchar(255) | |
| extrli_from_county | nvarchar(255) | |
| extrli_from_state | nvarchar(255) | |
| extrli_from_country | nvarchar(255) | |
| extrli_to_street | nvarchar(255) | |
| extrli_to_suburb | nvarchar(255) | |
| extrli_to_city | nvarchar(255) | |
| extrli_to_county | nvarchar(255) | |
| extrli_to_state | nvarchar(255) | |
| extrli_to_country | nvarchar(255) | |
| extrli_alloc_is_billable | smallint | |
| travel_item_ekey | nvarchar(255) | |
| purpose_ekey | nvarchar(255) | |
| currency_ekey | nvarchar(255) | |
| native_currency_ekey | nvarchar(255) | |
| alloc_base_currency_ekey | nvarchar(255) | |
| alloc_native_currency_ekey | nvarchar(255) | |
| alloc_cost_center_ekey | nvarchar(255) | |
| alloc_project_ekey | nvarchar(255) | |
| from_location_ekey | nvarchar(255) | |
| to_location_ekey | nvarchar(255) | |
| trip_type | nchar(2) | |
| from_airport_code | nchar(3) | |
| to_airport_code | nchar(3) | |
| lowest_airfare | numeric(28,10) | |
| lowest_airfare_currency_iso | nchar(3) | |
| lowest_airfare_currency_ekey | nvarchar(255) | |
| lowest_hotel_rate | numeric(28,10) | |
| lowest_hotel_rate_curr_iso | nchar(3) | |
| lowest_hotel_rate_curr_ekey | nvarchar(255) | |
| booking_source | nchar(2) | |
| agency_name | nvarchar(40) | |
| guest_count | int | |
| guest_entry_mode | smallint | |
| guest_amounts_equal | smallint | |
| guest_no_show_count | int | |
| re | ||
| CONSTRAINT pk__alt3ad6b8e2 PRIMARY KEY CLUSTERED ( export_tr_line_id ) ) | ||
| CREATE TABLE alts_export_line ( | ||
|---|---|---|
| export_line_id | int | NOT NULL |
| ts_line_item_id | int | NOT NULL |
| export_hdr_id | int | NOT NULL |
| export_line_status | smallint | NOT NULL |
| line_item_date | datetime | NOT NULL |
| top_project_code | nvarchar(255) | NOT NULL |
| project_code | nvarchar(255) | NOT NULL |
| hours | numeric(20,10) | NOT NULL |
| approved_hours | numeric(20,10) | NOT NULL |
| hourly_charge_type | nvarchar(255) | |
| app_hourly_charge_type | nvarchar(255) | |
| charge_type | nvarchar(255) | |
| location | nvarchar(255) | |
| charge_role | nvarchar(255) | |
| billable_rate | numeric(28,10) | |
| billable_rate_currency_iso | nchar(3) | |
| start_time | datetime | |
| end_time | datetime | |
| note | nvarchar(max) | |
| cost_center_name | nvarchar(255) | |
| cost_center_code | nvarchar(255) | |
| project_ekey | nvarchar(255) | |
| hourly_charge_type_ekey | nvarchar(255) | |
| app_hourly_charge_type_ekey | nvarchar(255) | |
| charge_type_ekey | nvarchar(255) | |
| location_ekey | nvarchar(255) | |
| charge_role_ekey | nvarchar(255) | |
| billable_rate_currency_ekey | nvarchar(255) | |
| cost_center_ekey | nvarchar(255) | |
| description | nvarchar(255) | |
| attd_in1 | datetime | |
| attd_out1 | datetime | |
| attd_in2 | datetime | |
| attd_out2 | datetime | |
| attd_in3 | datetime | |
| attd_out3 | datetime | |
| attd_in4 | datetime | |
| attd_out4 | datetime | |
| attd_in5 | datetime | |
| attd_out5 | datetime | |
| attd_in6 | datetime | |
| attd_out6 | datetime | |
| attd_absence_hours | numeric(14,4) | |
| company_name | nvarchar(255) | |
| company_code | nvarchar(255) | |
| division_name | nvarchar(255) | |
| division_code | nvarchar(255) | |
| department_name | nvarchar(255) | |
| department_code | nvarchar(255) | |
| segment_count | int | |
| segment1_name | nvarchar(255) | |
| segment1_code | nvarchar(255) | |
| segment2_name | nvarchar(255) | |
| segment2_code | nvarchar(255) | |
| segment3_name | nvarchar(255) | |
| segment3_code | nvarchar(255) | |
| segment4_name | nvarchar(255) | |
| segment4_code | nvarchar(255) | |
| segment5_name | nvarchar(255) | |
| segment5_code | nvarchar(255) | |
| segment6_name | nvarchar(255) | |
| segment6_code | nvarchar(255) | |
| segment7_name | nvarchar(255) | |
| segment7_code | nvarchar(255) | |
| segment8_name | nvarchar(255) | |
| segment8_code | nvarchar(255) | |
| segment9_name | nvarchar(255) | |
| segment9_code | nvarchar(255) | |
| review_segment_name | nvarchar(255) | |
| review_segment_code | nvarchar(255) | |
| CONSTRAINT pk__alt4de98d56 PRIMARY KEY CLUSTERED ( export_line_id ) ) | ||