PUB_BILLTEMPLET

PUB_BILLTEMPLET_B
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	CARDFLAG	NUMBER	38	0			√	1
2	DATATYPE	NUMBER	38	0			√	0
3	DEFAULTSHOWNAME	VARCHAR2	150				√
4	DEFAULTVALUE	VARCHAR2	1000				√
5	DR	NUMBER	10	0			√	0
6	EDITFLAG	NUMBER	38	0			√	1
7	EDITFORMULA	VARCHAR2	1000				√
8	FOREGROUND	NUMBER	38	0			√	0
9	HYPERLINKFLAG	CHAR	1				√
10	IDCOLNAME	VARCHAR2	50				√
11	INPUTLENGTH	NUMBER	38	0			√	20
12	ITEMKEY	VARCHAR2	50
13	ITEMTYPE	NUMBER	38	0			√	0
14	LEAFFLAG	CHAR	1				√	'N'
15	LISTFLAG	NUMBER	38	0			√	1
16	LISTHYPERLINKFLAG	CHAR	1				√
17	LISTSHOWFLAG	CHAR	1				√
18	LISTSHOWORDER	NUMBER	38	0			√	null
19	LOADFORMULA	VARCHAR2	1000				√
20	LOCKFLAG	NUMBER	38	0			√	0
21	METADATAPATH	VARCHAR2	100				√
22	METADATAPROPERTY	VARCHAR2	100				√
23	METADATARELATION	VARCHAR2	2000				√
24	NEWLINEFLAG	CHAR	1				√	'N'
25	NULLFLAG	NUMBER	38	0			√	0
26	OPTIONS	VARCHAR2	400				√
27	PK_BILLTEMPLET	CHAR	20
28	PK_BILLTEMPLET_B	CHAR	20		√
29	PK_CORP	VARCHAR2	20				√	'@@@@'
30	POS	NUMBER	38	0			√	0
31	REFTYPE	VARCHAR2	1000				√
32	RESID	VARCHAR2	30				√
33	RESID_TABNAME	VARCHAR2	30				√
34	REVISEFLAG	CHAR	1				√	'N'
35	SHOWFLAG	NUMBER	38	0			√	1
36	SHOWORDER	NUMBER	38	0			√	0
37	TABLE_CODE	VARCHAR2	40				√
38	TABLE_NAME	VARCHAR2	75				√
39	TOTALFLAG	NUMBER	38	0			√	0
40	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
41	USERDEFFLAG	CHAR	1				√
42	USERDEFINE1	VARCHAR2	50				√
43	USERDEFINE2	VARCHAR2	50				√
44	USERDEFINE3	VARCHAR2	50				√
45	USEREDITFLAG	NUMBER	38	0			√	0
46	USERFLAG	NUMBER	38	0			√	1
47	USERREVISEFLAG	CHAR	1				√
48	USERSHOWFLAG	NUMBER	38	0			√	0
49	VALIDATEFORMULA	VARCHAR2	1000				√
50	WIDTH	NUMBER	38	0			√	1