IN
INItemLotSerial
PX.Objects.IN17 of 17 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
InventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Nbr. | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiry Date | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LotSerAssign | char(1) | - | ||
Description:No description available | ||||
LotSerTrack | char(1) | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PreassignedObsolete | bit | Pre-Assigned | - | |
Description:No description available | ||||
QtyActual | decimal(25, 6) | Qty. Available for Issue | - | |
Description:No description available | ||||
QtyAvail | decimal(25, 6) | Qty. Available | - | |
Description:No description available | ||||
QtyHardAvail | decimal(25, 6) | Qty. Hard Available | - | |
Description:No description available | ||||
QtyInTransit | decimal(25, 6) | - | ||
Description:No description available | ||||
QtyOnHand | decimal(25, 6) | Qty. On Hand | - | |
Description:No description available | ||||
QtyOnReceipt | decimal(25, 6) | - | ||
Description:The field is used to store receipts Qty separately from issues. | ||||
QtyOrig | decimal(25, 6) | - | ||
Description:The field is used only for When Used Serial Numbers. It stores the quantity of the first IN Document released the serial number ("-1", "1") or "null" if it was not released yet. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||