# Layout para Importação de Pedidos

<span style="color: rgb(0, 0, 0); font-family: Arial; font-size: small;">**PEDIDOS**</span>

<span style="color: rgb(0, 0, 0);"><span style="font-family: Arial; font-size: small;">**Importante:** A primeria linha do arquivo deverá conter o nome dos campos\* do layout separados pelo caracter '|'. Por Exemplo:  
</span><span style="font-family: Arial; font-size: small;">"Abrev|Modelo|NumPedido|NumeroCli|...."</span></span>

<table border="0" cellspacing="0" id="bkmrk-id-campo-tipo-tamanh"><colgroup width="46"></colgroup> <colgroup width="136"></colgroup> <colgroup width="58"></colgroup> <colgroup width="73"></colgroup> <colgroup width="671"></colgroup><tbody><tr><td align="center" height="17" valign="top"><span style="color: #000000;">ID</span></td><td align="center" valign="top"><span style="color: #000000;">CAMPO</span></td><td align="center" valign="top"><span style="color: #000000;">TIPO</span></td><td align="center" valign="top"><span style="color: #000000;">TAMANHO</span></td><td align="center" valign="top"><span style="color: #000000;">DESCRIÇÃO</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">1</span></td><td align="center" valign="top"><span style="color: #000000;">Abrev</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">8</span></td><td align="left" valign="top"><span style="color: #000000;">Informar o nome abreviado da empresa (maiúsculas, Obrigatório)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">2</span></td><td align="center" valign="top"><span style="color: #000000;">Modelo</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">2</span></td><td align="left" valign="top"><span style="color: #000000;">Informar sempre PE (Obrigatório)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">3</span></td><td align="center" valign="top"><span style="color: #000000;">NumPedido</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">6</span></td><td align="left" valign="top"><span style="color: #000000;">Número do pedido (Alinhado a direita com espaços em branco, Obrigatório)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">4</span></td><td align="center" valign="top"><span style="color: #000000;">NumeroCli</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">18</span></td><td align="left" valign="top"><span style="color: #000000;">[CGC/CNPJ/CPF do Cliente (Deve estar cadastrado em Manutenção/Clientes, Obrigatório)](https://help.supersoftservice.com.br/VD/paginas/CadastrandoClientes.htm)</span></td></tr><tr><td align="center" height="49" valign="top"><span style="color: #000000;">5</span></td><td align="center" valign="top"><span style="color: #000000;">CodCondPag</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">3</span></td><td align="left" valign="top"><span style="color: #000000;">Código da condição de pagamento (Alinhado a direita com espaços em branco,Deve estar cadastrado em Manutenção/Tabelas/Condição de Pagamento, Obrigatório se em Manutenção/Empresa/Parâmetros Adicionais da Empresa não estiver marcado a opção de Aceita pedidos sem condição de pagamento).</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">6</span></td><td align="center" valign="top"><span style="color: #000000;">ValorTotal</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total do pedido (Obrigatório)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">7</span></td><td align="center" valign="top"><span style="color: #000000;">PorceDesconto</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Porcentagem de desconto sobre o total do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">8</span></td><td align="center" valign="top"><span style="color: #000000;">ValorDesconto</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor de desconto sobre o total do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">9</span></td><td align="center" valign="top"><span style="color: #000000;">TipoDesconto</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Tipo de desconto sobre o total do pedido (\[P\] Porcentagem ou \[V\] Valor)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">10</span></td><td align="center" valign="top"><span style="color: #000000;">DataEmissao</span></td><td align="center" valign="top"><span style="color: #000000;">D</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Data de emissão do pedido (Obrigatório)</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">11</span></td><td align="center" valign="top"><span style="color: #000000;">CodVendedor</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">3</span></td><td align="left" valign="top"><span style="color: #000000;">Código do vendedor (Alinhado a direita com espaços em branco, Deve estar cadastrado na tela de Manutenção/Vendedores)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">12</span></td><td align="center" valign="top"><span style="color: #000000;">Observacao1</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">13</span></td><td align="center" valign="top"><span style="color: #000000;">Observacao2</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">14</span></td><td align="center" valign="top"><span style="color: #000000;">Observacao3</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">15</span></td><td align="center" valign="top"><span style="color: #000000;">Observacao4</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">16</span></td><td align="center" valign="top"><span style="color: #000000;">Observacao5</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">17</span></td><td align="center" valign="top"><span style="color: #000000;">ValorIPI</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total do IPI do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">18</span></td><td align="center" valign="top"><span style="color: #000000;">BaseIPI</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total da base do IPI do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">19</span></td><td align="center" valign="top"><span style="color: #000000;">ValorICMS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total do ICMS do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">20</span></td><td align="center" valign="top"><span style="color: #000000;">BaseICMS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total da base do ICMS do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">21</span></td><td align="center" valign="top"><span style="color: #000000;">BaseICMRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total da base do ICMRF do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">22</span></td><td align="center" valign="top"><span style="color: #000000;">ValorProdutos</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor total dos produtos</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">23</span></td><td align="center" valign="top"><span style="color: #000000;">NumPedCli</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">20</span></td><td align="left" valign="top"><span style="color: #000000;">Número do pedido do cliente</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">24</span></td><td align="center" valign="top"><span style="color: #000000;">FretePorConta</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Frete por conta (\[E\] Emitente ou \[D\] Destinatário, Obrigatório)</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">25</span></td><td align="center" valign="top"><span style="color: #000000;">CodTransp</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">5</span></td><td align="left" valign="top"><span style="color: #000000;">Código do transportadora(Alinhado a direita com espaços em branco, Deve estar cadastrado na tela de Manutenção/Transportadoras)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">26</span></td><td align="center" valign="top"><span style="color: #000000;">Saldo</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Deve ser o total das quantidades dos itens do pedido (Obrigatório)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">27</span></td><td align="center" valign="top"><span style="color: #000000;">TransfCE</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Informar sempre N</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">28</span></td><td align="center" valign="top"><span style="color: #000000;">TransfFN</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Informar sempre N</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">29</span></td><td align="center" valign="top"><span style="color: #000000;">NumFatura</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">7</span></td><td align="left" valign="top"><span style="color: #000000;">Deixar vazio</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">30</span></td><td align="center" valign="top"><span style="color: #000000;">CodMotivo</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">3</span></td><td align="left" valign="top"><span style="color: #000000;">Código do motivo do cancelamento (Alinhado a direita com espaços em branco, Deve estar cadastrado na tela de Manutenção/Tabelas/Motivo de Cancelamentos)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">31</span></td><td align="center" valign="top"><span style="color: #000000;">Cancelado</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Se o pedido foi cancelado(\[S\] Sim ou \[N\] Não, Obrigatório)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">32</span></td><td align="center" valign="top"><span style="color: #000000;">NumPedInterno</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">20</span></td><td align="left" valign="top"><span style="color: #000000;">Número do pedido interno</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">33</span></td><td align="center" valign="top"><span style="color: #000000;">ValFrete</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor do frete</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">34</span></td><td align="center" valign="top"><span style="color: #000000;">ValSeguro</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor do Seguro</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">35</span></td><td align="center" valign="top"><span style="color: #000000;">ValOutDesp</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor de outras despesas</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">36</span></td><td align="center" valign="top"><span style="color: #000000;">AliqICMSFrete</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Porcentagem do ICMS sobre o frete</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">37</span></td><td align="center" valign="top"><span style="color: #000000;">ValICMSFrete</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor do ICMS sobre o frete</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">38</span></td><td align="center" valign="top"><span style="color: #000000;">Observ1</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">39</span></td><td align="center" valign="top"><span style="color: #000000;">Observ2</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">40</span></td><td align="center" valign="top"><span style="color: #000000;">Observ3</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">41</span></td><td align="center" valign="top"><span style="color: #000000;">Observ4</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">42</span></td><td align="center" valign="top"><span style="color: #000000;">Observ5</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">43</span></td><td align="center" valign="top"><span style="color: #000000;">Observ6</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">44</span></td><td align="center" valign="top"><span style="color: #000000;">Observ7</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">45</span></td><td align="center" valign="top"><span style="color: #000000;">Observ8</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">46</span></td><td align="center" valign="top"><span style="color: #000000;">Observ9</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">47</span></td><td align="center" valign="top"><span style="color: #000000;">Observ10</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;"> </span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">48</span></td><td align="center" valign="top"><span style="color: #000000;">Impresso</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Se o pedido já foi impresso (\[S\] Sim ou \[N\] Não, Obrigatório)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">49</span></td><td align="center" valign="top"><span style="color: #000000;">Status</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Status do pedido (\[A\] Aprovado, \[N\] Não Aprovado ou \[E\] Espera, Obrigatório)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">50</span></td><td align="center" valign="top"><span style="color: #000000;">RespStatus</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">10</span></td><td align="left" valign="top"><span style="color: #000000;">Usuário responsável pela alteração do Status</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">51</span></td><td align="center" valign="top"><span style="color: #000000;">DataStatus</span></td><td align="center" valign="top"><span style="color: #000000;">D</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Data da alteração do Status (dd/mm/aaaa)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">52</span></td><td align="center" valign="top"><span style="color: #000000;">HoraStatus</span></td><td align="center" valign="top"><span style="color: #000000;">D</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Hora da alteração do Status (hh:mm)</span></td></tr><tr><td align="center" height="28" valign="top"><span style="color: #000000;">53</span></td><td align="center" valign="top"><span style="color: #000000;">CodEndEntr</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">3</span></td><td align="left" valign="top"><span style="color: #000000;">[Código do endereço de entrega (Alinhado a direita com espaços em branco, Deve estar cadastrado em Manutenção/Clientes)](https://help.supersoftservice.com.br/VD/paginas/CadastrandoClientes.htm)</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">54</span></td><td align="center" valign="top"><span style="color: #000000;">PesoBruto</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Peso bruto total do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">55</span></td><td align="center" valign="top"><span style="color: #000000;">PesoLiquido</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Peso líquido total do pedido</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">56</span></td><td align="center" valign="top"><span style="color: #000000;">CodCont</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">3</span></td><td align="left" valign="top"><span style="color: #000000;">Deixar em branco</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">57</span></td><td align="center" valign="top"><span style="color: #000000;">NomeCont</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">50</span></td><td align="left" valign="top"><span style="color: #000000;">Deixar em branco</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">58</span></td><td align="center" valign="top"><span style="color: #000000;">DifICMSRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor devido por Substituição Tributária</span></td></tr><tr><td align="center" height="18" valign="top"><span style="color: #000000;">59</span></td><td align="center" valign="top"><span style="color: #000000;">CodMidia</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">2</span></td><td align="left" valign="top"><span style="color: #000000;">Código da mídia, alinhado com brancos a direita</span></td></tr><tr><td align="center" height="49" valign="top"><span style="color: #000000;">60</span></td><td align="center" valign="top"><span style="color: #000000;">RecSomaDAIPI</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Recalcula soma das despesas acessórias na base do IPI (Valor padrão "N"; só utilizar "S" se nos parâmetros da empresa estiver assinalada a opção "Soma as Despesas Acessórias à Base do IPI", Obrigatório)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">61</span></td><td align="center" valign="top"><span style="color: #000000;">VICMSDif</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;"> </span></td><td align="left" valign="top"><span style="color: #000000;">Valor de ICMS Diferido</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">62</span></td><td align="center" valign="top"><span style="color: #000000;">NumPedImport</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">6</span></td><td align="left" valign="top"><span style="color: #000000;">Substitui Número do Pedido do arquivo por Número gerado automaticamente e armazena Número do Pedido do arquivo em PEDIDOS</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">63</span></td><td align="center" valign="top"><span style="color: #000000;">DtCancelamento</span></td><td align="center" valign="top"><span style="color: #000000;">D</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Campo destinado a Data de Cancelamento do Pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">64</span></td><td align="center" valign="top"><span style="color: #000000;">ConsumidorFinal</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Deve ser marcado se o cliente/fornecedor do pedido é consumidor final ou não</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">65</span></td><td align="center" valign="top"><span style="color: #000000;">BasePISRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Base de Cálculo do PIS Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">66</span></td><td align="center" valign="top"><span style="color: #000000;">ValPISRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do Imposto PIS Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">67</span></td><td align="center" valign="top"><span style="color: #000000;">BaseCSLRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Base de Cálculo da Contribuição Social sobre Lucro Líquido (CSLL)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">68</span></td><td align="center" valign="top"><span style="color: #000000;">ValCSLRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Contribuição Social sobre Lucro Líquido (CSLL)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">69</span></td><td align="center" valign="top"><span style="color: #000000;">BaseCOFINSRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Base de Cálculo do Imposto Cofins Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">70</span></td><td align="center" valign="top"><span style="color: #000000;">ValCOFINSRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do Cofins Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">71</span></td><td align="center" valign="top"><span style="color: #000000;">ValIRRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do Imposto de Renda (IR) Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">72</span></td><td align="center" valign="top"><span style="color: #000000;">AliqIRRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Percentual (%) do Imposto de Renda Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">73</span></td><td align="center" valign="top"><span style="color: #000000;">AliqCOFINSRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Percentual (%) do Cofins Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">74</span></td><td align="center" valign="top"><span style="color: #000000;">AliqPISRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Percentual (%) do Pis Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">75</span></td><td align="center" valign="top"><span style="color: #000000;">AliqCSLRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Percentual (%) do CSL Retido na Fonte</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">76</span></td><td align="center" valign="top"><span style="color: #000000;">AliqISS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Percentual (%) de Imposto Sobre Serviço (ISS)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">77</span></td><td align="center" valign="top"><span style="color: #000000;">BaseISS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Base de Cálculo do Imposto Sobre Serviço (ISS)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">78</span></td><td align="center" valign="top"><span style="color: #000000;">ValISS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do Imposto Sobre Serviço (ISS)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">79</span></td><td align="center" valign="top"><span style="color: #000000;">BaseINSS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Base de Cálculo do INSS</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">80</span></td><td align="center" valign="top"><span style="color: #000000;">ValINSS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do INSS no Pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">81</span></td><td align="center" valign="top"><span style="color: #000000;">PorceINSS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Percentual (%) do INSS</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">82</span></td><td align="center" valign="top"><span style="color: #000000;">RetISS</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Informa se o pedido tem Imposto Sobre Serviço (ISS) Retido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">83</span></td><td align="center" valign="top"><span style="color: #000000;">ValServicos</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Total dos Serviços do Pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">84</span></td><td align="center" valign="top"><span style="color: #000000;">BaseIRRF</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor da Base de Cálculo do Imposto de Renda Retido na Fonte (IRRF)</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">85</span></td><td align="center" valign="top"><span style="color: #000000;">ValRetISS</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do Imposto Sobre Serviço (ISS) Retido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">86</span></td><td align="center" valign="top"><span style="color: #000000;">ValorLiquido</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Campo destinado para informar o Valor Liquido Retido do Pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">87</span></td><td align="center" valign="top"><span style="color: #000000;">INSSNota</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Campo na aba de Impostos RF, dentro de “Valores INSS” destinado ao valor do INSS no pedido</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">88</span></td><td align="center" valign="top"><span style="color: #000000;">INSSSubcontratada</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Campo na aba de Impostos RF, dentro de “Valores INSS” destinado ao valor do INSS no pedido quando for subcontratada</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">89</span></td><td align="center" valign="top"><span style="color: #000000;">INSSDevido</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Campo na aba de Impostos RF, dentro de “Valores INSS” destinado ao valor do INSS Devido no pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">90</span></td><td align="center" valign="top"><span style="color: #000000;">AltDesdobManual</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">1</span></td><td align="left" valign="top"><span style="color: #000000;">Utilizado para informar se o Pedido terá Alteração Manual de Desdobramento</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">91</span></td><td align="center" valign="top"><span style="color: #000000;">CodRegiao</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">2</span></td><td align="left" valign="top"><span style="color: #000000;">Campo destinado para informar o Código da Região </span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">92</span></td><td align="center" valign="top"><span style="color: #000000;">ValorFCP</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Indica o Valor do Fundo de Combate à Pobreza (FCP) do Pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">93</span></td><td align="center" valign="top"><span style="color: #000000;">ValorFCPST</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Indica o Valor do Fundo de Combate à Pobreza por Situação Tributária (FCP ST) do Pedido</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">94</span></td><td align="center" valign="top"><span style="color: #000000;">ValORFCPSTRet</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Indica o Valor do Fundo de Combate à Pobreza Retido na Fonte por Situação Tributária (FCPST RF) do Pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">95</span></td><td align="center" valign="top"><span style="color: #000000;">ValICMSFCPUFDest</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor do ICMS da UF do destinatário com percentual destinado para o Fundo de Combate à Pobreza </span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">96</span></td><td align="center" valign="top"><span style="color: #000000;">ValICMSUFDest</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Interno do ICMS na UF do destinatário do pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">97</span></td><td align="center" valign="top"><span style="color: #000000;">ValICMSUFRemet</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Valor Interno do ICMS na UF do remetente do pedido</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">98</span></td><td align="center" valign="top"><span style="color: #000000;">Marca</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">12</span></td><td align="left" valign="top"><span style="color: #000000;">Campo destinado a marca do produto nas informações complementares em “Informações Totais”</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">99</span></td><td align="center" valign="top"><span style="color: #000000;">NumInicial</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Número Inicial do produto nas informações complementares em “Informações Totais”</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">100</span></td><td align="center" valign="top"><span style="color: #000000;">NumFinal</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Número Final do produto nas informações complementares em “Informações Totais”</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">101</span></td><td align="center" valign="top"><span style="color: #000000;">NumVolumes</span></td><td align="center" valign="top"><span style="color: #000000;">N</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Número de Volumes específico do item do pedido nas informações complementares em “Informações Totais”</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">102</span></td><td align="center" valign="top"><span style="color: #000000;">EspecieVol1</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">40</span></td><td align="left" valign="top"><span style="color: #000000;">Campo primário destinado à Espécie de Volumes nas informações complementares em “Informações Totais”</span></td></tr><tr><td align="center" height="33" valign="top"><span style="color: #000000;">103</span></td><td align="center" valign="top"><span style="color: #000000;">EspecieVol2</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">40</span></td><td align="left" valign="top"><span style="color: #000000;">Campo secundário destinado à Espécie de Volumes nas informações complementares em “Informações Totais”</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">104</span></td><td align="center" valign="top"><span style="color: #000000;">DataExpedicao</span></td><td align="center" valign="top"><span style="color: #000000;">D</span></td><td align="center" valign="top"><span style="color: #000000;">  
</span></td><td align="left" valign="top"><span style="color: #000000;">Data de expedição é um campo específico da Pancrylon</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">105</span></td><td align="center" valign="top"><span style="color: #000000;">NomePreco</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">10</span></td><td align="left" valign="top"><span style="color: #000000;">Nome do Preço é um campo específico da Estrela Itaipu</span></td></tr><tr><td align="center" height="17" valign="top"><span style="color: #000000;">106</span></td><td align="center" valign="top"><span style="color: #000000;">Situacao</span></td><td align="center" valign="top"><span style="color: #000000;">C</span></td><td align="center" valign="top"><span style="color: #000000;">2</span></td><td align="left" valign="top"><span style="color: #000000;">Campo destinado ao código da Situação da Ocorrência do pedido</span></td></tr></tbody></table>

**Veja também os Itens:**

- [Layout para Importação de Pedidos](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-pedidos)
- [Layout para Importação de Itens do Pedido](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-itens-do-pedido)
- [Layout para Importação de Nota Fiscal](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-nota-fiscal)
- [Layout para Importação de Itens da Nota Fiscal](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-itens-da-nota-fiscal)
- [Layout para Importação de Produtos](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-produtos)
- [Layout para Importação de Clientes](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-clientes)
- [Layout para Importação de Fornecedores](https://autoatendimento.grupoallegus.com.br/books/vdne/page/layout-para-importacao-de-fornecedores)

> <span style="color: rgb(0, 0, 0); font-family: Arial; font-size: small;">***OBSERVAÇÕES:***</span>
> 
> <span style="color: rgb(0, 0, 0); font-family: Arial; font-size: small;">1.Os campos de valores devem ser zerados caso não sejam necessários.  
> 2.Todos os campos devem ser separados por um caracter ‘|’.  
> 3.Os campos não especificados podem ficar em branco, eles existem no arquivo para manter a compatibilidade com outros Sistemas </span>