New transaction tables
These transaction tables are added in Infor Expense Management 10.2.0:
| CREATE TABLE alco_xm_release ( | ||
|---|---|---|
| xm_release_id | int | NOT NULL, |
| release_name | nvarchar(255) | NOT NULL, |
| release_date | datetime | NOT NULL, |
| build | nvarchar(255) | NOT NULL, |
| active_status | smallint | NOT NULL, |
| change_timestamp | datetime | NULL, |
| CONSTRAINT PK601 PRIMARY KEY CLUSTERED (xm_release_id) ) | ||
| CREATE TABLE almt_duplicate_bob_info ( | ||
|---|---|---|
| bob_id | int | NOT NULL, |
| table_name | nvarchar(255) | NOT NULL, |
| load_file | nvarchar(255) | NOT NULL, |
| load_file_line | int | NOT NULL, |
| CONSTRAINT PK599 PRIMARY KEY CLUSTERED (bob_id, table_name) ) | ||
| CREATE TABLE almt_load_info ( | ||
|---|---|---|
| table_name | nvarchar(255) | NOT NULL, |
| absolute_file_path | nvarchar(255) | NOT NULL, |
| last_modified_time_millis | numeric(19, 0) | NOT NULL, |
| CONSTRAINT PK600 PRIMARY KEY CLUSTERED (table_name, absolute_file_path) ) | ||
These transaction tables are added in Infor Expense Management 10.2.6
| CREATE TABLE alco_import_line_item ( | ||
|---|---|---|
| import_line_item_id | int | NOT NULL, |
| import_external_id | nvarchar(255) | NOT NULL, |
| expense_category | nvarchar(255) | NOT NULL, |
| expense_type_id | int | NOT NULL, |
| payment_type_id | int | NOT NULL, |
| import_date | datetime | NOT NULL, |
| purchased_date | datetime | NOT NULL, |
| description | nvarchar(255) | NOT NULL, |
| native_amt_currency_code | nvarchar(255) | NOT NULL, |
| native_amt_currency_name | nvarchar(255) | NOT NULL, |
| native_amt_id | int | NOT NULL, |
| native_amt | numeric(28,10) | NOT NULL, |
| vat_amount_id | int | NOT NULL, |
| vat_amount | numeric(28,10) | NOT NULL, |
| vat_amt_currency_code | nvarchar(255) | NOT NULL, |
| purpose | nvarchar(255) | NOT NULL, |
| merchant_id | nvarchar(255) | NOT NULL, |
| vendor_code | nvarchar(255) | NOT NULL, |
| vendor_name | nvarchar(255) | NOT NULL, |
| location_code | nvarchar(255) | NOT NULL, |
| location_name | nvarchar(255) | NOT NULL, |
| city_code | nvarchar(255) | NOT NULL, |
| city_name | nvarchar(255) | NOT NULL, |
| state_code | nvarchar(255) | NOT NULL, |
| state_name | nvarchar(255) | NOT NULL, |
| country_code | nvarchar(255) | NOT NULL, |
| country_name | nvarchar(255) | NOT NULL, |
| import_status | nvarchar(255) | NOT NULL, |
| active_status | smallint | NOT NULL |
| user_id | int | NOT NULL, |
| raw_data | nvarchar(max) | NOT NULL, |
| line_item_id | int | NOT NULL, |
| document_tracking_number | nvarchar(255) | NOT NULL, |
|
CONSTRAINT PK602 PRIMARY KEY CLUSTERED ( import_line_item_id ) ) |
||
These transaction tables are added in Infor Expense Management 10.2.7
| CREATE TABLE alco_import_line_item_link ( | ||
|---|---|---|
| exp_line_item_id | int | NOT NULL, |
| import_line_item_link_id | int | NOT NULL |
| import_item_id | int | NOT NULL, |
| confirm | smallint | NOT NULL |
| tracking_num | nvarchar(255) | NOT NULL |
|
CONSTRAINT PK604 PRIMARY KEY CLUSTERED ( import_line_item_link_id ) ) |
||
These transaction tables are added in Infor Expense Management 10.2.9
| CREATE TABLE alco_itemize_import_line_item ( | ||
|---|---|---|
| itemize_import_id | int | NOT NULL |
| item_name | nvarchar(255) | NOT NULL |
| subtotal | numeric(28,10) | NOT NULL |
| subtotal_id | int | NOT NULL |
| item_date | datetime | NOT NULL |
| expense_category | nvarchar(255) | NOT NULL |
| expense_type_id | int | NOT NULL |
| change_timestamp | datetime | NOT NULL |
| import_line_item_id | int | NOT NULL |
|
CONSTRAINT PK605 PRIMARY KEY CLUSTERED ( itemize_import_id ) ) |
||
These transaction tables are added in Infor Expense Management 10.2.11
| CREATE TABLE alco_crypto_parameters ( | ||
|---|---|---|
| crypto_param_id | int | No |
| algorithm_name | nvarchar(255) | No |
| parm_name | nvarchar(255) | No |
| parm_value | nvarchar(255) | No |
| date_created | datetime | Yes |
| active_status | smallint | No |
| change_timestamp | datetime | Yes |
|
CONSTRAINT PK603 PRIMARY KEY CLUSTERED ( crypto_param_id ) ) |
||
These transaction tables are added in Infor Expense Management 10.2.13
| CREATE TABLE alco_xmdbtool_log ( | ||
|---|---|---|
| xmdbtool_log_id | int | NOT NULL |
| xmdbtool_tenant | nvarchar(255) | |
| xmdbtool_user | nvarchar(255) | |
| xmdbtool_command | nvarchar(255) | |
| xmdbtool_source | nvarchar(255) | |
| change_timestamp | datetime | |
|
CONSTRAINT PK606 PRIMARY KEY CLUSTERED ( xmdbtool_log_id ) ) |
||
| CREATE TABLE alco_io_document ( | ||
|---|---|---|
| name | nvarchar(255) | NOT NULL |
| outbound | smallint | DEFAULT 0 NOT NULL |
| inbound | smallint | DEFAULT 0 NOT NULL |
| active_status | smallint | DEFAULT 0 NOT NULL |
| etl_run_timestamp | datetime | NOT NULL |
|
CONSTRAINT PK607 PRIMARY KEY CLUSTERED ( name ) ) |
||
These transaction tables are added in Infor Expense Management 10.2.14
| CREATE TABLE alco_receipts_line_url ( | ||
|---|---|---|
| receipt_line_url_id | int | NOT NULL |
| document_id | nvarchar(255) | NOT NULL |
| line_id | int | NOT NULL |
| receipt_id | int | NOT NULL |
| url | nvarchar(510), | |
| flex_field_1 | nvarchar(255), | |
| flex_field_2 | int, | |
| status | int | NOT NULL, |
| active_status | int | NOT NULL, |
| change_timestamp | datetime, | |
|
CONSTRAINT PK552 PRIMARY KEY CLUSTERED ( receipt_line_url_id ) ) |
||
These transaction tables are added in Infor Expense Management 10.2.15
| CREATE TABLE alco_olt_receipt ( | ||
|---|---|---|
| olt_receipt_id | int | NOT NULL |
| receipt_name | nvarchar(255) | |
| user_id | int | |
| rec_receipt_id | int | |
| receipt_type | int | |
| change_timestamp | datetime | |
| active_status | smallint | NOT NULL |
| CONSTRAINT PK__olt_receipt_id PRIMARY KEY CLUSTERED ( olt_receipt_id ) ) | ||
| CREATE TABLE alco_olt_receipt_shell ( | ||
|---|---|---|
| olt_receipt_shell_id | int | NOT NULL |
| parent_id | int | NOT NULL |
| olt_receipt_id | int | NOT NULL |
| change_timestamp | datetime | |
| active_status | smallint | NOT NULL |
| CONSTRAINT PK__olt_receipt_shell_id PRIMARY KEY CLUSTERED (olt_receipt_shell_id) |
These transaction tables are added in Infor Expense Management 10.2.16
| CREATE TABLE alwf_wi_history_reviewers ( | ||
|---|---|---|
| reviewer_list_id | int | NOT NULL |
| wi_history_id | int | NOT NULL |
| user_id | int | |
| group_id | int | |
| reviewed | smallint | NOT NULL |
| review_date | datetime | |
| CONSTRAINT PK553 PRIMARY KEY CLUSTERED ( reviewer_list_id ) | ||
| ) |
| CREATE TABLE alco_datalake_deleted_bobs ( | ||
|---|---|---|
| deleted_bob_id | int | NOT NULL |
| bus_obj_id | int | NOT NULL |
| bus_obj_type_id | int | NOT NULL |
| bus_obj_date_created | datetime | NOT NULL |
| bus_obj_date_deleted | datetime | NOT NULL |
| change_timestamp | datetime DEFAULT current_timestamp | NOT NULL |
| CONSTRAINT PK554 PRIMARY KEY CLUSTERED ( deleted_bob_id ) | ||
| ) |
These transaction tables are added in Infor Expense Management 10.2.17
| CREATE TABLE alco_datalake_modified_docs ( | ||
|---|---|---|
| date_modified | datetime | NULL |
| document_id | nvarchar(255) | NULL |
| work_item_id | int | NULL |
| ) |
These transaction tables are added in Infor Expense Management 10.2.18
| CREATE TABLE alco_published_bobs ( | ||
|---|---|---|
| document_name | nvarchar (255) | NOT NULL |
| variation_id | bigint | NOT NULL |
| record_count | bigint | NOT NULL |
| start_date | datetime | NOT NULL |
| end_date | datetime | NOT NULL |
| change_timestamp | datetime | DEFAULT current_timestamp NOT NULL |
| is_datalake | smallint | NOT NULL |
| ) |
These transaction tables are added in Infor Expense Management 10.2.19
| CREATE TABLE alco_etl_table_modified ( | ||
|---|---|---|
| start_date | datetime | |
| end_date | datetime | |
| table_name | nvarchar(255) | NOT NULL |
| flag | int | |
| bob_id | int | NOT NULL |
| ) |
| CREATE TABLE alco_ocr_itemization_code ( | ||
|---|---|---|
| ocr_itemization_code_id | int | NOT NULL |
| code | int | NOT NULL |
| expense_type_id | int | NOT NULL |
| change_timestamp | datetime | |
| active_status | smallint | NOT NULL |
| CONSTRAINT PK569 PRIMARY KEY CLUSTERED ( ocr_itemization_code_id ) | ||
| ) |
| CREATE TABLE alco_vat_period ( | ||
|---|---|---|
| vat_period_id | int | NOT NULL |
| vat_account_id | int | NOT NULL |
| effective_date | datetime | |
| until_date | datetime | |
| CONSTRAINT PK570 PRIMARY KEY CLUSTERED ( vat_period_id ) | ||
| ) |
These transaction tables are added in Infor Expense Management 10.2.20
| CREATE TABLE alco_fx_rate_source ( | ||
|---|---|---|
| fx_rate_source_id | int | NOT NULL |
| source_name | nvarchar(50) | NOT NULL |
| base_currency_id | int | NOT NULL |
| active_status | smallint | NOT NULL |
| change_timestamp | datetime | |
| CONSTRAINT PK496 PRIMARY KEY CLUSTERED ( fx_rate_source_id ) | ||
| ) |