IN
INPIDetail
PX.Objects.IN27 of 27 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
PIID | nvarchar(15) | Reference Nbr. | INPIHeader | |
Description:No description available | ||||
BookQty | decimal(25, 6) | Book Quantity | - | |
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 | ||||
ExtVarCost | decimal(19, 6) | Estimated Ext. Variance Cost | - | |
Description:No description available | ||||
FinalExtVarCost | decimal(19, 6) | Final Ext. Variance Cost | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | InventoryItem | |
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 | ||||
LineType | char(1) | Line Type | - | |
Description:No description available | ||||
LocationID | int | Location | INLocation | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Number | INLotSerialStatus | |
Description:No description available | ||||
ManualCost | bit | Manual Cost | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
PhysicalQty | decimal(25, 6) | Physical Quantity | - | |
Description:No description available | ||||
ReasonCode | nvarchar(20) | Reason Code | ReasonCode | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TagNumber | int | Tag Nbr. | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnitCost | decimal(19, 6) | Unit Cost | - | |
Description:No description available | ||||
VarQty | decimal(25, 6) | Variance Quantity | - | |
Description:No description available | ||||