diff options
| -rw-r--r-- | db/schema/S_ERP/s_erp.ts | 10 |
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 }),
|