Power BI Connector for Oracle Fusion Cloud Financials

Build 26.0.9770

CustomerAccountSitesLOV

Displays customer account site details, linking customers to specific billing or shipping addresses for transaction processing.

Columns

Name Type SupportedFinders Description
CustomerName String ReceivablesCustomerAccountFinder The name of the customer associated with the account site, used for identification in the CustomerAccountSitesLOV table.
AccountNumber String ReceivablesCustomerAccountSiteFinder, ReceivablesCustomerAccountFinder The unique account number linked to the customer site, representing the specific financial account within the CustomerAccountSitesLOV table.
AccountDescription String ReceivablesCustomerAccountFinder A description of the account, providing additional context or details regarding the purpose or nature of the financial account in the CustomerAccountSitesLOV table.
TaxpayerIdentificationNumber String ReceivablesCustomerAccountFinder The unique identifier assigned by the tax authority to the customer, used for tax reporting and compliance purposes in the CustomerAccountSitesLOV table.
TaxRegistrationNumber String ReceivablesCustomerAccountFinder The registration number issued by the tax authority, used to track tax-related activities for the customer account in the CustomerAccountSitesLOV table.
CustomerAccountId Long The unique identifier for the customer account, linking the customer site to the overall customer account within the financial system.
PartyNumber String The identification number of the party (individual or organization) associated with the customer account site, used for party management and relationship tracking.
SiteName String ReceivablesCustomerAccountSiteFinder The name of the site associated with the customer account, providing a clear label for the specific physical or operational location.
PrimarySite String ReceivablesCustomerAccountFinder, ReceivablesCustomerAccountSiteFinder A flag or indication of whether this site is the primary location for the customer account, often used for priority or default handling in operations.
SiteUseId [KEY] Long PrimaryKey A unique identifier for the intended use or function of the site, specifying whether it is used for billing, shipping, or another purpose within the CustomerAccountSitesLOV table.
SetName String The name of the set to which the customer account site belongs, typically used for grouping related sites within a larger organizational structure.
Finder String An identifier or description of the method used to locate the customer account site, typically for internal search or query operations in the system.
SitePurpose String ReceivablesCustomerAccountSiteFinder, ReceivablesCustomerAccountFinder The specific purpose or function of the site, such as 'billing', 'shipping', or 'operational', used to categorize and manage customer sites effectively.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770