DraftPurchaseOrderslines
Details each line item (for example, item ID, quantity, unit price) within a draft purchase order prior to supplier communication.
Columns
| Name | Type | SupportedFinders | Description |
| DraftPurchaseOrdersPOHeaderId [KEY] | Long | The unique identifier for a draft purchase order header in the DraftPurchaseOrderslines table, linking it to the corresponding header record. | |
| POLineId [KEY] | Long | The unique identifier for the purchase order line within the DraftPurchaseOrderslines table. | |
| LineNumber | Decimal | The line number that identifies the position of the line item within the purchase order. | |
| POHeaderId | Long | PrimaryKey | The identifier linking this line to the corresponding purchase order header. |
| OrderNumber | String | The purchase order number associated with this line item. | |
| LineTypeId | Long | The identifier for the type of purchase order line, used to categorize the line item. | |
| LineType | String | The type of line item in the purchase order, such as goods or services. | |
| ItemId | Long | The identifier for the item associated with this purchase order line. | |
| Item | String | The description or name of the item being purchased in this order line. | |
| ItemRevision | String | The revision identifier for the item, used to track different versions of the same item. | |
| CategoryId | Long | The category identifier that classifies the purchased item or service. | |
| CategoryCode | String | The category code that represents the classification of the item or service in the purchase order line. | |
| Category | String | The name or description of the category to which the item or service belongs. | |
| Description | String | A description of the purchase order line item, providing details about the product or service. | |
| Amount | Decimal | The total amount of the purchase order line, usually representing the price before taxes or discounts. | |
| Quantity | Decimal | The quantity of items or services being purchased in this line. | |
| BasePrice | Decimal | The base price of the item or service before applying any discounts or price adjustments. | |
| DiscountType | String | The type of discount applied to the purchase order line, such as percentage or fixed amount. | |
| Discount | Decimal | The discount amount applied to the purchase order line, reducing the total price. | |
| DiscountReason | String | The reason for applying a discount to the purchase order line. | |
| Price | Decimal | The final price of the item or service after applying any discounts or adjustments. | |
| UOMCode | String | The unit of measure code that indicates how the item is measured (for example, each, kg, liter). | |
| UOM | String | The unit of measure for the item or service being purchased, such as 'each', 'box', or 'kg'. | |
| PricingUOMCode | String | The unit of measure code used for pricing, which may differ from the purchase unit of measure. | |
| PricingUOM | String | The unit of measure used to define the price of the item, often used for pricing consistency. | |
| CurrencyCode | String | The currency code indicating the currency in which the price is specified (for example, USD, EUR). | |
| Currency | String | The name of the currency used for the purchase order line (for example, US Dollars, Euros). | |
| BaseModelId | Long | The identifier for the base model of the item, typically used for configurable or configurable items. | |
| BaseModel | String | The name or description of the base model for the purchased item. | |
| BaseModelPrice | Decimal | The price of the base model for the item, before any custom configurations or changes. | |
| CancelDate | Date | The date when the purchase order line was canceled, if applicable. | |
| CancelFlag | Bool | A flag indicating whether the purchase order line has been canceled (true) or not (false). | |
| CancelReason | String | The reason for canceling the purchase order line, providing context for the cancellation. | |
| CancelledBy | Long | The identifier for the user or system that canceled the purchase order line. | |
| ChangeAcceptedFlag | Bool | A flag indicating whether any changes made to the purchase order line have been accepted. | |
| ConfiguredItemFlag | Bool | A flag indicating whether the item in the purchase order line is configurable. | |
| ConsignmentLineFlag | Bool | A flag indicating whether the line represents a consignment item, meaning the goods are supplied on a consignment basis. | |
| SourceAgreementId | Long | The identifier for the source agreement related to this purchase order line, linking it to an existing contract or agreement. | |
| SourceAgreementNumber | String | The number of the source agreement, providing an additional reference for the related contract or agreement. | |
| SourceAgreementLineId | Long | The identifier for the specific line within the source agreement that corresponds to this purchase order line. | |
| SourceAgreementLine | Decimal | The line number within the source agreement, used for mapping purchase order lines to contract lines. | |
| SourceAgreementTypeCode | String | The code representing the type of agreement associated with this purchase order line (for example, standard, blanket). | |
| SourceAgreementType | String | The name or description of the agreement type (for example, standard, blanket, framework). | |
| SourceAgreementProcurementBUId | Long | The identifier for the procurement business unit associated with the source agreement. | |
| SourceAgreementProcurementBU | String | The name of the procurement business unit associated with the source agreement. | |
| ResponseLine | Decimal | The response line number that corresponds to this purchase order line, typically used in negotiations or supplier responses. | |
| Response | Decimal | The response amount or price, representing the supplier’s reply to the purchase order request. | |
| NegotiationId | Long | The identifier for the negotiation session related to this purchase order line, used to track the negotiation process. | |
| Negotiation | String | The name or description of the negotiation related to this purchase order line. | |
| NegotiationLine | Decimal | The line number within the negotiation document that corresponds to this purchase order line. | |
| FundsStatusCode | String | The code indicating the status of funds associated with the purchase order line, such as available or reserved. | |
| FundsStatus | String | The name or description of the funds status, showing whether there is sufficient budget for the purchase order line. | |
| ManualPriceChangeFlag | Bool | A flag indicating whether the price of the purchase order line was manually adjusted. | |
| NegotiatedFlag | Bool | A flag indicating whether the price or terms for the purchase order line were negotiated. | |
| NoteToSupplier | String | Any special instructions or notes to the supplier regarding the purchase order line. | |
| ReasonForChange | String | The reason for any changes made to the purchase order line, providing context for the update. | |
| SupplierConfigurationId | String | The identifier for the supplier configuration associated with this purchase order line. | |
| SupplierItem | String | The item identifier or code used by the supplier for the item in the purchase order line. | |
| OptionsPrice | Decimal | The price for any optional items or configurations that can be added to the purchase order line. | |
| UNNumberCode | String | The UN (United Nations) number code for hazardous materials associated with this purchase order line. | |
| UNNumberId | Long | The identifier for the UN number associated with this purchase order line. | |
| UNNumber | String | The UN number for hazardous materials, used for regulatory compliance in the shipping and handling of the items. | |
| UNNumberDescription | String | A description of the UN number, typically providing more details about the hazardous material. | |
| HazardClassCode | String | The code representing the hazard class of the item, used for regulatory and safety purposes. | |
| HazardClassId | Long | The identifier for the hazard class associated with this purchase order line. | |
| HazardClass | String | The name or description of the hazard class for the item in the purchase order line. | |
| WorkOrderProduct | String | The product identifier associated with the work order, linking the purchase order line to the related work order. | |
| TaxableFlag | Bool | A flag indicating whether the purchase order line is subject to tax. | |
| ReferenceNumber | String | A reference number related to the purchase order line, used for tracking or external references. | |
| CancelUnfulfilledDemandFlag | Bool | A flag indicating whether unfulfilled demand should be canceled, often used when items are not available. | |
| CreationDate | Datetime | The date and time when the purchase order line was created. | |
| CreatedBy | String | The identifier for the user or system that created the purchase order line. | |
| LastUpdateDate | Datetime | The date and time when the purchase order line was last updated. | |
| LastUpdatedBy | String | The identifier for the user or system that last updated the purchase order line. | |
| MaximumRetainageAmount | Decimal | The maximum amount of retainage allowed for this purchase order line, typically used in construction or service contracts. | |
| Manufacturer | String | The name of the manufacturer of the item in the purchase order line. | |
| ManufacturerPartNumber | String | The part number assigned by the manufacturer for the item in the purchase order line. | |
| CreditFlag | Bool | A flag indicating whether the purchase order line is subject to credit terms. | |
| schedules | String | Schedules related to the purchase order line, typically used for managing delivery or service milestones. | |
| DFF | String | Descriptive flexfield data used for additional custom fields in the purchase order line, typically for capturing specific attributes. | |
| specialHandlingDFF | String | Descriptive flexfield data used for special handling instructions or requirements for the purchase order line. | |
| Finder | String | A search identifier used for locating specific purchase order lines within the system. | |
| Intent | String | FindByIntent | The intended action or purpose of the transaction, such as creating, updating, or reviewing a purchase order line. |
| SysEffectiveDate | String | FindByIntent | The system’s effective date, indicating when the purchase order line record was created or last modified. |
| CUReferenceNumber | Int | An identifier used to link child aggregate records with their corresponding parent tables for consistency. | |
| EffectiveDate | Date | The date from which the specified purchase order line is considered effective and valid. |