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