1.sql

将excel格式的文件销售订单导入数据库中

delete from inventory where cInvCode in ('HGRL-A274CBFA',
'LPIN-A239CBMZ','LPIN-A240CBPZ','LPLTMA905CBPZ')
go
insert into inventory ([cInvCode],[cInvAddCode],[cInvName],[cInvStd],[cInvCCode],[cVenCode],[cReplaceItem],[cPosition],[bSale],[bPurchase],[bSelf],[bComsume],[bProducing],[bService],[bAccessary],[iTaxRate],[iInvWeight],[iVolume],[iInvRCost],[iInvSPrice],[iInvSCost],[iInvLSCost],[iInvNCost],[iInvAdvance],[iInvBatch],[iSafeNum],[iTopSum],[iLowSum],[iOverStock],[cInvABC],[bInvQuality],[bInvBatch],[bInvEntrust],[bInvOverStock],[dSDate],[dEDate],[bFree1],[bFree2],[cInvDefine1],[cInvDefine2],[cInvDefine3],[bInvType],[iInvMPCost],[cQuality],[iInvSaleCost],[iInvSCost1],[iInvSCost2],[iInvSCost3],[bFree3],[bFree4],[bFree5],[bFree6],[bFree7],[bFree8],[bFree9],[bFree10],[cCreatePerson],[cModifyPerson],[dModifyDate],[fSubscribePoint],[fVagQuantity],[cValueType],[bFixExch],[fOutExcess],[fInExcess],[iMassDate],[iWarnDays],[fExpensesExch],[bTrack],[bSerial],[bBarCode],[iId],[cBarCode],[cInvDefine4],[cInvDefine5],[cInvDefine6],[cInvDefine7],[cInvDefine8],[cInvDefine9],[cInvDefine10],[cInvDefine11],[cInvDefine12],[cInvDefine13],[cInvDefine14],[cInvDefine15],[cInvDefine16],[iGroupType],[cGroupCode],[cComUnitCode],[cAssComUnitCode],[cSAComUnitCode],[cPUComUnitCode],[cSTComUnitCode],[cCAComUnitCode],[cFrequency],[iFrequency],[iDays],[dLastDate],[iWastage],[bSolitude],[cEnterprise],[cAddress],[cFile],[cLabel],[cCheckOut],[cLicence],[bSpecialties],[cDefWareHouse],[iHighPrice],[iExpSaleRate],[cPriceGroup],[cOfferGrade],[iOfferRate],[cMonth],[iAdvanceDate],[cCurrencyName],[cProduceAddress],[cProduceNation],[cRegisterNo],[cEnterNo],[cPackingType],[cEnglishName],[bPropertyCheck],[cPreparationType],[cCommodity],[iRecipeBatch],[cNotPatentName],[bPromotSales],[iPlanPolicy],[iROPMethod],[iBatchRule],[fBatchIncrement],[iAssureProvideDays],[iTestStyle],[iDTMethod],[fDTRate],[fDTNum],[cDTUnit],[iDTStyle],[iQTMethod],[PictureGUID],[bPlanInv],[bProxyForeign],[bATOModel],[bCheckItem],[bPTOModel],[bEquipment],[cProductUnit],[fOrderUpLimit],[cMassUnit],[fRetailPrice],[cInvDepCode],[iAlterAdvance],[fAlterBaseNum],[cPlanMethod],[bMPS],[bROP],[bRePlan],[cSRPolicy],[bBillUnite],[iSupplyDay],[fSupplyMulti],[fMinSupply],[bCutMantissa],[cInvPersonCode],[iInvTfId],[cEngineerFigNo],[bInTotalCost],[iSupplyType],[bConfigFree1],[bConfigFree2],[bConfigFree3],[bConfigFree4],[bConfigFree5],[bConfigFree6],[bConfigFree7],[bConfigFree8],[bConfigFree9],[bConfigFree10],[iDTLevel],[cDTAQL],[bPeriodDT],[cDTPeriod],[iBigMonth],[iBigDay],[iSmallMonth],[iSmallDay],[bOutInvDT],[bBackInvDT],[iEndDTStyle],[bDTWarnInv],[fBackTaxRate],[cCIQCode],[cWGroupCode],[cWUnit],[fGrossW],[cVGroupCode],[cVUnit],[fLength],[fWidth],[fHeight],[iDTUCounter],[iDTDCounter],[iBatchCounter],[cShopUnit],[cPurPersonCode],[bImportMedicine],[bFirstBusiMedicine],[bForeExpland],[cInvPlanCode],[fConvertRate],[dReplaceDate],[bInvModel],[bKCCutMantissa],[bReceiptByDT],[iImpTaxRate],[iExpTaxRate],[bExpSale],[iDrawBatch],[bCheckBSATP],[cInvProjectCode],[iTestRule],[cRuleCode],[bCheckFree1],[bCheckFree2],[bCheckFree3],[bCheckFree4],[bCheckFree5],[bCheckFree6],[bCheckFree7],[bCheckFree8],[bCheckFree9],[bCheckFree10],[bBomMain],[bBomSub],[bProductBill],[iCheckATP],[iInvATPId],[iPlanTfDay],[iOverlapDay],[bPiece],[bSrvItem],[bSrvFittings],[fMaxSupply],[fMinSplit],[bSpecialOrder],[bTrackSaleBill])
values('HGRL-A274CBFA',Null,'HGRL-A274CBFA',Null,'03',Null,Null,Null,'1','0','1','0','0','0','0',17,Null,Null,Null,Null,Null,Null,Null,2,Null,Null,Null,Null,Null,Null,'0','0','0','0','2006-11-19',Null,'0','0',Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','0','0','demo','demo','2006-11-01',Null,Null,Null,'0',Null,Null,Null,Null,Null,'0','0','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,1,'12','1201',Null,'1202','1202','1202','1202',Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,Null,8,Null,Null,Null,Null,Null,Null,Null,'0',Null,Null,0,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','1202',Null,Null,Null,Null,Null,Null,'R','0','0','0','PE','0',Null,Null,Null,'0',Null,Null,Null,'1',0,'0','0','0','0','0','0','0','0','0','0',Null,Null,'0',Null,Null,Null,Null,Null,'0','0',Null,'0',0,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'1202',Null,'0','0','0',Null,1,Null,'0','0','0',17,0,'1',Null,'0',Null,Null,Null,'0','0','0','0','0','0','0','0','0','0','1','1','1',0,Null,Null,Null,'0','0','0',Null,Null,'0','1')
go
insert into inventory ([cInvCode],[cInvAddCode],[cInvName],[cInvStd],[cInvCCode],[cVenCode],[cReplaceItem],[cPosition],[bSale],[bPurchase],[bSelf],[bComsume],[bProducing],[bService],[bAccessary],[iTaxRate],[iInvWeight],[iVolume],[iInvRCost],[iInvSPrice],[iInvSCost],[iInvLSCost],[iInvNCost],[iInvAdvance],[iInvBatch],[iSafeNum],[iTopSum],[iLowSum],[iOverStock],[cInvABC],[bInvQuality],[bInvBatch],[bInvEntrust],[bInvOverStock],[dSDate],[dEDate],[bFree1],[bFree2],[cInvDefine1],[cInvDefine2],[cInvDefine3],[bInvType],[iInvMPCost],[cQuality],[iInvSaleCost],[iInvSCost1],[iInvSCost2],[iInvSCost3],[bFree3],[bFree4],[bFree5],[bFree6],[bFree7],[bFree8],[bFree9],[bFree10],[cCreatePerson],[cModifyPerson],[dModifyDate],[fSubscribePoint],[fVagQuantity],[cValueType],[bFixExch],[fOutExcess],[fInExcess],[iMassDate],[iWarnDays],[fExpensesExch],[bTrack],[bSerial],[bBarCode],[iId],[cBarCode],[cInvDefine4],[cInvDefine5],[cInvDefine6],[cInvDefine7],[cInvDefine8],[cInvDefine9],[cInvDefine10],[cInvDefine11],[cInvDefine12],[cInvDefine13],[cInvDefine14],[cInvDefine15],[cInvDefine16],[iGroupType],[cGroupCode],[cComUnitCode],[cAssComUnitCode],[cSAComUnitCode],[cPUComUnitCode],[cSTComUnitCode],[cCAComUnitCode],[cFrequency],[iFrequency],[iDays],[dLastDate],[iWastage],[bSolitude],[cEnterprise],[cAddress],[cFile],[cLabel],[cCheckOut],[cLicence],[bSpecialties],[cDefWareHouse],[iHighPrice],[iExpSaleRate],[cPriceGroup],[cOfferGrade],[iOfferRate],[cMonth],[iAdvanceDate],[cCurrencyName],[cProduceAddress],[cProduceNation],[cRegisterNo],[cEnterNo],[cPackingType],[cEnglishName],[bPropertyCheck],[cPreparationType],[cCommodity],[iRecipeBatch],[cNotPatentName],[bPromotSales],[iPlanPolicy],[iROPMethod],[iBatchRule],[fBatchIncrement],[iAssureProvideDays],[iTestStyle],[iDTMethod],[fDTRate],[fDTNum],[cDTUnit],[iDTStyle],[iQTMethod],[PictureGUID],[bPlanInv],[bProxyForeign],[bATOModel],[bCheckItem],[bPTOModel],[bEquipment],[cProductUnit],[fOrderUpLimit],[cMassUnit],[fRetailPrice],[cInvDepCode],[iAlterAdvance],[fAlterBaseNum],[cPlanMethod],[bMPS],[bROP],[bRePlan],[cSRPolicy],[bBillUnite],[iSupplyDay],[fSupplyMulti],[fMinSupply],[bCutMantissa],[cInvPersonCode],[iInvTfId],[cEngineerFigNo],[bInTotalCost],[iSupplyType],[bConfigFree1],[bConfigFree2],[bConfigFree3],[bConfigFree4],[bConfigFree5],[bConfigFree6],[bConfigFree7],[bConfigFree8],[bConfigFree9],[bConfigFree10],[iDTLevel],[cDTAQL],[bPeriodDT],[cDTPeriod],[iBigMonth],[iBigDay],[iSmallMonth],[iSmallDay],[bOutInvDT],[bBackInvDT],[iEndDTStyle],[bDTWarnInv],[fBackTaxRate],[cCIQCode],[cWGroupCode],[cWUnit],[fGrossW],[cVGroupCode],[cVUnit],[fLength],[fWidth],[fHeight],[iDTUCounter],[iDTDCounter],[iBatchCounter],[cShopUnit],[cPurPersonCode],[bImportMedicine],[bFirstBusiMedicine],[bForeExpland],[cInvPlanCode],[fConvertRate],[dReplaceDate],[bInvModel],[bKCCutMantissa],[bReceiptByDT],[iImpTaxRate],[iExpTaxRate],[bExpSale],[iDrawBatch],[bCheckBSATP],[cInvProjectCode],[iTestRule],[cRuleCode],[bCheckFree1],[bCheckFree2],[bCheckFree3],[bCheckFree4],[bCheckFree5],[bCheckFree6],[bCheckFree7],[bCheckFree8],[bCheckFree9],[bCheckFree10],[bBomMain],[bBomSub],[bProductBill],[iCheckATP],[iInvATPId],[iPlanTfDay],[iOverlapDay],[bPiece],[bSrvItem],[bSrvFittings],[fMaxSupply],[fMinSplit],[bSpecialOrder],[bTrackSaleBill])
values('LPIN-A239CBMZ',Null,'LPIN-A239CBMZ',Null,'03',Null,Null,Null,'1','0','1','0','0','0','0',17,Null,Null,Null,Null,Null,Null,Null,2,Null,Null,Null,Null,Null,Null,'0','0','0','0','2006-11-19',Null,'0','0',Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','0','0','demo','demo','2006-11-01',Null,Null,Null,'0',Null,Null,Null,Null,Null,'0','0','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,1,'12','1201',Null,'1202','1202','1202','1202',Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,Null,8,Null,Null,Null,Null,Null,Null,Null,'0',Null,Null,0,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','1202',Null,Null,Null,Null,Null,Null,'R','0','0','0','PE','0',Null,Null,Null,'0',Null,Null,Null,'1',0,'0','0','0','0','0','0','0','0','0','0',Null,Null,'0',Null,Null,Null,Null,Null,'0','0',Null,'0',0,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'1202',Null,'0','0','0',Null,1,Null,'0','0','0',17,0,'1',Null,'0',Null,Null,Null,'0','0','0','0','0','0','0','0','0','0','1','1','1',0,Null,Null,Null,'0','0','0',Null,Null,'0','1')
go
insert into inventory ([cInvCode],[cInvAddCode],[cInvName],[cInvStd],[cInvCCode],[cVenCode],[cReplaceItem],[cPosition],[bSale],[bPurchase],[bSelf],[bComsume],[bProducing],[bService],[bAccessary],[iTaxRate],[iInvWeight],[iVolume],[iInvRCost],[iInvSPrice],[iInvSCost],[iInvLSCost],[iInvNCost],[iInvAdvance],[iInvBatch],[iSafeNum],[iTopSum],[iLowSum],[iOverStock],[cInvABC],[bInvQuality],[bInvBatch],[bInvEntrust],[bInvOverStock],[dSDate],[dEDate],[bFree1],[bFree2],[cInvDefine1],[cInvDefine2],[cInvDefine3],[bInvType],[iInvMPCost],[cQuality],[iInvSaleCost],[iInvSCost1],[iInvSCost2],[iInvSCost3],[bFree3],[bFree4],[bFree5],[bFree6],[bFree7],[bFree8],[bFree9],[bFree10],[cCreatePerson],[cModifyPerson],[dModifyDate],[fSubscribePoint],[fVagQuantity],[cValueType],[bFixExch],[fOutExcess],[fInExcess],[iMassDate],[iWarnDays],[fExpensesExch],[bTrack],[bSerial],[bBarCode],[iId],[cBarCode],[cInvDefine4],[cInvDefine5],[cInvDefine6],[cInvDefine7],[cInvDefine8],[cInvDefine9],[cInvDefine10],[cInvDefine11],[cInvDefine12],[cInvDefine13],[cInvDefine14],[cInvDefine15],[cInvDefine16],[iGroupType],[cGroupCode],[cComUnitCode],[cAssComUnitCode],[cSAComUnitCode],[cPUComUnitCode],[cSTComUnitCode],[cCAComUnitCode],[cFrequency],[iFrequency],[iDays],[dLastDate],[iWastage],[bSolitude],[cEnterprise],[cAddress],[cFile],[cLabel],[cCheckOut],[cLicence],[bSpecialties],[cDefWareHouse],[iHighPrice],[iExpSaleRate],[cPriceGroup],[cOfferGrade],[iOfferRate],[cMonth],[iAdvanceDate],[cCurrencyName],[cProduceAddress],[cProduceNation],[cRegisterNo],[cEnterNo],[cPackingType],[cEnglishName],[bPropertyCheck],[cPreparationType],[cCommodity],[iRecipeBatch],[cNotPatentName],[bPromotSales],[iPlanPolicy],[iROPMethod],[iBatchRule],[fBatchIncrement],[iAssureProvideDays],[iTestStyle],[iDTMethod],[fDTRate],[fDTNum],[cDTUnit],[iDTStyle],[iQTMethod],[PictureGUID],[bPlanInv],[bProxyForeign],[bATOModel],[bCheckItem],[bPTOModel],[bEquipment],[cProductUnit],[fOrderUpLimit],[cMassUnit],[fRetailPrice],[cInvDepCode],[iAlterAdvance],[fAlterBaseNum],[cPlanMethod],[bMPS],[bROP],[bRePlan],[cSRPolicy],[bBillUnite],[iSupplyDay],[fSupplyMulti],[fMinSupply],[bCutMantissa],[cInvPersonCode],[iInvTfId],[cEngineerFigNo],[bInTotalCost],[iSupplyType],[bConfigFree1],[bConfigFree2],[bConfigFree3],[bConfigFree4],[bConfigFree5],[bConfigFree6],[bConfigFree7],[bConfigFree8],[bConfigFree9],[bConfigFree10],[iDTLevel],[cDTAQL],[bPeriodDT],[cDTPeriod],[iBigMonth],[iBigDay],[iSmallMonth],[iSmallDay],[bOutInvDT],[bBackInvDT],[iEndDTStyle],[bDTWarnInv],[fBackTaxRate],[cCIQCode],[cWGroupCode],[cWUnit],[fGrossW],[cVGroupCode],[cVUnit],[fLength],[fWidth],[fHeight],[iDTUCounter],[iDTDCounter],[iBatchCounter],[cShopUnit],[cPurPersonCode],[bImportMedicine],[bFirstBusiMedicine],[bForeExpland],[cInvPlanCode],[fConvertRate],[dReplaceDate],[bInvModel],[bKCCutMantissa],[bReceiptByDT],[iImpTaxRate],[iExpTaxRate],[bExpSale],[iDrawBatch],[bCheckBSATP],[cInvProjectCode],[iTestRule],[cRuleCode],[bCheckFree1],[bCheckFree2],[bCheckFree3],[bCheckFree4],[bCheckFree5],[bCheckFree6],[bCheckFree7],[bCheckFree8],[bCheckFree9],[bCheckFree10],[bBomMain],[bBomSub],[bProductBill],[iCheckATP],[iInvATPId],[iPlanTfDay],[iOverlapDay],[bPiece],[bSrvItem],[bSrvFittings],[fMaxSupply],[fMinSplit],[bSpecialOrder],[bTrackSaleBill])
values('LPIN-A240CBPZ',Null,'LPIN-A240CBPZ',Null,'03',Null,Null,Null,'1','0','1','0','0','0','0',17,Null,Null,Null,Null,Null,Null,Null,2,Null,Null,Null,Null,Null,Null,'0','0','0','0','2006-11-19',Null,'0','0',Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','0','0','demo','demo','2006-11-01',Null,Null,Null,'0',Null,Null,Null,Null,Null,'0','0','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,1,'12','1201',Null,'1202','1202','1202','1202',Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,Null,8,Null,Null,Null,Null,Null,Null,Null,'0',Null,Null,0,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','1202',Null,Null,Null,Null,Null,Null,'R','0','0','0','PE','0',Null,Null,Null,'0',Null,Null,Null,'1',0,'0','0','0','0','0','0','0','0','0','0',Null,Null,'0',Null,Null,Null,Null,Null,'0','0',Null,'0',0,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'1202',Null,'0','0','0',Null,1,Null,'0','0','0',17,0,'1',Null,'0',Null,Null,Null,'0','0','0','0','0','0','0','0','0','0','1','1','1',0,Null,Null,Null,'0','0','0',Null,Null,'0','1')
go
insert into inventory ([cInvCode],[cInvAddCode],[cInvName],[cInvStd],[cInvCCode],[cVenCode],[cReplaceItem],[cPosition],[bSale],[bPurchase],[bSelf],[bComsume],[bProducing],[bService],[bAccessary],[iTaxRate],[iInvWeight],[iVolume],[iInvRCost],[iInvSPrice],[iInvSCost],[iInvLSCost],[iInvNCost],[iInvAdvance],[iInvBatch],[iSafeNum],[iTopSum],[iLowSum],[iOverStock],[cInvABC],[bInvQuality],[bInvBatch],[bInvEntrust],[bInvOverStock],[dSDate],[dEDate],[bFree1],[bFree2],[cInvDefine1],[cInvDefine2],[cInvDefine3],[bInvType],[iInvMPCost],[cQuality],[iInvSaleCost],[iInvSCost1],[iInvSCost2],[iInvSCost3],[bFree3],[bFree4],[bFree5],[bFree6],[bFree7],[bFree8],[bFree9],[bFree10],[cCreatePerson],[cModifyPerson],[dModifyDate],[fSubscribePoint],[fVagQuantity],[cValueType],[bFixExch],[fOutExcess],[fInExcess],[iMassDate],[iWarnDays],[fExpensesExch],[bTrack],[bSerial],[bBarCode],[iId],[cBarCode],[cInvDefine4],[cInvDefine5],[cInvDefine6],[cInvDefine7],[cInvDefine8],[cInvDefine9],[cInvDefine10],[cInvDefine11],[cInvDefine12],[cInvDefine13],[cInvDefine14],[cInvDefine15],[cInvDefine16],[iGroupType],[cGroupCode],[cComUnitCode],[cAssComUnitCode],[cSAComUnitCode],[cPUComUnitCode],[cSTComUnitCode],[cCAComUnitCode],[cFrequency],[iFrequency],[iDays],[dLastDate],[iWastage],[bSolitude],[cEnterprise],[cAddress],[cFile],[cLabel],[cCheckOut],[cLicence],[bSpecialties],[cDefWareHouse],[iHighPrice],[iExpSaleRate],[cPriceGroup],[cOfferGrade],[iOfferRate],[cMonth],[iAdvanceDate],[cCurrencyName],[cProduceAddress],[cProduceNation],[cRegisterNo],[cEnterNo],[cPackingType],[cEnglishName],[bPropertyCheck],[cPreparationType],[cCommodity],[iRecipeBatch],[cNotPatentName],[bPromotSales],[iPlanPolicy],[iROPMethod],[iBatchRule],[fBatchIncrement],[iAssureProvideDays],[iTestStyle],[iDTMethod],[fDTRate],[fDTNum],[cDTUnit],[iDTStyle],[iQTMethod],[PictureGUID],[bPlanInv],[bProxyForeign],[bATOModel],[bCheckItem],[bPTOModel],[bEquipment],[cProductUnit],[fOrderUpLimit],[cMassUnit],[fRetailPrice],[cInvDepCode],[iAlterAdvance],[fAlterBaseNum],[cPlanMethod],[bMPS],[bROP],[bRePlan],[cSRPolicy],[bBillUnite],[iSupplyDay],[fSupplyMulti],[fMinSupply],[bCutMantissa],[cInvPersonCode],[iInvTfId],[cEngineerFigNo],[bInTotalCost],[iSupplyType],[bConfigFree1],[bConfigFree2],[bConfigFree3],[bConfigFree4],[bConfigFree5],[bConfigFree6],[bConfigFree7],[bConfigFree8],[bConfigFree9],[bConfigFree10],[iDTLevel],[cDTAQL],[bPeriodDT],[cDTPeriod],[iBigMonth],[iBigDay],[iSmallMonth],[iSmallDay],[bOutInvDT],[bBackInvDT],[iEndDTStyle],[bDTWarnInv],[fBackTaxRate],[cCIQCode],[cWGroupCode],[cWUnit],[fGrossW],[cVGroupCode],[cVUnit],[fLength],[fWidth],[fHeight],[iDTUCounter],[iDTDCounter],[iBatchCounter],[cShopUnit],[cPurPersonCode],[bImportMedicine],[bFirstBusiMedicine],[bForeExpland],[cInvPlanCode],[fConvertRate],[dReplaceDate],[bInvModel],[bKCCutMantissa],[bReceiptByDT],[iImpTaxRate],[iExpTaxRate],[bExpSale],[iDrawBatch],[bCheckBSATP],[cInvProjectCode],[iTestRule],[cRuleCode],[bCheckFree1],[bCheckFree2],[bCheckFree3],[bCheckFree4],[bCheckFree5],[bCheckFree6],[bCheckFree7],[bCheckFree8],[bCheckFree9],[bCheckFree10],[bBomMain],[bBomSub],[bProductBill],[iCheckATP],[iInvATPId],[iPlanTfDay],[iOverlapDay],[bPiece],[bSrvItem],[bSrvFittings],[fMaxSupply],[fMinSplit],[bSpecialOrder],[bTrackSaleBill])
values('LPLTMA905CBPZ',Null,'LPLTMA905CBPZ',Null,'03',Null,Null,Null,'1','0','1','0','0','0','0',17,Null,Null,Null,Null,Null,Null,Null,2,Null,Null,Null,Null,Null,Null,'0','0','0','0','2006-11-19',Null,'0','0',Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','0','0','demo','demo','2006-11-01',Null,Null,Null,'0',Null,Null,Null,Null,Null,'0','0','0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,1,'12','1201',Null,'1202','1202','1202','1202',Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,Null,8,Null,Null,Null,Null,Null,Null,Null,'0',Null,Null,0,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0','0','0','0','0','0','1202',Null,Null,Null,Null,Null,Null,'R','0','0','0','PE','0',Null,Null,Null,'0',Null,Null,Null,'1',0,'0','0','0','0','0','0','0','0','0','0',Null,Null,'0',Null,Null,Null,Null,Null,'0','0',Null,'0',0,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'1202',Null,'0','0','0',Null,1,Null,'0','0','0',17,0,'1',Null,'0',Null,Null,Null,'0','0','0','0','0','0','0','0','0','0','1','1','1',0,Null,Null,Null,'0','0','0',Null,Null,'0','1')