EXP_BATCH_ID |
ColumnName | EXP_BATCH_ID |
Definition |
EXP_BATCH_TYPE_CD |
ColumnName | EXP_BATCH_TYPE_CD |
Definition |
TRANSACTION_ID |
ColumnName | TRANSACTION_ID |
Definition |
EMPL_ID |
ColumnName | EMPL_ID |
Definition |
S_TYPE_CD |
ColumnName | S_TYPE_CD |
Definition |
EXPENSE_DT |
ColumnName | EXPENSE_DT |
Definition |
PROVIDER_CD |
ColumnName | PROVIDER_CD |
Definition |
MERCHANT_NAME |
ColumnName | MERCHANT_NAME |
Definition |
TICKET_NUMBER_S |
ColumnName | TICKET_NUMBER_S |
Definition |
DEPARTURE_DTT |
ColumnName | DEPARTURE_DTT |
Definition |
RETURN_DTT |
ColumnName | RETURN_DTT |
Definition |
UNIT_NO |
ColumnName | UNIT_NO |
Definition |
PAY_METHOD_CD |
ColumnName | PAY_METHOD_CD |
Definition |
TRANS_CURRENCY_CD |
ColumnName | TRANS_CURRENCY_CD |
Definition |
TRANS_BASE_EXCHANGE_RATE |
ColumnName | TRANS_BASE_EXCHANGE_RATE |
Definition |
TRANS_UNIT_RATE |
ColumnName | TRANS_UNIT_RATE |
Definition |
TRANS_DAILY_ROOM_RATE |
ColumnName | TRANS_DAILY_ROOM_RATE |
Definition |
TRANS_DAILY_TAX_RATE |
ColumnName | TRANS_DAILY_TAX_RATE |
Definition |
TRANS_INCURRED_AMT |
ColumnName | TRANS_INCURRED_AMT |
Definition |
TRANS_TAX_AMT |
ColumnName | TRANS_TAX_AMT |
Definition |
START_DT |
ColumnName | START_DT |
Definition |
END_DT |
ColumnName | END_DT |
Definition |
DAYS_NIGHTS_NO |
ColumnName | DAYS_NIGHTS_NO |
Definition |
ITINERARY_TEXT |
ColumnName | ITINERARY_TEXT |
Definition |
COMMENTS_TEXT |
ColumnName | COMMENTS_TEXT |
Definition |
FILTERED_FL |
ColumnName | FILTERED_FL |
Definition |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition |
ROWVERSION |
ColumnName | ROWVERSION |
Definition |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition |
EMPL_IDENTIFIER_S |
ColumnName | EMPL_IDENTIFIER_S |
Definition |
PROVIDER_IDENTIFIER_S |
ColumnName | PROVIDER_IDENTIFIER_S |
Definition |
LOCATION1_S |
ColumnName | LOCATION1_S |
Definition |
LOCATION2_S |
ColumnName | LOCATION2_S |
Definition |
EMPLOYEE_NAME |
ColumnName | EMPLOYEE_NAME |
Definition |
GHOST_CARD_FL |
ColumnName | GHOST_CARD_FL |
Definition |
PERSONAL_FL |
ColumnName | PERSONAL_FL |
Definition |
VISA_EMPL_ID_S |
ColumnName | VISA_EMPL_ID_S |
Definition |
VISA_ACCOUNT_ID_S |
ColumnName | VISA_ACCOUNT_ID_S |
Definition |
VISA_ACCOUNT_ID_LAST4_S |
ColumnName | VISA_ACCOUNT_ID_LAST4_S |
Definition |
VISA_EFFECTIVE_DT |
ColumnName | VISA_EFFECTIVE_DT |
Definition |
TRANS_PAY_EXCHANGE_RATE |
ColumnName | TRANS_PAY_EXCHANGE_RATE |
Definition |
PAY_CURRENCY_CD |
ColumnName | PAY_CURRENCY_CD |
Definition |
DUE_DTT |
ColumnName | DUE_DTT |
Definition |
DUP_CHK_FL |
ColumnName | DUP_CHK_FL |
Definition |
ACCT_NAME |
ColumnName | ACCT_NAME |
Definition |
MERCHANT_LONG_NAME |
ColumnName | MERCHANT_LONG_NAME |
Definition |
MERCHANT_ADDR1_S |
ColumnName | MERCHANT_ADDR1_S |
Definition |
MERCHANT_ADDR2_S |
ColumnName | MERCHANT_ADDR2_S |
Definition |
MERCHANT_CITY_NAME |
ColumnName | MERCHANT_CITY_NAME |
Definition |
MERCHANT_STATE_NAME |
ColumnName | MERCHANT_STATE_NAME |
Definition |
MERCHANT_ZIPCODE |
ColumnName | MERCHANT_ZIPCODE |
Definition |
MERCHANT_COUNTRY_CD |
ColumnName | MERCHANT_COUNTRY_CD |
Definition |
MERCHANT_COUNTRY_NAME |
ColumnName | MERCHANT_COUNTRY_NAME |
Definition |
SIC_CD |
ColumnName | SIC_CD |
Definition |
SIC_DESC |
ColumnName | SIC_DESC |
Definition |
NAICS_CD |
ColumnName | NAICS_CD |
Definition |
NAICS_DESC |
ColumnName | NAICS_DESC |
Definition |
RENTAL_CLASS_CD |
ColumnName | RENTAL_CLASS_CD |
Definition |
RENTAL_CLASS_DESC |
ColumnName | RENTAL_CLASS_DESC |
Definition |
TRANS_INSURANCE_AMT |
ColumnName | TRANS_INSURANCE_AMT |
Definition |
TRANS_DROPOFF_AMT |
ColumnName | TRANS_DROPOFF_AMT |
Definition |
TRANS_EXTRA_MILEAGE_AMT |
ColumnName | TRANS_EXTRA_MILEAGE_AMT |
Definition |
TRANS_FUEL_AMT |
ColumnName | TRANS_FUEL_AMT |
Definition |
TRANS_TOWING_AMT |
ColumnName | TRANS_TOWING_AMT |
Definition |
TRANS_OTHER_AMT |
ColumnName | TRANS_OTHER_AMT |
Definition |
TRANS_TELEPHONE_AMT |
ColumnName | TRANS_TELEPHONE_AMT |
Definition |
TRANS_FOOD_BEVERAGE_AMT |
ColumnName | TRANS_FOOD_BEVERAGE_AMT |
Definition |
TRANS_PREPAID_AMT |
ColumnName | TRANS_PREPAID_AMT |
Definition |
TRANS_CASH_ADVANCE_AMT |
ColumnName | TRANS_CASH_ADVANCE_AMT |
Definition |
TRANS_VALET_PARKING_AMT |
ColumnName | TRANS_VALET_PARKING_AMT |
Definition |
TRANS_MINI_BAR_AMT |
ColumnName | TRANS_MINI_BAR_AMT |
Definition |
TRANS_LAUNDRY_AMT |
ColumnName | TRANS_LAUNDRY_AMT |
Definition |
TRANS_GIFT_SHOP_PURCHASES_AMT |
ColumnName | TRANS_GIFT_SHOP_PURCHASES_AMT |
Definition |
TRANS_MOVIE_AMT |
ColumnName | TRANS_MOVIE_AMT |
Definition |
TRANS_BUSINESS_CENTER_AMT |
ColumnName | TRANS_BUSINESS_CENTER_AMT |
Definition |
TRANS_HEALTH_CLUB_AMT |
ColumnName | TRANS_HEALTH_CLUB_AMT |
Definition |
HOTEL_FOLIO_NO |
ColumnName | HOTEL_FOLIO_NO |
Definition |
INVOICE_NO |
ColumnName | INVOICE_NO |
Definition |
TRANS_TIP_AMT |
ColumnName | TRANS_TIP_AMT |
Definition |
TRANS_UNALLOWABLE_AMT |
ColumnName | TRANS_UNALLOWABLE_AMT |
Definition |
SUPPLIER_VAT_NO |
ColumnName | SUPPLIER_VAT_NO |
Definition |
SUPPLIER_ORDER_NO |
ColumnName | SUPPLIER_ORDER_NO |
Definition |
CUSTOMER_VAT_NO |
ColumnName | CUSTOMER_VAT_NO |
Definition |
TRANS_VAT_AMT |
ColumnName | TRANS_VAT_AMT |
Definition |
TRANS_PST_HST_AMT |
ColumnName | TRANS_PST_HST_AMT |
Definition |
EXCHANGE_TICKET_NO |
ColumnName | EXCHANGE_TICKET_NO |
Definition |
TRANS_EXCHANGE_TICKET_AMT |
ColumnName | TRANS_EXCHANGE_TICKET_AMT |
Definition |
TRANS_VAT_RATE |
ColumnName | TRANS_VAT_RATE |
Definition |
TRANS_VAT_RECLAIM_RATE |
ColumnName | TRANS_VAT_RECLAIM_RATE |
Definition |
MERCHANT_TAX_ID |
ColumnName | MERCHANT_TAX_ID |
Definition |
MERCHANT_CATEGORY_CD |
ColumnName | MERCHANT_CATEGORY_CD |
Definition |
TRANS_FARE_AMT |
ColumnName | TRANS_FARE_AMT |
Definition |
TRANS_FEE_AMT |
ColumnName | TRANS_FEE_AMT |
Definition |
TRANS_DEPARTURE_TAX_AMT |
ColumnName | TRANS_DEPARTURE_TAX_AMT |
Definition |