Common Data Format for Email

          TABLE - oehdr - order entry header
            fields *eorder  - d6  - customer order number (automatically numbered)
                    custid  - d6  - customer number
                    cuspon  - a14 - customer purchase order number
                    shpto   - d4  - shipto address code
                    hrqdate - d6  - requested date to ship

          TABLE - oeline - order entry lines
            fields *eorder  - d6  - customer order number
                   *eoseq   - d4  - Sequence of order lines
                    litem   - a15 - item number
                    ldescr  - a30 - item description
                    lquant  - d8  - requested quantity

          TABLE - oenotes - Order entry notes
            fields *eorder  - d6  - customer order number
                   *eoseq   - d4  - for header use zero (0)
                                    for lines link with eoseq
                   *eosseq  - d2  - Sequence within eoseq (to keep order)
                    eotext  - a30 - Text

          TABLE - shipto - shipto address file
            fields *custid  - d6  - customer order number
                   *shpto   - d4  - customer shipto address code
                    shpnm   - a30 - shipto name
                    shpad1  - a30 - shipto address number 1
                    shpad2  - a30 - shipto address number 2
                    city    - a18 - shipto city
                    state   - a2  - shipto state
                    zip     - d5  - shipto zip code

Mainpage Contact Us