DraftPurchaseOrderslines
Details each line item (for example, item ID, quantity, unit price) within a draft purchase order prior to supplier communication.
Columns
| Name | Type | 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 | 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 | The intended action or purpose of the transaction, such as creating, updating, or reviewing a purchase order line. |
| SysEffectiveDate | String | 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. |