Changes to transaction 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 alat_corpdata_type ( | ||
|---|---|---|
| corpdata_type_id | int | NOT NULL, |
| corpdata_type_name | nchar(30) | NOT NULL, |
| corpdata_type_bob_type | int | NOT NULL, |
| corpdata_type_panel_id | int | NOT NULL, |
| corpdata_type_active_status | smallint | NOT NULL, |
| field_attribute_id | int | NULL, |
| app_id_bit_field | int | NOT NULL, |
| corpdata_bulk_editable | smallint | NULL, |
| br_event_ | int | NULL, |
| CONSTRAINT PK__ala0BC6C43E PRIMARY KEY CLUSTERED (corpdata_type_id) ) | ||
| CREATE TABLE albr_defn ( | ||
|---|---|---|
| rule_defn_id | int | NOT NULL, |
| rule_title | nvarchar(255) | NOT NULL, |
| class_name | nvarchar(255) | NOT NULL, |
| rule_created_date | datetime | NULL, |
| rule_description | nvarchar(510) | NULL, |
| rule_policy | nvarchar(max) | NULL, |
| process_document | int | NULL, |
| rule_scope | int | NULL, |
| rule_notify | int | NULL, |
| rule_interact_msg | nvarchar(510) | NULL, |
| rule_report_msg | nvarchar(510) | NULL, |
| rule_severity | int | NULL, |
| rule_category | int | NULL, |
| rule_active_status | smallint | NOT NULL, |
| template_id | int | NULL, |
| external_system_id | nvarchar(255) | NULL, |
| fire_mode | int | NULL, |
| server_side | smallint | NOT NULL, |
| change_timestamp | datetime | NULL, |
| has_own_dialog | smallint | NULL, |
| script_id | int | NULL, |
| routing_type_id | int | NULL, |
| brv_visibility | int | NULL, |
| CONSTRAINT PK__alb117F9D94 PRIMARY KEY CLUSTERED (rule_defn_id) ) | ||
| CREATE TABLE alcc_card ( | ||
|---|---|---|
| ccard_id | int | NOT NULL, |
| cc_processor_id | int | NULL, |
| user_id | int | NULL, |
| ccard_account | nvarchar(255) | NOT NULL, |
| ccard_name1 | nvarchar(255) | NULL, |
| ccard_name2 | nvarchar(255) | NULL, |
| ccard_address1 | nvarchar(255) | NULL, |
| ccard_address2 | nvarchar(255) | NULL, |
| is_paid_by_company | smallint | DEFAULT 0 NOT NULL, |
| ccard_limit_id | int | NULL, |
| ccard_limit | numeric(20, 10) | NULL, |
| ccard_issuer | nvarchar(255) | NULL, |
| payment_type_id | int | NULL, |
| ccard_active_status | smallint | NOT NULL, |
| ccard_deactive_date | datetime | NULL, |
| pr_payment_type_id | int | NULL, |
| is_pr_card | smallint | DEFAULT 0 NOT NULL |
| card_type | nvarchar(255) | NULL, |
| cost_center_id | int | NULL, |
| project_number_id | int | NULL, |
| glcode | nvarchar(255) | NULL, |
| change_timestamp | datetime | NULL, |
| cardholder_id | nvarchar(255) | NULL, |
| pci_token | nvarchar(255) | NULL, |
| per_transaction_limit_id | int | NULL, |
| per_transaction_limit | numeric(20, 10) | NULL, |
| CONSTRAINT PK__alc24927208 PRIMARY KEY CLUSTERED (ccard_id) ) | ||
| CREATE TABLE alcc_transaction ( | ||
|---|---|---|
| cc_transaction_id | int | NOT NULL, |
| ccard_id | int | NOT NULL, |
| merchant_id | int | NULL, |
| currency_fmt_defn_id | int | NULL, |
| cct_reference | nvarchar(255) | NULL, |
| cct_type | smallint | NOT NULL, |
| cct_amt_us_id | int | NULL, |
| cct_amt_us | numeric(20, 10) | NOT NULL, |
| cct_posting_date | datetime | NOT NULL, |
| cct_date | datetime | NULL, |
| vat_amt_native_id | int | NULL, |
| vat_amt_native | numeric(20, 10) | NULL, |
| cct_amt_native_id | int | NULL, |
| cct_amt_native | numeric(20, 10) | NULL, |
| cct_currency_code | nchar(3) | NULL, |
| cct_active_status | smallint | NOT NULL, |
| cct_import_timestamp | datetime | NULL, |
| external_system_id | nvarchar(255) | NULL, |
| offline_user_id | int | NULL, |
| doc_date_offlined | datetime | NULL, |
| er_doc_id | int | NULL, |
| location_id | int | NULL, |
| expense_type_id | int | NULL, |
| cct_description | nvarchar(255) | NULL, |
| cc_transaction_detail_id | int | NULL, |
| change_timestamp | datetime | NULL, |
| cct_status_int | int | NULL, |
| cct_sequence_number | int | NULL, |
| cct_statement_date | datetime | NULL, |
| CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED (cc_transaction_id) ) | ||
| CREATE TABLE alco_background_process ( | ||
|---|---|---|
| bkg_process_id | int | NOT NULL, |
| bkg_process_name | nvarchar(255) | NOT NULL, |
| bkg_process_type | int | NOT NULL, |
| bkg_startup_mode | int | NOT NULL, |
| bkg_wait_interval | int | NULL, |
| bkg_interval_unit | nchar(1) | NULL, |
| bkg_log_level | int | NULL, |
| user_id | int | NULL, |
| bkg_log_max_size | int | NULL, |
| bkg_process_package | nvarchar(255) | NOT NULL, |
| bkg_process_model | int | NULL, |
| server_port | int | NULL, |
| server_host_name | nvarchar(255) | NOT NULL, |
| bkg_process_params | nvarchar(1024) | NULL, |
| active_status | smallint | DEFAULT 1 NOT NULL, |
| change_timestamp | datetime | NULL, |
| xm_release_id | int | DEFAULT 3154966 NOT NULL |
| CONSTRAINT PK__alc3D5E1FD2 PRIMARY KEY CLUSTERED (bkg_process_id) ) | ||
| CREATE TABLE alco_expense_type ( | ||
|---|---|---|
| expense_type_id | int | NOT NULL, |
| user_id | int | NULL, |
| expense_type_label | nvarchar(255) | NOT NULL, |
| category_label | nvarchar(255) | NULL, |
| gl_code | nchar(20) | NULL, |
| tax_deductable_percent | smallint | NOT NULL, |
| itemization_only | smallint | DEFAULT 0 NOT NULL |
| field_disp_control | smallint | NULL, |
| category_class | smallint | NULL, |
| expense_special_code_id | int | NULL, |
| expense_active_status | smallint | NOT NULL, |
| major_account | nchar(10) | NULL, |
| travel_category_id | int | NULL, |
| external_system_id | nvarchar(255) | NULL, |
| default_offline_perdiem_amt_id | int | NULL, |
| default_offline_perdiem_amt | numeric(20, 10) | NULL, |
| change_timestamp | datetime | NULL, |
| currency_fmt_defn_id | int | NULL, |
| short_label | nvarchar(255) | NULL, |
| perdiem_subtype | smallint | NULL, |
| pd_definition_id | int | NULL, |
| description | nvarchar(max) | NULL, |
| not_selectable | int | DEFAULT 0 NOT NULL, |
| image_name | nvarchar(255) | NULL, |
| CONSTRAINT PK__alc6D0D32F4 PRIMARY KEY CLUSTERED (expense_type_id) ) | ||
| CREATE TABLE alco_mileage_route ( | ||
|---|---|---|
| mileage_route_id | int | NOT NULL, |
| route_name | nvarchar(255) | NOT NULL, |
| user_id | int | NOT NULL, |
| route_detail | nvarchar(max) | NOT NULL, |
| distance | numeric(15, 5) | NOT NULL, |
| change_timestamp | datetime | NULL, |
| from_address_id | int | NULL, |
| to_address_id | int | NULL, |
| active_status | smallint | DEFAULT 1 NOT NULL |
| original_route_id | int | NULL, |
| billable | smallint | DEFAULT 0 NOT NULL, |
| CONSTRAINT PK527 PRIMARY KEY CLUSTERED (mileage_route_id) ) | ||
| CREATE TABLE alco_project_number ( | ||
|---|---|---|
| project_number_id | int | NOT NULL, |
| user_id | int | NULL, |
| is_required | smallint | DEFAULT 0 NOT NULL |
| project_code | nvarchar(255) | NULL, |
| project_name | nvarchar(255) | NULL, |
| project_description | nvarchar(255) | NULL, |
| level_1_leader_id | int | NULL, |
| level_2_leader_id | int | NULL, |
| level_3_leader_id | int | NULL, |
| level_4_leader_id | int | NULL, |
| default_reviewer_id | int | NULL, |
| client_id | int | NULL, |
| proj_num_active_status | smallint | NULL, |
| parent_project_number_id | int | NULL, |
| code_level | int | NULL, |
| is_chargeable | smallint | DEFAULT 0 NOT NULL, |
| start_date | datetime | NULL, |
| end_date | datetime | NULL, |
| charge_type_id | int | NULL, |
| project_code_ref_id | int | NULL, |
| top_project_code | nvarchar(255) | NULL, |
| project_charge_code | nvarchar(255) | NOT NULL, |
| hier_project_name | nvarchar(255) | NULL, |
| office_id | int | NULL, |
| alternate_reviewer_id | int | NULL, |
| project_activity_type_id | int | NNULL,ULL, |
| change_timestamp | datetime | NULL, |
| app_flags | int | |
| CONSTRAINT PK__alc32AB8735 PRIMARY KEY CLUSTERED (project_number_id) ) | ||
| CREATE TABLE alco_user ( | ||
|---|---|---|
| user_id | int | NOT NULL, |
| cost_center_id | int | NULL, |
| user_full_name | nvarchar(255) | NOT NULL, |
| user_first_name | nvarchar(255) | NULL, |
| user_middle_initial | nchar(1) | NULL, |
| user_last_name | nvarchar(255) | NULL, |
| employee_number | nvarchar(255) | NULL, |
| user_password | nvarchar(255) | NOT NULL, |
| user_title | nvarchar(255) | NULL, |
| user_location | nvarchar(255) | NULL, |
| user_telephone | nvarchar(255) | NULL, |
| user_mailstop | nvarchar(255) | NULL, |
| user_email_address | nvarchar(255) | NULL, |
| email_product | nvarchar(255) | NULL, |
| user_login | nvarchar(255) | NULL, |
| user_dept_code | nchar(10) | NULL, |
| user_company_code | nchar(10) | NULL, |
| user_fax_number | nvarchar(255) | NULL, |
| payroll_system_code | nvarchar(255) | NULL, |
| active_status | smallint | NOT NULL, |
| ssn | nvarchar(255) | NULL, |
| creation_time | datetime | NOT NULL, |
| currency_fmt_defn_id | int | NOT NULL, |
| country_id | int | NULL, |
| has_credit_cards | smallint | NULL, |
| cc_expiration_date | datetime | NULL, |
| pso_data | int | NULL, |
| external_data | nvarchar(255) | NULL, |
| set_of_books_id | int | NULL, |
| remote_access_device_id | nvarchar(255) | NULL, |
| auth_amount | numeric(20, 10) | NULL, |
| auth_amount_id | int | NULL, |
| pr_auth_amount | numeric(20, 10) | NULL, |
| pr_auth_amount_id | int | NULL, |
| system_code_1 | nvarchar(255) | NULL, |
| system_code_2 | nvarchar(255) | NULL, |
| system_code_3 | nvarchar(255) | NULL, |
| system_code_4 | nvarchar(255) | NULL, |
| system_code_5 | nvarchar(255) | NULL, |
| system_code_6 | nvarchar(255) | NULL, |
| system_code_7 | nvarchar(255) | NULL, |
| system_code_8 | nvarchar(255) | NULL, |
| start_date | datetime | NULL, |
| end_date | datetime | NULL, |
| system_date_1 | datetime | NULL, |
| system_date_2 | datetime | NULL, |
| office_id | int | NULL, |
| out_of_office | smallint | DEFAULT 0 NOT NULL, |
| change_timestamp | datetime | NULL, |
| audit_group_id | int | NULL, |
| default_mileage_rate_id | int | NULL, |
| is_thin_client_user | smallint | NOT NULL, |
| preferred_locale | nvarchar(32) | NULL, |
| second_currency_id | int | NULL, |
| user_email_address_2 | nvarchar(255) | NULL, |
| user_email_address_3 | nvarchar(255) | NULL, |
| commute_miles | decimal(26, 16) | NULL, |
| validation_id | nvarchar(255) | NULL, |
| identity2 | nvarchar(36) | NULL, |
| lc_user_login | AS | lower(user_login), |
| preferred_timezone | nvarchar(255) | NULL, |
| CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED (user_id) ) | ||
| CREATE TABLE aldt_adc_defn ( | ||
|---|---|---|
| adc_id | int | NOT NULL, |
| adc_name | nvarchar(255) | NOT NULL, |
| sequence_no | int | NOT NULL, |
| application | int | NOT NULL, |
| adc_type | int | NOT NULL, |
| adc_app_type | int | NOT NULL, |
| control_type | nvarchar(30) | NOT NULL, |
| label | nvarchar(100) | NULL, |
| tooltip | nvarchar(255) | NULL, |
| mask | nvarchar(255) | NULL, |
| visible | smallint | NOT NULL, |
| enabled | smallint | NOT NULL, |
| required | smallint | NOT NULL, |
| standard_adc | smallint | NOT NULL, |
| gui_control_id | int | NULL, |
| gui_label_id | int | NULL, |
| base_bob | nvarchar(255) | NULL, |
| base_element | nvarchar(255) | NULL, |
| assoc_bob_type | int | NULL, |
| new_element | nvarchar(255) | NULL, |
| active_status | smallint | NOT NULL, |
| change_timestamp | datetime | NULL, |
| chooser_button_callback | nvarchar(255) | NULL, |
| chooser_event_data | nvarchar(255) | NULL, |
| bob_set_name | nvarchar(255) | NULL, |
| xm_release_id | int | DEFAULT 3154966 NOT NULL, |
| CONSTRAINT PK422 PRIMARY KEY CLUSTERED (adc_id) ) | ||
| CREATE TABLE aldt_new_bob_defn ( | ||
|---|---|---|
| new_bob_id | int | NOT NULL, |
| bob_name | nvarchar(255) | NOT NULL, |
| display_name | nvarchar(255) | NULL, |
| db_table_name | nvarchar(255) | NULL, |
| db_key_column_name | nvarchar(255) | NULL, |
| display_name_element | nvarchar(255) | NULL, |
| contains_user_rows | smallint | NOT NULL, |
| in_use | smallint | NOT NULL, |
| cd_panel | smallint | NOT NULL, |
| field_att_module_id | int | NULL, |
| application | smallint | NULL, |
| auto_userid_element | smallint | NULL, |
| auto_userid_column | nvarchar(255) | NULL, |
| auto_active_element | smallint | NULL, |
| auto_active_column | nvarchar(255) | NULL, |
| auto_timestamp_element | smallint | NULL, |
| auto_timestamp_column | nvarchar(255) | NULL, |
| active_status | smallint | NOT NULL, |
| change_timestamp | datetime | NULL, |
| callback_panel_ids | nvarchar(255) | NULL, |
| instructions | nvarchar(max) | NULL, |
| is_mru | smallint | DEFAULT 0 NOT NULL, |
| xm_release_id | int | DEFAULT 3154966 NOT NULL, |
| CONSTRAINT PK417 PRIMARY KEY CLUSTERED (new_bob_id) ) | ||
| CREATE TABLE almt_bob_elements ( | ||
|---|---|---|
| bus_elem_defn_id | int | NOT NULL, |
| type_of_bob_ref | int | NULL, |
| bus_obj_type_id | int | NOT NULL, |
| elem_order | smallint | NULL, |
| elem_name | nvarchar(255) | NULL, |
| use_in_equality | smallint | NULL, |
| prompt_when_unentered | nchar(20) | NULL, |
| elem_type | nchar(10) | NOT NULL, |
| is_suppressed | smallint | NULL, |
| db_server | nvarchar(255) | NULL, |
| db_name | nvarchar(255) | NULL, |
| db_table | nvarchar(255) | NULL, |
| db_column | nvarchar(255) | NULL, |
| unique_scope | smallint | NULL, |
| required_value | smallint | NULL, |
| encrypted_storage | smallint | NULL, |
| sort_order | int | NULL, |
| display_name | nvarchar(255) | NULL, |
| xm_release_id | int | DEFAULT 3154966 NOT NULL, |
| CONSTRAINT PK__alm43A1090D PRIMARY KEY CLUSTERED (bus_elem_defn_id) | ||
| CREATE TABLE almt_bob_type ( | ||
|---|---|---|
| bus_obj_type_id | int | NOT NULL, |
| parent_type_id_list | nvarchar(255) | NULL, |
| bob_name | nvarchar(255) | NOT NULL, |
| contains_user_rows | smallint | NULL, |
| class_name | nvarchar(255) | NOT NULL, |
| display_name | nvarchar(255) | NULL, |
| key_column_name | nvarchar(255) | NULL, |
| can_be_member | smallint | NULL, |
| app_flags | int | NULL, |
| permission_control | nvarchar(18) | NULL, |
| display_name_element | nvarchar(255) | NULL, |
| business_process_class_name | nvarchar(255) | NULL, |
| extends_bob_type | int | NULL, |
| xm_release_id | int | DEFAULT 3154966 NOT NULL, |
| CONSTRAINT PK__alm477199F1 PRIMARY KEY CLUSTERED (bus_obj_type_id) ) | ||
| CREATE TABLE alpr_vendor_terms ( | ||
|---|---|---|
| vendor_terms_id | int | NOT NULL, |
| name | nvarchar(255) | NOT NULL, |
| term_name | nvarchar(255) | NULL, |
| term_days | int | NULL, |
| discount_amount_type | smallint | NULL, |
| discount_amount_percentage | numeric(20, 10) | NULL, |
| discount_amount | numeric(20, 10) | NULL, |
| discount_amount_id | int | NULL, |
| discount_term_days | int | NULL, |
| is_global_default | smallint | DEFAULT 0 NOT NULL |
| active_status | smallint | NULL, |
| change_timestamp | datetime | NULL, |
| CONSTRAINT PK459 PRIMARY KEY CLUSTERED (vendor_terms_id) ) | ||
| CREATE TABLE altr_travel_category ( | ||
|---|---|---|
| travel_category_id | int | NOT NULL, |
| travel_category_name | nvarchar(255) | NOT NULL, |
| active_status | smallint | NOT NULL, |
| change_timestamp | datetime | NULL, |
| tax_category_name | nvarchar(255) | NULL, |
| summary_type | smallint | DEFAULT 0 NOT NULL, |
| CONSTRAINT PK__alt351DDF8C PRIMARY KEY CLUSTERED (travel_category_id) ) | ||
| CREATE TABLE alwf_appl_parameters ( | ||
|---|---|---|
| parm_id | int | NOT NULL, |
| parm_name | nvarchar(255) | NOT NULL, |
| parm_value | nvarchar(max) | NOT NULL, |
| parm_display_name | nvarchar(255) | NULL, |
| parm_description | nvarchar(1020) | NULL, |
| parm_allow_override | smallint | DEFAULT 0 NOT NULL, |
| parm_active_status | smallint | NOT NULL, |
| change_timestamp | datetime | NULL, |
| is_customer_editable | smallint | DEFAULT 0 NOT NULL |
| xm_release_id | int | DEFAULT 3154966 NOT NULL |
| CONSTRAINT PK__alw6E565CE8 PRIMARY KEY CLUSTERED (parm_id) ) | ||
| CREATE TABLE alwf_work_item ( | ||
|---|---|---|
| work_item_id | int | NOT NULL, |
| parent_work_item_id | int | NULL, |
| business_object_id | int | NOT NULL, |
| document_id | nvarchar(255) | NOT NULL, |
| activity_id | int | NOT NULL, |
| doc_priority | int | NULL, |
| doc_is_locked | smallint | NOT NULL, |
| session_num | int | NULL, |
| is_suspended | smallint | NOT NULL, |
| appl_exceptions | smallint | DEFAULT 0 NOT NULL, |
| overrides | smallint | DEFAULT 0 NOT NULL, |
| doc_specific | NULL, | |
| post_label | nvarchar(255) | NULL, |
| doc_date_created | datetime | NULL, |
| doc_date_modified | datetime | NULL, |
| time_entered_queue | datetime | NOT NULL, |
| creator_user_id | int | NULL, |
| owner_user_id | int | NULL, |
| locked_by_user_id | int | NULL, |
| suspended_by_user_id | int | NULL, |
| released_by_user_id | int | NULL, |
| proxy_user_id | int | NULL, |
| project_number_id | int | NULL, |
| doc_description | nvarchar(255) | NULL, |
| bus_obj_type_id | int | NULL, |
| offline_user_id | int | NULL, |
| activity_number | int | NULL, |
| doc_date_offlined | datetime | NULL, |
| offline_special_code | int | NULL, |
| split_count | int | NULL, |
| recall_state | int | NULL, |
| last_transition | int | NULL, |
| audit_indicator | nvarchar(255) | NULL, |
| doc_specific_indicator | datetime | NULL, |
| change_timestamp | datetime | NULL, |
| rejected_exceptions | int | DEFAULT 0 NOT NULL, |
| only_one_reviewer_needed | smallint | DEFAULT 0 NOT NULL, |
| is_exported | smallint | DEFAULT 0 NOT NULL, |
| doc_date_submitted | datetime | NULL, |
| audit_log | int | DEFAULT 0 NOT NULL |
| doc_specific_amount_id | int | NULL, |
| doc_specific_amount | numeric(20, 10) | NULL, |
| doc_purpose | nvarchar(255) | NULL, |
| doc_approved_amount_id | int | NULL, |
| doc_approved_amount | numeric(20, 10) | NULL, |
| CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED (work_item_id) ) | ||
Modifications in Infor Expense Management 10.2.3
| CREATE TABLE albr_parameter ( | ||
|---|---|---|
| br_parameter_id | int | NOT NULL |
| br_instance_id | int | |
| param_order | int | |
| param_type | nchar(2), | |
| param_name | nvarchar(255), | |
| string_value | nvarchar(1500), | |
| int_value | int, | |
| float_value | float, | |
| date_value | datetime, | |
| money_value | numeric(28,10), | |
| money_value_id | int | |
| corp_data_name | nvarchar(65), | |
| active_status | smallint NOT NULL, | NOT NULL |
| hours_value | numeric(14,4), | |
| change_timestamp | datetime, | |
| gmt_date_value | datetime, | |
|
CONSTRAINT PK__alb1CF15040 PRIMARY KEY CLUSTERED ( br_parameter_id ) ) |
||
| CREATE TABLE albr_parameter_template ( | ||
|---|---|---|
| br_parameter_template_id | int | NOT NULL |
| template_id | int | |
| param_order | int, | |
| param_type | nchar(2), | |
| param_name | nvarchar(255), | |
| string_value | nvarchar(1500), | |
| int_value | int, | |
| float_value | float, | |
| date_value | datetime, | |
| money_value | numeric(28,10), | |
| money_value_id | int, | |
| hours_value | numeric(14,4), | |
| corp_data_name | nvarchar(65), | |
| control_id | int, | |
| active_status | smallint | NOT NULL |
| change_timestamp | datetime, | |
| gmt_date_value | datetime, | |
|
CONSTRAINT PK__alb20C1E124 PRIMARY KEY CLUSTERED ( br_parameter_template_id ) ) |
||
| CREATE TABLE alcc_card ( | ||
|---|---|---|
| ccard_id | int | NOT NULL |
| cc_processor_id | int, | |
| user_id | int | NOT NULL |
| ccard_account | nvarchar(255) | |
| ccard_name1 | nvarchar(255), | |
| ccard_name2 | nvarchar(255), | |
| ccard_address1 | nvarchar(255), | |
| ccard_address2 | nvarchar(255), | |
| is_paid_by_company | smallint | DEFAULT 0 NOT NULL |
| ccard_limit_id | int, | |
| ccard_limit | numeric(28,10), | |
| ccard_issuer | nvarchar(255), | |
| payment_type_id | int, | |
| ccard_active_status | smallint | |
| ccard_deactive_date | datetime, | |
| pr_payment_type_id | int, | |
| is_pr_card | smallint | DEFAULT 0 NOT NULL |
| card_type | nvarchar(255), | |
| cost_center_id | int | |
| project_number_id | int | |
| glcode | nvarchar(255), | |
| change_timestamp | datetime, | |
| cardholder_id | nvarchar(255), | |
| pci_token | nvarchar(255), | |
| per_transaction_limit_id | int, | |
| per_transaction_limit | numeric(28,10), | |
|
CONSTRAINT PK__alc24927208 PRIMARY KEY CLUSTERED ( ccard_id ) ) |
||
| CREATE TABLE alcc_level3_detail ( | ||
|---|---|---|
| cc_level3_detail_id | int | NOT NULL, |
| cc_transaction_id | int, | |
| charge_date | datetime | NOT NULL, |
| native_amount | numeric(28,10) | NOT NULL, |
| native_amount_id | int | NOT NULL, |
| level3_code_id | int, | |
| description | nvarchar(255), | |
| sequence_number | int, | |
| level3_identifier | nvarchar(255), | |
| change_timestamp | datetime, | |
| cct_reference | nvarchar(255), | |
|
CONSTRAINT PK478 PRIMARY KEY CLUSTERED ( cc_level3_detail_id ) ) |
||
| CREATE TABLE alcc_transaction ( | ||
|---|---|---|
| cc_transaction_id | int | NOT NULL, |
| ccard_id | int | NOT NULL, |
| merchant_id | int, | NOT NULL |
| currency_fmt_defn_id | int, | |
| cct_reference | nvarchar(255), | |
| cct_type | smallint | NOT NULL, |
| cct_amt_us_id | int, | |
| cct_amt_us | numeric(28,10) | NOT NULL, |
| cct_posting_date | datetime | NOT NULL, |
| cct_date | datetime, | |
| vat_amt_native_id | int, | |
| vat_amt_native | numeric(28,10), | |
| cct_amt_native_id | int, | |
| cct_amt_native | numeric(28,10), | |
| cct_currency_code | nchar(3), | |
| cct_active_status | smallint | NOT NULL, |
| cct_import_timestamp | datetime, | |
| external_system_id | nvarchar(255), | |
| offline_user_id | int, | |
| doc_date_offlined | datetime, | |
| er_doc_id | int, | |
| location_id | int, | |
| expense_type_id | int, | |
| cct_description | nvarchar(255), | |
| cc_transaction_detail_id | int, | |
| change_timestamp | datetime, | |
| cct_status_int | int, | |
| cct_sequence_number | int, | |
| cct_statement_date | datetime, | |
|
CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id ) ) |
||
| CREATE TABLE alcc_transaction_detail ( | ||
|---|---|---|
| cc_transaction_detail_id | int | NOT NULL, |
| airline_departure_date | datetime, | |
| airline_routing | nvarchar(255), | |
| airline_class_of_service | nvarchar(20), | |
| airline_travel_agency_name | nvarchar(45), | |
| airline_ticket_number | nvarchar(20), | |
| car_rental_agreement_number | nvarchar(30), | |
| hotel_arrival_date | datetime, | |
| hotel_departure_date | datetime, | |
| hotel_stay_duration | int, | |
| hotel_folio_ref_number | nvarchar(30), | |
| hotel_room_type | nvarchar(30), | |
| hotel_room_amount | numeric(28,10), | |
| hotel_room_amount_id | int, | |
| hotel_room_tax_1 | numeric(28,10), | |
| hotel_room_tax_1_id | int, | |
| hotel_room_tax_2 | numeric(28,10), | |
| hotel_room_tax_2_id | int, | |
| hotel_phone_amount | numeric(28,10), | |
| hotel_phone_amount_id | int, | |
| hotel_phone_tax_1 | numeric(28,10), | |
| hotel_phone_tax_1_id | int, | |
| hotel_phone_tax_2 | numeric(28,10), | |
| hotel_phone_tax_2_id | int, | |
| hotel_restaurant_amount | numeric(28,10), | |
| hotel_restaurant_amount_id | int, | |
| hotel_restaurant_tax_1 | numeric(28,10), | |
| hotel_restaurant_tax_1_id | int, | |
| hotel_restaurant_tax_2 | numeric(28,10), | |
| hotel_restaurant_tax_2_id | int, | |
| hotel_room_service_amount | numeric(28,10), | |
| hotel_room_service_amount_id | int, | |
| hotel_room_service_tax_1 | numeric(28,10), | |
| hotel_room_service_tax_1_id | int, | |
| hotel_room_service_tax_2 | numeric(28,10), | |
| hotel_room_service_tax_2_id | int, | |
| hotel_tip_amount_1 | numeric(28,10), | |
| hotel_tip_amount_1_id | int, | |
| hotel_tip_amount_2 | numeric(28,10), | |
| hotel_tip_amount_2_id | int, | |
| hotel_others_amount | numeric(28,10), | |
| hotel_others_amount_id | int, | |
| hotel_others_tax_1 | numeric(28,10), | |
| hotel_others_tax_1_id | int, | |
| hotel_others_tax_2 | numeric(28,10), | |
| hotel_others_tax_2_id | int, | |
| hotel_room_rate | numeric(28,10), | |
| hotel_room_rate_id | int, | |
| hotel_room_tax_daily | numeric(28,10), | |
| hotel_room_tax_daily_id | int, | |
| hotel_laundry_amount | numeric(28,10), | |
| hotel_laundry_amount_id | int, | |
| hotel_gift_shop_amount | numeric(28,10), | |
| hotel_gift_shop_amount_id | int, | |
| hotel_movie_amount | numeric(28,10), | |
| hotel_movie_amount_id | int, | |
| hotel_bus_center_amount | numeric(28,10), | |
| hotel_bus_center_amount_id | int, | |
| hotel_health_club_amount | numeric(28,10), | |
| hotel_health_club_amount_id | int, | |
| hotel_total_tax | numeric(28,10), | |
| hotel_total_tax_id | int, | |
| origin_airport | nvarchar(10), | |
| dest_airport | nvarchar(10), | |
| booking_agent_id | int, | |
| airline_class_of_service_id | int, | |
| car_class_of_service_id | int, | |
| hotel_class_of_service_id | int, | |
| airline_domestic_or_intl | int, | |
| passenger_name | nvarchar(255), | |
|
CONSTRAINT PK415 PRIMARY KEY CLUSTERED ( cc_transaction_detail_id ) ) |
||
| CREATE TABLE alco_budget_history ( | ||
|---|---|---|
| budget_history_id | int | NOT NULL |
| doc_type | int | NOT NULL |
| doc_id | int | NOT NULL |
| budget_id | int | NOT NULL |
| budget_line_id | int | NOT NULL |
| amount | numeric(28,10) | NOT NULL |
| amount_id | int | NOT NULL |
| action | int | NOT NULL |
| released | smallint | |
| change_timestamp | datetime | |
|
CONSTRAINT PK563 PRIMARY KEY CLUSTERED ( budget_history_id ) ) |
||
| CREATE TABLE alco_budget_line ( | ||
|---|---|---|
| budget_line_id | int | NOT NULL |
| budget_id | int | NOT NULL |
| budget_account_id | int | NOT NULL |
| cost_center_id | int | |
| project_id | int | |
| budgeted_amount | numeric(28,10) | NOT NULL |
| budgeted_amount_id | int | NOT NULL |
| adjusted_amount | numeric(28,10) | NOT NULL |
| adjusted_amount_id | int | NOT NULL |
| allocated_amount | numeric(28,10) | NOT NULL |
| allocated_amount_id | int | NOT NULL |
| committed_amount | numeric(28,10) | NOT NULL |
| committed_amount_id | int | NOT NULL |
| change_timestamp | datetime | |
| active_status | smallint | NOT NULL |
| CONSTRAINT PK562 PRIMARY KEY CLUSTERED ( budget_line_id ) | ||
| CREATE TABLE alco_euro_rates ( | ||
|---|---|---|
| euro_rates_id | int | NOT NULL |
| currency_fmt_defn_id | int | NOT NULL |
| exchange_rate | numeric(28,10) | NOT NULL |
| change_timestamp | datetime | |
|
CONSTRAINT PK__alc656C112C PRIMARY KEY CLUSTERED ( euro_rates_id ) ) |
||
| CREATE TABLE alco_expense_type ( | ||
|---|---|---|
| expense_type_id | int | NOT NULL |
| user_id | int | |
| expense_type_label | nvarchar(255) | NOT NULL |
| category_label | nvarchar(255) | |
| gl_code | nchar(20) | |
| tax_deductable_percent | smallint | NOT NULL |
| itemization_only | smallint | DEFAULT 0 NOT NULL |
| field_disp_control | smallint | |
| category_class | smallint | |
| expense_special_code_id | int | |
| expense_active_status | smallint | NOT NULL |
| major_account | nchar(10) | |
| travel_category_id | int | |
| external_system_id | nvarchar(255) | |
| default_offline_perdiem_amt_id | int | |
| default_offline_perdiem_amt | numeric(28,10) | |
| change_timestamp | datetime | |
| currency_fmt_defn_id | int | |
| short_label | nvarchar(255) | |
| perdiem_subtype | smallint | |
| pd_definition_id | int | |
| description | nvarchar(max) | |
| not_selectable | int | DEFAULT 0 NOT NULL |
| image_name | nvarchar(255) | |
|
CONSTRAINT PK__alc6D0D32F4 PRIMARY KEY CLUSTERED ( expense_type_id ) ) |
||
| CREATE TABLE alco_fx_rate ( | ||
|---|---|---|
| fx_rate_id | int | NOT NULL |
| currency_fmt_defn_id | int | |
| valid_date | datetime | NOT NULL |
| fx_rate | numeric(28,10) | |
| change_timestamp | datetime | |
|
CONSTRAINT PK__alc787EE5A0 PRIMARY KEY CLUSTERED ( fx_rate_id ) ) |
||
| CREATE TABLE alco_guest_wrapper ( | ||
|---|---|---|
| guest_wrapper_id | int | NOT NULL |
| parent_id | int | NOT NULL |
| guest_id | int | NOT NULL |
| change_timestamp | datetime | |
| native_amount | numeric(28,10) | |
| native_amount_id | int | |
| paid_in_amount | numeric(28,10) | |
| paid_in_amount_id | int | |
| adc1 | nvarchar(255) | |
| adc2 | nvarchar(255) | |
| adc3 | nvarchar(255) | |
| adc4 | nvarchar(255) | |
| adc5 | nvarchar(255) | |
| adc6 | nvarchar(255) | |
| combo_adc1 | int | |
| combo_adc2 | int | |
| combo_adc3 | int | |
| combo_adc4 | int | |
| combo_adc5 | int | |
| combo_adc6 | int | |
| address_id | int | |
|
CONSTRAINT PK__alc7C4F7684 PRIMARY KEY CLUSTERED ( guest_wrapper_id ) ) |
||
| CREATE TABLE alco_mileage_rate ( | ||
|---|---|---|
| mileage_rate_id | int | NOT NULL |
| reimburs_rate | float | |
| take_effect_date | datetime | NOT NULL |
| mileage_active_status | smallint | |
| expense_type_id | int | |
| change_timestamp | datetime | |
| description | nvarchar(40) | NOT NULL |
| expiration_date | datetime | |
| per_passenger_rate | numeric(28,10) | |
| distance_low | int | |
| distance_high | int | |
| mileage_threshold | int | |
| rate_above_threshold | numeric(28,10) | |
| distance_unit | nchar(3) | NOT NULL |
|
CONSTRAINT PK__alc0E6E26BF PRIMARY KEY CLUSTERED ( mileage_rate_id ) ) |
||
| CREATE TABLE alco_report_fx_rate ( | ||
|---|---|---|
| report_fx_rate_id | int | NOT NULL |
| from_currency_fmt_id | int | NOT NULL |
| to_currency_fmt_id | int | NOT NULL |
| from_valid_date | datetime | |
| to_valid_date | datetime | NOT NULL |
| fx_rate | numeric(28,10) | |
| change_timestamp datetime | ||
|
CONSTRAINT PK544 PRIMARY KEY CLUSTERED ( report_fx_rate_id ) ) |
||
| CREATE TABLE alco_user ( | ||
|---|---|---|
| user_id | int | NOT NULL |
| cost_center_id | int | |
| user_full_name | nvarchar(255) | NOT NULL |
| user_first_name | nvarchar(255) | |
| user_middle_initial | nchar(1) | |
| user_last_name | nvarchar(255) | |
| employee_number | nvarchar(255) | |
| user_password | nvarchar(255) | NOT NULL |
| user_title | nvarchar(255) | |
| user_location | nvarchar(255) | |
| user_telephone | nvarchar(255) | |
| user_mailstop | nvarchar(255) | |
| user_email_address | nvarchar(255) | |
| email_product | nvarchar(255) | |
| user_login | nvarchar(255) | |
| user_dept_code | nchar(10) | |
| user_company_code | nchar(10) | |
| user_fax_number | nvarchar(255) | |
| payroll_system_code | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| ssn | nvarchar(255) | |
| creation_time | datetime | NOT NULL |
| currency_fmt_defn_id | int | NOT NULL |
| country_id | int | |
| has_credit_cards | smallint | |
| cc_expiration_date | datetime | |
| pso_data | int | |
| external_data | nvarchar(255) | |
| set_of_books_id | int | |
| remote_access_device_id | nvarchar(255) | |
| auth_amount | numeric(28,10) | |
| auth_amount_id | int | |
| pr_auth_amount | numeric(28,10) | |
| pr_auth_amount_id | int | |
| 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 | |
| office_id | int | |
| out_of_office | smallint | DEFAULT 0 NOT NULL |
| change_timestamp | datetime | |
| audit_group_id | int | |
| default_mileage_rate_id | int | |
| is_thin_client_user | smallint | NOT NULL |
| preferred_locale | nvarchar(32) | |
| second_currency_id | int | |
| user_email_address_2 | nvarchar(255) | |
| user_email_address_3 | nvarchar(255) | |
| commute_miles | numeric(26,16) | |
| validation_id | nvarchar(255) | |
| identity2 | nvarchar(36) | |
| lc_user_login AS ( lower(user_login) ) | ||
| preferred_timezone | nvarchar(255) | NULL |
|
CONSTRAINT PK__alc4C6B5938 PRIMARY KEY CLUSTERED ( user_id ) ) |
||
| CREATE TABLE alco_vat_account ( | ||
|---|---|---|
| vat_account_id | int | NOT NULL |
| set_of_books_id | int | NOT NULL |
| parent_id | int | |
| vat_account_name | nvarchar(255) | NOT NULL |
| vat_account_description | nvarchar(255) | |
| vatd_gl_account | nvarchar(255) | |
| vatd_gl_subaccount | nvarchar(255) | |
| vat_percent | float | |
| claimed_percent | float | |
| vat_deductible_percent | float | |
| vat_deductible_constant | numeric(28,10) | |
| vat_deductible_constant_id | int | |
| vat_deductible_per_mile | numeric(28,10) | |
| vat_deductible_per_mile_id | int | |
| vat_deductible_per_guest | numeric(28,10) | |
| vat_deductible_per_guest_id | int | |
| spending_locale_id | int | |
| active_status | int | NOT NULL |
| vatdsub0 | nvarchar(18) | |
| vatdsub1 | nvarchar(18) | |
| vatdsub2 | nvarchar(18) | |
| vatdsub3 | nvarchar(18) | |
| vatdsub4 | nvarchar(18) | |
| vatdsub5 | nvarchar(18) | |
| vatdsub6 | nvarchar(18) | |
| vatdsub7 | nvarchar(18) | |
| vatdsub8 | nvarchar(18) | |
| vatdsub9 | nvarchar(18) | |
| change_timestamp | datetime | |
| vat_rate_per_mile | numeric(28,10) | |
| vat_rate_per_mile_id | int | |
| pst_percent | float | |
| pst_claimed_percent | float | |
| include_gst_in_pst | int | DEFAULT 0 NOT NULL |
| pst_gl_account | nvarchar(255) | |
| pst_gl_subaccount | nvarchar(255) | |
| pstsub0 | nvarchar(18) | |
| pstsub1 | nvarchar(18) | |
| pstsub2 | nvarchar(18) | |
| pstsub3 | nvarchar(18) | |
| pstsub4 | nvarchar(18) | |
| pstsub5 | nvarchar(18) | |
| pstsub6 | nvarchar(18) | |
| pstsub7 | nvarchar(18) | |
| pstsub8 | nvarchar(18) | |
| pstsub9 | nvarchar(18) | |
| vat_unclaimed_gl_account | nvarchar(255) | |
| vat_unclaimed_gl_subaccount | nvarchar(255) | |
| vat_unclaimed_sub0 | nvarchar(18) | |
| vat_unclaimed_sub1 | nvarchar(18) | |
| vat_unclaimed_sub2 | nvarchar(18) | |
| vat_unclaimed_sub3 | nvarchar(18) | |
| vat_unclaimed_sub4 | nvarchar(18) | |
| vat_unclaimed_sub5 | nvarchar(18) | |
| vat_unclaimed_sub6 | nvarchar(18) | |
| vat_unclaimed_sub7 | nvarchar(18) | |
| vat_unclaimed_sub8 | nvarchar(18) | |
| vat_unclaimed_sub9 | nvarchar(18) | |
| pst_unclaimed_gl_account | nvarchar(255) | |
| pst_unclaimed_gl_subaccount | nvarchar(255) | |
| pst_unclaimed_sub0 | nvarchar(18) | |
| pst_unclaimed_sub1 | nvarchar(18) | |
| pst_unclaimed_sub2 | nvarchar(18) | |
| pst_unclaimed_sub3 | nvarchar(18) | |
| pst_unclaimed_sub4 | nvarchar(18) | |
| pst_unclaimed_sub5 | nvarchar(18) | |
| pst_unclaimed_sub6 | nvarchar(18) | |
| pst_unclaimed_sub7 | nvarchar(18) | |
| pst_unclaimed_sub8 | nvarchar(18) | |
| pst_unclaimed_sub9 | nvarchar(18) | |
| tax_deduction_method | int | |
| vat_on_personal_expenses | int | DEFAULT 0 NOT NULL |
| vat_javascript_id | int | |
| expense_account_list | nvarchar(255) | |
| effective_date | datetime | |
| until_date | datetime | |
|
CONSTRAINT PK__alc58D1301D PRIMARY KEY CLUSTERED ( vat_account_id ) ) |
||
| CREATE TABLE alct_name_value_pair ( | ||
|---|---|---|
| name_value_pair_id | int | NOT NULL |
| parent_id | int | |
| name | nvarchar(255) | NOT NULL |
| display_string | nvarchar(255) | NOT NULL |
| type | nchar(1) | NOT NULL |
| int_value | int | |
| float_value | float | |
| date_value | datetime | |
| string_value | nvarchar(255) | |
| hours_value | numeric(14,4) | |
| currency_value | numeric(28,10) | |
| currency_value_id | int | |
| bobref_value_type | int | |
| bobref_value | int | |
|
CONSTRAINT PK__alc04AFB25B PRIMARY KEY CLUSTERED ( name_value_pair_id ) ) |
||
| CREATE TABLE aler_expense_line_adjustment ( | ||
|---|---|---|
| adjustment_id | int | NOT NULL |
| exp_line_item_id | int | |
| sequence_number | int | NOT NULL |
| change_timestamp | datetime | |
| amount | numeric(28,10) | NOT NULL |
| amount_id | int | NOT NULL |
| new_balance | numeric(28,10) | NOT NULL |
| new_balance_id | int | NOT NULL |
| adjuster_id | int | |
| CONSTRAINT PK__ale1B9317B3 PRIMARY KEY CLUSTERED ( adjustment_id ) ) | ||
| CREATE TABLE aler_expense_line_item ( | ||
|---|---|---|
| exp_line_item_id | int | NOT NULL |
| parent_id | int | |
| payment_type_id | int | |
| expense_type_id | int | |
| vendor_id | int | |
| currency_fmt_defn_id | int | |
| cc_transaction_id | int | |
| cct_reference | nvarchar(255) | |
| expense_item_date | datetime | |
| expense_description | nvarchar(255) | |
| erli_amt_paid_id | int | |
| erli_amt_paid | numeric(28,10) | |
| erli_native_amt_id | int | |
| erli_native_amt | numeric(28,10) | |
| purpose_id | int | |
| odometer_start | numeric(15,5) | |
| odometer_end | numeric(15,5) | |
| miles | numeric(15,5) | |
| reimburs_rate | float | |
| erli_exch_rate | numeric(26,16) | |
| exp_item_note | nchar(5) | |
| item_gl_code | nchar(20) | |
| erli_amt_approv_id | int | |
| erli_amt_approv | numeric(28,10) | |
| item_overridden | smallint | |
| has_receipt | smallint | |
| receipt_checked | smallint | |
| is_approved | smallint | |
| tr_number | nvarchar(255) | |
| location_id | int | |
| chg_allocation_option | smallint | |
| chg_balancing_option | smallint | |
| is_personal | smallint | |
| is_itemized | smallint | |
| is_itemization | smallint | |
| has_notes | smallint | |
| use_euro | smallint | |
| doc_based_allocation | smallint | |
| perdiem_amount_id | int | |
| perdiem_amount | numeric(28,10) | |
| hh_transaction_id | int | |
| recurring_id | int | |
| recurring_count | int | |
| exch_rate_default | numeric(26,16) | |
| expense_account_id | int | |
| vat_account_id | int | |
| td_amount_id | int | |
| td_amount | numeric(28,10) | |
| ntd_amount_id | int | |
| ntd_amount | numeric(28,10) | |
| vat_amount_id | int | |
| vat_amount | numeric(28,10) | |
| approved_exchange_rate | numeric(26,16) | |
| vat_amount_override | numeric(28,10) | |
| vat_amount_override_id | int | |
| vat_miles_override | numeric(15,5) | |
| vat_guests_override | int | |
| expense_item_depart_date | datetime | |
| origin_airport | nvarchar(10) | |
| dest_airport | nvarchar(10) | |
| booking_agent | int | |
| ticket_status | int | |
| ticket_number | nvarchar(50) | |
| car_rental_agreement | nvarchar(50) | |
| airline_class_of_service | int | |
| car_class_of_service | int | |
| hotel_class_of_service | int | |
| is_vat_receipt | smallint | |
| mileage_rate_id | int | |
| mileage_passenger_num | int | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| pst_amount | numeric(28,10) | |
| pst_amount_id | int | |
| pst_amount_override | numeric(28,10) | |
| pst_amount_override_id | int | |
| vat_unclaimed_amount | numeric(28,10) | |
| vat_unclaimed_amount_id | int | |
| pst_unclaimed_amount | numeric(28,10) | |
| pst_unclaimed_amount_id | int | |
| guest_count | int | |
| flex_field_string_1 | nvarchar(255) | |
| flex_field_string_2 | nvarchar(255) | |
| flex_field_string_3 | nvarchar(255) | |
| flex_field_string_4 | nvarchar(255) | |
| flex_field_integer_1 | int | |
| flex_field_integer_2 | int | |
| flex_field_date_1 | datetime | |
| flex_field_date_2 | datetime | |
| flex_field_amount_1 | numeric(28,10) | |
| flex_field_amount_1_id | int | |
| flex_field_amount_2 | numeric(28,10) | |
| flex_field_amount_2_id | int | |
| flex_field_location_1_id | int | |
| flex_field_ddlb_1_id | int | |
| flex_field_ddlb_2_id | int | |
| flex_field_ddlb_3_id | int | |
| flex_field_ddlb_4_id | int | |
| flex_field_ddlb_5_id | int | |
| is_quick_item | smallint | |
| quick_item_error | smallint | |
| mileage_route_id | int | |
| original_vat_account_id | int | |
| commute_miles | numeric(26,16) | |
| guest_entry_mode | smallint | DEFAULT 0 NOT NULL |
| guest_amounts_equal | smallint | DEFAULT 1 NOT NULL |
| airline_domestic_or_intl | int | |
| guest_no_show_count | int | |
| passenger_name | nvarchar(255) | |
| creator_client_type | int | |
| CONSTRAINT PK__ale1D7B6025 PRIMARY KEY CLUSTERED ( exp_line_item_id ) ) | ||
| CREATE TABLE aler_expense_report ( | ||
|---|---|---|
| exp_rep_data_id | int | NOT NULL |
| user_id | int | |
| cash_adv_amount_id | int | |
| cash_adv_amount | numeric(28,10) | |
| company_charges_id | int | |
| company_charges | numeric(28,10) | |
| amount_due_emp_id | int | |
| amount_due_emp | numeric(28,10) | |
| amount_due_co_id | int | |
| amount_due_co | numeric(28,10) | |
| auth_amt_id | int | |
| auth_amt | numeric(28,10) | |
| total_expense_id | int | |
| total_expense | numeric(28,10) | |
| exp_rep_date_created | datetime | |
| exp_rep_date_filed | datetime | |
| er_date_from | datetime | |
| er_date_to | datetime | |
| show_currency | smallint | |
| show_bill_to | smallint | |
| separate_bill | smallint | |
| per_diem | nchar(6) | |
| doc_status | int | |
| exp_rep_is_approved | nchar(6) | |
| er_paid_on | datetime | |
| er_amt_paid | numeric(28,10) | |
| er_amt_paid_id | int | |
| er_payment_number | nvarchar(255) | |
| exp_rep_title | nvarchar(255) | |
| envelope_id | nvarchar(255) | |
| purpose_id | int | |
| exp_emp_dept | nvarchar(255) | |
| exp_emp_company | nvarchar(255) | |
| applied_lcf_id | int | |
| applied_lcf | numeric(28,10) | |
| applied_adj_id | int | |
| applied_adj | numeric(28,10) | |
| corp_charge_total_id | int | |
| corp_charge_total | numeric(28,10) | |
| remaining_lcf_id | int | |
| remaining_lcf | numeric(28,10) | |
| corp_charge_date | datetime | |
| corp_charge_amt_paid_id | int | |
| corp_charge_amt_paid | numeric(28,10) | |
| exp_note | nvarchar(5) | |
| chg_allocation_option | smallint | |
| chg_balancing_option | smallint | |
| corp_card_type | smallint | |
| business_model | smallint | |
| company_pays_cards | numeric(28,10) | |
| company_pays_cards_id | int | |
| generated_lcf_id | int | |
| generated_lcf | numeric(28,10) | |
| receipt_received | datetime | |
| date_approved | datetime | |
| payment_made | numeric(28,10) | |
| payment_made_id | int | |
| receipt_packet_expected | smallint | |
| receipt_email_deadline_date | datetime | |
| receipt_hitlist_deadline_date | datetime | |
| create_location_id | int | |
| flex_field_string_1 | nvarchar(255) | |
| flex_field_string_2 | nvarchar(255) | |
| flex_field_string_3 | nvarchar(255) | |
| flex_field_string_4 | nvarchar(255) | |
| flex_field_integer_1 | int | |
| flex_field_integer_2 | int | |
| flex_field_date_1 | datetime | |
| flex_field_date_2 | datetime | |
| flex_field_amount_1 | numeric(28,10) | |
| flex_field_amount_1_id | int | |
| flex_field_amount_2 | numeric(28,10) | |
| flex_field_amount_2_id | int | |
| flex_field_location_1_id | int | |
| flex_field_ddlb_1_id | int | |
| flex_field_ddlb_2_id | int | |
| flex_field_ddlb_3_id | int | |
| flex_field_ddlb_4_id | int | |
| flex_field_ddlb_5_id | int | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK__ale1F63A897 PRIMARY KEY CLUSTERED ( exp_rep_data_id ) ) | ||
| CREATE TABLE aler_line_allocation ( | ||
|---|---|---|
| line_allocation_id | int | NOT NULL |
| exp_line_item_id | int | NOT NULL |
| percent_allotted | numeric(26,16) | |
| base_amount_id | int | |
| base_amount | numeric(28,10) | |
| native_amount_id | int | |
| native_amount | numeric(28,10) | |
| is_approved | smallint | |
| cost_center_id | int | |
| project_number_id | int | |
| is_billable | smallint | |
| CONSTRAINT PK__ale251C81ED PRIMARY KEY CLUSTERED ( line_allocation_id ) ) | ||
| CREATE TABLE aler_overage ( | ||
|---|---|---|
| overage_id | int | NOT NULL |
| parent_id | int | NOT NULL |
| overage_date | datetime | NOT NULL |
| total_actual_amount | numeric(28,10) | |
| total_actual_amount_id | int | |
| total_perdiem_amount | numeric(28,10) | |
| total_perdiem_amount_id | int | |
| gl_account | nvarchar(255) | |
| overage_group_id | int | NOT NULL |
| total_personal_amount | numeric(28,10) | |
| total_personal_amount_id | int | |
| overage_end_date | datetime | |
| CONSTRAINT PK307 PRIMARY KEY CLUSTERED ( overage_id ) ) | ||
| CREATE TABLE aler_overage_lines ( | ||
|---|---|---|
| overage_lines_id | int | NOT NULL |
| overage_id | int | NOT NULL |
| overage_line_type | int | NOT NULL |
| exp_line_item_id | int | |
| perdiem_expense_type | int | |
| perdiem_amount | numeric(28,10) | |
| perdiem_amount_id | int | |
| CONSTRAINT PK308 PRIMARY KEY CLUSTERED ( overage_lines_id ) ) | ||
| CREATE TABLE aler_review_policies ( | ||
|---|---|---|
| review_policy_id | int | NOT NULL |
| expense_type_id | int | NOT NULL |
| amount | numeric(28,10) | NOT NULL |
| amount_id | int | |
| currency_fmt_defn_id | int | NOT NULL |
| change_timestamp | datetime | |
| rule_title | nvarchar(255) | |
| rule_policy | nvarchar(max) | |
| rule_interact_message | nvarchar(510) | |
| rule_report_message | nvarchar(510) | |
| rule_severity | int | |
| rule_notify | int | |
| locale | int | |
| active_status | int | |
| routing_type_id | int | |
| CONSTRAINT PK1 PRIMARY KEY CLUSTERED ( review_policy_id ) ) | ||
| CREATE TABLE aler_user_balance_history ( | ||
|---|---|---|
| user_bal_hist_id | int | NOT NULL |
| er_user_pref_id | int | |
| user_causing_change_id | int | NOT NULL |
| history_sequence_number | int | NOT NULL |
| history_timestamp | datetime | NOT NULL |
| transaction_type_code | int | NOT NULL |
| lcf_change_amount | numeric(28,10) | |
| lcf_change_amount_id | int | |
| lcf_new_balance | numeric(28,10) | |
| lcf_new_balance_id | int | |
| pa_change_amount | numeric(28,10) | |
| pa_change_amount_id | int | |
| pa_new_balance | numeric(28,10) | |
| pa_new_balance_id | int | |
| doc_tracking_id | nvarchar(255) | |
| exp_rep_data_id | int | |
| CONSTRAINT PK__ale2CBDA3B5 PRIMARY KEY CLUSTERED ( user_bal_hist_id ) | ||
| CREATE TABLE aler_user_preference ( | ||
|---|---|---|
| er_user_pref_id | int | NOT NULL |
| user_id | int | NOT NULL |
| unfiled_days_thresh | int | |
| alert_on_br_violation | smallint | |
| display_doc_number | smallint | |
| display_hist_thresh | int | |
| wf_initial_view | int | |
| cost_center_id | int | |
| lcf_total_id | int | |
| lcf_total | numeric(28,10) | |
| pending_adj_total_id | int | |
| pending_adj_total | numeric(28,10) | |
| project_number_id | int | |
| cur_balance_hist_seq | int | |
| change_timestamp | datetime | |
| CONSTRAINT PK__ale2EA5EC27 PRIMARY KEY CLUSTERED ( er_user_pref_id ) | ||
| CREATE TABLE alhh_transaction ( | ||
|---|---|---|
| hh_transaction_id | int | NOT NULL |
| user_id | int | NOT NULL |
| hh_device_id | int | |
| hht_date | datetime | NOT NULL |
| hh_exp_type_map_id | int | NOT NULL |
| hht_amount_id | int | |
| hht_amount | numeric(28,10) | NOT NULL |
| payment_type_id | int | |
| vendor_id | int | |
| location_id | int | |
| hht_attendees | nvarchar(255) | |
| hht_note | nvarchar(255) | |
| hht_document_id | int | |
| hht_import_timestamp | datetime | |
| hht_active_status | smallint | NOT NULL |
| hht_miles | numeric(15,5) | |
| hht_palm_internal_id | int | |
| CONSTRAINT PK__alh3CF40B7E PRIMARY KEY CLUSTERED ( hh_transaction_id ) | ||
| CREATE TABLE almt_extension ( | ||
|---|---|---|
| extension_id | int | |
| name | nvarchar(255) | NOT NULL |
| type | int | NOT NULL |
| value_int | int | |
| value_float | float | |
| value_date | datetime | |
| value_string | nvarchar(5,10) | |
| value_hours | numeric(14,4) | |
| value_currency_id | int | |
| value_currency | numeric(28,10) | |
| value_bobref_type | int | |
| value_bobref | int | |
| parent_id | int | NOT NULL |
| CREATE TABLE alpd_conus_oconus_deduction ( | ||
|---|---|---|
| conus_oconus_deduction_id | int | NOT NULL |
| locale | smallint | |
| effective_date | datetime | |
| active_status | int | NOT NULL |
| change_timestamp | datetime | |
| perdiem_rate_id | int | |
| perdiem_rate | numeric(28,10) | NOT NULL |
| breakfast_deduction_amt_id | int | |
| breakfast_deduction_amt | numeric(28,10) | |
| lunch_deduction_amt_id | int | |
| lunch_deduction_amt | numeric(28 ,10) | |
| dinner_deduction_amt_id | int | |
| dinner_deduction_amt | numeric(28,10) | |
| incidentals_deduction_amt_id | int | |
| incidentals_deduction_amt | numeric(28,10) | |
| CONSTRAINT PK441 PRIMARY KEY CLUSTERED ( conus_oconus_deduction_id ) | ||
| CREATE TABLE alpd_conus_oconus_perdiem ( | ||
|---|---|---|
| conus_oconus_perdiem_id | int | NOT NULL |
| location_id | int | |
| max_lodging_amt_id | int | |
| max_lodging_amt | numeric(28,10) | |
| non_govt_meals_amt_id | int | |
| non_govt_meals_amt | numeric(28,10) | |
| proportional_meals_amt_id | int | |
| proportional_meals_amt | numeric(28,10) | |
| incidental_amt_id | int | |
| incidental_amt | numeric(28,10) | |
| footnote_amt_id | int | |
| footnote_amt | numeric(28,10) | |
| footnote_rate_amt_id | int | |
| footnote_rate_amt | numeric(28,10) | |
| per_diem_amt_id | int | |
| per_diem_amt | numeric(28,10) | |
| effective_date | datetime | |
| active_status | int | NOT NULL |
| change_timestamp | datetime | |
| CONSTRAINT PK440 PRIMARY KEY CLUSTERED ( conus_oconus_perdiem_id ) | ||
| CREATE TABLE alpd_eur_deduction ( | ||
|---|---|---|
| pd_deduction_id | int | NOT NULL |
| pd_definition_id | int | NOT NULL |
| locale | smallint | |
| long_term_stay | smallint | |
| breakfast | smallint | |
| lunch | smallint | |
| dinner | smallint | |
| deduction_type | smallint | |
| deduction_amount | numeric(28,10) | |
| deduction_amount_id | int | |
| deduction_percentage | float | |
| effective_date | datetime | |
| active_status | smallint | NOT NULL |
| change_timestamp | datetime | |
| CONSTRAINT PK__alpddeductions PRIMARY KEY CLUSTERED ( pd_deduction_id ) | ||
| CREATE TABLE alpd_eur_rate ( | ||
|---|---|---|
| pd_rate_id | int | NOT NULL |
| pd_definition_id | int | NOT NULL |
| location_id | int | |
| min_time_at_location | smallint | |
| per_hour | smallint | |
| overnight_stay | smallint | |
| first_day_of_trip | smallint | |
| last_day_of_trip | smallint | |
| rate_value | numeric(28,10) | NOT NULL |
| rate_value_id | int | NOT NULL |
| effective_date | datetime | |
| active_status | smallint | NOT NULL |
| change_timestamp | datetime | |
| CONSTRAINT PK__alpdrates PRIMARY KEY CLUSTERED ( pd_rate_id ) | ||
| CREATE TABLE alpd_generic_rate ( | ||
|---|---|---|
| rate_id | int | NOT NULL |
| pd_definition_id | int | NOT NULL |
| location_id | int | |
| rate_value | numeric(28 ,10) | NOT NULL |
| rate_value_id | int | |
| flex_string_1 | nvarchar(255) | |
| flex_string_2 | nvarchar(255) | |
| flex_string_3 | nvarchar(255) | |
| flex_string_4 | nvarchar(255) | |
| flex_string_5 | nvarchar(255) | |
| effective_date | datetime | |
| active_status | smallint | NOT NULL |
| change_timestamp | datetime | |
| CONSTRAINT PK566 PRIMARY KEY CLUSTERED ( rate_id ) | ||
| CREATE TABLE alpd_perdiem_line_data ( | ||
|---|---|---|
| pd_line_data_id | int | NOT NULL |
| exp_line_item_id | int | NOT NULL |
| private_nightstay_address | nvarchar(255) | |
| first_day_of_trip | smallint | |
| last_day_of_trip | smallint | |
| change_timestamp | datetime | |
| 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_id | int | |
| CONSTRAINT PK__alpdli PRIMARY KEY CLUSTERED ( pd_line_data_id ) | ||
| CREATE TABLE alpr_invoice ( | ||
|---|---|---|
| invoice_id | int | 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 | |
| total_amount | numeric(28,10) | |
| total_amount_id | int | |
| total_calculated_amount | numeric(28,10) | |
| total_calculated_amount_id | int | |
| total_discounted_amount | numeric(28,10) | |
| total_discounted_amount_id | int | |
| is_approved | smallint | |
| envelope_id | nvarchar(255) | |
| paid_date | datetime | |
| paid_amount | numeric(28,10) | |
| paid_amount_id | int | |
| payment_number | nvarchar(255) | |
| chg_allocation_option | smallint | |
| chg_balancing_option | smallint | |
| pr_vendor_id | int | |
| send_to_id | smallint | NOT NULL |
| discount_pay_by_date | datetime | |
| pr_purpose_id | int | |
| invoice_received | datetime | |
| invoice_packet_expected | smallint | |
| inv_recpt_email_deadline | datetime | |
| inv_recpt_hitlist_deadline | datetime | |
| requested_payment_date | datetime | |
| voucher_number | nvarchar(255) | |
| special_handling | nvarchar(255) | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK456 PRIMARY KEY CLUSTERED ( invoice_id ) | ||
| CREATE TABLE alpr_invoice_line_item ( | ||
|---|---|---|
| invoice_line_item_id | int | NOT NULL |
| invoice_id | int | NOT NULL |
| item_number | nvarchar(255) | |
| item_description | nvarchar(255) | |
| invoiced_quantity | int | |
| unit_of_measure_id | int | |
| unit_price_amount | numeric(28,10) | |
| unit_price_amount_id | int | |
| total_price_amount | numeric(28,10) | |
| total_price_amount_id | int | |
| check_request_type_id | int | |
| chg_allocation_option | smallint | |
| chg_balancing_option | smallint | |
| doc_based_allocation | smallint | |
| is_approved | smallint | |
| expense_account_id | int | |
| vat_account_id | int | |
| 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 | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK457 PRIMARY KEY CLUSTERED ( invoice_line_item_id ) | ||
| CREATE TABLE alpr_line_item ( | ||
|---|---|---|
| pr_line_item_id | int | NOT NULL |
| pr_document_id | int | |
| pr_payment_type_id | int | |
| item_id | int | |
| prli_description | nvarchar(255) | |
| prli_is_capital_expenditure | int | |
| prli_quantity | int | |
| prli_quantity_approved | int | |
| prli_is_taxable | int | |
| pr_category_id | int | |
| item_description | nvarchar(255) | |
| unit_of_measure_id | int | |
| prli_unit_price | numeric(28,10) | |
| prli_unit_price_id | int | |
| prli_total_price | numeric(28,10) | |
| prli_total_price_id | int | |
| pr_vendor_id | int | |
| prli_reason_for_purchase | nvarchar(255) | |
| prli_recipient | nvarchar(255) | |
| prli_deliver_by | datetime | |
| prli_chg_alloc_option | smallint | |
| prli_chg_alloc_bal_option | smallint | |
| prli_note | nvarchar(max) | |
| manufacturer_id | int | |
| item_status | nvarchar(255) | |
| item_number | nvarchar(255) | |
| imported_from_template | smallint | |
| manager | nvarchar(255) | |
| room_number | nvarchar(255) | |
| location | nvarchar(255) | |
| start_date | datetime | |
| end_date | datetime | |
| op_sys_id | int | |
| promised_by_date | datetime | |
| ext_po_pr_number | nvarchar(255) | |
| user_message_name | nvarchar(255) | |
| variance_qty | int | |
| po_create_timestamp | datetime | |
| internal_status | int | |
| old_unit_price_id | int | |
| old_unit_price | numeric(28,10) | |
| old_uom | int | |
| partnum_ext | nvarchar(255) | |
| available_qty | int | |
| real_time_check_timestamp | datetime | |
| max_back_order_qty | int | |
| max_received_qty | int | |
| purchase_order_id | int | |
| item_source | int | |
| cbr_approved | smallint | |
| CONSTRAINT PK__alp7EC1CEDB PRIMARY KEY CLUSTERED ( pr_line_item_id ) | ||
| CREATE TABLE alpr_purchase_order ( | ||
|---|---|---|
| purchase_order_id | int | NOT NULL |
| pr_document_id | int | |
| po_number | nvarchar(255) | |
| document_id | nvarchar(255) | |
| create_date | datetime | |
| pr_vendor_id | int | |
| total_cost | numeric(28,10) | |
| total_cost_id | int | |
| status | nvarchar(255) | |
| total_costoutstanding | numeric(28,10) | |
| total_costoutstanding_id | int | |
| pr_payment_type_id | int | |
| first_receive_by_date | datetime | |
| last_receive_by_date | datetime | |
| address_id | int | |
| pastduenotified | smallint | |
| all_received_status | smallint | |
| CONSTRAINT PK__alp0A338187 PRIMARY KEY CLUSTERED ( purchase_order_id ) | ||
| CREATE TABLE alpr_purchase_requisition ( | ||
|---|---|---|
| pr_document_id | int | NOT NULL |
| user_id | int | |
| pr_title | nvarchar(255) | |
| pr_purpose_id | int | |
| date_created | datetime | |
| date_submitted | datetime | |
| date_approved | datetime | |
| pr_tax_total | numeric(28,10) | |
| pr_tax_total_id | int | |
| pr_shipping_cost | numeric(28,10) | |
| pr_shipping_cost_id | int | |
| total_expense | numeric(28,10) | |
| total_expense_id | int | |
| pr_is_sourcing_request | smallint | |
| pr_vendor_id | int | |
| manufacturer_id | int | |
| ship_to_id | int | |
| pr_chg_alloc_option | smallint | |
| pr_chg_balancing_option | smallint | |
| doc_note | nvarchar(5) | |
| po_number | nvarchar(255) | |
| payment_terms | nvarchar(255) | |
| professional_buyer_id | int | |
| is_required | smallint | |
| envelope_id | nvarchar(255) | |
| bill_to_id | int | |
| shopping_cart_xml | nvarchar(max) | |
| CONSTRAINT PK__alp0C1BC9F9 PRIMARY KEY CLUSTERED ( pr_document_id ) | ||
| CREATE TABLE alpr_vendor_terms ( | ||
|---|---|---|
| vendor_terms_id | int | NOT NULL |
| name | nvarchar(255) | NOT NULL |
| term_name | nvarchar(255) | |
| term_days | int | |
| discount_amount_type | smallint | |
| discount_amount_percentage | numeric(20,10) | |
| discount_amount | numeric(28,10) | |
| discount_amount_id | int | |
| discount_term_days | int | |
| is_global_default | smallint | DEFAULT 0 NOT NULL |
| active_status | smallint | |
| change_timestamp | datetime | |
| CONSTRAINT PK459 PRIMARY KEY CLUSTERED ( vendor_terms_id ) | ||
| CREATE TABLE altr_line_item ( | ||
|---|---|---|
| tr_line_item_id | int | NOT NULL |
| tr_document_id | int | NOT NULL |
| tr_item_type_id | int | NOT NULL |
| cost_id | int | |
| cost | numeric(28,10) | |
| tax_cost_id | int | |
| tax_cost | numeric(28,10) | |
| note | nvarchar(max) | |
| purpose | int | |
| vendor | int | |
| from_location | int | |
| from_date | datetime | |
| from_time | datetime | |
| to_location | int | |
| to_date | datetime | |
| to_time | datetime | |
| class_of_service | int | |
| daily_rate_id | int | |
| daily_rate | numeric(28,10) | |
| cust_def_1 | nvarchar(255) | |
| cust_def_2 | nvarchar(255) | |
| cust_def_3 | nvarchar(255) | |
| daily_rate_native_id | int | |
| daily_rate_native | numeric(28,10) | |
| currency_fmt_defn_id | int | |
| exch_rate | numeric(26,16) | |
| use_euro | smallint | |
| miles | numeric(15,5) | |
| reimburse_rate | float | |
| has_notes | smallint | |
| average_cost_id | int | |
| average_cost | numeric(28,10) | |
| is_imported | smallint | |
| description1 | nvarchar(255) | |
| description2 | nvarchar(255) | |
| ext_booking_key | nvarchar(255) | |
| exch_rate_default | numeric(26,16) | |
| trip_type | nchar(2) | |
| from_airport_code | nchar(3) | |
| to_airport_code | nchar(3) | |
| lowest_airfare | numeric(28,10) | |
| lowest_airfare_id | int | |
| lowest_hotel_rate | numeric(28,10) | |
| lowest_hotel_rate_id | int | |
| booking_source | nchar(2) | |
| agency_name | nvarchar(40) | |
| guest_count | int | |
| guest_entry_mode | smallint | DEFAULT 0 NOT NULL |
| guest_amounts_equal | smallint | DEFAULT 1 NOT NULL |
| guest_no_show_count | int | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK__alt314D4EA8 PRIMARY KEY CLUSTERED ( tr_line_item_id ) | ||
| CREATE TABLE altr_travel_item ( | ||
|---|---|---|
| tr_item_type_id | int | NOT NULL |
| expense_type_id | int | NOT NULL |
| tr_item_label | nvarchar(255) | NOT NULL |
| tr_item_icon | nvarchar(255) | |
| travel_category_id | int | NOT NULL |
| daily_rate_based | smallint | NOT NULL |
| taxable | smallint | NOT NULL |
| use_average_cost | smallint | |
| active_status | smallint | NOT NULL |
| short_label | nvarchar(255) | |
| default_offline_perdiem_amt_id | int | |
| default_offline_perdiem_amt | numeric(28,10) | |
| perdiem_subtype | smallint | |
| pd_definition_id | int | |
| include_last_day | smallint | DEFAULT 0 NOT NULL |
| instructions | nvarchar(max) | |
| CONSTRAINT PK__alt370627FE PRIMARY KEY CLUSTERED ( tr_item_type_id ) | ||
| CREATE TABLE altr_travel_request ( | ||
|---|---|---|
| tr_document_id | int | NOT NULL |
| user_id | int | NOT NULL |
| tr_title | nvarchar(255) | |
| tr_purpose | int | |
| tr_num_going | int | |
| tr_date_created | datetime | |
| tr_date_filed | datetime | |
| tr_date_from | datetime | |
| tr_date_to | datetime | |
| tr_tot_air_id | int | |
| tr_tot_air | numeric(28,10) | |
| tr_tot_hotel_id | int | |
| tr_tot_hotel | numeric(28,10) | |
| tr_tot_htax_id | int | |
| tr_tot_htax | numeric(28,10) | |
| tr_tot_car_id | int | |
| tr_tot_car | numeric(28,10) | |
| tr_tot_ctax_id | int | |
| tr_tot_ctax | numeric(28,10) | |
| tr_tot_meals_id | int | |
| tr_tot_meals | numeric(28,10) | |
| tr_tot_other_id | int | |
| tr_tot_other | numeric(28,10) | |
| tr_total_cost_id | int | |
| tr_total_cost | numeric(28,10) | |
| tr_emp_comp | nvarchar(255) | |
| tr_emp_dept | nvarchar(255) | |
| tr_tracking_num | nvarchar(255) | |
| doc_note | nvarchar(5) | |
| trip_type_id | int | |
| tr_date_approved | datetime | |
| chg_allocation_option | smallint | |
| chg_balancing_option | smallint | |
| ord_key | nvarchar(255) | |
| integration_partner_id | int | |
| max_air_ticket_amt_id | int | |
| max_air_ticket_amt | numeric(28,10) | |
| itinerary_state | int | |
| create_location_id | int | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK__alt3CBF0154 PRIMARY KEY CLUSTERED ( tr_document_id ) | ||
| CREATE TABLE alts_line_item ( | ||
|---|---|---|
| ts_line_item_id | int | NOT NULL |
| ts_document_id | int | NOT NULL |
| project_number_id | int | |
| ts_date | datetime | NOT NULL |
| ts_hours | numeric(14,4) | |
| hourly_charge_type_id | int | |
| charge_type_id | int | |
| ts_start_time | datetime | |
| ts_end_time | datetime | |
| location_id | int | |
| charge_role_id | int | |
| ts_note | nchar(5) | |
| pa_export_status | int | |
| app_ts_hours | numeric(14,4) | |
| app_hourly_charge_type_id | int | |
| ts_billable_rate | numeric(28,10) | |
| ts_billable_rate_id | int | |
| currency_fmt_defn_id | int | |
| cost_center_id | int | |
| change_timestamp | datetime | |
| 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) | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK__alt51BA1E3A PRIMARY KEY CLUSTERED ( ts_line_item_id ) | ||
| CREATE TABLE alts_timesheet ( | ||
|---|---|---|
| ts_document_id | int | NOT NULL |
| user_id | int | NOT NULL |
| ts_title | nvarchar(255) | |
| period_start | datetime | |
| period_end | datetime | |
| date_created | datetime | |
| date_submitted | datetime | |
| date_approved | datetime | |
| total_hours | numeric(14,4) | |
| report_period_id | int | |
| work_sched_id | int | |
| holiday_sched_id | int | |
| labor_status_id | int | |
| emp_status_id | int | |
| emp_comp | nvarchar(255) | |
| emp_dept | nvarchar(255) | |
| ts_tracking_num | nvarchar(255) | |
| doc_note | nvarchar(5) | |
| pa_export_status | int | |
| ts_billable_rate | numeric(28,10) | |
| ts_billable_rate_id | int | |
| ts_overrides_trail | nvarchar(max) | |
| ts_attendance_overtime | numeric(7,2) | |
| ts_attendance_double_time | numeric(7,2) | |
| ts_project_overtime | numeric(7,2) | |
| ts_project_double_time | numeric(7,2) | |
| mgr_preapproved_ot | smallint | |
| ts_attendance_triple_time | numeric(7,2) | |
| ts_project_triple_time | numeric(7,2) | |
| change_timestamp | datetime | |
| ts_profile_id | int | |
| creator_total | numeric(14,4) | |
| create_location_id | int | |
| job_class_id | int | |
| weekend_schedule_id | int | |
| is_incomplete | smallint | DEFAULT 0 NOT NULL |
| creator_client_type | int | |
| CONSTRAINT PK__alt5F141958 PRIMARY KEY CLUSTERED ( ts_document_id ) | ||
| CREATE TABLE alts_user_billable_rate ( | ||
|---|---|---|
| ts_user_billable_rate_id | int | NOT NULL |
| user_id | int | |
| project_number_id | int | |
| charge_role_id | int | |
| currency_fmt_defn_id | int | NOT NULL |
| ts_billable_rate | numeric(28,10) | NOT NULL |
| ts_billable_rate_id | int | NOT NULL |
| effective_date | datetime | |
| expiration_date | datetime | |
| create_user_id | int | |
| create_timestamp | datetime | |
| update_user_id | int | |
| change_timestamp | datetime | |
| CONSTRAINT PK__alt62E4AA3C PRIMARY KEY CLUSTERED ( ts_user_billable_rate_id ) | ||
| CREATE TABLE alwf_work_item ( | ||
|---|---|---|
| work_item_id | int | NOT NULL |
| parent_work_item_id | int | |
| business_object_id | int | NOT NULL |
| document_id | nvarchar(255) | NOT NULL |
| activity_id | int | NOT NULL |
| doc_priority | int | |
| doc_is_locked | smallint | NOT NULL |
| session_num | int | |
| is_suspended | smallint | NOT NULL |
| appl_exceptions | smallint | DEFAULT 0 NOT NULL |
| overrides | smallint | DEFAULT 0 NOT NULL |
| doc_specific | nvarchar(255) | |
| post_label | nvarchar(255) | |
| doc_date_created | datetime | |
| doc_date_modified | datetime | |
| time_entered_queue | datetime | |
| creator_user_id | int | |
| owner_user_id | int | |
| locked_by_user_id | int | |
| suspended_by_user_id | int | |
| released_by_user_id | int | |
| proxy_user_id | int | |
| project_number_id | int | |
| doc_description | nvarchar(255) | |
| bus_obj_type_id | int | |
| offline_user_id | int | |
| activity_number | int | |
| doc_date_offlined | datetime | |
| offline_special_code | int | |
| split_count | int | |
| recall_state | int | |
| last_transition | int | |
| audit_indicator | nvarchar(255) | |
| doc_specific_indicator | datetime | |
| change_timestamp | datetime | |
| rejected_exceptions | int | DEFAULT 0 NOT NULL |
| only_one_reviewer_needed | smallint | DEFAULT 0 NOT NULL |
| is_exported | smallint | DEFAULT 0 NOT NULL |
| doc_date_submitted | datetime | |
| audit_log | int | DEFAULT 0 NOT NULL |
| doc_specific_amount_id | int | |
| doc_specific_amount | numeric(28,10) | |
| doc_purpose | nvarchar(255) | |
| doc_approved_amount_id | int | |
| doc_approved_amount | numeric(28,10) | |
| CONSTRAINT PK__alw025D5595 PRIMARY KEY CLUSTERED ( work_item_id ) | ||
Modifications in Infor Expense Management 10.2.4
| CREATE TABLE alco_user_preference ( | ||
|---|---|---|
| user_pref_id | int | NOT NULL |
| user_id | int | NOT NULL |
| ccard_id | int | |
| backup_prompt_freq | nvarchar(255) | |
| toolbar_icons | nvarchar(255) | |
| show_list_on_entry | smallint | |
| auto_complete_flds | smallint | |
| cct_filter_status | smallint | |
| cct_filter_period | smallint | |
| cct_filter_startdate | datetime | |
| cct_filter_enddate | datetime | |
| cct_filter_transaction_type | nvarchar(255) | |
| cct_filter_card_name | nvarchar(255) | |
| cct_filter_er_title | nvarchar(255) | |
| cct_filter_er_Id | nvarchar(255) | |
| wf_filter_status | smallint | |
| wf_filter_er_created_beg | datetime | |
| wf_filter_er_created_end | datetime | |
| wf_filter_er_modified_beg | datetime | |
| wf_filter_er_modified_end | datetime | |
| wf_filter_er_queued_beg | datetime | |
| wf_filter_er_queued_end | datetime | |
| wf_filter_owner_option | smallint | |
| wf_filter_activity_option | smallint | |
| wf_filter_type_option | smallint | |
| wf_filter_owner_fld | nvarchar(255) | |
| wf_filter_activity_fld | nvarchar(255) | |
| wf_filter_type_fld | nvarchar(255) | |
| proxy_can_submit | smallint NOT NULL | |
| route_to | nvarchar(max) | |
| change_timestamp | datetime | |
| default_currency_id | int | |
| proxy_reviewer_can_submit | smallint | DEFAULT 0 NOT NULL |
| privacy_datetime_agreed | datetime | |
| mobile_privacy_agreed | datetime | |
| affirm_privacy_agreed | datetime | |
| CONSTRAINT PK__alc51300E55 PRIMARY KEY CLUSTERED ( user_pref_id ) ) | ||
| CREATE TABLE alob_online_booking_line_item ( | ||
|---|---|---|
| olb_line_item_id | int | |
| online_booking_data_id | int | |
| expense_type | nvarchar(255) | NOT NULL |
| vendor_code | nvarchar(255) | |
| vendor_name | nvarchar(255) | |
| location_code | nvarchar(255) | |
| location_name | nvarchar(255) | |
| olb_date | datetime | |
| olb_description | nvarchar(255) | |
| olbli_native_amt_currency_code | nvarchar(255) | |
| olbli_native_amt_currency_name | nvarchar(255) | |
| olbli_native_amt | nvarchar(255) | NOT NULL |
| purpose | nvarchar(255) | |
| origin_airport_code | nvarchar(255) | |
| origin_airport_name | nvarchar(255) | |
| dest_airport_code | nvarchar(255) | |
| dest_airport_name | nvarchar(255) | |
| ticket_status | nvarchar(255) | |
| ticket_number | nvarchar(255) | |
| airline_class_of_service_code | nvarchar(255) | |
| airline_class_of_service_name | nvarchar(255) | |
| route | nvarchar(255) | |
| car_class_of_service_code | nvarchar(255) | |
| car_class_of_service_name | nvarchar(255) | |
| hotel_class_of_service_code | nvarchar(255) | |
| hotel_class_of_service_name | nvarchar(255) | |
| hotel_arrival_date | datetime | |
| hotel_departure_date | datetime | |
| city_code | nvarchar(255) | |
| city_name | nvarchar(255) | |
| state_code | nvarchar(255) | |
| state_name | nvarchar(255) | |
| country_code | nvarchar(255) | |
| country_name | nvarchar(255) | |
| departure_date | datetime | |
| transaction_type | int | |
| CONSTRAINT PK490 PRIMARY KEY CLUSTERED ( olb_line_item_id ) ) | ||
| CREATE TABLE alcc_transaction ( | ||
|---|---|---|
| cc_transaction_id | int | NOT NULL |
| ccard_id | int | NOT NULL |
| merchant_id | int | |
| currency_fmt_defn_id | int | |
| cct_reference | nvarchar(255) | |
| cct_type | smallint | |
| cct_amt_us_id | int | |
| cct_amt_us | numeric(28,10) | NOT NULL |
| cct_posting_date | datetime | NOT NULL |
| cct_date | datetime | |
| vat_amt_native_id | int | |
| vat_amt_native | numeric(28,10) | |
| cct_amt_native_id | int | |
| cct_amt_native | numeric(28,10) | |
| cct_currency_code | nchar(3) | |
| cct_active_status | smallint | NOT NULL |
| cct_import_timestamp | datetime | |
| external_system_id | nvarchar(255) | |
| offline_user_id | int | |
| doc_date_offlined | datetime | |
| er_doc_id | int | |
| location_id | int | |
| expense_type_id | int | |
| cct_description | nvarchar(255) | |
| cc_transaction_detail_id | int | |
| change_timestamp | datetime | |
| cct_status_int | int | |
| cct_sequence_number | int | |
| cct_statement_date | datetime | |
| primary_iso_currency_code | nchar(3) | |
| market_code | nvarchar(50) | |
| global_client_origin_id | nvarchar(50) | |
| local_country_iso_code | nchar(3) | |
| CONSTRAINT PK__alc300424B4 PRIMARY KEY CLUSTERED ( cc_transaction_id ) ) | ||
Modifications in Infor Expense Management 10.2.5
| CREATE TABLE albr_parameter ( | ||
|---|---|---|
| br_parameter_id | int | NOT NULL |
| br_instance_id | int | |
| param_order | int | |
| param_type | nchar(2) | |
| param_name | nvarchar(255) | |
| string_value | nvarchar(1500) | |
| int_value | int | |
| float_value | float | |
| date_value | datetime | |
| money_value | numeric(28,10) | |
| money_value_id | int | |
| corp_data_name | nvarchar(65) | |
| active_status | smallint | NOT NULL |
| hours_value | numeric(14,4) | |
| change_timestamp | datetime | |
| gmt_date_value | datetime | |
| CONSTRAINT PK__alb1CF15040 PRIMARY KEY CLUSTERED ( br_parameter_id ) ) | ||
| CREATE TABLE albr_parameter_template ( | ||
|---|---|---|
| br_parameter_template_id | ||