Database Tables "Supplier" (supp)

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

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. $Agreements=CompNo=Company=Number=1 9999
  2. $Agreements=SupplierNo=Supplier No.=Number=1 999999
  3. $Agreements=LANNo=Supplier Item No.=Decimal=(14,0)
  4. $Agreements=AgreementNo=Agree No.=Number=1 34463
  5. Agreements=DiscPercent=Disc as Perc.=Decimal=(10,2)
  6. Agreements=DiscValue=Val.Discount=Decimal=(13,3)
  7. Agreements=FromDate=Valid from=Date=
  8. Agreements=ToDate=Valid until=Date=
  9. Agreements=BasedOnNo=Basis=Number=1 34463
  10. Agreements=CalcValue=Calculated Value=Decimal=(13,3)
  1. $AssortLine=CompNo=Company=Number=1 9999
  2. $AssortLine=AssortmentNo=Assortment No.=Number=1 9999
  3. $AssortLine=PositionNo=Position=Number=1 9999
  4. AssortLine=ItemNo=Item=Decimal=(14,0)
  5. AssortLine=Quantity=Quantity=Decimal=(11,3)
  6. AssortLine=QuantityUnit=Unit=Number=1 999
  7. AssortLine=QuUnitTxt=Unit=String=(8)
  1. $Assortment=CompNo=Company=Number=1 9999
  2. $Assortment=AssortmentNo=Assortment No.=Number=1 9999
  3. Assortment=Name=Description=String=(32)
  4. Assortment=SupplierNo=Supplier No.=Number=1 999999
  1. $Delivery=CompNo=Company=Number=1 9999
  2. $Delivery=BranchNo=Branch=Number=1 9999
  3. $Delivery=DeliveryNo=Internal Delivery Note No.=Number=1 99999999
  4. Delivery=SupplierNo=Supplier No.=Number=1 999999
  5. Delivery=SupplDeliNo=Delivery Note No.Supplier=String=(8)
  6. Delivery=OrderNo=Order No.=Number=1 99999999
  7. Delivery=ProFormaNo=Pro forma No.=Number=1 99999999
  8. Delivery=OperatorNo=Operator=Number=1 99999999
  9. Delivery=Specification=Free Text=String=(40)
  10. Delivery=ToBranchNo=To Branch=Number=1 9999
  11. Delivery=ToStockNo=Stock No.=Number=1 9999
  12. Delivery=DelivDay=Delivered Date=Date=
  13. Delivery=DelivClock=Delivered Time=Time=
  14. Delivery=DelivValue=Total Value of Delivery=Decimal=(11,3)
  15. Delivery=PaymentNo=Payment Type=Number=1 999
  16. Delivery=FreightCost=Freight Cost=Decimal=(11,3)
  17. Delivery=PickUpCost=Pick up Costs=Decimal=(11,3)
  18. Delivery=CashDiscount=Cash Discount=Decimal=(5,2)
  19. Delivery=DiscPercQuan=Discount Percent/Quantity=Decimal=(5,2)
  20. Delivery=DiscPercValue=Discount Percent/Value=Decimal=(5,2)
  21. Delivery=EditFreightC=Edit Shipping Cost=Bool=(Y/N)
  22. Delivery=EditDiscPVal=Edit Discount=Bool=(Y/N)
  23. Delivery=UpdatePrices=Update new Prices=Bool=(Y/N)
  24. Delivery=CloseOrd=Close order=Bool=(Y/N)
  25. Delivery=Confirmed=Confirmed=Bool=(Y/N)
  1. DelivPos=ItemNo=Item=Decimal=(14,0)
  2. DelivPos=LANNo=Supplier Item No.=Decimal=(14,0)
  3. DelivPos=Specification=Free Text=String=(40)
  4. DelivPos=RecItemNo=Supplier Item No.=Decimal=(14,0)
  5. DelivPos=SupplierNo=Supplier No.=Number=1 999999
  6. DelivPos=DiscPercQuan=Perc.Discount/Quantity=Decimal=(13,3)
  7. DelivPos=DiscPercValue=Perc.Discount/Value=Decimal=(13,3)
  8. DelivPos=DiscValQuan=Val.Discount/Quantity=Decimal=(13,3)
  9. DelivPos=DiscValValue=Val.Discount/Value=Decimal=(13,3)
  10. DelivPos=DiscNatQuan=Disc.in kind/Quantity=Decimal=(13,3)
  11. DelivPos=DiscNatVal=Disc.in kind/Value=Decimal=(13,3)
  12. DelivPos=Quantity=Quantity=Decimal=(13,3)
  13. DelivPos=PriceOrUnit=Price per Order Unit=Decimal=(11,3)
  14. DelivPos=PosValue=Value=Decimal=(11,3)
  15. DelivPos=OrderUnit=Order Unit=Number=1 999
  16. DelivPos=FixCost=Fixed Costs=Decimal=(11,3)
  17. DelivPos=VarCost=Variable Costs=Decimal=(11,3)
  18. DelivPos=CurrencySymbol=NOTEXT=String=(4)
  19. DelivPos=QuUnitTxt=Unit=String=(8)
  20. $DelivPos=CompNo=Company=Number=1 9999
  21. $DelivPos=BranchNo=Branch=Number=1 9999
  22. $DelivPos=DeliveryNo=Delivery Note No.=Number=1 99999999
  23. $DelivPos=PosNo=Position No.=Number=1 9999
  24. DelivPos=OrderQuan=Quantity=Decimal=(13,3)
  25. DelivPos=OrderValUnit=Price per Order Unit=Decimal=(11,3)
  26. DelivPos=IndiceTheoret=Indice theoretic=Decimal=(5,2)
  27. DelivPos=ContPercValue=Percentage Value=Decimal=(5,2)
  28. DelivPos=ReceivedAdjust=Adjust received Value=Decimal=(11,3)
  1. $DiscNatQuan=CompNo=Company=Number=1 9999
  2. $DiscNatQuan=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscNatQuan=DiscTabNo=Discount Table No.=Number=1 99
  4. $DiscNatQuan=DiscountNo=Discount No.=Number=1 5
  5. DiscNatQuan=DiscNatural=Quantity=Decimal=(11,0)
  6. DiscNatQuan=DiscNatQuant=Discount Nat./Quantity=Decimal=(5,2)
  1. $DiscNatQuaT=CompNo=Company=Number=1 9999
  2. $DiscNatQuaT=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscNatQuaT=DiscTabNo=Discount Table=Number=1 99
  4. DiscNatQuaT=Text=Description=String=(20)
  1. $DiscNatVal=CompNo=Company=Number=1 9999
  2. $DiscNatVal=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscNatVal=DiscTabNo=Discount Table No.=Number=1 99
  4. $DiscNatVal=DiscountNo=Discount No.=Number=1 5
  5. DiscNatVal=DiscNatural=Quantity=Decimal=(11,0)
  6. DiscNatVal=DiscNatValue=Discount in kind from Value up=Decimal=(13,3)
  1. $DiscNatValT=CompNo=Company=Number=1 9999
  2. $DiscNatValT=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscNatValT=DiscTabNo=Discount Table=Number=1 99
  4. DiscNatValT=Text=Description=String=(20)
  1. $DiscPercQuan=CompNo=Company=Number=1 9999
  2. $DiscPercQuan=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscPercQuan=DiscTabNo=Discount Table No.=Number=1 99
  4. $DiscPercQuan=DiscountNo=Discount No.=Number=1 5
  5. DiscPercQuan=DiscPercent=Disc. percent=Decimal=(5,2)
  6. DiscPercQuan=DiscPercQuant=Discount p.c. from qty. up=Decimal=(11,0)
  1. $DiscPercVal=CompNo=Company=Number=1 9999
  2. $DiscPercVal=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscPercVal=DiscTabNo=Discount Table No.=Number=1 99
  4. $DiscPercVal=DiscountNo=Discount No.=Number=1 5
  5. DiscPercVal=DiscPercent=Disc. percent=Decimal=(5,2)
  6. DiscPercVal=DiscPercValue=Discount p.c. from value up=Decimal=(13,3)
  1. $DiscPerQuaT=CompNo=Company=Number=1 9999
  2. $DiscPerQuaT=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscPerQuaT=DiscTabNo=Discount Table=Number=1 99
  4. DiscPerQuaT=Text=Description=String=(20)
  1. $DiscPerValT=CompNo=Company=Number=1 9999
  2. $DiscPerValT=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscPerValT=DiscTabNo=Discount Table=Number=1 99
  4. DiscPerValT=Text=Description=String=(20)
  1. $DiscValQuan=CompNo=Company=Number=1 9999
  2. $DiscValQuan=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscValQuan=DiscTabNo=Discount Table No.=Number=1 99
  4. $DiscValQuan=DiscountNo=Discount No.=Number=1 5
  5. DiscValQuan=DiscValue=Discount Value=Decimal=(13,3)
  6. DiscValQuan=DiscValueQuan=Discount Value from qty.up=Decimal=(11,0)
  1. $DiscValQuaT=CompNo=Company=Number=1 9999
  2. $DiscValQuaT=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscValQuaT=DiscTabNo=Discount Table=Number=1 99
  4. DiscValQuaT=Text=Description=String=(20)
  1. $DiscValVal=CompNo=Company=Number=1 9999
  2. $DiscValVal=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscValVal=DiscTabNo=Discount Table No.=Number=1 99
  4. $DiscValVal=DiscountNo=Discount No.=Number=1 5
  5. DiscValVal=DiscValue=Discount Value=Decimal=(13,3)
  6. DiscValVal=DiscValueVal=Discount Value from value up=Decimal=(13,3)
  1. $DiscValValT=CompNo=Company=Number=1 9999
  2. $DiscValValT=SupplierNo=Supplier No.=Number=1 999999
  3. $DiscValValT=DiscTabNo=Discount Table=Number=1 99
  4. DiscValValT=Text=Description=String=(20)
  1. OrderPos=ItemNo=Item=Decimal=(14,0)
  2. OrderPos=LANNo=Supplier Item No.=Decimal=(14,0)
  3. OrderPos=Specification=Free Text=String=(40)
  4. OrderPos=RecItemNo=Supplier Item No.=Decimal=(14,0)
  5. OrderPos=SupplierNo=Supplier No.=Number=1 999999
  6. OrderPos=DiscPercQuan=Perc.Discount/Quantity=Decimal=(13,3)
  7. OrderPos=DiscPercValue=Perc.Discount/Value=Decimal=(13,3)
  8. OrderPos=DiscValQuan=Val.Discount/Quantity=Decimal=(13,3)
  9. OrderPos=DiscValValue=Val.Discount/Value=Decimal=(13,3)
  10. OrderPos=DiscNatQuan=Disc.in kind/Quantity=Decimal=(13,3)
  11. OrderPos=DiscNatVal=Disc.in kind/Value=Decimal=(13,3)
  12. OrderPos=Quantity=Quantity=Decimal=(13,3)
  13. OrderPos=PriceOrUnit=Price per Order Unit=Decimal=(11,3)
  14. OrderPos=PosValue=Value=Decimal=(11,3)
  15. OrderPos=OrderUnit=Order Unit=Number=1 999
  16. OrderPos=FixCost=Fixed Costs=Decimal=(11,3)
  17. OrderPos=VarCost=Variable Costs=Decimal=(11,3)
  18. OrderPos=CurrencySymbol=NOTEXT=String=(4)
  19. OrderPos=QuUnitTxt=Unit=String=(8)
  20. $OrderPos=CompNo=Company=Number=1 9999
  21. $OrderPos=BranchNo=Branch=Number=1 9999
  22. $OrderPos=OrderNo=Order Note No.=Number=1 99999999
  23. $OrderPos=PosNo=Position No.=Number=1 9999
  1. $PreOrder=CompNo=Company=Number=1 9999
  2. $PreOrder=BranchNo=Branch=Number=1 9999
  3. $PreOrder=PreOrderNo=Order Note No.=Number=1 99999999
  4. PreOrder=OperatorNo=Operator=Number=1 99999999
  5. PreOrder=Specific1=Free Text=String=(40)
  6. PreOrder=Specific2=Free Text=String=(40)
  7. PreOrder=Specific3=Free Text=String=(40)
  8. PreOrder=ToBranchNo=To Branch=Number=1 9999
  9. PreOrder=ToStockNo=Stock No.=Number=1 9999
  10. PreOrder=PreOrderDay=Date=Date=
  11. PreOrder=PreOrderClock=Time=Time=
  12. PreOrder=DateOfDelivery=Date of Delivery=Date=
  13. PreOrder=TimeOfDelivery=Delivery Time=Time=
  14. PreOrder=PickUp=Pick up Costs=Number=
  15. PreOrder=PartDelivery=Part del. allowed=Number=
  16. PreOrder=PaymentNo=Payment Type=Number=1 999
  17. PreOrder=AcceptPercent=Order Accept. Level.=Decimal=(5,2)
  18. PreOrder=OrderValue=Value Amount of Order=Decimal=(13,3)
  19. PreOrder=FreightCost=Shipping Cost=Decimal=(11,3)
  20. PreOrder=PickUpCost=Pick up Costs=Decimal=(11,3)
  21. PreOrder=CashDiscount=Cash Discount=Decimal=(5,2)
  22. PreOrder=DiscPercValue=Discount Percent/Value=Decimal=(5,2)
  23. PreOrder=EditFreightC=Edit Shipping Cost=Bool=(Y/N)
  24. PreOrder=EditDiscPVal=Edit Discount=Bool=(Y/N)
  25. PreOrder=Confirmed=Confirmed=Bool=(Y/N)
  26. PreOrder=CloseOrd=Close Order=Bool=(Y/N)
  1. PreOrderPos=ItemNo=Item=Decimal=(14,0)
  2. PreOrderPos=LANNo=Supplier Item No.=Decimal=(14,0)
  3. PreOrderPos=Specification=Free Text=String=(40)
  4. PreOrderPos=RecItemNo=Supplier Item No.=Decimal=(14,0)
  5. PreOrderPos=SupplierNo=Supplier No.=Number=1 999999
  6. PreOrderPos=DiscPercQuan=Perc.Discount/Quantity=Decimal=(13,3)
  7. PreOrderPos=DiscPercValue=Perc.Discount/Value=Decimal=(13,3)
  8. PreOrderPos=DiscValQuan=Val.Discount/Quantity=Decimal=(13,3)
  9. PreOrderPos=DiscValValue=Val.Discount/Value=Decimal=(13,3)
  10. PreOrderPos=DiscNatQuan=Disc.in kind/Quantity=Decimal=(13,3)
  11. PreOrderPos=DiscNatVal=Disc.in kind/Value=Decimal=(13,3)
  12. PreOrderPos=Quantity=Quantity=Decimal=(13,3)
  13. PreOrderPos=PriceOrUnit=Price per Order Unit=Decimal=(11,3)
  14. PreOrderPos=PosValue=Value=Decimal=(11,3)
  15. PreOrderPos=OrderUnit=Order Unit=Number=1 999
  16. PreOrderPos=FixCost=Fixed Costs=Decimal=(11,3)
  17. PreOrderPos=VarCost=Variable Costs=Decimal=(11,3)
  18. PreOrderPos=CurrencySymbol=NOTEXT=String=(4)
  19. PreOrderPos=QuUnitTxt=Unit=String=(8)
  20. $PreOrderPos=CompNo=Company=Number=1 9999
  21. $PreOrderPos=BranchNo=Branch=Number=1 9999
  22. $PreOrderPos=PreOrderNo=Order No.=Number=1 99999999
  23. $PreOrderPos=PosNo=Position No.=Number=1 9999
  24. PreOrderPos=ToStockNo=Stock No.=Number=1 9999
  25. PreOrderPos=BestSupplier=Supplier No.=Number=1 999999
  26. PreOrderPos=LatestSupplier=Supplier No.=Number=1 999999
  27. PreOrderPos=PrefSupplier=Supplier No.=Number=1 999999
  28. PreOrderPos=BestPrice=Price per Base Unit=Decimal=(11,3)
  29. PreOrderPos=LatestPrice=Price per Base Unit=Decimal=(11,3)
  30. PreOrderPos=PrefPrice=Price per Base Unit=Decimal=(11,3)
  31. PreOrderPos=BestLANNo=Supplier Item No.=Decimal=(14,0)
  32. PreOrderPos=LatestLANNo=Supplier Item No.=Decimal=(14,0)
  33. PreOrderPos=PrefLANNo=Supplier Item No.=Decimal=(14,0)
  34. PreOrderPos=ChosenSupplier=Supplier=Number=0 2
  35. PreOrderPos=ChosenSupplierNo=Supplier No.=Number=1 999999
  36. PreOrderPos=DummyLANNo=Supplier Item No.=Decimal=(14,0)
  37. PreOrderPos=StockQuantityUnit=Quantity Unit=Number=1 999
  38. PreOrderPos=StockQUnitTxt=NOTEXT=String=(10)
  1. $ProFormaInvo=CompNo=Company=Number=1 9999
  2. $ProFormaInvo=BranchNo=Branch=Number=1 9999
  3. $ProFormaInvo=ProFormaInvNo=Invoice suggestion no.=Number=1 99999999
  4. ProFormaInvo=SupplierNo=Supplier No.=Number=1 999999
  5. ProFormaInvo=OrderNo=Order Note No.=Number=1 99999999
  6. ProFormaInvo=DeliveryNo=Delivery No=Number=1 99999999
  7. ProFormaInvo=OperatorNo=Operator=Number=1 99999999
  8. ProFormaInvo=Specification=Free Text=String=(40)
  9. ProFormaInvo=ToBranchNo=For Branch=Number=1 9999
  10. ProFormaInvo=ToStockNo=Stock No.=Number=1 9999
  11. ProFormaInvo=LastReceivedDay=Date of last Delivery=Date=
  12. ProFormaInvo=LastReceivedClock=Time of last Delivery=Time=
  13. ProFormaInvo=ProFormaValue=Total Value of Invoice=Decimal=(12,2)
  14. ProFormaInvo=FreightCost=Shipping Cost=Decimal=(11,3)
  15. ProFormaInvo=PickUpCost=Pick up Costs=Decimal=(11,3)
  16. ProFormaInvo=CashDiscount=Cash Discount=Decimal=(5,2)
  17. ProFormaInvo=DiscPercValue=Discount Percent/Value=Decimal=(5,2)
  18. ProFormaInvo=Confirmed=Confirmed=Bool=(Y/N)
  1. ProFormaPos=ItemNo=Item=Decimal=(14,0)
  2. ProFormaPos=LANNo=Supplier Item No.=Decimal=(14,0)
  3. ProFormaPos=Specification=Free Text=String=(40)
  4. ProFormaPos=RecItemNo=Supplier Item No.=Decimal=(14,0)
  5. ProFormaPos=SupplierNo=Supplier No.=Number=1 999999
  6. ProFormaPos=DiscPercQuan=NOTEXT=Decimal=(13,3)
  7. ProFormaPos=DiscPercValue=NOTEXT=Decimal=(13,3)
  8. ProFormaPos=DiscValQuan=NOTEXT=Decimal=(13,3)
  9. ProFormaPos=DiscValValue=NOTEXT=Decimal=(13,3)
  10. ProFormaPos=DiscNatQuan=NOTEXT=Decimal=(13,3)
  11. ProFormaPos=DiscNatVal=NOTEXT=Decimal=(13,3)
  12. ProFormaPos=Quantity=Quantity=Decimal=(13,3)
  13. ProFormaPos=PriceOrUnit=Price per Order Unit=Decimal=(11,3)
  14. ProFormaPos=PosValue=NOTEXT=Decimal=(11,3)
  15. ProFormaPos=OrderUnit=Quantity Unit=Number=1 999
  16. ProFormaPos=FixCost=Fixed Costs=Decimal=(11,3)
  17. ProFormaPos=VarCost=Variable Costs=Decimal=(11,3)
  18. ProFormaPos=CurrencySymbol=NOTEXT=String=(4)
  19. ProFormaPos=QuUnitTxt=Unit=String=(8)
  20. $ProFormaPos=CompNo=Company=Number=1 9999
  21. $ProFormaPos=BranchNo=Branch=Number=1 9999
  22. $ProFormaPos=ProFormaInvNo=No.=Number=1 99999999
  23. $ProFormaPos=PosNo=Position No.=Number=1 9999
  1. $SuArtState=CompNo=Company=Number=1 9999
  2. $SuArtState=BranchNo=Branch=Number=1 9999
  3. $SuArtState=SupplierNo=Supplier No.=Number=1 999999
  4. $SuArtState=LANNo=Supplier Item No.=Decimal=(14,0)
  5. SuArtState=OpenOrderQuan=Quantity all open Orders=Decimal=(13,3)
  6. SuArtState=OpenOrderTurn=Total all open Orders=Decimal=(13,3)
  7. SuArtState=LastOrderDate=Last Order=Date=
  8. SuArtState=LastDeliveryDate=Last Delivery=Date=
  9. SuArtState=DeliveryQuan=Quantity=Decimal=(13,3)
  10. SuArtState=ExchangeRate=Exchange Rate=Decimal=(20,2)
  11. SuArtState=AverageDelivTime=Average Delivery Time=Number=0 999
  12. SuArtState=AveragePrice=Average Price=Decimal=(11,3)
  13. SuArtState=LastPrice=Last Price=Decimal=(11,3)
  14. SuArtState=BestPrice=Best Price=Decimal=(11,3)
  15. SuArtState=DateBest=Date=Date=
  16. SuArtState=HighestPrice=Highest Price=Decimal=(11,3)
  17. SuArtState=DateHighest=Date=Date=
  18. SuArtState=NumberOfDeliv=Number of Deliveries=Number=0 99999999
  19. SuArtState=SuBaseQuantityUnit=Quantity Unit=Number=1 999
  20. SuArtState=SuBaseQUnitTxt=NOTEXT=String=(10)
  1. $SupplArt=CompNo=Company=Number=1 9999
  2. $SupplArt=SupplierNo=Supplier No.=Number=1 999999
  3. $SupplArt=LANNo=Supplier Item No.=Decimal=(14,0)
  4. SupplArt=LANName=Description=String=(20)
  5. SupplArt=ItemNo=Item=Decimal=(14,0)
  6. SupplArt=Price=Price=Decimal=(11,3)
  7. SupplArt=ForeignPrice=Foreign Curr. Price=Decimal=(11,3)
  8. SupplArt=RecommendPrice=Recommended Price=Decimal=(11,3)
  9. SupplArt=NewPrice=New Price=Decimal=(11,3)
  10. SupplArt=DatePrice=Date for new Price=Date=
  11. SupplArt=PromotionPrice=Promotion Price=Decimal=(11,3)
  12. SupplArt=FromDate=from Date=Date=
  13. SupplArt=ToDate=to Date=Date=
  14. SupplArt=DiscPercQuanTab=Perc.Discount/Quantity=Number=1 99
  15. SupplArt=DiscPercValTab=Perc.Discount/Value=Number=1 99
  16. SupplArt=DiscValQuanTab=Val.Discount/Quantity=Number=1 99
  17. SupplArt=DiscValValTab=Val.Discount/Value=Number=1 99
  18. SupplArt=DiscNatQuanTab=Disc.in kind/Quantity=Number=1 99
  19. SupplArt=DiscNatValTab=Disc.in kind/Value=Number=1 99
  20. SupplArt=MinQuan=Minimum per Order=Decimal=(13,3)
  21. SupplArt=BaseUnit=Base Unit=Number=1 999
  22. SupplArt=OrderUnit=Order Unit=Number=1 999
  23. SupplArt=FixCost=Fixed Costs=Decimal=(11,3)
  24. SupplArt=PrefereItem=Preferred Item Group=Bool=(Y/N)
  25. SupplArt=VarCost=Variable Costs=Decimal=(11,3)
  26. SupplArt=ShrinkagePerc=Shrinkage %=Decimal=(5,2)
  27. SupplArt=DelivDay=Deliv./Day=Number=0 999
  28. SupplArt=ActualDay=Durability in Days=Number=0 999
  29. SupplArt=ExtraDiscount=Extra Discount=Decimal=(11,3)
  30. SupplArt=PackBarcode=Pack Barcode=Decimal=(14,0)
  31. SupplArt=ProducerNo=Producer=Number=1 999999
  32. SupplArt=Discount=Discount=Decimal=(11,3)
  33. SupplArt=InvoicePrice=Invoice Price=Decimal=(11,3)
  34. SupplArt=NetCostPrice=Net Cost Price=Decimal=(11,3)
  35. SupplArt=SuBaseQUnitTxt=NOTEXT=String=(10)
  36. SupplArt=PerOrderTxt=NOTEXT=String=(10)
  37. SupplArt=DiscontinueItem=NOTEXT=Bool=(Y/N)
  1. $Supplier=CompNo=Company=Number=1 9999
  2. $Supplier=SupplierNo=Supplier No.=Number=1 999999
  3. Supplier=CountryOpNo=Further Supplier Ident.=Number=0 99999999
  4. Supplier=Name=Name=String=(32)
  5. Supplier=OperationType=Type of Operation=String=(8)
  6. Supplier=OperationGroup=Operation group=String=(32)
  7. Supplier=Add1=Address 1=String=(32)
  8. Supplier=Add2=Address 2=String=(32)
  9. Supplier=Add3=Address 3=String=(32)
  10. Supplier=Contact=Contact=String=(32)
  11. Supplier=Telephone=Phone=String=(16)
  12. Supplier=Fax=Fax=String=(16)
  13. Supplier=Modem=Modem=String=(16)
  14. Supplier=EMail=eMail=String=(32)
  15. Supplier=PaymentNo=Payment Type=Number=1 999
  16. Supplier=BankNo=Bank Number=String=(10)
  17. Supplier=AccountNo=Account No.=String=(16)
  18. Supplier=BankName=Name=String=(20)
  19. Supplier=CustomerNo=Customer No.=String=(20)
  20. Supplier=SupplQuality=Quality ID No.=Number=0 9
  21. Supplier=CashDiscount=Cash Discount=Decimal=(5,2)
  22. Supplier=CashDiscDays=Cash Discount Days=Number=0 999
  23. Supplier=DiscountPerc=Disc. percent=Decimal=(5,2)
  24. Supplier=DiscountTurnover=Discount in kind from Value up =Decimal=(13,3)
  25. Supplier=Bonus1=1st Disc. percent=Decimal=(5,2)
  26. Supplier=Bonus1Turnover=From Turnover up/Year=Decimal=(13,3)
  27. Supplier=Bonus2=2nd Disc. percent=Decimal=(5,2)
  28. Supplier=Bonus2Turnover=From Turnover up/Year=Decimal=(13,3)
  29. Supplier=MakeBillType=Type=Number=1 3
  30. Supplier=InvoicePeriod=Days to pay after Deliv.=Number=0 999
  31. Supplier=ReclamationPeriod=Return after Deliv.=Number=0 999
  32. Supplier=NeedPickUp=Pick up=Bool=(Y/N)
  33. Supplier=OrderRequired=With Order=Bool=(Y/N)
  34. Supplier=PriceIncludeVat=Price include VAT=Bool=(Y/N)
  35. Supplier=FreightCost1=1st Shipping Cost=Decimal=(11,3)
  36. Supplier=Conditions1=to Value=Decimal=(13,3)
  37. Supplier=FreightCost2=2nd Shipping Cost =Decimal=(11,3)
  38. Supplier=Conditions2=to Value=Decimal=(13,3)
  39. Supplier=PickUpCost=Pick up Costs=Decimal=(11,3)
  40. Supplier=WarningPerc=NOTEXT=Decimal=(5,2)
  1. $SupplOrder=CompNo=Company=Number=1 9999
  2. $SupplOrder=BranchNo=Branch=Number=1 9999
  3. $SupplOrder=OrderNo=Order Note No.=Number=1 99999999
  4. SupplOrder=SupplierNo=Supplier No.=Number=1 999999
  5. SupplOrder=OperatorNo=Operator=Number=1 99999999
  6. SupplOrder=Specific1=Free Text=String=(40)
  7. SupplOrder=Specific2=Free Text=String=(40)
  8. SupplOrder=Specific3=Free Text=String=(40)
  9. SupplOrder=ToBranchNo=To Branch=Number=1 9999
  10. SupplOrder=ToStockNo=Stock No.=Number=1 9999
  11. SupplOrder=OrderDay=Date=Date=
  12. SupplOrder=OrderClock=Time=Time=
  13. SupplOrder=DateOfDelivery=Date of Delivery=Date=
  14. SupplOrder=TimeOfDelivery=Time of Delivery=Time=
  15. SupplOrder=PickUp=Pick up Costs=Number=
  16. SupplOrder=PartDelivery=Part of Deliv. allowed=Number=
  17. SupplOrder=PaymentNo=Payment Type=Number=1 999
  18. SupplOrder=AcceptPercent=Order Accept. Level=Decimal=(5,2)
  19. SupplOrder=OrderValue=Total Order Value=Decimal=(13,3)
  20. SupplOrder=FreightCost=Shipping Cost=Decimal=(11,3)
  21. SupplOrder=PickUpCost=Pick up Costs=Decimal=(11,3)
  22. SupplOrder=CashDiscount=Cash Discount=Decimal=(5,2)
  23. SupplOrder=DiscPercValue=Discount Percent/Value=Decimal=(5,2)
  24. SupplOrder=EditFreightC=Edit Shipping Cost=Bool=(Y/N)
  25. SupplOrder=EditDiscPVal=Edit Discount=Bool=(Y/N)
  26. SupplOrder=Confirmed=Confirmed=Bool=(Y/N)
  27. SupplOrder=FromAdrNo=Address=Number=1 99999999
  28. SupplOrder=ToAdrNo=Address=Number=1 99999999
  1. $SupplState=CompNo=Company=Number=1 9999
  2. $SupplState=BranchNo=Branch=Number=1 9999
  3. $SupplState=SupplierNo=Supplier No.=Number=1 999999
  4. SupplState=OpenOrder=Number open Orders=Number=0 99999999
  5. SupplState=OpenOrderTurn=Turnover open Orders=Decimal=(13,3)
  6. SupplState=LastOrder=Last Order=Date=
  7. SupplState=LastDelivery=Last Delivery=Date=
  8. SupplState=AverageDelivTime=Average Delivery Time=Number=0 999
  9. SupplState=AccumTurn=Accumul. Turnover=Decimal=(13,3)
  10. SupplState=NumberOfDeliv=Number of Deliveries=Number=0 99999999
  1. $SupplTime=CompNo=Company=Number=1 9999
  2. $SupplTime=SupplierNo=Supplier No.=Number=1 999999
  3. $SupplTime=WeekDay=Weekday=Number=1 7
  4. SupplTime=NameDay=Name=String=(10)
  5. SupplTime=DeliveryInDays=Delivery Time in Days=Number=0 999
  6. SupplTime=OrderClock1=1st Order Time=Time=
  7. SupplTime=DeliveryInHour1=Delivery Time in Hours=Number=0 24
  8. SupplTime=OrderClock2=2nd Order Time=Time=
  9. SupplTime=DeliveryInHour2=Delivery Time in Hours=Number=0 24
  10. SupplTime=OrderClock3=3rd Order Time=Time=
  11. SupplTime=DeliveryInHour3=Delivery Time in Hours=Number=0 24
  12. SupplTime=DeliveryTime1=1st Delivery Time Time=Time=
  13. SupplTime=DeliveryTime2=2nd Delivery Time =Time=
  14. SupplTime=DeliveryTime3=3rd Delivery Time=Time=
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany