eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AP.AP_CREDIT_CARD_TRXNS_ALL#

Object Details

Object Name:	AP_CREDIT_CARD_TRXNS_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

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

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AP.AP_CREDIT_CARD_TRXNS_ALL# references the following:

AP: AP_CREDIT_CARD_TRXNS_ALL

AP.AP_CREDIT_CARD_TRXNS_ALL# is referenced by following:

APPS: AP_CREDIT_CARD_TRXNS; AP_CREDIT_CARD_TRXNS_ALL