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

TABLE: AP.AP_CREDIT_CARD_TRXNS_ALL

Object Details
Object Name: AP_CREDIT_CARD_TRXNS_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_CREDIT_CARD_TRXNS_ALL
Subobject Name:
Status: VALID


AP_CREDIT_CARD_TRXNS_ALL stores detailed information
about the credit card transactions of your employees. The
information in this table includes transactional data captured
by merchants at the point-of-sale, and data recorded by your
credit card provider. The credit card transactions this table
stores represent corporate (travel) credit card transactions,
not procurement card transactions. This table corresponds
to the Credit Card Transaction window of Self-Service Expenses.
Scope: public
Product: OIE
Lifecycle: active
Display Name: OIE Credit Card Transactions
Category: BUSINESS_ENTITY OIE_CREDIT_CARD_TRXN


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_CREDIT_CARD_TRXNS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
AP_CREDIT_CARD_TRXNS_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARD_PROGRAM_ID
ColumnCARD_ID
ColumnREFERENCE_NUMBER
AP_CREDIT_CARD_TRXNS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_HEADER_ID
AP_CREDIT_CARD_TRXNS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINACTIVE_EMP_WF_ITEM_KEY
AP_CREDIT_CARD_TRXNS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
AP_CREDIT_CARD_TRXNS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARD_ID
AP_CREDIT_CARD_TRXNS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALIDATE_CODE
ColumnTRANSACTION_DATE
ColumnCARD_PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
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
CARD_NUMBER VARCHAR2 (80)
The account number of the record in file
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_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).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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_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_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.
CARD_ID NUMBER (15) Yes ID of credit card
DESCRIPTION VARCHAR2 (240)
Description for the transaction.
COMPANY_NUMBER VARCHAR2 (15)
Company Number
MARKET_CODE VARCHAR2 (3)
Market Code
VALIDATE_REQUEST_ID VARCHAR2 (50)
Used with CC Validation Program
MERCHANT_NAME1#1 VARCHAR2 (240)
Name of merchant or establishment - part 1
CAR_RENTER_NAME#1 VARCHAR2 (240)
Car Renter Name
AIR_TICKET_ISSUER#1 VARCHAR2 (240)
Name of airline or travel agency issuing an air ticket
CUSTOMER_CODE VARCHAR2 (100)
Customer Code
PURCHASE_IDENTIFICATION VARCHAR2 (100)
Purchase Identification
FUEL_TYPE VARCHAR2 (15)
Fuel Type
FUEL_UOM_CODE VARCHAR2 (1)
Fuel UOM Code
FUEL_QUANTITY NUMBER

Fuel Quantity
FUEL_UNIT_PRICE NUMBER

Fuel Unit Price
FUEL_SALE_AMOUNT NUMBER

Fuel Sale Amount
NON_FUEL_SALE_AMOUNT NUMBER

Non Fuel Sale Amount
FLEET_IDENTITY_CODE VARCHAR2 (100)
Fleet Identity Code
AIR_AGENCY_NAME VARCHAR2 (240)
Air Travel Agency Name
AIR_TOTAL_LEGS VARCHAR2 (15)
Air travel Total legs
CUSTOMER_DATA1 VARCHAR2 (30)
CUSTOMER_DATA1
CUSTOMER_DATA2 VARCHAR2 (30)
CUSTOMER_DATA2
CUSTOMER_DATA3 VARCHAR2 (30)
CUSTOMER_DATA3
CUSTOMER_DATA4 VARCHAR2 (30)
CUSTOMER_DATA4
CUSTOMER_DATA5 VARCHAR2 (30)
CUSTOMER_DATA5
CUSTOMER_DATA6 VARCHAR2 (30)
CUSTOMER_DATA6
CUSTOMER_DATA7 VARCHAR2 (30)
CUSTOMER_DATA7
CUSTOMER_DATA8 VARCHAR2 (30)
CUSTOMER_DATA8
CUSTOMER_DATA9 VARCHAR2 (30)
CUSTOMER_DATA9
CUSTOMER_DATA10 VARCHAR2 (30)
CUSTOMER_DATA10
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_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_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_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
,      MERCHANT_NAME1#1
,      CAR_RENTER_NAME#1
,      AIR_TICKET_ISSUER#1
,      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 does not reference any database object

AP.AP_CREDIT_CARD_TRXNS_ALL is referenced by following:

SchemaAP
ViewAP_CREDIT_CARD_TRXNS_ALL#