ARAP_BILLMAP 业务数据映射表返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | DR | NUMBER | 10 | 0 | | | √ | 0 | 删除标志 |
2 | ISMANUAL | CHAR | 1 | | | | √ | | 是否手工关联 |
3 | MAPTYPE | NUMBER | 38 | 0 | | | √ | | 占用标志 |
4 | OLDJE | NUMBER | 28 | 8 | | | √ | | 历史金额 |
5 | PK_BILLMAP | VARCHAR2 | 50 | | √ | | | | 主键 |
6 | PK_CURRTYPE | VARCHAR2 | 20 | | | | √ | | 币种 |
7 | PK_ORG | VARCHAR2 | 20 | | | | √ | | 财务组织 |
8 | PK_ORG1 | VARCHAR2 | 20 | | | | √ | | 上游财务组织 |
9 | S_BILLID | VARCHAR2 | 20 | | | | √ | | 源单据主键 |
10 | S_BILLTYPE | VARCHAR2 | 20 | | | | √ | | 源单据类型 |
11 | S_ITEMID | VARCHAR2 | 20 | | | | √ | | 源单据行主键 |
12 | S_SYSTEM | NUMBER | 38 | 0 | | | √ | | 系统来源 |
13 | S_TERMID | VARCHAR2 | 20 | | | | √ | | 源单据协议表主键 |
14 | SETTLECURR | VARCHAR2 | 20 | | | | √ | | 拉单币种 |
15 | SETTLEMONEY | NUMBER | 28 | 8 | | | √ | | 拉单金额 |
16 | T_BILLID | VARCHAR2 | 20 | | | | √ | | 目的单据主键 |
17 | T_BILLTYPE | VARCHAR2 | 20 | | | | √ | | 目的单据类型 |
18 | T_ITEMID | VARCHAR2 | 20 | | | | √ | | 目的单据行主键 |
19 | T_TERMID | VARCHAR2 | 20 | | | | √ | | 目的协议表主键 |
20 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
21 | YBJE | NUMBER | 28 | 8 | | | √ | | 原币金额 |
22 | YBYE | NUMBER | 28 | 8 | | | √ | | 原币余额 |
|