ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

Supplierssitesassignments

Determines how supplier sites are assigned to internal business units or ledger sets, managing usage boundaries.

Columns

Name Type Description
SuppliersSupplierId [KEY] Long The unique identifier for the supplier associated with the supplier site assignment.
SitesSupplierSiteId [KEY] Long A unique identifier for the supplier site that is assigned to the client business unit in the procurement system.
AssignmentId [KEY] Long A value that uniquely identifies the supplier site assignment, used to track which supplier site is assigned to a particular business unit.
ClientBUId Long The unique identifier for the business unit that is the client of the procurement business unit where the supplier site resides. This ID is used to link supplier sites to specific client business units.
ClientBU String The name of the business unit that is a client of the procurement business unit. This business unit utilizes the supplier site for procurement purposes.
BillToBUId Long The unique identifier for the business unit that the system uses for billing, instead of the client business unit selected by the user.
BillToBU String The name of the business unit that is used for billing purposes instead of the client business unit selected by the user.
ShipToLocationId Long The unique identifier for the default shipping location used on purchasing documents for the client business unit.
ShipToLocation String The name of the default shipping location for the supplier site assignment, used in purchasing transactions.
ShipToLocationCode String An abbreviation identifying the shipping location. Review and update this value in the Setup and Maintenance work area, under the 'Manage Locations' task.
BillToLocationId Long The unique identifier for the default billing location used on purchasing documents for the selected bill-to business unit.
BillToLocation String The name of the default billing location for the supplier site assignment.
BillToLocationCode String An abbreviation identifying the billing location. Review and update this value in the Setup and Maintenance work area, under the 'Manage Locations' task.
UseWithholdingTaxFlag Bool Indicates whether withholding tax applies to the supplier site assignment. 'True' means withholding tax is applicable; 'False' means it is not. Default value is 'False.'
WithholdingTaxGroupId Long A unique identifier for the tax group assigned to the supplier site assignment for withholding tax purposes.
WithholdingTaxGroup String The description of the withholding tax group assigned to the supplier site assignment.
ChartOfAccountsId Long The unique identifier for the chart of accounts used by the supplier site assignment. This helps manage financial transactions for the site.
LiabilityDistributionId Long A unique identifier for the liability distribution used to allocate the liability for new invoices for the supplier site.
LiabilityDistribution String The description of the liability distribution for new invoices associated with the supplier site.
PrepaymentDistributionId Long A unique identifier for the prepayment distribution used to allocate prepayments made for the supplier site.
PrepaymentDistribution String The description of the prepayment distribution associated with the supplier site.
BillPayableDistributionId Long A unique identifier for the bill payable distribution used to allocate the payable bills for the supplier site.
BillPayableDistribution String The description of the bill payable distribution for the supplier site, used to track and manage payable bills.
DistributionSetId Long A unique identifier for the distribution set that determines the distribution of charges on invoices for the supplier site.
DistributionSet String The distribution set used to determine how charges are allocated on invoices for the supplier site.
InactiveDate Date The date when the supplier site assignment was marked as inactive and is no longer used for business transactions.
Status String The current status of the supplier site assignment, which can include 'Active,' 'Inactive,' or 'Pending.'
CreationDate Datetime The timestamp when the supplier site assignment was created in the system.
CreatedBy String The user or system responsible for creating the supplier site assignment.
LastUpdateDate Datetime The timestamp of the most recent update made to the supplier site assignment.
LastUpdatedBy String The user or system responsible for the last update made to the supplier site assignment.
BindPurchaseFlag String Indicates whether the supplier site assignment is bound to purchasing activities. A value of 'True' means it is bound to purchasing; 'False' means it is not.
BindReqBuId Long The unique identifier for the business unit required for processing the supplier site assignment.
BindSourcingOnlyFlag String Indicates whether the supplier site assignment is restricted to sourcing activities only. A value of 'True' means it is sourcing-only; 'False' means other activities are allowed.
BindSysdate Date The system date when the binding operation for the supplier site assignment was executed.
Finder String A reference or search function used to locate or retrieve the supplier site assignment in the system.
SupplierId Long The unique identifier for the supplier associated with the supplier site assignment.

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