引用自——http://blog.sina.com.cn/s/blog_15b9821340102wl4x.html
金蝶基础档案数据字典的sql语句
---------------------------------
--基础档案-02.客户表
select
t_Organization.FItemID As 客户内码 , t_Organization.FAddress As 地址 , t_Organization.FCity As 城市 , t_Organization.FProvince As 省份 , t_Organization.FCountry As 国家 , t_Organization.FPostalCode As 邮编 , t_Organization.FPhone As 电话号码 , t_Organization.FFax As 传真号 , t_Organization.FEmail As 邮件地址 , t_Organization.FHomePage As 公司主页 , t_Organization.FCreditLimit As 信用额度 , t_Organization.FTaxID As 未知17 , t_Organization.FBank As 开户银行 , t_Organization.FAccount As 银行账号 , t_Organization.FBankNumber As 未知22 , t_Organization.FBrNo As 公司代码 , t_Organization.FBoundAttr As 未知23 , t_Organization.FErpClsID As 产品类别 , t_Organization.FShortName As 客户简称 , t_Organization.FPriorityID As 未知10 , t_Organization.FPOGroupID As 未知8 , t_Organization.FStatus As 状态 , t_Organization.FLanguageID As 语言 , t_Organization.FRegionID As 区域代码 , t_Organization.FTrade As 行业代码 , t_Organization.FMinPOValue As 未知2 , t_Organization.FMaxDebitDate As 未知35 , t_Organization.FLegalPerson As 未知33 , t_Organization.FContact As 联系人 , t_Organization.FContactAcct As 对应会计科目 , t_Organization.FPhoneAcct As 未知7 , t_Organization.FFaxAcct As 未知30 , t_Organization.FZipAcct As 未知19 , t_Organization.FEmailAcct As 未知29 , t_Organization.FAddrAcct As 未知1 , t_Organization.FTax As 未知16 , t_Organization.FCyID As 结算币种1 , t_Organization.FSetID As 结算方式 , t_Organization.FSetDLineID As 未知12 , t_Organization.FTaxNum As 税务登记号 , t_Organization.FPriceClsID As 单价类别 , t_Organization.FOperID As 操作人ID , t_Organization.FCIQNumber As 海关代码 , t_Organization.FDeleted As 是否禁用 , t_Organization.FSaleMode As 销售模式 , t_Organization.FName As 客户名称 , t_Organization.FNumber As 客户代码 , t_Organization.FParentID As 上级内码 , t_Organization.FShortNumber As 客户简码 , t_Organization.FARAccountID As 应收账款科目代码 , t_Organization.FAPAccountID As 未知21 , t_Organization.FpreAcctID As 预收账款科目代码 , t_Organization.FlastTradeAmount As 未知32 , t_Organization.FlastRPAmount As 最后收款金额 , t_Organization.FfavorPolicy As 优惠政策 , t_Organization.Fdepartment As 分管部门 , t_Organization.Femployee As 专营业务员 , t_Organization.Fcorperate As 法人代表 , t_Organization.FbeginTradeDate As 开始交易日期 , t_Organization.FendTradeDate As 最后交易日期1 , t_Organization.FlastTradeDate As 最后交易日期2 , t_Organization.FlastReceiveDate As 最后收款日期 , t_Organization.FcashDiscount As 未知24 , t_Organization.FcurrencyID As 结算币种2 , t_Organization.FmaxDealAmount As 最大交易金额 , t_Organization.FminForeReceiveRate As 最小预收比率_ , t_Organization.FminReserverate As 最小订金比率_ , t_Organization.FdebtLevel As 偿债等级 , t_Organization.FCarryingAOS As 默认运输提前期_天 , t_Organization.FIsCreditMgr As 是否进行信用管理 , t_Organization.FCreditPeriod As 未知28 , t_Organization.FCreditLevel As 未知27 , t_Organization.FPayTaxAcctID As 应交税金科目代码 , t_Organization.FValueAddRate As 增值税率 , t_Organization.FTypeID As 客户分类 , t_Organization.FCreditDays As 未知26 , t_Organization.FCreditAmount As 未知25 , t_Organization.FStockIDAssign As 未知13 , t_Organization.FStockIDInst As 未知14 , t_Organization.FStockIDKeep As 未知15 , t_Organization.FPaperPeriod As 未知6 , t_Organization.FAlarmPeriod As 未知20 , t_Organization.FLicAndPermit As 未知34 , t_Organization.FOtherARAcctID As 未知5 , t_Organization.FOtherAPAcctID As 未知4 , t_Organization.FPreAPAcctID As 未知9 , t_Organization.FSaleID As 未知11 , t_Organization.FHelpCode As 未知31 , t_Organization.FModifyTime As 未知3 , t_Organization.FCreditDegree As 未知91 , t_Organization.F_102 As 未知92 , t_Organization.F_103 As 未知93 , t_Organization.F_104 As 未知94
from t_Organization
--更新客户分类为:终端客户
update t_Organization
set FTypeID = 40033
where FTypeID = 0
--基础档案-03.部门表
select
t_Department.FItemID As 部门内码 , t_Department.FBrNO As 公司代码 , t_Department.FManager As 负责人 , t_Department.FPhone As 电话 , t_Department.FFax As 传真 , t_Department.FNote As 备注 , t_Department.FNumber As 部门代码 , t_Department.FName As 部门名称 , t_Department.FParentID As 上级部门内码 , t_Department.FDProperty As 属性 , t_Department.FDStock As 部门库房 , t_Department.FDeleted As 是否禁用 , t_Department.FShortNumber As 部门简码 , t_Department.FAcctID As 科目内码 , t_Department.FCostAccountType As 成本核算类型 , t_Department.FModifyTime As 时间戳 , t_Department.FCalID As 工厂日历 , t_Department.FPlanArea As 计划区域 , t_Department.FOtherARAcctID As 其他应收账款科目代码 , t_Department.FOtherAPAcctID As 其他应付账款科目代码 , t_Department.FPreARAcctID As 预收账款科目代码 , t_Department.FPreAPAcctID As 预付账款科目代码 , t_Department.FIsCreditMgr As 是否进行信用管理 , t_Department.FHelpCode As 未知91
from t_Department
--基础档案-04.职员表
select
t_Emp.FItemID As 职员内码 , t_Emp.FGender As 性别 , t_Emp.FBirthday As 生日 , t_Emp.FEmail As 邮件地址 , t_Emp.FAddress As 地址 , t_Emp.FPhone As 电话 , t_Emp.FID As 身份证号码 , t_Emp.FDuty As 职务 , t_Emp.FDegree As 文化程度 , t_Emp.FHireDate As 入职日期 , t_Emp.FLeaveDate As 离职日期 , t_Emp.FEmpGroupID As 职员组代码 , t_Emp.FItemDepID As 部门号 , t_Emp.FBankID As 银行 , t_Emp.FBankAccount As 银行账号 , t_Emp.FNote As 备注 , t_Emp.FBrNO As 公司代码 , t_Emp.FName As 姓名 , t_Emp.FParentID As 上级代码 , t_Emp.FDeleted As 是否禁用 , t_Emp.FDepartmentID As 部门内码 , t_Emp.FEmpGroup As 职员组名称 , t_Emp.FNumber As 职员代码 , t_Emp.FShortNumber As 职员简码 , t_Emp.FIsCreditMgr As 是否进行信用管理 , t_Emp.FCreditPeriod As 信用期 , t_Emp.FCreditLevel As 信用级次 , t_Emp.FProfessionalGroup As 业务组 , t_Emp.FOperationGroup As 未知91 , t_Emp.FModifyTime As 未知1 , t_Emp.FJobTypeID As 工种 , t_Emp.FAllotPercent As 分配率 , t_Emp.FCreditDays As 未知92 , t_Emp.FCreditAmount As 未知93 , t_Emp.FOtherARAcctID As 未知94 , t_Emp.FOtherAPAcctID As 未知95 , t_Emp.FPreARAcctID As 未知96 , t_Emp.FPreAPAcctID As 未知97 , t_Emp.FHelpCode As 未知98
from t_Emp
--基础档案-05.产品表
select
t_ICItem.FItemID As 产品内码 , t_ICItem.FName As 产品名称 , t_ICItem.FHelpCode As 助记码 , t_ICItem.FDeleted As 是否禁用 , t_ICItem.FShortNumber As 产品简码 , t_ICItem.FNumber As 产品代码 , t_ICItem.FModifyTime As 未知3 , t_ICItem.FParentID As 产品类代码 , t_ICItem.FBrNo As 公司代码 , t_ICItem.FTopID As 最高级 , t_ICItem.FRP As 收付标志 , t_ICItem.FOmortize As 未知4 , t_ICItem.FOmortizeScale As 未知5 , t_ICItem.FForSale As 是否销售1 , t_ICItem.FStaCost As 未知9 , t_ICItem.FOrderPrice As 订货单价 , t_ICItem.FOrderMethod As 订货方法 , t_ICItem.FPriceFixingType As 未知7 , t_ICItem.FSalePriceFixingType As 未知8 , t_ICItem.FPerWastage As 未知6 , t_ICItem.FARAcctID As 应收科目 , t_ICItem.FPlanPriceMethod As 计划方法 , t_ICItem.FPlanClass As 计划类型 , t_ICItem.FModel As 规格型号 , t_ICItem.FAlias As 别名 , t_ICItem.FApproveNo As 批准文号 , t_ICItem.FAuxClassID As 辅助属性类别 , t_ICItem.FDefaultLoc As 缺省库房 , t_ICItem.FEquipmentNum As 设备编码 , t_ICItem.FErpClsID As 产品属性 , t_ICItem.FFullName As 全名 , t_ICItem.FHighLimit As 最高存量 , t_ICItem.FIsEquipment As 是否设备 , t_ICItem.FIsSparePart As 是否备件 , t_ICItem.FLowLimit As 最低存量 , t_ICItem.FOrderUnitID As 采购计量单位 , t_ICItem.FPreDeadLine As 未知91 , t_ICItem.FProductUnitID As 生产计量单位 , t_ICItem.FQtyDecimal As 数量精度 , t_ICItem.FSaleUnitID As 销售计量单位 , t_ICItem.FSecCoefficient As 辅助计量单位换算率 , t_ICItem.FSecUnitDecimal As 未知92 , t_ICItem.FSecInv As 安全库存 , t_ICItem.FSecUnitID As 辅助计量单位 , t_ICItem.FSerialClassID As 未知93 , t_ICItem.FSource As 来源 , t_ICItem.FSPID As 缺省仓位 , t_ICItem.FStoreUnitID As 库存计量单位 , t_ICItem.FTypeID As 产品分类 , t_ICItem.FUnitGroupID As 单位组内码 , t_ICItem.FUnitID As 单位内码 , t_ICItem.FUseState As 使用状态 , t_ICItem.FABCCls As ABC类别 , t_ICItem.FAcctID As 存货科目 , t_ICItem.FAdminAcctID As 代管物资科目 , t_ICItem.FAPAcctID As 应付科目 , t_ICItem.FBatchManager As 是否采用业务批次管理 , t_ICItem.FBatchQty As 订货批量 , t_ICItem.FBeforeExpire As 失效提前期_天 , t_ICItem.FBookPlan As 是否需要进行订补货计划的运算 , t_ICItem.FCheckCycle As 盘点周期 , t_ICItem.FCheckCycUnit As 盘点周期单位 , t_ICItem.FClass As 产品类别 , t_ICItem.FCostAcctID As 成本科目 , t_ICItem.FCostDiffRate As 成本差异科目 , t_ICItem.FCostProject As 成本项目 , t_ICItem.FDaysPer As 每周月第_天 , t_ICItem.FDepartment As 部门 , t_ICItem.FGoodSpec As 税目代码内码 , t_ICItem.FISKFPeriod As 是否进行保质期管理 , t_ICItem.FIsSale As 是否销售2 , t_ICItem.FIsSnManage As 未知2 , t_ICItem.FIsSpecialTax As 是否农林计税 , t_ICItem.FKFPeriod As 保质期_天 , t_ICItem.FLastCheckDate As 上次盘点日期 , t_ICItem.FNote As 备注 , t_ICItem.FOIHighLimit As 外购超收比例_ , t_ICItem.FOILowLimit As 外购欠收比例_ , t_ICItem.FOrderRector As 采购负责人内码 , t_ICItem.FPlanPrice As 计划单价 , t_ICItem.FPOHghPrcMnyType As 采购最高价币别 , t_ICItem.FPOHighPrice As 采购最高价 , t_ICItem.FPriceDecimal As 单价精度 , t_ICItem.FProfitRate As 毛利率 , t_ICItem.FSaleAcctID As 销售科目 , t_ICItem.FSalePrice As 销售单价 , t_ICItem.FSaleTaxAcctID As 税金科目 , t_ICItem.FSOHighLimit As 销售超交比例_ , t_ICItem.FSOLowLimit As 销售欠交比例_ , t_ICItem.FSOLowPrc As 销售最低价 , t_ICItem.FSOLowPrcMnyType As 销售最低价币别 , t_ICItem.FStockPrice As 未知98 , t_ICItem.FStockTime As 是否需要库龄管理 , t_ICItem.FTaxRate As 税率_ , t_ICItem.FTrack As 计价方法 , t_ICItem.FWWHghPrc As 委外加工最高价 , t_ICItem.FWWHghPrcMnyType As 委外加工最高价币别 , t_ICItem.FCBBmStandardID As 分配标准内码 , t_ICItem.FBatChangeEconomy As 变动提前期批量 , t_ICItem.FBatchAppendQty As 批量增量 , t_ICItem.FBatFixEconomy As 固定经济批量 , t_ICItem.FCUUnitID As 常用计量单位 , t_ICItem.FDailyConsume As 日消耗量 , t_ICItem.FDefaultRoutingID As 默认工艺路线 , t_ICItem.FDefaultWorkTypeID As 默认生产类型 , t_ICItem.FFixLeadTime As 固定提前期 , t_ICItem.FInHighLimit As 完工超收比例_ , t_ICItem.FInLowLimit As 完工欠收比例_ , t_ICItem.FLeadTime As 提前期 , t_ICItem.FLowestBomCode As 低层码 , t_ICItem.FMRPCon As MRP计算是否合并需求 , t_ICItem.FOrderInterVal As 订货间隔期_天 , t_ICItem.FOrderPoint As 再订货点 , t_ICItem.FOrderTrategy As 订货策略 , t_ICItem.FPlanner As 计划员 , t_ICItem.FPlanPoint As 计划时界_天 , t_ICItem.FPlanTrategy As 计划策略 , t_ICItem.FProductPrincipal As 生产负责人 , t_ICItem.FPutInteger As 投料自动取整 , t_ICItem.FQtyMax As 最大订货量 , t_ICItem.FQtyMin As 最小订货量 , t_ICItem.FRequirePoint As 需求时界_天 , t_ICItem.FTotalTQQ As 累计提前期 , t_ICItem.FMRPOrder As MRP计算是否产生采购申请 , t_ICItem.F_105 As 未知94 , t_ICItem.F_106 As 未知95 , t_ICItem.F_107 As 未知96 , t_ICItem.F_108 As 未知97 , t_ICItem.FChartNumber As 图号 , t_ICItem.FCubicMeasure As 长度单位 , t_ICItem.FGrossWeight As 毛重 , t_ICItem.FHeight As 高度 , t_ICItem.FIsKeyItem As 是否关键件 , t_ICItem.FLength As 长度 , t_ICItem.FMaund As 重量单位 , t_ICItem.FNetWeight As 净重 , t_ICItem.FSize As 体积 , t_ICItem.FVersion As 版本号 , t_ICItem.FWidth As 宽度 , t_ICItem.FChgFeeRate As 变动制造费用分配率 , t_ICItem.FOutMachFee As 单位委外加工费 , t_ICItem.FPieceRate As 单位计件工资 , t_ICItem.FStandardCost As 单位标准成本 , t_ICItem.FStandardManHour As 单位标准工时_小时 , t_ICItem.FStdFixFeeRate As 单位标准固定制造费用金额 , t_ICItem.FStdPayRate As 标准工资率 , t_ICItem.FIdentifier As 检验员 , t_ICItem.FInspectionLevel As 检验方式 , t_ICItem.FInspectionProject As 检验方案 , t_ICItem.FIsListControl As 未知1 , t_ICItem.FOtherChkMde As 其他检验方式 , t_ICItem.FProChkMde As 产品检验方式 , t_ICItem.FSOChkMde As 发货检验方式 , t_ICItem.FStkChkAlrm As 库存周期检验预警提前期_天 , t_ICItem.FStkChkMde As 库存检验方式 , t_ICItem.FStkChkPrd As 库存检验周期_天 , t_ICItem.FWthDrwChkMde As 退货检验方式 , t_ICItem.FWWChkMde As 委外加工检验方式
from t_ICItem
--基础档案-06.仓库表
select
t_Stock.FItemID As 库房内码 , t_Stock.FBrNO As 公司代码 , t_Stock.FHelpCode As 未知91 , t_Stock.FEmpID As 管理员 , t_Stock.FAddress As 库房地址 , t_Stock.FPhone As 库房电话 , t_Stock.FProperty As 库房属性 , t_Stock.FBWorkShop As 是否为车间仓库 , t_Stock.FName As 库房名称 , t_Stock.FNumber As 库房代码 , t_Stock.FParentID As 上级内码 , t_Stock.FDeleted As 是否禁用 , t_Stock.FShortNumber As 库房简码 , t_Stock.FTypeID As 库房类型 , t_Stock.FIsStockMgr As 是否进行仓位管理 , t_Stock.FSPGroupID As 仓位组ID1 , t_Stock.FMRPAvail As 是否MRP可用量 , t_Stock.FGroupID As 组ID , t_Stock.FStockGroupID As 仓位组ID2 , t_Stock.FModifyTime As 修改时间戳 , t_Stock.FCalcCostOrder As 成本计算顺序 , t_Stock.FPlanArea As 计划区域
from t_Stock
--基础档案-07.币别表
select
t_Currency.FCurrencyID As 币别内码 , t_Currency.FNumber As 币别代码 , t_Currency.FName As 币别名称 , t_Currency.FOperator As 运算符 , t_Currency.FExchangeRate As 汇率 , t_Currency.FScale As 小数位数 , t_Currency.FFixRate As 换算率 , t_Currency.FBrNo As 公司代码 , t_Currency.FControl As 未知91 , t_Currency.FDeleted As 是否禁用 , t_Currency.FModifyTime As 未知92 , t_Currency.FSystemType As 未知93 , t_Currency.UUID As 未知94
from t_Currency
--基础档案-08.科目档案
select
t_Account.FAccountID As 科目内码 , t_Account.FNumber As 科目代码 , t_Account.FName As 科目名称 , t_Account.FLevel As 科目级次 , t_Account.FDetail As 明细科目_1是_0否 , t_Account.FParentID As 顶级_即1级科目内码 , t_Account.FRootID As 上级科目内码 , t_Account.FGroupID As 科目类别内码 , t_Account.FDC As 借贷方向_1借_负1贷 , t_Account.FHelperCode As 助记码 , t_Account.FCurrencyID As 币别内码_0核算所有_1不核算 , t_Account.FAdjustRate As 期末调汇 , t_Account.FEarnAccountID As 利润科目内码 , t_Account.FQuantities As 数量辅助核算 , t_Account.FUnitGroupID As 单位组内码 , t_Account.FMeasureUnitID As 单位内码 , t_Account.FIsCash As 现金类科目 , t_Account.FIsBank As 银行类科目 , t_Account.FJournal As 输出明细账 , t_Account.FContact As 往来核算 , t_Account.FIsCashFlow As 现金等价物 , t_Account.FDetailID As 核算项目内码 , t_Account.FAcnt As 核算项目 , t_Account.FLoan As 贷款科目 , t_Account.FDpst As 定期存款 , t_Account.FStatedDpst As 活期存款 , t_Account.FInterest As 是否利息科目 , t_Account.FIsAcnt As 是否账号 , t_Account.FIsBudget As 是否预算科目 , t_Account.FAcntID As 账号 , t_Account.FBrNo As 公司代码 , t_Account.FAcctint As 是否计息 , t_Account.FintRate As 利息率 , t_Account.FLastintDate As 计息时间 , t_Account.FAcntType As 账户类型 , t_Account.FTradeNum As 集团控制科目代码 , t_Account.FControl As 未知1 , t_Account.FViewMsg As 未知5 , t_Account.FMessage As 未知3 , t_Account.FDelete As 是否禁用 , t_Account.FIsBusi As 未知2 , t_Account.FFullName As 科目全名 , t_Account.FModifyTime As 未知4 , t_Account.FSystemType As 系统标示 , t_Account.FControlSystem As 未知91 , t_Account.UUID As 未知6
from t_Account
--基础档案-09.结算方式
select
t_Settle.FBrNo As 公司代码 , t_Settle.FItemID As 结算方式内码 , t_Settle.FName As 结算方式名称 , t_Settle.FStatus As 状态 , t_Settle.FNumber As 结算方式代码 , t_Settle.FDeleted As 是否禁用 , t_Settle.FAcctID As 科目ID , t_Settle.FControl As 未知91 , t_Settle.FSystemType As 未知92 , t_Settle.FModifyTime As 未知93 , t_Settle.UUID As 未知94
from t_Settle
--基础档案-10.计量单位
select
t_MeasureUnit.FMeasureUnitID As 单位内码 , t_MeasureUnit.FUnitGroupID As 单位组别 , t_MeasureUnit.FNumber As 单位代码 , t_MeasureUnit.FAuxClass As 未知1 , t_MeasureUnit.FName As 单位名称 , t_MeasureUnit.FConversation As 未知3 , t_MeasureUnit.FCoefficient As 系数 , t_MeasureUnit.FPrecision As 未知5 , t_MeasureUnit.FBrNo As 公司代码 , t_MeasureUnit.FItemID As 单位内码二 , t_MeasureUnit.FParentID As 上级内码 , t_MeasureUnit.FDeleted As 是否禁用 , t_MeasureUnit.FShortNumber As 单位简码 , t_MeasureUnit.FOperDate As 操作日期 , t_MeasureUnit.FScale As 修正值 , t_MeasureUnit.FStandard As 基本单位 , t_MeasureUnit.FControl As 未知2 , t_MeasureUnit.FModifyTime As 未知4 , t_MeasureUnit.FSystemType As 系统标示 , t_MeasureUnit.UUID As 未知6
from t_MeasureUnit
--基础档案-12.基础资料类别表(核算项目类别表)
select
t_ItemClass.FItemClassID As 类别内码 , t_ItemClass.FNumber As 类别代码 , t_ItemClass.FName As 类别名称 , t_ItemClass.FName_cht As 未知91 , t_ItemClass.FName_en As 未知92 , t_ItemClass.FSQLTableName As 表名 , t_ItemClass.FVersion As 版本号 , t_ItemClass.FImport As 外部引入 , t_ItemClass.FBrNo As 公司代码 , t_ItemClass.FUserDefilast As 操作员 , t_ItemClass.FType As 类型 , t_ItemClass.FGRType As 集团控制类别 , t_ItemClass.FRemark As 备注 , t_ItemClass.FModifyTime As 未知1 , t_ItemClass.FGrControl As 未知93 , t_ItemClass.UUID As 统一ID
from t_ItemClass
--基础档案-13.基础资料主表(核算项目主表)
select
t_Item.FItemID As ID号 , t_Item.FItemClassID As 类型ID号 , t_Item.FExternID As 外键ID , t_Item.FNumber As 编码 , t_Item.FParentID As 父ID , t_Item.FLevel As 级别 , t_Item.FDetail As 是否明细 , t_Item.FName As 名称 , t_Item.FUnUsed As 是否使用 , t_Item.FBrNo As 公司代码 , t_Item.FFullNumber As 全编码 , t_Item.FDiff As 未知91 , t_Item.FDeleted As 是否删除 , t_Item.FShortNumber As 短代码 , t_Item.FFullName As 全名 , t_Item.UUID As UUID , t_Item.FGRCommonID As 未知92 , t_Item.FSystemType As 系统类型 , t_Item.FUseSign As 使用标记 , t_Item.FChkUserID As 审核人ID , t_Item.FGrControl As 下发受控类型 , t_Item.FModifyTime As 修改时间
from t_Item
--基础档案-14.辅助资料类别表(辅助资料类别的内码是系统自动生成的)
select
t_SubMesType.FTypeID As 类型内码 , t_SubMesType.FName As 类型名称 , t_SubMesType.FDetail As 明细标志 , t_SubMesType.FType As 类型 , t_SubMesType.FGRType As 集团统管账套标志 , t_SubMesType.FModifyTime As 未知1 , t_SubMesType.UUID As 未知2
from t_SubMesType
--基础档案-15.辅助资料表(辅助资料表)
select
t_SubMessage.FBrNo As 公司代码 , t_SubMessage.FInterID As 资料內码 , t_SubMessage.FID As 资料代码 , t_SubMessage.FParentID As 上级内码 , t_SubMessage.FName As 资料名称 , t_SubMessage.FTypeID As 类型内码 , t_SubMessage.FDetail As 是否明细 , t_SubMessage.FDeleted As 是否禁用 , t_SubMessage.FModifyTime As 未知1 , t_SubMessage.FSystemType As 系统标示 , t_SubMessage.FSpec As 未知91 , t_SubMessage.UUID As 未知2
from t_SubMessage
--基础档案-16.核算项目附表信息描述表(主要是用来对默认核算项目数据字典的说明;字段间的相互关联的关系)
select
t_ItemPropDesc.FItemClassID As 核算项目类别内码 , t_ItemPropDesc.FPropID As 字段序号 , t_ItemPropDesc.FName As 字段名称 , t_ItemPropDesc.FName_Cht As 未知91 , t_ItemPropDesc.FName_en As 未知92 , t_ItemPropDesc.FSQLColumnName As 字段数据库名称 , t_ItemPropDesc.FDataType As 字段数据类型 , t_ItemPropDesc.FPrecision As 数据精度 , t_ItemPropDesc.FScale As 小数位数 , t_ItemPropDesc.FActualType As 字段实际类型 , t_ItemPropDesc.FActualSize As 字段实际大小 , t_ItemPropDesc.FBehavior As 系统预留 , t_ItemPropDesc.FBrNo As 公司代码 , t_ItemPropDesc.FSearch As 字段关联内码 , t_ItemPropDesc.FAction As 作用 , t_ItemPropDesc.FSaveRule As 保存规则 , t_ItemPropDesc.FDefaultValue As 字段默认值 , t_ItemPropDesc.FSrcTable As 字段关联表 , t_ItemPropDesc.FSrcField As 关联表字段 , t_ItemPropDesc.FDisplayField As 关联表显示字段 , t_ItemPropDesc.FViewMask As 使用控制标志 , t_ItemPropDesc.FFilterField As 受控行号 , t_ItemPropDesc.FPageName As 所属页名 , t_ItemPropDesc.FPageName_Cht As 未知93 , t_ItemPropDesc.FPageName_en As 未知94 , t_ItemPropDesc.FComCall As 事件触发 , t_ItemPropDesc.FIsShownList As 是否在表中显示 , t_ItemPropDesc.FIsInput As 未知95 , t_ItemPropDesc.FIsDisplay As 未知96 , t_ItemPropDesc.FModifyTime As 未知1
from t_ItemPropDesc
--************************************************************************************************
--------------------------------------------------------------------------------------------------
--基础档案-15.辅助资料表_连接_14.辅助资料类别表<注意:不含结算方式:结算方式是独立的一个数据表:t_Settle>
select
t_SubMessage.FBrNo As 公司代码 , t_SubMessage.FInterID As 资料內码 , t_SubMessage.FID As 资料代码 , t_SubMessage.FParentID As 上级内码 , t_SubMessage.FName As 资料名称 , t_SubMessage.FTypeID As 类型内码 , t_SubMessage.FDetail As 是否明细 , t_SubMessage.FDeleted As 是否禁用 ,
t_SubMesType.FName As 类型名称 , t_SubMesType.FDetail As 明细标志
from t_SubMessage
left outer join t_SubMesType on t_SubMessage.FTypeID = t_SubMesType.FTypeID
--where t_SubMesType.FName = '文化程度' --辅助资料--文化程度
--where t_SubMesType.FName = '行业' --辅助资料--行业
--where t_SubMesType.FName = '区域' --辅助资料--区域
--where t_SubMesType.FName = '供应商分类' --辅助资料--供应商分类
--where t_SubMesType.FName = '职务' --辅助资料--职务
--where t_SubMesType.FName = '职员类别' --辅助资料--职员类别
--where t_SubMesType.FName = '交货方式' --辅助资料--交货方式
--where t_SubMesType.FName = '客户分类' --辅助资料--客户分类
-------
--where t_SubMessage.FParentID = '101' --辅助资料--销售方式 :现销/赊销/分期收款销售/委托代销
--where t_SubMessage.FParentID = '102' --辅助资料--性别 :男/女
--where t_SubMessage.FParentID = '103' --辅助资料--入库类型 :外购入库/委外加工入库
--where t_SubMessage.FParentID = '104' --辅助资料--费用发票类型 :应付费用发票/应收费用发票
--where t_SubMessage.FParentID = '106' --辅助资料--出库类型 :销售出库/受托出库
--where t_SubMessage.FParentID = '160' --辅助资料--仓库类型 :普通仓/虚仓/其他
--where t_SubMessage.FParentID = '162' --辅助资料--采购类型 :现购/赊购
--where t_SubMessage.FParentID = '165' --辅助资料--默认核算项目 :客户/供应商/部门/职员(一般不用)
order by t_SubMessage.FTypeID ,t_SubMessage.FParentID,t_SubMessage.FInterID
--为了方便以后写sql语句时,做连接,可以将辅助资料,做成各类型的视图或者用嵌套语句,将辅助项目表分别命名为不同的别名表,进行连接
--------------------------------------------------------------------------------------------------
--基础档案-13.基础资料主表(核算项目主表)_连接_12.基础资料类别表(核算项目类别表)<注意:不含计量单位:计量单位是独立的一个数据表:t_MeasureUnit>
select
t_Item.FItemID As ID号 , t_Item.FItemClassID As 类型ID号 , t_Item.FNumber As 编码 , t_Item.FParentID As 父ID , t_Item.FLevel As 级别 , t_Item.FDetail As 是否明细 , t_Item.FName As 名称 , t_Item.FFullNumber As 全编码 ,
t_ItemClass.FItemClassID As 类别内码 , t_ItemClass.FNumber As 类别代码 , t_ItemClass.FName As 类别名称 , t_ItemClass.FSQLTableName As 表名 , t_ItemClass.FType As 类型
from t_Item left outer join t_ItemClass on t_Item.FItemClassID = t_ItemClass.FItemClassID
--where t_ItemClass.FName = '客户' --核算项目--客户:类别内码: 1
--where t_ItemClass.FName = '部门' --核算项目--部门:类别内码: 2
--where t_ItemClass.FName = '职员' --核算项目--职员:类别内码: 3
--where t_ItemClass.FName = '物料' --核算项目--物料:类别内码: 4
--where t_ItemClass.FName = '仓库' --核算项目--仓库:类别内码: 5
--where t_ItemClass.FName = '计量单位' --核算项目--计量单位:内码: 7
--where t_ItemClass.FName = '供应商' --核算项目--供应商 :内码: 8
--where t_ItemClass.FName = '现金流量项目' --核算项目--现金流量项目: 9
--where t_ItemClass.FName = '*成本对象' --核算项目--成本对象: 2001
--where t_ItemClass.FName = '*成本项目' --核算项目--成本项目: 2003
--where t_ItemClass.FName = '*要素费用' --核算项目--要素费用: 2004
--where t_ItemClass.FName = '*成本对象' --核算项目--成本对象: 2001
----------------------------------------
where t_ItemClass.FNumber = '51' --核算项目--自定义项目:省份 取自核算项目档案中,的人工输入的类别编码
内容来源于网络如有侵权请私信删除
- 还没有人评论,欢迎说说您的想法!