KIS专业版-账套之间基础数据导出导入步骤

1、按照系统标准格式“物料.XLS”(事先从系统导出［物料］EXCEL,作为一个导入数据的模板)在编辑准备好需要导入的数据格式；(最好事先建一个文件夹)(1)D38▼V'采购单价A一▼AEJ35FicldlnfcFSOLovPrcFSOLowPrcMnyT消唐最低%nvarchar(255)t_CurrcncFCurrenc>Fllame+FlkFNunbcr1002是否消隹bit36FieldlnfcFIsSaleFIsSale37FieldlnfcFProfitRzFProfitRate毛利至(%)Decimal(28.10)38FieldlnfcFOrderPriFOrderPrice1系阳华“口Decimal(28.10) *3139FieldlnfcFSalePricFSalePrice 消隹单价Decimal(28,10)今240FieldlnfcFISKFPeriFISKFPenod是否进行砥bit 3341FieldlnfcFKFPeriocFKFPenod保质期(天：Decimal(28,10)市222244FieldlnfcFPlanPricFPlanPnce计划单价Decimal(28,10)弓8,b45FieldlnfcFPriccDecFPriceDecimal单价显示尊Vatchar(10)行9(b46FleldlnfcFAcctIDFAcctID存货科目仕nvarchar(255)40 t_AccountFAccount1FNumberFNunber10547FieldlnfcFSaleAcctFSaleAcctID消售收入术nvarchar(255)*41 t.AccountFAccountJFNuniberFNunberr10548FieldInfcFCostAcctFCostAcctID消色成本*nvarchar(255)42 t_AccountFAccount1FNumberFNunberr10649FieldlnfcFTaxRateFTaxRate税率(％)Decimal(28,10) 43"b50FieldlnfcFItejiDcscFIteniDescript Varchar(255) 4451FieldlnfcF102F102设皆商 Varchar(100)45,b52FieldlnfcF」03 F_l03制浩阳Varchar(100) 46(b53FieldlnfcF_104 F_104设爸商订名Varchar(100)(47rQ54FieldlnfcFGrContrcFGrControl控制 Decimal(28,10)④655FieldlnfcFDeletedFDeleted是否禁用Decimal(28,10)为56PageinfoPage2Page257FieldlnfcFBarCodeFBarCode条肥码Varchar(128)rl58FieldlnfcFRcnarkFRcmark备注 Varchar(iOO) 2b59FieldlnfcFKunberFMumber代码 Varchar(l28) 今"b60FieldlnfcFIianeFName名称 Varchar(l28)r4661PageinfoPage3Page362FieldlnfcFNunberFNumber代码 Varchar(128)’1(b63FieldlnfcFNancFllame名梆 Varchar(lOO)(0Ed丁qIXTrrfrPF cr3】”mhaE'lt-ffSYarrh^r(1A42FieldlnfcFBatchMarFBatchKan艾er是否采用;UbittSubMossFInterlDFID+FNaiieFID+FName^0043FieldlnfcFTrackFTrackm«>{p_Schoa/PagelPage?Page3,Paged5蜷s।y—计价方法nvarchar(255)台722222222n oPoooo3rl13七勺101勺勺殳00女2七2勺3*聿邛车¥¥未率***聿*¥奥费奥费资缴货滨费资缴费奥费资奥义义义天流天无谅天为流无差天光天天为本定定定物物物物拗物物物物物物物物物物基自自自rio6为31333七Iorio23石Ior10rio为255loo’100Fioo,b2oo^00*200^00‘128rioor128r1282oo^00’128riooRSTFalse’01False*01False为1False力1False为1False1False1False1False21False,21False1False21False1Falser2iFalse7)1False出1False力1False(01False1False2!Falser21False2False2False2False2False43False3Pel.3FieldlnfcFTrackFTrack计价方法nvarchar(255)r37tSubMessFInterlDFID+FNameFID+FNamer200,4FieldlnfcFPlanPricFPlanPrice计划单价Decimal(28,10)38,5FieldlnfcFPriceDecFPriceDecimal单价显示器Varchar(10)勺9.6FieldInfcFAcctIDFAcctID存货科目个nvarchar(255)%。t._AccoxmtFAccountIFNumberFNumber'105,7FieldlnfcFSaleAcctFSaleAcctIDi肖售收入表nvarchar(255)t..AccountFAccountIFNumberFNumber'105.8FieldlnfcFCostAcctFCostAcctID俏售成本术nvarchar(255)*42t._AccountFAccountIFNumberFNumberr105,9FieldlnfcFTaxRateFTaxRate税率设）Decimal(28,10)七10FieldlnfcFItemDescFItemDescript商品描述Varchar(255)(44七ilFieldInfcF_102F_102设备商Varchar(100)45七i2FieldInfcF_103F.103制造商Varchar(100)(46七；3FieldlnfcF104F104设备商订供Varchar(100)r47七i4FieldlnfcFGrContrcFGrControl控制Decimal(28,10)七；5FieldlnfcFDeletedFDeleted是否禁用Decimal(28,10)石0|1 11七i6PageinfoPage2Page2i7FieldlnfcFBarCodeFBarCode条形码Varchar(128)七i8FieldlnfcFRemarkFRemark备注Varchar(100)七FieldlnfcFNumberFNumber代码Varchar(128)七iOFieldlnfcFNameFName名称Varchar(128)ilPageinfoPage3Page3（注意：上图只做参考，要以你从系统中导出来的模板为准）（3）而［Pagel］表为主数据表，我们要导入的数据就是在这里进行编辑。（红色字段为需耍编辑的字段，其他为通用字段，不需要修改）ABC1DEFGHIJK匚-NumberFNaneFDetailFHelpCodeFModelFAuxClassIDFHaneFAuxClassIIFErpClsICFErpClsIEFUnxtGroupIDFName▼FUnrtl二300001耐震压力表True213.53100/0-2Sb<u-/©q]/Gl/2外购EAEA300002耐震后力表True213.S3.63/0-4b<u7径向/Gl/4外购EAEA300003耐震压力衰True213.S3.63/0-4bar/轴向/Gl/4外购EAEA300004耐震压力表True径向/Gl/4外购EAEA300005耐震压力表True213.5363/0T6bar/褊/G】/4外购EAEA)00006耐震压力表True213.5363/0-l6bar/酮/Gl/4外购EAEA300007耐震压力表True213.5363/0-100bw/®5]/Gl/4外购EAEA300008耐震压力表True213.5363/0-l60b<u-/©5]/Gl/4外购EAEA300009耐震压力表True213.S363/0-160bar/^/Gl/4外购EAEA300010耐需压力表True213.S3.63/0-1bar/径向/Gl/4外购EAEA300011甜言压力表True213.S3.63/0-1Obar/径向/Gl/4外购EAEAJ00012耐震压力表True213.S3.63/0-2.5bar/褊/Gl/4外购EAEA300013耐震压力表True213.5363/0-2.5bar/ttTo]/Gl/4外购EAEA)00014耐震压力表True213,5363/O-25bM/领/G1/4外购EAEA300015耐震压力表True213.5363/0-250b«■/轴向/Gl/4外购EAEA300016耐震压力表True213.S363/0-40b«r/径向/Gl/4外购EAEA300017耐震金力表True213.S3.63/0-40b«r/血/Gl"外购EAEA300018耐亮压力表True213.S3.63/0-600bar/^/Gl/4外购EAEA300019耐震压力赛True213.53.63/0-400bar/轴向/Gl/4外购EAEA)00020耐震压力表TrueYMBO/OTHF”径向外购EAEA)00021同步皮常True8M-800-40外购EAEA300022’/触防护占True |J-002-004翊型居J-102-0045外购EAEA300023族转单元True1121-380-345外购EAEA300024主轴联轴器True2so11607-001/SFC-140SS-T002外购EAEA300025LEVER手柄True30406350-001/SUS304外购EAEA300026传感器TrueM624Aoi替代型号配24BO1外购EAEAJ00027夹案弹苗TrueZQ2998-05-13外购EAEA300028密封条True12X9X5000外购EAEATriiPZQ3113-nS-13必腼> tSchenaPagelPage2Page3Page4p/III>□2、编辑好［物料］表后，通过开始菜单【程序】-【金蝶专业版】•【工具】-【系统工具工选择【数据交换平台】；——输入管理员密码，选择需要导入