IBY_EXTERNAL_PAYEES_ALL
IBY_EXTERNAL_PAYEES_ALL stores payment-related attributes for the funds disbursement payment process for external party payees. This table corresponds to the supplier attributes.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_EXTERNAL_PAYEES_ALL_PK |
EXT_PAYEE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXT_PAYEE_ID | NUMBER | 18 | Yes | System-generated primary key. | |
| PAYEE_PARTY_ID | NUMBER | 18 | Yes | TCA party Identifier | |
| PAYMENT_FUNCTION | VARCHAR2 | 30 | Yes | Function or purpose of the payment. Values from the lookup IBY_PAYMENT_FUNCTIONS include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others. | |
| EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag indicating whether documents payable for this payee should be prevented from being grouped with other like documents payable for payment. | |
| 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. | |
| PARTY_SITE_ID | NUMBER | 18 | Party site Identifier | ||
| SUPPLIER_SITE_ID | NUMBER | 18 | Supplier site Identifier | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| ORG_TYPE | VARCHAR2 | 30 | Organization type, such as business unit. Values taken from lookup: IBY_ORGANIZATION_TYPES | ||
| DEFAULT_PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Default payment method Identifier | ||
| ECE_TP_LOCATION_CODE | VARCHAR2 | 60 | Trading partner location code for e-Commerce Gateway | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Party that is responsible for paying regular or express bank charges, such as Payee or Payer. Values taken from lookup: IBY_BANK_CHARGE_BEARER | ||
| BANK_INSTRUCTION1_CODE | VARCHAR2 | 30 | Code of first bank instruction | ||
| BANK_INSTRUCTION2_CODE | VARCHAR2 | 30 | Code of second bank instruction | ||
| BANK_INSTRUCTION_DETAILS | VARCHAR2 | 255 | Additional bank instruction details | ||
| PAYMENT_REASON_CODE | VARCHAR2 | 30 | Payment reason code | ||
| PAYMENT_REASON_COMMENTS | VARCHAR2 | 240 | Free text field available for entering a reason for the payment | ||
| INACTIVE_DATE | DATE | web service java client proxy | |||
| PAYMENT_TEXT_MESSAGE1 | VARCHAR2 | 256 | Text message for use in payment processing | ||
| PAYMENT_TEXT_MESSAGE2 | VARCHAR2 | 256 | Text message for use in payment processing | ||
| PAYMENT_TEXT_MESSAGE3 | VARCHAR2 | 256 | Text message for use in payment processing | ||
| DELIVERY_CHANNEL_CODE | VARCHAR2 | 30 | Default delivery channel code | ||
| LOCAL_INSTRUMENT_CODE | VARCHAR2 | 30 | Default Local Instrument Code | ||
| SERVICE_LEVEL_CODE | VARCHAR2 | 30 | Default Service Level Code | ||
| PAYMENT_FORMAT_CODE | VARCHAR2 | 30 | Default payment format code | ||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | Priority with which the financial institution or payment system settles payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY. | ||
| REMIT_ADVICE_DELIVERY_METHOD | VARCHAR2 | 30 | Default delivery method set on the payee level. If the Override with Payee Delivery Method Preference flag on the Payment Process Profile is turned off, the setting here is ignored. Values from the lookup IBY_DELIVERY_METHODS include EMAIL, FAX, and PRINTED. | ||
| REMIT_ADVICE_EMAIL | VARCHAR2 | 255 | E-mail address at which the payee wishes to receive remittance advice | ||
| REMIT_ADVICE_FAX | VARCHAR2 | 100 | Fax number at which the payee wishes to receive remittance advice | ||
| START_DATE | DATE | Yes | Date when the payee record becomes inactive. | ||
| END_DATE | DATE | Yes | Date when the payee record becomes active. | ||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise identifier to support multi-tenancy. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_EXTERNAL_PAYEES_ALL | iby_formats_b | PAYMENT_FORMAT_CODE |
| iby_payments_all | iby_external_payees_all | EXT_PAYEE_ID |
| iby_ext_party_pmt_mthds | iby_external_payees_all | EXT_PMT_PARTY_ID |
| iby_temp_ext_bank_accts | iby_external_payees_all | EXT_PAYEE_ID |
| iby_docs_payable_all | iby_external_payees_all | EXT_PAYEE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_EXTERNAL_PAYEES_ALL_N1 | Non Unique | Default | BANK_INSTRUCTION1_CODE |
| IBY_EXTERNAL_PAYEES_ALL_N2 | Non Unique | Default | DEFAULT_PAYMENT_METHOD_CODE |
| IBY_EXTERNAL_PAYEES_ALL_N3 | Non Unique | Default | BANK_INSTRUCTION2_CODE |
| IBY_EXTERNAL_PAYEES_ALL_N4 | Non Unique | Default | PAYMENT_REASON_CODE |
| IBY_EXTERNAL_PAYEES_ALL_N5 | Non Unique | Default | DELIVERY_CHANNEL_CODE |
| IBY_EXTERNAL_PAYEES_ALL_N6 | Non Unique | Default | PAYMENT_FORMAT_CODE |
| IBY_EXTERNAL_PAYEES_ALL_N7 | Non Unique | Default | SUPPLIER_SITE_ID |
| IBY_EXTERNAL_PAYEES_ALL_U1 | Unique | Default | EXT_PAYEE_ID |
| IBY_EXTERNAL_PAYEES_ALL_U2 | Unique | Default | PAYEE_PARTY_ID, PAYMENT_FUNCTION, PARTY_SITE_ID, SUPPLIER_SITE_ID, ORG_ID, ORG_TYPE |