科目扩展设置
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| headerpubuserdefdecm5 (T+12.1) | 表头公有自定义项5 | decimal | 13 | True | |
| detailspriuserdefnvc0 (T+12.1) | 表体私有自定义项0 | nvarchar | 500 | True | |
| TaxRate (T+12.3) | 税率 | decimal | 13 | True | |
| detailspubuserdefnvc3 (T+12.1) | 表体公有自定义项3 | nvarchar | 500 | True | |
| inventorypriuserdefdecm3 (T+12.1) | 存货私有自定义项3 | decimal | 13 | True | |
| isreplaced (T+12.2) | 是否赠品 | int | 4 | True | |
| idvouchertype (T+12.1) | 单据类型id | int | 4 | True | |
| expensetype (T+12.1) | 费用类型 | int | 4 | True | |
| rowidx (T+12.1) | 行索引 | int | 4 | True | |
| Detailspubuserdefdecm4 (T+12.3) | 表体公有自定义项4 | decimal | 13 | True | |
| inventorypriuserdefnvc3 (T+12.1) | 存货私有自定义项字符型3 | nvarchar | 500 | True | |
| accountcode (T+12.1) | 科目编码 | nvarchar | 50 | True | |
| headerpriuserdefdecm4 (T+12.1) | 表头私有自定义项4 | decimal | 13 | True | |
| Detailspubuserdefnvc4 (T+12.3) | 表体公有自定义项4 | nvarchar | 500 | True | |
| ExpressionName (T+12.1) | 表达式名称 | nvarchar | 200 | True | |
| detailspriuserdefdecm3 (T+12.1) | 表体私有自定义项3 | decimal | 13 | True | |
| adjusttype (T+12.1) | 调整类型 | int | 4 | True | |
| inventorypriuserdefnvc1 (T+12.1) | 存货私有自定义项字符型1 | nvarchar | 500 | True | |
| IdSettleStyle (T+12.1) | 结算方式id | int | 4 | True | |
| inventorypriuserdefdecm4 (T+12.1) | 存货私有自定义项4 | decimal | 13 | True | |
| idinventory (T+12.1) | 存货id | int | 4 | True | |
| headerpubuserdefnvc3 (T+12.1) | 表头公有自定义项3 | nvarchar | 500 | True | |
| headerpriuserdefnvc3 (T+12.1) | 表头私有自定义项3 | nvarchar | 500 | True | |
| idexpenseitem (T+12.1) | 费用id | int | 4 | True | |
| headerpubuserdefnvc1 (T+12.1) | 表头公有自定义项1 | nvarchar | 500 | True | |
| inventorypriuserdefdecm2 (T+12.1) | 存货私有自定义项2 | decimal | 13 | True | |
| iddepartment (T+12.1) | 部门id | int | 4 | True | |
| headerpriuserdefdecm0 (T+12.1) | 表头私有自定义项0 | decimal | 13 | True | |
| detailspubuserdefdecm3 (T+12.1) | 表体公有自定义项3 | decimal | 13 | True | |
| inventorypriuserdefnvc4 (T+12.1) | 存货私有自定义项字符型4 | nvarchar | 500 | True | |
| accountname (T+12.1) | 科目名称 | nvarchar | 50 | True | |
| detailspubuserdefdecm2 (T+12.1) | 表体公有自定义项2 | decimal | 13 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| idassetProp (T+12.1) | 资产属性id | int | 4 | True | |
| inventorypriuserdefdecm1 (T+12.1) | 存货私有自定义项1 | decimal | 13 | True | |
| detailspriuserdefdecm0 (T+12.1) | 表体私有自定义项0 | decimal | 13 | True | |
| idinventoryclass (T+12.1) | 存货分类id | int | 4 | True | |
| islaborcost (T+12.1) | 是否劳务费用 | tinyint | 1 | True | |
| idassetClass (T+12.1) | 资产类别id | int | 4 | True | |
| detailspriuserdefnvc1 (T+12.1) | 表体私有自定义项1 | nvarchar | 500 | True | |
| idaccount (T+12.1) | 科目id | int | 4 | True | |
| headerpriuserdefdecm3 (T+12.1) | 表头私有自定义项3 | decimal | 13 | True | |
| headerpriuserdefnvc1 (T+12.1) | 表头私有自定义项1 | nvarchar | 500 | True | |
| idhandleReason (T+12.1) | 处置原因id | int | 4 | True | |
| inventorypriuserdefdecm0 (T+12.1) | 存货私有自定义项0 | decimal | 13 | True | |
| incomeExpensesType (T+12.1) | 收支类型 | int | 4 | True | |
| detailspubuserdefnvc2 (T+12.1) | 表体公有自定义项2 | nvarchar | 500 | True | |
| idincome (T+12.1) | 收入id | int | 4 | True | |
| idwarehouse (T+12.1) | 仓库id | int | 4 | True | |
| detailspriuserdefnvc2 (T+12.1) | 表体私有自定义项2 | nvarchar | 500 | True | |
| idbankaccount (T+12.1) | 账号id | int | 4 | True | |
| detailspubuserdefnvc1 (T+12.1) | 表体公有自定义项1 | nvarchar | 500 | True | |
| sequencenumber (T+12.1) | 顺序号 | int | 4 | True | |
| summary (T+12.1) | 摘要 | nvarchar | 200 | True | |
| headerpriuserdefdecm1 (T+12.1) | 表头私有自定义项1 | decimal | 13 | True | |
| headerpriuserdefdecm5 (T+12.1) | 表头私有自定义项5 | decimal | 13 | True | |
| headerpubuserdefnvc2 (T+12.1) | 表头公有自定义项2 | nvarchar | 500 | True | |
| headerpriuserdefdecm2 (T+12.1) | 表头私有自定义项2 | decimal | 13 | True | |
| headerpubuserdefdecm4 (T+12.1) | 表头公有自定义项4 | decimal | 13 | True | |
| headerpubuserdefnvc4 (T+12.1) | 表头公有自定义项4 | nvarchar | 500 | True | |
| inventorypriuserdefnvc2 (T+12.1) | 存货私有自定义项字符型2 | nvarchar | 500 | True | |
| idbusitype (T+12.1) | 业务类型id | int | 4 | True | |
| idincDecWay (T+12.1) | 增减方式id | int | 4 | True | |
| headerpubuserdefdecm3 (T+12.1) | 表头公有自定义项3 | decimal | 13 | True | |
| headerpriuserdefnvc4 (T+12.1) | 表头私有自定义项4 | nvarchar | 500 | True | |
| idrdstyle (T+12.1) | 出入库类别id | int | 4 | True | |
| detailspubuserdefdecm1 (T+12.1) | 表体公有自定义项1 | decimal | 13 | True | |
| headerpriuserdefnvc2 (T+12.1) | 表头私有自定义项2 | nvarchar | 500 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| checkstate (T+12.1) | 盘点结果 | int | 4 | True | |
| idproject (T+12.1) | 项目id | int | 4 | True | |
| headerpriuserdefnvc0 (T+12.1) | 表头私有自定义项0 | nvarchar | 500 | True | |
| headerpubuserdefdecm2 (T+12.1) | 表头公有自定义项2 | decimal | 13 | True | |
| idprojectClass (T+12.1) | 项目分类id | int | 4 | True | |
| Headerpubuserdefnvc6 (T+12.3) | 表头公有自定义项6 | nvarchar | 500 | True | |
| headerpubuserdefnvc5 (T+12.1) | 表头公有自定义项5 | nvarchar | 500 | True | |
| idpartner (T+12.1) | 往来单位id | int | 4 | True | |
| idAccountRuleDTO (T+12.1) | 科目设置id | int | 4 | True | |
| detailspriuserdefnvc3 (T+12.1) | 表体私有自定义项3 | nvarchar | 500 | True | |
| idpartnerclass (T+12.1) | 往来单位分类id | int | 4 | True | |
| ProfitLossType (T+12.1) | 损益类型 | int | 4 | True | |
| headerpubuserdefdecm1 (T+12.1) | 表头公有自定义项1 | decimal | 13 | True | |
| code (T+12.1) | 编号 | nvarchar | 30 | True | |
| name (T+12.1) | 名称 | nvarchar | 200 | True | |
| IsPresent (T+12.2) | 往来单位并户 | tinyint | 1 | True | |
| Headerpubuserdefdecm6 (T+12.3) | 表头公有自定义项6 | decimal | 13 | True | |
| idcurrency (T+12.1) | 币种id | int | 4 | True | |
| detailspriuserdefdecm2 (T+12.1) | 表体私有自定义项2 | decimal | 13 | True | |
| detailspriuserdefdecm1 (T+12.1) | 表体私有自定义项1 | decimal | 13 | True | |
| iddistrict (T+12.1) | 地区id | int | 4 | True | |
| headerpriuserdefnvc5 (T+12.1) | 表头私有自定义项5 | nvarchar | 500 | True | |
| inventorypriuserdefnvc0 (T+12.1) | 存货私有自定义项字符型0 | nvarchar | 500 | True |
Copyright 2019 Chanjet Inc.