diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/MDG/mdg.ts | 249 |
1 files changed, 125 insertions, 124 deletions
diff --git a/db/schema/MDG/mdg.ts b/db/schema/MDG/mdg.ts index 31dc61d3..3075ed50 100644 --- a/db/schema/MDG/mdg.ts +++ b/db/schema/MDG/mdg.ts @@ -27,7 +27,7 @@ export const mdgSchema = pgSchema("mdg"); // [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에서 필수 필드 + BP_HEADER: varchar().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(), @@ -35,10 +35,10 @@ export const CUSTOMER_MASTER_BP_HEADER = mdgSchema.table('CUSTOMER_MASTER_BP_HEA 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - ADDRNO: varchar({ length: 10 }).notNull(), // Address Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + ADDRNO: varchar().notNull(), // Address Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -46,11 +46,11 @@ export const CUSTOMER_MASTER_BP_HEADER_ADDRESS = mdgSchema.table('CUSTOMER_MASTE 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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에서 필수 필드 + CONSNUMBER: varchar().notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + DATE_FROM: varchar().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(), @@ -59,13 +59,13 @@ export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_EMAIL = mdgSchema.table('CUSTO 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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 + CONSNUMBER: varchar().notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + COUNTRY: varchar(), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + DATE_FROM: varchar().notNull(), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + FAX_EXTENS: varchar(), // 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(), @@ -74,30 +74,30 @@ export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_FAX = mdgSchema.table('CUSTOME 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), 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 + COUNTRY: varchar(), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + HOUSE_NUM1: varchar(), // House Number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LANGU: varchar(), // 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 + NATION: varchar(), // International address version ID // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + POST_CODE1: varchar(), // Postal Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + POST_CODE2: varchar(), // Postal Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PO_BOX: varchar(), // PO Box // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + REGION: varchar(), // 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 + TIME_ZONE: varchar(), // Time zone // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TITLE: varchar(), // Title // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TRANSPZONE: varchar(), // 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(), @@ -105,14 +105,14 @@ export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_POSTAL = mdgSchema.table('CUST 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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 + CONSNUMBER: varchar().notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + COUNTRY: varchar(), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + DATE_FROM: varchar().notNull(), // Valid-from date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + R3_USER: varchar(), // ndicator: Telephone is a Mobile Telephone // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + TEL_EXTENS: varchar(), // 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(), @@ -121,11 +121,11 @@ export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_TEL = mdgSchema.table('CUSTOME 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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에서 필수 필드 + CONSNUMBER: varchar().notNull(), // Sequence number // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + DATE_FROM: varchar().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(), @@ -134,68 +134,68 @@ export const CUSTOMER_MASTER_BP_HEADER_ADDRESS_AD_URL = mdgSchema.table('CUSTOME 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), 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 + AUFSD: varchar(), // Central order block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + FAKSD: varchar(), // Central billing block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + GFORM: varchar(), // Legal status // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + JMJAH: varchar(), // Year for which the number of employees is given // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + JMZAH: varchar(), // Yearly number of employees // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + J_1KFREPRE: varchar(), // 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 + KATR1: varchar(), // Attribute1(발행구분-정발행, 역발행등 계산서 발행구분) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KDKG1: varchar(), // Condition grp1 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KTOKD: varchar(), // Account Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KUNNR: varchar().notNull(), // Customer Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + LIFNR: varchar(), // Vendor Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LIFSD: varchar(), // Central delivery block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LOEVM: varchar(), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NIELS: varchar(), // Customer Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + NODEL: varchar(), // 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 + SPERR: varchar(), // Central Posting Block // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPRAS: varchar(), // 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 + UMJAH: varchar(), // Year For Which Sales are Given // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + UWAER: varchar(), // Currency of Sales figure // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VBUND: varchar(), // Company ID of Trading Partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZAPPDT_C: varchar(), // Apporval Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZAPPTM_C: varchar(), // 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 + ZZBA: varchar(), // Business Area(GBM) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZBRSCH_C: varchar(), // 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 + ZZDOKAR_C: varchar(), // 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 + ZZDOKTL_C: varchar(), // Document Part // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZDOKVR_C: varchar(), // 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 + ZZFTBU: varchar(), // 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 + ZZFTDT: varchar(), // 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 + ZZFTGT: varchar(), // 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 + ZZINBFLGC: varchar(), // Inbound Flag // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZLAMDT_C: varchar(), // Last Modified Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZLAMTM_C: varchar(), // 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 + ZZREASON: varchar(), // Reason for Duplication // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZREGDT_C: varchar(), // Registerd Date // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZZREGTM_C: varchar(), // 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 + ZZSTCDT_C: varchar(), // 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 + ZZSUBSEQ_C: varchar(), // 종사업장 일련번호 // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -203,18 +203,18 @@ export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN = mdgSchema.table('CUSTOMER_MAS 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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 + AKONT: varchar(), // Reconcil.acct // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + BUKRS: varchar().notNull(), // Company Code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + FDGRV: varchar(), // Planning Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LOEVM: varchar(), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPERR: varchar(), // Posting block for company code // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZAHLS: varchar(), // Block Key for Payment // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZTERM: varchar(), // Terms of Payment Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZUAWA: varchar(), // Sort key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZWELS: varchar(), // 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(), @@ -222,35 +222,35 @@ export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZCOMPANY = mdgSchema.table('CUS 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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 + AUFSD: varchar(), // Customer order block (sales area) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + AWAHR: varchar(), // Order probability of the item // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + BZIRK: varchar(), // Sales district // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + FAKSD: varchar(), // Billing block for customer (sales and distribution // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + INCO1: varchar(), // 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 + KALKS: varchar(), // Pricing procedure assigned to this customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KDGRP: varchar(), // Customer group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KONDA: varchar(), // Price group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KTGRD: varchar(), // Account assignment group for this customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KURST: varchar(), // Exchange Rate Type // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KZAZU: varchar(), // Order Combination // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LIFSD: varchar(), // Customer delivery block (sales area) // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LOEVM: varchar(), // Central Deletion Flag for Master Record // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + LPRIO: varchar(), // Delivery Priority // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PLTYP: varchar(), // Price List // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + SPART: varchar().notNull(), // Division // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + VERSG: varchar(), // Customer Statistics Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VKBUR: varchar(), // Sales Office // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VKGRP: varchar(), // Sales Group // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VKORG: varchar().notNull(), // Sales Org. // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + VSBED: varchar(), // Shipping Conditions // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + VTWEG: varchar().notNull(), // Distr. Channel // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + VWERK: varchar(), // From plant // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + WAERS: varchar(), // Currency // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + ZTERM: varchar(), // Terms of Payment Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -258,13 +258,13 @@ export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES = mdgSchema.table('CUSTO 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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에서 필수 필드 + DEFPA: varchar(), // Default Partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + KUNN2: varchar(), // Customer number of business partner // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl + PARVW: varchar().notNull(), // Partner Function // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + PARZA: varchar().notNull(), // Partner counter // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -272,12 +272,12 @@ export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZSALES_ZCPFN = mdgSchema.table( 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - 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 + ALAND: varchar().notNull(), // Departure country // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + TATYP: varchar().notNull(), // Tax category // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + TAXKD: varchar(), // Tax classification for customer // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -285,10 +285,10 @@ export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZTAXIND = mdgSchema.table('CUST 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), - LAND1: varchar({ length: 10 }).notNull(), // Country Key // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 + LAND1: varchar().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(), @@ -297,11 +297,11 @@ export const CUSTOMER_MASTER_BP_HEADER_BP_CUSGEN_ZVATREG = mdgSchema.table('CUST 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), + BP_HEADER: varchar().notNull().references(() => CUSTOMER_MASTER_BP_HEADER.BP_HEADER), id: integer('id').primaryKey().generatedByDefaultAsIdentity(), 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에서 필수 필드 + TAXTYPE: varchar().notNull(), // Tax Number Category // From: IF_MDZ_EVCP_CUSTOMER_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -1538,7 +1538,8 @@ export const VENDOR_MASTER_BP_HEADER_ADDRESS = mdgSchema.table('VENDOR_MASTER_BP 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에서 필수 필드 + // ADDRNO로 보내줌 + ADDRNO: varchar({ length: 10 }).notNull(), // 주소번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), @@ -1583,7 +1584,7 @@ export const VENDOR_MASTER_BP_HEADER_ADDRESS_AD_POSTAL = mdgSchema.table('VENDOR 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에서 필수 필드 + INTL_ADR_VER_ID: varchar({ length: 10 }), // 국제주소버전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 @@ -1802,10 +1803,10 @@ export const VENDOR_MASTER_BP_HEADER_BP_VENGEN_BP_PORG_ZVPFN = mdgSchema.table(' 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에서 필수 필드 + PLNT_NO: varchar({ length: 10 }), // 플랜트번호 // 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에서 필수 필드 + VNDR_SUB_NO: varchar({ length: 10 }), // VENDOR서브번호 // From: IF_MDZ_EVCP_VENDOR_MASTER.wsdl // WSDL에서 필수 필드 createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), |