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