PurchaseOrderslinesschedules
Defines the planned shipment dates and delivery details for each line item in a purchase order.
Columns
| Name | Type | 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 | 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 | A placeholder or reference for the intent or purpose related to the purchase order line schedule. |
| SysEffectiveDate | String | 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. |