MN
MNMaterialListLineSplit
Split of the material line.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AllocatedPlanTypeNonexistent in DB | string | - | ||
Description:No description available | ||||
AssignedNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
BackOrderPlanTypeNonexistent in DB | string | - | ||
Description:As material line does not support back-ordering, returns Booked item plan type. | ||||
BaseOpenQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
BaseQty | decimal | - | ||
Description:No description available | ||||
BaseReceivedQty | decimal | - | ||
Description:No description available | ||||
BaseShippedQty | decimal | - | ||
Description:No description available | ||||
BaseUnreceivedQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
BookedPlanTypeNonexistent in DB | string | - | ||
Description:Plan type that should be used for Booked item plan corresponding to the split. | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DocumentType | char(1) | - | ||
Description:Type of document header for the split. | ||||
ExpireDate | datetime | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
InvtMult | smallint | - | ||
Description:No description available | ||||
IsAllocated | bit | Allocated | - | |
Description:No description available | ||||
IsStockItem | bit | - | ||
Description:No description available | ||||
LastModifiedByID | 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 Number | MNMaterialListLine | |
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. | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerClassIDNonexistent in DB | string | - | ||
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | INLotSerialStatusByCostCenter | |
Description:No description available | ||||
MaterialListNoteID | uniqueidentifier | MNMaterialList | ||
Description:The NoteID of the parent material list. | ||||
OpenQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
POCanceled | bit | - | ||
Description:Indicates that the purchase order line linked to the split has been canceled. | ||||
POCompleted | bit | - | ||
Description:Indicates that the purchase order line linked to the split has been completed. | ||||
POCreateNonexistent in DB | bool? | Mark for PO | - | |
Description:Indicates that the parent material line is marked for purchase. | ||||
POLineNbr | int | PO Line Nbr. | POLine | |
Description:No description available | ||||
PONbr | nvarchar(15) | PO Nbr. | POOrder | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:Related Purchase Receipt number. | ||||
POReceiptType | char(2) | PO Receipt Type | POReceipt | |
Description:Related Purchase Receipt type. | ||||
POSiteID | int | - | ||
Description:No description available | ||||
POType | char(2) | PO Type | POOrder | |
Description:Purchase order type. | ||||
ParentSplitLineNbr | int | Parent Allocation ID | - | |
Description:No description available | ||||
PlanID | bigint | - | ||
Description:No description available | ||||
PlanTypeNonexistent in DB | string | - | ||
Description:Split plan type. | ||||
ProjectIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
ProvisioningSource | char(1) | Provisioning Source | - | |
Description:Provisioning Source type for the split item. | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
ReceivedQty | decimal | Qty. Received | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:Related purchase order or other provisioning document NoteID. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShipDate | datetime | Dispatch On | - | |
Description:No description available | ||||
ShipmentNbr | nvarchar | Shipment Nbr. | - | |
Description:No description available | ||||
ShippedQty | decimal | Qty. on Dispatch | - | |
Description:No description available | ||||
ShippingRule | char(1) | Shipping Rule | - | |
Description:The way the line item should be shipped. The field can have one of the values listed in SOShipComplete. | ||||
SiteID | int | Alloc. Warehouse | INSite | |
Description:No description available | ||||
SplitLineNbr | int | Allocation ID | - | |
Description:The original sequence number of the split among all the splits of the material line. | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
TranDate | datetime | - | ||
Description:No description available | ||||
TranTypeNonexistent in DB | string | - | ||
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
UnreceivedQtyNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
VendorID | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||