Database Tables "Item" (goods)

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

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. $ArtLabelType=CompNo=Company=Number=1 9999
  2. $ArtLabelType=ItemNo=Item No.=Decimal=(14,0)
  3. $ArtLabelType=PosNo=Position No.=Number=1 9999
  4. ArtLabelType=LabelNo=Label no.=Number=1 9999
  5. ArtLabelType=LabelQuan=Quantity=Number=1 999
  6. ArtLabelType=PromotLabelNo=Promotion Label=Number=1 9999
  7. ArtLabelType=PromotLabelQuan=Quantity (P)=Number=1 999
  1. $ArtSelect=CompNo=Company=Number=1 9999
  2. $ArtSelect=ArtSelectNo=Item Selector=Number=1 9999
  3. ArtSelect=Name=Descriptor=String=(32)
  1. $Article=CompNo=Company=Number=1 9999
  2. $Article=ItemNo=Item=Decimal=(14,0)
  3. Article=ItemName=Descriptor=String=(20)
  4. Article=DepartmentNo=Department=Number=1 999999
  5. Article=Text1=Text 1=String=(32)
  6. Article=Text2=Text 2=String=(32)
  7. Article=TextKeyb=Key Text=String=(32)
  8. Article=MatchCode=Match Code=String=(12)
  9. Article=SellingQuantityUnit=Sales Qty. Unit=Number=1 999
  10. Article=PackQuantityUnit=Pack Qty. Unit=Number=1 999
  11. Article=StockQuantityUnit=Stock Qty. Unit=Number=1 999
  12. Article=TaraValue=Tare Value=Decimal=(11,3)
  13. Article=AccountNo=Cost Center=Decimal=(11,0)
  14. Article=WasteFactor=% Waste=Decimal=(5,2)
  15. Article=WarningTextGrpNo=Warning Text Group=Number=1 65535 (Not in database)
  16. Article=WarningTextNo=Warning Text no.=Number=1 9999
  17. Article=Tandem=Tandem=Decimal=(14,0)
  18. Article=StockItemNo=Stock Item=Decimal=(14,0)
  19. Article=GroupItemNo=Group Item =Decimal=(14,0)
  20. Article=Totalizer=Totalizer=Number=0 99
  21. Article=Locked=Locked=Bool=(Y/N)
  22. Article=OpenPlu=Open Items=Bool=(Y/N)
  23. Article=TakeAway=Take away=Bool=(Y/N)
  24. Article=PriceNegative=Negative Price=Bool=(Y/N)
  25. Article=MultiplProhibited=Multiply prohibited=Bool=(Y/N)
  26. Article=MultiplForced=Multiply forced=Bool=(Y/N)
  27. Article=Discountable=Price Change permit=Bool=(Y/N)
  28. Article=Attendance=Service Charge=Bool=(Y/N)
  29. Article=SpiritTax=Alcohol Tax=Number=1 99
  30. Article=BeverageTax=Beverage Tax=Number=1 99
  31. Article=Scale=Scale Item=Bool=(Y/N)
  32. Article=Deposit=Deposit Item=Bool=(Y/N)
  33. Article=ContentOverride=Content overwrite=Bool=(Y/N)
  34. Article=GuestGift=Guest Gift=Bool=(Y/N)
  35. Article=PrintWaiterDate=Print Waiter/Date=Bool=(Y/N)
  36. Article=PrintOnZero=Print Price 0=Bool=(Y/N)
  37. Article=GuestCounter=Guest Counter=Bool=(Y/N)
  38. Article=CreditSale=Credit Sale=Bool=(Y/N)
  39. Article=PluNotFound=PLU not found=Bool=(Y/N)
  40. Article=TimePeriodStat=Time Period Statistic=Bool=(Y/N)
  41. Article=OperatorStat=Operator Statistic=Bool=(Y/N)
  42. Article=ImmediatePrint=Immediate Print=Bool=(Y/N)
  43. Article=IsSalesItem=Sales Item=Bool=(Y/N)
  44. Article=IsStockItem=Stock Item=Bool=(Y/N)
  45. Article=IsMagazineItem=Purchase Item=Bool=(Y/N)
  46. Article=AutoForSell=Autoriz. for sell =Bool=(Y/N)
  47. Article=LevelForOrder=Autorise to order =Number=
  48. Article=VoucherPrint=Voucher Print=Bool=(Y/N)
  49. Article=BlockedFromDay=Blocked from Date=date=
  50. Article=BlockedFromTime=Blocked from Time=time=
  51. Article=BlockedToDay=Blocked to Date=date=
  52. Article=BlockedToTime=Blocked to Time=time=
  53. Article=OrderTypeNo=Order Type=Number=0 9
  54. Article=SupplierNo=Preferred Supplier=Number=1 999999
  55. Article=PrintTypeNo1=Printer Type=Number=1 99
  56. Article=DispTypeNo=Dispenser Type=Number=1 99
  57. Article=StockTypeNo=Stock Type=Number=1 99
  58. Article=TextGroupNo=Text Group=Number=1 65535
  59. Article=SelTextAcc=No. of text select=Number=1 9
  60. Article=ArticleGrpNo=Item Group=Number=1 9999
  61. Article=PriceGrpNo=Price Group No.=Number=1 9999
  62. Article=ArtSelectNo1=1st Selection=Number=1 9999
  63. Article=ArtSelectNo2=2nd Selection=Number=1 9999
  64. Article=ArtSelectNo3=3rd Selection=Number=1 9999
  65. Article=ArtSelectNo4=4th Selection=Number=1 9999
  66. Article=BuffeNo=Buffet No.=Number=1 999999
  67. Article=RecipeNo=Recipe=Number=1 999999
  68. Article=MenuNo=Menu=Number=1 999
  69. Article=PrintLabelNo=Print label no.=Number=1 9999
  70. Article=LabelAcc=No. of Label=Number=1 999
  71. Article=ServiceCharge=Service Charge=Number=1 99
  72. Article=HandStock=Hand Stock=Bool=(Y/N)
  73. Article=GuaranteeGrp=Warranty Text=Number=1 65535
  74. Article=PrintKey=Receipt Print Type=Number=0 999
  75. Article=ProfitCalcBase=Profit calc.base=Decimal=(10,3)
  76. Article=ProdLocationNo=Production Area=Number=0 999
  77. Article=ProdQuant=Product Quantity=Number=0 9999
  78. Article=Preparation=Preparation=Number=
  79. Article=DeptName=Department=String=(20) (Not in database)
  80. Article=MainDeptName=Main Department=String=(20) (Not in database)
  81. Article=SectionName=Section=String=(20) (Not in database)
  82. Article=NormalSellingPrice=Normal Price=String=(32) (Not in database)
  1. $ArticleGrp=CompNo=Company=Number=1 9999
  2. $ArticleGrp=ArticleGrpNo=Item Group=Number=1 9999
  3. ArticleGrp=Name=Descriptor=String=(32)
  1. $CourseGroup=CompNo=Company=Number=1 9999
  2. $CourseGroup=CourseGrpNo=Course Grp.=Number=1 65535
  3. CourseGroup=Text=Descriptor=String=(20)
  1. $CourseGrpLine=CompNo=Company=Number=1 9999
  2. $CourseGrpLine=CourseGrpNo=Course Grp.=Number=1 65535
  3. $CourseGrpLine=PositionNo=Position=Number=1 9999
  4. CourseGrpLine=MaxSelect=Max.Select=Number=
  5. CourseGrpLine=Text=Descriptor=String=(20)
  1. $Department=CompNo=Company=Number=1 9999
  2. $Department=DeptNo=Department=Number=1 999999
  3. Department=ItemName=Descriptor=String=(20)
  4. Department=Text1=Text 1=String=(32)
  5. Department=Text2=Text 2=String=(32)
  6. Department=MainDeptNo=Main Department=Number=1 999999
  7. Department=Locked=Locked=Bool=(Y/N)
  8. Department=PriceNegative=Price negative=Bool=(Y/N)
  9. Department=MultiplProhibited=Multiply prohibited=Bool=(Y/N)
  10. Department=Discountable=Price Change permit=Bool=(Y/N)
  11. Department=ServiceCharge=Service Charge=Number=1 99
  12. Department=OperServiceMoney=Operator tip=Bool=(Y/N)
  13. Department=Deposit=Deposit=Bool=(Y/N)
  14. Department=SpiritTax=Alcohol Tax=Number=1 99
  15. Department=BeverageTax=Beverage Tax=Number=1 99
  16. Department=TakeAway=Take away=Bool=(Y/N)
  17. Department=DefaultLock=Locked by Default=Bool=(Y/N)
  18. Department=MinValue=min. Limit=Decimal=(10,2)
  19. Department=MaxValue=max. Limit=Decimal=(10,2)
  20. Department=DefPrintKey=Receipt Print Type=Number=0 999
  21. Department=PrintTypeNo=Printer Type=Number=1 99
  22. Department=Selector=Select. to Print=Number=
  23. Department=StartTime=Sales Begin=time=
  24. Department=EndTime=Sales End=time=
  25. Department=VatNo=VAT=Number=1 99
  26. Department=VatNo2=Purchase VAT=Number=1 99
  27. Department=TakeAwayVatNo=Takeaway Tax=Number=1 99
  28. Department=SalesAccount=Sales Account=Decimal=(11,0)
  29. Department=PurchaseAcc=Purchase Account=Decimal=(11,0)
  30. Department=CostAccount=NOTEXT=Decimal=(11,0)
  31. Department=SellingQuantityUnit=Sales Unit=Number=1 999
  32. Department=ServiceChargeNo=Service Charge No.=Number=
  33. Department=Totalizer=Totalizer=Number=0 99
  34. Department=SpecialTax=Consumer Tax=Number=1 99
  35. Department=ActivateDay=Activation Date=date=
  1. $DeptBudPos=CompNo=Company=Number=1 9999
  2. $DeptBudPos=BranchNo=Branch=Number=1 9999
  3. $DeptBudPos=ProfitCenterNo=Profit Center=Number=1 9999
  4. $DeptBudPos=YearNo=Year=Number=
  5. $DeptBudPos=MonthNo=Month=Number=
  6. $DeptBudPos=DeptNo=Department=Number=1 999999
  7. DeptBudPos=Turnover=Turnover=Decimal=(12,2)
  8. DeptBudPos=Profit=Profit=Decimal=(12,2)
  1. $DeptBudget=CompNo=Company=Number=1 9999
  2. $DeptBudget=BranchNo=Branch=Number=1 9999
  3. $DeptBudget=ProfitCenterNo=Profit Center=Number=1 9999
  4. $DeptBudget=YearNo=Year=Number=
  5. $DeptBudget=MonthNo=Month=Number=
  1. $DevGroup=CompNo=Company=Number=1 9999
  2. $DevGroup=DevGroupNo=Device Item Group=Number=1 99
  3. DevGroup=Text=Descriptor=String=(20)
  1. $DeviceItem=CompNo=Company=Number=1 9999
  2. $DeviceItem=ItemNo=Item=Decimal=(14,0)
  3. $DeviceItem=DevGroupNo=Device Item Group=Number=1 99
  4. DeviceItem=DevItemNo=Device Item=Decimal=(14,0)
  1. $EanNumber=CompNo=Company=Number=1 9999
  2. $EanNumber=EanNo=Ean=Decimal=(14,0)
  3. EanNumber=ItemNo=Item=Decimal=(14,0)
  1. $ItemError=CompNo=Company=Number=1 9999
  2. $ItemError=BranchNo=Branch=Number=1 9999
  3. $ItemError=TerminalNo=Terminal=Number=1 999999
  4. $ItemError=TransNo=Operation=Number=1 99999999
  5. $ItemError=PositionNo=Position=Number=1 9999
  6. ItemError=ArticleNo=Item=Decimal=(14,0)
  7. ItemError=DeptNo=Department=Number=1 999999
  8. ItemError=Quantity=Quantity=Decimal=(11,3)
  9. ItemError=PosVal=Pos Value=Decimal=(12,2)
  10. ItemError=Discount=Discount=Decimal=(12,2)
  11. ItemError=TruePrice=True Price=Decimal=(10,2)
  12. ItemError=TargetPrice=Item Price=Decimal=(10,2)
  13. ItemError=CostValue=Calc. Cost Price=Decimal=(12,2)
  14. ItemError=ServiceCharges=Service Charge=Decimal=(12,2)
  15. ItemError=PriceLevel=Level=Number=0 9
  16. ItemError=VatNo=VAT=Number=1 99
  17. ItemError=Category=Category=Number=0 99
  18. ItemError=TransTypeNo=Operation Mode=Number=1 9999
  19. ItemError=RelatedGcPos=Position=Number=1 9999
  20. ItemError=LineVoid=Linevoid=Bool=(Y/N)
  21. ItemError=DirectVoid=NOTEXT=Bool=(Y/N)
  22. ItemError=DirectVoided=Direct Void=Bool=(Y/N)
  23. ItemError=TakeAway=Take away=Bool=(Y/N)
  24. ItemError=Deposit=Deposit=Bool=(Y/N)
  25. ItemError=Scanned=Scanned=Bool=(Y/N)
  26. ItemError=MenuPart=Is Menu Part=Bool=(Y/N)
  27. ItemError=OnCall=On Call=Bool=(Y/N)
  28. ItemError=Course=Course=Number=1 99
  29. ItemError=Factor1=Quantity=Decimal=(11,3) (not in database)
  30. ItemError=Factor2=Quantity=Decimal=(11,3) (not in database)
  31. ItemError=Factor3= Quantity =Decimal=(11,3) (not in database)
  32. ItemError=NoPrint=NOTEXT=Bool=(Y/N) (not in database)
  33. ItemError=NoAddTexts=NOTEXT=Number= (not in database)
  34. ItemError=TransTypeText=Descriptor=String=(20) (not in database)
  35. ItemError=SalesmanNo=Salesman=Number=1 99999999
  36. ItemError=PromotNo=Promotion=Number=1 9999
  37. ItemError=PriceListNo=Price List=Number=1 9999
  1. $LabelBatch=CompNo=Company=Number=1 9999
  2. $LabelBatch=BranchNo=Branch=Number=1 9999
  3. $LabelBatch=BatchNo=Batch No.=Number=0 99999999
  4. LabelBatch=PrintDate=Date of Printing=Date=
  5. LabelBatch=PrintTime=Time of Printing=Time=
  6. LabelBatch=Specification=Free Text=String=(40)
  7. LabelBatch=Confirmed=Confirmed=Bool=(Y/N)
  1. $LabelTrans=CompNo=Company=Number=1 9999
  2. $LabelTrans=BranchNo=Branch=Number=1 9999
  3. $LabelTrans=ValidFrom=Valid from=Date=
  4. $LabelTrans=ItemNo=Item=Decimal=(14,0)
  5. LabelTrans=BatchNo=Batch No.=Number=0 99999999
  6. $LabelTrans=PrintLabelNo=Label No.=Number=1 9999
  7. LabelTrans=LabelAcc=No. of Labels=Number=1 999
  8. LabelTrans=PriceListNo=Price List=Number=1 9999
  9. LabelTrans=LANNo=Supplier Item No..=Decimal=(14,0)
  10. LabelTrans=LabelText1=Label Text 1=String=(30)
  11. LabelTrans=LabelText2= Label Text 2=String=(30)
  12. LabelTrans=LabelText3= Label Text 3=String=(30)
  13. LabelTrans=Price=NOTEXT=Decimal=(10,2)
  14. LabelTrans=SpecPrice1=1st Special Price=Decimal=(10,2)
  15. LabelTrans=PluItemNo=Item=Decimal=(14,0)
  16. LabelTrans=EanNo=Item=Decimal=(14,0)
  17. LabelTrans=DeptNo=Department=Number=1 999999
  18. LabelTrans=Deposit=Deposit=Bool=(Y/N)
  19. LabelTrans=Promotion=NOTEXT=Bool=(Y/N)
  20. LabelTrans=PackContents=NOTEXT=Decimal=(11,3)
  21. LabelTrans=ArtSelectNo1=Item Selector=Number=1 9999
  22. LabelTrans=ArtSelectNo2= Item Selector=Number=1 9999
  23. LabelTrans=ArtSelectNo3= Item Selector=Number=1 9999
  24. LabelTrans=ArtSelectNo4= Item Selector=Number=1 9999
  25. LabelTrans=ProducerNo=Supplier No.=Number=1 999999
  26. LabelTrans=Name=Descriptor=String=(32)
  27. LabelTrans=SupplierNo= Supplier No.=Number=1 999999
  28. LabelTrans=Scale=Scale Item=Bool=(Y/N)
  29. LabelTrans=ShortText=Unit=String=(8)
  30. LabelTrans=ComparePrice=Compare Price=Decimal=(10,2)
  31. LabelTrans=PriceUpDown=Price Change=Number=0 9
  32. LabelTrans=Confirmed=Confirmed=Bool=(Y/N)
  1. LabelTrigger=ClassName=Name=String=(20)
  2. LabelTrigger=AttribName=Name=String=(20)
  3. LabelTrigger=ClassNo=Table No.=Number=1 9999 (not in database)
  4. LabelTrigger=AttributeNo=Attribute=Number=1 9999 (not in database)
  5. $LabelTrigger=CompNo=Company=Number=1 9999
  6. $LabelTrigger=PrintLabelNo=Label No.=Number=1 9999
  7. $LabelTrigger=LabelTriggerNo=Position No.=Number=1 9999
  1. $LinkItem=CompNo=Company=Number=1 9999
  2. $LinkItem=BranchNo=Branch=Number=1 9999
  3. $LinkItem=LinkItemNo=Altern.Item=Decimal=(14,0)
  4. LinkItem=ItemNo=Item=Decimal=(14,0)
  1. $LinkProfIt=CompNo=Company=Number=1 9999
  2. $LinkProfIt=BranchNo=Branch=Number=1 9999
  3. $LinkProfIt=ProfitCenterNo=Profit Center=Number=1 9999
  4. $LinkProfIt=LinkProfItNo=Altern. Item=Decimal=(14,0)
  5. LinkProfIt=ItemNo=Item=Decimal=(14,0)
  1. $ListItem=CompNo=Company=Number=1 9999
  2. $ListItem=ItemNo=Item=Decimal=(14,0)
  3. $ListItem=PriceListNo=Price List=Number=1 9999
  4. ListItem=Price=Price=Decimal=(10,2)
  5. ListItem=SpecPrice1=Special Price1=Decimal=(10,2)
  6. ListItem=SpecPrice2=Special Price 2=Decimal=(10,2)
  7. ListItem=SpecPrice3=Special Price 3=Decimal=(10,2)
  8. ListItem=SpecPrice4=Special Price 4=Decimal=(10,2)
  9. ListItem=SpecPrice5=Special Price 5=Decimal=(10,2)
  10. ListItem=Locked=Locked=Bool=(Y/N)
  11. ListItem=NetCostPrice=NOTEXT=Decimal=(10,2) (not in database)
  12. ListItem=GrMarginPerc=NOTEXT=Decimal=(10,2) (not in database)
  13. ListItem=NetMarginVal=NOTEXT=Decimal=(10,2) (not in database)
  14. ListItem=NetMarginPerc=NOTEXT=Decimal=(10,2) (not in database)
  1. $MainDept=CompNo=Company=Number=1 9999
  2. $MainDept=MainDeptNo=Main Department=Number=1 999999
  3. MainDept=Text=Descriptor=String=(20)
  4. MainDept=SectionNo=Section=Number=1 999999
  1. $MainSect=CompNo=Company=Number=1 9999
  2. $MainSect=MainSectNo=Main Section=Number=1 999999
  3. MainSect=Text=Descriptor=String=(20)
  4. MainSect=SectorNo=Sector=Number=1 999999
  1. $MenuCarrier=CompNo=Company=Number=1 9999
  2. $MenuCarrier=MenuNo=Menu=Number=1 999
  3. MenuCarrier=MenuName=Name=String=(20)
  4. MenuCarrier=CourseGrpNo=Course Grp.=Number=1 65535
  1. $MenuPart=CompNo=Company=Number=1 9999
  2. $MenuPart=MenuNo=Menu=Number=1 999
  3. $MenuPart=CourseNo=Course=Number=1 99
  4. $MenuPart=PositionNo=Position=Number=1 9999
  5. MenuPart=PartNo=Item=Decimal=(14,0)
  6. MenuPart=AddPrice=Add. Price=Decimal=(12,2)
  1. $PriceChange=CompNo=Company=Number=1 9999
  2. $PriceChange=PriceChangeNo=Price Change No.=Number=1 9999
  3. $PriceChange=PriceListNo=Price List=Number=1 9999
  4. PriceChange=BranchNo=Branch=Number=1 9999
  5. PriceChange=OperatorNo=Operator=Number=1 99999999
  6. PriceChange=Text=Descriptor=String=(20)
  7. PriceChange=PriceChangeDay=Day=Date=
  8. PriceChange=PriceChangeClock= Time =Time=
  9. PriceChange=AutoChange=Auto.change=Bool=(Y/N)
  10. PriceChange=Confirmed=Confirmed=Bool=(Y/N)
  11. PriceChange=UseNetto=On Net=Bool=(Y/N)
  12. PriceChange=PriceGridNo=Price Grid=Number=1 9999
  13. PriceChange=RoundByDiff=Tolerance %=Decimal=(5,2)
  14. PriceChange=VatNo=VAT=Number=1 99
  15. PriceChange=NewRate=new VAT=Decimal=(5,2)
  1. $PriceChangePos=CompNo=Company=Number=1 9999
  2. $PriceChangePos=PriceChangeNo=Price Change No.=Number=1 9999
  3. $PriceChangePos=PriceListNo=Price List=Number=1 9999
  4. $PriceChangePos=ItemNo=Item=Decimal=(14,0)
  5. PriceChangePos=Price=Stand.Price=Decimal=(10,2)
  6. PriceChangePos=SpecPrice1=Spec.Price 1=Decimal=(10,2)
  7. PriceChangePos=SpecPrice2=Spec.Price 2=Decimal=(10,2)
  8. PriceChangePos=SpecPrice3=Spec.Price 3=Decimal=(10,2)
  9. PriceChangePos=SpecPrice4=Spec.Price 4=Decimal=(10,2)
  10. PriceChangePos=SpecPrice5=Spec.Price 5=Decimal=(10,2)
  1. $PriceGrid=CompNo=Company=Number=1 9999
  2. $PriceGrid=PriceGridNo=Price Grid=Number=1 9999
  3. PriceGrid=PriceGridText=Descriptor=String=(20)
  4. PriceGrid=Value1=Price 1=Decimal=(10,2)
  5. PriceGrid=Value2=Price 2=Decimal=(10,2)
  6. PriceGrid=Value3=Price 3=Decimal=(10,2)
  7. PriceGrid=Value4=Price 4=Decimal=(10,2)
  8. PriceGrid=Value5=Price 5=Decimal=(10,2)
  9. PriceGrid=Value6=Price 6=Decimal=(10,2)
  10. PriceGrid=Value7=Price 7=Decimal=(10,2)
  11. PriceGrid=Value8=Price 8=Decimal=(10,2)
  12. PriceGrid=Value9=Price 9=Decimal=(10,2)
  13. PriceGrid=Value10=Price 10=Decimal=(10,2)
  14. PriceGrid=Value11=Price 11=Decimal=(10,2)
  15. PriceGrid=Value12=Price 12=Decimal=(10,2)
  16. PriceGrid=Value13=Price 13=Decimal=(10,2)
  17. PriceGrid=Value14=Price 14=Decimal=(10,2)
  18. PriceGrid=Value15=Price 15=Decimal=(10,2)
  19. PriceGrid=Value16=Price 16=Decimal=(10,2)
  20. PriceGrid=Value17=Price 17=Decimal=(10,2)
  21. PriceGrid=Value18=Price 18=Decimal=(10,2)
  22. PriceGrid=Value19=Price 19=Decimal=(10,2)
  23. PriceGrid=Value20=Price 20=Decimal=(10,2)
  1. $PriceGrp=CompNo=Company=Number=1 9999
  2. $PriceGrp=PriceGrpNo=Price Group No.=Number=1 9999
  3. PriceGrp=Name=Descriptor=String=(32)
  4. PriceGrp=MinPrice=Minimum Price=Decimal=(10,2)
  5. PriceGrp=MaxPrice=Maximum Price=Decimal=(10,2)
  6. PriceGrp=PriceEnding1=1. Price Ending=Decimal=(10,2)
  7. PriceGrp=PriceEnding2=2. Price Ending=Decimal=(10,2)
  8. PriceGrp=PriceEnding3=3. Price Ending=Decimal=(10,2)
  9. PriceGrp=PriceEnding4=4. Price Ending=Decimal=(10,2)
  10. PriceGrp=PriceEnding5=5. Price Ending=Decimal=(10,2)
  11. PriceGrp=PriceEnding6=6. Price Ending=Decimal=(10,2)
  12. PriceGrp=PriceEnding7=7. Price Ending=Decimal=(10,2)
  13. PriceGrp=PriceEnding8=8. Price Ending=Decimal=(10,2)
  14. PriceGrp=PriceEnding9=9. Price Ending=Decimal=(10,2)
  15. PriceGrp=PriceEnding10=10. Price Ending=Decimal=(10,2)
  1. $PriceList=CompNo=Company=Number=1 9999
  2. $PriceList=PriceListNo=Price List=Number=1 9999
  3. PriceList=Text=Descriptor=String=(20)
  1. $PriceTime=CompNo=Company=Number=1 9999
  2. $PriceTime=TimeTableNo=Time Table=Number=1 99
  3. PriceTime=Text=Descriptor=String=(20)
  1. $PrintLabel=CompNo=Company=Number=1 9999
  2. $PrintLabel=PrintLabelNo=Label No.=Number=1 9999
  3. PrintLabel=Name=Descriptor=String=(32)
  4. PrintLabel=FglFunction=Function=String=(20)
  5. PrintLabel=FglFileName=File Name=String=(20)
  6. PrintLabel=PrinterName=Printer Name=String=(20)
  7. PrintLabel=TrayNo=Tray==
  8. PrintLabel=RealLabelNo=Real Label No.=Number=1 9999
  1. $ProfCentDept=CompNo=Company=Number=1 9999
  2. $ProfCentDept=DeptNo=Department=Number=1 999999
  3. $ProfCentDept=BranchNo=Branch=Number=1 9999
  4. $ProfCentDept=ProfitCenterNo=Profit Center=Number=1 9999
  5. ProfCentDept=Locked=Locked=Bool=(Y/N)
  6. ProfCentDept=PrintKey=Receipt Print Type=Number=0 999
  1. $Promot=CompNo=Company=Number=1 9999
  2. $Promot=PromotNo=Promotion=Number=1 9999
  3. Promot=Text=Descriptor=String=(20)
  4. Promot=StartDate=Start Date=date=
  5. Promot=EndDate=End Date=date=
  6. Promot=DiscTyp=Type=Number=0 99
  7. Promot=DiscValue=Disc.value=Decimal=(10,2)
  8. Promot=DiscPercent=Disc.percent=Decimal=(5,2)
  9. Promot=Surcharge=Surcharge=Bool=(Y/N)
  10. Promot=VoucherPromot=Voucher Promotion=Bool=(Y/N)
  11. Promot=SalesBudget=Sales Budget=Decimal=(10,2)
  12. Promot=AdvertCosts=Advertis.costs=Decimal=(10,2)
  13. Promot=OtherCosts=Other costs=Decimal=(10,2)
  14. Promot=GpBudget=Gr.profit Budget=Decimal=(10,2)
  15. Promot=SupplContrib=Suppl.Contribut=Decimal=(10,2)
  16. Promot=BranchGrpNo=Branch Group=Number=1 99
  17. Promot=ActDisc=NOTEXT=Decimal=(12,2) (not in database)
  18. Promot=CustomerTypNo=Customer Type=Number=1 99
  19. Promot=ProfCentTypeNo=Profc. Type=Number=1 99
  1. $PromotArt=CompNo=Company=Number=1 9999
  2. $PromotArt=PromotNo=Promotion=Number=1 9999
  3. PromotArt=PromotGrpNo=Group No.=Number=1 9999
  4. $PromotArt=ItemNo=Item=Decimal=(14,0)
  5. PromotArt=PromotPrice=Promot. Price=Decimal=(10,2)
  6. PromotArt=ActValue=NOTEXT=Decimal=(12,2) (not in database)
  7. PromotArt=ActQuantity=Quantity=Decimal=(11,3) (not in database)
  1. $PromotElement=CompNo=Company=Number=1 9999
  2. $PromotElement=PromotNo=Promotion=Number=1 9999
  3. $PromotElement=ElementNo=Element No.=Number=1 9999
  4. PromotElement=Text=Descriptor=String=(20)
  1. $PromotGrp=CompNo=Company=Number=1 9999
  2. $PromotGrp=PromotNo=Promotion=Number=1 9999
  3. $PromotGrp=PromotGrpNo=Group No.=Number=1 9999
  4. PromotGrp=Text=Descriptor=String=(20)
  5. PromotGrp=ElementNo=Element No.=Number=1 9999
  6. PromotGrp=DiscTyp=Type=Number=0 99
  7. PromotGrp=DiscValue=Disc.value=Decimal=(10,2)
  8. PromotGrp=DiscPercent=Disc.percent=Decimal=(5,2)
  9. PromotGrp=PromotPrice=Promot. Price=Decimal=(10,2)
  10. PromotGrp=Quantity=Quantity=Decimal=(11,3)
  11. PromotGrp=FreeItems=Free Item=Decimal=(11,3)
  12. PromotGrp=ActValue=NOTEXT=Decimal=(12,2) (not in database)
  13. PromotGrp=ActQuantity=Quantity=Decimal=(11,3) (not in database)
  1. $QuantUnit=CompNo=Company=Number=1 9999
  2. $QuantUnit=QuNo=Unit=Number=1 999
  3. QuantUnit=Text=Descriptor=String=(20)
  4. QuantUnit=ShortText=Abbreviation=String=(8)
  5. QuantUnit=Scale=Decimal Digits=Number=
  6. QuantUnit=BaseUnitNo=Base Unit=Number=1 999
  7. QuantUnit=Contents=Qty. Contents=Decimal=(11,3)
  8. QuantUnit=StockInBase=Stock in Base Unit.=Bool=(Y/N)
  1. $ScaleItem=CompNo=Company=Number=1 9999
  2. $ScaleItem=ItemNo=Item=Decimal=(14,0)
  3. ScaleItem=ScaleItemNo=Scale Item No..=Decimal=(14,0)
  4. ScaleItem=KeepingDays=Keeping Days=Number=
  5. ScaleItem=KeepingText=Keeping Text=Number=
  6. ScaleItem=TaraValue=Tare=Decimal=(11,3)
  7. ScaleItem=ScaleType=Scale Type=Number=
  8. ScaleItem=ScaleText1=Text 1=String=(30)
  9. ScaleItem=ScaleText2=Text 2=String=(30)
  10. ScaleItem=ScaleText3=Text 3=String=(30)
  11. ScaleItem=ScaleText4=Text 4=String=(30)
  12. ScaleItem=ScaleText5=Text 5=String=(30)
  13. ScaleItem=ScaleText6=Text 6=String=(30)
  1. $ScaleTrans=CompNo=Company=Number=1 9999
  2. $ScaleTrans=BranchNo=Branch=Number=1 9999
  3. $ScaleTrans=ValidFrom=NOTEXT=date=
  4. $ScaleTrans=ItemNo=Item=Decimal=(14,0)
  5. ScaleTrans=Deleted=NOTEXT=Bool=(Y/N)
  6. ScaleTrans=Confirmed=NOTEXT=Bool=(Y/N)
  1. $Section=CompNo=Company=Number=1 9999
  2. $Section=SectionNo=Section=Number=1 999999
  3. Section=Text=Descriptor=String=(20)
  4. Section=MainSectNo=Main Section=Number=1 999999
  1. $Sector=CompNo=Company=Number=1 9999
  2. $Sector=SectorNo=Sector=Number=1 999999
  3. Sector=Text=Descriptor=String=(20)
  1. $TextGroup=CompNo=Company=Number=1 9999
  2. $TextGroup=TextGroupNo=Text Group=Number=1 65535
  3. TextGroup=Text=Descriptor=String=(20)
  1. $TextGrpLine=CompNo=Company=Number=1 9999
  2. $TextGrpLine=TextGroupNo=Text Group=Number=1 65535
  3. $TextGrpLine=PositionNo=Position=Number=1 9999
  4. TextGrpLine=Text=Descriptor=String=(20)
  1. $TimeTable=CompNo=Company=Number=1 9999
  2. $TimeTable=TimeTableNo=Time table=Number=1 99
  3. $TimeTable=WeekDay=Day=Number=0 7
  4. TimeTable=Time1=Time 1=Time=
  5. TimeTable=SpecialPriceNo1=Price No.=Number=0 5
  6. TimeTable=Time2=Time 2=Time=
  7. TimeTable=SpecialPriceNo2=Price No.=Number=0 5
  8. TimeTable=Time3=Time 3=Time=
  9. TimeTable=SpecialPriceNo3=Price No.=Number=0 5
  10. TimeTable=Time4=Time 4=Time=
  11. TimeTable=SpecialPriceNo4=Price No.=Number=0 5
  12. TimeTable=Locked=Locked=Bool=(Y/N)
  1. TriggerBase=ClassName=Name=String=(20)
  2. TriggerBase=AttribName=Name=String=(20)
  3. TriggerBase=ClassNo=Table No.=Number=1 9999 (not in database)
  4. TriggerBase=AttributeNo=Attribute=Number=1 9999 (not in database)
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany