Escrituração Fiscal Digital: SPED – Usando o componente AcBrSpedFiscal - Parte 4

Nesta série de artigos, vamos ver um pequeno tutorial demonstrando o método de uso do componente AcBrSpedFiscal para gerar o arquivo EFD - Escrituração discal digital do SPED.

Nesta última parte do artigo, veremos o arquivo EFD do SPED gerado pelo exemplo do tutorial. Através deste podemos ter uma ideia da estrutura correta do arquivo, bastando agora, apenas selecionar os dados do banco de dados e repassar ao componente, para que o mesmo gere este arquivo de forma a ser validada pelo aplicativo de validação que poderá ser encontrado aqui.

Segue abaixo o arquivo gerado:

|0000|004|0|26012011|26012011|RAZAO SOCIAL DO INFORMANTE| |12345678901|RJ|0000000000|1234567|||A|1| |0001|0| |0005|NOME FANTASSIA DA EMPRESA|21000000|RUA PRINCIPAL|S/N| |CENTRO|0000000000|0000000000|email@empresa.net| |0100|NOME DO CONTADOR|12345678900|123456||00000000|||| |0000000000|0000000000||3200607| |0150|000001|RAZAO SOCIAL DO CLIENTE|001|12345678000123|| |0000001||ENDERECO||COMPL|BAIRRO| |0190|UN|Descricao unidade| |0200|000001|DESCRIÇÃO DO ITEM 000001|0000000000001||UN|00|||||18,00| |0200|000002|DESCRIÇÃO DO ITEM 000002|0000000000002||UN|00|||||18,00| |0200|000003|DESCRIÇÃO DO ITEM 000003|0000000000003||UN|00|||||18,00| |0200|000004|DESCRIÇÃO DO ITEM 000004|0000000000004||UN|00|||||18,00| |0200|000005|DESCRIÇÃO DO ITEM 000005|0000000000005||UN|00|||||18,00| |0200|000006|DESCRIÇÃO DO ITEM 000006|0000000000006||UN|00|||||18,00| |0990|13| |C001|0| |C100|0|0|000001|01|00||000001||26012011|26012011|0,00|9|0,00|0,00|0,00|9|0,00|0,00 |0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |C170|001|000001|Descricao do item 000001|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|002|000002|Descricao do item 000002|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|003|000003|Descricao do item 000003|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|004|000004|Descricao do item 000004|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|005|000005|Descricao do item 000005|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|006|000006|Descricao do item 000006|1|UN|10,00|0,00|1|000|5102||10,00|18,00 |1,80|0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C190|000|5102|18,00|60,00|60,00|10,80|0,00|0,00|0,00|0,00|| |C100|0|0|000001|01|00||000002||26012011|26012011|0,00|9|0,00|0,00|0,00|9|0,00|0,00 |0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |C170|001|000001|Descricao do item 000001|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|002|000002|Descricao do item 000002|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|003|000003|Descricao do item 000003|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|004|000004|Descricao do item 000004|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|005|000005|Descricao do item 000005|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|006|000006|Descricao do item 000006|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C190|000|5102|18,00|60,00|60,00|10,80|0,00|0,00|0,00|0,00|| |C100|0|0|000001|01|00||000003||26012011|26012011|0,00|9|0,00|0,00|0,00|9|0,00|0,00|0,00| 0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |C170|001|000001|Descricao do item 000001|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|002|000002|Descricao do item 000002|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|003|000003|Descricao do item 000003|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|004|000004|Descricao do item 000004|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|005|000005|Descricao do item 000005|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|006|000006|Descricao do item 000006|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C190|000|5102|18,00|60,00|60,00|10,80|0,00|0,00|0,00|0,00|| |C100|0|0|000001|01|00||000004||26012011|26012011|0,00|9|0,00|0,00|0,00|9|0,00|0,00|0,00| 0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |C170|001|000001|Descricao do item 000001|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|002|000002|Descricao do item 000002|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|003|000003|Descricao do item 000003|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|004|000004|Descricao do item 000004|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|005|000005|Descricao do item 000005|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|006|000006|Descricao do item 000006|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C190|000|5102|18,00|60,00|60,00|10,80|0,00|0,00|0,00|0,00|| |C100|0|0|000001|01|00||000005||26012011|26012011|0,00|9|0,00|0,00|0,00|9|0,00|0,00|0,00| 0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |C170|001|000001|Descricao do item 000001|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|002|000002|Descricao do item 000002|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|003|000003|Descricao do item 000003|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|004|000004|Descricao do item 000004|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|005|000005|Descricao do item 000005|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|006|000006|Descricao do item 000006|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C190|000|5102|18,00|60,00|60,00|10,80|0,00|0,00|0,00|0,00|| |C100|0|0|000001|01|00||000006||26012011|26012011|0,00|9|0,00|0,00|0,00|9|0,00|0,00|0,00| 0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |C170|001|000001|Descricao do item 000001|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|002|000002|Descricao do item 000002|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80 |0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|003|000003|Descricao do item 000003|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|004|000004|Descricao do item 000004|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|005|000005|Descricao do item 000005|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C170|006|000006|Descricao do item 000006|1|UN|10,00|0,00|1|000|5102||10,00|18,00|1,80| 0,00|0,00|0,00|0|02||0,00|0,00|0,00|99|0,00|0,00|0|0|0,00|99|0,00|0,00|0|0|0,00|000| |C190|000|5102|18,00|60,00|60,00|10,80|0,00|0,00|0,00|0,00|| |C990|50| |D001|1| |D990|2| |E001|0| |E100|26012011|26012011| |E110|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00|0,00| |E990|4| |G001|1| |G990|2| |H001|0| |H005|26012011|1000,00| |H010|000001|UN|1,00|100,00|100,00|0|||| |H010|000002|UN|1,00|100,00|100,00|0|||| |H010|000003|UN|1,00|100,00|100,00|0|||| |H010|000004|UN|1,00|100,00|100,00|0|||| |H010|000005|UN|1,00|100,00|100,00|0|||| |H010|000006|UN|1,00|100,00|100,00|0|||| |H990|9| |1001|1| |1990|2| |9001|0| |9900|0000|1| |9900|0001|1| |9900|0005|1| |9900|0100|1| |9900|0150|1| |9900|0190|1| |9900|0200|6| |9900|0990|1| |9900|C001|1| |9900|C100|6| |9900|C170|36| |9900|C190|6| |9900|C990|1| |9900|D001|1| |9900|D990|1| |9900|E001|1| |9900|E100|1| |9900|E110|1| |9900|E990|1| |9900|G001|1| |9900|G990|1| |9900|H001|1| |9900|H005|1| |9900|H010|6| |9900|H990|1| |9900|1001|1| |9900|1990|1| |9900|9001|1| |9900|9900|31| |9900|9990|1| |9900|9999|1| |9990|34| |9999|116|

Obviamente não conseguiremos validar estas informações, pois as mesmas são fictícias, mas ao passar o arquivo gerado pelo validador, observe que o mesmo não encontrará erros de estrutura.

Com isso concluímos este artigo. Espero que seja útil para quem está começando neste modulo do SPED.

Demais posts desta série:

Artigos relacionados