FA_INITACCBOOK_B 账簿初始化明细返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ACCUDEP | NUMBER | 28 | 8 | | | √ | | 累计折旧 |
2 | ACCUWORKLOAN | NUMBER | 28 | 8 | | | √ | | 累计工作量 |
3 | ALLWORKLOAN | NUMBER | 28 | 8 | | | √ | | 工作总量 |
4 | DEP_END_DATE | CHAR | 19 | | | | √ | | 折旧截止日期 |
5 | DEP_START_DATE | CHAR | 19 | | | | √ | | 折旧开始日期 |
6 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
7 | ISIMPORTED | CHAR | 1 | | | | √ | | 是否已导入 |
8 | ISMODIFIED | CHAR | 1 | | | | √ | | 修改标志 |
9 | LASTSTATE_FLAG | CHAR | 1 | | | | √ | | 最新状态 |
10 | LOCALORIGINVALUE | NUMBER | 28 | 8 | | | √ | | 本币原值 |
11 | NATUREMONTH | NUMBER | 38 | 0 | | | √ | | 使用月限 |
12 | NETRATING | NUMBER | 28 | 8 | | | √ | | 净额 |
13 | NETVALUE | NUMBER | 28 | 8 | | | √ | | 净值 |
14 | PK_CARD | VARCHAR2 | 20 | | | | √ | '~' | 资产卡片 |
15 | PK_CARDHISTORY | VARCHAR2 | 20 | | | | √ | '~' | 卡片历史表主键 |
16 | PK_CATEGORY | VARCHAR2 | 20 | | | | √ | '~' | 资产类别 |
17 | PK_DEPMETHOD | VARCHAR2 | 20 | | | | √ | '~' | 折旧方法 |
18 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 集团 |
19 | PK_INITACCBOOK | CHAR | 20 | | | | | | 账簿初始化_主键 |
20 | PK_INITACCBOOK_B | CHAR | 20 | | √ | | | | 主键 |
21 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 财务组织组织最新版本 |
22 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 财务组织 |
23 | PREDEVALUATE | NUMBER | 28 | 8 | | | √ | | 减值准备 |
24 | SALVAGE | NUMBER | 28 | 8 | | | √ | | 净残值 |
25 | SALVAGERATE | NUMBER | 28 | 8 | | | √ | | 净残值率 |
26 | SERVICEMONTH | NUMBER | 38 | 0 | | | √ | | 折旧期数 |
27 | TAXINPUT_FLAG | CHAR | 1 | | | | √ | | 抵扣进项税标记 |
28 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
29 | USEDMONTH | NUMBER | 38 | 0 | | | √ | | 已计提期数 |
|