SSIS Components for Oracle Fusion Cloud Financials

Build 25.0.9434

PaymentsExternalPayeesexternalPartyPaymentMethods

Lists payment methods (such as check, EFT or ACH) available to a specific external payee, ensuring valid disbursement choices.

Columns

Name Type Description
PaymentsExternalPayeesPayeeId [KEY] Long Unique identifier for the payee in the PaymentsExternalPayees table, which is used to track external payees in the payment system.
ExternalPartyPaymentMethodsId [KEY] Long Unique identifier for the external party payment method assignment. This associates a payment method with a specific payee.
PayeeId Long Unique identifier of the external payee associated with the payment method. This is used to link the payment method to the payee in the system.
PayeeName String The name of the payee associated with the payment method. This identifies the recipient of payments.
PaymentMethodCode String Code assigned to the payment method, which defines how the payment is processed (for example, bank transfer or check).
PaymentMethodName String The name of the payment method, corresponding to the PaymentMethodCode. This provides a human-readable description of the payment method.
PrimaryIndicator String Indicates whether this payment method is the primary one used for making payments to the payee. It helps identify the default payment method.
FromDate Date The date when the assignment of the payment method to the payee becomes effective.
ToDate Date The date when the assignment of the payment method to the payee ends or becomes inactive.
SiteName String The name of the site associated with the external payee. This identifies the location related to the payee’s account.
AddressName String The name of the address associated with the external payee’s site. This is typically used for billing or payment purposes.
Finder String A reference identifier used to locate or search for a particular external party payment method within the system.
Intent String The intended purpose of the payment method, defining whether the payment is for supplier disbursement, employee expenses, or another payment function.
OrganizationName String The name of the organization associated with the external payee, such as the company or business unit responsible for the payee.
PartyName String The name of the party associated with the external payee, which is typically the entity representing the payee in the system.
PayeePartyIdentifier Long Unique identifier of the party (business or individual) that represents the external payee in the system.
PayeePartyNumber String A unique number assigned to the payee party, typically used to reference the payee in related documents and transactions.
PayeePartySiteIdentifier Long Unique identifier for the specific site of the external payee. This helps distinguish between multiple sites for the same payee.
PayeePartySiteNumber String Number assigned to the specific site of the external payee. This is useful when multiple sites exist for the same payee.
PaymentFunctionCode String Code representing the function or purpose of the payment to the external payee, such as supplier payment or employee expense reimbursement.
SupplierNumber String Unique number assigned to the supplier, which identifies them in procurement or supply chain management systems.
SupplierSiteCode String Code assigned to the supplier’s site, used to track transactions and payments associated with a specific location of the supplier.
SupplierSiteIdentifier Long Unique identifier for the supplier site, used to associate payment methods and other details with specific supplier locations.

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