[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_SYS_CC_PF_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_SYS_CC_PF_B |
Subobject Name: | |
Status: | VALID |
IBY_FNDCPT_SYS_CC_PF stores payment system-defined attributes of the credit card funds capture process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FNDCPT_SYS_CC_PF_SPC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SYS_CC_PROFILE_CODE
ZD_EDITION_NAME |
IBY_FNDCPT_SYS_CC_PF_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYER_NOTIFICATION_FORMAT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYS_CC_PROFILE_CODE | VARCHAR2 | (30) | Yes | System process profile identifier |
PAYMENT_SYSTEM_ID | NUMBER | (15) | Yes | Payment system identifier |
ONLINE_AUTH_FORMAT_CODE | VARCHAR2 | (30) | Yes | Payment format identifier for online authorization messages. |
ONLINE_AUTH_TRANS_PRTCL_CODE | VARCHAR2 | (30) | Transmission protocol for online authorization messages | |
ONLINE_AUTH_ACK_RDR_CODE | VARCHAR2 | (30) | Yes | Acknowledgment reader for online authorization responses |
SETTLEMENT_FORMAT_CODE | VARCHAR2 | (30) | Yes | Format for settlement transactions. |
SETTLEMENT_TRANS_PRTCL_CODE | VARCHAR2 | (30) | Transmission protocol for settlement messages | |
SETTLEMENT_ACK_RDR_CODE | VARCHAR2 | (30) | Acknowledgment reader for settlement 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 | ||
INACTIVE_DATE | DATE | Inactivity date for the profile | ||
LIMIT_BY_SETTLEMENT_NUM | NUMBER | Maximum number of settlements that can be included in a settlement batch | ||
CREATED_BY | NUMBER | (15) | Yes | 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) | Yes | 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 | |
AUTOMATIC_PN_SUBMIT_FLAG | VARCHAR2 | (1) | Y or No Flag indicating whether the payer notification is submitted automatically at settlement completion point | |
PAYER_NOTIFICATION_CONDITION | VARCHAR2 | (30) | Condition for Payer notification to be sent is based on All the receipts or num of receipts | |
PN_COND_NUM_OF_RECEIPTS | NUMBER | Number of reciptis, Payer Notification will be sent only if Number of receipts in the batch > this number. | ||
EXCLUDE_TRXN_DET_EXTRACTION | VARCHAR2 | (1) | Indicates to Exclude the Invoice details | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SYS_CC_PROFILE_CODE
, PAYMENT_SYSTEM_ID
, ONLINE_AUTH_FORMAT_CODE
, ONLINE_AUTH_TRANS_PRTCL_CODE
, ONLINE_AUTH_ACK_RDR_CODE
, SETTLEMENT_FORMAT_CODE
, SETTLEMENT_TRANS_PRTCL_CODE
, SETTLEMENT_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
, INACTIVE_DATE
, LIMIT_BY_SETTLEMENT_NUM
, 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
, AUTOMATIC_PN_SUBMIT_FLAG
, PAYER_NOTIFICATION_CONDITION
, PN_COND_NUM_OF_RECEIPTS
, EXCLUDE_TRXN_DET_EXTRACTION
, ZD_EDITION_NAME
FROM IBY.IBY_FNDCPT_SYS_CC_PF_B;
IBY.IBY_FNDCPT_SYS_CC_PF_B does not reference any database object
IBY.IBY_FNDCPT_SYS_CC_PF_B is referenced by following:
|
|
|