AM
AMProdMatlSplit
Line details for a material on a production order. The line details are created on the Production Order Details (AM209000) form (corresponding to the ProdDetail graph). Parent: AMProdItem
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMBatNbr | nvarchar(15) | AM Batch Nbr | AMBatch | |
Description:No description available | ||||
AMDocType | char(1) | AM Document Type | - | |
Description:No description available | ||||
AMOrderType | char(2) | Sub. Assy. Order Type | - | |
Description:No description available | ||||
AMProdOrdID | nvarchar(19) | Sub. Assy. Production Nbr. | - | |
Description:No description available | ||||
AssignedNbrNonexistent in DB | string | - | ||
Description:No description available | ||||
BaseQty | decimal | - | ||
Description:No description available | ||||
BaseQtyComplete | decimal | - | ||
Description:No description available | ||||
BaseQtyReceived | decimal | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:No description available | ||||
CostCenterID | int | - | ||
Description:Cost center id selected project, task and warehouse | ||||
CostSiteIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
CostSubItemIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
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 | Stock Item | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineID | int | Line Nbr. | AMProdMatl | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerClassIDNonexistent in DB | string | - | ||
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | CostCenter | |
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
POCancelled | bit | - | ||
Description:No description available | ||||
POCompleted | bit | - | ||
Description:No description available | ||||
POCreate | bit | Mark for PO | - | |
Description:No description available | ||||
POLineNbr | int | PO Line Nbr. | - | |
Description:No description available | ||||
POOrderNbr | nvarchar(15) | PO Order Nbr. | POOrder | |
Description:No description available | ||||
POOrderType | char(2) | PO Type | - | |
Description:No description available | ||||
POReceiptNbr | nvarchar(15) | PO Receipt Nbr. | POReceipt | |
Description:No description available | ||||
POReceiptType | char(2) | PO Receipt Type | - | |
Description:No description available | ||||
ParentSplitLineNbr | int | Parent Allocation ID | - | |
Description:No description available | ||||
PlanID | bigint | Plan ID | INItemPlan | |
Description:No description available | ||||
ProdCreate | bit | Mark for Production | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
ProjectIDNonexistent in DB | int? | Project | - | |
Description:Project/Task is not implemented for Manufacturing. Including fields as a 5.30.0663 or greater requirement for the class that implements ILSPrimary/ILSMaster | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
QtyComplete | decimal | Qty. Complete | - | |
Description:No description available | ||||
QtyReceived | decimal | Qty. Received | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SiteID | int | Alloc. Warehouse | INSite | |
Description:No description available | ||||
SplitLineNbr | int | Allocation ID | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TaskIDNonexistent in DB | int? | Task | - | |
Description:Project/Task is not implemented for Manufacturing. Including fields as a 5.30.0663 or greater requirement for the class that implements ILSPrimary/ILSMaster | ||||
TranDate | datetime | Allocation Date | - | |
Description:No description available | ||||
TranType | char(3) | Tran. Type | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
VendorID | int | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||