Shawn > As nice as it would be to have our ERPs talk to each other using a service > or adapter, the fact is every company wants different things using a vast > array of different products to get it.
I did a quick analysis of all our mappings (mostly Retail) and found that for outbound Invoice (810) mappings, there are only 185 different fields being used. (These are specific fields that originate in tables like Invoice Header, Invoice Details, etc.) SrcTable IH SrcField AP_ACCOUNT count 1 SrcTable IH SrcField Bill_To_Addr_1 count 3 SrcTable IH SrcField Bill_To_City count 3 SrcTable IH SrcField Bill_To_Country count 1 SrcTable IH SrcField Bill_To_Name count 13 SrcTable IH SrcField Bill_To_State count 3 SrcTable IH SrcField Bill_To_Zip count 2 SrcTable IH SrcField BLading_No count 61 SrcTable IH SrcField Buyer count 1 SrcTable IH SrcField Buyer_Tel count 1 SrcTable IH SrcField Carrier_Name count 56 SrcTable IH SrcField Cartons count 54 SrcTable IH SrcField Currency_Code count 3 SrcTable IH SrcField Cust_Dept count 43 SrcTable IH SrcField Cust_PO count 118 SrcTable IH SrcField Cust_PO_4 count 1 SrcTable IH SrcField Cust_Vendor_No count 59 These are just a sample of some of the fields used by our mappers. Many of these fields are only used by a single partner or version. It would be very easy for VICS or a related group to publish an XML?? standard that allows these 185 fields to be mapped to almost any existing ERP system. In other words, each adapter only has to export these 185 fields, to automate the translation of ERP to X12. This has always been the missing link... actual fields used by actual systems. I'm sure that the incoming Purchase Orders (850) require even fewer fields... Earl Wertheimer [EMAIL PROTECTED] http://www.spe-edi.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/OIFolB/TM --------------------------------------------------------------------~-> . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> 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/
