GL_VOUCHERBACKUP

GL_VOUCHERBACKUP
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ADDCLASS	VARCHAR2	60				√
2	ADJUSTPERIOD	VARCHAR2	3				√
3	APPROVER	VARCHAR2	20				√
4	ATTACHMENT	NUMBER	38	0			√
5	BILLMAKER	VARCHAR2	20				√
6	CHECKEDDATE	CHAR	19				√
7	CONTRASTFLAG	NUMBER	38	0			√
8	CONVERTFLAG	CHAR	1				√
9	CREATIONTIME	CHAR	19				√
10	CREATOR	CHAR	20				√
11	DELETECLASS	VARCHAR2	60				√
12	DETAILMODFLAG	CHAR	1				√
13	DISCARDFLAG	CHAR	1				√
14	DR	NUMBER	10	0			√	0
15	ERRMESSAGE	VARCHAR2	60				√
16	ERRMESSAGEH	VARCHAR2	90				√
17	EXPLANATION	VARCHAR2	150				√
18	FREE1	VARCHAR2	60				√
19	FREE10	VARCHAR2	60				√
20	FREE2	VARCHAR2	60				√
21	FREE3	VARCHAR2	60				√
22	FREE4	VARCHAR2	60				√
23	FREE5	VARCHAR2	60				√
24	FREE6	VARCHAR2	60				√
25	FREE7	VARCHAR2	60				√
26	FREE8	VARCHAR2	60				√
27	FREE9	VARCHAR2	60				√
28	ISDIFFLAG	CHAR	1				√
29	MODIFIEDTIME	CHAR	19				√
30	MODIFIER	CHAR	20				√
31	MODIFYCLASS	VARCHAR2	60				√
32	MODIFYFLAG	CHAR	20				√
33	NUM	NUMBER	38	0			√
34	OFFERVOUCHER	VARCHAR2	20				√
35	PERIOD	CHAR	2
36	PK_ACCOUNTINGBOOK	CHAR	20
37	PK_CASHER	VARCHAR2	20				√
38	PK_CHECKED	VARCHAR2	20				√
39	PK_GROUP	CHAR	20				√
40	PK_MANAGER	VARCHAR2	20				√
41	PK_ORG	CHAR	20				√
42	PK_ORG_V	CHAR	20				√
43	PK_PREPARED	CHAR	20
44	PK_SETOFBOOK	CHAR	20				√
45	PK_SOURCEPK	CHAR	20				√
46	PK_SYSTEM	CHAR	20				√
47	PK_VOUCHER	CHAR	20		√
48	PK_VOUCHERTYPE	CHAR	20
49	PREPAREDDATE	CHAR	19
50	SIGNDATE	CHAR	19				√
51	SIGNFLAG	CHAR	1				√
52	TALLYDATE	CHAR	19				√
53	TEMPSAVEFLAG	CHAR	1				√	'N'
54	TOTALCREDIT	NUMBER	28	8			√
55	TOTALCREDITGLOBAL	NUMBER	28	8			√
56	TOTALCREDITGROUP	NUMBER	28	8			√
57	TOTALDEBIT	NUMBER	28	8			√
58	TOTALDEBITGLOBAL	NUMBER	28	8			√
59	TOTALDEBITGROUP	NUMBER	28	8			√
60	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
61	VOUCHERKIND	NUMBER	38	0			√
62	YEAR	CHAR	4