RESA_FACTOR 核算要素返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BALANFLAG | CHAR | 1 | | | | √ | | 余额方向控制 |
2 | BALANORIENT | VARCHAR2 | 1 | | | | | | 要素方向 |
3 | BOTHORIENT | CHAR | 1 | | | | √ | | 账簿余额双向显示 |
4 | COSTFEETYPE | NUMBER | 38 | 0 | | | √ | | 项目成本费用类型 |
5 | CURRENCY | VARCHAR2 | 20 | | | | √ | '~' | 默认币种 |
6 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
7 | EXPENSECLASS | NUMBER | 38 | 0 | | | √ | | 费用习性 |
8 | FACTORCLASS | NUMBER | 38 | 0 | | | √ | | 要素类别 |
9 | FACTORCODE | VARCHAR2 | 50 | | | | | | 要素编码 |
10 | FACTORLEV | NUMBER | 38 | 0 | | | √ | | 要素级次 |
11 | FACTORNAME | VARCHAR2 | 300 | | | | | | 要素名称 |
12 | FACTORNAME2 | VARCHAR2 | 300 | | | | √ | | 要素名称2 |
13 | FACTORNAME3 | VARCHAR2 | 300 | | | | √ | | 要素名称3 |
14 | FACTORNAME4 | VARCHAR2 | 300 | | | | √ | | 要素名称4 |
15 | FACTORNAME5 | VARCHAR2 | 300 | | | | √ | | 要素名称5 |
16 | FACTORNAME6 | VARCHAR2 | 300 | | | | √ | | 要素名称6 |
17 | FEETYPE | NUMBER | 38 | 0 | | | √ | | 费用类型 |
18 | INCOMEEXPENSES | NUMBER | 38 | 0 | | | √ | | 收支属性 |
19 | INCURFLAG | CHAR | 1 | | | | √ | | 发生额方向控制 |
20 | ISEXPLAND | CHAR | 1 | | | | √ | | 是否合并明细 |
21 | ISSEMIGOOD | CHAR | 1 | | | | √ | | 是否半成品 |
22 | ISWORKFACTOR | CHAR | 1 | | | | √ | | 是否作业要素 |
23 | PK_FACTOR | CHAR | 20 | | √ | | | | 标识 |
24 | PK_FACTORCHART | VARCHAR2 | 20 | | | | √ | '~' | 创建要素表 |
25 | PK_FACTORTYPE | CHAR | 20 | | | | | | 要素类型 |
26 | PK_ORIGINALFACTOR | VARCHAR2 | 20 | | | | √ | | 原始要素标识 |
27 | PRICE | CHAR | 1 | | | | √ | | 单价 |
28 | QUANTITY | CHAR | 1 | | | | √ | | 数量 |
29 | QUANTITYCHECK | CHAR | 1 | | | | √ | | 数量核算 |
30 | REMCODE | VARCHAR2 | 50 | | | | √ | | 助记码 |
31 | SEALFLAG | CHAR | 1 | | | | √ | | 封存标志 |
32 | SUMPRINT_LEVEL | NUMBER | 38 | 0 | | | √ | | 汇总打印级次 |
33 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
34 | UNIT | VARCHAR2 | 20 | | | | √ | '~' | 默认计量单位 |
|