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 ) ) |