The following is the structure of the TeleMagic Order Entry database. This information should be given out to Developers or Resellers who need it for importing/exporting and DBase conversion. TMITHIST.DBF (Item History) Field Field Name Type Width Dec -------------------------------------------------------------------------- 1 ITEM C 10 2 QUAN N 8 3 CODE C 1 4 CUST C 10 5 BRANCH C 3 6 CLASSCODE C 3 7 DESCRIP C 30 8 UNIT C 3 9 PRICE N 11 4 10 COST N 11 4 11 TAXCODE C 1 12 BILLTO C 10 13 DATE1 C 6 14 SEQNO C 4 15 TMPCT C 3 16 TMDAY C 2 17 SALESM C 3 18 ORD_NO C 8 19 TXBLTOT N 11 2 20 TAXTOT N 9 2 21 INVTOT N 11 2 22 INVNUM N 7 23 INVDATE D 8 **Total** 174 TMITMAST.DBF (Item Master File) Field Field Name Type Width Dec -------------------------------------------------------------------------- 1 CODE C 1 2 CUST C 10 3 ITEM C 10 4 BRANCH C 3 5 ONHAND N 7 6 CLASSCODE C 3 7 DESCRIP C 30 8 UNIT C 3 9 PRICE N 11 4 10 COST N 11 4 11 TAXCODE C 1 **Total** 91 TMITORDR.DBF (Open Orders) Field Field Name Type Width Dec -------------------------------------------------------------------------- 1 ITEM C 10 2 QUAN N 8 3 CODE C 1 4 CUST C 10 5 BRANCH C 3 6 CLASSCODE C 3 7 DESCRIP C 30 8 UNIT C 3 9 PRICE N 11 4 10 COST N 11 4 11 TAXCODE C 1 12 BILLTO C 10 13 DATE C 6 14 SEQNO C 4 15 TMPCT C 3 16 TMDAY C 2 17 SALESM C 3 18 ORD_NO C 8 19 TXBLTOT N 11 2 20 TAXTOT N 9 2 21 INVTOT N 11 2 22 INVNUM N 7 2 23 INVDATE D 8 **Total** 174 End 538 05-02-91 (New) VGK Index:Order Entry, Layout