Process_inv SQL 
Begin transaction; 


INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800240', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800240'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800240'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 1, 0, 0.000, '', '5600962800240', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('1',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(13.00, '5600962824055', 'SERIE DE NATAL LED C/500L P/EXTERIOR', (select art_med from art where art_ref='5600962824055'), 0, 0, (select art_med * 13.00 from art where art_ref='5600962824055'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 2, 0, 0.000, '', '5600962824055', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('2',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(17.00, '5600962800233', 'LED NATAL 200L EXTERIOR', (select art_med from art where art_ref='5600962800233'), 0, 0, (select art_med * 17.00 from art where art_ref='5600962800233'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 3, 0, 0.000, '', '5600962800233', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('3',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(24.00, '5600962800226', 'SERIE DE NATAL LED C/150L P/EXTERIOR', (select art_med from art where art_ref='5600962800226'), 0, 0, (select art_med * 24.00 from art where art_ref='5600962800226'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 4, 0, 0.000, '', '5600962800226', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('4',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(20.00, '5600962800219', 'SERIE DE NATAL LED C/100L P/EXTERIOR', (select art_med from art where art_ref='5600962800219'), 0, 0, (select art_med * 20.00 from art where art_ref='5600962800219'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 5, 0, 0.000, '', '5600962800219', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('5',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(5.00, '5600962940755', 'SERIE DE NATAL LED C/800L P/EXTERIOR', (select art_med from art where art_ref='5600962940755'), 0, 0, (select art_med * 5.00 from art where art_ref='5600962940755'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 6, 0, 0.000, '', '5600962940755', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('6',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(8.00, '5600962824086', 'SERIE DE NATAL LED C/500L P/EXTERIOR', (select art_med from art where art_ref='5600962824086'), 0, 0, (select art_med * 8.00 from art where art_ref='5600962824086'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 7, 0, 0.000, '', '5600962824086', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('7',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(17.00, '5600962800400', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800400'), 0, 0, (select art_med * 17.00 from art where art_ref='5600962800400'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 8, 0, 0.000, '', '5600962800400', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('8',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800394', 'SERIE DE NATAL LED C/200L P/EXTERIOR', (select art_med from art where art_ref='5600962800394'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800394'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 9, 0, 0.000, '', '5600962800394', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('9',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(31.00, '5600962800387', 'SERIE NATAL 150L', (select art_med from art where art_ref='5600962800387'), 0, 0, (select art_med * 31.00 from art where art_ref='5600962800387'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 10, 0, 0.000, '', '5600962800387', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('10',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(24.00, '5600962800370', 'SERIE NATAL 100L', (select art_med from art where art_ref='5600962800370'), 0, 0, (select art_med * 24.00 from art where art_ref='5600962800370'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 11, 0, 0.000, '', '5600962800370', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('11',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(23.00, '5600962824116', 'SERIE DE NATAL LED C/500L P/INTERIOR', (select art_med from art where art_ref='5600962824116'), 0, 0, (select art_med * 23.00 from art where art_ref='5600962824116'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 12, 0, 0.000, '', '5600962824116', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('12',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(18.00, '5600962800738', 'SERIE DE NATAL LED C/300L P/INTERIOR', (select art_med from art where art_ref='5600962800738'), 0, 0, (select art_med * 18.00 from art where art_ref='5600962800738'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 13, 0, 0.000, '', '5600962800738', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('13',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(20.00, '5600962800721', 'SERIE DE NATAL LED C/200L P/INTERIOR', (select art_med from art where art_ref='5600962800721'), 0, 0, (select art_med * 20.00 from art where art_ref='5600962800721'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 14, 0, 0.000, '', '5600962800721', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('14',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(25.00, '5600962800714', 'SERIE DE NATAL LED C/150L P/INTERIOR', (select art_med from art where art_ref='5600962800714'), 0, 0, (select art_med * 25.00 from art where art_ref='5600962800714'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 15, 0, 0.000, '', '5600962800714', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('15',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(13.00, '5600962800714', 'SERIE DE NATAL LED C/150L P/INTERIOR', (select art_med from art where art_ref='5600962800714'), 0, 0, (select art_med * 13.00 from art where art_ref='5600962800714'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 16, 0, 0.000, '', '5600962800714', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('16',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800707', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962800707'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800707'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 17, 0, 0.000, '', '5600962800707', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('17',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962800691', 'SERIE DE NATAL LED C/50L P/INTERIOR', (select art_med from art where art_ref='5600962800691'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962800691'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 18, 0, 0.000, '', '5600962800691', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('18',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(18.00, '5600962824147', 'SERIE DE NATAL LED C/500L P/INTERIOR', (select art_med from art where art_ref='5600962824147'), 0, 0, (select art_med * 18.00 from art where art_ref='5600962824147'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 19, 0, 0.000, '', '5600962824147', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('19',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(10.00, '5600962800936', 'SERIE DE NATAL LED C/300L P/INTERIOR', (select art_med from art where art_ref='5600962800936'), 0, 0, (select art_med * 10.00 from art where art_ref='5600962800936'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 20, 0, 0.000, '', '5600962800936', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('20',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(9.00, '5600962800929', 'SERIE DE NATAL LED C/200L P/INTERIOR', (select art_med from art where art_ref='5600962800929'), 0, 0, (select art_med * 9.00 from art where art_ref='5600962800929'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 21, 0, 0.000, '', '5600962800929', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('21',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(18.00, '5600962800912', 'SERIE DE NATAL LED C/150L P/INTERIOR', (select art_med from art where art_ref='5600962800912'), 0, 0, (select art_med * 18.00 from art where art_ref='5600962800912'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 22, 0, 0.000, '', '5600962800912', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('22',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(8.00, '5600962800905', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962800905'), 0, 0, (select art_med * 8.00 from art where art_ref='5600962800905'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 23, 0, 0.000, '', '5600962800905', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('23',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(43.00, '5600962800899', 'SERIE DE NATAL LED C/50L P/INTERIOR', (select art_med from art where art_ref='5600962800899'), 0, 0, (select art_med * 43.00 from art where art_ref='5600962800899'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 24, 0, 0.000, '', '5600962800899', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('24',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(2.00, '5600962801049', 'SERIE DE NATAL LED C/50L P/INTERIOR', (select art_med from art where art_ref='5600962801049'), 0, 0, (select art_med * 2.00 from art where art_ref='5600962801049'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 25, 0, 0.000, '', '5600962801049', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('25',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(14.00, '5600962801056', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962801056'), 0, 0, (select art_med * 14.00 from art where art_ref='5600962801056'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 26, 0, 0.000, '', '5600962801056', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('26',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(16.00, '5600962801063', 'SERIE DE NATAL LED C/150L P/INTERIOR', (select art_med from art where art_ref='5600962801063'), 0, 0, (select art_med * 16.00 from art where art_ref='5600962801063'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 27, 0, 0.000, '', '5600962801063', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('27',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962801070', 'SERIE DE NATAL LED C/200L P/INTERIOR', (select art_med from art where art_ref='5600962801070'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962801070'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 28, 0, 0.000, '', '5600962801070', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('28',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(17.00, '5600962801087', 'SERIE DE NATAL LED C/300L P/INTERIOR', (select art_med from art where art_ref='5600962801087'), 0, 0, (select art_med * 17.00 from art where art_ref='5600962801087'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 29, 0, 0.000, '', '5600962801087', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('29',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(7.00, '5600962824161', 'SERIE DE NATAL LED C/500L P/INTERIOR', (select art_med from art where art_ref='5600962824161'), 0, 0, (select art_med * 7.00 from art where art_ref='5600962824161'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 30, 0, 0.000, '', '5600962824161', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('30',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(18.00, '5600962800844', 'SERIE DE NATAL LED C/50L P/INTERIOR', (select art_med from art where art_ref='5600962800844'), 0, 0, (select art_med * 18.00 from art where art_ref='5600962800844'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 31, 0, 0.000, '', '5600962800844', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('31',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(27.00, '5600962800851', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962800851'), 0, 0, (select art_med * 27.00 from art where art_ref='5600962800851'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 32, 0, 0.000, '', '5600962800851', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('32',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(14.00, '5600962800868', 'SERIE NATAL 150L', (select art_med from art where art_ref='5600962800868'), 0, 0, (select art_med * 14.00 from art where art_ref='5600962800868'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 33, 0, 0.000, '', '5600962800868', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('33',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962800875', 'SERIE DE NATAL LED C/200L P/INTERIOR', (select art_med from art where art_ref='5600962800875'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962800875'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 34, 0, 0.000, '', '5600962800875', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('34',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962800882', 'SERIE NATAL 300L', (select art_med from art where art_ref='5600962800882'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962800882'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 35, 0, 0.000, '', '5600962800882', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('35',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962824130', 'SERIE DE NATAL LED C/500L P/INTERIOR', (select art_med from art where art_ref='5600962824130'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962824130'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 36, 0, 0.000, '', '5600962824130', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('36',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(7.00, '5600962800493', 'SERIE DE NATAL LED C/100L P/EXTERIOR', (select art_med from art where art_ref='5600962800493'), 0, 0, (select art_med * 7.00 from art where art_ref='5600962800493'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 37, 0, 0.000, '', '5600962800493', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('37',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(5.00, '5605858822689', 'LUZES NATAL', (select art_med from art where art_ref='5605858822689'), 0, 0, (select art_med * 5.00 from art where art_ref='5605858822689'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 38, 0, 0.000, '', '5605858822689', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('38',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(8.00, '5600962800509', 'SERIE DE NATAL LED C/150L P/EXTERIOR', (select art_med from art where art_ref='5600962800509'), 0, 0, (select art_med * 8.00 from art where art_ref='5600962800509'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 39, 0, 0.000, '', '5600962800509', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('39',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(15.00, '5600962800516', 'SERIE DE NATAL LED C/200L P/EXTERIOR', (select art_med from art where art_ref='5600962800516'), 0, 0, (select art_med * 15.00 from art where art_ref='5600962800516'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 40, 0, 0.000, '', '5600962800516', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('40',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(14.00, '5600962800523', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800523'), 0, 0, (select art_med * 14.00 from art where art_ref='5600962800523'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 41, 0, 0.000, '', '5600962800523', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('41',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962800523', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800523'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962800523'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 42, 0, 0.000, '', '5600962800523', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('42',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(2.00, '5600962824109', 'SERIE DE NATAL LED C/500L P/EXTERIOR', (select art_med from art where art_ref='5600962824109'), 0, 0, (select art_med * 2.00 from art where art_ref='5600962824109'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 43, 0, 0.000, '', '5600962824109', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('43',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800332', 'SERIE NATAL 100L', (select art_med from art where art_ref='5600962800332'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800332'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 44, 0, 0.000, '', '5600962800332', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('44',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(16.00, '5605858817746', 'LUZ.NATAL', (select art_med from art where art_ref='5605858817746'), 0, 0, (select art_med * 16.00 from art where art_ref='5605858817746'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 45, 0, 0.000, '', '5605858817746', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('45',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(25.00, '5600962800349', 'SERIE DE NATAL LED C/150L P/EXTERIOR', (select art_med from art where art_ref='5600962800349'), 0, 0, (select art_med * 25.00 from art where art_ref='5600962800349'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 46, 0, 0.000, '', '5600962800349', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('46',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962800356', 'SERIE DE NATAL', (select art_med from art where art_ref='5600962800356'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962800356'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 47, 0, 0.000, '', '5600962800356', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('47',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(17.00, '5600962800363', 'ERIE NATAL 300L', (select art_med from art where art_ref='5600962800363'), 0, 0, (select art_med * 17.00 from art where art_ref='5600962800363'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 48, 0, 0.000, '', '5600962800363', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('48',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962824079', 'SERIE DE NATAL', (select art_med from art where art_ref='5600962824079'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962824079'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 49, 0, 0.000, '', '5600962824079', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('49',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(14.00, '5600962824062', 'SERIE DE NATAL LED C/500L P/EXTERIOR', (select art_med from art where art_ref='5600962824062'), 0, 0, (select art_med * 14.00 from art where art_ref='5600962824062'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 50, 0, 0.000, '', '5600962824062', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('50',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(25.00, '5600962800325', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800325'), 0, 0, (select art_med * 25.00 from art where art_ref='5600962800325'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 51, 0, 0.000, '', '5600962800325', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('51',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(17.00, '5600962800318', 'SERIE DE NATAL LED C/200L P/EXTERIOR', (select art_med from art where art_ref='5600962800318'), 0, 0, (select art_med * 17.00 from art where art_ref='5600962800318'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 52, 0, 0.000, '', '5600962800318', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('52',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(13.00, '5600962800301', 'SERIE DE NATAL LED C/150L P/EXTERIOR', (select art_med from art where art_ref='5600962800301'), 0, 0, (select art_med * 13.00 from art where art_ref='5600962800301'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 53, 0, 0.000, '', '5600962800301', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('53',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(15.00, '5600962800295', 'SERIE DE NATAL LED C/100L P/EXTERIOR', (select art_med from art where art_ref='5600962800295'), 0, 0, (select art_med * 15.00 from art where art_ref='5600962800295'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 54, 0, 0.000, '', '5600962800295', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('54',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(8.00, '5600962940762', 'SERIE DE NATAL LED C/800L P/EXTERIOR', (select art_med from art where art_ref='5600962940762'), 0, 0, (select art_med * 8.00 from art where art_ref='5600962940762'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 55, 0, 0.000, '', '5600962940762', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('55',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(17.00, '5600962824093', 'SERIE DE NATAL LED C/500L P/EXTERIOR', (select art_med from art where art_ref='5600962824093'), 0, 0, (select art_med * 17.00 from art where art_ref='5600962824093'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 56, 0, 0.000, '', '5600962824093', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('56',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800486', 'SERIE DE NATAL LED C/300L P/EXTERIOR', (select art_med from art where art_ref='5600962800486'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800486'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 57, 0, 0.000, '', '5600962800486', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('57',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(18.00, '5600962800479', 'SERIE NATAL 200L', (select art_med from art where art_ref='5600962800479'), 0, 0, (select art_med * 18.00 from art where art_ref='5600962800479'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 58, 0, 0.000, '', '5600962800479', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('58',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800462', 'SERIE DE NATAL LED C/150L P/EXTERIOR', (select art_med from art where art_ref='5600962800462'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800462'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 59, 0, 0.000, '', '5600962800462', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('59',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(19.00, '5600962800455', 'SERIE DE NATAL LED C/100L P/EXTERIOR', (select art_med from art where art_ref='5600962800455'), 0, 0, (select art_med * 19.00 from art where art_ref='5600962800455'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 60, 0, 0.000, '', '5600962800455', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('60',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962824123', 'SERIE NATAL 500L', (select art_med from art where art_ref='5600962824123'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962824123'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 61, 0, 0.000, '', '5600962824123', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('61',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(8.00, '5600962800783', 'SERIE NATAL', (select art_med from art where art_ref='5600962800783'), 0, 0, (select art_med * 8.00 from art where art_ref='5600962800783'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 62, 0, 0.000, '', '5600962800783', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('62',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962800776', 'SERIE DE NATAL LED C/200L P/INTERIOR', (select art_med from art where art_ref='5600962800776'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962800776'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 63, 0, 0.000, '', '5600962800776', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('63',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962800769', 'SERIE DE NATAL LED C/150L P/INTERIOR', (select art_med from art where art_ref='5600962800769'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962800769'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 64, 0, 0.000, '', '5600962800769', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('64',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962800752', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962800752'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962800752'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 65, 0, 0.000, '', '5600962800752', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('65',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(7.00, '5600962800745', 'SERIE DE NATAL LED C/50L P/INTERIOR', (select art_med from art where art_ref='5600962800745'), 0, 0, (select art_med * 7.00 from art where art_ref='5600962800745'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 66, 0, 0.000, '', '5600962800745', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('66',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(2.00, '8430540534215', '96 LED C/TEMPORIZADOR EXT CALIDA - 8.8MT', (select art_med from art where art_ref='8430540534215'), 0, 0, (select art_med * 2.00 from art where art_ref='8430540534215'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 67, 0, 0.000, '', '8430540534215', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('67',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(4.00, '5600962824154', 'SERIE DE NATAL LED C/500L P/INTERIOR', (select art_med from art where art_ref='5600962824154'), 0, 0, (select art_med * 4.00 from art where art_ref='5600962824154'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 68, 0, 0.000, '', '5600962824154', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('68',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(8.00, '5600962800981', 'SERIE DE NATAL LED C/300L P/INTERIOR', (select art_med from art where art_ref='5600962800981'), 0, 0, (select art_med * 8.00 from art where art_ref='5600962800981'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 69, 0, 0.000, '', '5600962800981', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('69',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962800974', 'SERIE DE NATAL LED C/200L P/INTERIOR', (select art_med from art where art_ref='5600962800974'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962800974'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 70, 0, 0.000, '', '5600962800974', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('70',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(12.00, '5600962800967', 'SERIE DE NATAL LED C/150L P/INTERIOR', (select art_med from art where art_ref='5600962800967'), 0, 0, (select art_med * 12.00 from art where art_ref='5600962800967'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 71, 0, 0.000, '', '5600962800967', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('71',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(11.00, '5600962800950', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962800950'), 0, 0, (select art_med * 11.00 from art where art_ref='5600962800950'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 72, 0, 0.000, '', '5600962800950', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('72',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(5.00, '5600962800950', 'SERIE DE NATAL LED C/100L P/INTERIOR', (select art_med from art where art_ref='5600962800950'), 0, 0, (select art_med * 5.00 from art where art_ref='5600962800950'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 73, 0, 0.000, '', '5600962800950', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('73',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());
INSERT INTO LIN (LIN_QNT,ART_REF,LIN_DCR,LIN_PRC,LIN_DSC,LIN_DSC2,LIN_TOT,LIN_TDC,LIN_NUM,LIN_DAT,LIN_IVA,LIN_UNI,LIN_ENT,LIN_QN2,LIN_ACM,LIN_MOV,LIN_LOJ,LIN_FUN,LIN_TAL,LIN_IMP,ESTADO,LIN_LIN,LIN_TDS,LIN_CST,LIN_STK,LIN_REQ,LIN_INT,LIN_VAL,LIN_DMO,LIN_CHV,LIN_DAD,LIN_CNV,LIN_OUT,LIN_ENC,LIN_ORI,LIN_LOT,lin_siva,lin_civa,lin_mem,lin_mot,lin_viva,stk_tdc,lin_agr,dtalt) VALUES(1.00, '5600962800943', 'SERIE DE NATAL LED C/50L P/INTERIOR', (select art_med from art where art_ref='5600962800943'), 0, 0, (select art_med * 1.00 from art where art_ref='5600962800943'),(select substring('undefined',1,6)), (select str(substring('undefined',7,10))), (select cast(getdate()as date)), 0, 0, 0, 0.000, 'S', '0', 0, 0, '', 0, 9, 74, 0, 0.000, '', '5600962800943', 0, '1900-01-01', (select cast(getdate()as date)), 'undefined'+str('74',6), 'undefined', 0, '', 0, '', 'S/LOTE', 0, 0, '', '', 0, 'N', 0, getdate());

UPDATE DAD SET DAD_MXL=74, DAD_ULT=getdate(), ESTADO=9 WHERE DAD_CHV='undefined'
 commit transaction : Error converting data type varchar to float.