Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

PurchaseAgreementsbusinessUnitAccess

Agreement business unit access contains mapping for client requisitioning business units that can make purchases using the agreement. For example, a blanket purchase agreement with supplier Advanced Network Devices is hosted by Vision Operations, and is made available to Vision Services where Vision Operations provides the procurement service for all requisitions created by its client, Vision Services.

Columns

Name Type Description
PurchaseAgreementsAgreementHeaderId [KEY] Long Value that uniquely identifies the purchase agreement.
OrganizationAssignmentId [KEY] Long Value that uniquely identifies the procurement agent assignment.
RequisitioningBUId Long Value that uniquely identifies the business unit that requested the goods or services being purchased.
RequisitioningBU String Business unit that creates the requisition.
OrderLocallyFlag Bool Contains one of the following values: true or false. If true, then the client's order for items on the agreement should be routed to local supplier sites maintained by the client. If false, then the client's order for items on the agreement won't route to local supplier sites maintained by the client. This attribute doesn't have a default value.
PurchasingSiteId Long Value that uniquely identifies the supplier site for the purchasing operating unit.
PurchasingSite String Value that uniquely identifies the supplier site for the purchasing operating unit.
ShipToLocationId Long Value that uniquely identifies the location where the supplier ships the shipment item.
ShipToLocationCode String Abbreviation that identifies the location where the supplier ships the item.
ShipToLocation String Name of the location where the supplier ships the item.
BilltoBUId Long Value that uniquely identifies the business unit that processes supplier invoices for the purchase order.
BillToBU String Value that identifies the business unit that processes supplier invoices for the purchasing document.
BillToLocationId Long Value that uniquely identifies the bill-to location.
BillToLocation String Value that identifies the bill-to location where the supplier sends the invoice.
EnabledFlag Bool Contains one of the following values: true or false. If true, then the business unit assignment record on the agreement is enabled. If false, then business unit assignment record on the agreement is disabled. This attribute doesn't have a default value.
CreatedBy String User who created the business unit access on the purchase agreement
CreationDate Datetime Date and time when the buyer or application created the purchase agreement.
LastUpdatedBy String User who last updated the business unit access of a purchase agreement.
LastUpdateDate Datetime Date and time when the buyer or application last updated the business unit access of a purchase agreement.
AgreementHeaderId Long agreementheaderid
Finder String finder
EffectiveDate Date This query parameter is used to fetch resources which are effective dated as of the specified start date.

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