home *** CD-ROM | disk | FTP | other *** search
/ Shareware 1 2 the Maxx / sw_1.zip / sw_1 / TEXT / TM12_TIP.ZIP / 538.TXT < prev    next >
Text File  |  1991-12-18  |  4KB  |  88 lines
  1. The following is the structure of the TeleMagic Order Entry database.
  2. This information should be given out to Developers or Resellers who
  3. need it for importing/exporting and DBase conversion.
  4.  
  5.  
  6. TMITHIST.DBF  (Item History)
  7.                
  8.  
  9. Field        Field Name             Type         Width          Dec
  10. --------------------------------------------------------------------------
  11. 1            ITEM                    C           10
  12. 2            QUAN                    N            8
  13. 3            CODE                    C            1
  14. 4            CUST                    C           10
  15. 5            BRANCH                  C            3
  16. 6            CLASSCODE               C            3
  17. 7            DESCRIP                 C           30
  18. 8            UNIT                    C            3
  19. 9            PRICE                   N           11              4
  20. 10           COST                    N           11              4
  21. 11           TAXCODE                 C            1
  22. 12           BILLTO                  C           10
  23. 13           DATE1                   C            6
  24. 14           SEQNO                   C            4
  25. 15           TMPCT                   C            3
  26. 16           TMDAY                   C            2
  27. 17           SALESM                  C            3
  28. 18           ORD_NO                  C            8
  29. 19           TXBLTOT                 N           11              2
  30. 20           TAXTOT                  N            9              2
  31. 21           INVTOT                  N           11              2
  32. 22           INVNUM                  N            7
  33. 23           INVDATE                 D            8
  34. **Total**                                       174
  35.  
  36.  
  37. TMITMAST.DBF  (Item Master File)
  38.  
  39. Field        Field Name             Type         Width          Dec
  40. --------------------------------------------------------------------------
  41. 1            CODE                   C             1
  42. 2            CUST                   C            10
  43. 3            ITEM                   C            10
  44. 4            BRANCH                 C             3
  45. 5            ONHAND                 N             7
  46. 6            CLASSCODE              C             3
  47. 7            DESCRIP                C            30
  48. 8            UNIT                   C             3
  49. 9            PRICE                  N            11             4
  50. 10           COST                   N            11             4
  51. 11           TAXCODE                C             1
  52. **Total**                                        91
  53.  
  54.  
  55.  
  56. TMITORDR.DBF (Open Orders)
  57.  
  58. Field        Field Name             Type         Width          Dec
  59. --------------------------------------------------------------------------
  60. 1            ITEM                   C            10
  61. 2            QUAN                   N             8
  62. 3            CODE                   C             1
  63. 4            CUST                   C            10
  64. 5            BRANCH                 C             3
  65. 6            CLASSCODE              C             3
  66. 7            DESCRIP                C            30
  67. 8            UNIT                   C             3
  68. 9            PRICE                  N            11              4
  69. 10           COST                      N            11              4
  70. 11           TAXCODE                C             1
  71. 12           BILLTO                 C            10
  72. 13           DATE                   C             6
  73. 14           SEQNO                  C             4
  74. 15           TMPCT                  C             3
  75. 16           TMDAY                  C             2
  76. 17           SALESM                 C             3
  77. 18           ORD_NO                 C             8
  78. 19           TXBLTOT                N            11              2
  79. 20           TAXTOT                 N             9              2
  80. 21           INVTOT                 N            11              2
  81. 22           INVNUM                 N             7              2
  82. 23           INVDATE                D             8
  83. **Total**                                       174
  84.  
  85.  
  86. End 538
  87. 05-02-91 (New) VGK
  88. Index:Order Entry, Layout