[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_TRXN_SUMMARIES_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | IBY |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRXNMID | NUMBER | Yes | ||
| TRANSACTIONID | NUMBER | Yes | ||
| TANGIBLEID | VARCHAR2 | (80) | Yes | |
| PAYEEID | VARCHAR2 | (80) | Yes | |
| BEPID | NUMBER | (15) | ||
| MPAYEEID | NUMBER | Yes | ||
| ECAPPID | NUMBER | (15) | Yes | |
| ORG_ID | NUMBER | (15) | ||
| PAYMENTMETHODNAME | VARCHAR2 | (80) | ||
| MTANGIBLEID | NUMBER | Yes | ||
| PAYEEINSTRID | NUMBER | |||
| PAYERID | VARCHAR2 | (80) | ||
| PAYERINSTRID | NUMBER | |||
| DETAILLOOKUP | VARCHAR2 | (30) | ||
| AMOUNT | NUMBER | |||
| INSTRNUMBER | VARCHAR2 | (60) | ||
| CURRENCYNAMECODE | VARCHAR2 | (15) | ||
| STATUS | NUMBER | (15) | Yes | |
| UPDATEDATE | DATE | |||
| TRXNTYPEID | NUMBER | (15) | ||
| ERRORLOCATION | NUMBER | |||
| BEPCODE | VARCHAR2 | (40) | ||
| BEPMESSAGE | VARCHAR2 | (255) | ||
| BATCHID | VARCHAR2 | (80) | ||
| SETTLEDATE | DATE | |||
| MBATCHID | NUMBER | |||
| REQDATE | DATE | |||
| REQTYPE | VARCHAR2 | (20) | ||
| REQSEQ | NUMBER | (4) | ||
| DESTURL | VARCHAR2 | (1024) | ||
| NLSLANG | VARCHAR2 | (80) | ||
| NEEDSUPDT | VARCHAR2 | (3) | ||
| OVERALL_SCORE | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| INSTRTYPE | VARCHAR2 | (30) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| SALES_REP_PARTY_ID | NUMBER | (15) | ||
| BEPKEY | VARCHAR2 | (80) | ||
| CUST_ACCOUNT_ID | NUMBER | (15) | ||
| INSTRSUBTYPE | VARCHAR2 | (40) | ||
| SUB_KEY_ID | NUMBER | |||
| ECBATCHID | VARCHAR2 | (80) | ||
| TRXNREF | VARCHAR2 | (240) | ||
| PROCESS_PROFILE_CODE | VARCHAR2 | (30) | ||
| ACCT_SITE_USE_ID | NUMBER | (15) | ||
| ORG_TYPE | VARCHAR2 | (30) | ||
| LEGAL_ENTITY_ID | NUMBER | (15) | ||
| BILL_TO_ADDRESS_ID | NUMBER | (15) | ||
| FACTORED_FLAG | VARCHAR2 | (1) | ||
| INSTRNUM_HASH | VARCHAR2 | (60) | ||
| INSTRNUM_LENGTH | NUMBER | (3) | ||
| PAYMENT_CHANNEL_CODE | VARCHAR2 | (30) | ||
| CC_ISSUER_RANGE_ID | NUMBER | (15) | ||
| INSTRNUM_SEC_SEGMENT_ID | NUMBER | (15) | ||
| PROC_REFERENCE_CODE | VARCHAR2 | (240) | ||
| PROC_REFERENCE_AMOUNT | NUMBER | |||
| SETTLEMENT_CUSTOMER_REFERENCE | VARCHAR2 | (255) | ||
| BR_MATURITY_DATE | DATE | |||
| SETTLEMENT_DUE_DATE | DATE | |||
| CALL_APP_SERVICE_REQ_CODE | VARCHAR2 | (255) | ||
| BANK_CHARGE_BEARER_CODE | VARCHAR2 | (30) | ||
| DIRDEB_INSTRUCTION_CODE | VARCHAR2 | (30) | ||
| DEBIT_ADVICE_DELIVERY_METHOD | VARCHAR2 | (30) | ||
| DEBIT_ADVICE_EMAIL | VARCHAR2 | (255) | ||
| DEBIT_ADVICE_FAX | VARCHAR2 | (100) | ||
| PAYER_PARTY_ID | NUMBER | |||
| FIRST_TRXN_FLAG | VARCHAR2 | (1) | ||
| ACCT_SITE_ID | NUMBER | (15) | ||
| DEBIT_AUTH_FLAG | VARCHAR2 | (1) | ||
| DEBIT_AUTH_METHOD | VARCHAR2 | (30) | ||
| DEBIT_AUTH_REFERENCE | VARCHAR2 | (100) | ||
| PAYER_INSTR_ASSIGNMENT_ID | NUMBER | (15) | ||
| PAYER_NOTIFICATION_REQUIRED | VARCHAR2 | (1) | ||
| PAYER_NOTIFICATION_CREATED | VARCHAR2 | (1) | ||
| AR_RECEIPT_METHOD_ID | NUMBER | (15) | ||
| BR_DRAWEE_ISSUED_FLAG | VARCHAR2 | (1) | ||
| BR_SIGNED_FLAG | VARCHAR2 | (1) | ||
| SALT_VERSION | NUMBER | (2) | ||
| INITIATOR_EXTENSION_ID | NUMBER | (15) | Yes | |
| LOGICAL_GROUP_REFERENCE | VARCHAR2 | (80) | ||
| SEQ_TYPE | VARCHAR2 | (30) | ||
| SERVICE_LEVEL | VARCHAR2 | (30) | ||
| LOCALINSTR | VARCHAR2 | (30) | ||
| CATEGORY_PURPOSE | VARCHAR2 | (30) | ||
| DEBIT_AUTHORIZATION_ID | NUMBER | (15) | ||
| CREDITOR_REFERENCE | VARCHAR2 | (35) |
Cut, paste (and edit) the following text to query this object:
SELECT TRXNMID
, TRANSACTIONID
, TANGIBLEID
, PAYEEID
, BEPID
, MPAYEEID
, ECAPPID
, ORG_ID
, PAYMENTMETHODNAME
, MTANGIBLEID
, PAYEEINSTRID
, PAYERID
, PAYERINSTRID
, DETAILLOOKUP
, AMOUNT
, INSTRNUMBER
, CURRENCYNAMECODE
, STATUS
, UPDATEDATE
, TRXNTYPEID
, ERRORLOCATION
, BEPCODE
, BEPMESSAGE
, BATCHID
, SETTLEDATE
, MBATCHID
, REQDATE
, REQTYPE
, REQSEQ
, DESTURL
, NLSLANG
, NEEDSUPDT
, OVERALL_SCORE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INSTRTYPE
, SECURITY_GROUP_ID
, SALES_REP_PARTY_ID
, BEPKEY
, CUST_ACCOUNT_ID
, INSTRSUBTYPE
, SUB_KEY_ID
, ECBATCHID
, TRXNREF
, PROCESS_PROFILE_CODE
, ACCT_SITE_USE_ID
, ORG_TYPE
, LEGAL_ENTITY_ID
, BILL_TO_ADDRESS_ID
, FACTORED_FLAG
, INSTRNUM_HASH
, INSTRNUM_LENGTH
, PAYMENT_CHANNEL_CODE
, CC_ISSUER_RANGE_ID
, INSTRNUM_SEC_SEGMENT_ID
, PROC_REFERENCE_CODE
, PROC_REFERENCE_AMOUNT
, SETTLEMENT_CUSTOMER_REFERENCE
, BR_MATURITY_DATE
, SETTLEMENT_DUE_DATE
, CALL_APP_SERVICE_REQ_CODE
, BANK_CHARGE_BEARER_CODE
, DIRDEB_INSTRUCTION_CODE
, DEBIT_ADVICE_DELIVERY_METHOD
, DEBIT_ADVICE_EMAIL
, DEBIT_ADVICE_FAX
, PAYER_PARTY_ID
, FIRST_TRXN_FLAG
, ACCT_SITE_ID
, DEBIT_AUTH_FLAG
, DEBIT_AUTH_METHOD
, DEBIT_AUTH_REFERENCE
, PAYER_INSTR_ASSIGNMENT_ID
, PAYER_NOTIFICATION_REQUIRED
, PAYER_NOTIFICATION_CREATED
, AR_RECEIPT_METHOD_ID
, BR_DRAWEE_ISSUED_FLAG
, BR_SIGNED_FLAG
, SALT_VERSION
, INITIATOR_EXTENSION_ID
, LOGICAL_GROUP_REFERENCE
, SEQ_TYPE
, SERVICE_LEVEL
, LOCALINSTR
, CATEGORY_PURPOSE
, DEBIT_AUTHORIZATION_ID
, CREDITOR_REFERENCE
FROM IBY.IBY_TRXN_SUMMARIES_ALL#;
IBY
IBY_TRXN_SUMMARIES_ALL
APPS
IBY_TRXN_SUMMARIES_ALL
|
|
|
|