[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_TRANS_ALL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IBY.IBY_TRANS_ALL_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
IBY_TRANS_ALL view allows a merchant or business to view transactional detail.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTIONID | NUMBER | Yes | TRANSACTIONID is the ID generated for each payment request (orapmtreq) and passed back to ECApp. | |
| TANGIBLEID | VARCHAR2 | (80) | Yes | TANGIBLEID is the bill or order ID |
| PAYEEID | VARCHAR2 | (80) | Yes | Payee Identifier |
| BEPID | NUMBER | (15) | BEP Identifier | |
| ECAPPID | NUMBER | (15) | Yes | ECAPP Identifier |
| TRXNMID | NUMBER | Yes | TRXNMID is system generated ID | |
| AMOUNT | NUMBER | Transaction Amount | ||
| CURRENCYNAMECODE | VARCHAR2 | (15) | CURRENCYNAMECODE is the code for currency name such USD | |
| REQDATE | DATE | REQDATE is the date when the batch operation request is received | ||
| REQTYPE | VARCHAR2 | (20) | REQTYPE is the type of request such as closebatch, purgebatch, openbatch | |
| STATUS | NUMBER | (15) | Yes | Status of the transaction |
| SETTLEDATE | DATE | SETTLEDATE is the scheduled date for the bill or order used for offline payments only | ||
| UPDATEDATE | DATE | UPDATEDATE is the date scheduled payment is updated | ||
| TRXNTYPEID | NUMBER | (15) | The TRXTYPE columns is a Lookup code for lookup type IBY_TRXNTYPES | |
| TRXNREF | VARCHAR2 | (240) | Optional, secondary transaction identifier to be passed by calling application; useful in distinguishing transactions when the tangible/order id must be shared. | |
| ERRORLOCATION | NUMBER | ERRORLOCATION is numeric code for where the error occured. | ||
| BEPCODE | VARCHAR2 | (40) | BEPCODE is any BEP specific code | |
| BEPMESSAGE | VARCHAR2 | (255) | BEPMESSAGE is Payment System specific message | |
| BATCHID | VARCHAR2 | (80) | Batch Identifier | |
| NEEDSUPDT | VARCHAR2 | (3) | NEEDSUPDT is a flag to identify the rows that has changed status. Used by Schedular | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| PAYMENTMETHODNAME | VARCHAR2 | (80) | Payment Method Name | |
| MTANGIBLEID | NUMBER | Yes | MTANGIBLEID is the master id that points to iby_tangible table for additional information about tangible | |
| DETAILLOOKUP | VARCHAR2 | (30) | DETAILLOOKUP is a lookup column for CORE, EXTENDED or FI | |
| REQSEQ | NUMBER | (4) | Request Sequence | |
| DESTURL | VARCHAR2 | (1024) | DESTURL is used for storing the constructed bep url during schedule of Payments | |
| NLSLANG | VARCHAR2 | (80) | NLS Language | |
| TERMINALID | VARCHAR2 | (80) | Terminal Id is a concept for credit card processing. A merchant can get multiple terminal Ids and there is a batch open for each Terminal Id. The merchant could perform operations on those batches independantly. | |
| TRACENUMBER | VARCHAR2 | (80) | Unique Transaction id for payworks BEP follow-on transactions | |
| AUTHCODE | VARCHAR2 | (80) | AUTHCODE is the authorization code received from Credit Card Processing System for authorization. | |
| REFERENCECODE | VARCHAR2 | (80) | REFERENCECODE is any reference code received from Payment Systems or processing system which can be used for reference. | |
| OPERATIONCODE | VARCHAR2 | (80) | OPERATIONCODE is generic code for any operation such as auth, capture etc | |
| INSTRNAME | VARCHAR2 | (80) | INSTRNAME is the payment instrument name such as Visa, MasterCard etc. | |
| AUTHTYPE | VARCHAR2 | (20) | AUTHTYPE denotes whether authorization is authonly or authcapture. | |
| AVSCODE | VARCHAR2 | (80) | AVSCODE is the Address Verification Code from payment systems. | |
| ACQUIRER | VARCHAR2 | (80) | ACQUIRER is the merchant bank which may be optionally returned. | |
| AUXMSG | VARCHAR2 | (255) | AUXMSG is any auxillary message that may be returned by the payment system or processing system. | |
| ACCTNO | VARCHAR2 | (80) | ACCTNO is customer account number with the biller or merchant | |
| REFINFO | VARCHAR2 | (80) | REFINFO is any reference information passed by the ECApp | |
| MEMO | VARCHAR2 | (80) | MEMO is any memo for the payment | |
| ORDER_MEDIUM | VARCHAR2 | (30) | Medium or channel through which the order was sent. Possible values defined by lookup IBY_ORDER_MEDIUM_TYPE. | |
| EFT_AUTH_METHOD | VARCHAR2 | (30) | Electronic funds transfer authorization method |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTIONID
, TANGIBLEID
, PAYEEID
, BEPID
, ECAPPID
, TRXNMID
, AMOUNT
, CURRENCYNAMECODE
, REQDATE
, REQTYPE
, STATUS
, SETTLEDATE
, UPDATEDATE
, TRXNTYPEID
, TRXNREF
, ERRORLOCATION
, BEPCODE
, BEPMESSAGE
, BATCHID
, NEEDSUPDT
, ORG_ID
, PAYMENTMETHODNAME
, MTANGIBLEID
, DETAILLOOKUP
, REQSEQ
, DESTURL
, NLSLANG
, TERMINALID
, TRACENUMBER
, AUTHCODE
, REFERENCECODE
, OPERATIONCODE
, INSTRNAME
, AUTHTYPE
, AVSCODE
, ACQUIRER
, AUXMSG
, ACCTNO
, REFINFO
, MEMO
, ORDER_MEDIUM
, EFT_AUTH_METHOD
FROM APPS.IBY_TRANS_ALL_V;
APPS
IBY_TANGIBLE
IBY_TRXN_CORE
IBY_TRXN_SUMMARIES_ALL
APPS
AR_CC_REFUNDS
- show dependent code
AR_PMT_PROCESS_WRAPPER
- show dependent code
OE_PAYMENT_DATA_MIGRATION_UTIL
- show dependent code
OE_VERIFY_PAYMENT_PUB
- show dependent code
|
|
|
|