You are here: Reference Guide > Table Structures > Inventory > IN_WarehouseSOH

IN_WarehouseSOH

Purpose    

Maintains the stock on hand information, by warehouse, line by line, as stock is received, sold, transferred, stock taked, assemblies etc.  Cost details are stored together with any special prices set for stock.  Stock transfers, sales orders, purchase invoices and cost changes update this table.

Path       

Sales orders, receiving slips, stock transfer, warehouse transfers, Process Back Orders, stock takes, assemblies and Cost Price Updates  

Name

Type

Linked To/Supplied

IN_WarehouseSOHID

Text (20)

 

InventoryID

Text (20)

IN_Main.InventoryID

IN_LogicalID

Text (20)

IN_Logical.IN_LogicalID

QuantityLeft

Number (Decimal)

 

QuantityAllocated

Number (Decimal)

 

PickAllocated

Number (Decimal)

 

ShipAllocated

Number (Decimal)

 

ForwardRequirements

Number (Decimal)

 

TransferAllocated

Number (Decimal)

 

BOMAllocated

Number (Decimal)

 

Copyright © 2012 Jiwa Financials. All rights reserved.