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