Database Tables "Application" (applCommon)

The following description deals with the layout of the database tables for the component applCommon. 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. $ApplComp=ApplCompNo=Application=Number=1 9999
  2. ApplComp=ApplName=Name=String=(20)
  3. ApplComp=FsmName=FSM File=String=(20)
  4. ApplComp=FglName=4GL File=String=(20)
  5. ApplComp=ApplGroupNo=Application Group =Number=1 99
  6. ApplComp=FrameNo=Frame No.=Number=1 99999999
  1. $StatParam=Name=Statistic Name=String=(20)
  2. StatParam=Yearly=Year=Bool=(Y/N)
  3. StatParam=YearCnt=Year Cnt. =Number=
  4. StatParam=Monthly=Month=Bool=(Y/N)
  5. StatParam=MonthCnt=Month Cnt.=Number=
  6. StatParam=Weekly=Week=Bool=(Y/N)
  7. StatParam=WeekCnt=Week Cnt.=Number=
  8. StatParam=Daily=Day=Bool=(Y/N)
  9. StatParam=DayCnt=Day Cnt.=Number=
  10. StatParam=PerShift=Shift=Bool=(Y/N)
  11. StatParam=ShiftCnt=Shift Cnt.=Number=
  12. StatParam=MainObjRef=Reference=String=(20)
  13. StatParam=YearFrom=Year Table=String=(20)
  14. StatParam=MonthFrom=Month Table=String=(20)
  15. StatParam=WeekFrom=Week Table=String=(20)
  16. StatParam=DayFrom=Day Table=String=(20)
  17. StatParam=ShiftFrom=Shift Table=String=(20)

====

  1. SupplPosMix=ItemNo=Item=Decimal=(14,0)
  2. SupplPosMix=LANNo=Supplier Item No.=Decimal=(14,0)
  3. SupplPosMix=Specification=Free Text=String=(40)
  4. SupplPosMix=RecItemNo= Supplier Item No.=Decimal=(14,0)
  5. SupplPosMix=SupplierNo=Supplier No.=Number=1 999999
  6. SupplPosMix=DiscPercQuan=NOTEXT=Decimal=(13,3)
  7. SupplPosMix=DiscPercValue=NOTEXT=Decimal=(13,3)
  8. SupplPosMix=DiscValQuan=NOTEXT=Decimal=(13,3)
  9. SupplPosMix=DiscValValue=NOTEXT=Decimal=(13,3)
  10. SupplPosMix=DiscNatQuan=NOTEXT=Decimal=(13,3)
  11. SupplPosMix=DiscNatVal=NOTEXT=Decimal=(13,3)
  12. SupplPosMix=Quantity=Quantity=Decimal=(13,3)
  13. SupplPosMix=PriceOrUnit=Price per order unit.=Decimal=(11,3)
  14. SupplPosMix=PosValue=NOTEXT=Decimal=(11,3)
  15. SupplPosMix=OrderUnit=Quantity Unit=Number=1 999
  16. SupplPosMix=FixCost=Fix Costs=Decimal=(11,3)
  17. SupplPosMix=VarCost=Variable Costs=Decimal=(11,3)
  18. SupplPosMix=CurrencySymbol=NOTEXT=String=(4)
  19. SupplPosMix=QuUnitTxt=Unit=String=(8)
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany