BCS_VOUCH_TEMPLATE

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