Version 2022.09
Modified tables. The new columns are highlighted and the deleted columns are marked with the * symbol.
| 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 | |
| SOURCE_CARD_ID | int | |
| CONSTRAINT PK29 PRIMARY KEY CLUSTERED ( CREDIT_CARD_ID ) | ||
| ) | ||
| go | ||
| CREATE TABLE CREDIT_CARD_TRANSACTION ( | ||
|---|---|---|
| CREDIT_CARD_TRANSACTION_ID | int | NOT NULL |
| CREDIT_CARD_ID | int | |
| MERCHANT_NAME | nvarchar(255) | |
| MERCHANT_CITY | nvarchar(255) | |
| MERCHANT_STATE | nvarchar(255) | |
| MERCHANT_COUNTRY | nvarchar(255) | |
| MERCHANT_GIVEN_SIC_CODE | nvarchar(20) | |
| MERCHANT_STD_SIC_CODE | nvarchar(20) | |
| MERCHANT_VAT_NUMBER | nchar(20) | |
| VENDOR_NAME | nvarchar(255) | |
| TRANSACTION_REFERENCE | nvarchar(255) | |
| TRANSACTION_TYPE | smallint | |
| DUE_CC_CO_AMOUNT | numeric(28,10) | |
| DUE_CC_CO_AMOUNT_CURRENCY | nchar(3) | |
| POSTING_DATE | datetime | |
| TRANSACTION_DATE | datetime | |
| VAT_AMOUNT | numeric(28,10) | |
| VAT_AMOUNT_CURRENCY | nchar(3) | |
| TRANSACTION_AMOUNT | numeric(28,10) | |
| TRANSACTION_AMOUNT_CURRENCY | nchar(3) | |
| TRANSACTION_STATUS | int | |
| IMPORT_DATE | datetime | |
| DOCUMENT_ID | int | |
| AIRLINE_DEPARTURE_DATE | datetime | |
| AIRLINE_ROUTING | nvarchar(255) | |
| AIRLINE_CLASS_OF_SERVICE | nvarchar(20) | |
| AIRLINE_TRAVEL_AGENCY | nvarchar(45) | |
| AIRLINE_TICKET_NUMBER | nvarchar(20) | |
| CAR_RENTAL_AGREEMENT_NUMBER | nvarchar(30) | |
| HOTEL_ARRIVAL_DATE | datetime | |
| HOTEL_DEPARTURE_DATE | datetime | |
| HOTEL_STAY_DURATION | int | |
| HOTEL_FOLIO_REF_NUMBER | nvarchar(30) | |
| HOTEL_ROOM_TYPE | nvarchar(30) | |
| HOTEL_ROOM_AMOUNT | numeric(28,10) | |
| HOTEL_CURRENCY | nchar(3) | |
| HOTEL_ROOM_TAX_1 | numeric(28,10) | |
| HOTEL_ROOM_TAX_2 | numeric(28,10) | |
| HOTEL_PHONE_AMOUNT | numeric(28,10) | |
| HOTEL_PHONE_TAX_1 | numeric(28,10) | |
| HOTEL_PHONE_TAX_2 | numeric(28,10) | |
| HOTEL_RESTAURANT_AMOUNT | numeric(28,10) | |
| HOTEL_RESTAURANT_TAX_1 | numeric(28,10) | |
| HOTEL_RESTAURANT_TAX_2 | numeric(28,10) | |
| HOTEL_ROOM_SERVICE_AMOUNT | numeric(28,10) | |
| HOTEL_ROOM_SERVICE_TAX_1 | numeric(28,10) | |
| HOTEL_ROOM_SERVICE_TAX_2 | numeric(28,10) | |
| HOTEL_TIP_AMOUNT_1 | numeric(28,10) | |
| HOTEL_TIP_AMOUNT_2 | numeric(28,10) | |
| HOTEL_OTHERS_AMOUNT | numeric(28,10) | |
| HOTEL_OTHERS_TAX_1 | numeric(28,10) | |
| HOTEL_OTHERS_TAX_2 | numeric(28,10) | |
| HOTEL_ROOM_RATE | numeric(28,10) | |
| HOTEL_ROOM_TAX_DAILY | numeric(28,10) | |
| HOTEL_LAUNDRY_AMOUNT | numeric(28,10) | |
| HOTEL_GIFT_SHOP_AMOUNT | numeric(28,10) | |
| HOTEL_MOVIE_AMOUNT | numeric(28,10) | |
| HOTEL_BUS_CENTER_AMOUNT | numeric(28,10) | |
| HOTEL_HEALTH_CLUB_AMOUNT | numeric(28,10) | |
| HOTEL_TOTAL_TAX | numeric(28,10) | |
| ORIGIN_AIRPORT | nvarchar(10) | |
| DESTINATION_AIRPORT | nvarchar(10) | |
| CHANGE_TIMESTAMP | datetime | |
| TRANSACTION_DESCRIPTION | nvarchar(255) | |
| TRANSACTION_STATUS_INT | int | |
| TRANSACTION_SEQUENCE_NUM | int | |
| TRANSACTION_STATEMENT_DATE | datetime | |
| PRIMARY_ISO_CURRENCY_CODE | nchar(3) | |
| MARKET_CODE | nvarchar(50) | |
| GLOBAL_CLIENT_ORIGIN_ID | nvarchar(50) | |
| LOCAL_COUNTRY_ISO_CODE | nchar(3) | |
| TRANSACTION_TYPE_CODE | nvarchar(10) | |
| TAX1 | numeric(28,10) | |
| TAX1_CURRENCY | nchar(3) | |
| TAX2 | numeric(28,10) | |
| TAX2_CURRENCY | nchar(3) | |
| TAX1_INCLUDED | smallint | |
| TAX2_INCLUDED | smallint | |
| MERCHANT_ADDRESS | nvarchar(255) | |
| ASSIGNED_TRANSACTION_USER_ID | int | |
| SOURCE_TRANSACTION_ID | int | |
| BILLING_PERIOD | int | |
| CONSTRAINT PK30 PRIMARY KEY CLUSTERED ( CREDIT_CARD_TRANSACTION_ID ) | ||
| ) | ||
| go | ||
| CREATE TABLE EXPENSE_REPORT_LINE_ITEM ( | ||
|---|---|---|
| LINE_ITEM_ID | int | NOT NULL |
| DOCUMENT_ID | int | NOT NULL |
| PAYMENT_TYPE_ID | int | |
| EXPENSE_TYPE_ID | int | |
| VENDOR_NAME | nvarchar(255) | |
| VENDOR_GIVEN_SIC_CODE | nvarchar(255) | |
| VENDOR_CHAIN_CODE | nchar(20) | |
| VENDOR_CREATOR_USER_ID | int | |
| CREDIT_CARD_TRANSACTION_ID | int | |
| LINE_ITEM_DATE | datetime | |
| DESCRIPTION | nvarchar(255) | |
| TRANSACTION_AMT | numeric(28,10) | |
| TRANSACTION_AMT_CURRENCY | nchar(3) | |
| PAID_IN_AMT | numeric(28,10) | |
| PAID_IN_AMT_CURRENCY | nchar(3) | |
| EXCHANGE_RATE | numeric(28,10) | |
| PURPOSE | nvarchar(255) | |
| PURPOSE_CREATOR_ID | int | |
| MILES | numeric(15,5) | |
| MILEAGE_RATE | float | |
| GL_CODE | nchar(20) | |
| APPROVED_AMT | numeric(28,10) | |
| APPROVED_AMT_CURRENCY | nchar(3) | |
| IS_OVERRIDDEN | smallint | |
| HAS_RECEIPT | smallint | |
| HAVE_RECEIPTS_BEEN_CHECKED | smallint | |
| IS_APPROVED | smallint | |
| LOCATION_ID | int | |
| IS_PERSONAL | smallint | |
| APPROVED_EXCHANGE_RATE | numeric(28,10) | |
| DEPARTURE_DATE | datetime | |
| ORIGIN_AIRPORT | nvarchar(10) | |
| DESTINATION_AIRPORT | nvarchar(10) | |
| BOOKING_AGENT_NAME | nvarchar(50) | |
| TICKET_STATUS | nvarchar(255) | |
| TICKET_NUMBER | nvarchar(50) | |
| CAR_RENTAL_AGREEMENT | nvarchar(50) | |
| AIRLINE_CLASS_OF_SERVICE_CODE | nvarchar(4) | |
| AIRLINE_CLASS_OF_SERVICE | nvarchar(255) | |
| CAR_CLASS_OF_SERVICE_CODE | nvarchar(4) | |
| CAR_CLASS_OF_SERVICE | nvarchar(255) | |
| HOTEL_CLASS_OF_SERVICE_CODE | nvarchar(4) | |
| HOTEL_CLASS_OF_SERVICE | nvarchar(255) | |
| BREAKFAST_DEDUCTION | smallint | |
| LUNCH_DEDUCTION | smallint | |
| DINNER_DEDUCTION | smallint | |
| FIRST_DAY_DEDUCTION | smallint | |
| LAST_DAY_DEDUCTION | smallint | |
| OVERNIGHT_STAY_DEDUCTION | smallint | |
| LONG_TERM_STAY_DEDUCTION | smallint | |
| NUMBER_OF_GUESTS | int | |
| ODOMETER_START | numeric(15,5) | |
| ODOMETER_END | numeric(15,5) | |
| PERDIEM_AMOUNT | numeric(28,10) | |
| PERDIEM_AMOUNT_CURRENCY | nchar(3) | |
| CHANGE_TIMESTAMP | datetime | |
| ITEMIZATION_PARENT_ID | int | |
| ITEMIZATION_STATE | smallint | NOT NULL |
| MANUAL_FOLIO_ITEMIZATION | smallint | |
| NUMBER_OF_PASSENGERS | int | |
| FLEX_FIELD_STRING_1 | nvarchar(255) | |
| FLEX_FIELD_STRING_2 | nvarchar(255) | |
| FLEX_FIELD_STRING_3 | nvarchar(255) | |
| FLEX_FIELD_STRING_4 | nvarchar(255) | |
| FLEX_FIELD_INTEGER_1 | int | |
| FLEX_FIELD_INTEGER_2 | int | |
| FLEX_FIELD_DATE_1 | datetime | |
| FLEX_FIELD_DATE_2 | datetime | |
| FLEX_FIELD_AMOUNT_1 | numeric(28,10) | |
| FLEX_FIELD_AMOUNT_1_CURRENCY | nchar(3) | |
| FLEX_FIELD_AMOUNT_2 | numeric(28,10) | |
| FLEX_FIELD_AMOUNT_2_CURRENCY | nchar(3) | |
| FLEX_FIELD_LOCATION_1_ID | int | |
| FLEX_FIELD_DDLB_1_CODE | nvarchar(255) | |
| FLEX_FIELD_DDLB_2_CODE | nvarchar(255) | |
| FLEX_FIELD_DDLB_3_CODE | nvarchar(255) | |
| FLEX_FIELD_DDLB_4_CODE | nvarchar(255) | |
| FLEX_FIELD_DDLB_5_CODE | nvarchar(255) | |
| OPTIONAL_DEDUCTION_1 | nvarchar(255) | |
| OPTIONAL_DEDUCTION_2 | nvarchar(255) | |
| OPTIONAL_DEDUCTION_3 | nvarchar(255) | |
| OPTIONAL_DEDUCTION_4 | nvarchar(255) | |
| OPTIONAL_DEDUCTION_5 | nvarchar(255) | |
| RECURRING_ID | int | |
| RECURRING_COUNT | int | |
| MILEAGE_ROUTE_ID | int | |
| GUEST_NO_SHOW_COUNT | int | |
| PASSENGER_NAME | nvarchar(255) | |
| AIRLINE_DOMESTIC_OR_INTL | int | |
| COMMUTE_MILES | numeric(26,16) | |
| CREATOR_CLIENT_TYPE | int | |
| MILEAGE_RATE_DESCRIPTION | nvarchar(40) | |
| END_DATE | datetime | |
| EXPORT_STATUS | int | |
| VOID_STATUS | int | |
| REVERSAL_LINE_ITEM_ID | int | |
| FLEX_FIELD_DDLB_1_VALUE | nvarchar(255) | |
| FLEX_FIELD_DDLB_2_VALUE | nvarchar(255) | |
| FLEX_FIELD_DDLB_3_VALUE | nvarchar(255) | |
| FLEX_FIELD_DDLB_4_VALUE | nvarchar(255) | |
| FLEX_FIELD_DDLB_5_VALUE | nvarchar(255) | |
| BILLING_PERIOD | int | |
| CONSTRAINT PK7 PRIMARY KEY CLUSTERED ( LINE_ITEM_ID ) | ||
| ) | ||
| go | ||