BGR_VOUCH

BGR_VOUCH_HEAD
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	ALONE_ID	VARCHAR2	64				√
2	BALANCECREDITAMOUNT	NUMBER	28	8			√
3	BALANCEDEBITAMOUNT	NUMBER	28	8			√
4	BM_SCOPE	VARCHAR2	50				√
5	BUSIVOUCHTYPE	NUMBER	38	0			√
6	CANCELSTATE	CHAR	1				√
7	CHECKDATE	CHAR	19				√
8	CHECKER	VARCHAR2	20				√	'~'
9	CREATIONTIME	CHAR	19				√
10	CREATOR	VARCHAR2	20				√	'~'
11	CREDITAMOUNT	NUMBER	28	8			√
12	DATAORIGIN	VARCHAR2	50				√
13	DEBITAMOUNT	NUMBER	28	8			√
14	DIGEST	VARCHAR2	50				√	'~'
15	DR	NUMBER	10	0			√	0
16	ERROR	VARCHAR2	1024				√
17	ERRORSTATE	CHAR	1				√
18	INPUT_DATE	CHAR	19				√
19	IORDER	VARCHAR2	40				√
20	ISBALANCE	CHAR	1				√
21	KEY1	VARCHAR2	100				√
22	KEY10	VARCHAR2	40				√
23	KEY2	VARCHAR2	100				√
24	KEY3	VARCHAR2	100				√
25	KEY4	VARCHAR2	40				√
26	KEY5	VARCHAR2	40				√
27	KEY6	VARCHAR2	40				√
28	KEY7	VARCHAR2	40				√
29	KEY8	VARCHAR2	40				√
30	KEY9	VARCHAR2	40				√
31	MODIFIEDTIME	CHAR	19				√
32	MODIFIER	VARCHAR2	20				√	'~'
33	PK_ADJSCHEME	VARCHAR2	50				√
34	PK_AUDIT	VARCHAR2	50				√
35	PK_CURR	VARCHAR2	50				√
36	PK_DXRELA	VARCHAR2	50				√
37	PK_DXSCHEME	VARCHAR2	50				√
38	PK_GROUP	VARCHAR2	20				√	'~'
39	PK_HBSCHEME	VARCHAR2	20				√	'~'
40	PK_KEYGROUP	VARCHAR2	50				√
41	PK_MEASURE	VARCHAR2	20				√	'~'
42	PK_MVTYPE	VARCHAR2	50				√
43	PK_ORG	VARCHAR2	20				√	'~'
44	PK_PARAMENTITY	VARCHAR2	50				√
45	PK_RULE	VARCHAR2	50				√
46	PK_USER	VARCHAR2	20				√	'~'
47	PK_VERSION	VARCHAR2	50				√
48	PK_VOUCHHEAD	CHAR	20		√
49	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
50	VALIDFLAG	CHAR	1				√
51	VOUCH_TYPE	NUMBER	38	0			√