Advertisement
martinsluis

Script_vendas_concluidas

Sep 13th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.50 KB | None | 0 0
  1. --Feita no sisSerraria
  2. INSERT INTO VENDAS (ECF_NUMERO, ECF_DATA, CLI_CODIGO, VEN_CODIGO, ECF_DESCONTO, ECF_TOTAL, VND_TOTAL_LIQ, VND_DTFECHA, VND_DTMODIFICA, VND_HRMODIFICA, VND_MODIFICADO, CPG_CODIGO, VND_TOTAL_FECHADO, VND_TRAVADO, VND_VALIDADE, VND_ENTREGA, VND_CONDPAGAMENTO, VND_DESCLIBERADO, VND_TOTAL_DESCONTAVEL, VND_DESC_SOLICITADO, VND_DESCONTO_ITENS, FPG_CODIGO, VND_EXPORTADO, VND_SITUACAO, VND_COM_ESQUADRIA, CAR_SIGLA, VND_COM_ESQFERRO, VND_ENTREGA_LIB, VENDA_ID, VENDEDOR_ID, FORMAPGTO_ID)
  3.             VALUES (142442, '2019-09-13 00:00:00', 18942, '13', NULL, 22, 22, NULL, '2019-09-13 00:00:00', '09:04:55', 'THIAGO-PC', 2, 0, NULL, '05 (CINCO) DIAS', 'IMEDIATA', NULL, 0, 0, NULL, 0, 'CC ', NULL, 'F', 'N', NULL, 'N', NULL, 142443, 13, 0);
  4.  
  5. COMMIT WORK;
  6. --
  7. --AppWEB
  8.  
  9. INSERT INTO VENDAS (ECF_NUMERO, ECF_DATA, CLI_CODIGO, VEN_CODIGO, ECF_DESCONTO, ECF_TOTAL, VND_TOTAL_LIQ, VND_DTFECHA, VND_DTMODIFICA, VND_HRMODIFICA, VND_MODIFICADO, CPG_CODIGO, VND_TOTAL_FECHADO, VND_TRAVADO, VND_VALIDADE, VND_ENTREGA, VND_CONDPAGAMENTO, VND_DESCLIBERADO, VND_TOTAL_DESCONTAVEL, VND_DESC_SOLICITADO, VND_DESCONTO_ITENS, FPG_CODIGO, VND_EXPORTADO, VND_SITUACAO, VND_COM_ESQUADRIA, CAR_SIGLA, VND_COM_ESQFERRO, VND_ENTREGA_LIB, VENDA_ID, VENDEDOR_ID, FORMAPGTO_ID)
  10.             VALUES (142444, '2019-09-13 00:00:00', 18942, '13', NULL, 22, 22, NULL, '2019-09-13 00:00:00', '09:09:07', 'HUGO', 2, 0, 'N', '05 (CINCO) DIAS', 'IMEDIATA', NULL, 0, 22, NULL, 0, 'CC ', NULL, 'F', NULL, NULL, NULL, NULL, 142445, 13, 4);
  11.  
  12. COMMIT WORK;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement