Version 2023.01

Modified tables. The new columns are highlighted and the deleted columns are marked with the * symbol.

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)
END_DATE	datetime
EXPORT_STATUS	int
VOID_STATUS	int
REVERSAL_LINE_ITEM_ID	int
FLEX_FIELD_DDLB_1_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_2_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_3_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_4_VALUE	nvarchar(255)
FLEX_FIELD_DDLB_5_VALUE	nvarchar(255)
BILLING_PERIOD	int
ROUND_TRIP	smallint
CONSTRAINT PK7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )
)
go

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
EXPORT_STATUS	int
VOID_STATUS	int
REVERSAL_LINE_ITEM_ID	int
ROUND_TRIP	smallint
CONSTRAINT PK22 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )
)
go