PurchaseAgreements
Holds purchase agreement headers (quantity- or value-based) with negotiated terms, used by subsequent POs or contracts.
Columns
| Name | Type | Description |
| AgreementHeaderId [KEY] | Long | 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. |