Exibir código-fonte para Layout´s de Importação de dados vindos do ERP

== Pessoa, Cliente, Vendedor, Transportador e relacionados ==
<br>
<font face="Calibri" size="3">
'''''CL.TXT CLIENTES'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLIENTE </th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>PESSOA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>CLIENTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>GRUPO_PESSOA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>CONCEITO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>VENDEDOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>ENDERECO_COBRANCA</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>BAIRRO_COBRANCA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>CIDADE_COBRANCA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>CEP_COBRANCA</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>CAIXA_POSTAL_COBRANCA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>012</td>
<td>TELEFONE_COBRANCA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>013</td>
<td>SITUACAO</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>014</td>
<td>OBSERVACAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>015</td>
<td>OBSERVACAO_ENTREGA</td>
<td>VARCHAR (512)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>016</td>
<td>CPF_CNPJ_ENTREGA</td>
<td>VARCHAR (20)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>017</td>
<td>LIMITE_CREDITO</td>
<td>NUMERIC (15, 2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>018</td>
<td>DATA_VALIDADE_SINTEGRA</td>
<td>TIMESTAMP</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>019</td>
<td>SUFRAMA</td>
<td>VARCHAR (15)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>020</td>
<td>DATA_SUFRAMA</td>
<td>TIMESTAMP</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>021</td>
<td>DATA_FUNDACAO</td>
<td>TIMESTAMP </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>022</td>
<td>TRANSPORTADOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>023</td>
<td>REDESPACHO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>024</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC (5, 2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>025</td>
<td>COMISSAO_NEGOCIADA</td>
<td>NUMERIC (5, 2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>026</td>
<td>PRAZO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>027</td>
<td>MOEDA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>028</td>
<td>TABELA_PRECO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>029</td>
<td>ZIP_CODE</td>
<td>VARCHAR (15)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>030</td>
<td>SEQUENCIA_VISITA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>031</td>
<td>SEQUENCIA_ENTREGA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>032</td>
<td>REGIAO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>033</td>
<td>FORMA_PAGAMENTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>034</td>
<td>TIPO_EMBALAGEM</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>035</td>
<td>REGRA_VOLUME</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>036</td>
<td>CODIGO_ANTERIOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>037</td>
<td>NOME_FANTASIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>038</td>
<td>RAZAO_SOCIAL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>039</td>
<td>ENDERECO</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>040</td>
<td>BAIRRO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>041</td>
<td>CIDADE</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>042</td>
<td>CEP</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>043</td>
<td>CAIXA_POSTAL</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>044</td>
<td>TELEFONE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>045</td>
<td>FAX</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>046</td>
<td>CELULAR</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>047</td>
<td>CPF_CNPJ</td>
<td>VARCHAR (20)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>048</td>
<td>RG_IE</td>
<td>VARCHAR (20)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>049</td>
<td>E_MAIL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>050</td>
<td>HOME_PAGE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>051</td>
<td>DATA_CADASTRO</td>
<td>TIMESTAMP</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>052</td>
<td>CPF_CNPJ_NUMERICO</td>
<td>VARCHAR (18)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>053</td>
<td>ENDERECO_NUMERO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>054</td>
<td>ENDERECO_COMPLEMENTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>055</td>
<td>ENDERECO_COBRANCA_NUMERO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>056</td>
<td>ENDERECO_COBRANCA_COMPLEMENTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>057</td>
<td>DATA_NASCIMENTO</td>
<td>TIMESTAMP</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>058</td>
<td>DIA_NASCIMENTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>059</td>
<td>MES_NASCIMENTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>060</td>
<td>DIA_FUNDACAO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>061</td>
<td>MES_FUNDACAO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>062</td>
<td>SEGMENTO_NEGOCIO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>063</td>
<td>TIPO_NEGOCIO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>064</td>
<td>LOCALIZACAO_NEGOCIO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>065</td>
<td>DIAS_PRAZO_MAIS</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>066</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>067</td>
<td>TIPO_PESSOA</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>068</td>
<td>NOME_CIDADE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>069</td>
<td>NOME_ESTADO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>070</td>
<td>NOME_PAIS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>071</td>
<td>VENDEDOR_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>072</td>
<td>TRANSPORTADOR_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>073</td>
<td>REDESPACHO_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>074</td>
<td>REGIAO_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>075</td>
<td>MATRIZ_CLIENTE_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>076</td>
<td>MATRIZ_CPF_CNPJ</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>077</td>
<td>MATRIZ_CLIENTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>078</td>
<td>USA_PERC_FATURAMENTO_VENDA</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>079</td>
<td>CONTATO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>080</td>
<td>E_MAIL_COMERCIAL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>081</td>
<td>E_MAIL_FINANCEIRO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>082</td>
<td>E_MAIL_NFE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>083</td>
<td>EXCLUSIVO_PRACA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>084</td>
<td>UNICA_MARCA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>085</td>
<td>EMBARQUE_PARCIAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>086</td>
<td>BANCO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>087</td>
<td>AGENCIA</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>088</td>
<td>DIGITO_AGENCIA</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>089</td>
<td>CONTA</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>090</td>
<td>DIGITO_CONTA</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>091</td>
<td>REPRESENTANTE_CPF_CNPJ</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>092</td>
<td>REPRESENTANTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>093</td>
<td>NOME_SHOPPING</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>094</td>
<td>PISO_SHOPPING</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>095</td>
<td>PONTO_COMPRA_VENDA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>096</td>
<td>CODIGO_CLIENTE_AUX</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>097</td>
<td>INSCRICAO_MUNICIPAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>098</td>
<td>CONTRIBUINTE_ICMS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>099</td>
<td>PERMITE_VENDOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>100</td>
<td>PERMITE_PERC_FATURAMENTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>101</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>102</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>103</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>104</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>105</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>106</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>107</td>
<td>ORIGEM_CONTATO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>108</td>
<td>ORIGEM_CONTATO_EXT</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>109</td>
<td>ORIGEM_CONTATO_ESPECIFICACAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>110</td>
<td>COORDENADAS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>111</td>
<td>COORDENADAS_GRAUS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>112</td>
<td>COORDENADAS_GRAUS_LATITUDE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>113</td>
<td>COORDENADAS_GRAUS_LONGITUDE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>114</td>
<td>COORDENADAS_DECIMAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>115</td>
<td>COORDENADAS_DECIMAL_LATITUDE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>116</td>
<td>COORDENADAS_DECIMAL_LONGITUDE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>117</td>
<td>PRAZO_MEDIO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>118</td>
<td>PRAZO_MEDIO_MAXIMO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>119</td>
<td>PRAZO_LISTA_PARCELAS</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>120</td>
<td>TELEFONE_2</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>121</td>
<td>TELEFONE_3</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>122</td>
<td>CELULAR_2</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>123</td>
<td>CELULAR_3</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>124</td>
<td>CODIGO_VENDEDOR_EXPORTAR_ERP</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>125</td>
<td>CEP_NUMERICO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>126</td>
<td>TIPO_GRADE</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>127</td>
<td>PERC_DESCONTO_2</td>
<td>NUMERIC (5, 2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>128</td>
<td>PERC_DESCONTO_3</td>
<td>NUMERIC (5, 2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>129</td>
<td>PERC_DESCONTO_4</td>
<td>NUMERIC (5, 2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>130</td>
<td>PERMITE_SUBSTITUIR_PRODUTO</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>131</td>
<td>ACEITA_ENTREGA_TOTAL_PARCIAL</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>132</td>
<td>TIPO_EMPRESARIAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>133</td>
<td>CAPITAL_SOCIAL</td>
<td>NUMERIC (15, 3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>134</td>
<td>AGRUPA_FATURA</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>135</td>
<td>AGRUPA_VENDA</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>136</td>
<td>TABELA_PRECO_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>137</td>
<td>PRAZO_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PESSOA)</th>
</tr>
</table>
<br>
<br>
'''''CP.TXT CONTATOS DE PESSOA/CLIENTE'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CONTATO_PESSOA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PESSOA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* TIPO_CONTATO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>* CONTATO</td>
<td>VARCHAR (60) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>TELEFONE</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>CELULAR</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>DATA_NASCIMENTO</td>
<td>TIMESTAMP </td>
<td style="vertical-align: top;">DD/MM/AAAA HH:MM:SS ou somente DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>008</td>
<td>DDD</td>
<td>VARCHAR (7) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ESTADO_CIVIL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>SEXO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>E_MAIL</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ENDERECO</td>
<td>VARCHAR (200) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>BAIRRO</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>CIDADE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>CEP</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>CPF_CNPJ</td>
<td>VARCHAR (18) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>RG_IE</td>
<td>VARCHAR (18) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>TIME_FUTEBOL</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>HOBBY</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>POSSUI_FILHOS</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>QUANTOS_FILHOS</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>PROFISSAO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>DIA_NASCIMENTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>MES_NASCIMENTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PESSOA, TIPO_CONTATO,
CONTATO)</th>
</tr>
</table>
<br>
<br>
'''''TR.TXT TRANSPORTADORES DE DESPACHO E REDESPACHO'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TRANSPORTADOR</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>PESSOA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>TRANSPORTADOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>SITUACAO</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>CONCEITO</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>NOME_FANTASIA</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>RAZAO_SOCIAL</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>ENDERECO</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>BAIRRO</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>CIDADE</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>CEP</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>012</td>
<td>CAIXA_POSTAL</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>013</td>
<td>TELEFONE</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>014</td>
<td>FAX</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>015</td>
<td>CELULAR</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>016</td>
<td>CPF_CNPJ</td>
<td>VARCHAR (18)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>017</td>
<td>RG_IE</td>
<td>VARCHAR (20)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>018</td>
<td>E_MAIL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>019</td>
<td>HOME_PAGE</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>020</td>
<td>DATA_CADASTRO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>021</td>
<td>ENDERECO_NUMERO</td>
<td>VARCHAR (11)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>022</td>
<td>ENDERECO_COMPLEMENTO</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>023</td>
<td>TRANSPORTADOR_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>024</td>
<td>TIPO_PESSOA</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>025</td>
<td>NOME_CIDADE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>026</td>
<td>NOME_ESTADO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>027</td>
<td>NOME_PAIS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>028</td>
<td>CODIGO_TRANSPORTADOR_AUX</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>029</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>030</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>031</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>032</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>033</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>034</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PESSOA)</th>
</tr>
</table>
<br>
<br>
'''''VD.TXT VENDEDORES'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">VENDEDOR</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PESSOA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>VENDEDOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>REPRESENTANTE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>SITUACAO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PERC_COMISSAO_VISTA_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>PERC_COMISSAO_PRAZO_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>PERC_COMISSAO_VISTA_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>PERC_COMISSAO_PRAZO_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>PERC_COMISSAO_FATURAMENTO_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>PERC_COMISSAO_LIQUIDACAO_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>PERC_COMISSAO_FATURAMENTO_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>PERC_COMISSAO_LIQUIDACAO_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>DIA_PAGAMENTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>OBSERVACAO</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>VENDAS_WEB</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>CONCEITO</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>MENSAGEM</td>
<td>VARCHAR (256) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>NOME_FANTASIA</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>RAZAO_SOCIAL</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ENDERECO</td>
<td>VARCHAR (200) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>BAIRRO</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>CIDADE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>CEP</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>CAIXA_POSTAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>TELEFONE</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>FAX</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>CELULAR</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>CPF_CNPJ</td>
<td>VARCHAR (18) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>RG_IE</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>E_MAIL</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>032</td>
<td>HOME_PAGE</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>033</td>
<td>DATA_CADASTRO</td>
<td>TIMESTAMP </td>
<td style="vertical-align: top;">DD/MM/AAAA HH:MM:SS ou somente DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>034</td>
<td>ENDERECO_NUMERO</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>035</td>
<td>ENDERECO_COMPLEMENTO</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>036</td>
<td>VENDEDOR_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>037</td>
<td>TIPO_PESSOA</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>038</td>
<td>NOME_CIDADE</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>039</td>
<td>NOME_ESTADO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>040</td>
<td>NOME_PAIS</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>041</td>
<td>CONTATO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>042</td>
<td>REPRESENTANTE_CPF_CNPJ</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>043</td>
<td>CODIGO_VENDEDOR_AUX</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>044</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>045</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>046</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>047</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>048</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>049</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>050</td>
<td>TIPO_COMISSAO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>051</td>
<td>GERENTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>052</td>
<td>GERENTE_EXT</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>053</td>
<td>PERC_COMISSAO_GERENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PESSOA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLIENTE_PRAZO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* CLIENTE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* PRAZO</td>
<td>INTEGER(not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>PRAZO_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>PERC_DESCONTO_AUX</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>SEQUENCIA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>PREFERENCIAL</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>INDICE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CLIENTE, PRAZO)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLIENTE_FORMA_PAGAMENTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* CLIENTE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* FORMA_PAGAMENTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>SEQUENCIA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>PREFERENCIAL</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>INDICE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CLIENTE, FORMA_PAGAMENTO)</th>
</tr>
</table>
<br>
<br>
'''''CO.TXT CONCEITO DE PESSOAS:CLIENTE/TRANSPORTADOR/VENDEDOR'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CONCEITO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* CONCEITO</td>
<td>VARCHAR (30) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_CONCEITO</td>
<td>VARCHAR (60) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CONCEITO)</th>
</tr>
</table>
<br>
<br>
'''''EC.TXT ESTADO CIVIL DE CONTATO DE PESSOA/CLIENTE'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">ESTADO_CIVIL</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>ESTADO_CIVIL</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_ESTADO_CIVIL</td>
<td>VARCHAR (15) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, ESTADO_CIVIL)</th>
</tr>
</table>
<br>
<br>
'''''GE.TXT GRUPOS DE PESSOAS (REDES OU OUTRO TIPO DE AGRUPAMENTO)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">GRUPO_PESSOA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* GRUPO_PESSOA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_GRUPO_PESSOA</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>LIMITE_CREDITO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, GRUPO_PESSOA)</th>
</tr>
</table>
<br>
<br>
'''''TO.TXT TIPOS DE CONTATO DE CLIENTE (PROPRIETÁRIO, COMPRADOR, GERENTE, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TIPO_CONTATO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TIPO_CONTATO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_TIPO_CONTATO</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>PARENTESCO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TIPO_CONTATO)</th>
</tr>
</table>
<br>
<br>
'''''FR.TXT VENDEDORES QUE ATENDEM O CLIENTE, ALÉM DO VENDEDOR INDICADO EM CLIENTE'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">VENDEDOR_CLIENTE</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* VENDEDOR</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* CLIENTE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>FREQ_VISITAS_MES</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>VENDEDOR_EXT</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, VENDEDOR, CLIENTE)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">VENDEDOR_PRODUTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* VENDEDOR_PRODUTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>VENDEDOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>VENDEDOR_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>NIVEL</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>TIPO_VINCULO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>COLECAO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>COLECAO_AUX</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>MARCA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>TIPO_PRODUTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ESTILO_USO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ESPECIE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>DIMENSAO_TAMANHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>NICHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>LINHA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>GENERO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>CATEGORIA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>FAMILIA_COMERCIAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>GRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>GRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>SUBGRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>SUBGRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>PRODUTO</td>
<td>VARCHAR (15)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>DATA_VALIDADE_DESCONTO</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>029</td>
<td>LISTA_MULTIPLO_VENDA</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>DATA_ENTREGA_MINIMA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>031</td>
<td>DATA_ENTREGA_MAXIMA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>032</td>
<td>VENDA_LIBERADA</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>033</td>
<td>QUANTIDADE_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>034</td>
<td>VALOR_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>035</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>036</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>037</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>038</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>039</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>040</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (VENDEDOR_PRODUTO, EMPRESA)</th></tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">LOCALIZACAO_NEGOCIO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* LOCALIZACAO_NEGOCIO</td>
<td>VARCHAR (10) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_LOCALIZACAO_NEGOCIO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>OBRIGATORIO_NOME_SHOPPING</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, LOCALIZACAO_NEGOCIO)</th>
</tr>
</table>

<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">SEGMENTO_NEGOCIO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* SEGMENTO_NEGOCIO</td>
<td>VARCHAR (10) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_SEGMENTO_NEGOCIO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, SEGMENTO_NEGOCIO)</th>
</tr>
</table>
<br>
<br>

<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TIPO_NEGOCIO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* TIPO_NEGOCIO</td>
<td>VARCHAR (10) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_TIPO_NEGOCIO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TIPO_NEGOCIO)</th>
</tr>
</table>
<br>
<br>

== Produto e relacionados ==
<br>
'''''GR.TXT GRUPOS/LINHAS DE PRODUTOS'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">GRUPO_PRODUTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* GRUPO_PRODUTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_GRUPO_PRODUTO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>TIPO_COMPLEMENTO_1</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;">ex.: 1:COR<br>
</td>
</tr>
<tr>
<td>005</td>
<td>TIPO_COMPLEMENTO_2</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;">ex.: 2:TAMANHO<br>
</td>
</tr>
<tr>
<td>006</td>
<td>QUANTIDADE_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>VALOR_MIN_FRETE_CIF_GRAT</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>PERC_DESCONTO_PROMOCIONAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>PERC_DESCONTO_GERENCIAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>PERC_DESCONTO_PARCERIA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>DIAS_PRAZO_MAIS</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>TIPO_COMPLEMENTO_3</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>UNIDADE_FABRICACAO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>MARCA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>DESCRICAO_GRUPO_PRODUTO_FAT</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_1</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_2</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_3</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>SITUACAO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>GRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, GRUPO_PRODUTO)</th>
</tr>
</table>
<br>
'''Exemplo de Dados delimitados por | pipe :'''
<br>
458|7233|SAPATILHAS COM APLIQUE|1|2||0|0|0||<br>
458|7226|SAPATILHAS FEMININAS COM APLIQUE|1|2||0|0|0||<br>
458|7300|CASUAL MASCULINA|1|2||0|0|0||<br>
<br>
<br>
'''''GRADES.TXT ITENS/TAMANHOS DAS GRADES POR PRODUTO'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">ITEM_GRADE_PRODUTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* ITEM_GRADE_PRODUTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">ID sequencial<br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_GRADE_PRODUTO</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;">39 a 44 ou 34 a 39<br>
</td>
</tr>
<tr>
<td>004</td>
<td>GRADE</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;">1 ou 2<br>
</td>
</tr>
<tr>
<td>005</td>
<td>CODIGO_COMPLEMENTO_2</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><font face="Calibri" size="3">para
cada item da grade será gerado um registro aqui nesta tabela</font> </td>
</tr>
<tr>
<td>007</td>
<td>SITUACAO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>PRODUTO</td>
<td>VARCHAR (15) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>TIPO_GRADE</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>QUANTIDADE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, ITEM_GRADE_PRODUTO)</th>
</tr>
</table>
<br>
'''Exemplo de Dados delimitados por | pipe - gerar um registro para cada item da grade - supondo que fosse cada tamanho:'''
<br>
458|1001|39 AO 44|1|39<br>
458|1002|39 AO 44|1|40<br>
458|1003|39 AO 44|1|41<br>
458|1004|39 AO 44|1|42<br>
458|1005|39 AO 44|1|43<br>
458|1006|39 AO 44|1|44<br>
458|1007|34 AO 39|1|34<br>
458|1008|34 AO 39|1|35<br>
458|1009|34 AO 39|1|36<br>
458|1010|34 AO 39|1|37<br>
458|1011|34 AO 39|1|38<br>
458|1012|34 AO 39|1|39<br>
<br>
<br>
'''''PR.TXT PRODUTOS ACABADOS'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRODUTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PRODUTO</td>
<td>VARCHAR (15) (not null)</td>
<td style="vertical-align: top;">REFERENCIA BASE DO PRODUTO
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_PRODUTO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><font face="Calibri" size="3">DESCRIÇÃO/NOME DO PRODUTO</font>
</td>
</tr>
<tr>
<td>004</td>
<td>APELIDO_PRODUTO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;">PODE SER USADO PARA UMA REFERENCIA ALTERNATIVA
</td>
</tr>
<tr>
<td>005</td>
<td>ABREVIATURA_UNIDADE</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;">PAR, UN<br>
</td>
</tr>
<tr>
<td>006</td>
<td>GRUPO_PRODUTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;">PARA O ARQUIVO DE GRUPO_PRODUTO
</td>
</tr>
<tr>
<td>007</td>
<td>SUBGRUPO_PRODUTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>SITUACAO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>PESO_LIQUIDO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>CLASSIFICACAO_FISCAL</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>CATEGORIA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;">PARA UM ARQUIVO DE CLASSIFICAÇÕES FISCAIS
</td>
</tr>
<tr>
<td>012</td>
<td>PONTO_CRITICO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>GRADE</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;">PARA O ARQUIVO ITEM_GRADE_PRODUTO<br>
</td>
</tr>
<tr>
<td>014</td>
<td>CODIGO_BARRAS</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ESPECIFICACAO</td>
<td>VARCHAR (256) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>PRECO_BASE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>FAMILIA_COMERCIAL</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>UNIDADE_FABRICACAO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>GRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>SUBGRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ESPECIE</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>SEGMENTO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>TIPO_EMBALAGEM</td>
<td>VARCHAR (5) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>USO_PRODUTO_OPCIONAL</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>DESCRICAO_PRODUTO_2</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>032</td>
<td>DESCRICAO_PRODUTO_3</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>033</td>
<td>MARCA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>034</td>
<td>COLECAO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>035</td>
<td>TIPO_PRODUTO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>036</td>
<td>ESTILO_USO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>037</td>
<td>DIMENSAO_TAMANHO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>038</td>
<td>NICHO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>039</td>
<td>LINHA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>040</td>
<td>GENERO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>041</td>
<td>PRODUTO_EXT</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>042</td>
<td>NCM</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>043</td>
<td>PRECO_CUSTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>044</td>
<td>PRECO_FINAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>045</td>
<td>LISTA_MULTIPLO_VENDA</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>046</td>
<td>DESCRICAO_GRUPO_PRODUTO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>047</td>
<td>DESCRICAO_SUBGRUPO_PRODUTO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>048</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_1</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>049</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_2</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>050</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_3</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>051</td>
<td>GRADE_POR</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>052</td>
<td>SUBSTITUICAO_TRIBUTARIA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PRODUTO)</th>
</tr>
</table>
<br>
''Podemos usar a estrutura de PRODUTO para identificar a referência base do produto, e a PRODUTO_COMPLEMENTO para identificar as variável em COR e TAMANHO.''
<br>
<br>
'''Exemplo de Dados delimitados por | pipe - gerar um registro para cada item da grade - supondo que fosse cada tamanho:'''
<br>
458|72.33|SAPATILHA COM APLIQUE|72.33|PAR|7233|0|A|0|764|0|2|7890000000000001|||<br>
458|72.26|SAPATILHA FEMININA COM APLIQUE|72.26|PAR|7226|0|A|0|764|0|2|7890000000000684|||<br>
458|73.00|CASUAL MASCULINA|73.00|PAR|7300|0|A|0|764|0|2|7890000000000256|||<br>
<br>
<br>
'''''PC.TXT COMBINAÇÃO/VARIAÇÃO DE CORES E TAMANHOS DE CADA PRODUTO'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRODUTO_COMPLEMENTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PRODUTO</td>
<td>VARCHAR (15) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;">PARA O ARQUIVO DE COMPLEMENTO_1 DAS CORES
</td>
</tr>
<tr>
<td>004</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;">PARA O ARQUIVO DE COMPLEMENTO_2 DOS TAMANHOS
</td>
</tr>
<tr>
<td>005</td>
<td>SITUACAO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;">A PARA ATIVO OU I PARA INATIVO
</td>
</tr>
<tr>
<td>006</td>
<td>FAMILIA_COMERCIAL</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>APELIDO_PRODUTO_COMPLEMENTO</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;">REFERENCIA COMPLETA DO SKU
</td>
</tr>
<tr>
<td>008</td>
<td>CODIGO_BARRAS</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>PONTO_CRITICO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>PRODUTO_COMPLEMENTO_EXT</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>NCM</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>PRECO_BASE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>PRECO_CUSTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>PRECO_FINAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>LISTA_MULTIPLO_VENDA</td>
<td>VARCHAR (250) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_1</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>DESCRICAO_COMPLEMENTO_1</td>
<td>VARCHAR (200) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_2</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>DESCRICAO_COMPLEMENTO_2</td>
<td>VARCHAR (200) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>DESCRICAO_TIPO_COMPLEMENTO_3</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>DESCRICAO_COMPLEMENTO_3</td>
<td>VARCHAR (200) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PRODUTO)</th>
</tr>
</table>
<br>
<br>
'''Exemplo de Dados delimitados por | pipe - gerar um registro para cada item da grade - supondo que fosse cada tamanho:'''
<br>
458|72.33|460|34|A||010600243|7890000545414||<br>
458|72.33|460|35|A||010600243|7890000545415||<br>
458|72.33|460|36|A||010600243|7890000545416||<br>
458|72.33|460|37|A||010600243|7890000545417||<br>
458|72.33|460|38|A||010600243|7890000545418||<br>
458|72.33|460|39|A||010600243|7890000545419||<br>
458|72.33|390|34|A||010600228|7890000545414||<br>
458|72.33|390|35|A||010600228|7890000545415||<br>
458|72.33|390|36|A||010600228|7890000545416||<br>
458|72.33|390|37|A||010600228|7890000545417||<br>
458|72.33|390|38|A||010600228|7890000545418||<br>
458|72.33|390|39|A||010600228|7890000545419||<br>
458|72.26|199|34|A||010600219|7890000545414||<br>
458|72.26|199|35|A||010600219|7890000545415||<br>
458|72.26|199|36|A||010600219|7890000545416||<br>
458|72.26|199|37|A||010600219|7890000545417||<br>
458|72.26|199|38|A||010600219|7890000545418||<br>
458|72.26|199|39|A||010600219|7890000545419||<br>
<br>
<br>
'''''C1.TXT PRIMEIRO COMPLEMENTO DE PRODUTOS (COR, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">COMPLEMENTO_1</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* COMPLEMENTO_1</td>
<td>VARCHAR (20) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_COMPLEMENTO_1</td>
<td>VARCHAR (60) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>TIPO_COMPLEMENTO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>COMPLEMENTO_1_AUX</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, COMPLEMENTO_1)</th>
</tr>
</table>
<br>
<br>
'''No caso da Puket o COMPLEMENTO_1 será usado para indicar o cadastro de Cores dos produtos Ex.:'''
<br>
199 : PRETO<br>
460 : PINK<br>
390 : AZUL MARINHO<br>
108 : BRANCO<br>
891 : BEGE<br>
<br>
<br>
'''''C2.TXT SEGUNDO COMPLEMENTO DE PRODUTOS (TAMANHO, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">COMPLEMENTO_2</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* COMPLEMENTO_2</td>
<td>VARCHAR (20) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_COMPLEMENTO_2</td>
<td>VARCHAR (60) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>TIPO_COMPLEMENTO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>COMPLEMENTO_2_AUX</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, COMPLEMENTO_2)</th>
</tr>
</table>
<br>
''No caso da Puket o COMPLEMENTO_2 será usado para indicar o cadastro dos Tamanhos (item na grade) dos Produtos.''
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">COMPLEMENTO_3</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* COMPLEMENTO_3</td>
<td>VARCHAR (3) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>TIPO_COMPLEMENTO</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>COMPLEMENTO_3_AUX</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, COMPLEMENTO_3)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CATEGORIA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* CATEGORIA</td>
<td>VARCHAR (100) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_CATEGORIA</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>PARCELA_MINIMA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>PRIORIDADE</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CATEGORIA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">COLECAO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>COLECAO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_COLECAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>PERC_DESCONTO_COLECAO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>PERC_DESCONTO_PARCERIA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>DIAS_PRAZO_MAIS</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>TIPO_FLAG</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>TABELA_PRECO_LIBERADA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>BLOQUEIA_PRAZO_MAIS_DESCONTO</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>016</td>
<td>DATA_INICIAL</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>017</td>
<td>DATA_FINAL</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, COLECAO)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">COLECAO_PRODUTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>COLECAO_PRODUTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>COLECAO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>GRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>SUBGRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>PRODUTO</td>
<td>VARCHAR (15)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>APELIDO_PRODUTO_COMPLEMENTO</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>NIVEL</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (COLECAO_PRODUTO)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">MARCA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* MARCA</td>
<td>VARCHAR (100) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_MARCA</td>
<td>VARCHAR (200)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>SITUACAO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>PERC_DESCONTO_MARCA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>UNIDADE_FABRICACAO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, MARCA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">UNIDADE_FABRICACAO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* UNIDADE_FABRICACAO</td>
<td>VARCHAR (50) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_UNIDADE_FABRICACAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>DATA_ENTREGA_MINIMA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>005</td>
<td>DATA_ENTREGA_MAXIMA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>006</td>
<td>QUANTIDADE_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>VALOR_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, UNIDADE_FABRICACAO)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRODUTO_COMERCIAL</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* PRODUTO_COMERCIAL</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>PRODUTO</td>
<td>VARCHAR (15)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>GRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>SUBGRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>CATEGORIA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>009</td>
<td>FAMILIA_COMERCIAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>010</td>
<td>MULTIPLO_VENDA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>012</td>
<td>DATA_VALIDADE_DESCONTO</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>013</td>
<td>NIVEL</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>014</td>
<td>DATA_ENTREGA_MINIMA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>015</td>
<td>VENDA_LIBERADA</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>016</td>
<td>LISTA_MULTIPLO_VENDA</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>017</td>
<td>DATA_ENTREGA_MAXIMA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>018</td>
<td>QUANTIDADE_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>019</td>
<td>VALOR_MIN_FRETE_CIF_GRAT</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>020</td>
<td>COLECAO</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>021</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>022</td>
<td>MARCA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>023</td>
<td>TIPO_PRODUTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>024</td>
<td>ESTILO_USO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>025</td>
<td>ESPECIE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>026</td>
<td>DIMENSAO_TAMANHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>027</td>
<td>NICHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>028</td>
<td>LINHA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>029</td>
<td>GENERO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>030</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>031</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>032</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>033</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>034</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>035</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (PRODUTO_COMERCIAL, EMPRESA)</th>
</tr>
</table>
<br>
<br>
== Atributos de pedido de venda ==
<br>
'''''FP.TXT FORMAS DE PAGAMENTO (BOLETO, CHEQUE, DINHEIRO, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">FORMA_PAGAMENTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* FORMA_PAGAMENTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_FORMA_PAGAMENTO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, FORMA_PAGAMENTO)</th>
</tr>
</table>
<br>
<br>
'''''MO.TXT MOEDAS PARA O PEDIDO DE VENDA (REAL, DÓLAR, EURO, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">MOEDA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* MOEDA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_MOEDA</td>
<td>VARCHAR (15) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>ABREVIATURA_MOEDA</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>SITUACAO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, MOEDA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">MOEDA_COTACAO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* MOEDA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>* DATA_COTACAO</td>
<td>INTEGER (not null) (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>VALOR</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, MOEDA, DATA_COTACAO)</th>
</tr>
</table>
<br>
<br>
'''''PV.TXT PERÍODOS DE ENTREGA PARA OS PEDIDOS DE VENDA'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PERIODO_ENTREGA_VENDA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PERIODO_ENTREGA_VENDA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">id/código do período: ex:20121101
</td>
</tr>
<tr>
<td>003</td>
<td>DATA_INICIAL</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA data inicial do período, ex:01/11/2012
</td>
</tr>
<tr>
<td>004</td>
<td>DATA_FINAL</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA data final do período, ex:15/11/2012
</td>
</tr>
<tr>
<td>005</td>
<td>DATA_ALTERACAO</td>
<td>TIMESTAMP </td>
<td style="vertical-align: top;">DD/MM/AAAA HH:MM:SS ou somente DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>006</td>
<td>ANO</td>
<td>INTEGER </td>
<td style="vertical-align: top;">ano base do período, ex: 2012
</td>
</tr>
<tr>
<td>007</td>
<td>PERIODO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>DESCRICAO_PERIODO</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;">1a quinzena novembro
</td>
</tr>
<tr>
<td>009</td>
<td>DATA_REFERENCIA</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PERIODO_ENTREGA_VENDA)</th>
</tr>
</table>
<br>
<br>
'''''PZ.TXT PRAZOS DE PAGAMENTO (A VISTA, 7 DIAS, 30/60/90 DIAS, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRAZO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PRAZO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_PRAZO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>PARCELAS</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>TIPO_PRAZO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PERC_DESCONTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>PRAZO_MEDIO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>DIAS_PARCELA_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>DIAS_PARCELA_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>DIAS_PARCELA_3</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>DIAS_PARCELA_4</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>DIAS_PARCELA_5</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>DIAS_PARCELA_6</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>DIAS_PARCELA_7</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>DIAS_PARCELA_8</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>DIAS_PARCELA_9</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>DIAS_PARCELA_10</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>DIAS_PARCELA_11</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>DIAS_PARCELA_12</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>SITUACAO</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>PERC_DESCONTO_LIBERADO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>INDICE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>PRAZO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PRAZO)</th>
</tr>
</table>
<br>
<br>
'''''TM.TXT TIPO DA EMBALAGEM DE CAIXA COLETIVA - CASO EXISTA'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TIPO_EMBALAGEM</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TIPO_EMBALAGEM</td>
<td>VARCHAR (5) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_TIPO_EMBALAGEM</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TIPO_EMBALAGEM)</th>
</tr>
</table>
<br>
<br>
'''''TV.TXT TIPOS DE VENDA (VENDA, BONIFICAÇÃO, PRONTA ENTREGA, VENDOR, DEVOLUÇÃO, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TIPO_VENDA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TIPO_VENDA</td>
<td>VARCHAR (3) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_TIPO_VENDA</td>
<td>VARCHAR (40) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>CONSIDERA_PRODUTO_INATIVO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;">yes ou no para indicar se permite vender produtos em situação inativa
</td>
</tr>
<tr>
<td>005</td>
<td>GERA_COMISSAO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;">yes ou no para indicar se gera comissão
</td>
</tr>
<tr>
<td>006</td>
<td>GERA_CONTAS_RECEBER</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;">yes ou no para indicar se gera contas a receber
</td>
</tr>
<tr>
<td>007</td>
<td>PARCELA_MINIMA</td>
<td>INTEGER </td>
<td style="vertical-align: top;">valor de parcela mínima para pedidos com este tipo de venda
</td>
</tr>
<tr>
<td>008</td>
<td>HAB_PERC_FATURAMENTO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>LOCAL_ESTOQUE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>BAIXA_ESTOQUE</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;">yes ou no para indicar se baixa o estoque
</td>
</tr>
<tr>
<td>011</td>
<td>TIPO_LOTE_PRODUCAO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>PORTADOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>CARTERIA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>PRAZO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>EXPORTACAO</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>TIPO_VENDA_EXT</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>TIPO_VENDA_AUX</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TIPO_VENDA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TIPO_VENDA_FORMA_PAGAMENTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TIPO_VENDA</td>
<td>VARCHAR (3) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* FORMA_PAGAMENTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>INDICE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (NOTA_FISCAL_VENDA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRAZO_MEDIO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>PRAZO_MEDIO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PRAZO_MEDIO)</th>
</tr>
</table>
<br>
<br>
== Retorno do ERP para o SFA sobre a posição e situação do pedido de venda na empresa ==
<br>
'''''OP.TXT OCORRÊNCIAS DOS PEDIDOS IMPORTADOS NO ERP INDICANDO SITUAÇÃO E SE FOI PRODUZIDO'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">OCORRENCIA_VENDA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>ANO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">pode gerar 0
</td>
</tr>
<tr>
<td>003</td>
<td>VENDA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><font face="Calibri" size="3">pode gerar 0</font>
</td>
</tr>
<tr>
<td>004</td>
<td>SEQUENCIA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">código do item quando for por item, da venda gerar 0
</td>
</tr>
<tr>
<td>005</td>
<td>DATA_OCORRENCIA_VENDA</td>
<td>TIMESTAMP (not null)</td>
<td style="vertical-align: top;">DD/MM/AAAA HH:MM:SS ou somente DD/MM/AAAA
</td>
</tr>
<tr>
<td>006</td>
<td>HORA</td>
<td>VARCHAR (8) (not null)</td>
<td style="vertical-align: top;">hh:mm:ss
</td>
</tr>
<tr>
<td>007</td>
<td>HISTORICO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>OBSERVACAO</td>
<td>VARCHAR (256) </td>
<td style="vertical-align: top;">texto constando algo relativo ao pedido nesta ocorrência-momento
</td>
</tr>
<tr>
<td>009</td>
<td>PEDIDO_VENDEDOR</td>
<td>VARCHAR (35) </td>
<td style="vertical-align: top;">número do pedido_vendedor enviado para o ERP
</td>
</tr>
<tr>
<td>010</td>
<td>SITUACAO_VENDA</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;">A:Ativo, C:Cancelado, P:Produção, F:Faturado
</td>
</tr>
<tr>
<td>011</td>
<td>VENDEDOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;">código/numero do vendedor
</td>
</tr>
<tr>
<td>012</td>
<td>OCORRENCIA_VENDA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><font face="Calibri" size="3">pode gerar 0</font>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY ()</th>
</tr>
</table>
<br>
<br>
'''''HI.TXT HISTÔRICOS PARA INDICAR AS OCORRÊNCIAS DE VENDA E MOTIVOS DE NÃO VENDA GERADOS PELO SFA'''''
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">HISTORICO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* HISTORICO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_HISTORICO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>OCORRENCIA_VENDA</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>OCORRENCIA_PESSOA</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, HISTORICO)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">VENDA_ERP</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* VENDA_ERP</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>SISTEMA_ORIGEM_PEDIDO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>USUARIO_ORIGEM_PEDIDO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>NUMERO_PEDIDO_ORIGEM</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>NUMERO_PEDIDO_ERP</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>NUMERO_PEDIDO_VENDEDOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>NUMERO_PEDIDO_CLIENTE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>VENDEDOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>VENDEDOR_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>VENDEDOR_CPF_CNPJ</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>VENDEDOR_RAZAO_SOCIAL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>VENDEDOR_NOME_FANTASIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>VENDEDOR_OBSERVACAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>CLIENTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>CLIENTE_CPF_CNPJ</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>CLIENTE_RAZAO_SOCIAL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>CLIENTE_NOME_FANTASIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>CLIENTE_OBSERVACAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>CLIENTE_NOME_CONTATO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>CLIENTE_TIPO_CONTATO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>TRANSPORTADOR</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>TRANSPORTADOR_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>TRANSPORTADOR_CPF_CNPJ</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>TRANSPORTADOR_RAZAO_SOCIAL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>TRANSPORTADOR_NOME_FANTASIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>TRANSPORTADOR_OBSERVACAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>TRANSPORTADOR_FRETE</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>REDESPACHO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>REDESPACHO_EXT</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>032</td>
<td>REDESPACHO_CPF_CNPJ</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>033</td>
<td>REDESPACHO_RAZAO_SOCIAL</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>034</td>
<td>REDESPACHO_NOME_FANTASIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>035</td>
<td>REDESPACHO_OBSERVACAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>036</td>
<td>REDESPACHO_FRETE</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>037</td>
<td>TIPO_VENDA</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>038</td>
<td>TIPO_VENDA_DESCRICAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>039</td>
<td>TIPO_PRECO_DESCRICAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>040</td>
<td>MOEDA_DESCRICAO</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>041</td>
<td>TABELA_PRECO_DESCRICAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>042</td>
<td>FORMA_PAGAMENTO_DESCRICAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>043</td>
<td>PRAZO_DESCRICAO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>044</td>
<td>DATA_EMISSAO</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>045</td>
<td>DATA_INCLUSAO</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>046</td>
<td>DATA_ENTREGA_SOLICITADA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>047</td>
<td>DATA_ENTREGA_INICIAL</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>048</td>
<td>DATA_ENTREGA_FINAL</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>049</td>
<td>ITENS</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>050</td>
<td>QUANTIDADE_TOTAL</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>051</td>
<td>QUANTIDADE_CANCELADA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>052</td>
<td>QUANTIDADE_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>053</td>
<td>QUANTIDADE_PENDENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>054</td>
<td>LISTA_PERC_DESCONTOS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>055</td>
<td>VALOR_ICMS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>056</td>
<td>VALOR_IPI</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>057</td>
<td>VALOR_ISS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>058</td>
<td>VALOR_FRETE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>059</td>
<td>VALOR_PRODUTOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>060</td>
<td>VALOR_SERVICOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>061</td>
<td>VALOR_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>062</td>
<td>VALOR_SEGURO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>063</td>
<td>VALOR_OUTROS_ACRESCIMOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>064</td>
<td>VALOR_OUTROS_DESCONTOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>065</td>
<td>VALOR_OUTROS_IMPOSTOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>066</td>
<td>VALOR_TOTAL_BRUTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>067</td>
<td>VALOR_TOTAL_LIQUIDO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>068</td>
<td>VALOR_TOTAL_CANCELADO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>069</td>
<td>VALOR_TOTAL_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>070</td>
<td>VALOR_TOTAL_PENDENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>071</td>
<td>DESCRICAO_VERBAS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>072</td>
<td>PERC_COMISSAO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>073</td>
<td>VALOR_COMISSAO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>074</td>
<td>SITUACAO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>075</td>
<td>DESCRICAO_SITUACAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>076</td>
<td>OBSERVACAO_VENDA</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>077</td>
<td>OBSERVACAO_NF</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>078</td>
<td>OBSERVACAO_ORDEM_FAB</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>079</td>
<td>OBSERVACAO_INTERNA</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>080</td>
<td>OBSERVACAO_LOJA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>081</td>
<td>TIPO_EMBALAGEM_DESCRICAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>082</td>
<td>ENVIOU_COPIA_PEDIDO_E_MAIL</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>083</td>
<td>E_MAIL_EMISSOR_COPIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>084</td>
<td>E_MAIL_DESTINO_COPIA</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>085</td>
<td>E_MAIL_DESTINO_COPIA_CC</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>086</td>
<td>E_MAIL_CLIENTE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>087</td>
<td>E_MAIL_CLIENTE_NFE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>088</td>
<td>E_MAIL_CLIENTE_COMPRADOR</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>089</td>
<td>TELEFONE_CLIENTE</td>
<td>VARCHAR (30)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>090</td>
<td>CHAVE</td>
<td>VARCHAR (256)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>091</td>
<td>COLECAO_DESCRICAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>092</td>
<td>GRUPO_PRODUTO_DESCRICAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>093</td>
<td>PERMITE_SUBSTITUIR_PRODUTO</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>094</td>
<td>ACEITA_ENTREGA_TOTAL_PARCIAL</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>095</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>096</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>097</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>098</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>099</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>100</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (VENDA_ERP)</th></tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">VENDA_ERP_ITEM </th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* VENDA_ERP_ITEM</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">ID interno Trovata
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>VENDA_ERP</td>
<td>INTEGER</td>
<td style="vertical-align: top;">gerar 0, pelo numero pedido_erp será identificado
</td>
</tr>
<tr>
<td>004</td>
<td>NUMERO_PEDIDO_ORIGEM</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>NUMERO_PEDIDO_ERP</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>006</td>
<td>NUMERO_PEDIDO_VENDEDOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>007</td>
<td>SEQUENCIA_ITEM</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>008</td>
<td>PRODUTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">ID ou código
</td>
</tr>
<tr>
<td>009</td>
<td>APELIDO_PRODUTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">referência
</td>
</tr>
<tr>
<td>010</td>
<td>APELIDO_PRODUTO_COMPLEMENTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>011</td>
<td>DESCRICAO_PRODUTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>012</td>
<td>DESCRICAO_PRODUTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>013</td>
<td>REFERENCIA_PRODUTO_CLIENTE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;">referência deste produto no cliente
</td>
</tr>
<tr>
<td>014</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">Cor, etc
</td>
</tr>
<tr>
<td>015</td>
<td>DESCRICAO_COMPLEMENTO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>016</td>
<td>GRADE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>017</td>
<td>AGRUPAMENTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>018</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">Tamanho, etc
</td>
</tr>
<tr>
<td>019</td>
<td>DESCRICAO_COMPLEMENTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>020</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>021</td>
<td>DESCRICAO_COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>022</td>
<td>UNIDADE_MEDIDA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>023</td>
<td>DATA_ENTREGA_SOLICITADA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA
</td>
</tr>
<tr>
<td>024</td>
<td>DATA_ENTREGA_INICIAL</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA primeira entrega efetuada
</td>
</tr>
<tr>
<td>025</td>
<td>DATA_ENTREGA_FINAL</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA ultima entrega efetuada
</td>
</tr>
<tr>
<td>026</td>
<td>QUANTIDADE_TOTAL</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">solicitada
</td>
</tr>
<tr>
<td>027</td>
<td>QUANTIDADE_CANCELADA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>028</td>
<td>QUANTIDADE_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>029</td>
<td>QUANTIDADE_PENDENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>030</td>
<td>LISTA_PERC_DESCONTOS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">concatenar os descontos em % e/ou valor
</td>
</tr>
<tr>
<td>031</td>
<td>CAIXAS</td>
<td>INTEGER</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>032</td>
<td>PRECO_UNITARIO_TABELA_PRECO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>033</td>
<td>VALOR_UNITARIO_BRUTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>034</td>
<td>VALOR_UNITARIO_LIQUIDO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>035</td>
<td>VALOR_TOTAL_BRUTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>036</td>
<td>VALOR_TOTAL_LIQUIDO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>037</td>
<td>VALOR_TOTAL_CANCELADO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>038</td>
<td>VALOR_TOTAL_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>039</td>
<td>VALOR_TOTAL_PENDENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>040</td>
<td>ALIQ_IPI</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>041</td>
<td>VALOR_IPI</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>042</td>
<td>SITUACAO</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>043</td>
<td>DESCRICAO_SITUACAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>044</td>
<td>OBSERVACAO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>045</td>
<td>OBSERVACAO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>046</td>
<td>OBSERVACAO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>047</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>048</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>049</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>050</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>051</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>052</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (VENDA_ERP_ITEM)</th></tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLIENTE_ULTIMO_PRODUTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* CLIENTE_ULTIMO_PRODUTO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>CLIENTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>PRODUTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>APELIDO_PRODUTO_COMPLEMENTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>QUANTIDADE_TOTAL_PEDIDO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>QUANTIDADE_TOTAL_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>DATA_PEDIDO</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>013</td>
<td>PRECO_UNITARIO_PEDIDO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>PRECO_UNITARIO_FATURADO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>NUMERO_PEDIDO</td>
<td>VARCHAR(250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>NUMERO_NF</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (CLIENTE_ULTIMO_PRODUTO)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLIENTE_RESUMO_VENDAS</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* CLIENTE_RESUMO_VENDAS</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>CLIENTE</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>NIVEL</td>
<td>VARCHAR (50)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>ANO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>MES</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>DIA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>DATA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>010</td>
<td>QUANTIDADE_TOTAL</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>VALOR_TOTAL</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>QUANTIDADE_TOTAL_CANCELADA</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>VALOR_TOTAL_CANCELADO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>QUANTIDADE_TOTAL_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>VALOR_TOTAL_ENTREGUE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>QUANTIDADE_TOTAL_PENDENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>VALOR_TOTAL_PENDENTE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>COLECAO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>COLECAO_AUX</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>MARCA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>TIPO_PRODUTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>ESTILO_USO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>ESPECIE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>DIMENSAO_TAMANHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>NICHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>LINHA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>GENERO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>CATEGORIA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>FAMILIA_COMERCIAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>GRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>GRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>032</td>
<td>SUBGRUPO_PRODUTO</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>033</td>
<td>SUBGRUPO_PRODUTO_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>034</td>
<td>PRODUTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>035</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>036</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>037</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>038</td>
<td>APELIDO_PRODUTO_COMPLEMENTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>039</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (1)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>040</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (2)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>041</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (3)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>042</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (4)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>043</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (5)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>044</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (6)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (CLIENTE_RESUMO_VENDAS)</th></tr>
</table>
<br>
<br>
== Estoque Individual/Comum ==
<br>
'''''LE.TXT LOCAIS DE ESTOQUE (DEPOSITO UM, DEPÓSITO DOIS, ETC)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">LOCAL_ESTOQUE</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* LOCAL_ESTOQUE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_LOCAL_ESTOQUE</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>DESTINATARIO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>TIPO_LOCAL</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, LOCAL_ESTOQUE)</th>
</tr>
</table>
<br>
<br>
'''''SE.TXT SALDO DE ESTOQUE'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">SALDO_ESTOQUE</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>PRODUTO</td>
<td>VARCHAR (15) </td>
<td style="vertical-align: top;">referência base do produto, ex:010600287
</td>
</tr>
<tr>
<td>003</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;">código da cor, ex: 199
</td>
</tr>
<tr>
<td>004</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;">código do tamanho na grade, ex:"34 a 39", ou "P", ou "M", etc
</td>
</tr>
<tr>
<td>005</td>
<td>LOCAL_ESTOQUE</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>TIPO</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ANO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>MES</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>SALDO_INICIAL</td>
<td>NUMERIC </td>
<td style="vertical-align: top;">quantidade de saldo disponível
</td>
</tr>
<tr>
<td>010</td>
<td>ENTRADAS</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>SAIDAS</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>SALDO_FINAL</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>SALDO_DISPONIVEL</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>SALDO_AUXILIAR</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>RESERVA_ERP</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>RESERVA_ONLINE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>RESERVA_LOCAL</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>PONTO_CRITICO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>DATA_DISPONIVEL_INICIAL</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>021</td>
<td>DATA_DISPONIVEL_FINAL</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>022</td>
<td>PERIODO_ENTREGA_INICIAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>PERIODO_ENTREGA_FINAL</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>DIA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>DATA_BASE_SALDO_ESTOQUE</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA)</th>
</tr>
</table>
<br>
<br>
== Estoque de caixas coletivas, Pronta entrega, Online ==
<br>
'''''//AG.TXT AGRUPAMENTOS/GRADES DAS CAIXAS COLETIVAS'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRONTA_ENTREGA_AGRUPAMENTO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* AGRUPAMENTO</td>
<td>VARCHAR (15) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* COMPLEMENTO_2</td>
<td>VARCHAR (20) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>QUANTIDADE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, AGRUPAMENTO,
COMPLEMENTO_2)</th>
</tr>
</table>
<br>
<br>
'''''SC.TXT SALDO DE ESTOQUE DAS CAIXAS COLETIVAS'''''
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PRONTA_ENTREGA_ESTOQUE</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PRODUTO</td>
<td>VARCHAR (15) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* COMPLEMENTO_1</td>
<td>VARCHAR (20) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>* AGRUPAMENTO</td>
<td>VARCHAR (15) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>SALDO_ESTOQUE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>QTDE_PRODUCAO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>QTDE_PRODUZIDO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>QTDE_RESERVA_I</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>QTDE_RESERVA_E</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>SALDO_FINAL</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>DATA_FATURAMENTO</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PRODUTO, COMPLEMENTO_1,
AGRUPAMENTO)</th>
</tr>
</table>
<br>
<br>
== Tabela de Preço ==
<br>
'''''Table principal das tabelas de preço'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TABELA_PRECO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TABELA_PRECO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_TABELA_PRECO</td>
<td>VARCHAR (80) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>DATA_VALIDADE</td>
<td>TIMESTAMP </td>
<td style="vertical-align: top;">DD/MM/AAAA HH:MM:SS ou somente DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>005</td>
<td>PERC_DESCONTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>INDICE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>MOEDA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>PERC_DESCONTO_LIBERADO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>SITUACAO</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>TABELA_PRECO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>PERC_COMISSAO_FIXO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>COMISSAO_NEGOCIADA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>CODIGO_TABELA_PRECO_AUX</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>COLECAO</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>MARCA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TABELA_PRECO)</th>
</tr>
</table>
<br>
<br>
'''''Vínculo das tabelas de preço com cada referencia (Produto)'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">ITEM_TABELA_PRECO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* ITEM_TABELA_PRECO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>TABELA_PRECO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>GRUPO_PRODUTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>SUBGRUPO_PRODUTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>GRADE</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>PRODUTO</td>
<td>VARCHAR (15) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>PRECO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>QUANTIDADE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>FAMILIA_COMERCIAL</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>AGRUPAMENTO</td>
<td>VARCHAR (15) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>PRECO_MINIMO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>COMPLEMENTO_2_INICIAL</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>COMPLEMENTO_2_FINAL</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>TABELA_PRECO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (20) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>PRECO_CUSTO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>PRECO_FINAL</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>PRECO_ATACADO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>PRECO_VAREJO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (ITEM_TABELA_PRECO, EMPRESA)</th>
</tr>
</table>
<br>
<br>
'''''Vínculo com prazos de pagamento que será exibidos ao selecionar a tabela'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TABELA_PRECO_PRAZO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TABELA_PRECO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* PRAZO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>PERC_DESCONTO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>INDICE</td>
<td>NUMERIC </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PERC_DESCONTO_AUX</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>TABELA_PRECO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>PRAZO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TABELA_PRECO, PRAZO)</th>
</tr>
</table>
<br>
<br>
'''''Vínculo com o cadastro de vendedores que têm acesso a tabela'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TABELA_PRECO_VENDEDOR</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* TABELA_PRECO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* VENDEDOR</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>TABELA_PRECO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>VENDEDOR_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>TABELA_PADRAO</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TABELA_PRECO, VENDEDOR)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TABELA_PRECO_CLIENTE </th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>TABELA_PRECO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>003</td>
<td>CLIENTE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>004</td>
<td>PERC_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>005</td>
<td>INDICE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, TABELA_PRECO, CLIENTE)</th>
</tr>
</table>
<br>
<br>
== Nota Fiscal ==
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">NOTA_FISCAL</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* NOTA_FISCAL</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>NUMERO_NOTA_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>SERIE_NOTA_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>PEDIDO_VENDEDOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PEDIDO_CLIENTE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>DATA_EMISSAO</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>008</td>
<td>DATA_SAIDA</td>
<td>DATE</td>
<td style="vertical-align: top;">DD/MM/AAAA<br>
</td>
</tr>
<tr>
<td>009</td>
<td>CLIENTE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>CLIENTE_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>CNPJ_CLIENTE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>RAZAO_SOCIAL_CLIENTE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>TRANSPORTADOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>TRANSPORTADOR_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>CNPJ_TRANSPORTADOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>RAZAO_SOCIAL_TRANSPORTADOR</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>REDESPACHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>REDESPACHO_EXT</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>CNPJ_REDESPACHO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>RAZAO_SOCIAL_REDESPACHO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>SITUACAO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>OBSERVACAO</td>
<td>VARCHAR (5000)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>PRAZO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>DESCRICAO_PRAZO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>VOLUMES</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>VALOR_ICMS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>027</td>
<td>VALOR_IPI</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>028</td>
<td>VALOR_ISS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>029</td>
<td>VALOR_FRETE</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>030</td>
<td>VALOR_PRODUTOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>031</td>
<td>VALOR_SERVICOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>032</td>
<td>VALOR_TOTAL_BRUTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>033</td>
<td>VALOR_TOTAL_LIQUIDO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>034</td>
<td>VALOR_DESCONTO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>035</td>
<td>VALOR_SEGURO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>036</td>
<td>VALOR_OUTROS_ACRESCIMOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>037</td>
<td>VALOR_OUTROS_DESCONTOS</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>038</td>
<td>CHAVE_NFE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>039</td>
<td>URL_NFE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>040</td>
<td>E_MAIL_NFE</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>041</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>042</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>043</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>044</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>045</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>046</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>047</td>
<td>NUMERO_PEDIDO_ERP</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (NOTA_FISCAL)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">NOTA_FISCAL_ITEM</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* NOTA_FISCAL_ITEM</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>NUMERO_NOTA_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>SERIE_NOTA_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>SEQUENCIA_ITEM</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PRODUTO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>APELIDO_PRODUTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>APELIDO_PRODUTO_COMPLEMENTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>DESCRICAO_PRODUTO</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>DESCRICAO_PRODUTO_2</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>COMPLEMENTO_1</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>DESCRICAO_COMPLEMENTO_1</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>COMPLEMENTO_2</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>DESCRICAO_COMPLEMENTO_2</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>COMPLEMENTO_3</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>DESCRICAO_COMPLEMENTO_3</td>
<td>VARCHAR (250)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>UNIDADE_MEDIA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>QUANTIDADE_TOTAL</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>VALOR_UNITARIO</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>VALOR_TOTAL</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>021</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>022</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>023</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>024</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>025</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>026</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (NOTA_FISCAL_ITEM)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">NOTA_FISCAL_VENDA</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* NOTA_FISCAL_VENDA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>NUMERO_NOTA_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>SERIE_NOTA_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>PEDIDO_VENDEDOR</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>PEDIDO_CLIENTE</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>NUMERO_PEDIDO_ERP</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (NOTA_FISCAL_VENDA)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLASSIFICACAO_FISCAL</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* CLASSIFICACAO_FISCAL</td>
<td>VARCHAR (10) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>ALIQ_IPI</td>
<td>NUMERIC</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>SUBSTITUICAO_TRIBUTARIA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>NCM</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CLASSIFICACAO_FISCAL)</th>
</tr>
</table>
<br>
<br>
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLASSIFICACAO_FISCAL_ESTADO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* CLASSIFICACAO_FISCAL_ESTADO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>CLASSIFICACAO_FISCAL</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>PAIS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>ESTADO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>NOME_ESTADO</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>NOME_PAIS</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>SUBSTITUICAO_TRIBUTARIA</td>
<td>VARCHAR (100)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>ALIQUOTA_INTERNA</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ALIQUOTA_INTERESTADUAL</td>
<td>VARCHAR (10)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (CLASSIFICACAO_FISCAL_ESTADO)</th>
</tr>
</table>
== Dados financeiros dos clientes ==
<br>
'''''FN.TXT TÍTULOS EM ABERTO DOS CLIENTES, VENCIDOS E A VENCER'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">TITULO_FINANCEIRO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>002</td>
<td>* PESSOA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top; text-align: left;">Código do cliente
</td>
</tr>
<tr>
<td>003</td>
<td>* TIPO</td>
<td>VARCHAR (50) (not null)</td>
<td style="vertical-align: top; text-align: left;">Tipo 1 ou 2 - gerar 1
</td>
</tr>
<tr>
<td>004</td>
<td>* ORIGEM</td>
<td>VARCHAR (50) (not null)</td>
<td style="vertical-align: top; text-align: left;">Fatura, Cheque
</td>
</tr>
<tr>
<td>005</td>
<td>* DOCUMENTO</td>
<td>VARCHAR (50) (not null)</td>
<td style="vertical-align: top; text-align: left;">Código/numero do título
</td>
</tr>
<tr>
<td>006</td>
<td>* DESDOBRO</td>
<td>VARCHAR (50) (not null)</td>
<td style="vertical-align: top; text-align: left;">Código/numero da parcela 11, 12, 22, etc
</td>
</tr>
<tr>
<td>007</td>
<td>MOEDA</td>
<td>INTEGER </td>
<td style="vertical-align: top; text-align: left;">Código da moeda - gerar 1 que seria Real
</td>
</tr>
<tr>
<td>008</td>
<td>SITUACAO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top; text-align: left;">A para Aberto, P para Parcial
</td>
</tr>
<tr>
<td>009</td>
<td>DATA_VENCIMENTO</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">dd/mm/aaaa
</td>
</tr>
<tr>
<td>010</td>
<td>VALOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;">Valor original/inicial
</td>
</tr>
<tr>
<td>011</td>
<td>SALDO</td>
<td>INTEGER </td>
<td style="vertical-align: top;">Saldo em aberto/restante mesmo que igual ao inicial ainda
</td>
</tr>
<tr>
<td>012</td>
<td>DATA_EMISSAO</td>
<td>DATE (4) </td>
<td style="vertical-align: top;">dd/mm/aaaa
</td>
</tr>
<tr>
<td>013</td>
<td>VENDEDOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;">código do vendedor
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>016</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>017</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>018</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<td>019</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;">
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PESSOA, TIPO, ORIGEM,
DOCUMENTO, DESDOBRO)</th>
</tr>
</table>
<br>
<br>
'''''IR.TXT INFORMAÇÕES DE CRÉDITO DO CLIENTE, SITUAÇÃO SERASA/SCI/EQUIFAX/'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CLIENTE_CREDITO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* CLIENTE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;">id/código do cliente<br>
</td>
</tr>
<tr>
<td>003</td>
<td>CREDITO_USADO</td>
<td>NUMERIC </td>
<td style="vertical-align: top;">valor já usado do limite de crédito - soma de títulos e pedidos em aberto
</td>
</tr>
<tr>
<td>004</td>
<td>SITUACAO_FINANCEIRA</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;">RATING SPC ou SERASA...
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CLIENTE)</th>
</tr>
</table>
<br>
<br>
== Localização, cidades, estados, países, etc ==
<br>
'''''RE.TXT REGIÃO COMERCIAL/VENDA'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">REGIAO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* REGIAO</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>NOME_REGIAO</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>REGIAO_SUPERIOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>SEQUENCIA_VISITA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>SEQUENCIA_ENTREGA</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>DIA_SEMANA_VISITA</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>DIA_SEMANA_ENTREGA</td>
<td>VARCHAR (1) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>REGIAO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>PERC_DESCONTO_LIBERADO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, REGIAO)</th>
</tr>
</table>
<br>
<br>
'''''CD.TXT CADASTRO DE CIDADES DA EMPRESA'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">CIDADE</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* CIDADE</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>DESCRICAO_CIDADE</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>PAIS</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>UF</td>
<td>VARCHAR (2) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>TRANSPORTADOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>CEP_BASICO</td>
<td>VARCHAR (10) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>DDD</td>
<td>VARCHAR (7) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>DIA_FERIADO_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>MES_FERIADO_1</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>DIA_FERIADO_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>MES_FERIADO_2</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>DIA_FERIADO_3</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>MES_FERIADO_3</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ISENTO_ICMS</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>016</td>
<td>ISENTO_IPI</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>017</td>
<td>ISENTO_PIS</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>018</td>
<td>ISENTO_COFINS</td>
<td>VARCHAR (3) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>019</td>
<td>REGIAO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>020</td>
<td>REGIAO_EXT</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, CIDADE)</th>
</tr>
</table>
<br>
<br>
'''''UF.TXT ESTADO/UF DOS PAÍSES'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">ESTADO</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PAIS</td>
<td>VARCHAR (3) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>* ESTADO</td>
<td>VARCHAR (2) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>004</td>
<td>NOME_ESTADO</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>005</td>
<td>PERC_ICMS</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>006</td>
<td>NOME_PAIS</td>
<td>VARCHAR (50) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>007</td>
<td>TRANSPORTADOR</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>008</td>
<td>REDESPACHO</td>
<td>INTEGER </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>009</td>
<td>SUBSTITUICAO_TRIBUTARIA</td>
<td>VARCHAR (100) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>010</td>
<td>ATRIBUTO_GENERICO_1</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>011</td>
<td>ATRIBUTO_GENERICO_2</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>012</td>
<td>ATRIBUTO_GENERICO_3</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>013</td>
<td>ATRIBUTO_GENERICO_4</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>014</td>
<td>ATRIBUTO_GENERICO_5</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>015</td>
<td>ATRIBUTO_GENERICO_6</td>
<td>VARCHAR (500) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PAIS, ESTADO)</th>
</tr>
</table>
<br>
<br>
'''''PA.TXT PAÍSES'''''
<table border="1" cellspacing="0">
<tr>
<th colspan="4" bgcolor="#a6d8f5">PAIS</th>
</tr>
<tr>
<td bgcolor="#e6e6e6">SEQUÊNCIA</td>
<td bgcolor="#e6e6e6">COLUNA</td>
<td bgcolor="#e6e6e6">TIPO</td>
<td bgcolor="#e6e6e6">OBSERVAÇÃO</td>
</tr>
<tr>
<td>001</td>
<td>* EMPRESA</td>
<td>INTEGER (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>002</td>
<td>* PAIS</td>
<td>VARCHAR (3) (not null)</td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<td>003</td>
<td>NOME_PAIS</td>
<td>VARCHAR (30) </td>
<td style="vertical-align: top;"><br>
</td>
</tr>
<tr>
<th colspan="4">* PRIMARY KEY (EMPRESA, PAIS)</th>
</tr>
</table>