COST ESTIMATION

Construction Cost CODE STANDARD (2022년 02월 10일 수정)

31. 프로젝트 : CE_PJT_LST.jsp [ 테이블 명칭 : CE_PJT_LST] 재질코드 의 OUTER JOIN
query[0] = [Select pKey,B1,B2,B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B13,B14,B15,B16,EP1,EP2,EP3,EP4,EP5,EP6,EP7,EP8,EP9,EP10,EP_SUM,EP_OP,EP_PF,EP_TOTAL,OceanF,C1,C2,C3,C4,C5,C6,C7,C8,C_SUM,C_OP,C_PF,C_TOTAL,EPC_TOTAL,SPAIR_PART,REMARK From CE_PJT_LST Where pKey < 10 Order By pKey, B1 ]
dAryStr[2] = [com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'apitank.CE_PJT_LST' doesn't exist]
dAry[0].length= [1][1]
cAry[0].length= [1][1]
AAA1 rv = [

INT
4
0

VARCHAR
12
0

DOUBLE
8
0

BIGINT
-5
0

VARCHAR
12
0

DOUBLE
8
0

VARCHAR
12
0

BIGINT
-5
0

VARCHAR
12
0

B10

B11

B12

B13

B14

B15

B16

EP1

EP2

EP3

EP4

EP5

EP6

EP7

EP8

EP9

EP10

EP_SUM

EP_OP

EP_PF

EP_TOTAL

OceanF

C_SUM

C_OP

C_PF

C_TOTAL

EPC_TOTAL

SPAIR_PART

REMARK

Tank No.

Product

Design Code

Main Material

Inner Tank Size (m)

Outer Tank Size (m)

Storage Capacity per Tank

Design Pressure

Corrosion allowance

Design S.G

Shell Thick. (Out)

Q'TY

NET STEEL WEIGHT

Engineering Cost (설계비)

Material Purchsing (원재료)

Purchasing Item (구입품)

RTD for Cool-Down

Insulation Material (보냉재)

Fabrication (제작비)

Shop Insepction and Test

Shop Primer

Packing and T/R (운송포장)

Module Assembly(부두조립, BALL TANK)

Sub Total

Over Head

Profit

EP 부문 Total(1)

Ocean Freight (해상운송)

Inland T/R (내륙윤송)

Construction Cost (인건비/장비비/기타 등)

Support for Pre-commission (1명 2개월)

Welding Rod

Test and Inspection (Excluding H.T Water)

Site Painting

Insulation (Work)

Tank Calibration

SUB TOTAL

Over Head

Profit

C 부문 Total(2)

EPC 총합계 (1)+(2)　　
GRAND TOTAL

Spare parts for 2-years (Option)

REMARK

TankNo

Product

Design Code

Material

Inner_Dm
(m)

Inner_Hm
(m)

Outer_Dm
(m)

Outer_Hm
(m)

Volume
(ｍ³)

D_Pressure
(mm)

CA
(mm)

thk
(mm)

UQTY
Unit(대)

NETWT_Ton
(Ton)

EP1
(USD)

EP2
(USD)

EP3
(USD)

EP4
(USD)

EP5
(USD)

EP6
(USD)

EP7
(USD)

EP8
(USD)

EP9
(USD)

EP10
(USD)

EP_SUM
(USD)

EP_OP
(USD)

EP_PF
(USD)

EP_TOTAL
(USD)

OceanF
(USD)

C1
(USD)

C2
(USD)

C3
(USD)

C4
(USD)

C5
(USD)

C6
(USD)

C7
(USD)

C8
(USD)

C_SUM
(USD)

C_OP
(USD)

C_PF
(USD)

C_TOTAL
(USD)

EPC_TOTAL
(USD)

SPAIR_PART
(USD)

REMARK

dAry[0].length= [1][1]
cAry[0].length= [1][1]
rv = [

No.	Description		Unit
k=2, j=2	Tank No.
k=3, j=3	Product
k=4, j=4	Design Code
k=5, j=5	Main Material
k=6, j=6	Inner Tank Size (m)		(m)
k=7, j=7	Inner Tank Size (m)		(m)
k=8, j=8	Outer Tank Size (m)		(m)
k=9, j=9	Outer Tank Size (m)		(m)
k=10, j=10	Storage Capacity per Tank		(ｍ³)
k=11, j=11	Design Pressure		(mm)
k=12, j=12	Corrosion allowance		(mm)
k=13, j=13	Design S.G
k=14, j=14	Shell Thick. (Out)		(mm)
k=15, j=15	Q'TY		Unit(대)
k=16, j=16	NET STEEL WEIGHT		(Ton)
k=17, j=17	Engineering Cost (설계비)	1
k=18, j=18	Material Purchsing (원재료)	2
k=19, j=19	Purchasing Item (구입품)	3
k=20, j=20	RTD for Cool-Down	4
k=21, j=21	Insulation Material (보냉재)	5
k=22, j=22	Fabrication (제작비)	6
k=23, j=23	Shop Insepction and Test	7
k=24, j=24	Shop Primer	8
k=25, j=25	Packing and T/R (운송포장)	9
k=26, j=26	Module Assembly(부두조립, BALL TANK)	10
k=27, j=27	Sub Total	EP.1	(USD)
k=28, j=28	Over Head	EP.2	(USD)
k=29, j=29	Profit	EP.3	(USD)
k=30, j=30	EP 부문 Total(1)		(USD)
k=31, j=31	Ocean Freight (해상운송)	15
k=32, j=32	Inland T/R (내륙윤송)	16
k=33, j=33	Construction Cost (인건비/장비비/기타 등)	17
k=34, j=34	Support for Pre-commission (1명 2개월)	18
k=35, j=35	Welding Rod	19
k=36, j=36	Test and Inspection (Excluding H.T Water)	20
k=37, j=37	Site Painting	21
k=38, j=38	Insulation (Work)	22
k=39, j=39	Tank Calibration	23
k=40, j=40	SUB TOTAL	C.1	(USD)
k=41, j=41	Over Head	C.2	(USD)
k=42, j=42	Profit	C.3	(USD)
k=43, j=43	C 부문 Total(2)		(USD)
k=44, j=44	EPC 총합계 (1)+(2)　　 GRAND TOTAL		(USD)
k=45, j=45	Spare parts for 2-years (Option)		(USD)
k=46, j=46	REMARK
자세히

31.18 Material Purchsing (원재료) 산출 내역서 / 재질코드 의 OUTER JOIN
query[0] = [Select A.C1, F.N1, A.C2, F.N2, A.C3, F.N3, A.M_CODE, B.재질, A.UNITWT `(S)중량<BR>(Ton)`, A.UNITPRICE `UNIT PRICE<BR>(USD/Ton)`, A.PRICE_USD `(S)자재비<BR>USD` From `CE_PJT_EP` A LEFT OUTER JOIN `CE_FAB_CODE` F ON ( A.C1=F.C1 and A.C2=F.C2 ) LEFT OUTER JOIN `CE_MATEIAL_CD` B ON ( A.pKey=3 and B.C3 > 0 AND A.M_CODE=B.C3 ) Where A.pKey=3 AND A.C1 > 1 AND A.C3 >= 0 Order By A.C1, A.C3 ]
dAry.length = [1]
111 query[2] = [Insert Into `CE_PJT_EP` ( pKey, C1,C2,C3, M_CODE,MATL ) Select 3 as pKey, C1,C2,C3, M_CODE,MATL FROM `CE_FAB_CODE` Order By C1, C3 ]
ERROR MESSAGE:[java.lang.NullPointerException]
Document End