CData Python Connector for Oracle Fusion Cloud Financials

Build 26.0.9770

SupplierNegotiationPurchasingDocumentsPurchasingDocuments

Returns the purchasing documents associated with supplier negotiations.

Columns

Name Type SupportedFinders Description
SupplierNegotiationPurchasingDocumentsAuctionHeaderId [KEY] Long Value that finds purchasing document header details using the AuctionHeaderId as the primary key.
ResponseNumber [KEY] Long Uniquely identifies supplier's response for a negotiation.
SequenceNumber [KEY] Decimal Display sequence of the staged purchasing documents or purchasing documents within a negotiation.
AuctionHeaderId Long PrimaryKey Value that uniquely identifies a negotiation.
RequiredAcknowledgementCode String Abbreviation identifying the acknowledgment required from the supplier for the purchase order. Values include: Y (Document and Schedule), D (Document), and N (None).
AcknowledgeWithinDays Decimal Value that specifies the deadline by which a supplier must acknowledge the document to the buyer.
ExistingAgreementMatchingLineActionTypeCode String Abbreviation that identifies if matching lines from an existing purchasing document need to be expired, updated, or added.
InitiateApprovalFlag Bool Value that indicates whether to initiate approval for a purchasing document.
SupplierSiteId Long Value that identifies the supplier site.
AgreementEndDate Date Date when the purchase agreement expires.
AgreementStartDate Date Date when the purchase agreement goes into effect.
RequisitioningBUId Long Unique identifier of the requisitioning business unit in business unit access.
AgreementAmount Decimal Total amount on the purchase agreement.
SupplierId Long Value that uniquely identifies the supplier.
BuyerId Long Value that uniquely identifies the user who created the negotiation.
AutomaticallyGenerateOrdersFlag Bool Value that indicates whether to automatically generate orders for the agreement.
AutomaticallySubmitForApprovalFlag Bool Value that indicates whether to automatically submit the agreement for approval.
GroupRequisitionsFlag Bool Value that indicates whether to group requisitions for the agreement.
GroupRequisitionsLinesFlag Bool Value that indicates whether to group requisition lines for the agreement.
UseRequestedDateFlag Bool Value that indicates whether to group requisition lines by using the requested date for the agreement.
UseShipToOrganizationAndLocationFlag Bool Group requisition lines using ship to organization and location.
RepriceOpenOrdersOnlyFlag Bool Indicates whether the retroactive price update background process should reprice only open, unfulfilled orders referencing the agreement.
CommunicateRepricedOrdersFlag Bool Indicates whether orders repriced because of a price change on the referenced agreement should be communicated to the supplier.
TotalAwardAmount Decimal The total amount awarded to the supplier response.
TotalAwardAmountResponseCurrency Decimal Total award amount of a purchasing document in the response currency.
NumberOfAwardedLines Long Number of awarded lines in a staged purchasing document.
VendorId Long Value that uniquely identifies the supplier.
TotalAgreementAmount Decimal The total amount of all lines in the purchase agreement.
TotalAgreementAmountResponseCurrency Decimal Total agreement amount of a purchasing document in the response currency.
ContractId Long Unique identifier that represents a contract.
ResponseCurrencyCode String Abbreviation that identifies the currency that the response uses.
Supplier String Name of the supplier who responds to the negotiation.
SupplierSite String Name of the supplier site.
IsSupplierSiteEditableFlag Bool Value that indicates if the supplier site is editable or read-only for a staged purchasing document.
DocumentFiscalClassification String Value that uniquely identifies the document's fiscal classification.
RequisitioningBU String Name of the requisitioning business unit.
ProcurementBUId Long Value that uniquely identifies the procurement business unit that owns the negotiation.
ContractType String Value that uniquely identifies the contract type for the short-term or long-term purchase.
UpdateExistingAgreementFlag Bool Value that indicates whether updating an existing agreement from a sourcing award is enabled.
SupplierContact String Name of the supplier contact at the supplier that responds to the negotiation.
PricePrecision Int Indicates the accuracy (number of decimal places) with which the price values will be displayed in the award.
SoldToLEName String Indicates the party financially responsible for the purchases on a purchase order.
BillToLocation String Name of the bill-to location in the business unit access.
UsePurchasingDocumentHeaderId Long Value that uniquely identifies a purchasing document to which the awarded lines should be added.
PurchasingDocumentNumber String Number that identifies a purchasing document.
PurchasingDocumentHeaderId Long Value to uniquely identify a purchasing document.
HasPendingChangeOrder String Value that indicates whether a purchasing document has a pending change order.
TerritoryShortName String Name of the country where the transaction is deemed to have taken place for taxation purposes.
DisplayInitiateApprovalFlag Bool Value that indicates whether to display the text Initiate Approval.
PurchasingDocumentStatus String Status of the purchasing document.
PurchasingDocumentStatusCode String Abbreviation that identifies the status of the purchasing document.
RelationshipId Long Value to uniquely identify the relationship of the supplier contact.
Buyer String Name of the user who created the negotiation.
RequiredAcknowledgement String Acknowledgment required by the application from the supplier. Values include: Document and Schedule when the supplier must acknowledge the header and line of the purchase agreement, Document when the supplier must acknowledge the header of the purchase agreement, or None when the purchase agreement doesn't require acknowledgment.
SupplierContactId Long Value that uniquely identifies the supplier contact.
BillToLocationId Long Unique identifier of the bill-to location in the business unit access.
BilltoBUId Long Unique identifier of the bill-to business unit that vouches for the supplier invoices received for the purchase order.
SoldtoLeId Long Unique identifier of the party financially responsible for purchases on a purchase order.
BilltoBU String Name of the bill-to business unit for an agreement.
ProgressPaymentFlag Bool Indicates whether progress payments are enabled on the outcome document style.
UsePurchasingDocumentHeader String Purchasing document number the awarded lines will be added to.
ExistingAgreementMatchingLineActionType String Indicates if matching lines from an existing purchasing document need to be expired, updated, or added.
AwardedAlternateLineExistsFlag Bool Contains one of the following values: true or false. If true, the negotiation has at least one alternate line awarded. If false, the negotiation doesn't have any alternate lines awarded.
Finder String A named finder reference used to filter or locate specific supplier negotiation purchasing documents when querying.

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