diff options
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/MDG/mdg.ts | 2359 | ||||
| -rw-r--r-- | db/schema/MDG/modelMaster.ts | 178 | ||||
| -rw-r--r-- | db/schema/SOAP/soap.ts | 22 | ||||
| -rw-r--r-- | db/schema/index.ts | 5 |
4 files changed, 1450 insertions, 1114 deletions
diff --git a/db/schema/MDG/mdg.ts b/db/schema/MDG/mdg.ts index 217f94bb..31dc61d3 100644 --- a/db/schema/MDG/mdg.ts +++ b/db/schema/MDG/mdg.ts @@ -1,1323 +1,1812 @@ -import { relations } from 'drizzle-orm'; -import { timestamp, integer, varchar, pgSchema, unique } from 'drizzle-orm/pg-core'; +import { pgSchema } from 'drizzle-orm/pg-core'; +import { integer, varchar, timestamp, text } from 'drizzle-orm/pg-core'; -// MDG 전용 PostgreSQL 스키마 생성 +// 테이블이 너무 많아서 별도 스키마로 분리함 export const mdgSchema = pgSchema("mdg"); -export const BP_HEADER = mdgSchema.table('BP_HEADER', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BP_HEADER: varchar({ length: 255 }), // Business Partner Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - VNDRCD: varchar({ length: 255 }), // VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 +// unique 잡아준 건 충돌 기준이 됨 +// fk 는 정의서에서 안나와 있어서 나프로님 알려준 거 + 추정해서 만듦. + +// WSDL 기반 자동 생성된 스키마 +// 생성일시: 2025-06-25 00:28:21 (UTC로 9시간 빼야 한국 시간) +// 개선사항: +// 1. WSDL별로 테이블 만들었음. 인터페이스 정의서에 문제가 많아서 어쩔 수 없었음. +// 2. 타입은 varchar를 사용하도록 했음. 숫자관련된 건 부호, 소수점 대비 방어적으로 처리함 (사이즈) +// 3. 테이블명에서 '/' 문자를 '_'로 변경하여 PostgreSQL/TypeScript 호환성 확보함 + +// 수작업 처리한 부분은 +// 1. 루트 테이블 주석 추가 +// 2. FK 없는 건 명시적으로 추가 + +// 참고로 PK 관련해서는, 루트 테이블에 대해선 id가 필요없을수도 있음. +// 다만... 방어적으로 코딩하기 위해 별도의 인공키를 PK로 사용하기로 했음. +// 하위 테이블은 unique로 추정되는 필드가 있어도, 무시하기로 했음. +// 왜냐면 인터페이스 정의서를 신뢰할 수 없기에, 데이터가 어떤 식으로 들어오는지 알 수 없기 때문임 +// 어차피 전체 필드를 보내준다고 했으니, 루트만 충돌 기준을 정해두고, 하위 테이블은 FK 기준으로 전부 지우고 다시 넣으면 됨. + +// [root] +export const CUSTOMER_MASTER_BP_HEADER = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + BP_HEADER: varchar({ length: 10 }).notNull().unique(), // Business Partner Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.BP_HEADER), -]); +}); -// TODO: 물어봐야 함 -// BP_HEADER_ADDRESS 를 upsert 할 때 저장해줘야 하는건지? ADR_NO가 어떤 BP_HEADER에 속하는지 알 방법이 없는 상태임 -// 인터페이스 정의서에서도 안 주는데, XML 객체 구조상에서 파악해야 하는거면, 파싱 단계에서 처리해줘야 해서 할 일이 늘어남 +export const CUSTOMER_MASTER_BP_HEADER_ADDRESS = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_ADDRESS', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), -export const BP_HEADER_ADDRESS = mdgSchema.table('BP_HEADER_ADDRESS', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - bp_header_id: integer('bp_header_id').references(() => BP_HEADER.id), // BP_HEADER FK - ADR_NO: varchar({ length: 255 }), // 주소번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + ADDRNO: varchar({ length: 10 }).notNull(), // Address Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.ADR_NO), -]); +}); + +export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), -export const BP_HEADER_ADDRESS_AD_EMAIL = mdgSchema.table('BP_HEADER_ADDRESS_AD_EMAIL', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - address_id: integer('address_id').references(() => BP_HEADER_ADDRESS.id), // BP_HEADER_ADDRESS FK - CONSNUMBER: varchar({ length: 255 }), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - DATE_FROM: varchar({ length: 255 }), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - EMAIL_ADR: varchar({ length: 255 }), // 이메일주소 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REPR_SER: varchar({ length: 255 }), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - SMTP_ADDR: varchar({ length: 255 }), // E-Mail Address // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VLD_ST_DT: varchar({ length: 255 }), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + CONSNUMBER: varchar({ length: 10 }).notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + DATE_FROM: varchar({ length: 10 }).notNull(), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + SMTP_ADDR: varchar({ length: 241 }), // E-Mail Address // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.CONSNUMBER, table.VLD_ST_DT), -]); +}); + +export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), -export const BP_HEADER_ADDRESS_AD_FAX = mdgSchema.table('BP_HEADER_ADDRESS_AD_FAX', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CONSNUMBER: varchar({ length: 255 }), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - COUNTRY: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - DATE_FROM: varchar({ length: 255 }), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - FAXNO: varchar({ length: 255 }), // 팩스번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - FAX_ETS_NO: varchar({ length: 255 }), // 팩스내선번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - FAX_EXTENS: varchar({ length: 255 }), // Fax no.: Extension // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - FAX_NUMBER: varchar({ length: 255 }), // Fax number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NTN_CD: varchar({ length: 255 }), // 국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REPR_SER: varchar({ length: 255 }), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - VLD_ST_DT: varchar({ length: 255 }), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + CONSNUMBER: varchar({ length: 10 }).notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + COUNTRY: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + DATE_FROM: varchar({ length: 10 }).notNull(), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + FAX_EXTENS: varchar({ length: 10 }), // Fax no.: Extension // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + FAX_NUMBER: varchar({ length: 30 }), // Fax number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_ADDRESS_AD_POSTAL = mdgSchema.table('BP_HEADER_ADDRESS_AD_POSTAL', { +export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ADR_1: varchar({ length: 255 }), // 주소1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ADR_2: varchar({ length: 255 }), // 주소2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ADR_TMZ: varchar({ length: 255 }), // 주소시간대 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CITY1: varchar({ length: 255 }), // City // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - CITY2: varchar({ length: 255 }), // District // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - CITY_ZIP_NO: varchar({ length: 255 }), // 도시우편번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - COUNTRY: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ETC_ADR_1: varchar({ length: 255 }), // 기타주소1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ETC_ADR_2: varchar({ length: 255 }), // 기타주소2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - HOUSE_NUM1: varchar({ length: 255 }), // House Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - INTL_ADR_VER_ID: varchar({ length: 255 }), // 국제주소버전ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - LANGU: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LANG_KEY: varchar({ length: 255 }), // 언어키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - NAME1: varchar({ length: 255 }), // Name 1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NAME2: varchar({ length: 255 }), // Name 2 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NAME3: varchar({ length: 255 }), // Name 3 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NAME4: varchar({ length: 255 }), // Name 4 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NATION: varchar({ length: 255 }), // International address version ID // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - NTN_CD: varchar({ length: 255 }), // 국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - POBX: varchar({ length: 255 }), // 사서함 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - POBX_ZIP_NO: varchar({ length: 255 }), // 사서함우편번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - POST_CODE1: varchar({ length: 255 }), // Postal Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - POST_CODE2: varchar({ length: 255 }), // Postal Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - PO_BOX: varchar({ length: 255 }), // PO Box // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - REGION: varchar({ length: 255 }), // Region (State, Province, County) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - REGN_CD: varchar({ length: 255 }), // 지역코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SORT1: varchar({ length: 255 }), // Search Term 1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - SORT2: varchar({ length: 255 }), // Search Term 2 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - STREET: varchar({ length: 255 }), // Street // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TAXJURCODE: varchar({ length: 255 }), // Tax Jurisdiction // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TAX_JRDT_ZONE_CD: varchar({ length: 255 }), // 조세관할구역코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TIME_ZONE: varchar({ length: 255 }), // Time zone // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TITLE: varchar({ length: 255 }), // Title // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TRANSPZONE: varchar({ length: 255 }), // Transportation zone to or from which the goods are // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TRANS_ZONE: varchar({ length: 255 }), // 운송구역 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TTL: varchar({ length: 255 }), // 타이틀 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_1: varchar({ length: 255 }), // VENDOR명1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_2: varchar({ length: 255 }), // VENDOR명2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_3: varchar({ length: 255 }), // VENDOR명3 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_4: varchar({ length: 255 }), // VENDOR명4 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_ABRV_1: varchar({ length: 255 }), // VENDOR명약어1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_ABRV_2: varchar({ length: 255 }), // VENDOR명약어2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_ADDRESS_AD_TEL = mdgSchema.table('BP_HEADER_ADDRESS_AD_TEL', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CONSNUMBER: varchar({ length: 255 }), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - COUNTRY: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - DATE_FROM: varchar({ length: 255 }), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - ETX_NO: varchar({ length: 255 }), // 내선번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - HP_ORDR: varchar({ length: 255 }), // 핸드폰지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - NTN_CD: varchar({ length: 255 }), // 국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - R3_USER: varchar({ length: 255 }), // ndicator: Telephone is a Mobile Telephone // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - REPR_SER: varchar({ length: 255 }), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - TELNO: varchar({ length: 255 }), // 전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TEL_EXTENS: varchar({ length: 255 }), // Telephone no.: Extension // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TEL_NUMBER: varchar({ length: 255 }), // Telephone no.: dialling code+number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VLD_ST_DT: varchar({ length: 255 }), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_ADDRESS_AD_URL = mdgSchema.table('BP_HEADER_ADDRESS_AD_URL', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CONSNUMBER: varchar({ length: 255 }), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - DATE_FROM: varchar({ length: 255 }), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - REPR_SER: varchar({ length: 255 }), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - URI_ADDR: varchar({ length: 255 }), // Universal Resource Identifier (URI) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - URL: varchar({ length: 255 }), // URL // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VLD_ST_DT: varchar({ length: 255 }), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_BP_CUSGEN = mdgSchema.table('BP_HEADER_BP_CUSGEN', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ANRED: varchar({ length: 255 }), // Title // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - AUFSD: varchar({ length: 255 }), // Central order block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - FAKSD: varchar({ length: 255 }), // Central billing block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - GFORM: varchar({ length: 255 }), // Legal status // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - JMJAH: varchar({ length: 255 }), // Year for which the number of employees is given // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - JMZAH: varchar({ length: 255 }), // Yearly number of employees // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - J_1KFREPRE: varchar({ length: 255 }), // Name of Representative // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - J_1KFTBUS: varchar({ length: 255 }), // Type of Business // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - J_1KFTIND: varchar({ length: 255 }), // Type of Industry // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KATR1: varchar({ length: 255 }), // Attribute1(발행구분-정발행, 역발행등 계산서 발행구분) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KDKG1: varchar({ length: 255 }), // Condition grp1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KTOKD: varchar({ length: 255 }), // Account Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KUNNR: varchar({ length: 255 }), // Customer Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - LIFNR: varchar({ length: 255 }), // Vendor Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LIFSD: varchar({ length: 255 }), // Central delivery block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LOEVM: varchar({ length: 255 }), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NIELS: varchar({ length: 255 }), // Customer Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - NODEL: varchar({ length: 255 }), // Central deletion block for master record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - PUGRP: varchar({ length: 255 }), // Customer Group Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - SPERR: varchar({ length: 255 }), // Central Posting Block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - STCD1: varchar({ length: 255 }), // Tax Number 1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - STCD2: varchar({ length: 255 }), // Tax Number 2 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - STCD3: varchar({ length: 255 }), // Tax Number 3 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - STCD4: varchar({ length: 255 }), // Tax Number 4 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - STCEG: varchar({ length: 255 }), // VAT Registration Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - UMJAH: varchar({ length: 255 }), // Year For Which Sales are Given // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - UMSAT: varchar({ length: 255 }), // Annual Sales // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - UWAER: varchar({ length: 255 }), // Currency of Sales figure // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VBUND: varchar({ length: 255 }), // Company ID of Trading Partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZAPPDT_C: varchar({ length: 255 }), // Apporval Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZAPPTM_C: varchar({ length: 255 }), // Apporval Time // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZAPPUS_C: varchar({ length: 255 }), // Apporval User // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZBA: varchar({ length: 255 }), // Business Area(GBM) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZBRSCH_C: varchar({ length: 255 }), // Industry // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZCRMCD: varchar({ length: 255 }), // CRM Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZDOKAR_C: varchar({ length: 255 }), // Document Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZDOKNR_C: varchar({ length: 255 }), // Document // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZDOKTL_C: varchar({ length: 255 }), // Document Part // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZDOKVR_C: varchar({ length: 255 }), // Document version // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZDUNS: varchar({ length: 255 }), // DUNS Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZFTBU: varchar({ length: 255 }), // F-Tree BU Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZFTBUNM: varchar({ length: 255 }), // F-Tree BU Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZFTDT: varchar({ length: 255 }), // F-Tree DT Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZFTDTNM: varchar({ length: 255 }), // F-Tree DT Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZFTGT: varchar({ length: 255 }), // F-Tree GT Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZFTGTNM: varchar({ length: 255 }), // F-Tree GT Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZINBFLGC: varchar({ length: 255 }), // Inbound Flag // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZLAMDT_C: varchar({ length: 255 }), // Last Modified Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZLAMTM_C: varchar({ length: 255 }), // Last Modified Time // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZLAMUS_C: varchar({ length: 255 }), // Last Modified User // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZORT01_C: varchar({ length: 255 }), // City // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZORT02_C: varchar({ length: 255 }), // District // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZREASON: varchar({ length: 255 }), // Reason for Duplication // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZREGDT_C: varchar({ length: 255 }), // Registerd Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZREGTM_C: varchar({ length: 255 }), // Registerd Time // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZREGUS_C: varchar({ length: 255 }), // Registerd User // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZSTCDT_C: varchar({ length: 255 }), // Tax number type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZSTRAS_C: varchar({ length: 255 }), // House number and street // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZZSUBSEQ_C: varchar({ length: 255 }), // 종사업장 일련번호 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + CITY1: varchar({ length: 40 }), // City // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + CITY2: varchar({ length: 40 }), // District // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + COUNTRY: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + HOUSE_NUM1: varchar({ length: 10 }), // House Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LANGU: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NAME1: varchar({ length: 40 }), // Name 1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NAME2: varchar({ length: 40 }), // Name 2 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NAME3: varchar({ length: 40 }), // Name 3 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NAME4: varchar({ length: 40 }), // Name 4 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NATION: varchar({ length: 10 }).notNull(), // International address version ID // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + POST_CODE1: varchar({ length: 10 }), // Postal Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + POST_CODE2: varchar({ length: 10 }), // Postal Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PO_BOX: varchar({ length: 10 }), // PO Box // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + REGION: varchar({ length: 10 }), // Region (State, Province, County) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SORT1: varchar({ length: 20 }), // Search Term 1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SORT2: varchar({ length: 20 }), // Search Term 2 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + STREET: varchar({ length: 60 }), // Street // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TAXJURCODE: varchar({ length: 15 }), // Tax Jurisdiction // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TIME_ZONE: varchar({ length: 10 }), // Time zone // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TITLE: varchar({ length: 10 }), // Title // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TRANSPZONE: varchar({ length: 10 }), // Transportation zone to or from which the goods are // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_CUSGEN_ZCOMPANY = mdgSchema.table('BP_HEADER_BP_CUSGEN_ZCOMPANY', { +export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - AKONT: varchar({ length: 255 }), // Reconcil.acct // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - BUKRS: varchar({ length: 255 }), // Company Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - FDGRV: varchar({ length: 255 }), // Planning Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LOEVM: varchar({ length: 255 }), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - SPERR: varchar({ length: 255 }), // Posting block for company code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZAHLS: varchar({ length: 255 }), // Block Key for Payment // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZTERM: varchar({ length: 255 }), // Terms of Payment Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZUAWA: varchar({ length: 255 }), // Sort key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZWELS: varchar({ length: 255 }), // List of the Payment Methods to be Considered // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + CONSNUMBER: varchar({ length: 10 }).notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + COUNTRY: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + DATE_FROM: varchar({ length: 10 }).notNull(), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + R3_USER: varchar({ length: 10 }), // ndicator: Telephone is a Mobile Telephone // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TEL_EXTENS: varchar({ length: 10 }), // Telephone no.: Extension // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TEL_NUMBER: varchar({ length: 30 }), // Telephone no.: dialling code+number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_CUSGEN_ZSALES = mdgSchema.table('BP_HEADER_BP_CUSGEN_ZSALES', { +export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ANTLF: varchar({ length: 255 }), // Maximum Number of Partial Deliveries Allowed Per I // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - AUFSD: varchar({ length: 255 }), // Customer order block (sales area) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - AWAHR: varchar({ length: 255 }), // Order probability of the item // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - BZIRK: varchar({ length: 255 }), // Sales district // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - FAKSD: varchar({ length: 255 }), // Billing block for customer (sales and distribution // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - INCO1: varchar({ length: 255 }), // Incoterms (Part 1) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - INCO2: varchar({ length: 255 }), // Incoterms (Part 2) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KALKS: varchar({ length: 255 }), // Pricing procedure assigned to this customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KDGRP: varchar({ length: 255 }), // Customer group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KONDA: varchar({ length: 255 }), // Price group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KTGRD: varchar({ length: 255 }), // Account assignment group for this customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KURST: varchar({ length: 255 }), // Exchange Rate Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KZAZU: varchar({ length: 255 }), // Order Combination // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LIFSD: varchar({ length: 255 }), // Customer delivery block (sales area) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LOEVM: varchar({ length: 255 }), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - LPRIO: varchar({ length: 255 }), // Delivery Priority // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - PLTYP: varchar({ length: 255 }), // Price List // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - SPART: varchar({ length: 255 }), // Division // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - VERSG: varchar({ length: 255 }), // Customer Statistics Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VKBUR: varchar({ length: 255 }), // Sales Office // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VKGRP: varchar({ length: 255 }), // Sales Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VKORG: varchar({ length: 255 }), // Sales Org. // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - VSBED: varchar({ length: 255 }), // Shipping Conditions // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - VTWEG: varchar({ length: 255 }), // Distr. Channel // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - VWERK: varchar({ length: 255 }), // From plant // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - WAERS: varchar({ length: 255 }), // Currency // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - ZTERM: varchar({ length: 255 }), // Terms of Payment Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN = mdgSchema.table('BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DEFPA: varchar({ length: 255 }), // Default Partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - KUNN2: varchar({ length: 255 }), // Customer number of business partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - PARVW: varchar({ length: 255 }), // Partner Function // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - PARZA: varchar({ length: 255 }), // Partner counter // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_BP_CUSGEN_ZTAXIND = mdgSchema.table('BP_HEADER_BP_CUSGEN_ZTAXIND', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ALAND: varchar({ length: 255 }), // Departure country // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - TATYP: varchar({ length: 255 }), // Tax category // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - TAXKD: varchar({ length: 255 }), // Tax classification for customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_BP_CUSGEN_ZVATREG = mdgSchema.table('BP_HEADER_BP_CUSGEN_ZVATREG', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - LAND1: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - STCEG: varchar({ length: 255 }), // VAT Registration Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const BP_HEADER_BP_TAXNUM = mdgSchema.table('BP_HEADER_BP_TAXNUM', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BIZ_PTNR_TX_NO: varchar({ length: 255 }), // 사업파트너세금번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TAXNUM: varchar({ length: 255 }), // Business Partner Tax Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl - TAXTYPE: varchar({ length: 255 }), // Tax Number Category // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 - TX_NO_CTG: varchar({ length: 255 }), // 세금번호범주 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - + CONSNUMBER: varchar({ length: 10 }).notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + DATE_FROM: varchar({ length: 10 }).notNull(), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + URI_ADDR: text(), // Universal Resource Identifier (URI) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_VENGEN = mdgSchema.table('BP_HEADER_BP_VENGEN', { +export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ACNT_GRP: varchar({ length: 255 }), // 계정그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ACNT_GRP_TP: varchar({ length: 255 }), // 계정그룹유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ADR_1: varchar({ length: 255 }), // 주소1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ADR_2: varchar({ length: 255 }), // 주소2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - AGR_DT: varchar({ length: 255 }), // 승인일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - AGR_R_ID: varchar({ length: 255 }), // 승인자ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - AGR_TM: varchar({ length: 255 }), // 승인시간 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - BIZCON: varchar({ length: 255 }), // 산업유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - BIZR_NO: varchar({ length: 255 }), // 사업자번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - BIZTP: varchar({ length: 255 }), // 사업유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - BIZ_UOM_CD: varchar({ length: 255 }), // 사업단위코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - BIZ_UOM_NM: varchar({ length: 255 }), // 사업단위명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CHGR_ID: varchar({ length: 255 }), // 변경자ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CHG_DT: varchar({ length: 255 }), // 변경일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CHG_TM: varchar({ length: 255 }), // 변경시간 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CO_ID: varchar({ length: 255 }), // 법인ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CO_REG_NO: varchar({ length: 255 }), // 법인등록번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CO_VLM: varchar({ length: 255 }), // 기업규모 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CSTM_CD: varchar({ length: 255 }), // 고객코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DEL_HOLD_ORDR: varchar({ length: 255 }), // 삭제보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DEL_ORDR: varchar({ length: 255 }), // 삭제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DMST_TOP_CD: varchar({ length: 255 }), // 국내TOP코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DMST_TOP_NM: varchar({ length: 255 }), // 국내TOP명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DNS_NO: varchar({ length: 255 }), // DUNS번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DOC_NO: varchar({ length: 255 }), // 문서번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DOC_TP: varchar({ length: 255 }), // 문서유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DOC_VER: varchar({ length: 255 }), // 문서버전 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - FIR_NM: varchar({ length: 255 }), // FIRST이름 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - GBL_TOP_CD: varchar({ length: 255 }), // GLOBALTOP코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - GBL_TOP_NM: varchar({ length: 255 }), // GLOBALTOP명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - GIRO_VNDR_ORDR: varchar({ length: 255 }), // 지로VENDOR지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - HOLD_CAUS: varchar({ length: 255 }), // 보류사유 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - INB_FLAG: varchar({ length: 255 }), // 인바운드플래그 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - INTL_LCTN_CHK_NUM: varchar({ length: 255 }), // 국제LOCATION점검숫자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - OVLAP_CAUS_CD: varchar({ length: 255 }), // 중복사유코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PST_HOLD_ORDR: varchar({ length: 255 }), // 전기보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PTNT_VNDRCD: varchar({ length: 255 }), // 잠재VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PTN_DOC: varchar({ length: 255 }), // 부분문서 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_HOLD_DT: varchar({ length: 255 }), // 구매보류일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_HOLD_ORDR: varchar({ length: 255 }), // 구매보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - QLT_CHRGR_EMAIL: varchar({ length: 255 }), // 품질담당자이메일 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - QLT_CHRGR_NM: varchar({ length: 255 }), // 품질담당자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - QLT_CHRGR_TELNO: varchar({ length: 255 }), // 품질담당자전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REGR_ID: varchar({ length: 255 }), // 등록자ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REG_DT: varchar({ length: 255 }), // 등록일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REG_TM: varchar({ length: 255 }), // 등록시간 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REPR_NM: varchar({ length: 255 }), // 대표자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REPR_RESNO: varchar({ length: 255 }), // 대표자주민번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REP_TEL_NO: varchar({ length: 255 }), // 대표전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SB_WKA_SEQ: varchar({ length: 255 }), // SUB작업장순서 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCETX_RP_SEX_KEY: varchar({ length: 255 }), // 원천세의무자성별키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TTL: varchar({ length: 255 }), // 타이틀 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TX_CD_4: varchar({ length: 255 }), // 세금번호4 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VAT_REG_NO: varchar({ length: 255 }), // 부가세등록번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNM_1: varchar({ length: 255 }), // VENDOR명1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDRNO: varchar({ length: 255 }), // VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + ANRED: varchar({ length: 15 }), // Title // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + AUFSD: varchar({ length: 10 }), // Central order block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + FAKSD: varchar({ length: 10 }), // Central billing block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + GFORM: varchar({ length: 10 }), // Legal status // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + JMJAH: varchar({ length: 10 }), // Year for which the number of employees is given // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + JMZAH: varchar({ length: 10 }), // Yearly number of employees // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + J_1KFREPRE: varchar({ length: 10 }), // Name of Representative // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + J_1KFTBUS: varchar({ length: 30 }), // Type of Business // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + J_1KFTIND: varchar({ length: 30 }), // Type of Industry // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KATR1: varchar({ length: 10 }), // Attribute1(발행구분-정발행, 역발행등 계산서 발행구분) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KDKG1: varchar({ length: 10 }), // Condition grp1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KTOKD: varchar({ length: 10 }), // Account Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KUNNR: varchar({ length: 10 }).notNull(), // Customer Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + LIFNR: varchar({ length: 10 }), // Vendor Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LIFSD: varchar({ length: 10 }), // Central delivery block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LOEVM: varchar({ length: 10 }), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NIELS: varchar({ length: 10 }), // Customer Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NODEL: varchar({ length: 10 }), // Central deletion block for master record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PUGRP: varchar({ length: 20 }), // Customer Group Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPERR: varchar({ length: 10 }), // Central Posting Block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPRAS: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + STCD1: varchar({ length: 16 }), // Tax Number 1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + STCD2: varchar({ length: 11 }), // Tax Number 2 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + STCD3: varchar({ length: 18 }), // Tax Number 3 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + STCD4: varchar({ length: 18 }), // Tax Number 4 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + STCEG: varchar({ length: 20 }), // VAT Registration Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + UMJAH: varchar({ length: 10 }), // Year For Which Sales are Given // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + UWAER: varchar({ length: 10 }), // Currency of Sales figure // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VBUND: varchar({ length: 10 }), // Company ID of Trading Partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZAPPDT_C: varchar({ length: 10 }), // Apporval Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZAPPTM_C: varchar({ length: 10 }), // Apporval Time // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZAPPUS_C: varchar({ length: 12 }), // Apporval User // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZBA: varchar({ length: 10 }), // Business Area(GBM) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZBRSCH_C: varchar({ length: 10 }), // Industry // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZCRMCD: varchar({ length: 20 }), // CRM Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZDOKAR_C: varchar({ length: 10 }), // Document Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZDOKNR_C: varchar({ length: 25 }), // Document // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZDOKTL_C: varchar({ length: 10 }), // Document Part // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZDOKVR_C: varchar({ length: 10 }), // Document version // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZDUNS: varchar({ length: 11 }), // DUNS Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZFTBU: varchar({ length: 10 }), // F-Tree BU Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZFTBUNM: varchar({ length: 40 }), // F-Tree BU Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZFTDT: varchar({ length: 10 }), // F-Tree DT Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZFTDTNM: varchar({ length: 40 }), // F-Tree DT Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZFTGT: varchar({ length: 10 }), // F-Tree GT Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZFTGTNM: varchar({ length: 40 }), // F-Tree GT Name // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZINBFLGC: varchar({ length: 10 }), // Inbound Flag // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZLAMDT_C: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZLAMTM_C: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZLAMUS_C: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZORT01_C: varchar({ length: 35 }), // City // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZORT02_C: varchar({ length: 35 }), // District // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZREASON: varchar({ length: 10 }), // Reason for Duplication // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZREGDT_C: varchar({ length: 10 }), // Registerd Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZREGTM_C: varchar({ length: 10 }), // Registerd Time // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZREGUS_C: varchar({ length: 12 }), // Registerd User // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZSTCDT_C: varchar({ length: 10 }), // Tax number type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZSTRAS_C: varchar({ length: 35 }), // House number and street // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZSUBSEQ_C: varchar({ length: 10 }), // 종사업장 일련번호 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_VENGEN_BP_COMPNY = mdgSchema.table('BP_HEADER_BP_VENGEN_BP_COMPNY', { +export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ACOT_CHRGR_FAXNO: varchar({ length: 255 }), // 회계담당자FAX번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ACOT_CHRGR_TELNO: varchar({ length: 255 }), // 회계담당자전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - AUTH_GRP: varchar({ length: 255 }), // 권한그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - BF_VNDRCD: varchar({ length: 255 }), // 이전VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CO_CD: varchar({ length: 255 }), // 회사코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - CSTM_VNDR_CLR_ORDR: varchar({ length: 255 }), // CUSTOMER,VENDOR반제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CTL_ACNT: varchar({ length: 255 }), // 조정계정 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DEL_ORDR: varchar({ length: 255 }), // 삭제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - FIN_IR_ACT_DT: varchar({ length: 255 }), // 최종이자실행일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - FIN_IR_CALC_DT: varchar({ length: 255 }), // 최종이자계산일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - IATA_BIC_GB: varchar({ length: 255 }), // IATA,BIC구분 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - LOGST_VNDR_TP: varchar({ length: 255 }), // 물류VENDOR유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - MEMO: varchar({ length: 255 }), // 메모 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - MIN_ORDR: varchar({ length: 255 }), // 소수지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - MK_CHRGR_EMAIL: varchar({ length: 255 }), // MAKER담당자이메일 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - MOFFC_ACNT_NO: varchar({ length: 255 }), // 본사계정번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - OVLAP_INVC_ORDR: varchar({ length: 255 }), // 중복송장지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PLN_GRP: varchar({ length: 255 }), // 계획그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PST_HOLD_ORDR: varchar({ length: 255 }), // 전기보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - REP_TP: varchar({ length: 255 }), // 대표유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SPLY_COND: varchar({ length: 255 }), // 지급조건 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SPLY_HOLD_ORDR: varchar({ length: 255 }), // 지급보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SPLY_MTHD: varchar({ length: 255 }), // 지급방법 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SPRT_SPLY_ORDR: varchar({ length: 255 }), // 분리지급지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCE_TX_CD: varchar({ length: 255 }), // 원천세코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCE_TX_NTN_CD: varchar({ length: 255 }), // 원천세국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRT_KEY: varchar({ length: 255 }), // 정렬키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - TRD_BANK_SHRT_KEY: varchar({ length: 255 }), // 거래은행단축키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDR_ACNT_NO: varchar({ length: 255 }), // VENDOR계정번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDR_CHRGR_NM: varchar({ length: 255 }), // VENDOR담당자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + AKONT: varchar({ length: 10 }), // Reconcil.acct // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + BUKRS: varchar({ length: 10 }).notNull(), // Company Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + FDGRV: varchar({ length: 10 }), // Planning Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LOEVM: varchar({ length: 10 }), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPERR: varchar({ length: 10 }), // Posting block for company code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZAHLS: varchar({ length: 10 }), // Block Key for Payment // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZTERM: varchar({ length: 10 }), // Terms of Payment Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZUAWA: varchar({ length: 10 }), // Sort key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZWELS: varchar({ length: 10 }), // List of the Payment Methods to be Considered // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX = mdgSchema.table('BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX', { +export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DCHAG_CAUS: varchar({ length: 255 }), // 면제사유 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DCHAG_CERT_NO: varchar({ length: 255 }), // 면제증명서번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DCHAG_ED_DT: varchar({ length: 255 }), // 면제종료일 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DCHAG_RAT: varchar({ length: 255 }), // 면제율 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DCHAG_ST_DT: varchar({ length: 255 }), // 면제시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - RECIP_TP: varchar({ length: 255 }), // 수취인유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCE_TX_IDENT_NO: varchar({ length: 255 }), // 원천세식별번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCE_TX_NO: varchar({ length: 255 }), // 원천세코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCE_TX_REL_ORDR: varchar({ length: 255 }), // 원천세관련지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SRCE_TX_TP: varchar({ length: 255 }), // 원천세유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + AUFSD: varchar({ length: 10 }), // Customer order block (sales area) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + AWAHR: varchar({ length: 10 }), // Order probability of the item // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + BZIRK: varchar({ length: 10 }), // Sales district // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + FAKSD: varchar({ length: 10 }), // Billing block for customer (sales and distribution // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + INCO1: varchar({ length: 10 }), // Incoterms (Part 1) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + INCO2: varchar({ length: 28 }), // Incoterms (Part 2) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KALKS: varchar({ length: 10 }), // Pricing procedure assigned to this customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KDGRP: varchar({ length: 10 }), // Customer group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KONDA: varchar({ length: 10 }), // Price group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KTGRD: varchar({ length: 10 }), // Account assignment group for this customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KURST: varchar({ length: 10 }), // Exchange Rate Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KZAZU: varchar({ length: 10 }), // Order Combination // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LIFSD: varchar({ length: 10 }), // Customer delivery block (sales area) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LOEVM: varchar({ length: 10 }), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LPRIO: varchar({ length: 10 }), // Delivery Priority // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PLTYP: varchar({ length: 10 }), // Price List // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPART: varchar({ length: 10 }).notNull(), // Division // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + VERSG: varchar({ length: 10 }), // Customer Statistics Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VKBUR: varchar({ length: 10 }), // Sales Office // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VKGRP: varchar({ length: 10 }), // Sales Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VKORG: varchar({ length: 10 }).notNull(), // Sales Org. // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + VSBED: varchar({ length: 10 }), // Shipping Conditions // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VTWEG: varchar({ length: 10 }).notNull(), // Distr. Channel // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + VWERK: varchar({ length: 10 }), // From plant // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + WAERS: varchar({ length: 10 }), // Currency // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZTERM: varchar({ length: 10 }), // Terms of Payment Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_VENGEN_BP_PORG = mdgSchema.table('BP_HEADER_BP_VENGEN_BP_PORG', { +export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - AT_PUR_ORD_ORDR: varchar({ length: 255 }), // 자동구매오더지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CALC_SHM_GRP: varchar({ length: 255 }), // 계산스키마그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - CNFM_CTL_KEY: varchar({ length: 255 }), // 확정제어키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DEL_ORDR: varchar({ length: 255 }), // 삭제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DL_COND_1: varchar({ length: 255 }), // 인도조건1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - DL_COND_2: varchar({ length: 255 }), // 인도조건2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - GR_BSE_INVC_VR: varchar({ length: 255 }), // GR기준송장검증 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ORD_CNFM_REQ_ORDR: varchar({ length: 255 }), // 오더확인요청지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_HOLD_CAUS: varchar({ length: 255 }), // 구매보류사유 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_HOLD_DT: varchar({ length: 255 }), // 구매보류일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_HOLD_ORDR: varchar({ length: 255 }), // 구매보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_ORD_CUR: varchar({ length: 255 }), // 구매오더통화 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PUR_ORG_CD: varchar({ length: 255 }), // 구매조직 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - SALE_CHRGR_NM: varchar({ length: 255 }), // 영업담당자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - SPLY_COND: varchar({ length: 255 }), // 지급조건 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - VNDR_TELNO: varchar({ length: 255 }), // VENDOR전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DEFPA: varchar({ length: 10 }), // Default Partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KUNN2: varchar({ length: 10 }), // Customer number of business partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PARVW: varchar({ length: 10 }).notNull(), // Partner Function // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + PARZA: varchar({ length: 10 }).notNull(), // Partner counter // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN = mdgSchema.table('BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN', { +export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BSE_PTNR_ORDR: varchar({ length: 255 }), // 기본파트너지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - ETC_REF_VNDRCD: varchar({ length: 255 }), // 기타참조VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl - PLNT_NO: varchar({ length: 255 }), // 플랜트번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - PTNR_CNT: varchar({ length: 255 }), // 파트너카운터 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - PTNR_SKL: varchar({ length: 255 }), // 파트너기능 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 - VNDR_SUB_NO: varchar({ length: 255 }), // VENDOR서브번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + ALAND: varchar({ length: 10 }).notNull(), // Departure country // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + TATYP: varchar({ length: 10 }).notNull(), // Tax category // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + TAXKD: varchar({ length: 10 }), // Tax classification for customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_DEPT_MDG = mdgSchema.table('CMCTB_DEPT_MDG', { +export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BICD: varchar({ length: 255 }), // 사업장코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - BIZAREA: varchar({ length: 255 }), // 사업부문 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - CCCD: varchar({ length: 255 }), // 코스트센터 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - COMPCD: varchar({ length: 255 }), // 회사코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - CORPCD: varchar({ length: 255 }), // 법인코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 - DEPTCD: varchar({ length: 255 }), // 부서코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 - DEPTLVL: varchar({ length: 255 }), // 부서레벨 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - DEPTPOSNO: varchar({ length: 255 }), // 부서위치 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - DHEMPID: varchar({ length: 255 }), // 부서장사번 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - GNCD: varchar({ length: 255 }), // From multiple sources // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - PCCD: varchar({ length: 255 }), // 손익센터 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - PDEPTCD: varchar({ length: 255 }), // 상위부서코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - VALIDFROMDT: varchar({ length: 255 }), // 유효일자(시작) // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - VALIDTODT: varchar({ length: 255 }), // 유효일자(끝) // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - WERKS: varchar({ length: 255 }), // 플랜트코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const CMCTB_DEPT_MDG_COMPNM = mdgSchema.table('CMCTB_DEPT_MDG_COMPNM', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - COMPNM: varchar({ length: 255 }), // 회사명 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - SPRAS: varchar({ length: 255 }), // 언어구분 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 + LAND1: varchar({ length: 10 }).notNull(), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + STCEG: varchar({ length: 20 }), // VAT Registration Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_DEPT_MDG_CORPNM = mdgSchema.table('CMCTB_DEPT_MDG_CORPNM', { +export const CUSTOMER_MASTER_BP_HEADER_BP_TAXNUM = mdgSchema.table('CUSTOMER_MASTER_BP_HEADER_BP_TAXNUM', { + // [fk] + BP_HEADER: varchar({ length: 10 }).notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CORPNM: varchar({ length: 255 }), // 법인명 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - SPRAS: varchar({ length: 255 }), // 언어구분 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 + TAXNUM: varchar({ length: 20 }), // Business Partner Tax Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TAXTYPE: varchar({ length: 10 }).notNull(), // Tax Number Category // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_DEPT_MDG_DEPTNM = mdgSchema.table('CMCTB_DEPT_MDG_DEPTNM', { +// [root] +export const DEPARTMENT_CODE_CMCTB_DEPT_MDG = mdgSchema.table('DEPARTMENT_CODE_CMCTB_DEPT_MDG', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DEPTNM: varchar({ length: 255 }), // 부서명 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl - SPRAS: varchar({ length: 255 }), // 언어구분 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 + BICD: varchar({ length: 20 }), // 사업장코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + BIZAREA: varchar({ length: 10 }), // 사업부문 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + CCCD: varchar({ length: 10 }), // 코스트센터 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + COMPCD: varchar({ length: 20 }), // 회사코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + CORPCD: varchar({ length: 10 }).notNull(), // 법인코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 + DEPTCD: varchar({ length: 10 }).notNull().unique(), // 부서코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 + DEPTLVL: varchar({ length: 10 }), // 부서레벨 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + DEPTPOSNO: varchar({ length: 30 }), // 부서위치 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + DHEMPID: varchar({ length: 20 }), // 부서장사번 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + GNCD: varchar({ length: 20 }), // From multiple sources // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + PCCD: varchar({ length: 10 }), // 손익센터 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + PDEPTCD: varchar({ length: 10 }), // 상위부서코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + VALIDFROMDT: varchar({ length: 10 }), // 유효일자(시작) // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + VALIDTODT: varchar({ length: 10 }), // 유효일자(끝) // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + WERKS: varchar({ length: 10 }), // 플랜트코드 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG = mdgSchema.table('CMCTB_EMP_MDG', { +export const DEPARTMENT_CODE_CMCTB_DEPT_MDG_COMPNM = mdgSchema.table('DEPARTMENT_CODE_CMCTB_DEPT_MDG_COMPNM', { + // [fk] + DEPTCD: varchar({ length: 10 }).notNull().references(() => DEPARTMENT_CODE_CMCTB_DEPT_MDG.DEPTCD), // 부서코드 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ADDRCNTRY: varchar({ length: 255 }), // 우편번호의 국가코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - AEDAT: varchar({ length: 255 }), // 수정날짜 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - AENAM: varchar({ length: 255 }), // 수정자 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - AEZET: varchar({ length: 255 }), // 최근수정시간 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - BICD: varchar({ length: 255 }), // 사업장코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - BIZAREA: varchar({ length: 255 }), // Business Area // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - BSCADDR: varchar({ length: 255 }), // Basic Address // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - COMPCD: varchar({ length: 255 }), // 회사 코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - CORPCD: varchar({ length: 255 }), // 법인 코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - COUNTRYCD: varchar({ length: 255 }), // 국가코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - CSFROMDT: varchar({ length: 255 }), // [에스원]CS Start Date // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - CSTODT: varchar({ length: 255 }), // [에스원]CS End Date // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - CTIROLE: varchar({ length: 255 }), // [에스원]CTI Authority // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DEL: varchar({ length: 255 }), // 삭제Flag // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DEPENDDT: varchar({ length: 255 }), // 파견종료예정일 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DEPTCD: varchar({ length: 255 }), // 부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DHJOBGRDCD: varchar({ length: 255 }), // 부서장 직급코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DHNAME: varchar({ length: 255 }), // 부서장 이름 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DHSINGLID: varchar({ length: 255 }), // 부서장 SingleID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DISPATCH: varchar({ length: 255 }), // 파견여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DPSTARTDT: varchar({ length: 255 }), // 파견발령일 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DTLADDR: varchar({ length: 255 }), // Detail Address // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - DTLADDR2: varchar({ length: 255 }), // Detail Address2 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - EMAIL: varchar({ length: 255 }), // 이메일주소 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - EMPADR: varchar({ length: 255 }), // 주소 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - EMPID: varchar({ length: 255 }), // 사원번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 - EMPTYPE: varchar({ length: 255 }), // 인력유형 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ENGNAME: varchar({ length: 255 }), // 사원영문이름 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - EPID: varchar({ length: 255 }), // EPID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ERDAT: varchar({ length: 255 }), // 생성날짜 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ERNAM: varchar({ length: 255 }), // 생성자 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ERZET: varchar({ length: 255 }), // 생성시간 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - FORIGNFLG: varchar({ length: 255 }), // [기획]Foreign Flag // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - GJOBCD: varchar({ length: 255 }), // Global 직무 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - GJOBDUTYCD: varchar({ length: 255 }), // Global 직책 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - GJOBGRDCD: varchar({ length: 255 }), // Global 직급 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - GNCD: varchar({ length: 255 }), // 총괄코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - HRMANAGE: varchar({ length: 255 }), // HR시스템에서 관리 여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - IDNO: varchar({ length: 255 }), // [모직]개인ID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBCD: varchar({ length: 255 }), // 직무코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBCLASS: varchar({ length: 255 }), // [에스원]Job Class Code // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBDUTYCD: varchar({ length: 255 }), // 직책코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBGRDCD: varchar({ length: 255 }), // 직급코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - KTL_EMP: varchar({ length: 255 }), // 비용센터 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - LVABSENCE: varchar({ length: 255 }), // 휴직여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - MBPHONE: varchar({ length: 255 }), // 개인 휴대폰 전화번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - NAME: varchar({ length: 255 }), // 사원이름 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - OKTL_EMPL: varchar({ length: 255 }), // 원소속부서 비용센터 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ORGBICD: varchar({ length: 255 }), // 원소속사업장코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ORGCOMPCD: varchar({ length: 255 }), // 원소속회사코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ORGCORPCD: varchar({ length: 255 }), // 원소속법인코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ORGDEPTCD: varchar({ length: 255 }), // 원소속부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ORGPDEPCD: varchar({ length: 255 }), // 원소속부서의 상위부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - PAYPLC: varchar({ length: 255 }), // Payplace for Employee // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - PDEPTCD: varchar({ length: 255 }), // 상위부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - PSTLCODE: varchar({ length: 255 }), // 우편번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - RETIRE: varchar({ length: 255 }), // 퇴직여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SEX: varchar({ length: 255 }), // 성별 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SINGLEID: varchar({ length: 255 }), // 싱글 ID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SINGLRQ: varchar({ length: 255 }), // 싱글ID 요청 상태 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SOCIALID: varchar({ length: 255 }), // From multiple sources // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SOCIALID_DECR: varchar({ length: 255 }), // From multiple sources // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SOJRNEMP: varchar({ length: 255 }), // 주재원 여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - TELNUM: varchar({ length: 255 }), // 전화번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - TMPJDIV: varchar({ length: 255 }), // [에스원]Non-Regular Code // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - USEDSYS: varchar({ length: 255 }), // [기획]Used System // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - VALFROMDT: varchar({ length: 255 }), // 근무시작일 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - VALTODT: varchar({ length: 255 }), // 종료예정일(퇴직일자-정규직일경우) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - WFREQUIRE: varchar({ length: 255 }), // 전결필요여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - WORKPLC: varchar({ length: 255 }), // 근무처 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ZPRFLG: varchar({ length: 255 }), // 업데이트 여부 Flag // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - ZZBUKRS: varchar({ length: 255 }), // ECC Company 코드 (재무법인코드) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + COMPNM: varchar({ length: 90 }), // 회사명 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // 언어구분 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_BANM = mdgSchema.table('CMCTB_EMP_MDG_BANM', { +export const DEPARTMENT_CODE_CMCTB_DEPT_MDG_CORPNM = mdgSchema.table('DEPARTMENT_CODE_CMCTB_DEPT_MDG_CORPNM', { + // [fk] + DEPTCD: varchar({ length: 10 }).notNull().references(() => DEPARTMENT_CODE_CMCTB_DEPT_MDG.DEPTCD), // 부서코드 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - GTEXT: varchar({ length: 255 }), // Business area description // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (BIZAREA) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + CORPNM: varchar({ length: 90 }), // 법인명 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // 언어구분 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_BINM = mdgSchema.table('CMCTB_EMP_MDG_BINM', { +export const DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTNM = mdgSchema.table('DEPARTMENT_CODE_CMCTB_DEPT_MDG_DEPTNM', { + // [fk] + DEPTCD: varchar({ length: 10 }).notNull().references(() => DEPARTMENT_CODE_CMCTB_DEPT_MDG.DEPTCD), // 부서코드 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BINM: varchar({ length: 255 }), // Business Place Name (BICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (BICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + DEPTNM: varchar({ length: 90 }), // 부서명 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // 언어구분 // From: IF_MDZ_EVCP_DEPARTMENT_CODE.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_COMPNM = mdgSchema.table('CMCTB_EMP_MDG_COMPNM', { +// [root] +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - COMPNM: varchar({ length: 255 }), // Company Name (COMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (COMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + ADDRCNTRY: varchar({ length: 10 }), // 우편번호의 국가코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + AEDAT: varchar({ length: 10 }), // 수정날짜 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + AENAM: varchar({ length: 12 }), // 수정자 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + AEZET: varchar({ length: 10 }), // 최근수정시간 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + BICD: varchar({ length: 20 }), // 사업장코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + BIZAREA: varchar({ length: 10 }), // Business Area // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + BSCADDR: varchar({ length: 35 }), // Basic Address // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + COMPCD: varchar({ length: 20 }), // 회사 코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + CORPCD: varchar({ length: 10 }), // 법인 코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + COUNTRYCD: varchar({ length: 10 }), // 국가코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + CSFROMDT: varchar({ length: 10 }), // [에스원]CS Start Date // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + CSTODT: varchar({ length: 10 }), // [에스원]CS End Date // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + CTIROLE: varchar({ length: 10 }), // [에스원]CTI Authority // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DEL: varchar({ length: 10 }), // 삭제Flag // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DEPENDDT: varchar({ length: 10 }), // 파견종료예정일 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DEPTCD: varchar({ length: 10 }), // 부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DHJOBGRDCD: varchar({ length: 29 }), // 부서장 직급코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DHNAME: varchar({ length: 70 }), // 부서장 이름 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DHSINGLID: varchar({ length: 12 }), // 부서장 SingleID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DISPATCH: varchar({ length: 10 }), // 파견여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DPSTARTDT: varchar({ length: 10 }), // 파견발령일 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DTLADDR: varchar({ length: 35 }), // Detail Address // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + DTLADDR2: varchar({ length: 35 }), // Detail Address2 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + EMAIL: varchar({ length: 40 }), // 이메일주소 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + EMPADR: varchar({ length: 10 }), // 주소 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + EMPID: varchar({ length: 20 }).notNull().unique(), // 사원번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + EMPTYPE: varchar({ length: 20 }), // 인력유형 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ENGNAME: varchar({ length: 70 }), // 사원영문이름 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + EPID: varchar({ length: 50 }), // EPID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ERDAT: varchar({ length: 10 }), // 생성날짜 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ERNAM: varchar({ length: 12 }), // 생성자 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ERZET: varchar({ length: 10 }), // 생성시간 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + FORIGNFLG: varchar({ length: 10 }), // [기획]Foreign Flag // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + GJOBCD: varchar({ length: 20 }), // Global 직무 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + GJOBDUTYCD: varchar({ length: 20 }), // Global 직책 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + GJOBGRDCD: varchar({ length: 20 }), // Global 직급 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + GNCD: varchar({ length: 20 }), // 총괄코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + HRMANAGE: varchar({ length: 10 }), // HR시스템에서 관리 여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + IDNO: varchar({ length: 32 }), // [모직]개인ID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBCD: varchar({ length: 20 }), // 직무코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBCLASS: varchar({ length: 20 }), // [에스원]Job Class Code // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBDUTYCD: varchar({ length: 15 }), // 직책코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBGRDCD: varchar({ length: 12 }), // 직급코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + KTL_EMP: varchar({ length: 10 }), // 비용센터 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + LVABSENCE: varchar({ length: 10 }), // 휴직여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + MBPHONE: varchar({ length: 20 }), // 개인 휴대폰 전화번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + NAME: varchar({ length: 70 }), // 사원이름 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + OKTL_EMPL: varchar({ length: 10 }), // 원소속부서 비용센터 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ORGBICD: varchar({ length: 20 }), // 원소속사업장코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ORGCOMPCD: varchar({ length: 20 }), // 원소속회사코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ORGCORPCD: varchar({ length: 10 }), // 원소속법인코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ORGDEPTCD: varchar({ length: 10 }), // 원소속부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ORGPDEPCD: varchar({ length: 10 }), // 원소속부서의 상위부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + PAYPLC: varchar({ length: 10 }), // Payplace for Employee // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + PDEPTCD: varchar({ length: 10 }), // 상위부서코드 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + PSTLCODE: varchar({ length: 10 }), // 우편번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + RETIRE: varchar({ length: 10 }), // 퇴직여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SEX: varchar({ length: 10 }), // 성별 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SINGLEID: varchar({ length: 12 }), // 싱글 ID // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SINGLRQ: varchar({ length: 10 }), // 싱글ID 요청 상태 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SOCIALID: varchar({ length: 16 }), // From multiple sources // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SOCIALID_DECR: varchar({ length: 16 }), // From multiple sources // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SOJRNEMP: varchar({ length: 10 }), // 주재원 여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + TELNUM: varchar({ length: 20 }), // 전화번호 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + TMPJDIV: varchar({ length: 20 }), // [에스원]Non-Regular Code // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + USEDSYS: varchar({ length: 20 }), // [기획]Used System // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + VALFROMDT: varchar({ length: 10 }), // 근무시작일 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + VALTODT: varchar({ length: 10 }), // 종료예정일(퇴직일자-정규직일경우) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + WFREQUIRE: varchar({ length: 10 }), // 전결필요여부 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + WORKPLC: varchar({ length: 16 }), // 근무처 // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ZPRFLG: varchar({ length: 10 }), // 업데이트 여부 Flag // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + ZZBUKRS: varchar({ length: 10 }), // ECC Company 코드 (재무법인코드) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_CORPNM = mdgSchema.table('CMCTB_EMP_MDG_CORPNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_BANM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_BANM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CORPNM: varchar({ length: 255 }), // Corporate Name (CORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (CORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + GTEXT: varchar({ length: 30 }), // Business area description // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (BIZAREA) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_COUNTRYNM = mdgSchema.table('CMCTB_EMP_MDG_COUNTRYNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_BINM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_BINM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - COUNTRYNM: varchar({ length: 255 }), // Country Name (COUNTRYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (COUNTRYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + BINM: varchar({ length: 60 }), // Business Place Name (BICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (BICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_DEPTCODE = mdgSchema.table('CMCTB_EMP_MDG_DEPTCODE', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_COMPNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_COMPNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - PCCD: varchar({ length: 255 }), // Profit Center Code (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - WERKS: varchar({ length: 255 }), // Plant Code (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + COMPNM: varchar({ length: 60 }), // Company Name (COMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (COMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_DEPTCODE_PCCDNM = mdgSchema.table('CMCTB_EMP_MDG_DEPTCODE_PCCDNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_CORPNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_CORPNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - KTEXT: varchar({ length: 255 }), // General Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - LTEXT: varchar({ length: 255 }), // Long Text // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + CORPNM: varchar({ length: 60 }), // Corporate Name (CORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (CORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_DEPTNM = mdgSchema.table('CMCTB_EMP_MDG_DEPTNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_COUNTRYNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_COUNTRYNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DEPTNM: varchar({ length: 255 }), // Department Name (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + COUNTRYNM: varchar({ length: 60 }), // Country Name (COUNTRYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (COUNTRYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_DHJOBGDNM = mdgSchema.table('CMCTB_EMP_MDG_DHJOBGDNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - JOBGRDNM: varchar({ length: 255 }), // Job Grade Name (DHJOBGDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (DHJOBGDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + PCCD: varchar({ length: 10 }), // Profit Center Code (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + WERKS: varchar({ length: 10 }), // Plant Code (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_GJOBDUTYNM = mdgSchema.table('CMCTB_EMP_MDG_GJOBDUTYNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_PCCDNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTCODE_PCCDNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - GJOBDUTYNM: varchar({ length: 255 }), // Global Job Duty Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (GJOBDUTYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + KTEXT: varchar({ length: 20 }), // General Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + LTEXT: varchar({ length: 40 }), // Long Text // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_GJOBGRDNM = mdgSchema.table('CMCTB_EMP_MDG_GJOBGRDNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_DEPTNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - GJOBGRDNM: varchar({ length: 255 }), // Global Job Grade Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (GJOBGRDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + DEPTNM: varchar({ length: 60 }), // Department Name (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (DEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_GJOBGRDTYPE = mdgSchema.table('CMCTB_EMP_MDG_GJOBGRDTYPE', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_DHJOBGDNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_DHJOBGDNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ISEXECUT: varchar({ length: 255 }), // Executive Indicator // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBGRDTYPE: varchar({ length: 255 }), // Job Grade Type // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBGRDNM: varchar({ length: 60 }), // Job Grade Name (DHJOBGDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (DHJOBGDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_GJOBNM = mdgSchema.table('CMCTB_EMP_MDG_GJOBNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBDUTYNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBDUTYNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - SPRAS: varchar({ length: 255 }), // Language Key (GJOBCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + GJOBDUTYNM: varchar({ length: 21 }), // Global Job Duty Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (GJOBDUTYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_GNNM = mdgSchema.table('CMCTB_EMP_MDG_GNNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - GNNM: varchar({ length: 255 }), // General Name (GNCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (GNCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + GJOBGRDNM: varchar({ length: 21 }), // Global Job Grade Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (GJOBGRDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_JOBDUTYNM = mdgSchema.table('CMCTB_EMP_MDG_JOBDUTYNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDTYPE = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBGRDTYPE', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - JOBDUTYNM: varchar({ length: 255 }), // Job Duty Name (JOBDUTYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (JOBDUTYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + ISEXECUT: varchar({ length: 10 }), // Executive Indicator // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBGRDTYPE: varchar({ length: 10 }), // Job Grade Type // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_JOBGRDNM = mdgSchema.table('CMCTB_EMP_MDG_JOBGRDNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_GJOBNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ISEXECUT: varchar({ length: 255 }), // Executive Indicator // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBGRDNM: varchar({ length: 255 }), // Job Grade Name (JOBGRDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - JOBGRDTYPE: varchar({ length: 255 }), // Job Grade Type // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (JOBGRDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + GJOBNM: varchar({ length: 20 }), // Global Job Name // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (GJOBCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_JOBNM = mdgSchema.table('CMCTB_EMP_MDG_JOBNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_GNNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_GNNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - JOBNM: varchar({ length: 255 }), // Job Name (JOBCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (JOBCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + GNNM: varchar({ length: 60 }), // General Name (GNCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (GNCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_KTLNM = mdgSchema.table('CMCTB_EMP_MDG_KTLNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBDUTYNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBDUTYNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - LTEXT: varchar({ length: 255 }), // Cost Center (KTL_EMP) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (KTL_EMP) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + JOBDUTYNM: varchar({ length: 60 }), // Job Duty Name (JOBDUTYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (JOBDUTYCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_OKTLNM = mdgSchema.table('CMCTB_EMP_MDG_OKTLNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBGRDNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBGRDNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - LTEXT: varchar({ length: 255 }), // Cost Center (OKTL_EMPL) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (OKTL_EMPL) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + ISEXECUT: varchar({ length: 10 }), // Executive Indicator // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBGRDNM: varchar({ length: 60 }), // Job Grade Name (JOBGRDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + JOBGRDTYPE: varchar({ length: 10 }), // Job Grade Type // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (JOBGRDCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_ORGBICDNM = mdgSchema.table('CMCTB_EMP_MDG_ORGBICDNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_JOBNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BINM: varchar({ length: 255 }), // Business Place Name (ORGBICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (ORGBICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + JOBNM: varchar({ length: 60 }), // Job Name (JOBCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (JOBCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_ORGCOMPNM = mdgSchema.table('CMCTB_EMP_MDG_ORGCOMPNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_KTLNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_KTLNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - COMPNM: varchar({ length: 255 }), // Company Name (ORGCOMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (ORGCOMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + LTEXT: varchar({ length: 40 }), // Cost Center (KTL_EMP) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (KTL_EMP) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_ORGCORPNM = mdgSchema.table('CMCTB_EMP_MDG_ORGCORPNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_OKTLNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_OKTLNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CORPNM: varchar({ length: 255 }), // Corporate Name (ORGCORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (ORGCORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + LTEXT: varchar({ length: 40 }), // Cost Center (OKTL_EMPL) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (OKTL_EMPL) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_ORGDEPTNM = mdgSchema.table('CMCTB_EMP_MDG_ORGDEPTNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGBICDNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGBICDNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DEPTNM: varchar({ length: 255 }), // Department Name (ORGDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (ORGDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + BINM: varchar({ length: 60 }), // Business Place Name (ORGBICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (ORGBICD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_ORGPDEPNM = mdgSchema.table('CMCTB_EMP_MDG_ORGPDEPNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCOMPNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCOMPNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DEPTNM: varchar({ length: 255 }), // Department Name (ORGPDEPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (ORGPDEPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 + COMPNM: varchar({ length: 60 }), // Company Name (ORGCOMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (ORGCOMPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_MDG_PDEPTNM = mdgSchema.table('CMCTB_EMP_MDG_PDEPTNM', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCORPNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGCORPNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - DEPTNM: varchar({ length: 255 }), // Department Name (PDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key (PDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + CORPNM: varchar({ length: 60 }), // Corporate Name (ORGCORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (ORGCORPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_REF_MDG_IF = mdgSchema.table('CMCTB_EMP_REF_MDG_IF', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGDEPTNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGDEPTNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ADTL_01: varchar({ length: 255 }), // 추가필드1 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl - ADTL_02: varchar({ length: 255 }), // 추가필드2 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl - CORPCD: varchar({ length: 255 }), // 법인코드 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 - GRPCD: varchar({ length: 255 }), // 그룹코드 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 - MAINCD: varchar({ length: 255 }), // 메인코드 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 - VALIDFROMDT: varchar({ length: 255 }), // 시작유효일자 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl - VALIDTODT: varchar({ length: 255 }), // 종료유효일자 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl + DEPTNM: varchar({ length: 60 }), // Department Name (ORGDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (ORGDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_EMP_REF_MDG_IF_NAME = mdgSchema.table('CMCTB_EMP_REF_MDG_IF_NAME', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGPDEPNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_ORGPDEPNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - NAME: varchar({ length: 255 }), // 코드명 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // 언어구분 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 + DEPTNM: varchar({ length: 60 }), // Department Name (ORGPDEPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language Key (ORGPDEPCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_MAT_BSE = mdgSchema.table('CMCTB_MAT_BSE', { +export const EMPLOYEE_MASTER_CMCTB_EMP_MDG_PDEPTNM = mdgSchema.table('EMPLOYEE_MASTER_CMCTB_EMP_MDG_PDEPTNM', { + // [fk] + EMPID: varchar({ length: 20 }).notNull().references(() => EMPLOYEE_MASTER_CMCTB_EMP_MDG.EMPID), // 사원번호 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - IF_MSG: varchar({ length: 255 }), // IF 메시지 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl - IF_STAT: varchar({ length: 255 }), // IF 상태 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl - MAT_CD: varchar({ length: 255 }), // 자재코드 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl // WSDL에서 필수 필드 - MAT_ID: varchar({ length: 255 }), // PLM 채번 자재코드 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl + DEPTNM: varchar({ length: 60 }), // Department Name (PDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl + SPRAS: varchar({ length: 10 }), // Language Key (PDEPTCD) // From: IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const CMCTB_PROJ_MAST = mdgSchema.table('CMCTB_PROJ_MAST', { +// [root] +export const EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF = mdgSchema.table('EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - AS_GRNT_PRD: varchar({ length: 255 }), // A/S 보증기간 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - BIZCLS: varchar({ length: 255 }), // 사업부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - BIZLOC_CD: varchar({ length: 255 }), // 사업장코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - BIZ_DMN: varchar({ length: 255 }), // 사업영역 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - BP_DL_DT: varchar({ length: 255 }), // 선표인도일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CHN_PROJ_TP: varchar({ length: 255 }), // (중국)프로젝트타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CLS_1: varchar({ length: 255 }), // 선급1 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CLS_2: varchar({ length: 255 }), // 선급2 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CNRT_CNTN_YN: varchar({ length: 255 }), // 계약존속여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CNRT_DL_DT: varchar({ length: 255 }), // 계약인도일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CNRT_DT: varchar({ length: 255 }), // 계약일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CNRT_RESV_YN: varchar({ length: 255 }), // 계약유보여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CO_CD: varchar({ length: 255 }), // 회사코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - CSTM_PO_NO: varchar({ length: 255 }), // 고객발주번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DEL_YN: varchar({ length: 255 }), // 삭제 여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DIGT_PDT_GRP: varchar({ length: 255 }), // 전기전자 제품군 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DIST_PATH: varchar({ length: 255 }), // 유통경로 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DL_BF_PROJ_NM: varchar({ length: 255 }), // 인도전선명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DL_CSTM_CD: varchar({ length: 255 }), // 인도고객 ID // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DOCK_CD: varchar({ length: 255 }), // 도크 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - DSN_CHRGR: varchar({ length: 255 }), // 설계담당자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - EXMPT_AREA: varchar({ length: 255 }), // 면세면적 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - EXMPT_RAT: varchar({ length: 255 }), // 면세율 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - FIN_GRNT_FN_DT: varchar({ length: 255 }), // 최종수요자 보증종료일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - GENT_CNT: varchar({ length: 255 }), // 세대수/시리즈 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - GOV: varchar({ length: 255 }), // 관청명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - GRNT_STDT: varchar({ length: 255 }), // Project Warranty Start Date // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - GT: varchar({ length: 255 }), // G/T // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - IF_STAT: varchar({ length: 255 }), // 인터페이스 진행단계 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - IMO_NO: varchar({ length: 255 }), // IMO 번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - INQY_NO: varchar({ length: 255 }), // 안건번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - INQY_SEQ: varchar({ length: 255 }), // 안건순번 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - IO_GB: varchar({ length: 255 }), // 사내외 구분 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - LOA: varchar({ length: 255 }), // L.O.A // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - MNG_ACOT_DMN: varchar({ length: 255 }), // 관리회계영역 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - MN_ENGN_TP_CD: varchar({ length: 255 }), // Main engine type code // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - MSHIP_NO: varchar({ length: 255 }), // 기준호선 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - NEW_MC_YN: varchar({ length: 255 }), // MC YN // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - NTTP: varchar({ length: 255 }), // 국적 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - ORDR_GRNT_FN_DT: varchar({ length: 255 }), // 주문주 보증종료일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - ORDR_GRNT_PRD: varchar({ length: 255 }), // 주문주 보증기간 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - OWN_1: varchar({ length: 255 }), // 선주1 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - OWN_AB: varchar({ length: 255 }), // 선주약어 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - OWN_NM: varchar({ length: 255 }), // 선주명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PDT_LVL_4: varchar({ length: 255 }), // 제품 Level 4 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PLNT_CD: varchar({ length: 255 }), // 플랜트 코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PRCTR: varchar({ length: 255 }), // 손익센터 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PRGS_STAT: varchar({ length: 255 }), // 진행상태 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_CRTE_REQ_DT: varchar({ length: 255 }), // 프로젝트 생성요청일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_CRTE_REQ_EMPNO: varchar({ length: 255 }), // 프로젝트 생성요청자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_DL_PLN_DT: varchar({ length: 255 }), // 모프로젝트 인도계획일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_DL_RT_DT: varchar({ length: 255 }), // 모프로젝트 인도실적일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_DSC: varchar({ length: 255 }), // 프로젝트 설명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_DTL_TP: varchar({ length: 255 }), // 프로젝트 세부타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_ETC_TP: varchar({ length: 255 }), // 프로젝트 기타타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_GB: varchar({ length: 255 }), // 프로젝트구분 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_NO: varchar({ length: 255 }), // 프로젝트번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl // WSDL에서 필수 필드 - PROJ_PRGS_YN: varchar({ length: 255 }), // 공사진행여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_PROF: varchar({ length: 255 }), // 프로젝트 프로파일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_SCP: varchar({ length: 255 }), // 프로젝트범위 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PROJ_WBS_TP: varchar({ length: 255 }), // 프로젝트 WBS타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - PRO_PROJ_NO: varchar({ length: 255 }), // 프로포절 프로젝트 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - QM_CLS: varchar({ length: 255 }), // 품질사업부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - REF_NO: varchar({ length: 255 }), // 시리즈번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - RLTD_PROJ: varchar({ length: 255 }), // 연관프로젝트 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - RL_DL_DT: varchar({ length: 255 }), // 실인도일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SALE_GRP: varchar({ length: 255 }), // 영업그룹 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SALE_ORG_CD: varchar({ length: 255 }), // 영업조직 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SA_DT: varchar({ length: 255 }), // Sail Away Date // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SERS_NO: varchar({ length: 255 }), // 시리즈첫공사번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SERS_YN: varchar({ length: 255 }), // 시리즈여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SHTYPE: varchar({ length: 255 }), // 선형 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SHTYPE_CD: varchar({ length: 255 }), // 선형코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SHTYPE_GRP: varchar({ length: 255 }), // 선형군 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SHTYPE_UOM: varchar({ length: 255 }), // 선형단위 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SKND: varchar({ length: 255 }), // 선종 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SPD: varchar({ length: 255 }), // Speed // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SRC_SYS_ID: varchar({ length: 255 }), // Source System // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - STDT: varchar({ length: 255 }), // 시작일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - SYS_ACOT_CLSD_DT: varchar({ length: 255 }), // 시스템회계마감일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - TOT_AREA: varchar({ length: 255 }), // 전체면적 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - TOT_CNRT_CNT: varchar({ length: 255 }), // 전체 계약 대수 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - TYPE: varchar({ length: 255 }), // 프로젝트 Top/Hull // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - WP_PROJ_TP: varchar({ length: 255 }), // (풍력)프로젝트타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl - - createdAt: timestamp('created_at').defaultNow().notNull(), - updatedAt: timestamp('updated_at').defaultNow().notNull(), -}); - -export const HRHMTB_CCTR = mdgSchema.table('HRHMTB_CCTR', { - id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ABTEI: varchar({ length: 255 }), // Department // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ANRED: varchar({ length: 255 }), // Title // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - BKZER: varchar({ length: 255 }), // Actual Revenue // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - BKZKP: varchar({ length: 255 }), // Actual Primary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - BKZKS: varchar({ length: 255 }), // Actual Secondary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - BKZOB: varchar({ length: 255 }), // Commitment Update // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - BUKRS: varchar({ length: 255 }), // Company Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - CCTR: varchar({ length: 255 }), // Cost Center // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - DATAB: varchar({ length: 255 }), // Valid from // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - DATBI: varchar({ length: 255 }), // Valid to // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - DATLT: varchar({ length: 255 }), // Data communication line no. // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - DRNAM: varchar({ length: 255 }), // Printer destination for CCtr report // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - FUNC_AREA: varchar({ length: 255 }), // Functional Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - GSBER: varchar({ length: 255 }), // Business Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - KHINR: varchar({ length: 255 }), // Standard Hierarchy Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - KOKRS: varchar({ length: 255 }), // Controlling Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - KOSAR: varchar({ length: 255 }), // Cost Center Category // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - LAND1: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - MGEFL: varchar({ length: 255 }), // Record Quantity // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - NAME1: varchar({ length: 255 }), // Name 1 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - NAME2: varchar({ length: 255 }), // Name 2 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - NAME3: varchar({ length: 255 }), // Name 3 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - NAME4: varchar({ length: 255 }), // Name 4 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ORT01: varchar({ length: 255 }), // City // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ORT02: varchar({ length: 255 }), // District // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PFACH: varchar({ length: 255 }), // PO Box // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PKZER: varchar({ length: 255 }), // Plan Revenues // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PKZKP: varchar({ length: 255 }), // Plan Primary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PKZKS: varchar({ length: 255 }), // Plan Secondary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PRCTR: varchar({ length: 255 }), // Profit Center // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PSTL2: varchar({ length: 255 }), // P.O. Box Postal Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PSTLZ: varchar({ length: 255 }), // Postal Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - REGIO: varchar({ length: 255 }), // Region (State, Province, County) // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - SPRAS: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - STRAS: varchar({ length: 255 }), // House number and street // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TELBX: varchar({ length: 255 }), // Telebox number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TELF1: varchar({ length: 255 }), // First telephone number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TELF2: varchar({ length: 255 }), // Second telephone number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TELFX: varchar({ length: 255 }), // Fax Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TELTX: varchar({ length: 255 }), // Teletex number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TELX1: varchar({ length: 255 }), // Telex number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TXJCD: varchar({ length: 255 }), // Tax Jurisdiction // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - VERAK: varchar({ length: 255 }), // Person Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - VERAK_USE: varchar({ length: 255 }), // User Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - VMETH: varchar({ length: 255 }), // Allowed Allocation methods // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - WAERS: varchar({ length: 255 }), // Currency // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZBRANCH: varchar({ length: 255 }), // Business Place // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZDELETE: varchar({ length: 255 }), // Delete Flag // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZFCTRI: varchar({ length: 255 }), // Create Fund Center Indicator // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZSECCODE: varchar({ length: 255 }), // Section Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZSEGMENT: varchar({ length: 255 }), // Segment for Segmental Reporting // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ADTL_01: varchar({ length: 10 }), // 추가필드1 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl + ADTL_02: varchar({ length: 10 }), // 추가필드2 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl + CORPCD: varchar({ length: 10 }).notNull(), // 법인코드 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 + GRPCD: varchar({ length: 10 }).notNull().unique(), // 그룹코드 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 + MAINCD: varchar({ length: 20 }).notNull(), // 메인코드 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 + VALIDFROMDT: varchar({ length: 10 }), // 시작유효일자 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl + VALIDTODT: varchar({ length: 10 }), // 종료유효일자 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_CCTR_TEXT = mdgSchema.table('HRHMTB_CCTR_TEXT', { +export const EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_NAME = mdgSchema.table('EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF_NAME', { + // [fk] + GRPCD: varchar({ length: 10 }).notNull().references(() => EMPLOYEE_REFERENCE_MASTER_CMCTB_EMP_REF_MDG_IF.GRPCD), // 그룹코드 + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - KTEXT: varchar({ length: 255 }), // General Name // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - LTEXT: varchar({ length: 255 }), // Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + NAME: varchar({ length: 90 }), // 코드명 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // 언어구분 // From: IF_MDZ_EVCP_EMPLOYEE_REFERENCE_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_PCTR = mdgSchema.table('HRHMTB_PCTR', { +// [root] +export const EQUP_MASTER_MATL = mdgSchema.table('EQUP_MASTER_MATL', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ABTEI: varchar({ length: 255 }), // Department // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - DATAB: varchar({ length: 255 }), // Valid from // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - DATBI: varchar({ length: 255 }), // Valid to // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - KHINR: varchar({ length: 255 }), // Profit center area(Profit center group) // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - KOKRS: varchar({ length: 255 }), // Controlling Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - LOCK_IND: varchar({ length: 255 }), // Lock indicator // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - PCTR: varchar({ length: 255 }), // Profit Center // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - SEGMENT: varchar({ length: 255 }), // Segment // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - TXJCD: varchar({ length: 255 }), // Tax Jurisdiction // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - VERAK: varchar({ length: 255 }), // Person Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - VERAK_USE: varchar({ length: 255 }), // User Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZDELETE: varchar({ length: 255 }), // Delete Flag // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BISMT: varchar({ length: 18 }), // Old material number // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + BRGEW: varchar({ length: 13 }), // Gross Weight // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + GROES: varchar({ length: 32 }), // Size/dimensions // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + LVORM: varchar({ length: 10 }), // Deletion flag // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MAGRV: varchar({ length: 10 }), // Material Group: Packaging Materials // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MATKL: varchar({ length: 10 }), // Material Group // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MATNR: varchar({ length: 18 }).notNull().unique(), // Material Number // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MBRSH: varchar({ length: 10 }), // Industry sector // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MEABM: varchar({ length: 10 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MEINS: varchar({ length: 10 }), // Base Unit of Measure // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MSTAE: varchar({ length: 10 }), // Material Status // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MSTDE: varchar({ length: 10 }), // Date from which the cross-plant material status is // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MTART: varchar({ length: 10 }), // Material Type // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + NTGEW: varchar({ length: 16 }), // Net Weight // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + PRDHA: varchar({ length: 18 }), // Product hierarchy // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + SPART: varchar({ length: 10 }), // Division // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + VHART: varchar({ length: 10 }), // Packaging Material Type // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + VOLEH: varchar({ length: 10 }), // Volume unit // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZAPPDT: varchar({ length: 10 }), // Approval Date // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZAPPTM: varchar({ length: 10 }), // Approval Time // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZAPPUS: varchar({ length: 12 }), // Approval User // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZDESC: varchar({ length: 255 }), // Description // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZLAMDT: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZLAMTM: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZLAMUS: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZNAME: varchar({ length: 40 }), // Material Name // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZPRFLG: varchar({ length: 10 }), // CRUD Status // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZREGDT: varchar({ length: 10 }), // Registered Date // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZREGTM: varchar({ length: 10 }), // Registered Time // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZREGUS: varchar({ length: 12 }), // Registered User // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZSPEC: varchar({ length: 255 }), // Specification // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZBUKRS = mdgSchema.table('HRHMTB_ZBUKRS', { +export const EQUP_MASTER_MATL_CHARASGN = mdgSchema.table('EQUP_MASTER_MATL_CHARASGN', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => EQUP_MASTER_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CURR_BUKR: varchar({ length: 255 }), // Currency // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZBUKRS: varchar({ length: 255 }), // Company Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZBUTXT: varchar({ length: 255 }), // Company Code Name // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZCITY: varchar({ length: 255 }), // City // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZCOUNTRY: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZLANGU: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ATAW1: varchar({ length: 10 }), // Unit of Measurement // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATAWE: varchar({ length: 10 }), // Unit of Measurement // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATBEZ: varchar({ length: 30 }), // 특성내역 // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATFLB: varchar({ length: 16 }), // Internal floating point value to // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATFLV: varchar({ length: 16 }), // Internal floating point from // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATNAM: varchar({ length: 30 }), // Characteristic Name // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATWRT: varchar({ length: 30 }), // Characteristic Value // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ATWTB: varchar({ length: 30 }), // 특성값내역 // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + CLASS: varchar({ length: 18 }), // Class number // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + KLART: varchar({ length: 10 }), // Class Type // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZEKGRP = mdgSchema.table('HRHMTB_ZEKGRP', { +export const EQUP_MASTER_MATL_CLASSASGN = mdgSchema.table('EQUP_MASTER_MATL_CLASSASGN', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => EQUP_MASTER_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZEKGRP: varchar({ length: 255 }), // Purchasing Group // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZEKNAM: varchar({ length: 255 }), // Purchasing Group Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZEKTEL: varchar({ length: 255 }), // Telephone Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZEMPNUM: varchar({ length: 255 }), // Employee Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZSINGLE: varchar({ length: 255 }), // Single ID // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZTELFX: varchar({ length: 255 }), // Fax Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZTEL_NUM: varchar({ length: 255 }), // Telephone Number (Office) // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + CLASS: varchar({ length: 18 }), // Class number // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + KLART: varchar({ length: 10 }), // Class Type // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZEKORG = mdgSchema.table('HRHMTB_ZEKORG', { +export const EQUP_MASTER_MATL_DESC = mdgSchema.table('EQUP_MASTER_MATL_DESC', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => EQUP_MASTER_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZEKORG: varchar({ length: 255 }), // Purchasing Organization // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZEKOTX: varchar({ length: 255 }), // Purchasing Organization Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + MAKTX: varchar({ length: 40 }), // Material Description (Short Text) // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + SPRAS: varchar({ length: 10 }), // Language // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZGSBER = mdgSchema.table('HRHMTB_ZGSBER', { +export const EQUP_MASTER_MATL_PLNT = mdgSchema.table('EQUP_MASTER_MATL_PLNT', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => EQUP_MASTER_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZGSBER: varchar({ length: 255 }), // Business Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LVORM: varchar({ length: 10 }), // Deletion Flag // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MMSTA: varchar({ length: 10 }), // Plant-Specific Material Status // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MMSTD: varchar({ length: 10 }), // Date from which the plant-specific material status // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + WERKS: varchar({ length: 10 }), // Plant // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZLAMDT: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZLAMTM: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZLAMUS: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZMTARP: varchar({ length: 10 }), // Plant Material Type // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZPRFLG: varchar({ length: 10 }), // CRUD Status // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZREGDT: varchar({ length: 10 }), // Registered Date // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZREGTM: varchar({ length: 10 }), // Registered Time // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + ZZREGUS: varchar({ length: 12 }), // Registered User // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZGSBER_TEXT = mdgSchema.table('HRHMTB_ZGSBER_TEXT', { +export const EQUP_MASTER_MATL_UNIT = mdgSchema.table('EQUP_MASTER_MATL_UNIT', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => EQUP_MASTER_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - LANGU: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - TXTMI: varchar({ length: 255 }), // Business area description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MEABM: varchar({ length: 10 }), // Unit // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + MEINH: varchar({ length: 10 }), // AlternativeUnit // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + UMREN: varchar({ length: 10 }), // Denominator // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + UMREZ: varchar({ length: 10 }), // Numerator // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl + VOLEH: varchar({ length: 10 }), // Volume Unit // From: IF_MDZ_EVCP_EQUP_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZLGORT = mdgSchema.table('HRHMTB_ZLGORT', { +// [root] +export const MATERIAL_MASTER_PART_MATL = mdgSchema.table('MATERIAL_MASTER_PART_MATL', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZLGORT: varchar({ length: 255 }), // Storage Location // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZWERKS: varchar({ length: 255 }), // Plant // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZLGOBE: varchar({ length: 255 }), // Storage Location Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BISMT: varchar({ length: 18 }), // Old material number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + BRGEW: varchar({ length: 13 }), // Gross Weight // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + GROES: varchar({ length: 32 }), // Size/dimensions // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + LVORM: varchar({ length: 10 }), // Deletion flag // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MAGRV: varchar({ length: 10 }), // Material Group: Packaging Materials // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MATKL: varchar({ length: 10 }), // Material Group // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MATNR: varchar({ length: 18 }).notNull().unique(), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + MBRSH: varchar({ length: 10 }), // Industry sector // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MEABM: varchar({ length: 10 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MEINS: varchar({ length: 10 }), // Base Unit of Measure // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MSTAE: varchar({ length: 10 }), // Material Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MSTDE: varchar({ length: 10 }), // Date from which the cross-plant material status is // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MTART: varchar({ length: 10 }), // Material Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + NTGEW: varchar({ length: 16 }), // Net Weight // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + PRDHA: varchar({ length: 18 }), // Product hierarchy // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + SPART: varchar({ length: 10 }), // Division // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + VHART: varchar({ length: 10 }), // Packaging Material Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + VOLEH: varchar({ length: 10 }), // Volume unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZACT: varchar({ length: 18 }), // Activity Code // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZAPPDT: varchar({ length: 10 }), // Approval Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZAPPTM: varchar({ length: 10 }), // Approval Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZAPPUS: varchar({ length: 12 }), // Approval User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZCERT: varchar({ length: 10 }), // Certification Code // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZDESC: varchar({ length: 255 }), // Description // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZINSP: varchar({ length: 10 }), // Inspection // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZLAMDT: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZLAMTM: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZLAMUS: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZMMTYP: varchar({ length: 10 }), // Material Master Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZMRC: varchar({ length: 10 }), // MRC // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZNAME: varchar({ length: 40 }), // Material Name // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZPJT: varchar({ length: 24 }), // Project Code // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZPLMID: varchar({ length: 50 }), // PLM ID // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZPRCD_SCV_CTLP: varchar({ length: 10 }), // 선행후행조정관 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZPRFLG: varchar({ length: 12 }), // CRUD Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREGDT: varchar({ length: 10 }), // Registered Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREGTM: varchar({ length: 10 }), // Registered Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREGUS: varchar({ length: 12 }), // Registered User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREPMAT: varchar({ length: 18 }), // REP Material // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREP_DIA: varchar({ length: 10 }), // 대표지름 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREP_DIA_UOM: varchar({ length: 10 }), // 대표지름단위 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREP_ITM_MATL: varchar({ length: 60 }), // 대표품명재질 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZSMID: varchar({ length: 18 }), // SM ID // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZSPEC: varchar({ length: 255 }), // Specification // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZSTL: varchar({ length: 50 }), // Steel Material // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZSPART = mdgSchema.table('HRHMTB_ZSPART', { +export const MATERIAL_MASTER_PART_MATL_CHARASGN = mdgSchema.table('MATERIAL_MASTER_PART_MATL_CHARASGN', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MATERIAL_MASTER_PART_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZSPART: varchar({ length: 255 }), // Division // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ATAW1: varchar({ length: 10 }), // Unit of Measurement // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATAWE: varchar({ length: 10 }), // Unit of Measurement // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATBEZ: varchar({ length: 30 }), // 특성내역 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATFLB: varchar({ length: 16 }), // Internal floating point value to // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATFLV: varchar({ length: 16 }), // Internal floating point from // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATNAM: varchar({ length: 30 }).notNull(), // Characteristic Name // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + ATWRT: varchar({ length: 30 }), // Characteristic Value // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATWTB: varchar({ length: 30 }), // 특성값내역 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + CLASS: varchar({ length: 18 }).notNull(), // Class number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + KLART: varchar({ length: 10 }).notNull(), // Class Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZVKBUR = mdgSchema.table('HRHMTB_ZVKBUR', { +export const MATERIAL_MASTER_PART_MATL_CLASSASGN = mdgSchema.table('MATERIAL_MASTER_PART_MATL_CLASSASGN', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MATERIAL_MASTER_PART_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CTRY_SOFF: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - LANG_SOFF: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZVKBUR: varchar({ length: 255 }), // Sales Office // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + CLASS: varchar({ length: 18 }).notNull(), // Class number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + KLART: varchar({ length: 10 }).notNull(), // Class Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZVKGRP = mdgSchema.table('HRHMTB_ZVKGRP', { +export const MATERIAL_MASTER_PART_MATL_DESC = mdgSchema.table('MATERIAL_MASTER_PART_MATL_DESC', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MATERIAL_MASTER_PART_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZVKGRP: varchar({ length: 255 }), // Sales Group // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + MAKTX: varchar({ length: 40 }), // Material Description (Short Text) // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + SPRAS: varchar({ length: 10 }).notNull(), // Language // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZVKORG = mdgSchema.table('HRHMTB_ZVKORG', { +export const MATERIAL_MASTER_PART_MATL_PLNT = mdgSchema.table('MATERIAL_MASTER_PART_MATL_PLNT', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MATERIAL_MASTER_PART_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZVKORG: varchar({ length: 255 }), // Sales Organization // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZBOAVO: varchar({ length: 255 }), // Rebate processing active in the sales organization // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZKUNNR: varchar({ length: 255 }), // Customer number for intercompany billing // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZVKOKL: varchar({ length: 255 }), // Sales organization calendar // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZWAERS: varchar({ length: 255 }), // Statistics currency // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LVORM: varchar({ length: 10 }), // Deletion Flag // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MMSTA: varchar({ length: 10 }), // Plant-Specific Material Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MMSTD: varchar({ length: 10 }), // Date from which the plant-specific material status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + WERKS: varchar({ length: 10 }).notNull(), // Plant // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + ZZLAMDT: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZLAMTM: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZLAMUS: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZMTARP: varchar({ length: 10 }), // Plant Material Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZPRFLG: varchar({ length: 10 }), // CRUD Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREGDT: varchar({ length: 10 }), // Registered Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREGTM: varchar({ length: 10 }), // Registered Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZZREGUS: varchar({ length: 12 }), // Registered User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZVSTEL = mdgSchema.table('HRHMTB_ZVSTEL', { +export const MATERIAL_MASTER_PART_MATL_UNIT = mdgSchema.table('MATERIAL_MASTER_PART_MATL_UNIT', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MATERIAL_MASTER_PART_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ALAN_VSTE: varchar({ length: 255 }), // Departure zone // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - AZON_VSTE: varchar({ length: 255 }), // Departure country // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - CTRY_SHPT: varchar({ length: 255 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - LANG_SHPT: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZVSTEL: varchar({ length: 255 }), // Shipping Point // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZFABKL: varchar({ length: 255 }), // Factory calendar key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZLAZBS: varchar({ length: 255 }), // Determine loading time // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZLAZZT: varchar({ length: 255 }), // Default loading time // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZRIZBS: varchar({ length: 255 }), // Determine pick/pack time // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZRIZZT: varchar({ length: 255 }), // Default pick/pack time // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BREIT: varchar({ length: 13 }), // Width // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + BRGEW: varchar({ length: 13 }), // Gross Weight // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + HOEHE: varchar({ length: 13 }), // Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + LAENG: varchar({ length: 13 }), // Length // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MEABM: varchar({ length: 10 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + MEINH: varchar({ length: 10 }).notNull(), // Alternative Unit of Measure for Stockkeeping Unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + UMREN: varchar({ length: 10 }), // Denominator for conversion to base units of measur // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + UMREZ: varchar({ length: 10 }), // Numerator for Conversion to Base Units of Measure // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + VOLEH: varchar({ length: 10 }), // Volume unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + VOLUM: varchar({ length: 13 }), // Volume // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZVTWEG = mdgSchema.table('HRHMTB_ZVTWEG', { +// [root] +export const MATERIAL_MASTER_PART_RETURN_CMCTB_MAT_BSE = mdgSchema.table('MATERIAL_MASTER_PART_RETURN_CMCTB_MAT_BSE', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ZVTWEG: varchar({ length: 255 }), // Distribution Channel // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + IF_MSG: varchar({ length: 100 }), // IF 메시지 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl + IF_STAT: varchar({ length: 10 }), // IF 상태 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl + MAT_CD: varchar({ length: 18 }).notNull().unique(), // 자재코드 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl // WSDL에서 필수 필드 + MAT_ID: varchar({ length: 50 }), // PLM 채번 자재코드 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART_RETURN.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const HRHMTB_ZWERKS = mdgSchema.table('HRHMTB_ZWERKS', { +// [root] +export const MODEL_MASTER_MATL = mdgSchema.table('MODEL_MASTER_MATL', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CTRY_PLNT: varchar({ length: 255 }), // Country // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - LANG_PLNT: varchar({ length: 255 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZWERKS: varchar({ length: 255 }), // Plant // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZDELETE: varchar({ length: 255 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZFABKL: varchar({ length: 255 }), // Factory Calendar // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZNAME1: varchar({ length: 255 }), // Name // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl - ZZNAME2: varchar({ length: 255 }), // Name2 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BISMT: varchar({ length: 18 }), // Old material number // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + BRGEW: varchar({ length: 13 }), // Gross Weight // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + GROES: varchar({ length: 32 }), // Size/dimensions // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + LVORM: varchar({ length: 10 }), // Deletion flag // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MAGRV: varchar({ length: 10 }), // Material Group: Packaging Materials // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MATKL: varchar({ length: 10 }), // Material Group // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MATNR: varchar({ length: 18 }).notNull().unique(), // Material Number // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MBRSH: varchar({ length: 10 }), // Industry sector // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MEABM: varchar({ length: 10 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MEINS: varchar({ length: 10 }), // Base Unit of Measure // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MSTAE: varchar({ length: 10 }), // Material Status // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MSTDE: varchar({ length: 10 }), // Date from which the cross-plant material status is // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MTART: varchar({ length: 10 }), // Material Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + NTGEW: varchar({ length: 16 }), // Net Weight // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + PRDHA: varchar({ length: 18 }), // Product hierarchy // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + SPART: varchar({ length: 10 }), // Division // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + VHART: varchar({ length: 10 }), // Packaging Material Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + VOLEH: varchar({ length: 10 }), // Volume unit // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZAPPDT: varchar({ length: 10 }), // Approval Date // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZAPPTM: varchar({ length: 10 }), // Approval Time // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZAPPUS: varchar({ length: 12 }), // Approval User // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZDESC: varchar({ length: 255 }), // Description // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZDOKAR: varchar({ length: 10 }), // Document Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZDOKNR: varchar({ length: 25 }), // Document number // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZDOKTL: varchar({ length: 10 }), // Document Part // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZDOKVR: varchar({ length: 10 }), // Document Version // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZLAMDT: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZLAMTM: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZLAMUS: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZMMTYP: varchar({ length: 10 }), // Material Master Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZNAME: varchar({ length: 40 }), // Material Name // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZPRFLG: varchar({ length: 10 }), // CRUD Status // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZREGDT: varchar({ length: 10 }), // Registered Date // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZREGTM: varchar({ length: 10 }), // Registered Time // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZREGUS: varchar({ length: 12 }), // Registered User // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZSPEC: varchar({ length: 255 }), // Specification // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), }); -export const MATL = mdgSchema.table('MATL', { +export const MODEL_MASTER_MATL_CHARASGN = mdgSchema.table('MODEL_MASTER_MATL_CHARASGN', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MODEL_MASTER_MATL.MATNR), // Material Number + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BISMT: varchar({ length: 255 }), // Old material number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - BREIT: varchar({ length: 255 }), // Width // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - BRGEW: varchar({ length: 255 }), // Gross Weight // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - GEWEI: varchar({ length: 255 }), // Weight Unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - GROES: varchar({ length: 255 }), // Size/dimensions // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - HOEHE: varchar({ length: 255 }), // Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - LAENG: varchar({ length: 255 }), // Length // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - LVORM: varchar({ length: 255 }), // Deletion flag // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MAGRV: varchar({ length: 255 }), // Material Group: Packaging Materials // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MATKL: varchar({ length: 255 }), // Material Group // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - // MATNR: MATL 의 키. 이 키를 기준으로 다른 테이블과 연결됨. - MATNR: varchar({ length: 255 }), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - MBRSH: varchar({ length: 255 }), // Industry sector // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MEABM: varchar({ length: 255 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MEINS: varchar({ length: 255 }), // Base Unit of Measure // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MSTAE: varchar({ length: 255 }), // Material Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MSTDE: varchar({ length: 255 }), // Date from which the cross-plant material status is // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MTART: varchar({ length: 255 }), // Material Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - NTGEW: varchar({ length: 255 }), // Net Weight // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - PRDHA: varchar({ length: 255 }), // Product hierarchy // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - SPART: varchar({ length: 255 }), // Division // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - VHART: varchar({ length: 255 }), // Packaging Material Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - VOLEH: varchar({ length: 255 }), // Volume unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - VOLUM: varchar({ length: 255 }), // Volume // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZACT: varchar({ length: 255 }), // Activity Code // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZAPPDT: varchar({ length: 255 }), // Approval Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZAPPTM: varchar({ length: 255 }), // Approval Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZAPPUS: varchar({ length: 255 }), // Approval User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZCERT: varchar({ length: 255 }), // Certification Code // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZDESC: varchar({ length: 255 }), // Description // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZDOKAR: varchar({ length: 255 }), // Document Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl - ZZDOKNR: varchar({ length: 255 }), // Document number // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl - ZZDOKTL: varchar({ length: 255 }), // Document Part // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl - ZZDOKVR: varchar({ length: 255 }), // Document Version // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl - ZZINSP: varchar({ length: 255 }), // Inspection // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZLAMDT: varchar({ length: 255 }), // Last Modified Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZLAMTM: varchar({ length: 255 }), // Last Modified Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZLAMUS: varchar({ length: 255 }), // Last Modified User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZMMTYP: varchar({ length: 255 }), // Material Master Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZMRC: varchar({ length: 255 }), // MRC // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZNAME: varchar({ length: 255 }), // Material Name // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZPJT: varchar({ length: 255 }), // Project Code // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZPLMID: varchar({ length: 255 }), // PLM ID // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZPRCD_SCV_CTLP: varchar({ length: 255 }), // 선행후행조정관 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZPRFLG: varchar({ length: 255 }), // CRUD Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREGDT: varchar({ length: 255 }), // Registered Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREGTM: varchar({ length: 255 }), // Registered Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREGUS: varchar({ length: 255 }), // Registered User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREPMAT: varchar({ length: 255 }), // REP Material // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREP_DIA: varchar({ length: 255 }), // 대표지름 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREP_DIA_UOM: varchar({ length: 255 }), // 대표지름단위 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREP_ITM_MATL: varchar({ length: 255 }), // 대표품명재질 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZSMID: varchar({ length: 255 }), // SM ID // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZSPEC: varchar({ length: 255 }), // Specification // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZSTL: varchar({ length: 255 }), // Steel Material // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ATAW1: varchar({ length: 10 }), // Unit of Measurement // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATAWE: varchar({ length: 10 }), // Unit of Measurement // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATBEZ: varchar({ length: 30 }), // 특성내역 // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATFLB: varchar({ length: 16 }), // Internal floating point value to // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATFLV: varchar({ length: 16 }), // Internal floating point from // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATNAM: varchar({ length: 30 }), // Characteristic Name // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATWRT: varchar({ length: 30 }), // Characteristic Value // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ATWTB: varchar({ length: 30 }), // 특성값내역 // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + CLASS: varchar({ length: 18 }), // Class number // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + KLART: varchar({ length: 10 }), // Class Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const MODEL_MASTER_MATL_CLASSASGN = mdgSchema.table('MODEL_MASTER_MATL_CLASSASGN', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MODEL_MASTER_MATL.MATNR), // Material Number + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + CLASS: varchar({ length: 18 }), // Class number // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + KLART: varchar({ length: 10 }), // Class Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const MODEL_MASTER_MATL_DESC = mdgSchema.table('MODEL_MASTER_MATL_DESC', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MODEL_MASTER_MATL.MATNR), // Material Number + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + MAKTX: varchar({ length: 40 }), // Material Description (Short Text) // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + SPRAS: varchar({ length: 10 }), // Language // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const MODEL_MASTER_MATL_PLNT = mdgSchema.table('MODEL_MASTER_MATL_PLNT', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MODEL_MASTER_MATL.MATNR), // Material Number + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + LVORM: varchar({ length: 10 }), // Deletion Flag // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MMSTA: varchar({ length: 10 }), // Plant-Specific Material Status // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MMSTD: varchar({ length: 10 }), // Date from which the plant-specific material status // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + WERKS: varchar({ length: 10 }), // Plant // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZLAMDT: varchar({ length: 10 }), // Last Modified Date // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZLAMTM: varchar({ length: 10 }), // Last Modified Time // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZLAMUS: varchar({ length: 12 }), // Last Modified User // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZMTARP: varchar({ length: 10 }), // Plant Material Type // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZPRFLG: varchar({ length: 10 }), // CRUD Status // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZREGDT: varchar({ length: 10 }), // Registered Date // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZREGTM: varchar({ length: 10 }), // Registered Time // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + ZZREGUS: varchar({ length: 12 }), // Registered User // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const MODEL_MASTER_MATL_UNIT = mdgSchema.table('MODEL_MASTER_MATL_UNIT', { + // [fk] + MATNR: varchar({ length: 18 }).notNull().references(() => MODEL_MASTER_MATL.MATNR), // Material Number + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + BREIT: varchar({ length: 13 }), // Width // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + BRGEW: varchar({ length: 13 }), // Gross Weight // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + HOEHE: varchar({ length: 13 }), // Height // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + LAENG: varchar({ length: 13 }), // Length // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MEABM: varchar({ length: 10 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + MEINH: varchar({ length: 10 }), // Alternative Unit of Measure for Stockkeeping Unit // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + UMREN: varchar({ length: 10 }), // Denominator for conversion to base units of measur // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + UMREZ: varchar({ length: 10 }), // Numerator for Conversion to Base Units of Measure // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + VOLEH: varchar({ length: 10 }), // Volume unit // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + VOLUM: varchar({ length: 13 }), // Volume // From: IF_MDZ_EVCP_MODEL_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_CCTR = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_CCTR', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ABTEI: varchar({ length: 12 }), // Department // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ANRED: varchar({ length: 15 }), // Title // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BKZER: varchar({ length: 10 }), // Actual Revenue // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BKZKP: varchar({ length: 10 }), // Actual Primary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BKZKS: varchar({ length: 10 }), // Actual Secondary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BKZOB: varchar({ length: 10 }), // Commitment Update // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + BUKRS: varchar({ length: 10 }), // Company Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + CCTR: varchar({ length: 10 }).notNull().unique(), // Cost Center // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + DATAB: varchar({ length: 10 }), // Valid from // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + DATBI: varchar({ length: 10 }).notNull(), // Valid to // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + DATLT: varchar({ length: 14 }), // Data communication line no. // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + DRNAM: varchar({ length: 10 }), // Printer destination for CCtr report // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + FUNC_AREA: varchar({ length: 16 }), // Functional Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + GSBER: varchar({ length: 10 }), // Business Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + KHINR: varchar({ length: 12 }), // Standard Hierarchy Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + KOKRS: varchar({ length: 10 }).notNull(), // Controlling Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + KOSAR: varchar({ length: 10 }), // Cost Center Category // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LAND1: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + MGEFL: varchar({ length: 10 }), // Record Quantity // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + NAME1: varchar({ length: 70 }), // Name 1 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + NAME2: varchar({ length: 70 }), // Name 2 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + NAME3: varchar({ length: 70 }), // Name 3 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + NAME4: varchar({ length: 70 }), // Name 4 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ORT01: varchar({ length: 35 }), // City // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ORT02: varchar({ length: 35 }), // District // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PFACH: varchar({ length: 10 }), // PO Box // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PKZER: varchar({ length: 10 }), // Plan Revenues // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PKZKP: varchar({ length: 10 }), // Plan Primary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PKZKS: varchar({ length: 10 }), // Plan Secondary Costs // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PRCTR: varchar({ length: 10 }), // Profit Center // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PSTL2: varchar({ length: 10 }), // P.O. Box Postal Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PSTLZ: varchar({ length: 10 }), // Postal Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + REGIO: varchar({ length: 10 }), // Region (State, Province, County) // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + SPRAS: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + STRAS: varchar({ length: 35 }), // House number and street // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TELBX: varchar({ length: 15 }), // Telebox number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TELF1: varchar({ length: 16 }), // First telephone number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TELF2: varchar({ length: 16 }), // Second telephone number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TELFX: varchar({ length: 31 }), // Fax Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TELTX: varchar({ length: 30 }), // Teletex number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TELX1: varchar({ length: 30 }), // Telex number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TXJCD: varchar({ length: 15 }), // Tax Jurisdiction // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + VERAK: varchar({ length: 60 }), // Person Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + VERAK_USE: varchar({ length: 12 }), // User Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + VMETH: varchar({ length: 10 }), // Allowed Allocation methods // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + WAERS: varchar({ length: 10 }), // Currency // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZBRANCH: varchar({ length: 10 }), // Business Place // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZDELETE: varchar({ length: 10 }), // Delete Flag // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZFCTRI: varchar({ length: 10 }), // Create Fund Center Indicator // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZSECCODE: varchar({ length: 10 }), // Section Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZSEGMENT: varchar({ length: 10 }), // Segment for Segmental Reporting // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.MATNR), -]); +}); + +export const ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_CCTR_TEXT', { + // [fk] + CCTR: varchar({ length: 10 }).notNull().unique().references(() => ORGANIZATION_MASTER_HRHMTB_CCTR.CCTR), // Cost Center -export const MATL_CHARASGN = mdgSchema.table('MATL_CHARASGN', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ATAW1: varchar({ length: 255 }), // Unit of Measurement // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ATAWE: varchar({ length: 255 }), // Unit of Measurement // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ATBEZ: varchar({ length: 255 }), // 특성내역 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ATFLB: varchar({ length: 255 }), // Internal floating point value to // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ATFLV: varchar({ length: 255 }), // Internal floating point from // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ATNAM: varchar({ length: 255 }), // Characteristic Name // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - ATWRT: varchar({ length: 255 }), // Characteristic Value // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ATWTB: varchar({ length: 255 }), // 특성값내역 // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - CLASS: varchar({ length: 255 }), // Class number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - KLART: varchar({ length: 255 }), // Class Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - MATNR: varchar({ length: 255 }).notNull().references(() => MATL.MATNR, { onDelete: 'cascade' }), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + KTEXT: varchar({ length: 60 }), // General Name // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LTEXT: varchar({ length: 120 }), // Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.MATNR, table.CLASS, table.KLART, table.ATNAM), -]); +}); -export const MATL_CLASSASGN = mdgSchema.table('MATL_CLASSASGN', { +// [root] +export const ORGANIZATION_MASTER_HRHMTB_PCTR = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_PCTR', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - CLASS: varchar({ length: 255 }), // Class number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - KLART: varchar({ length: 255 }), // Class Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - MATNR: varchar({ length: 255 }).notNull().references(() => MATL.MATNR, { onDelete: 'cascade' }), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + ABTEI: varchar({ length: 12 }), // Department // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + DATAB: varchar({ length: 10 }), // Valid from // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + DATBI: varchar({ length: 10 }).notNull(), // Valid to // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + KHINR: varchar({ length: 12 }), // Profit center area(Profit center group) // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + KOKRS: varchar({ length: 10 }).notNull(), // Controlling Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + LOCK_IND: varchar({ length: 10 }), // Lock indicator // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + PCTR: varchar({ length: 10 }).notNull().unique(), // Profit Center // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + SEGMENT: varchar({ length: 10 }), // Segment // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + TXJCD: varchar({ length: 15 }), // Tax Jurisdiction // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + VERAK: varchar({ length: 20 }), // Person Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + VERAK_USE: varchar({ length: 12 }), // User Responsible // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZDELETE: varchar({ length: 10 }), // Delete Flag // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.MATNR, table.CLASS, table.KLART), -]); +}); -export const MATL_DESC = mdgSchema.table('MATL_DESC', { +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZBUKRS = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZBUKRS', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - MAKTX: varchar({ length: 255 }), // Material Description (Short Text) // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MATNR: varchar({ length: 255 }).notNull().references(() => MATL.MATNR, { onDelete: 'cascade' }), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - SPRAS: varchar({ length: 255 }), // Language // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 + CURR_BUKR: varchar({ length: 10 }), // Currency // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZBUKRS: varchar({ length: 10 }).notNull().unique(), // Company Code // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZBUTXT: varchar({ length: 50 }), // Company Code Name // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZCITY: varchar({ length: 50 }), // City // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZCOUNTRY: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZLANGU: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.MATNR, table.SPRAS), -]); +}); -export const MATL_PLNT = mdgSchema.table('MATL_PLNT', { +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZEKGRP = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZEKGRP', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - LVORM: varchar({ length: 255 }), // Deletion Flag // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MATNR: varchar({ length: 255 }).notNull().references(() => MATL.MATNR, { onDelete: 'cascade' }), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - MMSTA: varchar({ length: 255 }), // Plant-Specific Material Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MMSTD: varchar({ length: 255 }), // Date from which the plant-specific material status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - WERKS: varchar({ length: 255 }), // Plant // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - ZZLAMDT: varchar({ length: 255 }), // Last Modified Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZLAMTM: varchar({ length: 255 }), // Last Modified Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZLAMUS: varchar({ length: 255 }), // Last Modified User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZMTARP: varchar({ length: 255 }), // Plant Material Type // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZPRFLG: varchar({ length: 255 }), // CRUD Status // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREGDT: varchar({ length: 255 }), // Registered Date // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREGTM: varchar({ length: 255 }), // Registered Time // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - ZZREGUS: varchar({ length: 255 }), // Registered User // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZEKGRP: varchar({ length: 10 }).notNull().unique(), // Purchasing Group // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZEKNAM: varchar({ length: 36 }), // Purchasing Group Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZEKTEL: varchar({ length: 12 }), // Telephone Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZEMPNUM: varchar({ length: 10 }), // Employee Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZSINGLE: varchar({ length: 241 }), // Single ID // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZTELFX: varchar({ length: 31 }), // Fax Number // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZTEL_NUM: varchar({ length: 30 }), // Telephone Number (Office) // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.MATNR, table.WERKS), -]); +}); -export const MATL_UNIT = mdgSchema.table('MATL_UNIT', { +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZEKORG = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZEKORG', { id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - BREIT: varchar({ length: 255 }), // Width // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - BRGEW: varchar({ length: 255 }), // Gross Weight // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - GEWEI: varchar({ length: 255 }), // Weight Unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - HOEHE: varchar({ length: 255 }), // Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - LAENG: varchar({ length: 255 }), // Length // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MATNR: varchar({ length: 255 }), // Material Number // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - MEABM: varchar({ length: 255 }), // Unit of Dimension for Length/Width/Height // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - MEINH: varchar({ length: 255 }), // Alternative Unit of Measure for Stockkeeping Unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl // WSDL에서 필수 필드 - UMREN: varchar({ length: 255 }), // Denominator for conversion to base units of measur // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - UMREZ: varchar({ length: 255 }), // Numerator for Conversion to Base Units of Measure // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - VOLEH: varchar({ length: 255 }), // Volume unit // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl - VOLUM: varchar({ length: 255 }), // Volume // From: IF_MDZ_EVCP_MATERIAL_MASTER_PART.wsdl + ZEKORG: varchar({ length: 10 }).notNull().unique(), // Purchasing Organization // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZEKOTX: varchar({ length: 40 }), // Purchasing Organization Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), -}, (table) => [ - unique().on(table.MATNR, table.MEINH), -]); +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZGSBER = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZGSBER', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ZGSBER: varchar({ length: 10 }).notNull().unique(), // Business Area // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZGSBER_TEXT', { + // [fk] + ZGSBER: varchar({ length: 10 }).notNull().unique().references(() => ORGANIZATION_MASTER_HRHMTB_ZGSBER.ZGSBER), // Business Area + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + LANGU: varchar({ length: 10 }).notNull(), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + TXTMI: varchar({ length: 60 }), // Business area description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZLGORT = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZLGORT', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ZLGORT: varchar({ length: 10 }).notNull().unique(), // Storage Location // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZWERKS: varchar({ length: 10 }).notNull(), // Plant // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZLGOBE: varchar({ length: 32 }), // Storage Location Description // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZSPART = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZSPART', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ZSPART: varchar({ length: 10 }).notNull().unique(), // Division // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZVKBUR = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZVKBUR', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + CTRY_SOFF: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LANG_SOFF: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZVKBUR: varchar({ length: 10 }).notNull().unique(), // Sales Office // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZVKGRP = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZVKGRP', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ZVKGRP: varchar({ length: 10 }).notNull().unique(), // Sales Group // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZVKORG = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZVKORG', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ZVKORG: varchar({ length: 10 }).notNull().unique(), // Sales Organization // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZBOAVO: varchar({ length: 10 }), // Rebate processing active in the sales organization // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZKUNNR: varchar({ length: 10 }), // Customer number for intercompany billing // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZVKOKL: varchar({ length: 10 }), // Sales organization calendar // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZWAERS: varchar({ length: 10 }), // Statistics currency // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZVSTEL = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZVSTEL', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ALAN_VSTE: varchar({ length: 10 }), // Departure zone // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + AZON_VSTE: varchar({ length: 10 }), // Departure country // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + CTRY_SHPT: varchar({ length: 10 }), // Country Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LANG_SHPT: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZVSTEL: varchar({ length: 10 }).notNull().unique(), // Shipping Point // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZFABKL: varchar({ length: 10 }), // Factory calendar key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZLAZBS: varchar({ length: 10 }), // Determine loading time // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZRIZBS: varchar({ length: 10 }), // Determine pick/pack time // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZVTWEG = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZVTWEG', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ZVTWEG: varchar({ length: 10 }).notNull().unique(), // Distribution Channel // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl // WSDL에서 필수 필드 + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const ORGANIZATION_MASTER_HRHMTB_ZWERKS = mdgSchema.table('ORGANIZATION_MASTER_HRHMTB_ZWERKS', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + CTRY_PLNT: varchar({ length: 10 }), // Country // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + LANG_PLNT: varchar({ length: 10 }), // Language Key // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + // 인터페이스 정의서 정보 누락으로 의심되는 부분. 아래 ZWERKS 필드에 M 없음. + ZWERKS: varchar({ length: 10 }).notNull().unique(), // Plant // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZDELETE: varchar({ length: 10 }), // Flag for deletion // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZFABKL: varchar({ length: 10 }), // Factory Calendar // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZNAME1: varchar({ length: 60 }), // Name // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + ZZNAME2: varchar({ length: 60 }), // Name2 // From: IF_MDZ_EVCP_ORGANIZATION_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const PROJECT_MASTER_CMCTB_PROJ_MAST = mdgSchema.table('PROJECT_MASTER_CMCTB_PROJ_MAST', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + AS_GRNT_PRD: varchar({ length: 10 }), // A/S 보증기간 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + BIZCLS: varchar({ length: 10 }), // 사업부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + BIZLOC_CD: varchar({ length: 10 }), // 사업장코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + BIZ_DMN: varchar({ length: 10 }), // 사업영역 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + BP_DL_DT: varchar({ length: 10 }), // 선표인도일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CHN_PROJ_TP: varchar({ length: 10 }), // (중국)프로젝트타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CLS_1: varchar({ length: 20 }), // 선급1 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CLS_2: varchar({ length: 20 }), // 선급2 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CNRT_CNTN_YN: varchar({ length: 10 }), // 계약존속여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CNRT_DL_DT: varchar({ length: 10 }), // 계약인도일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CNRT_DT: varchar({ length: 10 }), // 계약일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CNRT_RESV_YN: varchar({ length: 10 }), // 계약유보여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CO_CD: varchar({ length: 10 }), // 회사코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + CSTM_PO_NO: varchar({ length: 35 }), // 고객발주번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DEL_YN: varchar({ length: 10 }), // 삭제 여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DIGT_PDT_GRP: varchar({ length: 10 }), // 전기전자 제품군 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DIST_PATH: varchar({ length: 10 }), // 유통경로 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DL_BF_PROJ_NM: varchar({ length: 120 }), // 인도전선명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DL_CSTM_CD: varchar({ length: 10 }), // 인도고객 ID // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DOCK_CD: varchar({ length: 10 }), // 도크 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + DSN_CHRGR: varchar({ length: 13 }), // 설계담당자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + FIN_GRNT_FN_DT: varchar({ length: 10 }), // 최종수요자 보증종료일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + GENT_CNT: varchar({ length: 10 }), // 세대수/시리즈 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + GOV: varchar({ length: 60 }), // 관청명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + GRNT_STDT: varchar({ length: 10 }), // Project Warranty Start Date // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + IF_STAT: varchar({ length: 10 }), // 인터페이스 진행단계 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + IMO_NO: varchar({ length: 10 }), // IMO 번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + INQY_NO: varchar({ length: 30 }), // 안건번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + INQY_SEQ: varchar({ length: 10 }), // 안건순번 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + IO_GB: varchar({ length: 10 }), // 사내외 구분 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + MNG_ACOT_DMN: varchar({ length: 10 }), // 관리회계영역 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + MN_ENGN_TP_CD: varchar({ length: 30 }), // Main engine type code // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + MSHIP_NO: varchar({ length: 24 }), // 기준호선 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + NEW_MC_YN: varchar({ length: 10 }), // MC YN // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + NTTP: varchar({ length: 10 }), // 국적 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + ORDR_GRNT_FN_DT: varchar({ length: 10 }), // 주문주 보증종료일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + ORDR_GRNT_PRD: varchar({ length: 10 }), // 주문주 보증기간 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + OWN_1: varchar({ length: 10 }), // 선주1 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + OWN_AB: varchar({ length: 60 }), // 선주약어 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + OWN_NM: varchar({ length: 40 }), // 선주명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PDT_LVL_4: varchar({ length: 14 }), // 제품 Level 4 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PLNT_CD: varchar({ length: 10 }), // 플랜트 코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PRCTR: varchar({ length: 10 }), // 손익센터 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PRGS_STAT: varchar({ length: 10 }), // 진행상태 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_CRTE_REQ_DT: varchar({ length: 10 }), // 프로젝트 생성요청일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_CRTE_REQ_EMPNO: varchar({ length: 13 }), // 프로젝트 생성요청자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_DL_PLN_DT: varchar({ length: 10 }), // 모프로젝트 인도계획일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_DL_RT_DT: varchar({ length: 10 }), // 모프로젝트 인도실적일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_DSC: varchar({ length: 120 }), // 프로젝트 설명 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_DTL_TP: varchar({ length: 10 }), // 프로젝트 세부타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_ETC_TP: varchar({ length: 10 }), // 프로젝트 기타타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_GB: varchar({ length: 10 }), // 프로젝트구분 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_NO: varchar({ length: 24 }).notNull().unique(), // 프로젝트번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl // WSDL에서 필수 필드 + PROJ_PRGS_YN: varchar({ length: 10 }), // 공사진행여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_PROF: varchar({ length: 10 }), // 프로젝트 프로파일 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_SCP: varchar({ length: 10 }), // 프로젝트범위 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PROJ_WBS_TP: varchar({ length: 10 }), // 프로젝트 WBS타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + PRO_PROJ_NO: varchar({ length: 24 }), // 프로포절 프로젝트 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + QM_CLS: varchar({ length: 10 }), // 품질사업부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + REF_NO: varchar({ length: 10 }), // 시리즈번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + RLTD_PROJ: varchar({ length: 24 }), // 연관프로젝트 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + RL_DL_DT: varchar({ length: 10 }), // 실인도일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SALE_GRP: varchar({ length: 10 }), // 영업그룹 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SALE_ORG_CD: varchar({ length: 10 }), // 영업조직 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SA_DT: varchar({ length: 10 }), // Sail Away Date // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SERS_NO: varchar({ length: 24 }), // 시리즈첫공사번호 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SERS_YN: varchar({ length: 10 }), // 시리즈여부 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SHTYPE: varchar({ length: 10 }), // 선형 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SHTYPE_CD: varchar({ length: 10 }), // 선형코드 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SHTYPE_GRP: varchar({ length: 10 }), // 선형군 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SHTYPE_UOM: varchar({ length: 10 }), // 선형단위 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SKND: varchar({ length: 10 }), // 선종 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SRC_SYS_ID: varchar({ length: 10 }), // Source System // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + STDT: varchar({ length: 10 }), // 시작일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + SYS_ACOT_CLSD_DT: varchar({ length: 10 }), // 시스템회계마감일자 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + TOT_CNRT_CNT: varchar({ length: 10 }), // 전체 계약 대수 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + TYPE: varchar({ length: 10 }), // 프로젝트 Top/Hull // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + WP_PROJ_TP: varchar({ length: 10 }), // (풍력)프로젝트타입 // From: IF_MDZ_EVCP_PROJECT_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +// [root] +export const VENDOR_MASTER_BP_HEADER = mdgSchema.table('VENDOR_MASTER_BP_HEADER', { + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + VNDRCD: varchar({ length: 10 }).notNull().unique(), // VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_ADDRESS = mdgSchema.table('VENDOR_MASTER_BP_HEADER_ADDRESS', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ADR_NO: varchar({ length: 10 }).notNull(), // 주소번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_ADDRESS_AD_EMAIL = mdgSchema.table('VENDOR_MASTER_BP_HEADER_ADDRESS_AD_EMAIL', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + EMAIL_ADR: varchar({ length: 241 }), // 이메일주소 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REPR_SER: varchar({ length: 10 }).notNull(), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + VLD_ST_DT: varchar({ length: 10 }).notNull(), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_ADDRESS_AD_FAX = mdgSchema.table('VENDOR_MASTER_BP_HEADER_ADDRESS_AD_FAX', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + FAXNO: varchar({ length: 30 }), // 팩스번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + FAX_ETS_NO: varchar({ length: 10 }), // 팩스내선번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + NTN_CD: varchar({ length: 10 }), // 국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REPR_SER: varchar({ length: 10 }).notNull(), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + VLD_ST_DT: varchar({ length: 10 }).notNull(), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL = mdgSchema.table('VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ADR_1: varchar({ length: 190 }), // 주소1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ADR_2: varchar({ length: 120 }), // 주소2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ADR_TMZ: varchar({ length: 10 }), // 주소시간대 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CITY_ZIP_NO: varchar({ length: 10 }), // 도시우편번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ETC_ADR_1: varchar({ length: 180 }), // 기타주소1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ETC_ADR_2: varchar({ length: 180 }), // 기타주소2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + INTL_ADR_VER_ID: varchar({ length: 10 }).notNull(), // 국제주소버전ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + LANG_KEY: varchar({ length: 10 }), // 언어키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + NTN_CD: varchar({ length: 10 }), // 국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + POBX: varchar({ length: 10 }), // 사서함 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + POBX_ZIP_NO: varchar({ length: 10 }), // 사서함우편번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REGN_CD: varchar({ length: 10 }), // 지역코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TAX_JRDT_ZONE_CD: varchar({ length: 15 }), // 조세관할구역코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TRANS_ZONE: varchar({ length: 10 }), // 운송구역 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TTL: varchar({ length: 90 }), // 타이틀 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_1: varchar({ length: 120 }), // VENDOR명1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_2: varchar({ length: 120 }), // VENDOR명2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_3: varchar({ length: 120 }), // VENDOR명3 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_4: varchar({ length: 120 }), // VENDOR명4 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_ABRV_1: varchar({ length: 60 }), // VENDOR명약어1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_ABRV_2: varchar({ length: 60 }), // VENDOR명약어2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_ADDRESS_AD_TEL = mdgSchema.table('VENDOR_MASTER_BP_HEADER_ADDRESS_AD_TEL', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ETX_NO: varchar({ length: 10 }), // 내선번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + HP_ORDR: varchar({ length: 10 }), // 핸드폰지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + NTN_CD: varchar({ length: 10 }), // 국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REPR_SER: varchar({ length: 10 }).notNull(), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + TELNO: varchar({ length: 30 }), // 전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VLD_ST_DT: varchar({ length: 10 }).notNull(), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_ADDRESS_AD_URL = mdgSchema.table('VENDOR_MASTER_BP_HEADER_ADDRESS_AD_URL', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + REPR_SER: varchar({ length: 10 }).notNull(), // 대표자순번 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + URL: varchar({ length: 2000 }), // URL // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VLD_ST_DT: varchar({ length: 10 }).notNull(), // 유효시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_BP_TAXNUM = mdgSchema.table('VENDOR_MASTER_BP_HEADER_BP_TAXNUM', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + BIZ_PTNR_TX_NO: varchar({ length: 20 }), // 사업파트너세금번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TX_NO_CTG: varchar({ length: 10 }).notNull(), // 세금번호범주 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_BP_VENGEN = mdgSchema.table('VENDOR_MASTER_BP_HEADER_BP_VENGEN', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ACNT_GRP: varchar({ length: 10 }), // 계정그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ACNT_GRP_TP: varchar({ length: 10 }), // 계정그룹유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ADR_1: varchar({ length: 120 }), // 주소1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ADR_2: varchar({ length: 512 }), // 주소2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + AGR_DT: varchar({ length: 10 }), // 승인일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + AGR_R_ID: varchar({ length: 13 }), // 승인자ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + AGR_TM: varchar({ length: 10 }), // 승인시간 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + BIZCON: varchar({ length: 30 }), // 산업유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + BIZR_NO: varchar({ length: 10 }), // 사업자번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + BIZTP: varchar({ length: 30 }), // 사업유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + BIZ_UOM_CD: varchar({ length: 10 }), // 사업단위코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + BIZ_UOM_NM: varchar({ length: 40 }), // 사업단위명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CHGR_ID: varchar({ length: 13 }), // 변경자ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CHG_DT: varchar({ length: 10 }), // 변경일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CHG_TM: varchar({ length: 10 }), // 변경시간 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CO_ID: varchar({ length: 10 }), // 법인ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CO_REG_NO: varchar({ length: 18 }), // 법인등록번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CO_VLM: varchar({ length: 10 }), // 기업규모 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CSTM_CD: varchar({ length: 10 }), // 고객코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DEL_HOLD_ORDR: varchar({ length: 10 }), // 삭제보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DEL_ORDR: varchar({ length: 10 }), // 삭제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DMST_TOP_CD: varchar({ length: 10 }), // 국내TOP코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DMST_TOP_NM: varchar({ length: 120 }), // 국내TOP명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DNS_NO: varchar({ length: 11 }), // DUNS번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DOC_NO: varchar({ length: 25 }), // 문서번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DOC_TP: varchar({ length: 10 }), // 문서유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DOC_VER: varchar({ length: 10 }), // 문서버전 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + FIR_NM: varchar({ length: 120 }), // FIRST이름 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + GBL_TOP_CD: varchar({ length: 10 }), // GLOBALTOP코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + GBL_TOP_NM: varchar({ length: 120 }), // GLOBALTOP명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + GIRO_VNDR_ORDR: varchar({ length: 10 }), // 지로VENDOR지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + HOLD_CAUS: varchar({ length: 200 }), // 보류사유 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + INB_FLAG: varchar({ length: 10 }), // 인바운드플래그 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + INTL_LCTN_CHK_NUM: varchar({ length: 10 }), // 국제LOCATION점검숫자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + OVLAP_CAUS_CD: varchar({ length: 10 }), // 중복사유코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PST_HOLD_ORDR: varchar({ length: 10 }), // 전기보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PTNT_VNDRCD: varchar({ length: 10 }), // 잠재VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PTN_DOC: varchar({ length: 10 }), // 부분문서 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_HOLD_DT: varchar({ length: 10 }), // 구매보류일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_HOLD_ORDR: varchar({ length: 10 }), // 구매보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + QLT_CHRGR_EMAIL: varchar({ length: 241 }), // 품질담당자이메일 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + QLT_CHRGR_NM: varchar({ length: 20 }), // 품질담당자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + QLT_CHRGR_TELNO: varchar({ length: 30 }), // 품질담당자전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REGR_ID: varchar({ length: 13 }), // 등록자ID // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REG_DT: varchar({ length: 10 }), // 등록일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REG_TM: varchar({ length: 10 }), // 등록시간 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REPR_NM: varchar({ length: 30 }), // 대표자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REPR_RESNO: varchar({ length: 13 }), // 대표자주민번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REP_TEL_NO: varchar({ length: 30 }), // 대표전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SB_WKA_SEQ: varchar({ length: 10 }), // SUB작업장순서 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCETX_RP_SEX_KEY: varchar({ length: 10 }), // 원천세의무자성별키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TTL: varchar({ length: 45 }), // 타이틀 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TX_CD_4: varchar({ length: 18 }), // 세금번호4 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VAT_REG_NO: varchar({ length: 20 }), // 부가세등록번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNM_1: varchar({ length: 10 }), // VENDOR명1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDRNO: varchar({ length: 10 }).notNull(), // VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY = mdgSchema.table('VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + ACOT_CHRGR_FAXNO: varchar({ length: 31 }), // 회계담당자FAX번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ACOT_CHRGR_TELNO: varchar({ length: 30 }), // 회계담당자전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + AUTH_GRP: varchar({ length: 10 }), // 권한그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + BF_VNDRCD: varchar({ length: 10 }), // 이전VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CO_CD: varchar({ length: 10 }).notNull(), // 회사코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + CSTM_VNDR_CLR_ORDR: varchar({ length: 10 }), // CUSTOMER,VENDOR반제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CTL_ACNT: varchar({ length: 10 }), // 조정계정 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DEL_ORDR: varchar({ length: 10 }), // 삭제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + FIN_IR_ACT_DT: varchar({ length: 10 }), // 최종이자실행일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + FIN_IR_CALC_DT: varchar({ length: 10 }), // 최종이자계산일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + IATA_BIC_GB: varchar({ length: 10 }), // IATA,BIC구분 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + LOGST_VNDR_TP: varchar({ length: 10 }), // 물류VENDOR유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + MEMO: varchar({ length: 120 }), // 메모 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + MIN_ORDR: varchar({ length: 10 }), // 소수지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + MK_CHRGR_EMAIL: varchar({ length: 241 }), // MAKER담당자이메일 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + MOFFC_ACNT_NO: varchar({ length: 10 }), // 본사계정번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + OVLAP_INVC_ORDR: varchar({ length: 10 }), // 중복송장지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PLN_GRP: varchar({ length: 10 }), // 계획그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PST_HOLD_ORDR: varchar({ length: 10 }), // 전기보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + REP_TP: varchar({ length: 10 }), // 대표유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SPLY_COND: varchar({ length: 10 }), // 지급조건 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SPLY_HOLD_ORDR: varchar({ length: 10 }), // 지급보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SPLY_MTHD: varchar({ length: 10 }), // 지급방법 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SPRT_SPLY_ORDR: varchar({ length: 10 }), // 분리지급지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCE_TX_CD: varchar({ length: 10 }), // 원천세코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCE_TX_NTN_CD: varchar({ length: 10 }), // 원천세국가코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRT_KEY: varchar({ length: 10 }), // 정렬키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + TRD_BANK_SHRT_KEY: varchar({ length: 10 }), // 거래은행단축키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDR_ACNT_NO: varchar({ length: 12 }), // VENDOR계정번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDR_CHRGR_NM: varchar({ length: 45 }), // VENDOR담당자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX = mdgSchema.table('VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_COMPNY_BP_WHTAX', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + DCHAG_CAUS: varchar({ length: 200 }), // 면제사유 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DCHAG_CERT_NO: varchar({ length: 15 }), // 면제증명서번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DCHAG_ED_DT: varchar({ length: 10 }), // 면제종료일 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DCHAG_ST_DT: varchar({ length: 10 }), // 면제시작일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + RECIP_TP: varchar({ length: 10 }), // 수취인유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCE_TX_IDENT_NO: varchar({ length: 16 }), // 원천세식별번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCE_TX_NO: varchar({ length: 10 }), // 원천세코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCE_TX_REL_ORDR: varchar({ length: 10 }), // 원천세관련지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SRCE_TX_TP: varchar({ length: 10 }).notNull(), // 원천세유형 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG = mdgSchema.table('VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + AT_PUR_ORD_ORDR: varchar({ length: 10 }), // 자동구매오더지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CALC_SHM_GRP: varchar({ length: 10 }), // 계산스키마그룹 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + CNFM_CTL_KEY: varchar({ length: 10 }), // 확정제어키 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DEL_ORDR: varchar({ length: 10 }), // 삭제지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DL_COND_1: varchar({ length: 10 }), // 인도조건1 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + DL_COND_2: varchar({ length: 28 }), // 인도조건2 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + GR_BSE_INVC_VR: varchar({ length: 10 }), // GR기준송장검증 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ORD_CNFM_REQ_ORDR: varchar({ length: 10 }), // 오더확인요청지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_HOLD_CAUS: varchar({ length: 120 }), // 구매보류사유 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_HOLD_DT: varchar({ length: 10 }), // 구매보류일자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_HOLD_ORDR: varchar({ length: 10 }), // 구매보류지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_ORD_CUR: varchar({ length: 10 }), // 구매오더통화 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PUR_ORG_CD: varchar({ length: 10 }).notNull(), // 구매조직 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + SALE_CHRGR_NM: varchar({ length: 120 }), // 영업담당자명 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + SPLY_COND: varchar({ length: 10 }), // 지급조건 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + VNDR_TELNO: varchar({ length: 30 }), // VENDOR전화번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); + +export const VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN = mdgSchema.table('VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN', { + // [fk] + VNDRCD: varchar({ length: 10 }).notNull().references(() => VENDOR_MASTER_BP_HEADER.VNDRCD), // VENDOR코드 + + id: integer('id').primaryKey().generatedByDefaultAsIdentity(), + BSE_PTNR_ORDR: varchar({ length: 10 }), // 기본파트너지시자 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + ETC_REF_VNDRCD: varchar({ length: 10 }), // 기타참조VENDOR코드 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl + PLNT_NO: varchar({ length: 10 }).notNull(), // 플랜트번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + PTNR_CNT: varchar({ length: 10 }).notNull(), // 파트너카운터 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + PTNR_SKL: varchar({ length: 10 }).notNull(), // 파트너기능 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + VNDR_SUB_NO: varchar({ length: 10 }).notNull(), // VENDOR서브번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 + + createdAt: timestamp('created_at').defaultNow().notNull(), + updatedAt: timestamp('updated_at').defaultNow().notNull(), +}); diff --git a/db/schema/MDG/modelMaster.ts b/db/schema/MDG/modelMaster.ts deleted file mode 100644 index 360989f9..00000000 --- a/db/schema/MDG/modelMaster.ts +++ /dev/null @@ -1,178 +0,0 @@ -import { pgTable, serial, varchar, timestamp } from "drizzle-orm/pg-core"; -import { relations } from "drizzle-orm"; - -/** - * 접근법 1: WSDL과 동일하게 DB 테이블/컬럼명 및 변수 이름 만들기 - * - 모든 테이블/컬럼명이 SAP 시스템의 네이밍을 그대로 유지 - * - 개발자가 SAP 시스템에 익숙하다면 이해하기 쉬움 - * - SAP 문서와 비교하기 쉬움 - */ - -// 자재 마스터 테이블 (MATL) -export const MATL = pgTable("MATL", { - id: serial("id").primaryKey(), - MATNR: varchar("MATNR", { length: 18 }).notNull().unique(), // Material Number (자재 번호) (PK) - MBRSH: varchar("MBRSH", { length: 1 }), // Industry Sector (산업 부문) - MTART: varchar("MTART", { length: 4 }), // Material Type (자재 유형) - LVORM: varchar("LVORM", { length: 1 }), // Deletion flag (삭제 플래그) - MEINS: varchar("MEINS", { length: 3 }), // Base Unit of Measure (기본 단위) - MATKL: varchar("MATKL", { length: 9 }), // Material Group (자재 그룹) - BISMT: varchar("BISMT", { length: 18 }), // Old material number (기존 자재 번호) - SPART: varchar("SPART", { length: 2 }), // Division (부문) - PRDHA: varchar("PRDHA", { length: 18 }), // Product hierachy (제품 계층) - MSTAE: varchar("MSTAE", { length: 2 }), // Material Status (자재 상태) - MSTDE: varchar("MSTDE", { length: 8 }), // Date from which the cross-plant material status is (자재 상태 유효 날짜) - BRGEW: varchar("BRGEW", { length: 13 }), // Gross weight (총 중량) - GEWEI: varchar("GEWEI", { length: 3 }), // Weight Unit (중량 단위) - NTGEW: varchar("NTGEW", { length: 13 }), // Net Weight (순 중량) - VOLUM: varchar("VOLUM", { length: 13 }), // Volume (체적) - VOLEH: varchar("VOLEH", { length: 3 }), // Volume Unit (체적 단위) - GROES: varchar("GROES", { length: 32 }), // Size/dimensions (크기/치수) - LAENG: varchar("LAENG", { length: 13 }), // Length (길이) - BREIT: varchar("BREIT", { length: 13 }), // Width (너비) - HOEHE: varchar("HOEHE", { length: 13 }), // Height (높이) - MEABM: varchar("MEABM", { length: 3 }), // Unit of Dimension for Length/Width/Height (치수 단위) - MAGRV: varchar("MAGRV", { length: 4 }), // Material Group: Packaging Materials (포장 자재 그룹) - VHART: varchar("VHART", { length: 4 }), // Packaging Material Type (포장 자재 유형) - ZZNAME: varchar("ZZNAME", { length: 40 }), // Material Name (자재 이름) - ZZSPEC: varchar("ZZSPEC", { length: 255 }), // Specification (자재 사양) - ZZDESC: varchar("ZZDESC", { length: 255 }), // Description (자재 설명) - ZZMMTYP: varchar("ZZMMTYP", { length: 1 }), // Material Master Type (자재 마스터 유형) - ZZREGDT: varchar("ZZREGDT", { length: 8 }), // Registered Date (등록 날짜) - ZZREGTM: varchar("ZZREGTM", { length: 6 }), // Registered Time (등록 시간) - ZZREGUS: varchar("ZZREGUS", { length: 12 }), // Registerd User (등록 사용자) - ZZAPPDT: varchar("ZZAPPDT", { length: 8 }), // Approval Date (승인 날짜) - ZZAPPTM: varchar("ZZAPPTM", { length: 6 }), // Approval Time (승인 시간) - ZZAPPUS: varchar("ZZAPPUS", { length: 12 }), // Approval User (승인 사용자) - ZZLAMDT: varchar("ZZLAMDT", { length: 8 }), // Last Modified Date (최종 수정 날짜) - ZZLAMTM: varchar("ZZLAMTM", { length: 6 }), // Last Modified Time (최종 수정 시간) - ZZLAMUS: varchar("ZZLAMUS", { length: 12 }), // Last Modified User (최종 수정 사용자) - ZZPRFLG: varchar("ZZPRFLG", { length: 1 }), // CRUD Status (처리 플래그) - ZZDOKAR: varchar("ZZDOKAR", { length: 3 }), // Document Type (문서 유형) - ZZDOKNR: varchar("ZZDOKNR", { length: 25 }), // Document Number (문서 번호) - ZZDOKTL: varchar("ZZDOKTL", { length: 3 }), // Document Part (문서 부분) - ZZDOKVR: varchar("ZZDOKVR", { length: 2 }), // Document Version (문서 버전) - createdAt: timestamp("created_at").defaultNow().notNull(), - updatedAt: timestamp("updated_at").defaultNow().notNull(), -}); - -// 자재 설명 테이블 (DESC) -export const DESC = pgTable("DESC", { - id: serial("id").primaryKey(), - MATNR: varchar("MATNR", { length: 18 }).notNull(), // Material Number (자재 번호) (FK) - SPRAS: varchar("SPRAS", { length: 1 }), // Language (언어) - MAKTX: varchar("MAKTX", { length: 40 }), // Material Description (Short Text) (자재 설명) - createdAt: timestamp("created_at").defaultNow().notNull(), - updatedAt: timestamp("updated_at").defaultNow().notNull(), -}); - -// 플랜트별 자재 데이터 테이블 (PLNT) -export const PLNT = pgTable("PLNT", { - id: serial("id").primaryKey(), - MATNR: varchar("MATNR", { length: 18 }).notNull(), // Material Number (자재 번호) (FK) - WERKS: varchar("WERKS", { length: 4 }), // Plant (플랜트) - LVORM: varchar("LVORM", { length: 1 }), // Deletion Flag (삭제 플래그) - MMSTA: varchar("MMSTA", { length: 2 }), // Plant-Specific Material Status (플랜트별 자재 상태) - MMSTD: varchar("MMSTD", { length: 8 }), // Date from which the plant-specific material status (플랜트별 자재 상태 유효 날짜) - ZZMTARP: varchar("ZZMTARP", { length: 4 }), // Plant Material Type (플랜트 자재 유형) - ZZREGDT: varchar("ZZREGDT", { length: 8 }), // Registered Dated (등록 날짜) - ZZREGTM: varchar("ZZREGTM", { length: 6 }), // Registered Time (등록 시간) - ZZREGUS: varchar("ZZREGUS", { length: 12 }), // Registered USER (등록 사용자) - ZZLAMDT: varchar("ZZLAMDT", { length: 8 }), // Last Modified Date (최종 수정 날짜) - ZZLAMTM: varchar("ZZLAMTM", { length: 6 }), // Last Modified Time (최종 수정 시간) - ZZLAMUS: varchar("ZZLAMUS", { length: 12 }), // Last Modified User (최종 수정 사용자) - ZZPRFLG: varchar("ZZPRFLG", { length: 1 }), // CRUD Status (처리 플래그) - createdAt: timestamp("created_at").defaultNow().notNull(), - updatedAt: timestamp("updated_at").defaultNow().notNull(), -}); - -// 단위 테이블 (UNIT) -export const UNIT = pgTable("UNIT", { - id: serial("id").primaryKey(), - MATNR: varchar("MATNR", { length: 18 }).notNull(), // Material Number (자재 번호) (FK) - MEINH: varchar("MEINH", { length: 3 }), // Alternative Unit of Measure for Stockkeeping Unit (대체 단위) - UMREZ: varchar("UMREZ", { length: 5 }), // Numerator for Conversion to Base Units of Measure (기본 단위 변환 분자) - UMREN: varchar("UMREN", { length: 5 }), // Denominator for conversion to base units of measure (기본 단위 변환 분모) - LAENG: varchar("LAENG", { length: 13 }), // Length (길이) - BREIT: varchar("BREIT", { length: 13 }), // Width (너비) - HOEHE: varchar("HOEHE", { length: 13 }), // Height (높이) - MEABM: varchar("MEABM", { length: 3 }), // Unit of Dimension for Length/Width/Height (치수 단위) - VOLUM: varchar("VOLUM", { length: 13 }), // Volume (체적) - VOLEH: varchar("VOLEH", { length: 3 }), // Volume unit (체적 단위) - BRGEW: varchar("BRGEW", { length: 13 }), // Gross Weight (총 중량) - GEWEI: varchar("GEWEI", { length: 3 }), // Weight Unit (중량 단위) - createdAt: timestamp("created_at").defaultNow().notNull(), - updatedAt: timestamp("updated_at").defaultNow().notNull(), -}); - -// 클래스 할당 테이블 (CLASSASGN) -export const CLASSASGN = pgTable("CLASSASGN", { - id: serial("id").primaryKey(), - MATNR: varchar("MATNR", { length: 18 }).notNull(), // Material Number (자재 번호) (FK) - CLASS: varchar("CLASS", { length: 18 }), // Class number (클래스 번호) - KLART: varchar("KLART", { length: 3 }), // Class Type (클래스 유형) - createdAt: timestamp("created_at").defaultNow().notNull(), - updatedAt: timestamp("updated_at").defaultNow().notNull(), -}); - -// 특성 할당 테이블 (CHARASGN) -export const CHARASGN = pgTable("CHARASGN", { - id: serial("id").primaryKey(), - MATNR: varchar("MATNR", { length: 18 }).notNull(), // Material Number (자재 번호) (FK) - CLASS: varchar("CLASS", { length: 18 }), // Class number (클래스 번호) - KLART: varchar("KLART", { length: 3 }), // Class Type (클래스 유형) - ATNAM: varchar("ATNAM", { length: 30 }), // Characteristic Name (특성 이름) - ATWRT: varchar("ATWRT", { length: 30 }), // Characteristic Value (특성 값) - ATFLV: varchar("ATFLV", { length: 16 }), // Internal floating point from (내부 실수값 시작) - ATAWE: varchar("ATAWE", { length: 3 }), // Unit of Measurement (측정 단위) - ATFLB: varchar("ATFLB", { length: 16 }), // Internal floating point value to (내부 실수값 끝) - ATAW1: varchar("ATAW1", { length: 3 }), // Unit of Measurement (측정 단위) - ATBEZ: varchar("ATBEZ", { length: 30 }), // 특성내역 (특성 설명) - ATWTB: varchar("ATWTB", { length: 30 }), // 특성값내역 (특성 값 설명) - createdAt: timestamp("created_at").defaultNow().notNull(), - updatedAt: timestamp("updated_at").defaultNow().notNull(), -}); - -// 관계 정의 -export const MATLRelations = relations(MATL, ({ many }) => ({ - descriptions: many(DESC), - plants: many(PLNT), - units: many(UNIT), - classAssignments: many(CLASSASGN), - characteristicAssignments: many(CHARASGN), -})); - -export const DESCRelations = relations(DESC, ({ one }) => ({ - material: one(MATL, { - fields: [DESC.MATNR], - references: [MATL.MATNR], - }), -})); - -export const PLNTRelations = relations(PLNT, ({ one }) => ({ - material: one(MATL, { - fields: [PLNT.MATNR], - references: [MATL.MATNR], - }), -})); - -export const UNITRelations = relations(UNIT, ({ one }) => ({ - material: one(MATL, { - fields: [UNIT.MATNR], - references: [MATL.MATNR], - }), -})); - -export const CLASSASGNRelations = relations(CLASSASGN, ({ one }) => ({ - material: one(MATL, { - fields: [CLASSASGN.MATNR], - references: [MATL.MATNR], - }), -})); - -export const CHARASGNRelations = relations(CHARASGN, ({ one }) => ({ - material: one(MATL, { - fields: [CHARASGN.MATNR], - references: [MATL.MATNR], - }), -})); diff --git a/db/schema/SOAP/soap.ts b/db/schema/SOAP/soap.ts new file mode 100644 index 00000000..7a16b50a --- /dev/null +++ b/db/schema/SOAP/soap.ts @@ -0,0 +1,22 @@ +import { serial, varchar, timestamp, text, boolean } from "drizzle-orm/pg-core"; +import { pgSchema } from "drizzle-orm/pg-core"; + +export const soapSchema = pgSchema("soap"); + +export const soapLogs = soapSchema.table("soap_logs", { + id: serial().primaryKey(), + direction: varchar({ length: 20 }).notNull(), + system: varchar({ length: 50 }).notNull(), + interface: varchar({ length: 100 }).notNull(), + startedAt: timestamp().notNull(), + endedAt: timestamp(), + isSuccess: boolean().default(false).notNull(), + requestData: text(), + responseData: text(), + errorMessage: text(), +}); + +export type LogDirection = 'INBOUND' | 'OUTBOUND'; + +export type SoapLogInsert = typeof soapLogs.$inferInsert; +export type SoapLogSelect = typeof soapLogs.$inferSelect;
\ No newline at end of file diff --git a/db/schema/index.ts b/db/schema/index.ts index b9491235..cb5a42d8 100644 --- a/db/schema/index.ts +++ b/db/schema/index.ts @@ -24,4 +24,7 @@ export * from './evaluationCriteria'; export * from './projectGtc'; // MDG SOAP 수신용 -// export * from './MDG/modelMaster' +export * from './MDG/mdg' + +// SOAP 로깅 목적 +export * from './SOAP/soap';
\ No newline at end of file |