MNMaterialListLine

PX.Objects.MNRelease 2026.1

Material line.

Select a row for its description 90 of 90 fields

	Field Name	Type	Display Name	Foreign Key
	`BaseClosedQty`Nonexistent in DB	`decimal?`		-
Description:The closed quantity of the item, expressed in the base unit of measure.
	`BaseNotDispatchedQty`	`decimal`		-
Description:The quantity of a material line that is not included in any dispatching document with any status in base UOM.
	`BaseOpenQty`	`decimal`		-
Description:The quantity of the item to be shipped, expressed in the base unit of measure.
	`BaseQtyAllocated`	`decimal`		-
Description:The quantity of the stock item being allocated for shipment but not yet shipped for this order, expressed in the base unit of measure.
	`BaseQtyAwaiting`	`decimal`		-
Description:The quantity of the stock item being already purchased, but not yet received for this order, expressed in the base unit of measure.
	`BaseQtyDispatched`	`decimal`		-
Description:Base UOM quantity on Dispatching documents which processing is already finished.
	`BaseQtyOnConfirmedShipments`	`decimal`		-
Description:Total quantity of item on related confirmed shipmens expressed in base UOM.
	`BaseQtyOnDispatch`	`decimal`		-
Description:Quantity on Dispatching documents processing of which is not finished expressed in base UOM.
	`BaseQtyOnOrders`	`decimal`		-
Description:Quantity of item on linked Purchase Orders (no more than required) expressed in base UOM.
	`BaseQtyOnPurchaseLines`	`decimal`		-
Description:Total quantity of item added to related purchase order lines in item's base UOM.
	`BaseQtyProcured`	`decimal`		-
Description:The quantity which is overall allocated/dispatched/issued for this particular MLine expressed in base UOM.
	`BaseQtyReceived`	`decimal`		-
Description:Total quantity of item received (added to released purchase receipts) expressed in base UOM.
	`BaseQtyToOrder`	`decimal`		-
Description:The quantity of the stock item being prepared for purchasing for this order, expressed in the base unit of measure.
	`BaseQtyUsed`	`decimal`		-
Description:Extra quantity from Project and Field Service teams in base UOM.
	`BaseRequiredQty`	`decimal`	Base Qty.	-
Description:The quantity of an item which is required to procure and utilize of the item in the base unit of measure.
	`BaseShippedQty`	`decimal`		-
Description:The quantity of the stock item being prepared for shipment and already shipped for this order, expressed in the base unit of measure.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The identifier of the branch associated with the material line. The value of this field corresponds to the value of the Branch.BranchID field.
	`Canceled`	`bit`		-
Description:Specifies whether the line has been canceled.
	`ClosedQty`Nonexistent in DB	`decimal?`		-
Description:The closed quantity of the item, calculated as the subtraction of the quantity of the item to be shipped from the quantity of the item ordered.
	`CompleteQtyMax`	`decimal`		-
Description:The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer.
	`CompleteQtyMin`	`decimal`		-
Description:The minimum percentage of goods shipped (with respect to the ordered quantity) for the system to mark the order as completely shipped.
	`Completed`	`bit`		-
Description:Indicates that the line has been completed by shipping it in full, completing it manually or canceling.
	`CostCenterID`	`int`		INSiteStatusByCostCenter
Description:No description available
	`CostCodeID`Default Navigation	`int`	Cost Code	PMCostCode
Description:The identifier of the cost code associated with the material line. The value of this field corresponds to the value of the PMCostCode.CostCodeID field.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CustomerID`	`int`		-
Description:The identifier of the customer of the original sales order. The field is a part of the identifier of the reason code AR.Customer.Customer.bAccountID.
	`Description`	`nvarchar(256)`	Description	-
Description:The description provided for the stock item.
	`DocumentType`	`char(1)`		-
Description:Type of document header for the line.
	`ExpectedByDate`	`datetime`	Expected By	-
Description:The date when the goods are expected in the company's warehouse in case when Provisioning Source = Purchase to Order/Blanket For Normal.
	`ExpireDate`	`datetime`	Expiration Date	-
Description:No description available
	`ExtCost`	`decimal`	Ext. Cost	-
Description:The extended cost of the line which is calculated as the unit cost multiplied by the quantity.
	`Hold`	`bit`		-
Description:Indicates if the line processing is on hold.
	`InventoryID`Default Navigation	`int`	Inventory ID	InventoryItem
Description:The identifier of the inventory item associated with the material line. Non-stock kits are omitted. .
	`InventorySource`	`char(1)`	Inventory Source	-
Description:The type of inventory source for the line item.
	`InvtMult`	`smallint`		-
Description:No description available
	`IsCreatedFromWorkTicket`	`bit`	Created from Work Ticket	-
Description:No description available
	`IsKit`Nonexistent in DB	`bool?`		-
Description:A Boolean value that indicates whether the item is a kit.
	`IsStockItem`	`bit`		-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LineNbr`	`int`	Line Nbr.	-
Description:The original sequence number of the line among all the material lines. The sequence of line numbers of the material lines belonging to a single document can include gaps.
	`LineQtyAvail`Nonexistent in DB	`decimal?`		-
Description:The Quantity Available of the item of the line.
	`LineQtyHardAvail`Nonexistent in DB	`decimal?`		-
Description:The Quantity Hard Available of the item of the line.
	`LineType`	`char(2)`		-
Description:No description available
	`LocationID`Default Navigation	`int`	Location	INLocation
Description:No description available
	`LotSerialNbr`	`nvarchar(100)`	Lot Serial Number	INLotSerialStatusByCostCenter
Description:No description available
	`MaterialListNoteID`	`uniqueidentifier`		MNMaterialList
Description:The NoteID of the material list.
	`NeededByDate`	`datetime`	Needed By	-
Description:The date when the goods should be on the project site/job site.
	`NotDispatchedQty`	`decimal`		-
Description:The quantity of a material line that is not included in any dispatching document with any status.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OpenQty`	`decimal`		-
Description:The quantity of the item to be shipped. That is, the total quantity minus the quantity shipped according to closed shipment documents.
	`POCreateDate`	`datetime`	PO Creation Date	-
Description:Determines when the system must pick up the line on the Create Purchase Orders (PO505000) form: PO Creation Date should be not greater than current business date.
	`POCreated`	`bit`		-
Description:A Boolean value that indicates whether the line was added to a purchase order.
	`POSiteID`Default Navigation	`int`	Purchase Warehouse	INSite
Description:The identifier of the destination warehouse for the items to be purchased. The field is included in the FK.POSite foreign key. The value of this field corresponds to the value of the INSite.siteID field.
	`ProjectID`	`int`		PMProject
Description:The identifier of the project associated with the material line.
	`ProvisionNoteID`	`uniqueidentifier`	Provisioning Doc. Ref. Nbr.	-
Description:Related purchase order or other provisioning document NoteID.
	`ProvisioningSource`	`char(1)`	Provisioning Source	-
Description:Provisioning Source type for the line item.
	`QtyAllocated`	`decimal`	Qty. Allocated	-
Description:The quantity of the stock item being allocated for shipment but not yet shipped for this line.
	`QtyAvailableForDispatch`Nonexistent in DB	`decimal?`	Qty. Available for Dispatch	-
Description:Available for Shipping items quantity from line warehouse, but not more than line Required Qty, including allocated items and excluding quantities on Dispatches(Qty.on Dispatch) and quantities already dispatched (Qty.Dispatched). Is calculated in .
	`QtyAwaiting`	`decimal`	Qty. Awaiting Delivery	-
Description:The quantity of the item being already purchased, but not yet received for this order.
	`QtyDispatched`	`decimal`	Qty. Dispatched	-
Description:Quantity on Dispatching documents which processing is already finished.
	`QtyOnConfirmedShipments`	`decimal`		-
Description:Total quantity of item on related confirmed shipments.
	`QtyOnDispatch`	`decimal`	Qty. on Dispatch	-
Description:Quantity on Dispatching documents which processing is not finished yet.
	`QtyOnOrders`	`decimal`	Qty. on Orders	-
Description:Linked PO line quantity but no more than . For Provisioning Source different from INReplenishmentSource.PurchaseToOrder equals 0.
	`QtyOnPurchaseLines`	`decimal`		-
Description:Total quantity of item added to related purchase order lines.
	`QtyProcured`	`decimal`	Qty. Procured	-
Description:The quantity which is overall allocated/dispatched/issued for this particular MLine.
	`QtyReceived`	`decimal`		-
Description:Total quantity of item received (added to released purchase receipts).
	`QtyToOrder`	`decimal`	Qty. to Order or Allocate	-
Description:The quantity of the item being prepared for purchasing or allocating for this line.
	`QtyUsed`	`decimal`	Qty. Used	-
Description:Extra quantity from Project and Field Service teams.
	`RequiredQty`	`decimal`	Required Qty.	-
Description:The quantity of an item which is required to procure and utilize. The value can be manually modified.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:Determines if the line is selected as an action target.
	`ShipDate`	`datetime`	Dispatch On	-
Description:The date when the item should be shipped.
	`ShippedQty`	`decimal`		-
Description:The quantity of the stock item being prepared for shipment and already shipped for this order.
	`ShippingRule`	`char(1)`		-
Description:The way the line item should be shipped. The field can have one of the values listed in SOShipComplete.
	`SiteID`Default Navigation	`int`	Warehouse	INSite
Description:No description available
	`SplitCntr`	`int`		-
Description:A counter of the document lines, which is used internally to assign numbers to newly created splits. We do not recommend that you rely on this field to determine the exact number of splits because it might not reflect the this number under various conditions.
	`Status`	`char(1)`	Status	-
Description:The read-only status of the material line. For values see MaterialLineStatus members.
	`SubItemID`Default Navigation	`int`	Subitem	INSubItem
Description:No description available
	`TaskID`Default Navigation	`int`	Project Task	PMTask
Description:The identifier of the task associated with the material line. The value of this field corresponds to the value of the PMTask.TaskID field.
	`TranDate`	`datetime`		-
Description:The date of the document in which this line item is listed.
	`TranType`Nonexistent in DB	`string`		-
Description:No description available
	`UOM`Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure for the quantity associated with the material line.
	`UnassignedQty`	`decimal`		-
Description:Contains the difference between the line quantity and the quantity on child split lines for Inventory Items with lot or serial number.
	`UnitCost`	`decimal`	Unit Cost	-
Description:The cost of the item or the rate of the service in the base currency.
	`VendorID`Default Navigation	`int`	Vendor	Vendor
Description:The identifier of the vendor associated with the material line. The value of this field corresponds to the value of the BAccount.BAccountID field.
	`WorkOrderNbr`	`nvarchar(40)`		-
Description:Reference number of a Work Order.
	`tstamp`	`timestamp`		-
Description:No description available