diff options
Diffstat (limited to 'lib/vendor-pool/excel-utils.ts')
| -rw-r--r-- | lib/vendor-pool/excel-utils.ts | 40 |
1 files changed, 3 insertions, 37 deletions
diff --git a/lib/vendor-pool/excel-utils.ts b/lib/vendor-pool/excel-utils.ts index 81426ebd..fe69aa8d 100644 --- a/lib/vendor-pool/excel-utils.ts +++ b/lib/vendor-pool/excel-utils.ts @@ -17,55 +17,24 @@ export interface ExcelColumnConfig { export const vendorPoolExcelColumns: ExcelColumnConfig[] = [ { accessorKey: 'constructionSector', header: '조선/해양', width: 15, required: true }, { accessorKey: 'htDivision', header: 'H/T구분', width: 15, required: true }, - { accessorKey: 'designCategoryCode', header: '설계기능코드', width: 20, required: true }, - { accessorKey: 'designCategory', header: '설계기능(공종)', width: 25 }, // 코드로 자동완성 가능 + { accessorKey: 'discipline', header: '설계공종', width: 25, required: true }, { accessorKey: 'equipBulkDivision', header: 'Equip/Bulk', width: 15 }, - { accessorKey: 'packageCode', header: '패키지코드', width: 20 }, - { accessorKey: 'packageName', header: '패키지명', width: 25 }, { accessorKey: 'materialGroupCode', header: '자재그룹코드', width: 20 }, { accessorKey: 'materialGroupName', header: '자재그룹명', width: 30 }, // 코드로 자동완성 가능 - { accessorKey: 'smCode', header: 'SM Code', width: 15 }, { accessorKey: 'similarMaterialNamePurchase', header: '유사자재명(구매)', width: 25 }, - { accessorKey: 'similarMaterialNameOther', header: '유사자재명(기타)', width: 25 }, { accessorKey: 'vendorCode', header: '협력업체코드', width: 20 }, { accessorKey: 'vendorName', header: '협력업체명', width: 25 }, // 코드로 자동완성 가능 + { accessorKey: 'taxId', header: '사업자번호', width: 20 }, { accessorKey: 'faTarget', header: 'FA대상', width: 15, type: 'boolean' }, { accessorKey: 'faStatus', header: 'FA현황', width: 15 }, { accessorKey: 'tier', header: '등급', width: 15, required: true }, - { accessorKey: 'isAgent', header: 'Agent여부', width: 15, type: 'boolean' }, - { accessorKey: 'contractSignerCode', header: '계약서명주체코드', width: 20 }, - { accessorKey: 'contractSignerName', header: '계약서명주체명', width: 25 }, // 코드로 자동완성 가능 { accessorKey: 'headquarterLocation', header: '본사위치', width: 20, required: true }, { accessorKey: 'manufacturingLocation', header: '제작/선적지', width: 20, required: true }, { accessorKey: 'avlVendorName', header: 'AVL등재업체명', width: 25, required: true }, { accessorKey: 'similarVendorName', header: '유사업체명', width: 25 }, - { accessorKey: 'hasAvl', header: 'AVL보유', width: 15, type: 'boolean' }, { accessorKey: 'isBlacklist', header: '블랙리스트', width: 15, type: 'boolean' }, { accessorKey: 'isBcc', header: 'BCC', width: 15, type: 'boolean' }, { accessorKey: 'purchaseOpinion', header: '구매의견', width: 30 }, - // 선종 - { accessorKey: 'shipTypeCommon', header: '선종공통', width: 15, type: 'boolean' }, - { accessorKey: 'shipTypeAmax', header: 'A-MAX', width: 15, type: 'boolean' }, - { accessorKey: 'shipTypeSmax', header: 'S-MAX', width: 15, type: 'boolean' }, - { accessorKey: 'shipTypeVlcc', header: 'VLCC', width: 15, type: 'boolean' }, - { accessorKey: 'shipTypeLngc', header: 'LNGC', width: 15, type: 'boolean' }, - { accessorKey: 'shipTypeCont', header: '컨테이너선', width: 15, type: 'boolean' }, - // 해양플랜트 - { accessorKey: 'offshoreTypeCommon', header: '해양플랜트공통', width: 20, type: 'boolean' }, - { accessorKey: 'offshoreTypeFpso', header: 'FPSO', width: 15, type: 'boolean' }, - { accessorKey: 'offshoreTypeFlng', header: 'FLNG', width: 15, type: 'boolean' }, - { accessorKey: 'offshoreTypeFpu', header: 'FPU', width: 15, type: 'boolean' }, - { accessorKey: 'offshoreTypePlatform', header: '플랫폼', width: 15, type: 'boolean' }, - { accessorKey: 'offshoreTypeWtiv', header: 'WTIV', width: 15, type: 'boolean' }, - { accessorKey: 'offshoreTypeGom', header: 'GOM', width: 15, type: 'boolean' }, - // 담당자 정보 - { accessorKey: 'picName', header: '담당자명', width: 20 }, - { accessorKey: 'picEmail', header: '담당자이메일', width: 30 }, - { accessorKey: 'picPhone', header: '담당자연락처', width: 20 }, - // 대행사 정보 - { accessorKey: 'agentName', header: '대행사명', width: 20 }, - { accessorKey: 'agentEmail', header: '대행사이메일', width: 30 }, - { accessorKey: 'agentPhone', header: '대행사연락처', width: 20 }, // 최근 거래 정보 { accessorKey: 'recentQuoteDate', header: '최근견적일', width: 20 }, { accessorKey: 'recentQuoteNumber', header: '최근견적번호', width: 25 }, @@ -151,15 +120,13 @@ export async function createVendorPoolTemplate(filename?: string) { const guideContent = [ '', '■ 필수 입력 필드 (헤더가 빨간색)', - ' - 조선/해양, H/T구분, 설계기능코드', + ' - 조선/해양, H/T구분, 설계공종', ' - 등급, 본사위치, 제작/선적지, AVL등재업체명', '', '■ 자동완성 기능 (코드 입력 시)', ' 1. 코드가 있는 경우 → 코드만 입력하면 명칭 자동완성', - ' • 설계기능코드 → 설계기능명', ' • 자재그룹코드 → 자재그룹명', ' • 협력업체코드 → 협력업체명', - ' • 계약서명주체코드 → 계약서명주체명', '', ' 2. 코드가 없는 경우 → 명칭 직접 입력', '', @@ -170,7 +137,6 @@ export async function createVendorPoolTemplate(filename?: string) { '■ 입력 규칙', ' - 조선/해양: "조선" 또는 "해양"', ' - H/T구분: "H", "T", "공통"', - ' - 설계기능코드: 2자리 이하', ' - Equip/Bulk: "E", "B", "S" (1자리)', ' - 등급: "Tier 1", "Tier 2", "등급 외"' ] |