CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

PaymentsExternalPayees

Defines external payees (for example, suppliers, vendors) for payments, enabling creation and modification of payee records.

Columns

Name Type Description
PayeeId [KEY] Long This column holds the unique identifier of the external payee in the financial system, which is automatically generated by the application.
PaymentFunctionCode String This code identifies the function or purpose of the payment. It maps to predefined values in the IBY_PAYMENT_FUNCTIONS lookup, including categories such as SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and others.
OrganizationIdentifier String This column contains the unique identifier associated with the business unit that is linked to an external payee, used for organizational classification.
OrganizationName String This column stores the name of the business unit tied to an external payee, helping distinguish between different payee relationships in financial transactions.
OrganizationType String Defines the type of organization for the external payee, classifying the payee within organizational structures such as company, department, or external vendor.
PayEachDocumentAloneOption String Indicates whether the external payee's documents are required to be processed separately from other documents, ensuring they are not grouped with other payees for payment.
DefaultPaymentMethodCode String This column stores the default payment method code, indicating how payments to the external payee are typically processed, such as bank transfer or check.
DefaultPaymentMethodName String The name corresponding to the default payment method of the external payee, used to simplify transaction processing by assigning a standard method.
BankChargeBearerCode String Specifies who is responsible for paying the bank charges in a payment transaction. The values for this field are defined in the IBY_BANK_CHARGE_BEARER lookup, with options like Payee or Payer.
BankChargeBearerName String This column stores the name of the external payee responsible for paying the bank charges, as defined by the IBY_BANK_CHARGE_BEARER lookup.
BankInstructionCodeOne String This is the code used for the first bank instruction, specifying the exact action the payee’s bank should perform for the transaction.
BankInstructionNameOne String Contains the name or description of the first bank instruction, providing clarity on the specific action required from the payee's bank.
BankInstructionCodeTwo String The code of the second bank instruction for an external payee, used to indicate additional steps or actions to be taken by the bank during the transaction.
BankInstructionNameTwo String The name associated with the second bank instruction, describing the action the bank is required to take as per the second set of instructions.
BankInstructionDetails String Stores any additional information regarding further bank instructions, providing more context on the required actions from the bank in the transaction.
PaymentReasonCode String The code representing the reason for making a payment to the external payee, such as for services rendered or refund processing.
PaymentReasonName String The name of the reason for the payment to the external payee, providing more context about the nature of the transaction.
PaymentReasonComments String Allows for the inclusion of additional text to explain or provide further details on the reason for making the payment to the external payee.
PaymentTextMessageOne String The first message that is sent to the external payee as part of the payment notification or remittance advice.
PaymentTextMessageTwo String The second message included with the payment notification, which can provide further details to the payee.
PaymentTextMessageThree String The third message in the set of payment notifications, allowing more specific information to be shared with the external payee.
DeliveryChannelCode String The code of the delivery channel used for communicating with the external payee. This could include methods such as EMAIL, FAX, or PRINTED.
DeliveryChannelName String This column stores the name of the delivery channel used for communication with the external payee, helping categorize the communication method.
ServiceLevelCode String Represents the code that defines the service level for the external payee, which impacts how promptly or securely payments are processed.
ServiceLevelName String This column holds the name associated with the service level, which provides a descriptive label for the type of service provided to the external payee.
SettlementPriority String Defines the priority with which payments to the external payee are processed, affecting the speed of settlement by the financial institution or payment system.
DeliveryMethod String Specifies how the payment information or remittance advice is delivered to the external payee, based on the defined preferences for delivery such as EMAIL, FAX, or PRINTED.
Email String The email address where remittance advice is sent to the external payee, enabling electronic communication of payment details.
Fax String The fax number at which the external payee receives remittance advice, used for traditional methods of communicating payment information.
PayeePartyIdentifier Long A unique identifier for an external payee party, used to link the payee with payment records and manage their information.
PartyName String The name of the external payee party, used for identifying and distinguishing payees in the payment system.
PayeePartyNumber String An application-generated number for the external payee in the Trading Community Architecture, used for tracking and referencing within the system.
PayeePartySiteIdentifier Long The identifier associated with the specific site or location of the external payee, useful for managing payee records in multiple locations.
SupplierNumber String An application-generated identifier for a supplier within the procurement system, used to track suppliers for payment purposes.
SupplierSiteCode String The code used to identify the supplier site, important for distinguishing between different locations of the same supplier.
SupplierSiteIdentifier Long The unique identifier for a supplier site, helping the system differentiate between multiple supplier locations for payment or ordering.
PayeePartySiteNumber String The number assigned to an external payee site, which helps in organizing and categorizing multiple payee sites.
PaymentFormatCode String The code associated with the payment format used for processing payments to an external payee, like ACH or wire transfer.
PaymentFormatName String The name of the payment format, providing an easily recognizable label for the type of payment method associated with the external payee.
PersonId Long The identifier used when the external payee is an employee, tying the payment to the individual within the organization.
Intent String Describes the purpose of the external payee in the context of the payment. Common values include PAYABLES_DISB (supplier), EMPLOYEE_EXP (person), AR_CUSTOMER_REFUNDS (refund), and others.
Finder String A search term or query used to filter or identify external payees in the system, assisting in quick access and management of payee records.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454