VIEW: AP.AP_CREDIT_CARD_TRXNS_ARC#

Source

View Text - Preformatted

select ARC_REQ_ID ARC_REQ_ID, ARCHIVE_DATE ARCHIVE_DATE, TRX_ID TRX_ID, VALIDATE_CODE VALIDATE_CODE, CARD_PROGRAM_ID CARD_PROGRAM_ID, EXPENSED_AMOUNT EXPENSED_AMOUNT, CARD_NUMBER CARD_NUMBER, REFERENCE_NUMBER REFERENCE_NUMBER, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, DEBIT_FLAG DEBIT_FLAG, BILLED_DATE BILLED_DATE, BILLED_AMOUNT BILLED_AMOUNT, BILLED_DECIMAL BILLED_DECIMAL, BILLED_CURRENCY_CODE BILLED_CURRENCY_CODE, POSTED_DATE POSTED_DATE, POSTED_AMOUNT POSTED_AMOUNT, POSTED_DECIMAL POSTED_DECIMAL, POSTED_CURRENCY_CODE POSTED_CURRENCY_CODE, CURRENCY_CONVERSION_EXPONENT CURRENCY_CONVERSION_EXPONENT, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, MIS_INDUSTRY_CODE MIS_INDUSTRY_CODE, SIC_CODE SIC_CODE, MERCHANT_TAX_ID MERCHANT_TAX_ID, MERCHANT_REFERENCE MERCHANT_REFERENCE, MERCHANT_NAME1#1 MERCHANT_NAME1, MERCHANT_NAME2 MERCHANT_NAME2, MERCHANT_ADDRESS1 MERCHANT_ADDRESS1, MERCHANT_ADDRESS2 MERCHANT_ADDRESS2, MERCHANT_ADDRESS3 MERCHANT_ADDRESS3, MERCHANT_ADDRESS4 MERCHANT_ADDRESS4, MERCHANT_CITY MERCHANT_CITY, MERCHANT_PROVINCE_STATE MERCHANT_PROVINCE_STATE, MERCHANT_POSTAL_CODE MERCHANT_POSTAL_CODE, MERCHANT_COUNTRY MERCHANT_COUNTRY, TOTAL_TAX TOTAL_TAX, LOCAL_TAX LOCAL_TAX, NATIONAL_TAX NATIONAL_TAX, OTHER_TAX OTHER_TAX, ORG_ID ORG_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, FOLIO_TYPE FOLIO_TYPE, ATM_CASH_ADVANCE ATM_CASH_ADVANCE, ATM_TRANSACTION_DATE ATM_TRANSACTION_DATE, ATM_FEE_AMOUNT ATM_FEE_AMOUNT, ATM_TYPE ATM_TYPE, ATM_ID ATM_ID, ATM_NETWORK_ID ATM_NETWORK_ID, RESTAURANT_FOOD_AMOUNT RESTAURANT_FOOD_AMOUNT, RESTAURANT_BEVERAGE_AMOUNT RESTAURANT_BEVERAGE_AMOUNT, RESTAURANT_TIP_AMOUNT RESTAURANT_TIP_AMOUNT, CAR_RENTAL_DATE CAR_RENTAL_DATE, CAR_RETURN_DATE CAR_RETURN_DATE, CAR_RENTAL_LOCATION CAR_RENTAL_LOCATION, CAR_RENTAL_STATE CAR_RENTAL_STATE, CAR_RETURN_LOCATION CAR_RETURN_LOCATION, CAR_RETURN_STATE CAR_RETURN_STATE, CAR_RENTER_NAME#1 CAR_RENTER_NAME, CAR_RENTAL_DAYS CAR_RENTAL_DAYS, CAR_RENTAL_AGREEMENT_NUMBER CAR_RENTAL_AGREEMENT_NUMBER, CAR_CLASS CAR_CLASS, CAR_TOTAL_MILEAGE CAR_TOTAL_MILEAGE, CAR_GAS_AMOUNT CAR_GAS_AMOUNT, CAR_INSURANCE_AMOUNT CAR_INSURANCE_AMOUNT, CAR_MILEAGE_AMOUNT CAR_MILEAGE_AMOUNT, CAR_DAILY_RATE CAR_DAILY_RATE, HOTEL_ARRIVAL_DATE HOTEL_ARRIVAL_DATE, HOTEL_DEPART_DATE HOTEL_DEPART_DATE, HOTEL_CHARGE_DESC HOTEL_CHARGE_DESC, HOTEL_GUEST_NAME HOTEL_GUEST_NAME, HOTEL_STAY_DURATION HOTEL_STAY_DURATION, HOTEL_ROOM_RATE HOTEL_ROOM_RATE, HOTEL_NO_SHOW_FLAG HOTEL_NO_SHOW_FLAG, HOTEL_ROOM_AMOUNT HOTEL_ROOM_AMOUNT, HOTEL_TELEPHONE_AMOUNT HOTEL_TELEPHONE_AMOUNT, HOTEL_ROOM_TAX HOTEL_ROOM_TAX, HOTEL_BAR_AMOUNT HOTEL_BAR_AMOUNT, HOTEL_MOVIE_AMOUNT HOTEL_MOVIE_AMOUNT, HOTEL_GIFT_SHOP_AMOUNT HOTEL_GIFT_SHOP_AMOUNT, HOTEL_LAUNDRY_AMOUNT HOTEL_LAUNDRY_AMOUNT, HOTEL_HEALTH_AMOUNT HOTEL_HEALTH_AMOUNT, HOTEL_RESTAURANT_AMOUNT HOTEL_RESTAURANT_AMOUNT, HOTEL_BUSINESS_AMOUNT HOTEL_BUSINESS_AMOUNT, HOTEL_PARKING_AMOUNT HOTEL_PARKING_AMOUNT, HOTEL_ROOM_SERVICE_AMOUNT HOTEL_ROOM_SERVICE_AMOUNT, HOTEL_TIP_AMOUNT HOTEL_TIP_AMOUNT, HOTEL_MISC_AMOUNT HOTEL_MISC_AMOUNT, HOTEL_CITY HOTEL_CITY, HOTEL_STATE HOTEL_STATE, HOTEL_FOLIO_NUMBER HOTEL_FOLIO_NUMBER, HOTEL_ROOM_TYPE HOTEL_ROOM_TYPE, AIR_DEPARTURE_DATE AIR_DEPARTURE_DATE, AIR_DEPARTURE_CITY AIR_DEPARTURE_CITY, AIR_ROUTING AIR_ROUTING, AIR_ARRIVAL_CITY AIR_ARRIVAL_CITY, AIR_STOPOVER_FLAG AIR_STOPOVER_FLAG, AIR_BASE_FARE_AMOUNT AIR_BASE_FARE_AMOUNT, AIR_FARE_BASIS_CODE AIR_FARE_BASIS_CODE, AIR_SERVICE_CLASS AIR_SERVICE_CLASS, AIR_CARRIER_ABBREVIATION AIR_CARRIER_ABBREVIATION, AIR_CARRIER_CODE AIR_CARRIER_CODE, AIR_TICKET_ISSUER#1 AIR_TICKET_ISSUER, AIR_ISSUER_CITY AIR_ISSUER_CITY, AIR_PASSENGER_NAME AIR_PASSENGER_NAME, AIR_REFUND_TICKET_NUMBER AIR_REFUND_TICKET_NUMBER, AIR_EXCHANGED_TICKET_NUMBER AIR_EXCHANGED_TICKET_NUMBER, AIR_AGENCY_NUMBER AIR_AGENCY_NUMBER, AIR_TICKET_NUMBER AIR_TICKET_NUMBER, FINANCIAL_CATEGORY FINANCIAL_CATEGORY, PAYMENT_FLAG PAYMENT_FLAG, RECORD_TYPE RECORD_TYPE, MERCHANT_ACTIVITY MERCHANT_ACTIVITY, CATEGORY CATEGORY, REPORT_HEADER_ID REPORT_HEADER_ID, EXPENSE_STATUS EXPENSE_STATUS, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID, INACTIVE_EMP_WF_ITEM_KEY INACTIVE_EMP_WF_ITEM_KEY, LOCATION_ID LOCATION_ID, REQUEST_ID REQUEST_ID, MERCHANT_COUNTRY_CODE MERCHANT_COUNTRY_CODE, DISPUTE_DATE DISPUTE_DATE, PAYMENT_DUE_FROM_CODE PAYMENT_DUE_FROM_CODE, TRX_AVAILABLE_DATE TRX_AVAILABLE_DATE, CARD_ACCEPTOR_ID CARD_ACCEPTOR_ID, TRXN_DETAIL_FLAG TRXN_DETAIL_FLAG, CARD_ID CARD_ID, DESCRIPTION DESCRIPTION, COMPANY_NUMBER COMPANY_NUMBER, MARKET_CODE MARKET_CODE, VALIDATE_REQUEST_ID VALIDATE_REQUEST_ID, CUSTOMER_CODE CUSTOMER_CODE, PURCHASE_IDENTIFICATION PURCHASE_IDENTIFICATION, FUEL_TYPE FUEL_TYPE, FUEL_UOM_CODE FUEL_UOM_CODE, FUEL_QUANTITY FUEL_QUANTITY, FUEL_UNIT_PRICE FUEL_UNIT_PRICE, FUEL_SALE_AMOUNT FUEL_SALE_AMOUNT, NON_FUEL_SALE_AMOUNT NON_FUEL_SALE_AMOUNT, FLEET_IDENTITY_CODE FLEET_IDENTITY_CODE, AIR_AGENCY_NAME AIR_AGENCY_NAME, AIR_TOTAL_LEGS AIR_TOTAL_LEGS, CUSTOMER_DATA1 CUSTOMER_DATA1, CUSTOMER_DATA2 CUSTOMER_DATA2, CUSTOMER_DATA3 CUSTOMER_DATA3, CUSTOMER_DATA4 CUSTOMER_DATA4, CUSTOMER_DATA5 CUSTOMER_DATA5, CUSTOMER_DATA6 CUSTOMER_DATA6, CUSTOMER_DATA7 CUSTOMER_DATA7, CUSTOMER_DATA8 CUSTOMER_DATA8, CUSTOMER_DATA9 CUSTOMER_DATA9, CUSTOMER_DATA10 CUSTOMER_DATA10 from "AP"."AP_CREDIT_CARD_TRXNS_ARC"

View Text - HTML Formatted

SELECT ARC_REQ_ID ARC_REQ_ID
, ARCHIVE_DATE ARCHIVE_DATE
, TRX_ID TRX_ID
, VALIDATE_CODE VALIDATE_CODE
, CARD_PROGRAM_ID CARD_PROGRAM_ID
, EXPENSED_AMOUNT EXPENSED_AMOUNT
, CARD_NUMBER CARD_NUMBER
, REFERENCE_NUMBER REFERENCE_NUMBER
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, DEBIT_FLAG DEBIT_FLAG
, BILLED_DATE BILLED_DATE
, BILLED_AMOUNT BILLED_AMOUNT
, BILLED_DECIMAL BILLED_DECIMAL
, BILLED_CURRENCY_CODE BILLED_CURRENCY_CODE
, POSTED_DATE POSTED_DATE
, POSTED_AMOUNT POSTED_AMOUNT
, POSTED_DECIMAL POSTED_DECIMAL
, POSTED_CURRENCY_CODE POSTED_CURRENCY_CODE
, CURRENCY_CONVERSION_EXPONENT CURRENCY_CONVERSION_EXPONENT
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, MIS_INDUSTRY_CODE MIS_INDUSTRY_CODE
, SIC_CODE SIC_CODE
, MERCHANT_TAX_ID MERCHANT_TAX_ID
, MERCHANT_REFERENCE MERCHANT_REFERENCE
, MERCHANT_NAME1#1 MERCHANT_NAME1
, MERCHANT_NAME2 MERCHANT_NAME2
, MERCHANT_ADDRESS1 MERCHANT_ADDRESS1
, MERCHANT_ADDRESS2 MERCHANT_ADDRESS2
, MERCHANT_ADDRESS3 MERCHANT_ADDRESS3
, MERCHANT_ADDRESS4 MERCHANT_ADDRESS4
, MERCHANT_CITY MERCHANT_CITY
, MERCHANT_PROVINCE_STATE MERCHANT_PROVINCE_STATE
, MERCHANT_POSTAL_CODE MERCHANT_POSTAL_CODE
, MERCHANT_COUNTRY MERCHANT_COUNTRY
, TOTAL_TAX TOTAL_TAX
, LOCAL_TAX LOCAL_TAX
, NATIONAL_TAX NATIONAL_TAX
, OTHER_TAX OTHER_TAX
, ORG_ID ORG_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, FOLIO_TYPE FOLIO_TYPE
, ATM_CASH_ADVANCE ATM_CASH_ADVANCE
, ATM_TRANSACTION_DATE ATM_TRANSACTION_DATE
, ATM_FEE_AMOUNT ATM_FEE_AMOUNT
, ATM_TYPE ATM_TYPE
, ATM_ID ATM_ID
, ATM_NETWORK_ID ATM_NETWORK_ID
, RESTAURANT_FOOD_AMOUNT RESTAURANT_FOOD_AMOUNT
, RESTAURANT_BEVERAGE_AMOUNT RESTAURANT_BEVERAGE_AMOUNT
, RESTAURANT_TIP_AMOUNT RESTAURANT_TIP_AMOUNT
, CAR_RENTAL_DATE CAR_RENTAL_DATE
, CAR_RETURN_DATE CAR_RETURN_DATE
, CAR_RENTAL_LOCATION CAR_RENTAL_LOCATION
, CAR_RENTAL_STATE CAR_RENTAL_STATE
, CAR_RETURN_LOCATION CAR_RETURN_LOCATION
, CAR_RETURN_STATE CAR_RETURN_STATE
, CAR_RENTER_NAME#1 CAR_RENTER_NAME
, CAR_RENTAL_DAYS CAR_RENTAL_DAYS
, CAR_RENTAL_AGREEMENT_NUMBER CAR_RENTAL_AGREEMENT_NUMBER
, CAR_CLASS CAR_CLASS
, CAR_TOTAL_MILEAGE CAR_TOTAL_MILEAGE
, CAR_GAS_AMOUNT CAR_GAS_AMOUNT
, CAR_INSURANCE_AMOUNT CAR_INSURANCE_AMOUNT
, CAR_MILEAGE_AMOUNT CAR_MILEAGE_AMOUNT
, CAR_DAILY_RATE CAR_DAILY_RATE
, HOTEL_ARRIVAL_DATE HOTEL_ARRIVAL_DATE
, HOTEL_DEPART_DATE HOTEL_DEPART_DATE
, HOTEL_CHARGE_DESC HOTEL_CHARGE_DESC
, HOTEL_GUEST_NAME HOTEL_GUEST_NAME
, HOTEL_STAY_DURATION HOTEL_STAY_DURATION
, HOTEL_ROOM_RATE HOTEL_ROOM_RATE
, HOTEL_NO_SHOW_FLAG HOTEL_NO_SHOW_FLAG
, HOTEL_ROOM_AMOUNT HOTEL_ROOM_AMOUNT
, HOTEL_TELEPHONE_AMOUNT HOTEL_TELEPHONE_AMOUNT
, HOTEL_ROOM_TAX HOTEL_ROOM_TAX
, HOTEL_BAR_AMOUNT HOTEL_BAR_AMOUNT
, HOTEL_MOVIE_AMOUNT HOTEL_MOVIE_AMOUNT
, HOTEL_GIFT_SHOP_AMOUNT HOTEL_GIFT_SHOP_AMOUNT
, HOTEL_LAUNDRY_AMOUNT HOTEL_LAUNDRY_AMOUNT
, HOTEL_HEALTH_AMOUNT HOTEL_HEALTH_AMOUNT
, HOTEL_RESTAURANT_AMOUNT HOTEL_RESTAURANT_AMOUNT
, HOTEL_BUSINESS_AMOUNT HOTEL_BUSINESS_AMOUNT
, HOTEL_PARKING_AMOUNT HOTEL_PARKING_AMOUNT
, HOTEL_ROOM_SERVICE_AMOUNT HOTEL_ROOM_SERVICE_AMOUNT
, HOTEL_TIP_AMOUNT HOTEL_TIP_AMOUNT
, HOTEL_MISC_AMOUNT HOTEL_MISC_AMOUNT
, HOTEL_CITY HOTEL_CITY
, HOTEL_STATE HOTEL_STATE
, HOTEL_FOLIO_NUMBER HOTEL_FOLIO_NUMBER
, HOTEL_ROOM_TYPE HOTEL_ROOM_TYPE
, AIR_DEPARTURE_DATE AIR_DEPARTURE_DATE
, AIR_DEPARTURE_CITY AIR_DEPARTURE_CITY
, AIR_ROUTING AIR_ROUTING
, AIR_ARRIVAL_CITY AIR_ARRIVAL_CITY
, AIR_STOPOVER_FLAG AIR_STOPOVER_FLAG
, AIR_BASE_FARE_AMOUNT AIR_BASE_FARE_AMOUNT
, AIR_FARE_BASIS_CODE AIR_FARE_BASIS_CODE
, AIR_SERVICE_CLASS AIR_SERVICE_CLASS
, AIR_CARRIER_ABBREVIATION AIR_CARRIER_ABBREVIATION
, AIR_CARRIER_CODE AIR_CARRIER_CODE
, AIR_TICKET_ISSUER#1 AIR_TICKET_ISSUER
, AIR_ISSUER_CITY AIR_ISSUER_CITY
, AIR_PASSENGER_NAME AIR_PASSENGER_NAME
, AIR_REFUND_TICKET_NUMBER AIR_REFUND_TICKET_NUMBER
, AIR_EXCHANGED_TICKET_NUMBER AIR_EXCHANGED_TICKET_NUMBER
, AIR_AGENCY_NUMBER AIR_AGENCY_NUMBER
, AIR_TICKET_NUMBER AIR_TICKET_NUMBER
, FINANCIAL_CATEGORY FINANCIAL_CATEGORY
, PAYMENT_FLAG PAYMENT_FLAG
, RECORD_TYPE RECORD_TYPE
, MERCHANT_ACTIVITY MERCHANT_ACTIVITY
, CATEGORY CATEGORY
, REPORT_HEADER_ID REPORT_HEADER_ID
, EXPENSE_STATUS EXPENSE_STATUS
, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID
, INACTIVE_EMP_WF_ITEM_KEY INACTIVE_EMP_WF_ITEM_KEY
, LOCATION_ID LOCATION_ID
, REQUEST_ID REQUEST_ID
, MERCHANT_COUNTRY_CODE MERCHANT_COUNTRY_CODE
, DISPUTE_DATE DISPUTE_DATE
, PAYMENT_DUE_FROM_CODE PAYMENT_DUE_FROM_CODE
, TRX_AVAILABLE_DATE TRX_AVAILABLE_DATE
, CARD_ACCEPTOR_ID CARD_ACCEPTOR_ID
, TRXN_DETAIL_FLAG TRXN_DETAIL_FLAG
, CARD_ID CARD_ID
, DESCRIPTION DESCRIPTION
, COMPANY_NUMBER COMPANY_NUMBER
, MARKET_CODE MARKET_CODE
, VALIDATE_REQUEST_ID VALIDATE_REQUEST_ID
, CUSTOMER_CODE CUSTOMER_CODE
, PURCHASE_IDENTIFICATION PURCHASE_IDENTIFICATION
, FUEL_TYPE FUEL_TYPE
, FUEL_UOM_CODE FUEL_UOM_CODE
, FUEL_QUANTITY FUEL_QUANTITY
, FUEL_UNIT_PRICE FUEL_UNIT_PRICE
, FUEL_SALE_AMOUNT FUEL_SALE_AMOUNT
, NON_FUEL_SALE_AMOUNT NON_FUEL_SALE_AMOUNT
, FLEET_IDENTITY_CODE FLEET_IDENTITY_CODE
, AIR_AGENCY_NAME AIR_AGENCY_NAME
, AIR_TOTAL_LEGS AIR_TOTAL_LEGS
, CUSTOMER_DATA1 CUSTOMER_DATA1
, CUSTOMER_DATA2 CUSTOMER_DATA2
, CUSTOMER_DATA3 CUSTOMER_DATA3
, CUSTOMER_DATA4 CUSTOMER_DATA4
, CUSTOMER_DATA5 CUSTOMER_DATA5
, CUSTOMER_DATA6 CUSTOMER_DATA6
, CUSTOMER_DATA7 CUSTOMER_DATA7
, CUSTOMER_DATA8 CUSTOMER_DATA8
, CUSTOMER_DATA9 CUSTOMER_DATA9
, CUSTOMER_DATA10 CUSTOMER_DATA10
FROM "AP"."AP_CREDIT_CARD_TRXNS_ARC"