path: root/db/schema/ECC/ecc.ts

import {
  integer,
  varchar,
  timestamp,
  decimal,
  pgSchema,
} from 'drizzle-orm/pg-core';

// WSDL 정의에서 CHG_GB, 응답할 메시지 타입(성공/실패) 및 내용은 메타데이터이다.
// 따라서 로깅 테이블에 저장하고, 별도 스키마를 생성하지는 않는다.

// S-ERP에서 받는 ECC 데이터를 MDG와 구분하기 위해 스키마를 새로 생성한다.
export const ECCSchema = pgSchema('ecc');

// *** === START === WSDL FILE: IF_ECC_EVCP_PR_INFORMATION.wsdl === ***
// Table: PR_INFORMATION_T_BID_HEADER
export const PR_INFORMATION_T_BID_HEADER = ECCSchema.table(
  'PR_INFORMATION_T_BID_HEADER',
  {
    id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
    ANFNR: varchar({ length: 10 }).notNull().unique(), // Bidding/RFQ Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
    EKGRP: varchar({ length: 10 }), // Purchaing Group // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    EKORG: varchar({ length: 10 }), // Purchasing Organization // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    WERKS: varchar({ length: 10 }), // Plant // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    ZBSART: varchar({ length: 10 }), // Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
    ZRFQ_TRS_DT: varchar({ length: 10 }), // Date on Creating Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    ZRFQ_TRS_TM: varchar({ length: 10 }), // Time of Creating Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl

    createdAt: timestamp('created_at').defaultNow().notNull(),
    updatedAt: timestamp('updated_at').defaultNow().notNull(),
  }
);

// Table: PR_INFORMATION_T_BID_ITEM
export const PR_INFORMATION_T_BID_ITEM = ECCSchema.table(
  'PR_INFORMATION_T_BID_ITEM',
  {
    id: integer('id').primaryKey().generatedByDefaultAsIdentity(),
    ANFNR: varchar({ length: 10 }).notNull().references(() => PR_INFORMATION_T_BID_HEADER.ANFNR), // Bidding/RFQ Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
    ANFPS: varchar({ length: 10 }), // Item Number of Bidding // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
    AUFNR: varchar({ length: 12 }), // Order Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    BANFN: varchar({ length: 10 }), // Purchase Requisition Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
    BANPO: varchar({ length: 10 }), // Item Number of Purchase Requisition // From: IF_ECC_EVCP_PR_INFORMATION.wsdl // Required
    BPRME: varchar({ length: 10 }), // Order Price Unit (Purchasing) // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    BRGEW: decimal({ precision: 15, scale: 3 }), // Gross Weight // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    DISMM: varchar({ length: 10 }), // MRP Type // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    EBELP: varchar({ length: 10 }), // Series PO Item Seq // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    GEWEI: varchar({ length: 10 }), // Weight Unit // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    KNTTP: varchar({ length: 10 }), // Account Assignment Category // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    KOSTL: varchar({ length: 10 }), // Cost Center // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    LFDAT: varchar({ length: 10 }), // Delivery Date // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    MATKL: varchar({ length: 10 }), // Material Group // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    MATNR: varchar({ length: 18 }), // Material Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    MEINS: varchar({ length: 10 }), // Purchase Requisition Unit of Measure // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    MENGE: decimal({ precision: 15, scale: 3 }), // Purchase Requisition Quantity // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    PEINH: integer(), // Price Unit // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    PERNR: varchar({ length: 20 }), // Employee ID // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    POSID: varchar({ length: 24 }), // WBS No // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    PREIS: decimal({ precision: 15, scale: 2 }), // Price in Purchase Requisition // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    PSPID: varchar({ length: 24 }), // Project No // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    SAKTO: varchar({ length: 10 }), // G/L Account Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    TXZ01: varchar({ length: 40 }), // Short Text // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    WAERS1: varchar({ length: 10 }), // PR Currency Key // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    WAERS2: varchar({ length: 10 }), // Reference Price Currency Key // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    ZCON_NO_PO: varchar({ length: 15 }), // PR Consolidation Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    ZREQ_FN: varchar({ length: 10 }), // P/R Request Number // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    ZREQ_PO: varchar({ length: 10 }), // Item Number of P/R Request // From: IF_ECC_EVCP_PR_INFORMATION.wsdl
    ZRSLT_AMT: decimal({ precision: 17, scale: 2 }), // Reference Price // From: IF_ECC_EVCP_PR_INFORMATION.wsdl

    createdAt: timestamp('created_at').defaultNow().notNull(),
    updatedAt: timestamp('updated_at').defaultNow().notNull(),
  }
);
// *** === END === WSDL FILE: IF_ECC_EVCP_PR_INFORMATION.wsdl === ***




// *** === START === WSDL FILE: IF_ECC_EVCP_PCR.wsdl === ***
// PCR (Purchase Change Request) 테이블
export const ZMM_PCR = ECCSchema.table('ZMM_PCR', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // SEQ,Table,Field,M/O,Type,Size,Description
  // 1,ZMM_PCR,PCR_REQ,M,CHAR,10,PCR 요청번호
  PCR_REQ: varchar({ length: 255 }).notNull().unique(),
  // 2,ZMM_PCR,PCR_REQ_SEQ,M,NUMC,5,PCR 요청순번
  PCR_REQ_SEQ: varchar({ length: 255 }).notNull(),
  // 3,ZMM_PCR,PCR_REQ_DATE,M,DATS,8,PCR 요청일자
  PCR_REQ_DATE: varchar({ length: 255 }),
  // 4,ZMM_PCR,EBELN,M,CHAR,10,구매오더
  EBELN: varchar({ length: 255 }),
  // 5,ZMM_PCR,EBELP,M,NUMC,5,구매오더 품번
  EBELP: varchar({ length: 255 }),
  // 6,ZMM_PCR,PCR_TYPE,M,CHAR,2,"물량/Spec 변경 Type : Q, W, S, QW"
  PCR_TYPE: varchar({ length: 255 }),
  // 7,ZMM_PCR,PSPID,,CHAR,24,프로젝트
  PSPID: varchar({ length: 255 }),
  // 8,ZMM_PCR,BANFN,M,CHAR,10,구매요청
  BANFN: varchar({ length: 255 }),
  // 9,ZMM_PCR,BNFPO,M,NUMC,5,구매요청 품번
  BNFPO: varchar({ length: 255 }),
  // 10,ZMM_PCR,MATNR,,CHAR,18,자재번호
  MATNR: varchar({ length: 255 }),
  // 11,ZMM_PCR,MAKTX,,CHAR,40,자재명
  MAKTX: varchar({ length: 255 }),
  // 12,ZMM_PCR,ZZSPEC,,CHAR,255,Specification
  ZZSPEC: varchar({ length: 255 }),
  // 13,ZMM_PCR,ZSPEC_NUM,,CHAR,25,POS
  ZSPEC_NUM: varchar({ length: 255 }),
  // 14,ZMM_PCR,QTY_B,,QUAN,"13,3",변경 전 수량
  QTY_B: varchar({ length: 255 }),
  // 15,ZMM_PCR,QTY_A,,QUAN,"13,3",변경 후 수량
  QTY_A: varchar({ length: 255 }),
  // 16,ZMM_PCR,MEINS,,UNIT,3,단위
  MEINS: varchar({ length: 255 }),
  // 17,ZMM_PCR,T_WEIGHT_B,,QUAN,"13,3",변경 전 Total 중량
  T_WEIGHT_B: varchar({ length: 255 }),
  // 18,ZMM_PCR,T_WEIGHT_A,,QUAN,"13,3",변경 후 Total 중량
  T_WEIGHT_A: varchar({ length: 255 }),
  // 19,ZMM_PCR,MEINS_W,,UNIT,3,중량 단위
  MEINS_W: varchar({ length: 255 }),
  // 20,ZMM_PCR,S_WEIGHT_B,,QUAN,"13,3",변경 전 사급 중량
  S_WEIGHT_B: varchar({ length: 255 }),
  // 21,ZMM_PCR,S_WEIGHT_A,,QUAN,"13,3",변경 후 사급 중량
  S_WEIGHT_A: varchar({ length: 255 }),
  // 22,ZMM_PCR,C_WEIGHT_B,,QUAN,"13,3",변경 전 도급 중량
  C_WEIGHT_B: varchar({ length: 255 }),
  // 23,ZMM_PCR,C_WEIGHT_A,,QUAN,"13,3",변경 후 도급 중량
  C_WEIGHT_A: varchar({ length: 255 }),
  // 24,ZMM_PCR,ZACC_DT,,DATS,8,구매담당자 PR 접수일
  ZACC_DT: varchar({ length: 255 }),
  // 25,ZMM_PCR,ERDAT,,DATS,8,물량 변경일
  ERDAT: varchar({ length: 255 }),
  // 26,ZMM_PCR,DEPTCD,,CHAR,10,설계부서
  DEPTCD: varchar({ length: 255 }),
  // 27,ZMM_PCR,DEPTNM,,CHAR,60,설계부서명
  DEPTNM: varchar({ length: 255 }),
  // 28,ZMM_PCR,EMPID,,CHAR,20,설계담당자ID
  EMPID: varchar({ length: 255 }),
  // 29,ZMM_PCR,NAME,,CHAR,70,설계담당명
  NAME: varchar({ length: 255 }),
  // 30,ZMM_PCR,LIFNR,M,CHAR,10,공급업체
  LIFNR: varchar({ length: 255 }),
  // 31,ZMM_PCR,NAME1,,CHAR,35,공급업체명
  NAME1: varchar({ length: 255 }),
  // 32,ZMM_PCR,ZPROC_IND,,CHAR,1,PR 상태
  ZPROC_IND: varchar({ length: 255 }),
  // 33,ZMM_PCR,LFDAT,,DATS,8,PR 납품일
  LFDAT: varchar({ length: 255 }),
  // 34,ZMM_PCR,WAERS,M,CUKY,5,PO 통화
  WAERS: varchar({ length: 255 }),
  // 35,ZMM_PCR,NETPR,M,CURR,"13,2",PO 단가
  NETPR: varchar({ length: 255 }),
  // 36,ZMM_PCR,PEINH,,DEC,5,"Price Unit, 수량에 대한 PER 당 단가"
  PEINH: varchar({ length: 255 }),
  // 37,ZMM_PCR,NETWR,M,CURR,"13,2",PO 금액
  NETWR: varchar({ length: 255 }),
  // 38,ZMM_PCR,POSID,,CHAR,24,WBS
  POSID: varchar({ length: 255 }),
  // 39,ZMM_PCR,EKGRP,,CHAR,3,구매그룹
  EKGRP: varchar({ length: 255 }),
  // 40,ZMM_PCR,EKNAM,,CHAR,18,구매그룹명
  EKNAM: varchar({ length: 255 }),
  // 41,ZMM_PCR,ZCHG_NO,,CHAR,10,(ECC 내부목적) PR 수정번호
  ZCHG_NO: varchar({ length: 255 }),
  // 42,ZMM_PCR,DOKNR,,CHAR,25,(ECC 내부목적) 도면번호
  DOKNR: varchar({ length: 255 }),
  // 43,ZMM_PCR,DOKAR,,CHAR,3,(ECC 내부목적) 도면문서Type
  DOKAR: varchar({ length: 255 }),
  // 44,ZMM_PCR,DOKTL,,CHAR,3,(ECC 내부목적) 도면문서Part
  DOKTL: varchar({ length: 255 }),
  // 45,ZMM_PCR,DOKVR,,CHAR,2,(ECC 내부목적) 도면문서버젼
  DOKVR: varchar({ length: 255 }),
  // 46,ZMM_PCR,ZAEDAT,,DATS,8,(ECC 내부목적) 도면변경일
  ZAEDAT: varchar({ length: 255 }),
  // 47,ZMM_PCR,WERKS,,CHAR,4,PLANT
  WERKS: varchar({ length: 255 }),
  // 48,ZMM_PCR,REQUEST_CD,,CHAR,10,Request 코드
  REQUEST_CD: varchar({ length: 255 }),
  // 49,ZMM_PCR,REQUEST_RSN,,CHAR,50,Request 사유
  REQUEST_RSN: varchar({ length: 255 }),

  // 수신 처리 완료하고, 응답해줄 형식은 다음과 같다.
  // 하나의 요청이 여러 데이터셋을 가지고 있는데, 응답은 하나의 요청에 대해 한번만 하며, 에 저장하지 않음
  // 50,ZMM_RT (수신측 응답),PCR_REQ,M,CHAR,10,PCR 요청번호
  // 51,ZMM_RT (수신측 응답),PCR_REQ_SEQ,M,NUMC,5,PCR 요청순번
  // 52,ZMM_RT (수신측 응답),EBELN,M,CHAR,10,구매오더
  // 53,ZMM_RT (수신측 응답),EBELP,M,NUMC,5,구매오더 품번
  // 54,ZMM_RT (수신측 응답),MSGTY,,CHAR,1,Message Type
  // 55,ZMM_RT (수신측 응답),MSGTXT,,CHAR,100,Message Text


  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});
// *** === END === WSDL FILE: IF_ECC_EVCP_PCR.wsdl === ***




// *** === START === WSDL FILE: IF_ECC_EVCP_PO_INFORMATION.wsdl === ***
export const ZMM_HD = ECCSchema.table('ZMM_HD', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // SEQ,Table,Field,M/O,Type,Size,Description
  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
  EBELN: varchar({ length: 255 }).notNull().unique(),
  // 2,ZMM_HD,BUKRS,M,CHAR,4,회사코드
  BUKRS: varchar({ length: 255 }),
  // 3,ZMM_HD,BSTYP,M,CHAR,1,구매문서범주
  BSTYP: varchar({ length: 255 }),
  // 4,ZMM_HD,BSART,M,CHAR,4,구매문서유형
  BSART: varchar({ length: 255 }),
  // 5,ZMM_HD,LOEKZ,M,CHAR,1,구매문서삭제지시자
  LOEKZ: varchar({ length: 255 }),
  // 6,ZMM_HD,AEDAT,M,DATS,8,생성일자
  AEDAT: varchar({ length: 255 }),
  // 7,ZMM_HD,ERNAM,M,CHAR,13,생성자ID
  ERNAM: varchar({ length: 255 }),
  // 8,ZMM_HD,LIFNR,M,CHAR,10,VENDOR코드
  LIFNR: varchar({ length: 255 }),
  // 9,ZMM_HD,ZTERM,M,CHAR,4,지급조건코드
  ZTERM: varchar({ length: 255 }),
  // 10,ZMM_HD,EKORG,M,CHAR,4,구매조직코드
  EKORG: varchar({ length: 255 }),
  // 11,ZMM_HD,EKGRP,M,CHAR,3,구매그룹코드
  EKGRP: varchar({ length: 255 }),
  // 12,ZMM_HD,WKURS,M,DEC,"9,5",환율
  WKURS: varchar({ length: 255 }),
  // 13,ZMM_HD,BEDAT,M,DATS,8,구매증빙일자
  BEDAT: varchar({ length: 255 }),
  // 14,ZMM_HD,INCO1,M,CHAR,3,인도조건코드
  INCO1: varchar({ length: 255 }),
  // 15,ZMM_HD,ZSHIPMT_PLC_CD,M,CHAR,5,선적지코드
  ZSHIPMT_PLC_CD: varchar({ length: 255 }),
  // 16,ZMM_HD,ZUNLD_PLC_CD,M,CHAR,5,하역지코드
  ZUNLD_PLC_CD: varchar({ length: 255 }),
  // 17,ZMM_HD,ZIND_CD,M,CHAR,2,증감코드
  ZIND_CD: varchar({ length: 255 }),
  // 18,ZMM_HD,ZDAMT_DD_SUBRT,M,DEC,"6,2",지체상금일일공제율
  ZDAMT_DD_SUBRT: varchar({ length: 255 }),
  // 19,ZMM_HD,ZMAX_SUBRT,M,DEC,"6,2",최대공제율
  ZMAX_SUBRT: varchar({ length: 255 }),
  // 20,ZMM_HD,ZCNRT_GRNT_CD,M,CHAR,1,계약보증코드
  ZCNRT_GRNT_CD: varchar({ length: 255 }),
  // 21,ZMM_HD,ZDFCT_GRNT_CD,M,CHAR,1,하자보증코드
  ZDFCT_GRNT_CD: varchar({ length: 255 }),
  // 22,ZMM_HD,ZGRNT_PRD_CD,M,CHAR,1,보증기간코드
  ZGRNT_PRD_CD: varchar({ length: 255 }),
  // 23,ZMM_HD,ZPAMT_YN,M,CHAR,1,선급금여부
  ZPAMT_YN: varchar({ length: 255 }),
  // 24,ZMM_HD,ZBGT_AMT,M,CURR,"17,2","예산금액, ZBTG_CURR"
  ZBGT_AMT: varchar({ length: 255 }),
  // 25,ZMM_HD,ZBGT_CURR,M,CUKY,3,예산금액 통화키
  ZBGT_CURR: varchar({ length: 255 }),
  // 26,ZMM_HD,ZPO_AMT,M,CURR,"17,2",발주금액
  ZPO_AMT: varchar({ length: 255 }),
  // 27,ZMM_HD,ZPO_AMT_KRW,M,CURR,"17,2",발주금액 KRW
  ZPO_AMT_KRW: varchar({ length: 255 }),
  // 28,ZMM_HD,ZPO_CURR,M,CUKY,5,통화키
  ZPO_CURR: varchar({ length: 255 }),
  // 29,ZMM_HD,ZCHG_PO_DT,M,DATS,8,변경발주일자
  ZCHG_PO_DT: varchar({ length: 255 }),
  // 30,ZMM_HD,ZPO_CNFM_STAT,M,CHAR,1,구매오더확인상태
  ZPO_CNFM_STAT: varchar({ length: 255 }),
  // 31,ZMM_HD,ZOWN_AGR_IND_YN,M,CHAR,1,선주승인필요여부
  ZOWN_AGR_IND_YN: varchar({ length: 255 }),
  // 32,ZMM_HD,ZELC_AGR_DT,M,DATS,8,전자승인일자
  ZELC_AGR_DT: varchar({ length: 255 }),
  // 33,ZMM_HD,ZELC_AGR_TM,M,TIMS,6,전자승인시간
  ZELC_AGR_TM: varchar({ length: 255 }),
  // 34,ZMM_HD,ZELC_CNRT_ND_YN,M,CHAR,1,전자계약필요여부
  ZELC_CNRT_ND_YN: varchar({ length: 255 }),
  // 35,ZMM_HD,ZPO_DT,M,DATS,8,발주일자
  ZPO_DT: varchar({ length: 255 }),
  // 36,ZMM_HD,ZPLN_INO_GB,M,CHAR,1,계획내외구분
  ZPLN_INO_GB: varchar({ length: 255 }),
  // 37,ZMM_HD,ZECAL_BSE,M,CHAR,1,정산기준
  ZECAL_BSE: varchar({ length: 255 }),
  // 38,ZMM_HD,ZWGT_ECAL_GB,M,CHAR,1,중량정산구분
  ZWGT_ECAL_GB: varchar({ length: 255 }),
  // 39,ZMM_HD,ZPO_TRANS_DT,M,DATS,8,발주전송일자
  ZPO_TRANS_DT: varchar({ length: 255 }),
  // 40,ZMM_HD,ZPO_TRANS_CANC,M,DATS,1,전송여부지시자
  ZPO_TRANS_CANC: varchar({ length: 255 }),
  // 41,ZMM_HD,ZVST_TMS,M,NUMC,9,방문횟수
  ZVST_TMS: varchar({ length: 255 }),
  // 42,ZMM_HD,ZSVC_WK_PRD,M,NUMC,9,SE작업일수
  ZSVC_WK_PRD: varchar({ length: 255 }),
  // 43,ZMM_HD,ZDT_EXCS_AMT,M,CURR,"17,2",일초과금액1
  ZDT_EXCS_AMT: varchar({ length: 255 }),
  // 44,ZMM_HD,ZDT_EXCS_AMT2,M,CURR,"17,2",일초과금액2
  ZDT_EXCS_AMT2: varchar({ length: 255 }),
  // 45,ZMM_HD,ZDT_EXCS_AMT3,M,CURR,"17,2",일초과금액3
  ZDT_EXCS_AMT3: varchar({ length: 255 }),
  // 46,ZMM_HD,ZSVC_CNRT_CUR,M,CUKY,5,SE계약통화
  ZSVC_CNRT_CUR: varchar({ length: 255 }),
  // 47,ZMM_HD,ZPAY_GB,M,CHAR,1,기타비용처리구분
  ZPAY_GB: varchar({ length: 255 }),
  // 48,ZMM_HD,ZFULL_COMM,M,CHAR,1,수수료전체부담여부
  ZFULL_COMM: varchar({ length: 255 }),
  // 49,ZMM_HD,PSPID,M,CHAR,24,프로젝트 번호
  PSPID: varchar({ length: 255 }),
  // 50,ZMM_HD,ZCON_NO,M,CHAR,10,구매통합번호
  ZCON_NO: varchar({ length: 255 }),
  // 51,ZMM_HD,ZTITLE,M,CHAR,90,발주제목
  ZTITLE: varchar({ length: 255 }),
  // 52,ZMM_HD,ZPO_VER,M,NUMC,2,발주버전
  ZPO_VER: varchar({ length: 255 }),
  // 53,ZMM_HD,ITEM_CATEGORY,M,CHAR,2,선물환 Item Category
  ITEM_CATEGORY: varchar({ length: 255 }),
  // 54,ZMM_HD,LTEXT,M,CHAR,60,선물환 Item Category 명
  LTEXT: varchar({ length: 255 }),
  // 55,ZMM_HD,ITEM_NO,M,CHAR,3,PO의 ITEM 수 (인터페이스검증)
  ITEM_NO: varchar({ length: 255 }),
  // 56,ZMM_HD,USECD,M,CHAR,20,사용코드
  USECD: varchar({ length: 255 }),
  // 57,ZMM_HD,ETC_2,M,CHAR,100,확장2
  ETC_2: varchar({ length: 255 }),
  // 58,ZMM_HD,ETC_3,M,CHAR,100,확장3
  ETC_3: varchar({ length: 255 }),
  // 59,ZMM_HD,ETC_4,M,CHAR,100,확장4
  ETC_4: varchar({ length: 255 }),
  // 60,ZMM_HD,ETC_5,M,CHAR,100,확장5
  ETC_5: varchar({ length: 255 }),
  // 61,ZMM_HD,ETC_6,M,CHAR,100,확장6
  ETC_6: varchar({ length: 255 }),
  // 62,ZMM_HD,ETC_7,M,CHAR,100,확장7
  ETC_7: varchar({ length: 255 }),
  // 63,ZMM_HD,ETC_8,M,CHAR,100,확장8
  ETC_8: varchar({ length: 255 }),
  // 64,ZMM_HD,ETC_9,M,CHAR,100,확장9
  ETC_9: varchar({ length: 255 }),
  // 65,ZMM_HD,ETC_10,M,CHAR,100,확장10
  ETC_10: varchar({ length: 255 }),
  // 66,ZMM_HD,ZDLV_PRICE_T,,CHAR,1,"납품대금연동제대상여부 (Y:대상, N:미대상, 공백:미해당)"
  ZDLV_PRICE_T: varchar({ length: 255 }),
  // 67,ZMM_HD,ZWEBELN,,CHAR,10,서면계약번호
  ZWEBELN: varchar({ length: 255 }),
  // 68,ZMM_HD,ZVER_NO,,NUMC,3,서면계약차수
  ZVER_NO: varchar({ length: 255 }),

  // 응답은 전체 요청에 대해 하나의 메시지만 전송하며, 데이터베이스에 저장하지 않음
  // 191,ZMM_RT,EBELN,M,CHAR,10,구매오더번호
  // 192,ZMM_RT,RT_CODE,M,CHAR,1,IF상태
  // 193,ZMM_RT,RT_TEXT,M,CHAR,100,IF메세지

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
})

export const ZMM_PAY = ECCSchema.table('ZMM_PAY', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // FK
  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),

  // 69,ZMM_HD/ZMM_PAY,ZPAYSEQ,M,CHAR,2,선급금차수
  ZPAYSEQ: varchar({ length: 255 }),
  // 70,ZMM_HD/ZMM_PAY,ZADVTYP,M,CHAR,1,선급금타입
  ZADVTYP: varchar({ length: 255 }),
  // 71,ZMM_HD/ZMM_PAY,ZDWPRT,M,NUMC,3,선급금비율
  ZDWPRT: varchar({ length: 255 }),
  // 72,ZMM_HD/ZMM_PAY,ZDWPAMT,M,CURR,"17,2",선급금
  ZDWPAMT: varchar({ length: 255 }),
  // 73,ZMM_HD/ZMM_PAY,ZDWPDAT,M,DATS,8,지불계획일자
  ZDWPDAT: varchar({ length: 255 }),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const ZMM_DT = ECCSchema.table('ZMM_DT', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // FK
  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),

  // 74,ZMM_HD/ZMM_DT,EBELP,M,NUMC,5,구매오더품목번호
  EBELP: varchar({ length: 255 }),
  // 75,ZMM_HD/ZMM_DT,LOEKZ,M,CHAR,1,구매문서삭제지시자
  LOEKZ: varchar({ length: 255 }),
  // 76,ZMM_HD/ZMM_DT,AEDAT,M,DATS,8,변경일자
  AEDAT: varchar({ length: 255 }),
  // 77,ZMM_HD/ZMM_DT,MAKTX,M,CHAR,120,자재내역
  MAKTX: varchar({ length: 255 }),
  // 78,ZMM_HD/ZMM_DT,MATKL,M,CHAR,9,자재그룹
  MATKL: varchar({ length: 255 }),
  // 79,ZMM_HD/ZMM_DT,MATNR,M,CHAR,18,자재코드
  MATNR: varchar({ length: 255 }),
  // 80,ZMM_HD/ZMM_DT,WERKS,M,CHAR,4,플랜트코드
  WERKS: varchar({ length: 255 }),
  // 81,ZMM_HD/ZMM_DT,LGORT,M,CHAR,10,저장위치
  LGORT: varchar({ length: 255 }),
  // 82,ZMM_HD/ZMM_DT,BEDNR,M,CHAR,10,요청추적번호
  BEDNR: varchar({ length: 255 }),
  // 83,ZMM_HD/ZMM_DT,MENGE,M,QUAN,"13,3",구매오더수량
  MENGE: varchar({ length: 255 }),
  // 84,ZMM_HD/ZMM_DT,NETPR,M,CURR,"17,2",구매단가
  NETPR: varchar({ length: 255 }),
  // 85,ZMM_HD/ZMM_DT,PEINH,M,DEC,5,가격단위값
  PEINH: varchar({ length: 255 }),
  // 86,ZMM_HD/ZMM_DT,NETWR,M,CURR,"17,2",오더정가
  NETWR: varchar({ length: 255 }),
  // 87,ZMM_HD/ZMM_DT,BRTWR,M,CURR,"17,2",오더총액
  BRTWR: varchar({ length: 255 }),
  // 88,ZMM_HD/ZMM_DT,WEBAZ,M,DEC,3,입고소요일수
  WEBAZ: varchar({ length: 255 }),
  // 89,ZMM_HD/ZMM_DT,MWSKZ,M,CHAR,2,매출부가가치세코드
  MWSKZ: varchar({ length: 255 }),
  // 90,ZMM_HD/ZMM_DT,INSMK,M,CHAR,1,재고유형
  INSMK: varchar({ length: 255 }),
  // 91,ZMM_HD/ZMM_DT,BWTAR,M,CHAR,10,평가유형
  BWTAR: varchar({ length: 255 }),
  // 92,ZMM_HD/ZMM_DT,BWTTY,M,CHAR,1,평가범주
  BWTTY: varchar({ length: 255 }),
  // 93,ZMM_HD/ZMM_DT,ELIKZ,M,CHAR,1,납품완료지시자
  ELIKZ: varchar({ length: 255 }),
  // 94,ZMM_HD/ZMM_DT,EREKZ,M,CHAR,1,최종송장지시자
  EREKZ: varchar({ length: 255 }),
  // 95,ZMM_HD/ZMM_DT,TWRKZ,M,CHAR,1,분할송장지시자
  TWRKZ: varchar({ length: 255 }),
  // 96,ZMM_HD/ZMM_DT,REPOS,M,CHAR,1,송장수령지시자
  REPOS: varchar({ length: 255 }),
  // 97,ZMM_HD/ZMM_DT,WEBRE,M,CHAR,1,GR송장검증지시자
  WEBRE: varchar({ length: 255 }),
  // 98,ZMM_HD/ZMM_DT,KNTTP,M,CHAR,1,계정지정범주
  KNTTP: varchar({ length: 255 }),
  // 99,ZMM_HD/ZMM_DT,NTGEW,M,QUAN,"13,3",순중량
  NTGEW: varchar({ length: 255 }),
  // 100,ZMM_HD/ZMM_DT,GEWEI,M,UNIT,3,중량단위
  GEWEI: varchar({ length: 255 }),
  // 101,ZMM_HD/ZMM_DT,BRGEW,M,QUAN,"15,3",총중량
  BRGEW: varchar({ length: 255 }),
  // 102,ZMM_HD/ZMM_DT,VOLUM,M,QUAN,"15,3",볼륨
  VOLUM: varchar({ length: 255 }),
  // 103,ZMM_HD/ZMM_DT,VOLEH,M,UNIT,3,볼륨단위
  VOLEH: varchar({ length: 255 }),
  // 104,ZMM_HD/ZMM_DT,BANFN,M,CHAR,10,구매요청번호
  BANFN: varchar({ length: 255 }),
  // 105,ZMM_HD/ZMM_DT,BNFPO,M,NUMC,5,구매요청품목번호
  BNFPO: varchar({ length: 255 }),
  // 106,ZMM_HD/ZMM_DT,UPTYP,M,CHAR,1,하위품목범주
  UPTYP: varchar({ length: 255 }),
  // 107,ZMM_HD/ZMM_DT,UPVOR,M,CHAR,1,하위품목존재여부
  UPVOR: varchar({ length: 255 }),
  // 108,ZMM_HD/ZMM_DT,ZPO_DLV_DT,M,DATS,8,PO납기일자
  ZPO_DLV_DT: varchar({ length: 255 }),
  // 109,ZMM_HD/ZMM_DT,ZSHIP_DT,M,DATS,8,생산소요선적일자
  ZSHIP_DT: varchar({ length: 255 }),
  // 110,ZMM_HD/ZMM_DT,ZDST_CD,M,CHAR,4,강재도착지코드
  ZDST_CD: varchar({ length: 255 }),
  // 111,ZMM_HD/ZMM_DT,ZRCV_DT,M,DATS,8,구매접수일자
  ZRCV_DT: varchar({ length: 255 }),
  // 112,ZMM_HD/ZMM_DT,ZCON_NO,M,CHAR,10,구매통합번호
  ZCON_NO: varchar({ length: 255 }),
  // 113,ZMM_HD/ZMM_DT,ZCON_IND,M,CHAR,1,시리즈구분
  ZCON_IND: varchar({ length: 255 }),
  // 114,ZMM_HD/ZMM_DT,ZCHAR_CD,M,CHAR,1,"물성코드,풍력 일련번호 처리여부"
  ZCHAR_CD: varchar({ length: 255 }),
  // 115,ZMM_HD/ZMM_DT,ZMAT_AREA,M,QUAN,"13,3",자재면적
  ZMAT_AREA: varchar({ length: 255 }),
  // 116,ZMM_HD/ZMM_DT,ZSZ,M,CHAR,50,품목사이즈
  ZSZ: varchar({ length: 255 }),
  // 117,ZMM_HD/ZMM_DT,ZAF_ECAL_AMT,M,CURR,"17,2","사후정산금액(참고: NETWR), ZPO_CURR"
  ZAF_ECAL_AMT: varchar({ length: 255 }),
  // 118,ZMM_HD/ZMM_DT,ZPLN_ST_DT,M,DATS,8,예정시작일자
  ZPLN_ST_DT: varchar({ length: 255 }),
  // 119,ZMM_HD/ZMM_DT,ZPLN_ED_DT,M,DATS,8,예정종료일자
  ZPLN_ED_DT: varchar({ length: 255 }),
  // 120,ZMM_HD/ZMM_DT,PSPID,M,CHAR,24,프로젝트번호
  PSPID: varchar({ length: 255 }),
  // 121,ZMM_HD/ZMM_DT,ZUSD_BGT,M,CURR,"17,2",미화예산
  ZUSD_BGT: varchar({ length: 255 }),
  // 122,ZMM_HD/ZMM_DT,ZKRW_BGT,M,CURR,"17,2",원화예산
  ZKRW_BGT: varchar({ length: 255 }),
  // 123,ZMM_HD/ZMM_DT,ZDLV_CNTLR,M,CHAR,3,조달담당자코드
  ZDLV_CNTLR: varchar({ length: 255 }),
  // 124,ZMM_HD/ZMM_DT,ANFNR,M,CHAR,10,RFQ번호
  ANFNR: varchar({ length: 255 }),
  // 125,ZMM_HD/ZMM_DT,ANFPS,M,NUMC,5,RFQ품목번호
  ANFPS: varchar({ length: 255 }),
  // 126,ZMM_HD/ZMM_DT,KONNR,M,CHAR,10,계약번호
  KONNR: varchar({ length: 255 }),
  // 127,ZMM_HD/ZMM_DT,KTPNR,M,NUMC,5,계약항목번호
  KTPNR: varchar({ length: 255 }),
  // 128,ZMM_HD/ZMM_DT,ZCR_NO,M,CHAR,40,CR번호
  ZCR_NO: varchar({ length: 255 }),
  // 129,ZMM_HD/ZMM_DT,ZCR_AMT,M,CURR,"17,2",EXTRA CREDIT 금액
  ZCR_AMT: varchar({ length: 255 }),
  // 130,ZMM_HD/ZMM_DT,ZRT_CUR,M,CUKY,3,실적통화
  ZRT_CUR: varchar({ length: 255 }),
  // 131,ZMM_HD/ZMM_DT,ZRT_AMT,M,CURR,"17,2","실적금액, ZRT_CURR"
  ZRT_AMT: varchar({ length: 255 }),
  // 132,ZMM_HD/ZMM_DT,ZPO_UNIT,M,UNIT,3,구매오더수량단위
  ZPO_UNIT: varchar({ length: 255 }),
  // 133,ZMM_HD/ZMM_DT,ZREF_NETPR,M,CURR,"17,2","참조단가, ZPO_CURR"
  ZREF_NETPR: varchar({ length: 255 }),
  // 134,ZMM_HD/ZMM_DT,ZNETPR,M,CURR,"17,2","발주단가, ZPO_CURR"
  ZNETPR: varchar({ length: 255 }),
  // 135,ZMM_HD/ZMM_DT,BPRME,M,UNIT,3,구매단가단위
  BPRME: varchar({ length: 255 }),
  // 136,ZMM_HD/ZMM_DT,ZDISPLN,M,CHAR,1,설계기능
  ZDISPLN: varchar({ length: 255 }),
  // 137,ZMM_HD/ZMM_DT,ZORCT_CNRT_KRW,M,CURR,"17,2",외주비계약KRW
  ZORCT_CNRT_KRW: varchar({ length: 255 }),
  // 138,ZMM_HD/ZMM_DT,ZORCT_CNRT_USD,M,CURR,"17,2",외주비계약USD
  ZORCT_CNRT_USD: varchar({ length: 255 }),
  // 139,ZMM_HD/ZMM_DT,ZETC_CNRT_KRW,M,CURR,"17,2",기타계약KRW
  ZETC_CNRT_KRW: varchar({ length: 255 }),
  // 140,ZMM_HD/ZMM_DT,ZETC_CNRT_USD,M,CURR,"17,2",기타계약USD
  ZETC_CNRT_USD: varchar({ length: 255 }),
  // 141,ZMM_HD/ZMM_DT,ZEXTRA_AMT,M,CURR,"17,2","EXTRA금액, ZPO_CURR"
  ZEXTRA_AMT: varchar({ length: 255 }),
  // 142,ZMM_HD/ZMM_DT,ZCRDT_AMT,M,CURR,"17,2","CREDIT금액, ZPO_CURR"
  ZCRDT_AMT: varchar({ length: 255 }),
  // 143,ZMM_HD/ZMM_DT,ZART,M,CHAR,2,검사코드
  ZART: varchar({ length: 255 }),
  // 144,ZMM_HD/ZMM_DT,ART,M,CHAR,8,검사유형(QMAT)
  ART: varchar({ length: 255 }),
  // 145,ZMM_HD/ZMM_DT,ZPDT_BSE_UPR,M,CURR,"17,2","BASE금액, ZPO_CURR"
  ZPDT_BSE_UPR: varchar({ length: 255 }),
  // 146,ZMM_HD/ZMM_DT,ZPDT_EXTRA_UPR,M,CURR,"17,2","EXTRA금액, ZPO_CURR"
  ZPDT_EXTRA_UPR: varchar({ length: 255 }),
  // 147,ZMM_HD/ZMM_DT,ZPDT_EXDS_AMT,M,CURR,"17,2","할인/할증금액, ZPO_CURR"
  ZPDT_EXDS_AMT: varchar({ length: 255 }),
  // 148,ZMM_HD/ZMM_DT,ZTRNS_UPR,M,CURR,"17,2","운송단가, ZPO_CURR"
  ZTRNS_UPR: varchar({ length: 255 }),
  // 149,ZMM_HD/ZMM_DT,ZFST_DST_CD,M,CHAR,4,발주초기착지코드
  ZFST_DST_CD: varchar({ length: 255 }),
  // 150,ZMM_HD/ZMM_DT,ZCHG_CHK,M,CHAR,1,물량수정승인여부
  ZCHG_CHK: varchar({ length: 255 }),
  // 151,ZMM_HD/ZMM_DT,ZITP_CHK,M,CHAR,1,ITP체크
  ZITP_CHK: varchar({ length: 255 }),
  // 152,ZMM_HD/ZMM_DT,ZPO_RMK,M,CHAR,90,발주비고
  ZPO_RMK: varchar({ length: 255 }),
  // 153,ZMM_HD/ZMM_DT,ZPO_LOT_NO,M,CHAR,50,Steel Material Marking No
  ZPO_LOT_NO: varchar({ length: 255 }),
  // 154,ZMM_HD/ZMM_DT,ZCLM_NO,M,CHAR,10,SR번호
  ZCLM_NO: varchar({ length: 255 }),
  // 155,ZMM_HD/ZMM_DT,ZWH_CNTLR,M,CHAR,3,현물담당자코드
  ZWH_CNTLR: varchar({ length: 255 }),
  // 156,ZMM_HD/ZMM_DT,LFDAT,M,DATS,8,PR Delivery Date
  LFDAT: varchar({ length: 255 }),
  // 157,ZMM_HD/ZMM_DT,ETC_2,M,CHAR,100,확장2
  ETC_2: varchar({ length: 255 }),
  // 158,ZMM_HD/ZMM_DT,ETC_3,M,CHAR,100,확장3
  ETC_3: varchar({ length: 255 }),
  // 159,ZMM_HD/ZMM_DT,ETC_4,M,CHAR,100,확장4
  ETC_4: varchar({ length: 255 }),
  // 160,ZMM_HD/ZMM_DT,ETC_5,M,CHAR,100,확장5
  ETC_5: varchar({ length: 255 }),
  // 161,ZMM_HD/ZMM_DT,ETC_6,M,CHAR,100,확장6
  ETC_6: varchar({ length: 255 }),
  // 162,ZMM_HD/ZMM_DT,ETC_7,M,CHAR,100,확장7
  ETC_7: varchar({ length: 255 }),
  // 163,ZMM_HD/ZMM_DT,ETC_8,M,CHAR,100,확장8
  ETC_8: varchar({ length: 255 }),
  // 164,ZMM_HD/ZMM_DT,ETC_9,M,CHAR,100,확장9
  ETC_9: varchar({ length: 255 }),
  // 165,ZMM_HD/ZMM_DT,ETC_10,M,CHAR,100,확장10
  ETC_10: varchar({ length: 255 }),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const ZMM_KN = ECCSchema.table('ZMM_KN', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // FK
  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),
  // ZMM_DT의 서브테이블이므로 EBELP도 필요
  EBELP: varchar({ length: 255 }).notNull(),

  // 166,ZMM_HD/ZMM_DT/ZMM_KN,ZEKKN,M,NUMC,2,계정지정순번
  ZEKKN: varchar({ length: 255 }),
  // 167,ZMM_HD/ZMM_DT/ZMM_KN,SAKTO,M,CHAR,10,G/L계정번호
  SAKTO: varchar({ length: 255 }),
  // 168,ZMM_HD/ZMM_DT/ZMM_KN,GSBER,M,CHAR,4,사업영역코드
  GSBER: varchar({ length: 255 }),
  // 169,ZMM_HD/ZMM_DT/ZMM_KN,KOSTL,M,CHAR,10,코스트센터
  KOSTL: varchar({ length: 255 }),
  // 170,ZMM_HD/ZMM_DT/ZMM_KN,VBELN,M,CHAR,10,판매오더번호
  VBELN: varchar({ length: 255 }),
  // 171,ZMM_HD/ZMM_DT/ZMM_KN,VBELP,M,NUMC,6,판매오더품목번호
  VBELP: varchar({ length: 255 }),
  // 172,ZMM_HD/ZMM_DT/ZMM_KN,ANLN1,M,CHAR,12,주요자산번호
  ANLN1: varchar({ length: 255 }),
  // 173,ZMM_HD/ZMM_DT/ZMM_KN,ANLN2,M,CHAR,4,자산하위번호
  ANLN2: varchar({ length: 255 }),
  // 174,ZMM_HD/ZMM_DT/ZMM_KN,AUFNR,M,CHAR,12,생산오더번호
  AUFNR: varchar({ length: 255 }),
  // 175,ZMM_HD/ZMM_DT/ZMM_KN,WEMPF,M,CHAR,20,자재수령인명
  WEMPF: varchar({ length: 255 }),
  // 176,ZMM_HD/ZMM_DT/ZMM_KN,ABLAD,M,CHAR,75,하역지점
  ABLAD: varchar({ length: 255 }),
  // 177,ZMM_HD/ZMM_DT/ZMM_KN,KOKRS,M,CHAR,4,관리회계영역
  KOKRS: varchar({ length: 255 }),
  // 178,ZMM_HD/ZMM_DT/ZMM_KN,PRCTR,M,CHAR,10,손익센터
  PRCTR: varchar({ length: 255 }),
  // 179,ZMM_HD/ZMM_DT/ZMM_KN,NPLNR,M,CHAR,12,네트워크오더번호
  NPLNR: varchar({ length: 255 }),
  // 180,ZMM_HD/ZMM_DT/ZMM_KN,AUFPL,M,NUMC,10,오더라우팅번호
  AUFPL: varchar({ length: 255 }),
  // 181,ZMM_HD/ZMM_DT/ZMM_KN,APLZL,M,NUMC,8,오더내부카운터
  APLZL: varchar({ length: 255 }),
  // 182,ZMM_HD/ZMM_DT/ZMM_KN,FIPOS,M,CHAR,14,약정항목
  FIPOS: varchar({ length: 255 }),
  // 183,ZMM_HD/ZMM_DT/ZMM_KN,FISTL,M,CHAR,16,자금관리센터
  FISTL: varchar({ length: 255 }),
  // 184,ZMM_HD/ZMM_DT/ZMM_KN,GEBER,M,CHAR,10,자금코드
  GEBER: varchar({ length: 255 }),
  // 185,ZMM_HD/ZMM_DT/ZMM_KN,VORNR,M,CHAR,4,네트워크작업번호
  VORNR: varchar({ length: 255 }),
  // 186,ZMM_HD/ZMM_DT/ZMM_KN,POSID,M,CHAR,24,WBS요소
  POSID: varchar({ length: 255 }),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});

export const ZMM_NOTE = ECCSchema.table('ZMM_NOTE', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // FK
  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),

  // 187,ZMM_HD/ZMM_NOTE,ZNOTE_SER,M,NUMC,4,발주 Note 순번
  ZNOTE_SER: varchar({ length: 255 }),
  // 188,ZMM_HD/ZMM_NOTE,ZNOTE_TXT,M,CHAR,4000,발주 Note Text
  ZNOTE_TXT: varchar({ length: 10000 }),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});


export const ZMM_NOTE2 = ECCSchema.table('ZMM_NOTE2', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // FK
  // 1,ZMM_HD,EBELN,M,CHAR,10,구매오더번호
  EBELN: varchar({ length: 255 }).notNull().references(() => ZMM_HD.EBELN),

  // 189,ZMM_HD/ZMM_NOTE2,ZDLV_PRICE_SER,,NUMC,4,연동제  Note 순번
  ZDLV_PRICE_SER: varchar({ length: 255 }),
  // 190,ZMM_HD/ZMM_NOTE2,ZDLV_PRICE_NOTE,,CHAR,4000,연동제 Note Text
  ZDLV_PRICE_NOTE: varchar({ length: 10000 }),

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});
// *** === END === WSDL FILE: IF_ECC_EVCP_PO_INFORMATION.wsdl === ***




// *** === START === WSDL FILE: IF_ECC_EVCP_REJECT_FOR_REVISED_PR.wsdl === ***
export const T_CHANGE_PR = ECCSchema.table('T_CHANGE_PR', {
  id: integer('id').primaryKey().generatedByDefaultAsIdentity(),

  // SEQ,Table,Field,M/O,,Type,Size,,Description
  // 1,메타데이터(저장하지 않음),IV_ERDAT,M,,DATS,8,,Reject Date
  // 2,메타데이터(저장하지 않음),IV_ERZET,M,,TIMS,6,,Reject  Time
  // 3,T_CHANGE_PR,BANFN,M,,CHAR,10,,Purchase Requisition Number
  BANFN: varchar({ length: 255 }),
  // 4,T_CHANGE_PR,BANPO,M,,NUMC,5,,Item Number of Purchase Requisition
  BANPO: varchar({ length: 255 }),
  // 5,T_CHANGE_PR,ZCHG_NO,M,,CHAR,10,,Change Number
  ZCHG_NO: varchar({ length: 255 }),
  // 6,T_CHANGE_PR,ZACC_IND,,,CHAR,1,,P/R Accept Indicator
  ZACC_IND: varchar({ length: 255 }),
  // 7,T_CHANGE_PR,PCR_REQ,,,CHAR,10,,PCR Request No.
  PCR_REQ: varchar({ length: 255 }),
  // 8,T_CHANGE_PR,PCR_REQ_SEQ,,,NUMC,5,,PCR Request Sequence No.
  PCR_REQ_SEQ: varchar({ length: 255 }),
  // 응답은 전체 요청에 대해 하나의 메시지만 전송하며, 데이터베이스에 저장하지 않음
  // 9,수신측 응답,EV_TYPE,,,CHAR,1,,Message Type
  // 10,수신측 응답,EV_MESSAGE,,,CHAR,100,,Message Text

  createdAt: timestamp('created_at').defaultNow().notNull(),
  updatedAt: timestamp('updated_at').defaultNow().notNull(),
});
// *** === END === WSDL FILE: IF_ECC_EVCP_REJECT_FOR_REVISED_PR.wsdl === ***