[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#;
|
|
|