Database Tables "Sales" (sales)

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

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. CredDebAnswer=Waiter=Waiter=Number=1 99999999
  2. CredDebAnswer=TerminalNo=Terminal=Number=1 999999
  3. CredDebAnswer=DispTypeNo=Dispenser Type=Number=1 99
  4. CredDebAnswer=Table=GC=Number=1 99999999
  5. CredDebAnswer=ItemNo=Item=Decimal=(14,0)
  6. CredDebAnswer=DevItemNo=Item=Decimal=(14,0)
  7. CredDebAnswer=ItemText=NOTEXT=String=(20)
  8. CredDebAnswer=Quantity=Quantity=Decimal=(11,3)
  9. CredDebAnswer=CreditDebit=Quantity=Decimal=(11,3)
  1. $CreditCHead=CompNo=Company=Number=1 9999
  2. $CreditCHead=BranchNo=Branch=Number=1 9999
  3. $CreditCHead=TerminalNo=Terminal=Number=1 999999
  4. $CreditCHead=TransNo=Transaction=Number=1 99999999
  5. CreditCHead=ReceiptNo=Receipt=Number=1 999999
  6. CreditCHead=ProfitCenterNo=Profit Center=Number=1 9999
  7. CreditCHead=OperatorNo=Operator=Number=1 99999999
  8. CreditCHead=Shift=Shift No.=Number=0 9
  9. CreditCHead=Confirmed=Confirmed=Bool=(Y/N)
  10. CreditCHead=Date=Date=Date=
  11. CreditCHead=Time=Time=Time=
  12. CreditCHead=CreditCTransType=Transaction Type=Number=0 999
  13. CreditCHead=Amount=Amount=Decimal=(12,2)
  14. CreditCHead=Vat=VAT=Decimal=(12,2)
  15. CreditCHead=Track2=Track 2=String=(40)
  16. CreditCHead=CardNumber=Card No.=String=(24)
  17. CreditCHead=ManualInput=Manual Input=Bool=(Y/N)
  18. CreditCHead=ManualAuth=Manual Auth.=Bool=(Y/N)
  19. CreditCHead=AuthType=Authorization Type=Number=0 9
  20. CreditCHead=OnlineAuthReq=ONLINE Author.enf.=Bool=(Y/N)
  21. CreditCHead=ManualAuthAllow=Manual Auth. allowed=Bool=(Y/N)
  22. CreditCHead=IssuerNo=Issuer=Number=1 99999999
  23. CreditCHead=UsageNo=Usage No.=Number=0 99
  24. CreditCHead=AuthCode=Auth. Code=String=(9)
  25. CreditCHead=IDNumber=ID No.=String=(12)
  26. CreditCHead=ExpDate=Expiry date=Number=
  27. CreditCHead=CardNo=Card Type=Number=1 999
  28. CreditCHead=ClearingInstNo=Clearing Institute=Number=1 9999
  29. CreditCHead=CTransType=Card trans type=Number=0 9
  30. CreditCHead=OrgTerminalNo=Orig. Terminal=Number=1 999999
  31. CreditCHead=OrgTransNo=Orig. Transaction=Number=1 99999999
  32. CreditCHead=Message=Message=String=(80)
  33. CreditCHead=Track3=Track 3=String=(106)
  34. CreditCHead=VUNumber=VU Number=String=(15)
  35. CreditCHead=CashName=Terminal Name=String=(9)
  36. CreditCHead=VoidedReceiptNo=Void Receipt no.=Number=1 999999
  37. CreditCHead=Ready=NOTEXT=Number= (not in database)
  1. FFOrder=TerminalNo=Terminal=Number=1 999999
  2. FFOrder=FFOrderNo=NOTEXT=Number=1 99999999
  3. FFOrder=Urgent=NOTEXT=Bool=(Y/N)
  1. FFOrderPos=PositionNo=Position=Number=1 9999
  2. FFOrderPos=PlateNo=Position=Number=1 9999
  3. FFOrderPos=Text=Description=String=(20)
  1. FFProdPos=ItemNo=Item=Decimal=(14,0)
  2. FFProdPos=Text=Description=String=(20)
  3. FFProdPos=ProdLocationNo=Production Area
  4. =Number=0 999
  5. FFProdPos=Quantity=Quantity=Decimal=(11,3)
  6. FFProdPos=MinProdQuant=Quantity=Decimal=(11,3)
  1. $FinancePos=CompNo=Company=Number=1 9999
  2. $FinancePos=BranchNo=Branch=Number=1 9999
  3. $FinancePos=TerminalNo=Terminal=Number=1 999999
  4. $FinancePos=TransNo=Transaction=Number=1 99999999
  5. $FinancePos=PositionNo=Position=Number=1 9999
  6. FinancePos=ParentPosNo=Parent Pos.=Number=1 9999
  7. FinancePos=VoidMode=Void Mode=Number=0 9
  8. FinancePos=Amount=Amount=Decimal=(10,2)
  9. FinancePos=Text=Description=String=(20)
  10. FinancePos=FinanceMode=Finance no.=Number=1 9999
  11. FinancePos=FinanceClass=Finance type=Number=0 99
  12. FinancePos=IsCredit=Credit=Bool=(Y/N)
  13. FinancePos=VoucherNo=Voucher No.=Number=1 99999999
  14. FinancePos=RecordNo=Record no.=Decimal=(20,0)
  1. $GCHead=CompNo=Company=Number=1 9999
  2. $GCHead=BranchNo=Branch=Number=1 9999
  3. $GCHead=TermNo=Terminal=Number=1 999999
  4. $GCHead=TransNo=Transaction=Number=1 99999999
  5. GCHead=GuestNo=GC=Number=1 99999999
  6. GCHead=TableNo=Table No.=Number=1 9999
  7. GCHead=SeatNo=Seat=Number=1 99
  8. GCHead=ProfitCenterNo=Profit Center=Number=1 9999
  9. GCHead=CreationDate=Creation Date=Date=
  10. GCHead=CreationTime=Creation Time=Time=
  11. GCHead=ClosingDate=Closing Date=Date=
  12. GCHead=ClosingTime=Closing Time=Time=
  13. GCHead=ClosingTermNo=Closing Terminal=Number=1 999999
  14. GCHead=ClosingTransNo=Closing Transaction=Number=1 99999999
  15. GCHead=ActTermNo=Actual Terminal=Number=1 999999
  16. GCHead=OperatorNo=Operator=Number=1 99999999
  17. GCHead=CustomerNo=Customer No.=Number=1 999999
  18. GCHead=CustomerTypNo=Customer Type=Number=1 99
  19. GCHead=Balance=Balance=Decimal=(12,2)
  20. GCHead=PrePay=Pre Pay=Decimal=(12,2)
  21. GCHead=Tip=Tip=Decimal=(12,2)
  22. GCHead=Extra=Extra=Decimal=(12,2)
  23. GCHead=IsOpen=Open GC=Bool=(Y/N)
  24. GCHead=NumberOfGuests=Count Guests=Number=0 999
  25. GCHead=PrintPage=Printed Pages==
  26. GCHead=PrintLine=Print Lines==
  27. GCHead=PrintPos=Print Position=Number=1 9999
  28. GCHead=ActPos=Position=Number=1 9999
  29. GCHead=Training=Training=Bool=(Y/N)
  30. GCHead=InvoiceCopy=Invoice Copy=Bool=(Y/N)
  31. GCHead=GcBillNo=GC Invoice No.=Number=1 99999999
  32. GCHead=IdentText=Description=String=(20) (not in database)
  1. $GCPos=CompNo=Company=Number=1 9999
  2. $GCPos=BranchNo=Branch=Number=1 9999
  3. $GCPos=TermNo=Terminal=Number=1 999999
  4. $GCPos=TransNo=Transaction=Number=1 99999999
  5. $GCPos=PositionNo=Position=Number=1 9999
  6. GCPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. GCPos=ProfitCenterNo=Profit Center=Number=1 9999
  8. GCPos=TableNo=Table=Number=1 9999
  9. GCPos=Shift=Shift No.=Number=0 9
  10. GCPos=TimePeriodNo=Time Period=Number=1 99
  11. GCPos=ArticleNo=Item=Decimal=(14,0)
  12. GCPos=DeptNo=Department=Number=1 999999
  13. GCPos=FinanceMode=Finance No.=Number=1 9999
  14. GCPos=Price=Price=Decimal=(10,2)
  15. GCPos=OperatorNo=Operator=Number=1 99999999
  16. GCPos=PriceLevel=Level=Number=0 9
  17. GCPos=Category=Category=Number=0 99
  18. GCPos=Cancellation=Void=Bool=(Y/N)
  19. GCPos=TakeAway=Takeaway=Bool=(Y/N)
  20. GCPos=OnCall=On Call=Bool=(Y/N)
  21. GCPos=MenuPart=Menu Part=Bool=(Y/N)
  22. GCPos=TandemPart=Tandem Part=Bool=(Y/N)
  23. GCPos=Course=Course=Number=1 99
  24. GCPos=Time=Time=Time=
  25. GCPos=Date=Date=Date=
  26. GCPos=Quantity=Quantity=Decimal=(11,3)
  27. GCPos=ContentOvr=Content override=Number=0 9999
  28. GCPos=QuantityUnit=Quantity Unit=Number=1 999
  29. GCPos=Turnover=Turnover=Decimal=(12,2)
  30. GCPos=ServiceCharges=Service Charge=Decimal=(12,2)
  31. GCPos=VatNo=VAT=Number=1 99
  32. GCPos=PriceListNo=Price List=Number=1 9999
  33. GCPos=TransTypeText=Transaction Type=String=(20) (not in database)
  34. GCPos=ItemText=NOTEXT=String=(20) (not in database)
  35. GCPos=Cancelled=NOTEXT=Number= (not in database)
  36. GCPos=Discount=NOTEXT=Decimal=(12,2) (not in database)
  1. $GcSplitPos=CompNo=Company=Number=1 9999
  2. $GcSplitPos=BranchNo=Branch=Number=1 9999
  3. $GcSplitPos=TerminalNo=Terminal=Number=1 999999
  4. $GcSplitPos=TransNo=Transaction=Number=1 99999999
  5. $GcSplitPos=PositionNo=Position=Number=1 9999
  6. GcSplitPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. GcSplitPos=VoidMode=Void Mode=Number=0 9
  8. GcSplitPos=GcTermNo=GC Terminal=Number=1 999999
  9. GcSplitPos=GcTransNo=GC Transaction=Number=1 99999999
  10. GcSplitPos=GuestCheckPosNo=GC Position No.=Number=1 9999
  11. GcSplitPos=Quantity=Quantity=Decimal=(11,3)
  12. GcSplitPos=Amount=Amount=Decimal=(12,2)
  1. $GcTransHead=CompNo=Company=Number=1 9999
  2. $GcTransHead=BranchNo=Branch=Number=1 9999
  3. $GcTransHead=TerminalNo=Terminal=Number=1 999999
  4. $GcTransHead=TransNo=Transaction=Number=1 99999999
  5. GcTransHead=ReceiptNo=Receipt=Number=1 999999
  6. GcTransHead=ProfitCenterNo=Profit Center=Number=1 9999
  7. GcTransHead=OperatorNo=Operator=Number=1 99999999
  8. GcTransHead=Shift=Shift No.=Number=0 9
  9. GcTransHead=Confirmed=Confirmed=Bool=(Y/N)
  10. GcTransHead=Date=Date=Date=
  11. GcTransHead=Time=Time=Time=
  12. GcTransHead=GcTermNo=GC Terminal=Number=1 999999
  13. GcTransHead=GcTransNo=GC Transaction=Number=1 99999999
  14. GcTransHead=GuestNo=Guest No.=Number=1 99999999
  15. GcTransHead=TableNo=Table=Number=1 9999
  16. GcTransHead=SeatNo=Seat=Number=1 99
  17. GcTransHead=NumberOfGuests=Guest Count=Number=0 999
  18. GcTransHead=CustomerNo=Customer No.=Number=1 999999
  19. GcTransHead=CustomerTypNo=Customer Type=Number=1 99
  20. GcTransHead=GcTrans=GC Transaction=Number=0 9
  21. GcTransHead=Amount=Amount=Decimal=(12,2)
  22. GcTransHead=Training=Training=Bool=(Y/N)
  23. GcTransHead=InvoiceCopy=Invoice Copy=Bool=(Y/N)
  24. GcTransHead=FromOper=from Operator=Number=1 99999999
  25. GcTransHead=ToOper=to Operator=Number=1 99999999
  26. GcTransHead=GcBillNo=GC Invoice No.=Number=1 99999999
  1. $ItemPos=CompNo=Company=Number=1 9999
  2. $ItemPos=BranchNo=Branch=Number=1 9999
  3. $ItemPos=TerminalNo=Terminal=Number=1 999999
  4. $ItemPos=TransNo=Transaction=Number=1 99999999
  5. $ItemPos=PositionNo=Position=Number=1 9999
  6. ItemPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. ItemPos=VoidMode=Void Mode=Number=0 9
  8. ItemPos=ArticleNo=Item=Decimal=(14,0)
  9. ItemPos=DeptNo=Department=Number=1 999999
  10. ItemPos=Quantity=Quantity=Decimal=(11,3)
  11. ItemPos=QuantityUnit=Quantity Unit=Number=1 999
  12. ItemPos=ContentOvr=Content override=Number=0 9999
  13. ItemPos=PosVal=Value of Item=Decimal=(12,2)
  14. ItemPos=TruePrice=True Price=Decimal=(10,2)
  15. ItemPos=TargetPrice=Target Price=Decimal=(10,2)
  16. ItemPos=CostValue=Calc. Cost price=Decimal=(12,2)
  17. ItemPos=ServiceCharges=Service Charge=Decimal=(12,2)
  18. ItemPos=PriceLevel=Level=Number=0 9
  19. ItemPos=VatNo=VAT=Number=1 99
  20. ItemPos=Category=Category=Number=0 99
  21. ItemPos=TransTypeNo=Transaction Type=Number=1 9999
  22. ItemPos=RelatedGcPos=GC Position=Number=1 9999
  23. ItemPos=SalesmanNo=Salesman=Number=1 99999999
  24. ItemPos=PromotNo=Promotion=Number=1 9999
  25. ItemPos=PriceListNo=Price List=Number=1 9999
  26. ItemPos=DirectVoided=Direct Void=Bool=(Y/N)
  27. ItemPos=TakeAway=Takeaway=Bool=(Y/N)
  28. ItemPos=Extra=Extra=Bool=(Y/N)
  29. ItemPos=Deposit=Deposit=Bool=(Y/N)
  30. ItemPos=Scanned=Scanned=Bool=(Y/N)
  31. ItemPos=IsMenuPart=Is Menu Part=Bool=(Y/N)
  32. ItemPos=TandemPart=Tandem Part=Bool=(Y/N)
  33. ItemPos=OnCall=On Call=Bool=(Y/N)
  34. ItemPos=Course=Course=Number=1 99
  35. ItemPos=Factor1=Quantity=Decimal=(11,3) (not in database)
  36. ItemPos=Factor2=Quantity=Decimal=(11,3) (not in database)
  37. ItemPos=Factor3=Quantity=Decimal=(11,3) (not in database)
  38. ItemPos=NoPrint=NOTEXT=Bool=(Y/N) (not in database)
  39. ItemPos=PrintCourse=NOTEXT=Bool=(Y/N) (not in database)
  40. ItemPos=IsScaled=NOTEXT=Bool=(Y/N) (not in database)
  41. ItemPos=Package=NOTEXT=Bool=(Y/N) (not in database)
  42. ItemPos=NoAddTexts=NOTEXT=Number= (not in database)
  43. ItemPos=Discount=NOTEXT=Decimal=(12,2) (not in database)
  44. ItemPos=PrepStatus=NOTEXT=Number=0 9 (not in database)
  45. ItemPos=ProdStatus=NOTEXT=Number=0 9 (not in database)
  46. ItemPos=PlateNumber=NOTEXT=Number= (not in database)
  47. ItemPos=FFPosition=Position=Number=1 9999 (not in database)
  48. ItemPos=TransTypeText=Description=String=(20) (not in database)
  49. ItemPos=PriceChanged=NOTEXT=Bool=(Y/N) (not in database)
  50. ItemPos=VatAmount=NOTEXT=Decimal=(12,2) (not in database)
  1. $MoneyHead=CompNo=Company=Number=1 9999
  2. $MoneyHead=BranchNo=Branch=Number=1 9999
  3. $MoneyHead=TerminalNo=Terminal=Number=1 999999
  4. $MoneyHead=TransNo=Transaction=Number=1 99999999
  5. MoneyHead=ReceiptNo=Receipt=Number=1 999999
  6. MoneyHead=ProfitCenterNo=Profit Center=Number=1 9999
  7. MoneyHead=OperatorNo=Operator=Number=1 99999999
  8. MoneyHead=Shift=Shift No.=Number=0 9
  9. MoneyHead=Confirmed=Confirmed=Bool=(Y/N)
  10. MoneyHead=Date=Date=Date=
  11. MoneyHead=Time=Time=Time=
  12. MoneyHead=MoneyTrans=Money Transaction=Number=0 99
  13. MoneyHead=Amount=Amount=Decimal=(12,2)
  14. MoneyHead=DepOpNo=to Operator=Number=1 99999999
  15. MoneyHead=AccPerNo=Account No.=Number=0 99999998
  16. MoneyHead=RecText=NOTEXT=String=(20) (not in database)
  17. MoneyHead=CalcAmount=Calc. Amount=Decimal=(20,2) (not in database)
  18. MoneyHead=CalcAmountSum=Calc. Amount TL=Decimal=(12,2) (not in database)
  19. MoneyHead=DeclAmountSum=Decl. Amount TL=Decimal=(12,2) (not in database)
  20. MoneyHead=IsBackOffice=from Admin. Term.=Bool=(Y/N)
  21. MoneyHead=IncOpAccount=New Account No.=Bool=(Y/N)
  1. $MoneyPos=CompNo=Company=Number=1 9999
  2. $MoneyPos=BranchNo=Branch=Number=1 9999
  3. $MoneyPos=TerminalNo=Terminal=Number=1 999999
  4. $MoneyPos=TransNo=Transaction=Number=1 99999999
  5. $MoneyPos=PositionNo=Position=Number=1 9999
  6. MoneyPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. MoneyPos=VoidMode=Void Mode=Number=0 9
  8. MoneyPos=Amount=Amount=Decimal=(12,2)
  9. MoneyPos=PayMode=Payment Type=Number=1 999
  10. MoneyPos=RecordTrack=Record track=Bool=(Y/N)
  11. MoneyPos=AmountForCurr=Amount Foreign Currency=Decimal=(12,2)
  12. MoneyPos=Quantity=Quantity=Decimal=(11,3)
  13. MoneyPos=RecordNo1=Record Number 1=Decimal=(20,0)
  14. MoneyPos=RecordNo2=Record Number 2=Decimal=(20,0)
  15. MoneyPos=RecordNo3=Record Number 3=Decimal=(20,0)
  16. MoneyPos=RecordNo4=Record Number 4=Decimal=(20,0)
  17. MoneyPos=CredCardTrans=Credit Transaction=Number=1 99999999
  18. MoneyPos=RecText=NOTEXT=String=(20) (not in database)
  19. MoneyPos=PaymentClass=NOTEXT=Number= (not in database)
  20. MoneyPos=CurrSymbol=NOTEXT=String=(20) (not in database)
  21. MoneyPos=FcUnit=NOTEXT=Decimal=(20,2) (not in database)
  22. MoneyPos=Rate=NOTEXT=Decimal=(20,2) (not in database)
  23. MoneyPos=CalcAmount=Calc. Amount Paym.Type=Decimal=(12,2) (not in database)
  24. MoneyPos=DeclAmount=Decl. Amount Paym.Type=Decimal=(12,2) (not in database)
  1. $OpStateHead=CompNo=Company=Number=1 9999
  2. $OpStateHead=BranchNo=Branch=Number=1 9999
  3. $OpStateHead=TerminalNo=Terminal=Number=1 999999
  4. $OpStateHead=TransNo=Transaction=Number=1 99999999
  5. OpStateHead=ReceiptNo=Receipt=Number=1 999999
  6. OpStateHead=ProfitCenterNo=Profit Center=Number=1 9999
  7. OpStateHead=OperatorNo=Operator=Number=1 99999999
  8. OpStateHead=Shift=Shift No.=Number=0 9
  9. OpStateHead=Confirmed=Confirmed=Bool=(Y/N)
  10. OpStateHead=Date=Date=Date=
  11. OpStateHead=Time=Time=Time=
  12. OpStateHead=OperatorState=Operator State=Number=0 99
  13. OpStateHead=CashUpNo=Cash Payment Type=Number=1 99999999
  14. OpStateHead=Receipt=Receipt=Bool=(Y/N)
  15. OpStateHead=NewSecretNumber=New Secret Number=Number=
  16. OpStateHead=WaitingTime=Waiting Time=Number=
  17. OpStateHead=Comes=Start Working=Time=
  18. OpStateHead=Goes=End Working=Time=
  1. $PayPos=CompNo=Company=Number=1 9999
  2. $PayPos=BranchNo=Branch=Number=1 9999
  3. $PayPos=TerminalNo=Terminal=Number=1 999999
  4. $PayPos=TransNo=Transaction=Number=1 99999999
  5. $PayPos=PositionNo=Position=Number=1 9999
  6. PayPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. PayPos=VoidMode=Void Mode=Number=0 9
  8. PayPos=Amount=Amount=Decimal=(10,2)
  9. PayPos=AmountForCurr=Amount Foreign Curr.=Decimal=(10,2)
  10. PayPos=DiffAmount=Difference=Decimal=(10,2)
  11. PayPos=Cancellation=Void=Bool=(Y/N)
  12. PayPos=PayMode=Payment Type=Number=1 999
  13. PayPos=Quantity=Quantity=Decimal=(11,3)
  14. PayPos=Change=Change=Bool=(Y/N)
  15. PayPos=RecordNo1=Record Number 1=Decimal=(20,0)
  16. PayPos=RecordNo2=Record Number 2=Decimal=(20,0)
  17. PayPos=RecordNo3=Record Number 3=Decimal=(20,0)
  18. PayPos=RecordNo4=Record Number 4=Decimal=(20,0)
  19. PayPos=CredCardTrans=Credit Transaction=Number=1 99999999
  20. PayPos=RecText=Text=String=(20) (not in database)
  21. PayPos=PaymentClass=Category=Number= (not in database)
  22. PayPos=CurrSymbol=Currency Symbol=String=(20) (not in database)
  23. PayPos=FcUnit=Unit=Decimal=(20,2) (not in database)
  24. PayPos=Rate=Exchange Rate=Decimal=(20,2) (not in database)
  25. PayPos=HotCredText=NOTEXT=String=(20) (not in database)
  1. $Position=CompNo=Company=Number=1 9999
  2. $Position=BranchNo=Branch=Number=1 9999
  3. $Position=TerminalNo=Terminal=Number=1 999999
  4. $Position=TransNo=Transaction=Number=1 99999999
  5. $Position=PositionNo=Position=Number=1 9999
  6. Position=ParentPosNo=Parent Pos.=Number=1 9999
  7. Position=VoidMode=Void Mode=Number=0 9
  1. $RecHead=CompNo=Company=Number=1 9999
  2. $RecHead=BranchNo=Branch=Number=1 9999
  3. $RecHead=TerminalNo=Terminal=Number=1 999999
  4. $RecHead=TransNo=Transaction=Number=1 99999999
  5. RecHead=ReceiptNo=Receipt=Number=1 999999
  6. RecHead=ProfitCenterNo=Profit Center=Number=1 9999
  7. RecHead=OperatorNo=Operator=Number=1 99999999
  8. RecHead=Shift=Shift No.=Number=0 9
  9. RecHead=Confirmed=Confirmed=Bool=(Y/N)
  10. RecHead=Date=Date=Date=
  11. RecHead=Time=Time=Time=
  12. RecHead=GcTermNo=GC Terminal=Number=1 999999
  13. RecHead=GcTransNo=GC Transaction=Number=1 99999999
  14. RecHead=Turnover=Turnover=Decimal=(12,2)
  15. RecHead=LoyaltyPoints=Loyalty Points=Decimal=(5,0)
  16. RecHead=LoyaltyPointsEarned=Loyalty Points earned=Decimal=(5,0)
  17. RecHead=LoyaltyPointsCashIn=Loyalty Points cash in=Decimal=(5,0)
  18. RecHead=PriceLevel=Price level=Number=0 9
  19. RecHead=Category=Category=Number=0 99
  20. RecHead=TransTypeNo=Transaction Type=Number=1 9999
  21. RecHead=RecMode=Receipt Mode=Number=0 99
  22. RecHead=VoidReceipt=Void Receipt=Bool=(Y/N)
  23. RecHead=TakeAway=Takeaway=Bool=(Y/N)
  24. RecHead=Deposit=Deposit=Bool=(Y/N)
  25. RecHead=Training=Training=Bool=(Y/N)
  26. RecHead=InvoiceCopy=Invoice Copy=Bool=(Y/N)
  27. RecHead=NetReceipt=Net Receipt=Bool=(Y/N)
  28. RecHead=OnCall=On Call=Bool=(Y/N)
  29. RecHead=InputDate=Input Date=Date=
  30. RecHead=WaitingTime=Waiting Time=Number=
  31. RecHead=SellingTime=Selling Time=Number=
  32. RecHead=TimePeriodNo=Time Period=Number=1 99
  33. RecHead=CustomerNo=Customer No.=Number=1 999999
  34. RecHead=CustomerTypNo=Customer Type=Number=1 99
  35. RecHead=CustomerCnt=Cust. Count==
  36. RecHead=CustSpec=Special Customer=Number=1 999999
  37. RecHead=SubSubTotal=NOTEXT=Decimal=(12,2) (not in database)
  38. RecHead=LastCustomerCnt=NOTEXT (not in database)==
  39. RecHead=CustRetoure=NOTEXT=Bool=(Y/N) (not in database)
  40. RecHead=PrintMode=NOTEXT=Number=0 99 (not in database)
  41. RecHead=VatPrint=NOTEXT=Bool=(Y/N) (not in database)
  42. RecHead=IsJouOn=NOTEXT=Bool=(Y/N) (not in database)
  43. RecHead=IsRecOn=NOTEXT=Bool=(Y/N) (not in database)
  44. RecHead=LastSTPrinted=NOTEXT=Bool=(Y/N) (not in database)
  45. RecHead=TransTypeText=NOTEXT=String=(20) (not in database)
  46. RecHead=TurnoverRd=NOTEXT=Decimal=(12,2) (not in database)
  47. RecHead=AmountLeadCurrency=NOTEXT=Decimal=(12,2) (not in database)
  1. $TextPos=CompNo=Company=Number=1 9999
  2. $TextPos=BranchNo=Branch=Number=1 9999
  3. $TextPos=TerminalNo=Terminal=Number=1 999999
  4. $TextPos=TransNo=Transaction=Number=1 99999999
  5. $TextPos=PositionNo=Position=Number=1 9999
  6. TextPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. TextPos=VoidMode=Void Mode=Number=0 9
  8. TextPos=RelatedPos=Parent Pos.=Number=1 9999
  9. TextPos=MultFact=Mul.Factor=Number=0 99999999
  10. TextPos=ReceiptText=Description=String=(20)
  1. $TransHead=CompNo=Company=Number=1 9999
  2. $TransHead=BranchNo=Branch=Number=1 9999
  3. $TransHead=TerminalNo=Terminal=Number=1 999999
  4. $TransHead=TransNo=Transaction=Number=1 99999999
  5. TransHead=ReceiptNo=Receipt=Number=1 999999
  6. TransHead=ProfitCenterNo=Profit Center=Number=1 9999
  7. TransHead=OperatorNo=Operator=Number=1 99999999
  8. TransHead=Shift=Shift No.=Number=0 9
  9. TransHead=Confirmed=Confirmed=Bool=(Y/N)
  10. TransHead=Date=Date=Date=
  11. TransHead=Time=Time=Time=
  1. $UpDownPos=CompNo=Company=Number=1 9999
  2. $UpDownPos=BranchNo=Branch=Number=1 9999
  3. $UpDownPos=TerminalNo=Terminal=Number=1 999999
  4. $UpDownPos=TransNo=Transaction=Number=1 99999999
  5. $UpDownPos=PositionNo=Position=Number=1 9999
  6. UpDownPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. UpDownPos=VoidMode=Void Mode=Number=0 9
  8. UpDownPos=UpDownNo=Markup/Markdown no.=Number=1 9999
  9. UpDownPos=PromotNo=Promotion=Number=1 9999
  10. UpDownPos=Text=Description=String=(20)
  11. UpDownPos=UpDownAmount=Value=Decimal=(12,2)
  12. UpDownPos=NewPrice=New Price=Decimal=(10,2)
  13. UpDownPos=UpDownRate=Rate=Decimal=(5,2)
  14. UpDownPos=Percental=Per cent=Bool=(Y/N)
  15. UpDownPos=Surcharge=Surcharge=Bool=(Y/N)
  16. UpDownPos=StRelated=ST-related=Bool=(Y/N)
  17. UpDownPos=VatNo=VAT=Number=1 99
  18. UpDownPos=Totalizer=Totalizer=Number=0 99
  19. UpDownPos=Voucher=Voucher=Bool=(Y/N)
  1. $VATPos=CompNo=Company=Number=1 9999
  2. $VATPos=BranchNo=Branch=Number=1 9999
  3. $VATPos=TerminalNo=Terminal=Number=1 999999
  4. $VATPos=TransNo=Transaction=Number=1 99999999
  5. $VATPos=PositionNo=Position=Number=1 9999
  6. VATPos=ParentPosNo=Parent Pos.=Number=1 9999
  7. VATPos=VoidMode=Void Mode=Number=0 9
  8. VATPos=VatNo=VAT Number=Number=1 99
  9. VATPos=VatRate=VAT Rate=Decimal=(5,2)
  10. VATPos=GrossAmount=Gross Amount=Decimal=(12,2)
  11. VATPos=VatAmount=VAT Amount=Decimal=(12,2)
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany