summaryrefslogtreecommitdiff
path: root/db/schema/ECC
diff options
context:
space:
mode:
authorjoonhoekim <26rote@gmail.com>2025-08-04 11:07:10 +0000
committerjoonhoekim <26rote@gmail.com>2025-08-04 11:07:10 +0000
commit305a29e0e245ed9de1a7f4d32e96634116dcda82 (patch)
treebba0f654d7072ab8b619ac08ccc4b988fef143f3 /db/schema/ECC
parent4dc27e9495b005b29b4d7a2ad404c8c0644769eb (diff)
(김준회) SOAP ECC 개선, 린터 오류 해결, 구매 기준정보(인코텀즈, 지불조건, 장소(출발지, 도착지)) Non-SAP 동기화 처리
Diffstat (limited to 'db/schema/ECC')
-rw-r--r--db/schema/ECC/ecc.ts2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema/ECC/ecc.ts b/db/schema/ECC/ecc.ts
index e836909e..a1dfe15b 100644
--- a/db/schema/ECC/ecc.ts
+++ b/db/schema/ECC/ecc.ts
@@ -19,7 +19,7 @@ export const PR_INFORMATION_T_BID_HEADER = ECCSchema.table(
'PR_INFORMATION_T_BID_HEADER',
{
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().unique(), // Bidding/RFQ Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
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