(김준회) PO 및 RFQ 관련 구매 피드백 반영

- PO매핑 오류 수정, 스키마 컬럼추가, 숫자포매팅 등
- rfq 담당자 문제 수정 등

5 files changed, 264 insertions, 55 deletions

diff --git a/lib/po/vendor-table/service.ts b/lib/po/vendor-table/service.ts
index 224dd2f1..bc4a693b 100644
--- a/lib/po/vendor-table/service.ts
+++ b/lib/po/vendor-table/service.ts
@@ -366,14 +366,60 @@ export async function getVendorPOItems(contractId: number): Promise<VendorPOItem
         id: contractItems.id,
         contractId: contractItems.contractId,
         itemId: contractItems.itemId,
+        itemNo: contractItems.itemNo, // EBELP - 구매오더품목번호 (품번)
+        prNo: contractItems.prNo, // BANFN - 구매요청번호 (PR번호)
+        prItemNo: contractItems.prItemNo, // BNFPO - 구매요청품목번호 (PR 품번)
+        materialGroup: contractItems.materialGroup, // MATKL - 자재그룹
+        weight: contractItems.weight, // NTGEW - 순중량
+        weightUnit: contractItems.weightUnit, // GEWEI - 중량단위
+        totalWeight: contractItems.totalWeight, // BRGEW - 총중량
         description: contractItems.description,
         quantity: contractItems.quantity,
-        unitPrice: contractItems.unitPrice,
+        unitPrice: contractItems.unitPrice, // NETPR - 구매단가
+        
+        // 가격 관련 추가 필드
+        PEINH: contractItems.PEINH, // 가격단위값
+        BPRME: contractItems.BPRME, // 구매단가단위
+        ZNETPR: contractItems.ZNETPR, // 발주단가
+        ZREF_NETPR: contractItems.ZREF_NETPR, // 참조단가
+        
         taxRate: contractItems.taxRate,
         taxAmount: contractItems.taxAmount,
+        taxType: contractItems.taxType, // MWSKZ - 매출부가가치세코드
         totalLineAmount: contractItems.totalLineAmount,
         remark: contractItems.remark,
         
+        // SAP ECC 추가 필드들
+        ZPO_UNIT: contractItems.ZPO_UNIT, // 구매오더수량단위
+        NETWR: contractItems.NETWR, // 오더정가 (최종 정가)
+        BRTWR: contractItems.BRTWR, // 오더총액 (기본 총액)
+        ZPDT_EXDS_AMT: contractItems.ZPDT_EXDS_AMT, // 할인/할증금액
+        
+        // 위치 정보
+        WERKS: contractItems.WERKS, // 플랜트코드
+        LGORT: contractItems.LGORT, // 저장위치
+        
+        // RFQ 추적
+        ANFNR: contractItems.ANFNR, // RFQ번호
+        ANFPS: contractItems.ANFPS, // RFQ품목번호
+        
+        // 자재 추적
+        ZPO_LOT_NO: contractItems.ZPO_LOT_NO, // Steel Material Marking No
+        
+        // 볼륨 정보
+        VOLUM: contractItems.VOLUM, // 볼륨
+        VOLEH: contractItems.VOLEH, // 볼륨단위
+        
+        // 날짜 정보
+        ZPO_DLV_DT: contractItems.ZPO_DLV_DT, // PO납기일자
+        ZPLN_ST_DT: contractItems.ZPLN_ST_DT, // 예정시작일자
+        ZPLN_ED_DT: contractItems.ZPLN_ED_DT, // 예정종료일자
+        LFDAT: contractItems.LFDAT, // PR Delivery Date
+        ZRCV_DT: contractItems.ZRCV_DT, // 구매접수일자
+        
+        // 기타
+        ZCON_IND: contractItems.ZCON_IND, // 시리즈구분
+        
         // contracts 테이블 필드들
         contractNo: contracts.contractNo,
         
@@ -393,33 +439,74 @@ export async function getVendorPOItems(contractId: number): Promise<VendorPOItem
       .orderBy(contractItems.id);
 
     // VendorPOItem 타입으로 변환
+    // SAP에서 제공하지 않는 데이터는 임의로 만들지 않고 그대로 표시 (FE에서 '-' 처리)
     const vendorPOItems: VendorPOItem[] = rawItems.map(row => ({
       contractNo: row.contractNo || '',
-      itemNo: row.itemCode || 'AUTO-ITEM', // mock 데이터용
-      prNo: `PR-${new Date().getFullYear()}-${String(row.id).padStart(4, '0')}`, // mock 데이터용
-      materialGroup: row.packageCode || 'Unknown Group',
-      priceStandard: 'FOB', // mock 데이터용 기본값
+      itemNo: row.itemNo || '', // EBELP - 구매오더품목번호 (품번)
+      prNo: row.prNo || '', // BANFN - 구매요청번호 (PR번호)
+      prItemNo: row.prItemNo || '', // BNFPO - 구매요청품목번호 (PR 품번)
+      materialGroup: row.materialGroup || '', // MATKL - 자재그룹
+      priceStandard: '', // SAP에서 제공되지 않음 - FE에서 '-' 처리
       materialNo: row.itemCode || '',
       itemDescription: row.itemName || '',
       materialSpec: row.description || '',
-      fittingNo: undefined, // contract_items에 없는 필드
-      cert: undefined, // contract_items에 없는 필드
+      fittingNo: undefined, // SAP에서 제공되지 않음
+      cert: undefined, // SAP에서 제공되지 않음
       material: row.gradeMaterial || undefined,
       specification: row.description || '',
-      quantity: row.quantity || 1,
-      quantityUnit: row.unitOfMeasure || 'EA',
-      weight: undefined, // contract_items에 없는 필드
-      weightUnit: undefined, // contract_items에 없는 필드
-      totalWeight: undefined, // contract_items에 없는 필드
-      unitPrice: row.unitPrice ? Number(row.unitPrice) : 0,
-      priceUnit: 'KRW', // 기본값
-      priceUnitValue: '원/EA', // 기본값
-      contractAmount: row.totalLineAmount ? Number(row.totalLineAmount) : 0,
-      adjustmentAmount: undefined, // contract_items에 없는 필드
-      deliveryDate: new Date().toISOString().split('T')[0], // 기본값 (오늘 날짜)
-      vatType: row.taxRate && Number(row.taxRate) > 0 ? '과세' : '면세',
+      quantity: row.quantity ?? 0, // null/undefined면 0, 0이면 0 표시
+      quantityUnit: row.ZPO_UNIT || row.unitOfMeasure || '', // SAP 단위 우선, 없으면 items 테이블 단위
+      ZPO_UNIT: row.ZPO_UNIT || undefined, // SAP 구매오더수량단위
+      weight: row.weight ? Number(row.weight) : undefined, // NTGEW - 순중량
+      weightUnit: row.weightUnit || undefined, // GEWEI - 중량단위
+      totalWeight: row.totalWeight ? Number(row.totalWeight) : undefined, // BRGEW - 총중량
+      unitPrice: row.unitPrice ? Number(row.unitPrice) : 0, // NETPR - 구매단가
+      
+      // 가격 관련 추가 필드
+      PEINH: row.PEINH ?? undefined, // 가격단위값
+      BPRME: row.BPRME || undefined, // 구매단가단위
+      ZNETPR: row.ZNETPR ? Number(row.ZNETPR) : undefined, // 발주단가
+      ZREF_NETPR: row.ZREF_NETPR ? Number(row.ZREF_NETPR) : undefined, // 참조단가
+      
+      priceUnit: row.BPRME || '', // BPRME을 priceUnit으로 사용
+      priceUnitValue: row.PEINH ? String(row.PEINH) : '', // PEINH를 priceUnitValue로 사용
+      contractAmount: row.NETWR ? Number(row.NETWR) : (row.totalLineAmount ? Number(row.totalLineAmount) : 0), // NETWR 우선, 없으면 totalLineAmount
+      adjustmentAmount: row.ZPDT_EXDS_AMT ? Number(row.ZPDT_EXDS_AMT) : undefined, // SAP 조정금액
+      
+      // SAP ECC 금액 필드
+      NETWR: row.NETWR ? Number(row.NETWR) : undefined, // 오더정가 (최종 정가)
+      BRTWR: row.BRTWR ? Number(row.BRTWR) : undefined, // 오더총액 (기본 총액)
+      ZPDT_EXDS_AMT: row.ZPDT_EXDS_AMT ? Number(row.ZPDT_EXDS_AMT) : undefined, // 할인/할증금액
+      
+      // 위치 정보
+      WERKS: row.WERKS || undefined, // 플랜트코드
+      LGORT: row.LGORT || undefined, // 저장위치
+      
+      // RFQ 추적
+      ANFNR: row.ANFNR || undefined, // RFQ번호
+      ANFPS: row.ANFPS || undefined, // RFQ품목번호
+      
+      // 자재 추적
+      ZPO_LOT_NO: row.ZPO_LOT_NO || undefined, // Steel Material Marking No
+      
+      // 볼륨 정보
+      VOLUM: row.VOLUM ? Number(row.VOLUM) : undefined, // 볼륨
+      VOLEH: row.VOLEH || undefined, // 볼륨단위
+      
+      deliveryDate: row.ZPO_DLV_DT || '', // SAP 납기일자, 없으면 빈 문자열 (FE에서 '-' 처리)
+      ZPO_DLV_DT: row.ZPO_DLV_DT || undefined, // SAP PO납기일자
+      ZPLN_ST_DT: row.ZPLN_ST_DT || undefined, // SAP 예정시작일자
+      ZPLN_ED_DT: row.ZPLN_ED_DT || undefined, // SAP 예정종료일자
+      LFDAT: row.LFDAT || undefined, // PR Delivery Date
+      ZRCV_DT: row.ZRCV_DT || undefined, // 구매접수일자
+      
+      // 기타
+      ZCON_IND: row.ZCON_IND || undefined, // 시리즈구분 (SS 등)
+      
+      vatType: row.taxType || '', // MWSKZ - 매출부가가치세코드 (V1, V2 등)
       steelSpec: row.steelType || undefined,
-      prManager: 'AUTO-MANAGER', // mock 데이터용 기본값
+      prManager: '', // SAP에서 제공되지 않음 - FE에서 '-' 처리
+      remark: row.remark || undefined,
     }));
 
     return vendorPOItems;
diff --git a/lib/po/vendor-table/types.ts b/lib/po/vendor-table/types.ts
index f8bc3ea2..e318ff39 100644
--- a/lib/po/vendor-table/types.ts
+++ b/lib/po/vendor-table/types.ts
@@ -76,8 +76,9 @@ export interface VendorPO {
 
 export interface VendorPOItem {
   contractNo: string // PO/계약번호
-  itemNo: string // 품번
-  prNo: string // P/R번호
+  itemNo: string // 품번 (EBELP)
+  prNo: string // P/R번호 (BANFN)
+  prItemNo: string // PR 품번 (BNFPO)
   materialGroup: string // 자재그룹(명)
   priceStandard: string // 단가기준
   materialNo: string // 자재번호
@@ -89,16 +90,54 @@ export interface VendorPOItem {
   material?: string // 재질
   specification: string // 규격
   quantity: number // 수량
-  quantityUnit: string // 수량단위
+  quantityUnit: string // 수량단위 (기존)
+  ZPO_UNIT?: string // SAP 구매오더수량단위
   weight?: number // 중량
   weightUnit?: string // 중량단위
   totalWeight?: number // 총중량
-  unitPrice: number // 단가기준 (단가)
+  unitPrice: number // 단가기준 (단가 - NETPR)
+  
+  // 가격 관련 추가 필드
+  PEINH?: number // 가격단위값 (예: 1, 10, 100)
+  BPRME?: string // 구매단가단위 (EA, KG 등)
+  ZNETPR?: number // 발주단가
+  ZREF_NETPR?: number // 참조단가
+  
   priceUnit: string // 단가단위
   priceUnitValue: string // 가격단위값
-  contractAmount: number // PO계약금액
-  adjustmentAmount?: number // 조정금액
-  deliveryDate: string // 납기일자
+  contractAmount: number // PO계약금액 (기존 필드 - 호환성 유지)
+  adjustmentAmount?: number // 조정금액 (기존 필드 - 호환성 유지)
+  
+  // SAP ECC 금액 필드 (금액 관계: NETWR = BRTWR + ZPDT_EXDS_AMT)
+  NETWR?: number // 오더정가 (최종 정가)
+  BRTWR?: number // 오더총액 (기본 총액)
+  ZPDT_EXDS_AMT?: number // 할인/할증금액 (조정금액: 할인은 음수, 할증은 양수)
+  
+  // 위치 정보
+  WERKS?: string // 플랜트코드
+  LGORT?: string // 저장위치
+  
+  // RFQ 추적
+  ANFNR?: string // RFQ번호
+  ANFPS?: string // RFQ품목번호
+  
+  // 자재 추적
+  ZPO_LOT_NO?: string // Steel Material Marking No
+  
+  // 볼륨 정보
+  VOLUM?: number // 볼륨
+  VOLEH?: string // 볼륨단위
+  
+  deliveryDate: string // 납기일자 (기존)
+  ZPO_DLV_DT?: string // SAP PO납기일자
+  ZPLN_ST_DT?: string // SAP 예정시작일자
+  ZPLN_ED_DT?: string // SAP 예정종료일자
+  LFDAT?: string // PR Delivery Date
+  ZRCV_DT?: string // 구매접수일자
+  
+  // 기타
+  ZCON_IND?: string // 시리즈구분 (SS 등)
+  
   vatType: string // VAT구분
   steelSpec?: string // 철의장 SPEC
   prManager: string // P/R 담당자
diff --git a/lib/po/vendor-table/vendor-po-actions.tsx b/lib/po/vendor-table/vendor-po-actions.tsx
index 329d91fd..08fe3f88 100644
--- a/lib/po/vendor-table/vendor-po-actions.tsx
+++ b/lib/po/vendor-table/vendor-po-actions.tsx
@@ -160,13 +160,6 @@ export function VendorPOActions({ row, setRowAction }: VendorPOActionsProps) {
         <DropdownMenuContent align="end">
           <DropdownMenuLabel>액션</DropdownMenuLabel>
           <DropdownMenuItem
-            onClick={() => setRowAction({ row, type: "view-items" })}
-          >
-            <FileTextIcon className="mr-2 h-4 w-4" />
-            상세품목 보기
-          </DropdownMenuItem>
-          <DropdownMenuSeparator />
-          <DropdownMenuItem
             onClick={handlePcrCreate}
             disabled={isLoading || !canCreatePcr}
           >
diff --git a/lib/po/vendor-table/vendor-po-columns.tsx b/lib/po/vendor-table/vendor-po-columns.tsx
index c954b872..de44adce 100644
--- a/lib/po/vendor-table/vendor-po-columns.tsx
+++ b/lib/po/vendor-table/vendor-po-columns.tsx
@@ -9,6 +9,7 @@ import { Checkbox } from "@/components/ui/checkbox"
 import { DataTableColumnHeaderSimple } from "@/components/data-table/data-table-column-simple-header"
 import { VendorPO, VendorPOActionType } from "./types"
 import { VendorPOActions } from "./vendor-po-actions"
+import { formatNumber } from "@/lib/utils"
 
 interface GetVendorColumnsProps {
   setRowAction: React.Dispatch<React.SetStateAction<{ row: { original: VendorPO }; type: VendorPOActionType } | null>>
@@ -193,7 +194,13 @@ export function getVendorColumns({ setRowAction, selectedRows = [], onRowSelect
       ),
       cell: ({ row }) => {
         const amount = row.getValue("totalAmount") as string | number
-        return <div className="text-sm text-right font-mono">{amount || '-'}</div>
+        const currency = row.getValue("currency") as string
+        
+        // 통화별 소수점 자리수 결정 (KRW, JPY: 0자리, 나머지: 2자리)
+        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+        const formattedAmount = formatNumber(amount, decimals)
+        
+        return <div className="text-sm text-right font-mono">{formattedAmount}</div>
       },
       size: 120,
     },
diff --git a/lib/po/vendor-table/vendor-po-items-dialog.tsx b/lib/po/vendor-table/vendor-po-items-dialog.tsx
index 647950c4..d88d88d1 100644
--- a/lib/po/vendor-table/vendor-po-items-dialog.tsx
+++ b/lib/po/vendor-table/vendor-po-items-dialog.tsx
@@ -16,10 +16,10 @@ import {
   TableHeader,
   TableRow,
 } from "@/components/ui/table"
-import { Badge } from "@/components/ui/badge"
 import { Skeleton } from "@/components/ui/skeleton"
 import { VendorPO, VendorPOItem } from "./types"
 import { getVendorPOItemsByContractNo } from "./service"
+import { formatNumber } from "@/lib/utils"
 
 interface VendorPOItemsDialogProps {
   open: boolean
@@ -99,8 +99,9 @@ export function VendorPOItemsDialog({ open, onOpenChange, po }: VendorPOItemsDia
                     <TableHead className="min-w-[120px] whitespace-nowrap">PO/계약번호</TableHead>
                     <TableHead className="min-w-[100px] whitespace-nowrap">품번</TableHead>
                     <TableHead className="min-w-[100px] whitespace-nowrap">P/R번호</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">PR 품번</TableHead>
                     <TableHead className="min-w-[120px] whitespace-nowrap">자재그룹(명)</TableHead>
-                    <TableHead className="min-w-[100px] whitespace-nowrap">단가기준</TableHead>
+                    {/* <TableHead className="min-w-[100px] whitespace-nowrap">단가기준</TableHead> */}
                     <TableHead className="min-w-[100px] whitespace-nowrap">자재번호</TableHead>
                     <TableHead className="min-w-[200px] whitespace-nowrap">품목/자재내역</TableHead>
                     {/* <TableHead className="min-w-[200px] whitespace-nowrap">자재내역사양</TableHead>
@@ -114,15 +115,31 @@ export function VendorPOItemsDialog({ open, onOpenChange, po }: VendorPOItemsDia
                     <TableHead className="min-w-[80px] text-right whitespace-nowrap">중량</TableHead>
                     <TableHead className="min-w-[80px] whitespace-nowrap">중량단위</TableHead>
                     <TableHead className="min-w-[100px] text-right whitespace-nowrap">총중량</TableHead>
-                    <TableHead className="min-w-[100px] text-right whitespace-nowrap">단가기준</TableHead>
-                    <TableHead className="min-w-[80px] whitespace-nowrap">단가단위</TableHead>
-                    <TableHead className="min-w-[100px] whitespace-nowrap">가격단위값</TableHead>
-                    <TableHead className="min-w-[120px] text-right whitespace-nowrap">PO계약금액</TableHead>
-                    <TableHead className="min-w-[100px] text-right whitespace-nowrap">조정금액</TableHead>
+                    <TableHead className="min-w-[100px] text-right whitespace-nowrap">단가(NETPR)</TableHead>
+                    <TableHead className="min-w-[80px] whitespace-nowrap">단가단위(BPRME)</TableHead>
+                    <TableHead className="min-w-[80px] text-right whitespace-nowrap">가격단위값(PEINH)</TableHead>
+                    <TableHead className="min-w-[100px] text-right whitespace-nowrap">참조단가</TableHead>
+                    <TableHead className="min-w-[100px] text-right whitespace-nowrap">발주단가</TableHead>
+                    <TableHead className="min-w-[120px] text-right whitespace-nowrap">기본총액(BRTWR)</TableHead>
+                    <TableHead className="min-w-[120px] text-right whitespace-nowrap">조정금액(ZPDT_EXDS_AMT)</TableHead>
+                    <TableHead className="min-w-[120px] text-right whitespace-nowrap">최종정가(NETWR)</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">예정시작일자</TableHead>
                     <TableHead className="min-w-[100px] whitespace-nowrap">납기일자</TableHead>
-                    <TableHead className="min-w-[80px] whitespace-nowrap">VAT구분</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">예정종료일자</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">PR납기일</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">구매접수일</TableHead>
+                    <TableHead className="min-w-[80px] whitespace-nowrap">세금코드</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">플랜트</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">저장위치</TableHead>
+                    <TableHead className="min-w-[100px] whitespace-nowrap">RFQ번호</TableHead>
+                    <TableHead className="min-w-[80px] whitespace-nowrap">RFQ품번</TableHead>
+                    <TableHead className="min-w-[150px] whitespace-nowrap">LOT No.</TableHead>
+                    <TableHead className="min-w-[80px] text-right whitespace-nowrap">볼륨</TableHead>
+                    <TableHead className="min-w-[80px] whitespace-nowrap">볼륨단위</TableHead>
+                    <TableHead className="min-w-[80px] whitespace-nowrap">시리즈구분</TableHead>
+                    <TableHead className="min-w-[150px] whitespace-nowrap">비고</TableHead>
                     {/* <TableHead className="min-w-[120px] whitespace-nowrap">철의장 SPEC</TableHead> */}
-                    <TableHead className="min-w-[100px] whitespace-nowrap">P/R 담당자</TableHead>
+                    {/* <TableHead className="min-w-[100px] whitespace-nowrap">P/R 담당자</TableHead> */}
                   </TableRow>
                 </TableHeader>
               <TableBody>
@@ -131,8 +148,9 @@ export function VendorPOItemsDialog({ open, onOpenChange, po }: VendorPOItemsDia
                     <TableCell className="font-medium">{item.contractNo || '-'}</TableCell>
                     <TableCell>{item.itemNo || '-'}</TableCell>
                     <TableCell>{item.prNo || '-'}</TableCell>
+                    <TableCell>{item.prItemNo || '-'}</TableCell>
                     <TableCell>{item.materialGroup || '-'}</TableCell>
-                    <TableCell>{item.priceStandard || '-'}</TableCell>
+                    {/* <TableCell>{item.priceStandard || '-'}</TableCell> */}
                     <TableCell className="font-mono text-sm">{item.materialNo || '-'}</TableCell>
                     <TableCell className="max-w-[200px]">
                       <div className="truncate" title={item.itemDescription || ''}>
@@ -151,7 +169,7 @@ export function VendorPOItemsDialog({ open, onOpenChange, po }: VendorPOItemsDia
                     <TableCell>{item.material || '-'}</TableCell>
                     <TableCell>{item.specification || '-'}</TableCell> */}
                     <TableCell className="text-right font-mono">
-                      {item.quantity?.toLocaleString() || '-'}
+                      {item.quantity !== undefined && item.quantity !== null ? item.quantity.toLocaleString() : '-'}
                     </TableCell>
                     <TableCell>{item.quantityUnit || '-'}</TableCell>
                     <TableCell className="text-right font-mono">
@@ -162,20 +180,76 @@ export function VendorPOItemsDialog({ open, onOpenChange, po }: VendorPOItemsDia
                       {item.totalWeight ? item.totalWeight.toLocaleString() : '-'}
                     </TableCell>
                     <TableCell className="text-right font-mono">
-                      {item.unitPrice?.toLocaleString() || '-'}
+                      {(() => {
+                        const currency = po?.currency || ''
+                        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                        return formatNumber(item.unitPrice, decimals)
+                      })()}
                     </TableCell>
-                    <TableCell>{item.priceUnit || '-'}</TableCell>
-                    <TableCell>{item.priceUnitValue || '-'}</TableCell>
-                    <TableCell className="text-right font-mono font-semibold">
-                      {item.contractAmount?.toLocaleString() || '-'}
+                    <TableCell>{item.BPRME || '-'}</TableCell>
+                    <TableCell className="text-right">{item.PEINH ?? '-'}</TableCell>
+                    <TableCell className="text-right font-mono">
+                      {(() => {
+                        const currency = po?.currency || ''
+                        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                        return item.ZREF_NETPR ? formatNumber(item.ZREF_NETPR, decimals) : '-'
+                      })()}
+                    </TableCell>
+                    <TableCell className="text-right font-mono">
+                      {(() => {
+                        const currency = po?.currency || ''
+                        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                        return item.ZNETPR ? formatNumber(item.ZNETPR, decimals) : '-'
+                      })()}
                     </TableCell>
                     <TableCell className="text-right font-mono">
-                      {item.adjustmentAmount ? item.adjustmentAmount.toLocaleString() : '-'}
+                      {(() => {
+                        const currency = po?.currency || ''
+                        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                        return item.BRTWR ? formatNumber(item.BRTWR, decimals) : '-'
+                      })()}
+                    </TableCell>
+                    <TableCell className="text-right font-mono">
+                      {(() => {
+                        const currency = po?.currency || ''
+                        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                        return item.ZPDT_EXDS_AMT ? formatNumber(item.ZPDT_EXDS_AMT, decimals) : '-'
+                      })()}
+                    </TableCell>
+                    <TableCell className="text-right font-mono font-semibold">
+                      {(() => {
+                        const currency = po?.currency || ''
+                        const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                        return item.NETWR ? formatNumber(item.NETWR, decimals) : '-'
+                      })()}
                     </TableCell>
-                    <TableCell>{item.deliveryDate || '-'}</TableCell>
+                    <TableCell>{item.ZPLN_ST_DT || '-'}</TableCell>
+                    <TableCell>{item.ZPO_DLV_DT || item.deliveryDate || '-'}</TableCell>
+                    <TableCell>{item.ZPLN_ED_DT || '-'}</TableCell>
+                    <TableCell>{item.LFDAT || '-'}</TableCell>
+                    <TableCell>{item.ZRCV_DT || '-'}</TableCell>
                     <TableCell>{item.vatType || '-'}</TableCell>
+                    <TableCell>{item.WERKS || '-'}</TableCell>
+                    <TableCell>{item.LGORT || '-'}</TableCell>
+                    <TableCell>{item.ANFNR || '-'}</TableCell>
+                    <TableCell>{item.ANFPS || '-'}</TableCell>
+                    <TableCell className="max-w-[150px]">
+                      <div className="truncate" title={item.ZPO_LOT_NO || ''}>
+                        {item.ZPO_LOT_NO || '-'}
+                      </div>
+                    </TableCell>
+                    <TableCell className="text-right font-mono">
+                      {item.VOLUM ? item.VOLUM.toLocaleString() : '-'}
+                    </TableCell>
+                    <TableCell>{item.VOLEH || '-'}</TableCell>
+                    <TableCell>{item.ZCON_IND || '-'}</TableCell>
+                    <TableCell className="max-w-[150px]">
+                      <div className="truncate" title={item.remark || ''}>
+                        {item.remark || '-'}
+                      </div>
+                    </TableCell>
                     {/* <TableCell>{item.steelSpec || '-'}</TableCell> */}
-                    <TableCell>{item.prManager || '-'}</TableCell>
+                    {/* <TableCell>{item.prManager || '-'}</TableCell> */}
                   </TableRow>
                 ))}
               </TableBody>
@@ -190,7 +264,16 @@ export function VendorPOItemsDialog({ open, onOpenChange, po }: VendorPOItemsDia
               총 {items.length}개 품목
             </div>
             <div className="text-sm font-medium">
-              총 계약금액: {items.reduce((sum, item) => sum + item.contractAmount, 0).toLocaleString()} 원
+              {(() => {
+                // NETWR(최종정가) 합계 계산
+                const totalNETWR = items.reduce((sum, item) => sum + (item.NETWR || item.contractAmount || 0), 0)
+                // 통화별 소수점 자리수 결정 (KRW, JPY: 0자리, 나머지: 2자리)
+                const currency = po?.currency || ''
+                const decimals = (currency === 'KRW' || currency === 'JPY') ? 0 : 2
+                const formattedAmount = formatNumber(totalNETWR, decimals)
+                
+                return `총 계약금액(NETWR): ${currency} ${formattedAmount}`
+              })()}
             </div>
           </div>
         )}