PWC 出的中石油财务信息系统设计报告

PetroChinaRequirementsanddesignofFMISmodificationsFMISenhancementprojectDecember19991Contents1.Businessrequirements32.Gapanalysis103.Overallapproachanddesignprinciples134.Businessprocessoverview155.Overviewofsystemchanges186.Newdatafilesandassociatedprocesses247.Systemprocessesforconsolidationandreporting29AppendixA-Reportformats322SystemDesignforFMISModification2BusinessrequirementsChapter13TobeabletodoanIPO,PetroChinaneedtobeabletoproducecertainkeyfinancialreportsToproducethesereports,somechangestoFMISneedstobeimplemented.BusinessrequirementoverviewTheFMISsystemneedtobeabletoproducethefollowingreports:AnnualconsolidationreportsasrequiredbyChinaFinanceMinistrybasedonthePRCGAAPforjoint-stockcompany.QuarterlyconsolidationofreportsoftheoverallListCobasedontheIASisrequiredforpubliclylistedcompanies.DisclosureitemsarealsorequiredbyIASandPRCGAAPforjoint-stockcompany.Someotherinformationisrequiredtosupportannualauditing.Alltheabovereports(excepttheauditinformation)willneedtobeproducedalongthenewPetroChinaorganizationstructureasdescribedinthefollowingpage.Theabovereportingrequirementsaredetailedinthenextpages.4PetroChinaLevel1PetroChinaLevel2SpecializedCo/BusinessGroupLevel3SegmentLevel4TypeE&P.........Level5BusinessUnits......Gas&PipelineDownstreamOil&GasE&PNaturalgas(inc.gaspipeline)Refining&MarketingPetrochemicals&marketingOthersRefiningPetroChinareportingstructureMarketingR&DChinaoilHQBeijingE&PHuaBeiG&PHuaBeiRefineryHuaBeiNorthChinaPetr.TradeChinaO&GresearchinstituteLevel6OperationsUnitsLevel7SuboperationsUnitsOilfield#1Oilfield#2Oilfield#3District1District2District35PRCGAAPconsolidationreportrequiresthefollowingdata:BusinessrequirementsforPRCconsolidationIndividualPRCGAAPreportsofallentityinvolvedinconsolidation.Balancesheet(PRCGAAP)IncomestatementCashflowstatementInternaltransactionsreportsInternaltransactionlistInternalproductsalesorpurchasereportInternalrenderingofservicereportorinternalservicepurchasereportInternallong-termequityinvestmentreport,capitalstructurereportInternalpayableorreceivablesRequiredinformationforinternaltransactionsCounterpart,transactiontype,period,beginningbalance,creditamount,debitamount,endingbalance6TherearetwotypesofchangesthatneedtobemadetocomplywithIASBusinessrequirementsforIASconsolidationPRCconsolidatedfinancialstatementswithspecificdetailsIndividualPRCreportslistedearlierLedgerreportTransactionswithdifferentaccountingtreatmentinIASandPRCGAAPDevelopmentcosts-E&PsegmentspecificCostofsuccessfulwell(succeededintheperiod)Assetsanddepreciation(straightlinemethodvsUOP)andrelatedtaxcreditAssetsclass,accumulateddepreciationamountbasedonreevaluatedcarryingamountbystraightlinemethod;depreciationamountbasedonun-reevaluatedamountbyunitofproductionmethodorstraightlinemethod(dependonassetsclass)Deferredbusinessinitialcost(pre-operationexpenditures)Beginningbalance,endingbalanceMonthlyrevaluationofnon-currentmonetaryassets&liabilities(foreigncurrencyitem)Historicalvalue(calculatedbyexchangerateofoccurringdate),reevaluatedvalueoflong-termloan(foreigncurrency),long-termdeposit(foreigncurrency),otherlong-termmonetaryassetsorliabilities.7IASandPRCGAAPrequiresthefollowingitemsfordisclosurepurpose:BusinessrequirementsfordisclosurepurposesAgingreportofaccountsreceivable(PRCGAAP)Long-termequityinvestment(PRCGAAP)Investee,stocktype,sharenumberofstock,sharepercentage,amount,remarksLong-termbondinvestment(PRCGAAP)Bondtype,parvalue,rate,purchasedamount,duedate,interestofthisyear,accumulatedinterest,remarksOthernon-equitylong-terminvestment(PRCGAAP)Debtor,principal,rate,duedate,interestincomeofcurrentperiod,accumulatedinterest,remarksLong-termloan(PRCGAAP)Loaner,amount,duedate,rate,term(Ifforeignloan)Foreigncurrencyamount,RMBamountbyexchangerateofbalancesheetdateBondspayable(PRCGAAP)Bondname,parvalue,issueddate,issuedamount,duedate,interestexpenseofcurrentyear,accumulatedinterestRelatedpartytransactions(PRCGAAP&IAS)Alldatalistedininternaltransactionreports,onlydifferententitynameIncomeanalysisreport(IAS)Specialdeductionsrelatingtoexplorationandproductionactivities,Incomenotsubjecttotax;ExpensesnotdeductiblefortaxpurposesMovementofallowancefordoubtfulaccountsBalanceatbeginningofperiod,Provision,Deductions,BalanceatendofperiodMovementsinallowancefordiminutioninvalueofinventoriesBalanceatbeginningofperiod;Provision;Deductions;BalanceatendofperiodMovementreportofPPE&accumulateddepreciationCost:Beginningbalance,additions,disposals,endingbalance;Accumulateddepreciation:Beginningbalance,chargefortheyear,disposals,endingbalanceMovementofallowanceofinvestmentvaluediminutionBeginningbalance;Provision;Deductions;EndingbalanceLoansAnalysisReportDirector’sremunerationreportSalaries,allowancesandotherbenefitsContributiontoretirementbenefitscheme8FMISalsoneedtoproducecertaininformationthatisrequiredtofacilitateannualaudit.BusinessrequirementsforannualauditTherequiredinformationforaccountsreceivable,long-termequityinvestment,long-termnon-equityinvestmenthasbeenlistedindisclosurerequirement.Theonlyremainingitemsforannualauditarelistedbelow:Short-terminvestmentInvestmenttype,investee,securitytype,parvalue,historicalcost,rate,duedate,interestreceivableordividendsreceivable,premium/discountanditsamortisationNotesreceivableNotestype,parvalue,rate,drawer,duedateOtherreceivableDebtor,amount,postduedaysAssetsrevaluationAssetsclass,bookvaluebeforerevaluation,bookvalueafterrevaluationShort-termloanLoaner,amount,rate,duedateNotespayableOwner,parvalue,rate,duedate9GapanalysisChapter210ChangesinfinancialreportingprocessPetroChinaneedstoimplementalargescalechangeinitsfinancialreportingprocess.CurrentConsolidationisdonebytheauditorsusingspreadsheetsandmanualdatacollectionandmanipulationFMISreportisnotcompliantwithPRCaccountingstandardforjoint-stockcompany.IASreportisproducedbytheauditorsusingmanualmethodReportingisdoneforthewholeCNPCwiththecurrentorgstructureUsecurrentchartofaccountsFutureConsolidationwillbedonebyPetroChinaaccountantsaspartoftheregularaccountingprocessusingFMISFMISreportwillbecompliantwithPRCaccountingstandardforjoint-stockcompany.ASreportisproducedbyPetrochinaaccountantsusingFMISReportingstructureforPetroChinawillbeseparatedfromtheoldCNPC.NeworgstructurewillbeputinplaceNewchartofaccountswillbeineffect11SystemsissuesThefollowingsystemsissuesareidentifiedascriticaltotheabilityforPetroChinatobeabletodoconsolidationandproducetherequiredreportsREQUIREMENTReconciliationoftransactionsthatoccursacrossdifferentaccountingentities.Somedetailedinformationneedtobepassedupthecorporatereportingstructure.SYSTEMISSUEThisisdifficulttodowiththecurrentFMISsinceFMIStreatseachaccountingentityasindependentfromotheraccountingentities.ThisisnotpossibleinthecurrentFMISsinceFMISonlytransferreports,notdetailedinformation.CONSOLIDATIONPROCESSREQUIREMENTIASreporthavesomedifferentgroupingofaccountscomparedtoPRCreportsIntheinterim,CNPCrequiresreportingbasedonlocationsinadditiontothe“normal”reportingprocedurealongsegmentDisclosureitemsneedtobeproducedandrolledupSYSTEMISSUECurrentFMISaggregatesreportupthehierarchyanditisnotpossibletoseeorreconstructtheindividualaccounts,thereforeitisnotpossibletoregroupaccountsathigherlevel.CurrentlyFMISreportinghierarchyfollowsastricttreepatternwithoneentityreportingtoonlyoneparent.CurrentFMIScannotproducethisdatanorrollitupREPORTINGPROCESS12OverallapproachanddesignprinciplesChapter313Designprinciples/goalsThedesignhastobeimplementablepriortotheIPOModifiedFMISmustbeabletoproduceallrequiredreportswithminimalmanualworkAvoidmajorchangesinbusinessprocessAvoidmajorchangesinFMISwhichneedslongdevelopmenttimeand/orhighriskofdestabilizingFMISMarginalchangestoFMISispreferredtomarginalchangeinbusinessprocessChangesinbusinessprocessorFMISshouldhaveminimaldependencyonshort-termimprovementtoITinfrastructure.Duetocurrentlimitationsintelecommunication,theamountofdatathatneedstobetransferredshouldbeminimized.Toeasetransition,themodifiedFMISneedtohavedatacompatibilitywithcurrentFMISThefollowingprincipleshavebeenfollowedincreatingthedesignforthenewsystem:14BusinessprocessoverviewChapter415LocationLevel5SegmentLevel3HQCorpLevel1LgrLgrLgr+Lgr+IASIASPRCSegmentASegmentBElimElimPRCElimIASElimIASElimIASLgr+Lgr+IASIASElimIASElimIASIASDifferentsegment,differentlocationSamesegment,differentlocationSamesegment,samelocationDifferentsegment,samelocationLEGENDLedgersReportsModifiedreport/consldtnsystemConsolidationentryConsolidationfileDataflowdiagramofrollupprocessPRCPRCLgrLgrNotes:Lgr+=ledgerreportplussomeotherspecialreports.16Rollupandconsolidationprocesschart1.1EntertransactionsforLevel6HO1.5Entersame-segment,same-locationeliminationentries1.4Importreportsfromlevel6HOledgers1.2CreatereportsforLevel6HOledgers1.3Receivereports&importdatafromlevel7(district)1.8ProduceIASadjustmentfile(IASfile)1.7ProduceBUsegmentPRCreport1.6DetermineIASadjustments1.9SendPRCBUsegmentreportandIASfiletoBeijingBusinessgroupFinance2.1ReceivePRCreportfromBULocationsegments2.2Enterdifferent-segmentsame-locationeliminationentries2.4Senddifferent-segment,same-locationeliminationfiletoBeijingH.Q.2.3ProduceLocationPRCreport3.1ReceiveBUsegmentPRCreportandIASfile1.10SendPRCreporttoLocationHOfinance3.2Entersame-segment,different-locationseliminationentries3.3Producebus.groupPRCreportandIASadjustedreport4.1ReceivePRCreportandsegmentIASfile4.2Receivedifferent-segment,same-locationeliminationfiles4.3Enterdifferent-segment,different-locationeliminationentries4.5ProducecorporatePRCreportsandIASreportsBULocationLocationHOFinanceSegmentFinance(Beijing)CorpFinance3.4SendbusinessgroupPRCreportandIASfiletocorp4.4EnterIASadjustments(corporatelevel)Level5Level3Level117OverviewofsystemchangesChapter518Dataflowdiagram-TransactionsystemSomechangesarerequiredintheFMISTransactionsystemtocollectrequireddatafromallaccountingentitiesExistingfunctionalityTransactionDBEnteraccountingentriestoFMISProduceLedgerreportT1SpecialdisclosureitemsLedgerreportsfileF2Disclosure&IASsupportingdatafileF1InternaltransactiondatafileNewfunctionalityP4ProducespecialdisclosureitemsreportP2ProduceinternaltransactionsdatafileP3Enterspecialdisclosure&IASsupportdataP1Forinternaltransactions,entercustomer/suppliercode19Newormodifiedfunctionalities-TransactionsystemNewdatafileF1-InternaltransactiondatafileF2-Disclosure&IASsupportingdatafileNewtablesT1-SpecialdisclosureitemsNewsystemprocessesP1-InternaltransactiondataentryP2-InternaltransactionfileexportP3-Specialdisclosureitems&IASsupportingdataentryP4-Specialdisclosureitems&IASsupportingfileexportChangestoFMISTransactionsystemissummarizedinthefollowinglist:20F3EliminationdatafileDataflowdiagram-ReportingsystemNewfunctionalityLowerlevelReportsLedgerreportfilesAggregationP7EliminationprocessExistingfunctionalityAggregatedReportsConsolidatedLedgerReportP16Export/printconsolidatedledgerreportT2EliminationF2Disclosure&IASsupportingdatafileF1InternaltransactiondatafileT4InternalTransactionP13ExportremaininginternaltransactionEliminationEntriesInternaltransaction&eliminationreports&queriesAnalyzeinfoanddeterminerequiredeliminationP5Query,view,printP14Exportdisclosures&IASsupportingdataP8ExportEliminationentriesF4IASadjustmententryfileF3EliminationdatafileLedgerreportfilesF2Disclosure&IASsupportingdatafileF1InternaltransactiondatafileF4IASadjustmententryfileP12ExportIASadjustmentP15PrintIASreportsT3IASadjIASadjustmententriesAnalyzeinfoanddeterminerequiredIASadjustmentP9QueryIASadjustmentdataIASadjustmentinforeportsSomemajorchangesarerequiredintheFMISReportingsystemP19ImportinternaltransactionP6EntereliminationentriesP18ImporteliminationentriesP17ImportIASadjustmentsP10EnterIASadjustmentsP15PrintPRCreportsP20Importdisclosure/IASsupportdataT5Consolidationaccountpair21Newormodifiedfunctionalities-ReportingsystemNewdatafileF1-InternaltransactiondatafileF2-Disclosure&IASsupportingdatafileF3-EliminationdatafileF4-IASadjustmententryfileNewdatatablesT2-EliminationentrytableT3-IASadjustmententrytableT4-InternaltransactiontableT5-ConsolidationaccountpairtableThechangestotheFMISReportingsystemisshowninthefollowinglist:NewsystemprocessesP5-QueryinfoforeliminationP6-EntereliminationentriesP7-EliminationprocessP8-ExporteliminationP9-QueryinfoforIASadjustmentP10-EnterIASadjustmentsP11-IASadjustmentprocessP12-ExportIASadjustmentsP13-ExportremaininginternaltransactionsP14-Exportdisclosure&IASsupportdataP15-PrintIASreportP16-Print/ExportPRCreportP17-ImportIASadjustmentsP18-ImporteliminationentriesP19-ImportinternaltransactionsP20-Importdisclosure/AISsupportdata22Requirednew/modifiedreportsPRCreport&disclosurerequirementPRCIncomestatementreportmodificationPRCBalancesheetmodificationPRCCashflowstatementmodificationInternaltransactionreportAgingreportofaccountsreceivableLong-termequityinvestmentreportLong-termbondinvestmentreportOtherlong-terminvestmentreportLong-termloanreportBondspayablereportRelatedpartytransactionreportIASreport&disclosurerequirementIASincomestatementdefinitionIASbalancesheetdefinitionIAScashflowstatementdefinitionStatementofowner'sequityNote4EmployeecompensationcostsNote5interestexpenseNote6IncomebeforeincometaxesNote7IncometaxesNote8CashandcashequivalentsNote9AccountsreceivableNote10InventoriesNote11PrepaidexpensesandothercurrentassetsNote12Property,plant,andequipmentNote13InvestmentsNote14IntangibleandotherassetsNote15AccountspayableandaccruedliabilitiesNote16DebtNote17DeferredincometaxesNote22,23,24AuditingrequiredreportsShort-terminvestmentreportNotesreceivablereportOtherreceivablereportShort-termloanreportNotespayablereportInadditiontothesystemchanges,thefollowingreportsmustbedevelopedandproduced23NewdatafilesandassociatedprocessesChapter624ReportingsystemTransactionSystemF1-InternaltransactiondatafileandassociatedprocessesP1.Modificationtovoucherentryintransactionsystemneedtobedone.Currentlythetransactiontablehasafieldtorecordcustomer/vendorcodethatisonlyusedforA/RorA/P.Thesystemneedstobemodifiedtomakethecustomer/vendorcodeapplicableforallinternaltransactiontypes.Thesystemshouldmakecustomer/vendorcodeentrymandatoryforallinternaltransactions.P2.Whencounterpartcodesofallinternaltransactionshavebeenrecorded,transactionsystemwillbeabletoexportdataofinternaltransactionsandtransferthedatauptothehigherlevels.P5.Thereportingsystemmusthavefacilitiesforuserstoquery,viewandprinttheinternaltransactiondataandtheeliminationentries.Thisreportisthekeyinputfortheusersintheeliminationprocess.Userscreateeliminationentriesbasedontheinformationcontainedintheinternaltransactiontable.Tofacilitatethecreationofthisreport,tableT5-(Accountpairs)isneededtorecordtheaccount“pairs”fortheoffsetingaccounts.Thisprocessmustalsobeabletoprinteliminationreportwhichcomparestheinternaltransactionswiththeeliminationentriesthathasbeendone.Theeliminationreportmustbereportedtothehigherlevelasacontrolreporttoensurethateliminationsaredoneproperlyatthelevelwhereitisperformed.P13.Aspartoftheconsolidationprocess,thesystemwillfiltertheinternaltransactionsandrolluptheinternaltransactionsinformationthathasnotbeeneliminatedbyignoringalltheinternaltransactionswithintheaccountingentityanditslowerentities,androlluptheremaininginternaltransactionswithoutaggregation.Theinternaltransactiondatafileisakeyinputtotheconsolidationprocess.F1InternaltransactiondatafileP2ProduceinternaltransactionsdatafileP1Forinternaltransactions,entercustomer/suppliercodeTransactionDBT4InternalTransactionP13ExportremaininginternaltransactionInternaltransactionreports&queriesP5Query,view,printInternaltransactiondatafileImportinternaltransactionsT5AccountpairsTABLESTRUCTUREF5-ConsolidationAccountpairSourceacctcodeCounterpartacctcodeT2EliminationFILEFORMAT&TABLESTRUCTUREF1/T4InternaltransactiondataPeriodCounterpartcodeSourceentitycodedebitBegbalcreditdebitMovementcreditdebitEndBalcreditAccountcode25F2-DisclosureandIASsupportdatafileandassociatedprocessesP3ThedisclosuredataandIASsupportingdatawillberecordedtothespecialdisclosuretable(T1).Thispurposeofthistableistocollectdatathatcannotbederivedfromaccountbalances,e.g.UOPvsstraightlinedepreciationinIASadjustment.Althoughdifferentdisclosuretypesarerequiredfordifferenttransactiontypes,thesystemwillusethesametabletostorethedata.Eachfieldinthetablehasdifferentmeaningfordifferentdisclosuretype.Thedisclosuretypesarepre-definedbyPetroChinaheadquarterandclearinstructionstotheaccountingentitiesneedtobegivenaboutwhichdisclosuretypesmustbefilledoutbyeachaccountingentity.FMISshouldbeenhancedto“understand”thedifferentdisclosuretypeandforeachdisclosuretype,thesystemneedstobeabletodisplayaspecialinputscreenforthedisclosuretypetopreventwrongentrytobemadetothedisclosuredatabase.P4AllrecordeddisclosuredataandIASsupportdatawillbeexportedtoafileandsentup.Thefileisthenimportedtoreportingsystem(P20)andstoredinthereportdatabase.P9UsersreviewtheIASsupportingdatainreportingsystemtoproducetheIASadjustmententries.P14AlldetailsofdisclosureandIASsupportingdatareceivedfromlowerlevelinreportingsystemwillbeexportedandsentuptohigherlevelwithoutaggregation.Thisfileisdesignedtocollectnon-ledgerdataforPRC&IASdisclosuresandsupportingdataforusertodoIASadjustment.REPORTINGSYSTEMLowerlevelReportsP14Exportdisclosures&IASsupportingdataDisclosure&IASsupportingdatafilesP9QueryIASadjustmentdataIASadjustmentinforeportsTRANSACTIONSYSTEMT1SpecialdisclosureitemsF2Disclosure&IASsupportingdatafilesP4ProducespecialdisclosureitemsreportP3Enterspecialdisclosure&IASsupportdataP20Importdisclosure&IASsupportFILEFORMAT&TABLESTRUCTUREF2/T1DisclosuresandIASsupportingdataUser-definednum1(number)User-definednum2(number)Disclosurecode…num6User-definedchar1(char.)User-definedchar2(char)….char6(char)Businessentitycode26F3-EliminationdatafileandassociatedprocessesP6Thisfunctionletsusersentereliminationentriestotheeliminationtable.Theentrieswillbecheckedandpostedifapproved.Iftheentriesarenotapproved,usercanmodifyitpriortoposting.P8Theeliminationentrieswillbeusedinconsolidationatthevariouslevels(See7.Systemprocessesforconsolidationandreporting).Toalloweliminationathigherlevels,F3filewillbeexportedandsentuptohigherlevelwithoutanyaggregation.Note:thebusinessentitycodeinthistablereferstothebusinessentitywhichcreatetheeliminationentry.Eliminationentriesareinputandrolledupinconsolidationindifferentlevel.REPORTINGSYSTEMT2EliminationEliminationEntriesInternaltransactionreports&queriesAnalyzeinfoanddeterminerequiredeliminationP8ExportEliminationentriesF3EliminationdatafileP6EnterEliminationEntriesF3EliminationdatafileImportEliminationEntriesFILEFORMAT-F3-EliminationdataTABLESTRUCTURE-T2EliminationDescriptionCreditamountAccountcodeDebitamountPeriodBusinessentitycodeP5Query,view,print27F4-IASadjustmententryfileandassociatedprocessesP10.TheusercreatesIASadjustmententriesbasedonanalysisofIASadjustmentsupportingdataandtheninputsthedatatoIASadjustmententrytable(T3)inthereportingsystem.Theentrieswillbecheckedbyapproverandiftheyarecorrect,theywillbepostedtodisablefurtherchange.Iftheyarenot,itwillbemodifiedandrechecked.P12.IASadjustmententriesareexportedandrolledupwithoutaggregationtothehigherlevels.TheentrieswillbeusedinIASreporting,basicallyonthehighestlevelsinthecorporationontheoriginallevelTheIASadjustmentfilecollectsdatatofulfillIASadjustmentindifferentlevelandrollituptothecorporatelevelREPORTINGSYSTEMT3IASadj.IASadj.EntriesP12ExportIASadj.entriesF4IASadj.datafileP10EnterIASadj.EntriesF4IASadj.datafileIASreportingprocessAnalyzeinfoanddeterminerequiredIASadjustmentIASadjustmentinforeportsF3/T2IASAdjustmentEntriesFILEFORMAT&TABLESTRUCTUREDescriptionCreditamountAccountcodeDebitamountPeriodBusinessentitycode28SystemprocessesforconsolidationandreportingChapter729P9-EliminationprocessandPRCreportingTheeliminationprocessinvolvestwosteps:1)Eliminationentrypreparation-includesstepP6&P8.Thisstephasbeendescribedearlierinthisdocument2)Performtheeliminationofinternaltransactions-stepP7TheresultoftheeliminationprocessisaLedgerreportadjustedbyeliminatingtheeffectofinternaltransactions.Eliminationentryrecorddefinitionis:(accountcode,entrydescript