summaryrefslogtreecommitdiff
path: root/db/schema/MDG/mdg.ts
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema/MDG/mdg.ts')
-rw-r--r--db/schema/MDG/mdg.ts249
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(),
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-07 13:16:05 +0000