From 0a821afb1a7a0f526e7008aaec160576111c8aa6 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Wed, 15 Oct 2025 10:16:48 +0000
Subject: (임수민) S-ERP 스키마 업데이트 요청 처리
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/S_ERP/s_erp.ts | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'db')

diff --git a/db/schema/S_ERP/s_erp.ts b/db/schema/S_ERP/s_erp.ts
index 5a9ca36c..fc3bc59e 100644
--- a/db/schema/S_ERP/s_erp.ts
+++ b/db/schema/S_ERP/s_erp.ts
@@ -524,7 +524,7 @@ export const technicalGuidanceInvestment = sErpSchema.table("Technical_Guidance_
   FUMNR: varchar({ length: 10 }), // pk
   FUMIT: bigint({ mode: 'number' }), // pk
   DESCR: varchar({ length: 50 }),
-  FU_APPDATE: varchar({ length: 8 }),
+  FU_APPDATE: varchar({ length: 10 }),
   COST_INVEST: varchar({ length: 15 })
 }, (table) => ({
   // FUMNR, FUMIT 복합 PK에 UNIQUE 인덱스 추가
@@ -535,17 +535,17 @@ export const technicalGuidanceOrder = sErpSchema.table("Technical_Guidance_Order
   id: serial().primaryKey(),
   AUFNR: varchar({ length: 12 }), // pk (Order)
   VORNR: varchar({ length: 4 }), // pk (Operation)
-  ORD_ERDAT: varchar({ length: 50 }),
+  ORD_ERDAT: varchar({ length: 10 }),
   FUMNR: varchar({ length: 10 }),
   FUMIT: bigint({ mode: 'number' }),
   DESCR: varchar({ length: 50 }),
-  FU_APPDATE: varchar({ length: 50 }),
+  FU_APPDATE: varchar({ length: 10 }),
   BANFN: varchar({ length: 10 }),
   BNFPO: bigint({ mode: 'number' }),
-  BADAT: varchar({ length: 50 }),
+  BADAT: varchar({ length: 10 }),
   EBELN: varchar({ length: 10 }),
   EBELP: bigint({ mode: 'number' }),
-  PO_ERDAT: varchar({ length: 50 }),
+  PO_ERDAT: varchar({ length: 10 }),
   AUART: varchar({ length: 4 }),
   STTXT: varchar({ length: 40 }),
   EQUNR: varchar({ length: 18 }),
-- 
cgit v1.2.3