RESA_CORS

RESA_CORS_FINAL
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ACCATTR1	VARCHAR2	20				√
2	ACCATTR2	VARCHAR2	20				√
3	ACCATTR3	VARCHAR2	20				√
4	ACCATTR4	VARCHAR2	20				√
5	ACCATTR5	VARCHAR2	20				√
6	ACCATTR6	VARCHAR2	20				√
7	ACCATTR7	VARCHAR2	20				√
8	ACCATTR8	VARCHAR2	20				√
9	ACCATTR9	VARCHAR2	20				√
10	BATCHNO	VARCHAR2	128				√
11	DIRECT	VARCHAR2	50				√
12	DR	NUMBER	10	0			√	0
13	GLOBMNY	NUMBER	28	8			√
14	GROUPMNY	NUMBER	28	8			√
15	ORGMNY	NUMBER	28	8			√
16	ORIMNY	NUMBER	28	8			√
17	PK_ACCCOSTCENTER	VARCHAR2	20				√	'~'
18	PK_ACCCURRTYPE	VARCHAR2	20				√	'~'
19	PK_ACCDIMGROUPS	VARCHAR2	20				√	'~'
20	PK_ACCFACTOR	VARCHAR2	20				√	'~'
21	PK_ACCLIABOOK	VARCHAR2	20				√	'~'
22	PK_ACCLIACENTER	VARCHAR2	20				√	'~'
23	PK_ALLOCRULE	VARCHAR2	20				√	'~'
24	PK_CORS_FINAL	VARCHAR2	50				√
25	PK_COSTCENTER	VARCHAR2	20				√	'~'
26	PK_CURRTYPE	VARCHAR2	20				√	'~'
27	PK_DIMGROUPS	VARCHAR2	20				√	'~'
28	PK_FACTORASOA	VARCHAR2	20				√	'~'
29	PK_GROUP	VARCHAR2	20				√	'~'
30	PK_LIABOOK	VARCHAR2	20				√	'~'
31	PK_ORG	VARCHAR2	20				√	'~'
32	PK_ROOTCOSTCENTER	VARCHAR2	20				√	'~'
33	PK_ROOTCURRTYPE	VARCHAR2	20				√	'~'
34	PK_ROOTFACTOR	VARCHAR2	20				√	'~'
35	PK_ROOTORG	VARCHAR2	20				√	'~'
36	QUANTITY	NUMBER	28	8			√
37	ROOTDIMSGROUP	VARCHAR2	20				√	'~'
38	ROOTORIENT	VARCHAR2	20				√
39	SPERIOD	VARCHAR2	50				√
40	SYEAR	VARCHAR2	50				√
41	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')