Version 10.2.10

Modifications in Expense Management 10.2.10

CREATE TABLE TRAVEL_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
TRAVEL_EXPENSE_TYPE_ID	int	NOT NULL
COST_AMOUNT_CURRENCY	nchar(3)
COST_AMOUNT	numeric(28,10)
TAX_AMOUNT_CURRENCY	nchar(3)
TAX_AMOUNT	numeric(28,10)
PURPOSE	nvarchar(255)
PURPOSE_USER_ID	int
VENDOR_NAME	nvarchar(255)
VENDOR_USER_ID	int
FROM_LOCATION_ID	int
FROM_DATE	datetime
FROM_TIME	datetime
TO_LOCATION_ID	int
TO_DATE	datetime
TO_TIME	datetime
CLASS_OF_SERVICE	nvarchar(255)
DAILY_RATE_AMOUNT_CURRENCY	nchar(3)
DAILY_RATE_AMOUNT	numeric(28,10)
CUST_DEF_1	nvarchar(255)
CUST_DEF_2	nvarchar(255)
CUST_DEF_3	nvarchar(255)
DAILY_RATE_NATIVE_AMOUNT_CURR	nchar(3)
DAILY_RATE_NATIVE_AMOUNT	numeric(28,10)
EXCHANGE_RATE	numeric(28,10)
MILES	numeric(15,5)
REIMBURSE_RATE	float
AVERAGE_COST_AMOUNT_CURRENCY	nchar(3)
AVERAGE_COST_AMOUNT	numeric(28,10)
IS_IMPORTED	smallint
DESCRIPTION1	nvarchar(255)
DESCRIPTION2	nvarchar(255)
EXT_BOOKING_KEY	nvarchar(255)
EXCH_RATE_DEFAULT	numeric(28,10)
TRIP_TYPE	nchar(2)
FROM_AIRPORT_CODE	nchar(3)
TO_AIRPORT_CODE	nchar(3)
LOWEST_AIRFARE_AMT	numeric(28,10)
LOWEST_AIRFARE_AMT_CURRENCY	nchar(3)
LOWEST_HOTEL_RATE_AMT	numeric(28,10)
LOWEST_HOTEL_RATE_AMT_CURRENCY	nchar(3)
BOOKING_SOURCE	nchar(2)
AGENCY_NAME	nvarchar(255)
NUMBER_OF_GUESTS	int
CHANGE_TIMESTAMP	datetime
GUEST_NO_SHOW_COUNT	int
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK22 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE DOCUMENT_ACTIVITY (
ACTIVITY_ID	int	NOT NULL
DISPLAY_NAME	nvarchar(255)	NOT NULL
ACTIVITY_NUMBER	int
DESCRIPTION	nvarchar(255)
CHANGE_TIMESTAMP	datetime
INTERNAL_NAME	nvarchar(255)
ACTIVITY_VIEW	nvarchar(255)
CONSTRAINT PK3 PRIMARY KEY CLUSTERED ( ACTIVITY_ID ) )