Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: IBY.IBY_FNDCPT_SYS_EFT_PF_B#

Object Details
Object Name: IBY_FNDCPT_SYS_EFT_PF_B#
Object Type: VIEW
Owner: IBY
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SYS_EFT_PROFILE_CODE VARCHAR2 (30) Yes
PAYMENT_SYSTEM_ID NUMBER (15) Yes
VERIFY_FORMAT_CODE VARCHAR2 (30)
VERIFY_TRANS_PRTCL_CODE VARCHAR2 (30)
VERIFY_ACK_RDR_CODE VARCHAR2 (30)
SETTLE_REQUIRE_VRFY_FLAG VARCHAR2 (1) Yes
FUNDS_XFER_FORMAT_CODE VARCHAR2 (30) Yes
FUNDS_XFER_TRANS_PRTCL_CODE VARCHAR2 (30)
FUNDS_XFER_ACK_RDR_CODE VARCHAR2 (30)
QUERY_FORMAT_CODE VARCHAR2 (30)
QUERY_TRANS_PRTCL_CODE VARCHAR2 (30)
QUERY_ACK_RDR_CODE VARCHAR2 (30)
GROUP_BY_ORG VARCHAR2 (1)
GROUP_BY_INT_BANK_ACCOUNT VARCHAR2 (1)
GROUP_BY_SETTLEMENT_CURR VARCHAR2 (1)
GROUP_BY_SETTLEMENT_DATE VARCHAR2 (1)
LIMIT_BY_AMT_CURR VARCHAR2 (10)
LIMIT_BY_EXCH_RATE_TYPE VARCHAR2 (255)
LIMIT_BY_TOTAL_AMT NUMBER

LIMIT_BY_SETTLEMENT_NUM NUMBER

INACTIVE_DATE DATE

CREATED_BY NUMBER (15)
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15)
SETTLEMENT_COMPLETE_POINT VARCHAR2 (50)
OVERRIDE_PAYER_DELIVERY_FLAG VARCHAR2 (1)
PAYER_NOTIFICATION_FORMAT VARCHAR2 (30)
PAYER_NOTIFICATION_DEL_METHOD VARCHAR2 (100)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ACCOMPANY_LETTER_FORMAT VARCHAR2 (30)
AUTOMATIC_PN_SUBMIT_FLAG VARCHAR2 (1)
PAYER_NOTIFICATION_CONDITION VARCHAR2 (30)
PN_COND_NUM_OF_RECEIPTS NUMBER

EXCLUDE_TRXN_DET_EXTRACTION VARCHAR2 (1)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SYS_EFT_PROFILE_CODE
,      PAYMENT_SYSTEM_ID
,      VERIFY_FORMAT_CODE
,      VERIFY_TRANS_PRTCL_CODE
,      VERIFY_ACK_RDR_CODE
,      SETTLE_REQUIRE_VRFY_FLAG
,      FUNDS_XFER_FORMAT_CODE
,      FUNDS_XFER_TRANS_PRTCL_CODE
,      FUNDS_XFER_ACK_RDR_CODE
,      QUERY_FORMAT_CODE
,      QUERY_TRANS_PRTCL_CODE
,      QUERY_ACK_RDR_CODE
,      GROUP_BY_ORG
,      GROUP_BY_LEGAL_ENTITY
,      GROUP_BY_INT_BANK_ACCOUNT
,      GROUP_BY_SETTLEMENT_CURR
,      GROUP_BY_SETTLEMENT_DATE
,      LIMIT_BY_AMT_CURR
,      LIMIT_BY_EXCH_RATE_TYPE
,      LIMIT_BY_TOTAL_AMT
,      LIMIT_BY_SETTLEMENT_NUM
,      INACTIVE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SETTLEMENT_COMPLETE_POINT
,      OVERRIDE_PAYER_DELIVERY_FLAG
,      PAYER_NOTIFICATION_FORMAT
,      PAYER_NOTIFICATION_DEL_METHOD
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACCOMPANY_LETTER_FORMAT
,      AUTOMATIC_PN_SUBMIT_FLAG
,      PAYER_NOTIFICATION_CONDITION
,      PN_COND_NUM_OF_RECEIPTS
,      EXCLUDE_TRXN_DET_EXTRACTION
,      ZD_EDITION_NAME
FROM IBY.IBY_FNDCPT_SYS_EFT_PF_B#;

Dependencies

[top of page]

IBY.IBY_FNDCPT_SYS_EFT_PF_B# references the following:

SchemaIBY
TableIBY_FNDCPT_SYS_EFT_PF_B
IBY.IBY_FNDCPT_SYS_EFT_PF_B# is referenced by following:

SchemaAPPS
SynonymIBY_FNDCPT_SYS_EFT_PF_B
TriggerIBY_FNDCPT_SYS_EFT_PF_B+