PurchaseAgreements
Holds purchase agreement headers (quantity- or value-based) with negotiated terms, used by subsequent POs or contracts.
Columns
| Name | Type | SupportedFinders | Description |
| AgreementHeaderId [KEY] | Long | PrimaryKey | The unique identifier for the purchase agreement header, linking all agreement lines and related information to the overall purchase agreement. |
| AgreementNumber | String | The number assigned to the purchase agreement that uniquely identifies it within the sold-to legal entity, used for reference and tracking. | |
| ProcurementBUId | Long | The unique identifier for the procurement business unit that manages and owns the purchase agreement, helping to associate it with the relevant business unit. | |
| ProcurementBU | String | The name of the procurement business unit responsible for managing and overseeing the purchase agreement. | |
| BuyerId | Long | The unique identifier for the buyer handling the purchase agreement, used for accountability and to link the agreement to the responsible individual. | |
| Buyer | String | The name of the person responsible for managing the purchase agreement, typically the procurement officer or purchasing manager. | |
| DocumentStyleId | Long | The unique identifier for the purchasing document style, used to control and customize the display parameters of the purchase agreement document. | |
| DocumentStyle | String | The name of the purchasing document style, specifying how the purchase agreement document is structured and displayed in the system. | |
| StatusCode | String | A code representing the status of the purchase agreement header, indicating its current state in the agreement lifecycle (for example, 'Active,' 'Closed'). | |
| Status | String | The status of the purchase agreement, providing a human-readable representation of its lifecycle (for example, 'Active,' 'Pending,' 'Completed'). | |
| SupplierId | Long | The unique identifier for the supplier associated with the purchase agreement, used to track the party providing the goods or services. | |
| Supplier | String | The name of the supplier providing the goods or services on the purchase agreement, enabling easy identification of the supplier. | |
| SupplierSiteId | Long | The unique identifier for the supplier site, representing the location where the supplier fulfills the order specified in the purchase agreement. | |
| SupplierSite | String | The name or identifier of the supplier site where the purchase order will be fulfilled, ensuring accurate delivery and site-specific details. | |
| SupplierContactId | Long | The unique identifier for the supplier contact, used to link to the person who communicates with the buyer regarding the purchase agreement. | |
| SupplierContact | String | The name of the person at the supplier organization responsible for managing communications with the buyer about the purchase agreement. | |
| SupplierCommunicationMethodCode | String | The code that identifies the method of communication between the supplier and the buyer, such as email, phone, or fax. | |
| SupplierEmailAddress | String | The email address provided for the supplier, used for sending documents or communication after the purchase agreement has been approved. | |
| SupplierFax | String | The fax number provided for the supplier, used for sending or receiving official documents after the purchase agreement is approved. | |
| StartDate | Date | The date when the purchase agreement becomes effective, indicating when the terms of the agreement are officially valid and enforceable. | |
| EndDate | Date | The date when the purchase agreement expires, marking the end of its validity and the point after which the agreement is no longer applicable. | |
| AgreementAmount | Decimal | The total amount agreed upon for the purchase agreement, representing the monetary value of the agreement between the buyer and supplier. | |
| CurrencyCode | String | The code representing the currency used in the purchase agreement, such as USD for US Dollar or EUR for Euro. | |
| Currency | String | The name of the currency used in the purchase agreement, providing clarity on the financial terms (for example, 'US Dollar,' 'Euro'). | |
| AmountLimit | Decimal | The maximum amount limit for the purchase agreement, beyond which no additional releases or orders can be made against it. | |
| MinimumReleaseAmount | Decimal | The minimum amount that can be released from the purchase agreement when converting requisition lines into purchase orders. | |
| ReleasedAmount | Decimal | The total amount released against the purchase agreement, representing the sum of all amounts for approved purchase orders. | |
| Description | String | A detailed description of the purchase agreement, summarizing its purpose, terms, and other key aspects for easy reference. | |
| DocumentTypeCode | String | The code representing the type of document associated with a change order template, helping to classify the type of document within the system. | |
| MasterContractId | Long | The unique identifier for the master contract associated with the purchase agreement, linking it to overarching contract terms and conditions. | |
| MasterContractNumber | String | The number assigned to the master contract, providing a reference to a higher-level contract that governs the terms of the purchase agreement. | |
| MasterContractTypeId | Long | The unique identifier for the master contract type, used to categorize the contract based on its functionality or purpose. | |
| MasterContractType | String | The name of the master contract type, representing the classification that determines the functionality and terms for the contract. | |
| ConversionRateTypeCode | String | The code representing the type of conversion rate applied to currency exchanges in the purchase agreement (for example, 'Spot,' 'Forward'). | |
| ConversionRateDate | Date | The date used for determining the applicable conversion rate, specifying which exchange rate is applied based on the transaction date. | |
| ConversionRate | Decimal | The actual conversion rate used to convert the purchase agreement amount from one currency to another, based on the applicable rate. | |
| RevisionNumber | Decimal | The revision number of the purchase agreement, indicating changes or updates made to the original document over time. | |
| SupplierAgreement | String | The number provided by the supplier to identify the supplier’s version of the agreement, used for cross-reference and audit purposes. | |
| ReferenceNumber | String | A reference number used for the EDI (Electronic Data Interchange) transaction audit trail, ensuring traceability for electronic communication. | |
| ClosedDate | Date | The date when the purchase agreement was closed, marking the point at which no further changes or releases can be made. | |
| RequiredAcknowledgmentCode | String | Indicates whether an acknowledgment from the supplier is required for the purchase agreement, and if so, the level of acknowledgment needed. | |
| RequiredAcknowledgment | String | The specific acknowledgment required from the supplier, such as 'Document' for acknowledging the purchase agreement or 'Schedule' for acknowledging specific schedules within the agreement. | |
| AcknowledgmentDueDate | Date | The date by which the supplier is required to acknowledge the purchase agreement, ensuring timely confirmation of the terms. | |
| AcknowledgmentWithinDays | Decimal | The number of days within which the supplier must decide to accept or reject the purchase agreement document. | |
| PaymentTermsId | Long | The unique identifier for the payment terms associated with the purchase agreement, detailing how and when payments are to be made. | |
| PaymentTerms | String | The payment terms for the purchase agreement, specifying the conditions under which payments are to be scheduled, including due dates and discount conditions. | |
| CarrierId | Long | The unique identifier for the carrier transporting the item, linking the purchase agreement to the logistics provider responsible for delivery. | |
| Carrier | String | The name of the carrier responsible for transporting the item specified in the purchase agreement, ensuring coordination of delivery logistics. | |
| ModeOfTransportCode | String | The code identifying the mode of transport used to move the goods, such as land, sea, or air. | |
| ModeOfTransport | String | The name of the mode of transport (for example, truck, ship, air) used to deliver the item specified in the purchase agreement. | |
| ServiceLevelCode | String | The code identifying the level of service required for the transportation of goods, affecting delivery speed and conditions. | |
| ServiceLevel | String | The description of the service level for transport, indicating how urgently goods must be delivered (for example, 'Standard,' 'Expedited'). | |
| FreightTermsCode | String | The code representing the type of freight terms for the purchase agreement, specifying who is responsible for transportation charges. | |
| FreightTerms | String | The terms that describe who bears the responsibility for freight charges, such as 'FOB' or 'CIF,' affecting the cost structure for transportation. | |
| FOBCode | String | The code identifying the type of free-on-board (FOB) terms applied to the purchase agreement, which determines when ownership and risk transfer. | |
| FOB | String | The description of the free-on-board (FOB) terms for the purchase agreement, indicating when ownership and responsibility for the goods shift from the supplier to the buyer. | |
| RequiresSignatureFlag | Bool | Indicates whether signatures are required on the purchase document before it can be implemented. 'Yes' means signatures are required, 'No' means they are not. | |
| BuyerManagedTransportFlag | Bool | Indicates whether the buying company is responsible for arranging transportation. 'True' means the buyer arranges the transport, 'False' means the supplier handles it. | |
| PayOnReceiptFlag | Bool | Indicates whether invoices should be automatically generated when supplier-owned material is consumed by the buying organization. 'True' means invoices are generated upon receipt. | |
| ConfirmingOrderFlag | Bool | Indicates whether the purchase agreement is a confirmation of an order that the supplier may already be aware of. 'True' means it's a confirmation, 'False' means it's not. | |
| ConsumptionAdviceFrequencyCode | String | The code indicating the frequency of consumption advice for the purchase agreement, helping to manage inventory and supply chain needs. | |
| ConsumptionAdviceFrequency | String | The value identifying the frequency at which consumption advice is generated for consigned inventory under the agreement, such as 'Daily,' 'Weekly,' or 'Monthly.' | |
| ConsumptionAdviceSummaryCode | String | The code indicating the frequency of consumption advice summaries, which helps consolidate information for the supplier. | |
| ConsumptionAdviceSummary | String | The value identifying the default frequency for generating consumption advice summaries, including options like 'Daily,' 'Weekly,' or 'Monthly.' | |
| AgingOnsetPointCode | String | The code identifying when the aging of consigned material begins, which determines the duration for which inventory can be held before aging. | |
| AgingOnsetPoint | String | The event point agreed upon for when consigned material starts to age, with options like 'None,' 'Receipt,' or 'Shipment.' | |
| AgingPeriodDays | Int | The number of days consigned material can remain in inventory before it is considered aged, after which action may be required. | |
| NoteToReceiver | String | Special instructions for the receiver, providing guidance on how to handle the goods upon receipt in the docking area. | |
| NoteToSupplier | String | A note to the supplier, detailing important information or requests related to the purchase agreement. | |
| AutomaticallyGenerateOrdersFlag | Bool | Indicates whether orders should be automatically generated for requisition lines referencing the purchase agreement. 'True' means automatic order creation is enabled. | |
| AutomaticallySubmitForApprovalFlag | Bool | Indicates whether the purchase agreement document can be automatically submitted for approval. 'True' means automatic submission is enabled. | |
| GroupRequisitionsFlag | Bool | Indicates whether requisition lines from different requisitions referencing the same agreement line should be grouped when creating an order. | |
| UseCustomerSalesOrderFlag | Bool | Indicates whether requisition lines should be grouped by sales order number to create distinct purchase orders. 'True' means they should be grouped. | |
| UseShipToLocationFlag | Bool | Indicates whether requisitions should be grouped by ship-to location when creating orders. 'True' means grouping by location is enabled. | |
| GroupRequisitionLinesFlag | Bool | Indicates whether requisition lines referencing the same agreement line should be grouped together when creating an order. 'True' means they will be grouped. | |
| UseRequestedDateFlag | Bool | Indicates whether the requested delivery date on requisition lines should be used when grouping requisitions. 'True' enables grouping by requested date. | |
| UseShipToOrganizationAndLocationFlag | Bool | Indicates whether item descriptions can be updated on the document lines. 'True' means updates are allowed. | |
| AllowUnassignedSitesFlag | Bool | Indicates whether the agreement can be used to order from supplier sites that are not listed as purchasing sites in the agreement's business unit assignments. | |
| EnableRetroactivePricingFlag | Bool | Indicates whether retroactive pricing updates should be applied to orders. 'True' means open orders will be repriced when price changes are made. | |
| InitiateRetroactivePricingUponApprovalFlag | Bool | Indicates whether retroactive price updates should be initiated upon agreement approval. 'True' means updates are triggered after approval. | |
| RepriceOpenOrdersFlag | Bool | Indicates whether only open unfulfilled orders should be repriced due to a retroactive price update. 'True' enables repricing for open orders. | |
| CommunicateRepricedOrdersFlag | Bool | Indicates whether orders that were repriced due to a price change should be communicated to the supplier. 'True' enables communication. | |
| PunchoutRequestsOnlyFlag | Bool | Indicates whether automatic document sourcing is restricted to punchout requisition lines. 'True' means only punchout requisition lines will source from the agreement. | |
| UseOrderDateForOrderPricingFlag | Bool | Indicates whether the order date should be used to derive the price for orders referencing the agreement. 'True' uses the order date, 'False' uses the requested delivery date. | |
| Priority | Int | The priority assigned to the purchase agreement, affecting the urgency and processing order of the associated orders. | |
| Checklist | String | The unique identifier for the checklist associated with the purchase agreement, providing additional instructions or requirements for processing. | |
| CreationDate | Datetime | The date and time when the purchase agreement was created, providing context for its entry into the system. | |
| CreatedBy | String | The name of the person or system that created the purchase agreement, ensuring accountability for its creation. | |
| LastUpdateDate | Datetime | The date and time when the purchase agreement was last updated, indicating the most recent modifications. | |
| LastUpdatedBy | String | The name of the person or system that last updated the purchase agreement, ensuring accountability for changes. | |
| Finder | String | The search function used to locate the purchase agreement, based on criteria like supplier, status, or agreement number. | |
| EffectiveDate | Date | The date on which the purchase agreement becomes effective, specifying the date from which its terms and conditions are valid. |