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