INSERT INTO [ERP].[dbo].[F_DOCLIGNE] ([DO_Domaine] ,[DO_Type] ,[CT_Num] ,[DO_Piece] ,[DL_PieceBC] ,[DL_PieceBL] ,[DO_Date] ,[DL_DateBC] ,[DL_DateBL] ,[DL_Ligne] ,[DO_Ref] ,[DL_TNomencl] ,[DL_TRemPied] ,[DL_TRemExep] ,[AR_Ref] ,[DL_Design] ,[DL_Qte] ,[DL_QteBC] ,[DL_QteBL] ,[DL_PoidsNet] ,[DL_PoidsBrut] ,[DL_Remise01REM_Valeur] ,[DL_Remise01REM_Type] ,[DL_Remise02REM_Valeur] ,[DL_Remise02REM_Type] ,[DL_Remise03REM_Valeur] ,[DL_Remise03REM_Type] ,[DL_PrixUnitaire] ,[DL_PUBC] ,[DL_Taxe1] ,[DL_TypeTaux1] ,[DL_TypeTaxe1] ,[DL_Taxe2] ,[DL_TypeTaux2] ,[DL_TypeTaxe2] ,[CO_No] ,[AG_No1] ,[AG_No2] ,[DL_PrixRU] ,[DL_CMUP] ,[DL_MvtStock] ,[DT_No] ,[AF_RefFourniss] ,[EU_Enumere] ,[EU_Qte] ,[DL_TTC] ,[DE_No] ,[DL_NoRef] ,[DL_TypePL] ,[DL_PUDevise] ,[DL_PUTTC] ,[DL_No] ,[DO_DateLivr] ,[CA_Num] ,[DL_Taxe3] ,[DL_TypeTaux3] ,[DL_TypeTaxe3] ,[DL_Frais] ,[DL_Valorise] ,[AR_RefCompose] ,[DL_NonLivre] ,[AC_RefClient] ,[DL_MontantHT] ,[DL_MontantTTC] ,[DL_FactPoids] ,[DL_Escompte] ,[DL_PiecePL] ,[DL_DatePL] ,[DL_QtePL] ,[DL_NoColis] ,[DL_NoLink] ,[RP_Code] ,[DL_QteRessource] ,[DL_DateAvancement] ,[PF_Num] ,[DL_CodeTaxe1] ,[DL_CodeTaxe2] ,[DL_CodeTaxe3] ,[DL_PieceOFProd] ,[DL_PieceDE] ,[DL_DateDE] ,[DL_QteDE] ,[DL_Operation] ,[Colisage] ,[QTE ANNULEE]) VALUES (0 ,1 ,'2211110' ,'BC1600015' ,'' ,'' ,'20160704 23:59:59' ,'20160704 23:59:59' ,'1900-01-01 00:00:00' , 1000 ,'' ,0 ,0 ,0 ,'5708932923293' ,'BLABLA BLA' ,1 ,1 ,0 ,0 ,0 ,6 ,1 ,0 ,0 ,0 ,0 ,57.04 ,0 ,5.500000 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,53.62 ,0 ,0 ,'' ,'Unité' ,1 ,0 ,1 ,1 ,0 ,0 ,56.57 ,16 ,'1900-01-01 00:00:00' ,'' ,0 ,0 ,0 ,0 ,1 ,null ,0 ,'' ,53.62 ,56.57 ,0 ,0 ,'' ,'1900-01-01 00:00:00' ,1 ,'' ,0 ,null ,0 ,'1900-01-01 00:00:00' ,'' ,'C02' ,null ,null ,0 ,'' ,'20160704 23:59:59' ,1 ,'' ,1 ,'')
L'erreur renvoyée par SQL Serveur est la suivante :
Partager