PurchaseOrderSchedules
Manages delivery schedules within a purchase order, tracking ship-to locations, dates, and associated quantities.
Columns
| Name | Type | Description |
| SoldToLegalEntityId | Long | The unique identifier for the legal entity that the purchase order is billed to, ensuring proper invoicing and legal alignment. |
| POHeaderId | Long | The unique identifier for the purchase order header, linking the purchase order schedule to its associated header. |
| OrderNumber | String | The unique order number associated with the purchase order, used for tracking and reference in procurement processes. |
| BuyerId | Long | The unique identifier for the buyer handling the purchase order schedule, ensuring accountability for procurement activities. |
| POLineId | Long | The unique identifier for the purchase order line, linking the schedule to a specific item or service on the purchase order. |
| ItemDescription | String | A detailed description of the item or service associated with the purchase order schedule, providing context for procurement. |
| ItemId | Long | The unique identifier for the item associated with the purchase order schedule, ensuring accurate tracking and fulfillment. |
| LineNumber | Decimal | The line number for the item or service in the purchase order schedule, used for sorting and tracking within the order. |
| UOMCode | String | The unit of measure code used for the item or service in the purchase order schedule, ensuring consistency in how quantities are measured. |
| SupplierItem | String | The identifier assigned by the supplier for the item, allowing for matching between the buyer's order and the supplier's catalog. |
| CategoryId | Long | The unique identifier for the purchasing category associated with the item in the purchase order schedule, aiding in classification. |
| LineLocationId [KEY] | Long | The unique identifier for the location associated with the purchase order line, ensuring proper logistics and inventory management. |
| ScheduleNumber | Long | The unique number assigned to the schedule in the purchase order, used to track delivery or shipment details. |
| ShipToLocationId | Long | The unique identifier for the location to which the goods or services will be shipped, providing clarity for logistics. |
| RequestedDeliveryDate | Date | The date on which the buyer requests the delivery of the goods or services associated with the purchase order schedule. |
| ScheduleStatusCode | String | The status code representing the current state of the schedule, such as 'Pending,' 'Shipped,' or 'Received.' |
| ClosedReason | String | The reason for closing the schedule, providing context for the completion or cancellation of the scheduled item or service. |
| InvoiceMatchOptionCode | String | The code representing the invoice matching option for the purchase order schedule, specifying the matching criteria (for example, 'PO Invoice,' 'Receipt Invoice'). |
| BilledQuantity | Decimal | The quantity of items billed in the purchase order schedule, providing insight into invoicing against the schedule. |
| ShippedQuantity | Decimal | The quantity of items shipped as part of the purchase order schedule, helping track the fulfillment progress. |
| ReceivedQuantity | Decimal | The quantity of items received as part of the purchase order schedule, indicating how much of the order has been delivered. |
| AcceptedQuantity | Decimal | The quantity of items accepted by the buyer from the scheduled delivery, confirming the successful receipt of goods or services. |
| BilledAmount | Decimal | The total billed amount for the scheduled items, reflecting the monetary value of the billed goods or services. |
| ShippedAmount | Decimal | The total amount corresponding to the shipped items in the purchase order schedule, helping track partial deliveries. |
| ReceivedAmount | Decimal | The total amount for the received items, showing how much has been received and accounted for from the purchase order schedule. |
| AcceptedAmount | Decimal | The total amount for the items accepted by the buyer, ensuring financial records reflect only accepted quantities. |
| ShipToCustomerId | Long | The unique identifier for the customer to whom the goods are shipped, often used in the context of direct sales or distribution. |
| SoldToLegalEntity | String | The name of the legal entity to which the purchase order schedule is billed, ensuring proper invoicing and tax processing. |
| UOM | String | The unit of measure used for the items or services in the purchase order schedule, ensuring uniformity in measurement (for example, 'Units,' 'Boxes'). |
| ShipToLocationCode | String | The code representing the location where the goods or services are to be delivered, used for routing logistics. |
| ScheduleStatus | String | The descriptive status of the schedule, indicating whether it is open, closed, or partially fulfilled. |
| PaymentTermsId | Long | The unique identifier for the payment terms associated with the purchase order schedule, dictating the payment schedule and conditions. |
| FreightTermsCode | String | The code representing the freight terms for the purchase order schedule, indicating the responsibility for shipping costs (for example, 'FOB'). |
| Category | String | The name of the purchasing category associated with the purchase order schedule, aiding in inventory and procurement classification. |
| CategoryCode | String | The code associated with the purchasing category, used for categorization and reporting of purchase order schedules. |
| Buyer | String | The name of the buyer responsible for the purchase order schedule, ensuring accountability for procurement actions. |
| InvoiceMatchOption | String | The descriptive option used for invoice matching against the purchase order schedule, determining how invoices are reconciled. |
| PaymentTerms | String | The terms of payment for the purchase order schedule, such as 'Net 30' or 'Due on Receipt,' determining when payment is expected. |
| FreightTerms | String | The description of the freight terms for the purchase order schedule, clarifying the responsibility for shipping costs (for example, 'Prepaid,' 'Collect'). |
| ShipToCustomer | String | The name of the customer to whom the goods are shipped, ensuring proper delivery logistics and customer service. |
| PurchaseBasisCode | String | The code representing the purchase basis, such as 'Fixed Price,' 'Time and Materials,' which dictates the purchasing model. |
| ItemNumber | String | The item number assigned to the product in the purchase order schedule, used for identification and tracking. |
| Total | Decimal | The total value of the purchase order schedule, accounting for the cost of all items and services within the schedule. |
| TotalTax | Decimal | The total tax amount applied to the purchase order schedule, ensuring accurate financial records and compliance with tax regulations. |
| PurchaseBasis | String | The basis on which the purchase order schedule is made, such as 'Fixed Price' or 'Time and Materials,' specifying the procurement structure. |
| Quantity | Decimal | The quantity of items ordered in the purchase order schedule, used for inventory tracking and fulfillment. |
| Amount | Decimal | The total monetary value of the items or services in the purchase order schedule, before tax and adjustments. |
| ShipToLocation | String | The name or identifier for the location where the goods are shipped, providing details for fulfillment and delivery. |
| DocumentStatusCode | String | The status code of the document associated with the purchase order schedule, used for tracking its approval and processing stage. |
| DocumentStatus | String | The descriptive status of the document, reflecting its current state in the approval, processing, or completion stages. |
| AnticipatedArrivalDate | Date | The anticipated arrival date for the goods or services, helping plan for receipt and inventory management. |
| CreationDate | Datetime | The date and time when the purchase order schedule was created, serving as a historical reference for procurement. |
| RequestedShipDate | Date | The requested shipping date for the goods or services in the purchase order schedule, setting expectations for delivery. |
| Supplier | String | The name of the supplier fulfilling the purchase order schedule, ensuring clarity on the supplier's role in the transaction. |
| SupplierId | Long | The unique identifier for the supplier associated with the purchase order schedule, ensuring accurate supplier records. |
| SupplierSiteId | Long | The unique identifier for the supplier site associated with the purchase order schedule, used for logistics and inventory management. |
| SupplierSite | String | The name of the supplier's site responsible for fulfilling the order, helping with delivery and contact management. |
| RetainageRate | Decimal | The rate at which payment is withheld for the purchase order schedule, often used in construction or long-term contracts. |
| RetainageAmount | Decimal | The amount withheld from payment as retainage, typically used in contracts requiring performance completion before full payment. |
| RetainageReleasedAmount | Decimal | The amount of retainage that has been released, representing funds that were previously withheld but are now available for payment. |
| ProcurementBUId | Long | The unique identifier for the procurement business unit managing the purchase order schedule, ensuring proper procurement oversight. |
| ProcurementBU | String | The name of the procurement business unit that owns and manages the purchase order schedule, ensuring proper budget and resource allocation. |
| RequisitioningBUId | Long | The unique identifier for the business unit that initiated the requisition for the purchase order schedule, linking the order to its origin. |
| RequisitioningBU | String | The name of the requisitioning business unit, providing insight into the department or unit that requested the purchase order. |
| ScheduleDescription | String | A description of the schedule, providing additional context or details about the goods or services being ordered. |
| ScheduleTypeCode | String | The code representing the type of schedule, indicating whether it is a regular, emergency, or backorder schedule. |
| ScheduleType | String | The descriptive name of the schedule type, clarifying the nature of the scheduled order (for example, 'Backorder,' 'Standard'). |
| DocumentStyleId | Long | The unique identifier for the document style associated with the purchase order schedule, ensuring consistent presentation and formatting. |
| DocumentStyle | String | The name or identifier for the document style applied to the purchase order schedule, ensuring a consistent look and feel across procurement documents. |
| FundsStatusCode | String | The code representing the status of funds allocated for the purchase order schedule, indicating whether funds are available or restricted. |
| FundsStatus | String | The descriptive status of the funds allocated for the purchase order schedule, providing insight into financial availability. |
| AccrueAtReceiptFlag | Bool | Indicates whether the financial accrual should be recognized upon receipt of goods or services, ensuring proper accounting treatment. |
| Price | Decimal | The unit price of the item or service in the purchase order schedule, providing the cost per unit for budgeting and financial records. |
| LineNumberScheduleNumber | String | A unique identifier combining the line number and schedule number, used to track specific items or services in the schedule. |
| ItemOrScheduleDescription | String | A description of either the item or schedule, providing more context for the goods or services being ordered. |
| DueDate | String | The due date for the completion of the schedule, setting expectations for the delivery or fulfillment timeline. |
| Finder | String | The search function or query used to locate specific purchase order schedules, providing efficient filtering and retrieval of data. |
| Intent | String | The purpose or intent of the purchase order schedule, clarifying whether it is for an immediate purchase, contract fulfillment, or other procurement goals. |
| SysEffectiveDate | String | The system effective date that determines which version of the data is valid based on the date of the query, ensuring accurate data retrieval. |
| EffectiveDate | Date | The effective date from which the purchase order schedule is valid, determining the applicable schedule version for the given time period. |