Need help on query with subquery

Question

Need help on query with subquery

luissantos

SSCertifiable

Points: 7391
More actions
March 30, 2009 at 2:56 pm

#207919

Hello comunity
I need to build a query that return in one line per product several information based on my shopping documents, like this
My header table is : FO (is here that i have supplier name, document date)
My Details line table is : FN ( is here i have Design , qtt, unitprice )
my actual script is :
SELECT distinct design,sum(qtt) AS 'QTT',sum(etiliquido) AS 'PCusto',MIN(pmb.epv) AS 'PMB',pmb.nome,
MAX(pmb.epv) AS 'PMC',
SUM(fn.etiliquido)/sum(fn.qtt) AS 'PCP' , SUM(fn.epv) AS 'PRCUnit'
FROM
(select min(nome) AS 'nome', min(epv) AS 'EPV' , fn.fostamp , fn.fnstamp
from fn (NOLOCK)INNER JOIN fo on fn.fostamp=fo.fostamp GROUP BY fn.fostamp , fn.fnstamp ) AS PMB
INNER JOIN fo (nolock) ON pmb.fostamp = fo.fostamp
INNER JOIN fn (NOLOCK) ON pmb.fnstamp=fn.fnstamp
WHERE fo.docdata BETWEEN '20090101' AND '20090131'
AND fn.design LIKE '%banana%'
GROUP BY fn.design,pmb.nome
ORDER BY fn.design ASC
but , in my script i have 2 lines for the same product "DESIGN", because i have two supplier.
But the unitprice for both are OK.
I need this :
These fields are my columns:
Design | QTT | UNITPRICE | total(qtt*unitprice) | CostMoreExpensive supplierName |costLessExpensive | SupplierName
on my line , i want only , like i said , 1 line per DESIGN.
Could someone help me
Many thanks
Luis Santos

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 1

Luis, I will be happy to help you. I just answered a similar question here. Let me know if you understand how it could be applied to your problem.

Could you please post a script to create your two temp tables and put a couple of rows of sample data in them? It would enable me to test the code and give you a solid answer next time. It only takes a moment, and getting into the habit of doing this will win you many friends among the volunteers here.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

luissantos SSCertifiable Points: 7391 More actions · Answer 2

Hello BOB

Thanks for your reply.

I prepare this scripts to recreate tables FO and FN with the data on them .

Note : i have use only one article "DESIGN" that i have 2 suppliers.

Many thanks for your help

Luis Santos

Here come the scripts

TABLE FO :

/* Data for the `FO` table (Records 1 - 8) */

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09012938698,501498841', N'V/Factura', N'194', N'Eurohabil - Comercio de Fruta,lda', N'388632,35218', N'1938,49', '20090127', N'', '20090127', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090313', 0, N'0', N'', N'', N'370125,859', 0, N'18506,49342', N'0', 0, N'370125,85876', 0, 0, 0, 0, 1, 0, 1, N'370125,859', N'0', N'0', N'1846,18', N'92,31', N'0', N'1846,18', N'1846,18', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'18506', N'92,31', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'18506', N'92,31', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'370126', N'1846,18', N'0', N'0', N'0', N'0', N'388632', N'1938,49', N'0', '20090127', N'COMPRAS/FORNECEDORES', 1000540, 27, 0, N'VO09021238432,46001,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27774, N'JP', '20090129', N'10:45:20', N'JP', '20090129', N'10:45:20', 0, 0, N'', 0, N'JP09012938723,923000004', N'', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'194', N'kg', 0, 448, N'290,6989', 5, N'130233,1072', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 4000, 0, N'', '20090127', N'', N'649,6', N'0', N'1,45', 0, N'F01088', N'212', N'290,7', N'1,45', N'130233', N'649,6', N'0', N'0', N'Jg09012622552,777000002', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012938698,501498841', N'JP', '20090129', N'10:45:20', N'JP', '20090129', N'10:45:20', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09012938761,857037188', N'V/Factura', N'207', N'Eurohabil - Comercio de Fruta,lda', N'238242,7847', N'1188,35', '20090128', N'', '20090128', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090314', 0, N'0', N'', N'', N'226897,508', 0, N'11345,27638', N'0', 0, N'226897,50832', 0, 0, 0, 0, 1, 0, 1, N'226897,508', N'0', N'0', N'1131,76', N'56,59', N'0', N'1131,76', N'1131,76', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'11345', N'56,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'11345', N'56,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'226898', N'1131,76', N'0', N'0', N'0', N'0', N'238243', N'1188,35', N'0', '20090128', N'COMPRAS/FORNECEDORES', 1000567, 28, 0, N'VO09021238565,88201,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27775, N'JP', '20090129', N'10:46:17', N'JP', '20090129', N'10:47:11', 0, 0, N'', 0, N'JP09012938841,064000004', N'', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'207', N'kg', 0, 320, N'280,6748', 5, N'89815,936', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 4000, 0, N'', '20090128', N'', N'448', N'0', N'1,4', 0, N'F01088', N'213', N'280,7', N'1,4', N'89816', N'448', N'0', N'0', N'JP09012758492,244000002', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012938761,857037188', N'JP', '20090129', N'10:46:17', N'JP', '20090129', N'10:47:11', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09012264254,466222458', N'V/Nt. Crédito', N'14', N'Eurohabil - Comercio de Fruta,lda', N'351940,13654', N'1755,47', '20090119', N'', '20090119', 2009, 3, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090305', 0, N'0', N'', N'', N'335181,846', 0, N'16758,29038', N'0', 0, N'335181,84616', 0, 0, 0, 0, 1, 0, 1, N'335181,846', N'0', N'0', N'1671,88', N'83,59', N'0', N'1671,88', N'1671,88', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'16759', N'83,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'16759', N'83,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'335182', N'1671,88', N'0', N'0', N'0', N'0', N'351941', N'1755,47', N'0', '20090119', N'OP. DIVERSAS', 1000025, 19, 0, N'VO09020436467,31501,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27635, N'JP', '20090122', N'17:50:58', N'JP', '20090204', N'10:05:31', 0, 0, N'', 0, N'JP09012264299,122000005', N'', N'BANANA CANÁRIAS EXTRA', N'V/Nt. Crédito', N'14', N'kg', 0, 32, N'230,5543', 5, N'7377,7376', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 5000, 0, N'', '20090119', N'', N'36,8', N'0', N'1,15', 0, N'F01088', N'207', N'230,6', N'1,15', N'7378', N'36,8', N'0', N'0', N'JP09011329690,852000002', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012264254,466222458', N'JP', '20090122', N'17:50:58', N'JP', '20090122', N'17:50:58', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09010759542,533940527', N'V/Factura', N'38', N'Eurohabil - Comercio de Fruta,lda', N'514376,6674', N'2565,7', '20090107', N'', '20090107', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090221', 0, N'0', N'', N'', N'489881,777', 0, N'24494,89076', N'0', 0, N'489881,77664', 0, 0, 0, 0, 1, 0, 1, N'489881,777', N'0', N'0', N'2443,52', N'122,18', N'0', N'2443,52', N'2443,52', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'24494', N'122,18', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'24494', N'122,18', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'489882', N'2443,52', N'0', N'0', N'0', N'0', N'514376', N'2565,7', N'0', '20090107', N'COMPRAS/FORNECEDORES', 1000110, 7, 0, N'JM09012241044,24501,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27235, N'JP', '20090107', N'16:33:08', N'JP', '20090107', N'16:33:08', 0, 0, N'', 0, N'JP09010759571,174000003', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'38', N'kg', 0, 260, N'230,6', 5, N'59944,118', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 3000, 0, N'', '20090107', N'', N'299', N'0', N'1,15', 0, N'F01088', N'207', N'230,6', N'1,15', N'59944', N'299', N'0', N'0', N'', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09010759542,533940527', N'JP', '20090107', N'16:33:08', N'JP', '20090107', N'16:33:08', 0, N'', 20, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09011559348,099147095', N'V/Factura', N'106', N'Eurohabil - Comercio de Fruta,lda', N'332152,56314', N'1656,77', '20090115', N'', '20090115', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090301', 0, N'0', N'', N'', N'316336,538', 0, N'15816,02498', N'0', 0, N'316336,53816', 0, 0, 0, 0, 1, 0, 1, N'316336,538', N'0', N'0', N'1577,88', N'78,89', N'0', N'1577,88', N'1577,88', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'15817', N'78,89', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'15817', N'78,89', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'316337', N'1577,88', N'0', N'0', N'0', N'0', N'332154', N'1656,77', N'0', '20090115', N'COMPRAS/FORNECEDORES', 1000297, 15, 0, N'JM09020340532,05201,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27455, N'JP', '20090115', N'16:30:02', N'JP', '20090115', N'16:30:02', 0, 0, N'', 0, N'JP09011559379,568000002', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'106', N'kg', 0, 425, N'216,52056', 5, N'92021,238', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 2000, 0, N'', '20090115', N'', N'459', N'0', N'1,08', 0, N'F01088', N'209', N'216,5', N'1,08', N'92021', N'459', N'0', N'0', N'', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09011559348,099147095', N'JP', '20090115', N'16:30:02', N'JP', '20090115', N'16:30:02', 0, N'', 25, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09011939720,250491436', N'V/Factura', N'95', N'Eurohabil - Comercio de Fruta,lda', N'373985,13726', N'1865,43', '20090114', N'', '20090114', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090228', 0, N'0', N'', N'', N'356176,321', 0, N'17808,81606', N'0', 0, N'356176,3212', 0, 0, 0, 0, 1, 0, 1, N'356176,321', N'0', N'0', N'1776,6', N'88,83', N'0', N'1776,6', N'1776,6', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'17809', N'88,83', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'17809', N'88,83', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'356176', N'1776,6', N'0', N'0', N'0', N'0', N'373985', N'1865,43', N'0', '20090114', N'COMPRAS/FORNECEDORES', 1000288, 14, 0, N'JM09020340510,55201,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27535, N'JP', '20090119', N'11:07:54', N'JP', '20090119', N'11:07:54', 0, 0, N'', 0, N'JP09011940066,297000004', N'', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'95', N'kg', 0, 720, N'216,52056', 5, N'155894,8032', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 4000, 0, N'', '20090114', N'', N'777,6', N'0', N'1,08', 0, N'F01088', N'208', N'216,5', N'1,08', N'155895', N'777,6', N'0', N'0', N'JP09011329374,055000002', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09011939720,250491436', N'JP', '20090119', N'11:07:54', N'JP', '20090119', N'11:07:54', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'JP09012362845,269498395', N'V/Factura', N'166', N'Eurohabil - Comercio de Fruta,lda', N'153791,74702', N'767,11', '20090123', N'', '20090123', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090309', 0, N'0', N'', N'', N'146468,14', 0, N'7323,60746', N'0', 0, N'146468,13956', 0, 0, 0, 0, 1, 0, 1, N'146468,14', N'0', N'0', N'730,58', N'36,53', N'0', N'730,58', N'730,58', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'7323', N'36,53', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'7323', N'36,53', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'146468', N'730,58', N'0', N'0', N'0', N'0', N'153791', N'767,11', N'0', '20090123', N'COMPRAS/FORNECEDORES', 1000465, 23, 0, N'VO09021238101,85001,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27669, N'JP', '20090123', N'17:27:29', N'JP', '20090123', N'17:27:29', 0, 0, N'', 0, N'JP09012362884,941000002', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'166', N'kg', 0, 160, N'290,6989', 5, N'46511,824', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 2000, 0, N'', '20090123', N'', N'232', N'0', N'1,45', 0, N'F01088', N'211', N'290,7', N'1,45', N'46512', N'232', N'0', N'0', N'', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012362845,269498395', N'JP', '20090123', N'17:27:29', N'JP', '20090123', N'17:27:29', 0, N'', 10, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

INSERT INTO [FO] ([fostamp], [docnome], [adoc], [nome], [total], [etotal], [data], [tipo], [docdata], [foano], [doccode], [no], [fref], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres], [valacres], [zona], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series], [series2], [despinc], [edespinc], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen], [processo], [subproc], [multi], [crend], [foid], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [introvalacres], [czonag], [sujirsisen], [fnstamp], [ref], [design], [docnome_1], [adoc_1], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres_1], [valacres_1], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref_1], [data_1], [fnfref], [etiliquido], [evalacres_1], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series_1], [series2_1], [despa], [despinc_1], [edespinc_1], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen_1], [peso], [pbruto], [codfiscal], [itstamp], [fostamp_1], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona_1], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem])

VALUES (N'CG09012844657,534538566', N'V/Factura', N'9140062059', N'Hermanos Fernandez Lopez, S.A.', N'1508388,47642', N'7523,81', '20090128', N'', '20090128', 2009, 55, 501, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090128', 0, N'0', N'', N'', N'1494531,161', 0, N'13857,31584', N'0', 0, N'1494531,16058', 0, 0, 0, 0, 1, 0, 2, N'1494531,161', N'0', N'0', N'7454,69', N'69,12', N'0', N'7454,69', N'7454,69', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'13857', N'69,12', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'Nave B Ptos 51-53-55-57', N'Mercamadrid', N'28053 Madrid', N'A-08620056', N'', N'', '19000101', 0, N'', N'', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'13857', N'69,12', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'1494531', N'7454,69', N'0', N'0', N'0', N'0', N'1508388', N'7523,81', N'0', '20090128', N'COMPRAS/FORNECEDORES', 1000639, 28, 0, N'VO09021841119,36401,E+6', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27753, N'CG', '20090128', N'12:30:47', N'JM', '20090219', N'11:27:35', 0, 0, N'', 0, N'CG09012845838,395000011', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'9140062059', N'kg', 0, 765, N'280,6748', 0, N'214716,222', N'0', N'0', 0, 1, 0, N'0', 1, 1, 0, 0, N'', 70000, 0, N'', '20090128', N'', N'1071', N'0', N'1,4', 0, N'F01088', N'214', N'280,7', N'1,4', N'214716', N'1071', N'0', N'0', N'', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'CG09012844657,534538566', N'CG', '20090128', N'12:30:47', N'CG', '20090128', N'12:54:14', 0, N'', 45, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'')

GO

TABLE FN :

/* Data for the `FN` table (Records 1 - 8) */

INSERT INTO [FN] ([fnstamp], [ref], [design], [docnome], [adoc], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09012938723,923000004', N'', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'194', N'kg', 0, 448, N'290,6989', 5, N'130233,1072', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 4000, 0, N'', '20090127', N'', N'649,6', N'0', N'1,45', 0, N'F01088', N'212', N'290,7', N'1,45', N'130233', N'649,6', N'0', N'0', N'Jg09012622552,777000002', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012938698,501498841', N'JP', '20090129', N'10:45:20', N'JP', '20090129', N'10:45:20', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09012938698,501498841', N'V/Factura', N'194', N'Eurohabil - Comercio de Fruta,lda', N'388632,35218', N'1938,49', '20090127', N'', '20090127', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090313', 0, N'0', N'', N'', N'370125,859', 0, N'18506,49342', N'0', 0, N'370125,85876', 0, 0, 0, 0, 1, 0, 1, N'370125,859', N'0', N'0', N'1846,18', N'92,31', N'0', N'1846,18', N'1846,18', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'18506', N'92,31', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'18506', N'92,31', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'370126', N'1846,18', N'0', N'0', N'0', N'0', N'388632', N'1938,49', N'0', '20090127', N'COMPRAS/FORNECEDORES', 1000540, 27, 0, N'VO09021238432,46001,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27774, N'JP', '20090129', N'10:45:20', N'JP', '20090129', N'10:45:20', 0, 0, N'', 0)

GO

INSERT INTO [FN], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09012938841,064000004', N'', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'207', N'kg', 0, 320, N'280,6748', 5, N'89815,936', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 4000, 0, N'', '20090128', N'', N'448', N'0', N'1,4', 0, N'F01088', N'213', N'280,7', N'1,4', N'89816', N'448', N'0', N'0', N'JP09012758492,244000002', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012938761,857037188', N'JP', '20090129', N'10:46:17', N'JP', '20090129', N'10:47:11', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09012938761,857037188', N'V/Factura', N'207', N'Eurohabil - Comercio de Fruta,lda', N'238242,7847', N'1188,35', '20090128', N'', '20090128', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090314', 0, N'0', N'', N'', N'226897,508', 0, N'11345,27638', N'0', 0, N'226897,50832', 0, 0, 0, 0, 1, 0, 1, N'226897,508', N'0', N'0', N'1131,76', N'56,59', N'0', N'1131,76', N'1131,76', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'11345', N'56,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'11345', N'56,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'226898', N'1131,76', N'0', N'0', N'0', N'0', N'238243', N'1188,35', N'0', '20090128', N'COMPRAS/FORNECEDORES', 1000567, 28, 0, N'VO09021238565,88201,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27775, N'JP', '20090129', N'10:46:17', N'JP', '20090129', N'10:47:11', 0, 0, N'', 0)

GO

INSERT INTO [FN] ([fnstamp], [ref], [design], [docnome], [adoc], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09012264299,122000005', N'', N'BANANA CANÁRIAS EXTRA', N'V/Nt. Crédito', N'14', N'kg', 0, 32, N'230,5543', 5, N'7377,7376', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 5000, 0, N'', '20090119', N'', N'36,8', N'0', N'1,15', 0, N'F01088', N'207', N'230,6', N'1,15', N'7378', N'36,8', N'0', N'0', N'JP09011329690,852000002', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012264254,466222458', N'JP', '20090122', N'17:50:58', N'JP', '20090122', N'17:50:58', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09012264254,466222458', N'V/Nt. Crédito', N'14', N'Eurohabil - Comercio de Fruta,lda', N'351940,13654', N'1755,47', '20090119', N'', '20090119', 2009, 3, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090305', 0, N'0', N'', N'', N'335181,846', 0, N'16758,29038', N'0', 0, N'335181,84616', 0, 0, 0, 0, 1, 0, 1, N'335181,846', N'0', N'0', N'1671,88', N'83,59', N'0', N'1671,88', N'1671,88', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'16759', N'83,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'16759', N'83,59', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'335182', N'1671,88', N'0', N'0', N'0', N'0', N'351941', N'1755,47', N'0', '20090119', N'OP. DIVERSAS', 1000025, 19, 0, N'VO09020436467,31501,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27635, N'JP', '20090122', N'17:50:58', N'JP', '20090204', N'10:05:31', 0, 0, N'', 0)

GO

INSERT INTO [FN] ([fnstamp], [ref], [design], [docnome], [adoc], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09010759571,174000003', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'38', N'kg', 0, 260, N'230,6', 5, N'59944,118', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 3000, 0, N'', '20090107', N'', N'299', N'0', N'1,15', 0, N'F01088', N'207', N'230,6', N'1,15', N'59944', N'299', N'0', N'0', N'', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09010759542,533940527', N'JP', '20090107', N'16:33:08', N'JP', '20090107', N'16:33:08', 0, N'', 20, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09010759542,533940527', N'V/Factura', N'38', N'Eurohabil - Comercio de Fruta,lda', N'514376,6674', N'2565,7', '20090107', N'', '20090107', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090221', 0, N'0', N'', N'', N'489881,777', 0, N'24494,89076', N'0', 0, N'489881,77664', 0, 0, 0, 0, 1, 0, 1, N'489881,777', N'0', N'0', N'2443,52', N'122,18', N'0', N'2443,52', N'2443,52', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'24494', N'122,18', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'24494', N'122,18', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'489882', N'2443,52', N'0', N'0', N'0', N'0', N'514376', N'2565,7', N'0', '20090107', N'COMPRAS/FORNECEDORES', 1000110, 7, 0, N'JM09012241044,24501,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27235, N'JP', '20090107', N'16:33:08', N'JP', '20090107', N'16:33:08', 0, 0, N'', 0)

GO

INSERT INTO [FN] ([fnstamp], [ref], [design], [docnome], [adoc], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09011559379,568000002', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'106', N'kg', 0, 425, N'216,52056', 5, N'92021,238', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 2000, 0, N'', '20090115', N'', N'459', N'0', N'1,08', 0, N'F01088', N'209', N'216,5', N'1,08', N'92021', N'459', N'0', N'0', N'', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09011559348,099147095', N'JP', '20090115', N'16:30:02', N'JP', '20090115', N'16:30:02', 0, N'', 25, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09011559348,099147095', N'V/Factura', N'106', N'Eurohabil - Comercio de Fruta,lda', N'332152,56314', N'1656,77', '20090115', N'', '20090115', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090301', 0, N'0', N'', N'', N'316336,538', 0, N'15816,02498', N'0', 0, N'316336,53816', 0, 0, 0, 0, 1, 0, 1, N'316336,538', N'0', N'0', N'1577,88', N'78,89', N'0', N'1577,88', N'1577,88', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'15817', N'78,89', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'15817', N'78,89', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'316337', N'1577,88', N'0', N'0', N'0', N'0', N'332154', N'1656,77', N'0', '20090115', N'COMPRAS/FORNECEDORES', 1000297, 15, 0, N'JM09020340532,05201,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27455, N'JP', '20090115', N'16:30:02', N'JP', '20090115', N'16:30:02', 0, 0, N'', 0)

GO

INSERT INTO [FN] ([fnstamp], [ref], [design], [docnome], [adoc], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09011940066,297000004', N'', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'95', N'kg', 0, 720, N'216,52056', 5, N'155894,8032', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 4000, 0, N'', '20090114', N'', N'777,6', N'0', N'1,08', 0, N'F01088', N'208', N'216,5', N'1,08', N'155895', N'777,6', N'0', N'0', N'JP09011329374,055000002', 0, N'ARMAZEM', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'LBANANACANEXTRA', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09011939720,250491436', N'JP', '20090119', N'11:07:54', N'JP', '20090119', N'11:07:54', 0, N'', 0, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09011939720,250491436', N'V/Factura', N'95', N'Eurohabil - Comercio de Fruta,lda', N'373985,13726', N'1865,43', '20090114', N'', '20090114', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090228', 0, N'0', N'', N'', N'356176,321', 0, N'17808,81606', N'0', 0, N'356176,3212', 0, 0, 0, 0, 1, 0, 1, N'356176,321', N'0', N'0', N'1776,6', N'88,83', N'0', N'1776,6', N'1776,6', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'17809', N'88,83', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'17809', N'88,83', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'356176', N'1776,6', N'0', N'0', N'0', N'0', N'373985', N'1865,43', N'0', '20090114', N'COMPRAS/FORNECEDORES', 1000288, 14, 0, N'JM09020340510,55201,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27535, N'JP', '20090119', N'11:07:54', N'JP', '20090119', N'11:07:54', 0, 0, N'', 0)

GO

INSERT INTO [FN] ([fnstamp], [ref], [design], [docnome], [adoc], [unidade], [taxaiva], [qtt], [pv], [iva], [tiliquido], [tmoeda], [pvmoeda], [ivaincl], [tabiva], [pctacres], [valacres], [armazem], [cpoc], [composto], [compostoori], [lrecno], [lordem], [fmarcada], [fref], [data], [fnfref], [etiliquido], [evalacres], [epv], [uni2qtt], [codigo], [lote], [slvu], [eslvu], [sltt], [esltt], [slvumoeda], [slttmoeda], [bistamp], [stns], [fnccusto], [fnncusto], [usr1], [usr2], [usr3], [usr4], [usr5], [usr6], [beref], [usalote], [texteis], [uni2], [cor], [tam], [familia], [oref], [noserie], [ncmassa], [ncunsup], [ncvest], [encvest], [nccod], [ncinteg], [series], [series2], [despa], [despinc], [edespinc], [dfostamp], [desconto], [desc2], [desc3], [desc4], [desc5], [desc6], [rpflstamp], [fnrpfl], [num1], [sujirs], [ltab1], [ltab2], [ltab3], [ltab4], [ltab5], [forref], [tieca], [etieca], [mtieca], [volume], [iecasug], [iecagrad], [iecacodisen], [peso], [pbruto], [codfiscal], [itstamp], [fostamp], [ousrinis], [ousrdata], [ousrhora], [usrinis], [usrdata], [usrhora], [marcada], [ofnstamp], [u_caixas], [u_forlote], [alvstamp], [identificacao], [szzstamp], [zona], [qttenc], [qttrcb], [oobranome], [oobrano], [oboano], [obistamp], [onmdos], [nocf], [nocfobs], [u_cat], [u_origem], [fostamp_1], [docnome_1], [adoc_1], [nome], [total], [etotal], [data_1], [tipo], [docdata], [foano], [doccode], [no], [fref_1], [ccusto], [ncusto], [moeda], [totmoeda], [pdata], [pctacres_1], [valacres_1], [zona_1], [encomenda], [ivain], [ivatx], [ttiva], [finv], [fin], [ttiliq], [ivamin], [tmiva], [finmv], [tmiliq], [plano], [estab], [pais], [ivainsns], [descc], [descm], [eivain], [ettiva], [efinv], [ettiliq], [eivainsns], [edescc], [evalacres_1], [introfin], [final], [cambiofixo], [memissao], [ivav1], [eivav1], [ivamv1], [ivav2], [eivav2], [ivamv2], [ivav3], [eivav3], [ivamv3], [ivav4], [eivav4], [ivamv4], [ivav5], [eivav5], [ivamv5], [ivav6], [eivav6], [ivamv6], [ivav7], [eivav7], [ivamv7], [ivav8], [eivav8], [ivamv8], [ivav9], [eivav9], [ivamv9], [morada], [local], [codpost], [ncont], [nmaprov], [nmemail], [dtaprov], [aprovado], [intid], [nome2], [tpstamp], [tpdesc], [erdtotal], [rdtotal], [rdtotalm], [aivav1], [eaivav1], [aivamv1], [paivav1], [epaivav1], [paivamv1], [aivav2], [eaivav2], [aivamv2], [paivav2], [epaivav2], [paivamv2], [aivav3], [eaivav3], [aivamv3], [paivav3], [epaivav3], [paivamv3], [aivav4], [eaivav4], [aivamv4], [paivav4], [epaivav4], [paivamv4], [aivav5], [eaivav5], [aivamv5], [paivav5], [epaivav5], [paivamv5], [aivav6], [eaivav6], [aivamv6], [paivav6], [epaivav6], [paivamv6], [aivav7], [eaivav7], [aivamv7], [paivav7], [epaivav7], [paivamv7], [aivav8], [eaivav8], [aivamv8], [paivav8], [epaivav8], [paivamv8], [aivav9], [eaivav9], [aivamv9], [paivav9], [epaivav9], [paivamv9], [aivain], [eaivain], [aivamin], [paivain], [epaivain], [paivamin], [atotal], [eatotal], [atotmoeda], [patotal], [epatotal], [patotmoeda], [dplano], [dinoplano], [dilnoplano], [diaplano], [planoonline], [dostamp], [pscm], [zncm], [excm], [ptcm], [encm], [ntcm], [pscmdesc], [znregiao], [excmdesc], [ptcmdesc], [encmdesc], [ncin], [ncout], [usaintra], [series_1], [series2_1], [despinc_1], [edespinc_1], [eprocesso], [dprocesso], [cambio], [ollocal], [telocal], [contado], [site], [pnome], [pno], [cxstamp], [cxusername], [ssstamp], [ssusername], [classe], [virs], [evirs], [txirs], [lang], [moeda2], [valorm2], [arstamp], [arno], [eanfl], [ettieca], [ttieca], [mttieca], [iectisento], [iecacodisen_1], [processo], [subproc], [multi], [crend], [foid], [ousrinis_1], [ousrdata_1], [ousrhora_1], [usrinis_1], [usrdata_1], [usrhora_1], [marcada_1], [introvalacres], [czonag], [sujirsisen])

VALUES (N'JP09012362884,941000002', N'LBANANACANEXTRA', N'BANANA CANÁRIAS EXTRA', N'V/Factura', N'166', N'kg', 0, 160, N'290,6989', 5, N'46511,824', N'0', N'0', 0, 2, 0, N'0', 1, 1, 0, 0, N'', 2000, 0, N'', '20090123', N'', N'232', N'0', N'1,45', 0, N'F01088', N'211', N'290,7', N'1,45', N'46512', N'232', N'0', N'0', N'', 0, N'', N'', N'EXTRA', N'II', N'CANARIAS', N'', N'', N'', N'', 1, 0, N'kg', N'', N'', N'frutas', N'', 0, N'0', 0, N'0', N'0', N'', N'', N'', N'', 0, N'0', N'0', N'', 0, 0, 0, 0, 0, 0, N'', N'', N'0', 0, N'', N'', N'', N'', N'', N'', N'0', N'0', 0, 0, 0, 0, N'', 0, 0, N'', N'', N'JP09012362845,269498395', N'JP', '20090123', N'17:27:29', N'JP', '20090123', N'17:27:29', 0, N'', 10, N'', N'', N'', N'', N'', 0, 0, N'', 0, 0, N'', N'', 0, N'', N'', N'', N'JP09012362845,269498395', N'V/Factura', N'166', N'Eurohabil - Comercio de Fruta,lda', N'153791,74702', N'767,11', '20090123', N'', '20090123', 2009, 55, 301, N'', N'ARMAZEM', N'', N'PTE ou EURO', N'0', '20090309', 0, N'0', N'', N'', N'146468,14', 0, N'7323,60746', N'0', 0, N'146468,13956', 0, 0, 0, 0, 1, 0, 1, N'146468,14', N'0', N'0', N'730,58', N'36,53', N'0', N'730,58', N'730,58', N'0', N'0', 0, N'', 0, N'EURO', N'0', N'0', N'0', N'7323', N'36,53', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'ZONA EMPREASARIAL DA MAIA ,363 arm, 26', N'MOREIRA', N'4470-606 MAIA', N'507898346', N'', N'', '19000101', 0, N'', N'AGL', N'', N'', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'7323', N'36,53', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'146468', N'730,58', N'0', N'0', N'0', N'0', N'153791', N'767,11', N'0', '20090123', N'COMPRAS/FORNECEDORES', 1000465, 23, 0, N'VO09021238101,85001,E+7', N'', 0, 0, N'', N'', 0, N'', N'', N'', N'', N'', 0, 0, 0, N'', N'', N'0', N'0', 0, N'', N'0', N'Caixa', N'C', 0, N'', N'', 0, N'', N'', N'', N'', N'', N'0', N'0', 0, N'', N'PTE ou EURO', N'0', N'', 0, N'', N'0', N'0', N'0', 0, N'', N'', N'', 0, N'', 27669, N'JP', '20090123', N'17:27:29', N'JP', '20090123', N'17:27:29', 0, 0, N'', 0)

GO

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Beautiful 🙂

While I'm looking at this, have you checked out the link I pointed you to in the first message? I expect to use the same CROSS APPLY technique on your issue.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 4

Luis, can you also send the CREATE TABLE statements for FN and FO??

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

luissantos SSCertifiable Points: 7391 More actions · Answer 5

Hello Bob

Sorry, i forget to send the script to create the table FO and FN, now i will send to you the scirp

Many thanks

Luis Santos

TABLE FO

CREATE TABLE [dbo].[fo] (

[fostamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL UNIQUE,

[docnome] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[adoc] varchar(20) COLLATE Latin1_General_CI_AS CONSTRAINT [DF__FO__ADOC__reconstruido] DEFAULT '' NOT NULL,

[nome] char(55) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[total] numeric(18, 5) DEFAULT 0 NOT NULL,

[etotal] numeric(19, 6) DEFAULT 0 NOT NULL,

[data] datetime DEFAULT convert(datetime,'19000101') NOT NULL,

[tipo] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[docdata] datetime DEFAULT convert(datetime,'19000101') NOT NULL,

[foano] numeric(4, 0) DEFAULT 0 NOT NULL,

[doccode] numeric(6, 0) DEFAULT 0 NOT NULL,

[no] numeric(10, 0) DEFAULT 0 NOT NULL,

[fref] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ccusto] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ncusto] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[moeda] varchar(11) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[totmoeda] numeric(15, 2) DEFAULT 0 NOT NULL,

[pdata] datetime DEFAULT convert(datetime,'19000101') NOT NULL,

[pctacres] numeric(7, 3) DEFAULT 0 NOT NULL,

[valacres] numeric(18, 5) DEFAULT 0 NOT NULL,

[zona] varchar(13) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[encomenda] varchar(15) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ivain] numeric(16, 3) DEFAULT 0 NOT NULL,

[ivatx] numeric(5, 2) DEFAULT 0 NOT NULL,

[ttiva] numeric(18, 5) DEFAULT 0 NOT NULL,

[finv] numeric(18, 5) DEFAULT 0 NOT NULL,

[fin] numeric(5, 2) DEFAULT 0 NOT NULL,

[ttiliq] numeric(18, 5) DEFAULT 0 NOT NULL,

[ivamin] numeric(12, 2) DEFAULT 0 NOT NULL,

[tmiva] numeric(12, 2) DEFAULT 0 NOT NULL,

[finmv] numeric(12, 2) DEFAULT 0 NOT NULL,

[tmiliq] numeric(12, 2) DEFAULT 0 NOT NULL,

[plano] bit DEFAULT 0 NOT NULL,

[estab] numeric(3, 0) DEFAULT 0 NOT NULL,

[pais] numeric(1, 0) DEFAULT 0 NOT NULL,

[ivainsns] numeric(16, 3) DEFAULT 0 NOT NULL,

[descc] numeric(18, 5) DEFAULT 0 NOT NULL,

[descm] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivain] numeric(19, 6) DEFAULT 0 NOT NULL,

[ettiva] numeric(19, 6) DEFAULT 0 NOT NULL,

[efinv] numeric(19, 6) DEFAULT 0 NOT NULL,

[ettiliq] numeric(19, 6) DEFAULT 0 NOT NULL,

[eivainsns] numeric(19, 6) DEFAULT 0 NOT NULL,

[edescc] numeric(19, 6) DEFAULT 0 NOT NULL,

[evalacres] numeric(19, 6) DEFAULT 0 NOT NULL,

[introfin] bit DEFAULT 0 NOT NULL,

[final] varchar(100) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[cambiofixo] bit DEFAULT 0 NOT NULL,

[memissao] varchar(4) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ivav1] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav1] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv1] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav2] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav2] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv2] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav3] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav3] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv3] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav4] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav4] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv4] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav5] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav5] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv5] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav6] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav6] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv6] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav7] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav7] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv7] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav8] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav8] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv8] numeric(19, 2) DEFAULT 0 NOT NULL,

[ivav9] numeric(18, 5) DEFAULT 0 NOT NULL,

[eivav9] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivamv9] numeric(19, 2) DEFAULT 0 NOT NULL,

[morada] varchar(55) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[local] varchar(43) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[codpost] varchar(45) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ncont] varchar(18) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[nmaprov] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[nmemail] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[dtaprov] datetime DEFAULT convert(datetime,'19000101') NOT NULL,

[aprovado] bit DEFAULT 0 NOT NULL,

[intid] varchar(10) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[nome2] varchar(55) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[tpstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[tpdesc] varchar(55) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[erdtotal] numeric(19, 6) DEFAULT 0 NOT NULL,

[rdtotal] numeric(18, 5) DEFAULT 0 NOT NULL,

[rdtotalm] numeric(15, 3) DEFAULT 0 NOT NULL,

[aivav1] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav1] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv1] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav1] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav1] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv1] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav2] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav2] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv2] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav2] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav2] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv2] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav3] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav3] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv3] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav3] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav3] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv3] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav4] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav4] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv4] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav4] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav4] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv4] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav5] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav5] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv5] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav5] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav5] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv5] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav6] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav6] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv6] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav6] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav6] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv6] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav7] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav7] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv7] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav7] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav7] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv7] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav8] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav8] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv8] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav8] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav8] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv8] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivav9] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivav9] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamv9] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivav9] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivav9] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamv9] numeric(19, 2) DEFAULT 0 NOT NULL,

[aivain] numeric(18, 5) DEFAULT 0 NOT NULL,

[eaivain] numeric(19, 6) DEFAULT 0 NOT NULL,

[aivamin] numeric(19, 2) DEFAULT 0 NOT NULL,

[paivain] numeric(18, 5) DEFAULT 0 NOT NULL,

[epaivain] numeric(19, 6) DEFAULT 0 NOT NULL,

[paivamin] numeric(19, 2) DEFAULT 0 NOT NULL,

[atotal] numeric(18, 5) DEFAULT 0 NOT NULL,

[eatotal] numeric(19, 6) DEFAULT 0 NOT NULL,

[atotmoeda] numeric(19, 2) DEFAULT 0 NOT NULL,

[patotal] numeric(18, 5) DEFAULT 0 NOT NULL,

[epatotal] numeric(19, 6) DEFAULT 0 NOT NULL,

[patotmoeda] numeric(19, 2) DEFAULT 0 NOT NULL,

[dplano] datetime DEFAULT convert(datetime,'19000101') NOT NULL,

[dinoplano] varchar(40) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[dilnoplano] numeric(10, 0) DEFAULT 0 NOT NULL,

[diaplano] numeric(2, 0) DEFAULT 0 NOT NULL,

[planoonline] bit DEFAULT 0 NOT NULL,

[dostamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[pscm] varchar(2) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[zncm] numeric(2, 0) DEFAULT 0 NOT NULL,

[excm] numeric(2, 0) DEFAULT 0 NOT NULL,

[ptcm] varchar(3) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[encm] varchar(3) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ntcm] numeric(2, 0) DEFAULT 0 NOT NULL,

[pscmdesc] varchar(70) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[znregiao] varchar(70) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[excmdesc] varchar(70) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ptcmdesc] varchar(70) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[encmdesc] varchar(70) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ncin] bit DEFAULT 0 NOT NULL,

[ncout] bit DEFAULT 0 NOT NULL,

[usaintra] bit DEFAULT 0 NOT NULL,

[series] text COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[series2] text COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[despinc] numeric(18, 5) DEFAULT 0 NOT NULL,

[edespinc] numeric(19, 6) DEFAULT 0 NOT NULL,

[eprocesso] bit DEFAULT 0 NOT NULL,

[dprocesso] varchar(100) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[cambio] numeric(20, 10) CONSTRAINT [DF__FO__CAMBIO__reconstruido] DEFAULT 0 NOT NULL,

[ollocal] varchar(50) COLLATE Latin1_General_CI_AS DEFAULT 'Caixa' NOT NULL,

[telocal] varchar(1) COLLATE Latin1_General_CI_AS DEFAULT 'C' NOT NULL,

[contado] numeric(4, 0) DEFAULT 0 NOT NULL,

[site] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[pnome] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[pno] numeric(3, 0) DEFAULT 0 NOT NULL,

[cxstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[cxusername] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ssstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ssusername] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[classe] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[virs] numeric(18, 5) DEFAULT 0 NOT NULL,

[evirs] numeric(19, 6) DEFAULT 0 NOT NULL,

[txirs] numeric(5, 2) DEFAULT 0 NOT NULL,

[lang] char(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[moeda2] varchar(11) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[valorm2] numeric(15, 2) DEFAULT 0 NOT NULL,

[arstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[arno] numeric(10, 0) DEFAULT 0 NOT NULL,

[eanfl] varchar(35) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ettieca] numeric(19, 6) DEFAULT 0 NOT NULL,

[ttieca] numeric(18, 5) DEFAULT 0 NOT NULL,

[mttieca] numeric(19, 6) DEFAULT 0 NOT NULL,

[iectisento] bit DEFAULT 0 NOT NULL,

[iecacodisen] varchar(4) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[processo] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[subproc] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[multi] bit DEFAULT 0 NOT NULL,

[crend] varchar(1) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[foid] numeric(12, 0) IDENTITY(1, 1) NOT NULL,

[ousrinis] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ousrdata] datetime DEFAULT getdate() NOT NULL,

[ousrhora] varchar(8) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usrinis] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usrdata] datetime DEFAULT getdate() NOT NULL,

[usrhora] varchar(8) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[marcada] bit DEFAULT 0 NOT NULL,

[introvalacres] bit DEFAULT 0 NOT NULL,

[czonag] varchar(1) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[sujirsisen] bit DEFAULT 0 NOT NULL

)

GO

TABLE FN

CREATE TABLE [dbo].[fn] (

[fnstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL PRIMARY KEY,

[ref] char(18) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[design] varchar(60) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[docnome] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[adoc] varchar(20) COLLATE Latin1_General_CI_AS CONSTRAINT [DF__FN__ADOC__reconstruido] DEFAULT '' NOT NULL,

[unidade] varchar(4) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[taxaiva] numeric(5, 2) DEFAULT 0 NOT NULL,

[qtt] numeric(12, 3) DEFAULT 0 NOT NULL,

[pv] numeric(18, 5) DEFAULT 0 NOT NULL,

[iva] numeric(5, 2) DEFAULT 0 NOT NULL,

[tiliquido] numeric(18, 5) DEFAULT 0 NOT NULL,

[tmoeda] numeric(15, 2) DEFAULT 0 NOT NULL,

[pvmoeda] numeric(19, 6) DEFAULT 0 NOT NULL,

[ivaincl] bit DEFAULT 0 NOT NULL,

[tabiva] numeric(1, 0) DEFAULT 0 NOT NULL,

[pctacres] numeric(11, 2) DEFAULT 0 NOT NULL,

[valacres] numeric(18, 5) DEFAULT 0 NOT NULL,

[armazem] numeric(5, 0) DEFAULT 0 NOT NULL,

[cpoc] numeric(6, 0) DEFAULT 0 NOT NULL,

[composto] bit DEFAULT 0 NOT NULL,

[compostoori] bit DEFAULT 0 NOT NULL,

[lrecno] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[lordem] numeric(10, 0) DEFAULT 0 NOT NULL,

[fmarcada] bit DEFAULT 0 NOT NULL,

[fref] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[data] datetime DEFAULT convert(datetime,'19000101') NOT NULL,

[fnfref] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[etiliquido] numeric(19, 6) DEFAULT 0 NOT NULL,

[evalacres] numeric(19, 6) DEFAULT 0 NOT NULL,

[epv] numeric(19, 6) DEFAULT 0 NOT NULL,

[uni2qtt] numeric(12, 3) DEFAULT 0 NOT NULL,

[codigo] char(18) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[lote] varchar(15) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[slvu] numeric(18, 5) DEFAULT 0 NOT NULL,

[eslvu] numeric(19, 6) DEFAULT 0 NOT NULL,

[sltt] numeric(18, 5) DEFAULT 0 NOT NULL,

[esltt] numeric(19, 6) DEFAULT 0 NOT NULL,

[slvumoeda] numeric(15, 2) DEFAULT 0 NOT NULL,

[slttmoeda] numeric(15, 2) DEFAULT 0 NOT NULL,

[bistamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[stns] bit DEFAULT 0 NOT NULL,

[fnccusto] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[fnncusto] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usr1] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usr2] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usr3] varchar(35) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usr4] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usr5] varchar(120) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usr6] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[beref] varchar(18) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usalote] bit DEFAULT 0 NOT NULL,

[texteis] bit DEFAULT 0 NOT NULL,

[uni2] varchar(4) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[cor] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[tam] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[familia] varchar(18) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[oref] varchar(18) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[noserie] bit DEFAULT 0 NOT NULL,

[ncmassa] numeric(16, 3) DEFAULT 0 NOT NULL,

[ncunsup] numeric(14, 4) DEFAULT 0 NOT NULL,

[ncvest] numeric(18, 5) DEFAULT 0 NOT NULL,

[encvest] numeric(19, 6) DEFAULT 0 NOT NULL,

[nccod] varchar(8) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ncinteg] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[series] text COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[series2] text COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[despa] bit DEFAULT 0 NOT NULL,

[despinc] numeric(18, 5) DEFAULT 0 NOT NULL,

[edespinc] numeric(19, 6) DEFAULT 0 NOT NULL,

[dfostamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[desconto] numeric(5, 2) DEFAULT 0 NOT NULL,

[desc2] numeric(5, 2) DEFAULT 0 NOT NULL,

[desc3] numeric(5, 2) DEFAULT 0 NOT NULL,

[desc4] numeric(5, 2) DEFAULT 0 NOT NULL,

[desc5] numeric(5, 2) DEFAULT 0 NOT NULL,

[desc6] numeric(5, 2) DEFAULT 0 NOT NULL,

[rpflstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[fnrpfl] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[num1] numeric(19, 5) DEFAULT 0 NOT NULL,

[sujirs] bit DEFAULT 0 NOT NULL,

[ltab1] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ltab2] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ltab3] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ltab4] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ltab5] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[forref] char(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[tieca] numeric(18, 5) DEFAULT 0 NOT NULL,

[etieca] numeric(19, 6) DEFAULT 0 NOT NULL,

[mtieca] numeric(13, 3) DEFAULT 0 NOT NULL,

[volume] numeric(11, 3) DEFAULT 0 NOT NULL,

[iecasug] bit DEFAULT 0 NOT NULL,

[iecagrad] numeric(7, 3) DEFAULT 0 NOT NULL,

[iecacodisen] varchar(4) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[peso] numeric(14, 3) DEFAULT 0 NOT NULL,

[pbruto] numeric(14, 3) DEFAULT 0 NOT NULL,

[codfiscal] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[itstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[fostamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ousrinis] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[ousrdata] datetime DEFAULT getdate() NOT NULL,

[ousrhora] varchar(8) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usrinis] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[usrdata] datetime DEFAULT getdate() NOT NULL,

[usrhora] varchar(8) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[marcada] bit DEFAULT 0 NOT NULL,

[ofnstamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[u_caixas] numeric(4, 0) DEFAULT 0 NOT NULL,

[u_forlote] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[alvstamp] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[identificacao] varchar(55) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[szzstamp] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[zona] varchar(30) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[qttenc] numeric(14, 4) DEFAULT 0 NOT NULL,

[qttrcb] numeric(14, 4) DEFAULT 0 NOT NULL,

[oobranome] varchar(20) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[oobrano] numeric(10, 0) DEFAULT 0 NOT NULL,

[oboano] numeric(4, 0) DEFAULT 0 NOT NULL,

[obistamp] char(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[onmdos] varchar(24) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[nocf] bit DEFAULT 0 NOT NULL,

[nocfobs] text COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[u_cat] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL,

[u_origem] varchar(25) COLLATE Latin1_General_CI_AS DEFAULT '' NOT NULL

)

GO

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 6

Thanks, Luis.

Sorry to say this, but those CREATE TABLE statements don't seem to work with your INSERT statements. I keep getting an error saying column names are invalid. I even tried reversing the table names.

Could you put together one block of code that uses the CREATE TABLE statements to create two #temp tables (#FN and #FO) and the inserts that would work with those?

It might be easier if you posted them as an attachment in a .txt file. (See the "Edit Attachments" button at the bottom left of the page when you are typing a reply.)

We will get you an answer, yet 😉

Bob

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills