PurchaseOrderslinesschedules
Defines the planned shipment dates and delivery details for each line item in a purchase order.
Columns
| Name | Type | SupportedFinders | Description |
| PurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for the header of the purchase order in the PurchaseOrderslinesschedules table. | |
| LinesPOLineId [KEY] | Long | The unique identifier for the individual line item of the purchase order in the PurchaseOrderslinesschedules table. | |
| LineLocationId [KEY] | Long | The identifier that represents the location associated with the purchase order line in the PurchaseOrderslinesschedules table. | |
| POLineId | Long | The identifier of the purchase order line within the PurchaseOrderslinesschedules table, used to reference a specific line. | |
| POHeaderId | Long | PrimaryKey, findByIntent | The identifier for the purchase order header, linking the purchase order line to its header in the PurchaseOrderslinesschedules table. |
| ScheduleNumber | Decimal | A numerical identifier for the schedule associated with the purchase order line in the PurchaseOrderslinesschedules table. | |
| StatusCode | String | The code representing the current status of the purchase order line schedule (for example, Open, Closed, Pending). | |
| Quantity | Decimal | The quantity of items specified in the purchase order line schedule. | |
| SecondaryQuantity | Decimal | The secondary quantity, usually representing a different unit of measure, for the purchase order line schedule. | |
| SecondaryUOMCode | String | The unit of measure code for the secondary quantity (for example, cases, boxes) in the purchase order line schedule. | |
| Ordered | Decimal | The total ordered quantity for the purchase order line schedule. | |
| CountryOfOriginCode | String | The code representing the country of origin for the goods in the purchase order line schedule. | |
| ShipToLocationId | Long | The identifier of the location to which the items in the purchase order line schedule are shipped. | |
| ShipToOrganizationId | Long | The identifier of the organization responsible for receiving the shipment in the purchase order line schedule. | |
| ShipToCustomerId | Long | The identifier of the customer to which the items in the purchase order line schedule are being shipped. | |
| BackToBackFlag | Bool | Indicates whether the purchase order line is linked to a sales order or other fulfillment process (True/False). | |
| SalesOrderNumber | String | The number of the sales order related to the purchase order line schedule, if applicable. | |
| DestinationTypeCode | String | The code that identifies the type of destination for the shipment (for example, customer, warehouse). | |
| ModeOfTransportCode | String | The transport method used to ship the purchase order line items (for example, Air, Sea, Land). | |
| EarlyReceiptToleranceDays | Decimal | The tolerance in days that defines how early a receipt can be processed compared to the promised delivery date. | |
| LateReceiptToleranceDays | Decimal | The tolerance in days that defines how late a receipt can be processed compared to the promised delivery date. | |
| ReceiptDateExceptionActionCode | String | The code specifying the action to take when a receipt date exception occurs. | |
| ShipToExceptionActionCode | String | The code specifying the action to take when there is an exception with the shipping address. | |
| ReceiptCloseTolerancePercent | Decimal | The percentage tolerance allowed for receipt quantities before the system considers the receipt closed. | |
| OverReceiptTolerancePercent | Decimal | The percentage tolerance allowed for over-receipt quantities compared to the ordered quantity. | |
| OverReceiptActionCode | String | The code indicating the action to take when the quantity received exceeds the expected amount. | |
| ReceiptRoutingId | Long | The identifier for the routing path used for receiving goods associated with the purchase order line schedule. | |
| AllowSubstituteReceiptsFlag | Bool | Indicates whether substitute items can be received instead of the originally ordered items (True/False). | |
| InvoiceMatchOptionCode | String | The code representing the matching option for invoices (for example, Match to Purchase Order, Match to Receipt). | |
| InvoiceCloseTolerancePercent | Decimal | The percentage tolerance allowed for invoice amounts before the system considers the invoice closed. | |
| AccrueAtReceiptFlag | Bool | Indicates whether accruals should be created at the time of receipt (True/False). | |
| NoteToReceiver | String | A note or comment provided for the receiver of the goods, often including special instructions. | |
| WorkOrderId | Long | The unique identifier for the work order associated with the purchase order line schedule, if applicable. | |
| WorkOrderNumber | String | The work order number related to the purchase order line schedule. | |
| OrchestrationAgreementLineNumber | Long | The line number in the orchestration agreement related to the purchase order line schedule. | |
| OrchestrationAgreementNumber | String | The orchestration agreement number associated with the purchase order line schedule. | |
| PrimaryTradeRelationshipId | Long | The identifier for the primary trade relationship related to the purchase order line schedule. | |
| POTradingOrganizationId | Long | The identifier for the organization involved in the purchase order trading relationship. | |
| POTradingOrganizationCode | String | The code for the trading organization associated with the purchase order line schedule. | |
| POTradingOrganization | String | The name or description of the trading organization linked to the purchase order. | |
| RequestedDeliveryDate | Date | The requested delivery date for the goods in the purchase order line schedule. | |
| PromisedDeliveryDate | Date | The date on which the goods are promised to be delivered, as agreed upon in the purchase order. | |
| RequestedShipDate | Date | The requested shipment date for the purchase order line items. | |
| PromisedShipDate | Date | The promised shipment date for the goods in the purchase order line schedule. | |
| WorkOrderOperationSequence | Decimal | The operation sequence number for a specific work order associated with the purchase order line schedule. | |
| Status | String | The current status of the purchase order line schedule (for example, Open, Approved, Closed). | |
| DestinationType | String | The type of destination associated with the purchase order line (for example, Warehouse, Store, Customer). | |
| InvoiceMatchOption | String | The invoice match option for the purchase order line, determining how the system matches invoices with receipts. | |
| LineNumber | Decimal | The line number within the purchase order line schedule, used for referencing individual items. | |
| UOM | String | The unit of measure for the primary quantity in the purchase order line schedule (for example, Each, Box, Pallet). | |
| SecondaryUOM | String | The unit of measure for the secondary quantity in the purchase order line schedule. | |
| ShipToLocationCode | String | The code for the location to which the goods in the purchase order line are shipped. | |
| ShipToCustomer | String | The name or code of the customer to whom the goods are being shipped. | |
| Carrier | String | The name of the carrier company responsible for delivering the goods in the purchase order line schedule. | |
| ModeOfTransport | String | The transportation method used to ship the goods for the purchase order line schedule (for example, Truck, Air, Ship). | |
| ReceiptDateExceptionAction | String | The action to take when a receipt date is outside of the expected range. | |
| ShipToExceptionAction | String | The action to take when there is an issue with the shipping address. | |
| OverReceiptAction | String | The action to take when more goods than expected are received for the purchase order line. | |
| ReceiptRouting | String | The routing or process for receiving goods in the purchase order line schedule. | |
| OriginalPromisedDeliveryDate | Date | The original date on which the delivery of the goods was promised, before any updates. | |
| OriginalPromisedShipDate | Date | The original date on which the shipment of goods was promised, before any changes. | |
| CurrencyCode | String | The currency code (for example, USD, EUR) used for the purchase order line schedule. | |
| Currency | String | The type of currency (for example, US Dollar, Euro) used for the financial transactions of the purchase order line schedule. | |
| CountryOfOrigin | String | The country of origin for the goods in the purchase order line schedule. | |
| OrderNumber | String | The purchase order number associated with the line item schedule. | |
| TotalTax | Decimal | The total tax amount calculated for the purchase order line schedule. | |
| Total | Decimal | The total value of the purchase order line schedule, including items, tax, and other fees. | |
| MatchApprovalLevelCode | String | The code indicating the level of approval required for matching purchase orders, receipts, and invoices. | |
| LastAcceptableDeliveryDate | Date | The last acceptable delivery date for the purchase order line schedule before penalties or delays apply. | |
| LastAcceptableShipDate | Date | The last acceptable shipment date for the goods in the purchase order line schedule. | |
| LastAcceptDate | Date | The most recent date on which the purchase order line schedule was accepted by the system. | |
| CarrierId | Long | The unique identifier for the carrier handling the shipment for the purchase order line schedule. | |
| ShipToOrganization | String | The name of the organization responsible for receiving the goods in the purchase order line schedule. | |
| ShipToOrganizationCode | String | The code for the organization receiving the goods in the purchase order line schedule. | |
| RetainageRate | Decimal | The percentage of the total amount to be withheld (retainage) for the purchase order line schedule. | |
| RetainageAmount | Decimal | The actual amount withheld (retainage) from the total value of the purchase order line schedule. | |
| RetainageReleasedAmount | Decimal | The amount of retainage that has been released and paid for the purchase order line schedule. | |
| Description | String | A description or comment about the purchase order line schedule, providing more context or details. | |
| Type | String | The type of purchase order line, indicating its classification (for example, Standard, Service, Subcontract). | |
| Price | Decimal | The price per unit for the items in the purchase order line schedule. | |
| TypeCode | String | The code representing the type of the purchase order line (for example, Standard or Service). | |
| UOMCode | String | The unit of measure code for the purchase order line (for example, Each or Box). | |
| CreationDate | Datetime | The date and time when the purchase order line schedule was created. | |
| CreatedBy | String | The user or system that created the purchase order line schedule entry. | |
| LastUpdateDate | Datetime | The date and time when the purchase order line schedule was last updated. | |
| LastUpdatedBy | String | The user or system that last updated the purchase order line schedule. | |
| PricingUOMCode | String | The unit of measure code used for pricing the items in the purchase order line schedule. | |
| PricingUOM | String | The unit of measure used to price the items in the purchase order line schedule. | |
| BilledAmount | Decimal | The amount billed for the items in the purchase order line schedule. | |
| ReceivedAmount | Decimal | The total value of items received against the purchase order line schedule. | |
| BilledQuantity | Decimal | The quantity of items that have been billed in the purchase order line schedule. | |
| ReceivedQuantity | Decimal | The quantity of items that have been received against the purchase order line schedule. | |
| ShippingMethod | String | The method of shipping selected for the purchase order line schedule (for example, Ground, Air Freight). | |
| ShipToCustomerLocationId | Long | The unique identifier for the customer location where the items are shipped. | |
| ShipToCustomerLocation | String | The name or description of the location to which the goods are being shipped. | |
| Finder | String | A placeholder or reference for a lookup process within the system. | |
| Intent | String | FindByIntent | A placeholder or reference for the intent or purpose related to the purchase order line schedule. |
| SysEffectiveDate | String | FindByIntent | The system effective date for the data, indicating when the current data state was applied. |
| EffectiveDate | Date | The date from which the resource or data is effective, used as a filter for queries that require specific date ranges. |