[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_CREDIT_CARD_TRXNS_ARC |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_CREDIT_CARD_TRXNS_ARC
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ARC_REQ_ID | NUMBER | Yes | Archive Request Id | |
| ARCHIVE_DATE | DATE | Archive Date | ||
| TRX_ID | NUMBER | (15) | Yes | Transaction Id |
| VALIDATE_CODE | VARCHAR2 | (25) | Yes | Validate Code |
| CARD_PROGRAM_ID | NUMBER | (15) | Yes | Card Program Id |
| EXPENSED_AMOUNT | NUMBER | Expensed Amount | ||
| CARD_NUMBER | VARCHAR2 | (80) | Card Number | |
| REFERENCE_NUMBER | VARCHAR2 | (240) | Yes | Reference Number |
| TRANSACTION_TYPE | VARCHAR2 | (80) | Transaction Type | |
| TRANSACTION_DATE | DATE | Transaction Date | ||
| TRANSACTION_AMOUNT | NUMBER | Transaction Amount | ||
| DEBIT_FLAG | VARCHAR2 | (1) | Debit Flag | |
| BILLED_DATE | DATE | Billed Date | ||
| BILLED_AMOUNT | NUMBER | Billed Amount | ||
| BILLED_DECIMAL | NUMBER | (1) | Billed Decimal | |
| BILLED_CURRENCY_CODE | VARCHAR2 | (15) | Billed Currency Code | |
| POSTED_DATE | DATE | Posted Date | ||
| POSTED_AMOUNT | NUMBER | Posted Amount | ||
| POSTED_DECIMAL | NUMBER | (1) | Posted Decimal | |
| POSTED_CURRENCY_CODE | VARCHAR2 | (15) | Posted Currency Code | |
| CURRENCY_CONVERSION_EXPONENT | NUMBER | (1) | Currency Conversion Exponent | |
| CURRENCY_CONVERSION_RATE | NUMBER | Conversion Rate | ||
| MIS_INDUSTRY_CODE | VARCHAR2 | (80) | MIS Industry Code | |
| SIC_CODE | NUMBER | (15) | SIC Code | |
| MERCHANT_TAX_ID | VARCHAR2 | (80) | Merchant Tax Id | |
| MERCHANT_REFERENCE | VARCHAR2 | (80) | Merchant Reference | |
| MERCHANT_NAME2 | VARCHAR2 | (80) | Merchant Name 2 | |
| MERCHANT_ADDRESS1 | VARCHAR2 | (80) | Merchant Address 1 | |
| MERCHANT_ADDRESS2 | VARCHAR2 | (80) | Merchant Address 2 | |
| MERCHANT_ADDRESS3 | VARCHAR2 | (80) | Merchant Address 3 | |
| MERCHANT_ADDRESS4 | VARCHAR2 | (80) | Merchant Address 5 | |
| MERCHANT_CITY | VARCHAR2 | (80) | Merchant City | |
| MERCHANT_PROVINCE_STATE | VARCHAR2 | (80) | Merchant State | |
| MERCHANT_POSTAL_CODE | VARCHAR2 | (80) | Merchant Postal Code | |
| MERCHANT_COUNTRY | VARCHAR2 | (80) | Merchant Country | |
| TOTAL_TAX | NUMBER | Total Tax | ||
| LOCAL_TAX | NUMBER | Local Tax | ||
| NATIONAL_TAX | NUMBER | National Tax | ||
| OTHER_TAX | NUMBER | Other Tax | ||
| ORG_ID | NUMBER | (15) | Org Id | |
| LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| CREATION_DATE | DATE | Standard WHO Column | ||
| CREATED_BY | NUMBER | (15) | Standard WHO Column | |
| FOLIO_TYPE | VARCHAR2 | (80) | Folio Type | |
| ATM_CASH_ADVANCE | NUMBER | ATM Cash Advance | ||
| ATM_TRANSACTION_DATE | DATE | ATM Transaction Date | ||
| ATM_FEE_AMOUNT | NUMBER | ATM Fee Amount | ||
| ATM_TYPE | VARCHAR2 | (80) | ATM Type | |
| ATM_ID | VARCHAR2 | (80) | ATM ID | |
| ATM_NETWORK_ID | VARCHAR2 | (80) | ATM Network ID | |
| RESTAURANT_FOOD_AMOUNT | NUMBER | Restaurant Food Amount | ||
| RESTAURANT_BEVERAGE_AMOUNT | NUMBER | Restaurant Beverge Amount | ||
| RESTAURANT_TIP_AMOUNT | NUMBER | Restaurant Tip Amount | ||
| CAR_RENTAL_DATE | DATE | Car Rental Date | ||
| CAR_RETURN_DATE | DATE | Car Return Date | ||
| CAR_RENTAL_LOCATION | VARCHAR2 | (80) | Car Rental Location | |
| 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) | Car Rental Agreement Number | |
| CAR_CLASS | VARCHAR2 | (80) | Car Class | |
| CAR_TOTAL_MILEAGE | NUMBER | Car Total Mileage | ||
| CAR_GAS_AMOUNT | NUMBER | Car Gas Amount | ||
| CAR_INSURANCE_AMOUNT | NUMBER | Car Insurance Amount | ||
| CAR_MILEAGE_AMOUNT | NUMBER | Car Mileage Amount | ||
| CAR_DAILY_RATE | NUMBER | Car Daily Rate | ||
| HOTEL_ARRIVAL_DATE | DATE | Hotel Arrival Date | ||
| HOTEL_DEPART_DATE | DATE | Hotel Depart Date | ||
| HOTEL_CHARGE_DESC | VARCHAR2 | (80) | Hotel Charge Desc | |
| HOTEL_GUEST_NAME | VARCHAR2 | (80) | Hotel Guest Name | |
| HOTEL_STAY_DURATION | NUMBER | Hotel Stay Duration | ||
| HOTEL_ROOM_RATE | NUMBER | Hotel Room Rate | ||
| HOTEL_NO_SHOW_FLAG | VARCHAR2 | (1) | Hotel No Show Flag | |
| HOTEL_ROOM_AMOUNT | NUMBER | Hotel Room Amount | ||
| HOTEL_TELEPHONE_AMOUNT | NUMBER | Hotel Telephone Amount | ||
| HOTEL_ROOM_TAX | NUMBER | Hotel Room Tax | ||
| HOTEL_BAR_AMOUNT | NUMBER | Hotel Bar Amount | ||
| HOTEL_MOVIE_AMOUNT | NUMBER | Hotel Movie Amount | ||
| HOTEL_GIFT_SHOP_AMOUNT | NUMBER | Hotel Gift Shop Amount | ||
| HOTEL_LAUNDRY_AMOUNT | NUMBER | Hotel Laundry Amount | ||
| HOTEL_HEALTH_AMOUNT | NUMBER | Hotel Health Amount | ||
| HOTEL_RESTAURANT_AMOUNT | NUMBER | Hotel Restaurant Amount | ||
| HOTEL_BUSINESS_AMOUNT | NUMBER | Hotel Business Amount | ||
| HOTEL_PARKING_AMOUNT | NUMBER | Hotel Parking Amount | ||
| HOTEL_ROOM_SERVICE_AMOUNT | NUMBER | Hotel Room Service Amount | ||
| HOTEL_TIP_AMOUNT | NUMBER | Hotel Tip Amount | ||
| HOTEL_MISC_AMOUNT | NUMBER | Hotel Misc Amount | ||
| HOTEL_CITY | VARCHAR2 | (80) | Hotel City | |
| HOTEL_STATE | VARCHAR2 | (80) | Hotel State | |
| HOTEL_FOLIO_NUMBER | VARCHAR2 | (80) | Hotel Folio Number | |
| HOTEL_ROOM_TYPE | VARCHAR2 | (240) | Hotel Room Type | |
| AIR_DEPARTURE_DATE | DATE | Air Departure Date | ||
| AIR_DEPARTURE_CITY | VARCHAR2 | (80) | Air Departure City | |
| AIR_ROUTING | VARCHAR2 | (80) | Air Routing | |
| AIR_ARRIVAL_CITY | VARCHAR2 | (80) | Air Arrival City | |
| AIR_STOPOVER_FLAG | VARCHAR2 | (1) | Air Stopover Flag | |
| AIR_BASE_FARE_AMOUNT | NUMBER | Air Base Fare Amount | ||
| AIR_FARE_BASIS_CODE | VARCHAR2 | (80) | Air fare basis code | |
| AIR_SERVICE_CLASS | VARCHAR2 | (80) | Air Service Class | |
| AIR_CARRIER_ABBREVIATION | VARCHAR2 | (80) | Air Carrier abbreviation | |
| AIR_CARRIER_CODE | VARCHAR2 | (80) | Air Carrier Code | |
| AIR_ISSUER_CITY | VARCHAR2 | (80) | Air Issuer City | |
| AIR_PASSENGER_NAME | VARCHAR2 | (80) | Air Passenger Name | |
| AIR_REFUND_TICKET_NUMBER | VARCHAR2 | (80) | Air Refund Ticket Number | |
| AIR_EXCHANGED_TICKET_NUMBER | VARCHAR2 | (80) | Air Exchanged Ticket Number | |
| AIR_AGENCY_NUMBER | VARCHAR2 | (80) | Air Agency Number | |
| AIR_TICKET_NUMBER | VARCHAR2 | (80) | Air Ticket Number | |
| FINANCIAL_CATEGORY | VARCHAR2 | (80) | Financial Category | |
| PAYMENT_FLAG | VARCHAR2 | (1) | Payment Flag | |
| RECORD_TYPE | VARCHAR2 | (80) | Record Type | |
| MERCHANT_ACTIVITY | VARCHAR2 | (80) | Merchant Activity | |
| CATEGORY | VARCHAR2 | (30) | Category | |
| REPORT_HEADER_ID | NUMBER | (15) | Report Header Id | |
| EXPENSE_STATUS | VARCHAR2 | (15) | Expense Status | |
| COMPANY_PREPAID_INVOICE_ID | NUMBER | (15) | Company Prepaid Invoice Id | |
| INACTIVE_EMP_WF_ITEM_KEY | VARCHAR2 | (50) | Inactive Employee Key | |
| LOCATION_ID | NUMBER | (15) | Location Id | |
| REQUEST_ID | NUMBER | (15) | Request Id | |
| MERCHANT_COUNTRY_CODE | VARCHAR2 | (30) | Merchant Country Code | |
| DISPUTE_DATE | DATE | Dispute Date | ||
| PAYMENT_DUE_FROM_CODE | VARCHAR2 | (30) | Payment Due From Code | |
| TRX_AVAILABLE_DATE | DATE | Transaction Available Date | ||
| CARD_ACCEPTOR_ID | NUMBER | (15) | Card Acceptior Id | |
| TRXN_DETAIL_FLAG | VARCHAR2 | (1) | Transaction Detail Flag | |
| CARD_ID | NUMBER | (15) | Yes | Card Id |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ARC_REQ_ID
, ARCHIVE_DATE
, 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_ARC;
AP.AP_CREDIT_CARD_TRXNS_ARC does not reference any database object
AP.AP_CREDIT_CARD_TRXNS_ARC is referenced by following:
AP
AP_CREDIT_CARD_TRXNS_ARC#
|
|
|
|