AM
AMProdMatlLotSerial
Table to store the relationship between lot/serial numbers of materials issued to a production order, and the parent lot/serial numbers of the finished good. This relationship can be viewed and edited on the Late Assignment (AM312000) form (corresponding to the LateAssignmentMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
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 | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
OperationID | int | Operation ID | AMProdOper | |
Description:No description available | ||||
OrderType | char(2) | Order Type | AMOrderType | |
Description:No description available | ||||
ParentLotSerialNbr | nvarchar(100) | Parent Lot/Serial Nbr. | - | |
Description:No description available | ||||
ProdOrdID | nvarchar(19) | Production Nbr. | AMProdItem | |
Description:No description available | ||||
QtyIssued | decimal | Issued Qty. | - | |
Description:No description available | ||||