From 4fcbdaff827e298ecd8a57939a287f61cc1b30d6 Mon Sep 17 00:00:00 2001 From: joonhoekim <26rote@gmail.com> Date: Fri, 24 Oct 2025 10:50:51 +0900 Subject: (김준회) 벤더 연락처 삭제 기능 구현 MDG vendor 송신부 csv에 설명 추가 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- public/wsdl/P2MD3007_AO.csv | 92 ++++++++++++++++++++++----------------------- 1 file changed, 46 insertions(+), 46 deletions(-) (limited to 'public') diff --git a/public/wsdl/P2MD3007_AO.csv b/public/wsdl/P2MD3007_AO.csv index 25d3ef65..ddef7bb6 100644 --- a/public/wsdl/P2MD3007_AO.csv +++ b/public/wsdl/P2MD3007_AO.csv @@ -1,47 +1,47 @@ SEQ,Table,Field,M/O,Type,Size,Description -1,SUPPLIER_MASTER,BP_HEADER,M,CHAR,10,Business Partner Number -2,SUPPLIER_MASTER,ZZSRMCD,M,CHAR,20,SRM Vendor Code -3,SUPPLIER_MASTER,SORT1,M,NUMC,20,Search Term 1 -4,SUPPLIER_MASTER,NAME1,M,CHAR,40,Name 1 -5,SUPPLIER_MASTER,NAME2,,CHAR,40,Name 2 -6,SUPPLIER_MASTER,NAME3,,CHAR,40,Name 3 -7,SUPPLIER_MASTER,NAME4,,CHAR,40,Name 4 -8,SUPPLIER_MASTER,KTOKK,M,CHAR,4,Vendor account group -9,SUPPLIER_MASTER,ZTYPE,,CHAR,2,Account Group type -10,SUPPLIER_MASTER,VBUND,,CHAR,6,Company ID of Trading Partner -11,SUPPLIER_MASTER,J_1KFREPRE,,CHAR,10,Name of Representative -12,SUPPLIER_MASTER,J_1KFTBUS,,CHAR,30,Type of Business -13,SUPPLIER_MASTER,J_1KFTIND,,CHAR,30,Type of Industry -14,SUPPLIER_MASTER,VQMGRP,,CHAR,20,Vendor QM Group -15,SUPPLIER_MASTER,VTELNO,,CHAR,30,Vendor QM Group Tel. -16,SUPPLIER_MASTER,VEMAIL,,CHAR,30,Vendor QM Group E-Mail -17,SUPPLIER_MASTER,ZZCNAME1,,CHAR,35,First name -18,SUPPLIER_MASTER,ZZCNAME2,,CHAR,35,Name 1 -19,SUPPLIER_MASTER,ZZTELF1_C,,CHAR,16,First telephone number -20,SUPPLIER_MASTER,MASTERFLAG,M,CHAR,1,Master Flag -21,SUPPLIER_MASTER,IBND_TYPE,M,CHAR,1,Inbound Type -22,SUPPLIER_MASTER,ZZVNDTYP,,CHAR,2,Vendor Type -23,SUPPLIER_MASTER,ZZREQID,M,VARCHAR2,12,Registered User -24,SUPPLIER_MASTER,ZZIND01,,VARCHAR2,1,Indicator 01 -25,SUPPLIER_MASTER,ADDRNO,M,CHAR,10,Address Number -26,SUPPLIER_MASTER,NATION,,CHAR,1,International address version ID -27,SUPPLIER_MASTER,COUNTRY,M,CHAR,3,Country Key -28,SUPPLIER_MASTER,LANGU,,LANG,1,Language Key -29,SUPPLIER_MASTER,POST_CODE1,M,CHAR,10,Postal Code -30,SUPPLIER_MASTER,CITY1,M,CHAR,40,City -31,SUPPLIER_MASTER,CITY2,,CHAR,40,District -32,SUPPLIER_MASTER,REGION,,CHAR,3,"Region (State, Province, County)" -33,SUPPLIER_MASTER,STREET,M,CHAR,60,Street -34,SUPPLIER_MASTER,CONSNUMBER,,NUMC,3,Sequence number -35,SUPPLIER_MASTER,TEL_NUMBER,,CHAR,30,Telephone no.: dialling code+number -36,SUPPLIER_MASTER,TEL_EXTENS,,CHAR,10,Telephone no.: Extension -37,SUPPLIER_MASTER,R3_USER,M,CHAR,1,ndicator: Telephone is a Mobile Telephone -38,SUPPLIER_MASTER,FAX_NUMBER,,CHAR,30,Fax number -39,SUPPLIER_MASTER,FAX_EXTENS,,CHAR,10,Fax no.: Extension -40,SUPPLIER_MASTER,URI_ADDR,,LCHR,2048,Universal Resource Identifier (URI) -41,SUPPLIER_MASTER,SMTP_ADDR,,CHAR,241,E-Mail Address -42,SUPPLIER_MASTER,TAXTYPE,M,CHAR,4,Tax Number Category -43,SUPPLIER_MASTER,TAXNUM,,CHAR,20,Business Partner Tax Number -44,SUPPLIER_MASTER,BP_TX_TYP,,VARCHAR2,6,Resident Registration Number -45,SUPPLIER_MASTER,STCD3,,CHAR,18,법인등록번호 -46,SUPPLIER_MASTER,ZZIND03,,CHAR,1,기업규모 \ No newline at end of file +1,SUPPLIER_MASTER,BP_HEADER,M,CHAR,10,Business Partner Number (벤더코드입력(없는데..어떻게?)) +2,SUPPLIER_MASTER,ZZSRMCD,M,CHAR,20,SRM Vendor Code (SRM코드 없음. 일단 필수값이긴 하니 고정값 보낼 것임.) +3,SUPPLIER_MASTER,SORT1,M,NUMC,20,Search Term 1 (벤더명과 동일하게) +4,SUPPLIER_MASTER,NAME1,M,CHAR,40,Name 1 (벤더명과 동일하게) +5,SUPPLIER_MASTER,NAME2,,CHAR,40,Name 2 (무시) +6,SUPPLIER_MASTER,NAME3,,CHAR,40,Name 3 (무시) +7,SUPPLIER_MASTER,NAME4,,CHAR,40,Name 4 (무시) +8,SUPPLIER_MASTER,KTOKK,M,CHAR,4,Vendor account group (항상 LIEF) +9,SUPPLIER_MASTER,ZTYPE,,CHAR,2,Account Group type (무시) +10,SUPPLIER_MASTER,VBUND,,CHAR,6,Company ID of Trading Partner (무시) +11,SUPPLIER_MASTER,J_1KFREPRE,,CHAR,10,Name of Representative: 대표자명 +12,SUPPLIER_MASTER,J_1KFTBUS,,CHAR,30,Type of Business: 사업유형 +13,SUPPLIER_MASTER,J_1KFTIND,,CHAR,30,Type of Industry: 산업유형 +14,SUPPLIER_MASTER,VQMGRP,,CHAR,20,Vendor QM Group: 무시 +15,SUPPLIER_MASTER,VTELNO,,CHAR,30,Vendor QM Group Tel.: 무시 +16,SUPPLIER_MASTER,VEMAIL,,CHAR,30,Vendor QM Group E-Mail: 무시 +17,SUPPLIER_MASTER,ZZCNAME1,,CHAR,35,First name: ? +18,SUPPLIER_MASTER,ZZCNAME2,,CHAR,35,Name 1: ? +19,SUPPLIER_MASTER,ZZTELF1_C,,CHAR,16,First telephone number: ? +20,SUPPLIER_MASTER,MASTERFLAG,M,CHAR,1,Master Flag: (항상 V?) +21,SUPPLIER_MASTER,IBND_TYPE,M,CHAR,1,Inbound Type: (항상 I?) +22,SUPPLIER_MASTER,ZZVNDTYP,,CHAR,2,Vendor Type: 무시 +23,SUPPLIER_MASTER,ZZREQID,M,VARCHAR2,12,Registered User: (?요청자 녹스ID 대문자?) +24,SUPPLIER_MASTER,ZZIND01,,VARCHAR2,1,Indicator 01: 무시 +25,SUPPLIER_MASTER,ADDRNO,M,CHAR,10,Address Number: (값을 보내면 안된다고 함.. 정의서에 필수값인데..) +26,SUPPLIER_MASTER,NATION,,CHAR,1,International address version ID: (값을 보내면 안된다고 함) +27,SUPPLIER_MASTER,COUNTRY,M,CHAR,3,Country Key: (국가코드 2자리인듯. 내자(국내업체)는 KR) +28,SUPPLIER_MASTER,LANGU,,LANG,1,Language Key: 무시 +29,SUPPLIER_MASTER,POST_CODE1,M,CHAR,10,Postal Code: 우편번호 +30,SUPPLIER_MASTER,CITY1,M,CHAR,40,City: 이게 주소로 쓰이는 걸로 보임. 상세주소 (ex: 한화오션내 H안벽생산지원센터 403) +31,SUPPLIER_MASTER,CITY2,,CHAR,40,District: 무시 +32,SUPPLIER_MASTER,REGION,,CHAR,3,"Region (State, Province, County) : 무시" +33,SUPPLIER_MASTER,STREET,M,CHAR,60,Street: 이게 주소로 쓰이는 걸로 보임. 기본주소 (ex: 경상남도 거제시 거제대로 3370 (한화오션) +34,SUPPLIER_MASTER,CONSNUMBER,,NUMC,3,Sequence number: 뭔지 모르겠음. 같은 벤더 여러값 보낼 때 시퀀스인듯. 단건은 항상1로 고정 +35,SUPPLIER_MASTER,TEL_NUMBER,,CHAR,30,Telephone no.: dialling code+number (-를 포함한 전화번호) +36,SUPPLIER_MASTER,TEL_EXTENS,,CHAR,10,Telephone no.: Extension (내선번호) +37,SUPPLIER_MASTER,R3_USER,M,CHAR,1,Indicator: Telephone is a Mobile Telephone () : (0이면 일반전화 1이면 휴대폰) +38,SUPPLIER_MASTER,FAX_NUMBER,,CHAR,30,Fax number: (팩스번호) +39,SUPPLIER_MASTER,FAX_EXTENS,,CHAR,10,Fax no.: Extension: (팩스내선번호) +40,SUPPLIER_MASTER,URI_ADDR,,LCHR,2048,Universal Resource Identifier (URI): 홈페이지 주소 +41,SUPPLIER_MASTER,SMTP_ADDR,,CHAR,241,E-Mail Address: 대표자이메일 +42,SUPPLIER_MASTER,TAXTYPE,M,CHAR,4,Tax Number Category: 구분기준모름 김태후프로님은 항상 KR2 로 보내라고 하심 +43,SUPPLIER_MASTER,TAXNUM,,CHAR,20,Business Partner Tax Number (사업자번호 -없이숫자만입력) +44,SUPPLIER_MASTER,BP_TX_TYP,,VARCHAR2,6,Resident Registration Number (YYMMDD0000000) +45,SUPPLIER_MASTER,STCD3,,CHAR,18,법인등록번호: (법인등록번호 -없이 숫자만) +46,SUPPLIER_MASTER,ZZIND03,,CHAR,1,"기업규모: (A,B,C,D 값을 넣는걸로 아는데 기준을 알려주지 않음)" \ No newline at end of file -- cgit v1.2.3