IBY_FNDCPT_SYS_DC_PF_B
IBY_FNDCPT_SYS_DC_PF stores payment system-defined attributes of the bank account electronic funds transfer process.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
Name | Columns |
---|---|
IBY_FNDCPT_SYS_DC_PF_B_PK |
SYS_DC_PROFILE_CODE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
SYS_DC_PROFILE_CODE | VARCHAR2 | 30 | Yes | System process profile identifier | ||
PAYMENT_SYSTEM_ID | NUMBER | 18 | Yes | Payment system identifier | ||
ONLINE_DEB_FORMAT_CODE | VARCHAR2 | 30 | Yes | Payment format identifier for online debits | ||
ONLINE_DEB_TRANS_PRTCL_CODE | VARCHAR2 | 30 | Transmission protocol for online debit messages | |||
ONLINE_DEB_ACK_RDR_CODE | VARCHAR2 | 30 | Yes | Acknowledgment reader for debit responses | ||
SETTLEMENT_REQ_FLAG | VARCHAR2 | 1 | Yes | Indicates whether settlement is required by the payment system after the online debit | ||
SETTLEMENT_FORMAT_CODE | VARCHAR2 | 30 | Format for settlements | |||
SETTLEMENT_TRANS_PRTCL_CODE | VARCHAR2 | 30 | Transmission protocol for funds transfer messages | |||
SETTLEMENT_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 acknowledgment or response reader | |||
INACTIVE_DATE | DATE | Inactivity date for the profile | ||||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | 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 | Yes | 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. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Debit Card Funds Capture Process Profile (IBY_FNDCPT_SYS_DC_PF) | ||
AUTOMATIC_PN_SUBMIT_FLAG | VARCHAR2 | 1 | Y or N flag indicating whether the payer notification is submitted automatically at settlement completion point | |||
START_DATE | DATE | Yes | Date from which debit card system profile is available for use | |||
END_DATE | DATE | Yes | Date until which debit card system profile is available for use | |||
PAYER_NOTIFICATION_CONDITION | VARCHAR2 | 255 | Payer Notification Condition. | |||
PAYER_NOTIFY_INVOICES_COUNT | NUMBER | Number of Invoices | ||||
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. | |||
ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
IBY_FNDCPT_SYS_DC_PF_B | iby_bepinfo | PAYMENT_SYSTEM_ID |
IBY_FNDCPT_SYS_DC_PF_B | iby_formats_b | PAYER_NOTIFICATION_FORMAT |
IBY_FNDCPT_SYS_DC_PF_B | iby_formats_b | ONLINE_DEB_ACK_RDR_CODE |
IBY_FNDCPT_SYS_DC_PF_B | iby_transmit_protocols_b | ONLINE_DEB_TRANS_PRTCL_CODE |
IBY_FNDCPT_SYS_DC_PF_B | iby_formats_b | SETTLEMENT_FORMAT_CODE |
IBY_FNDCPT_SYS_DC_PF_B | iby_transmit_protocols_b | SETTLEMENT_TRANS_PRTCL_CODE |
IBY_FNDCPT_SYS_DC_PF_B | iby_formats_b | QUERY_FORMAT_CODE |
IBY_FNDCPT_SYS_DC_PF_B | iby_transmit_protocols_b | QUERY_TRANS_PRTCL_CODE |
iby_fndcpt_sys_dc_pf_tl | iby_fndcpt_sys_dc_pf_b | SYS_DC_PROFILE_CODE |
iby_fndcpt_user_dc_pf_b | iby_fndcpt_sys_dc_pf_b | SYS_DC_PROFILE_CODE |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
IBY_FNDCPT_SYS_DC_PF_B_N1 | Non Unique | Default | PAYMENT_SYSTEM_ID |
IBY_FNDCPT_SYS_DC_PF_B_U1 | Unique | Default | SYS_DC_PROFILE_CODE, ORA_SEED_SET1 |
IBY_FNDCPT_SYS_DC_PF_B_U11 | Unique | Default | SYS_DC_PROFILE_CODE, ORA_SEED_SET2 |