您好,欢迎访问三七文档
当前位置:首页 > 商业/管理/HR > 项目/工程管理 > 速达3000数据库表、字段中英文对照表
1基础资料2进销存3帐务4固定资产5工资6生产管理7GSP管理99其他snView_idView_NameType_D1ACCINFO帐套信息表32ACCOPTIONS套帐选项表33AREA地区14ATTACHAST附属设备表45BILLTYPE单据类型16BRIEFTYPE凭证摘要类型37CASHITEM现金流量金额分配表38CHARTABLE字母表19CLASS班次(POS用)410CREDITEM_TMP凭证从表中间表311CREDTYPE凭证类型312CURRENCY货币113DEPARTMENT部门114DEPRECIATE折旧表415EMPTYPE员工类别116FLOW资金流量表317FORMULA工资计算方式518FUNC自定义报表公式表319GOODSTYPE货品类别120GSP_OTHER_CHECKREPORTDETAIL药品检验报告书从表721GSP_OTHER_EMPLOYHEALTHDETAIL员工健康档案从表722GSP_OTHER_EQUIPMENTDETAIL计量器具管理台帐从表723GSP_OTHER_FORCECHECKDETAIL强制检定工作计量器具定期检定记录卡从表724GSP_OTHER_MAINTAINDETAIL药品养护档案从表725GSP_OTHER_TRIANINGDETAIL员工培训记录从表726GSP_STOCK_EQUSINGDETAIL库房设备使用记录从表727GSP_STOCK_HUMITEMPDETAIL库房温湿度记录从表728INITASTBALA固定资产初始化表429INITFLOW现金流量初始化表330INITRATE汇率初始化表331INV_INOUT仓库收发明细232LABALLOT工资项目分类主表533LOOKDAY应收应付帐龄分组表334MNF_WORKPLACE生产车间635OPERATOR操作员表136OPGROUP操作员分组137PRIVILEGETYPE控制类型438PROCEDURES工种表139PROJECTFILTER工资项目过滤器主表540PROJECTFILTERITEM工资项目过滤器从表541PU_PURCHASEDETAIL采购明细242REPORT_VIRSUAL虚拟记录143SA_SALEDETAIL销售明细244SAT其他库存变动类型245STORE仓库146USEDTYPE固定资产使用类型447VIEW_ADJAP调价单主表248VIEW_ALLOT调拨单主表249VIEW_ASSETCARD固定资产卡片450VIEW_ASSETTYPE固定资产类别451VIEW_ASTBALANCE固定资产及累计折旧余额表452VIEW_ASTCLEAR固定资产清理453VIEW_BACKDETAIL退料单从表254VIEW_BACKDRAW退料单主表255VIEW_BALANCE财务盘点356VIEW_BALDETAIL仓库盘点单从表257VIEW_BALITEM仓库盘点单主表258VIEW_BANK现金银行359VIEW_BRIEF凭证摘要360VIEW_CHARGE销售收款单主表261VIEW_CHARGEDETAIL销售收款单从表262VIEW_CLIENT客户163VIEW_COMBIN组装拆卸单主表264VIEW_COMBIND组装拆卸单从表265VIEW_CRCVDDETAIL现款采购单从表266VIEW_CRECIEVED现款采购单主表267VIEW_CREDENCE凭证主表368VIEW_CREDITEM凭证从表369VIEW_CSALE现款销售单主表270VIEW_CSALEDETAIL现款销售单从表271VIEW_DADJAP调价单从表272VIEW_DALLOT调拨单从表273VIEW_DEPUTESALE委托代销主表274VIEW_DEPUTESALEDETAIL委托代销从表275VIEW_DEPUTESETTLEMENT代销结算主表276VIEW_DEPUTESETTLEMENTDETAIL代销结算从表277VIEW_DINOUT库存变动单从表278VIEW_DISC折扣表179VIEW_DISLABORAGE工资支付表580VIEW_DRAWDETAIL领料单从表281VIEW_DRAWITEM领料单主表282VIEW_EMPLOY员工183VIEW_EMPTYPELAB工资费用分摊科目584VIEW_EXPENSE费用主表385VIEW_EXPENSED费用从表386VIEW_GCM货品核算方法187VIEW_GOODS货品188VIEW_GOODS_UNIT货品单位189VIEW_GOODSCASE货品案例290VIEW_GOODSINIT货品月收发存汇总表291VIEW_GSP_OTHER_CHECKREPORT药品检验报告书主表792VIEW_GSP_OTHER_EMPLOYHEALTH员工健康档案主表793VIEW_GSP_OTHER_EQUIPMENT计量器具管理台帐主表794VIEW_GSP_OTHER_FORCECHECK强制检定工作计量器具定期检定记录卡主表795VIEW_GSP_OTHER_GOODSQAOPINION药品质量、质量管理征询意见书796VIEW_GSP_OTHER_GTAKEOUTCHECK药品抽(送)检单797VIEW_GSP_OTHER_MAINTAIN药品养护档案主表798VIEW_GSP_OTHER_MASSBACK药品质量信息反馈单799VIEW_GSP_OTHER_MSGREBOUND信息传递反馈单7100VIEW_GSP_OTHER_QUALITYRETURN质量信息反馈单7101VIEW_GSP_OTHER_RECIPE门市中药配剂处方记录7102VIEW_GSP_OTHER_SALE有效期药品催销主表7103VIEW_GSP_OTHER_SALEDETAIL有效期药品催销从表7104VIEW_GSP_OTHER_TRIANING员工培训记录主表7105VIEW_GSP_OTHER_TRSPNTCHK针剂透明度检查记录主表7106VIEW_GSP_OTHER_TRSPNTCHKDETAIL针剂透明度检查记录从表7107VIEW_GSP_PUR_ACCEPT药品质量验收记录主表7108VIEW_GSP_PUR_ACCEPTDETAIL药品质量验收记录从表7109VIEW_GSP_PUR_CHECKCARD药品检验卡7110VIEW_GSP_PUR_EXAMAPPLY药品验证申请表7111VIEW_GSP_PUR_MANAGEEXAM药品经营审批表7112VIEW_GSP_PUR_PURCHASE药品购入登记台帐主表7113VIEW_GSP_PUR_PURCHASEDETAIL药品购入登记台帐从表7114VIEW_GSP_PUR_REJECTREPORT药品拒收报告单7115VIEW_GSP_PUR_RETURN药品退货登记台帐主表7116VIEW_GSP_PUR_RETURNDETAIL药品退货登记台帐从表7117VIEW_GSP_SALE_OUTCHECK药品出库复核主表7118VIEW_GSP_SALE_OUTCHECKDETAIL药品出库复核从表7119VIEW_GSP_SALE_RETURN销售退回药品主表7120VIEW_GSP_SALE_RETURNDETAIL销售退回药品从表7121VIEW_GSP_SALE_RETURNNOTIFY退货通知单7122VIEW_GSP_SALE_SALE销售台帐主表7123VIEW_GSP_SALE_SALEDETAIL销售台帐从表7124VIEW_GSP_SALE_STOPSALE药品停售通知单7125VIEW_GSP_SALE_UNSTOPSALE解除停售通知单7126VIEW_GSP_STOCK_DESTROY报损药品台帐主表7127VIEW_GSP_STOCK_DESTROYDETAIL报损药品台帐从表7128VIEW_GSP_STOCK_EQUSING库房设备使用记录主表7129VIEW_GSP_STOCK_FILE药品质量档案7130VIEW_GSP_STOCK_GOODSDESTROY报损商品销毁单7131VIEW_GSP_STOCK_GQUALITYCHECK药品质量检询登记表7132VIEW_GSP_STOCK_HUMIDITYTEMP库房温湿度记录7133VIEW_GSP_STOCK_REJECT不合格药品台帐主表7134VIEW_GSP_STOCK_REJECTDETAIL不合格药品台帐从表7135VIEW_GSP_STOCK_TESTNOTIFY药品质量复检通知单7136VIEW_IETYPE收入支出类别表3137VIEW_INCOME其它收入主表3138VIEW_INCOMED其它收入从表3139VIEW_INCRDECR固定资产增减方式4140VIEW_INDETAIL产品进仓从表2141VIEW_INITBALA会计科目初始化数据3142VIEW_INOUT库存变动单主表2143VIEW_INOUTCASH现金流动表3144VIEW_INPRODUCT产品进仓主表2145VIEW_INVOICE销售单主表2146VIEW_LABALLOTITEM工资项目分类从表5147VIEW_LABITEM工资项目表5148VIEW_LABORAGE工资表5149VIEW_MNFEXPENSEAPP费用分摊单主表6150VIEW_MNFEXPENSEAPPD费用分摊单从表6151VIEW_MNFFINISHIMPORT完工入库单6152VIEW_MNFGCMB物料清单6153VIEW_MNFMASTERPRDSCH主生产计划6154VIEW_MNFORDER加工单主表6155VIEW_MNFORDERBOM加工单材料表6156VIEW_MONEYDETAIL货币从表3157VIEW_MOVE银行存取款3158VIEW_MULTIBAR多栏帐主表3159VIEW_MULTIBARITEM多栏帐从表3160VIEW_ONHAND当前库存表2161VIEW_ONHANDINIT库存初始表2162VIEW_ONHANDTABLE当前货品库存2163VIEW_ORDERDETAIL采购订单从表2164VIEW_PAY采购付款主表2165VIEW_PAYDETAIL采购付款从表2166VIEW_PAYTYPE付款方式表3167VIEW_PIECEWORK计件工资表5168VIEW_PORDER采购订单主表2169VIEW_PRDETAIL采购退货从表2170VIEW_PRETURN采购退货主表2171VIEW_PROFITLOSS损益表3172VIEW_RCVDDETAIL采购收货单从表2173VIEW_RECIEVED采购收货单主表2174VIEW_RETURN销售退货单主表2175VIEW_RETURNDETAIL销售退货单从表2176VIEW_SALEDETAIL销售单从表2177VIEW_SHOPCALENDAR工厂日历6178VIEW_SORDER销售订单主表2179VIEW_SORDERDETAIL销售订单从表2180VIEW_STOREGOODSINIT仓库月收发存汇总表2181VIEW_SUBJECT会计科目3182VIEW_VALUEDRCVD估价入库单主表2183VIEW_VALUEDRCVDITEM估价入库单从表2184VIEW_VENDOR供应商1185VIEW_WORKPRO计件工序5186WORKLOAD固定资产工作量4OwnerVisible系统0系统0系统1系统1系统0系统0系统0系统0系统0系统0系统0系统1系统1系统0系统1系统0系统0系统0系统1系统1系统1系统1系统1系统1系统1系统1系统1系统0系统0系统0系统1系统0系统0系统1系统0系统0系统0系统1系统0系统0系统1系统1系统1系统1系统1系统1系统1系统1系统1系统1系统0系统1系统1系统1
本文标题:速达3000数据库表、字段中英文对照表
链接地址:https://www.777doc.com/doc-5859562 .html