PurchaseOrders
Represents finalized purchase orders for goods or services from external suppliers, capturing key terms and statuses.
Columns
| Name | Type | Description |
| POHeaderId [KEY] | Long | 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 | The intent of the purchase order, indicating whether it’s for immediate purchase, a request for quote, or another purpose. |
| SysEffectiveDate | String | 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. |