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

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.

imagem

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

Demais posts desta série: