> A good question. Our software has the ability to map data to and from > multiple key-linked delimited files. The only ERP which ever used this > format was Baan, and over a decade ago they introduced the capability to > import and export using a structured 'flat' file - an approach which was > promptly adopted by everyone we dealt with. > > So the answer is that people do not like the multiple table approach. To > the further question as to why this should be so I have no answer.
Who are these "people" who "do not like" multiple tables? Seems to me in the hands of any competent Mapper/Programmer/Analyst there is no real difference at all. When you think about it, what is the difference between mapping the "customer PO Number" to Flat File Record type "10" position 62 or to table order_header, column "ponum" ; or mapping the part number to "Flat File Record Type 30 position 9" or to table order_line column "part_no" ??? Call me naive, but data are data and it goes where it goes. . Michael C. Mattias Tal Systems Inc. Racine WI [email protected] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
