GL_DISTRANSRULE 分布系统传输规则返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | COMBINDETAILS | CHAR | 1 | | | | √ | | 合并分录 |
2 | CONTAINTALLY | CHAR | 1 | | | | √ | | 包含未记账 |
3 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
4 | FRIDAY | CHAR | 1 | | | | √ | | 周五 |
5 | ISASSCONTAIN | CHAR | 1 | | | | √ | | 是否传辅助核算 |
6 | ISCASHFLOWCONTAIN | CHAR | 1 | | | | √ | | 是否传现金流量 |
7 | ISCOMBINDIFABS | CHAR | 1 | | | | √ | | 不同摘要是否合并 |
8 | ISCOMBINDIFDC | CHAR | 1 | | | | √ | | 借贷方向相反是否合并 |
9 | MONDAY | CHAR | 1 | | | | √ | | 周一 |
10 | MONTHDAYS | NUMBER | 38 | 0 | | | √ | | 下月第几天 |
11 | MONTHPERIODS | NUMBER | 38 | 0 | | | √ | | 每隔几月 |
12 | PK_GROUP | CHAR | 20 | | | | √ | | 集团 |
13 | PK_TRANSRULE | CHAR | 20 | | √ | | | | 传输规则ID |
14 | RULENAME | VARCHAR2 | 50 | | | | √ | | 规则名称 |
15 | SATURDAY | CHAR | 1 | | | | √ | | 周六 |
16 | SRCSYSCODE | VARCHAR2 | 50 | | | | √ | | 来源系统编码 |
17 | SUNDAY | CHAR | 1 | | | | √ | | 周日 |
18 | THURSDAY | CHAR | 1 | | | | √ | | 周四 |
19 | TRANSDATATYPE | VARCHAR2 | 50 | | | | √ | | 传输数据类型 |
20 | TRANSDATE | CHAR | 8 | | | | √ | | 开始时间 |
21 | TRANSPERIOD | VARCHAR2 | 50 | | | | √ | | 上传周期 |
22 | TRANSTYPE | VARCHAR2 | 50 | | | | √ | | 传输方式 |
23 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
24 | TUESDAY | CHAR | 1 | | | | √ | | 周二 |
25 | WEDNESDAY | CHAR | 1 | | | | √ | | 周三 |
26 | WEEKPERIODS | NUMBER | 38 | 0 | | | √ | | 每隔几周 |
|