PurchaseOrders
Represents finalized purchase orders for goods or services from external suppliers, capturing key terms and statuses.
Columns
| Name | Type | SupportedFinders | Description |
| POHeaderId [KEY] | Long | PrimaryKey, findByIntent | The unique identifier for the purchase order header, linking all details of the purchase order to its overall record. |
| OrderNumber | String | The unique order number assigned to the purchase order, used for tracking and referencing the order within the procurement process. | |
| SoldToLegalEntityId | Long | The unique identifier for the legal entity to which the purchase order is billed, ensuring accurate invoicing and financial processing. | |
| SoldToLegalEntity | String | The name of the legal entity to which the purchase order is billed, providing clarity for financial operations and legal records. | |
| StatusCode | String | The status code representing the current state of the purchase order, such as 'Open,' 'Closed,' 'Pending.' | |
| Status | String | The human-readable status of the purchase order, reflecting its current stage in the procurement and approval process. | |
| ProcurementBUId | Long | The unique identifier for the procurement business unit responsible for managing and overseeing the purchase order. | |
| ProcurementBU | String | The name of the procurement business unit that owns and manages the purchase order, ensuring proper oversight and management. | |
| RequisitioningBUId | Long | The unique identifier for the business unit that initiated the purchase requisition, linking the order to the requesting department. | |
| RequisitioningBU | String | The name of the business unit that created the requisition, providing context for which department initiated the purchase. | |
| BillToBUId | Long | The unique identifier for the business unit responsible for processing supplier invoices for the purchase order. | |
| BillToBU | String | The name of the business unit responsible for processing the invoices for the purchase order, ensuring proper financial accountability. | |
| Revision | Decimal | The revision number of the purchase order, used to track changes or updates to the original order. | |
| BuyerId | Long | The unique identifier for the buyer managing the purchase order, ensuring accountability for the procurement process. | |
| Buyer | String | The name of the buyer responsible for managing and overseeing the purchase order, ensuring proper execution of procurement tasks. | |
| SupplierId | Long | The unique identifier for the supplier providing the goods or services, ensuring accurate supplier tracking and relations. | |
| Supplier | String | The name of the supplier fulfilling the purchase order, providing clarity on who is responsible for delivery. | |
| SupplierSiteId | Long | The unique identifier for the supplier site from which goods or services are provided, ensuring proper delivery and fulfillment. | |
| SupplierSite | String | The name or identifier of the supplier site, providing context for the logistics of fulfilling the purchase order. | |
| SupplierContactId | Long | The unique identifier for the supplier contact person, ensuring direct communication with the appropriate representative. | |
| SupplierContact | String | The name of the supplier's contact person, ensuring clear communication with the right individual at the supplier organization. | |
| BillToLocationId | Long | The unique identifier for the location where invoices for the purchase order should be sent, ensuring proper financial processing. | |
| BillToLocation | String | The name or identifier of the location where supplier invoices for the purchase order should be directed. | |
| ConversionRateType | String | The type of conversion rate applied to the purchase order, used for currency exchange between different financial systems or entities. | |
| Ordered | Decimal | The total number of items ordered in the purchase order, used to track quantity and manage procurement. | |
| OrderedAmountBeforeAdjustments | Decimal | The total amount of the order before any adjustments, such as discounts or taxes, are applied. | |
| CreditAmount | Decimal | The total amount of credit applied to the purchase order, often due to returns, overpayments, or negotiated discounts. | |
| DiscountAmount | Decimal | The total discount amount applied to the purchase order, providing financial relief or savings on the order. | |
| CurrencyCode | String | The currency code used for the purchase order, indicating which currency the financial amounts are represented in (for example, USD, EUR). | |
| Currency | String | The name of the currency used for the purchase order, providing clarity on the currency type in use for the transaction. | |
| TotalTax | Decimal | The total tax amount applied to the purchase order, ensuring compliance with local tax regulations and financial reporting. | |
| Total | Decimal | The total value of the purchase order, including items, taxes, and any applicable discounts or adjustments. | |
| Description | String | A brief description of the purchase order, summarizing the nature of the purchase or purpose of the order. | |
| MasterContractId | Long | The unique identifier for the master contract associated with the purchase order, linking the order to a broader contractual agreement. | |
| MasterContractNumber | String | The number associated with the master contract, used to reference and manage the overarching contractual terms. | |
| MasterContractTypeId | Long | The unique identifier for the type of master contract, used to classify the nature of the agreement (for example, blanket, framework). | |
| MasterContractType | String | The type of master contract associated with the purchase order, indicating the contract's structure and terms (for example, 'Framework,' 'Blanket'). | |
| RequiredAcknowledgmentCode | String | The code indicating whether a supplier acknowledgment is required for the purchase order, and if so, at what level (for example, header, item). | |
| RequiredAcknowledgment | String | The acknowledgment requirement for the supplier, indicating if the supplier must confirm receipt or terms of the purchase order. | |
| SupplierOrder | String | The order number assigned by the supplier for the goods or services being provided, used to track the supplier’s fulfillment. | |
| ReferenceNumber | String | A reference number used for external tracking or for communication with suppliers, often used in EDI or for audit purposes. | |
| AcknowledgmentDueDate | Date | The date by which the supplier is required to acknowledge receipt or acceptance of the purchase order. | |
| PaymentTermsId | Long | The unique identifier for the payment terms associated with the purchase order, used for scheduling payments. | |
| PaymentTerms | String | The payment terms specified in the purchase order, indicating the conditions under which payment is due (for example, 'Net 30'). | |
| CarrierId | Long | The unique identifier for the carrier responsible for delivering the goods in the purchase order, ensuring proper logistics tracking. | |
| Carrier | String | The name of the carrier responsible for the delivery of goods under the purchase order, providing context for shipping logistics. | |
| ModeOfTransportCode | String | The code representing the mode of transport used to deliver the goods (for example, 'Air,' 'Sea,' 'Land'). | |
| ModeOfTransport | String | The mode of transport used for delivering the goods or services under the purchase order, clarifying shipping logistics (for example, 'Air,' 'Truck'). | |
| ServiceLevelCode | String | The code representing the level of service for the delivery, such as 'Expedited,' 'Standard.' | |
| ServiceLevel | String | The description of the service level for the delivery, indicating the speed and quality of the transportation service (for example, 'Overnight,' '2-Day'). | |
| ShippingMethod | String | The method used for shipping the goods under the purchase order, providing clarity on the delivery method. | |
| FreightTermsCode | String | The code representing the freight terms for the order, specifying the responsibility for shipping costs (for example, 'FOB'). | |
| FreightTerms | String | The freight terms for the order, describing who pays for shipping (for example, 'FOB Origin,' 'Prepaid'). | |
| FOBCode | String | The code representing the freight on board (FOB) terms, defining the point at which ownership of goods transfers from seller to buyer. | |
| FOB | String | The description of the freight on board (FOB) terms, indicating when the risk and ownership of the goods are transferred (for example, 'FOB Origin'). | |
| RequiresSignatureFlag | Bool | Indicates whether a signature is required upon delivery of the goods, providing security and confirmation of receipt. | |
| AcknowledgeWithinDays | Decimal | The number of days within which the supplier is required to acknowledge the purchase order, ensuring timely responses. | |
| BuyerManagedTransportFlag | Bool | Indicates whether the buying company is responsible for arranging transportation, ensuring clarity on who handles logistics. | |
| PayOnReceiptFlag | Bool | Indicates whether payment for the order should be made upon receipt of the goods, helping manage financial terms. | |
| ConfirmingOrderFlag | Bool | Indicates whether the purchase order is a confirmation of a previous order, helping to track order statuses. | |
| NoteToSupplier | String | A note or special instruction directed to the supplier, providing additional context or requests related to the purchase order. | |
| NoteToReceiver | String | Special instructions for the receiving party, helping to clarify handling, inspection, or any other special requirements for the received goods. | |
| CreationDate | Datetime | The date and time when the purchase order was created, providing a historical record of when the order was initiated. | |
| CreatedBy | String | The name of the user or system that created the purchase order, ensuring accountability for the data entry. | |
| LastUpdateDate | Datetime | The date and time when the purchase order was last updated, ensuring that the most recent changes are reflected. | |
| LastUpdatedBy | String | The name of the user or system that last updated the purchase order, ensuring accountability for any modifications. | |
| ImportSourceCode | String | The code representing the source from which the purchase order was imported, such as an external system or manual entry. | |
| OverridingApproverId | Long | The unique identifier for the user responsible for overriding approval processes for the purchase order. | |
| OverridingApprover | String | The name of the user responsible for overriding the approval processes for the purchase order, ensuring accountability for exceptions. | |
| SupplierCommunicationMethodCode | String | The code representing the method of communication with the supplier (for example, 'Email,' 'Fax'). | |
| SupplierBccEmailAddress | String | The email address to which a blind carbon copy (BCC) of the purchase order will be sent for supplier communication. | |
| SupplierEmailAddress | String | The email address to which the purchase order will be sent for supplier communication, ensuring direct contact. | |
| SupplierFax | String | The fax number to which the purchase order can be sent for supplier communication, in case of manual order processing. | |
| SupplierCcEmailAddress | String | The email address to which a carbon copy (CC) of the purchase order will be sent for supplier communication. | |
| OverrideB2BCommunicationFlag | Bool | Indicates whether business-to-business communication settings should be overridden for this purchase order. | |
| AdditionalContactEmail | String | The email address of an additional contact person related to the purchase order, providing an alternative method of communication. | |
| SpecialHandlingType | String | The type of special handling required for the goods under the purchase order, such as 'Fragile' or 'Temperature Sensitive.' | |
| SpecialHandlingTypeCode | String | The code representing the special handling type for the purchase order, ensuring proper treatment of the goods during shipping. | |
| ConversionRate | Decimal | The conversion rate applied to the purchase order for currency exchange, ensuring the correct value is calculated when multiple currencies are involved. | |
| ConversionRateDate | Date | The date used to determine the applicable conversion rate for the purchase order, reflecting the correct rate based on the date of the order. | |
| Requisition | String | The requisition number associated with the purchase order, linking it to the original requisition request. | |
| SourceAgreement | String | The source agreement number from which the purchase order is derived, helping to track the agreement's origin. | |
| SalesOrder | String | The sales order number associated with the purchase order, linking it to the sales process and tracking. | |
| Negotiation | String | The negotiation identifier associated with the purchase order, providing a reference to the terms negotiated. | |
| ShipToLocationId | Long | The unique identifier for the location where goods are delivered as part of the purchase order, helping with logistics. | |
| ShipToLocationCode | String | The code for the location where goods are shipped, ensuring proper delivery tracking. | |
| ShipToLocationAddress | String | The address of the location where goods are shipped, providing full details for shipping. | |
| RequesterId | Long | The unique identifier for the person who requested the purchase order, ensuring accountability for the request. | |
| RequesterDisplayName | String | The name of the person who requested the purchase order, providing clarity for tracking purposes. | |
| BuyerDisplayName | String | The name of the buyer responsible for processing the purchase order, ensuring accountability for purchase order management. | |
| SupplierCommunicationMethod | String | The method of communication used to contact the supplier regarding the purchase order (for example, 'Email,' 'Fax'). | |
| SupplierContactDisplayName | String | The name of the supplier's contact person for the purchase order, providing a clear point of contact for communication. | |
| DocumentStyleId | Long | The unique identifier for the document style associated with the purchase order, ensuring consistency in formatting and terms. | |
| ProgressPaymentFlag | Bool | Indicates whether the purchase order involves progress payments, providing a flag for payment tracking. | |
| PurchaseBasis | String | The basis on which the purchase order is made (for example, 'Fixed Price,' 'Time and Materials'), defining the procurement model. | |
| DocumentStyle | String | The style used for the purchase order document, ensuring consistent formatting and layout across orders. | |
| OverridingApproverDisplayName | String | The name of the approver responsible for overriding approval workflows for the purchase order, ensuring transparency. | |
| ConsignmentTermsFlag | Bool | Indicates whether the purchase order follows consignment terms, providing flags for inventory and payment control. | |
| Finder | String | The search function or query used to locate or filter purchase orders, helping to retrieve specific data based on criteria. | |
| Intent | String | FindByIntent | The intent of the purchase order, indicating whether it’s for immediate purchase, a request for quote, or another purpose. |
| SysEffectiveDate | String | FindByIntent | The system effective date used to determine the active records at the time of the query, ensuring accurate data retrieval. |
| EffectiveDate | Date | The date from which the purchase order is effective, ensuring proper tracking and management of the order’s lifecycle. |