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