JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

PurchaseAgreementsbusinessUnitAccess

Specifies which business units can use a purchase agreement, enabling enterprise-wide or localized access to negotiated terms.

Columns

Name Type Description
PurchaseAgreementsAgreementHeaderId [KEY] Long The unique identifier for the purchase agreement header, linking all business unit access records and related information to the overall agreement.
OrganizationAssignmentId [KEY] Long The unique identifier for the procurement agent assignment, indicating the person or system responsible for managing the business unit access within the purchase agreement.
RequisitioningBUId Long The unique identifier for the business unit that requested the goods or services being purchased, helping to track which business unit initiated the purchase.
RequisitioningBU String The name of the business unit that creates the requisition for the goods or services, ensuring clarity on which department is responsible for the request.
OrderLocallyFlag Bool Indicates whether the client's order should be routed to local supplier sites maintained by the client. 'True' means the order will go to local sites, 'False' means it won't. No default value is provided.
PurchasingSiteId Long The unique identifier for the supplier site associated with the purchasing operating unit, used for routing purchase orders to the correct fulfillment site.
PurchasingSite String The name or identifier of the supplier site where goods are sourced from in the purchasing operating unit, providing context for the logistics of procurement.
ShipToLocationId Long The unique identifier for the location where the supplier will ship the goods or services, helping to track delivery destinations.
ShipToLocationCode String An abbreviation identifying the location where the supplier ships the item, used for efficient routing and inventory management.
ShipToLocation String The name of the location where the supplier ships the goods, providing clarity for shipping and delivery coordination.
BilltoBUId Long The unique identifier for the business unit responsible for processing supplier invoices for the purchase order, ensuring accurate billing and financial tracking.
BillToBU String The name of the business unit that processes supplier invoices for the purchasing document, providing accountability for financial operations.
BillToLocationId Long The unique identifier for the bill-to location, ensuring proper invoice processing by indicating where the invoice should be sent.
BillToLocation String The name or identifier of the location where the supplier sends the invoice, aiding in correct financial and accounting processes.
EnabledFlag Bool Indicates whether the business unit access record for the purchase agreement is active or disabled. 'True' means it is enabled, 'False' means it is disabled. No default value is provided.
CreatedBy String The name of the user who created the business unit access record for the purchase agreement, ensuring accountability for data entry.
CreationDate Datetime The date and time when the business unit access record for the purchase agreement was created, providing a historical record of the assignment.
LastUpdatedBy String The name of the user who last updated the business unit access record for the purchase agreement, ensuring accountability for changes made.
LastUpdateDate Datetime The date and time when the business unit access record was last updated, providing a clear record of recent modifications.
AgreementHeaderId Long The unique identifier for the purchase agreement header, used to link this record to the purchase agreement's overall terms and conditions.
Finder String The search function or query mechanism used to locate or filter business unit access records associated with the purchase agreement.
EffectiveDate Date The date used to fetch business unit access records that are effective as of this date, ensuring that the correct version of the record is retrieved.

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