Version 10.2.16

New tables in Expense Management 10.2.16

No new are added in Expense Management 10.2.16.

Modifications to tables in 10.2.16

These tables are modified in Expense Management 10.2.16. Newly added columns are highlighted.

CREATE TABLE HOTEL_FOLIO (
HOTEL_FOLIO_ID int NOT NULL
CREDIT_CARD_TRANSACTION_ID int
CHARGE_DATE datetime NOT NULL
NATIVE_AMOUNT numeric(28,10) NOT NULL
NATIVE_AMOUNT_CURRENCY nchar(3) NOT NULL
EXPENSE_TYPE_ID int NOT NULL
ITEM_CODE nvarchar(50)
CARD_TYPE int
ITEM_CODE_DESCRIPTION nvarchar(255)
CATEGORY_CODE nvarchar(32)
CATEGORY_CODE_DESCRIPTION nvarchar(255)
DESCRIPTION nvarchar(255)
SEQUENCE_NUMBER int
LEVEL3_IDENTIFIER nvarchar(255)
IS_UNATTACHED smallint NOT NULL
CHANGE_TIMESTAMP datetime
WORK_ITEM_ID int
)
Note: The NOT NULL columns have been removed from ITEM_CODE, CARD_TYPE, ITEM_CODE_DESCRIPTION.