ARAP_AGIOTAGE_D 汇兑损益子表返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BILLNO | VARCHAR2 | 40 | | | | √ | | 单据编号 |
2 | BUSIDATE | CHAR | 19 | | | | √ | | 处理日期 |
3 | BUSIPERIOD | CHAR | 2 | | | | √ | | 处理期间 |
4 | BUSIYEAR | CHAR | 4 | | | | √ | | 处理年度 |
5 | CURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 币种 |
6 | CUSTOMER | VARCHAR2 | 20 | | | | √ | | 客户 |
7 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
8 | EXPIREDATE | CHAR | 19 | | | | √ | | 信用到期日 |
9 | GLOBAL_MONEY_BAL | NUMBER | 28 | 8 | | | √ | | 全局本币余额 |
10 | GLOBAL_MONEY_CR | NUMBER | 28 | 8 | | | √ | | 贷方处理全局本币金额 |
11 | GLOBAL_MONEY_DE | NUMBER | 28 | 8 | | | √ | | 借方处理全局本币金额 |
12 | GLOBALRATE | NUMBER | 28 | 8 | | | √ | | 全局本币汇率 |
13 | GROUP_MONEY_BAL | NUMBER | 28 | 8 | | | √ | | 集团本币余额 |
14 | GROUP_MONEY_CR | NUMBER | 28 | 8 | | | √ | | 贷方处理集团本币金额 |
15 | GROUP_MONEY_DE | NUMBER | 28 | 8 | | | √ | | 借方处理集团本币金额 |
16 | GROUPRATE | NUMBER | 28 | 8 | | | √ | | 集团本币汇率 |
17 | INNERCTLDEFERDAYS | CHAR | 19 | | | | √ | | 内控到期日 |
18 | LOCAL_MONEY_BAL | NUMBER | 28 | 8 | | | √ | | 组织本币余额 |
19 | LOCAL_MONEY_CR | NUMBER | 28 | 8 | | | √ | | 贷方处理本币金额 |
20 | LOCAL_MONEY_DE | NUMBER | 28 | 8 | | | √ | | 借方处理本币金额 |
21 | MONEY_BAL | NUMBER | 28 | 8 | | | √ | | 原币余额 |
22 | ORDERCUBASDOC | VARCHAR2 | 20 | | | | √ | | 订单客户 |
23 | PK_AGIOTAGE | CHAR | 20 | | | | √ | | 主表主键 |
24 | PK_AGIOTAGE_D | CHAR | 20 | | √ | | | | 主键 |
25 | PK_BILL | VARCHAR2 | 30 | | | | √ | | 单据PK |
26 | PK_BILLTYPE | VARCHAR2 | 20 | | | | √ | '~' | 单据类型 |
27 | PK_BUSIDATA | VARCHAR2 | 20 | | | | √ | | 业务数据主键 |
28 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 所属集团 |
29 | PK_ITEM | VARCHAR2 | 30 | | | | √ | | 单据子表PK |
30 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 主组织 |
31 | PK_TERMITEM | CHAR | 20 | | | | √ | | 收付业务数据标识 |
32 | PK_TRADETYPE | VARCHAR2 | 50 | | | | √ | | 交易类型 |
33 | RATE | NUMBER | 15 | 8 | | | √ | | 汇率 |
34 | REDFLAG | NUMBER | 38 | 0 | | | √ | | 红冲标志 |
35 | SCOMMENT | VARCHAR2 | 300 | | | | √ | | 摘要 |
36 | SUPPLIER | VARCHAR2 | 20 | | | | √ | | 供应商 |
37 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|