(김준회) PCR, PO, 변경PR 거절사유 수신 라우트 구현 (ECC 인터페이스), 세일즈포스 POC 테스트페이지 추가 (경로가 파트너 내부인 이유는 CORS 추가한 경로이기 때문이며, 수정될 수 있음), shi-api 유저 업데이트 로직 개선(분할정복패턴)

1 files changed, 619 insertions, 3 deletions

diff --git a/db/schema/ECC/ecc.ts b/db/schema/ECC/ecc.ts
index a1dfe15b..af726678 100644
--- a/db/schema/ECC/ecc.ts
+++ b/db/schema/ECC/ecc.ts
@@ -6,14 +6,13 @@ import {
   pgSchema,
 } from 'drizzle-orm/pg-core';
 
-// 적용된 WSDL 파일: IF_ECC_EVCP_PR_INFORMATION.wsdl
-
 // WSDL 정의에서 CHG_GB, 응답할 메시지 타입(성공/실패) 및 내용은 메타데이터이다.
 // 따라서 로깅 테이블에 저장하고, 별도 스키마를 생성하지는 않는다.
 
 // S-ERP에서 받는 ECC 데이터를 MDG와 구분하기 위해 스키마를 새로 생성한다.
 export const ECCSchema = pgSchema('ecc');
 
+// *** === START === WSDL FILE: IF_ECC_EVCP_PR_INFORMATION.wsdl === ***
 // Table: PR_INFORMATION_T_BID_HEADER
 export const PR_INFORMATION_T_BID_HEADER = ECCSchema.table(
   'PR_INFORMATION_T_BID_HEADER',
@@ -37,7 +36,7 @@ export const PR_INFORMATION_T_BID_ITEM = ECCSchema.table(
   'PR_INFORMATION_T_BID_ITEM',
   {
     id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
-    ANFNR: varchar({ length: 10 }).notNull(), // Bidding/RFQ Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
+    ANFNR: varchar({ length: 10 }).notNull().references(() => PR_INFORMATION_T_BID_HEADER.ANFNR), // Bidding/RFQ Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
     ANFPS: varchar({ length: 10 }).notNull(), // Item Number of Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
     AUFNR: varchar({ length: 12 }), // Order Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
     BANFN: varchar({ length: 10 }).notNull(), // Purchase Requisition Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
@@ -72,3 +71,620 @@ export const PR_INFORMATION_T_BID_ITEM = ECCSchema.table(
     updatedAt: timestamp('updated_at').defaultNow().notNull(),
   }
 );
+// *** === END === WSDL FILE: IF_ECC_EVCP_PR_INFORMATION.wsdl === ***
+
+
+
+
+// *** === START === WSDL FILE: IF_ECC_EVCP_PCR.wsdl === ***
+// PCR (Purchase Change Request) 테이블
+export const ZMM_PCR = ECCSchema.table('ZMM_PCR', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // SEQ,Table,Field,M/O,Type,Size,Description
+  // 1,ZMM_PCR,PCR_REQ,M,CHAR,10,PCR 요청번호
+  PCR_REQ: varchar({ length: 255 }).notNull().unique(),
+  // 2,ZMM_PCR,PCR_REQ_SEQ,M,NUMC,5,PCR 요청순번
+  PCR_REQ_SEQ: varchar({ length: 255 }).notNull(),
+  // 3,ZMM_PCR,PCR_REQ_DATE,M,DATS,8,PCR 요청일자
+  PCR_REQ_DATE: varchar({ length: 255 }).notNull(),
+  // 4,ZMM_PCR,EBELN,M,CHAR,10,구매오더
+  EBELN: varchar({ length: 255 }).notNull(),
+  // 5,ZMM_PCR,EBELP,M,NUMC,5,구매오더 품번
+  EBELP: varchar({ length: 255 }).notNull(),
+  // 6,ZMM_PCR,PCR_TYPE,M,CHAR,2,"물량/Spec 변경 Type : Q, W, S, QW"
+  PCR_TYPE: varchar({ length: 255 }).notNull(),
+  // 7,ZMM_PCR,PSPID,,CHAR,24,프로젝트
+  PSPID: varchar({ length: 255 }),
+  // 8,ZMM_PCR,BANFN,M,CHAR,10,구매요청
+  BANFN: varchar({ length: 255 }).notNull(),
+  // 9,ZMM_PCR,BNFPO,M,NUMC,5,구매요청 품번
+  BNFPO: varchar({ length: 255 }).notNull(),
+  // 10,ZMM_PCR,MATNR,,CHAR,18,자재번호
+  MATNR: varchar({ length: 255 }),
+  // 11,ZMM_PCR,MAKTX,,CHAR,40,자재명
+  MAKTX: varchar({ length: 255 }),
+  // 12,ZMM_PCR,ZZSPEC,,CHAR,255,Specification
+  ZZSPEC: varchar({ length: 255 }),
+  // 13,ZMM_PCR,ZSPEC_NUM,,CHAR,25,POS
+  ZSPEC_NUM: varchar({ length: 255 }),
+  // 14,ZMM_PCR,QTY_B,,QUAN,"13,3",변경 전 수량
+  QTY_B: varchar({ length: 255 }),
+  // 15,ZMM_PCR,QTY_A,,QUAN,"13,3",변경 후 수량
+  QTY_A: varchar({ length: 255 }),
+  // 16,ZMM_PCR,MEINS,,UNIT,3,단위
+  MEINS: varchar({ length: 255 }),
+  // 17,ZMM_PCR,T_WEIGHT_B,,QUAN,"13,3",변경 전 Total 중량
+  T_WEIGHT_B: varchar({ length: 255 }),
+  // 18,ZMM_PCR,T_WEIGHT_A,,QUAN,"13,3",변경 후 Total 중량
+  T_WEIGHT_A: varchar({ length: 255 }),
+  // 19,ZMM_PCR,MEINS_W,,UNIT,3,중량 단위
+  MEINS_W: varchar({ length: 255 }),
+  // 20,ZMM_PCR,S_WEIGHT_B,,QUAN,"13,3",변경 전 사급 중량
+  S_WEIGHT_B: varchar({ length: 255 }),
+  // 21,ZMM_PCR,S_WEIGHT_A,,QUAN,"13,3",변경 후 사급 중량
+  S_WEIGHT_A: varchar({ length: 255 }),
+  // 22,ZMM_PCR,C_WEIGHT_B,,QUAN,"13,3",변경 전 도급 중량
+  C_WEIGHT_B: varchar({ length: 255 }),
+  // 23,ZMM_PCR,C_WEIGHT_A,,QUAN,"13,3",변경 후 도급 중량
+  C_WEIGHT_A: varchar({ length: 255 }),
+  // 24,ZMM_PCR,ZACC_DT,,DATS,8,구매담당자 PR 접수일
+  ZACC_DT: varchar({ length: 255 }),
+  // 25,ZMM_PCR,ERDAT,,DATS,8,물량 변경일
+  ERDAT: varchar({ length: 255 }),
+  // 26,ZMM_PCR,DEPTCD,,CHAR,10,설계부서
+  DEPTCD: varchar({ length: 255 }),
+  // 27,ZMM_PCR,DEPTNM,,CHAR,60,설계부서명
+  DEPTNM: varchar({ length: 255 }),
+  // 28,ZMM_PCR,EMPID,,CHAR,20,설계담당자ID
+  EMPID: varchar({ length: 255 }),
+  // 29,ZMM_PCR,NAME,,CHAR,70,설계담당명
+  NAME: varchar({ length: 255 }),
+  // 30,ZMM_PCR,LIFNR,M,CHAR,10,공급업체
+  LIFNR: varchar({ length: 255 }),
+  // 31,ZMM_PCR,NAME1,,CHAR,35,공급업체명
+  NAME1: varchar({ length: 255 }),
+  // 32,ZMM_PCR,ZPROC_IND,,CHAR,1,PR 상태
+  ZPROC_IND: varchar({ length: 255 }),
+  // 33,ZMM_PCR,LFDAT,,DATS,8,PR 납품일
+  LFDAT: varchar({ length: 255 }),
+  // 34,ZMM_PCR,WAERS,M,CUKY,5,PO 통화
+  WAERS: varchar({ length: 255 }),
+  // 35,ZMM_PCR,NETPR,M,CURR,"13,2",PO 단가
+  NETPR: varchar({ length: 255 }),
+  // 36,ZMM_PCR,PEINH,,DEC,5,"Price Unit, 수량에 대한 PER 당 단가"
+  PEINH: varchar({ length: 255 }),
+  // 37,ZMM_PCR,NETWR,M,CURR,"13,2",PO 금액
+  NETWR: varchar({ length: 255 }),
+  // 38,ZMM_PCR,POSID,,CHAR,24,WBS
+  POSID: varchar({ length: 255 }),
+  // 39,ZMM_PCR,EKGRP,,CHAR,3,구매그룹
+  EKGRP: varchar({ length: 255 }),
+  // 40,ZMM_PCR,EKNAM,,CHAR,18,구매그룹명
+  EKNAM: varchar({ length: 255 }),
+  // 41,ZMM_PCR,ZCHG_NO,,CHAR,10,(ECC 내부목적) PR 수정번호
+  ZCHG_NO: varchar({ length: 255 }),
+  // 42,ZMM_PCR,DOKNR,,CHAR,25,(ECC 내부목적) 도면번호
+  DOKNR: varchar({ length: 255 }),
+  // 43,ZMM_PCR,DOKAR,,CHAR,3,(ECC 내부목적) 도면문서Type
+  DOKAR: varchar({ length: 255 }),
+  // 44,ZMM_PCR,DOKTL,,CHAR,3,(ECC 내부목적) 도면문서Part
+  DOKTL: varchar({ length: 255 }),
+  // 45,ZMM_PCR,DOKVR,,CHAR,2,(ECC 내부목적) 도면문서버젼
+  DOKVR: varchar({ length: 255 }),
+  // 46,ZMM_PCR,ZAEDAT,,DATS,8,(ECC 내부목적) 도면변경일
+  ZAEDAT: varchar({ length: 255 }),
+  // 47,ZMM_PCR,WERKS,,CHAR,4,PLANT
+  WERKS: varchar({ length: 255 }),
+  // 48,ZMM_PCR,REQUEST_CD,,CHAR,10,Request 코드
+  REQUEST_CD: varchar({ length: 255 }),
+  // 49,ZMM_PCR,REQUEST_RSN,,CHAR,50,Request 사유
+  REQUEST_RSN: varchar({ length: 255 }),
+
+  // 수신 처리 완료하고, 응답해줄 형식은 다음과 같다.
+  // 하나의 요청이 여러 데이터셋을 가지고 있는데, 응답은 하나의 요청에 대해 한번만 하며, 에 저장하지 않음
+  // 50,ZMM_RT (수신측 응답),PCR_REQ,M,CHAR,10,PCR 요청번호
+  // 51,ZMM_RT (수신측 응답),PCR_REQ_SEQ,M,NUMC,5,PCR 요청순번
+  // 52,ZMM_RT (수신측 응답),EBELN,M,CHAR,10,구매오더
+  // 53,ZMM_RT (수신측 응답),EBELP,M,NUMC,5,구매오더 품번
+  // 54,ZMM_RT (수신측 응답),MSGTY,,CHAR,1,Message Type
+  // 55,ZMM_RT (수신측 응답),MSGTXT,,CHAR,100,Message Text
+
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+// *** === END === WSDL FILE: IF_ECC_EVCP_PCR.wsdl === ***
+
+
+
+
+// *** === START === WSDL FILE: IF_ECC_EVCP_PO_INFORMATION.wsdl === ***
+export const ZMM_HD = ECCSchema.table('ZMM_HD', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // SEQ,Table,Field,M/O,Type,Size,Description
+  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
+  EBELN: varchar({ length: 255 }).notNull().unique(),
+  // 2,ZMM_HD,BUKRS,M,CHAR,4,회사코드
+  BUKRS: varchar({ length: 255 }),
+  // 3,ZMM_HD,BSTYP,M,CHAR,1,구매문서범주
+  BSTYP: varchar({ length: 255 }),
+  // 4,ZMM_HD,BSART,M,CHAR,4,구매문서유형
+  BSART: varchar({ length: 255 }),
+  // 5,ZMM_HD,LOEKZ,M,CHAR,1,구매문서삭제지시자
+  LOEKZ: varchar({ length: 255 }),
+  // 6,ZMM_HD,AEDAT,M,DATS,8,생성일자
+  AEDAT: varchar({ length: 255 }),
+  // 7,ZMM_HD,ERNAM,M,CHAR,13,생성자ID
+  ERNAM: varchar({ length: 255 }),
+  // 8,ZMM_HD,LIFNR,M,CHAR,10,VENDOR코드
+  LIFNR: varchar({ length: 255 }),
+  // 9,ZMM_HD,ZTERM,M,CHAR,4,지급조건코드
+  ZTERM: varchar({ length: 255 }),
+  // 10,ZMM_HD,EKORG,M,CHAR,4,구매조직코드
+  EKORG: varchar({ length: 255 }),
+  // 11,ZMM_HD,EKGRP,M,CHAR,3,구매그룹코드
+  EKGRP: varchar({ length: 255 }),
+  // 12,ZMM_HD,WKURS,M,DEC,"9,5",환율
+  WKURS: varchar({ length: 255 }),
+  // 13,ZMM_HD,BEDAT,M,DATS,8,구매증빙일자
+  BEDAT: varchar({ length: 255 }),
+  // 14,ZMM_HD,INCO1,M,CHAR,3,인도조건코드
+  INCO1: varchar({ length: 255 }),
+  // 15,ZMM_HD,ZSHIPMT_PLC_CD,M,CHAR,5,선적지코드
+  ZSHIPMT_PLC_CD: varchar({ length: 255 }),
+  // 16,ZMM_HD,ZUNLD_PLC_CD,M,CHAR,5,하역지코드
+  ZUNLD_PLC_CD: varchar({ length: 255 }),
+  // 17,ZMM_HD,ZIND_CD,M,CHAR,2,증감코드
+  ZIND_CD: varchar({ length: 255 }),
+  // 18,ZMM_HD,ZDAMT_DD_SUBRT,M,DEC,"6,2",지체상금일일공제율
+  ZDAMT_DD_SUBRT: varchar({ length: 255 }),
+  // 19,ZMM_HD,ZMAX_SUBRT,M,DEC,"6,2",최대공제율
+  ZMAX_SUBRT: varchar({ length: 255 }),
+  // 20,ZMM_HD,ZCNRT_GRNT_CD,M,CHAR,1,계약보증코드
+  ZCNRT_GRNT_CD: varchar({ length: 255 }),
+  // 21,ZMM_HD,ZDFCT_GRNT_CD,M,CHAR,1,하자보증코드
+  ZDFCT_GRNT_CD: varchar({ length: 255 }),
+  // 22,ZMM_HD,ZGRNT_PRD_CD,M,CHAR,1,보증기간코드
+  ZGRNT_PRD_CD: varchar({ length: 255 }),
+  // 23,ZMM_HD,ZPAMT_YN,M,CHAR,1,선급금여부
+  ZPAMT_YN: varchar({ length: 255 }),
+  // 24,ZMM_HD,ZBGT_AMT,M,CURR,"17,2","예산금액, ZBTG_CURR"
+  ZBGT_AMT: varchar({ length: 255 }),
+  // 25,ZMM_HD,ZBGT_CURR,M,CUKY,3,예산금액 통화키
+  ZBGT_CURR: varchar({ length: 255 }),
+  // 26,ZMM_HD,ZPO_AMT,M,CURR,"17,2",발주금액
+  ZPO_AMT: varchar({ length: 255 }),
+  // 27,ZMM_HD,ZPO_AMT_KRW,M,CURR,"17,2",발주금액 KRW
+  ZPO_AMT_KRW: varchar({ length: 255 }),
+  // 28,ZMM_HD,ZPO_CURR,M,CUKY,5,통화키
+  ZPO_CURR: varchar({ length: 255 }),
+  // 29,ZMM_HD,ZCHG_PO_DT,M,DATS,8,변경발주일자
+  ZCHG_PO_DT: varchar({ length: 255 }),
+  // 30,ZMM_HD,ZPO_CNFM_STAT,M,CHAR,1,구매오더확인상태
+  ZPO_CNFM_STAT: varchar({ length: 255 }),
+  // 31,ZMM_HD,ZOWN_AGR_IND_YN,M,CHAR,1,선주승인필요여부
+  ZOWN_AGR_IND_YN: varchar({ length: 255 }),
+  // 32,ZMM_HD,ZELC_AGR_DT,M,DATS,8,전자승인일자
+  ZELC_AGR_DT: varchar({ length: 255 }),
+  // 33,ZMM_HD,ZELC_AGR_TM,M,TIMS,6,전자승인시간
+  ZELC_AGR_TM: varchar({ length: 255 }),
+  // 34,ZMM_HD,ZELC_CNRT_ND_YN,M,CHAR,1,전자계약필요여부
+  ZELC_CNRT_ND_YN: varchar({ length: 255 }),
+  // 35,ZMM_HD,ZPO_DT,M,DATS,8,발주일자
+  ZPO_DT: varchar({ length: 255 }),
+  // 36,ZMM_HD,ZPLN_INO_GB,M,CHAR,1,계획내외구분
+  ZPLN_INO_GB: varchar({ length: 255 }),
+  // 37,ZMM_HD,ZECAL_BSE,M,CHAR,1,정산기준
+  ZECAL_BSE: varchar({ length: 255 }),
+  // 38,ZMM_HD,ZWGT_ECAL_GB,M,CHAR,1,중량정산구분
+  ZWGT_ECAL_GB: varchar({ length: 255 }),
+  // 39,ZMM_HD,ZPO_TRANS_DT,M,DATS,8,발주전송일자
+  ZPO_TRANS_DT: varchar({ length: 255 }),
+  // 40,ZMM_HD,ZPO_TRANS_CANC,M,DATS,1,전송여부지시자
+  ZPO_TRANS_CANC: varchar({ length: 255 }),
+  // 41,ZMM_HD,ZVST_TMS,M,NUMC,9,방문횟수
+  ZVST_TMS: varchar({ length: 255 }),
+  // 42,ZMM_HD,ZSVC_WK_PRD,M,NUMC,9,SE작업일수
+  ZSVC_WK_PRD: varchar({ length: 255 }),
+  // 43,ZMM_HD,ZDT_EXCS_AMT,M,CURR,"17,2",일초과금액1
+  ZDT_EXCS_AMT: varchar({ length: 255 }),
+  // 44,ZMM_HD,ZDT_EXCS_AMT2,M,CURR,"17,2",일초과금액2
+  ZDT_EXCS_AMT2: varchar({ length: 255 }),
+  // 45,ZMM_HD,ZDT_EXCS_AMT3,M,CURR,"17,2",일초과금액3
+  ZDT_EXCS_AMT3: varchar({ length: 255 }),
+  // 46,ZMM_HD,ZSVC_CNRT_CUR,M,CUKY,5,SE계약통화
+  ZSVC_CNRT_CUR: varchar({ length: 255 }),
+  // 47,ZMM_HD,ZPAY_GB,M,CHAR,1,기타비용처리구분
+  ZPAY_GB: varchar({ length: 255 }),
+  // 48,ZMM_HD,ZFULL_COMM,M,CHAR,1,수수료전체부담여부
+  ZFULL_COMM: varchar({ length: 255 }),
+  // 49,ZMM_HD,PSPID,M,CHAR,24,프로젝트 번호
+  PSPID: varchar({ length: 255 }),
+  // 50,ZMM_HD,ZCON_NO,M,CHAR,10,구매통합번호
+  ZCON_NO: varchar({ length: 255 }),
+  // 51,ZMM_HD,ZTITLE,M,CHAR,90,발주제목
+  ZTITLE: varchar({ length: 255 }),
+  // 52,ZMM_HD,ZPO_VER,M,NUMC,2,발주버전
+  ZPO_VER: varchar({ length: 255 }),
+  // 53,ZMM_HD,ITEM_CATEGORY,M,CHAR,2,선물환 Item Category
+  ITEM_CATEGORY: varchar({ length: 255 }),
+  // 54,ZMM_HD,LTEXT,M,CHAR,60,선물환 Item Category 명
+  LTEXT: varchar({ length: 255 }),
+  // 55,ZMM_HD,ITEM_NO,M,CHAR,3,PO의 ITEM 수 (인터페이스검증)
+  ITEM_NO: varchar({ length: 255 }),
+  // 56,ZMM_HD,USECD,M,CHAR,20,사용코드
+  USECD: varchar({ length: 255 }),
+  // 57,ZMM_HD,ETC_2,M,CHAR,100,확장2
+  ETC_2: varchar({ length: 255 }),
+  // 58,ZMM_HD,ETC_3,M,CHAR,100,확장3
+  ETC_3: varchar({ length: 255 }),
+  // 59,ZMM_HD,ETC_4,M,CHAR,100,확장4
+  ETC_4: varchar({ length: 255 }),
+  // 60,ZMM_HD,ETC_5,M,CHAR,100,확장5
+  ETC_5: varchar({ length: 255 }),
+  // 61,ZMM_HD,ETC_6,M,CHAR,100,확장6
+  ETC_6: varchar({ length: 255 }),
+  // 62,ZMM_HD,ETC_7,M,CHAR,100,확장7
+  ETC_7: varchar({ length: 255 }),
+  // 63,ZMM_HD,ETC_8,M,CHAR,100,확장8
+  ETC_8: varchar({ length: 255 }),
+  // 64,ZMM_HD,ETC_9,M,CHAR,100,확장9
+  ETC_9: varchar({ length: 255 }),
+  // 65,ZMM_HD,ETC_10,M,CHAR,100,확장10
+  ETC_10: varchar({ length: 255 }),
+  // 66,ZMM_HD,ZDLV_PRICE_T,,CHAR,1,"납품대금연동제대상여부 (Y:대상, N:미대상, 공백:미해당)"
+  ZDLV_PRICE_T: varchar({ length: 255 }),
+  // 67,ZMM_HD,ZWEBELN,,CHAR,10,서면계약번호
+  ZWEBELN: varchar({ length: 255 }),
+  // 68,ZMM_HD,ZVER_NO,,NUMC,3,서면계약차수
+  ZVER_NO: varchar({ length: 255 }),
+
+  // 응답은 전체 요청에 대해 하나의 메시지만 전송하며, 데이터베이스에 저장하지 않음
+  // 191,ZMM_RT,EBELN,M,CHAR,10,구매오더번호
+  // 192,ZMM_RT,RT_CODE,M,CHAR,1,IF상태
+  // 193,ZMM_RT,RT_TEXT,M,CHAR,100,IF메세지
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+})
+
+export const ZMM_PAY = ECCSchema.table('ZMM_PAY', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // FK
+  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
+  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
+
+  // 69,ZMM_HD/ZMM_PAY,ZPAYSEQ,M,CHAR,2,선급금차수
+  ZPAYSEQ: varchar({ length: 255 }).notNull(),
+  // 70,ZMM_HD/ZMM_PAY,ZADVTYP,M,CHAR,1,선급금타입
+  ZADVTYP: varchar({ length: 255 }),
+  // 71,ZMM_HD/ZMM_PAY,ZDWPRT,M,NUMC,3,선급금비율
+  ZDWPRT: varchar({ length: 255 }),
+  // 72,ZMM_HD/ZMM_PAY,ZDWPAMT,M,CURR,"17,2",선급금
+  ZDWPAMT: varchar({ length: 255 }),
+  // 73,ZMM_HD/ZMM_PAY,ZDWPDAT,M,DATS,8,지불계획일자
+  ZDWPDAT: varchar({ length: 255 }),
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+
+export const ZMM_DT = ECCSchema.table('ZMM_DT', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // FK
+  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
+  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
+
+  // 74,ZMM_HD/ZMM_DT,EBELP,M,NUMC,5,구매오더품목번호
+  EBELP: varchar({ length: 255 }),
+  // 75,ZMM_HD/ZMM_DT,LOEKZ,M,CHAR,1,구매문서삭제지시자
+  LOEKZ: varchar({ length: 255 }),
+  // 76,ZMM_HD/ZMM_DT,AEDAT,M,DATS,8,변경일자
+  AEDAT: varchar({ length: 255 }),
+  // 77,ZMM_HD/ZMM_DT,MAKTX,M,CHAR,120,자재내역
+  MAKTX: varchar({ length: 255 }),
+  // 78,ZMM_HD/ZMM_DT,MATKL,M,CHAR,9,자재그룹
+  MATKL: varchar({ length: 255 }),
+  // 79,ZMM_HD/ZMM_DT,MATNR,M,CHAR,18,자재코드
+  MATNR: varchar({ length: 255 }),
+  // 80,ZMM_HD/ZMM_DT,WERKS,M,CHAR,4,플랜트코드
+  WERKS: varchar({ length: 255 }),
+  // 81,ZMM_HD/ZMM_DT,LGORT,M,CHAR,10,저장위치
+  LGORT: varchar({ length: 255 }),
+  // 82,ZMM_HD/ZMM_DT,BEDNR,M,CHAR,10,요청추적번호
+  BEDNR: varchar({ length: 255 }),
+  // 83,ZMM_HD/ZMM_DT,MENGE,M,QUAN,"13,3",구매오더수량
+  MENGE: varchar({ length: 255 }),
+  // 84,ZMM_HD/ZMM_DT,NETPR,M,CURR,"17,2",구매단가
+  NETPR: varchar({ length: 255 }),
+  // 85,ZMM_HD/ZMM_DT,PEINH,M,DEC,5,가격단위값
+  PEINH: varchar({ length: 255 }),
+  // 86,ZMM_HD/ZMM_DT,NETWR,M,CURR,"17,2",오더정가
+  NETWR: varchar({ length: 255 }),
+  // 87,ZMM_HD/ZMM_DT,BRTWR,M,CURR,"17,2",오더총액
+  BRTWR: varchar({ length: 255 }),
+  // 88,ZMM_HD/ZMM_DT,WEBAZ,M,DEC,3,입고소요일수
+  WEBAZ: varchar({ length: 255 }),
+  // 89,ZMM_HD/ZMM_DT,MWSKZ,M,CHAR,2,매출부가가치세코드
+  MWSKZ: varchar({ length: 255 }),
+  // 90,ZMM_HD/ZMM_DT,INSMK,M,CHAR,1,재고유형
+  INSMK: varchar({ length: 255 }),
+  // 91,ZMM_HD/ZMM_DT,BWTAR,M,CHAR,10,평가유형
+  BWTAR: varchar({ length: 255 }),
+  // 92,ZMM_HD/ZMM_DT,BWTTY,M,CHAR,1,평가범주
+  BWTTY: varchar({ length: 255 }),
+  // 93,ZMM_HD/ZMM_DT,ELIKZ,M,CHAR,1,납품완료지시자
+  ELIKZ: varchar({ length: 255 }),
+  // 94,ZMM_HD/ZMM_DT,EREKZ,M,CHAR,1,최종송장지시자
+  EREKZ: varchar({ length: 255 }),
+  // 95,ZMM_HD/ZMM_DT,TWRKZ,M,CHAR,1,분할송장지시자
+  TWRKZ: varchar({ length: 255 }),
+  // 96,ZMM_HD/ZMM_DT,REPOS,M,CHAR,1,송장수령지시자
+  REPOS: varchar({ length: 255 }),
+  // 97,ZMM_HD/ZMM_DT,WEBRE,M,CHAR,1,GR송장검증지시자
+  WEBRE: varchar({ length: 255 }),
+  // 98,ZMM_HD/ZMM_DT,KNTTP,M,CHAR,1,계정지정범주
+  KNTTP: varchar({ length: 255 }),
+  // 99,ZMM_HD/ZMM_DT,NTGEW,M,QUAN,"13,3",순중량
+  NTGEW: varchar({ length: 255 }),
+  // 100,ZMM_HD/ZMM_DT,GEWEI,M,UNIT,3,중량단위
+  GEWEI: varchar({ length: 255 }),
+  // 101,ZMM_HD/ZMM_DT,BRGEW,M,QUAN,"15,3",총중량
+  BRGEW: varchar({ length: 255 }),
+  // 102,ZMM_HD/ZMM_DT,VOLUM,M,QUAN,"15,3",볼륨
+  VOLUM: varchar({ length: 255 }),
+  // 103,ZMM_HD/ZMM_DT,VOLEH,M,UNIT,3,볼륨단위
+  VOLEH: varchar({ length: 255 }),
+  // 104,ZMM_HD/ZMM_DT,BANFN,M,CHAR,10,구매요청번호
+  BANFN: varchar({ length: 255 }),
+  // 105,ZMM_HD/ZMM_DT,BNFPO,M,NUMC,5,구매요청품목번호
+  BNFPO: varchar({ length: 255 }),
+  // 106,ZMM_HD/ZMM_DT,UPTYP,M,CHAR,1,하위품목범주
+  UPTYP: varchar({ length: 255 }),
+  // 107,ZMM_HD/ZMM_DT,UPVOR,M,CHAR,1,하위품목존재여부
+  UPVOR: varchar({ length: 255 }),
+  // 108,ZMM_HD/ZMM_DT,ZPO_DLV_DT,M,DATS,8,PO납기일자
+  ZPO_DLV_DT: varchar({ length: 255 }),
+  // 109,ZMM_HD/ZMM_DT,ZSHIP_DT,M,DATS,8,생산소요선적일자
+  ZSHIP_DT: varchar({ length: 255 }),
+  // 110,ZMM_HD/ZMM_DT,ZDST_CD,M,CHAR,4,강재도착지코드
+  ZDST_CD: varchar({ length: 255 }),
+  // 111,ZMM_HD/ZMM_DT,ZRCV_DT,M,DATS,8,구매접수일자
+  ZRCV_DT: varchar({ length: 255 }),
+  // 112,ZMM_HD/ZMM_DT,ZCON_NO,M,CHAR,10,구매통합번호
+  ZCON_NO: varchar({ length: 255 }),
+  // 113,ZMM_HD/ZMM_DT,ZCON_IND,M,CHAR,1,시리즈구분
+  ZCON_IND: varchar({ length: 255 }),
+  // 114,ZMM_HD/ZMM_DT,ZCHAR_CD,M,CHAR,1,"물성코드,풍력 일련번호 처리여부"
+  ZCHAR_CD: varchar({ length: 255 }),
+  // 115,ZMM_HD/ZMM_DT,ZMAT_AREA,M,QUAN,"13,3",자재면적
+  ZMAT_AREA: varchar({ length: 255 }),
+  // 116,ZMM_HD/ZMM_DT,ZSZ,M,CHAR,50,품목사이즈
+  ZSZ: varchar({ length: 255 }),
+  // 117,ZMM_HD/ZMM_DT,ZAF_ECAL_AMT,M,CURR,"17,2","사후정산금액(참고: NETWR), ZPO_CURR"
+  ZAF_ECAL_AMT: varchar({ length: 255 }),
+  // 118,ZMM_HD/ZMM_DT,ZPLN_ST_DT,M,DATS,8,예정시작일자
+  ZPLN_ST_DT: varchar({ length: 255 }),
+  // 119,ZMM_HD/ZMM_DT,ZPLN_ED_DT,M,DATS,8,예정종료일자
+  ZPLN_ED_DT: varchar({ length: 255 }),
+  // 120,ZMM_HD/ZMM_DT,PSPID,M,CHAR,24,프로젝트번호
+  PSPID: varchar({ length: 255 }),
+  // 121,ZMM_HD/ZMM_DT,ZUSD_BGT,M,CURR,"17,2",미화예산
+  ZUSD_BGT: varchar({ length: 255 }),
+  // 122,ZMM_HD/ZMM_DT,ZKRW_BGT,M,CURR,"17,2",원화예산
+  ZKRW_BGT: varchar({ length: 255 }),
+  // 123,ZMM_HD/ZMM_DT,ZDLV_CNTLR,M,CHAR,3,조달담당자코드
+  ZDLV_CNTLR: varchar({ length: 255 }),
+  // 124,ZMM_HD/ZMM_DT,ANFNR,M,CHAR,10,RFQ번호
+  ANFNR: varchar({ length: 255 }),
+  // 125,ZMM_HD/ZMM_DT,ANFPS,M,NUMC,5,RFQ품목번호
+  ANFPS: varchar({ length: 255 }),
+  // 126,ZMM_HD/ZMM_DT,KONNR,M,CHAR,10,계약번호
+  KONNR: varchar({ length: 255 }),
+  // 127,ZMM_HD/ZMM_DT,KTPNR,M,NUMC,5,계약항목번호
+  KTPNR: varchar({ length: 255 }),
+  // 128,ZMM_HD/ZMM_DT,ZCR_NO,M,CHAR,40,CR번호
+  ZCR_NO: varchar({ length: 255 }),
+  // 129,ZMM_HD/ZMM_DT,ZCR_AMT,M,CURR,"17,2",EXTRA CREDIT 금액
+  ZCR_AMT: varchar({ length: 255 }),
+  // 130,ZMM_HD/ZMM_DT,ZRT_CUR,M,CUKY,3,실적통화
+  ZRT_CUR: varchar({ length: 255 }),
+  // 131,ZMM_HD/ZMM_DT,ZRT_AMT,M,CURR,"17,2","실적금액, ZRT_CURR"
+  ZRT_AMT: varchar({ length: 255 }),
+  // 132,ZMM_HD/ZMM_DT,ZPO_UNIT,M,UNIT,3,구매오더수량단위
+  ZPO_UNIT: varchar({ length: 255 }),
+  // 133,ZMM_HD/ZMM_DT,ZREF_NETPR,M,CURR,"17,2","참조단가, ZPO_CURR"
+  ZREF_NETPR: varchar({ length: 255 }),
+  // 134,ZMM_HD/ZMM_DT,ZNETPR,M,CURR,"17,2","발주단가, ZPO_CURR"
+  ZNETPR: varchar({ length: 255 }),
+  // 135,ZMM_HD/ZMM_DT,BPRME,M,UNIT,3,구매단가단위
+  BPRME: varchar({ length: 255 }),
+  // 136,ZMM_HD/ZMM_DT,ZDISPLN,M,CHAR,1,설계기능
+  ZDISPLN: varchar({ length: 255 }),
+  // 137,ZMM_HD/ZMM_DT,ZORCT_CNRT_KRW,M,CURR,"17,2",외주비계약KRW
+  ZORCT_CNRT_KRW: varchar({ length: 255 }),
+  // 138,ZMM_HD/ZMM_DT,ZORCT_CNRT_USD,M,CURR,"17,2",외주비계약USD
+  ZORCT_CNRT_USD: varchar({ length: 255 }),
+  // 139,ZMM_HD/ZMM_DT,ZETC_CNRT_KRW,M,CURR,"17,2",기타계약KRW
+  ZETC_CNRT_KRW: varchar({ length: 255 }),
+  // 140,ZMM_HD/ZMM_DT,ZETC_CNRT_USD,M,CURR,"17,2",기타계약USD
+  ZETC_CNRT_USD: varchar({ length: 255 }),
+  // 141,ZMM_HD/ZMM_DT,ZEXTRA_AMT,M,CURR,"17,2","EXTRA금액, ZPO_CURR"
+  ZEXTRA_AMT: varchar({ length: 255 }),
+  // 142,ZMM_HD/ZMM_DT,ZCRDT_AMT,M,CURR,"17,2","CREDIT금액, ZPO_CURR"
+  ZCRDT_AMT: varchar({ length: 255 }),
+  // 143,ZMM_HD/ZMM_DT,ZART,M,CHAR,2,검사코드
+  ZART: varchar({ length: 255 }),
+  // 144,ZMM_HD/ZMM_DT,ART,M,CHAR,8,검사유형(QMAT)
+  ART: varchar({ length: 255 }),
+  // 145,ZMM_HD/ZMM_DT,ZPDT_BSE_UPR,M,CURR,"17,2","BASE금액, ZPO_CURR"
+  ZPDT_BSE_UPR: varchar({ length: 255 }),
+  // 146,ZMM_HD/ZMM_DT,ZPDT_EXTRA_UPR,M,CURR,"17,2","EXTRA금액, ZPO_CURR"
+  ZPDT_EXTRA_UPR: varchar({ length: 255 }),
+  // 147,ZMM_HD/ZMM_DT,ZPDT_EXDS_AMT,M,CURR,"17,2","할인/할증금액, ZPO_CURR"
+  ZPDT_EXDS_AMT: varchar({ length: 255 }),
+  // 148,ZMM_HD/ZMM_DT,ZTRNS_UPR,M,CURR,"17,2","운송단가, ZPO_CURR"
+  ZTRNS_UPR: varchar({ length: 255 }),
+  // 149,ZMM_HD/ZMM_DT,ZFST_DST_CD,M,CHAR,4,발주초기착지코드
+  ZFST_DST_CD: varchar({ length: 255 }),
+  // 150,ZMM_HD/ZMM_DT,ZCHG_CHK,M,CHAR,1,물량수정승인여부
+  ZCHG_CHK: varchar({ length: 255 }),
+  // 151,ZMM_HD/ZMM_DT,ZITP_CHK,M,CHAR,1,ITP체크
+  ZITP_CHK: varchar({ length: 255 }),
+  // 152,ZMM_HD/ZMM_DT,ZPO_RMK,M,CHAR,90,발주비고
+  ZPO_RMK: varchar({ length: 255 }),
+  // 153,ZMM_HD/ZMM_DT,ZPO_LOT_NO,M,CHAR,50,Steel Material Marking No
+  ZPO_LOT_NO: varchar({ length: 255 }),
+  // 154,ZMM_HD/ZMM_DT,ZCLM_NO,M,CHAR,10,SR번호
+  ZCLM_NO: varchar({ length: 255 }),
+  // 155,ZMM_HD/ZMM_DT,ZWH_CNTLR,M,CHAR,3,현물담당자코드
+  ZWH_CNTLR: varchar({ length: 255 }),
+  // 156,ZMM_HD/ZMM_DT,LFDAT,M,DATS,8,PR Delivery Date
+  LFDAT: varchar({ length: 255 }),
+  // 157,ZMM_HD/ZMM_DT,ETC_2,M,CHAR,100,확장2
+  ETC_2: varchar({ length: 255 }),
+  // 158,ZMM_HD/ZMM_DT,ETC_3,M,CHAR,100,확장3
+  ETC_3: varchar({ length: 255 }),
+  // 159,ZMM_HD/ZMM_DT,ETC_4,M,CHAR,100,확장4
+  ETC_4: varchar({ length: 255 }),
+  // 160,ZMM_HD/ZMM_DT,ETC_5,M,CHAR,100,확장5
+  ETC_5: varchar({ length: 255 }),
+  // 161,ZMM_HD/ZMM_DT,ETC_6,M,CHAR,100,확장6
+  ETC_6: varchar({ length: 255 }),
+  // 162,ZMM_HD/ZMM_DT,ETC_7,M,CHAR,100,확장7
+  ETC_7: varchar({ length: 255 }),
+  // 163,ZMM_HD/ZMM_DT,ETC_8,M,CHAR,100,확장8
+  ETC_8: varchar({ length: 255 }),
+  // 164,ZMM_HD/ZMM_DT,ETC_9,M,CHAR,100,확장9
+  ETC_9: varchar({ length: 255 }),
+  // 165,ZMM_HD/ZMM_DT,ETC_10,M,CHAR,100,확장10
+  ETC_10: varchar({ length: 255 }),
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+
+export const ZMM_KN = ECCSchema.table('ZMM_KN', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // FK
+  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
+  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
+  // ZMM_DT의 서브테이블이므로 EBELP도 필요
+  EBELP: varchar({ length: 255 }).notNull(),
+
+  // 166,ZMM_HD/ZMM_DT/ZMM_KN,ZEKKN,M,NUMC,2,계정지정순번
+  ZEKKN: varchar({ length: 255 }),
+  // 167,ZMM_HD/ZMM_DT/ZMM_KN,SAKTO,M,CHAR,10,G/L계정번호
+  SAKTO: varchar({ length: 255 }),
+  // 168,ZMM_HD/ZMM_DT/ZMM_KN,GSBER,M,CHAR,4,사업영역코드
+  GSBER: varchar({ length: 255 }),
+  // 169,ZMM_HD/ZMM_DT/ZMM_KN,KOSTL,M,CHAR,10,코스트센터
+  KOSTL: varchar({ length: 255 }),
+  // 170,ZMM_HD/ZMM_DT/ZMM_KN,VBELN,M,CHAR,10,판매오더번호
+  VBELN: varchar({ length: 255 }),
+  // 171,ZMM_HD/ZMM_DT/ZMM_KN,VBELP,M,NUMC,6,판매오더품목번호
+  VBELP: varchar({ length: 255 }),
+  // 172,ZMM_HD/ZMM_DT/ZMM_KN,ANLN1,M,CHAR,12,주요자산번호
+  ANLN1: varchar({ length: 255 }),
+  // 173,ZMM_HD/ZMM_DT/ZMM_KN,ANLN2,M,CHAR,4,자산하위번호
+  ANLN2: varchar({ length: 255 }),
+  // 174,ZMM_HD/ZMM_DT/ZMM_KN,AUFNR,M,CHAR,12,생산오더번호
+  AUFNR: varchar({ length: 255 }),
+  // 175,ZMM_HD/ZMM_DT/ZMM_KN,WEMPF,M,CHAR,20,자재수령인명
+  WEMPF: varchar({ length: 255 }),
+  // 176,ZMM_HD/ZMM_DT/ZMM_KN,ABLAD,M,CHAR,75,하역지점
+  ABLAD: varchar({ length: 255 }),
+  // 177,ZMM_HD/ZMM_DT/ZMM_KN,KOKRS,M,CHAR,4,관리회계영역
+  KOKRS: varchar({ length: 255 }),
+  // 178,ZMM_HD/ZMM_DT/ZMM_KN,PRCTR,M,CHAR,10,손익센터
+  PRCTR: varchar({ length: 255 }),
+  // 179,ZMM_HD/ZMM_DT/ZMM_KN,NPLNR,M,CHAR,12,네트워크오더번호
+  NPLNR: varchar({ length: 255 }),
+  // 180,ZMM_HD/ZMM_DT/ZMM_KN,AUFPL,M,NUMC,10,오더라우팅번호
+  AUFPL: varchar({ length: 255 }),
+  // 181,ZMM_HD/ZMM_DT/ZMM_KN,APLZL,M,NUMC,8,오더내부카운터
+  APLZL: varchar({ length: 255 }),
+  // 182,ZMM_HD/ZMM_DT/ZMM_KN,FIPOS,M,CHAR,14,약정항목
+  FIPOS: varchar({ length: 255 }),
+  // 183,ZMM_HD/ZMM_DT/ZMM_KN,FISTL,M,CHAR,16,자금관리센터
+  FISTL: varchar({ length: 255 }),
+  // 184,ZMM_HD/ZMM_DT/ZMM_KN,GEBER,M,CHAR,10,자금코드
+  GEBER: varchar({ length: 255 }),
+  // 185,ZMM_HD/ZMM_DT/ZMM_KN,VORNR,M,CHAR,4,네트워크작업번호
+  VORNR: varchar({ length: 255 }),
+  // 186,ZMM_HD/ZMM_DT/ZMM_KN,POSID,M,CHAR,24,WBS요소
+  POSID: varchar({ length: 255 }),
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+
+export const ZMM_NOTE = ECCSchema.table('ZMM_NOTE', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // FK
+  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
+  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
+
+  // 187,ZMM_HD/ZMM_NOTE,ZNOTE_SER,M,NUMC,4,발주 Note 순번
+  ZNOTE_SER: varchar({ length: 255 }).notNull(),
+  // 188,ZMM_HD/ZMM_NOTE,ZNOTE_TXT,M,CHAR,4000,발주 Note Text
+  ZNOTE_TXT: varchar({ length: 10000 }).notNull(),
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+
+
+export const ZMM_NOTE2 = ECCSchema.table('ZMM_NOTE2', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // FK
+  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
+  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
+
+  // 189,ZMM_HD/ZMM_NOTE2,ZDLV_PRICE_SER,,NUMC,4,연동제  Note 순번
+  ZDLV_PRICE_SER: varchar({ length: 255 }).notNull(),
+  // 190,ZMM_HD/ZMM_NOTE2,ZDLV_PRICE_NOTE,,CHAR,4000,연동제 Note Text
+  ZDLV_PRICE_NOTE: varchar({ length: 10000 }).notNull(),
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+// *** === END === WSDL FILE: IF_ECC_EVCP_PO_INFORMATION.wsdl === ***
+
+
+
+
+// *** === START === WSDL FILE: IF_ECC_EVCP_REJECT_FOR_REVISED_PR.wsdl === ***
+export const T_CHANGE_PR = ECCSchema.table('T_CHANGE_PR', {
+  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
+
+  // SEQ,Table,Field,M/O,,Type,Size,,Description
+  // 1,메타데이터(저장하지 않음),IV_ERDAT,M,,DATS,8,,Reject Date
+  // 2,메타데이터(저장하지 않음),IV_ERZET,M,,TIMS,6,,Reject  Time
+  // 3,T_CHANGE_PR,BANFN,M,,CHAR,10,,Purchase Requisition Number
+  BANFN: varchar({ length: 255 }).notNull(),
+  // 4,T_CHANGE_PR,BANPO,M,,NUMC,5,,Item Number of Purchase Requisition
+  BANPO: varchar({ length: 255 }).notNull(),
+  // 5,T_CHANGE_PR,ZCHG_NO,M,,CHAR,10,,Change Number
+  ZCHG_NO: varchar({ length: 255 }).notNull(),
+  // 6,T_CHANGE_PR,ZACC_IND,,,CHAR,1,,P/R Accept Indicator
+  ZACC_IND: varchar({ length: 255 }),
+  // 7,T_CHANGE_PR,PCR_REQ,,,CHAR,10,,PCR Request No.
+  PCR_REQ: varchar({ length: 255 }),
+  // 8,T_CHANGE_PR,PCR_REQ_SEQ,,,NUMC,5,,PCR Request Sequence No.
+  PCR_REQ_SEQ: varchar({ length: 255 }),
+  // 응답은 전체 요청에 대해 하나의 메시지만 전송하며, 데이터베이스에 저장하지 않음
+  // 9,수신측 응답,EV_TYPE,,,CHAR,1,,Message Type
+  // 10,수신측 응답,EV_MESSAGE,,,CHAR,100,,Message Text
+
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+// *** === END === WSDL FILE: IF_ECC_EVCP_REJECT_FOR_REVISED_PR.wsdl === ***
\ No newline at end of file