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