Maintains the stock on hand information, 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.
Sales orders, receiving slips, stock transfer, warehouse transfers, Process Back Orders, stock takes, assemblies and Cost Price Updates
|
Name |
Type |
Linked To/Supplied |
|
LinkID |
Text (20) |
|
|
LastSavedDateTime |
Date/Time |
|
|
InventoryID |
Text (20) |
IN_Main.InventoryID |
|
DateIn |
Date/Time |
|
|
QuantityIn |
Number (Decimal) |
|
|
LCostIn |
Number (Float) |
|
|
SCostIn |
Number (Float) |
|
|
SpecialPrice |
Number (Float) |
|
|
QuantityLeft |
Number (Decimal) |
|
|
SerialNo |
Text (50) |
|
|
TaxPaid |
Number (Float) |
|
|
Ref |
Text (250) |
|
|
OrdersPSLinesID |
Text (20) |
RE_Lines.OrdersPSLinesID;IN_AssemblyHistory.INAssemblyHistoryID |
|
HistoryText |
Text (250) |
|
|
QuantityAllocated |
Number (Decimal) |
|
|
IN_LogicalID |
Text (20) |
IN_Logical.IN_LogicalID |
|
BinLocationDesc |
Text (50) |
|
|
ExpiryDate |
Date/Time |
|
Copyright © 2012 Jiwa Financials. All rights reserved.