1 files changed, 5 insertions, 5 deletions
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 }),