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

VIEW: APPS.APBV_CREDIT_CARD_TRXNS

Object Details
Object Name: APBV_CREDIT_CARD_TRXNS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.APBV_CREDIT_CARD_TRXNS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Based on AP_CREDIT_CARD_TRXNS_ALL, this business view contains credit card transaction data.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CARD_ID NUMBER (15) Yes ID of credit card
TRX_ID NUMBER (15) Yes Credit card transaction unique identifier
VALIDATE_CODE VARCHAR2 (25) Yes Code resulting from transaction validation
CARD_PROGRAM_ID NUMBER (15) Yes ID of card program
EXPENSED_AMOUNT NUMBER

Amount already submitted for expense reporting
REFERENCE_NUMBER VARCHAR2 (240) Yes Contains a transaction reference number for use in customer inquiries
TRANSACTION_TYPE VARCHAR2 (80)
Type of transaction. Represents a grouping of charge types to facilitate meaningful report charge type consolidation
TRANSACTION_DATE DATE

Date transaction incurred
TRANSACTION_AMOUNT NUMBER

Amount of transaction in billing currency
DEBIT_FLAG VARCHAR2 (1)
Debit/Credit indicator; i.e. T=Debit or F=Credit
BILLED_DATE DATE

Date transaction is billed
BILLED_AMOUNT NUMBER

Original currency amount for the incurred in a foreign country and requires currency conversion
BILLED_DECIMAL NUMBER (1)
Indicates the number of decimal places used to display the billed currency
BILLED_CURRENCY_CODE VARCHAR2 (15)
The ISO code of the currency in which the cardholder is billed
POSTED_DATE DATE

Date transaction is posted to the account
POSTED_AMOUNT NUMBER

Original currency amount for the incurred in a foreign country and requires currency conversion
POSTED_DECIMAL NUMBER (1)
Indicates the number of decimal places used to display the posted currency
POSTED_CURRENCY_CODE VARCHAR2 (15)
The code of the currency in which the cardholder is posted
CURRENCY_CONVERSION_EXPONENT NUMBER (1)
Indicates the number of decimal places needed to display currency
CURRENCY_CONVERSION_RATE NUMBER

The conversion rate used to obtain the posted/billed amount in transaction's original currency
MIS_INDUSTRY_CODE VARCHAR2 (80)
A description corresponding to a merchant's primary business which is associated with an MSC internal code
SIC_CODE NUMBER (15)
Standard Industry Classification code description that permits charges/credits to be categorized into industry types for each transaction
MERCHANT_TAX_ID VARCHAR2 (80)
Taxpayer identifier of the merchant with which employee conducted the transaction
MERCHANT_REFERENCE VARCHAR2 (80)
Provided by the merchant for use in customer inquiries
MERCHANT_NAME1 VARCHAR2 (240)
Name of merchant or establishment - part 1
MERCHANT_NAME2 VARCHAR2 (80)
Name of merchant or establishment - part 2
MERCHANT_ADDRESS1 VARCHAR2 (80)
Address of merchant or establishment - part 1
MERCHANT_ADDRESS2 VARCHAR2 (80)
Address of merchant or establishment - part 2
MERCHANT_ADDRESS3 VARCHAR2 (80)
Address of merchant or establishment - part 3
MERCHANT_ADDRESS4 VARCHAR2 (80)
Address of merchant or establishment - part 4
MERCHANT_CITY VARCHAR2 (80)
City where merchant or establishment is located
MERCHANT_PROVINCE_STATE VARCHAR2 (80)
State or Province where merchant or establishment is located
MERCHANT_POSTAL_CODE VARCHAR2 (80)
Zip or Postal code where merchant or establishment is located
MERCHANT_COUNTRY VARCHAR2 (80)
Country where merchant or establishment is located
TOTAL_TAX NUMBER

The total amount of tax for a transaction
LOCAL_TAX NUMBER

The amount of local tax for a transaction
NATIONAL_TAX NUMBER

The amount of national tax for a transaction
OTHER_TAX NUMBER

Any other tax amount for a transaction
ORG_ID NUMBER (15)
Organization identifier
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
FOLIO_TYPE VARCHAR2 (80)
Identifies the expense type to which the credit card transaction is associated
ATM_CASH_ADVANCE NUMBER

The amount of cash withdrawn from an ATM with a card
ATM_TRANSACTION_DATE DATE

Date on which ATM cash withdrawal took place
ATM_FEE_AMOUNT NUMBER

Transaction fee for ATM withdrawal
ATM_TYPE VARCHAR2 (80)
Identifies Cash Advance or Travelers Checks
ATM_ID VARCHAR2 (80)
Identification of the ATM machine
ATM_NETWORK_ID VARCHAR2 (80)
Identification of the ATM network
RESTAURANT_FOOD_AMOUNT NUMBER

Restaurant Food Amount
RESTAURANT_BEVERAGE_AMOUNT NUMBER

Restaurant Beverage Amount
RESTAURANT_TIP_AMOUNT NUMBER

Restaurant Tip Amount
CAR_RENTAL_DATE DATE

Date the car was first rented
CAR_RETURN_DATE DATE

Date the car was returned
CAR_RENTAL_LOCATION VARCHAR2 (80)
Location where the car was rented
CAR_RENTAL_STATE VARCHAR2 (80)
Car Rental State
CAR_RETURN_LOCATION VARCHAR2 (80)
Car Return Location
CAR_RETURN_STATE VARCHAR2 (80)
Car Return State
CAR_RENTER_NAME VARCHAR2 (240)
Car Renter Name
CAR_RENTAL_DAYS VARCHAR2 (80)
Car Rental Days
CAR_RENTAL_AGREEMENT_NUMBER VARCHAR2 (80)
Number of the car rental agreement on car rental transactions as provided by the card rental company
CAR_CLASS VARCHAR2 (80)
The class of the car rented as provided by the Car Rental Company
CAR_TOTAL_MILEAGE NUMBER

Total number of miles used by the renter
CAR_GAS_AMOUNT NUMBER

Amount paid for gasoline to the Car Rental Company
CAR_INSURANCE_AMOUNT NUMBER

Amount paid for car insurance to the Car Rental Company
CAR_MILEAGE_AMOUNT NUMBER

Amount paid for excess mileage to the Car Rental Company
CAR_DAILY_RATE NUMBER

Daily Rate for Car Rental
HOTEL_ARRIVAL_DATE DATE

Hotel Arrival Date
HOTEL_DEPART_DATE DATE

Hotel Departure Date
HOTEL_CHARGE_DESC VARCHAR2 (80)
Description of hotel charge
HOTEL_GUEST_NAME VARCHAR2 (80)
Name of registered guest at hotel for transaction
HOTEL_STAY_DURATION NUMBER

Number of room nights at hotel
HOTEL_ROOM_RATE NUMBER

Per Night Rate
HOTEL_NO_SHOW_FLAG VARCHAR2 (1)
Indicates whether hotel guest checked-in
HOTEL_ROOM_AMOUNT NUMBER

Room rate for the stay which the hotel submits
HOTEL_TELEPHONE_AMOUNT NUMBER

Hotel Telephone Amounts
HOTEL_ROOM_TAX NUMBER

Amount of tax for hotel room
HOTEL_BAR_AMOUNT NUMBER

Total charges for mini bar expenses paid to the hotel
HOTEL_MOVIE_AMOUNT NUMBER

Total charges for in room movies paid to the hotel
HOTEL_GIFT_SHOP_AMOUNT NUMBER

Total charges for gift shop and merchandise purchases paid to the hotel
HOTEL_LAUNDRY_AMOUNT NUMBER

Total charges for laundry paid to the hotel
HOTEL_HEALTH_AMOUNT NUMBER

Total charges for health club, court and equipment rental and golf green fees paid to the hotel
HOTEL_RESTAURANT_AMOUNT NUMBER

Total of any restaurant or room service charges paid to the hotel
HOTEL_BUSINESS_AMOUNT NUMBER

Total charges paid for copies, faxes and other business center paid to the hotel
HOTEL_PARKING_AMOUNT NUMBER

Total charges paid for valet and hotel parking paid to the hotel
HOTEL_ROOM_SERVICE_AMOUNT NUMBER

Amount of charges for room service paid to the hotel
HOTEL_TIP_AMOUNT NUMBER

Amount of tip given in a hotel
HOTEL_MISC_AMOUNT NUMBER

Amount of miscellaneous hotel charges
HOTEL_CITY VARCHAR2 (80)
City in which hotel is located
HOTEL_STATE VARCHAR2 (80)
State in which hotel is located
HOTEL_FOLIO_NUMBER VARCHAR2 (80)
Reference number assigned by the Hotel
HOTEL_ROOM_TYPE VARCHAR2 (240)
Type of accommodation
AIR_DEPARTURE_DATE DATE

Date of departure
AIR_DEPARTURE_CITY VARCHAR2 (80)
City of departure
AIR_ROUTING VARCHAR2 (80)
IATA travel point code for each leg of an air journey
AIR_ARRIVAL_CITY VARCHAR2 (80)
City to which employee traveled
AIR_STOPOVER_FLAG VARCHAR2 (1)
Identifies whether an airport/city is a destination or connection
AIR_BASE_FARE_AMOUNT NUMBER

Base air fare without any taxes
AIR_FARE_BASIS_CODE VARCHAR2 (80)
Fare basis code for air transportation
AIR_SERVICE_CLASS VARCHAR2 (80)
The code for the class of service for each leg of journey
AIR_CARRIER_ABBREVIATION VARCHAR2 (80)
Three (3) letter abbreviation code for airline
AIR_CARRIER_CODE VARCHAR2 (80)
Three (3) digit identification code for airline
AIR_TICKET_ISSUER VARCHAR2 (240)
Name of airline or travel agency issuing an air ticket
AIR_ISSUER_CITY VARCHAR2 (80)
Name of city where airline ticket issued
AIR_PASSENGER_NAME VARCHAR2 (80)
Name of traveler using an airline ticket
AIR_REFUND_TICKET_NUMBER VARCHAR2 (80)
Refund number for airline ticket
AIR_EXCHANGED_TICKET_NUMBER VARCHAR2 (80)
New ticket number generated by exchanging a previously valid air ticket
AIR_AGENCY_NUMBER VARCHAR2 (80)
Eight (8) digit identification code for ticketing agency
AIR_TICKET_NUMBER VARCHAR2 (80)
Fourteen (14) digit ticket number
FINANCIAL_CATEGORY VARCHAR2 (80)
Identifies the financial category of the transaction
PAYMENT_FLAG VARCHAR2 (1)
Identifies whether the transaction is a payment
RECORD_TYPE VARCHAR2 (80)
Identifies the type of record
MERCHANT_ACTIVITY VARCHAR2 (80)
Identifies whether transaction was initiated by the merchant, or whether the transaction was an adjustment initiated by credit card issuer
CATEGORY VARCHAR2 (30)
Category of a credit card transaction
REPORT_HEADER_ID NUMBER (15)
Report_header_id of the report that includes this transaction
EXPENSE_STATUS VARCHAR2 (15)
Keeps track of the status of an expense report.
COMPANY_PREPAID_INVOICE_ID NUMBER (15)
Invoice ID when this line is an prepaid credit card transaction
INACTIVE_EMP_WF_ITEM_KEY VARCHAR2 (50)
This column is populated with the workflow item key when the workflow process is initiated
LOCATION_ID NUMBER (15)
Location identifier
REQUEST_ID NUMBER (15)
Concurrent request identifier
MERCHANT_COUNTRY_CODE VARCHAR2 (30)
Location country code
DISPUTE_DATE DATE

Dispute date
PAYMENT_DUE_FROM_CODE VARCHAR2 (30)
Determines where the payment to the credit card issuer comes from
TRX_AVAILABLE_DATE DATE

Date on which a credit card transaction is available for expense reporting.
CARD_ACCEPTOR_ID NUMBER (15)
Foreign key to credit card acceptors.
TRXN_DETAIL_FLAG VARCHAR2 (1)
Indicates if the transaction contains detailed information.
TRX_CATEGORY VARCHAR2 (30)
Query Text

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


SELECT CARD_ID
,      TRX_ID
,      VALIDATE_CODE
,      CARD_PROGRAM_ID
,      EXPENSED_AMOUNT
,      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
,      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
,      TRX_CATEGORY
FROM APPS.APBV_CREDIT_CARD_TRXNS;

Dependencies

[top of page]

APPS.APBV_CREDIT_CARD_TRXNS references the following:

SchemaAPPS
SynonymAP_CREDIT_CARD_TRXNS_ALL

APPS.APBV_CREDIT_CARD_TRXNS is not referenced by any database object