bd_accsubj_histry - 历史科目表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_accsubj_histry | 历史科目主健 | CHAR | Y | 20 | 0 | | | | |
accremove | 是否核销科目 | CHAR | | 1 | 0 | | | | |
altertype | 变更类型 | SMALLINT | | 2 | 0 | | | | |
balanflag | 余额方向控制 | CHAR | | 1 | 0 | N | | | |
balanorient | 余额方向 | SMALLINT | | 2 | 0 | 0 | | | |
beginperiod | 启用期间 | CHAR | | 2 | 0 | | | | |
beginyear | 启用年度 | CHAR | | 4 | 0 | | | | |
bothorient | 帐簿余额双向显示 | CHAR | | 1 | 0 | N | | | |
cashbankflag | 现金银行科目 | SMALLINT | | 2 | 0 | 0 | | | |
createcorp | 创建公司 | CHAR | | 4 | 0 | | | | |
createperiod | 创建月份 | CHAR | | 2 | 0 | | | | |
createyear | 创建年度 | CHAR | | 4 | 0 | | | | |
ctlsystem | 控制系统 | VARCHAR | | 80 | 0 | | | | |
currency | 科目默认币种 | CHAR | | 20 | 0 | | | | |
dispname | 显示名称 | VARCHAR | | 200 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
endflag | 末级标志 | CHAR | | 1 | 0 | | | | |
endperiod | 终止期间 | CHAR | | 2 | 0 | | | | |
endyear | 终止年度 | CHAR | | 4 | 0 | | | | |
engsubjname | 英文名称 | VARCHAR | | 100 | 0 | | | | |
free1 | 自由项1 | CHAR | | 20 | 0 | | | | |
free10 | 自由项10 | CHAR | | 20 | 0 | | | | |
free11 | 自由项11 | CHAR | | 20 | 0 | | | | |
free12 | 自由项12 | CHAR | | 20 | 0 | | | | |
free13 | 自由项13 | CHAR | | 20 | 0 | | | | |
free14 | 自由项14 | CHAR | | 20 | 0 | | | | |
free15 | 自由项15 | CHAR | | 20 | 0 | | | | |
free16 | 自由项16 | CHAR | | 20 | 0 | | | | |
free17 | 自由项17 | CHAR | | 20 | 0 | | | | |
free18 | 自由项18 | CHAR | | 20 | 0 | | | | |
free19 | 自由项19 | CHAR | | 20 | 0 | | | | |
free2 | 自由项2 | CHAR | | 20 | 0 | | | | |
free20 | 自由项20 | CHAR | | 20 | 0 | | | | |
free3 | 自由项3 | CHAR | | 20 | 0 | | | | |
free4 | 自由项4 | CHAR | | 20 | 0 | | | | |
free5 | 自由项5 | CHAR | | 20 | 0 | | | | |
free6 | 自由项6 | CHAR | | 20 | 0 | | | | |
free7 | 自由项7 | CHAR | | 20 | 0 | | | | |
free8 | 自由项8 | CHAR | | 20 | 0 | | | | |
free9 | 自由项9 | CHAR | | 20 | 0 | | | | |
incurflag | 发生额方向控制 | CHAR | | 1 | 0 | N | | | |
innerinfonull | 内部交易信息是否必录 | CHAR | | 1 | 0 | | | | |
innersubj | 内部交易科目 | CHAR | | 1 | 0 | | | | |
isstoped | 是否停用 | CHAR | | 1 | 0 | | | | |
outflag | 表外科目 | CHAR | | 1 | 0 | N | | | |
pk_accsubj | 科目主键 | CHAR | | 20 | 0 | | | | |
pk_alter_glorgbook | 变更主体账簿主键 | VARCHAR | | 20 | 0 | | | | |
pk_altercorp | 变更公司主健 | CHAR | | 4 | 0 | | | | |
pk_corp | 公司编码 | CHAR | | 4 | 0 | | | | |
pk_create_glorgbook | 创建会计主体账簿 | VARCHAR | | 20 | 0 | | | | |
pk_glorgbook | 会计主体账簿 | VARCHAR | | 20 | 0 | | | | |
pk_grpaccsubj | 对应集团科目 | CHAR | | 20 | 0 | | | | |
pk_roadmap | 路线主键 | CHAR | | 20 | 0 | | | | |
pk_subjscheme | 科目方案主键 | CHAR | | 20 | 0 | | | | |
pk_subjsys | 科目方案 | CHAR | | 20 | 0 | | | | |
pk_subjtype | 科目类型主键 | CHAR | | 20 | 0 | | | | |
property1 | 属性1 | VARCHAR | | 100 | 0 | | | | |
property2 | 属性2 | VARCHAR | | 100 | 0 | | | | |
property3 | 属性3 | VARCHAR | | 100 | 0 | | | | |
property4 | 属性4 | VARCHAR | | 100 | 0 | | | | |
property5 | 属性5 | VARCHAR | | 100 | 0 | | | | |
remcode | 助记码 | VARCHAR | | 50 | 0 | | | | |
sealflag | 封存标志 | CHAR | | 10 | 0 | | | | |
stoped | 停用标志 | CHAR | | 1 | 0 | | | | |
subjcode | 科目编码 | VARCHAR | | 40 | 0 | | | | |
subjlev | 科目级次 | SMALLINT | | 2 | 0 | | | | |
subjname | 科目名称 | VARCHAR | | 200 | 0 | | | | |
sumprint_level | 汇总打印级次 | SMALLINT | | 2 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
unit | 计量单位 | VARCHAR | | 10 | 0 | | | | |
外键列表
索引列表