IBY_FNDCPT_SYS_CC_PF_B_
IBY_FNDCPT_SYS_CC_PF stores payment system-defined attributes of the credit card funds capture process.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
IBY_FNDCPT_SYS_CC_PF_B_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, SYS_CC_PROFILE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SYS_CC_PROFILE_CODE | VARCHAR2 | 30 | Yes | System process profile identifier | |
| PAYMENT_SYSTEM_ID | NUMBER | 18 | Payment system identifier | ||
| ONLINE_AUTH_FORMAT_CODE | VARCHAR2 | 30 | 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 | Acknowledgment reader for online authorization responses | ||
| SETTLEMENT_FORMAT_CODE | VARCHAR2 | 30 | 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 acknowledgment or response reader | ||
| INACTIVE_DATE | DATE | Inactivity date for the profile | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| 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, such as corporate, spot, and daily, 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 table. | ||
| 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 | |||
| 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 definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| AUTOMATIC_PN_SUBMIT_FLAG | VARCHAR2 | 1 | Y or No Flag indicating whether the payer notification is submitted automatically at settlement completion point | ||
| START_DATE | DATE | Date from which credit card system profile is available for use | |||
| END_DATE | DATE | Date until which credit card system profile is available for use | |||
| PAYER_NOTIFICATION_CONDITION | VARCHAR2 | 255 | Payer Notification Condition. | ||
| PAYER_NOTIFY_INVOICES_COUNT | NUMBER | Number of Settlements | |||
| SETTLEMENT_FILE_DIRECTORY | VARCHAR2 | 255 | File directory where output of settlement file is stored | ||
| SETTLEMENT_FILE_EXTENSION | VARCHAR2 | 255 | File extension of settlement file | ||
| SETTLEMENT_FILE_PREFIX | VARCHAR2 | 255 | File name prefix of settlement file | ||
| EXTERNAL_SETTLEMENT_FLAG | VARCHAR2 | 1 | Indicates whether or not settlements should be performed externally. Possible values are Y or N. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_FNDCPT_SYS_CC_PF_BN1_ | Non Unique | Default | SYS_CC_PROFILE_CODE, LAST_UPDATE_DATE |
| IBY_FNDCPT_SYS_CC_PF_B_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, SYS_CC_PROFILE_CODE |