1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
// CSV 필드 정의 타입
export interface CsvField {
table: string;
field: string;
mandatory: boolean;
}
// P2MD3007_AO CSV 데이터 (정적 상수)
export const CSV_FIELDS: CsvField[] = [
{ table: 'SUPPLIER_MASTER', field: 'BP_HEADER', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'ZZSRMCD', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'SORT1', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'NAME1', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'NAME2', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'NAME3', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'NAME4', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'KTOKK', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'ZTYPE', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'VBUND', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'J_1KFREPRE', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'J_1KFTBUS', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'J_1KFTIND', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'VQMGRP', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'VTELNO', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'VEMAIL', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'ZZCNAME1', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'ZZCNAME2', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'ZZTELF1_C', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'MASTERFLAG', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'IBND_TYPE', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'ZZVNDTYP', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'ZZREQID', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'ZZIND01', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'ADDRNO', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'NATION', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'COUNTRY', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'LANGU', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'POST_CODE1', mandatory: true }, // 우편번호 (postal_code)
{ table: 'SUPPLIER_MASTER', field: 'CITY1', mandatory: true }, // 주소 (address)
{ table: 'SUPPLIER_MASTER', field: 'CITY2', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'REGION', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'STREET', mandatory: true }, // 상세주소 (address_detail)
{ table: 'SUPPLIER_MASTER', field: 'CONSNUMBER', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'TEL_NUMBER', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'TEL_EXTENS', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'R3_USER', mandatory: true }, // 모바일여부 010 시작이면 1
{ table: 'SUPPLIER_MASTER', field: 'FAX_NUMBER', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'FAX_EXTENS', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'URI_ADDR', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'SMTP_ADDR', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'TAXTYPE', mandatory: true },
{ table: 'SUPPLIER_MASTER', field: 'TAXNUM', mandatory: false }, // 한국이면 KR2
{ table: 'SUPPLIER_MASTER', field: 'BP_TX_TYP', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'STCD3', mandatory: false },
{ table: 'SUPPLIER_MASTER', field: 'ZZIND03', mandatory: false }
];
|
