IBY_PAYMENT_METHODS_B
IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods include printing paper checks in-house, outsourcing checks to be printed by a payment system, and wiring money. A payment method can be very generic, such as EFT, or very specific, such as EFT in Denmark via Citibank using the EDIFACT format. Some payment methods are seeded, but implementers may define their own payment methods. This table corresponds to the Payment Methods pages.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
IBY_PAYMENT_METHODS_B_PK |
PAYMENT_METHOD_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Yes | User-entered primary key. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| 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. | ||
| SEEDED_FLAG | VARCHAR2 | 1 | Y or N flag controlling updatability of records. Y indicates record was seeded by Oracle and may have user updates limited. | |||
| BANK_CHARGE_BEARER_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the bank charge bearer attribute is mandatory, optional or non-applicable to this payment method. The default setting is disabled. | ||
| PAYMENT_REASON_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the payment reason attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| PAYMENT_REASON_COMNT_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the payment reason comment attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| REMITTANCE_MESSAGE1_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the remittance message1 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is optional. | ||
| REMITTANCE_MESSAGE2_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the remittance message2 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| REMITTANCE_MESSAGE3_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the remittance message3 attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| UNIQUE_REMITTANCE_ID_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the unique remittance identifier attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| URI_CHECK_DIGIT_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the URI check digit attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| DELIVERY_CHANNEL_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the delivery channel attribute is mandatory, optional, or non-applicable to this payment method. The default setting is optional. | ||
| PAYMENT_FORMAT_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the payment format attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| SETTLEMENT_PRIORITY_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the settlement priority attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| EXCLUSIVE_PMT_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the pay alone attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| EXTERNAL_BANK_ACCT_APL_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the external bank account attribute is mandatory, optional, or non-applicable to this payment method. The default setting is disabled. | ||
| SUPPORT_BILLS_PAYABLE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this payment method can be used to issue bills payable, that is future dated payments | ||
| DOCUMENT_CATEGORY_CODE | VARCHAR2 | 30 | Document category code that is linked to a payment method. Document category codes are used in providing document sequence numbers for payments. | |||
| MATURITY_DATE_OFFSET_DAYS | NUMBER | 18 | With this payment method, number of days to be added to the payment date on a payment, which determines its maturity date | |||
| INACTIVE_DATE | DATE | Inactive date | ||||
| ANTICIPATED_FLOAT | NUMBER | 18 | Days added to the payment date for use in cash forecasting | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Disbursement Payment Methods (IBY_PAYMENT_METHODS) | ||
| FORMAT_VALUE | VARCHAR2 | 80 | Value used in the formatted payment instruction | |||
| START_DATE | DATE | Yes | Date when the payment method becomes active. | |||
| END_DATE | DATE | Yes | Date when the payment method becomes inactive. | |||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | |||
| 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 |
|---|---|---|
| ap_checks_all | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_payments_all | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_temp_ext_payees | iby_payment_methods_b | DEFAULT_PAYMENT_METHOD_CODE |
| iby_documents_payable_h | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_payment_methods_tl | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_ext_party_pmt_mthds | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_ext_party_pmt_mthds | iby_payment_methods_b | BACKUP_PAYMENT_METHOD_CODE |
| iby_docs_payable_all | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_payment_rules | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_applicable_pmt_mthds | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| poz_supp_pmt_method_requests | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_val_assignments | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| iby_gen_docs_payable | iby_payment_methods_b | PAYMENT_METHOD_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_PAYMENT_METHODS_B_U1 | Unique | Default | PAYMENT_METHOD_CODE, ORA_SEED_SET1 |
| IBY_PAYMENT_METHODS_B_U11 | Unique | Default | PAYMENT_METHOD_CODE, ORA_SEED_SET2 |