Power BI Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

PaymentsExternalPayees

The payments external payees resource is used to view, create, and modify an external payee.

Columns

Name Type Description
PayeeId [KEY] Long Application-generated identifier of the external payee.
PaymentFunctionCode String Code that indicates the function or purpose of the payment. Values from the IBY_PAYMENT_FUNCTIONS lookup include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and Others.
OrganizationIdentifier String Identifier of the business unit associated with an external payee.
OrganizationName String Name of the business unit associated with an external payee.
OrganizationType String OrganizationType of PaymentsExternalPayees
PayEachDocumentAloneOption String Indicates whether documents payable for an external payee are prevented from being grouped with other like documents payable for payment.
DefaultPaymentMethodCode String DefaultPaymentMethodCode of PaymentsExternalPayees
DefaultPaymentMethodName String DefaultPaymentMethodName of PaymentsExternalPayees
BankChargeBearerCode String Code of an external payee who is responsible for paying regular or express bank charges, such as Payee or Payer. Values are from the IBY_BANK_CHARGE_BEARER lookup.
BankChargeBearerName String Name of an external payee who is responsible for paying regular or express bank charges, such as Payee or Payer.
BankInstructionCodeOne String Code of the first bank instruction to an external payee.
BankInstructionNameOne String Name of the first bank instruction to the external payee.
BankInstructionCodeTwo String Code of the second bank instruction to the external payee.
BankInstructionNameTwo String Name of the second bank instruction to an external payee.
BankInstructionDetails String Details of an additional bank instruction to an external payee.
PaymentReasonCode String Code of the reason for paying an external payee.
PaymentReasonName String Name of the reason for paying an external payee.
PaymentReasonComments String Text field available for entering information about an external payee payment.
PaymentTextMessageOne String First text payment message to an external payee.
PaymentTextMessageTwo String Second text payment message to an external payee.
PaymentTextMessageThree String Third text payment message to an external payee.
DeliveryChannelCode String Code of the delivery channel for an external payee.
DeliveryChannelName String Name of the delivery channel for an external payee.
ServiceLevelCode String Code of the service level for an external payee.
ServiceLevelName String Name of the service level for an external payee.
SettlementPriority String Priority with which the financial institution or payment system settles payments for an external payee.
DeliveryMethod String Delivery method that is set on the external payee level. If the Override with Payee Delivery Method Preference option on the payment process profile is turned off, the setting is ignored. Values from the IBY_DELIVERY_METHODS lookup include EMAIL, FAX, and PRINTED.
Email String Email address at which an external payee receives remittance advice.
Fax String Fax number at which an external payee receives remittance advice.
PayeePartyIdentifier Long Identifier of an external payee.
PartyName String Name of an external payee.
PayeePartyNumber String Application-generated party number in Trading Community Architecture.
PayeePartySiteIdentifier Long Identifier of an external payee site.
SupplierNumber String Application-generated party number in Procurement.
SupplierSiteCode String Code of a supplier site.
SupplierSiteIdentifier Long Identifier of a supplier site.
PayeePartySiteNumber String Number of an external payee site.
PaymentFormatCode String Code of the payment format that is associated with an external payee.
PaymentFormatName String Name of the payment format that is associated with an external payee.
PersonId Long Person identifier when the external payee is an employee.
Intent String Purpose of the external payee. The value is based on the payment function of the external payee. The following are the expected values: PAYABLES_DISB - Supplier, EMPLOYEE_EXP - Person, EMPLOYEE_EXP - Employee, AR_CUSTOMER_REFUNDS - Refund, CUSTOMER_PAYMENT - Customer, ONETIME_PAYMENT - Onetime, and ADHOC_PAYMENT - Adhoc.
Finder String Finder of PaymentsExternalPayees

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060