[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_SYS_EFT_PF_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_SYS_EFT_PF_B |
Subobject Name: | |
Status: | VALID |
IBY_FNDCPT_SYS_EFT_PF stores payment system-defined attributes of the bank account electronic funds transfer process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FNDCPT_SYS_EFT_PF_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SYS_EFT_PROFILE_CODE |
IBY_FNDCPT_SYS_EFT_PF_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYER_NOTIFICATION_FORMAT |
IBY_FNDCPT_SYS_EFT_PF_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOMPANY_LETTER_FORMAT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYS_EFT_PROFILE_CODE | VARCHAR2 | (30) | Yes | System process profile identifier |
PAYMENT_SYSTEM_ID | NUMBER | (15) | Yes | Payment system identifier |
VERIFY_FORMAT_CODE | VARCHAR2 | (30) | Payment format identifier for verification messages (if supported). | |
VERIFY_TRANS_PRTCL_CODE | VARCHAR2 | (30) | Transmission protocol for verification messages | |
VERIFY_ACK_RDR_CODE | VARCHAR2 | (30) | Acknowledgment reader for verification responses | |
SETTLE_REQUIRE_VRFY_FLAG | VARCHAR2 | (1) | Yes | Y or N flag indicating that the settlements require pre-existing verification operations |
FUNDS_XFER_FORMAT_CODE | VARCHAR2 | (30) | Yes | Format for funds transfer transactions. |
FUNDS_XFER_TRANS_PRTCL_CODE | VARCHAR2 | (30) | Transmission protocol for funds transfer messages. | |
FUNDS_XFER_ACK_RDR_CODE | VARCHAR2 | (30) | Acknowledgment reader for funds transfer responses | |
QUERY_FORMAT_CODE | VARCHAR2 | (30) | Format for the query request | |
QUERY_TRANS_PRTCL_CODE | VARCHAR2 | (30) | Transmission protocol for query requests | |
QUERY_ACK_RDR_CODE | VARCHAR2 | (30) | Query acknowledgement/response reader | |
GROUP_BY_ORG | VARCHAR2 | (1) | Y or N flag specifying whether settlements should be grouped into settlement batches by first party organization | |
GROUP_BY_LEGAL_ENTITY | VARCHAR2 | (1) | Y or N flag specifying whether settlements should be grouped into settlement batches by first party legal entity | |
GROUP_BY_INT_BANK_ACCOUNT | VARCHAR2 | (1) | Y or N flag specifying whether settlements should be grouped into settlement batches by internal bank account | |
GROUP_BY_SETTLEMENT_CURR | VARCHAR2 | (1) | Y or N flag specifying whether settlements should be grouped into settlement batches by settlement currency | |
GROUP_BY_SETTLEMENT_DATE | VARCHAR2 | (1) | Y or N flag specifying whether settlements should be grouped into settlement batches by settlement date | |
LIMIT_BY_AMT_CURR | VARCHAR2 | (10) | Currency in which the maximum total amount per settlement batch is calculated. | |
LIMIT_BY_EXCH_RATE_TYPE | VARCHAR2 | (255) | Exchange rate type used to compare the settlement batch total amount to the maximum total amount allowed. Types are defined in the General Ledger currency exchange rate type lookups table. These include CORPORATE, SPOT, and DAILY. | |
LIMIT_BY_TOTAL_AMT | NUMBER | Maximum total amount for which a settlement batch can be created | ||
LIMIT_BY_SETTLEMENT_NUM | NUMBER | Maximum number of settlements that can be included in a settlement batch | ||
INACTIVE_DATE | DATE | Inactivity date for the profile | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
SETTLEMENT_COMPLETE_POINT | VARCHAR2 | (50) | A point when the settlement is considered complete. | |
OVERRIDE_PAYER_DELIVERY_FLAG | VARCHAR2 | (1) | Y or N flag indicating whether the payer notification delivery method should be overridden by the payer delivery method preference. | |
PAYER_NOTIFICATION_FORMAT | VARCHAR2 | (30) | Payment format identifier for payer notification | |
PAYER_NOTIFICATION_DEL_METHOD | VARCHAR2 | (100) | Remittance advice delivery method. Values, from the lookup IBY_DELIVERY_METHODS, include EMAIL, FAX, and PRINTED | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ACCOMPANY_LETTER_FORMAT | VARCHAR2 | (30) | Accompany Letter Format | |
AUTOMATIC_PN_SUBMIT_FLAG | VARCHAR2 | (1) | Y or N flag indicating whether the payer notification is submitted automatically at settlement completion point |
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
FROM IBY.IBY_FNDCPT_SYS_EFT_PF_B;
IBY.IBY_FNDCPT_SYS_EFT_PF_B does not reference any database object
IBY.IBY_FNDCPT_SYS_EFT_PF_B is referenced by following:
|
|
|