Modelo de dados para SPED baseado em XBRL GL

Detalhes bibliográficos
Autor(a) principal: LUCIANO, José Geraldo
Data de Publicação: 2015
Tipo de documento: Dissertação
Idioma: por
Título da fonte: Biblioteca Digital de Teses e Dissertações da UNIFACS
Texto Completo: http://teste.tede.unifacs.br:8080/tede/handle/tede/428
Resumo: The project SPED (Public Digital Bookkeeping System) has been leading to significant changes in the financial processes and relationships between companies, software developers, accounting firms and regulatory government agencies. It is a new fiscal paradigm which has brought significant changes in business routines. Currently, the SPED project consists of twelve projects: NF-e (Electronic Invoice), CT-e (Electronic Freight), NFS-e (Electronic Invoice Services), EFD-Fiscal Sped, EFD-Contributions, ECF-Fiscal Accounting Bookkeeping, FCONT-Bookkeeping Balance Sheet and Profit, ECD-Bookkeeping Digital, NFC-e (Electronic Invoice Consumer), MDF-e (Electronic Manifest Fiscal Documents), e-Social and e-Financial. Seven of these projects generate their transactional files in XML format. Others of them generate their transactional files in ASCII standard text format. Besides the absence of a pattern in the data representation it was found duplicate concepts over conceptual structures of each project. The lack of standardization affects the IT area affecting the interoperability between systems. In this context, it causes an increase in the cost of development and maintenance of systems, as well the development of various interfaces to solve the problem of interoperability and the low quality of data. Consequently, this affects business area since the information is inaccurate and it’s not always available. This scenario has become an obstacle for the implementation of audit procedures. This paper presents, as a effort to standardization, the development of a data model for SPED based on XBRL GL, which is called XBRL SPED taxonomy. To create this taxonomy is presented a process model for its development. It is expected that the proposed model allows organizations can have: (i) easier generating and transparency of information; (ii) increasing flexibility and exchange of information between the entities covered by the project, i.e. government and society, (iii) so do interoperability between SPED projects as well; (iv) facility over validation and consolidation of data according to the rules imposed on each project; (v) support continuous auditing processes and monitoring of the database and documents produced. This possibilities may be important contributions to software application developers. To evaluate the proposed data model an example of this taxonomy is presented , in which a simulation is done over files produced by SPED projects. The used example allowed infer that the proposal objectives have been achieved.
id UNIF_38386c9c733b68724eace426dc333e2f
oai_identifier_str oai:teste.tede.unifacs.br:tede/428
network_acronym_str UNIF
network_name_str Biblioteca Digital de Teses e Dissertações da UNIFACS
repository_id_str
spelling SILVA, Paulo Caetano daPERES, ClóvisVASARHELYI, Miklos A.FERNANDES, Sérgio MartinsLUCIANO, José Geraldo2017-05-26T18:52:01Z2015-05-25LUCIANO, José Geraldo. Modelo de dados para SPED baseado em XBRL GL. 2015. 134 f. il. Dissertação (Sistemas e Computação) - UNIFACS Universidade Salvador, Salvador.http://teste.tede.unifacs.br:8080/tede/handle/tede/428The project SPED (Public Digital Bookkeeping System) has been leading to significant changes in the financial processes and relationships between companies, software developers, accounting firms and regulatory government agencies. It is a new fiscal paradigm which has brought significant changes in business routines. Currently, the SPED project consists of twelve projects: NF-e (Electronic Invoice), CT-e (Electronic Freight), NFS-e (Electronic Invoice Services), EFD-Fiscal Sped, EFD-Contributions, ECF-Fiscal Accounting Bookkeeping, FCONT-Bookkeeping Balance Sheet and Profit, ECD-Bookkeeping Digital, NFC-e (Electronic Invoice Consumer), MDF-e (Electronic Manifest Fiscal Documents), e-Social and e-Financial. Seven of these projects generate their transactional files in XML format. Others of them generate their transactional files in ASCII standard text format. Besides the absence of a pattern in the data representation it was found duplicate concepts over conceptual structures of each project. The lack of standardization affects the IT area affecting the interoperability between systems. In this context, it causes an increase in the cost of development and maintenance of systems, as well the development of various interfaces to solve the problem of interoperability and the low quality of data. Consequently, this affects business area since the information is inaccurate and it’s not always available. This scenario has become an obstacle for the implementation of audit procedures. This paper presents, as a effort to standardization, the development of a data model for SPED based on XBRL GL, which is called XBRL SPED taxonomy. To create this taxonomy is presented a process model for its development. It is expected that the proposed model allows organizations can have: (i) easier generating and transparency of information; (ii) increasing flexibility and exchange of information between the entities covered by the project, i.e. government and society, (iii) so do interoperability between SPED projects as well; (iv) facility over validation and consolidation of data according to the rules imposed on each project; (v) support continuous auditing processes and monitoring of the database and documents produced. This possibilities may be important contributions to software application developers. To evaluate the proposed data model an example of this taxonomy is presented , in which a simulation is done over files produced by SPED projects. The used example allowed infer that the proposal objectives have been achieved.O projeto SPED (Sistema Público de Escrituração Digital) tem provocado mudanças significativas nos processos e nas relações entre as empresas, desenvolvedores de softwares, escritórios contábeis e os órgãos governamentais reguladores. Trata-se de um novo paradigma fiscal que traz mudanças significativas na rotina das empresas. Atualmente, o projeto SPED é composto por doze projetos: Sped Contábil, Sped Fiscal, CT-e, NF-e, FCont, NFS-e, EFD-Contribuições, ECF, NFC-e, MDF-e, e-Social e e-Financeira. Sete destes projetos geram seus arquivos transacionais no formato XML. Os demais geram seus arquivos transacionais no formato texto padrão ASCII. Além da ausência de um padrão de representação de dados apurou-se a existência de duplicação de conceitos entre as estruturas conceituais de cada projeto. A falta de padronização afeta a área de TI comprometendo a interoperabilidade entre sistemas. Neste contexto, provoca aumento no custo do desenvolvimento e manutenção de sistemas, o desenvolvimento de várias interfaces para solucionar o problema da interoperabilidade e a baixa qualidade de dados. Consequentemente, afeta área de negócios já que as informações são imprecisas e nem sempre disponíveis. Esse cenário é um entrave para a aplicação dos processos de auditoria. Esse trabalho apresenta, como um esforço de padronização dos dados, o desenvolvimento de um modelo de dados para o SPED baseado em XBRL GL: a taxonomia SPEDXBRL. Para a criação da taxonomia foi apresentado um modelo de processo para o seu desenvolvimento. Espera-se, que o modelo proposto permita que as organizações tenham: uma maior facilidade na geração e transparência das informações; maior flexibilidade e intercâmbio de informações entre as entidades abrangidas pelo projeto, i.e., governo e sociedade; maior interoperabilidade entre os projetos do SPED; maior facilidade na validação e consolidação dos dados de acordo com as regras impostas a cada projeto; suporte aos processos de auditoria e monitoramento contínuos sobre a base de dados e documentos produzidos; o que podem ser contribuições importantes aos desenvolvedores de softwares aplicativos. Para se avaliar o modelo de dados proposto foi feito um exemplo de uso da taxonomia a partir da simulação de relatórios produzidos pelos projetos do SPED o que permitiu inferir que os objetivos da proposta foram alcançados.Submitted by Roseli Araujo (roseli.araujo@unifacs.br) on 2017-05-26T18:52:00Z No. of bitstreams: 1 Dissertação JOSÉ GERALDO LUCIANO 2015.pdf: 6810819 bytes, checksum: f698154ba1863db0e07360eb1acff286 (MD5)Made available in DSpace on 2017-05-26T18:52:01Z (GMT). No. of bitstreams: 1 Dissertação JOSÉ GERALDO LUCIANO 2015.pdf: 6810819 bytes, checksum: f698154ba1863db0e07360eb1acff286 (MD5) Previous issue date: 2015-05-25application/pdfporUniversidade SalvadorSistemas e ComputaçãoUNIFACSBrasilSistemas e ComputaçãoSPEDXBRLXBRL GTaxonomiaCiência da ComputaçãoModelo de dados para SPED baseado em XBRL GLinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisinfo:eu-repo/semantics/openAccessreponame:Biblioteca Digital de Teses e Dissertações da UNIFACSinstname:Universidade Salvador (UNIFACS)instacron:UNIFACSORIGINALDissertação JOSÉ GERALDO LUCIANO 2015.pdfDissertação JOSÉ GERALDO LUCIANO 2015.pdfapplication/pdf6810819http://teste.tede.unifacs.br:8080/tede/bitstream/tede/428/2/Disserta%C3%A7%C3%A3o+JOS%C3%89+GERALDO+LUCIANO+2015.pdff698154ba1863db0e07360eb1acff286MD52LICENSElicense.txtlicense.txttext/plain; charset=utf-82165http://teste.tede.unifacs.br:8080/tede/bitstream/tede/428/1/license.txtbd3efa91386c1718a7f26a329fdcb468MD51tede/4282017-05-26 15:52:01.435oai:teste.tede.unifacs.br:tede/428Tk9UQTogQ09MT1FVRSBBUVVJIEEgU1VBIFBSw5NQUklBIExJQ0VOw4dBCkVzdGEgbGljZW7Dp2EgZGUgZXhlbXBsbyDDqSBmb3JuZWNpZGEgYXBlbmFzIHBhcmEgZmlucyBpbmZvcm1hdGl2b3MuCgpMSUNFTsOHQSBERSBESVNUUklCVUnDh8ODTyBOw4NPLUVYQ0xVU0lWQQoKQ29tIGEgYXByZXNlbnRhw6fDo28gZGVzdGEgbGljZW7Dp2EsIHZvY8OqIChvIGF1dG9yIChlcykgb3UgbyB0aXR1bGFyIGRvcyBkaXJlaXRvcyBkZSBhdXRvcikgY29uY2VkZSDDoCBVbml2ZXJzaWRhZGUgClhYWCAoU2lnbGEgZGEgVW5pdmVyc2lkYWRlKSBvIGRpcmVpdG8gbsOjby1leGNsdXNpdm8gZGUgcmVwcm9kdXppciwgIHRyYWR1emlyIChjb25mb3JtZSBkZWZpbmlkbyBhYmFpeG8pLCBlL291IApkaXN0cmlidWlyIGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyAoaW5jbHVpbmRvIG8gcmVzdW1vKSBwb3IgdG9kbyBvIG11bmRvIG5vIGZvcm1hdG8gaW1wcmVzc28gZSBlbGV0csO0bmljbyBlIAplbSBxdWFscXVlciBtZWlvLCBpbmNsdWluZG8gb3MgZm9ybWF0b3Mgw6F1ZGlvIG91IHbDrWRlby4KClZvY8OqIGNvbmNvcmRhIHF1ZSBhIFNpZ2xhIGRlIFVuaXZlcnNpZGFkZSBwb2RlLCBzZW0gYWx0ZXJhciBvIGNvbnRlw7pkbywgdHJhbnNwb3IgYSBzdWEgdGVzZSBvdSBkaXNzZXJ0YcOnw6NvIApwYXJhIHF1YWxxdWVyIG1laW8gb3UgZm9ybWF0byBwYXJhIGZpbnMgZGUgcHJlc2VydmHDp8Ojby4KClZvY8OqIHRhbWLDqW0gY29uY29yZGEgcXVlIGEgU2lnbGEgZGUgVW5pdmVyc2lkYWRlIHBvZGUgbWFudGVyIG1haXMgZGUgdW1hIGPDs3BpYSBhIHN1YSB0ZXNlIG91IApkaXNzZXJ0YcOnw6NvIHBhcmEgZmlucyBkZSBzZWd1cmFuw6dhLCBiYWNrLXVwIGUgcHJlc2VydmHDp8Ojby4KClZvY8OqIGRlY2xhcmEgcXVlIGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyDDqSBvcmlnaW5hbCBlIHF1ZSB2b2PDqiB0ZW0gbyBwb2RlciBkZSBjb25jZWRlciBvcyBkaXJlaXRvcyBjb250aWRvcyAKbmVzdGEgbGljZW7Dp2EuIFZvY8OqIHRhbWLDqW0gZGVjbGFyYSBxdWUgbyBkZXDDs3NpdG8gZGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyBuw6NvLCBxdWUgc2VqYSBkZSBzZXUgCmNvbmhlY2ltZW50bywgaW5mcmluZ2UgZGlyZWl0b3MgYXV0b3JhaXMgZGUgbmluZ3XDqW0uCgpDYXNvIGEgc3VhIHRlc2Ugb3UgZGlzc2VydGHDp8OjbyBjb250ZW5oYSBtYXRlcmlhbCBxdWUgdm9jw6ogbsOjbyBwb3NzdWkgYSB0aXR1bGFyaWRhZGUgZG9zIGRpcmVpdG9zIGF1dG9yYWlzLCB2b2PDqiAKZGVjbGFyYSBxdWUgb2J0ZXZlIGEgcGVybWlzc8OjbyBpcnJlc3RyaXRhIGRvIGRldGVudG9yIGRvcyBkaXJlaXRvcyBhdXRvcmFpcyBwYXJhIGNvbmNlZGVyIMOgIFNpZ2xhIGRlIFVuaXZlcnNpZGFkZSAKb3MgZGlyZWl0b3MgYXByZXNlbnRhZG9zIG5lc3RhIGxpY2Vuw6dhLCBlIHF1ZSBlc3NlIG1hdGVyaWFsIGRlIHByb3ByaWVkYWRlIGRlIHRlcmNlaXJvcyBlc3TDoSBjbGFyYW1lbnRlIAppZGVudGlmaWNhZG8gZSByZWNvbmhlY2lkbyBubyB0ZXh0byBvdSBubyBjb250ZcO6ZG8gZGEgdGVzZSBvdSBkaXNzZXJ0YcOnw6NvIG9yYSBkZXBvc2l0YWRhLgoKQ0FTTyBBIFRFU0UgT1UgRElTU0VSVEHDh8ODTyBPUkEgREVQT1NJVEFEQSBURU5IQSBTSURPIFJFU1VMVEFETyBERSBVTSBQQVRST0PDjU5JTyBPVSAKQVBPSU8gREUgVU1BIEFHw4pOQ0lBIERFIEZPTUVOVE8gT1UgT1VUUk8gT1JHQU5JU01PIFFVRSBOw4NPIFNFSkEgQSBTSUdMQSBERSAKVU5JVkVSU0lEQURFLCBWT0PDiiBERUNMQVJBIFFVRSBSRVNQRUlUT1UgVE9ET1MgRSBRVUFJU1FVRVIgRElSRUlUT1MgREUgUkVWSVPDg08gQ09NTyAKVEFNQsOJTSBBUyBERU1BSVMgT0JSSUdBw4fDlUVTIEVYSUdJREFTIFBPUiBDT05UUkFUTyBPVSBBQ09SRE8uCgpBIFNpZ2xhIGRlIFVuaXZlcnNpZGFkZSBzZSBjb21wcm9tZXRlIGEgaWRlbnRpZmljYXIgY2xhcmFtZW50ZSBvIHNldSBub21lIChzKSBvdSBvKHMpIG5vbWUocykgZG8ocykgCmRldGVudG9yKGVzKSBkb3MgZGlyZWl0b3MgYXV0b3JhaXMgZGEgdGVzZSBvdSBkaXNzZXJ0YcOnw6NvLCBlIG7Do28gZmFyw6EgcXVhbHF1ZXIgYWx0ZXJhw6fDo28sIGFsw6ltIGRhcXVlbGFzIApjb25jZWRpZGFzIHBvciBlc3RhIGxpY2Vuw6dhLgo=Biblioteca Digital de Teses e Dissertaçõeshttp://tede.unifacs.br/http://tede.unifacs.br:8080/oai/requestbibliotecadigital@unifacs.br||bibliotecadigital@unifacs.bropendoar:2017-05-26T18:52:01Biblioteca Digital de Teses e Dissertações da UNIFACS - Universidade Salvador (UNIFACS)false
dc.title.por.fl_str_mv Modelo de dados para SPED baseado em XBRL GL
title Modelo de dados para SPED baseado em XBRL GL
spellingShingle Modelo de dados para SPED baseado em XBRL GL
LUCIANO, José Geraldo
SPED
XBRL
XBRL G
Taxonomia
Ciência da Computação
title_short Modelo de dados para SPED baseado em XBRL GL
title_full Modelo de dados para SPED baseado em XBRL GL
title_fullStr Modelo de dados para SPED baseado em XBRL GL
title_full_unstemmed Modelo de dados para SPED baseado em XBRL GL
title_sort Modelo de dados para SPED baseado em XBRL GL
author LUCIANO, José Geraldo
author_facet LUCIANO, José Geraldo
author_role author
dc.contributor.advisor1.fl_str_mv SILVA, Paulo Caetano da
dc.contributor.referee1.fl_str_mv PERES, Clóvis
dc.contributor.referee2.fl_str_mv VASARHELYI, Miklos A.
dc.contributor.referee3.fl_str_mv FERNANDES, Sérgio Martins
dc.contributor.author.fl_str_mv LUCIANO, José Geraldo
contributor_str_mv SILVA, Paulo Caetano da
PERES, Clóvis
VASARHELYI, Miklos A.
FERNANDES, Sérgio Martins
dc.subject.por.fl_str_mv SPED
XBRL
XBRL G
Taxonomia
topic SPED
XBRL
XBRL G
Taxonomia
Ciência da Computação
dc.subject.cnpq.fl_str_mv Ciência da Computação
description The project SPED (Public Digital Bookkeeping System) has been leading to significant changes in the financial processes and relationships between companies, software developers, accounting firms and regulatory government agencies. It is a new fiscal paradigm which has brought significant changes in business routines. Currently, the SPED project consists of twelve projects: NF-e (Electronic Invoice), CT-e (Electronic Freight), NFS-e (Electronic Invoice Services), EFD-Fiscal Sped, EFD-Contributions, ECF-Fiscal Accounting Bookkeeping, FCONT-Bookkeeping Balance Sheet and Profit, ECD-Bookkeeping Digital, NFC-e (Electronic Invoice Consumer), MDF-e (Electronic Manifest Fiscal Documents), e-Social and e-Financial. Seven of these projects generate their transactional files in XML format. Others of them generate their transactional files in ASCII standard text format. Besides the absence of a pattern in the data representation it was found duplicate concepts over conceptual structures of each project. The lack of standardization affects the IT area affecting the interoperability between systems. In this context, it causes an increase in the cost of development and maintenance of systems, as well the development of various interfaces to solve the problem of interoperability and the low quality of data. Consequently, this affects business area since the information is inaccurate and it’s not always available. This scenario has become an obstacle for the implementation of audit procedures. This paper presents, as a effort to standardization, the development of a data model for SPED based on XBRL GL, which is called XBRL SPED taxonomy. To create this taxonomy is presented a process model for its development. It is expected that the proposed model allows organizations can have: (i) easier generating and transparency of information; (ii) increasing flexibility and exchange of information between the entities covered by the project, i.e. government and society, (iii) so do interoperability between SPED projects as well; (iv) facility over validation and consolidation of data according to the rules imposed on each project; (v) support continuous auditing processes and monitoring of the database and documents produced. This possibilities may be important contributions to software application developers. To evaluate the proposed data model an example of this taxonomy is presented , in which a simulation is done over files produced by SPED projects. The used example allowed infer that the proposal objectives have been achieved.
publishDate 2015
dc.date.issued.fl_str_mv 2015-05-25
dc.date.accessioned.fl_str_mv 2017-05-26T18:52:01Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.citation.fl_str_mv LUCIANO, José Geraldo. Modelo de dados para SPED baseado em XBRL GL. 2015. 134 f. il. Dissertação (Sistemas e Computação) - UNIFACS Universidade Salvador, Salvador.
dc.identifier.uri.fl_str_mv http://teste.tede.unifacs.br:8080/tede/handle/tede/428
identifier_str_mv LUCIANO, José Geraldo. Modelo de dados para SPED baseado em XBRL GL. 2015. 134 f. il. Dissertação (Sistemas e Computação) - UNIFACS Universidade Salvador, Salvador.
url http://teste.tede.unifacs.br:8080/tede/handle/tede/428
dc.language.iso.fl_str_mv por
language por
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.publisher.none.fl_str_mv Universidade Salvador
dc.publisher.program.fl_str_mv Sistemas e Computação
dc.publisher.initials.fl_str_mv UNIFACS
dc.publisher.country.fl_str_mv Brasil
dc.publisher.department.fl_str_mv Sistemas e Computação
publisher.none.fl_str_mv Universidade Salvador
dc.source.none.fl_str_mv reponame:Biblioteca Digital de Teses e Dissertações da UNIFACS
instname:Universidade Salvador (UNIFACS)
instacron:UNIFACS
instname_str Universidade Salvador (UNIFACS)
instacron_str UNIFACS
institution UNIFACS
reponame_str Biblioteca Digital de Teses e Dissertações da UNIFACS
collection Biblioteca Digital de Teses e Dissertações da UNIFACS
bitstream.url.fl_str_mv http://teste.tede.unifacs.br:8080/tede/bitstream/tede/428/2/Disserta%C3%A7%C3%A3o+JOS%C3%89+GERALDO+LUCIANO+2015.pdf
http://teste.tede.unifacs.br:8080/tede/bitstream/tede/428/1/license.txt
bitstream.checksum.fl_str_mv f698154ba1863db0e07360eb1acff286
bd3efa91386c1718a7f26a329fdcb468
bitstream.checksumAlgorithm.fl_str_mv MD5
MD5
repository.name.fl_str_mv Biblioteca Digital de Teses e Dissertações da UNIFACS - Universidade Salvador (UNIFACS)
repository.mail.fl_str_mv bibliotecadigital@unifacs.br||bibliotecadigital@unifacs.br
_version_ 1800393064324268032