Database Tables "Customer" (cust)

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

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. $CustDelPos=CompNo=Company=Number=1 9999
  2. $CustDelPos=BranchNo=Branch=Number=1 9999
  3. $CustDelPos=CustDelivNo=Delivery Number=Number=1 99999999
  4. $CustDelPos=PosNo=Position No.=Number=1 9999
  5. CustDelPos=ArticleNo=Item=Decimal=(14,0)
  6. CustDelPos=DeptNo=Department=Number=1 999999
  7. CustDelPos=VatNo=VAT=Number=1 99
  8. CustDelPos=Text=Remark=String=(32)
  9. CustDelPos=Price=Price=Decimal=(10,2)
  10. CustDelPos=Quantity=Quantity=Decimal=(11,3)
  11. CustDelPos=Turnover=Amount=Decimal=(12,2)
  12. CustDelPos=Discount=Discount=Decimal=(12,2)
  13. CustDelPos=OriginalPos=Original Pos.no.=Number=1 9999
  1. $CustDelivery=CompNo=Company=Number=1 9999
  2. $CustDelivery=BranchNo=Branch=Number=1 9999
  3. $CustDelivery=CustDelivNo=Delivery Number=Number=1 99999999
  4. CustDelivery=CustomerNo=Customer No.=Number=1 999999
  5. CustDelivery=TerminalNo=Terminal=Number=1 999999
  6. CustDelivery=TransNo=Transaction=Number=1 99999999
  7. CustDelivery=GcTransNo=GC Transaction=Number=1 99999999
  8. CustDelivery=GcTermNo=GC Terminal=Number=1 999999
  9. CustDelivery=OperatorNo=Operator=Number=1 99999999
  10. CustDelivery=CustInvoiceNo=Invoice No.=Number=1 99999999
  11. CustDelivery=Text=Delivery Name=String=(32)
  12. CustDelivery=Total=Total=Decimal=(12,2)
  13. CustDelivery=PrePay=Prepay=Decimal=(12,2)
  14. CustDelivery=DeliveryDate=Delivery Date=Date=
  15. CustDelivery=DeliveryTime=Delivery Time=Time=
  16. CustDelivery=CustPayCondNo=Payment Condition=Number=1 9999
  17. CustDelivery=VoidDelivery=Void=Bool=(Y/N)
  18. CustDelivery=ReturnDelivery=Returns=Bool=(Y/N)
  19. CustDelivery=Printed=Printed=Bool=(Y/N)
  20. CustDelivery=DateSent=Date of Print=Date=
  1. $CustInvPos=CompNo=Company=Number=1 9999
  2. $CustInvPos=BranchNo=Branch=Number=1 9999
  3. $CustInvPos=CustInvoiceNo=Invoice No.=Number=1 99999999
  4. $CustInvPos=PosNo=Position No.=Number=1 9999
  5. CustInvPos=ArticleNo=Item=Decimal=(14,0)
  6. CustInvPos=DeptNo=Department=Number=1 999999
  7. CustInvPos=VatNo=VAT=Number=1 99
  8. CustInvPos=Text=Remark=String=(32)
  9. CustInvPos=Price=Price=Decimal=(10,2)
  10. CustInvPos=Quantity=Quantity=Decimal=(11,3)
  11. CustInvPos=Turnover=Amount=Decimal=(12,2)
  12. CustInvPos=Discount=Discount=Decimal=(12,2)
  13. CustInvPos=ShoppingDate=Purchase Date=Date=
  14. CustInvPos=ShoppingTime=Purchase Time=Time=
  15. CustInvPos=CustDelivNo=Delivery Number=Number=1 99999999
  16. CustInvPos=CustDelivPos=Position No.=Number=1 9999
  1. $CustInvoice=CompNo=Company=Number=1 9999
  2. $CustInvoice=BranchNo=Branch=Number=1 9999
  3. $CustInvoice=CustInvoiceNo=Invoice No.=Number=1 99999999
  4. CustInvoice=CustomerNo=Customer No.=Number=1 999999
  5. CustInvoice=OperatorNo=Operator=Number=1 99999999
  6. CustInvoice=Text=Remark=String=(32)
  7. CustInvoice=InvoiceTyp=Invoice Type=Number=
  8. CustInvoice=Total=Total=Decimal=(12,2)
  9. CustInvoice=PrePay=Prepay=Decimal=(12,2)
  10. CustInvoice=InvoiceDate=Invoice Date=Date=
  11. CustInvoice=InvoiceTime=Invoice Time=Time=
  12. CustInvoice=CustPayCondNo=Payment Condition=Number=1 9999
  13. CustInvoice=VoidInvoice=Void Invoice=Bool=(Y/N)
  14. CustInvoice=ReturnInvoice=Return Invoice=Bool=(Y/N)
  15. CustInvoice=Printed=Printed=Bool=(Y/N)
  16. CustInvoice=DateSent=Date sent=Date=
  1. $CustPayCond=CompNo=Company=Number=1 9999
  2. $CustPayCond=CustPayCondNo=Payment Condition=Number=1 9999
  3. CustPayCond=Text=Descriptor=String=(32)
  4. CustPayCond=InvoiceLine1=Invoice Line 1=String=(60)
  5. CustPayCond=InvoiceLine2= Invoice Line 2=String=(60)
  6. CustPayCond=InvoiceLine3= Invoice Line 3=String=(60)
  7. CustPayCond=NameOf4GlFct=Function Name=String=(20)
  8. CustPayCond=InvoicePeriod=Invoice Creation Periods=Number=1 3
  9. CustPayCond=MaxOverdueDay=Max. overdue days=Number=0 999
  10. CustPayCond=DaysToPayable=Days to Payment=Number=0 999
  11. CustPayCond=DaysToCashDiscount=Days to cash discount=Number=0 999
  12. CustPayCond=CashDiscPercent=% Sconto=Decimal=(5,2)
  13. CustPayCond=OverDueInterest=Interest payable=Decimal=(5,2)
  14. CustPayCond=DaysPromptNote1=Days to 1st demand note =Number=0 999
  15. CustPayCond=FeePromptNote1=Fee Type 1st demand note=Number=
  16. CustPayCond=DaysPromptNote2=Days to 2nd demand note=Number=0 999
  17. CustPayCond=FeePromptNote2=Fee Type 2nd demand note=Number=
  18. CustPayCond=DaysPromptNote3=Days to 3rd demand note=Number=0 999
  19. CustPayCond=FeePromptNote3=Fee type 3rd demand note=Number=
  20. CustPayCond=MonthlyDay=Day of Month=Number=0 28
  21. CustPayCond=FirstMonthlyDay=1st day of Month=Number=0 28
  22. CustPayCond=SecondMonthlyDay=2nd day of Month=Number=0 28
  1. $CustPayment=CompNo=Company=Number=1 9999
  2. $CustPayment=BranchNo=Branch=Number=1 9999
  3. $CustPayment=CustPaymentNo=Payment Number=Number=1 99999999
  4. CustPayment=CustomerNo=Customer No.=Number=1 999999
  5. CustPayment=CustInvoiceNo=Invoice No.=Number=1 99999999
  6. CustPayment=OperatorNo=Operator=Number=1 99999999
  7. CustPayment=TerminalNo=Terminal=Number=1 999999
  8. CustPayment=TransNo=Transaction=Number=1 99999999
  9. CustPayment=Text=Remark=String=(32)
  10. CustPayment=PaymentDate=Payment Date=Datum=
  11. CustPayment=Total=Total=Decimal=(12,2)
  12. CustPayment=CashDiscount=Sconto=Decimal=(12,2)
  1. $CustPrice=CompNo=Company=Number=1 9999
  2. $CustPrice=CustomerNo=Customer No.=Number=1 999999
  3. $CustPrice=ItemNo=Item=Decimal=(14,0)
  4. CustPrice=Price=Price=Decimal=(10,2)
  1. $CustState=CompNo=Company=Number=1 9999
  2. $CustState=CustomerNo=Customer No.=Number=1 999999
  3. CustState=Balance=Balance=Decimal=(12,2)
  4. CustState=PrePayment=Pre Payment=Decimal=(12,2)
  5. CustState=GrandTotal=Grandtotal=Decimal=(12,2)
  6. CustState=Securities=Securities=Decimal=(12,2)
  7. CustState=BonusTotal=Bonus Total=Decimal=(12,2)
  8. CustState=StartDateForBonus=Date for start bonus=Date=
  9. CustState=LastPurchase=Last Purchase=Date=
  10. CustState=InvoiceOpen=Invoice open=Bool=(Y/N)
  11. CustState=PointsBalance=Points balance=Decimal=(5,0)
  12. CustState=PointsToDate=Points to date=Decimal=(5,0)
  13. CustState=LastCashInDate=Last cash in date=Datum=
  1. $Customer=CompNo=Company=Number=1 9999
  2. $Customer=CustomerNo=Customer No..=Number=1 999999
  3. Customer=Name=Name=String=(32)
  4. Customer=MatchCode=Match Code=String=(12)
  5. Customer=Adr1=Address 1=String=(32)
  6. Customer=Adr2=Address 2=String=(32)
  7. Customer=Adr3=Address 3=String=(32)
  8. Customer=Contact=Contact=String=(20)
  9. Customer=Telefon=Phone=String=(16)
  10. Customer=Fax=Fax=String=(16)
  11. Customer=Modem=Modem=String=(16)
  12. Customer=EMail=eMail=String=(32)
  13. Customer=CardNo1=Credit Card No.1=String=(20)
  14. Customer=CardNo2= Credit Card No.2=String=(20)
  15. Customer=BankNo=Bank Number=String=(10)
  16. Customer=AccountNo=Account Number=String=(16)
  17. Customer=BankName=Bank Account=String=(20)
  18. Customer=Creditworthy=Creditworthy=Bool=(Y/N)
  19. Customer=CreditLimit=Credit Limit=Decimal=(12,2)
  20. Customer=UpDownTypeNo=Discount Type No.=Number=1 9999
  21. Customer=PriceLevel=Price Level=Number=0 9
  22. Customer=Text=Addition Text=String=(32)
  23. Customer=NetPrice=with net price=Bool=(Y/N)
  24. Customer=PosDelivery=no VAT receipt=Bool=(Y/N)
  25. Customer=PrintForm=Print Form=Bool=(Y/N)
  26. Customer=SelectCriteria1=Selection 1=Number=0 99
  27. Customer=SelectCriteria2= Selection 2=Number=0 99
  28. Customer=SelectCriteria3= Selection 3=Number=0 99
  29. Customer=PurchaseByArticle=Record purchase by item=Bool=(Y/N)
  30. Customer=CustomerTypNo=Customer Type=Number=1 99
  31. Customer=CustPayCondNo=Payment Condition=Number=1 9999
  32. Customer=BranchNo=Branch=Number=1 9999
  33. Customer=CustLoyTypeNo=Loyalty Bonus=Number=0 3
  34. Customer=LoyaltyTableNo=Loyalty Table=Number=1 9999
  35. Customer=Locked=Locked=Bool=(Y/N)
  36. Customer=LimitExceedSpv=Ex. limit spv.key=Bool=(Y/N)
  1. $CustomerGrp=CompNo=Company=Number=1 9999
  2. $CustomerGrp=CustomerGrpNo=Customer Group=Number=1 9999
  3. CustomerGrp=Name=Name=String=(32)
  1. $CustomerTyp=CompNo=Company=Number=1 9999
  2. $CustomerTyp=CustomerTypNo=Customer type=Number=1 99
  3. CustomerTyp=Name=Name=String=(32)
  4. CustomerTyp=CustomerGrpNo=Customer Group=Number=1 9999
  5. CustomerTyp=CustSpecify=Cust specifying=Number=
  6. CustomerTyp=CustCnt=Customer count=Bool=(Y/N)
  7. CustomerTyp=UpDownTypeNo=Discount Type No.=Number=1 9999
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany