ER_JKBX_INIT

ER_JKBX_INIT
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	APPROVER	CHAR	20				√
2	BBHL	NUMBER	15	8			√
3	BBJE	NUMBER	28	8			√
4	BBYE	NUMBER	28	8			√
5	BUSITYPE	CHAR	20				√
6	BZBM	CHAR	20				√
7	CASHITEM	CHAR	20				√
8	CASHPROJ	CHAR	20				√
9	CENTER_DEPT	VARCHAR2	20				√	'~'
10	CHECKTYPE	CHAR	20				√
11	CJKBBJE	NUMBER	28	8			√
12	CJKYBJE	NUMBER	28	8			√
13	CONTRASTENDDATE	CHAR	19				√
14	CREATIONTIME	CHAR	19				√
15	CREATOR	CHAR	20				√
16	CUSTACCOUNT	CHAR	20				√
17	CUSTOMER	CHAR	20				√
18	DEPTID	CHAR	20				√
19	DEPTID_V	CHAR	20				√
20	DJBH	VARCHAR2	30				√
21	DJDL	VARCHAR2	2
22	DJLXBM	VARCHAR2	20
23	DJRQ	CHAR	19				√
24	DJZT	NUMBER	38	0			√
25	DR	NUMBER	10	0			√	0
26	DWBM	CHAR	20				√
27	DWBM_V	CHAR	20				√
28	FJZS	NUMBER	38	0			√
29	FKYHZH	CHAR	20				√
30	FREECUST	CHAR	20				√
31	FYDEPTID	CHAR	20				√
32	FYDEPTID_V	CHAR	20				√
33	FYDWBM	CHAR	20				√
34	FYDWBM_V	CHAR	20				√
35	GLOBALBBHL	NUMBER	15	8			√
36	GLOBALBBJE	NUMBER	28	8			√
37	GLOBALBBYE	NUMBER	28	8			√
38	GLOBALCJKBBJE	NUMBER	28	8			√
39	GLOBALHKBBJE	NUMBER	28	8			√
40	GLOBALZFBBJE	NUMBER	28	8			√
41	GROUPBBHL	NUMBER	15	8			√
42	GROUPBBJE	NUMBER	28	8			√
43	GROUPBBYE	NUMBER	28	8			√
44	GROUPCJKBBJE	NUMBER	28	8			√
45	GROUPHKBBJE	NUMBER	28	8			√
46	GROUPZFBBJE	NUMBER	28	8			√
47	HBBM	CHAR	20				√
48	HKBBJE	NUMBER	28	8			√
49	HKYBJE	NUMBER	28	8			√
50	ISCHECK	CHAR	1				√
51	ISCOSTSHARE	CHAR	1				√	'N'
52	ISCUSUPPLIER	CHAR	1				√
53	ISEXPAMT	CHAR	1				√	'N'
54	ISINITGROUP	CHAR	1				√
55	JKBXR	CHAR	20				√
56	JOBID	CHAR	20				√
57	JSFS	CHAR	20				√
58	JSH	VARCHAR2	30				√
59	JSRQ	CHAR	19				√
60	KJND	CHAR	4				√
61	KJQJ	CHAR	2				√
62	MNGACCID	CHAR	20				√
63	MODIFIEDTIME	CHAR	19				√
64	MODIFIER	CHAR	20				√
65	OPERATOR	CHAR	20				√
66	PAYFLAG	NUMBER	38	0			√
67	PAYTARGET	NUMBER	38	0			√
68	PJH	VARCHAR2	20				√
69	PK_BRAND	VARCHAR2	20				√	'~'
70	PK_CASHACCOUNT	CHAR	20				√
71	PK_CHECKELE	CHAR	20				√
72	PK_FIORG	CHAR	20				√
73	PK_GROUP	CHAR	20				√
74	PK_ITEM	CHAR	20				√
75	PK_JKBX	CHAR	20		√
76	PK_ORG	CHAR	20				√
77	PK_ORG_V	CHAR	20				√
78	PK_PAYORG	VARCHAR2	20				√
79	PK_PAYORG_V	VARCHAR2	20				√
80	PK_PCORG	CHAR	20				√
81	PK_PCORG_V	CHAR	20				√
82	PK_PROLINE	VARCHAR2	20				√	'~'
83	PK_RESACOSTCENTER	CHAR	20				√
84	PK_TRADETYPEID	VARCHAR2	20				√
85	PROJECTTASK	CHAR	20				√
86	QCBZ	CHAR	1				√
87	QZZT	NUMBER	38	0			√
88	RECEIVER	CHAR	20				√
89	SHRQ	CHAR	19				√
90	SKYHZH	CHAR	20				√
91	SPZT	NUMBER	38	0			√
92	START_PERIOD	VARCHAR2	50				√
93	SXBZ	NUMBER	38	0			√
94	SZXMID	CHAR	20				√
95	TOTAL	NUMBER	28	8			√
96	TOTAL_PERIOD	NUMBER	38	0			√
97	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
98	YBJE	NUMBER	28	8			√
99	YBYE	NUMBER	28	8			√
100	YWBM	CHAR	20				√
101	ZFBBJE	NUMBER	28	8			√
102	ZFYBJE	NUMBER	28	8			√
103	ZHRQ	CHAR	19				√
104	ZPXE	NUMBER	28	8			√
105	ZY	VARCHAR2	300				√
106	ZYX1	VARCHAR2	100				√
107	ZYX10	VARCHAR2	100				√
108	ZYX11	VARCHAR2	100				√
109	ZYX12	VARCHAR2	100				√
110	ZYX13	VARCHAR2	100				√
111	ZYX14	VARCHAR2	100				√
112	ZYX15	VARCHAR2	100				√
113	ZYX16	VARCHAR2	100				√
114	ZYX17	VARCHAR2	100				√
115	ZYX18	VARCHAR2	100				√
116	ZYX19	VARCHAR2	100				√
117	ZYX2	VARCHAR2	100				√
118	ZYX20	VARCHAR2	100				√
119	ZYX21	VARCHAR2	100				√
120	ZYX22	VARCHAR2	100				√
121	ZYX23	VARCHAR2	100				√
122	ZYX24	VARCHAR2	100				√
123	ZYX25	VARCHAR2	100				√
124	ZYX26	VARCHAR2	100				√
125	ZYX27	VARCHAR2	100				√
126	ZYX28	VARCHAR2	100				√
127	ZYX29	VARCHAR2	100				√
128	ZYX3	VARCHAR2	100				√
129	ZYX30	VARCHAR2	100				√
130	ZYX4	VARCHAR2	100				√
131	ZYX5	VARCHAR2	100				√
132	ZYX6	VARCHAR2	100				√
133	ZYX7	VARCHAR2	100				√
134	ZYX8	VARCHAR2	100				√
135	ZYX9	VARCHAR2	100				√