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