IN
InventorySummaryEnquiryResult
PX.Objects.IN62 of 62 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
GridLineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
BaseUnit | nvarchar(6) | Base Unit | - | |
Description:No description available | ||||
CostLayerType | varchar(1) | Cost Layer Type | - | |
Description:No description available | ||||
ExpireDate | datetime2 | Expiration Date | - | |
Description:No description available | ||||
InventoryID | int | Inventory ID | - | |
Description:No description available | ||||
IsTotalNonexistent in DB | bit | - | ||
Description:No description available | ||||
LocationID | int | Location | - | |
Description:No description available | ||||
LotSerialNbr | nvarchar(100) | Lot/Serial Number | - | |
Description:No description available | ||||
QtyActual | decimal | Available for Issue | - | |
Description:No description available | ||||
QtyAvail | decimal | Available | - | |
Description:No description available | ||||
QtyExpired | decimal | Expired | - | |
Description:No description available | ||||
QtyFixedFSSrvOrd | decimal | FS to Purchase | - | |
Description:No description available | ||||
QtyFSSrvOrdAllocated | decimal | FS Allocated | - | |
Description:No description available | ||||
QtyFSSrvOrdBooked | decimal | FS Booked | - | |
Description:No description available | ||||
QtyFSSrvOrdPrepared | decimal | FS Prepared | - | |
Description:No description available | ||||
QtyHardAvail | decimal | Available for Shipment | - | |
Description:No description available | ||||
QtyINAssemblyDemand | decimal | In Assembly Demand | - | |
Description:No description available | ||||
QtyINAssemblySupply | decimal | In Assembly Supply | - | |
Description:No description available | ||||
QtyINIssues | decimal | IN Issues | - | |
Description:No description available | ||||
QtyINReceipts | decimal | IN Receipts | - | |
Description:No description available | ||||
QtyInTransit | decimal | In-Transit | - | |
Description:No description available | ||||
QtyInTransitToProduction | decimal | Transit to Production | - | |
Description:No description available | ||||
QtyInTransitToSO | decimal | In-Transit to SO | - | |
Description:No description available | ||||
QtyNotAvail | decimal | Not Available | - | |
Description:No description available | ||||
QtyOnHand | decimal | On Hand | - | |
Description:No description available | ||||
QtyPODropShipOrders | decimal | Drop-Ship for SO | - | |
Description:No description available | ||||
QtyPODropShipPrepared | decimal | Drop-Ship for SO Prepared | - | |
Description:No description available | ||||
QtyPODropShipReceipts | decimal | Drop-Ship for SO Receipts | - | |
Description:No description available | ||||
QtyPOFixedFSSrvOrd | decimal | Purchase for FS | - | |
Description:No description available | ||||
QtyPOFixedFSSrvOrdPrepared | decimal | Purchase for FS Prepared | - | |
Description:No description available | ||||
QtyPOFixedFSSrvOrdReceipts | decimal | Receipts for FS | - | |
Description:No description available | ||||
QtyPOFixedOrders | decimal | Purchase for SO | - | |
Description:No description available | ||||
QtyPOFixedPrepared | decimal | Purchase for SO Prepared | - | |
Description:No description available | ||||
QtyPOFixedProductionOrders | decimal | Purchase for Production | - | |
Description:No description available | ||||
QtyPOFixedProductionPrepared | decimal | Purchase for Prod. Prepared | - | |
Description:No description available | ||||
QtyPOFixedReceipts | decimal | Receipts for SO | - | |
Description:No description available | ||||
QtyPOOrders | decimal | Purchase Orders | - | |
Description:No description available | ||||
QtyPOPrepared | decimal | Purchase Prepared | - | |
Description:No description available | ||||
QtyPOReceipts | decimal | PO Receipts | - | |
Description:No description available | ||||
QtyProdFixedProdOrders | decimal | Production for Production | - | |
Description:Production / Manufacturing Specifies the quantity On Production for Production | ||||
QtyProdFixedProdOrdersPrepared | decimal | Production for Prod. Prepared | - | |
Description:Production / Manufacturing Specifies the quantity On Production for Prod. Prepared | ||||
QtyProdFixedProduction | decimal | Production to Production | - | |
Description:Production / Manufacturing Specifies the quantity On Production to Production | ||||
QtyProdFixedPurchase | decimal | Production to Purchase | - | |
Description:Production / Manufacturing Specifies the quantity On Production to Purchase. | ||||
QtyProdFixedSalesOrders | decimal | Production for SO | - | |
Description:Production / Manufacturing Specifies the quantity On Production for SO | ||||
QtyProdFixedSalesOrdersPrepared | decimal | Production for SO Prepared | - | |
Description:Production / Manufacturing Specifies the quantity On Production for SO Prepared | ||||
QtyProductionAllocated | decimal | Production Allocated | - | |
Description:No description available | ||||
QtyProductionDemand | decimal | Production Demand | - | |
Description:No description available | ||||
QtyProductionDemandPrepared | decimal | Production Demand Prepared | - | |
Description:No description available | ||||
QtyProductionSupply | decimal | Production Supply | - | |
Description:No description available | ||||
QtyProductionSupplyPrepared | decimal | Production Supply Prepared | - | |
Description:No description available | ||||
QtySOBackOrdered | decimal | SO Back Ordered | - | |
Description:No description available | ||||
QtySOBooked | decimal | SO Booked | - | |
Description:No description available | ||||
QtySODropShip | decimal | SO to Drop-Ship | - | |
Description:No description available | ||||
QtySOFixed | decimal | SO to Purchase | - | |
Description:No description available | ||||
QtySOFixedProduction | decimal | SO to Production | - | |
Description:No description available | ||||
QtySOPrepared | decimal | SO Prepared | - | |
Description:No description available | ||||
QtySOShipped | decimal | SO Shipped | - | |
Description:No description available | ||||
QtySOShipping | decimal | SO Allocated | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SubItemID | int | Subitem | - | |
Description:No description available | ||||
TotalCost | decimal | Estimated Total Cost | - | |
Description:No description available | ||||
UnitCost | decimal | Estimated Unit Cost | - | |
Description:No description available | ||||