想分析一下管家婆的财务部分的数据结构
CREATE TABLE [dbo].[atypecw] (
[typeId] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[parid] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[leveal] [smallint] NOT NULL ,
[sonnum] [int] NOT NULL ,
[soncount] [int] NOT NULL ,
[FullName] [varchar] (66) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserCode] [varchar] (26) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Comment] [varchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sysrow] [bit] NOT NULL ,
[deleted] [bit] NOT NULL ,
[Lend00] [decimal](18, 2) NOT NULL ,
[LendTTL01] [decimal](18, 2) NOT NULL ,
[LendTTL02] [decimal](18, 2) NOT NULL ,
[LendTTL03] [decimal](18, 2) NOT NULL ,
[LendTTL04] [decimal](18, 2) NOT NULL ,
[LendTTL05] [decimal](18, 2) NOT NULL ,
[LendTTL06] [decimal](18, 2) NOT NULL ,
[LendTTL07] [decimal](18, 2) NOT NULL ,
[LendTTL08] [decimal](18, 2) NOT NULL ,
[LendTTL09] [decimal](18, 2) NOT NULL ,
[LendTTL10] [decimal](18, 2) NOT NULL ,
[LendTTL11] [decimal](18, 2) NOT NULL ,
[LendTTL12] [decimal](18, 2) NOT NULL ,
[NAMEPY] [varchar] (66) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ParRec] [int] NOT NULL ,
[version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[direction] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Debit00] [decimal](18, 2) NOT NULL ,
[DebitTTL01] [decimal](18, 2) NOT NULL ,
[DebitTTL02] [decimal](18, 2) NOT NULL ,
[DebitTTL03] [decimal](18, 2) NOT NULL ,
[DebitTTL04] [decimal](18, 2) NOT NULL ,
[DebitTTL05] [decimal](18, 2) NOT NULL ,
[DebitTTL06] [decimal](18, 2) NOT NULL ,
[DebitTTL07] [decimal](18, 2) NOT NULL ,
[DebitTTL08] [decimal](18, 2) NOT NULL ,
[DebitTTL09] [decimal](18, 2) NOT NULL ,
[DebitTTL10] [decimal](18, 2) NOT NULL ,
[DebitTTL11] [decimal](18, 2) NOT NULL ,
[DebitTTL12] [decimal](18, 2) NOT NULL ,
[DebitTTL] [decimal](18, 2) NOT NULL ,
[LendTTL] [decimal](18, 2) NOT NULL ,
[DebitTTL00] [decimal](18, 2) NOT NULL ,
[LendTTL00] [decimal](18, 2) NOT NULL ,
[checkcash] [int] NOT NULL ,
[debit] [decimal](18, 2) NOT NULL ,
[lend] [decimal](18, 2) NOT NULL ,
[debit01] [decimal](18, 2) NOT NULL ,
[debit02] [decimal](18, 2) NOT NULL ,
[debit03] [decimal](18, 2) NOT NULL ,
[debit04] [decimal](18, 2) NOT NULL ,
[debit05] [decimal](18, 2) NOT NULL ,
[debit06] [decimal](18, 2) NOT NULL ,
[debit07] [decimal](18, 2) NOT NULL ,
[debit08] [decimal](18, 2) NOT NULL ,
[debit09] [decimal](18, 2) NOT NULL ,
[debit10] [decimal](18, 2) NOT NULL ,
[debit11] [decimal](18, 2) NOT NULL ,
[debit12] [decimal](18, 2) NOT NULL ,
[lend01] [decimal](18, 2) NOT NULL ,
[lend02] [decimal](18, 2) NOT NULL ,
[lend03] [decimal](18, 2) NOT NULL ,
[lend04] [decimal](18, 2) NOT NULL ,
[lend05] [decimal](18, 2) NOT NULL ,
[lend06] [decimal](18, 2) NOT NULL ,
[lend07] [decimal](18, 2) NOT NULL ,
[lend08] [decimal](18, 2) NOT NULL ,
[lend09] [decimal](18, 2) NOT NULL ,
[lend10] [decimal](18, 2) NOT NULL ,
[lend11] [decimal](18, 2) NOT NULL ,
[lend12] [decimal](18, 2) NOT NULL ,
[debitlend] [decimal](18, 2) NOT NULL ,
[iniatype] [int] NOT NULL ,
[JxcOnly] [bit] NOT NULL ,
[OrderNO] [int] NOT NULL ,
[CheckDep] [bit] NOT NULL ,
[CheckBtype] [bit] NOT NULL ,
[CheckEtype] [bit] NOT NULL ,
[CheckQty] [bit] NOT NULL ,
[CheckClient] [bit] NOT NULL ,
[QtyUnit] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Rec] [int] NOT NULL
) ON [PRIMARY]
GO
这个表结构是财务方面的,谁有研究过,这个表主要实现什么功能?TYPEID是会计科目
其中 lend00..lend01...lend12
lendTTL00..lendTTL01...lendTTL12
debit00..debit01...debit12
debitTTL00..debitTTL01...debitTTL12 这几组字段是干什么么?怎么应用?
CREATE TABLE [dbo].[atypecw] (
[typeId] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[parid] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[leveal] [smallint] NOT NULL ,
[sonnum] [int] NOT NULL ,
[soncount] [int] NOT NULL ,
[FullName] [varchar] (66) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserCode] [varchar] (26) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Comment] [varchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sysrow] [bit] NOT NULL ,
[deleted] [bit] NOT NULL ,
[Lend00] [decimal](18, 2) NOT NULL ,
[LendTTL01] [decimal](18, 2) NOT NULL ,
[LendTTL02] [decimal](18, 2) NOT NULL ,
[LendTTL03] [decimal](18, 2) NOT NULL ,
[LendTTL04] [decimal](18, 2) NOT NULL ,
[LendTTL05] [decimal](18, 2) NOT NULL ,
[LendTTL06] [decimal](18, 2) NOT NULL ,
[LendTTL07] [decimal](18, 2) NOT NULL ,
[LendTTL08] [decimal](18, 2) NOT NULL ,
[LendTTL09] [decimal](18, 2) NOT NULL ,
[LendTTL10] [decimal](18, 2) NOT NULL ,
[LendTTL11] [decimal](18, 2) NOT NULL ,
[LendTTL12] [decimal](18, 2) NOT NULL ,
[NAMEPY] [varchar] (66) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ParRec] [int] NOT NULL ,
[version] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[direction] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Debit00] [decimal](18, 2) NOT NULL ,
[DebitTTL01] [decimal](18, 2) NOT NULL ,
[DebitTTL02] [decimal](18, 2) NOT NULL ,
[DebitTTL03] [decimal](18, 2) NOT NULL ,
[DebitTTL04] [decimal](18, 2) NOT NULL ,
[DebitTTL05] [decimal](18, 2) NOT NULL ,
[DebitTTL06] [decimal](18, 2) NOT NULL ,
[DebitTTL07] [decimal](18, 2) NOT NULL ,
[DebitTTL08] [decimal](18, 2) NOT NULL ,
[DebitTTL09] [decimal](18, 2) NOT NULL ,
[DebitTTL10] [decimal](18, 2) NOT NULL ,
[DebitTTL11] [decimal](18, 2) NOT NULL ,
[DebitTTL12] [decimal](18, 2) NOT NULL ,
[DebitTTL] [decimal](18, 2) NOT NULL ,
[LendTTL] [decimal](18, 2) NOT NULL ,
[DebitTTL00] [decimal](18, 2) NOT NULL ,
[LendTTL00] [decimal](18, 2) NOT NULL ,
[checkcash] [int] NOT NULL ,
[debit] [decimal](18, 2) NOT NULL ,
[lend] [decimal](18, 2) NOT NULL ,
[debit01] [decimal](18, 2) NOT NULL ,
[debit02] [decimal](18, 2) NOT NULL ,
[debit03] [decimal](18, 2) NOT NULL ,
[debit04] [decimal](18, 2) NOT NULL ,
[debit05] [decimal](18, 2) NOT NULL ,
[debit06] [decimal](18, 2) NOT NULL ,
[debit07] [decimal](18, 2) NOT NULL ,
[debit08] [decimal](18, 2) NOT NULL ,
[debit09] [decimal](18, 2) NOT NULL ,
[debit10] [decimal](18, 2) NOT NULL ,
[debit11] [decimal](18, 2) NOT NULL ,
[debit12] [decimal](18, 2) NOT NULL ,
[lend01] [decimal](18, 2) NOT NULL ,
[lend02] [decimal](18, 2) NOT NULL ,
[lend03] [decimal](18, 2) NOT NULL ,
[lend04] [decimal](18, 2) NOT NULL ,
[lend05] [decimal](18, 2) NOT NULL ,
[lend06] [decimal](18, 2) NOT NULL ,
[lend07] [decimal](18, 2) NOT NULL ,
[lend08] [decimal](18, 2) NOT NULL ,
[lend09] [decimal](18, 2) NOT NULL ,
[lend10] [decimal](18, 2) NOT NULL ,
[lend11] [decimal](18, 2) NOT NULL ,
[lend12] [decimal](18, 2) NOT NULL ,
[debitlend] [decimal](18, 2) NOT NULL ,
[iniatype] [int] NOT NULL ,
[JxcOnly] [bit] NOT NULL ,
[OrderNO] [int] NOT NULL ,
[CheckDep] [bit] NOT NULL ,
[CheckBtype] [bit] NOT NULL ,
[CheckEtype] [bit] NOT NULL ,
[CheckQty] [bit] NOT NULL ,
[CheckClient] [bit] NOT NULL ,
[QtyUnit] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Rec] [int] NOT NULL
) ON [PRIMARY]
GO
这个表结构是财务方面的,谁有研究过,这个表主要实现什么功能?TYPEID是会计科目
其中 lend00..lend01...lend12
lendTTL00..lendTTL01...lendTTL12
debit00..debit01...debit12
debitTTL00..debitTTL01...debitTTL12 这几组字段是干什么么?怎么应用?
lend00..lend01...lend12 可能是1-12月的每月借方金额
lendTTL00..lendTTL01...lendTTL12 可能是1-12月的每月借方金额的期末结余debit00..debit01...debit12 可能是1-12月的每月贷方金额
debitTTL00..debitTTL01...debitTTL12 可能是1-12月的每月贷方金额的期末结余
因为,管家婆不能跨年记账,就是不能分析以前的旧帐,所以00 应该是每年期末结帐时上一年的年尾结余,
他们的真正关系是什么样呢?希望有研究过这个结构的人参加讨论