Reporting Database Schema

These tables are added in the Reporting database schema.

Added in Expense Management 10.2

CREATE TABLE ER_FLEX_FIELD_LABELS(
FF_LABELS_ID	int,
STRING_1_LABEL	nvarchar(255),
STRING_2_LABEL	nvarchar(255),
STRING_3_LABEL	nvarchar(255),
STRING_4_LABEL	nvarchar(255),
INTEGER_1_LABEL	nvarchar(255),
INTEGER_2_LABEL	nvarchar(255),
DATE_1_LABEL	nvarchar(255),
DATE_2_LABEL	nvarchar(255),
AMOUNT_1_LABEL	nvarchar(255),
AMOUNT_2_LABEL	nvarchar(255),
LOCATION_1_LABEL	nvarchar(255),
DDLB_1_LABEL	nvarchar(255),
DDLB_2_LABEL	nvarchar(255),
DDLB_3_LABEL	nvarchar(255),
DDLB_4_LABEL	nvarchar(255),
DDLB_5_LABEL	nvarchar(255) )

CREATE TABLE ERLI_FLEX_FIELD_LABELS )
FF_LABELS_ID	int,
STRING_1_LABEL	nvarchar(255),
STRING_2_LABEL	nvarchar(255),
STRING_3_LABEL	nvarchar(255),
STRING_4_LABEL	nvarchar(255),
INTEGER_1_LABEL	nvarchar(255),
INTEGER_2_LABEL	nvarchar(255),
DATE_1_LABEL	nvarchar(255),
DATE_2_LABEL	nvarchar(255),
AMOUNT_1_LABEL	nvarchar(255),
AMOUNT_2_LABEL	nvarchar(255),
LOCATION_1_LABEL	nvarchar(255),
DDLB_1_LABEL	nvarchar(255),
DDLB_2_LABEL	nvarchar(255),
DDLB_3_LABEL	nvarchar(255),
DDLB_4_LABEL	nvarchar(255),
DDLB_5_LABEL	nvarchar(255) )

CREATE TABLE INVOICE_LINE_ITEM_VAT(
LINE_ITEM_ID	int	NOT NULL,
DOCUMENT_ID	int	NOT NULL,
ENVELOPE_ID	nvarchar(255)	NOT NULL,
ACCOUNTING_CALENDAR _NAME	nvarchar(255)	NULL,
SET_OF_BOOKS_NAME	nvarchar(255)	NULL,
VAT_ACCOUNT_NAME	nvarchar(255)	NULL,
VAT_ACCOUNT_ DESCRIPTION	nvarchar(255)	NULL,
TD_GL_ACCOUNT	nvarchar(255)	NULL,
TD_GL_SUBACCOUNT	nvarchar(255)	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
CONSTRAINT PK352_5 PRIMARY KEY (LINE_ITEM_ID) )

These tables are modified in Expense Management 10.2.0. The new columns are highlighted.

CREATE TABLE CREDIT_CARD_TRANSACTION(
CREDIT_CARD_ TRANSACTION_ID	int	NOT NULL,
CREDIT_CARD_ID	int	NULL,
MERCHANT_NAME	nvarchar(255)	NULL,
MERCHANT_CITY	nvarchar(255)	NULL,
MERCHANT_STATE	nvarchar(255)	NULL,
MERCHANT_COUNTRY	nvarchar(255)	NULL,
MERCHANT_GIVEN_SIC_ CODE	nvarchar(20)	NULL,
MERCHANT_STD_SIC_ CODE	nvarchar(20)	NULL,
MERCHANT_VAT_NUMBER	nchar(20)	NULL,
VENDOR_NAME	nvarchar(255)	NULL,
TRANSACTION_ REFERENCE	nvarchar(255)	NULL,
TRANSACTION_TYPE	smallint	NULL,
DUE_CC_CO_AMOUNT	numeric(20, 10)	NULL,
DUE_CC_CO_AMOUNT_ CURRENCY	nchar(3)	NULL,
POSTING_DATE	datetime	NULL,
TRANSACTION_DATE	datetime	NULL,
VAT_AMOUNT	numeric(20, 10)	NULL,
VAT_AMOUNT_CURRENCY	nchar(3)	NULL,
TRANSACTION_AMOUNT	numeric(20, 10)	NULL,
TRANSACTION_AMOUNT_ CURRENCY	nchar(3)	NULL,
TRANSACTION_STATUS	int	NULL,
IMPORT_DATE	datetime	NULL,
DOCUMENT_ID	int	NULL,
AIRLINE_DEPARTURE_ DATE	datetime	NULL,
AIRLINE_ROUTING	nvarchar(255)	NULL,
AIRLINE_CLASS_OF_ SERVICE	nvarchar(20)	NULL,
AIRLINE_TRAVEL_ AGENCY	nvarchar(45)	NULL,
AIRLINE_TICKET_NUMBER	nvarchar(20)	NULL,
CAR_RENTAL_ AGREEMENT_NUMBER	nvarchar(30)	NULL,
HOTEL_ARRIVAL_DATE	datetime	NULL,
HOTEL_DEPARTURE_ DATE	datetime	NULL,
HOTEL_STAY_DURATION	int	NULL,
HOTEL_FOLIO_REF_ NUMBER	nvarchar(30)	NULL,
HOTEL_ROOM_TYPE	nvarchar(30)	NULL,
HOTEL_ROOM_AMOUNT	numeric(20, 10)	NULL,
HOTEL_CURRENCY	nchar(3)	NULL,
HOTEL_ROOM_TAX_1	numeric(20, 10)	NULL,
HOTEL_ROOM_TAX_2	numeric(20, 10)	NULL,
HOTEL_PHONE_AMOUNT	numeric(20, 10)	NULL,
HOTEL_PHONE_TAX_1	numeric(20, 10)	NULL,
HOTEL_PHONE_TAX_2	numeric(20, 10)	NULL,
HOTEL_RESTAURANT_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_RESTAURANT_ TAX_1	numeric(20, 10)	NULL,
HOTEL_RESTAURANT_ TAX_2	numeric(20, 10)	NULL,
HOTEL_ROOM_SERVICE_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_ROOM_SERVICE_ TAX_1	numeric(20, 10)	NULL,
HOTEL_ROOM_SERVICE_ TAX_2	numeric(20, 10)	NULL,
HOTEL_TIP_AMOUNT_1	numeric(20, 10)	NULL,
HOTEL_TIP_AMOUNT_2	numeric(20, 10)	NULL,
HOTEL_OTHERS_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_OTHERS_TAX_1	numeric(20, 10)	NULL,
HOTEL_OTHERS_TAX_2	numeric(20, 10)	NULL,
HOTEL_ROOM_RATE	numeric(20, 10)	NULL,
HOTEL_ROOM_TAX_ DAILY	numeric(20, 10)	NULL,
HOTEL_LAUNDRY_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_GIFT_SHOP_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_MOVIE_AMOUNT	numeric(20, 10)	NULL,
HOTEL_BUS_CENTER_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_HEALTH_CLUB_ AMOUNT	numeric(20, 10)	NULL,
HOTEL_TOTAL_TAX	numeric(20, 10)	NULL,
ORIGIN_AIRPORT	nvarchar(10)	NULL,
DESTINATION_AIRPORT	nvarchar(10)	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
TRANSACTION_ DESCRIPTION	nvarchar(255)	NULL,
TRANSACTION_STATUS_ INT	int	NULL,
TRANSACTION_ SEQUENCE_ NUM	int	NULL,
TRANSACTION_ STATEMENT_DATE	datetime	NULL,
CONSTRAINT PK30 PRIMARY KEY (CREDIT_CARD_TRANSACTION_ID) )

CREATE TABLE EXPENSE_REPORT(
DOCUMENT_ID	int	NOT NULL,
TRACKING_NUMBER	nvarchar(255)	NOT NULL,
DOCUMENT_STATUS	nvarchar(255)	NULL,
CURRENT_ACTIVITY_ID	int	NOT NULL,
ENTERED_CURRENT_ ACTIVITY_DATE	datetime	NOT NULL,
ACTIVITY_OWNER_ID	int	NULL,
HAS_EXCEPTIONS	smallint	NULL,
HAS_OVERRIDES	smallint	NULL,
CREATE_DATE	datetime	NULL,
CREATOR_USER_ID	int	NULL,
OWNER_USER_ID	int	NULL,
AUDIT_INDICATOR	nvarchar(255)	NULL,
RECEIPTS_RECEIVED_ DATE	datetime	NULL,
TITLE	nvarchar(255)	NULL,
CASH_ADVANCE_AMT	numeric(20, 10)	NULL,
CASH_ADVANCE_AMT_ CURRENCY	nchar(3)	NULL,
COMPANY_CHARGES_ AMT	numeric(20, 10)	NULL,
COMPANY_CHARGES_ AMT_CURRENCY	nchar(3)	NULL,
DUE_EMPLOYEE_AMT	numeric(20, 10)	NULL,
DUE_EMPLOYEE_AMT_ CURRENCY	nchar(3)	NULL,
DUE_COMPANY_AMT	numeric(20, 10)	NULL,
DUE_COMPANY_AMT_ CURRENCY	nchar(3)	NULL,
TOTAL_AUTHORIZED_ AMT	numeric(20, 10)	NULL,
TOTAL_AUTHORIZED_ AMT_CURRENCY	nchar(3)	NULL,
TOTAL_EXPENSED_AMT	numeric(20, 10)	NULL,
TOTAL_EXPENSED_AMT_ CURRENCY	nchar(3)	NULL,
SUBMITTED_DATE	datetime	NULL,
APPROVED_DATE	datetime	NULL,
EXPENSE_FROM_DATE	datetime	NULL,
EXPENSE_TO_DATE	datetime	NULL,
IS_APPROVED	smallint	NULL,
PAID_AMT	numeric(20, 10)	NULL,
PAID_AMT_CURRENCY	nchar(3)	NULL,
PAID_DATE	datetime	NULL,
PAYMENT_NUMBER	nvarchar(255)	NULL,
PURPOSE_TEXT	nvarchar(255)	NULL,
PURPOSE_CREATOR_ID	int	NULL,
CORP_CHARGE_TOTAL_ AMT	numeric(20, 10)	NULL,
CORP_CHARGE_TOTAL_ AMT_CURRENCY	nchar(3)	NULL,
CORP_CHARGE_PAID_ AMT	numeric(20, 10)	NULL,
CORP_CHARGE_PAID_ AMT_CURRENCY	nchar(3)	NULL,
CORP_CHARGE_PAID_ DATE	datetime	NULL,
COMP_PAYS_CARDS_ AMT	numeric(20, 10)	NULL,
COMP_PAYS_CARDS_ AMT_CURRENCY	nchar(3)	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
CREATE_LOCATION_ID	int	NULL,
FLEX_FIELD_STRING_1	nvarchar(255)	NULL,
FLEX_FIELD_STRING_2	nvarchar(255)	NULL,
FLEX_FIELD_STRING_3	nvarchar(255)	NULL,
FLEX_FIELD_STRING_4	nvarchar(255)	NULL,
FLEX_FIELD_INTEGER_1	int	NULL,
FLEX_FIELD_INTEGER_2	int	NULL,
FLEX_FIELD_DATE_1	datetime	NULL,
FLEX_FIELD_DATE_2	datetime	NULL,
FLEX_FIELD_AMOUNT_1	numeric(20, 10)	NULL,
FLEX_FIELD_AMOUNT_1_ CURRENCY	nchar(3)	NULL,
FLEX_FIELD_AMOUNT_2	numeric(20, 10)	NULL,
FLEX_FIELD_AMOUNT_2 _CURRENCY	nchar(3)	NULL,
FLEX_FIELD_LOCATION_ 1_ID	int	NULL,
FLEX_FIELD_DDLB_1_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_2_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_3_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_4_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_5_ CODE	nvarchar(255)	NULL,
APPLIED_LCF	numeric(20, 10)	NULL,
APPLIED_LCF_CURRENCY	nchar(3)	NULL,
REMAINING_LCF	numeric(20, 10)	NULL,
REMAINING_LCF_ CURRENCY	nchar(3)	NULL,
GENERATED_LCF	numeric(20, 10)	NULL,
GENERATED_LCF_ CURRENCY	nchar(3)	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK6 PRIMARY KEY (DOCUMENT_ID) )

CREATE TABLE EXPENSE_REPORT_LINE_ITEM(
LINE_ITEM_ID	int	NOT NULL,
DOCUMENT_ID	int	NOT NULL,
PAYMENT_TYPE_ID	int	NULL,
EXPENSE_TYPE_ID	int	NULL,
VENDOR_NAME	nvarchar(255)	NULL,
VENDOR_GIVEN_SIC_ CODE	nvarchar(255)	NULL,
VENDOR_CHAIN_CODE	nchar(20)	NULL,
VENDOR_CREATOR_ USER_ID	int	NULL,
CREDIT_CARD_ TRANSACTION_ID	int	NULL,
LINE_ITEM_DATE	datetime	NULL,
DESCRIPTION	nvarchar(255)	NULL,
TRANSACTION_AMT	numeric(20, 10)	NULL,
TRANSACTION_AMT_ CURRENCY	nchar(3)	NULL,
PAID_IN_AMT	numeric(20, 10)	NULL,
PAID_IN_AMT_ CURRENCY	nchar(3)	NULL,
EXCHANGE_RATE	numeric(20, 10)	NULL,
PURPOSE	nvarchar(255)	NULL,
PURPOSE_CREATOR_ID	int	NULL,
MILES	numeric(15, 5)	NULL,
MILEAGE_RATE	float	NULL,
GL_CODE	nchar(20)	NULL,
APPROVED_AMT	numeric(20, 10)	NULL,
APPROVED_AMT_ CURRENCY	nchar(3)	NULL,
IS_OVERRIDDEN	smallint	NULL,
HAS_RECEIPT	smallint	NULL,
HAVE_RECEIPTS_ BEEN_CHECKED	smallint	NULL,
IS_APPROVED	smallint	NULL,
LOCATION_ID	int	NULL,
IS_PERSONAL	smallint	NULL,
APPROVED_EXCHANGE_ RATE	numeric(20, 10)	NULL,
DEPARTURE_DATE	datetime	NULL,
ORIGIN_AIRPORT	nvarchar(10)	NULL,
DESTINATION_AIRPORT	nvarchar(10)	NULL,
BOOKING_AGENT_NAME	nvarchar(50)	NULL,
TICKET_STATUS	nvarchar(255)	NULL,
TICKET_NUMBER	nvarchar(50)	NULL,
CAR_RENTAL_ AGREEMENT	nvarchar(50)	NULL,
AIRLINE_CLASS_OF_ SERVICE_CODE	nvarchar(4)	NULL,
AIRLINE_CLASS_OF_ SERVICE	nvarchar(255)	NULL,
CAR_CLASS_OF_ SERVICE_CODE	nvarchar(4)	NULL,
CAR_CLASS_OF_ SERVICE	nvarchar(255)	NULL,
HOTEL_CLASS_OF_ SERVICE_CODE	nvarchar(4)	NULL,
HOTEL_CLASS_OF_ SERVICE	nvarchar(255)	NULL,
BREAKFAST_DEDUCTION	smallint	NULL,
LUNCH_DEDUCTION	smallint	NULL,
DINNER_DEDUCTION	smallint	NULL,
FIRST_DAY_DEDUCTION	smallint	NULL,
LAST_DAY_DEDUCTION	smallint	NULL,
OVERNIGHT_STAY_ DEDUCTION	smallint	NULL,
LONG_TERM_STAY_ DEDUCTION	smallint	NULL,
NUMBER_OF_GUESTS	int	NULL,
ODOMETER_START	numeric(15, 5)	NULL,
ODOMETER_END	numeric(15, 5)	NULL,
PERDIEM_AMOUNT	numeric(20, 10)	NULL,
PERDIEM_AMOUNT_ CURRENCY	nchar(3)	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
ITEMIZATION_PARENT_ID	int	NULL,
ITEMIZATION_STATE	smallint	NOT NULL,
MANUAL_FOLIO_ ITEMIZATION	smallint	NULL,
NUMBER_OF_PASSENGERS	int	NULL,
FLEX_FIELD_STRING_1	nvarchar(255)	NULL,
FLEX_FIELD_STRING_2	nvarchar(255)	NULL,
FLEX_FIELD_STRING_3	nvarchar(255)	NULL,
FLEX_FIELD_STRING_4	nvarchar(255)	NULL,
FLEX_FIELD_INTEGER_1	int	NULL,
FLEX_FIELD_INTEGER_2	int	NULL,
FLEX_FIELD_DATE_1	datetime	NULL,
FLEX_FIELD_DATE_2	datetime	NULL,
FLEX_FIELD_AMOUNT_1	numeric(20, 10)	NULL,
FLEX_FIELD_AMOUNT_1 _CURRENCY	nchar(3)	NULL,
FLEX_FIELD_AMOUNT_2	numeric(20, 10)	NULL,
FLEX_FIELD_AMOUNT_2 _CURRENCY	nchar(3)	NULL,
FLEX_FIELD_LOCATION_ 1_ID	int	NULL,
FLEX_FIELD_DDLB_1_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_2_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_3_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_4_ CODE	nvarchar(255)	NULL,
FLEX_FIELD_DDLB_5_ CODE	nvarchar(255)	NULL,
OPTIONAL_DEDUCTION_ 1	nvarchar(255)	NULL,
OPTIONAL_DEDUCTION_ 2	nvarchar(255)	NULL,
OPTIONAL_DEDUCTION_ 3	nvarchar(255)	NULL,
OPTIONAL_DEDUCTION_ 4	nvarchar(255)	NULL,
OPTIONAL_DEDUCTION_ 5	nvarchar(255)	NULL,
RECURRING_ID	int	NULL,
RECURRING_COUNT	int	NULL,
MILEAGE_ROUTE_ID	int	NULL,
GUEST_NO_SHOW_ COUNT	int	NULL,
PASSENGER_NAME	nvarchar(255)	NULL,
AIRLINE_DOMESTIC_ OR_INTL	int	NULL,
COMMUTE_MILES	numeric(26, 16)	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK7 PRIMARY KEY (LINE_ITEM_ID) )

CREATE TABLE INVOICE_DOCUMENT(
DOCUMENT_ID	int	NOT NULL,
TRACKING_NUMBER	nvarchar(255)	NULL,
DOCUMENT_STATUS	nvarchar(255)	NULL,
CURRENT_ACTIVITY_ID	int	NOT NULL,
ENTERED_CURRENT_ ACTIVITY_DATE	datetime	NOT NULL,
ACTIVITY_OWNER_ID	int	NULL,
HAS_EXCEPTIONS	smallint	NOT NULL,
HAS_OVERRIDES	smallint	NOT NULL,
CREATE_DATE	datetime	NULL,
CREATOR_USER_ID	int	NULL,
OWNER_USER_ID	int	NULL,
AUDIT_INDICATOR	nvarchar(255)	NULL,
INVOICE_NUMBER	nvarchar(255)	NULL,
PURPOSE	nvarchar(255)	NULL,
PURPOSE_CREATOR_ID	int	NULL,
SUBMITTED_DATE	datetime	NULL,
APPROVED_DATE	datetime	NULL,
INVOICE_DATE	datetime	NULL,
INVOICE_DUE_DATE	datetime	NULL,
TOTAL_AMOUNT	numeric(20, 10)	NULL,
TOTAL_AMOUNT_ CURRENCY	nchar(3)	NULL,
TOTAL_CALCULATED_ AMOUNT	numeric(20, 10)	NULL,
TOTAL_CALCULATED_ AMT_CURRENCY	nchar(3)	NULL,
TOTAL_DISCOUNTED_ AMOUNT	numeric(20, 10)	NULL,
TOTAL_DISCOUNTED_ AMT_CURRENCY	nchar(3)	NULL,
IS_APPROVED	smallint	NULL,
PAID_DATE	datetime	NULL,
PAID_AMOUNT	numeric(20, 10)	NULL,
PAID_AMOUNT_ CURRENCY	nchar(3)	NULL,
PAYMENT_NUMBER	nvarchar(255)	NULL,
VENDOR_ID	int	NULL,
SEND_TO_ID	smallint	NULL,
DISCOUNT_PAY_BY _DATE	datetime	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
REQUESTED_PAYMENT_ DATE	datetime	NULL,
VOUCHER_NUMBER	nvarchar(255)	NULL,
SPECIAL_HANDLING	nvarchar(255)	NULL,
TITLE	nvarchar(255)	NULL,
VENDOR_ADDRESS_ID	int	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK5 PRIMARY KEY (DOCUMENT_ID) )

CREATE TABLE INVOICE_LINE_ITEM(
LINE_ITEM_ID	int	NOT NULL,
DOCUMENT_ID	int	NOT NULL,
ITEM_NUMBER	nvarchar(255)	NULL,
ITEM_DESCRIPTION	nvarchar(255)	NULL,
INVOICED_QUANTITY	Column type changed from int to numeric (15, 5)	NULL,
UNIT_OF_MEASURE_ CODE	nvarchar(255)	NULL,
UNIT_OF_MEASURE	nvarchar(255)	NULL,
UNIT_OF_MEASURE_ CREATOR_ID	int	NULL,
UNIT_PRICE	numeric(20, 10)	NULL,
UNIT_PRICE_CURRENCY	nchar(3)	NULL,
TOTAL_PRICE	numeric(20, 10)	NULL,
TOTAL_PRICE_ CURRENCY	nchar(3)	NULL,
CHECK_REQUEST_TYPE_ ID	int	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
NUMBER_OF_GUESTS	int	NULL,
GUEST_NO_SHOW_ COUNT	int	NULL,
INVOICE_DATE	datetime	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK11 PRIMARY KEY (LINE_ITEM_ID) )

CREATE TABLE MILEAGE_ROUTE (
MILEAGE_ROUTE_ID	int	NOT NULL,
ROUTE_NAME NOT	nvarchar(255)	NULL,
USER_ID	int	NOT NULL,
ROUTE_DETAIL	nvarchar(max)	NULL,
DISTANCE	numeric(15, 5)	NOT NULL,
CHANGE_TIMESTAMP	datetime	NULL,
FROM_ADDRESS_ID	int	NULL,
TO_ADDRESS_ID	int	NULL,
ACTIVE_STATUS	smallint	DEFAULT 1 NOT NULL,
ORIGINAL_ROUTE_ID	int	NULL,
BILLABLE	smallint	DEFAULT 0 NOT NULL,
CONSTRAINT PK_13 PRIMARY KEY (MILEAGE_ROUTE_ID) )

CREATE TABLE TIMESHEET_DOCUMENT(
DOCUMENT_ID	int	NOT NULL,
TRACKING_NUMBER	nvarchar(255)	NULL,
DOCUMENT_STATUS	nvarchar(255)	NULL,
CURRENT_ACTIVITY_ID	int	NULL,
ENTERED_CURRENT_ ACTIVITY_DATE	datetime	NULL,
ACTIVITY_OWNER_ID	int	NULL,
HAS_EXCEPTIONS	smallint	NOT NULL,
HAS_OVERRIDES	smallint	NOT NULL,
CREATE_DATE	datetime	NULL,
CREATOR_USER_ID	int	NULL,
OWNER_USER_ID	int	NULL,
AUDIT_INDICATOR	nvarchar(255)	NULL,
TITLE	nvarchar(255)	NULL,
PERIOD_START	datetime	NULL,
PERIOD_END	datetime	NULL,
SUBMITTED_DATE	datetime	NULL,
APPROVED_DATE	datetime	NULL,
TOTAL_HOURS	numeric(14, 4)	NULL,
WORK_SCHEDULE_ HOURS	numeric(14, 4)	NULL,
HOLIDAY_SCHEDULE	nvarchar(255)	NULL,
LABOR_STATUS	nvarchar(255)	NULL,
EMPLOYMENT_STATUS	nvarchar(255)	NULL,
BILLABLE_RATE	numeric(20, 10)	NULL,
BILLABLE_RATE_ CURRENCY	nchar(3)	NULL,
OVERTIME_HOURS	numeric(7, 2)	NULL,
DOUBLE_TIME_HOURS	numeric(7, 2)	NULL,
TRIPLE_TIME_HOURS	numeric(7, 2)	NULL,
REGULAR_HOURS	numeric(7, 2)	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
CREATE_LOCATION_ID	int	NULL,
JOB_CLASSIFICATION	nvarchar(100)	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK26 PRIMARY KEY (DOCUMENT_ID) )

CREATE TABLE TIMESHEET_LINE_ITEM(
LINE_ITEM_ID	int	NOT NULL,
DOCUMENT_ID	int	NULL,
IS_ATTENDANCE_LINE _ITEM	smallint	NOT NULL,
HOURS	numeric(14, 4)	NULL,
WORK_DATE	datetime	NULL,
START_TIME	datetime	NULL,
END_TIME	datetime	NULL,
COST_CENTER_ID	int	NULL,
PROJECT_NUMBER_ID	int	NULL,
PROJECT_ACTIVITY_ CODE	nvarchar(255)	NULL,
PROJECT_ACTIVITY_ NAME	nvarchar(255)	NULL,
APPROVED_HOURS	numeric(14, 4)	NULL,
HOURLY_CHARGE_TYPE	nchar(40)	NULL,
HOURLY_CHARGE_TYPE	nchar(40)	NULL,
CHARGE_TYPE	nvarchar(255)	NULL,
LOCATION_ID	int	NULL,
CHARGE_ROLE	nvarchar(255)	NULL,
APPROVED_HOURLY_ CHARGE_TYPE	nchar(40)	NULL,
BILLABLE_RATE	numeric(20, 10)	NULL,
BILLABLE_RATE_ CURRENCY	nchar(3)	NULL,
DESCRIPTION	nvarchar(255)	NULL,
ADJUSTED_HOURS	numeric(7, 2)	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
ATTD_IN1	datetime	NULL,
ATTD_OUT1	datetime	NULL,
ATTD_IN2	datetime	NULL,
ATTD_OUT2	datetime	NULL,
ATTD_IN3	datetime	NULL,
ATTD_OUT3	datetime	NULL,
ATTD_IN4	datetime	NULL,
ATTD_OUT4	datetime	NULL,
ATTD_IN5	datetime	NULL,
ATTD_OUT5	datetime	NULL,
ATTD_IN6	datetime	NULL,
ATTD_OUT6	datetime	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK27 PRIMARY KEY (LINE_ITEM_ID) )

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)	NULL,
COST_AMOUNT	numeric(20, 10)	NULL,
TAX_AMOUNT_ CURRENCY	nchar(3)	NULL,
TAX_AMOUNT	numeric(20, 10)	NULL,
PURPOSE	nvarchar(255)	NULL,
PURPOSE_USER_ID	int	NULL,
VENDOR_NAME	nvarchar(255)	NULL,
VENDOR_USER_ID	int	NULL,
FROM_LOCATION_ID	int	NULL,
FROM_DATE	datetime	NULL,
FROM_TIME	datetime	NULL,
TO_LOCATION_ID	int	NULL,
TO_DATE	datetime	NULL,
TO_TIME	datetime	NULL,
CLASS_OF_SERVICE	nvarchar(255)	NULL,
DAILY_RATE_AMOUNT_ CURRENCY	nchar(3)	NULL,
DAILY_RATE_AMOUNT	numeric(20, 10)	NULL,
CUST_DEF_1	nvarchar(255)	NULL,
CUST_DEF_2	nvarchar(255)	NULL,
CUST_DEF_3	nvarchar(255)	NULL,
DAILY_RATE_NATIVE_ AMOUNT_CURR	nchar(3)	NULL,
DAILY_RATE_NATIVE_ AMOUNT	numeric(20, 10)	NULL,
EXCHANGE_RATE	numeric(20, 10)	NULL,
MILES	numeric(15, 5)	NULL,
REIMBURSE_RATE	float	NULL,
AVERAGE_COST_ AMOUNT_CURRENCY	nchar(3)	NULL,
AVERAGE_COST_ AMOUNT	numeric(20, 10)	NULL,
IS_IMPORTED	smallint	NULL,
DESCRIPTION1	nvarchar(255)	NULL,
DESCRIPTION2	nvarchar(255)	NULL,
EXT_BOOKING_KEY	nvarchar(255)	NULL,
EXCH_RATE_DEFAULT	numeric(20, 10)	NULL,
TRIP_TYPE	nchar(2)	NULL,
FROM_AIRPORT_CODE	nchar(3)	NULL,
TO_AIRPORT_CODE	nchar(3)	NULL,
LOWEST_AIRFARE_AMT	numeric(20, 10)	NULL,
LOWEST_AIRFARE_AMT _CURRENCY	nchar(3)	NULL,
LOWEST_HOTEL_RATE_ AMT	numeric(20, 10)	NULL,
LOWEST_HOTEL_RATE_ AMT_CURRENCY	nchar(3)	NULL,
BOOKING_SOURCE	nchar(2)	NULL,
AGENCY_NAME	nvarchar(255)	NULL,
NUMBER_OF_GUESTS	int	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
GUEST_NO_SHOW_ COUNT	int	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK22 PRIMARY KEY (LINE_ITEM_ID) )

CREATE TABLE TRAVEL_PLAN(
DOCUMENT_ID	int	NOT NULL,
TRACKING_NUMBER	nvarchar(255)	NOT NULL,
DOCUMENT_STATUS	nvarchar(255)	NULL,
HAS_EXCEPTIONS	smallint	NULL,
HAS_OVERRIDES	smallint	NULL,
CURRENT_ACTIVITY_ID	int	NOT NULL,
CURRENT_ACTIVITY_ ENTRY_DATE	datetime	NOT NULL,
ACTIVITY_OWNER_ID	int	NULL,
CREATE_DATE	datetime	NULL,
SUBMITTED_DATE	datetime	NULL,
APPROVED_DATE	datetime	NULL,
FROM_DATE	datetime	NULL,
TO_DATE	datetime	NULL,
CREATOR_USER_ID	int	NULL,
OWNER_USER_ID	int	NULL,
TITLE	nvarchar(255)	NULL,
PURPOSE	nvarchar(255)	NULL,
PURPOSE_USER_ID	int	NULL,
NUMBER_GOING	int	NULL,
AIR_AMOUNT_CURRENCY	nchar(3)	NULL,
AIR_AMOUNT	numeric(20, 10)	NULL,
HOTEL_AMOUNT_ CURRENCY	nchar(3)	NULL,
HOTEL_AMOUNT	numeric(20, 10)	NULL,
HOTEL_TAX_AMOUNT_ CURRENCY	nchar(3)	NULL,
HOTEL_TAX_AMOUNT	numeric(20, 10)	NULL,
CAR_AMOUNT_ CURRENCY	nchar(3)	NULL,
CAR_AMOUNT	numeric(20, 10)	NULL,
CAR_TAX_AMOUNT_ CURRENCY	nchar(3)	NULL,
CAR_TAX_AMOUNT	numeric(20, 10)	NULL,
MEALS_AMOUNT_ CURRENCY	nchar(3)	NULL,
MEALS_AMOUNT	numeric(20, 10)	NULL,
OTHER_AMOUNT_ CURRENCY	nchar(3)	NULL,
OTHER_AMOUNT	numeric(20, 10)	NULL,
TOTAL_AMOUNT_ CURRENCY	nchar(3)	NULL,
TOTAL_AMOUNT	numeric(20, 10)	NULL,
EMPLOYEE_COMPANY	nvarchar(255)	NULL,
EMPLOYEE_DEPARTMENT	nvarchar(255)	NULL,
TRIP_TYPE	nvarchar(255)	NULL,
ORD_KEY	nvarchar(255)	NULL,
INTEGRATION_PARTNER _NAME	nvarchar(255)	NULL,
MAX_AIR_TICKET_ AMOUNT_CURRENCY	nchar(3)	NULL,
MAX_AIR_TICKET_ AMOUNT	numeric(20, 10)	NULL,
ITINERARY_STATE	int	NULL,
CHANGE_TIMESTAMP	datetime	NULL,
CREATE_LOCATION_ID	int	NULL,
CREATOR_CLIENT_TYPE	int	NULL,
CONSTRAINT PK23 PRIMARY KEY (DOCUMENT_ID) )

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

Modifications in Expense Management 10.2.3

CREATE TABLE ALLOCATION (
LINE_ITEM_ID	int
LINE_ITEM_ID_TYPE	int
PERCENT_ALLOTTED	float
PAID_IN_AMOUNT_CURRENCY	nchar(3)
PAID_IN_AMOUNT	numeric(28,10)
TRANSACTION_AMOUNT_CURRENCY	nchar(3)
TRANSACTION_AMOUNT	numeric(28,10)
IS_APPROVED	smallint
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
IS_BILLABLE	smallint
CHANGE_TIMESTAMP	datetime
ALLOCATION_DATE	datetime )

CREATE TABLE BUDGET_LINE_HISTORY (
HISTORY_ID	int	NOT NULL
DOCUMENT_TYPE	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
BUDGET_ID	int	NOT NULL
BUDGET_LINE_ID	int	NOT NULL
AMOUNT	numeric(28,10)	NOT NULL
AMOUNT_CURRENCY	nchar(3)	NOT NULL
ACTION	nvarchar(255)	NOT NULL
RELEASED	smallint
CHANGE_TIMESTAMP	datetime
FROM_DATE	datetime
CONSTRAINT PK563_1 PRIMARY KEY CLUSTERED ( HISTORY_ID )

CREATE TABLE BUDGET_LINE_ITEM (
BUDGET_LINE_ID	int	NOT NULL
BUDGET_ID	int	NOT NULL
BUDGET_ACCOUNT_ID	int	NOT NULL
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
BUDGETED_AMT	numeric(28,10)	NOT NULL
BUDGETED_AMT_CURRENCY	nchar(3)	NOT NULL
ADJUSTED_AMT	numeric(28,10)	NOT NULL
ADJUSTED_AMT_CURRENCY	nchar(3)	NOT NULL
ALLOCATED_AMT	numeric(28,10)	NOT NULL
ALLOCATED_AMT_CURRENCY	nchar(3)	NOT NULL
COMMITTED_AMT	numeric(28,10)	NOT NULL
COMMITTED_AMT_CURRENCY	nchar(3)	NOT NULL
IS_ACTIVE	smallint	NOT NULL
CHANGE_TIMESTAMP	datetime
FROM_DATE	datetime
CONSTRAINT PK562_1 PRIMARY KEY CLUSTERED ( BUDGET_LINE_ID )

CREATE TABLE CREDIT_CARD (
CREDIT_CARD_ID	int	NOT NULL
PROCESSOR_NAME	nvarchar(255)
PAYMENT_TYPE_ID	int
USER_ID	int
ACCOUNT_NUMBER	nvarchar(255)
NAME_LINE_1	nvarchar(255)
NAME_LINE_2	nvarchar(255)
ADDRESS_LINE_1	nvarchar(255)
ADDRESS_LINE_2	nvarchar(255)
IS_PAID_BY_COMPANY	smallint
SPENDING_LIMIT_AMOUNT_CURRENCY	nchar(3)
SPENDING_LIMIT_AMOUNT	numeric(28,10)
CARD_ISSUER	nvarchar(255)
IS_CARD_ACTIVE	smallint
DEACTIVATION_DATE	datetime
IS_PR_CARD	smallint
PR_PAYMENT_TYPE	nvarchar(255)
CARD_TYPE	nvarchar(255)
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
GLCODE	nvarchar(255)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK29 PRIMARY KEY CLUSTERED ( CREDIT_CARD_ID ) )

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 CURRENCY_EXCHANGE_RATE (
FX_RATE_ID	int	NOT NULL
FROM_CURRENCY_CODE	nchar(3)	NOT NULL
TO_CURRENCY_CODE	nchar(3)	NOT NULL
FROM_VALID_DATE	datetime	NOT NULL
TO_VALID_DATE	datetime
FX_RATE	numeric(28,10)	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK31_1 PRIMARY KEY CLUSTERED ( FX_RATE_ID ) )

CREATE TABLE ER_LINE_ITEM_ADJUSTMENT (
LINE_ITEM_ID	int
SEQUENCE_NUMBER	int	NOT NULL
CHANGE_DATE	datetime
CHANGE_AMOUNT	numeric(28,10)
CHANGE_AMOUNT_ISO	nchar(3)
NEW_BALANCE_AMOUNT	numeric(28,10)
NEW_BALANCE_AMOUNT_ISO	nchar(3)
ADJUSTER_ID	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int
)

CREATE TABLE ER_TR_ITEM_LINK (
LINE_ITEM_ID	int	NOT NULL
TR_TRACKING_NUM	nvarchar(255)
PREAPPROVED_AMT_CURRENCY	nchar(3)
PREAPPROVED_AMT	numeric(28,10)
LINE_ITEM_DATE	datetime
CONSTRAINT PK597_1 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE EXPENSE_REPORT (
DOCUMENT_ID	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)	NOT NULL
DOCUMENT_STATUS	nvarchar(255)
CURRENT_ACTIVITY_ID	int	NOT NULL
ENTERED_CURRENT_ACTIVITY_DATE	datetime	NOT NULL
ACTIVITY_OWNER_ID	int
HAS_EXCEPTIONS	smallint
HAS_OVERRIDES	smallint
CREATE_DATE	datetime
CREATOR_USER_ID	int
OWNER_USER_ID	int
AUDIT_INDICATOR	nvarchar(255)
RECEIPTS_RECEIVED_DATE	datetime
TITLE	nvarchar(255)
CASH_ADVANCE_AMT	numeric(28,10)
CASH_ADVANCE_AMT_CURRENCY	nchar(3)
COMPANY_CHARGES_AMT	numeric(28,10)
COMPANY_CHARGES_AMT_CURRENCY	nchar(3)
DUE_EMPLOYEE_AMT	numeric(28,10)
DUE_EMPLOYEE_AMT_CURRENCY	nchar(3)
DUE_COMPANY_AMT	numeric(28,10)
DUE_COMPANY_AMT_CURRENCY	nchar(3)
TOTAL_AUTHORIZED_AMT	numeric(28,10)
TOTAL_AUTHORIZED_AMT_CURRENCY	nchar(3)
TOTAL_EXPENSED_AMT	numeric(28,10)
TOTAL_EXPENSED_AMT_CURRENCY	nchar(3)
SUBMITTED_DATE	datetime
APPROVED_DATE	datetime
EXPENSE_FROM_DATE	datetime
EXPENSE_TO_DATE	datetime
IS_APPROVED	smallint
PAID_AMT	numeric(28,10)
PAID_AMT_CURRENCY	nchar(3)
PAID_DATE	datetime
PAYMENT_NUMBER	nvarchar(255)
PURPOSE_TEXT	nvarchar(255)
PURPOSE_CREATOR_ID	int
CORP_CHARGE_TOTAL_AMT	numeric(28,10)
CORP_CHARGE_TOTAL_AMT_CURRENCY	nchar(3)
CORP_CHARGE_PAID_AMT	numeric(28,10)
CORP_CHARGE_PAID_AMT_CURRENCY	nchar(3)
CORP_CHARGE_PAID_DATE	datetime
COMP_PAYS_CARDS_AMT	numeric(28,10)
COMP_PAYS_CARDS_AMT_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CREATE_LOCATION_ID	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)
APPLIED_LCF	numeric(28,10)	Null
APPLIED_LCF_CURRENCY	nchar(3)	Null
REMAINING_LCF	numeric(28,10)	Null
REMAINING_LCF_CURRENCY	nchar(3)	Null
GENERATED_LCF	numeric(28,10)	Null
GENERATED_LCF_CURRENCY	nchar(3)	Null
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK6 PRIMARY KEY CLUSTERED ( DOCUMENT_ID ) )

CREATE TABLE EXPENSE_REPORT_ADC (
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35 PRIMARY KEY CLUSTERED ( DOCUMENT_ID ) )

CREATE TABLE EXPENSE_REPORT_DEDUCTION_LINE (
LINE_ITEM_ID	int	NOT NULL
PERDIEM_DEDUCTION	numeric(28,10)
PERDIEM_DEDUCTION_CURRENCY	nchar(3)
DEDUCTION_TYPES	int
PRIVATE_NIGHTSTAY_ADDRESS	nvarchar(255)
START_TIME	datetime
END_TIME	datetime
MEAL_AMOUNT	numeric(28,10)
MEAL_AMOUNT_CURRENCY	nchar(3)
DURATION_OF_STAY	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int	NOT NULL
)

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
CONSTRAINT PK7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE EXPENSE_REPORT_LINE_ITEM_ADC (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK352 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE EXPENSE_REPORT_LINE_ITEM_VAT (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ACCOUNTING_CALENDAR_NAME	nvarchar(255)
SET_OF_BOOKS_NAME	nvarchar(255)
VAT_ACCOUNT_NAME	nvarchar(255)
VAT_ACCOUNT_DESCRIPTION	nvarchar(255)
VATD_GL_ACCOUNT	nvarchar(255)
VATD_GL_SUBACCOUNT	nvarchar(255)
TD_GL_ACCOUNT	nvarchar(255)
TD_GL_SUBACCOUNT	nvarchar(255)
NTD_GL_ACCOUNT	nvarchar(255)
NTD_GL_SUBACCOUNT	nvarchar(255)
CLAIMED_PERCENT	float
DEDUCTIBLE_PERCENTAGE	float
TD_AMOUNT	numeric(28,10)
TD_AMOUNT_CURRENCY	nchar(3)
NTD_AMOUNT	numeric(28,10)
NTD_AMOUNT_CURRENCY	nchar(3)
VAT_AMOUNT	numeric(28,10)
VAT_AMOUNT_CURRENCY	nchar(3)
OVERRIDDEN_VAT_AMOUNT	numeric(28,10)
OVERRIDDEN_VAT_AMOUNT_CURRENCY	nchar(3)
OVERRIDDEN_VAT_MILES	numeric(15,5)
OVERRIDDEN_VAT_GUESTS	int
CHANGE_TIMESTAMP	datetime
VAT_UNCLAIMED_GL_ACCOUNT	nvarchar(255)
VAT_UNCLAIMED_GL_SUBACCOUNT	nvarchar(255)
PST_GL_ACCOUNT	nvarchar(255)
PST_GL_SUBACCOUNT	nvarchar(255)
PST_UNCLAIMED_GL_ACCOUNT	nvarchar(255)
PST_UNCLAIMED_GL_SUBACCOUNT	nvarchar(255)
VAT_PERCENT	float
PST_PERCENT	float
PST_CLAIMED_PERCENT	float
VAT_UNCLAIMED_AMOUNT	numeric(28,10)
VAT_UNCLAIMED_AMOUNT_CURRENCY	nchar(3)
PST_AMOUNT	numeric(28,10)
PST_AMOUNT_CURRENCY	nchar(3)
PST_UNCLAIMED_AMOUNT	numeric(28,10)
PST_UNCLAIMED_AMOUNT_CURRENCY	nchar(3)
OVERRIDDEN_PST_AMOUNT	numeric(28,10)
OVERRIDDEN_PST_AMOUNT_CURRENCY	nchar(3)
INCLUDE_GST_IN_PST	int
TAX_DEDUCTION_METHOD	int
LINE_ITEM_DATE	datetime
CONSTRAINT PK34 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE EXPENSE_REPORT_OVERAGE (
OVERAGE_ID	int	NOT NULL
DOCUMENT_ID	int
OVERAGE_DATE	datetime
TOTAL_ACTUAL_AMOUNT	numeric(28,10)
TOTAL_ACTUAL_CURRENCY	nchar(3)
TOTAL_PERDIEM_AMOUNT	numeric(28,10)
TOTAL_PERDIEM_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
OVERAGE_LEVEL	smallint
TOTAL_OVERAGE_AMOUNT	numeric(28,10)
TOTAL_OVERAGE_CURRENCY	nchar(3)
PERDIEM_EXPENSE_TYPE	int
OVERAGE_GROUP_NAME	nvarchar(255)
OVERAGE_GROUP_DESCRIPTION	nvarchar(255)
GL_ACCOUNT	nvarchar(255)
CONSTRAINT PK49 PRIMARY KEY CLUSTERED ( OVERAGE_ID ) )

CREATE TABLE EXT_USER (
USER_ID	int	NOT NULL
FULL_NAME	nvarchar(255)	NOT NULL
FIRST_NAME	nvarchar(255)
MIDDLE_INITIAL	nchar(1)
LAST_NAME	nvarchar(255)
EMPLOYEE_NUMBER	nvarchar(255)
LOGIN	nvarchar(255)
TITLE	nvarchar(255)
IS_ACTIVE	smallint
TAXPAYER_ID	nvarchar(255)
DEFAULT_COST_CENTER_ID	int
LCF_TOTAL_AMT_CUR	nchar(3)
LCF_TOTAL_AMT	numeric(28,10)
COUNTRY_NAME	nvarchar(255)
COUNTRY_ISO_CODE	nchar(2)
BOSS_ID	int
OFFICE_NAME	nvarchar(255)
LOCATION_ID	int
SET_OF_BOOKS_NAME	nvarchar(255)
AUTH_AMT	numeric(28,10)
AUTH_AMT_CUR	nchar(3)
PR_AUTH_AMT	numeric(28,10)
PR_AUTH_AMT_CUR	nchar(3)
SYSTEM_CODE_1	nvarchar(255)
SYSTEM_CODE_2	nvarchar(255)
SYSTEM_CODE_3	nvarchar(255)
SYSTEM_CODE_4	nvarchar(255)
SYSTEM_CODE_5	nvarchar(255)
SYSTEM_CODE_6	nvarchar(255)
SYSTEM_CODE_7	nvarchar(255)
SYSTEM_CODE_8	nvarchar(255)
SYSTEM_DATE_1	datetime
SYSTEM_DATE_2	datetime
CHANGE_TIMESTAMP	datetime
EMAIL_ADDRESS	nvarchar(255)
DEFAULT_CURRENCY	nchar(3)
CREATION_TIME	datetime
LAST_MODIFIED_TIME	datetime
PAYROLL_SYSTEM_CODE	nvarchar(255)
ER_DEFAULT_PROJECT_ID	int
PROXY_CAN_SUBMIT	smallint
PROXY_REVIEWER_CAN_SUBMIT	smallint
SECOND_CURRENCY	nchar(3)
START_DATE	datetime
END_DATE	datetime
USER_MAILSTOP	nvarchar(255)
IDENTITY2	nvarchar(36)
CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID ) )

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
ITEM_CODE	nvarchar(50)	NOT NULL
CARD_TYPE	int	NOT NULL
ITEM_CODE_DESCRIPTION	nvarchar(255)	NOT NULL
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 )

CREATE TABLE INVOICE_DOCUMENT (
DOCUMENT_ID	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)
DOCUMENT_STATUS	nvarchar(255)
CURRENT_ACTIVITY_ID	int	NOT NULL
ENTERED_CURRENT_ACTIVITY_DATE	datetime	NOT NULL
ACTIVITY_OWNER_ID	int
HAS_EXCEPTIONS	smallint	NOT NULL
HAS_OVERRIDES	smallint	NOT NULL
CREATE_DATE	datetime
CREATOR_USER_ID	int
OWNER_USER_ID	int
AUDIT_INDICATOR	nvarchar(255)
INVOICE_NUMBER	nvarchar(255)
PURPOSE	nvarchar(255)
PURPOSE_CREATOR_ID	int
SUBMITTED_DATE	datetime
APPROVED_DATE	datetime
INVOICE_DATE	datetime
INVOICE_DUE_DATE	datetime
TOTAL_AMOUNT	numeric(28,10)
TOTAL_AMOUNT_CURRENCY	nchar(3)
TOTAL_CALCULATED_AMOUNT	numeric(28,10)
TOTAL_CALCULATED_AMT_CURRENCY	nchar(3)
TOTAL_DISCOUNTED_AMOUNT	numeric(28,10)
TOTAL_DISCOUNTED_AMT_CURRENCY	nchar(3)
IS_APPROVED	smallint
PAID_DATE	datetime
PAID_AMOUNT	numeric(28,10)
PAID_AMOUNT_CURRENCY	nchar(3)
PAYMENT_NUMBER	nvarchar(255)
VENDOR_ID	int
SEND_TO_ID	smallint
DISCOUNT_PAY_BY_DATE	datetime
CHANGE_TIMESTAMP	datetime
REQUESTED_PAYMENT_DATE	datetime
VOUCHER_NUMBER	nvarchar(255)
SPECIAL_HANDLING	nvarchar(255)
TITLE	nvarchar(255)
VENDOR_ADDRESS_ID	int
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK5 PRIMARY KEY CLUSTERED ( DOCUMENT_ID ) )

CREATE TABLE INVOICE_DOCUMENT_ADC (
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_1 PRIMARY KEY CLUSTERED ( DOCUMENT_ID ) )

CREATE TABLE INVOICE_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ITEM_NUMBER	nvarchar(255)
ITEM_DESCRIPTION	nvarchar(255)
INVOICED_QUANTITY	int
UNIT_OF_MEASURE_CODE	nvarchar(255)
UNIT_OF_MEASURE	nvarchar(255)
UNIT_OF_MEASURE_CREATOR_ID	int
UNIT_PRICE	numeric(28,10)
UNIT_PRICE_CURRENCY	nchar(3)
TOTAL_PRICE	numeric(28,10)
TOTAL_PRICE_CURRENCY	nchar(3)
CHECK_REQUEST_TYPE_ID	int
CHANGE_TIMESTAMP	datetime
NUMBER_OF_GUESTS	int
GUEST_NO_SHOW_COUNT	int
INVOICE_DATE	datetime
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK11 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE INVOICE_LINE_ITEM_ADC (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK352_1 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE LINE_ITEM_GUEST (
LINE_ITEM_GUEST_ID	int	NOT NULL
LINE_ITEM_ID	int	NOT NULL
LINE_ITEM_ID_TYPE	nchar(10)
USER_ID	int
SELF_ID	int
LOCATION_ID	int
EXTERNAL_ID	nvarchar(255)
FIRST_NAME	nvarchar(255)
LAST_NAME	nvarchar(255)
EXTERNAL_FLAG	smallint
COMPANY	nvarchar(255)
TITLE	nvarchar(255)
ADC1	nvarchar(255)
ADC2	nvarchar(255)
ADC3	nvarchar(255)
ADC4	nvarchar(255)
ADC5	nvarchar(255)
ADC6	nvarchar(255)
CHANGE_TIMESTAMP	datetime
GUEST_ID	int	NOT NULL
PRIMARY_ADDRESS_ID	int
OCCUPATION_NAME	nvarchar(255)
OCCUPATION_CODE	nvarchar(255)
NATIVE_AMOUNT	numeric(28,10)
NATIVE_AMOUNT_CURRENCY	nchar(3)
PAID_IN_AMOUNT	numeric(28,10)
PAID_IN_AMOUNT_CURRENCY	nchar(3)
LINE_ITEM_GUEST_ADC1	nvarchar(255)
LINE_ITEM_GUEST_ADC2	nvarchar(255)
LINE_ITEM_GUEST_ADC3	nvarchar(255)
LINE_ITEM_GUEST_ADC4	nvarchar(255)
LINE_ITEM_GUEST_ADC5	nvarchar(255)
LINE_ITEM_GUEST_ADC6	nvarchar(255)
DOCUMENT_ID	int	NOT NULL
CONSTRAINT PK352_2 PRIMARY KEY CLUSTERED ( LINE_ITEM_GUEST_ID )

CREATE TABLE PR_VENDOR (
VENDOR_ID	int	NOT NULL
CREATOR_ID	int
NAME	nvarchar(255)
SUPPORTS_PCARD	smallint
TERM_NAME	nvarchar(255)
TERM_DAYS	int
DISCOUNT_AMOUNT_TYPE	smallint
DISCOUNT_AMOUNT_PERCENTAGE	numeric(20,10)
DISCOUNT_AMOUNT	numeric(28,10)
DISCOUNT_AMOUNT_CURRENCY	nchar(3)
DISCOUNT_TERM_DAYS	int
CHANGE_TIMESTAMP	datetime
	nvarchar(255) EXTERNAL_VENDOR_ID
IS_TAXABLE	smallint	DEFAULT 0 NOT NULL
TAX_CODE	nvarchar(255)
TAX_ID	nvarchar(255)
IS_ONE_TIME_ONLY	smallint	DEFAULT 0 NOT NULL
SYSTEM_CODE_1	nvarchar(255)
SYSTEM_CODE_2	nvarchar(255)
SYSTEM_CODE_3	nvarchar(255)
SYSTEM_CODE_4	nvarchar(255)
SYSTEM_CODE_5	nvarchar(255)
SYSTEM_CODE_6	nvarchar(255)
SYSTEM_CODE_7	nvarchar(255)
SYSTEM_CODE_8	nvarchar(255)
CONSTRAINT PK15 PRIMARY KEY CLUSTERED ( VENDOR_ID )

CREATE TABLE PURCHASE_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
PAYMENT_TYPE	nvarchar(255)
BILL_METHOD	nvarchar(255)
BILL_METHOD_CODE	int
IS_CAPITAL_EXPENDITURE	smallint
REQUESTED_QUANTITY	int
APPROVED_QUANTITY	int
IS_TAXABLE	smallint
PURCHASE_TYPE_ID	int
ITEM_DESCRIPTION	nvarchar(255)
UNIT_OF_MEASURE_CODE	nvarchar(255)
UNIT_OF_MEASURE	nvarchar(255)
UNIT_OF_MEASURE_CREATOR_ID	int
UNIT_PRICE	numeric(28,10)
UNIT_PRICE_CURRENCY	nchar(3)
TOTAL_PRICE	numeric(28,10)
TOTAL_PRICE_CURRENCY	nchar(3)
VENDOR_ID	int
VENDOR_ADDRESS_ID	int
DELIVER_BY_DATE	datetime
MANUFACTURER_NAME	nvarchar(255)
MANUFACTURER_CREATOR_ID	int
VENDOR_ITEM_NUMBER	nvarchar(255)
WAS_IMPORTED_FROM_TEMPLATE	smallint
MANAGER	nvarchar(255)
ROOM_NUMBER	nvarchar(255)
SERVICE_START_DATE	datetime
SERVICE_STOP_DATE	datetime
VENDOR_PROMISED_DATE	datetime
PURCHASE_ORDER_NUMBER	nvarchar(255)
CHANGE_TIMESTAMP	datetime
EXTERNAL_KEY	nvarchar(255)
ACTIVE_STATUS	smallint
CONSTRAINT PK17 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE PURCHASE_LINE_ITEM_ADC (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5 datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_3 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )

CREATE TABLE PURCHASE_REQUISITION (
DOCUMENT_ID	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)	NOT NULL
DOCUMENT_STATUS	nvarchar(255)
CURRENT_ACTIVITY_ID	int	NOT NULL
ENTERED_CURRENT_ACTIVITY_DATE	datetime	NOT NULL
ACTIVITY_OWNER_ID	int
HAS_EXCEPTIONS	smallint
HAS_OVERRIDES	smallint
CREATE_DATE	datetime
CREATOR_USER_ID	int
OWNER_USER_ID	int
AUDIT_INDICATOR	nvarchar(255)
TITLE	nvarchar(255)
PURPOSE	nvarchar(255)
PURPOSE_CREATOR_ID	int
SUBMITTED_DATE	datetime
APPROVED_DATE	datetime
TAX_AMOUNT	numeric(28,10)
TAX_AMOUNT_CURRENCY	nchar(3)
SHIPPING_AMOUNT	numeric(28,10)
SHIPPING_AMOUNT_CURRENCY	nchar(3)
TOTAL_AMOUNT	numeric(28,10)
TOTAL_AMOUNT_CURRENCY	nchar(3)
IS_SOURCING_REQUEST	smallint
SHIP_TO_ADDRESS_ID	int
SHIP_METHOD	nvarchar(255)
SHIP_METHOD_CREATOR_ID	int
TRANSPORT_MODE_CODE	nvarchar(70)
TRANSPORT_MEAN_CODE	nvarchar(70)
TRANSPORT_CARRIER	nvarchar(70)
ALLOW_PARTIAL_SHIPMENT	smallint
MANUALLY_ENTERED_SHIP_ADDRESS	smallint
BILL_TO_ADDRESS_ID	int
PROFESSIONAL_BUYER_ID	int
IS_CORPORATE_TEMPLATE	smallint
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK18 PRIMARY KEY CLUSTERED ( DOCUMENT_ID )

CREATE TABLE PURCHASE_REQUISITION_ADC (
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_2 PRIMARY KEY CLUSTERED ( DOCUMENT_ID )

CREATE TABLE TIMESHEET_ADC (
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_4 PRIMARY KEY CLUSTERED ( DOCUMENT_ID )

CREATE TABLE TIMESHEET_DOCUMENT (
DOCUMENT_ID	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)
DOCUMENT_STATUS	nvarchar(255)
CURRENT_ACTIVITY_ID	int
ENTERED_CURRENT_ACTIVITY_DATE	datetime
ACTIVITY_OWNER_ID	int
HAS_EXCEPTIONS	smallint	NOT NULL
HAS_OVERRIDES	smallint	NOT NULL
CREATE_DATE	datetime
CREATOR_USER_ID	int
OWNER_USER_ID	int
AUDIT_INDICATOR	nvarchar(255)
TITLE	nvarchar(255)
PERIOD_START	datetime
PERIOD_END	datetime
SUBMITTED_DATE	datetime
APPROVED_DATE	datetime
TOTAL_HOURS	numeric(14,4)
WORK_SCHEDULE_HOURS	numeric(14,4)
HOLIDAY_SCHEDULE	nvarchar(255)
LABOR_STATUS	nvarchar(255)
EMPLOYMENT_STATUS	nvarchar(255)
BILLABLE_RATE	numeric(28,10)
BILLABLE_RATE_CURRENCY	nchar(3)
OVERTIME_HOURS	numeric(7,2)
DOUBLE_TIME_HOURS	numeric(7,2)
TRIPLE_TIME_HOURS	numeric(7,2)
REGULAR_HOURS	numeric(7,2)
CHANGE_TIMESTAMP	datetime
CREATE_LOCATION_ID	int
JOB_CLASSIFICATION	nvarchar(100)
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK26 PRIMARY KEY CLUSTERED ( DOCUMENT_ID )

CREATE TABLE TIMESHEET_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int
IS_ATTENDANCE_LINE_ITEM	smallint	NOT NULL
HOURS	numeric(14,4)
WORK_DATE	datetime
START_TIME	datetime
END_TIME	datetime
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
PROJECT_ACTIVITY_CODE	nvarchar(255)
PROJECT_ACTIVITY_NAME	nvarchar(255)
APPROVED_HOURS	numeric(14,4)
HOURLY_CHARGE_TYPE	nchar(40)
CHARGE_TYPE	nvarchar(255)
LOCATION_ID	int
CHARGE_ROLE	nvarchar(255)
APPROVED_HOURLY_CHARGE_TYPE	nchar(40)
BILLABLE_RATE	numeric(28,10)
BILLABLE_RATE_CURRENCY	nchar(3)
DESCRIPTION	nvarchar(255)
ADJUSTED_HOURS	numeric(7,2)
CHANGE_TIMESTAMP	datetime
ATTD_IN1	datetime
ATTD_OUT1	datetime
ATTD_IN2	datetime
ATTD_OUT2	datetime
ATTD_IN3	datetime
ATTD_OUT3	datetime
ATTD_IN4	datetime
ATTD_OUT4	datetime
ATTD_IN5	datetime
ATTD_OUT5	datetime
ATTD_IN6	datetime
ATTD_OUT6	datetime
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK27 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE TIMESHEET_LINE_ITEM_ADC (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	EXTERNAL_VENDOR_ID datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_5 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )

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 TRAVEL_LINE_ITEM_ADC (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )

CREATE TABLE TRAVEL_PLAN (
DOCUMENT_ID	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)	NOT NULL
DOCUMENT_STATUS	nvarchar(255)
HAS_EXCEPTIONS	smallint
HAS_OVERRIDES	smallint
CURRENT_ACTIVITY_ID	int	NOT NULL
CURRENT_ACTIVITY_ENTRY_DATE	datetime	NOT NULL
ACTIVITY_OWNER_ID	int
CREATE_DATE	datetime
SUBMITTED_DATE	datetime
APPROVED_DATE	datetime
FROM_DATE	datetime
TO_DATE	datetime
CREATOR_USER_ID	int
OWNER_USER_ID	int
TITLE	nvarchar(255)
PURPOSE	nvarchar(255)
PURPOSE_USER_ID	int
NUMBER_GOING	int
AIR_AMOUNT_CURRENCY	nchar(3)
AIR_AMOUNT	numeric(28,10)
HOTEL_AMOUNT_CURRENCY	nchar(3)
HOTEL_AMOUNT	numeric(28,10)
HOTEL_TAX_AMOUNT_CURRENCY	nchar(3)
HOTEL_TAX_AMOUNT	numeric(28,10)
CAR_AMOUNT_CURRENCY	nchar(3)
CAR_AMOUNT	numeric(28,10)
CAR_TAX_AMOUNT_CURRENCY	nchar(3)
CAR_TAX_AMOUNT	numeric(28,10)
MEALS_AMOUNT_CURRENCY	nchar(3)
MEALS_AMOUNT	numeric(28,10)
OTHER_AMOUNT_CURRENCY	nchar(3)
OTHER_AMOUNT	numeric(28,10)
TOTAL_AMOUNT_CURRENCY	nchar(3)
TOTAL_AMOUNT	numeric(28,10)
EMPLOYEE_COMPANY	nvarchar(255)
EMPLOYEE_DEPARTMENT	nvarchar(255)
TRIP_TYPE	nvarchar(255)
ORD_KEY	nvarchar(255)
INTEGRATION_PARTNER_NAME	nvarchar(255)
MAX_AIR_TICKET_AMOUNT_CURRENCY	nchar(3)
MAX_AIR_TICKET_AMOUNT	numeric(28,10)
ITINERARY_STATE	int
CHANGE_TIMESTAMP	datetime
CREATE_LOCATION_ID	int
CREATOR_CLIENT_TYPE	int
CONSTRAINT PK23 PRIMARY KEY CLUSTERED ( DOCUMENT_ID )

CREATE TABLE TRAVEL_PLAN_ADC (
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK35_8 PRIMARY KEY CLUSTERED ( DOCUMENT_ID )

CREATE TABLE USER_LCF_TOTAL (
LCF_BALANCE	numeric(28,10)	NOT NULL
LCF_BALANCE_CURRENCY	nchar(3)	NOT NULL
USER_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime )

Modifications in Expense Management 10.2.4

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
PRIMARY_ISO_CURRENCY_CODE	nchar(3)
MARKET_CODE	nvarchar(50)
GLOBAL_CLIENT_ORIGIN_ID	nvarchar(50)
LOCAL_COUNTRY_ISO_CODE	nchar(3)
CONSTRAINT PK30 PRIMARY KEY CLUSTERED ( CREDIT_CARD_TRANSACTION_ID ) )

New table in Expense Management 10.2.9

CREATE TABLE DELETED_ROWS (
TABLE_NAME	nvarchar(255)	NOT NULL
PK_COLUMNS	nvarchar(255)	NOT NULL
PK_VALUE_1	int
PK_VALUE_2	int
PK_VALUE_3	int
PK_VALUE_4	int
PK_VALUE_5	int
CHANGE_TIMESTAMP datetime )

Modifications in Expense Management 10.2.9

CREATE TABLE USER_AUDIT_LIST (
USER_ID	int	NOT NULL
DOCUMENT_ID	int
AUDIT_NOTES	nvarchar(255)
REASON_FOR_AUDIT	nvarchar(255)
CHANGE_TIMESTAMP	datetime
USER_AUDIT_LIST_ID	int	NOT NULL
CONSTRAINT USER_AUDIT_LIST_PK PRIMARY KEY CLUSTERED ( USER_AUDIT_LIST_ID )

CREATE TABLE EXPENSE_REPORT_OVERAGE_LINE (
OVERAGE_ID	int
LINE_ITEM_ID	int
LINE_ITEM_EXPENSE_TYPE_ID	int
CHANGE_TIMESTAMP	datetime
DOCUMENT_ID	int
OVERAGE_LINE_ID	int	NOT NULL
CONSTRAINT EXPENSE_REPORT_OVERAGE_LINE_PK PRIMARY KEY CLUSTERED ( OVERAGE_LINE_ID )

CREATE TABLE DELINQUENT_TIMESHEET (
DELINQUENT_TS_ID	int	NOT NULL
USER_ID	int	NOT NULL
START_DATE	datetime	NOT NULL
END_DATE	datetime	NOT NULL
END_CALENDAR_DATE	datetime	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK439_1 PRIMARY KEY CLUSTERED ( DELINQUENT_TS_ID ) )

CREATE TABLE ER_FLEX_FIELD_LABELS (
FF_LABELS_ID	int
STRING_1_LABEL	nvarchar(255)
STRING_2_LABEL	nvarchar(255)
STRING_3_LABEL	nvarchar(255)
STRING_4_LABEL	nvarchar(255)
INTEGER_1_LABEL	nvarchar(255)
INTEGER_2_LABEL	nvarchar(255)
DATE_1_LABEL	nvarchar(255)
DATE_2_LABEL	nvarchar(255)
AMOUNT_1_LABEL	nvarchar(255)
AMOUNT_2_LABEL	nvarchar(255)
LOCATION_1_LABEL	nvarchar(255)
DDLB_1_LABEL	nvarchar(255)
DDLB_2_LABEL	nvarchar(255)
DDLB_3_LABEL	nvarchar(255)
DDLB_4_LABEL	nvarchar(255)
DDLB_5_LABEL	nvarchar(255)
CHANGE_TIMESTAMP	datetime )

CREATE TABLE ER_TR_ITEM_LINK (
LINE_ITEM_ID	int	NOT NULL
TR_TRACKING_NUM	nvarchar(255)
PREAPPROVED_AMT_CURRENCY	nchar(3)
PREAPPROVED_AMT	numeric(28,10)
LINE_ITEM_DATE	datetime
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK597_1 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE ERLI_FLEX_FIELD_LABELS (
FF_LABELS_ID	int
STRING_1_LABEL	nvarchar(255)
STRING_2_LABEL	nvarchar(255)
STRING_3_LABEL	nvarchar(255)
STRING_4_LABEL	nvarchar(255)
INTEGER_1_LABEL	nvarchar(255)
INTEGER_2_LABEL	nvarchar(255)
DATE_1_LABEL	nvarchar(255)
DATE_2_LABEL	nvarchar(255)
AMOUNT_1_LABEL	nvarchar(255)
AMOUNT_2_LABEL	nvarchar(255)
LOCATION_1_LABEL	nvarchar(255)
DDLB_1_LABEL	nvarchar(255)
DDLB_2_LABEL	nvarchar(255)
DDLB_3_LABEL	nvarchar(255)
DDLB_4_LABEL	nvarchar(255)
DDLB_5_LABEL	nvarchar(255)
CHANGE_TIMESTAMP	datetime

CREATE TABLE EXPENSE_TYPE_RELATIONSHIP (
RELATIONSHIP_ID	int	NOT NULL
EXPENSE_TYPE_ID	int	NOT NULL
PARENT_EXPENSE_TYPE_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK8_1 PRIMARY KEY CLUSTERED ( RELATIONSHIP_ID ) )

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

Modifications in Expense Management 10.2.11

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
PRIMARY_ISO_CURRENCY_CODE	nchar(3)
MARKET_CODE	nvarchar(50)
GLOBAL_CLIENT_ORIGIN_ID	nvarchar(50)
LOCAL_COUNTRY_ISO_CODE	nchar(3)
TRANSACTION_TYPE_CODE	nvarchar(10)
TAX1	numeric(28,10)
TAX1_CURRENCY	nchar(3)
TAX2	numeric(28,10)
TAX2_CURRENCY	nchar(3)
TAX1_INCLUDED	smallint
TAX2_INCLUDED	smallint
CONSTRAINT PK30 PRIMARY KEY CLUSTERED ( CREDIT_CARD_TRANSACTION_ID ) )

Modifications in Expense Management 10.2.12

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
CONSTRAINT PK7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

Modification in Expense Management 10.2.13

CREATE TABLE FLAT_COST_CENTER_PERMISSION (
REPORTING_USER_ID	int	NOT NULL
REPORTING_USER_LOGIN	nvarchar(255),
REVIEW_SEGMENT_CODE	nvarchar(60),
SEGMENT1_CODE	nvarchar(60),
SEGMENT1_INDEX	int,
SEGMENT2_CODE	nvarchar(60),
SEGMENT2_INDEX	int,
SEGMENT3_CODE	nvarchar(60),
SEGMENT3_INDEX	int,
SEGMENT4_CODE	nvarchar(60),
SEGMENT4_INDEX	int,
SEGMENT5_CODE	nvarchar(60),
SEGMENT5_INDEX	int,
SEGMENT6_CODE	nvarchar(60),
SEGMENT6_INDEX	int,
SEGMENT7_CODE	nvarchar(60),
SEGMENT7_INDEX	int,
SEGMENT8_CODE	nvarchar(60),
SEGMENT8_INDEX	int,
SEGMENT9_CODE	nvarchar(60),
SEGMENT9_INDEX	int,
CHANGE_TIMESTAMP	datetime,
CONSTRAINT FLAT_COST_CENTER_PERMISSION_PK PRIMARY KEY CLUSTERED ( REPORTING_USER_ID ) )

Modifications to tables in Expense Management 10.2.13

CREATE TABLE FLAT_COST_CENTER (
COST_CENTER_ID	int	NOT NULL,
USER_ID	int,
REVIEW_SEGMENT_NAME	nvarchar(255),
REVIEW_SEGMENT_CODE	nvarchar(60)	NOT NULL,
REVIEW_SEGMENT_DISPLAY_STRING	nvarchar(255)	NOT NULL,
REVIEW_SEGMENT_DESCRIPTION	nvarchar(255),
DEFAULT_REVIEWER_ID	int,
ALTERNATE_REVIEWER_ID	int,
SEGMENT1_NAME	nvarchar(255),
SEGMENT1_CODE	nvarchar(60)	NOT NULL,
SEGMENT1_DISPLAY_STRING	nvarchar(255),
SEGMENT2_NAME	nvarchar(255),
SEGMENT2_CODE	nvarchar(60),
SEGMENT2_DISPLAY_STRING	nvarchar(255),
SEGMENT3_NAME	nvarchar(255),
SEGMENT3_CODE	nvarchar(60),
SEGMENT3_DISPLAY_STRING	nvarchar(255),
SEGMENT4_NAME	nvarchar(255),
SEGMENT4_CODE	nvarchar(60),
SEGMENT4_DISPLAY_STRING	nvarchar(255),
SEGMENT5_NAME	nvarchar(255),
SEGMENT5_CODE	nvarchar(60),
SEGMENT5_DISPLAY_STRING	nvarchar(255),
SEGMENT6_NAME	nvarchar(255),
SEGMENT6_CODE	nvarchar(60),
SEGMENT6_DISPLAY_STRING	nvarchar(255),
SEGMENT7_NAME	nvarchar(255),
SEGMENT7_CODE	nvarchar(60),
SEGMENT7_DISPLAY_STRING	nvarchar(255),
SEGMENT8_NAME	nvarchar(255),
SEGMENT8_CODE	nvarchar(60),
SEGMENT8_DISPLAY_STRING	nvarchar(255),
SEGMENT9_NAME	nvarchar(255),
SEGMENT9_CODE	nvarchar(60),
SEGMENT9_DISPLAY_STRING	nvarchar(255),
SEGMENT_COUNT	int	NOT NULL,
COST_CENTER_NAME	nvarchar(510),
COST_CENTER_CODE	nvarchar(255),
COST_CENTER_DISPLAY_STRING	nvarchar(510)	NOT NULL,
COST_CENTER_ACTIVE_STATUS	smallint	NOT NULL,
CHANGE_TIMESTAMP	datetime,
SEGMENT1_INDEX	int,
SEGMENT2_INDEX	int,
SEGMENT3_INDEX	int,
SEGMENT4_INDEX	int,
SEGMENT5_INDEX	int,
SEGMENT6_INDEX	int,
SEGMENT7_INDEX	int,
SEGMENT8_INDEX	int,
SEGMENT9_INDEX	int,
CONSTRAINT PK110 PRIMARY KEY CLUSTERED ( COST_CENTER_ID ) )

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,
ITEM_CODE	nvarchar(50)	NOT NULL,
CARD_TYPE	int	NOT NULL,
ITEM_CODE_DESCRIPTION	nvarchar(255)	NOT NULL,
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
)

New tables in Expense Management 10.2.14

CREATE TABLE RECEIPTS_LINE_URL (
RECEIPT_LINE_URL_ID	int	NOT NULL,
DOCUMENT_ID	nvarchar(255)	NOT NULL,
LINE_ID	int	NOT NULL,
RECEIPT_ID	int	NOT NULL
URL	nvarchar(510),
FLEX_FIELD_1	nvarchar(255),
FLEX_FIELD_2	int,
STATUS	int	NOT NULL,
ACTIVE_STATUS	int	NOT NULL,
CHANGE_TIMESTAMP	datetime,
CONSTRAINT PK550_1 PRIMARY KEY CLUSTERED ( RECEIPT_LINE_URL_ID ) )

Modifications to tables in Expense Management 10.2.14

CREATE TABLE ER_TR_ITEM_LINK (
LINE_ITEM_ID	int	NOT NULL
TR_TRACKING_NUM	nvarchar(255)
PREAPPROVED_AMT_CURRENCY	nchar(3)
PREAPPROVED_AMT	numeric(28,10)
LINE_ITEM_DATE	datetime
CHANGE_TIMESTAMP	datetime
TR_ITEM_ID	int	NOT NULL
CONSTRAINT PK597_1 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) )

CREATE TABLE EXT_USER (
USER_ID	int	NOT NULL
FULL_NAME	nvarchar(255)	NOT NULL
FIRST_NAME	nvarchar(255)
MIDDLE_INITIAL	nchar(1)
LAST_NAME	nvarchar(255)
EMPLOYEE_NUMBER	nvarchar(255)
LOGIN	nvarchar(255)
TITLE	nvarchar(255)
IS_ACTIVE	smallint
TAXPAYER_ID	nvarchar(255)
DEFAULT_COST_CENTER_ID	int
LCF_TOTAL_AMT_CUR	nchar(3)
LCF_TOTAL_AMT	numeric(28,10)
COUNTRY_NAME	nvarchar(255)
COUNTRY_ISO_CODE	nchar(2)
BOSS_ID	int
OFFICE_NAME	nvarchar(255)
LOCATION_ID	int
SET_OF_BOOKS_NAME	nvarchar(255)
AUTH_AMT	numeric(28,10)
AUTH_AMT_CUR	nchar(3)
PR_AUTH_AMT	numeric(28,10)
PR_AUTH_AMT_CUR	nchar(3)
SYSTEM_CODE_1	nvarchar(255)
SYSTEM_CODE_2	nvarchar(255)
SYSTEM_CODE_3	nvarchar(255)
SYSTEM_CODE_4	nvarchar(255)
SYSTEM_CODE_5	nvarchar(255)
SYSTEM_CODE_6	nvarchar(255)
SYSTEM_CODE_7	nvarchar(255)
SYSTEM_CODE_8	nvarchar(255)
SYSTEM_DATE_1	datetime
SYSTEM_DATE_2	datetime
CHANGE_TIMESTAMP	datetime
EMAIL_ADDRESS	nvarchar(255)
DEFAULT_CURRENCY	nchar(3)
CREATION_TIME	datetime
LAST_MODIFIED_TIME	datetime
PAYROLL_SYSTEM_CODE	nvarchar(255)
ER_DEFAULT_PROJECT_ID	int
PROXY_CAN_SUBMIT	smallint
PROXY_REVIEWER_CAN_SUBMIT	smallint
SECOND_CURRENCY	nchar(3)
START_DATE	datetime
END_DATE	datetime
USER_MAILSTOP	nvarchar(255)
IDENTITY2	nvarchar(36)
CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID ) )

New tables in Expense Management 10.2.15

No new are added in Expense Management 10.2.15.

Modifications to tables in 10.2.15

These tables are modified in Expense Management 10.2.15. Newly added columns are highlighted. Deleted columns are grey out.

CREATE TABLE EXT_USER (
USER_ID	int	NOT NULL
FULL_NAME	nvarchar(255)	NOT NULL
FIRST_NAME	nvarchar(255)
MIDDLE_INITIAL	nchar(1)
LAST_NAME	nvarchar(255)
EMPLOYEE_NUMBER	nvarchar(255)
LOGIN	nvarchar(255)
TITLE	nvarchar(255)
IS_ACTIVE	smallint
TAXPAYER_ID	nvarchar(255)
DEFAULT_COST_CENTER_ID	int
LCF_TOTAL_AMT_CUR	nchar(3)
LCF_TOTAL_AMT	numeric(28,10)
COUNTRY_NAME	nvarchar(255)
COUNTRY_ISO_CODE	nchar(2)
BOSS_ID	int
OFFICE_NAME	nvarchar(255)
LOCATION_ID	int
SET_OF_BOOKS_NAME	nvarchar(255)
AUTH_AMT	numeric(28,10)
AUTH_AMT_CUR	nchar(3)
PR_AUTH_AMT	numeric(28,10)
PR_AUTH_AMT_CUR	nchar(3)
SYSTEM_CODE_1	nvarchar(255)
SYSTEM_CODE_2	nvarchar(255)
SYSTEM_CODE_3	nvarchar(255)
SYSTEM_CODE_4	nvarchar(255)
SYSTEM_CODE_5	nvarchar(255)
SYSTEM_CODE_6	nvarchar(255)
SYSTEM_CODE_7	nvarchar(255)
SYSTEM_CODE_8	nvarchar(255)
SYSTEM_DATE_1	datetime
SYSTEM_DATE_2	datetime
CHANGE_TIMESTAMP	datetime
EMAIL_ADDRESS	nvarchar(255)
DEFAULT_CURRENCY	nchar(3)
CREATION_TIME	datetime
LAST_MODIFIED_TIME	datetime
PAYROLL_SYSTEM_CODE	nvarchar(255)
ER_DEFAULT_PROJECT_ID	int
PROXY_CAN_SUBMIT	smallint
PROXY_REVIEWER_CAN_SUBMIT	smallint
SECOND_CURRENCY	nchar(3)
START_DATE	datetime
END_DATE	datetime
USER_MAILSTOP	nvarchar(255)
IDENTITY2	nvarchar(36)
USER_LOCATION	nvarchar(255)
CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID ) )

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
)

New tables in Expense Management 10.2.17

Modifications to tables in 10.2.17

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

CREATE TABLE ALLOCATION (
LINE_ITEM_ID	int
LINE_ITEM_ID_TYPE	int
PERCENT_ALLOTTED	float
PAID_IN_AMOUNT_CURRENCY	nchar(3)
PAID_IN_AMOUNT	numeric(28,10)
TRANSACTION_AMOUNT_CURRENCY	nchar(3)
TRANSACTION_AMOUNT	numeric(28,10)
IS_APPROVED	smallint
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
IS_BILLABLE	smallint
CHANGE_TIMESTAMP	datetime
ALLOCATION_DATE	datetime
ALLOCATION_ID	int	Not Null
CONSTRAINT PK555 PRIMARY KEY CLUSTERED ( ALLOCATION_ID )
)

CREATE TABLE CREDIT_CARD_TRANSACTION (
CREDIT_CARD_TRANSACTION_I	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	nchar(20)
MERCHANT_STD_SIC_CODE	nchar(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
PRIMARY_ISO_CURRENCY_CODE	nchar(3)
MARKET_CODE	nvarchar(50)
GLOBAL_CLIENT_ORIGIN_ID	nvarchar(50)
LOCAL_COUNTRY_ISO_CODE	nchar(3)
TRANSACTION_TYPE_CODE	nvarchar(10)
TAX1	numeric(28,10)
TAX1_CURRENCY	nchar(3)
TAX2	numeric(28,10)
TAX2_CURRENCY	nchar(3)
TAX1_INCLUDED	smallint
TAX2_INCLUDED	smallint
MERCHANT_ADDRESS	nvarchar(255)
CONSTRAINT PK30 PRIMARY KEY CLUSTERED ( CREDIT_CARD_TRANSACTION_ID )
)

CREATE TABLE EXPENSE_REPORT (
DOCUMENT_ID	int	NOT NULL
TRACKING_NUMBER	nvarchar(255)	NOT NULL
DOCUMENT_STATUS	nvarchar(255)
CURRENT_ACTIVITY_ID	int	NOT NULL
ENTERED_CURRENT_ACTIVITY_DATE	datetime	NOT NULL
ACTIVITY_OWNER_ID	int
HAS_EXCEPTIONS	smallint
HAS_OVERRIDES	smallint
CREATE_DATE	datetime
CREATOR_USER_ID	int
OWNER_USER_ID	int
AUDIT_INDICATOR	nvarchar(255)
RECEIPTS_RECEIVED_DATE	datetime
TITLE	nvarchar(255)
CASH_ADVANCE_AMT	numeric(28,10)
CASH_ADVANCE_AMT_CURRENCY	nchar(3)
COMPANY_CHARGES_AMT	numeric(28,10)
COMPANY_CHARGES_AMT_CURRENCY	nchar(3)
DUE_EMPLOYEE_AMT	numeric(28,10)
DUE_EMPLOYEE_AMT_CURRENCY	nchar(3)
DUE_COMPANY_AMT	numeric(28,10)
DUE_COMPANY_AMT_CURRENCY	nchar(3)
TOTAL_AUTHORIZED_AMT	numeric(28,10)
TOTAL_AUTHORIZED_AMT_CURRENCY	nchar(3)
TOTAL_EXPENSED_AMT	numeric(28,10)
TOTAL_EXPENSED_AMT_CURRENCY	nchar(3)
SUBMITTED_DATE	datetime
APPROVED_DATE	datetime
EXPENSE_FROM_DATE	datetime
EXPENSE_TO_DATE	datetime
IS_APPROVED	smallint
PAID_AMT	numeric(28,10)
PAID_AMT_CURRENCY	nchar(3)
PAID_DATE	datetime
PAYMENT_NUMBER	nvarchar(255)
PURPOSE_TEXT	nvarchar(255)
PURPOSE_CREATOR_ID	int
CORP_CHARGE_TOTAL_AMT	numeric(28,10)
CORP_CHARGE_TOTAL_AMT_CURRENCY	nchar(3)
CORP_CHARGE_PAID_AMT	numeric(28,10)
CORP_CHARGE_PAID_AMT_CURRENCY	nchar(3)
CORP_CHARGE_PAID_DATE	datetime
COMP_PAYS_CARDS_AMT	numeric(28,10)
COMP_PAYS_CARDS_AMT_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CREATE_LOCATION_ID	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)
APPLIED_LCF	numeric(28,10)
APPLIED_LCF_CURRENCY	nchar(3)
REMAINING_LCF	numeric(28,10)
REMAINING_LCF_CURRENCY	nchar(3)
GENERATED_LCF	numeric(28,10)
GENERATED_LCF_CURRENCY	nchar(3)
CREATOR_CLIENT_TYPE	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)
CONSTRAINT PK6 PRIMARY KEY CLUSTERED ( DOCUMENT_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)
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)
CONSTRAINT PK7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )
)

CREATE TABLE INVOICE_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ITEM_NUMBER	nvarchar(255)
ITEM_DESCRIPTION	nvarchar(255)
INVOICED_QUANTITY	numeric(15,5)
UNIT_OF_MEASURE_CODE	nvarchar(255)
UNIT_OF_MEASURE	nvarchar(255)
UNIT_OF_MEASURE_CREATOR_ID	int
UNIT_PRICE	numeric(28,10)
UNIT_PRICE_CURRENCY	nchar(3)
TOTAL_PRICE	numeric(28,10)
TOTAL_PRICE_CURRENCY	nchar(3)
CHECK_REQUEST_TYPE_ID	int
CHANGE_TIMESTAMP	datetime
NUMBER_OF_GUESTS	int
GUEST_NO_SHOW_COUNT	int
INVOICE_DATE	datetime
CREATOR_CLIENT_TYPE	int
EXPORT_STATUS	int
VOID_STATUS	int
REVERSAL_LINE_ITEM_ID	int
CONSTRAINT PK11 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )
)

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
CONSTRAINT PK22 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )
)

CREATE TABLE TIMESHEET_LINE_ITEM (
LINE_ITEM_ID	int	NOT NULL
DOCUMENT_ID	int
IS_ATTENDANCE_LINE_ITEM	smallint	NOT NULL
HOURS	numeric(14,4)
WORK_DATE	datetime
START_TIME	datetime
END_TIME	datetime
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
PROJECT_ACTIVITY_CODE	nvarchar(255)
PROJECT_ACTIVITY_NAME	nvarchar(255)
APPROVED_HOURS	numeric(14,4)
HOURLY_CHARGE_TYPE	nchar(40)
CHARGE_TYPE	nvarchar(255)
LOCATION_ID	int
CHARGE_ROLE	nvarchar(255)
APPROVED_HOURLY_CHARGE_TYPE	nchar(40)
BILLABLE_RATE	numeric(28,10)
BILLABLE_RATE_CURRENCY	nchar(3)
DESCRIPTION	nvarchar(255)
ADJUSTED_HOURS	numeric(7,2)
CHANGE_TIMESTAMP	datetime
ATTD_IN1	datetime
ATTD_OUT1	datetime
ATTD_IN2	datetime
ATTD_OUT2	datetime
ATTD_IN3	datetime
ATTD_OUT3	datetime
ATTD_IN4	datetime
ATTD_OUT4	datetime
ATTD_IN5	datetime
ATTD_OUT5	datetime
ATTD_IN6	datetime
ATTD_OUT6	datetime
CREATOR_CLIENT_TYPE	int
EXPORT_STATUS	int
VOID_STATUS	int
REVERSAL_LINE_ITEM_ID	int
CONSTRAINT PK27 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID )
)

CREATE TABLE CUMULATIVE_MILES (
CUMULATIVE_MILEAGE_ID	int	NOT NULL
USER_ID	int
PERIOD_START_DATE	datetime
PERIOD_END_DATE	datetime
CUMULATIVE_MILES	numeric(15,5)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK115_1 PRIMARY KEY CLUSTERED ( CUMULATIVE_MILEAGE_ID )
)

CREATE TABLE ORGANIZATION_PERMISSION (
ORGANIZATION_PERMISSION_ID	int	NOT NULL
REPORTING_USER_ID	int	NOT NULL
REPORTING_USER_LOGIN	nvarchar(255)
ORGANIZATION_ID	int
ORGANIZATION_ID_TYPE	int
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK112_1 PRIMARY KEY CLUSTERED ( ORGANIZATION_PERMISSION_ID )
)

CREATE TABLE PROJECT_NUMBER_PERMISSION (
PROJECT_NUMBER_PERMISSION_ID	int	NOT NULL
REPORTING_USER_ID	int	NOT NULL
REPORTING_USER_LOGIN	nvarchar(255)
PROJECT_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK113_1 PRIMARY KEY CLUSTERED ( PROJECT_NUMBER_PERMISSION_ID )
)

CREATE TABLE USER_PERMISSION (
USER_PERMISSION_ID	int	NOT NULL
REPORTING_USER_ID	int	NOT NULL
REPORTING_USER_LOGIN	nvarchar(255)
USER_ID	int	NOT NULL
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK114_1 PRIMARY KEY CLUSTERED ( USER_PERMISSION_ID )
)

New tables in Expense Management 10.2.18

CREATE TABLE ADMIN_LOG (
ADMIN_LOG_ID	int	NOT NULL
LOG_DATE	datetime	NOT NULL
USER_ID	int
ACTION_NAME	nvarchar(255)
BOB_ID	int
BOB_TYPE_ID	int
BOB_TYPE_NAME	nvarchar(255)
DESCRIPTION	nvarchar(max)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK_ADMIN_LOG PRIMARY KEY CLUSTERED ( ADMIN_LOG_ID )
)

Modifications to tables in 10.2.18

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

CREATE TABLE ALLOCATION (
LINE_ITEM_ID	int	NOT NULL
LINE_ITEM_ID_TYPE	int
PERCENT_ALLOTTED	float
PAID_IN_AMOUNT_CURRENCY	nchar(3)
PAID_IN_AMOUNT	numeric(28, 10)
TRANSACTION_AMOUNT_CURRENCY	nchar(3)
TRANSACTION_AMOUN T	numeric(28, 10)
IS_APPROVED	smallint
COST_CENTER_ID	int
PROJECT_NUMBER_ID	int
IS_BILLABLE	smallint
CHANGE_TIMESTAMP	datetime
ALLOCATION_DATE	datetime
ALLOCATION_ID	int	NOT NULL
CONSTRAINT PK555 PRIMARY KEY CLUSTERED ( ALLOCATION_ID,LINE_ITEM_ID)
)

CREATE TABLE BUSINESS_RULE_VIOLATION (
VIOLATION_ID	int	NOT NULL
MESSAGE	nvarchar(4000)
SEVERITY	int
TITLE	nvarchar(255)	NOT NULL
REPORT_MESSAGE	nvarchar(510)
TEMPLATE_NAME	nvarchar(255)
IS_ACTIVE	smallint
IS_APPROVED	smallint
DOCUMENT_ID	int
EXPLANATION	nvarchar(max)
DOCUMENT_TYPE	int
VIOLATOR_ID	int
LINE_ITEM_ID	int
ROUTING_TYPE_CODE	nvarchar(30)
ROUTING_TYPE_NAME	nvarchar(255)
ROUTING_TYPE_POLICY_FLAG	nchar(1)
ROUTING_TYPE_DESCRIPTION	nvarchar(255)
IS_REVIEW_POLICY	smallint
CHANGE_TIMESTAMP	datetime
POINTS	int
CONSTRAINT PK2 PRIMARY KEY CLUSTERED ( VIOLATION_ID )
)

Modifications to tables in 10.2.20

CREATE TABLE EXT_USER (
USER_ID	int	NOT NULL
FULL_NAME	nvarchar(255)	NOT NULL
FIRST_NAME	nvarchar(255)
MIDDLE_INITIAL	nchar(1)
LAST_NAME	nvarchar(255)
EMPLOYEE_NUMBER	nvarchar(255)
LOGIN	nvarchar(255)
TITLE	nvarchar(255)
IS_ACTIVE	smallint
TAXPAYER_ID	nvarchar(255)
DEFAULT_COST_CENTER_ID	int
LCF_TOTAL_AMT_CUR	nchar(3)
LCF_TOTAL_AMT	numeric(28,10)
COUNTRY_NAME	nvarchar(255)
COUNTRY_ISO_CODE	nchar(2)
BOSS_ID	int
OFFICE_NAME	nvarchar(255)
LOCATION_ID	int
SET_OF_BOOKS_NAME	nvarchar(255)
AUTH_AMT	numeric(28,10)
AUTH_AMT_CUR	nchar(3)
PR_AUTH_AMT	numeric(28,10)
PR_AUTH_AMT_CUR	nchar(3)
SYSTEM_CODE_1	nvarchar(255)
SYSTEM_CODE_2	nvarchar(255)
SYSTEM_CODE_3	nvarchar(255)
SYSTEM_CODE_4	nvarchar(255)
SYSTEM_CODE_5	nvarchar(255)
SYSTEM_CODE_6	nvarchar(255)
SYSTEM_CODE_7	nvarchar(255)
SYSTEM_CODE_8	nvarchar(255)
SYSTEM_DATE_1	datetime
SYSTEM_DATE_2	datetime
CHANGE_TIMESTAMP	datetime
EMAIL_ADDRESS	nvarchar(255)
DEFAULT_CURRENCY	nchar(3)
CREATION_TIME	datetime
LAST_MODIFIED_TIME	datetime
PAYROLL_SYSTEM_CODE	nvarchar(255)
ER_DEFAULT_PROJECT_ID	int
PROXY_CAN_SUBMIT	smallint
PROXY_REVIEWER_CAN_SUBMIT	smallint
SECOND_CURRENCY	nchar(3)
START_DATE	datetime
END_DATE	datetime
USER_MAILSTOP	nvarchar(255)
IDENTITY2	nvarchar(36)
USER_LOCATION	nvarchar(255)
FX_RATE_SOURCE_NAME	nvarchar(50)
CONSTRAINT PK9 PRIMARY KEY CLUSTERED ( USER_ID )
)

New table in Expense Management 10.2.21

CREATE TABLE ALLOCATION_ADC (
ALLOCATION_ID	int	NOT NULL
DOCUMENT_ID	int	NOT NULL
ADC_STRING_1	nvarchar(510)
ADC_STRING_2	nvarchar(510)
ADC_STRING_3	nvarchar(510)
ADC_STRING_4	nvarchar(510)
ADC_STRING_5	nvarchar(510)
ADC_STRING_6	nvarchar(510)
ADC_STRING_7	nvarchar(510)
ADC_STRING_8	nvarchar(510)
ADC_STRING_9	nvarchar(510)
ADC_STRING_10	nvarchar(510)
ADC_DATE_1	datetime
ADC_DATE_2	datetime
ADC_DATE_3	datetime
ADC_DATE_4	datetime
ADC_DATE_5	datetime
ADC_INTEGER_1	int
ADC_INTEGER_2	int
ADC_INTEGER_3	int
ADC_AMOUNT_1	numeric(28,10)
ADC_AMOUNT_1_CURRENCY	nchar(3)
ADC_AMOUNT_2	numeric(28,10)
ADC_AMOUNT_2_CURRENCY	nchar(3)
ADC_AMOUNT_3	numeric(28,10)
ADC_AMOUNT_3_CURRENCY	nchar(3)
CHANGE_TIMESTAMP	datetime
CONSTRAINT PK_ALLOC_ADC PRIMARY KEY CLUSTERED ( ALLOCATION_ID )
)

Modifications to tables in Expense Management 10.2.21

CREATE TABLE CUMULATIVE_MILES (
CUMULATIVE_MILEAGE_ID	int	NOT NULL
USER_ID	int
PERIOD_START_DATE	datetime
PERIOD_END_DATE	datetime
CUMULATIVE_MILES	numeric(15,5)
CHANGE_TIMESTAMP	datetime
EXPENSE_TYPE_ID	int
CONSTRAINT PK115_1 PRIMARY KEY CLUSTERED ( CUMULATIVE_MILEAGE_ID )
)

CREATE TABLE ORGANIZATION (
COST_CENTER_ID	int	NOT NULL
COMPANY_ID	int
COMPANY_NAME	nvarchar(255)
COMPANY_CODE	nchar( 60 )
DIVISION_ID	int
DIVISION_NAME	nvarchar(255)
DIVISION_CODE	nchar( 60 )
DEPARTMENT_ID	int
DEPARTMENT_NAME	nvarchar(255)
DEPARTMENT_CODE	nchar( 60 )
USER_ID	int
COST_CENTER_NAME	nvarchar(255)
COST_CENTER_CODE	nchar(60)
COST_CENTER_DESCRIPTION	nvarchar(255)
DEFAULT_REVIEWER_ID	int
ALTERNATE_REVIEWER_ID	int
CHANGE_TIMESTAMP	datetime
COST_CENTER_ACTIVE_STATUS	smallint
CONSTRAINT PK10 PRIMARY KEY CLUSTERED ( COST_CENTER_ID )
)