[Home] [Help] [Dependency Information]
Object Name: | IBY_TRANSACTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IBY.IBY_TRANSACTIONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_ID | VARCHAR2 | (80) | Yes | TANGIBLEID is the bill or order ID |
BEPKEY | VARCHAR2 | (80) | BEPKEY is the Bep Key (merchant account ID) used with this transaction | |
MERCHANT_ID | VARCHAR2 | (80) | Yes | Payee Identifier |
VENDOR_ID | NUMBER | (15) | ||
TRXN_TYPE | NUMBER | (15) | ||
AMOUNT | NUMBER | |||
CURRENCY | VARCHAR2 | (15) | ||
TIME | DATE | |||
STATUS | NUMBER | (15) | Yes | |
PAYMENT_TYPE | VARCHAR2 | (80) | ||
MERCHBATCHID | VARCHAR2 | (80) | ||
PAYMENT_NAME | VARCHAR2 | (80) | ||
AUTHCODE | VARCHAR2 | (80) | ||
AVSCODE | VARCHAR2 | (80) | ||
REFERENCECODE | VARCHAR2 | (80) | ||
ERROR_LOCATION | NUMBER | |||
VENDOR_CODE | VARCHAR2 | (40) | ||
ACQUIRER | VARCHAR2 | (80) | ||
VENDOR_MESSAGE | VARCHAR2 | (255) | ||
AUXMSG | VARCHAR2 | (255) | ||
TERMINALID | VARCHAR2 | (80) | ||
TRACENUMBER | VARCHAR2 | (80) | ||
ORG_ID | NUMBER | (15) | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_ID
, BEPKEY
, MERCHANT_ID
, VENDOR_ID
, TRXN_TYPE
, AMOUNT
, CURRENCY
, TIME
, STATUS
, PAYMENT_TYPE
, MERCHBATCHID
, PAYMENT_NAME
, AUTHCODE
, AVSCODE
, REFERENCECODE
, ERROR_LOCATION
, VENDOR_CODE
, ACQUIRER
, VENDOR_MESSAGE
, AUXMSG
, TERMINALID
, TRACENUMBER
, ORG_ID
FROM APPS.IBY_TRANSACTIONS_V;
|
|
|