· 7 years ago · Dec 27, 2018, 12:12 PM
1
2 CREATE TABLE "VILLE5"."PCNFSAID"
3 ( "ESPECIE" VARCHAR2(2 BYTE),
4 "SERIE" VARCHAR2(5 BYTE),
5 "NUMNOTA" NUMBER(10,0),
6 "DTSAIDA" DATE NOT NULL ENABLE,
7 "VLTOTAL" NUMBER(12,2),
8 "CODCONT" VARCHAR2(8 BYTE) NOT NULL ENABLE,
9 "CODFISCAL" NUMBER(8,0) NOT NULL ENABLE,
10 "CODCLI" NUMBER(6,0) NOT NULL ENABLE,
11 "CAIXA" NUMBER(8,0) NOT NULL ENABLE,
12 "CODUSUR" NUMBER(4,0) NOT NULL ENABLE,
13 "DTENTREGA" DATE,
14 "COMISSAO" NUMBER(12,2),
15 "VLTOTGER" NUMBER(12,2),
16 "VLTABELA" NUMBER(12,2),
17 "CODFILIAL" VARCHAR2(2 BYTE) NOT NULL ENABLE,
18 "VLDESCONTO" NUMBER(12,2),
19 "TIPOVENDA" VARCHAR2(2 BYTE) NOT NULL ENABLE,
20 "OBS" VARCHAR2(120 BYTE),
21 "VLCUSTOREAL" NUMBER(14,2),
22 "VLCUSTOFIN" NUMBER(14,2),
23 "VLFRETE" NUMBER(14,2),
24 "VLOUTRASDESP" NUMBER(14,2),
25 "TOTPESO" NUMBER(18,6),
26 "TOTVOLUME" NUMBER(18,6),
27 "CODPRACA" NUMBER(6,0) NOT NULL ENABLE,
28 "NUMITENS" NUMBER(4,0),
29 "CODEMITENTE" NUMBER(8,0),
30 "DTCANCEL" DATE,
31 "NUMCAR" NUMBER(8,0),
32 "CODCOB" VARCHAR2(4 BYTE),
33 "NUMPED" NUMBER(10,0),
34 "STRIBUT" NUMBER(14,2),
35 "ICMSRETIDO" NUMBER(14,2),
36 "BCST" NUMBER(14,2),
37 "CODDEVOL" NUMBER(4,0),
38 "NFFORNEC" NUMBER(10,0),
39 "CODFORNEC" NUMBER(6,0),
40 "CODDOC" VARCHAR2(4 BYTE),
41 "NUMTRANSVENDA" NUMBER(10,0) NOT NULL ENABLE,
42 "CODPLPAG" NUMBER(4,0),
43 "CODFUNCCANCEL" NUMBER(8,0),
44 "NUMTAB" NUMBER(4,0),
45 "NUMSEQ" NUMBER(20,0),
46 "CODSUPERVISOR" NUMBER(4,0),
47 "CONDVENDA" NUMBER(5,0),
48 "VLDEVOLUCAO" NUMBER(14,2),
49 "VLBASEIPI" NUMBER(14,2),
50 "VLIPI" NUMBER(12,2),
51 "VLICMSANTECIPADO" NUMBER(12,2),
52 "CODEPTO" NUMBER(6,0),
53 "VLTOTALNF" NUMBER(12,2),
54 "CODFILIALNF" VARCHAR2(2 BYTE),
55 "UF" VARCHAR2(2 BYTE),
56 "VLBASE" NUMBER(12,2),
57 "VLICMS" NUMBER(12,2),
58 "VLISENTAS" NUMBER(12,2),
59 "VLOUTRAS" NUMBER(12,2),
60 "NUMIDF" VARCHAR2(30 BYTE),
61 "NUMFORMULARIO" NUMBER(10,0),
62 "VLCUSTOREP" NUMBER(14,2),
63 "VLCUSTOCONT" NUMBER(14,2),
64 "DTDEVOL" DATE,
65 "NUMSELONF" NUMBER(10,0),
66 "NUMSEQMONTAGEM" NUMBER(4,0),
67 "NUMVOLUME" NUMBER(9,0),
68 "VLRECEBIDODIN" NUMBER(10,2),
69 "VLRECEBIDOCH" NUMBER(10,2),
70 "VLRECEBIDOBOLETO" NUMBER(10,2),
71 "VLTROCO" NUMBER(10,2),
72 "NUMCUPOM" NUMBER(10,0),
73 "CODFUNCLIBENT" NUMBER(8,0),
74 "DTLIBENT" DATE,
75 "VLDESCPROM" NUMBER(12,2),
76 "NUMVIAS" NUMBER(4,0),
77 "CODCONTRATO" NUMBER(6,0),
78 "FRETEDESPACHO" VARCHAR2(1 BYTE),
79 "FRETEREDESPACHO" VARCHAR2(1 BYTE),
80 "CODFORNECFRETE" NUMBER(6,0),
81 "VLRECEBIDOCARTAO" NUMBER(12,2),
82 "NUMTRANSVENDAORIGEM" NUMBER(10,0),
83 "CODFUNCLANC" NUMBER(8,0),
84 "DTCANHOTO" DATE,
85 "NUMTRANSVENDADESTINO" NUMBER(10,0),
86 "CODUSUR3" NUMBER(4,0),
87 "CODUSUR2" NUMBER(4,0),
88 "VLISS" NUMBER(18,6),
89 "CODSUPERVISOR2" NUMBER(4,0),
90 "CODSUPERVISOR3" NUMBER(4,0),
91 "COMISSAO2" NUMBER(12,2),
92 "COMISSAO3" NUMBER(12,2),
93 "HORALANC" VARCHAR2(2 BYTE),
94 "MINUTOLANC" VARCHAR2(2 BYTE),
95 "ROTINALANC" VARCHAR2(48 BYTE),
96 "EQUIPLANC" VARCHAR2(64 BYTE),
97 "FUNCLANC" VARCHAR2(30 BYTE),
98 "VLFRETENF" NUMBER(12,2),
99 "NUMLANCCP" NUMBER(8,0),
100 "PRAZOMEDIO" NUMBER(4,0),
101 "PRAZOADICIONAL" NUMBER(4,0),
102 "DTWMS" DATE,
103 "VILNUMNOTAORIGEM" NUMBER(10,0),
104 "VILNUMTRANSENT" NUMBER(10,0),
105 "PRAZOPONDERADO" VARCHAR2(1 BYTE) DEFAULT 'N',
106 "SERIEECF" VARCHAR2(2 BYTE),
107 "NUMSERIEEQUIP" VARCHAR2(30 BYTE),
108 "NUMNFTRANSF" NUMBER(10,0),
109 "TIPODEVOL" VARCHAR2(2 BYTE),
110 "ENTRADACONFIRMADA" VARCHAR2(1 BYTE),
111 "ICMSRETIDOGNRE" NUMBER(14,2),
112 "DTCONFIRMACAO" DATE,
113 "VLIR" NUMBER(18,6),
114 "VLBONIFIC" NUMBER(16,3),
115 "BCSTGNRE" NUMBER(14,2),
116 "CODCLINF" NUMBER(6,0),
117 "USURARIODTCONFIRMACAO" NUMBER(8,0),
118 "VILRPFMONTADO" VARCHAR2(1 BYTE),
119 "VILDTMONTAGEMRPF" DATE,
120 "VILNUMRPF" NUMBER(10,0),
121 "PERCFRETE" NUMBER(8,4),
122 "NUMREGIAOFRETE" NUMBER(4,0),
123 "NUMORCA" NUMBER(10,0),
124 "NUMVIASPU" NUMBER(4,0),
125 "CODCONDICAOVENDA" NUMBER(6,0),
126 "TOTVLDESCFIN" NUMBER(18,6),
127 "TOTVLDESCCOM" NUMBER(18,6),
128 "TOTVLBONIFIC" NUMBER(18,6),
129 "TOTVLDESCFLEX" NUMBER(18,6),
130 "TOTVLREDCOMISS" NUMBER(18,6),
131 "COMISSAOSUP" NUMBER(18,6),
132 "DTEMISSAONFFORNEC" DATE,
133 "TOTVLREDCOMISSSUP" NUMBER(18,6),
134 "TIPOFRETE" VARCHAR2(1 BYTE),
135 "NUMCAIXAFISCAL" NUMBER(4,0),
136 "DTHORACHEGADA" DATE,
137 "DTHORASAIDA" DATE,
138 "KMFINALENTREGA" NUMBER(12,2),
139 "BROKER" VARCHAR2(1 BYTE),
140 "PERBASEREDOUTRASDESP" NUMBER(8,2),
141 "APRESENTOUCUPOMPROMOCAO" VARCHAR2(1 BYTE),
142 "NSU" NUMBER(10,0),
143 "DTNSU" DATE,
144 "VLVERBACMVCLI" NUMBER(18,6),
145 "ESPECIEVOLUME" VARCHAR2(100 BYTE),
146 "MARCARVOLUME" VARCHAR2(100 BYTE),
147 "USAINTEGRACAOWMS" VARCHAR2(1 BYTE),
148 "ENVIADANFE" VARCHAR2(1 BYTE),
149 "AUTENTPGTOGNRE" VARCHAR2(200 BYTE),
150 "BANCOPGTOGNRE" VARCHAR2(50 BYTE),
151 "AGENCIAPGTOGNRE" VARCHAR2(30 BYTE),
152 "VENDAASSISTIDA" VARCHAR2(1 BYTE),
153 "CODEMITENTEPEDIDO" NUMBER(8,0),
154 "PERCCOMPROFISSIONAL" NUMBER(8,4),
155 "CLIENTE" VARCHAR2(60 BYTE),
156 "CGC" VARCHAR2(18 BYTE),
157 "IE" VARCHAR2(15 BYTE),
158 "TIPOFJ" VARCHAR2(1 BYTE),
159 "CONSUMIDORFINAL" VARCHAR2(1 BYTE),
160 "CODATV1" NUMBER(6,0),
161 "CODPAIS" NUMBER(6,0),
162 "DESCPAIS" VARCHAR2(60 BYTE),
163 "CGCFILIAL" VARCHAR2(14 BYTE),
164 "IEFILIAL" VARCHAR2(20 BYTE),
165 "UFFILIAL" VARCHAR2(2 BYTE),
166 "AGREGARSTPRODSINTEGRA" VARCHAR2(1 BYTE),
167 "TIPOALIQOUTRASDESP" VARCHAR2(1 BYTE),
168 "IESUBSTTRIBUT" VARCHAR2(20 BYTE),
169 "UFCODIGO" VARCHAR2(2 BYTE),
170 "HISTORICO" VARCHAR2(1 BYTE),
171 "SUBSERIE" VARCHAR2(2 BYTE),
172 "ENVIADA" VARCHAR2(1 BYTE),
173 "NUMLOTENFE" VARCHAR2(15 BYTE),
174 "DTEXPORTACAOSERVINT" DATE,
175 "EXPORTADOSERVINT" VARCHAR2(1 BYTE),
176 "IMPORTADOSERVPRINC" VARCHAR2(1 BYTE),
177 "DTIMPORTACAOSERVPRINC" DATE,
178 "NUMTRANSVENDAECF" NUMBER(10,0),
179 "CHAVENFE" VARCHAR2(45 BYTE),
180 "SITUACAONFE" NUMBER(10,0),
181 "PROTOCOLONFE" VARCHAR2(16 BYTE),
182 "DTHORANFE" DATE,
183 "IEENT" VARCHAR2(15 BYTE),
184 "DTPGTOCAMPANHA" DATE,
185 "NUMECF" NUMBER(10,0),
186 "TENTATIVAENVIONFE" NUMBER(4,0),
187 "GERACP" VARCHAR2(1 BYTE) DEFAULT 'N',
188 "RESERVARITENSTV7" VARCHAR2(1 BYTE),
189 "NUMPREVENDA" NUMBER(10,0),
190 "GERACAORAZAOAUXILIAR" VARCHAR2(1 BYTE),
191 "NUMORCAFILIAL" NUMBER(10,0),
192 "NUMREGIAO" NUMBER(4,0),
193 "VLPIS" NUMBER(18,6),
194 "PERDESCFIN" NUMBER(12,6),
195 "CODCLIRECEBEDOR" NUMBER(6,0),
196 "NUMCARANTERIOR" NUMBER(8,0),
197 "NUMOP" NUMBER(8,0),
198 "ALIQUOTA" NUMBER(7,2),
199 "CODCONSIGNATARIOFRETE" NUMBER(8,0),
200 "CODEXPORTADOR" NUMBER(6,0),
201 "UFDESEMBARACO" VARCHAR2(2 BYTE),
202 "LOCALDESEMBARACO" VARCHAR2(30 BYTE),
203 "CODREMETENTEFRETE" NUMBER(6,0),
204 "CODDESTINATARIOFRETE" NUMBER(6,0),
205 "CODVEICULO" NUMBER(4,0),
206 "CODMOTORISTA" NUMBER(8,0),
207 "CODPRACADESTFRETE" NUMBER(6,0),
208 "OBSCONHECFRETE" VARCHAR2(400 BYTE),
209 "VLSECCAT" NUMBER(18,6),
210 "VLDESPACHO" NUMBER(18,6),
211 "VLLTR" NUMBER(18,6),
212 "VLPEDAGIO" NUMBER(18,6),
213 "VLSEGURO" NUMBER(18,6),
214 "CODUSUR4" NUMBER(6,0),
215 "COMISSAO4" NUMBER(12,2),
216 "CLIENTEFONTEST" VARCHAR2(1 BYTE),
217 "ORGAOPUB" VARCHAR2(1 BYTE),
218 "TRANSPORTADORA" VARCHAR2(60 BYTE),
219 "CODCLIFILIAL" NUMBER(6,0),
220 "CGCFRETE" VARCHAR2(18 BYTE),
221 "IEFRETE" VARCHAR2(15 BYTE),
222 "UFFRETE" VARCHAR2(2 BYTE),
223 "VLPAUTAFRETE" NUMBER(12,2),
224 "COBRANCA" VARCHAR2(30 BYTE),
225 "ENDERECO" VARCHAR2(40 BYTE),
226 "BAIRRO" VARCHAR2(40 BYTE),
227 "MUNICIPIO" VARCHAR2(30 BYTE),
228 "CEP" VARCHAR2(10 BYTE),
229 "SULFRAMA" VARCHAR2(15 BYTE),
230 "CODMUNICIPIO" NUMBER(10,0),
231 "PLACAVEIC" VARCHAR2(10 BYTE),
232 "CODCONTCLI" NUMBER(10,0),
233 "CODIBGE" NUMBER(10,0),
234 "TIPOEMPRESA" VARCHAR2(4 BYTE),
235 "CODFISCALFRETE" NUMBER(4,0),
236 "PERCICMFRETE" NUMBER(4,2),
237 "CODFISCALOUTRASDESP" NUMBER(4,0),
238 "ALIQICMOUTRASDESP" NUMBER(4,2),
239 "ATACADISTA" VARCHAR2(1 BYTE),
240 "VLINSS" NUMBER(18,6),
241 "PROTOCOLONFECAN" VARCHAR2(16 BYTE),
242 "PROTOCOLONFEAUTO" VARCHAR2(16 BYTE),
243 "COMISSAOMOT" NUMBER(12,2),
244 "DTPAGCOMISSAOPROF" DATE,
245 "TIPOEMISSAO" VARCHAR2(1 BYTE) DEFAULT '1',
246 "VILGERANFVENDA" VARCHAR2(1 BYTE),
247 "VLCOFINS" NUMBER(24,6),
248 "VILVALORRPF" NUMBER(14,2),
249 "DTLANCTO" DATE,
250 "RECARGA" VARCHAR2(1 BYTE),
251 "DTFECHACCRCA" DATE,
252 "CONTRIBUINTE" VARCHAR2(1 BYTE),
253 "DTCANCELWMS" DATE,
254 "CODFISCALNF" NUMBER(8,0),
255 "DTHORARECIBODPEC" DATE,
256 "NUMTRANSVENDACONHEC" NUMBER(14,2),
257 "VLDESPDENTRONF" NUMBER(14,2),
258 "DTHORAAUTORIZACAOSEFAZ" DATE,
259 "RECIBONFE" VARCHAR2(20 BYTE),
260 "LOTEDPEC" VARCHAR2(20 BYTE),
261 "RECIBODPEC" VARCHAR2(20 BYTE),
262 "AMBIENTE" VARCHAR2(1 BYTE),
263 "PROTOCOLOCANCELAMENTO" VARCHAR2(20 BYTE),
264 "DTHORACANCELAMENTOSEFAZ" DATE,
265 "DTFECHA" DATE,
266 "NUMCONTRATO" NUMBER(8,0),
267 "OBSNFE" CLOB,
268 "TOTDIFALIQUOTAS" NUMBER(14,2),
269 "DTLIBERACAOENTREGA" DATE,
270 "CODFUNCLIBERACAOENTREGA" NUMBER(8,0),
271 "CODPRODPREDOMINANTE" NUMBER(6,0),
272 "TOTPESOLIQ" NUMBER(18,6),
273 "TOTPESOAGRUPADO" NUMBER(18,6),
274 "TOTPESOLIQAGRUPADO" NUMBER(18,6),
275 "TOTVOLUMEAGRUPADO" NUMBER(18,6),
276 "VENDATRIANGULAR" VARCHAR2(1 BYTE),
277 "SITUACAOCTE" NUMBER(10,0),
278 "RECIBOCTE" VARCHAR2(20 BYTE),
279 "PROTOCOLOCTE" VARCHAR2(16 BYTE),
280 "CHAVECTE" VARCHAR2(44 BYTE),
281 "NUMLOTECTE" VARCHAR2(15 BYTE),
282 "DTA_HORAENVIOSEFAZ" DATE,
283 "AMBIENTECTE" VARCHAR2(1 BYTE),
284 "AMBIENTENFE" VARCHAR2(1 BYTE),
285 "NUMSEQENTREGA" NUMBER(20,0),
286 "HORAEMISSAO" VARCHAR2(8 BYTE),
287 "CONTADORCUPOMFISCAL" NUMBER(6,0),
288 "VLFRETERETIDO" NUMBER(14,2),
289 "VLSTFRETERETIDO" NUMBER(14,2),
290 "PERCFRETERETIDO" NUMBER(8,4),
291 "PERCSTFRETERETIDO" NUMBER(8,4),
292 "PRAZO1" NUMBER(4,0),
293 "PRAZO2" NUMBER(4,0),
294 "PRAZO3" NUMBER(4,0),
295 "PRAZO4" NUMBER(4,0),
296 "PRAZO5" NUMBER(4,0),
297 "PRAZO6" NUMBER(4,0),
298 "PRAZO7" NUMBER(4,0),
299 "PRAZO8" NUMBER(4,0),
300 "PRAZO9" NUMBER(4,0),
301 "PRAZO10" NUMBER(4,0),
302 "PRAZO11" NUMBER(4,0),
303 "PRAZO12" NUMBER(4,0),
304 "JUSTIFICATIVACONTIGENCIA" VARCHAR2(256 BYTE),
305 "DTAHORAENTRADACONTIGENCIA" DATE,
306 "CUSTOBONIFICACAO" VARCHAR2(1 BYTE),
307 "CODFORNECBONIFIC" NUMBER(6,0),
308 "CODBNF" NUMBER(4,0),
309 "TOTPESOBRUTO" NUMBER(18,6),
310 "DTSAIDANF" DATE,
311 "CNPJCISP" VARCHAR2(8 BYTE),
312 "CONSUMIUNUMNFE" VARCHAR2(1 BYTE),
313 "CONFERIDO" VARCHAR2(1 BYTE),
314 "DATAEMPENHO" DATE,
315 "CODUNIDADEEXECUTORA" VARCHAR2(20 BYTE),
316 "VALORST" NUMBER(12,2),
317 "MENSAGEMPISCOFINS" VARCHAR2(4000 BYTE),
318 "VLDESCICMS" NUMBER(14,2),
319 "VLTOTALSEMDESCICMS" NUMBER(12,2),
320 "NUMEMPENHO" VARCHAR2(20 BYTE),
321 "OBSEXP" VARCHAR2(200 BYTE),
322 "CONTAORDEM" VARCHAR2(1 BYTE),
323 "DTHORACTE" DATE,
324 "TENTATIVAENVIOCTE" NUMBER(10,0),
325 "PROTOCOLOCANCELAMENTOCTE" VARCHAR2(20 BYTE),
326 "CODFORNECREDESPACHO" NUMBER(6,0),
327 "EMAILFRETE" VARCHAR2(100 BYTE),
328 "EMAILFRETEREDESPACHO" VARCHAR2(100 BYTE),
329 "OBSPISCOFINS" VARCHAR2(500 BYTE),
330 "VLBASEPISCOFINS" NUMBER(12,2),
331 "PERPIS" NUMBER(8,4),
332 "PERCOFINS" NUMBER(8,4),
333 "CODSITTRIBPISCOFINS" NUMBER(3,0),
334 "SITDOC" VARCHAR2(2 BYTE),
335 "TELEFONE" VARCHAR2(20 BYTE),
336 "NUMENDERECO" VARCHAR2(6 BYTE),
337 "EMAILDEST" VARCHAR2(100 BYTE),
338 "UFPLACAVEIC" VARCHAR2(2 BYTE),
339 "DTEXPORTACAOWMS" DATE,
340 "DTIMPORTACAOWMS" DATE,
341 "NFATUALWMS" VARCHAR2(1 BYTE),
342 "FINALIDADENFE" VARCHAR2(2 BYTE),
343 "SERIEORIGINAL" VARCHAR2(3 BYTE),
344 "DESPESASRATEADA" VARCHAR2(1 BYTE),
345 "NUMTRANSENTORIGEM" NUMBER(10,0),
346 "FORNECENTREGA" VARCHAR2(1 BYTE),
347 "DTFAT" DATE,
348 "CODGERENTE" NUMBER(4,0),
349 "NUMPEDCLI" VARCHAR2(15 BYTE),
350 "MOTORISTAVEICULO" VARCHAR2(40 BYTE),
351 "CONSUMIUNUMCTE" VARCHAR2(1 BYTE),
352 "UTILIZAIPICALCICMS" VARCHAR2(1 BYTE),
353 "NUMOS" NUMBER(8,0),
354 "WMSCODFUNCIGNORA" NUMBER(8,0),
355 "WMSIGNORADO" VARCHAR2(1 BYTE),
356 "PISRETIDO" VARCHAR2(1 BYTE),
357 "INSSRETIDO" VARCHAR2(1 BYTE),
358 "IRRRETIDO" VARCHAR2(1 BYTE),
359 "NUMTRANSENTDEST" NUMBER(10,0),
360 "DTDENEGADA" DATE,
361 "ENTREGA" VARCHAR2(1 BYTE),
362 "TAXAENTREGA" NUMBER(14,2),
363 "UFPLACAVEI" VARCHAR2(2 BYTE),
364 "NORMAREGESPECIAL" VARCHAR2(250 BYTE),
365 "TIPOEMISSAOCTE" VARCHAR2(2 BYTE),
366 "COFINSRETIDO" VARCHAR2(1 BYTE),
367 "GERANFVENDA" VARCHAR2(1 BYTE),
368 "NUMCONTRATOCARRETEIRO" VARCHAR2(20 BYTE),
369 "VLDESCABATIMENTO" NUMBER(18,6),
370 "NUMLISTA" NUMBER(6,0),
371 "DEVSIMBOLICA" VARCHAR2(1 BYTE),
372 "VLIPIOUTRAS" NUMBER(18,6),
373 "PROTOCOLO" VARCHAR2(50 BYTE),
374 "CODVEICULO1" NUMBER(4,0),
375 "CODVEICULO2" NUMBER(4,0),
376 "CSLLRETIDO" VARCHAR2(1 BYTE),
377 "GERARBCRNFE" VARCHAR2(1 BYTE),
378 "NUMCARGAEDI" NUMBER(8,0),
379 "DEPOSITOFECHADO" VARCHAR2(1 BYTE),
380 "OBSNFCARREG" VARCHAR2(255 BYTE),
381 "DTEMISSAODECLARACAO" DATE,
382 "MOTESTORNONFE" VARCHAR2(250 BYTE),
383 "NATOPERNFE" VARCHAR2(60 BYTE),
384 "VENDAEXPORTACAO" VARCHAR2(1 BYTE),
385 "ENVIADOEMAILCANCELADO" VARCHAR2(1 BYTE),
386 "SITUACAONFEORIG" NUMBER(10,0),
387 "NUMTRANSVENDATV13" NUMBER(10,0),
388 "CODMEDICOPRESCRIT" NUMBER(6,0),
389 "IDINTEGRACAOMYFROTA" RAW(16) DEFAULT SYS_GUID(),
390 "NUMPEDVANXML" VARCHAR2(20 BYTE),
391 "CNPJFORNEC" VARCHAR2(18 BYTE),
392 "NUMCOMPROVANTE" NUMBER(20,0),
393 "CNPJRESPONSAVEL" VARCHAR2(18 BYTE),
394 "INUTILIZADA" VARCHAR2(1 BYTE),
395 "AGREGASTVLMERC" VARCHAR2(1 BYTE),
396 "SIMPLESNACIONAL" VARCHAR2(1 BYTE),
397 "RESPSEGURO" NUMBER(1,0),
398 "NOMESEGURADORA" VARCHAR2(30 BYTE),
399 "NUMEROAPOLICE" VARCHAR2(20 BYTE),
400 "NUMEROAVERBACAO" VARCHAR2(40 BYTE),
401 "VLRAVERBACAO" NUMBER(13,2),
402 "VLTRIBUTOS" NUMBER(14,2),
403 "CARTAODOTZ" VARCHAR2(18 BYTE),
404 "CNPJCOLETA" VARCHAR2(18 BYTE),
405 "RAZAOSOCIALCOLETA" VARCHAR2(60 BYTE),
406 "LOGRADOUROCOLETA" VARCHAR2(60 BYTE),
407 "NUMEROCOLETA" VARCHAR2(60 BYTE),
408 "COMPLEMENTOCOLETA" VARCHAR2(60 BYTE),
409 "BAIRROCOLETA" VARCHAR2(60 BYTE),
410 "CODCIDADECOLETA" NUMBER(6,0),
411 "CNPJFORNECPEDAGIO" VARCHAR2(18 BYTE),
412 "NUMVALEPEDAGIO" VARCHAR2(20 BYTE),
413 "CPNJRESPONSAVELPEDAGIO" VARCHAR2(18 BYTE),
414 "VALORPEDAGIO" NUMBER(13,2),
415 "NUMTRANSCTEANUL" NUMBER(10,0),
416 "NUMTRANSCTESUBS" NUMBER(10,0),
417 "CHAVECTEREF" VARCHAR2(45 BYTE),
418 "CNPJCPFCTEREF" VARCHAR2(18 BYTE),
419 "IECTEREF" VARCHAR2(20 BYTE),
420 "RAZAOSOCIALCTEREF" VARCHAR2(60 BYTE),
421 "TIPODOCCTEREF" VARCHAR2(2 BYTE),
422 "SERIEDOCCTEREF" VARCHAR2(3 BYTE),
423 "SUBSERIEDOCCTEREF" VARCHAR2(2 BYTE),
424 "NUMDOCCTEREF" VARCHAR2(20 BYTE),
425 "DTEMISSAOCTEREF" DATE,
426 "ORGAOPUBMUNICIPAL" VARCHAR2(1 BYTE),
427 "ORGAOPUBFEDERAL" VARCHAR2(1 BYTE),
428 "CHAVECTEANULACAO" VARCHAR2(45 BYTE),
429 "CHAVECTESUBSTITUICAO" VARCHAR2(45 BYTE),
430 "CHAVECTETOMADORSUB" VARCHAR2(45 BYTE),
431 "CHAVENFETOMADORSUB" VARCHAR2(45 BYTE),
432 "CNPJCPFEMITENTESUB" VARCHAR2(14 BYTE),
433 "DTEMISSAODOCSUB" DATE,
434 "MODELODOCSUB" VARCHAR2(2 BYTE),
435 "NSUSOCIOTORCEDOR" VARCHAR2(15 BYTE),
436 "NUMERODOCSUB" NUMBER(10,0),
437 "SERIEDOCSUB" VARCHAR2(3 BYTE),
438 "SUBSERIEDOCSUB" VARCHAR2(3 BYTE),
439 "TIPODOCUMENTOSUB" VARCHAR2(3 BYTE),
440 "UFCTEREF" VARCHAR2(2 BYTE),
441 "VALORDOCSUB" NUMBER(13,2),
442 "VERSAOROTINA" VARCHAR2(20 BYTE),
443 "VLDESCSOCIOTORCEDOR" NUMBER(18,2),
444 "CODFORNECFRETECTEREF" NUMBER(6,0),
445 "CODPRODNFAJUSTE" VARCHAR2(60 BYTE),
446 "CTECODTOMADORSERVICO" NUMBER(6,0),
447 "CTECODTRANSPSUBCONTRATADO" NUMBER(6,0),
448 "CTECODTRANSPSUBCONTRATANTE" NUMBER(6,0),
449 "CTECODVEICULOSUBCONTRATANTE" NUMBER(6,0),
450 "CTESUBCONTRATADOCHAVECTEREF" VARCHAR2(45 BYTE),
451 "DESCRICAOPRODNFAJUSTE" VARCHAR2(120 BYTE),
452 "DTPAGDOTZ" DATE,
453 "IDLOCALDESTMERC" VARCHAR2(1 BYTE),
454 "IDTIPOPRESENCA" VARCHAR2(2 BYTE),
455 "NCMNFAJUSTE" VARCHAR2(8 BYTE),
456 "NUMCHAVEEXP" VARCHAR2(44 BYTE),
457 "NUMDRAWBACK" NUMBER(11,0),
458 "NUMREGEXP" NUMBER(12,0),
459 "OBSNFAJUSTE" VARCHAR2(1000 BYTE),
460 "ROTINACADCTE" VARCHAR2(48 BYTE),
461 "UNIDADENFAJUSTE" VARCHAR2(6 BYTE),
462 "VLBONIFICACERTO" NUMBER(14,2),
463 "VLSUBTOTAL" NUMBER(18,2),
464 "VLTOTBRUTOPRODAJUSTE" NUMBER(18,2),
465 "VILICMSRETIDO" NUMBER(14,2),
466 "VILBCST" NUMBER(14,2),
467 "CODRECEBFRETECTEREF" NUMBER(6,0),
468 "TIPOSERVICOCTE" VARCHAR2(1 BYTE),
469 "TIPOSUBCONTRATACAOCTE" VARCHAR2(1 BYTE),
470 "TIPOPRESENCAADQUIRINTE" VARCHAR2(1 BYTE),
471 "DOCEMISSAO" VARCHAR2(2 BYTE),
472 "VLGRIS" NUMBER(12,2),
473 "VLDESPPEDAGIO" NUMBER(12,2),
474 "VLTAS" NUMBER(12,2),
475 "FORMULARIO" NUMBER(10,0),
476 "NUMNOTAMANIF" NUMBER(10,0),
477 "NUMREMESSA" NUMBER(10,0),
478 "ORIGEMFRETE" VARCHAR2(1 BYTE),
479 "SELO" VARCHAR2(20 BYTE),
480 "TIPOMOVGARANTIA" NUMBER(3,0),
481 "NUMCIRURGIA" NUMBER(10,0),
482 "UTILIZAEXPDIVERSOS" VARCHAR2(1 BYTE),
483 "SITUACAONFEEPEC" NUMBER(3,0),
484 "PROTOCOLONFEEPEC" VARCHAR2(15 BYTE),
485 "DATAHORAREGISTROEPEC" DATE,
486 "NUMTRANSENTORIGCONSIG" NUMBER(10,0),
487 "NUMFECHAMENTOMOVCX" NUMBER(10,0),
488 "DTMOVIMENTOCX" DATE,
489 "IDENTIFICARCLIENTENFCE" VARCHAR2(1 BYTE),
490 "MD5LISTAARQ" VARCHAR2(300 BYTE),
491 "VENDANFSERIED" VARCHAR2(1 BYTE),
492 "NUMSERIESAT" VARCHAR2(13 BYTE),
493 "CHAVESAT" VARCHAR2(400 BYTE),
494 "SITUACAOSAT" VARCHAR2(2 BYTE),
495 "EMISSNUMAUTOMATICO" VARCHAR2(1 BYTE) DEFAULT 'S',
496 "DATAHORAEMISSAOSAT" DATE,
497 "QRCODESAT" VARCHAR2(4000 BYTE),
498 "VLBOLETO" NUMBER(14,2),
499 "NUMTRANSENTNFESTORNADA" NUMBER(10,0),
500 "NOTADUPLIQUESVC" VARCHAR2(1 BYTE),
501 "TIPOINSCPRESTSERV" NUMBER(1,0),
502 "INDICPRESTSERV" NUMBER(1,0),
503 "NUMCOLETA_AUX" VARCHAR2(20 BYTE),
504 "NUMTRANSENTDEPENDENTE" NUMBER(10,0),
505 "NUMTRANSVENDADEPENDENTE" NUMBER(10,0),
506 "ROTINACAD" VARCHAR2(48 BYTE),
507 "NUMCOLETA" VARCHAR2(10 BYTE),
508 "NOMEARQUIVODOTZ" VARCHAR2(100 BYTE),
509 "NOMEARQUIVODOTZESTORNO" VARCHAR2(100 BYTE),
510 "PONTOSDOTZ" NUMBER(6,0),
511 "VLBASERETENCAO" NUMBER(18,6),
512 "CODRETENCAOCPRB" NUMBER(1,0),
513 "TRANSFDEP" VARCHAR2(1 BYTE),
514 "TIPOTRANSFENTREDEPOSITO" VARCHAR2(1 BYTE),
515 "CODSTATUSSAT" NUMBER(10,0),
516 "NUMVIASGNRE" NUMBER(4,0),
517 "QTDEREPROCNFE" NUMBER(6,0),
518 "HORASAIDA" NUMBER(2,0),
519 "MINUTOSAIDA" NUMBER(2,0),
520 "CTEREGIMEESPECIAL" VARCHAR2(1 BYTE) DEFAULT 'N',
521 "NFDEVENTFUTURA" VARCHAR2(1 BYTE),
522 "VILNUMNOTA_ANTERIOR" NUMBER(10,0),
523 "PERDESCFINTOT" NUMBER(18,6),
524 "VLDESCFIN" NUMBER(18,6),
525 "QRCODENFCE" VARCHAR2(500 BYTE),
526 "HORAENTREGA" NUMBER(2,0),
527 "MINUTOENTREGA" NUMBER(2,0),
528 "DTPAGCOMISSAO" DATE,
529 "UIDREGISTRO" NUMBER(10,0),
530 "IDPARCEIRO" VARCHAR2(15 BYTE),
531 "ASSINATURA" VARCHAR2(100 BYTE),
532 "VILTRANSFDEAVARIA" VARCHAR2(1 BYTE),
533 "DTPAGCOMISSAOOP" DATE,
534 "IMPRIMIUDACTEJUNTODANFE" VARCHAR2(1 BYTE),
535 "NUMNOTAVINCULADA" NUMBER(10,0),
536 "TIPODOCARRECGNRE" VARCHAR2(1 BYTE),
537 "UFBENEFICIARIA" VARCHAR2(2 BYTE),
538 "NUMDOCARREC" VARCHAR2(255 BYTE),
539 "CODAUTENTICACAO" VARCHAR2(255 BYTE),
540 "VLDOCARRECADACAO" NUMBER(20,6),
541 "DTVENCARREC" DATE,
542 "DTPAGARREC" DATE,
543 "VLOPERACAOFRETE" NUMBER(14,2),
544 "VLBASESTFRETE" NUMBER(14,2),
545 "VLICMSSTFRETE" NUMBER(14,2),
546 "CTEGLOBALIZADO" VARCHAR2(1 BYTE),
547 "TOMADORCTE" NUMBER(1,0),
548 "VLCSLL" NUMBER(18,6),
549 "CNPJSEGURADORA" VARCHAR2(14 BYTE),
550 "INFGLOBALIZADO" VARCHAR2(256 BYTE),
551 "QTDEREPROCCTE" NUMBER(6,0) DEFAULT '0',
552 "PERCENTUALSTFRETE" NUMBER(14,2),
553 "CODEDITAL" NUMBER(9,0),
554 "FIL_MONTARKITAUTOMATICAMENTE" VARCHAR2(1 BYTE),
555 "PAGCHEQUEMORADIA" VARCHAR2(1 BYTE),
556 "HORAINICIO" VARCHAR2(8 BYTE),
557 "HORAFIM" VARCHAR2(8 BYTE),
558 "USAMULTUNIDITEM" VARCHAR2(1 BYTE),
559 "CONDFINANC" VARCHAR2(9 BYTE),
560 "NUMNOTAORIGEM" NUMBER(10,0),
561 "PLANOSUPPLI" NUMBER(2,0),
562 "TIPOREMESSA" VARCHAR2(1 BYTE),
563 "CODTRANSPAUTONOMO" NUMBER(10,0),
564 "VLTRANSPAUTONOMO" NUMBER(18,6),
565 "TRANSPAUTONOMO" VARCHAR2(1 BYTE),
566 "GERARCPTRANSPAUNOTOMO" VARCHAR2(1 BYTE),
567 "CODFORNECTRANSPAUTONOMO" NUMBER(10,0),
568 "CODCOBSEFAZ" VARCHAR2(4 BYTE),
569 "NUMSESSAOSAT" NUMBER(10,0),
570 "CODSEFAZSAT" NUMBER(10,0),
571 "VLTOTALFCPST" NUMBER(18,6),
572 "VLTOTALFCPICMS" NUMBER(18,6),
573 "DIGITOVERIFICADORNFSE" VARCHAR2(100 BYTE),
574 "LINKNFSE" VARCHAR2(100 BYTE),
575 "PROTOCOLONFSE" VARCHAR2(16 BYTE),
576 "SERIERPS" VARCHAR2(3 BYTE),
577 "NUMERORPS" NUMBER(10,0),
578 "SITUACAONFSE" NUMBER(10,0),
579 "NUMNOTANFSE" NUMBER(18,0),
580 "VLFRETEOUTRASDESP" NUMBER(14,2),
581 "VLTOTALNFCOMPOEMCTE" NUMBER(22,6),
582 "MD5PAF" VARCHAR2(200 BYTE),
583 "VILVLDOACAO" NUMBER(12,2),
584 "DEDUZIRDESONERORGAOPUB" VARCHAR2(1 BYTE),
585 "TIPOCONTACORRENTE" VARCHAR2(1 BYTE),
586 "NUMEROPROCESSO" VARCHAR2(14 BYTE),
587 "TIPOPROCESSO" VARCHAR2(1 BYTE),
588 "CODIGOINDICATIVOSUSPENSAO" VARCHAR2(14 BYTE),
589 "CODPROMOCAOMED" NUMBER(9,0),
590 "CODPLPAGETICO" NUMBER(4,0),
591 "CODPLPAGGENERICO" NUMBER(4,0),
592 "VLPUNITMED" NUMBER(12,2),
593 "MATERIALDECONSTRUCAO" VARCHAR2(1 BYTE),
594 "VILCODCLI" NUMBER(6,0),
595 "VILVALORDESCFUNC" NUMBER(12,2),
596 "DEDUZIRICMSBASEPISCOFINS" VARCHAR2(1 BYTE),
597 "CODMUNINICTE" NUMBER(7,0),
598 "CODMUNFIMCTE" NUMBER(7,0),
599 "VLCREDICMSPRESUMIDO" NUMBER(12,2),
600 "DATACONSOLIDACAOPREFAT" DATE,
601 "VERSAOLAYOUTNFE" VARCHAR2(5 BYTE),
602 "OBSNFEFISCO" CLOB,
603 "PCT_ESTOQUE" VARCHAR2(1 BYTE),
604 "PCT_CUSTO" VARCHAR2(1 BYTE),
605 CONSTRAINT "PCNFSAID_UK" UNIQUE ("UIDREGISTRO", "IDPARCEIRO")
606 USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
607 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
608 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
609 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
610 TABLESPACE "TS_INDICE" ENABLE,
611 CONSTRAINT "PCNFSAID_PK" PRIMARY KEY ("NUMTRANSVENDA")
612 USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
613 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
614 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
615 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE KEEP)
616 TABLESPACE "TS_INDICE" ENABLE
617 ) SEGMENT CREATION IMMEDIATE
618 PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
619 STORAGE(
620 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
621 TABLESPACE "TS_DADOS"
622 LOB ("OBSNFE") STORE AS BASICFILE (
623 TABLESPACE "TS_DADOS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
624 NOCACHE LOGGING
625 STORAGE(
626 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
627 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
628 ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
629 NOCACHE LOGGING
630 STORAGE(
631 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
632 PARTITION BY RANGE ("DTSAIDA") INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
633 SUBPARTITION BY HASH ("NUMTRANSVENDA")
634 SUBPARTITION TEMPLATE (
635 SUBPARTITION "P1"
636 TABLESPACE "TS_DADOS" ,
637 SUBPARTITION "P2"
638 TABLESPACE "TS_DADOS1" ,
639 SUBPARTITION "P3"
640 TABLESPACE "TS_DADOS2" ,
641 SUBPARTITION "P4"
642 TABLESPACE "TS_DADOS3" ,
643 SUBPARTITION "P5"
644 TABLESPACE "TS_DADOS4" ,
645 SUBPARTITION "P6"
646 TABLESPACE "TS_DADOS" ,
647 SUBPARTITION "P7"
648 TABLESPACE "TS_DADOS1" ,
649 SUBPARTITION "P8"
650 TABLESPACE "TS_DADOS2" ,
651 SUBPARTITION "P9"
652 TABLESPACE "TS_DADOS3" ,
653 SUBPARTITION "P10"
654 TABLESPACE "TS_DADOS4" ,
655 SUBPARTITION "P11"
656 TABLESPACE "TS_DADOS" ,
657 SUBPARTITION "P12"
658 TABLESPACE "TS_DADOS1" ,
659 SUBPARTITION "P13"
660 TABLESPACE "TS_DADOS2" ,
661 SUBPARTITION "P14"
662 TABLESPACE "TS_DADOS3" ,
663 SUBPARTITION "P15"
664 TABLESPACE "TS_DADOS4" ,
665 SUBPARTITION "P16"
666 TABLESPACE "TS_DADOS" ,
667 SUBPARTITION "P17"
668 TABLESPACE "TS_DADOS1" ,
669 SUBPARTITION "P18"
670 TABLESPACE "TS_DADOS2" ,
671 SUBPARTITION "P19"
672 TABLESPACE "TS_DADOS3" ,
673 SUBPARTITION "P20"
674 TABLESPACE "TS_DADOS4" ,
675 SUBPARTITION "P21"
676 TABLESPACE "TS_DADOS" ,
677 SUBPARTITION "P22"
678 TABLESPACE "TS_DADOS1" ,
679 SUBPARTITION "P23"
680 TABLESPACE "TS_DADOS2" ,
681 SUBPARTITION "P24"
682 TABLESPACE "TS_DADOS3" ,
683 SUBPARTITION "P25"
684 TABLESPACE "TS_DADOS4" ,
685 SUBPARTITION "P26"
686 TABLESPACE "TS_DADOS" ,
687 SUBPARTITION "P27"
688 TABLESPACE "TS_DADOS1" ,
689 SUBPARTITION "P28"
690 TABLESPACE "TS_DADOS2" ,
691 SUBPARTITION "P29"
692 TABLESPACE "TS_DADOS3" ,
693 SUBPARTITION "P30"
694 TABLESPACE "TS_DADOS4" ,
695 SUBPARTITION "P31"
696 TABLESPACE "TS_DADOS" ,
697 SUBPARTITION "P32"
698 TABLESPACE "TS_DADOS1" ,
699 SUBPARTITION "P33"
700 TABLESPACE "TS_DADOS2" ,
701 SUBPARTITION "P34"
702 TABLESPACE "TS_DADOS3" ,
703 SUBPARTITION "P35"
704 TABLESPACE "TS_DADOS4" ,
705 SUBPARTITION "P36"
706 TABLESPACE "TS_DADOS" ,
707 SUBPARTITION "P37"
708 TABLESPACE "TS_DADOS1" ,
709 SUBPARTITION "P38"
710 TABLESPACE "TS_DADOS2" ,
711 SUBPARTITION "P39"
712 TABLESPACE "TS_DADOS3" ,
713 SUBPARTITION "P40"
714 TABLESPACE "TS_DADOS4" ,
715 SUBPARTITION "P41"
716 TABLESPACE "TS_DADOS" ,
717 SUBPARTITION "P42"
718 TABLESPACE "TS_DADOS1" ,
719 SUBPARTITION "P43"
720 TABLESPACE "TS_DADOS2" ,
721 SUBPARTITION "P44"
722 TABLESPACE "TS_DADOS3" ,
723 SUBPARTITION "P45"
724 TABLESPACE "TS_DADOS4" ,
725 SUBPARTITION "P46"
726 TABLESPACE "TS_DADOS" ,
727 SUBPARTITION "P47"
728 TABLESPACE "TS_DADOS1" ,
729 SUBPARTITION "P48"
730 TABLESPACE "TS_DADOS2" ,
731 SUBPARTITION "P49"
732 TABLESPACE "TS_DADOS3" ,
733 SUBPARTITION "P50"
734 TABLESPACE "TS_DADOS4" )
735 (PARTITION "P_INIT1" VALUES LESS THAN (TO_DATE(' 2009-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
736PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
737 STORAGE(
738 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
739 TABLESPACE "TS_DADOS"
740 LOB ("OBSNFE") STORE AS BASICFILE (
741 TABLESPACE "TS_DADOS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
742 NOCACHE LOGGING
743 STORAGE(
744 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
745 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
746 ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
747 NOCACHE LOGGING
748 STORAGE(
749 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
750 ( SUBPARTITION "P_INIT1_P1"
751 LOB ("OBSNFE") STORE AS BASICFILE (
752 TABLESPACE "TS_DADOS" )
753 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
754 TABLESPACE "TS_DADOS" )
755 TABLESPACE "TS_DADOS"
756 NOCOMPRESS ,
757 SUBPARTITION "P_INIT1_P2"
758 LOB ("OBSNFE") STORE AS BASICFILE (
759 TABLESPACE "TS_DADOS" )
760 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
761 TABLESPACE "TS_DADOS1" )
762 TABLESPACE "TS_DADOS1"
763 NOCOMPRESS ,
764 SUBPARTITION "P_INIT1_P3"
765 LOB ("OBSNFE") STORE AS BASICFILE (
766 TABLESPACE "TS_DADOS" )
767 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
768 TABLESPACE "TS_DADOS2" )
769 TABLESPACE "TS_DADOS2"
770 NOCOMPRESS ,
771 SUBPARTITION "P_INIT1_P4"
772 LOB ("OBSNFE") STORE AS BASICFILE (
773 TABLESPACE "TS_DADOS" )
774 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
775 TABLESPACE "TS_DADOS3" )
776 TABLESPACE "TS_DADOS3"
777 NOCOMPRESS ,
778 SUBPARTITION "P_INIT1_P5"
779 LOB ("OBSNFE") STORE AS BASICFILE (
780 TABLESPACE "TS_DADOS" )
781 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
782 TABLESPACE "TS_DADOS4" )
783 TABLESPACE "TS_DADOS4"
784 NOCOMPRESS ,
785 SUBPARTITION "P_INIT1_P6"
786 LOB ("OBSNFE") STORE AS BASICFILE (
787 TABLESPACE "TS_DADOS" )
788 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
789 TABLESPACE "TS_DADOS" )
790 TABLESPACE "TS_DADOS"
791 NOCOMPRESS ,
792 SUBPARTITION "P_INIT1_P7"
793 LOB ("OBSNFE") STORE AS BASICFILE (
794 TABLESPACE "TS_DADOS" )
795 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
796 TABLESPACE "TS_DADOS1" )
797 TABLESPACE "TS_DADOS1"
798 NOCOMPRESS ,
799 SUBPARTITION "P_INIT1_P8"
800 LOB ("OBSNFE") STORE AS BASICFILE (
801 TABLESPACE "TS_DADOS" )
802 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
803 TABLESPACE "TS_DADOS2" )
804 TABLESPACE "TS_DADOS2"
805 NOCOMPRESS ,
806 SUBPARTITION "P_INIT1_P9"
807 LOB ("OBSNFE") STORE AS BASICFILE (
808 TABLESPACE "TS_DADOS" )
809 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
810 TABLESPACE "TS_DADOS3" )
811 TABLESPACE "TS_DADOS3"
812 NOCOMPRESS ,
813 SUBPARTITION "P_INIT1_P10"
814 LOB ("OBSNFE") STORE AS BASICFILE (
815 TABLESPACE "TS_DADOS" )
816 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
817 TABLESPACE "TS_DADOS4" )
818 TABLESPACE "TS_DADOS4"
819 NOCOMPRESS ,
820 SUBPARTITION "P_INIT1_P11"
821 LOB ("OBSNFE") STORE AS BASICFILE (
822 TABLESPACE "TS_DADOS" )
823 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
824 TABLESPACE "TS_DADOS" )
825 TABLESPACE "TS_DADOS"
826 NOCOMPRESS ,
827 SUBPARTITION "P_INIT1_P12"
828 LOB ("OBSNFE") STORE AS BASICFILE (
829 TABLESPACE "TS_DADOS" )
830 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
831 TABLESPACE "TS_DADOS1" )
832 TABLESPACE "TS_DADOS1"
833 NOCOMPRESS ,
834 SUBPARTITION "P_INIT1_P13"
835 LOB ("OBSNFE") STORE AS BASICFILE (
836 TABLESPACE "TS_DADOS" )
837 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
838 TABLESPACE "TS_DADOS2" )
839 TABLESPACE "TS_DADOS2"
840 NOCOMPRESS ,
841 SUBPARTITION "P_INIT1_P14"
842 LOB ("OBSNFE") STORE AS BASICFILE (
843 TABLESPACE "TS_DADOS" )
844 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
845 TABLESPACE "TS_DADOS3" )
846 TABLESPACE "TS_DADOS3"
847 NOCOMPRESS ,
848 SUBPARTITION "P_INIT1_P15"
849 LOB ("OBSNFE") STORE AS BASICFILE (
850 TABLESPACE "TS_DADOS" )
851 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
852 TABLESPACE "TS_DADOS4" )
853 TABLESPACE "TS_DADOS4"
854 NOCOMPRESS ,
855 SUBPARTITION "P_INIT1_P16"
856 LOB ("OBSNFE") STORE AS BASICFILE (
857 TABLESPACE "TS_DADOS" )
858 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
859 TABLESPACE "TS_DADOS" )
860 TABLESPACE "TS_DADOS"
861 NOCOMPRESS ,
862 SUBPARTITION "P_INIT1_P17"
863 LOB ("OBSNFE") STORE AS BASICFILE (
864 TABLESPACE "TS_DADOS" )
865 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
866 TABLESPACE "TS_DADOS1" )
867 TABLESPACE "TS_DADOS1"
868 NOCOMPRESS ,
869 SUBPARTITION "P_INIT1_P18"
870 LOB ("OBSNFE") STORE AS BASICFILE (
871 TABLESPACE "TS_DADOS" )
872 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
873 TABLESPACE "TS_DADOS2" )
874 TABLESPACE "TS_DADOS2"
875 NOCOMPRESS ,
876 SUBPARTITION "P_INIT1_P19"
877 LOB ("OBSNFE") STORE AS BASICFILE (
878 TABLESPACE "TS_DADOS" )
879 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
880 TABLESPACE "TS_DADOS3" )
881 TABLESPACE "TS_DADOS3"
882 NOCOMPRESS ,
883 SUBPARTITION "P_INIT1_P20"
884 LOB ("OBSNFE") STORE AS BASICFILE (
885 TABLESPACE "TS_DADOS" )
886 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
887 TABLESPACE "TS_DADOS4" )
888 TABLESPACE "TS_DADOS4"
889 NOCOMPRESS ,
890 SUBPARTITION "P_INIT1_P21"
891 LOB ("OBSNFE") STORE AS BASICFILE (
892 TABLESPACE "TS_DADOS" )
893 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
894 TABLESPACE "TS_DADOS" )
895 TABLESPACE "TS_DADOS"
896 NOCOMPRESS ,
897 SUBPARTITION "P_INIT1_P22"
898 LOB ("OBSNFE") STORE AS BASICFILE (
899 TABLESPACE "TS_DADOS" )
900 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
901 TABLESPACE "TS_DADOS1" )
902 TABLESPACE "TS_DADOS1"
903 NOCOMPRESS ,
904 SUBPARTITION "P_INIT1_P23"
905 LOB ("OBSNFE") STORE AS BASICFILE (
906 TABLESPACE "TS_DADOS" )
907 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
908 TABLESPACE "TS_DADOS2" )
909 TABLESPACE "TS_DADOS2"
910 NOCOMPRESS ,
911 SUBPARTITION "P_INIT1_P24"
912 LOB ("OBSNFE") STORE AS BASICFILE (
913 TABLESPACE "TS_DADOS" )
914 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
915 TABLESPACE "TS_DADOS3" )
916 TABLESPACE "TS_DADOS3"
917 NOCOMPRESS ,
918 SUBPARTITION "P_INIT1_P25"
919 LOB ("OBSNFE") STORE AS BASICFILE (
920 TABLESPACE "TS_DADOS" )
921 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
922 TABLESPACE "TS_DADOS4" )
923 TABLESPACE "TS_DADOS4"
924 NOCOMPRESS ,
925 SUBPARTITION "P_INIT1_P26"
926 LOB ("OBSNFE") STORE AS BASICFILE (
927 TABLESPACE "TS_DADOS" )
928 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
929 TABLESPACE "TS_DADOS" )
930 TABLESPACE "TS_DADOS"
931 NOCOMPRESS ,
932 SUBPARTITION "P_INIT1_P27"
933 LOB ("OBSNFE") STORE AS BASICFILE (
934 TABLESPACE "TS_DADOS" )
935 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
936 TABLESPACE "TS_DADOS1" )
937 TABLESPACE "TS_DADOS1"
938 NOCOMPRESS ,
939 SUBPARTITION "P_INIT1_P28"
940 LOB ("OBSNFE") STORE AS BASICFILE (
941 TABLESPACE "TS_DADOS" )
942 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
943 TABLESPACE "TS_DADOS2" )
944 TABLESPACE "TS_DADOS2"
945 NOCOMPRESS ,
946 SUBPARTITION "P_INIT1_P29"
947 LOB ("OBSNFE") STORE AS BASICFILE (
948 TABLESPACE "TS_DADOS" )
949 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
950 TABLESPACE "TS_DADOS3" )
951 TABLESPACE "TS_DADOS3"
952 NOCOMPRESS ,
953 SUBPARTITION "P_INIT1_P30"
954 LOB ("OBSNFE") STORE AS BASICFILE (
955 TABLESPACE "TS_DADOS" )
956 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
957 TABLESPACE "TS_DADOS4" )
958 TABLESPACE "TS_DADOS4"
959 NOCOMPRESS ,
960 SUBPARTITION "P_INIT1_P31"
961 LOB ("OBSNFE") STORE AS BASICFILE (
962 TABLESPACE "TS_DADOS" )
963 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
964 TABLESPACE "TS_DADOS" )
965 TABLESPACE "TS_DADOS"
966 NOCOMPRESS ,
967 SUBPARTITION "P_INIT1_P32"
968 LOB ("OBSNFE") STORE AS BASICFILE (
969 TABLESPACE "TS_DADOS" )
970 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
971 TABLESPACE "TS_DADOS1" )
972 TABLESPACE "TS_DADOS1"
973 NOCOMPRESS ,
974 SUBPARTITION "P_INIT1_P33"
975 LOB ("OBSNFE") STORE AS BASICFILE (
976 TABLESPACE "TS_DADOS" )
977 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
978 TABLESPACE "TS_DADOS2" )
979 TABLESPACE "TS_DADOS2"
980 NOCOMPRESS ,
981 SUBPARTITION "P_INIT1_P34"
982 LOB ("OBSNFE") STORE AS BASICFILE (
983 TABLESPACE "TS_DADOS" )
984 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
985 TABLESPACE "TS_DADOS3" )
986 TABLESPACE "TS_DADOS3"
987 NOCOMPRESS ,
988 SUBPARTITION "P_INIT1_P35"
989 LOB ("OBSNFE") STORE AS BASICFILE (
990 TABLESPACE "TS_DADOS" )
991 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
992 TABLESPACE "TS_DADOS4" )
993 TABLESPACE "TS_DADOS4"
994 NOCOMPRESS ,
995 SUBPARTITION "P_INIT1_P36"
996 LOB ("OBSNFE") STORE AS BASICFILE (
997 TABLESPACE "TS_DADOS" )
998 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
999 TABLESPACE "TS_DADOS" )
1000 TABLESPACE "TS_DADOS"
1001 NOCOMPRESS ,
1002 SUBPARTITION "P_INIT1_P37"
1003 LOB ("OBSNFE") STORE AS BASICFILE (
1004 TABLESPACE "TS_DADOS" )
1005 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1006 TABLESPACE "TS_DADOS1" )
1007 TABLESPACE "TS_DADOS1"
1008 NOCOMPRESS ,
1009 SUBPARTITION "P_INIT1_P38"
1010 LOB ("OBSNFE") STORE AS BASICFILE (
1011 TABLESPACE "TS_DADOS" )
1012 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1013 TABLESPACE "TS_DADOS2" )
1014 TABLESPACE "TS_DADOS2"
1015 NOCOMPRESS ,
1016 SUBPARTITION "P_INIT1_P39"
1017 LOB ("OBSNFE") STORE AS BASICFILE (
1018 TABLESPACE "TS_DADOS" )
1019 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1020 TABLESPACE "TS_DADOS3" )
1021 TABLESPACE "TS_DADOS3"
1022 NOCOMPRESS ,
1023 SUBPARTITION "P_INIT1_P40"
1024 LOB ("OBSNFE") STORE AS BASICFILE (
1025 TABLESPACE "TS_DADOS" )
1026 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1027 TABLESPACE "TS_DADOS4" )
1028 TABLESPACE "TS_DADOS4"
1029 NOCOMPRESS ,
1030 SUBPARTITION "P_INIT1_P41"
1031 LOB ("OBSNFE") STORE AS BASICFILE (
1032 TABLESPACE "TS_DADOS" )
1033 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1034 TABLESPACE "TS_DADOS" )
1035 TABLESPACE "TS_DADOS"
1036 NOCOMPRESS ,
1037 SUBPARTITION "P_INIT1_P42"
1038 LOB ("OBSNFE") STORE AS BASICFILE (
1039 TABLESPACE "TS_DADOS" )
1040 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1041 TABLESPACE "TS_DADOS1" )
1042 TABLESPACE "TS_DADOS1"
1043 NOCOMPRESS ,
1044 SUBPARTITION "P_INIT1_P43"
1045 LOB ("OBSNFE") STORE AS BASICFILE (
1046 TABLESPACE "TS_DADOS" )
1047 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1048 TABLESPACE "TS_DADOS2" )
1049 TABLESPACE "TS_DADOS2"
1050 NOCOMPRESS ,
1051 SUBPARTITION "P_INIT1_P44"
1052 LOB ("OBSNFE") STORE AS BASICFILE (
1053 TABLESPACE "TS_DADOS" )
1054 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1055 TABLESPACE "TS_DADOS3" )
1056 TABLESPACE "TS_DADOS3"
1057 NOCOMPRESS ,
1058 SUBPARTITION "P_INIT1_P45"
1059 LOB ("OBSNFE") STORE AS BASICFILE (
1060 TABLESPACE "TS_DADOS" )
1061 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1062 TABLESPACE "TS_DADOS4" )
1063 TABLESPACE "TS_DADOS4"
1064 NOCOMPRESS ,
1065 SUBPARTITION "P_INIT1_P46"
1066 LOB ("OBSNFE") STORE AS BASICFILE (
1067 TABLESPACE "TS_DADOS" )
1068 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1069 TABLESPACE "TS_DADOS" )
1070 TABLESPACE "TS_DADOS"
1071 NOCOMPRESS ,
1072 SUBPARTITION "P_INIT1_P47"
1073 LOB ("OBSNFE") STORE AS BASICFILE (
1074 TABLESPACE "TS_DADOS" )
1075 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1076 TABLESPACE "TS_DADOS1" )
1077 TABLESPACE "TS_DADOS1"
1078 NOCOMPRESS ,
1079 SUBPARTITION "P_INIT1_P48"
1080 LOB ("OBSNFE") STORE AS BASICFILE (
1081 TABLESPACE "TS_DADOS" )
1082 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1083 TABLESPACE "TS_DADOS2" )
1084 TABLESPACE "TS_DADOS2"
1085 NOCOMPRESS ,
1086 SUBPARTITION "P_INIT1_P49"
1087 LOB ("OBSNFE") STORE AS BASICFILE (
1088 TABLESPACE "TS_DADOS" )
1089 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1090 TABLESPACE "TS_DADOS3" )
1091 TABLESPACE "TS_DADOS3"
1092 NOCOMPRESS ,
1093 SUBPARTITION "P_INIT1_P50"
1094 LOB ("OBSNFE") STORE AS BASICFILE (
1095 TABLESPACE "TS_DADOS" )
1096 LOB ("OBSNFEFISCO") STORE AS BASICFILE (
1097 TABLESPACE "TS_DADOS4" )
1098 TABLESPACE "TS_DADOS4"
1099 NOCOMPRESS ) ) ENABLE ROW MOVEMENT ;
1100
1101 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMNOTA" IS '';
1102 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTAL" IS 'Valor total.';
1103 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CAIXA" IS 'Caixa';
1104 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTGER" IS 'Valor total.';
1105 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESCONTO" IS 'Valor total do desconto.';
1106 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBS" IS '';
1107 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTPESO" IS '';
1108 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVOLUME" IS '';
1109 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCAR" IS '';
1110 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NFFORNEC" IS '';
1111 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMSEQ" IS '';
1112 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONDVENDA" IS 'Indica a condição da venda.';
1113 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UF" IS 'UF cliente.';
1114 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMIDF" IS '';
1115 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMFORMULARIO" IS '';
1116 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLCUSTOREP" IS '';
1117 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTDEVOL" IS '';
1118 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMSELONF" IS '';
1119 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMSEQMONTAGEM" IS '';
1120 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMVOLUME" IS '';
1121 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLRECEBIDODIN" IS '';
1122 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLRECEBIDOCH" IS '';
1123 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLRECEBIDOBOLETO" IS '';
1124 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTROCO" IS '';
1125 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCUPOM" IS '';
1126 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFUNCLIBENT" IS '';
1127 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTLIBENT" IS '';
1128 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESCPROM" IS '';
1129 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMVIAS" IS '';
1130 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCONTRATO" IS '';
1131 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FRETEDESPACHO" IS '';
1132 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FRETEREDESPACHO" IS '';
1133 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFORNECFRETE" IS '';
1134 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLRECEBIDOCARTAO" IS '';
1135 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSVENDAORIGEM" IS '';
1136 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFUNCLANC" IS '';
1137 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTCANHOTO" IS '';
1138 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSVENDADESTINO" IS '';
1139 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODUSUR3" IS '';
1140 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODUSUR2" IS '';
1141 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLISS" IS '';
1142 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODSUPERVISOR2" IS '';
1143 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODSUPERVISOR3" IS '';
1144 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COMISSAO2" IS '';
1145 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COMISSAO3" IS '';
1146 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."HORALANC" IS '';
1147 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MINUTOLANC" IS '';
1148 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ROTINALANC" IS '';
1149 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."EQUIPLANC" IS '';
1150 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FUNCLANC" IS '';
1151 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLFRETENF" IS '';
1152 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMLANCCP" IS '';
1153 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZOMEDIO" IS '';
1154 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZOADICIONAL" IS '';
1155 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTWMS" IS '';
1156 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZOPONDERADO" IS '';
1157 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SERIEECF" IS '';
1158 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMSERIEEQUIP" IS '';
1159 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMNFTRANSF" IS '';
1160 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPODEVOL" IS '';
1161 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ICMSRETIDOGNRE" IS '';
1162 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLIR" IS '';
1163 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLBONIFIC" IS '';
1164 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."BCSTGNRE" IS '';
1165 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCLINF" IS 'Código do cliente para o endereço de entraga da NF.';
1166 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERCFRETE" IS '';
1167 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMREGIAOFRETE" IS '';
1168 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMORCA" IS '';
1169 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMVIASPU" IS '';
1170 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCONDICAOVENDA" IS 'Indica o código da condição de venda.';
1171 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVLDESCFIN" IS '';
1172 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVLDESCCOM" IS '';
1173 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVLBONIFIC" IS '';
1174 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVLDESCFLEX" IS '';
1175 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVLREDCOMISS" IS '';
1176 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COMISSAOSUP" IS '';
1177 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTEMISSAONFFORNEC" IS '';
1178 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVLREDCOMISSSUP" IS '';
1179 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOFRETE" IS '';
1180 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCAIXAFISCAL" IS '';
1181 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORACHEGADA" IS '';
1182 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORASAIDA" IS '';
1183 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."KMFINALENTREGA" IS '';
1184 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."BROKER" IS '';
1185 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERBASEREDOUTRASDESP" IS 'Contém o percentual de redução para despesas acessórias (se houver).';
1186 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."APRESENTOUCUPOMPROMOCAO" IS '';
1187 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NSU" IS 'NSU (número sequencial único) que deve ser gerado e impresso em todas as notas fiscais (entrada e saÃda).';
1188 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTNSU" IS 'Data e hora de geração do NSU (número sequencial único), que deve ser impresso em todas as notas fiscais (entrada e saÃda).';
1189 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLVERBACMVCLI" IS 'Indica o valor total da verba CMV registrado no pedido.';
1190 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ESPECIEVOLUME" IS 'Indica a especie dos volumes da nota fiscal.';
1191 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MARCARVOLUME" IS 'Indica a marca dos produtos da nota fiscal.';
1192 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."USAINTEGRACAOWMS" IS 'Usa integração WMS';
1193 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ENVIADANFE" IS 'NF-e já enviada ao cliente.';
1194 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AUTENTPGTOGNRE" IS 'Autenticação bancaria.';
1195 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."BANCOPGTOGNRE" IS 'Banco de pagto.';
1196 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AGENCIAPGTOGNRE" IS 'Agencia de pagto.';
1197 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VENDAASSISTIDA" IS 'Indica se a NF é de venda assistida.';
1198 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODEMITENTEPEDIDO" IS 'Código do emitente do pedido.';
1199 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERCCOMPROFISSIONAL" IS 'Indica o percentual de comissao do profissional cadastrado na rotina 340.';
1200 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CLIENTE" IS 'Razão social do cliente.';
1201 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CGC" IS 'CNPJ do cliente.';
1202 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IE" IS 'IE do cliente.';
1203 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOFJ" IS 'Tipo pessoa (em casos de dev. de clientes).';
1204 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONSUMIDORFINAL" IS 'Indica se cliente é consumidor final.';
1205 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODATV1" IS 'Cód.Atividade do cliente.';
1206 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPAIS" IS 'Código do PaÃs.';
1207 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DESCPAIS" IS 'Descrição do PaÃs.';
1208 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CGCFILIAL" IS 'CNPJ da filial.';
1209 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IEFILIAL" IS 'IE da filial.';
1210 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFFILIAL" IS 'UF da filial.';
1211 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AGREGARSTPRODSINTEGRA" IS 'Agregar ou não o ST ao valor dos itens (Sintegra).';
1212 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOALIQOUTRASDESP" IS 'Tipo de tributação do frete e despesas acessórias.';
1213 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IESUBSTTRIBUT" IS 'IE como substituto tributário.';
1214 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFCODIGO" IS 'Código da UF.';
1215 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."HISTORICO" IS 'Gerou histórico para o registro, sim ou não.';
1216 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SUBSERIE" IS 'Indica a subserie da nota fiscal.';
1217 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ENVIADA" IS 'Indica se em caso de contingência, já enviou para o SEFAZ.';
1218 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMLOTENFE" IS 'Número de Lote da Nota Fiscal Eletrônica.';
1219 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTEXPORTACAOSERVINT" IS '';
1220 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."EXPORTADOSERVINT" IS '';
1221 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IMPORTADOSERVPRINC" IS '';
1222 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTIMPORTACAOSERVPRINC" IS '';
1223 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSVENDAECF" IS '';
1224 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVENFE" IS '';
1225 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITUACAONFE" IS '';
1226 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLONFE" IS '';
1227 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORANFE" IS '';
1228 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IEENT" IS '';
1229 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTPGTOCAMPANHA" IS '';
1230 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMECF" IS '';
1231 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TENTATIVAENVIONFE" IS 'Indica a quantidade de tentativas de envio da nota fiscal a SEFAZ.';
1232 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."GERACP" IS 'Indica se pedido TV10 irá gerar Contas a Pagar. |Campo do tipo caracter, de tamanho 1, com valor padrão "N';
1233 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RESERVARITENSTV7" IS '';
1234 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMPREVENDA" IS '';
1235 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."GERACAORAZAOAUXILIAR" IS 'Indica que já foi importado na geração do Razão Auxiliar (rotina 1050).';
1236 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMORCAFILIAL" IS 'Número Orçamento da Filial.';
1237 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMREGIAO" IS 'Região de preço usada na nota fiscal.';
1238 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLPIS" IS 'Valor do PIS a ser lançado na Geração de Nota Fiscal de Prestação de Serviço (rotina 1446).';
1239 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERDESCFIN" IS 'Mesmo campo gravado no pedido, que é replicado durante o faturamento.';
1240 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCLIRECEBEDOR" IS 'Indica o cliente recebedor da mercadoria em pedidos feitos para redes de clientes.';
1241 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCARANTERIOR" IS 'Indica o numero do carregamento anterior.';
1242 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMOP" IS 'Indica o numero da ordem de produção.';
1243 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ALIQUOTA" IS 'Indica a alÃquota de ICMS.|Campo do tipo numérico, de tamanho 7, com 2 casas decimais.';
1244 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCONSIGNATARIOFRETE" IS 'Indica o código do consignatário do conhecimento de frete.';
1245 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODEXPORTADOR" IS 'Indica o código de exportador.';
1246 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFDESEMBARACO" IS 'Indica a UF desembaraço.';
1247 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."LOCALDESEMBARACO" IS 'Indica o local desembaraço.';
1248 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODREMETENTEFRETE" IS 'Indica o código do remetente do conhecimento de frete.(Utilizado apenas para o projeto 50507 - Transportadora)';
1249 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODDESTINATARIOFRETE" IS 'Indica o código do destinatário do conhecimento de frete.(Utilizado apenas para o projeto 50507 - Transportadora)';
1250 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODVEICULO" IS 'Indica o código do veÃculo do conhecimento de frete.(Utilizado apenas para o projeto 50507 - Transportadora)';
1251 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODMOTORISTA" IS 'Indica o código do motorista do conhecimento de frete.(Utilizado apenas para o projeto 50507 - Transportadora)';
1252 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPRACADESTFRETE" IS 'Indica o código do frete (rota de entrega) do conhecimento de frete.(Utilizado apenas para o projeto 50507 - Transportadora)';
1253 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSCONHECFRETE" IS 'Indica a observação do conhecimento de frete.(Utilizado apenas para o projeto 50507 - Transportadora)';
1254 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLSECCAT" IS 'Indica o valor de despesa com escolta.(Utilizado apenas para o projeto 50507 - Transportadora)';
1255 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESPACHO" IS 'Indica o valor de despesa de despacho. (Utilizado apenas para o projeto 50507 - Transportadora)';
1256 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLLTR" IS 'Indica o valor de despesa de LTR. (Utilizado apenas para o projeto 50507 - Transportadora)';
1257 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLPEDAGIO" IS 'Indica o valor de despesa do pedágio.(Utilizado apenas para o projeto 50507 - Transportadora)';
1258 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLSEGURO" IS 'Indica o valor de despesa de seguro da carga.(Utilizado apenas para o projeto 50507 - Transportadora)';
1259 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODUSUR4" IS 'Indica o código do terceiro profissional.';
1260 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COMISSAO4" IS 'Indica a comissão do terceiro profissional.';
1261 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CLIENTEFONTEST" IS 'Indica o cliente fonte ST.';
1262 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ORGAOPUB" IS 'Indica orgão público.';
1263 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TRANSPORTADORA" IS 'Indica a transportadora.';
1264 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCLIFILIAL" IS 'Indica o código do cliente para a filial.';
1265 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CGCFRETE" IS 'CNPJ do transportador.';
1266 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IEFRETE" IS 'IE do transportador.';
1267 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFFRETE" IS 'UF do transportador.';
1268 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLPAUTAFRETE" IS 'Vl.Pauta do frete na nota.';
1269 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COBRANCA" IS 'Cobrança utilizada para a nota.';
1270 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ENDERECO" IS 'Endereço do cliente.';
1271 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."BAIRRO" IS 'Bairro do cliente.';
1272 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MUNICIPIO" IS 'Municpio do cliente.';
1273 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CEP" IS 'CEP do cliente.';
1274 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SULFRAMA" IS 'Incrição Suframa do cliente.';
1275 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODMUNICIPIO" IS 'Cód.Municipio do cliente.';
1276 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PLACAVEIC" IS 'Placa do veÃculo utilizado para transporte.';
1277 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCONTCLI" IS 'Código da conta de cliente.';
1278 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODIBGE" IS 'Código da cidade no IBGE.';
1279 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOEMPRESA" IS 'Tipo da empresa do cliente.';
1280 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFISCALFRETE" IS 'CFOP do frete na nota fiscal.';
1281 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERCICMFRETE" IS 'Aliq.ICMS do frete na nota fiscal.';
1282 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFISCALOUTRASDESP" IS 'CFOP da despesa na nota fiscal.';
1283 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ALIQICMOUTRASDESP" IS 'Aliq.ICMS da despesa na nota fiscal.';
1284 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ATACADISTA" IS 'Indica se o cliente é atacadista.';
1285 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLINSS" IS 'Indica o valor do INSS.';
1286 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLONFECAN" IS 'Indica o protocolo de cancelamento da NF-e.';
1287 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLONFEAUTO" IS 'Indica o protocolo de autorizaçãoda NF-e.';
1288 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COMISSAOMOT" IS 'Indica o valor de comissão para o motorista.';
1289 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTPAGCOMISSAOPROF" IS 'Indica quando a comissão foi paga para o profissional.';
1290 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOEMISSAO" IS 'Tipo de emissão da NFE (Normal, Contingência, SCAN). Campo do tipo caracter, de tamanho 1, com valor default 1';
1291 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLCOFINS" IS 'Indica o valor total de crédito de COFINS na NF.';
1292 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTLANCTO" IS 'Indica a data da inclusão do lançamento.';
1293 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RECARGA" IS 'Indica pedido de recarga.';
1294 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTFECHACCRCA" IS 'Indica se foi lançado saldo no contacorrente do RCA para a NF.';
1295 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONTRIBUINTE" IS 'Indica se o e contribuinte ou não.';
1296 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTCANCELWMS" IS 'Indica se o processo do WMS foi cancelado.';
1297 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFISCALNF" IS 'Indica o código fiscal da NF.';
1298 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORARECIBODPEC" IS 'Data e hora do recibo DPEC.';
1299 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSVENDACONHEC" IS 'Número de transação do conhecimento de frete.';
1300 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESPDENTRONF" IS 'Indica o Valor outras despesas na NF.';
1301 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORAAUTORIZACAOSEFAZ" IS 'Indica a hora que foi autorizado no sefaz.';
1302 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RECIBONFE" IS 'Indica o recibo de envio de lote.';
1303 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."LOTEDPEC" IS 'Indica o número do lote dpec.';
1304 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RECIBODPEC" IS 'Indica o recibo de envio de lote dpec.';
1305 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AMBIENTE" IS 'Indica o ambiente em que foi enviada a nota.';
1306 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLOCANCELAMENTO" IS 'Indica o número do protocolo de cancelamento.';
1307 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORACANCELAMENTOSEFAZ" IS 'Indica a data e hora em que foi cancelada no sefaz.';
1308 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTFECHA" IS 'Data de fechamento da carga.';
1309 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCONTRATO" IS 'Indica o número do contrato.';
1310 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSNFE" IS 'Observações da NF-e.';
1311 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTDIFALIQUOTAS" IS 'Total do diferencial de alÃquotas.';
1312 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTLIBERACAOENTREGA" IS 'Data de liberação de entrega do pedido na expedição.';
1313 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFUNCLIBERACAOENTREGA" IS 'Código do funcionário que efetuou liberação de entrega do pedido na expedição.';
1314 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPRODPREDOMINANTE" IS 'Código produto predominante conhecimento de frete eletrônico.';
1315 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTPESOLIQ" IS 'Peso liquido dos produtos.';
1316 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTPESOAGRUPADO" IS 'Peso total agrupado.';
1317 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTPESOLIQAGRUPADO" IS 'Peso total liquido agrupado.';
1318 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTVOLUMEAGRUPADO" IS 'Volume total agrupado.';
1319 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VENDATRIANGULAR" IS 'Venda Triangular.';
1320 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITUACAOCTE" IS 'Situaçao do cte';
1321 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RECIBOCTE" IS 'Recibo cte';
1322 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLOCTE" IS 'Protocolo do cte';
1323 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVECTE" IS 'Chave do cte';
1324 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMLOTECTE" IS 'Numero do lote do cte';
1325 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTA_HORAENVIOSEFAZ" IS 'Data e hora do envio do cte ao sefaz';
1326 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AMBIENTECTE" IS 'Ambiente do cte';
1327 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AMBIENTENFE" IS 'Ambiente da nfe';
1328 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMSEQENTREGA" IS 'Número de sequência de entrega';
1329 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."HORAEMISSAO" IS 'Hora da emissão da venda.';
1330 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONTADORCUPOMFISCAL" IS 'Contador cupom fiscal.';
1331 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLFRETERETIDO" IS 'Valor de frete retido.';
1332 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLSTFRETERETIDO" IS 'Valor ST de frete retido.';
1333 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERCFRETERETIDO" IS 'Percentual de frete retido.';
1334 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERCSTFRETERETIDO" IS 'Percentual de ST do frete retido.';
1335 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO1" IS 'Prazo de pagamento em dias da primeira parcela.';
1336 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO2" IS 'Prazo de pagamento em dias da segunda parcela.';
1337 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO3" IS 'Prazo de pagamento em dias da terceira parcela.';
1338 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO4" IS 'Prazo de pagamento em dias da quarta parcela.';
1339 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO5" IS 'Prazo de pagamento em dias da quinta parcela.';
1340 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO6" IS 'Prazo de pagamento em dias da sexta parcela.';
1341 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO7" IS 'Prazo de pagamento em dias da sétima parcela.';
1342 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO8" IS 'Prazo de pagamento em dias da oitava parcela.';
1343 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO9" IS 'Prazo de pagamento em dias da nona parcela.';
1344 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO10" IS 'Prazo de pagamento em dias da décima parcela.';
1345 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO11" IS 'Prazo de pagamento em dias da décima primeira parcela.';
1346 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PRAZO12" IS 'Prazo de pagamento em dias da décima segunda parcela.';
1347 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."JUSTIFICATIVACONTIGENCIA" IS 'Motivo da entrada de contigência.';
1348 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTAHORAENTRADACONTIGENCIA" IS 'Data e Hora da entrada de contigência.';
1349 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CUSTOBONIFICACAO" IS 'Custo da bonificação TV5.';
1350 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFORNECBONIFIC" IS 'Código do Fornecedor da Bonificação TV5.';
1351 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODBNF" IS 'Código do tipo de bonificação TV5.';
1352 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOTPESOBRUTO" IS 'Total do peso bruto das mercadorias.';
1353 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTSAIDANF" IS 'Data de emissão da Nota Fiscal.';
1354 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJCISP" IS 'CNPJ para CISP.';
1355 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONSUMIUNUMNFE" IS 'Se já tem um número de Nfe para o registro.';
1356 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONFERIDO" IS 'Nota Fiscal Conferida.';
1357 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DATAEMPENHO" IS 'Data de Empenho.';
1358 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODUNIDADEEXECUTORA" IS 'Código da unidade executora.';
1359 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VALORST" IS 'Valor de ST da nota fiscal';
1360 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MENSAGEMPISCOFINS" IS 'Mensagens da tributação PIS/COFINS';
1361 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESCICMS" IS 'Valor de desconto do ICMS de isenção.';
1362 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTALSEMDESCICMS" IS 'Valor total da NF sem desconto de Isenção de ICMS.';
1363 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMEMPENHO" IS 'Número de empenho do Órgão Púbico.';
1364 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSEXP" IS 'Obs. De ocorrência de entrega de nota fiscal.';
1365 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONTAORDEM" IS 'Indica que a venda TV7, TV8 é do tipo conta e ordem.';
1366 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTHORACTE" IS 'Data e Hora do CTE.';
1367 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TENTATIVAENVIOCTE" IS 'Nro de Tentativas de Envio do CTE.';
1368 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLOCANCELAMENTOCTE" IS 'Protocolo de cancelamento do CTE.';
1369 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFORNECREDESPACHO" IS 'Código fornecedore frete redespacho.';
1370 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."EMAILFRETE" IS 'E-mail fornecedor frete.';
1371 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."EMAILFRETEREDESPACHO" IS 'E-mail fornecedor frete redespacho.';
1372 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSPISCOFINS" IS 'Observação da tributação de PIS/COFINS';
1373 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLBASEPISCOFINS" IS 'Valor Base PIS/COFINS';
1374 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERPIS" IS 'Percentual PIS';
1375 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERCOFINS" IS 'Percentual COFINS';
1376 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODSITTRIBPISCOFINS" IS 'Código Situação Tributário PIS COFINS';
1377 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITDOC" IS 'Situação Documento';
1378 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TELEFONE" IS 'Telefone do destinatário';
1379 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMENDERECO" IS 'Número do Logradouro do destinatário';
1380 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."EMAILDEST" IS 'E-mail do destinatário';
1381 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFPLACAVEIC" IS 'Gravar a UF da Placa do Veiculo';
1382 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTEXPORTACAOWMS" IS 'Data e hora de exportação';
1383 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTIMPORTACAOWMS" IS 'Data e hora de importação';
1384 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NFATUALWMS" IS 'Atualização Nota Fiscal no WMAS Store.';
1385 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FINALIDADENFE" IS 'Finalidade NF-e';
1386 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SERIEORIGINAL" IS 'SERIE ORIGINAL DA NOTA FISCAL ELETRONICA';
1387 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DESPESASRATEADA" IS 'Informar se o frete e outras despesas foram rateados nos itens.';
1388 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSENTORIGEM" IS 'Campo que grava o número da transação de entrada associadas a nota fiscal de saÃda.';
1389 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FORNECENTREGA" IS 'Campo que grava a venda do cliente como venda com entrega pelo fornecedor.';
1390 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTFAT" IS 'Data de faturamento';
1391 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODGERENTE" IS 'Código do Gerente do RCA';
1392 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMPEDCLI" IS 'Número do pedido do cliente';
1393 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MOTORISTAVEICULO" IS 'Motorista VeÃculo';
1394 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONSUMIUNUMCTE" IS 'Consumiu número de cte';
1395 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UTILIZAIPICALCICMS" IS 'Utiliza IPI no calculo de ICMS';
1396 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMOS" IS 'Campo para armazenar o número da ordem de serviço que gerou a NF.';
1397 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."WMSCODFUNCIGNORA" IS 'Funcionário que ignorou WMS';
1398 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."WMSIGNORADO" IS 'WMS Ignorado';
1399 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PISRETIDO" IS 'Identificar se foi retido PIS na nota fiscal de saÃda';
1400 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."INSSRETIDO" IS 'Identificar se foi retido INSS na nota fiscal de saÃda';
1401 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IRRRETIDO" IS 'Identificar se foi retido IRR na nota fiscal de saÃda';
1402 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSENTDEST" IS 'Gravar o NUMTRANSENT da nota de destino';
1403 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTDENEGADA" IS 'Data denegada';
1404 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ENTREGA" IS 'Indica se o item será entregue ao invés de ser retirando em venda balcão.';
1405 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TAXAENTREGA" IS 'Valor cobrado para realizar a entrega da compra.';
1406 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFPLACAVEI" IS 'Uf da Placa do Veiculo';
1407 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NORMAREGESPECIAL" IS 'Norma Especifica (Regime Especial)';
1408 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOEMISSAOCTE" IS 'Tipo Emissão Ct-e';
1409 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COFINSRETIDO" IS 'Identificar se foi retido cofins na nota fiscal de saÃda';
1410 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."GERANFVENDA" IS 'Informa se o número da nota foi gerado automatico.';
1411 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCONTRATOCARRETEIRO" IS 'Número do Contrato Carreteiro';
1412 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESCABATIMENTO" IS 'GRAVAR O VALOR DO DESCONTO DO ABATIMENTO';
1413 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMLISTA" IS 'Número da Lista de Presente';
1414 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DEVSIMBOLICA" IS 'Esse atributo serve para identificar se a operação, é uma devolução simbólica ou não.';
1415 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLIPIOUTRAS" IS 'Esse atributo serve para armazenar o valor do ipi para devolução simbolica.';
1416 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLO" IS 'Número do protocolo';
1417 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODVEICULO1" IS 'VeÃculo 1';
1418 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODVEICULO2" IS 'VeÃculo 2';
1419 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CSLLRETIDO" IS 'Identificar se foi retido csll na nota fiscal de saÃda';
1420 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."GERARBCRNFE" IS 'Inserir os valores Base e ST BCR no XML da NF-e';
1421 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCARGAEDI" IS 'Número Carga EDI';
1422 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DEPOSITOFECHADO" IS 'Identificação de deposito fechado';
1423 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSNFCARREG" IS 'OBSERVAÇÕES NA NOTA FISCAL REFERENTE A ENTREGA DA CARGA.';
1424 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTEMISSAODECLARACAO" IS 'Data de emissão da declaração emitida pelo tomador do Ct-e, quando este não for contribuinte';
1425 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MOTESTORNONFE" IS 'Motivo de estorno Nfe';
1426 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NATOPERNFE" IS 'Nat. Operação Nfe';
1427 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VENDAEXPORTACAO" IS 'Venda de exportação';
1428 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ENVIADOEMAILCANCELADO" IS 'ENVIADO EMAIL CANCELADO';
1429 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITUACAONFEORIG" IS 'Situação NFe Original.';
1430 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSVENDATV13" IS 'Número de transação da nota fiscal tipo 13.';
1431 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODMEDICOPRESCRIT" IS 'Código do Médico Prescritor.';
1432 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IDINTEGRACAOMYFROTA" IS 'Identifica a integra¿¿o com My Frota.';
1433 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMPEDVANXML" IS 'Num. Pedido VAN para gravar no XML da NF-e.';
1434 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJFORNEC" IS 'CNPF do Fornecedor.';
1435 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCOMPROVANTE" IS 'Número do comprovante do pagamento do pedagio.';
1436 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJRESPONSAVEL" IS 'CNPF do Responsavel.';
1437 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."INUTILIZADA" IS 'INFORMA SE FOI INUTILIZAÇÃO DE NUMERACAO.';
1438 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."AGREGASTVLMERC" IS 'Agregar valor de ST ao valor da mercadoria.';
1439 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SIMPLESNACIONAL" IS 'Informar se o cliente é optante do simples';
1440 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RESPSEGURO" IS 'RESPONSÃVEL PELO SEGURO';
1441 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NOMESEGURADORA" IS 'NOME DA SEGURADORA';
1442 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMEROAPOLICE" IS 'NUMERO DA APOLICE DO SEGURO';
1443 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMEROAVERBACAO" IS 'NUMERO DA AVERBAÇÃO DO SEGURO';
1444 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLRAVERBACAO" IS 'Valor da Averbação.';
1445 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTRIBUTOS" IS 'Guarda o Valor do Conhec. Frete X Perc.';
1446 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CARTAODOTZ" IS 'Número do CPF do cliente ou Número do cartão de fidelidade DOTZ.';
1447 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJCOLETA" IS 'CNPJ do local de Coleta do CTE';
1448 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RAZAOSOCIALCOLETA" IS 'Razão Social do local de Coleta do CTE';
1449 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."LOGRADOUROCOLETA" IS 'Logradouro do local de Coleta do CTE';
1450 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMEROCOLETA" IS 'Número do endereço do local de Coleta do CTE';
1451 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."COMPLEMENTOCOLETA" IS 'Complemento do local de Coleta do CTE';
1452 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."BAIRROCOLETA" IS 'Bairro do local de Coleta do CTE';
1453 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCIDADECOLETA" IS 'Código da Cidade do local de Coleta do CTE';
1454 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJFORNECPEDAGIO" IS 'CPNJ da empresa fornecedora do vale pedagio';
1455 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMVALEPEDAGIO" IS 'Número do comprovante de compra do vale pedagio';
1456 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CPNJRESPONSAVELPEDAGIO" IS 'CNPJ do responsável pelo pagamento do vale pedágio';
1457 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VALORPEDAGIO" IS 'Valor do Vale Pedágio';
1458 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSCTEANUL" IS 'Para que o Ct-e de substituição(SaÃda) seja vinculado ao Ct-e que foi excluÃdo fiscalmente';
1459 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSCTESUBS" IS 'Para que Ct-e de substituição(SaÃda) seja vinculado ao Ct-e de entrada';
1460 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVECTEREF" IS 'Chave do cte referenciado';
1461 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJCPFCTEREF" IS 'CNPJ/CPF do cte referenciado';
1462 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IECTEREF" IS 'Inscrição estadual do cte referenciado';
1463 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."RAZAOSOCIALCTEREF" IS 'Razão social do cte referenciado';
1464 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPODOCCTEREF" IS 'Tipo do documento do cte referenciado';
1465 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SERIEDOCCTEREF" IS 'Série do documento do cte referenciado';
1466 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SUBSERIEDOCCTEREF" IS 'Sub-série do documento do cte referenciado';
1467 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMDOCCTEREF" IS 'Número do documento do cte referenciado';
1468 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTEMISSAOCTEREF" IS 'Data de emissão do cte referenciado';
1469 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ORGAOPUBMUNICIPAL" IS 'Orgão Pub. Municipal';
1470 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ORGAOPUBFEDERAL" IS 'Orgão Pub. Federal';
1471 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVECTEANULACAO" IS 'Chave de acesso do CT-e de Anulação';
1472 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVECTESUBSTITUICAO" IS 'Chave de acesso do CT-e a ser substituido (original)';
1473 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVECTETOMADORSUB" IS 'Chave de acesso do CT-e emitido pelo Tomador';
1474 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVENFETOMADORSUB" IS 'Chave de acesso da NF-e emitida pelo Tomador';
1475 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJCPFEMITENTESUB" IS 'CNPJ ou CPF do emitente';
1476 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTEMISSAODOCSUB" IS 'Data da emissão do documento fiscal';
1477 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MODELODOCSUB" IS 'Modelo do documento fiscal';
1478 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NSUSOCIOTORCEDOR" IS 'Número de Transação Sitef';
1479 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMERODOCSUB" IS 'Número do documento fiscal';
1480 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SERIEDOCSUB" IS 'Serie do documento fiscal';
1481 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SUBSERIEDOCSUB" IS 'Subserie do documento fiscal';
1482 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPODOCUMENTOSUB" IS 'Flag para identificação do tipo do documento (NF/ NFE/ CT/ CTE)';
1483 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFCTEREF" IS 'Sigla da UF do Emissor do documento anterior';
1484 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VALORDOCSUB" IS 'Valor do documento fiscal';
1485 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VERSAOROTINA" IS 'Versão da rotina gerarou os dados';
1486 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESCSOCIOTORCEDOR" IS 'Desconto Sócio Torcedor';
1487 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFORNECFRETECTEREF" IS 'Código do fornecedor de frete referenciado (redespacho) informado na 1450';
1488 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPRODNFAJUSTE" IS 'Código de produto para NF-e de ajuste';
1489 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTECODTOMADORSERVICO" IS 'Código do tomador de serviço cte subcontratado';
1490 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTECODTRANSPSUBCONTRATADO" IS 'Código do veiculo cte subcontratado';
1491 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTECODTRANSPSUBCONTRATANTE" IS 'Código da transportadora cte subcontratante';
1492 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTECODVEICULOSUBCONTRATANTE" IS 'Código do veiculo cte subcontratante';
1493 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTESUBCONTRATADOCHAVECTEREF" IS 'Chave do cte referenciado pelo tomador serviço';
1494 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DESCRICAOPRODNFAJUSTE" IS 'Descrição do produto paa NF ajuste';
1495 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTPAGDOTZ" IS 'Data do pagamento para Dotz.';
1496 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IDLOCALDESTMERC" IS 'Identificação do local de destino da mercadoria';
1497 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IDTIPOPRESENCA" IS 'Indica o tipo de presença do comprador no estabelecimento no momento da operação';
1498 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NCMNFAJUSTE" IS 'NCM para item de NF de ajuste';
1499 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCHAVEEXP" IS 'Número da Chave de Acesso da Nfe recebida para exportação';
1500 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMDRAWBACK" IS 'Número do ato concessório do Drawback';
1501 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMREGEXP" IS 'Número do Registro de Exportação ';
1502 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSNFAJUSTE" IS 'Observação complementar para NF de ajuste';
1503 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ROTINACADCTE" IS 'Rotina que efetuou a geração do CTE';
1504 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UNIDADENFAJUSTE" IS 'Unidade de medida para NF de ajuste';
1505 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLBONIFICACERTO" IS 'Valor da bonificação acerto';
1506 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLSUBTOTAL" IS 'Valor do subtotal dos itens';
1507 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTBRUTOPRODAJUSTE" IS 'Valor total bruto para NF de ajuste';
1508 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODRECEBFRETECTEREF" IS 'Código do Recebedor de frete referenciado(redespacho) informado na 1450';
1509 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOSERVICOCTE" IS 'Código do tipo de serviço do CT-e';
1510 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOSUBCONTRATACAOCTE" IS 'Tipo do CT-e';
1511 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOPRESENCAADQUIRINTE" IS 'Tipo presença do adquirinte';
1512 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DOCEMISSAO" IS 'Tipo de documento de emissão da venda.';
1513 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLGRIS" IS 'Valor do GRIS no conhecimento';
1514 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESPPEDAGIO" IS 'Valor de Outras despesas de pedágio';
1515 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTAS" IS 'Valor do TAS no conheciemento';
1516 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FORMULARIO" IS 'Formulário da nota fiscal';
1517 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMNOTAMANIF" IS 'Número da nota de manifesto';
1518 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMREMESSA" IS 'Número remessa garantia';
1519 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ORIGEMFRETE" IS 'Origem do percentual de Frete';
1520 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SELO" IS 'Selo da sefaz';
1521 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOMOVGARANTIA" IS 'Define qual tipo de movimentação de garantia a nota representa.';
1522 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCIRURGIA" IS 'Núm. Cirurgia';
1523 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UTILIZAEXPDIVERSOS" IS 'Valor do parâmetro na hora que foi gravada a NF';
1524 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITUACAONFEEPEC" IS 'Situação Nfe EPEC';
1525 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLONFEEPEC" IS 'Protocolo de autorização EPEC';
1526 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DATAHORAREGISTROEPEC" IS 'Data e hora de registro do EPEC';
1527 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSENTORIGCONSIG" IS '';
1528 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMFECHAMENTOMOVCX" IS 'Numero do fechamento da movimentacao';
1529 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTMOVIMENTOCX" IS 'Data da movimentacao do caixa.';
1530 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IDENTIFICARCLIENTENFCE" IS 'Indentificar cliente NFC-e';
1531 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MD5LISTAARQ" IS 'MD5 da lista de arquivos PAF-ECF';
1532 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VENDANFSERIED" IS 'Venda NF Serie D';
1533 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMSERIESAT" IS 'Número de serie do SAT';
1534 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CHAVESAT" IS 'Chave NFCE gerada pelo SAT';
1535 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITUACAOSAT" IS 'Situa¿¿o da Venda';
1536 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."EMISSNUMAUTOMATICO" IS 'Emissão de nota própia';
1537 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DATAHORAEMISSAOSAT" IS 'Data Hora Aprovação da venda';
1538 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."QRCODESAT" IS 'Código Consulta venda';
1539 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLBOLETO" IS 'Valor total de boleto na NF';
1540 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSENTNFESTORNADA" IS 'Número da nota de devolução que gerou o estorno';
1541 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NOTADUPLIQUESVC" IS 'Validar as notas quando elas forem enviadas em ambiente de SVC. Quando nota for duplicada o campo deverá ser preenchido';
1542 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOINSCPRESTSERV" IS 'Tipo da Inscrição do Prestador de Serviço';
1543 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."INDICPRESTSERV" IS 'Indicativo de Prestação de Serviços';
1544 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSENTDEPENDENTE" IS 'Transação de nota de entrada dependente';
1545 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMTRANSVENDADEPENDENTE" IS 'Transação de nota de saida dependente';
1546 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ROTINACAD" IS 'Gravar a rotina que inseriu o registro na PCNFSAID';
1547 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMCOLETA" IS '';
1548 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NOMEARQUIVODOTZ" IS 'Campo para armazenar o nome do arquivo dotz no qual foi gerado';
1549 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NOMEARQUIVODOTZESTORNO" IS 'Campo para armazenar o nome do arquivo dotz no qual foi gerado para estorno';
1550 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PONTOSDOTZ" IS 'Pontuação do dotz na venda';
1551 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLBASERETENCAO" IS 'Valor de base para rentenção do servico';
1552 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODRETENCAOCPRB" IS 'Código de retenção do CPRB';
1553 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TRANSFDEP" IS 'Define se a NF é uma nota de transferência para o depósito fechado';
1554 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOTRANSFENTREDEPOSITO" IS 'Tipo de transfer¿ncia entre dep¿sitos (E = Envio; R = Retorno)';
1555 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODSTATUSSAT" IS 'Status da venda';
1556 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMVIASGNRE" IS 'N¿mero de impress¿es da nota na GNRE';
1557 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."QTDEREPROCNFE" IS 'Quantidade de m¿xima de tentativas de aprova¿¿o da nota.';
1558 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."HORASAIDA" IS 'Hora de sa¿da';
1559 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MINUTOSAIDA" IS 'Minuto de sa¿da';
1560 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTEREGIMEESPECIAL" IS 'Define se o CT-e emitido pela rotina 1450 faz parte do regime especial PTA n¿ 45.000008189-09';
1561 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NFDEVENTFUTURA" IS 'Devolu¿¿o NF entrega Futura';
1562 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PERDESCFINTOT" IS 'Percentual total do desconto financeiro na NF';
1563 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDESCFIN" IS 'Valor do desconto financeiro';
1564 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."QRCODENFCE" IS 'link para geração do qrcode da nfce';
1565 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."HORAENTREGA" IS 'Hora de entrega';
1566 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MINUTOENTREGA" IS 'Minuto de entrega';
1567 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTPAGCOMISSAO" IS 'Data de pagamento da comissão';
1568 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UIDREGISTRO" IS 'Id ¿nico do registro de assinatura';
1569 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IDPARCEIRO" IS 'Id do parceiro da assinatura do registro';
1570 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."ASSINATURA" IS 'Assinatura do registro';
1571 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTPAGCOMISSAOOP" IS 'Fechamento de comiss¿o do Operador';
1572 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."IMPRIMIUDACTEJUNTODANFE" IS 'Imprimiu o DACTe junto ao DANFe vinculado (Se S, significa que o Cte foi impresso junto a Nfe vinculada)';
1573 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMNOTAVINCULADA" IS 'N¿mero de nota vinculada';
1574 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPODOCARRECGNRE" IS 'Tipo de documento - GNRE ou Documento Arrecada¿¿o';
1575 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."UFBENEFICIARIA" IS 'Unidade Federa¿¿o benefici¿ria';
1576 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMDOCARREC" IS 'N¿mero do documento de arrecada¿¿o';
1577 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODAUTENTICACAO" IS 'C¿digo de autentica¿¿o';
1578 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLDOCARRECADACAO" IS 'Valor do documento de arrecada¿¿o';
1579 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTVENCARREC" IS 'Data do Vencimento';
1580 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DTPAGARREC" IS 'Data do Pagamento';
1581 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLOPERACAOFRETE" IS 'Valor da Opera¿¿o';
1582 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLBASESTFRETE" IS 'Base de c¿lculo ST frete';
1583 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLICMSSTFRETE" IS 'Valor do ICMS/ST Frete';
1584 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CTEGLOBALIZADO" IS 'CT-e Globalizado (Sim ou N¿o)';
1585 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TOMADORCTE" IS 'Define o tomador do Cte (0-Remetente/1-Expedidor/2-Recebedor/3-Destinat¿rio)';
1586 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLCSLL" IS 'Valor do CSLL RETIDO NA NF';
1587 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CNPJSEGURADORA" IS 'CNPJ da seguradora';
1588 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."INFGLOBALIZADO" IS 'Informa¿¿es adicionais do Cte Globalizado';
1589 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."QTDEREPROCCTE" IS 'Quantidade de reprocessamento CT-e';
1590 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODEDITAL" IS 'C¿digo Edital';
1591 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."FIL_MONTARKITAUTOMATICAMENTE" IS 'grava o valor do par¿metro no momento da gera¿¿o da nota fiscal';
1592 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PAGCHEQUEMORADIA" IS 'Define se o cliente faz pagamento usando cheque moradia';
1593 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."USAMULTUNIDITEM" IS 'Usa multimplas unidades (Master ou Venda) por item na entrada mercadoria';
1594 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CONDFINANC" IS 'Condi¿¿o de financiamento suppliercard.';
1595 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMNOTAORIGEM" IS 'Numero de nota original';
1596 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PLANOSUPPLI" IS 'Plano de quantidade de parcelas suppliercard.';
1597 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOREMESSA" IS 'Indica o tipo de simples remessa M-Manuten¿¿o B-Baixa de Item';
1598 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODTRANSPAUTONOMO" IS 'Indica o c¿digo do transportador aut¿nomo';
1599 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTRANSPAUTONOMO" IS 'indica o valor ¿ pagar ao transportador aut¿nomo';
1600 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TRANSPAUTONOMO" IS 'Indica se o transporte foi realizar por um transportador aut¿nomo';
1601 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."GERARCPTRANSPAUNOTOMO" IS 'Indica se ir¿ gerar contas ¿ pagar para o transportador aut¿nomo';
1602 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODFORNECTRANSPAUTONOMO" IS 'Indica o c¿digo do transportador aut¿nomo do frete';
1603 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODCOBSEFAZ" IS 'C¿digo de cobran¿a da SEFAZ';
1604 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTALFCPST" IS 'Valor Total do Fundo de Combate a Pobreza ST';
1605 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTALFCPICMS" IS 'Valor Total do Fundo de Combate a Pobreza ICMS';
1606 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DIGITOVERIFICADORNFSE" IS 'Digito Verificardor NFSE';
1607 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."LINKNFSE" IS 'Link de consulta NFSE';
1608 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PROTOCOLONFSE" IS 'Protocolo NFSE';
1609 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SERIERPS" IS 'Serie RPS';
1610 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMERORPS" IS 'Numero RPS';
1611 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."SITUACAONFSE" IS 'Situacao NFSE';
1612 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMNOTANFSE" IS 'Numero nota NFSE';
1613 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLFRETEOUTRASDESP" IS 'Valor fixo da Taxa de Frete que ser¿ impresso na NF.';
1614 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLTOTALNFCOMPOEMCTE" IS 'Valor total das notas fiscais que comp¿em o conhecimento de frete';
1615 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MD5PAF" IS 'Assinatura MD5 do registro do PAF';
1616 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DEDUZIRDESONERORGAOPUB" IS 'Deduzir ICMS desonerado NF Licita¿¿o Org¿os P¿blicos';
1617 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOCONTACORRENTE" IS 'Tipo de conta corrente movimentada: RCA, Supervisor ou Gerente';
1618 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."NUMEROPROCESSO" IS 'N¿mero do processo';
1619 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."TIPOPROCESSO" IS 'Tipo do processo';
1620 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODIGOINDICATIVOSUSPENSAO" IS 'C¿digo Indicativo de Suspens¿o';
1621 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPROMOCAOMED" IS 'C¿digo da Promo¿¿o Medicamento';
1622 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPLPAGETICO" IS 'C¿digo Plano Pagamento Etico';
1623 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODPLPAGGENERICO" IS 'C¿digo Plano Pagamento Gen¿rico';
1624 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLPUNITMED" IS 'Valor Total a Pre¿o Unit¿rio Medicamento';
1625 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."MATERIALDECONSTRUCAO" IS 'Identifica se o pedido foi feito pelo modulo 041';
1626 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DEDUZIRICMSBASEPISCOFINS" IS 'Deduzir valor do ICMS da base de c¿lculo do PIS/COFINS';
1627 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODMUNINICTE" IS 'C¿digo do munic¿pio de origem da presta¿¿o do servi¿o(Cte)';
1628 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."CODMUNFIMCTE" IS 'C¿digo do munic¿pio de destino da presta¿¿o do servi¿o(Cte)';
1629 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VLCREDICMSPRESUMIDO" IS 'Valor de credito icms retido para ct-e';
1630 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."DATACONSOLIDACAOPREFAT" IS 'Data consolida¿¿o Pr¿-Faturamento';
1631 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."VERSAOLAYOUTNFE" IS 'Vers¿o do layout do arquivo na Sefaz';
1632 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."OBSNFEFISCO" IS 'Informa¿¿es Adicionais de Interesse do Fisco';
1633 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PCT_ESTOQUE" IS 'Gravar a efetiva¿¿o da package de estoque';
1634 COMMENT ON COLUMN "VILLE5"."PCNFSAID"."PCT_CUSTO" IS 'Gravar a efetiva¿¿o do servi¿o de custo';
1635
1636 CREATE INDEX "VILLE5"."PCNFSAID_IDX1" ON "VILLE5"."PCNFSAID" ("NUMNOTA")
1637 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1638 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1639 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1640 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1641 TABLESPACE "TS_INDICE" ;
1642
1643 CREATE INDEX "VILLE5"."PCNFSAID_IDX10" ON "VILLE5"."PCNFSAID" ("CODSUPERVISOR", "CODUSUR", "DTSAIDA")
1644 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
1645 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1646 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1647 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1648 TABLESPACE "TS_INDICE" ;
1649
1650 CREATE INDEX "VILLE5"."PCNFSAID_IDX100" ON "VILLE5"."PCNFSAID" ("CONDVENDA")
1651 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1652 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1653 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1654 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1655 TABLESPACE "TS_INDICE" ;
1656
1657 CREATE INDEX "VILLE5"."PCNFSAID_IDX101" ON "VILLE5"."PCNFSAID" ("VLTOTAL", "DTSAIDA")
1658 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
1659 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1660 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1661 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1662 TABLESPACE "TS_INDICE" ;
1663
1664 CREATE INDEX "VILLE5"."PCNFSAID_IDX103" ON "VILLE5"."PCNFSAID" ("NUMCAR", "DTCANCEL")
1665 PCTFREE 10 INITRANS 2 MAXTRANS 255
1666 STORAGE(
1667 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1668 TABLESPACE "TS_INDICE" GLOBAL PARTITION BY HASH ("NUMCAR","DTCANCEL")
1669 (PARTITION "SYS_P233079"
1670 TABLESPACE "TS_INDICE1" ,
1671 PARTITION "SYS_P233080"
1672 TABLESPACE "TS_INDICE2" ,
1673 PARTITION "SYS_P233081"
1674 TABLESPACE "TS_INDICE3" ,
1675 PARTITION "SYS_P233082"
1676 TABLESPACE "TS_INDICE4" ,
1677 PARTITION "SYS_P233083"
1678 TABLESPACE "TS_INDICE1" ,
1679 PARTITION "SYS_P233084"
1680 TABLESPACE "TS_INDICE2" ,
1681 PARTITION "SYS_P233085"
1682 TABLESPACE "TS_INDICE3" ,
1683 PARTITION "SYS_P233086"
1684 TABLESPACE "TS_INDICE4" ,
1685 PARTITION "SYS_P233087"
1686 TABLESPACE "TS_INDICE1" ,
1687 PARTITION "SYS_P233088"
1688 TABLESPACE "TS_INDICE2" ,
1689 PARTITION "SYS_P233089"
1690 TABLESPACE "TS_INDICE3" ,
1691 PARTITION "SYS_P233090"
1692 TABLESPACE "TS_INDICE4" ,
1693 PARTITION "SYS_P233091"
1694 TABLESPACE "TS_INDICE1" ,
1695 PARTITION "SYS_P233092"
1696 TABLESPACE "TS_INDICE2" ,
1697 PARTITION "SYS_P233093"
1698 TABLESPACE "TS_INDICE3" ,
1699 PARTITION "SYS_P233094"
1700 TABLESPACE "TS_INDICE4" ,
1701 PARTITION "SYS_P233095"
1702 TABLESPACE "TS_INDICE1" ,
1703 PARTITION "SYS_P233096"
1704 TABLESPACE "TS_INDICE2" ,
1705 PARTITION "SYS_P233097"
1706 TABLESPACE "TS_INDICE3" ,
1707 PARTITION "SYS_P233098"
1708 TABLESPACE "TS_INDICE4" ,
1709 PARTITION "SYS_P233099"
1710 TABLESPACE "TS_INDICE1" ,
1711 PARTITION "SYS_P233100"
1712 TABLESPACE "TS_INDICE2" ,
1713 PARTITION "SYS_P233101"
1714 TABLESPACE "TS_INDICE3" ,
1715 PARTITION "SYS_P233102"
1716 TABLESPACE "TS_INDICE4" ,
1717 PARTITION "SYS_P233103"
1718 TABLESPACE "TS_INDICE1" ,
1719 PARTITION "SYS_P233104"
1720 TABLESPACE "TS_INDICE2" ,
1721 PARTITION "SYS_P233105"
1722 TABLESPACE "TS_INDICE3" ,
1723 PARTITION "SYS_P233106"
1724 TABLESPACE "TS_INDICE4" ,
1725 PARTITION "SYS_P233107"
1726 TABLESPACE "TS_INDICE1" ,
1727 PARTITION "SYS_P233108"
1728 TABLESPACE "TS_INDICE2" ,
1729 PARTITION "SYS_P233109"
1730 TABLESPACE "TS_INDICE3" ,
1731 PARTITION "SYS_P233110"
1732 TABLESPACE "TS_INDICE4" ) COMPRESS 2 ;
1733
1734 CREATE INDEX "VILLE5"."PCNFSAID_IDX104" ON "VILLE5"."PCNFSAID" ("ESPECIE", "NUMNOTA", "DTSAIDA")
1735 PCTFREE 10 INITRANS 2 MAXTRANS 255
1736 STORAGE(
1737 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1738 TABLESPACE "TS_INDICE" GLOBAL PARTITION BY HASH ("ESPECIE","NUMNOTA")
1739 (PARTITION "SYS_P233111"
1740 TABLESPACE "TS_INDICE1" ,
1741 PARTITION "SYS_P233112"
1742 TABLESPACE "TS_INDICE2" ,
1743 PARTITION "SYS_P233113"
1744 TABLESPACE "TS_INDICE3" ,
1745 PARTITION "SYS_P233114"
1746 TABLESPACE "TS_INDICE4" ,
1747 PARTITION "SYS_P233115"
1748 TABLESPACE "TS_INDICE1" ,
1749 PARTITION "SYS_P233116"
1750 TABLESPACE "TS_INDICE2" ,
1751 PARTITION "SYS_P233117"
1752 TABLESPACE "TS_INDICE3" ,
1753 PARTITION "SYS_P233118"
1754 TABLESPACE "TS_INDICE4" ,
1755 PARTITION "SYS_P233119"
1756 TABLESPACE "TS_INDICE1" ,
1757 PARTITION "SYS_P233120"
1758 TABLESPACE "TS_INDICE2" ,
1759 PARTITION "SYS_P233141"
1760 TABLESPACE "TS_INDICE3" ,
1761 PARTITION "SYS_P233142"
1762 TABLESPACE "TS_INDICE4" ,
1763 PARTITION "SYS_P233143"
1764 TABLESPACE "TS_INDICE1" ,
1765 PARTITION "SYS_P233144"
1766 TABLESPACE "TS_INDICE2" ,
1767 PARTITION "SYS_P233145"
1768 TABLESPACE "TS_INDICE3" ,
1769 PARTITION "SYS_P233146"
1770 TABLESPACE "TS_INDICE4" ,
1771 PARTITION "SYS_P233147"
1772 TABLESPACE "TS_INDICE1" ,
1773 PARTITION "SYS_P233148"
1774 TABLESPACE "TS_INDICE2" ,
1775 PARTITION "SYS_P233149"
1776 TABLESPACE "TS_INDICE3" ,
1777 PARTITION "SYS_P233150"
1778 TABLESPACE "TS_INDICE4" ,
1779 PARTITION "SYS_P233151"
1780 TABLESPACE "TS_INDICE1" ,
1781 PARTITION "SYS_P233152"
1782 TABLESPACE "TS_INDICE2" ,
1783 PARTITION "SYS_P233153"
1784 TABLESPACE "TS_INDICE3" ,
1785 PARTITION "SYS_P233154"
1786 TABLESPACE "TS_INDICE4" ,
1787 PARTITION "SYS_P233155"
1788 TABLESPACE "TS_INDICE1" ,
1789 PARTITION "SYS_P233156"
1790 TABLESPACE "TS_INDICE2" ,
1791 PARTITION "SYS_P233157"
1792 TABLESPACE "TS_INDICE3" ,
1793 PARTITION "SYS_P233158"
1794 TABLESPACE "TS_INDICE4" ,
1795 PARTITION "SYS_P233159"
1796 TABLESPACE "TS_INDICE1" ,
1797 PARTITION "SYS_P233160"
1798 TABLESPACE "TS_INDICE2" ,
1799 PARTITION "SYS_P233161"
1800 TABLESPACE "TS_INDICE3" ,
1801 PARTITION "SYS_P233162"
1802 TABLESPACE "TS_INDICE4" ) COMPRESS 2 ;
1803
1804 CREATE INDEX "VILLE5"."PCNFSAID_IDX105" ON "VILLE5"."PCNFSAID" ("DTSAIDA", "NUMNOTA", NVL("CODFILIALNF","CODFILIAL"), NVL("CODCLINF","CODCLI"))
1805 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
1806 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1807 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1808 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1809 TABLESPACE "TS_INDICE" ;
1810
1811 CREATE INDEX "VILLE5"."PCNFSAID_IDX106" ON "VILLE5"."PCNFSAID" ("CODFISCAL", "CODFILIAL", "DTSAIDA", "NUMTRANSVENDA")
1812 PCTFREE 10 INITRANS 2 MAXTRANS 255
1813 STORAGE(
1814 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1815 TABLESPACE "TS_INDICE" GLOBAL PARTITION BY HASH ("CODFISCAL","CODFILIAL","DTSAIDA")
1816 (PARTITION "SYS_P233049"
1817 TABLESPACE "TS_INDICE1" ,
1818 PARTITION "SYS_P233050"
1819 TABLESPACE "TS_INDICE2" ,
1820 PARTITION "SYS_P233051"
1821 TABLESPACE "TS_INDICE3" ,
1822 PARTITION "SYS_P233052"
1823 TABLESPACE "TS_INDICE4" ,
1824 PARTITION "SYS_P233053"
1825 TABLESPACE "TS_INDICE1" ,
1826 PARTITION "SYS_P233054"
1827 TABLESPACE "TS_INDICE2" ,
1828 PARTITION "SYS_P233055"
1829 TABLESPACE "TS_INDICE3" ,
1830 PARTITION "SYS_P233056"
1831 TABLESPACE "TS_INDICE4" ,
1832 PARTITION "SYS_P233057"
1833 TABLESPACE "TS_INDICE1" ,
1834 PARTITION "SYS_P233058"
1835 TABLESPACE "TS_INDICE2" ,
1836 PARTITION "SYS_P233059"
1837 TABLESPACE "TS_INDICE3" ,
1838 PARTITION "SYS_P233060"
1839 TABLESPACE "TS_INDICE4" ,
1840 PARTITION "SYS_P233121"
1841 TABLESPACE "TS_INDICE1" ,
1842 PARTITION "SYS_P233122"
1843 TABLESPACE "TS_INDICE2" ,
1844 PARTITION "SYS_P233123"
1845 TABLESPACE "TS_INDICE3" ,
1846 PARTITION "SYS_P233124"
1847 TABLESPACE "TS_INDICE4" ,
1848 PARTITION "SYS_P233125"
1849 TABLESPACE "TS_INDICE1" ,
1850 PARTITION "SYS_P233126"
1851 TABLESPACE "TS_INDICE2" ,
1852 PARTITION "SYS_P233127"
1853 TABLESPACE "TS_INDICE3" ,
1854 PARTITION "SYS_P233128"
1855 TABLESPACE "TS_INDICE4" ,
1856 PARTITION "SYS_P233129"
1857 TABLESPACE "TS_INDICE1" ,
1858 PARTITION "SYS_P233130"
1859 TABLESPACE "TS_INDICE2" ,
1860 PARTITION "SYS_P233131"
1861 TABLESPACE "TS_INDICE3" ,
1862 PARTITION "SYS_P233132"
1863 TABLESPACE "TS_INDICE4" ,
1864 PARTITION "SYS_P233133"
1865 TABLESPACE "TS_INDICE1" ,
1866 PARTITION "SYS_P233134"
1867 TABLESPACE "TS_INDICE2" ,
1868 PARTITION "SYS_P233135"
1869 TABLESPACE "TS_INDICE3" ,
1870 PARTITION "SYS_P233136"
1871 TABLESPACE "TS_INDICE4" ,
1872 PARTITION "SYS_P233137"
1873 TABLESPACE "TS_INDICE1" ,
1874 PARTITION "SYS_P233138"
1875 TABLESPACE "TS_INDICE2" ,
1876 PARTITION "SYS_P233139"
1877 TABLESPACE "TS_INDICE3" ,
1878 PARTITION "SYS_P233140"
1879 TABLESPACE "TS_INDICE4" ) COMPRESS 4 ;
1880
1881 CREATE INDEX "VILLE5"."PCNFSAID_IDX107" ON "VILLE5"."PCNFSAID" ("TIPOVENDA", "NUMNOTA")
1882 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS COMPRESS 2
1883 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1884 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1885 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1886 TABLESPACE "TS_INDICE" ;
1887
1888 CREATE INDEX "VILLE5"."PCNFSAID_IDX108" ON "VILLE5"."PCNFSAID" ("CHAVENFE", "CONDVENDA")
1889 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1890 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1891 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1892 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1893 TABLESPACE "TS_INDICE" ;
1894
1895 CREATE INDEX "VILLE5"."PCNFSAID_IDX109" ON "VILLE5"."PCNFSAID" ("NUMNOTA", "CAIXA", "CODFILIAL")
1896 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
1897 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1898 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1899 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1900 TABLESPACE "TS_INDICE" ;
1901
1902 CREATE INDEX "VILLE5"."PCNFSAID_IDX11" ON "VILLE5"."PCNFSAID" ("NUMCAR", "NUMTRANSVENDA")
1903 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1904 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1905 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1906 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1907 TABLESPACE "TS_INDICE" ;
1908
1909 CREATE INDEX "VILLE5"."PCNFSAID_IDX110" ON "VILLE5"."PCNFSAID" ("SITUACAONFE", "DTSAIDA")
1910 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1911 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1912 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1913 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1914 TABLESPACE "TS_INDICE" ;
1915
1916 CREATE INDEX "VILLE5"."PCNFSAID_IDX111" ON "VILLE5"."PCNFSAID" ("CODFILIAL", "DTCANCEL", "DTSAIDA")
1917 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1918 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1919 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1920 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1921 TABLESPACE "TS_INDICE" ;
1922
1923 CREATE INDEX "VILLE5"."PCNFSAID_IDX12" ON "VILLE5"."PCNFSAID" ("NUMCAR", "NUMNOTA")
1924 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1925 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1926 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1927 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1928 TABLESPACE "TS_INDICE" ;
1929
1930 CREATE INDEX "VILLE5"."PCNFSAID_IDX13" ON "VILLE5"."PCNFSAID" ("NUMCAR", "NUMPED")
1931 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1932 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1933 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1934 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1935 TABLESPACE "TS_INDICE" ;
1936
1937 CREATE INDEX "VILLE5"."PCNFSAID_IDX14" ON "VILLE5"."PCNFSAID" ("NUMPED")
1938 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1939 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1940 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1941 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1942 TABLESPACE "TS_INDICE" ;
1943
1944 CREATE INDEX "VILLE5"."PCNFSAID_IDX1409" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDADESTINO")
1945 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
1946 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1947 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1948 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1949 TABLESPACE "TS_INDICE" ;
1950
1951 CREATE INDEX "VILLE5"."PCNFSAID_IDX1452" ON "VILLE5"."PCNFSAID" ("CODFILIALNF", "SITUACAONFE", "ESPECIE", "DTCANCEL")
1952 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
1953 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1954 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1955 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1956 TABLESPACE "TS_INDICE" ;
1957
1958 CREATE INDEX "VILLE5"."PCNFSAID_IDX1452_1" ON "VILLE5"."PCNFSAID" ("ESPECIE", "SITUACAONFE", "DTCANCEL", "DTSAIDA", "NUMNOTA", "NUMTRANSVENDA")
1959 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1960 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1961 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1962 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1963 TABLESPACE "TS_INDICE" ;
1964
1965 CREATE INDEX "VILLE5"."PCNFSAID_IDX15" ON "VILLE5"."PCNFSAID" ("NUMCAR", "CODCLI", "NUMSEQMONTAGEM")
1966 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1967 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1968 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1969 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1970 TABLESPACE "TS_INDICE" ;
1971
1972 CREATE INDEX "VILLE5"."PCNFSAID_IDX155" ON "VILLE5"."PCNFSAID" ("NUMCAR", "ESPECIE")
1973 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1974 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1975 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1976 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1977 TABLESPACE "TS_INDICE" ;
1978
1979 CREATE INDEX "VILLE5"."PCNFSAID_IDX16" ON "VILLE5"."PCNFSAID" ("CODFILIAL", "NUMPED")
1980 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1981 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1982 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1983 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1984 TABLESPACE "TS_INDICE" ;
1985
1986 CREATE INDEX "VILLE5"."PCNFSAID_IDX17" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDA", "CODFISCAL", "CONDVENDA", "DTCANCEL")
1987 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
1988 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1989 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1990 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1991 TABLESPACE "TS_INDICE" ;
1992
1993 CREATE INDEX "VILLE5"."PCNFSAID_IDX2" ON "VILLE5"."PCNFSAID" ("DTSAIDA")
1994 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
1995 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
1996 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
1997 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
1998 TABLESPACE "TS_INDICE" ;
1999
2000 CREATE INDEX "VILLE5"."PCNFSAID_IDX22" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDA", "NUMNOTA")
2001 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2002 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2003 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2004 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2005 TABLESPACE "TS_INDICE" ;
2006
2007 CREATE INDEX "VILLE5"."PCNFSAID_IDX23" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDAORIGEM", "DTCANCEL")
2008 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2009 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2010 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2011 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2012 TABLESPACE "TS_INDICE" ;
2013
2014 CREATE INDEX "VILLE5"."PCNFSAID_IDX24" ON "VILLE5"."PCNFSAID" ("SITUACAONFE", "ESPECIE")
2015 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
2016 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2017 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2018 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2019 TABLESPACE "TS_INDICE" ;
2020
2021 CREATE INDEX "VILLE5"."PCNFSAID_IDX3" ON "VILLE5"."PCNFSAID" ("CODFISCAL")
2022 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2023 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2024 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2025 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2026 TABLESPACE "TS_INDICE" ;
2027
2028 CREATE INDEX "VILLE5"."PCNFSAID_IDX31" ON "VILLE5"."PCNFSAID" ("CODFILIAL", "NUMTRANSVENDA")
2029 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2030 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2031 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2032 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2033 TABLESPACE "TS_INDICE" ;
2034
2035 CREATE INDEX "VILLE5"."PCNFSAID_IDX33" ON "VILLE5"."PCNFSAID" ("CHAVENFE")
2036 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2037 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2038 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2039 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2040 TABLESPACE "TS_INDICE" ;
2041
2042 CREATE INDEX "VILLE5"."PCNFSAID_IDX34" ON "VILLE5"."PCNFSAID" ("TIPOEMISSAO", "ESPECIE", "SITUACAONFE")
2043 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2044 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2045 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2046 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2047 TABLESPACE "TS_INDICE" ;
2048
2049 CREATE INDEX "VILLE5"."PCNFSAID_IDX4" ON "VILLE5"."PCNFSAID" ("CODCLI")
2050 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2051 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2052 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2053 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2054 TABLESPACE "TS_INDICE" ;
2055
2056 CREATE INDEX "VILLE5"."PCNFSAID_IDX44" ON "VILLE5"."PCNFSAID" ("CHAVECTE")
2057 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2058 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2059 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2060 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2061 TABLESPACE "TS_INDICE" ;
2062
2063 CREATE INDEX "VILLE5"."PCNFSAID_IDX444" ON "VILLE5"."PCNFSAID" ("CODCLI", "NUMNOTA")
2064 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
2065 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2066 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2067 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2068 TABLESPACE "TS_INDICE" ;
2069
2070 CREATE INDEX "VILLE5"."PCNFSAID_IDX445" ON "VILLE5"."PCNFSAID" ("NUMPED", "CODCLI")
2071 PCTFREE 10 INITRANS 2 MAXTRANS 255 INVISIBLE COMPUTE STATISTICS
2072 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2073 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2074 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2075 TABLESPACE "TS_INDICE" ;
2076
2077 CREATE INDEX "VILLE5"."PCNFSAID_IDX46" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDATV13")
2078 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2079 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2080 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2081 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2082 TABLESPACE "TS_INDICE" ;
2083
2084 CREATE INDEX "VILLE5"."PCNFSAID_IDX47" ON "VILLE5"."PCNFSAID" ("NUMTRANSCTEANUL")
2085 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2086 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2087 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2088 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2089 TABLESPACE "TS_INDICE" ;
2090
2091 CREATE INDEX "VILLE5"."PCNFSAID_IDX48" ON "VILLE5"."PCNFSAID" ("NUMTRANSCTESUBS")
2092 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2093 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2094 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2095 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2096 TABLESPACE "TS_INDICE" ;
2097
2098 CREATE INDEX "VILLE5"."PCNFSAID_IDX49" ON "VILLE5"."PCNFSAID" ("DTSAIDA", "NUMNOTA", NVL("CODFILIALNF","CODFILIAL"))
2099 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2100 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2101 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2102 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2103 TABLESPACE "TS_INDICE" ;
2104
2105 CREATE INDEX "VILLE5"."PCNFSAID_IDX5" ON "VILLE5"."PCNFSAID" ("CAIXA")
2106 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2107 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2108 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2109 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2110 TABLESPACE "TS_INDICE" ;
2111
2112 CREATE INDEX "VILLE5"."PCNFSAID_IDX6" ON "VILLE5"."PCNFSAID" ("CODUSUR")
2113 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2114 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2115 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2116 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2117 TABLESPACE "TS_INDICE" ;
2118
2119 CREATE INDEX "VILLE5"."PCNFSAID_IDX7" ON "VILLE5"."PCNFSAID" ("CODFILIAL")
2120 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2121 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2122 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2123 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2124 TABLESPACE "TS_INDICE" ;
2125
2126 CREATE INDEX "VILLE5"."PCNFSAID_IDX8" ON "VILLE5"."PCNFSAID" ("TIPOVENDA")
2127 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2128 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2129 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2130 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2131 TABLESPACE "TS_INDICE" ;
2132
2133 CREATE INDEX "VILLE5"."PCNFSAID_IDX9" ON "VILLE5"."PCNFSAID" ("CODPRACA")
2134 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2135 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2136 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2137 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2138 TABLESPACE "TS_INDICE" ;
2139
2140 CREATE INDEX "VILLE5"."PCNFSAID_IDX90" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDACONHEC")
2141 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
2142 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2143 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2144 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2145 TABLESPACE "TS_INDICE" ;
2146
2147 CREATE INDEX "VILLE5"."PCNFSAID_IDX91" ON "VILLE5"."PCNFSAID" ("NUMTRANSVENDAORIGEM", "NUMNOTA")
2148 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
2149 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2150 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2151 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2152 TABLESPACE "TS_INDICE" ;
2153
2154 CREATE INDEX "VILLE5"."PCNFSAID_IDX9877_1" ON "VILLE5"."PCNFSAID" ("CODFILIAL", "VILNUMRPF")
2155 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2156 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2157 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2158 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2159 TABLESPACE "TS_INDICE" ;
2160
2161 CREATE INDEX "VILLE5"."PCNFSAID_IDX9877_2" ON "VILLE5"."PCNFSAID" ("VILNUMRPF", "NUMTRANSVENDA")
2162 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2163 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2164 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2165 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2166 TABLESPACE "TS_INDICE" ;
2167
2168 CREATE INDEX "VILLE5"."PCNFSAID_IDX99" ON "VILLE5"."PCNFSAID" ("NUMNOTA", "DTSAIDA", "NUMTRANSVENDA")
2169 PCTFREE 10 INITRANS 2 MAXTRANS 255
2170 STORAGE(
2171 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2172 TABLESPACE "TS_INDICE" GLOBAL PARTITION BY HASH ("NUMNOTA")
2173 (PARTITION "SYS_P233163"
2174 TABLESPACE "TS_INDICE" ) COMPRESS 1 ;
2175
2176 CREATE INDEX "VILLE5"."PCNFSAID_IDXDOCFISCAL" ON "VILLE5"."PCNFSAID" ("NUMTRANSENTORIGEM")
2177 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2178 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2179 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2180 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2181 TABLESPACE "TS_INDICE" ;
2182
2183 CREATE INDEX "VILLE5"."PCNFSAID_VILNUMTRANSENT" ON "VILLE5"."PCNFSAID" ("VILNUMTRANSENT")
2184 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
2185 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
2186 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
2187 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
2188 TABLESPACE "TS_INDICE" ;
2189
2190 CREATE OR REPLACE TRIGGER "VILLE5"."T_PCNFSAID_HISTORICO" BEFORE INSERT OR UPDATE
2191 ON PCNFSAID REFERENCING NEW AS NEW FOR EACH ROW
2192DECLARE
2193 /************************************************************************************************
2194 Proposito: Trigger para gravação dos dados de cadastro (historico de movimentação)
2195 Rotina: Pacote
2196 Utilizada por: rotinas que fazem inclusão na PCNFSAID
2197 ------------------------------------------------------------------------------------------------
2198 Data Responsavel Descricao
2199 ---------- -------------- --------------------------------------------------------------------
2200 17/11/2008 Ricardo Criação da trigger
2201 01/03/2010 Ricardo Trigger não mais travará o processo, apenas gerará Log na tabela
2202 PCLOGALTERACAODADOS.
2203 08/03/2010 Ricardo Trigger alterada para pegar dados da PCVENDACONSUM somente se
2204 CODCLI for 1, 2 ou 3.
2205 03/09/2010 Natanael Trigger alterada para gravar o AmbienteNFE no qual a nota foi aprovada.
2206 07/04/2011 Thiago Melo Alterada trigger para gravação do campo PCNFSAID.IEENT de acordo com o
2207 campo PCCLIENT.IEENT.
2208 10/10/2012 Rodrigo Guimaraes Alterado a trigger para gravar o endereço de entrega do pedido de acordo
2209 com a tabela PCENDERECOENTREGAPEDIDO. Caso não existe o registro na
2210 tabela, mantém a regra de gravação atual.
2211 ************************************************************************************************/
2212
2213 VTIPOALIQOUTRASDESP PCNFSAID.TIPOALIQOUTRASDESP%type;
2214 VAGREGARSTPRODSINTEGRA PCNFSAID.AGREGARSTPRODSINTEGRA%type;
2215 VCODCONTCLI PCNFSAID.CODCONTCLI%type;
2216 VPERCICMFRETE PCNFSAID.PERCICMFRETE%type;
2217 VPERCICMINTERFRETE number(4, 2);
2218 VALIQICMOUTRASDESP PCNFSAID.ALIQICMOUTRASDESP%type;
2219 VALIQICMINTEROUTRASDESP number(4, 2);
2220 VCODFISCALFRETE PCNFSAID.CODFISCALFRETE%type;
2221 VCODFISCALINTERFRETE number(4);
2222 VCODFISCALOUTRASDESP PCNFSAID.CODFISCALOUTRASDESP%type;
2223 VCODFISCALINTEROUTRASDESP number(4);
2224 VCODFISCALDEVOUTRASDESP number(4);
2225 VCODFISCALINTERDEVOUTRASDESP number(4);
2226 VUFFILIAL PCNFSAID.UFFILIAL%type;
2227 VCODFILIAL PCNFSAID.CODFILIAL%type;
2228 VCFOPFRETE number(4);
2229 VCFOPDESPESA number(4);
2230 VALIQICMSFRETE number(4, 2);
2231 VALIQICMSDESPESA number(4, 2);
2232 VVLPIS PCNFSAID.VLPIS%type;
2233 VVLCOFINS PCNFSAID.VLCOFINS%type;
2234 VCODFISCALNF PCNFSAID.CODFISCALNF%type;
2235 VMENSAGEM_ERRO varchar2(100);
2236 VAMBIENTENFE PCNFSAID.AMBIENTENFE%type;
2237 VAMBIENTECTE PCNFSAID.AMBIENTECTE%type;
2238 VGERARBCRNFE PCNFSAID.GERARBCRNFE%type;
2239 VSIEENT PCCLIENT.IEENT%type;
2240 VENDERECOENTREGAPEDIDO PCENDERECOENTREGAPEDIDO%rowtype;
2241 VERRO_TRIBUTACAO exception;
2242 VNUMTRANSITEM NUMBER;
2243 ------------------------------------------------------------------------------------------------
2244 -- FUNÇÕES GERAR LOG SE OCORRER UM ERRO
2245 ------------------------------------------------------------------------------------------------
2246 procedure GERAR_LOG(PMENSAGEM_ERRO in varchar2, PLINHA_ERRO in varchar2) is
2247 begin
2248 insert into PCLOGALTERACAODADOS
2249 (DATA,
2250 TABELA,
2251 COLUNA,
2252 TIPOVALOR,
2253 VALORALFA,
2254 TERMINAL,
2255 MAQUINA,
2256 PROGRAMA,
2257 OSUSER,
2258 OBSERVACOES,
2259 OBSERVACOES2)
2260 values
2261 (sysdate,
2262 'PCNFSAID',
2263 'INDEFINIDA',
2264 'A',
2265 'ERRO NA INCLUSÃO DO REGISTRO',
2266 SYS_CONTEXT('USERENV', 'TERMINAL'),
2267 SYS_CONTEXT('USERENV', 'HOST'),
2268 SYS_CONTEXT('USERENV', 'MODULE'),
2269 SYS_CONTEXT('USERENV', 'OS_USER'),
2270 'ERRO TRIGGER HISTORICO: NUMTRANSVENDA: ' ||
2271 TO_CHAR(NVL(:new.NUMTRANSVENDA, 0)) || ' NUMNOTA: ' ||
2272 TO_CHAR(NVL(:new.NUMNOTA, 0)),
2273 'ERRO ORIGINAL: ' || PMENSAGEM_ERRO || PLINHA_ERRO);
2274 end;
2275
2276 /****************************************************************************/
2277 function GET_VALORCLIENTE(PCODCLI in number,
2278 PCONSUMIDOR in varchar2,
2279 PVENDACONSUM in varchar2,
2280 PVALOR_CONSUM in varchar2,
2281 PVALOR_CLIENTE in varchar2,
2282 PVALOR_FILIAL in varchar2) return varchar2 is
2283 begin
2284 case
2285 when PCODCLI in (1, 2, 3) then
2286 if PVENDACONSUM = 'S'
2287 then
2288 return PVALOR_CONSUM;
2289 elsif PCONSUMIDOR = 'S'
2290 then
2291 return PVALOR_FILIAL;
2292 else
2293 return PVALOR_CLIENTE;
2294 end if;
2295 else
2296 return PVALOR_CLIENTE;
2297 end case;
2298 end;
2299 ------------------------------------------------------------------------------------------------
2300 -- FUNÇÕES PARA RECUPERAR INFORMAÇÕES SOBRE A TRIBUTAÇÃO DE FRETE E DESPESAS ACESSORRIAS
2301 ------------------------------------------------------------------------------------------------
2302 procedure ATUALIZAR_TRIBUTACOES is
2303 begin
2304 if VTIPOALIQOUTRASDESP <> 'T'
2305 then
2306 VCFOPFRETE := case when VUFFILIAL = :new.UF then VCODFISCALFRETE else VCODFISCALINTERFRETE end;
2307 VCFOPDESPESA := case when VUFFILIAL = :new.UF then VCODFISCALOUTRASDESP else VCODFISCALINTEROUTRASDESP end;
2308 VALIQICMSFRETE := case when VUFFILIAL = :new.UF then VPERCICMFRETE else VPERCICMINTERFRETE end;
2309 VALIQICMSDESPESA := case when VUFFILIAL = :new.UF then VALIQICMOUTRASDESP else VALIQICMINTEROUTRASDESP end;
2310 else
2311 begin
2312 select DECODE(:new.TIPOVENDA,
2313 'DF',
2314 NVL(CODFISCALFRETEDEVFORNEC, CODFISCALFRETE),
2315 DECODE(NVL(:new.CONSUMIDORFINAL, 'N') || :new.TIPOFJ,
2316 'SF',
2317 NVL(CODFISCALFRETEPF, CODFISCALFRETE),
2318 CODFISCALFRETE)),
2319 DECODE(:new.TIPOVENDA,
2320 'DF',
2321 DECODE(NVL(:new.CONSUMIDORFINAL, 'N') || :new.TIPOFJ,
2322 'SF',
2323 NVL(CODFISCALDEVOUTRASDESPPF,
2324 CODFISCALDEVOUTRASDESP),
2325 CODFISCALDEVOUTRASDESP),
2326 DECODE(NVL(:new.CONSUMIDORFINAL, 'N') || :new.TIPOFJ,
2327 'SF',
2328 CODFISCALOUTRASDESPPF,
2329 CODFISCALOUTRASDESP)),
2330 DECODE(:new.TIPOVENDA,
2331 'DF',
2332 NVL(ALIQICMFRETEDEVFORNEC, PERCICMFRETE),
2333 DECODE(NVL(:new.CONSUMIDORFINAL, 'N') || :new.TIPOFJ,
2334 'SF',
2335 NVL(PERCICMFRETEPF, PERCICMFRETE),
2336 PERCICMFRETE)),
2337 DECODE(NVL(:new.CONSUMIDORFINAL, 'N') || :new.TIPOFJ,
2338 'SF',
2339 NVL(ALIQICMOUTRASDESPPF, ALIQICMOUTRASDESP),
2340 ALIQICMOUTRASDESP)
2341 into VCFOPFRETE, VCFOPDESPESA, VALIQICMSFRETE, VALIQICMSDESPESA
2342 from PCTRIBOUTROS
2343 where UFDESTINO = :new.UF
2344 and CODFILIALNF = VCODFILIAL;
2345 exception
2346 when others then
2347 VMENSAGEM_ERRO := 'TRIBUTAÇÃO POR ESTADO INEXISTENTE (ROTINA 596)! FILIAL: ' ||
2348 VCODFILIAL || ' UF DESTINO: ' || :new.UF;
2349 raise VERRO_TRIBUTACAO;
2350 end;
2351 end if;
2352 end;
2353begin
2354 IF INSERTING
2355 THEN
2356----------------------------------------------------------------------------------
2357 -- BUSCAR PARAMETROS GERAIS
2358 ----------------------------------------------------------------------------------
2359 begin
2360 select TIPOALIQOUTRASDESP,
2361 PERCICMFRETE,
2362 PERCICMINTERFRETE,
2363 ALIQICMOUTRASDESP,
2364 ALIQICMINTEROUTRASDESP,
2365 CODFISCALFRETE,
2366 CODFISCALINTERFRETE,
2367 CODFISCALOUTRASDESP,
2368 CODFISCALINTEROUTRASDESP,
2369 CODFISCALDEVOUTRASDESP,
2370 CODFISCALINTERDEVOUTRASDESP,
2371 AGREGARSTPRODSINTEGRA,
2372 CODCONTCLI
2373 into VTIPOALIQOUTRASDESP,
2374 VPERCICMFRETE,
2375 VPERCICMINTERFRETE,
2376 VALIQICMOUTRASDESP,
2377 VALIQICMINTEROUTRASDESP,
2378 VCODFISCALFRETE,
2379 VCODFISCALINTERFRETE,
2380 VCODFISCALOUTRASDESP,
2381 VCODFISCALINTEROUTRASDESP,
2382 VCODFISCALDEVOUTRASDESP,
2383 VCODFISCALINTERDEVOUTRASDESP,
2384 VAGREGARSTPRODSINTEGRA,
2385 VCODCONTCLI
2386 from PCCONSUM;
2387 exception
2388 when others then
2389 null;
2390 end;
2391
2392 ----------------------------------------------------------------------------------
2393 -- BUSCAR PARAMETROS DA TABELA PCPARAMFILIAL (NOVA 132)
2394 ----------------------------------------------------------------------------------
2395 begin
2396 select VALOR AMBIENTENFE
2397 into VAMBIENTENFE
2398 from PCPARAMFILIAL
2399 where CODFILIAL = NVL(:new.CODFILIALNF, :new.CODFILIAL)
2400 and NOME = 'AMBIENTENFE';
2401 exception
2402 when others then
2403 null;
2404 end;
2405
2406 begin
2407 select VALOR AMBIENTECTE
2408 into VAMBIENTECTE
2409 from PCPARAMFILIAL
2410 where CODFILIAL = NVL(:new.CODFILIALNF, :new.CODFILIAL)
2411 and NOME = 'AMBIENTECTE';
2412 exception
2413 when others then
2414 null;
2415 end;
2416
2417 ----------------------------------------------------------------------------------
2418 -- BUSCAR PARAMETROS DA TABELA PCPARAMFILIAL, BUSCAR O PARAMETRO GERARCRNFE (NOVA 132)
2419 ----------------------------------------------------------------------------------
2420 begin
2421 select VALOR GERARBCRNFE
2422 into VGERARBCRNFE
2423 from PCPARAMFILIAL
2424 where CODFILIAL = NVL(:new.CODFILIALNF, :new.CODFILIAL)
2425 and NOME = 'GERARBCRNFE';
2426 exception
2427 when others then
2428 null;
2429 end;
2430
2431 ----------------------------------------------------------------------------------
2432 -- BUSCAR DADOS DO CLIENTE DA NOTA
2433 ----------------------------------------------------------------------------------
2434 begin
2435 select PCCLIENT.IEENT
2436 into VSIEENT
2437 from PCCLIENT
2438 where PCCLIENT.CODCLI = :new.CODCLI;
2439 end;
2440
2441 ----------------------------------------------------------------------------------
2442 -- BUSCAR PARAMETROS POR FILIAL
2443 ----------------------------------------------------------------------------------
2444 begin
2445 select CODIGO, UF
2446 into VCODFILIAL, VUFFILIAL
2447 from PCFILIAL
2448 where CODIGO = NVL(:new.CODFILIALNF, :new.CODFILIAL);
2449 exception
2450 when others then
2451 null;
2452 end;
2453
2454 ----------------------------------------------------------------------------------
2455 if VTIPOALIQOUTRASDESP = 'F'
2456 then
2457 begin
2458 select ALIQICMOUTRASDESP,
2459 ALIQICMINTEROUTRASDESP,
2460 CODFISCALOUTRASDESP,
2461 CODFISCALINTEROUTRASDESP
2462 into VALIQICMOUTRASDESP,
2463 VALIQICMINTEROUTRASDESP,
2464 VCODFISCALOUTRASDESP,
2465 VCODFISCALINTEROUTRASDESP
2466 from PCFILIAL
2467 where CODIGO = VCODFILIAL;
2468 exception
2469 when others then
2470 null;
2471 end;
2472 end if;
2473
2474 ----------------------------------------------------------------------------------
2475 for DADOS in (select C.CLIENTE,
2476 C.CODCLI,
2477 case
2478 when trim(UPPER(C.CLIENTE)) like '%CONSUMIDOR%' then
2479 'S'
2480 else
2481 'N'
2482 end CLIENTE_CONSUMIDOR,
2483 C.CGCENT CGCCLIENTE,
2484 C.IEENT IECLIENTE,
2485 C.ENDERENT ENDERCLIENTE,
2486 C.BAIRROENT BAIRROCLIENTE,
2487 C.MUNICENT CIDADECLIENTE,
2488 C.CEPENT CEPCLIENTE,
2489 C.ESTENT UFCLIENTE,
2490 C.TIPOFJ TIPOFJCLIENTE,
2491 C.CODCIDADE CODCIDADECLIENTE,
2492 C.CONSUMIDORFINAL,
2493 C.CLIENTEFONTEST,
2494 C.SULFRAMA,
2495 C.ORGAOPUB,
2496 C.ORGAOPUBFEDERAL,
2497 C.ORGAOPUBMUNICIPAL,
2498 C.TIPOEMPRESA,
2499 C.CONTRIBUINTE,
2500 C.CODATV1,
2501 C.TELENT TELEFONECLI,
2502 C.EMAIL EMAILCLI,
2503 C.NUMEROENT NUMEROCLI,
2504 FL.CODCLI CODCLIFILIAL,
2505 NVL((select ATACADISTA
2506 from PCATIVI
2507 where CODATIV = C.CODATV1),
2508 'S') ATACADISTA,
2509 case
2510 when (C.CODCLI in (1, 2, 3)) then
2511 'S'
2512 else
2513 'N'
2514 end CODCLI_123,
2515 case
2516 when (NVL((select NUMPED
2517 from PCVENDACONSUM
2518 where NUMPED = :new.NUMPED),
2519 0) > 0) and (C.CODCLI in (1, 2, 3)) then
2520 'S'
2521 else
2522 'N'
2523 end VENDACONSUM,
2524 (select FORNECEDOR
2525 from PCFORNEC
2526 where CODFORNEC = :new.CODFORNECFRETE) TRANSPORTADORA,
2527 (select CGC
2528 from PCFORNEC
2529 where CODFORNEC = :new.CODFORNECFRETE) CGCFRETE,
2530 (select IE
2531 from PCFORNEC
2532 where CODFORNEC = :new.CODFORNECFRETE) IEFRETE,
2533 (select ESTADO
2534 from PCFORNEC
2535 where CODFORNEC = :new.CODFORNECFRETE) UFFRETE,
2536 (select CLIENTE
2537 from PCVENDACONSUM
2538 where NUMPED = :new.NUMPED) CONSUMIDOR,
2539 (select CGCENT
2540 from PCVENDACONSUM
2541 where NUMPED = :new.NUMPED) CGCCONSUM,
2542 (select IEENT
2543 from PCVENDACONSUM
2544 where NUMPED = :new.NUMPED) IECONSUM,
2545 (select ENDERENT
2546 from PCVENDACONSUM
2547 where NUMPED = :new.NUMPED) ENDERCONSUM,
2548 (select BAIRROENT
2549 from PCVENDACONSUM
2550 where NUMPED = :new.NUMPED) BAIRROCONSUM,
2551 (select MUNICENT
2552 from PCVENDACONSUM
2553 where NUMPED = :new.NUMPED) CIDADECONSUM,
2554 (select CEPENT
2555 from PCVENDACONSUM
2556 where NUMPED = :new.NUMPED) CEPCONSUM,
2557 (select ESTENT
2558 from PCVENDACONSUM
2559 where NUMPED = :new.NUMPED) UFCONSUM,
2560 (select CODCIDADE
2561 from PCVENDACONSUM
2562 where NUMPED = :new.NUMPED) CODCIDADECONSUM,
2563 'F' TIPOFJCONSUM,
2564 C.PAISENT CODPAIS_CLIENTE,
2565 (select CODPAIS from PCPAIS where CODPAIS = E.CODPAIS) CODPAIS,
2566 (select DESCRICAO
2567 from PCPAIS
2568 where CODPAIS = E.CODPAIS) DESCPAIS,
2569 (select TELENT
2570 from PCVENDACONSUM
2571 where NUMPED = :new.NUMPED) TELEFONECONSUM,
2572 (select NUMEROENT
2573 from PCVENDACONSUM
2574 where NUMPED = :new.NUMPED) NUMEROCONSUM,
2575 (select EMAIL
2576 from PCVENDACONSUM
2577 where NUMPED = :new.NUMPED) EMAILCONSUM,
2578 FL.CIDADE CIDADEFILIAL,
2579 FL.BAIRRO BAIRROFILIAL,
2580 FL.ENDERECO ENDERFILIAL,
2581 FL.CODMUN CODIBGEFILIAL,
2582 FL.CEP CEPFILIAL,
2583 FL.CGC CGCFILIAL,
2584 FL.IE IEFILIAL,
2585 FL.UF UFFILIAL,
2586 FL.CODFORNEC CODFORFILIAL,
2587 (select ST.IESUBSTTRIBUT
2588 from PCINSCRICAOST ST
2589 where ST.CODFILIAL = FL.CODIGO
2590 and ST.UF = C.ESTENT) IESUBSTTRIBUT,
2591 (select V.PLACA
2592 from PCCARREG CA, PCVEICUL V
2593 where CA.NUMCAR = :new.NUMCAR
2594 and CA.CODVEICULO = V.CODVEICULO(+)) PLACA,
2595 (select V.UFPLACAVEICULO
2596 from PCCARREG CA, PCVEICUL V
2597 where CA.NUMCAR = :new.NUMCAR
2598 and CA.CODVEICULO = V.CODVEICULO(+)) UFPLACA,
2599 E.CODIGO UFCODIGO,
2600 NVL((select VLPAUTAFRETE
2601 from PCPRACA
2602 where CODPRACA = :new.CODPRACA),
2603 0) VLPAUTAFRETE,
2604 (select COBRANCA from PCCOB where CODCOB = :new.CODCOB) COBRANCA,
2605 FL.EMAIL EMAILFIL,
2606 FL.TELEFONE TELEFONEFIL,
2607 TO_CHAR(FL.NUMERO) NUMEROFIL,
2608 C.SIMPLESNACIONAL,
2609 TRIM(UPPER(C.CLIENTE)) NOME_CLIENTE
2610 from PCCLIENT C, PCFILIAL FL, PCESTADO E
2611 where C.CODCLI = DECODE(NVL(:new.CODCLINF, 0),
2612 0,
2613 :new.CODCLI,
2614 :new.CODCLINF)
2615 and C.ESTENT = E.UF(+)
2616 and FL.CODIGO(+) = VCODFILIAL)
2617 loop
2618 --------------------------------------------------------------------------------
2619 -- Processo para integracao com e-commerce
2620 -- Recuperar na tabela PCENDERECOENTREGAPEDIDO o endereco informado no pedido
2621 --------------------------------------------------------------------------------
2622 begin
2623 select * into VENDERECOENTREGAPEDIDO
2624 from PCENDERECOENTREGAPEDIDO
2625 where NUMPED = :new.NUMPED and rownum = 1;
2626 exception
2627 when others then
2628 VENDERECOENTREGAPEDIDO := null;
2629 end;
2630
2631 --------------------------------------------------------------------------------
2632 begin
2633 select sum(QTCONT * NVL(VLPIS, 0)) VLPIS,
2634 sum(QTCONT * NVL(VLCOFINS, 0)) VLCOFINS,
2635 min(CODFISCAL) CODFISCALNF
2636 into VVLPIS, VVLCOFINS, VCODFISCALNF
2637 from PCMOV
2638 where NUMTRANSVENDA = :new.NUMTRANSVENDA
2639 and DTCANCEL is null
2640 and QTCONT > 0;
2641 exception
2642 when others then
2643 begin
2644 VVLPIS := 0;
2645 VVLCOFINS := 0;
2646
2647 begin
2648 select max(CODFISCAL)
2649 into VCODFISCALNF
2650 from PCNFBASE
2651 where NUMTRANSVENDA = :new.NUMTRANSVENDA;
2652 exception
2653 when others then
2654 null;
2655 end;
2656 end;
2657 end;
2658
2659 --------------------------------------------------------------------------------
2660 :new.IEENT := VSIEENT;
2661 :new.CLIENTE := NVL(:new.CLIENTE, case when DADOS.CODCLI_123 = 'S' and DADOS.VENDACONSUM = 'S' then DADOS.CONSUMIDOR else DADOS.CLIENTE end);
2662 :new.CGC := NVL(:new.CGC, case when DADOS.CODCLI_123 = 'S' and DADOS.VENDACONSUM = 'S' then DADOS.CGCCONSUM else DADOS.CGCCLIENTE end);
2663 :new.IE := NVL(:new.IE, case when DADOS.CODCLI_123 = 'S' and DADOS.VENDACONSUM = 'S' then DADOS.IECONSUM else DADOS.IECLIENTE end);
2664 :new.ENDERECO := NVL(VENDERECOENTREGAPEDIDO.ENDERECO, NVL(:new.ENDERECO,
2665 GET_VALORCLIENTE(DADOS.CODCLI,
2666 DADOS.CLIENTE_CONSUMIDOR,
2667 DADOS.VENDACONSUM,
2668 DADOS.ENDERCONSUM,
2669 DADOS.ENDERCLIENTE,
2670 DADOS.ENDERFILIAL)));
2671 :new.BAIRRO := NVL(VENDERECOENTREGAPEDIDO.BAIRRO, NVL(:new.BAIRRO,
2672 GET_VALORCLIENTE(DADOS.CODCLI,
2673 DADOS.CLIENTE_CONSUMIDOR,
2674 DADOS.VENDACONSUM,
2675 DADOS.BAIRROCONSUM,
2676 DADOS.BAIRROCLIENTE,
2677 DADOS.BAIRROFILIAL)));
2678 :new.MUNICIPIO := NVL(VENDERECOENTREGAPEDIDO.MUNICIPIO, NVL(:new.MUNICIPIO,
2679 GET_VALORCLIENTE(DADOS.CODCLI,
2680 DADOS.CLIENTE_CONSUMIDOR,
2681 DADOS.VENDACONSUM,
2682 DADOS.CIDADECONSUM,
2683 DADOS.CIDADECLIENTE,
2684 DADOS.CIDADEFILIAL)));
2685 :new.CEP := NVL(VENDERECOENTREGAPEDIDO.CEP, NVL(:new.CEP,
2686 GET_VALORCLIENTE(DADOS.CODCLI,
2687 DADOS.CLIENTE_CONSUMIDOR,
2688 DADOS.VENDACONSUM,
2689 DADOS.CEPCONSUM,
2690 DADOS.CEPCLIENTE,
2691 DADOS.CEPFILIAL)));
2692 :new.UF := NVL(VENDERECOENTREGAPEDIDO.ESTADO, NVL(:new.UF,
2693 GET_VALORCLIENTE(DADOS.CODCLI,
2694 DADOS.CLIENTE_CONSUMIDOR,
2695 DADOS.VENDACONSUM,
2696 DADOS.UFCONSUM,
2697 DADOS.UFCLIENTE,
2698 DADOS.UFFILIAL)));
2699 :new.TIPOFJ := NVL(:new.TIPOFJ, case when DADOS.CODCLI_123 = 'S' and DADOS.VENDACONSUM = 'S' then DADOS.TIPOFJCONSUM else DADOS.TIPOFJCLIENTE end);
2700 :new.CODMUNICIPIO := NVL(VENDERECOENTREGAPEDIDO.CODCIDADE,
2701 NVL(:new.CODMUNICIPIO, case when DADOS.CODCLI_123 = 'S' and DADOS.VENDACONSUM = 'S' then DADOS.CODCIDADECONSUM else DADOS.CODCIDADECLIENTE end));
2702 :new.TELEFONE := NVL(VENDERECOENTREGAPEDIDO.TELEFONE, NVL(:new.TELEFONE,
2703 GET_VALORCLIENTE(DADOS.CODCLI,
2704 DADOS.CLIENTE_CONSUMIDOR,
2705 DADOS.VENDACONSUM,
2706 DADOS.TELEFONECONSUM,
2707 DADOS.TELEFONECLI,
2708 DADOS.TELEFONEFIL)));
2709 :new.EMAILDEST := NVL(:new.EMAILDEST,
2710 GET_VALORCLIENTE(DADOS.CODCLI,
2711 DADOS.CLIENTE_CONSUMIDOR,
2712 DADOS.VENDACONSUM,
2713 DADOS.EMAILCONSUM,
2714 DADOS.EMAILCLI,
2715 DADOS.EMAILFIL));
2716 :new.NUMENDERECO := NVL(VENDERECOENTREGAPEDIDO.NUMERO, NVL(:new.NUMENDERECO,
2717 GET_VALORCLIENTE(DADOS.CODCLI,
2718 DADOS.CLIENTE_CONSUMIDOR,
2719 DADOS.VENDACONSUM,
2720 DADOS.NUMEROCONSUM,
2721 DADOS.NUMEROCLI,
2722 DADOS.NUMEROFIL)));
2723 :new.AGREGASTVLMERC := PARAMFILIAL.OBTERCOMOVARCHAR2('AGREGASTVLMERC',
2724 VCODFILIAL);
2725 :new.SIMPLESNACIONAL := DADOS.SIMPLESNACIONAL;
2726
2727 -- ATRIBUINDO CODIBGE
2728 begin
2729 if (((DADOS.CODCLI_123 = 'S') AND (DADOS.NOME_CLIENTE = 'CONSUMIDOR FINAL')) and
2730 DADOS.VENDACONSUM = 'N')
2731 then
2732 :new.CODIBGE := DADOS.CODIBGEFILIAL;
2733
2734 --------------------------------------
2735 select max(NVL(:new.CODMUNICIPIO, CODCIDADE))
2736 into :new.CODMUNICIPIO
2737 from PCCIDADE
2738 where CODIBGE = DADOS.CODIBGEFILIAL;
2739 else
2740 select NVL(:new.CODIBGE, CODIBGE)
2741 into :new.CODIBGE
2742 from PCCIDADE
2743 where CODCIDADE = :new.CODMUNICIPIO;
2744 end if;
2745 exception
2746 when others then
2747 null;
2748 end;
2749
2750 :new.CONSUMIDORFINAL := NVL(:new.CONSUMIDORFINAL, DADOS.CONSUMIDORFINAL);
2751 :new.CLIENTEFONTEST := NVL(:new.CLIENTEFONTEST, DADOS.CLIENTEFONTEST);
2752 :new.SULFRAMA := NVL(:new.SULFRAMA, DADOS.SULFRAMA);
2753 :new.ORGAOPUB := NVL(:new.ORGAOPUB, DADOS.ORGAOPUB);
2754 :new.ORGAOPUBFEDERAL := NVL(:new.ORGAOPUBFEDERAL, DADOS.ORGAOPUBFEDERAL);
2755 :new.ORGAOPUBMUNICIPAL := NVL(:new.ORGAOPUBMUNICIPAL, DADOS.ORGAOPUBMUNICIPAL);
2756 :new.TIPOEMPRESA := NVL(:new.TIPOEMPRESA, DADOS.TIPOEMPRESA);
2757 :new.CONTRIBUINTE := NVL(:new.CONTRIBUINTE, DADOS.CONTRIBUINTE);
2758 :new.TRANSPORTADORA := NVL(:new.TRANSPORTADORA, DADOS.TRANSPORTADORA);
2759 :new.CGCFRETE := NVL(:new.CGCFRETE, DADOS.CGCFRETE);
2760 :new.IEFRETE := NVL(:new.IEFRETE, DADOS.IEFRETE);
2761 :new.UFFRETE := NVL(:new.UFFRETE, DADOS.UFFRETE);
2762 :new.CODATV1 := NVL(:new.CODATV1, DADOS.CODATV1);
2763 :new.ATACADISTA := NVL(:new.ATACADISTA, DADOS.ATACADISTA);
2764 :new.AGREGASTVLMERC := PARAMFILIAL.OBTERCOMOVARCHAR2('AGREGASTVLMERC', VCODFILIAL);
2765 -- tratamento para o paÃs do cliente -------------------------------------------
2766 begin
2767 :new.CODPAIS := NVL(:new.CODPAIS,
2768 NVL(TO_NUMBER(DADOS.CODPAIS_CLIENTE),
2769 DADOS.CODPAIS));
2770
2771 select DESCRICAO
2772 into :new.DESCPAIS
2773 from PCPAIS
2774 where CODPAIS = :new.CODPAIS;
2775 exception
2776 when others then
2777 :new.CODPAIS := NVL(:new.CODPAIS, DADOS.CODPAIS);
2778 :new.DESCPAIS := NVL(:new.DESCPAIS, DADOS.DESCPAIS);
2779 end;
2780 --------------------------------------------------------------------------------
2781 :new.CGCFILIAL := NVL(:new.CGCFILIAL, DADOS.CGCFILIAL);
2782 :new.IEFILIAL := NVL(:new.IEFILIAL, DADOS.IEFILIAL);
2783 :new.UFFILIAL := NVL(:new.UFFILIAL, DADOS.UFFILIAL);
2784 :new.CODCLIFILIAL := NVL(:new.CODCLIFILIAL, DADOS.CODCLIFILIAL);
2785 :new.CODCONTCLI := NVL(:new.CODCONTCLI, VCODCONTCLI);
2786 :new.AGREGARSTPRODSINTEGRA := NVL(:new.AGREGARSTPRODSINTEGRA, VAGREGARSTPRODSINTEGRA);
2787 :new.TIPOALIQOUTRASDESP := NVL(:new.TIPOALIQOUTRASDESP, VTIPOALIQOUTRASDESP);
2788 :new.IESUBSTTRIBUT := NVL(:new.IESUBSTTRIBUT, DADOS.IESUBSTTRIBUT);
2789 :new.PLACAVEIC := NVL(:new.PLACAVEIC, DADOS.PLACA);
2790 :new.UFPLACAVEIC := NVL(:new.UFPLACAVEIC, DADOS.UFPLACA );
2791 :new.UFCODIGO := NVL(:new.UFCODIGO, DADOS.UFCODIGO);
2792 :new.VLPAUTAFRETE := NVL(:new.VLPAUTAFRETE, DADOS.VLPAUTAFRETE);
2793 :new.COBRANCA := SUBSTR(NVL(:new.COBRANCA, DADOS.COBRANCA), 1, 30);
2794 :new.VLPIS := VVLPIS;
2795 :new.VLCOFINS := VVLCOFINS;
2796 :new.CODFISCALNF := VCODFISCALNF;
2797 :new.SITUACAONFE := NVL(:new.SITUACAONFE, 0);
2798 IF :NEW.TIPOVENDA <> 'DF' THEN
2799 :new.GERARBCRNFE := VGERARBCRNFE;
2800 END IF;
2801
2802 begin
2803 :new.AMBIENTENFE := PARAMFILIAL.OBTERCOMOVARCHAR2('AMBIENTENFE', VCODFILIAL);
2804 exception
2805 when others then
2806 begin
2807 :new.AMBIENTENFE := -1;
2808 GERAR_LOG(sqlerrm, 'Erro na trigger T_PCNFSAID_HISTORICO');
2809 end;
2810 end;
2811
2812 begin
2813 :new.AMBIENTECTE := PARAMFILIAL.OBTERCOMOVARCHAR2('AMBIENTECTE', VCODFILIAL);
2814 exception
2815 when others then
2816 begin
2817 :new.AMBIENTECTE := -1;
2818 GERAR_LOG(sqlerrm, 'Erro na trigger T_PCNFSAID_HISTORICO');
2819 end;
2820 end;
2821
2822 :new.HISTORICO := 'S';
2823 end loop;
2824
2825 -- INFORMAÇÕES DE TRIBUTAÇÃO DE FRETE E DESP.ACESSORIA
2826 -------------------------------------------------------------------------------------------------------
2827 -- ATUALIZAR_TRIBUTACOES();
2828 -------------------------------------------------------------------------------------------------------
2829 :new.CODFISCALFRETE := NVL(:new.CODFISCALFRETE, VCFOPFRETE);
2830 :new.CODFISCALOUTRASDESP := NVL(:new.CODFISCALOUTRASDESP, VCFOPDESPESA);
2831 :new.PERCICMFRETE := NVL(:new.PERCICMFRETE, VALIQICMSFRETE);
2832 :new.ALIQICMOUTRASDESP := NVL(:new.ALIQICMOUTRASDESP, VALIQICMSDESPESA);
2833 END IF;
2834 -------------------------------------------------------------------------------------
2835 -- GRAVANDO NA TABELA PCMOVCOMPLE
2836 -------------------------------------------------------------------------------------
2837 IF UPDATING
2838 THEN
2839 FOR CR_PCMOV IN (SELECT PCMOV.NUMTRANSITEM,
2840 PCMOV.NUMTRANSVENDA,
2841 PCMOV.CODPROD,
2842 PCMOV.NUMSEQ,
2843 PCMOV.NUMNOTA,
2844 PCMOVCOMPLE.ORIGMERCTRIB ORIGMERCTRIB_MOV,
2845 NVL(PCPRODFILIAL.ORIGMERCTRIB, DECODE(PCMOV.IMPORTADO, 'S', '2', DECODE(PCMOV.IMPORTADO, 'D', '1', '0'))) ORIGMERCTRIB
2846 FROM PCMOV,
2847 PCMOVCOMPLE,
2848 PCPRODFILIAL
2849 WHERE PCMOV.NUMTRANSVENDA = :OLD.NUMTRANSVENDA
2850 AND PCMOV.NUMNOTA = :OLD.NUMNOTA
2851 AND PCMOV.NUMTRANSITEM = PCMOVCOMPLE.NUMTRANSITEM(+)
2852 AND NVL(PCMOV.CODFILIALNF, PCMOV.CODFILIAL) = PCPRODFILIAL.CODFILIAL(+)
2853 AND PCMOV.CODPROD = PCPRODFILIAL.CODPROD(+)
2854 ) LOOP
2855 IF (CR_PCMOV.ORIGMERCTRIB_MOV IS NULL) AND (:NEW.SITUACAONFE > 0) AND (:NEW.SITUACAONFE <> :OLD.SITUACAONFE)
2856 THEN
2857 IF (NVL(CR_PCMOV.NUMTRANSITEM, 0) > 0)
2858 THEN
2859 UPDATE PCMOVCOMPLE SET
2860 PCMOVCOMPLE.ORIGMERCTRIB = CR_PCMOV.ORIGMERCTRIB
2861 WHERE PCMOVCOMPLE.NUMTRANSITEM = CR_PCMOV.NUMTRANSITEM
2862 AND PCMOVCOMPLE.ORIGMERCTRIB IS NULL;
2863 END IF;
2864
2865 IF (NVL(CR_PCMOV.NUMTRANSITEM, 0) = 0)
2866 THEN
2867 SELECT DFSEQ_PCMOVCOMPLE.NEXTVAL
2868 INTO VNUMTRANSITEM
2869 FROM DUAL;
2870
2871 IF VNUMTRANSITEM > 0
2872 THEN
2873 INSERT INTO PCMOVCOMPLE (ORIGMERCTRIB, NUMTRANSITEM)
2874 VALUES (CR_PCMOV.ORIGMERCTRIB, VNUMTRANSITEM);
2875
2876 UPDATE PCMOV SET NUMTRANSITEM = VNUMTRANSITEM
2877 WHERE NUMTRANSVENDA = CR_PCMOV.NUMTRANSVENDA
2878 AND NUMNOTA = CR_PCMOV.NUMNOTA
2879 AND CODPROD = CR_PCMOV.CODPROD
2880 AND NUMSEQ = CR_PCMOV.NUMSEQ;
2881 END IF;
2882 END IF;
2883 END IF;
2884 END LOOP;
2885
2886 --------------------------------------------------------------------------------
2887 --bloco abaixo serve para atualizar o cfop no cabeçalho da nota, também quando editado
2888 --0.149304.2016 - Eddy - 05/01/2016
2889 begin
2890 select min(CODFISCAL) CODFISCALNF
2891 into VCODFISCALNF
2892 from PCMOV
2893 where NUMTRANSVENDA = :new.NUMTRANSVENDA
2894 and DTCANCEL is null
2895 and QTCONT > 0;
2896 exception
2897 when others then
2898 begin
2899 begin
2900 select max(CODFISCAL)
2901 into VCODFISCALNF
2902 from PCNFBASE
2903 where NUMTRANSVENDA = :new.NUMTRANSVENDA;
2904 exception
2905 when others then
2906 null;
2907 end;
2908 end;
2909 end;
2910
2911 :new.CODFISCALNF := VCODFISCALNF;
2912 --------------------------------------------------------------------------------
2913
2914 END IF;
2915
2916exception
2917 when VERRO_TRIBUTACAO then
2918 begin
2919 GERAR_LOG(VMENSAGEM_ERRO,null);
2920 end;
2921 when others then
2922 begin
2923 GERAR_LOG(sqlerrm, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2924 exception
2925 when others then
2926 begin
2927 GERAR_LOG(sqlerrm, 'Erro na trigger T_PCNFSAID_HISTORICO');
2928 end;
2929 end;
2930end;
2931
2932
2933/
2934ALTER TRIGGER "VILLE5"."T_PCNFSAID_HISTORICO" ENABLE;
2935
2936 CREATE OR REPLACE TRIGGER "VILLE5"."TRG_PCNFSAID_DADOS_INICIAIS"
2937 BEFORE INSERT ON PCNFSAID
2938 REFERENCING OLD AS OLD NEW AS NEW
2939 FOR EACH ROW
2940DECLARE
2941 /*******************************************************************************
2942 Historico de Alteracoes
2943 --------------------------------------------------------------------------------
2944 Data Responsavel Tarefa Alteracao
2945 ----------- ------------- ---------------- -----------------------------------------
2946 12/05/2016 Eddy.Pereira 2033.051131.2016 Criação desta trigger, para dados iniciais
2947 dos registros
2948 *******************************************************************************/
2949 VSEQUIPAMENTO VARCHAR2(64);
2950 VSUSUARIO VARCHAR2(30);
2951 VSPROGRAMA VARCHAR2(48);
2952BEGIN
2953 IF :NEW.CODFILIALNF IS NULL THEN
2954 :NEW.CODFILIALNF := :NEW.CODFILIAL;
2955 END IF;
2956
2957 VSEQUIPAMENTO := SUBSTR(SYS_CONTEXT('USERENV', 'TERMINAL'), 1, 64);
2958 VSUSUARIO := SUBSTR(SYS_CONTEXT('USERENV', 'OS_USER'), 1, 30);
2959 VSPROGRAMA := SUBSTR(SYS_CONTEXT('USERENV', 'MODULE'), 1, 48);
2960
2961 IF :NEW.ROTINALANC IS NULL THEN
2962 :NEW.ROTINALANC := VSPROGRAMA;
2963 END IF;
2964
2965 IF ((UPPER(VSPROGRAMA) <> 'PCSIS1303.EXE') OR (VSPROGRAMA IS NULL)) AND
2966 --Tarefa 107540
2967 (:OLD.HORALANC IS NULL) AND
2968 (:OLD.MINUTOLANC IS NULL) THEN
2969 :NEW.HORALANC := TO_CHAR(SYSDATE, 'HH24');
2970 :NEW.MINUTOLANC := TO_CHAR(SYSDATE, 'MI');
2971 END IF;
2972
2973 :NEW.ROTINACAD := VSPROGRAMA;
2974 :NEW.EQUIPLANC := VSEQUIPAMENTO;
2975 :NEW.FUNCLANC := VSUSUARIO;
2976END;
2977
2978
2979/
2980ALTER TRIGGER "VILLE5"."TRG_PCNFSAID_DADOS_INICIAIS" ENABLE;
2981
2982 CREATE OR REPLACE TRIGGER "VILLE5"."TRG_PCNFSAID"
2983 BEFORE INSERT OR UPDATE
2984 ON pcnfsaid
2985 REFERENCING NEW AS NEW OLD AS OLD
2986 FOR EACH ROW
2987DECLARE
2988/*****************************************************************************
2989 Historico de Alteracoes
2990------------------------------------------------------------------------------
2991 Data Responsavel Tarefa Alteracao
2992 ---------- -------------------- -------- -----------------------------------
2993 25/04/2006 Rogerio Criacao do Programa
2994 27/05/2008 Pablo 63216 Totalização do PCNFSAID.VLBONIFIC conforme o PCMOV.QTCONT * PCMOV.PUNITCONT
2995 03/07/2008 Pablo Correção da totaliza da venda TV6 e TV12
2996 06/01/2009 Pablo 99270 Consultar pela numtransvenda estave gerando erro ao consultar pelo numped.
2997*****************************************************************************/
2998 vnvlbonific NUMBER;
2999BEGIN
3000 IF (:NEW.condvenda IN (5, 6, 11, 12))
3001 AND (:NEW.vlbonific IS NULL)
3002 THEN
3003 SELECT SUM ( round( DECODE (:NEW.condvenda
3004 ,6, pbonific
3005 ,12, pbonific
3006 ,punitcont
3007 )
3008 * DECODE (:NEW.condvenda
3009 ,6, qt
3010 ,12, qt
3011 ,qtcont
3012 ),2))
3013 INTO vnvlbonific
3014 FROM pcmov
3015 WHERE numtransvenda = :OLD.numtransvenda;
3016
3017 :NEW.vlbonific :=
3018 (vnvlbonific + NVL (:NEW.vlfrete, 0) + NVL (:NEW.vloutrasdesp, 0)
3019 );
3020 END IF;
3021END;
3022
3023
3024/
3025ALTER TRIGGER "VILLE5"."TRG_PCNFSAID" ENABLE;
3026
3027 CREATE OR REPLACE TRIGGER "VILLE5"."TRG_NFSAIDTRANSENTORIG"
3028BEFORE
3029INSERT OR UPDATE
3030ON PCNFSAID
3031REFERENCING OLD AS OLD NEW AS NEW
3032FOR EACH ROW
3033BEGIN
3034 if :new.NUMTRANSENTORIGEM IS null
3035 then :new.NUMTRANSENTORIGEM := :new.VILNUMTRANSENT ;
3036
3037END IF;
3038
3039 if :new.DTSAIDANF IS null
3040 then :new.DTSAIDANF := :new.DTENTREGA ;
3041
3042 END IF;
3043
3044
3045
3046END;
3047
3048
3049/
3050ALTER TRIGGER "VILLE5"."TRG_NFSAIDTRANSENTORIG" ENABLE;
3051
3052 CREATE OR REPLACE TRIGGER "VILLE5"."T_PCNFSAID_NFE"
3053 BEFORE UPDATE
3054 OF ESPECIE, SERIE, NUMNOTA, CHAVENFE, PROTOCOLONFE, RECIBONFE, SITUACAONFE, TIPOEMISSAO, CONSUMIUNUMNFE, CHAVECTE, SITUACAOCTE, SITUACAONFEEPEC, AMBIENTENFE, AMBIENTECTE, CODFILIAL, CODFILIALNF
3055 ON PCNFSAID
3056 REFERENCING OLD AS OLD NEW AS NEW
3057 FOR EACH ROW
3058declare
3059 procedure GERAR_LOG(PCAMPO in varchar2,
3060 PVALORANT in varchar2,
3061 PVALORNOVO in varchar2,
3062 PNUMTRANSVENDA in number,
3063 PERROADIC in varchar2 default '') is
3064 begin
3065 insert into PCLOGALTERACAODADOS
3066 (DATA,
3067 TABELA,
3068 COLUNA,
3069 TIPOVALOR,
3070 VALORALFAANT,
3071 VALORALFA,
3072 TERMINAL,
3073 MAQUINA,
3074 PROGRAMA,
3075 OSUSER,
3076 OBSERVACOES,
3077 OBSERVACOES2)
3078 values
3079 (sysdate,
3080 'PCNFSAID',
3081 PCAMPO,
3082 'A',
3083 PVALORANT,
3084 PVALORNOVO,
3085 SYS_CONTEXT('USERENV', 'TERMINAL'),
3086 SYS_CONTEXT('USERENV', 'HOST'),
3087 SYS_CONTEXT('USERENV', 'MODULE'),
3088 SYS_CONTEXT('USERENV', 'OS_USER'),
3089 'MUDANÇA DE INFORMAÇÃO: NUMTRANSVENDA: ' || TO_CHAR(PNUMTRANSVENDA),
3090 PERROADIC);
3091 end;
3092
3093begin
3094 if (SYS_CONTEXT('USERENV', 'MODULE') not like '%PCNFE%' and
3095 SYS_CONTEXT('USERENV', 'MODULE') not like '%PCSIS1008%')
3096 then
3097 if (:old.ESPECIE <> :new.ESPECIE) and (:old.chavenfe is not null)
3098 then
3099 GERAR_LOG('ESPECIE', :old.ESPECIE, :new.ESPECIE, :new.NUMTRANSVENDA);
3100 end if;
3101 if (:old.NUMNOTA <> :new.NUMNOTA and :old.NUMNOTA > 0)
3102 then
3103 GERAR_LOG('NUMNOTA',
3104 TO_CHAR(:old.NUMNOTA),
3105 TO_CHAR(:new.NUMNOTA),
3106 :new.NUMTRANSVENDA);
3107 end if;
3108 if (:old.SERIE <> :new.SERIE) and (:old.chavenfe is not null)
3109 then
3110 GERAR_LOG('SERIE', :old.SERIE, :new.SERIE, :new.NUMTRANSVENDA);
3111 end if;
3112 if NVL(:old.CHAVENFE, '0') <> NVL(:new.CHAVENFE, '0')
3113 then
3114 GERAR_LOG('CHAVENFE',
3115 :old.CHAVENFE,
3116 :new.CHAVENFE,
3117 :new.NUMTRANSVENDA);
3118 end if;
3119 if NVL(:old.PROTOCOLONFE, '0') <> NVL(:new.PROTOCOLONFE, '0')
3120 then
3121 GERAR_LOG('PROTOCOLONFE',
3122 :old.PROTOCOLONFE,
3123 :new.PROTOCOLONFE,
3124 :new.NUMTRANSVENDA);
3125 end if;
3126 if NVL(:old.RECIBONFE, '0') <> NVL(:new.RECIBONFE, '0')
3127 then
3128 GERAR_LOG('RECIBONFE',
3129 :old.RECIBONFE,
3130 :new.RECIBONFE,
3131 :new.NUMTRANSVENDA);
3132 end if;
3133 if NVL(:old.SITUACAONFE, 0) <> NVL(:new.SITUACAONFE, 0)
3134 then
3135 GERAR_LOG('SITUACAONFE',
3136 TO_CHAR(:old.SITUACAONFE),
3137 TO_CHAR(:new.SITUACAONFE),
3138 :new.NUMTRANSVENDA);
3139 end if;
3140 if NVL(:old.TIPOEMISSAO, '0') <> NVL(:new.TIPOEMISSAO, '0')
3141 then
3142 GERAR_LOG('TIPOEMISSAO',
3143 TO_CHAR(:old.TIPOEMISSAO),
3144 TO_CHAR(:new.TIPOEMISSAO),
3145 :new.NUMTRANSVENDA);
3146 end if;
3147 if NVL(:old.CONSUMIUNUMNFE, '0') <> NVL(:new.CONSUMIUNUMNFE, '0')
3148 then
3149 GERAR_LOG('CONSUMIUNUMNFE',
3150 TO_CHAR(:old.CONSUMIUNUMNFE),
3151 TO_CHAR(:new.CONSUMIUNUMNFE),
3152 :new.NUMTRANSVENDA);
3153 end if;
3154 if NVL(:old.CHAVECTE, '0') <> NVL(:new.CHAVECTE, '0')
3155 then
3156 GERAR_LOG('CHAVECTE',
3157 TO_CHAR(:old.CHAVECTE),
3158 TO_CHAR(:new.CHAVECTE),
3159 :new.NUMTRANSVENDA);
3160 end if;
3161 if NVL(:old.SITUACAOCTE, '0') <> NVL(:new.SITUACAOCTE, '0')
3162 then
3163 GERAR_LOG('SITUACAOCTE',
3164 TO_CHAR(:old.SITUACAOCTE),
3165 TO_CHAR(:new.SITUACAOCTE),
3166 :new.NUMTRANSVENDA);
3167 end if;
3168 if NVL(:old.SITUACAONFEEPEC, '0') <> NVL(:new.SITUACAONFEEPEC, '0')
3169 then
3170 GERAR_LOG('SITUACAONFEEPEC',
3171 TO_CHAR(:old.SITUACAONFEEPEC),
3172 TO_CHAR(:new.SITUACAONFEEPEC),
3173 :new.NUMTRANSVENDA);
3174 end if;
3175 if NVL(:old.AMBIENTENFE, '0') <> NVL(:new.AMBIENTENFE, '0')
3176 then
3177 GERAR_LOG('AMBIENTENFE',
3178 TO_CHAR(:old.AMBIENTENFE),
3179 TO_CHAR(:new.AMBIENTENFE),
3180 :new.NUMTRANSVENDA);
3181 end if;
3182 if NVL(:old.AMBIENTECTE, '0') <> NVL(:new.AMBIENTECTE, '0')
3183 then
3184 GERAR_LOG('AMBIENTECTE',
3185 TO_CHAR(:old.AMBIENTECTE),
3186 TO_CHAR(:new.AMBIENTECTE),
3187 :new.NUMTRANSVENDA);
3188 end if;
3189 if NVL(:old.CODFILIAL, '0') <> NVL(:new.CODFILIAL, '0')
3190 then
3191 GERAR_LOG('CODFILIAL',
3192 TO_CHAR(:old.CODFILIAL),
3193 TO_CHAR(:new.CODFILIAL),
3194 :new.NUMTRANSVENDA);
3195 end if;
3196 if NVL(:old.CODFILIALNF, '0') <> NVL(:new.CODFILIALNF, '0')
3197 then
3198 GERAR_LOG('CODFILIAL',
3199 TO_CHAR(:old.CODFILIALNF),
3200 TO_CHAR(:new.CODFILIALNF),
3201 :new.NUMTRANSVENDA);
3202 end if;
3203 end if;
3204exception
3205 when others then
3206 GERAR_LOG('NENHUM',
3207 '',
3208 'ERRO AO GERAR RASTREABILIDADE NFE',
3209 :new.NUMTRANSVENDA,
3210 'ERRO OCORRIDO: ' || sqlerrm);
3211
3212end; -- Ricardo 13/02/2013
3213
3214
3215/
3216ALTER TRIGGER "VILLE5"."T_PCNFSAID_NFE" ENABLE;
3217
3218 CREATE OR REPLACE TRIGGER "VILLE5"."TRG_PCNFSAID_DELETE"
3219 BEFORE DELETE ON PCNFSAID REFERENCES OLD AS OLD NEW AS NEW
3220 FOR EACH ROW
3221
3222DECLARE
3223 V_SCRIPT long;
3224
3225 vn_TRANSACAO PCNFENT.NUMTRANSENT%TYPE;
3226 VSPROGRAMA VARCHAR2(30);
3227 VSUSUARIO VARCHAR2(40);
3228 v_code NUMBER;
3229 v_errm VARCHAR2(64);
3230 vc_insert CLOB;
3231BEGIN
3232
3233 vn_TRANSACAO := :OLD.NUMTRANSVENDA;
3234
3235 VSUSUARIO := SUBSTR(SYS_CONTEXT('USERENV', 'OS_USER'), 1, 30);
3236 VSPROGRAMA := SUBSTR(SYS_CONTEXT('USERENV', 'MODULE'), 1, 48);
3237
3238 V_SCRIPT :=
3239 'DECLARE
3240 vc_insert_Colunas CLOB;
3241 vc_insert_Values CLOB;
3242 vc_insert CLOB;
3243 vs_DataType VARCHAR2(100);
3244 vn_TRANSACAO PCMOV.NUMTRANSVENDA%TYPE;
3245 VSPROGRAMA VARCHAR2(30);
3246 VSUSUARIO VARCHAR2(40);
3247 v_code NUMBER;
3248 v_errm VARCHAR2(64);
3249 BEGIN
3250 VSUSUARIO := SUBSTR(SYS_CONTEXT(''USERENV'', ''OS_USER''), 1, 30);
3251 VSPROGRAMA := SUBSTR(SYS_CONTEXT(''USERENV'', ''MODULE''), 1, 48);
3252 BEGIN
3253 for dados in (with t as (select xmltype(DBMS_XMLGEN.getXML(''SELECT * FROM PCNFSAID WHERE NUMTRANSVENDA = '||vn_TRANSACAO|| ' '')) xml
3254 from dual)
3255
3256 select t2.column_value.getrootelement() coluna,
3257 extractvalue(t2.column_value,
3258 t2.column_value.getrootelement()) as valor
3259 from t t,
3260 table(xmlsequence(t.xml.extract(''/ROWSET/ROW/node()''))) t2) loop
3261
3262 BEGIN
3263 SElECT c.DATA_TYPE
3264 INTO vs_DataType
3265 FROM all_tab_columns c
3266 WHERE c.TABLE_NAME = ''PCNFSAID''
3267 AND c.COLUMN_NAME = dados.coluna;
3268 EXCEPTION
3269 WHEN NO_DATA_FOUND THEN
3270 vs_DataType := '''';
3271 END;
3272 vc_insert_Colunas := vc_insert_Colunas || dados.coluna || '','';
3273
3274 IF vs_DataType = ''DATE'' THEN
3275
3276 vc_insert_Values := vc_insert_Values || ''TO_DATE('' || '''''''' ||
3277 SUBSTR(dados.valor, 1, CASE WHEN instr(dados.valor,'' '') = 0 THEN LENGTH(dados.valor) ELSE instr(dados.valor,'' '') END ) || '''''''' || '','' ||
3278 ''''''DD/MM/YYYY '''''' || '')'' || '','';
3279
3280 ELSIF (vs_DataType = ''VARCHAR2'') OR (vs_DataType = ''VARCHAR'') OR (vs_DataType = ''RAW'') OR (vs_DataType = ''CLOB'') THEN
3281
3282 vc_insert_Values := vc_insert_Values || '''''''' ||
3283 dados.valor || '''''''' || '','';
3284
3285 ELSE
3286
3287 vc_insert_Values := vc_insert_Values || dados.valor || '','';
3288
3289 END IF;
3290
3291 end loop;
3292
3293 vn_TRANSACAO := '||vn_TRANSACAO||';
3294
3295 vc_insert := ''INSERT INTO PCNFSAID ('' ||
3296 SUBSTR(vc_insert_Colunas,
3297 1,
3298 LENGTH(vc_insert_Colunas) - 1) ||
3299 '')VALUES('' ||
3300 SUBSTR(vc_insert_Values,
3301 1,
3302 LENGTH(vc_insert_Values) - 1) || '')'';
3303
3304 EXCEPTION
3305 WHEN OTHERS THEN
3306 v_code := SQLCODE;
3307 v_errm := SUBSTR(SQLERRM, 1 , 64);
3308 vc_insert := ''Não foi possÃvel obter a linha de recuparação da PCMOV.''||chr(13)||
3309 ''Verifique se seu banco tem o modulo DBMS_XMLGEN corretamente instalado.''||chr(13)||
3310 ''Erro:'' || ''v_code'' || ''-'' || v_errm;
3311
3312 END;
3313
3314 INSERT INTO PCLOGDELETEDADOS
3315 (TABELA, TRANSACAO, USUARIO, ARQUIVO, DTDELETE, MOVIMENTACAO, ROTINA)
3316 VALUES
3317 (''PCNFSAID'',
3318 vn_TRANSACAO,
3319 VSUSUARIO,
3320 vc_insert,
3321 SYSDATE,
3322 ''S'',
3323 VSPROGRAMA);
3324 END;';
3325
3326 BEGIN
3327 execute immediate DBMS_LOB.SUBSTR(V_SCRIPT, 32765, 1);
3328 EXCEPTION
3329 WHEN OTHERS THEN
3330 v_code := SQLCODE;
3331 v_errm := SUBSTR(SQLERRM, 1 , 64);
3332 vc_insert := 'Não foi possÃvel obter a linha de recuparação da PCMOV.'||chr(13)||
3333 'Verifique se seu banco tem o modulo DBMS_XMLGEN corretamente instalado.'||chr(13)||
3334 'Erro:' || v_code || '-' || v_errm;
3335 INSERT INTO PCLOGDELETEDADOS
3336 (TABELA, TRANSACAO, USUARIO, ARQUIVO, DTDELETE, MOVIMENTACAO, ROTINA)
3337 VALUES
3338 ('PCNFSAID',
3339 vn_TRANSACAO,
3340 VSUSUARIO,
3341 vc_insert,
3342 SYSDATE,
3343 'S',
3344 VSPROGRAMA);
3345
3346 END;
3347
3348
3349 /*INSERT INTO PCLOGDELETEDADOS
3350 (TABELA, TRANSACAO, USUARIO, ARQUIVO, DTDELETE, MOVIMENTACAO, ROTINA)
3351 VALUES
3352 ('PCMOV',
3353 1,
3354 '',
3355 V_SCRIPT,
3356 SYSDATE,
3357 '1',
3358 'teste'); */
3359END;
3360
3361
3362/
3363ALTER TRIGGER "VILLE5"."TRG_PCNFSAID_DELETE" ENABLE;
3364
3365 CREATE OR REPLACE TRIGGER "VILLE5"."TR_WMS_GERARWMSAUTOMATICO"
3366 AFTER
3367 INSERT
3368 ON PCNFSAID
3369 REFERENCING OLD AS OLD NEW AS NEW
3370 FOR EACH ROW
3371DECLARE
3372 vgerawmsautomatico pcparametrowms.valor%TYPE;
3373 vgerawmsautomaticovendabalcao pcparametrowms.valor%TYPE;
3374 vnumped pcpedc.numped%TYPE;
3375 vfilialusawms pcfilial.usawms%TYPE;
3376BEGIN
3377 IF (:NEW.rotinalanc = 'AutoServico.Faturamento.exe') OR (:NEW.rotinalanc LIKE '%2030%') OR (:NEW.rotinalanc LIKE '%2075%') OR (:NEW.numped > 0)
3378 THEN
3379 BEGIN --Parametros
3380 SELECT NVL (valor, 'N')
3381 INTO vgerawmsautomatico
3382 FROM pcparametrowms
3383 WHERE nome IN ('GERARWMSAUTOMATICOPARAAUTOSERVICO')
3384 AND codfilial = :NEW.codfilial;
3385 EXCEPTION
3386 WHEN NO_DATA_FOUND
3387 THEN
3388 vgerawmsautomatico := 'N';
3389 END;
3390
3391 IF vgerawmsautomatico = 'S'
3392 THEN
3393 BEGIN --Filial do pedido utiliza WMS
3394 SELECT NVL (usawms, 'N')
3395 INTO vfilialusawms
3396 FROM pcfilial
3397 WHERE codigo IN (
3398 SELECT MAX (NVL (i.codfilialretira, c.codfilial))
3399 FROM pcpedi i, pcpedc c
3400 WHERE i.numped = c.numped
3401 AND c.numped = :NEW.numped);
3402 EXCEPTION
3403 WHEN NO_DATA_FOUND
3404 THEN
3405 vfilialusawms := 'N';
3406 END;
3407
3408 IF vfilialusawms = 'S'
3409 THEN
3410 BEGIN --Parametros
3411 SELECT DECODE (NVL (valor, 'N'), 'N', 'A', 'B')
3412 INTO vgerawmsautomaticovendabalcao
3413 FROM pcparametrowms
3414 WHERE nome IN ('GERAWMSAUTOMATICOVENDABALCAO')
3415 AND codfilial = :NEW.codfilial;
3416 EXCEPTION
3417 WHEN NO_DATA_FOUND
3418 THEN
3419 vgerawmsautomaticovendabalcao := 'N';
3420 END;
3421
3422 --Ilquias - Devido autosservico faturar todas as origens exceto B
3423 IF ((:NEW.rotinalanc = 'AutoServico.Faturamento.exe') OR (:NEW.rotinalanc LIKE '%2030%')) and (vgerawmsautomaticovendabalcao in ('B', 'A'))
3424 THEN
3425 SELECT origemped
3426 INTO vgerawmsautomaticovendabalcao
3427 FROM pcpedc
3428 WHERE numped = :NEW.numped;
3429 END IF;
3430
3431 FOR reg IN (SELECT DISTINCT (NVL (c.numped, 0)) numped
3432 FROM pcpedc c
3433 WHERE c.numped = :NEW.numped
3434 AND c.dtwms IS NULL
3435 AND nvl(c.condvenda,0) NOT IN (4, 7, 14) --venda igual 4 ? simples remessa, e gera somente o contabil.
3436 AND ( (c.origemped = 'A')
3437 OR (c.origemped = vgerawmsautomaticovendabalcao
3438 )
3439 )
3440 AND NOT EXISTS (
3441 SELECT 1
3442 FROM pcwms
3443 WHERE pcwms.numped = c.numped
3444 AND PCWMS.CODOPER = 'S'))
3445 LOOP
3446 IF reg.numped > 0
3447 THEN
3448 wms_gera_movimentacao (reg.numped, 1700);
3449 END IF;
3450 END LOOP;
3451 END IF;
3452 END IF;
3453 END IF;
3454END;
3455
3456
3457/
3458ALTER TRIGGER "VILLE5"."TR_WMS_GERARWMSAUTOMATICO" ENABLE;
3459
3460 CREATE OR REPLACE TRIGGER "VILLE5"."VILLE_FILIAL_PCNFSAID"
3461 BEFORE INSERT OR UPDATE
3462 ON PCNFSAID
3463 REFERENCING OLD AS OLD NEW AS NEW
3464 FOR EACH ROW
3465BEGIN
3466 IF :NEW.codfilial IN (10, 29)
3467 THEN
3468 :NEW.codfilialnf := 10;
3469 ELSE
3470 IF :NEW.codfilial IN (6, 7, 8)
3471 THEN
3472 :NEW.codfilialnf := 7;
3473 ELSE
3474 IF :NEW.codfilial IN (1, 16, 17)
3475 THEN
3476 :NEW.codfilialnf := 16;
3477 ELSE
3478 :NEW.codfilialnf := :NEW.codfilial;
3479 END IF;
3480 END IF;
3481 END IF;
3482END;
3483
3484
3485/
3486ALTER TRIGGER "VILLE5"."VILLE_FILIAL_PCNFSAID" ENABLE;
3487
3488 CREATE OR REPLACE TRIGGER "VILLE5"."LOG_PCNFSAID"
3489 BEFORE UPDATE ON PCNFSAID
3490 REFERENCING OLD AS OLD NEW AS NEW
3491 FOR EACH ROW
3492DECLARE
3493 /*******************************************************************************
3494 Historico de Alteracoes
3495 --------------------------------------------------------------------------------
3496 Data Responsavel Tarefa Alteracao
3497 ----------- ----------------- --------------------- -----------------------------------------
3498 30/11/2005 Sabrina 23303 Apenas gravar dados de rotinalanc
3499 se o mesmo estiver vazio
3500 15/01/2007 Sabrina 37619 Correcao na gravacao de dados de usuario
3501 para tratar quando a execucao for
3502 acionada por jobs e nao usuarios
3503 07/07/2008 Rogério 64879 Não atualizar campos MINUTOLANC e HORALANC
3504 da PCNFSAID se alteração for proviniente
3505 da Rotina 1303.
3506 13/05/2010 Thiago 107540 Conforme solicitação Rafael Martins não atualizar os campos
3507 caso os mesmos esteja preenchidos MINUTOLANC e HORALANC
3508 26/09/2010 Thiago 144863 Delimitando a quantidade de caracteres do campo "pcnfsaid.equiplanc"
3509 12/05/2016 Eddy.Pereira 2033.051131.2016 Separação da parte de gravação dos dados
3510 apenas no insert e dos dados de update.
3511 Nova trigger com a parte do insert: TRG_PCNFSAID_DADOS_INICIAIS
3512 *******************************************************************************/
3513 VSEQUIPAMENTO VARCHAR2(64);
3514 VSUSUARIO VARCHAR2(30);
3515 VSPROGRAMA VARCHAR2(48);
3516BEGIN
3517
3518 VSEQUIPAMENTO := SUBSTR(SYS_CONTEXT('USERENV', 'TERMINAL'), 1, 64);
3519 VSUSUARIO := SUBSTR(SYS_CONTEXT('USERENV', 'OS_USER'), 1, 30);
3520 VSPROGRAMA := SUBSTR(SYS_CONTEXT('USERENV', 'MODULE'), 1, 48);
3521
3522 :NEW.ROTINALANC := VSPROGRAMA;
3523 :NEW.EQUIPLANC := VSEQUIPAMENTO;
3524 :NEW.FUNCLANC := VSUSUARIO;
3525END;
3526
3527
3528/
3529ALTER TRIGGER "VILLE5"."LOG_PCNFSAID" ENABLE;
3530
3531 CREATE OR REPLACE TRIGGER "VILLE5"."T_PCNFSAID_CONTROLE_NUMNOTA"
3532 before update of NUMNOTA on PCNFSAID
3533 referencing old as old new as new
3534 for each row
3535declare
3536 ALTERACAO_NUMNOTA_INDEVIDA exception;
3537
3538 procedure GERAR_LOG(PCAMPO in varchar2,
3539 PVALORANT in varchar2,
3540 PVALORNOVO in varchar2,
3541 PNUMTRANSVENDA in number,
3542 PERROADIC in varchar2 default NULL) is
3543 begin
3544 insert into PCLOGALTERACAODADOS
3545 (DATA
3546 ,TABELA
3547 ,COLUNA
3548 ,TIPOVALOR
3549 ,VALORALFAANT
3550 ,VALORALFA
3551 ,TERMINAL
3552 ,MAQUINA
3553 ,PROGRAMA
3554 ,OSUSER
3555 ,OBSERVACOES
3556 ,OBSERVACOES2)
3557 values
3558 (sysdate
3559 ,'PCNFSAID'
3560 ,PCAMPO
3561 ,'A'
3562 ,PVALORANT
3563 ,PVALORNOVO
3564 ,SYS_CONTEXT('USERENV', 'TERMINAL')
3565 ,SYS_CONTEXT('USERENV', 'HOST')
3566 ,SYS_CONTEXT('USERENV', 'MODULE')
3567 ,SYS_CONTEXT('USERENV', 'OS_USER')
3568 ,'MUDANÇA DO NUMNOTA: NUMTRANSVENDA: ' || TO_CHAR(PNUMTRANSVENDA)
3569 ,PERROADIC);
3570 end;
3571
3572begin
3573
3574 if NVL(:OLD.CONSUMIUNUMNFE, 'N') = 'S' and NVL(:NEW.NUMNOTA, 0) <> NVL(:OLD.NUMNOTA, 0)
3575 then
3576 raise ALTERACAO_NUMNOTA_INDEVIDA;
3577 end if;
3578
3579exception
3580 when ALTERACAO_NUMNOTA_INDEVIDA then
3581 RAISE_APPLICATION_ERROR(-20000,
3582 'OCORREU UMA TENTATIVA DE ALTERAÇÃO DO NÚMERO DA NOTA FISCAL INDEVIDAMENTE!' || CHR(13) ||
3583 'O PROCESSO SERà ABORTADO.' || CHR(13) || 'TRANSAÇÃO DE SAÃDA: ' || :NEW.NUMTRANSVENDA);
3584 when others then
3585 GERAR_LOG('NUMNOTA', :OLD.NUMNOTA, :NEW.NUMNOTA, :NEW.NUMTRANSVENDA, 'ERRO OCORRIDO: ' || sqlerrm);
3586
3587end; -- Ricardo 12/08/2015
3588
3589
3590/
3591ALTER TRIGGER "VILLE5"."T_PCNFSAID_CONTROLE_NUMNOTA" ENABLE;
3592
3593 CREATE OR REPLACE TRIGGER "VILLE5"."TRG_ECOMMERCE_PCNFSAID"
3594 BEFORE
3595 DELETE OR UPDATE OF CHAVENFE
3596 ON PCNFSAID
3597REFERENCING NEW AS NEW OLD AS OLD
3598 FOR EACH ROW
3599BEGIN
3600 BEGIN
3601 INSERT INTO PCECOMMERCEUNILEVERFILA (CODFILIAL, TABELA, ID, DTINCLUSAO)
3602 SELECT NVL(PCPEDCTEMP.SERIEMANIF, PCPEDCTEMP.CODFILIAL),'SELECTPEDIDO', PCPEDCTEMP.ROWID, SYSDATE
3603 FROM PCPEDCTEMP
3604 WHERE PCPEDCTEMP.NUMPED = :NEW.NUMPED
3605 AND PCPEDCTEMP.NUMPED > 0
3606 AND PCPEDCTEMP.INTEGRADORA = 29
3607 AND :NEW.CHAVENFE IS NOT NULL;
3608 EXCEPTION
3609 WHEN DUP_VAL_ON_INDEX THEN
3610 NULL;
3611 END;
3612
3613 --Enviar sempre o limite de crédito também
3614 BEGIN
3615 INSERT INTO PCECOMMERCEUNILEVERFILA (CODFILIAL, TABELA, ID, DTINCLUSAO)
3616 SELECT PCECOMMERCEUNILEVERCLIENTE.CODFILIAL
3617 , 'SELECTLIMITE'
3618 , PCCLIENT.ROWID
3619 , SYSDATE
3620 FROM PCECOMMERCEUNILEVERCLIENTE
3621 , PCCLIENT
3622 WHERE PCCLIENT.CODCLI = NVL(:OLD.CODCLI, :NEW.CODCLI)
3623 AND NVL(PCCLIENT.SITUACAOECOMMERCEUNILEVER,'NAO') <> 'NAO'
3624 AND PCECOMMERCEUNILEVERCLIENTE.CODCLI = PCCLIENT.CODCLI
3625 AND PCECOMMERCEUNILEVERCLIENTE.CODFILIAL = NVL(:OLD.CODFILIALNF, :OLD.CODFILIAL);
3626 EXCEPTION
3627 WHEN DUP_VAL_ON_INDEX THEN
3628 NULL;
3629 END;
3630END;
3631/
3632ALTER TRIGGER "VILLE5"."TRG_ECOMMERCE_PCNFSAID" ENABLE;