当前位置:文档之家› 用友U8数据字典

用友U8数据字典

用友U8数据字典
用友U8数据字典

UFSystem数据库

UA_Account Table (AA 系统管理) [U861] 账套表

Key Column Name Description Datatype Length Allow Nulls cDescription (U870)备注nvarchar100 True cIndustryCode (U8100)行业编号nvarchar100 True cUnitAddress4En (U870)单位英文地址4 nvarchar60 True cUnitAddress2En (U870)单位英文地址2 nvarchar60 True cCustomBrokerCode (U870)报关行nvarchar20 True cCustomCode (U870)海关代码nvarchar30 True cUnitNameEn (U870)单位英文名称nvarchar40 True cUnitAddress3En (U870)单位英文地址3 nvarchar60 True cOrgCode (U870)机构编码nvarchar50 True cPortCode (U870)发运港编码nvarchar10 True cUnitAddress1En (U870)单位英文地址1 nvarchar60 True iSysID (U861)账套内部标识nvarchar50 False cAcc_Id (U861)账套号nvarchar 3 False cAcc_Name (U861)账套名称nvarchar40 False cAcc_Path (U861)账套路径nvarchar128 False iYear (U861)启用会计期年smallint 2 False iMonth (U861)启用会计期月smallint 2 False cAcc_Master (U861)账套主管nvarchar20 True cCurCode (U861)本币代码nvarchar 4 False cCurName (U861)本币名称nvarchar8 False cUnitName (U861)单位名称nvarchar40 False cUnitAbbre (U861)单位简称nvarchar40 True cUnitAddr (U861)单位地址nvarchar80 True cUnitZap (U861)邮政编码nvarchar 6 True cUnitTel (U861)联系电话nvarchar30 True cUnitFax (U861)传真nvarchar30 True cUnitEMail (U861)电子邮件nvarchar40 True cUnitTaxNo (U861)税号nvarchar20 True cUnitLP (U861)法人nvarchar16 True cFinKind (U861)备注二nvarchar16 True cFinType (U861)备注一nvarchar16 True cEntType (U861)企业类型nvarchar12 False cTradeKind (U861)行业类型nvarchar100 True cIsCompanyVer (U861)是否集团版nchar 1 False cDomain (U861)域名nvarchar40 True UA_Account_sub Table (AA 系统管理) [U861] 账套年度表

Key Column Name Description Datatype Length Allow Nulls cAcc_Id (U861)账套号nvarchar 3 False iYear (U861)账套年度smallint 2 False cSub_Id (U861)模块标识nvarchar 2 False bIsDelete (U861)是否删除bit 1 False bClosing (U861)是否关闭bit 1 True

iModiPeri (U861)会计期间tinyint 1 True dSubSysUsed (U861)启用会计日期datetime8 True cUser_Id (U861)操作员nvarchar20 True dSubOriDate (U861)启用自然日期datetime8 True UA_Period Table (AA 系统管理) [U861] 会计期间表

Column Name Description Datatype Length Allow Nulls cAcc_Id (U861)账套号nvarchar 3 False iYear (U861)账簿年度smallint 2 False iId (U861)会计期间tinyint 1 False dBegin (U861)开始日期datetime8 False dEnd (U861)结束日期datetime8 False bIsDelete (U861)是否删除bit 1 True UA_TaskLog Table (AA 系统管理) [U861]站点网络控制表

Column Name Description Datatype Length Allow Nulls uuid (U872)guid nvarchar40 True cLSSubId (U872)子系统标示对应的加密号nvarchar 4 True cStationSerial (U872)工作站唯一标识nvarchar255 True cSub_Id (U861)模块标识nvarchar 2 True cSub_Name (U861)模块名称nvarchar40 True cStation (U861)机器名nvarchar255 True dInTime (U861)进入日期datetime8 True cTaskId (U861)任务标识nvarchar20 False TaskState (U861)任务状态nvarchar40 True cAppServer (U861)应用服务器名称nvarchar80 True UA_Log Table (AA 系统管理) [U861] 上机日志

Column Name Description Datatype Length Allow Nulls cAcc_Id (U861)账套号nvarchar 3 False cSub_Id (U861)模块标识nvarchar 2 False cUser_Id (U861)操作员nvarchar20 False cAuth_Id (U861)功能编号nvarchar100 False cStation (U861)机器名nvarchar255 False dInTime (U861)进入日期datetime8 True dOutTime (U861)退出日期datetime8 True iLogId (U861)登录标识float8 True iyear (U861)账簿年度nvarchar 4 True Success (U861)成功标志smallint 2 True UA_AALog_base Table (AA 系统管理) [U870] 系统管理日志信息

Column Name Description Datatype Length Allow Nulls cSub_Id (U870)产品号nvarchar 2 False cLogItem_ID (U890)日志内容号nvarchar100 True cLog_Txt (U870)日志信息nvarchar3000 False iyear (U870)年度nvarchar 4 True cLog_ID (U870)日志编码nvarchar100 False cAcc_Id (U870)账套号nvarchar 3 False cUser_Id (U870)用户编号nvarchar20 False

cTargetUser_Id (U890)目标客户nvarchar20 True cStation (U870)工作站nvarchar255 False dInTime (U870)开始执行时间datetime8 True dOutTime (U870)执行结束时间datetime 8 True Success (U870)是否成功smallint 2 True UA_ToNextYear_base Table (AA 系统管理)[U861] 需要导入新年度账数据表名称Column Name Description Datatype Length Allow Nulls whereEx (U872)结转条件nvarchar2000 True localeid (U861)语言ID,zh-CN(简体中nvarchar32 False iNo (U861)编号int 4 True cTblId (U861)表名称nvarchar64 True cTblName (U861)表中文名称nvarchar64 True cYearField (U8100)10.0未使用nvarchar128 True UA_HoldAuth Table (AA 系统管理) [U861] 操作员权限分配表

Column Name Description Datatype Length Allow Nulls cRepellentModule (U871)(预留) nvarchar255 True cRepellent (U871)(预留) nvarchar4000 True cNotRepellent (U871)(预留) nvarchar1024 True csub_id (U871)产品号nvarchar 2 True cAuthType (U871)(预留) nvarchar10 True cAcc_Id (U861)账套号nvarchar 3 False iYear (U861)账簿年度smallint 2 False cUser_Id (U861)操作员nvarchar20 False cAuth_Id (U861)功能编号nvarchar100 False iIsUser (U861)否为用户tinyint 1 False

UFDATA_账套号_会计年度

AccInformation Table (AS 公用目录设置) [U861] 账套参数表

Column Name Description Datatype Length Allow Nulls cSysID (U861)系统标识nvarchar 2 False cID (U861)项目标识nvarchar 5 True cName (U861)项目名称nvarchar30 False cCaption (U861)项目描述nvarchar30 True cType (U861)项目类型nvarchar20 True cValue (U861)参数取值nvarchar200 True cDefault (U861)缺省值nvarchar100 True bVisible (U861)是否可见bit 1 False bEnable (U861)是否有效bit 1 False pubufts (U861)时间戳timestamp8 True dsign Table (GL 总账) [U861] 凭证类别档案主表

Column Name Description Datatype Length Allow Nulls iAdjustFlag (U870)是否调整期凭证标志tinyint 1 False i_id (U861)自动编号int 4 False csign (U861)凭证类别字nvarchar8 False isignseq (U861)凭证类别排序号int 4 False ctext (U861)凭证类别名称nvarchar30 True

itype (U861)限制方式tinyint 1 True iotherused (U861)其它系统是否使用int 4 True cOtherName (U861)未使用nvarchar 4 True dsigns Table (AS 公用目录设置) [U861] 凭证类别档案子表

Column Name Description Datatype Length Allow Nulls i_id (U861)子表标识int 4 False csign (U861)凭证类别字nvarchar8 False ccode (U861)受限科目编码nvarchar15 False GL_bdigest Table (GL 总账) [U861] 常用摘要表

Column Name Description Datatype Length Allow Nulls i_id (U861)自动编号int 4 False cid (U861)常用摘要编码nvarchar 6 False ctext (U861)常用摘要正文nvarchar60 False ccode (U861)相关科目编码nvarchar15 True pubufts (U861)时间戳timestamp8 True GL_accsum Table (GL 总账) [U861] 科目总账

Column Name Description Datatype Length Allow Nulls iyear (U8100)会计年度int 4 False iYPeriod (U8100)包括年度的会计期间int 4 True i_id (U861)自动编号int 4 False ccode (U861)科目编码nvarchar15 False cexch_name (U861)币种名称nvarchar8 True iperiod (U861)会计期间tinyint 1 False cbegind_c (U861)金额期初方向nvarchar 2 False cbegind_c_engl (U861)金额期初方向英文nvarchar 2 False mb (U861)金额期初money8 False md (U861)借方金额money8 False mc (U861)贷方金额money8 False cendd_c (U861)金额期末方向nvarchar 2 False cendd_c_engl (U861)金额期末方向英文nvarchar 2 False me (U861)金额期末money8 False mb_f (U861)外币期初money8 False md_f (U861)外币借方金额money8 False mc_f (U861)外币贷方金额money8 False me_f (U861)外币期末money8 False nb_s (U861)数量期初float8 False nd_s (U861)数量借方float8 False nc_s (U861)数量贷方float8 False ne_s (U861)数量期末float8 False GL_accvouch Table (GL 总账) [U861] 凭证及明细账

Column Name Description Datatype Length Allow Nulls cBankReconNo (U890)银行对账序号nvarchar30 True NCVouchID (U870)NC凭证标识nvarchar60 True CErrReason (U870)错误原因nvarchar512 True iYPeriod (U8100)包括年度的会计期间int 4 True

iBG_ControlResult (U870)凭证预算通过标识smallint 2 True cBudgetBuffer (U870)作废时是否预算过nvarchar10 True RowGuid (U890)行标识varchar60 False daudit_date (U871)凭证审核日期datetime8 True wllqPeriod (U8100)往来两清的会计期间int 4 True BG_AuditRemark (U870)预算审核意见nvarchar512 True wllqDate (U8100)往来两清的日期datetime8 True iyear (U8100)凭证的会计年度smallint 2 True i_id (U861)自动编号int 4 False iperiod (U861)会计期间tinyint 1 False csign (U861)凭证类别字nvarchar8 True isignseq (U861)凭证类别排序号int 4 True ino_id (U861)凭证编号smallint 2 True inid (U861)行号smallint 2 False dbill_date (U861)制单日期datetime8 False idoc (U861)附单据数smallint 2 False cbill (U861)制单人nvarchar20 True ccheck (U861)审核人nvarchar20 True cbook (U861)记账人nvarchar20 True ibook (U861)记账标志tinyint 1 False ccashier (U861)出纳签字人nvarchar20 True iflag (U861)凭证标志tinyint 1 True ctext1 (U861)凭证头自定义项1 nvarchar10 True ctext2 (U861)凭证头自定义项2 nvarchar10 True cdigest (U861)摘要nvarchar120 True ccode (U861)科目编码nvarchar15 False cexch_name (U861)币种名称nvarchar8 True md (U861)借方金额money8 False mc (U861)贷方金额money8 False md_f (U861)外币借方金额money8 False mc_f (U861)外币贷方金额money8 False nfrat (U861)汇率float8 False nd_s (U861)数量借方float8 False nc_s (U861)数量贷方float8 False csettle (U861)结算方式编码nvarchar 3 True cn_id (U861)票据号nvarchar30 True dt_date (U861)票号发生日期datetime8 True cdept_id (U861)部门编码nvarchar12 True cperson_id (U861)职员编码nvarchar20 True ccus_id (U861)客户编码nvarchar20 True csup_id (U861)供应商编码nvarchar20 True citem_id (U861)项目编码nvarchar20 True citem_class (U861)项目大类编码nvarchar 2 True cname (U861)业务员nvarchar40 True ccode_equal (U861)对方科目编码nvarchar50 True

iflagbank (U861)银行账两清标志tinyint 1 True iflagPerson (U861)往来账两清标志tinyint 1 True bdelete (U861)是否核销bit 1 True coutaccset (U861)外部凭证账套号nvarchar 3 True ioutyear (U861)外部凭证会计年度smallint 2 True coutsysname (U861)外部凭证系统名称nvarchar10 True coutsysver (U861)外部凭证系统版本号nvarchar10 True doutbilldate (U861)外部凭证制单日期datetime8 True ioutperiod (U861)外部凭证会计期间tinyint 1 True coutsign (U861)外部凭证业务类型nvarchar100 True coutno_id (U861)外部凭证业务号nvarchar50 True doutdate (U861)外部凭证单据日期datetime8 True coutbillsign (U861)外部凭证单据类型nvarchar100 True coutid (U861)外部凭证单据号nvarchar50 True bvouchedit (U861)凭证是否可修改bit 1 True bvouchAddordele (U861)凭证分录是否可增删bit 1 True bvouchmoneyhold (U861)凭证合计金额是否保值bit 1 True bvalueedit (U861)分录数值是否可修改bit 1 True bcodeedit (U861)分录科目是否可修改bit 1 True ccodecontrol (U861)分录受控科目可用状态nvarchar50 True bPCSedit (U861)分录往来项是否可修改bit 1 True bDeptedit (U861)分录部门是否可修改bit 1 True bItemedit (U861)分录项目是否可修改bit 1 True bCusSupInput (U861)分录往来项是否必输bit 1 True cDefine1 (U861)自定义项1 nvarchar20 True cDefine2 (U861)自定义项2 nvarchar20 True cDefine3 (U861)自定义项3 nvarchar20 True cDefine4 (U861)自定义项4 datetime8 True cDefine5 (U861)自定义项5 int 4 True cDefine6 (U861)自定义项6 datetime8 True cDefine7 (U861)自定义项7 float8 True cDefine8 (U861)自定义项8 nvarchar 4 True cDefine9 (U861)自定义项9 nvarchar8 True cDefine10 (U861)自定义项10 nvarchar60 True cDefine11 (U861)自定义项11 nvarchar120 True cDefine12 (U861)自定义项12 nvarchar120 True cDefine13 (U861)自定义项13 nvarchar120 True cDefine14 (U861)自定义项14 nvarchar120 True cDefine15 (U861)自定义项15 int 4 True cDefine16 (U861)自定义项16 float8 True dReceive (U861)u8/nc传输接受日期datetime8 True cWLDZFlag (U861)公司对账类型nvarchar 1 True dWLDZTime (U861)公司对账日期datetime8 True bFlagOut (U861)公司对帐是否导出过对帐单bit 1 False iBG_OverFlag (U861)超预算标识int 4 True

cBG_Auditor (U861)超预算审批人nvarchar 40 True dBG_AuditTime (U861)超预算审批时间datetime8 True cBG_AuditOpinion (U861)超预算审批结论nvarchar50 True bWH_BgFlag (U861)预算审核标志bit 1 True ssxznum (U861)实时核销号int 4 True GL_accass Table (GL 总账) [U861] 辅助总账

Column Name Description Datatype Length Allow Nulls iYPeriod (U8100)包括年度的会计期间int 4 True iyear (U8100)会计年度smallint 2 True i_id (U861)自动编号int 4 False ccode (U861)科目编码nvarchar15 False cexch_name (U861)币种名称nvarchar8 True cdept_id (U861)部门编码nvarchar12 True cperson_id (U861)职员编码nvarchar20 True ccus_id (U861)客户编码nvarchar20 True csup_id (U861)供应商编码nvarchar20 True citem_class (U861)项目大类编码nvarchar 2 True citem_id (U861)项目编码nvarchar20 True iperiod (U861)会计期间tinyint 1 False cbegind_c (U861)金额期初方向nvarchar 2 False cbegind_c_engl (U861)金额期初方向英文nvarchar 2 False mb (U861)金额期初money8 False md (U861)借方金额money8 False mc (U861)贷方金额money8 False cendd_c (U861)金额期末方向nvarchar 2 False cendd_c_engl (U861)金额期末方向英文nvarchar 2 False me (U861)金额期末money8 False mb_f (U861)外币期初money8 False md_f (U861)外币借方金额money8 False mc_f (U861)外币贷方金额money8 False me_f (U861)外币期末money8 False nb_s (U861)数量期初float8 False nd_s (U861)数量借方float8 False nc_s (U861)数量贷方float8 False ne_s (U861)数量期末float8 False GL_AccAttachs Table (GL 总账) [U870] 凭证附件表

Column Name Description Datatype Length Allow Nulls Inid (U870)自动编号int 4 False CClientFileName (U870)客户端文件名称nvarchar255 False iyear (U8100)会计年度smallint 2 True iYPeriod (U8100)包括年度的会计期间int 4 True isignseq (U870)凭证类别字int 4 False SubmitTime (U870)提交时间datetime8 True ino_id (U870)凭证编号int 4 False CServerFileName (U870)服务器端文件名称nvarchar255 False

Iperiod (U870)期间tinyint 1 False GL_AccMultiAss Table (GL 总账) [U870] 多辅助明细账汇总表

Column Name Description Datatype Length Allow Nulls md_f (U870)外币借方金额money8 True addnc_s (U870)数量累计贷方float8 True ccus_id (U870)客户编码nvarchar20 True cperson_id (U870)个人编码nvarchar20 True cDefine10 (U870)自定义项10nvarchar60 True addmd_f (U870)外币累计借方money8 True nc_s (U870)贷方数量float8 True me_f (U870)外币期末金额money8 True mb_f (U870)外币期初金额money8 True md (U870)借方金额money8 True cDefine13 (U870)自定义项13nvarchar120 True addnd_s (U870)数量累计借方float8 True addmc (U870)本币累计贷方money8 True cDefine2 (U870)自定义项2nvarchar20 True addmc_f (U870)外币累计贷方money8 True cDefine5 (U870)自定义项5int 4 True mb (U870)期初金额money8 True iperiod (U870)会计期间tinyint 1 True mc (U870)贷方金额money8 True cDefine9 (U870)自定义项9nvarchar8 True csup_id (U870)供应商编码nvarchar20 True me (U870)期末金额money8 True nd_s (U870)借方数量float8 True cDefine3 (U870)自定义项3nvarchar20 True addmd (U870)本币累计借方money8 True cDefine6 (U870)自定义项6datetime8 True iYPeriod (U8100)包括年度的会计期间int 4 True cexch_name (U870)外币名称nvarchar8 True mc_f (U870)外币贷方金额money8 True cDefine11 (U870)自定义项11nvarchar120 True cDefine7 (U870)自定义项7float8 True cDefine1 (U870)自定义项1nvarchar20 True cname (U870)业务员名称nvarchar40 True iyear (U8100)会计年度smallint 2 True nb_s (U870)期初数量float8 True citem_class (U870)项目大类编码nvarchar 2 True citem_id (U870)项目编码nvarchar20 True cDefine16 (U870)自定义项16float8 True cDefine12 (U870)自定义项12nvarchar120 True cDefine8 (U870)自定义项8nvarchar 4 True ccode (U870)科目编码nvarchar15 False ne_s (U870)期末数量float8 True

cDefine14 (U870)自定义项14nvarchar 120 True i_id (U870)自动编号int 4 False cDefine15 (U870)自定义项15int 4 True cdept_id (U870)部门编码nvarchar12 True cDefine4 (U870)自定义项4datetime8 True GL_mccontrol Table (GL 总账) [U861] 总账科目控制表

Column Name Description Datatype Length Allow Nulls iyear (U8100)smallint 2 True ccode (U861)科目编码nvarchar15 False cauth (U861)功能名称nvarchar50 True cuser (U861)用户名nvarchar20 True cmachine (U861)机器名nvarchar50 True GL_mvcontrol Table (GL 总账) [U861] 总账凭证控制表

Column Name Description Datatype Length Allow Nulls iyear (U8100)smallint 2 True iperiod (U861)会计期间tinyint 1 False csign (U861)凭证类别字nvarchar8 False ino_id (U861)凭证编号smallint 2 False cauth (U861)功能名称nvarchar50 True cuser (U861)用户名nvarchar20 True cmachine (U861)机器名nvarchar50 True GL_mend Table (GL 总账) [U861] 产品结帐状态表

Column Name Description Datatype Length Allow Nulls iYPeriod (U8100)int 4 True bflag_WM (U861)福利管理结帐标志 bit 1 False bflag_SC (U871)出纳结账标志 bit 1 True bflag_FM (U861)资金管理结帐标志 bit 1 False bflag_HY (U890)bit 1 False bFlag_RP (U870)出纳结账标志 bit 1 True bflag_GLGZ (U870)关账标志 bit 1 True iyear (U8100)smallint 2 False iperiod (U861)会计期间 tinyint 1 False bflag (U861)总账结账标志 bit 1 False bcheck (U861)总账本次对账结果 bit 1 True dpri_check (U861)总账上次对账日期 datetime8 True bpri_check (U861)总账上次对账结果 bit 1 True bflag_AP (U861)应付结账标志 bit 1 True bflag_AR (U861)应收结账标志 bit 1 True bflag_CA (U861)成本结账标志 bit 1 True bflag_FA (U861)固定资产结账标志 bit 1 True bflag_FD (U861)资金结账标志 bit 1 True bflag_IA (U861)存货结账标志 bit 1 True bflag_PP (U861)物料需求计划结账标志 nvarchar50 True bflag_PU (U861)采购结账标志 bit 1 True bflag_WA (U861)工资结账标志 bit 1 True

bflag_ST (U861)库存结账标志 bit 1 True bflag_SA (U861)销售结账标志 bit 1 True pubufts (U861)时间戳 timestamp8 True bflag_GS (U861)GSP质量管理结帐标志 bit 1 False bflag_WH (U861)报账中心结账标志 bit 1 False bflag_NB (U861)网上银行结账标志 bit 1 True bflag_PM (U861)项目管理结帐标志 bit 1 False bflag_CP (U861)CP标志 bit 1 True bflag_OM (U861)委外管理标志 bit 1 False printEx Table (AS 公用目录设置) [U861] 打印格式设置表

Column Name Description Datatype Length Allow Nulls cSystemName (U861)系统名称nvarchar20 False cSystemSubNum (U861)工资类别号nvarchar 3 True nTableNum (U861)表标识int 4 False cTableName (U861)表名称nvarchar50 False cTableCode (U861)表编号nvarchar20 True cPaperType (U861)纸型nvarchar50 False bOrientation (U861)方向bit 1 False iTitleRes (U861)表头内容来源tinyint 1 True cResPathHead (U861)表头文件全名nvarchar255 True cResPathTail (U861)表尾文件全名nvarchar255 True iSelfDefWidth (U861)自定义纸宽int 4 True iselfDefHeight (U861)自定义纸高int 4 True iLeftMargin (U861)打印纸张左边距int 4 True iRightMargin (U861)打印纸张右边距int 4 True iBottomMargin (U861)打印纸张底边距int 4 True iTopMargin (U861)打印纸张顶边距int 4 True GL_mybooktype Table (GL 总账) [U861] 总账帐簿套打格式设置表

Column Name Description Datatype Length Allow Nulls LocaleId (U861)语言ID,zh-CN(简体中nvarchar32 False itable_id (U861)账簿编号tinyint 1 False ifield_id (U861)栏目顺序号tinyint 1 False ctable_name (U861)账簿名称nvarchar100 True itable_left (U861)左坐标float8 False itable_top (U861)上坐标float8 False itable_line (U861)行数tinyint 1 False cfield_name (U861)纸型及方向nvarchar50 False ifieldwidth (U861)行高float8 False ctable_up (U861)账簿表头模板名称nvarchar50 False ctable_down (U861)账簿表尾模板名称nvarchar50 False Inventory Table (AS 公用目录设置) [U861] 存货档案

Remark:存货可作为项目大类之一

Column Name Description Datatype Length Allow Nulls bTrackSaleBill (U870)销售跟单bit 1 False bPiece (U870)计件bit 1 False

iTestRule (U870)检验规则smallint 2 True cInvMnemCode (U8100)助记码nvarchar40 True bCheckFree9 (U870)核算自由项9 bit 1 False bSpecialOrder (U870)客户订单专用bit 1 False iDrawBatch (U870)领料批量float8 True bBomSub (U870)允许BOM子件bit 1 False cInvProjectCode (U870)售前ATP方案nvarchar16 True bCheckFree5 (U870)核算自由项5 bit 1 False bImportMedicine (U861)是否进口药品bit 1 False iImpTaxRate (U870)进项税率float8 True cInvPlanCode (U861)计划品nvarchar20 True bBomMain (U870)允许BOM母件bit 1 False iOverlapDay (U870)重叠天数int 4 True iCheckATP (U870)检查ATP smallint 2 False iInvATPId (U870)ATP规则int 4 True bCheckFree3 (U870)核算自由项3 bit 1 False bCheckFree6 (U870)核算自由项6 bit 1 False bCheckFree10 (U870)核算自由项10 bit 1 False bForeExpland (U861)预测展开bit 1 False bProductBill (U870)允许生产订单bit 1 False fConvertRate (U861)转换因子float8 False bKCCutMantissa (U861)领料是否切除尾数bit 1 False bCheckFree1 (U870)核算自由项1 bit 1 False bSrvFittings (U870)服务配件bit 1 False bCheckFree8 (U870)核算自由项8 bit 1 False bExpSale (U870)外销bit 1 False bSrvItem (U870)服务项目bit 1 False iExpTaxRate (U870)出口税率float8 True dReplaceDate (U861)替换日期datetime8 True bCheckFree2 (U870)核算自由项2 bit 1 False bCheckBSATP (U870)检查售前ATP bit 1 False iPlanTfDay (U870)计划时栅天数int 4 True bFirstBusiMedicine (U861)是否首营药品bit 1 False fMinSplit (U870)最小分割量float8 True bCheckFree4 (U870)核算自由项4 bit 1 False cRuleCode (U870)自定义抽检规则nvarchar20 True bReceiptByDT (U870)来料须依据检验结果入库bit 1 False fMaxSupply (U870)最高供应量float8 True bInvModel (U861)模型bit 1 False bCheckFree7 (U870)核算自由项7 bit 1 False cInvCode (U861)存货编码nvarchar20 False cInvAddCode (U861)存货代码nvarchar255 True cInvName (U861)存货名称nvarchar255 True cInvStd (U861)规格型号nvarchar255 True cInvCCode (U861)存货大类编码nvarchar12 True

cVenCode (U861)供应商编码nvarchar20 True cReplaceItem (U861)替换件nvarchar20 True cPosition (U861)货位编码nvarchar20 True bSale (U861)是否销售bit 1 False bPurchase (U861)是否外购bit 1 False bSelf (U861)是否自制bit 1 False bComsume (U861)是否生产耗用bit 1 False bProducing (U861)是否在制bit 1 False bService (U861)是否应税劳务bit 1 False bAccessary (U861)是否成套件bit 1 False iTaxRate (U861)税率float8 True iInvWeight (U861)单位重量float8 True iVolume (U861)单位体积float8 True iInvRCost (U861)计划价或售价float8 True iInvSPrice (U861)参考成本float8 True iInvSCost (U861)参考售价float8 True iInvLSCost (U861)最低售价float8 True iInvNCost (U861)最新成本float8 True iInvAdvance (U861)提前期float8 True iInvBatch (U861)经济批量float8 True iSafeNum (U861)安全库存量float8 True iTopSum (U861)最高库存float8 True iLowSum (U861)最低库存float8 True iOverStock (U861)积压标准float8 True cInvABC (U861)存货ABC分类nvarchar 1 True bInvQuality (U861)是否保质期管理bit 1 False bInvBatch (U861)是否批次管理bit 1 False bInvEntrust (U861)是否受托代销bit 1 False bInvOverStock (U861)是否呆滞积压bit 1 False dSDate (U861)启用日期datetime8 True dEDate (U861)停用日期datetime8 True bFree1 (U861)存货是否有自由项1 bit 1 False bFree2 (U861)存货是否有自由项2 bit 1 False cInvDefine1 (U861)存货自定义项1 nvarchar20 True cInvDefine2 (U861)存货自定义项2 nvarchar20 True cInvDefine3 (U861)存货自定义项3 nvarchar20 True I_id (U861)自动编号int 4 False bInvType (U861)是否折扣bit 1 True iInvMPCost (U861)最高进价float8 True cQuality (U861)质量要求说明nvarchar100 True iInvSaleCost (U861)零售单价float8 True iInvSCost1 (U861)一级批发价float8 True iInvSCost2 (U861)二级批发价float8 True iInvSCost3 (U861)三级批发价float8 True bFree3 (U861)存货是否有自由项3 bit 1 False

bFree4 (U861)存货是否有自由项4 bit 1 False bFree5 (U861)存货是否有自由项5 bit 1 False bFree6 (U861)存货是否有自由项6 bit 1 False bFree7 (U861)存货是否有自由项7 bit 1 False bFree8 (U861)存货是否有自由项8 bit 1 False bFree9 (U861)存货是否有自由项9 bit 1 False bFree10 (U861)存货是否有自由项10 bit 1 False cCreatePerson (U861)建档人nvarchar20 True cModifyPerson (U861)变更人nvarchar20 True dModifyDate (U861)变更日期datetime8 True fSubscribePoint (U861)订货点float8 True fVagQuantity (U861)平均耗用量float8 True cValueType (U861)计价方式nvarchar20 True bFixExch (U861)是否为固定换算率bit 1 False fOutExcess (U861)出库超额上限float8 True fInExcess (U861)入库超额上限float8 True iMassDate (U861)保质期天数smallint 2 True iWarnDays (U861)保质期预警天数smallint 2 True fExpensesExch (U861)费用率float8 True bTrack (U861)是否出库跟踪入库bit 1 False bSerial (U861)是否有序列号管理bit 1 False bBarCode (U861)是否条形码管理bit 1 False iId (U861)所属权限组int 4 True cBarCode (U861)对应条形码编码nvarchar30 True cInvDefine4 (U861)存货自定义项4 nvarchar60 True cInvDefine5 (U861)存货自定义项5 nvarchar60 True cInvDefine6 (U861)存货自定义项6 nvarchar60 True cInvDefine7 (U861)存货自定义项7 nvarchar120 True cInvDefine8 (U861)存货自定义项8 nvarchar120 True cInvDefine9 (U861)存货自定义项9 nvarchar120 True cInvDefine10 (U861)存货自定义项10 nvarchar120 True cInvDefine11 (U861)存货自定义项11 int 4 True cInvDefine12 (U861)存货自定义项12 int 4 True cInvDefine13 (U861)存货自定义项13 float8 True cInvDefine14 (U861)存货自定义项14 float8 True cInvDefine15 (U861)存货自定义项15 datetime8 True cInvDefine16 (U861)存货自定义项16 datetime8 True iGroupType (U861)计量单位组类别tinyint 1 False cGroupCode (U861)计量单位组编码nvarchar35 True cComUnitCode (U861)主计量单位编码nvarchar35 True cAssComUnitCode (U861)辅计量单位编码nvarchar35 True cSAComUnitCode (U861)销售默认计量单位编码nvarchar35 True cPUComUnitCode (U861)采购默认计量单位编码nvarchar35 True cSTComUnitCode (U861)库存默认计量单位编码nvarchar35 True cCAComUnitCode (U861)成本默认计量单位编码nvarchar35 True

cFrequency (U861)盘点周期单位nvarchar10 True iFrequency (U861)盘点周期smallint 2 True iDays (U861)盘点日smallint 2 True dLastDate (U861)上次盘点日期datetime8 True iWastage (U861)合理损耗率float8 True bSolitude (U861)是否单独存放bit 1 False cEnterprise (U861)生产企业nvarchar100 True cAddress (U861)产地nvarchar255 True cFile (U861)批准文号或注册证号nvarchar40 True cLabel (U861)注册商标nvarchar30 True cCheckOut (U861)合格证号nvarchar30 True cLicence (U861)生产许可证号nvarchar30 True bSpecialties (U861)是否特殊药品bit 1 False cDefWareHouse (U861)仓库编码nvarchar10 True iHighPrice (U861)最高售价float8 True iExpSaleRate (U861)销售加成率float8 True cPriceGroup (U861)价格组nvarchar20 True cOfferGrade (U861)销售贡献等级nvarchar20 True iOfferRate (U861)销售贡献率float8 True cMonth (U861)存货期末处理会计期nvarchar 6 True iAdvanceDate (U861)累计提前期smallint 2 True cCurrencyName (U861)通用名称nvarchar60 True cProduceAddress (U861)生产地点nvarchar255 True cProduceNation (U861)生产国别nvarchar60 True cRegisterNo (U861)进口药品注册证号nvarchar60 True cEnterNo (U861)入关证号nvarchar60 True cPackingType (U861)包装规格nvarchar60 True cEnglishName (U861)存货英文名称nvarchar100 True bPropertyCheck (U861)是否质检bit 1 False cPreparationType (U861)剂型nvarchar30 True cCommodity (U861)注册商标批件nvarchar60 True iRecipeBatch (U861)处方药或非处方药tinyint 1 False cNotPatentName (U861)国际非专利名nvarchar30 True pubufts (U861)时间戳timestamp8 True bPromotSales (U861)是否促销品bit 1 False iPlanPolicy (U861)计划策略smallint 2 True iROPMethod (U861)再订货点方法smallint 2 True iBatchRule (U861)批量规则smallint 2 True fBatchIncrement (U861)批量增量float8 True iAssureProvideDays (U861)保证供应天数int 4 True iTestStyle (U861)检验方式smallint 2 True iDTMethod (U861)抽检方案smallint 2 True fDTRate (U861)抽检率float8 True fDTNum (U861)抽检量float8 True cDTUnit (U861)检验计量单位nvarchar35 True

iDTStyle (U861)抽检方式smallint 2 True iQTMethod (U861)质量检验方案int 4 True

PictureGUID (U861)图片GUID uniqueiden

tifier 16 True

bPlanInv (U861)是否计划品bit 1 False bProxyForeign (U861)是否委外bit 1 False bATOModel (U861)是否ATO模型bit 1 False bCheckItem (U861)是否选项类bit 1 False bPTOModel (U861)是否PTO模型bit 1 False bEquipment (U861)设备bit 1 False cProductUnit (U861)生产计量单位nvarchar35 True fOrderUpLimit (U861)订货超额上限float8 True cMassUnit (U861)保质期单位smallint 2 True fRetailPrice (U861)零售价格float8 True cInvDepCode (U861)生产部门nvarchar12 True iAlterAdvance (U861)变动提前期int 4 True fAlterBaseNum (U861)变动基数float8 True cPlanMethod (U861)计划方法nvarchar 1 True bMPS (U861)MPS件bit 1 False bROP (U861)ROP件bit 1 False bRePlan (U861)是否重复计划bit 1 False cSRPolicy (U861)供需政策nvarchar 2 True bBillUnite (U861)是否令单合并bit 1 False iSupplyDay (U861)供应期间int 4 True fSupplyMulti (U861)供应倍数float8 True fMinSupply (U861)最低供应量float8 True bCutMantissa (U861)是否切除尾数bit 1 False cInvPersonCode (U861)计划员nvarchar20 True iInvTfId (U861)时栅代号int 4 True cEngineerFigNo (U861)工程图号nvarchar60 True bInTotalCost (U861)成本累计否bit 1 False iSupplyType (U861)供应类型smallint 2 False bConfigFree1 (U861)结构性自由项1 bit 1 False bConfigFree2 (U861)结构性自由项2 bit 1 False bConfigFree3 (U861)结构性自由项3 bit 1 False bConfigFree4 (U861)结构性自由项4 bit 1 False bConfigFree5 (U861)结构性自由项5 bit 1 False bConfigFree6 (U861)结构性自由项6 bit 1 False bConfigFree7 (U861)结构性自由项7 bit 1 False bConfigFree8 (U861)结构性自由项8 bit 1 False bConfigFree9 (U861)结构性自由项9 bit 1 False bConfigFree10 (U861)结构性自由项10 bit 1 False iDTLevel (U861)检验水平smallint 2 True cDTAQL (U861)AQL nvarchar20 True bPeriodDT (U861)是否周期检验bit 1 False cDTPeriod (U861)检验周期nvarchar30 True

iBigMonth (U861)不大于月int 4 True iBigDay (U861)不大于天int 4 True iSmallMonth (U861)不小于月int 4 True iSmallDay (U861)不小于天int 4 True bOutInvDT (U861)是否发货检验bit 1 False bBackInvDT (U861)是否退货检验bit 1 False iEndDTStyle (U861)自制品检验严格度smallint 2 True bDTWarnInv (U861)保质期存货是否检验bit 1 True fBackTaxRate (U861)退税率float8 True cCIQCode (U861)海关代码nvarchar30 True cWGroupCode (U861)重量计量组nvarchar35 True cWUnit (U861)重量单位nvarchar35 True fGrossW (U861)毛重float8 True cVGroupCode (U861)体积计量组nvarchar35 True cVUnit (U861)体积单位nvarchar35 True fLength (U861)长(CM)float8 True fWidth (U861)宽(CM)float8 True fHeight (U861)高(CM)float8 True iDTUCounter (U861)检验正方向记数int 4 True iDTDCounter (U861)检验反方向记数int 4 True iBatchCounter (U861)连续累计批记数int 4 True cShopUnit (U861)零售计量单位nvarchar35 True cPurPersonCode (U861)采购员nvarchar20 True LockVouch Table (AS 公用目录设置) [U861] 客户供应商控制表

Column Name Description Datatype Length Allow Nulls AutoID (U861)自动编号int 4 False cVouchType (U861)单据类型编码nvarchar 2 False ID (U861)记录标识nvarchar40 False cAuth (U861)功能名称nvarchar20 True cUser (U861)用户名nvarchar20 True cWorkStation (U861)机器名nvarchar30 False MainBatch Table (ST 库存管理) [U861] 出入库跟踪表

Column Name Description Datatype Length Allow Nulls cposition (U8100)货位编码nvarchar20 True iExpiratDateCalcu (U8100)有效期推算方式smallint 2 True cBatchProperty2 (U8100)属性2 decimal17 True cbatch (U8100)批号nvarchar60 True cdefine37 (U8100)表体自定义项37 datetime8 True iSodid (U861)销售订单子表ID nvarchar40 True cBatchProperty4 (U8100)属性4 decimal17 True cdefine24 (U8100)表体自定义项24 nvarchar60 True iUnitCost (U8100)单价decimal17 True iSoType (U861)订单类型int 4 True cBatchProperty5 (U8100)属性5 decimal17 True cBatchProperty8 (U8100)属性8 nvarchar120 True

cRdCode (U8100)收发类别编码nvarchar 5 True cdefine31 (U8100)表体自定义项31 nvarchar120 True cmassunit (U8100)保质期单位smallint 2 True coritracktype (U8100)原始入库单类型nvarchar 2 True iMassDate (U8100)保质期天数int 4 True cdefine30 (U8100)表体自定义项30 nvarchar120 True citemcode (U8100)项目编码nvarchar60 True cdefine23 (U8100)表体自定义项23 nvarchar60 True cBatchProperty7 (U8100)属性7 nvarchar120 True cdefine35 (U8100)表体自定义项35 int 4 True cdefine33 (U8100)表体自定义项33 nvarchar120 True cItemCName (U8100)项目大类名称nvarchar20 True cdefine22 (U8100)表体自定义项22 nvarchar60 True isoutnum (U8100)累计出库辅计量数量decimal17 True cBatchProperty9 (U8100)属性9 nvarchar120 True ddate (U8100)单据日期datetime8 True cBatchProperty1 (U8100)属性1 decimal17 True cHandler (U8100)审核人nvarchar20 True iOriTrackID (U8100)ioritrackid bigint8 True ccode (U8100)收发单据号nvarchar30 True cvouchtype (U8100)单据类型编码nvarchar 2 True cvmivencode (U8100)代管商编码nvarchar20 True cName (U8100)项目名称nvarchar255 True cBatchProperty3 (U8100)属性3 decimal17 True cdefine27 (U8100)表体自定义项27 float8 True dMadeDate (U8100)生产日期datetime8 True cbarcode (U8100)对应条形码编码nvarchar200 True dExpirationDate (U8100)有效期计算项datetime8 True cBatchProperty10 (U8100)属性10 datetime8 True cdefine29 (U8100)表体自定义项29 nvarchar120 True cBatchProperty6 (U8100)属性6 nvarchar120 True cdefine34 (U8100)表体自定义项34 int 4 True inum (U8100)辅计量数量decimal17 True rdmid (U8100)单据主表id int 4 True dVDate (U8100)失效日期datetime8 True iquantity (U8100)数量decimal17 True cdefine25 (U8100)表体自定义项25 nvarchar60 True cExpirationDate (U8100)有效期至varchar10 True cpersoncode (U8100)业务员编码nvarchar20 True citem_class (U8100)项目大类编码nvarchar10 True cdefine26 (U8100)表体自定义项26 float8 True cDepCode (U8100)部门编码nvarchar20 True isoutquantity (U8100)累计出库数量decimal17 True cdefine36 (U8100)表体自定义项36 datetime8 True cdefine32 (U8100)表体自定义项32 nvarchar120 True

cvencode (U8100)供应商编码nvarchar20 True

cdefine28 (U8100)表体自定义项28 nvarchar120 True

ID (U861)收发记录主表标识int 4 False

cWhCode (U861)仓库编码nvarchar10 False

cInvCode (U861)存货编码nvarchar20 False

bIsNull (U861)是否出空int 4 False

RdID (U861)收发记录子表标识int 4 False

cFree1 (U861)存货自由项1 nvarchar20 True

cFree2 (U861)存货自由项2 nvarchar20 True

cFree3 (U861)存货自由项3 nvarchar20 True

cFree4 (U861)存货自由项4 nvarchar20 True

cFree5 (U861)存货自由项5 nvarchar20 True

cFree6 (U861)存货自由项6 nvarchar20 True

cFree7 (U861)存货自由项7 nvarchar20 True

cFree8 (U861)存货自由项8 nvarchar20 True

cFree9 (U861)存货自由项9 nvarchar20 True

cFree10 (U861)存货自由项10 nvarchar20 True PurBillVouch Table (PU 采购管理) [U861] 采购发票主表

费发票、期初发票,采购发票可拷贝采购订单、采购入库单、采购发票,可结算、现结,可由应付Column Name Description Datatype Length Allow Nulls

cVenAccount (U8100)供方银行账号nvarchar50 True

iflowid (U890)流程id int 4 True

cBG_Auditor (U890)预算审批人nvarchar20 True

ControlResult (U890)控制结果smallint 2 True

ccleanver (U8100)卸载版本nvarchar50 True

bCredit (U872)是否为立账依据smallint 2 True

cReviser (U871)修改人nvarchar40 True

dverifysystime (U8100)系统审核时间datetime8 True

iBG_OverFlag (U890)预算审批状态smallint 2 True

dGatheringDate (U870)到期日datetime8 True

cModifyDate (U871)修改日期datetime8 True

cBG_AuditTime (U890)预算审批时间nvarchar20 True

dCreditStart (U870)立账日datetime8 True

iDiscountTaxType (U870)扣税类别(0应税外加,1应税内tinyint 1 True

iPrintCount (U8100)打印次数int 4 True

dverifydate (U8100)审核日期datetime8 True

cVenPUOMProtocol (U870)收付款协议编码nvarchar20 True

iCreditPeriod (U870)账期int 4 True

PBVID (U861)采购发票主表标识int 4 False

cPBVBillType (U861)发票类型nvarchar 4 True

cPBVCode (U861)采购发票号nvarchar30 True

cPTCode (U861)采购类型编码nvarchar 2 True

dPBVDate (U861)开票日期datetime8 False

cVenCode (U861)供应商编码nvarchar20 True

cUnitCode (U861)代垫单位编码nvarchar30 True

cDepCode (U861)部门编码nvarchar12 True cPersonCode (U861)业务员编码nvarchar20 True cPayCode (U861)付款条件编码nvarchar 3 True cexch_name (U861)币种名称nvarchar8 True cExchRate (U861)汇率float8 True iPBVTaxRate (U861)表头税率float8 True cPBVMemo (U861)备注nvarchar60 True cOrderCode (U861)采购订单号nvarchar30 True cInCode (U861)对应入库单号nvarchar30 True cBusType (U861)业务类型nvarchar8 True dSDate (U861)结算日期datetime8 True cPBVMaker (U861)制单人nvarchar20 True cPBVVerifier (U861)审核人nvarchar20 True bNegative (U861)负发票标志bit 1 False bOriginal (U861)采购期初标志bit 1 False bFirst (U861)应付期初标志bit 1 False citem_class (U861)项目大类编码nvarchar 2 True citemcode (U861)项目编码nvarchar20 True cHeadCode (U861)科目编码nvarchar15 True iNetLock (U861)现无用real 4 True cDefine1 (U861)自定义项1 nvarchar20 True cDefine2 (U861)自定义项2 nvarchar20 True cDefine3 (U861)自定义项3 nvarchar20 True cDefine4 (U861)自定义项4 datetime8 True cDefine5 (U861)自定义项5 int 4 True cDefine6 (U861)自定义项6 datetime8 True cDefine7 (U861)自定义项7 float8 True cDefine8 (U861)自定义项8 nvarchar 4 True cDefine9 (U861)自定义项9 nvarchar8 True cDefine10 (U861)自定义项10 nvarchar60 True bPayment (U861)现付现结标志nvarchar20 True dVouDate (U861)单据日期datetime8 True iVTid (U861)单据模版号int 4 False ufts (U861)时间戳timestamp8 True cAccounter (U861)记账人nvarchar20 True cSource (U861)单据来源nvarchar 4 True cDefine11 (U861)自定义项11 nvarchar120 True cDefine12 (U861)自定义项12 nvarchar120 True cDefine13 (U861)自定义项13 nvarchar120 True cDefine14 (U861)自定义项14 nvarchar120 True cDefine15 (U861)自定义项15 int 4 True cDefine16 (U861)自定义项16 float8 True bIAFirst (U861)存货期初标志bit 1 True PurBillVouchs Table (PU 采购管理) [U861] 采购发票子表

Remark:采购及应付用专用发票、普通发票、运费发票、期初发票,采购发票可拷贝采购订

Column Name Description Datatype Length Allow Nulls cBG_CaliberKey5 (U8100)口径5类型编码nvarchar50 True iInvMPCost (U870)最高进价decimal13 True cBG_CaliberKey6 (U8100)口径6类型编码nvarchar50 True bCosting (U870)核算成本标志bit 1 True cBG_CaliberCode3 (U890)口径3编码nvarchar50 True cBG_CaliberCode1 (U890)口径1编码nvarchar50 True

inattaxprice (U871)本币含税单价userdecim

al 13 True

dlastretdate (U890)最后退税日期datetime8 True cBG_CaliberKeyName2 (U890)口径2类型名称nvarchar100 True cdescription (U871)委外工序nvarchar120 True iBG_Ctrl (U890)是否预算控制tinyint 1 True cConExecID (U890)合同执行单号nvarchar40 True

iinvexchrate (U871)换算率userdecim

al 13 True

cPZNum (U8100)凭证号nvarchar20 True cBG_Auditopinion (U890)审批意见nvarchar100 True dkeepdate (U8100)记账日期datetime8 True chyordercode (U871)委外加工单号nvarchar30 True iZbjMoney (U890)本币含税质保金money8 True bTaxCost (U871)价格标识bit 1 True cBG_CaliberKey2 (U890)口径2类型编码nvarchar50 True ihyorderdid (U871)委外加工单IDint 4 True opseq (U872)委外工序行号nchar 4 True cBG_CaliberName6 (U8100)口径6名称nvarchar100 True brettax (U890)退税申报tinyint 1 True

cBG_CaliberKeyName6 (U8100)口径6类型名称nvarchar100 True

fretmoney (U890)累计退税金额money8 True iOriTaxCost (U870)原币含税单价decimal13 True cBG_CaliberCode6 (U8100)口径6编码nvarchar90 True UpSoType (U870)上游单据类型nvarchar10 True cBG_CaliberKey3 (U890)口径3类型编码nvarchar50 True

cBG_CaliberKeyName5 (U8100)口径5类型名称nvarchar100 True

cBG_CaliberKeyName3 (U890)口径3类型名称nvarchar100 True iOriZbjMoney (U890)原币含税质保金money8 True cConRowID (U890)合同执行单行号nvarchar60 True cBG_CaliberKeyName1 (U890)口径1类型名称nvarchar100 True cBG_CaliberName1 (U890)口径1名称nvarchar100 True

cBG_CaliberKeyName4 (U8100)口径4类型名称nvarchar100 True

ContractRowNo (U871)合同行号nvarchar128 True copcode (U871)委外工序代码 nvarchar20 True cBG_CaliberName3 (U890)口径3名称nvarchar100 True cBG_CaliberName2 (U890)口径2名称nvarchar100 True cBG_CaliberCode2 (U890)口径2编码nvarchar50 True

fretquantity (U890)累计退税数量userdecim

al 13 True

cBAccounter (U870)采购发票表体记帐人nvarchar20 True

相关主题
相关文档 最新文档