Changes to staging tables
These tables are modified in Infor Expense Management 10.2.0. The new columns and the modified columns are highlighted. the deleted columns are greyed out.
| CREATE TABLE aler_export_external_data ( | ||
|---|---|---|
| export_er_hdr_id | int | NOT NULL, |
| er_paid_on | datetime | NULL, |
| er_amt_paid | numeric(20, 10) | NULL, |
| er_payment_number | nvarchar(255) | NULL, |
| corp_charge_date | datetime | NULL, |
| corp_charge_amt_paid | numeric(20, 10) | NULL, |
| update_status | int |
NULL
) |
| CREATE TABLE alex_invoice_payment ( | ||
|---|---|---|
| export_invoice_hdr_id | int | NOT NULL, |
| paid_amount | numeric(20, 10) | NULL, |
| paid_date | datetime | NULL, |
| payment_number | nvarchar(255) | NULL, |
| voucher_number | nvarchar(255) | NULL, |
| update_status | int |
NULL
) |
Modifications in Infor Expense Management 10.2.3
| CREATE TABLE aler_expense_export_header ( | ||
|---|---|---|
| export_er_hdr_id | int | NOT NULL |
| export_hdr_status | int | NOT NULL |
| export_hdr_status_datetime | datetime | NOT NULL |
| export_create_date | datetime | NOT NULL |
| er_work_item_id | int | NOT NULL |
| er_document_id | nvarchar(255) | NOT NULL |
| er_exp_rep_title | nvarchar(255) | |
| er_purpose | nvarchar(255) | |
| er_exp_rep_date_created | datetime | |
| er_exp_rep_date_filed | datetime | |
| er_date_from | datetime | |
| er_date_to | datetime | |
| er_corp_charge_date | datetime | |
| er_currency_iso | nchar(3) | NOT NULL |
| er_cash_adv_amount | numeric(28, 10) | |
| er_company_charges | numeric(28, 10) | |
| er_amount_due_emp | numeric(28, 10) | |
| er_amount_due_co | numeric(28, 10) | |
| er_auth_amt | numeric(28, 10) | |
| er_total_expense | numeric(28, 10) | |
| er_applied_lcf | numeric(28, 10) | |
| er_applied_adj | numeric(28, 10) | |
| er_corp_charge_total | numeric(28, 10) | |
| er_remaining_lcf | numeric(28, 10) | |
| er_generated_lcf | numeric(28, 10) | |
| er_user_id | int | |
| er_user_login | nvarchar(255) | |
| er_user_full_name | nvarchar(255) | |
| er_employee_number | nvarchar(255) | |
| er_user_location | nvarchar(255) | |
| er_user_email_address | nvarchar(255) | |
| er_user_payroll_system_code | nvarchar(255) | |
| er_user_ssn | nvarchar(255) | |
| er_user_cost_center_name | nvarchar(255) | |
| er_user_cost_center_code | nvarchar(255) | |
| er_user_dept_name | nvarchar(255) | |
| er_user_division_name | nvarchar(255) | |
| er_user_dept_code | nvarchar(255) | |
| er_user_division_code | nvarchar(255) | |
| er_user_company_name | nvarchar(255) | |
| er_user_company_code | nvarchar(255) | |
| exp_rep_data_id | int | |
| purpose_ekey | nvarchar(255) | |
| currency_ekey | nvarchar(255) | |
| user_ekey | nvarchar(255) | |
| date_approved | datetime | |
| 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) | |
| er_user_segment1_name | nvarchar(255) | |
| er_user_segment1_code | nvarchar(255) | |
| er_user_segment2_name | nvarchar(255) | |
| er_user_segment2_code | nvarchar(255) | |
| er_user_segment3_name | nvarchar(255) | |
| er_user_segment3_code | nvarchar(255) | |
| er_user_segment4_name | nvarchar(255) | |
| er_user_segment4_code | nvarchar(255) | |
| er_user_segment5_name | nvarchar(255) | |
| er_user_segment5_code | nvarchar(255) | |
| er_user_segment6_name | nvarchar(255) | |
| er_user_segment6_code | nvarchar(255) | |
| er_user_segment7_name | nvarchar(255) | |
| er_user_segment7_code | nvarchar(255) | |
| er_user_segment8_name | nvarchar(255) | |
| er_user_segment8_code | nvarchar(255) | |
| er_user_segment9_name | nvarchar(255) | |
| er_user_segment9_code | nvarchar(255) | |
| er_user_country_iso | nvarchar(255) | |
| segment_count | int | |
| er_user_review_segment_name | nvarchar(255) | |
| er_user_review_segment_code | nvarchar(255) | |
| CONSTRAINT pk__ale17c286cf PRIMARY KEY CLUSTERED ( export_er_hdr_id ) ) | ||
| CREATE TABLE aler_expense_export_line ( | ||
|---|---|---|
| export_status | int | NULL |
| void_status | int | NULL |
| reversal_line_item_id | int | NULL |
| 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 aler_export_external_data ( | ||
|---|---|---|
| export_er_hdr_id | int | NOT NULL |
| er_paid_on | datetime | |
| er_amt_paid | numeric(28,10) | |
| er_payment_number | nvarchar(255) | |
| corp_charge_date | datetime | |
| corp_charge_amt_paid | numeric(28,10) | |
| update_status | int | |
| ) | ||
| CREATE TABLE aler_overage_export_allocation ( | ||
|---|---|---|
| overage_export_allocation_id | int | NOT NULL |
| export_er_hdr_id | int | NOT NULL |
| overage_id | int | NOT NULL |
| exp_line_item_id | int | |
| base_amt | numeric(28,10) | |
| base_amt_currency | nvarchar(3) | |
| base_currency_ekey | nvarchar(255) | |
| native_amt | numeric(28,10) | |
| native_amt_currency | nvarchar(3) | |
| native_currency_ekey | nvarchar(255) | |
| percent_allocated | numeric(26,16) | |
| is_billable | smallint | |
| is_approved | smallint | |
| expense_gl_code | nvarchar(255) | |
| overage_date | datetime | |
| cost_center_ekey | nvarchar(255) | |
| cost_center_name | nvarchar(255) | |
| cost_center_code | nvarchar(255) | |
| dept_name | nvarchar(255) | |
| dept_code | nvarchar(255) | |
| division_name | nvarchar(255) | |
| division_code | nvarchar(255) | |
| company_name | nvarchar(255) | |
| company_code | nvarchar(255) | |
| project_number_ekey | nvarchar(255) | |
| project_charge_code | nvarchar(255) | |
| project_code | nvarchar(255) | |
| parent_project_charge_code | nvarchar(255) | |
| is_personal | smallint | DEFAULT 0 NOT NULL |
| 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) | |
| segment_count | int | |
| review_segment_name | nvarchar(255) | |
| review_segment_code | nvarchar(255) | |
| CONSTRAINT PK59 PRIMARY KEY CLUSTERED ( overage_export_allocation_id ) ) | ||
| CREATE TABLE aler_vat_data_export ( | ||
|---|---|---|
| ervd_vat_data_export_id | int | NOT NULL |
| ervd_export_expense_line_id | int | |
| ervd_erli_native_amt | numeric(28, 10) | |
| ervd_erli_native_amt_currency | nvarchar(10) | |
| ervd_guest_count | smallint | |
| ervd_miles | numeric(15,5) | |
| ervd_td_gl_account | nvarchar(255) | |
| ervd_ntd_gl_account | nvarchar(255) | |
| ervd_vatd_gl_account | nvarchar(255) | |
| ervd_vat_amount_override | numeric(28, 10) | |
| ervd_vat_guest_override | int | |
| ervd_vat_miles_override | numeric(15,5) | |
| ervd_td_amount | numeric(28, 10) | |
| ervt_ntd_amount | numeric(28, 10) | |
| ervd_vat_amount | numeric(28, 10) | |
| native_amt_currency_ekey | nvarchar(255) | |
| export_er_hdr_id | int | |
| set_of_books_name | nvarchar(255) | |
| set_of_books_external_sys_id | nvarchar(255) | |
| set_of_books_description | nvarchar(255) | |
| set_of_books_ekey | nvarchar(255) | |
| vat_unclaimed_amount | numeric(28, 10) | |
| pst_amount | numeric(28, 10) | |
| pst_amount_override | numeric(28, 10) | |
| pst_unclaimed_amount | numeric(28, 10) | |
| pst_gl_account | nvarchar(255) | |
| vat_unclaimed_gl_account | nvarchar(255) | |
| pst_unclaimed_gl_account | nvarchar(255) | |
| base_currency | nvarchar(10) | |
| base_currency_ekey | nvarchar(255) | |
| td_base_amount | numeric(28, 10) | |
| ntd_base_amount | numeric(28, 10) | |
| vat_base_amount | numeric(28, 10) | |
| vat_base_amount_override | numeric(28, 10) | |
| vat_unclaimed_base_amount | numeric(28, 10) | |
| pst_base_amount | numeric(28, 10) | |
| pst_base_amount_override | numeric(28, 10) | |
| pst_unclaimed_base_amount | numeric(28, 10) | |
| alloc_percent_allotted | numeric(26,16) | |
| alloc_cost_center_name | nvarchar(255) | |
| alloc_cost_center_code | nvarchar(255) | |
| alloc_project_charge_code | nvarchar(255) | |
| alloc_project_code | nvarchar(255) | |
| alloc_parent_proj_code | nvarchar(255) | |
| alloc_top_project_code | nvarchar(255) | |
| alloc_cost_center_ekey | nvarchar(255) | |
| alloc_project_ekey | nvarchar(255) | |
| 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) | |
| export_er_line_id | int | |
| calc_vat_amount | numeric(28,10) | |
| calc_vat_base_amount | numeric(28,10) | |
| calc_vat_unclaimed_amount | numeric(28,10) | |
| calc_vat_unclaimed_base_amount | numeric(28,10) | |
| calc_pst_amount | numeric(28,10) | |
| calc_pst_base_amount | numeric(28,10) | |
| calc_pst_unclaimed_amount | numeric(28,10) | |
| calc_pst_unclaimed_base_amount | numeric(28,10) | |
| 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) | |
| CONSTRAINT pk292 PRIMARY KEY CLUSTERED ( ervd_vat_data_export_id ) ) | ||
| CREATE TABLE alex_budget_line ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| budget_ekey | nvarchar(255) | |
| budget_name | nvarchar(255) | NOT NULL |
| budget_description | nvarchar(1000) | |
| start_date | datetime | NOT NULL |
| end_date | datetime | NOT NULL |
| currency_ekey | nvarchar(255) | NOT NULL |
| gl_code | nvarchar(200) | NOT NULL |
| budgeted_amount | numeric(28,10) | NOT NULL |
| adjusted_amount | numeric(28,10) | |
| allocated_amount | numeric(28,10) | |
| committed_amount | numeric(28,10) | |
| cost_center_ekey | nvarchar(255) | |
| project_ekey | nvarchar(255) | |
| status | int | NOT NULL |
| CONSTRAINT PK118 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_export_adc ( | ||
|---|---|---|
| export_adc_id | int | NOT NULL |
| export_adc_parent_id | int | |
| parent_bob_id | int | |
| sequence | smallint | |
| type | nchar(10) | |
| name | nvarchar(255) | |
| integer_value | int | |
| string_value | nvarchar(510) | |
| date_value | datetime | |
| float_value | numeric(28,10) | |
| currency_iso | nchar(3) | |
| currency_ekey | nvarchar(255) | |
| CONSTRAINT pk__ale318258d2 PRIMARY KEY CLUSTERED ( export_adc_id ) ) | ||
| CREATE TABLE alex_fx_rate ( | ||
|---|---|---|
| currency_ekey | nvarchar(255) | NOT NULL |
| valid_date | datetime | NOT NULL |
| fx_rate | numeric(28,10) | NOT NULL |
| CONSTRAINT pk__ale336aa144 PRIMARY KEY CLUSTERED ( currency_ekey, valid_date ) ) | ||
| CREATE TABLE alex_import_ts_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) | |
| project_number_id_ekey | nvarchar(255) | |
| ts_date | datetime | NOT NULL |
| ts_hours | numeric(14 ,4) | |
| hourly_charge_type_id_ekey | nvarchar(255) | |
| charge_type_id_ekey | nvarchar(255) | |
| ts_start_time | datetime | |
| ts_end_time | datetime | |
| location_id_ekey | nvarchar(255) | |
| charge_role_id_ekey | nvarchar(255) | |
| app_ts_hours | numeric(14,4) | |
| app_hourly_charge_type_id_ekey | int | |
| ts_billable_rate | numeric(28,10) | |
| ts_billable_rate_id_ekey | nvarchar(255) | |
| currency_fmt_defn_id_ekey | nvarchar(255) | |
| cost_center_id_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) | |
| keyword_note | nvarchar(max) | |
| CONSTRAINT PK135 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_invoice_export_allocation ( | ||
|---|---|---|
| export_invoice_alloc_line_id | int | NOT NULL |
| export_invoice_hdr_id | int | NOT NULL |
| export_invoice_line_id | int | NOT NULL |
| line_allocation_source_id | int | NOT NULL |
| percent_allotted | numeric(26,16) | |
| base_amount | numeric(28,10) | |
| cost_center_name | nvarchar(255) | |
| cost_center_code | nvarchar(255) | |
| cost_center_ekey | nvarchar(255) | |
| company_code | nvarchar(255) | |
| company_name | nvarchar(255) | |
| division_code | nvarchar(255) | |
| division_name | nvarchar(255) | |
| department_code | nvarchar(255) | |
| department_name | nvarchar(255) | |
| project_code | nvarchar(255) | |
| parent_project_charge_code | nvarchar(255) | |
| project_charge_code | nvarchar(255) | |
| project_code_ekey | nvarchar(255) | |
| 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) | |
| segment_count | int | |
| review_segment_name | nvarchar(255) | |
| review_segment_code | nvarchar(255) | |
| CONSTRAINT PK73 PRIMARY KEY CLUSTERED ( export_invoice_alloc_line_id ) ) | ||
| CREATE TABLE alex_invoice_export_header ( | ||
|---|---|---|
| export_invoice_hdr_id | int | NOT NULL |
| export_hdr_status | int | NOT NULL |
| export_hdr_status_datetime | datetime | NOT NULL |
| export_create_date | datetime | NOT NULL |
| work_item_id | int | NOT NULL |
| document_id | nvarchar(255) | NOT NULL |
| title | nvarchar(255) | |
| date_created | datetime | |
| date_submitted | datetime | |
| date_approved | datetime | |
| invoice_number | nvarchar(255) | |
| invoice_date | datetime | |
| invoice_due_date | datetime | |
| invoice_currency_iso | nchar(3) NOT NULL | |
| invoice_currency_ekey | nvarchar(255) | |
| total_amount | numeric(28,10) | |
| total_calculated_amount | numeric(28,10) | |
| total_discounted_amount | numeric(28,10) | |
| pr_vendor_type_ext_sys_id | nvarchar(255) | |
| pr_vendor_type_name | nvarchar(255) | |
| pr_vendor_type_ekey | nvarchar(255) | |
| pr_vendor_terms_name | nvarchar(255) | |
| pr_vendor_terms_days | int | |
| pr_vendor_terms_ekey | nvarchar(255) | |
| pr_vendor_address_ekey | nvarchar(255) | |
| pr_vendor_address_name | nvarchar(255) | |
| pr_vendor_location_name | nvarchar(255) | |
| pr_vendor_addr_line_1 | nvarchar(255) | |
| pr_vendor_addr_line_2 | nvarchar(255) | |
| pr_vendor_city_name | nvarchar(255) | |
| pr_vendor_state_name | nvarchar(255) | |
| pr_vendor_zip_code | nvarchar(20) | |
| pr_vendor_country_name | nvarchar(255) | |
| pr_vendor_phone_number | nvarchar(255) | |
| pr_vendor_contact_name | nvarchar(255) | |
| pr_vendor_contact_email | nvarchar(255) | |
| pr_vendor_contact_phone | nvarchar(255) | |
| pr_vendor_fax_number | nvarchar(255) | |
| send_to_id | smallint | |
| discount_pay_by_date | datetime | |
| pr_purpose | nvarchar(255) | |
| pr_purpose_ekey | nvarchar(255) | |
| owner_user_id | int | |
| owner_login | nvarchar(255) | |
| owner_full_name | nvarchar(255) | |
| owner_employee_number | nvarchar(255) | |
| owner_location | nvarchar(255) | |
| owner_email_address | nvarchar(255) | |
| owner_payroll_system_code | nvarchar(255) | |
| owner_ssn | nvarchar(255) | |
| owner_cost_center_name | nvarchar(255) | |
| owner_cost_center_code | nvarchar(255) | |
| owner_dept_name | nvarchar(255) | |
| owner_division_name | nvarchar(255) | |
| owner_dept_code | nvarchar(255) | |
| owner_division_code | nvarchar(255) | |
| owner_company_name | nvarchar(255) | |
| owner_company_code | nvarchar(255) | |
| owner_user_ekey | nvarchar(255) | |
| pr_vendor_vendor_id | nvarchar(255) | |
| pr_vendor_is_payment_taxable | smallint | |
| pr_vendor_tax_code | nvarchar(255) | |
| pr_vendor_tax_id | nvarchar(255) | |
| pr_vendor_system_code1 | nvarchar(255) | |
| pr_vendor_system_code2 | nvarchar(255) | |
| pr_vendor_system_code3 | nvarchar(255) | |
| pr_vendor_system_code4 | nvarchar(255) | |
| pr_vendor_system_code5 | nvarchar(255) | |
| pr_vendor_system_code6 | nvarchar(255) | |
| pr_vendor_system_code7 | nvarchar(255) | |
| pr_vendor_system_code8 | nvarchar(255) | |
| requested_payment_date | datetime | |
| voucher_number | nvarchar(255) | |
| special_handling | nvarchar(255) | |
| pr_vendor_is_one_time_only | smallint | |
| owner_segment1_name | nvarchar(255) | |
| owner_segment1_code | nvarchar(255) | |
| owner_segment2_name | nvarchar(255) | |
| owner_segment2_code | nvarchar(255) | |
| owner_segment3_name | nvarchar(255) | |
| owner_segment3_code | nvarchar(255) | |
| owner_segment4_name | nvarchar(255) | |
| owner_segment4_code | nvarchar(255) | |
| owner_segment5_name | nvarchar(255) | |
| owner_segment5_code | nvarchar(255) | |
| owner_segment6_name | nvarchar(255) | |
| owner_segment6_code | nvarchar(255) | |
| owner_segment7_name | nvarchar(255) | |
| owner_segment7_code | nvarchar(255) | |
| owner_segment8_name | nvarchar(255) | |
| owner_segment8_code | nvarchar(255) | |
| owner_segment9_name | nvarchar(255) | |
| owner_segment9_code | nvarchar(255) | |
| segment_count | int | |
| owner_review_segment_name | nvarchar(255) | |
| owner_review_segment_code | nvarchar(255) | |
| CONSTRAINT PK71 PRIMARY KEY CLUSTERED ( export_invoice_hdr_id ) ) | ||
| CREATE TABLE alex_invoice_export_line ( | ||
|---|---|---|
| export_status | int | NULL |
| void_status | int | NULL |
| reversal_line_item_id | int | NULL |
| export_line_status | smallint | NULL |
| export_line_status_datetime | datetime | NULL |
| 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 | int | |
| 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 | smallint | |
| guest_count | int | |
| guest_entry_mode | smallint | |
| guest_amounts_equal | smallint | |
| guest_no_show_count | int | |
| CONSTRAINT PK72 PRIMARY KEY CLUSTERED ( export_invoice_line_id ) ) | ||
| CREATE TABLE alex_invoice_payment ( | ||
|---|---|---|
| export_invoice_hdr_id | int | NOT NULL |
| paid_amount | numeric(28,10) | |
| paid_date | datetime | |
| payment_number | nvarchar(255) | |
| voucher_number | nvarchar(255) | |
| ) update_status int | ||
| CREATE TABLE alex_pd_eur_rate ( | ||
|---|---|---|
| perdiem_definition_ekey | nvarchar(255) | NOT NULL |
| location_ekey | nvarchar(255) | |
| min_time_at_location | smallint | |
| perdiem_per_hour | smallint | |
| overnight_stay | smallint | NOT NULL |
| first_day_of_trip | smallint | NOT NULL |
| last_day_of_trip | smallint | NOT NULL |
| effective_date | datetime | |
| rate_value | numeric(28,10) | NOT NULL |
| rate_currency_ekey | nvarchar(255) | NOT NULL |
| active_status | smallint | NOT NULL |
| CREATE TABLE alex_perdiem_line_data ( | ||
|---|---|---|
| export_perdiem_line_data_id | int | NOT NULL |
| export_expense_line_id | int | NOT NULL |
| time_at_location | smallint | |
| start_time | datetime | |
| end_time | datetime | |
| overnight_stay | smallint | |
| long_term_stay | smallint | |
| breakfast | smallint | |
| lunch | smallint | |
| dinner | smallint | |
| meal_amount | numeric(28,10) | |
| meal_amount_currency_ekey | nvarchar(255) | |
| private_nightstay_address | nvarchar(255) | |
| first_day_of_trip | smallint | |
| last_day_of_trip | smallint | |
| optional_deduction_1 | smallint | |
| optional_deduction_2 | smallint | |
| optional_deduction_3 | smallint | |
| optional_deduction_4 | smallint | |
| optional_deduction_5 | smallint | |
| CONSTRAINT PK85 PRIMARY KEY CLUSTERED ( export_perdiem_line_data_id ) ) | ||
| CREATE TABLE alex_pr_vendor_terms ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| name | nvarchar(255) | NOT NULL |
| term_name | nvarchar(255) | |
| term_days | int | |
| discount_amount_type | smallint | NOT NULL |
| discount_amount_percentage | numeric(20,10) | |
| discount_amount | numeric(28,10) | |
| discount_amount_ekey | nvarchar(255) | |
| discount_term_days | int | |
| is_global_default | smallint | NOT NULL |
| active_status | smallint | NOT NULL |
| CONSTRAINT PK84 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alex_user ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| employee_number | nvarchar(255) | |
| cost_center_ekey | nvarchar(255) | NOT NULL |
| user_first_name | nvarchar(255) | NOT NULL |
| user_middle_initial | nvarchar(1) | |
| user_last_name | nvarchar(255) | NOT NULL |
| user_password | nvarchar(255) | NOT NULL |
| user_title | nvarchar(255) | |
| user_location_name | nvarchar(255) | |
| user_telephone | nvarchar(255) | |
| user_mailstop | nvarchar(255) | |
| user_email_address | nvarchar(255) | |
| user_email_product | nvarchar(255) | |
| user_login_name | nvarchar(255) | NOT NULL |
| fax_number | nvarchar(255) | |
| payroll_system_code | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| user_ssn | nvarchar(40) | |
| currency_ekey | nvarchar(255) | NOT NULL |
| country_ekey | nvarchar(255) | |
| default_approver_user_ekey | nvarchar(255) | |
| creation_date | datetime | NOT NULL |
| credit_card_ekey | nvarchar(255) | |
| credit_card_number | nvarchar(40) | |
| cc_processor_ekey | nvarchar(255) | |
| cc_payment_type_ekey | nvarchar(255) | |
| set_of_books_ekey | nvarchar(255) | |
| auth_amount | numeric(28,10) | |
| auth_amount_currency_ekey | nvarchar(255) | |
| pr_auth_amount | numeric(28,10) | |
| pr_auth_amount_currency_ekey | 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) | |
| start_date | datetime | |
| end_date | datetime | |
| system_date_1 | datetime | |
| system_date_2 | datetime | |
| out_of_office | smallint | NOT NULL |
| proxy_can_submit | smallint | |
| audit_group_ekey | nvarchar(255) | |
| is_html_client_user | smallint | NOT NULL |
| second_currency_ekey | nvarchar(255) | |
| proxy_reviewer_can_submit | smallint | |
| commute_miles | numeric(26,16) | |
| identity2 | nvarchar(36) | |
| CONSTRAINT pk__al1367e606 PRIMARY KEY CLUSTERED ( external_key ) ) | ||
| CREATE TABLE alpr_export_allocation ( | ||
|---|---|---|
| expr_alloc_line_id | int | NOT NULL |
| expr_header_id | int | NOT NULL |
| exprli_line_id | int | NOT NULL |
| expr_alloc_line_status | smallint | |
| alloc_line_status_datetime | datetime | |
| expr_alloc_source_id | int | NOT NULL |
| expr_alloc_percent_allotted | numeric(26,16) | |
| expr_alloc_base_amt | numeric(28,10) | |
| expr_alloc_base_currency | nchar(3) | |
| expr_alloc_native_amt | numeric(28,10) | |
| expr_alloc_native_currency | nchar(3) | |
| expr_alloc_is_approved | smallint | |
| expr_alloc_is_billable | smallint | |
| expr_alloc_project_charge_code | nvarchar(255) | |
| expr_alloc_cost_center_name | nvarchar(255) | |
| expr_alloc_cost_center_code | nvarchar(255) | |
| expr_alloc_dept_name | nvarchar(255) | |
| expr_alloc_division_name | nvarchar(255) | |
| expr_alloc_dept_code | nvarchar(255) | |
| expr_alloc_division_code | nvarchar(255) | |
| expr_alloc_company_name | nvarchar(255) | |
| expr_alloc_company_code | nvarchar(255) | |
| expr_alloc_project_code | nvarchar(255) | |
| expr_alloc_parent_project_code | nvarchar(255) | |
| expr_alloc_top_project_code | nvarchar(255) | |
| alloc_base_currency_ekey | nvarchar(255) | |
| alloc_native_currency_ekey | nvarchar(255) | |
| alloc_project_ekey | nvarchar(255) | |
| alloc_cost_center_ekey | nvarchar(255) | |
| CONSTRAINT pk296 PRIMARY KEY CLUSTERED ( expr_alloc_line_id ) ) | ||
| CREATE TABLE alpr_export_header ( | ||
|---|---|---|
| expr_header_id | int | NOT NULL |
| expr_header_status | smallint | NOT NULL |
| expr_header_status_datetime | datetime | NOT NULL |
| expr_create_date | datetime | NOT NULL |
| expr_work_item_id | int | NOT NULL |
| expr_document_id | nvarchar(255) | NOT NULL |
| expr_title | nvarchar(255) | |
| expr_purpose | nvarchar(255) | |
| expr_date_created | datetime | |
| expr_date_submitted | datetime | |
| expr_date_approved | datetime | |
| expr_total_expense | numeric(28,10) | |
| expr_currency_iso | nchar(3) | NOT NULL |
| expr_is_sourcing_request | smallint | |
| expr_ship_to_attention | nvarchar(255) | |
| expr_ship_to_comments | nvarchar(max) | |
| ship_to_manually_entered_addr | smallint | |
| ship_to_allow_partial_shipment | smallint | |
| expr_ship_to_external_sys_id | nvarchar(255) | |
| expr_ship_to_address_name | nvarchar(255) | |
| expr_ship_to_location_name | nvarchar(255) | |
| expr_ship_to_addr_line_1 | nvarchar(255) | |
| expr_ship_to_addr_line_2 | nvarchar(255) | |
| expr_ship_to_city_name | nvarchar(255) | |
| expr_ship_to_state_name | nvarchar(255) | |
| expr_ship_to_zip_code | nvarchar(20) | |
| expr_ship_to_country_name | nvarchar(255) | |
| expr_ship_to_phone_number | nvarchar(255) | |
| expr_ship_to_ship_method | nvarchar(255) | |
| expr_transport_carrier_code | nvarchar(70) | |
| transport_carrier_description | nvarchar(255) | |
| expr_transport_mean_code | nvarchar(70) | |
| transport_mean_description | nvarchar(255) | |
| expr_transport_mode_code | nvarchar(70) | |
| transport_mode_description | nvarchar(255) | |
| expr_payment_terms | nvarchar(255) | |
| expr_user_id | int | |
| expr_user_login | nvarchar(255) | |
| expr_user_full_name | nvarchar(255) | |
| expr_employee_number | nvarchar(255) | |
| expr_user_location | nvarchar(255) | |
| expr_user_email_address | nvarchar(255) | |
| expr_user_payroll_system_code | nvarchar(255) | |
| expr_user_ssn | nvarchar(255) | |
| expr_user_cost_center_name | nvarchar(255) | |
| expr_user_cost_center_code | nvarchar(255) | |
| expr_user_dept_name | nvarchar(255) | |
| expr_user_division_name | nvarchar(255) | |
| expr_user_dept_code | nvarchar(255) | |
| expr_user_division_code | nvarchar(255) | |
| expr_user_company_name | nvarchar(255) | |
| expr_user_company_code | nvarchar(255) | |
| pr_purpose_ekey | nvarchar(255) | |
| currency_ekey | nvarchar(255) | |
| user_ekey | nvarchar(255) | |
| expr_ship_to_address_ekey | nvarchar(255) | |
| expr_ship_to_user_ekey | nvarchar(255) | |
| expr_ship_to_user_id | int | |
| expr_ship_to_user_login | nvarchar(255) | |
| expr_ship_to_employee_number | nvarchar(255) | |
| expr_ship_to_user_location | nvarchar(255) | |
| expr_ship_to_user_email_addr | nvarchar(255) | |
| expr_ship_to_user_system_code | nvarchar(255) | |
| expr_ship_to_user_ssn | nvarchar(255) | |
| expr_bill_to_user_ekey | nvarchar(255) | |
| expr_bill_to_user_id | int | |
| expr_bill_to_user_login | nvarchar(255) | |
| expr_bill_to_employee_number | nvarchar(255) | |
| expr_bill_to_user_full_name | nvarchar(255) | |
| expr_bill_to_user_location | nvarchar(255) | |
| expr_bill_to_user_email_addr | nvarchar(255) | |
| expr_bill_to_user_system_code | nvarchar(255) | |
| expr_bill_to_user_ssn | nvarchar(255) | |
| bill_to_manually_entered_addr | smallint | |
| expr_bill_to_address_ekey | nvarchar(255) | |
| expr_bill_to_external_sys_id | nvarchar(255) | |
| expr_bill_to_address_name | nvarchar(255) | |
| expr_bill_to_location_name | nvarchar(255) | |
| expr_bill_to_addr_line_1 | nvarchar(255) | |
| expr_bill_to_addr_line_2 | nvarchar(255) | |
| expr_bill_to_city_name | nvarchar(255) | |
| expr_bill_to_state_name | nvarchar(255) | |
| expr_bill_to_zip_code | nvarchar(20) | |
| expr_bill_to_country_name | nvarchar(255) | |
| expr_bill_to_phone_number | nvarchar(255) | |
| CONSTRAINT pk294 PRIMARY KEY CLUSTERED ( expr_header_id ) ) | ||
| CREATE TABLE alpr_export_line ( | ||
|---|---|---|
| exprli_line_id | int | NOT NULL |
| expr_header_id | int | NOT NULL |
| exprli_line_status | smallint | |
| exprli_line_status_datetime | datetime | |
| exprli_source_line_id | int | |
| exprli_payment_type_label | nvarchar(255) | |
| exprli_bill_method_name | nvarchar(255) | |
| exprli_bill_method_code | int | |
| exprli_is_capitol_expenditure | int | |
| exprli_quantity_approved | int | |
| exprli_is_taxable | int | |
| exprli_category_string | nvarchar(255) | |
| exprli_item_description | nvarchar(255) | |
| exprli_uom_code | nvarchar(255) | |
| exprli_uom_description | nvarchar(255) | |
| exprli_unit_price | numeric(28,10) | |
| exprli_unit_price_currency | nchar(3) | |
| exprli_total_price | numeric(28,10) | |
| exprli_vendor_external_sys_id | nvarchar(255) | |
| exprli_vendor_type_name | nvarchar(255) | |
| exprli_vendor_ccard_account | nvarchar(255) | |
| exprli_vendor_address_name | nvarchar(255) | |
| exprli_vendor_location_name | nvarchar(255) | |
| exprli_vendor_addr_line_1 | nvarchar(255) | |
| exprli_vendor_addr_line_2 | nvarchar(255) | |
| exprli_vendor_city_name | nvarchar(255) | |
| exprli_vendor_state_name | nvarchar(255) | |
| exprli_vendor_zip_code | nvarchar(20) | |
| exprli_vendor_country_name | nvarchar(255) | |
| exprli_vendor_phone_number | nvarchar(255) | |
| exprli_vendor_contact_name | nvarchar(255) | |
| exprli_vendor_contact_email | nvarchar(255) | |
| vendor_contact_phone_number | nvarchar(255) | |
| exprli_reason_for_purchase | nvarchar(255) | |
| exprli_recipient | nvarchar(255) | |
| exprli_deliver_by | datetime | |
| exprli_note | nvarchar(max) | |
| exprli_manufacturer_name | nvarchar(255) | |
| exprli_item_number | nvarchar(255) | |
| exprli_part_num_ext | nvarchar(255) | |
| exprli_manager | nvarchar(255) | |
| exprli_room_number | nvarchar(255) | |
| exprli_location | nvarchar(255) | |
| exprli_start_date | datetime | |
| exprli_end_date | datetime | |
| exprli_op_sys_name | nvarchar(255) | |
| exprli_max_back_order_qty | int | |
| pr_payment_type_ekey | nvarchar(255) | |
| pr_category_ekey | nvarchar(255) | |
| unit_of_measure_ekey | nvarchar(255) | |
| unit_price_currency_ekey | nvarchar(255) | |
| pr_vendor_type_ekey | nvarchar(255) | |
| vendor_address_ekey | nvarchar(255) | |
| manufacturer_ekey | nvarchar(255) | |
| exprli_category_glcode | nvarchar(255) | |
| CONSTRAINT pk295 PRIMARY KEY CLUSTERED ( exprli_line_id ) ) | ||
| CREATE TABLE altr_travel_plan_export_header ( | ||
|---|---|---|
| export_tr_hdr_id | int | NOT NULL |
| export_hdr_status | smallint | NOT NULL |
| export_hdr_status_datetime | datetime | NOT NULL |
| export_create_date | datetime | NOT NULL |
| extr_work_item_id | int | NOT NULL |
| extr_tracking_number | nvarchar(255) | |
| extr_title | nvarchar(255) | |
| extr_purpose | nvarchar(255) | |
| extr_num_going | int | |
| extr_date_created | datetime | |
| extr_date_filed | datetime | |
| extr_date_from | datetime | |
| extr_date_to | datetime | |
| extr_date_approved | datetime | |
| extr_currency_iso | nchar(3) | |
| extr_tot_air | numeric(28,10) | |
| extr_tot_hotel | numeric(28,10) | |
| extr_tot_hotel_tax | numeric(28,10) | |
| extr_tot_car | numeric(28,10) | |
| extr_tot_car_tax | numeric(28,10) | |
| extr_tot_meals | numeric(28,10) | |
| extr_tot_other | numeric(28,10) | |
| extr_total_cost | numeric(28,10) | |
| extr_max_air_ticket_amt | numeric(28,10) | |
| extr_trip_type_label | nvarchar(255) | |
| extr_ord_key | nvarchar(255) | |
| extr_integration_partner_name | nvarchar(255) | |
| extr_user_id | int | |
| extr_user_login | nvarchar(255) | |
| extr_user_full_name | nvarchar(255) | |
| extr_employee_number | nvarchar(255) | |
| extr_user_email_address | nvarchar(255) | |
| extr_user_location | nvarchar(255) | |
| extr_user_payroll_system_code | nvarchar(255) | |
| extr_user_ssn | nvarchar(255) | |
| extr_user_cost_center_name | nvarchar(255) | |
| extr_user_cost_center_code | nvarchar(255) | |
| extr_user_dept_name | nvarchar(255) | |
| extr_user_division_name | nvarchar(255) | |
| extr_user_dept_code | nvarchar(255) | |
| extr_user_division_code | nvarchar(255) | |
| extr_user_company_name | nvarchar(255) | |
| extr_user_company_code | nvarchar(255) | |
| purpose_ekey | nvarchar(255) | |
| currency_ekey | nvarchar(255) | |
| user_ekey | nvarchar(255) | |
| itinerary_state | int | |
| extr_user_segment1_name | nvarchar(255) | |
| extr_user_segment1_code | nvarchar(255) | |
| extr_user_segment2_name | nvarchar(255) | |
| extr_user_segment2_code | nvarchar(255) | |
| extr_user_segment3_name | nvarchar(255) | |
| extr_user_segment3_code | nvarchar(255) | |
| extr_user_segment4_name | nvarchar(255) | |
| extr_user_segment4_code | nvarchar(255) | |
| extr_user_segment5_name | nvarchar(255) | |
| extr_user_segment5_code | nvarchar(255) | |
| extr_user_segment6_name | nvarchar(255) | |
| extr_user_segment6_code | nvarchar(255) | |
| extr_user_segment7_name | nvarchar(255) | |
| extr_user_segment7_code | nvarchar(255) | |
| extr_user_segment8_name | nvarchar(255) | |
| extr_user_segment8_code | nvarchar(255) | |
| extr_user_segment9_name | nvarchar(255) | |
| extr_user_segment9_code | nvarchar(255) | |
| segment_count | int | |
| extr_user_review_segment_name | nvarchar(255) | |
| extr_user_review_segment_code | nvarchar(255) | |
| CONSTRAINT pk__alt38ee7070 PRIMARY KEY CLUSTERED ( export_tr_hdr_id ) ) | ||
| CREATE TABLE altr_travel_plan_export_line ( | ||
|---|---|---|
| export_status | int | NULL |
| void_status | int | NULL |
| reversal_line_item_id | int | NULL |
| 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_eke | y 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 | |
| CONSTRAINT pk__alt3ad6b8e2 PRIMARY KEY CLUSTERED ( export_tr_line_id ) ) | ||
| CREATE TABLE alts_export_line ( | ||
|---|---|---|
| export_status | int | NULL |
| void_status | int | NULL |
| reversal_line_item_id | int | NULL |
| export_line_status | datetime | NULL |
| 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 ) ) | ||
Modifications in Infor Expense Management 10.2.12
| CREATE TABLE alex_xmdbtool ( | ||
|---|---|---|
| xmdbtool_id | int | NOT NULL |
| table_name | nvarchar(255) | NOT NULL |
| sequence | int | NOT NULL |
| xmtype | nchar(1) | NOT NULL |
| module | nvarchar(255) | NOT NULL |
| pre_query | nvarchar(max) | |
| inline_query | nvarchar(max) | |
| post_query | nvarchar(max) | |
| has_child | int | NOT NULL |
| parent_id | int | NOT NULL |
| time_range | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| change_timestamp | datetime | |
| post_query_sftp nvarchar(max) | ||
| CONSTRAINT PK88 PRIMARY KEY CLUSTERED ( xmdbtool_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 | smallint | |
| guest_count | int | |
| guest_entry_mode | smallint | |
| guest_amounts_equal | smallint | |
| guest_no_show_count | int | |
| CONSTRAINT PK72 PRIMARY KEY CLUSTERED ( export_invoice_line_id ) ) | ||
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 | smallint | |
| 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 ) ) | ||
Modifications in Infor Expense Management 10.2.15
| CREATE TABLE alex_user ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| employee_number | nvarchar(255) | |
| cost_center_ekey | nvarchar(255) | NOT NULL |
| user_first_name | nvarchar(255) | NOT NULL |
| user_middle_initial | nvarchar(1) | |
| user_last_name | nvarchar(255) | NOT NULL |
| user_password | nvarchar(255) | NOT NULL |
| user_title | nvarchar(255) | |
| user_location_name | nvarchar(255) | |
| user_telephone | nvarchar(255) | |
| user_mailstop | nvarchar(255) | |
| user_email_address | nvarchar(255) | |
| user_email_product | nvarchar(255) | |
| user_login_name | nvarchar(255) | NOT NULL |
| fax_number | nvarchar(255) | |
| payroll_system_code | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| user_ssn | nvarchar(40) | |
| currency_ekey | nvarchar(255) | NOT NULL |
| country_ekey | nvarchar(255) | |
| default_approver_user_ekey | nvarchar(255) | |
| creation_date | datetime | NOT NULL |
| credit_card_ekey | nvarchar(255) | |
| credit_card_number | nvarchar(40) | |
| cc_processor_ekey | nvarchar(255) | |
| cc_payment_type_ekey | nvarchar(255) | |
| set_of_books_ekey | nvarchar(255) | |
| auth_amount | numeric(28,10) | |
| auth_amount_currency_ekey | nvarchar(255) | |
| pr_auth_amount | numeric(28,10) | |
| pr_auth_amount_currency_ekey | 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) | |
| start_date | datetime | |
| end_date | datetime | |
| system_date_1 | datetime | |
| system_date_2 | datetime | |
| out_of_office | smallint | NOT NULL |
| proxy_can_submit | smallint | |
| audit_group_ekey | nvarchar(255) | |
| is_html_client_user | smallint | NOT NULL |
| second_currency_ekey | nvarchar(255) | |
| proxy_reviewer_can_submit | smallint | |
| commute_miles | numeric(26,16) | |
| identity2 | nvarchar(36) | |
| preferred_timezone | nvarchar(255) | |
| CONSTRAINT pk__al1367e606 PRIMARY KEY CLUSTERED ( external_key ) | ||
| ) | ||
Modifications in 10.2.16
| CREATE TABLE alex_user ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| employee_number | nvarchar(255) | |
| cost_center_ekey | nvarchar(255) | NOT NULL |
| user_first_name | nvarchar(255) | NOT NULL |
| user_middle_initial | nvarchar(1) | |
| user_last_name | nvarchar(255) | NOT NULL |
| user_password | nvarchar(255) | NOT NULL |
| user_title | nvarchar(255) | |
| user_location_name | nvarchar(255) | |
| user_telephone | nvarchar(255) | |
| user_mailstop | nvarchar(255) | |
| user_email_address | nvarchar(255) | |
| user_email_product | nvarchar(255) | |
| user_login_name | nvarchar(255) | NOT NULL |
| fax_number | nvarchar(255) | |
| payroll_system_code | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| user_ssn | nvarchar(40) | |
| currency_ekey | nvarchar(255) | NOT NULL |
| country_ekey | nvarchar(255) | |
| default_approver_user_ekey | nvarchar(255) | |
| creation_date | datetime | NOT NULL |
| credit_card_ekey | nvarchar(255) | |
| credit_card_number | nvarchar(40) | |
| cc_processor_ekey | nvarchar(255) | |
| cc_payment_type_ekey | nvarchar(255) | |
| set_of_books_ekey | nvarchar(255) | |
| auth_amount | numeric(28,10) | |
| auth_amount_currency_ekey | nvarchar(255) | |
| pr_auth_amount | numeric(28,10) | |
| pr_auth_amount_currency_ekey | 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) | |
| start_date | datetime | |
| end_date | datetime | |
| system_date_1 | datetime | |
| system_date_2 | datetime | |
| out_of_office | smallint | NOT NULL |
| proxy_can_submit | smallint | |
| audit_group_ekey | nvarchar(255) | |
| is_html_client_user | smallint | NOT NULL |
| second_currency_ekey | nvarchar(255) | |
| proxy_reviewer_can_submit | smallint | |
| commute_miles | numeric(26,16) | |
| identity2 | nvarchar(36) | |
| preferred_timezone | nvarchar(255) | |
| user_email_address_2 | nvarchar(255) | |
| user_email_address_3 | nvarchar(255) | |
| CONSTRAINT pk__al1367e606 PRIMARY KEY CLUSTERED ( external_key ) | ||
| ) | ||
Modifications in 10.2.18
| 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_accoun t | 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) | |
| export_status | int | |
| void_status | int | |
| reversal_line_item_id | int | |
| export_date | datetime | |
| CONSTRAINT pk__ale19aacf41 PRIMARY KEY CLUSTERED ( export_er_line_id ) | ||
| ) | ||
| CREATE TABLE alex_address ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| address_name | nvarchar(255) | NOT NULL |
| location_name | nvarchar(255) | |
| addr_line_1 | nvarchar(255) | |
| addr_line_2 | nvarchar(255) | |
| city_name | nvarchar(255) | |
| state_ekey | nvarchar(255) | |
| zip_code | nvarchar(20) | |
| country_ekey | nvarchar(255) | |
| phone_nbr | nvarchar(255) | |
| url | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| company_ekey | nvarchar(255) | |
| contact_name | nvarchar(255) | |
| contact_email_address | nvarchar(255) | |
| contact_phone_number | nvarchar(255) | |
| external_sys_id | nvarchar(255) | |
| suggest_in_map | smallint | |
| CONSTRAINT pk300 PRIMARY KEY CLUSTERED ( external_key ) | ||
| ) | ||
| 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 | smallint | |
| guest_count | int | |
| guest_entry_mode | smallint | |
| guest_amounts_equal | smallint | |
| guest_no_show_count | int | |
| export_line_status | smallint | |
| export_line_status_datetime | datetime | |
| export_status | int | |
| void_status | int | |
| reversal_line_item_id | int | |
| export_date | datetime | |
| 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) | |