Version 10.2.11
Modifications in Expense Management 10.2.11
| 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 | |
| CONSTRAINT PK30 PRIMARY KEY CLUSTERED ( CREDIT_CARD_TRANSACTION_ID ) ) | ||