(김준회) ECC I/F 관련 작업

- ECC 인터페이스 수신테이블 notNull 조건 제거 (테스트 데이터 문제)
- 수신 라우트의 구조 불일치 문제 처리

1 files changed, 18 insertions, 18 deletions

diff --git a/db/schema/ECC/ecc.ts b/db/schema/ECC/ecc.ts
index af726678..4d4198c7 100644
--- a/db/schema/ECC/ecc.ts
+++ b/db/schema/ECC/ecc.ts
@@ -22,7 +22,7 @@ export const PR_INFORMATION_T_BID_HEADER = ECCSchema.table(
     EKGRP: varchar({ length: 10 }), // Purchaing Group // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
     EKORG: varchar({ length: 10 }), // Purchasing Organization // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
     WERKS: varchar({ length: 10 }), // Plant // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
-    ZBSART: varchar({ length: 10 }).notNull(), // Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
+    ZBSART: varchar({ length: 10 }), // Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
     ZRFQ_TRS_DT: varchar({ length: 10 }), // Date on Creating Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
     ZRFQ_TRS_TM: varchar({ length: 10 }), // Time of Creating Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
 
@@ -37,10 +37,10 @@ export const PR_INFORMATION_T_BID_ITEM = ECCSchema.table(
   {
     id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
     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
+    ANFPS: varchar({ length: 10 }), // 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
-    BANPO: varchar({ length: 10 }).notNull(), // Item Number of Purchase Requisition // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
+    BANFN: varchar({ length: 10 }), // Purchase Requisition Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
+    BANPO: varchar({ length: 10 }), // Item Number of Purchase Requisition // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
     BPRME: varchar({ length: 10 }), // Order Price Unit (Purchasing) // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
     BRGEW: decimal({ precision: 15, scale: 3 }), // Gross Weight // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
     DISMM: varchar({ length: 10 }), // MRP Type // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
@@ -87,19 +87,19 @@ export const ZMM_PCR = ECCSchema.table('ZMM_PCR', {
   // 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(),
+  PCR_REQ_DATE: varchar({ length: 255 }),
   // 4,ZMM_PCR,EBELN,M,CHAR,10,구매오더
-  EBELN: varchar({ length: 255 }).notNull(),
+  EBELN: varchar({ length: 255 }),
   // 5,ZMM_PCR,EBELP,M,NUMC,5,구매오더 품번
-  EBELP: varchar({ length: 255 }).notNull(),
+  EBELP: varchar({ length: 255 }),
   // 6,ZMM_PCR,PCR_TYPE,M,CHAR,2,"물량/Spec 변경 Type : Q, W, S, QW"
-  PCR_TYPE: varchar({ length: 255 }).notNull(),
+  PCR_TYPE: varchar({ length: 255 }),
   // 7,ZMM_PCR,PSPID,,CHAR,24,프로젝트
   PSPID: varchar({ length: 255 }),
   // 8,ZMM_PCR,BANFN,M,CHAR,10,구매요청
-  BANFN: varchar({ length: 255 }).notNull(),
+  BANFN: varchar({ length: 255 }),
   // 9,ZMM_PCR,BNFPO,M,NUMC,5,구매요청 품번
-  BNFPO: varchar({ length: 255 }).notNull(),
+  BNFPO: varchar({ length: 255 }),
   // 10,ZMM_PCR,MATNR,,CHAR,18,자재번호
   MATNR: varchar({ length: 255 }),
   // 11,ZMM_PCR,MAKTX,,CHAR,40,자재명
@@ -358,7 +358,7 @@ export const ZMM_PAY = ECCSchema.table('ZMM_PAY', {
   EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
 
   // 69,ZMM_HD/ZMM_PAY,ZPAYSEQ,M,CHAR,2,선급금차수
-  ZPAYSEQ: varchar({ length: 255 }).notNull(),
+  ZPAYSEQ: varchar({ length: 255 }),
   // 70,ZMM_HD/ZMM_PAY,ZADVTYP,M,CHAR,1,선급금타입
   ZADVTYP: varchar({ length: 255 }),
   // 71,ZMM_HD/ZMM_PAY,ZDWPRT,M,NUMC,3,선급금비율
@@ -632,9 +632,9 @@ export const ZMM_NOTE = ECCSchema.table('ZMM_NOTE', {
   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(),
+  ZNOTE_SER: varchar({ length: 255 }),
   // 188,ZMM_HD/ZMM_NOTE,ZNOTE_TXT,M,CHAR,4000,발주 Note Text
-  ZNOTE_TXT: varchar({ length: 10000 }).notNull(),
+  ZNOTE_TXT: varchar({ length: 10000 }),
 
   createdAt: timestamp('created_at').defaultNow().notNull(),
   updatedAt: timestamp('updated_at').defaultNow().notNull(),
@@ -649,9 +649,9 @@ export const ZMM_NOTE2 = ECCSchema.table('ZMM_NOTE2', {
   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(),
+  ZDLV_PRICE_SER: varchar({ length: 255 }),
   // 190,ZMM_HD/ZMM_NOTE2,ZDLV_PRICE_NOTE,,CHAR,4000,연동제 Note Text
-  ZDLV_PRICE_NOTE: varchar({ length: 10000 }).notNull(),
+  ZDLV_PRICE_NOTE: varchar({ length: 10000 }),
 
   createdAt: timestamp('created_at').defaultNow().notNull(),
   updatedAt: timestamp('updated_at').defaultNow().notNull(),
@@ -669,11 +669,11 @@ export const T_CHANGE_PR = ECCSchema.table('T_CHANGE_PR', {
   // 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(),
+  BANFN: varchar({ length: 255 }),
   // 4,T_CHANGE_PR,BANPO,M,,NUMC,5,,Item Number of Purchase Requisition
-  BANPO: varchar({ length: 255 }).notNull(),
+  BANPO: varchar({ length: 255 }),
   // 5,T_CHANGE_PR,ZCHG_NO,M,,CHAR,10,,Change Number
-  ZCHG_NO: varchar({ length: 255 }).notNull(),
+  ZCHG_NO: varchar({ length: 255 }),
   // 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.