GL_CASHFLOWCASE 现金流量发生项返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ASSID | CHAR | 20 | | | | √ | | 辅助核算 |
2 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
3 | FLAG | NUMBER | 38 | 0 | | | √ | | 分析标记 |
4 | MEMO | VARCHAR2 | 150 | | | | √ | | 备注 |
5 | MONEY | NUMBER | 28 | 8 | | | √ | | 金额 |
6 | MONEYGLOBAL | NUMBER | 28 | 8 | | | √ | | 全局本币 |
7 | MONEYGROUP | NUMBER | 28 | 8 | | | √ | | 集团本币 |
8 | MONEYMAIN | NUMBER | 28 | 8 | | | √ | | 主币 |
9 | PK_ACCASOA | CHAR | 20 | | | | √ | | 科目主键 |
10 | PK_ACCOUNTINGBOOK | CHAR | 20 | | | | √ | | 核算账簿 |
11 | PK_CASHFLOW | CHAR | 20 | | | | √ | | 现金流量表项 |
12 | PK_CASHFLOWCASE | CHAR | 20 | | √ | | | | 现金流量标识 |
13 | PK_CURRTYPE | CHAR | 20 | | | | √ | | 现金流量币种 |
14 | PK_DETAIL | CHAR | 20 | | | | √ | | 凭证分录 |
15 | PK_DETAIL_OPP | CHAR | 20 | | | | √ | | 对方科目 |
16 | PK_GROUP | CHAR | 20 | | | | √ | | 所属集团 |
17 | PK_INNERCORP | CHAR | 20 | | | | √ | | |
18 | PK_MANAGER | CHAR | 20 | | | | √ | | 记账人 |
19 | PK_ORG | CHAR | 20 | | | | √ | | 财务组织 |
20 | PK_ORG_V | CHAR | 20 | | | | √ | | 财务组织版本 |
21 | PK_SETOFBOOK | CHAR | 20 | | | | √ | | 账簿类型 |
22 | PK_UNIT | CHAR | 20 | | | | √ | | 业务单元 |
23 | PK_VOUCHER | CHAR | 20 | | | | √ | | 凭证表体主键 |
24 | PREPAREDDATE | CHAR | 19 | | | | √ | | 制单日期 |
25 | QUICKFLAG | CHAR | 1 | | | | √ | | |
26 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|