[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_CREDIT_CARD_TRXNS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_CREDIT_CARD_TRXNS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TRX_ID
|
| AP_CREDIT_CARD_TRXNS_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
CARD_PROGRAM_ID
CARD_ID
REFERENCE_NUMBER
|
| AP_CREDIT_CARD_TRXNS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REPORT_HEADER_ID
|
| AP_CREDIT_CARD_TRXNS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INACTIVE_EMP_WF_ITEM_KEY
|
| AP_CREDIT_CARD_TRXNS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
|
| AP_CREDIT_CARD_TRXNS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARD_ID
|
| AP_CREDIT_CARD_TRXNS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VALIDATE_CODE
TRANSACTION_DATE
CARD_PROGRAM_ID
|
| 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_NAME1 | VARCHAR2 | (80) | 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). | |
| 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_RENTER_NAME | VARCHAR2 | (80) | 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 | (80) | 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. | |
| CARD_ID | NUMBER | (15) | Yes | ID of credit card |
| DESCRIPTION | VARCHAR2 | (240) | Description for the transaction. |
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
FROM AP.AP_CREDIT_CARD_TRXNS_ALL;
AP.AP_CREDIT_CARD_TRXNS_ALL does not reference any database object
AP.AP_CREDIT_CARD_TRXNS_ALL is referenced by following:
APPS
AP_CREDIT_CARD_TRXNS
AP_CREDIT_CARD_TRXNS_ALL
|
|
|
|