Database Tables "Stock" (stock)

The following description shows the layout of the database tables for the component stock.

Each of the database tables listed here contains the number of fields with the corresponding table name, the internal field description, the field name, the data type and the field length.

Fields characterized by the "$" sign are primary keys.

For more detailed information on the database tables (e.g. attributes, references, indices etc.) go to the update program System -> Database-> Database Tables.

  1. $Buffe=CompNo=Company=Number=1 9999
  2. $Buffe=BuffeNo=Buffet No.=Number=1 999999
  3. Buffe=Name=Description=String=(32)
  4. Buffe=Active=Active=Bool=(Y/N)
  1. $BuffeLine=CompNo=Company=Number=1 9999
  2. $BuffeLine=BuffeNo=Buffet No.=Number=1 999999
  3. $BuffeLine=ItemNo=Item=Decimal=(14,0)
  4. BuffeLine=Quantity=Quantity=Decimal=(11,3)
  5. BuffeLine=QuantityUnit=Unit=Number=1 999
  6. BuffeLine=AverageCost=Average Cost=Decimal=(11,3)
  7. BuffeLine=QuUnitTxt=Unit=String=(8)
  1. $GoodsReceive=CompNo=Company=Number=1 9999
  2. $GoodsReceive=BranchNo=Branch=Number=1 9999
  3. $GoodsReceive=ReceivedNo=Internal Delivery Note No.=Number=1 99999999
  4. GoodsReceive=SupplierNo=Supplier No.=Number=1 999999
  5. GoodsReceive=SupplDeliNo=Delivery Note No. Supplier=String=(8)
  6. GoodsReceive=OperatorNo=Operator=Number=1 99999999
  7. GoodsReceive=Specification=Free Text=String=(40)
  8. GoodsReceive=ToStockNo=Stock No.=Number=1 9999
  9. GoodsReceive=PaymentNo=Payment Type=Number=1 999
  10. GoodsReceive=ReceivedDay=Delivery Date=Date=
  11. GoodsReceive=ReceivedClock=Delivery Time=Time=
  12. GoodsReceive=ReceivedValue=Value=Decimal=(11,3)
  13. GoodsReceive=FreightCost=Shipping Cost=Decimal=(11,3)
  14. GoodsReceive=PickUpCost=Pick up Cost=Decimal=(11,3)
  15. GoodsReceive=CashDiscount=Cash Discount=Decimal=(5,2)
  16. GoodsReceive=DiscPercValue=Discount percent/value=Decimal=(5,2)
  17. GoodsReceive=EditFreightC=Edit Shipping Cost=Bool=(Y/N)
  18. GoodsReceive=EditDiscPVal=Edit percent Value=Bool=(Y/N)
  19. GoodsReceive=Confirmed=Confirmed=Bool=(Y/N)
  1. $GoodsReturn=CompNo=Company=Number=1 9999
  2. $GoodsReturn=BranchNo=Branch=Number=1 9999
  3. $GoodsReturn=ReturnNo=Return Note No.=Number=1 99999999
  4. GoodsReturn=SupplierNo=Supplier No.=Number=1 999999
  5. GoodsReturn=RetType=Type of Return=Number=1 9999
  6. GoodsReturn=ReceivedNo=Delivery Note No.=Number=1 99999999
  7. GoodsReturn=OperatorNo=Operator=Number=1 99999999
  8. GoodsReturn=Specification=Free Text=String=(40)
  9. GoodsReturn=FromStockNo=Stock No.=Number=1 9999
  10. GoodsReturn=PaymentNo=Payment Type=Number=1 999
  11. GoodsReturn=ReturnDay=Date=Date=
  12. GoodsReturn=ReturnClock=Time=Time=
  13. GoodsReturn=ReturnValue=Value=Decimal=(11,3)
  14. GoodsReturn=FreightCost=Shipping Cost=Decimal=(11,3)
  15. GoodsReturn=PickUpCost=Pick up Cost=Decimal=(11,3)
  16. GoodsReturn=DiscPercValue=Discount Percent/Value=Decimal=(5,2)
  17. GoodsReturn=EditFreightC=Edit Shipping Cost=Bool=(Y/N)
  18. GoodsReturn=EditDiscPVal=Edit Discount=Bool=(Y/N)
  19. GoodsReturn=Confirmed=Confirmed=Bool=(Y/N)
  20. GoodsReturn=TextGroupNo=Text Group=Number=1 65535
  1. $InvenPos=CompNo=Company=Number=1 9999
  2. $InvenPos=BranchNo=Branch=Number=1 9999
  3. $InvenPos=InventoryNo=Inventory Sheet No.=Number=1 99999999
  4. $InvenPos=PosNo=Position No.=Number=1 9999
  5. InvenPos=ItemNo=Item=Decimal=(14,0)
  6. InvenPos=BaseCostPrice=Base Costprice=Decimal=(11,3)
  7. InvenPos=ItemQuan=Quantity=Decimal=(11,3)
  8. InvenPos=NominalStock=Nominal Stock=Decimal=(11,3)
  9. InvenPos=QuantityUnit=Quantity Unit=Number=1 999
  10. InvenPos=SinceInvQuan=Quantity sold=Decimal=(11,3)
  11. InvenPos=SinceInvCVal=Sold in Costprice=Decimal=(11,3)
  12. InvenPos=SinceInvTuOv=Turnover=Decimal=(13,3)
  13. InvenPos=SinceInvBuffQ=Sold Buffet=Decimal=(13,3)
  14. InvenPos=SinceInvInVal=Value incoming=Decimal=(13,3)
  15. InvenPos=SinceInvInQua=Quantity incoming=Decimal=(11,3)
  16. InvenPos=InStockNo=in Stock No.=Number=1 9999
  17. InvenPos=QuUnitTxt=Unit=String=(8)
  18. InvenPos=TotalValue=Quantity=Decimal=(13,3)
  19. InvenPos=TotalDiff=Difference=Decimal=(13,3)
  20. InvenPos=SalesVal=NOTEXT=Decimal=(12,2)
  21. InvenPos=SalesName=Description=String=(20)
  1. $Inventory=CompNo=Company=Number=1 9999
  2. $Inventory=BranchNo=Branch=Number=1 9999
  3. $Inventory=InventoryNo=Inventory Sheet No.=Number=1 99999999
  4. Inventory=OperatorNo=Operator=Number=1 99999999
  5. Inventory=Specification=Free Text=String=(40)
  6. Inventory=InStockNo=in Stock=Number=1 9999
  7. Inventory=InventoryDay=Date=Date=
  8. Inventory=InventoryClock=Time=Time=
  9. Inventory=CountOpeNo=Inventory Counter=Number=1 99999999
  10. Inventory=FreezeDay=Freeze Date=Date=
  11. Inventory=FreezeClock=Freeze Time=Time=
  12. Inventory=Frozen=Stock Frozen=Bool=(Y/N)
  13. Inventory=BuffeInventory=Buffet inventory=Bool=(Y/N)
  14. Inventory=NoStockInventory=NOTEXT=Bool=(Y/N)
  15. Inventory=InventoryGrpNo=Inventory Group=Number=1 99999999
  16. Inventory=Confirmed=Confirmed=Bool=(Y/N)
  17. Inventory=SalesTurnover=NOTEXT=Decimal=(12,2)
  18. Inventory=SelectLevel=NOTEXT=Number=
  1. $InventoryGrp=CompNo=Company=Number=1 9999
  2. $InventoryGrp=BranchNo=Branch=Number=1 9999
  3. $InventoryGrp=InventoryGrpNo=Inventory Group=Number=1 99999999
  4. InventoryGrp=Specification=Free Text=String=(40)
  5. InventoryGrp=InStockNo=Stock No.=Number=1 9999
  6. InventoryGrp=InventoryDay=Starting Date Inventory=Date=
  7. InventoryGrp=InventoryClock=Starting Time Inventory=Time=
  8. InventoryGrp=Confirmed=Confirmed=Bool=(Y/N)
  9. $MoveBranchInPos=CompNo=Company=Number=1 9999
  1. $MoveBranchInPos=BranchNo=Branch=Number=1 9999
  2. $MoveBranchInPos=StockMoveNo=Stock Movement Note No.=Number=1 99999999
  3. $MoveBranchInPos=PosNo=Position No.=Number=1 9999
  4. MoveBranchInPos=ItemNo=Item=Decimal=(14,0)
  5. MoveBranchInPos=Specification=Free Text=String=(40)
  6. MoveBranchInPos=OrderQuan=Quantity=Decimal=(13,3)
  7. MoveBranchInPos=MoveQuan=Moved Quantity=Decimal=(13,3)
  8. MoveBranchInPos=MoveValue=Moved Value=Decimal=(11,3)
  9. MoveBranchInPos=MoveLastValue=Last moved value=Decimal=(11,3)
  10. MoveBranchInPos=QuUnitTxt=Unit=String=(8)
  11. MoveBranchInPos=QuantityUnit=Quantity Unit=Number=1 999
  12. MoveBranchInPos=FromBranchNo=Branch=Number=1 9999
  13. MoveBranchInPos=ToBranchNo=Branch=Number=1 9999
  14. MoveBranchInPos=FromStockNo=Stock No.=Number=1 9999
  15. MoveBranchInPos=ToStockNo=Stock No.=Number=1 9999
  1. $MoveBranchOutPos=CompNo=Company=Number=1 9999
  2. $MoveBranchOutPos=BranchNo=Branch=Number=1 9999
  3. $MoveBranchOutPos=StockMoveNo=Stock Movement Note No.=Number=1 99999999
  4. $MoveBranchOutPos=PosNo=Position No.=Number=1 9999
  5. MoveBranchOutPos=ItemNo=Item=Decimal=(14,0)
  6. MoveBranchOutPos=Specification=Free Text=String=(40)
  7. MoveBranchOutPos=OrderQuan=Quantity=Decimal=(13,3)
  8. MoveBranchOutPos=MoveQuan=Moved Quantity=Decimal=(13,3)
  9. MoveBranchOutPos=MoveValue=Moved Value=Decimal=(11,3)
  10. MoveBranchOutPos=MoveLastValue=Last moved Value=Decimal=(11,3)
  11. MoveBranchOutPos=QuUnitTxt=Unit=String=(8)
  12. MoveBranchOutPos=QuantityUnit=Quantity Unit=Number=1 999
  13. MoveBranchOutPos=FromBranchNo=Branch=Number=1 9999
  14. MoveBranchOutPos=ToBranchNo=Branch=Number=1 9999
  15. MoveBranchOutPos=FromStockNo=Stock No.=Number=1 9999
  16. MoveBranchOutPos=ToStockNo=Stock No.=Number=1 9999
  1. $MovementPos=CompNo=Company=Number=1 9999
  2. $MovementPos=BranchNo=Branch=Number=1 9999
  3. $MovementPos=StockMoveNo=Stock Movement No.=Number=1 99999999
  4. $MovementPos=PosNo=Position No.=Number=1 9999
  5. MovementPos=ItemNo=Item=Decimal=(14,0)
  6. MovementPos=Specification=Free Text=String=(40)
  7. MovementPos=OrderQuan=Quantity=Decimal=(13,3)
  8. MovementPos=MoveQuan=Quantity=Decimal=(13,3)
  9. MovementPos=MoveValue=Value=Decimal=(11,3)
  10. MovementPos=MoveLastValue=Value last Price=Decimal=(11,3)
  11. MovementPos=QuUnitTxt=Unit=String=(8)
  12. MovementPos=QuantityUnit=Quantity Unit=Number=1 999
  13. MovementPos=FromStockNo=Stock No.=Number=1 9999
  14. MovementPos=ToStockNo=Stock No.=Number=1 9999
  15. MovementPos=IsCostItem=NOTEXT=String=(3)
  1. $OrderReqPos=CompNo=Company=Number=1 9999
  2. $OrderReqPos=BranchNo=Branch=Number=1 9999
  3. $OrderReqPos=OrderReqNo=Internal Delivery Note No.=Number=1 99999999
  4. $OrderReqPos=PosNo=Position No.=Number=1 9999
  5. OrderReqPos=ItemNo=Item=Decimal=(14,0)
  6. OrderReqPos=AssortmentNo=Assortment No.=Number=1 9999
  7. OrderReqPos=OrderQuan=Quantity in Orders=Decimal=(11,3)
  8. OrderReqPos=QuUnitTxt=Unit=String=(8)
  9. OrderReqPos=QuantityUnit=Quantity Unit=Number=1 999
  10. OrderReqPos=Specification=Free Text=String=(40)
  11. OrderReqPos=FromStockNo=from Stock=Number=1 9999
  1. $OrderRequest=CompNo=Company=Number=1 9999
  2. $OrderRequest=BranchNo=Branch=Number=1 9999
  3. $OrderRequest=OrderReqNo=Internal Delivery Note No.=Number=1 99999999
  4. OrderRequest=OperatorNo=Operator=Number=1 99999999
  5. OrderRequest=Specification=Free Text=String=(40)
  6. OrderRequest=OrderReqDay=Date=Date=
  7. OrderRequest=OrderReqClock=Time=Time=
  8. OrderRequest=ToStockNo=to Stock=Number=1 9999
  9. OrderRequest=ReservDay=Reservation Date=Date=
  10. OrderRequest=ReservClock=Reservation Time=Time=
  11. OrderRequest=Confirmed=Confirmed=Bool=(Y/N)
  1. $Preparation=CompNo=Company=Number=1 9999
  2. $Preparation=BranchNo=Branch=Number=1 9999
  3. $Preparation=PreparationNo=Preparation Note No.=Number=1 99999999
  4. Preparation=OperatorNo=Operator=Number=1 99999999
  5. Preparation=ItemNo=Preparation Item=Decimal=(14,0)
  6. Preparation=Specification=Free Text=String=(40)
  7. Preparation=InBranchNo=in Branch=Number=1 9999
  8. Preparation=ToStockNo=Stock No.=Number=1 9999
  9. Preparation=PreparationDay=Date=Date=
  10. Preparation=PreparationClock=Time=Time=
  11. Preparation=PreparCosts=Preparation Costs=Decimal=(11,3)
  12. Preparation=Confirmed=Confirmed=Bool=(Y/N)
  1. $PreparPos=CompNo=Company=Number=1 9999
  2. $PreparPos=BranchNo=Branch=Number=1 9999
  3. $PreparPos=PreparationNo=Preparation Note No.=Number=1 99999999
  4. $PreparPos=PosNo=Position No.=Number=1 9999
  5. PreparPos=ItemNo=Item=Decimal=(14,0)
  6. PreparPos=Specification=Free Text=String=(40)
  7. PreparPos=ItemQuan=Quantity=Decimal=(13,3)
  1. $ProdPos=CompNo=Company=Number=1 9999
  2. $ProdPos=BranchNo=Branch=Number=1 9999
  3. $ProdPos=ProductionNo=Production Note No.=Number=1 99999999
  4. $ProdPos=PosNo=Position No.=Number=1 9999
  5. ProdPos=ItemNo=Prod. Item=Decimal=(14,0)
  6. ProdPos=Specification=Free Text=String=(40)
  7. ProdPos=ItemQuan=Quantity=Decimal=(13,3)
  8. ProdPos=ProductCosts=Production Cost=Decimal=(11,3)
  9. ProdPos=QuUnitTxt=Unit=String=(8)
  10. ProdPos=QuantityUnit=Unit=Number=1 999
  11. ProdPos=InBranchNo=Branch=Number=1 9999
  12. ProdPos=InStockNo=Stock No.=Number=1 9999
  1. $Production=CompNo=Company=Number=1 9999
  2. $Production=BranchNo=Branch=Number=1 9999
  3. $Production=ProductionNo=Production Note No.=Number=1 99999999
  4. Production=OperatorNo=Operator=Number=1 99999999
  5. Production=Specification=Free Text=String=(40)
  6. Production=InProfitCenterNo=Profit Center=Number=1 9999
  7. Production=ProductionDay=Date=Date=
  8. Production=ProductionClock=Time=Time=
  9. Production=Confirmed=Confirmed=Bool=(Y/N)
  1. ReceivedPos=ItemNo=Item=Decimal=(14,0)
  2. ReceivedPos=LANNo=Supplier Item No.=Decimal=(14,0)
  3. ReceivedPos=Specification=Free Text=String=(40)
  4. ReceivedPos=RecItemNo=Supplier Item No.=Decimal=(14,0)
  5. ReceivedPos=SupplierNo=Supplier No.=Number=1 999999
  6. ReceivedPos=DiscPercQuan=Perc.Discount/Quantity=Decimal=(13,3)
  7. ReceivedPos=DiscPercValue=Perc.Discount/Value=Decimal=(13,3)
  8. ReceivedPos=DiscValQuan=Val.Discount/Quantity=Decimal=(13,3)
  9. ReceivedPos=DiscValValue=Val.Discount/Value=Decimal=(13,3)
  10. ReceivedPos=DiscNatQuan=Disc.in kind/Quantity=Decimal=(13,3)
  11. ReceivedPos=DiscNatVal=Disc.in kind/Value=Decimal=(13,3)
  12. ReceivedPos=Quantity=Quantity=Decimal=(13,3)
  13. ReceivedPos=PriceOrUnit=Price per Order Unit=Decimal=(11,3)
  14. ReceivedPos=PosValue=Value=Decimal=(11,3)
  15. ReceivedPos=OrderUnit=Order Unit=Number=1 999
  16. ReceivedPos=FixCost=Fixed Costs=Decimal=(11,3)
  17. ReceivedPos=VarCost=Variable Costs=Decimal=(11,3)
  18. ReceivedPos=CurrencySymbol=Currency Symbol=String=(4)
  19. ReceivedPos=QuUnitTxt=Unit=String=(8)
  20. $ReceivedPos=CompNo=Company=Number=1 9999
  21. $ReceivedPos=BranchNo=Branch=Number=1 9999
  22. $ReceivedPos=ReceivedNo=Delivery Note No.=Number=1 99999999
  23. $ReceivedPos=PosNo=Position No.=Number=1 9999
  24. ReceivedPos=IndiceTheoret=Index % CP=Decimal=(7,2)
  25. ReceivedPos=ContPercValue=Index % SP=Decimal=(7,2)
  26. ReceivedPos=ReceivedAdjust=Adjust received Value=Decimal=(11,3)
  27. ReceivedPos=ToStockNo=to Stock=Number=1 9999
  1. $Recipe=CompNo=Company=Number=1 9999
  2. $Recipe=RecipeNo=Recipe=Number=1 999999
  3. Recipe=Name=Description=String=(32)
  4. Recipe=RecipeType=Recipe type=Number=1 3
  5. Recipe=RecommendSellP=Recommended Sell.Price=Decimal=(10,2)
  6. Recipe=GrossProfitMargin=Profit margin=Decimal=(11,3)
  7. Recipe=QuantityUnit=Base Unit=Number=1 999
  8. Recipe=RecipeSize=Size=Decimal=(5,2)
  9. Recipe=CalculatedPrice=Calculated Price=Decimal=(10,2)
  10. Recipe=AutoProduction=Auto production=Bool=(Y/N)
  11. Recipe=CostValue=Recipe Cost=Decimal=(11,3)
  1. $RecipeLine=CompNo=Company=Number=1 9999
  2. $RecipeLine=RecipeNo=Recipe=Number=1 999999
  3. $RecipeLine=PositionNo=Position=Number=1 9999
  4. RecipeLine=ItemNo=Item=Decimal=(14,0)
  5. RecipeLine=SubRecipeNo=Subrecipe=Number=1 999999
  6. RecipeLine=Quantity=Quantity=Decimal=(11,3)
  7. RecipeLine=QuantityUnit=Quantity Unit=Number=1 999
  8. RecipeLine=QuUnitTxt=Unit=String=(8)
  9. RecipeLine=Text=Description=String=(32)
  10. RecipeLine=CostValue=Cost=Decimal=(11,3)
  1. RecipeResolv=CompNo=Company=Number=1 9999
  2. RecipeResolv=RecipeNo=Recipe=Number=1 999999
  3. RecipeResolv=ItemNo=Item=Decimal=(14,0)
  4. RecipeResolv=Quantity=Quantity=Decimal=(11,3)
  5. RecipeResolv=PosVal=Pos.Value=Decimal=(12,2)
  6. RecipeResolv=Discount=Discount=Decimal=(12,2)
  7. RecipeResolv=CostValue=Cost=Decimal=(11,3)
  8. RecipeResolv=QuantityUnit=Unit=Number=1 999
  9. RecipeResolv=BranchNo=Branch=Number=1 9999
  10. RecipeResolv=StockNo=Stock No.=Number=1 9999
  11. RecipeResolv=DepartmentNo=Department=Number=1 999999
  12. RecipeResolv=VatAmount=NOTEXT=Decimal=(12,2)
  1. ReturnPos=ItemNo=Item=Decimal=(14,0)
  2. ReturnPos=LANNo=Supplier Item No.=Decimal=(14,0)
  3. ReturnPos=Specification=Free Text=String=(40)
  4. ReturnPos=RecItemNo=Supplier Item No.=Decimal=(14,0)
  5. ReturnPos=SupplierNo=Supplier No.=Number=1 999999
  6. ReturnPos=DiscPercQuan=NOTEXT=Decimal=(13,3)
  7. ReturnPos=DiscPercValue=NOTEXT=Decimal=(13,3)
  8. ReturnPos=DiscValQuan=NOTEXT=Decimal=(13,3)
  9. ReturnPos=DiscValValue=NOTEXT=Decimal=(13,3)
  10. ReturnPos=DiscNatQuan=NOTEXT=Decimal=(13,3)
  11. ReturnPos=DiscNatVal=NOTEXT=Decimal=(13,3)
  12. ReturnPos=Quantity=Quantity=Decimal=(13,3)
  13. ReturnPos=PriceOrUnit=Price per Order Unit=Decimal=(11,3)
  14. ReturnPos=PosValue=Position Value=Decimal=(11,3)
  15. ReturnPos=OrderUnit=Order Unit=Number=1 999
  16. ReturnPos=FixCost=Fixed Costs=Decimal=(11,3)
  17. ReturnPos=VarCost=Variable Costs=Decimal=(11,3)
  18. ReturnPos=CurrencySymbol=NOTEXT=String=(4)
  19. ReturnPos=QuUnitTxt=Unit=String=(8)
  20. $ReturnPos=CompNo=Company=Number=1 9999
  21. $ReturnPos=BranchNo=Branch=Number=1 9999
  22. $ReturnPos=ReturnNo=Return Note No.=Number=1 99999999
  23. $ReturnPos=PosNo=Position No.=Number=1 9999
  24. ReturnPos=ReturnAdjust=Return adjust=Decimal=(11,3)
  25. ReturnPos=FromStockNo=from Stock=Number=1 9999
  1. $Shrinkage=CompNo=Company=Number=1 9999
  2. $Shrinkage=BranchNo=Branch=Number=1 9999
  3. $Shrinkage=ShrinkageNo=Shrinkage No.=Number=1 99999999
  4. Shrinkage=OperatorNo=Operator=Number=1 99999999
  5. Shrinkage=Specification=Free Text=String=(40)
  6. Shrinkage=InProfitCenterNo=Profit Center=Number=1 9999
  7. Shrinkage=ShrinkageDay=Date=Date=
  8. Shrinkage=ShrinkageClock=Time=Time=
  9. Shrinkage=Confirmed=Confirmed=Bool=(Y/N)
  1. $ShrinkagePos=CompNo=Company=Number=1 9999
  2. $ShrinkagePos=BranchNo=Branch=Number=1 9999
  3. $ShrinkagePos=ShrinkageNo=Shrinkage No.=Number=1 99999999
  4. $ShrinkagePos=PosNo=Position No.=Number=1 9999
  5. ShrinkagePos=ItemNo=Item=Decimal=(14,0)
  6. ShrinkagePos=Specification=Free Text=String=(40)
  7. ShrinkagePos=ShrinkageType=Shrinkage Type=Number=1 9999
  8. ShrinkagePos=ItemQuan=Quantity=Decimal=(13,3)
  9. ShrinkagePos=ShrinkValue=Shrinkage Value=Decimal=(11,3)
  10. ShrinkagePos=QuUnitTxt=Unit=String=(8)
  11. ShrinkagePos=QuantityUnit=Quantity Unit=Number=1 999
  12. ShrinkagePos=InBranchNo=Branch=Number=1 9999
  13. ShrinkagePos=InStockNo=Stock No.=Number=1 9999
  14. ShrinkagePos=TextGroupNo=Text Group=Number=1 65535
  1. $StockItem=CompNo=Company=Number=1 9999
  2. $StockItem=BranchNo=Branch=Number=1 9999
  3. $StockItem=StockNo=Stock No.=Number=1 9999
  4. $StockItem=ItemNo=Item=Decimal=(14,0)
  5. StockItem=MinStock=Minimum=Decimal=(11,3)
  6. StockItem=TargetStock=Plan Stock=Decimal=(11,3)
  7. StockItem=MaxStock=Maximum=Decimal=(11,3)
  8. StockItem=ShelfNo=Shelf Position 1=String=(8)
  9. StockItem=ShelfNo2=Shelf Position 2=String=(8)
  10. StockItem=SuppNoLastTi=Preferred Supplier=Number=1 999999
  11. StockItem=OrderLocal=Order in Company Level=Bool=(Y/N)
  12. StockItem=BaseQuantityUnit=Quantity Unit=Number=1 999
  13. StockItem=StockQuantityUnit=Quantity Unit=Number=1 999
  14. StockItem=CostItem=Cost Item=Bool=(Y/N)
  1. $StockItemSt=CompNo=Company=Number=1 9999
  2. $StockItemSt=BranchNo=Branch=Number=1 9999
  3. $StockItemSt=StockNo=Stock No.=Number=1 9999
  4. $StockItemSt=ItemNo=Item=Decimal=(14,0)
  5. StockItemSt=InStock=Quantity in Stock=Decimal=(11,3)
  6. StockItemSt=SinceInvBuffQ=Buffet since last Inv.=Decimal=(11,3)
  7. StockItemSt=CostPrice=Calc.cost price=Decimal=(11,3)
  8. StockItemSt=LastPrice=Last Price=Decimal=(11,3)
  9. StockItemSt=QuanOrders=Open orders=Decimal=(11,3)
  10. StockItemSt=QuanRequested=Quantity requested=Decimal=(11,3)
  11. StockItemSt=SinceInvQuan=Quantity sold=Decimal=(11,3)
  12. StockItemSt=SinceInvCVal=Sold Value Cost Price=Decimal=(13,3)
  13. StockItemSt=SinceInvTuOv=Turnover since Inventory=Decimal=(13,3)
  14. StockItemSt=SinceInvInVal=Delivery Turnover since Inventory=Decimal=(13,3)
  15. StockItemSt=SinceInvInQua=Quan. incoming Goods=Decimal=(11,3)
  16. StockItemSt=LastDelivDay=Last outgoing Goods=Date=
  17. StockItemSt=ArrivalDay=Goods received Date=Date=
  18. StockItemSt=LastInvDay=Last Inventory=Date=
  19. StockItemSt=LastSellDay=Last Sell=Date=
  20. StockItemSt=BaseQuantityUnit=Quantity Unit=Number=1 999
  21. StockItemSt=StockQuantityUnit=Quantity Unit=Number=1 999
  22. StockItemSt=ShortText=Unit=String=(8)
  23. StockItemSt=InStockSu=Quantity=Decimal=(11,3)
  1. $StockLocatio=CompNo=Company=Number=1 9999
  2. $StockLocatio=BranchNo=Branch=Number=1 9999
  3. $StockLocatio=StockNo=Stock No.=Number=1 9999
  4. StockLocatio=TerminalNo=Terminal=Number=1 999999
  5. StockLocatio=ProfitCenterNo=Profit Center=Number=1 9999
  6. StockLocatio=OperatorNo=Operator=Number=1 99999999
  7. StockLocatio=Magazine=Goods Received Stock=Bool=(Y/N)
  8. StockLocatio=OrderTypNo=Order Type=Number=0 9
  9. StockLocatio=HandStock=Hand Stock=Bool=(Y/N)
  10. StockLocatio=BuffeStock=Buffet Stock=Bool=(Y/N)
  11. StockLocatio=NoStockInventory=NOTEXT=Bool=(Y/N)
  12. StockLocatio=Text=Description=String=(20)
  13. StockLocatio=SupplTypNo=Goods Rec. Select Type=Number=0 9
  1. $StockMoveBranchIn=CompNo=Company=Number=1 9999
  2. $StockMoveBranchIn=BranchNo=Branch=Number=1 9999
  3. $StockMoveBranchIn=StockMoveNo=Stock Movement No.=Number=1 99999999
  4. StockMoveBranchIn=OperatorNo=Operator=Number=1 99999999
  5. StockMoveBranchIn=Specification=Free Text=String=(40)
  6. StockMoveBranchIn=FromBranchNo=From Branch=Number=1 9999
  7. StockMoveBranchIn=ToBranchNo=To Branch=Number=1 9999
  8. StockMoveBranchIn=FromStockNo=From Stock=Number=1 9999
  9. StockMoveBranchIn=ToStockNo=To Stock=Number=1 9999
  10. StockMoveBranchIn=StockMoveDay=Date=Date=
  11. StockMoveBranchIn=StockMoveClock=Time=Time=
  12. StockMoveBranchIn=FromStockMoveNo=From Stock move No.=Number=1 99999999
  13. StockMoveBranchIn=GoodsInTrans=Goods in transit=Bool=(Y/N)
  14. StockMoveBranchIn=Confirmed=Confirmed=Bool=(Y/N)
  1. $StockMoveBranchOut=CompNo=Company=Number=1 9999
  2. $StockMoveBranchOut=BranchNo=Branch=Number=1 9999
  3. $StockMoveBranchOut=StockMoveNo=Stock Movement No.=Number=1 99999999
  4. StockMoveBranchOut=OperatorNo=Operator=Number=1 99999999
  5. StockMoveBranchOut=Specification=Free Text=String=(40)
  6. StockMoveBranchOut=FromBranchNo=Branch=Number=1 9999
  7. StockMoveBranchOut=ToBranchNo=Branch=Number=1 9999
  8. StockMoveBranchOut=FromStockNo=Stock No.=Number=1 9999
  9. StockMoveBranchOut=ToStockNo=Stock No.=Number=1 9999
  10. StockMoveBranchOut=StockMoveDay=Date=Date=
  11. StockMoveBranchOut=StockMoveClock=Time=Time=
  12. StockMoveBranchOut=GoodsInTrans=Goods in transit=Bool=(Y/N)
  13. StockMoveBranchOut=Confirmed=Confirmed=Bool=(Y/N)
  1. $StockMovemen=CompNo=Company=Number=1 9999
  2. $StockMovemen=BranchNo=Branch=Number=1 9999
  3. $StockMovemen=StockMoveNo=Stock Movement No.=Number=1 99999999
  4. StockMovemen=OperatorNo=Operator=Number=1 99999999
  5. StockMovemen=Specification=Free Text=String=(40)
  6. StockMovemen=FromStockNo=Stock No.=Number=1 9999
  7. StockMovemen=ToStockNo=to Stock=Number=1 9999
  8. StockMovemen=StockMoveDay=Date=Date=
  9. StockMovemen=StockMoveClock=Time=Time=
  10. StockMovemen=GoodsInTrans=Goods in transit=Bool=(Y/N)
  11. StockMovemen=Confirmed=Confirmed=Bool=(Y/N)
  1. $StockTabEnt=CompNo=Company=Number=1 9999
  2. $StockTabEnt=BranchNo=Branch=Number=1 9999
  3. $StockTabEnt=StockTableNo=Stock Table=Number=1 9999
  4. $StockTabEnt=StockTypeNo=Stock Type=Number=1 99
  5. StockTabEnt=StockNo=Stock No.=Number=1 9999
  6. StockTabEnt=ProductionProCNo=Profit Center=Number=1 9999
  1. $StockTable=CompNo=Company=Number=1 9999
  2. $StockTable=BranchNo=Branch=Number=1 9999
  3. $StockTable=StockTableNo=Stock Table=Number=1 9999
  4. StockTable=Text=Description=String=(20)
  1. $StockType=CompNo=Company=Number=1 9999
  2. $StockType=StockTypeNo=Stock Type=Number=1 99
  3. StockType=Text=Description=String=(20)
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany