Version 10.2.2

Modifications in Expense Management 10.2.2

CREATE TABLE CREDIT_CARD_TRANSACTION (
CREDIT_CARD_TRANSACTION_ID	int	NOT NULL
CREDIT_CARD_ID	int
MERCHANT_NAME	nvarchar(255)
MERCHANT_CITY	nvarchar(255)
MERCHANT_STATE	nvarchar(255)
MERCHANT_COUNTRY	nvarchar(255)
MERCHANT_GIVEN_SIC_CODE	nvarchar(20)
MERCHANT_STD_SIC_CODE	nvarchar(20)
MERCHANT_VAT_NUMBER	nchar(20)
VENDOR_NAME	nvarchar(255)
TRANSACTION_REFERENCE	nvarchar(255)
TRANSACTION_TYPE	smallint
DUE_CC_CO_AMOUNT	numeric(28,10)
DUE_CC_CO_AMOUNT_CURRENCY	nchar(3)
POSTING_DATE	datetime
TRANSACTION_DATE	datetime
VAT_AMOUNT	numeric(28,10)
VAT_AMOUNT_CURRENCY	nchar(3)
TRANSACTION_AMOUNT	numeric(28,10)
TRANSACTION_AMOUNT_CURRENCY	nchar(3)
TRANSACTION_STATUS	int
IMPORT_DATE	datetime
DOCUMENT_ID	int
AIRLINE_DEPARTURE_DATE	datetime
AIRLINE_ROUTING	nvarchar(255)
AIRLINE_CLASS_OF_SERVICE	nvarchar(20)
AIRLINE_TRAVEL_AGENCY	nvarchar(45)
AIRLINE_TICKET_NUMBER	nvarchar(20)
CAR_RENTAL_AGREEMENT_NUMBER	nvarchar(30)
HOTEL_ARRIVAL_DATE	datetime
HOTEL_DEPARTURE_DATE	datetime
HOTEL_STAY_DURATION	int
HOTEL_FOLIO_REF_NUMBER	nvarchar(30)
HOTEL_ROOM_TYPE	nvarchar(30)
HOTEL_ROOM_AMOUNT	numeric(28,10)
HOTEL_CURRENCY	nchar(3)
HOTEL_ROOM_TAX_1	numeric(28,10)
HOTEL_ROOM_TAX_2	numeric(28,10)
HOTEL_PHONE_AMOUNT	numeric(28,10)
HOTEL_PHONE_TAX_1	numeric(28,10)
HOTEL_PHONE_TAX_2	numeric(28,10)
HOTEL_RESTAURANT_AMOUNT	numeric(28,10)
HOTEL_RESTAURANT_TAX_1	numeric(28,10)
HOTEL_RESTAURANT_TAX_2	numeric(28,10)
HOTEL_ROOM_SERVICE_AMOUNT	numeric(28,10)
HOTEL_ROOM_SERVICE_TAX_1	numeric(28,10)
HOTEL_ROOM_SERVICE_TAX_2	numeric(28,10)
HOTEL_TIP_AMOUNT_1	numeric(28,10)
HOTEL_TIP_AMOUNT_2	numeric(28,10)
HOTEL_OTHERS_AMOUNT	numeric(28,10)
HOTEL_OTHERS_TAX_1	numeric(28,10)
HOTEL_OTHERS_TAX_2	numeric(28,10)
HOTEL_ROOM_RATE	numeric(28,10)
HOTEL_ROOM_TAX_DAILY	numeric(28,10)
HOTEL_LAUNDRY_AMOUNT	numeric(28,10)
HOTEL_GIFT_SHOP_AMOUNT	numeric(28,10)
HOTEL_MOVIE_AMOUNT	numeric(28,10)
HOTEL_BUS_CENTER_AMOUNT	numeric(28,10)
HOTEL_HEALTH_CLUB_AMOUNT	numeric(28,10)
HOTEL_TOTAL_TAX	numeric(28,10)
ORIGIN_AIRPORT	nvarchar(10)
DESTINATION_AIRPORT	nvarchar(10)
CHANGE_TIMESTAMP	datetime
TRANSACTION_DESCRIPTION	nvarchar(255)
TRANSACTION_STATUS_INT	int
TRANSACTION_SEQUENCE_NUM	int
TRANSACTION_STATEMENT_DATE	datetime
CONSTRAINT PK30 PRIMARY KEY CLUSTERED ( CREDIT_CARD_TRANSACTION_ID )

CREATE TABLE EXPENSE_REPORT_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
PAYMENT_TYPE_ID	int
EXPENSE_TYPE_ID	int
VENDOR_NAME	nvarchar(255)
VENDOR_GIVEN_SIC_CODE	nvarchar(255)
VENDOR_CHAIN_CODE	nchar(20)
VENDOR_CREATOR_USER_ID	int
CREDIT_CARD_TRANSACTION_ID	int
LINE_ITEM_DATE	datetime
DESCRIPTION	nvarchar(255)
TRANSACTION_AMT	numeric(28,10)
TRANSACTION_AMT_CURRENCY	nchar(3)
PAID_IN_AMT	numeric(28,10)
PAID_IN_AMT_CURRENCY	nchar(3)
EXCHANGE_RATE	numeric(28,10)
PURPOSE	nvarchar(255)
PURPOSE_CREATOR_ID	int
MILES	numeric(15,5)
MILEAGE_RATE	float
GL_CODE	nchar(20)
APPROVED_AMT	numeric(28,10)
APPROVED_AMT_CURRENCY	nchar(3)
IS_OVERRIDDEN	smallint
HAS_RECEIPT	smallint
HAVE_RECEIPTS_BEEN_CHECKED	smallint
IS_APPROVED	smallint
LOCATION_ID	int
IS_PERSONAL	smallint
APPROVED_EXCHANGE_RATE	numeric(28,10)
DEPARTURE_DATE	datetime
ORIGIN_AIRPORT	nvarchar(10)
DESTINATION_AIRPORT	nvarchar(10)
BOOKING_AGENT_NAME	nvarchar(50)
TICKET_STATUS	nvarchar(255)
TICKET_NUMBER	nvarchar(50)
CAR_RENTAL_AGREEMENT	nvarchar(50)
AIRLINE_CLASS_OF_SERVICE_CODE	nvarchar(4)
AIRLINE_CLASS_OF_SERVICE	nvarchar(255)
CAR_CLASS_OF_SERVICE_CODE	nvarchar(4)
CAR_CLASS_OF_SERVICE	nvarchar(255)
HOTEL_CLASS_OF_SERVICE_CODE	nvarchar(4)
HOTEL_CLASS_OF_SERVICE	nvarchar(255)
BREAKFAST_DEDUCTION	smallint
LUNCH_DEDUCTION	smallint
DINNER_DEDUCTION	smallint
FIRST_DAY_DEDUCTION	smallint
LAST_DAY_DEDUCTION	smallint
OVERNIGHT_STAY_DEDUCTION	smallint
LONG_TERM_STAY_DEDUCTION	smallint
NUMBER_OF_GUESTS	int
ODOMETER_START	numeric(15,5)
ODOMETER_END	numeric(15,5)
PERDIEM_AMOUNT	numeric(28,10)
PERDIEM_AMOUNT_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
ITEMIZATION_PARENT_ID	int
ITEMIZATION_STATE	smallint	NOT NULL
MANUAL_FOLIO_ITEMIZATION	smallint
NUMBER_OF_PASSENGERS	int
FLEX_FIELD_STRING_1	nvarchar(255)
FLEX_FIELD_STRING_2	nvarchar(255)
FLEX_FIELD_STRING_3	nvarchar(255)
FLEX_FIELD_STRING_4	nvarchar(255)
FLEX_FIELD_INTEGER_1	int
FLEX_FIELD_INTEGER_2	int
FLEX_FIELD_DATE_1	datetime
FLEX_FIELD_DATE_2	datetime
FLEX_FIELD_AMOUNT_1	numeric(28,10)
FLEX_FIELD_AMOUNT_1_CURRENCY	nchar(3)
FLEX_FIELD_AMOUNT_2	numeric(28,10)
FLEX_FIELD_AMOUNT_2_CURRENCY	nchar(3)
FLEX_FIELD_LOCATION_1_ID	int
FLEX_FIELD_DDLB_1_CODE	nvarchar(255)
FLEX_FIELD_DDLB_2_CODE	nvarchar(255)
FLEX_FIELD_DDLB_3_CODE	nvarchar(255)
FLEX_FIELD_DDLB_4_CODE	nvarchar(255)
FLEX_FIELD_DDLB_5_CODE	nvarchar(255)
OPTIONAL_DEDUCTION_1	nvarchar(255)
OPTIONAL_DEDUCTION_2	nvarchar(255)
OPTIONAL_DEDUCTION_3	nvarchar(255)
OPTIONAL_DEDUCTION_4	nvarchar(255)
OPTIONAL_DEDUCTION_5	nvarchar(255)
RECURRING_ID	int
RECURRING_COUNT	int
MILEAGE_ROUTE_ID	int
GUEST_NO_SHOW_COUNT	int
PASSENGER_NAME	nvarchar(255)
AIRLINE_DOMESTIC_OR_INTL	int
COMMUTE_MILES	numeric(26,16)
CREATOR_CLIENT_TYPE	int
MILEAGE_RATE_DESCRIPTION	nvarchar(40)
CONSTRAINT PK7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )