MN
MNMaterialListLineProjection
Projection of MNMaterialListLine containing only fields required for the FixedDemand view.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BranchID | int | - | ||
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. | ||||
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. | ||||
ExpectedByDate | datetime | - | ||
Description:The date when the goods are expected in the company's warehouse in case when Provisioning Source = Purchase to Order/Blanket For Normal. | ||||
InventoryID | int | - | ||
Description:The identifier of the inventory item associated with the material line. Non-stock kits are omitted. . | ||||
LineNbr | int | - | ||
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. | ||||
MaterialListNoteID | uniqueidentifier | - | ||
Description:The NoteID of the material list. | ||||
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 | - | ||
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. | ||||
ProjectID | int | - | ||
Description:The identifier of the project associated with the material line. | ||||
RequiredQty | decimal | - | ||
Description:The quantity of an item which is required to procure and utilize. The value can be manually modified. | ||||
UOM | nvarchar | - | ||
Description:The unit of measure for the quantity associated with the material line. | ||||