CM_PROCOSTDETAILBODYRESULTVO

CM_PROCOSTDETAILBODYRESULTVO
返回目录
序号	列名	数据类型	长度	小数位数	主键	自增	允许空	默认值	列说明
1	CACTIVITYID	VARCHAR2	20				√	'~'
2	CELEMENTID	VARCHAR2	20					'~'
3	CMATERIALID	VARCHAR2	20				√	'~'
4	CMEASURENUIT	CHAR	20				√	'~'
5	CORIGCURRENCYID	VARCHAR2	20				√	'~'
6	CPARENTELEMENTID	CHAR	20				√	'~'
7	CUNITIDNAME	VARCHAR2	50				√
8	DR	NUMBER	10	0			√	0
9	NCONSTOTALCURRPD	NUMBER	28	8			√
10	NCONSTOTALFRMOTHCTR	NUMBER	28	8			√
11	NCONSTOTALLSTSAMEPD	NUMBER	28	8			√
12	NCONSTOTALSTD	NUMBER	28	8			√
13	NCONSTOTALSUB	NUMBER	28	8			√
14	NCONSTOTALTHIS	NUMBER	28	8			√
15	NCONSTOTALTHISCTR	NUMBER	28	8			√
16	NCONSTOTALTHISYTOTL	NUMBER	28	8			√
17	NODECODE	VARCHAR2	50				√
18	NODEID	VARCHAR2	50		√
19	NPRICECURRPERIOD	NUMBER	28	8			√
20	NPRICEFROMOTHERCTR	NUMBER	28	8			√
21	NPRICELSTSAMEPERIOD	NUMBER	28	8			√
22	NPRICESTD	NUMBER	28	8			√
23	NPRICESUB	NUMBER	28	8			√
24	NPRICETHIS	NUMBER	28	8			√
25	NPRICETHISCENTER	NUMBER	28	8			√
26	NPRICETHISYEARTOTAL	NUMBER	28	8			√
27	NTOTALCOSTCURRPRD	NUMBER	28	8			√
28	NTOTALCOSTFRMOTHCTR	NUMBER	28	8			√
29	NTOTALCOSTLSTSAMEPD	NUMBER	28	8			√
30	NTOTALCOSTSTD	NUMBER	28	8			√
31	NTOTALCOSTSUB	NUMBER	28	8			√
32	NTOTALCOSTTHIS	NUMBER	28	8			√
33	NTOTALCOSTTHISCTR	NUMBER	28	8			√
34	NTOTALCOSTTHISYTOTL	NUMBER	28	8			√
35	NUNITCONSCURRPERIOD	NUMBER	28	8			√
36	NUNITCONSFRMOTHRCTR	NUMBER	28	8			√
37	NUNITCONSLSTSAMEPD	NUMBER	28	8			√
38	NUNITCONSSTD	NUMBER	28	8			√
39	NUNITCONSSUB	NUMBER	28	8			√
40	NUNITCONSTHIS	NUMBER	28	8			√
41	NUNITCONSTHISCENTER	NUMBER	28	8			√
42	NUNITCONSTHISYTOTAL	NUMBER	28	8			√
43	NUNITCOSTCURRPERIOD	NUMBER	28	8			√
44	NUNITCOSTFRMOTHRCTR	NUMBER	28	8			√
45	NUNITCOSTLSTSAMEPD	NUMBER	28	8			√
46	NUNITCOSTSTD	NUMBER	28	8			√
47	NUNITCOSTSUB	NUMBER	28	8			√
48	NUNITCOSTTHIS	NUMBER	28	8			√
49	NUNITCOSTTHISCENTER	NUMBER	28	8			√
50	NUNITCOSTTHISYTOTAL	NUMBER	28	8			√
51	PK_ORG	VARCHAR2	20				√	'~'
52	TS	CHAR	19				√	to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')