I am developing a VB application that takes cost centre data in the form of text files from ERP applications like SAP, Peoplesoft etc. My application parses the text files and rebuilds the cost centre hierarchy in the client application. Cost centre details need to include name and address of centre, contact details, and other details which may go beyond the details of the General Ledger.
To do this, each cost centre record also needs to have one or more fields which uniquely identify each cost centre's parent, so my program can "look up" each cost centre parent and rebuild the hierarchy. It follows that the cost centre records need to be in order of highest level first, so the parents can be found.
My questions are
a. How likely is it that companies will be able to export text files from their ERP systems in this format?, and
b. Does anyone have any practical examples of how cost centre coding typically works?