DMOA
Tables (43)
OrderDocument_tbl
- order_num — varchar(13) — Primary key — NOT NULL
- document — varbinary(max)
- inputDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- FILLFACTOR — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
PartnerCamp_TBL
- seq — int — Primary key — NOT NULL
- CampName — nvarchar(200) — NOT NULL
- PartnerName — nvarchar(150) — NOT NULL
- Attendee — nvarchar(50) — NOT NULL
- Position — nvarchar(30)
- Email — nvarchar(200)
- Mobile — nvarchar(20)
- ETC — nvarchar(50)
- RegistrationDay — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Board
- Board_SE — int — Primary key — NOT NULL
- Title — varchar(200) — NOT NULL
- Contents — text
- Hit_Cnt — int — NOT NULL
- Kind_CD — int — NOT NULL
- Category_SE — int — NOT NULL
- State_CD — int — NOT NULL
- State_User_SE — int
- State_DT — smalldatetime
- Register_User_SE — int — NOT NULL
- Register_DT — datetime — NOT NULL
- Update_User_SE — int
- Update_DT — smalldatetime
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
- Info_YN — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_BoardComment
- Board_SE — int — Primary key — NOT NULL
- BoartComment_SE — int — Primary key — NOT NULL
- Contents — text
- Register_User_SE — int — NOT NULL
- Register_DT — datetime — NOT NULL
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_BoardFile
- Board_SE — int — Primary key — NOT NULL
- BoardFile_SE — int — Primary key — NOT NULL
- File_NM — varchar(100) — NOT NULL
- File_PH — varchar(300) — NOT NULL
- File_SZ — int
- File_Type — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Busi
- Busi_SE — int — Primary key — NOT NULL
- User_SE — int — NOT NULL
- Busi_NM — varchar(20) — NOT NULL
- Eng_Busi_NM — varchar(50)
- Busi_Pos — varchar(50)
- Busi_Dept — varchar(50)
- Phone — varchar(20)
- Hp — varchar(20) — NOT NULL
- Email — varchar(255) — NOT NULL
- UseYN — char(1) — NOT NULL
- RegisterUserSE — int — NOT NULL
- Register_DT — smalldatetime — NOT NULL
- Update_User_SE — int
- Update_DT — smalldatetime
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
TB_CD_Detail
- CD_SE — int — Primary key — NOT NULL
- SECTION_CD — varchar(20) — NOT NULL
- CD_NM — varchar(20) — NOT NULL
- UseYN — char(1) — NOT NULL
- RegisterUserSE — int — NOT NULL
- RegisterDT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_CSPEmailList
- SEQ_NO — int — NOT NULL
- NAME — nvarchar(100)
- EMAIL_ADDR — nvarchar(1000) — NOT NULL
- REG_DATETIME — datetime
- IS_DELETED — int
- DELETED_DATETIME — datetime
TB_CSPEmailSentHistory
- SEQ_NO — int — Primary key — NOT NULL
- USER_NAME — nvarchar(50) — 로그인 사용자
- SENT_DATETIME — datetime
- SENT_FROM — nvarchar(50) — 보내는 사람 이메일 주소
- SENT_TO — nvarchar(2000)
- SENT_CC — nvarchar(2000)
- PARAM_CLIENTNAME — nvarchar(20)
- PARAM_PROGRAM — nvarchar(10)
- PARAM_ORDERTYPE — nvarchar(10)
- PARAM_DOMAIN — nvarchar(100)
- PARAM_ACCOUNT — nvarchar(100)
- PARAM_MSID — nvarchar(100)
- PARAM_PASSWORD — nvarchar(50)
- SUCCESS — int — 0: Failure, 1: Success
- ERROR_MESSAGE — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Ctg
- Category_SE — int — Primary key — NOT NULL
- ctg1 — varchar(100) — NOT NULL
- ctg2 — varchar(100) — NOT NULL
- ctg3 — varchar(100) — NOT NULL
- ctg4 — varchar(100) — NOT NULL
- ctg5 — varchar(100) — NOT NULL
- Use_YN — char(1) — NOT NULL
- Register_User_SE — int — NOT NULL
- Register_DT — smalldatetime — NOT NULL
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
- clientInfo — tinyint
TB_Ctg_TEST
- Category_SE — int — NOT NULL
- ctg1 — varchar(100) — NOT NULL
- ctg2 — varchar(100) — NOT NULL
- ctg3 — varchar(100) — NOT NULL
- ctg4 — varchar(100) — NOT NULL
- ctg5 — varchar(100) — NOT NULL
- Use_YN — char(1) — NOT NULL
- Register_User_SE — int — NOT NULL
- Register_DT — smalldatetime — NOT NULL
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
- clientInfo — tinyint
TB_Goods
- Goods_SE — int — Primary key — NOT NULL
- YearMonth — varchar(6) — NOT NULL
- Part_Num — varchar(100)
- Category_SE (Category_SE2) — int — Foreign key → TB_Ctg.Category_SE — NOT NULL
- Goods_NM — varchar(255) — NOT NULL
- Buy_Price — money
- Sellin_Price — money
- Erp_Price — money
- Memo — varchar(200)
- Supplier — varchar(20)
- Use_YN — char(1) — NOT NULL
- Register_User_SE — int — NOT NULL
- Register_DT — smalldatetime — NOT NULL
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
- SearchValue — AS
- PurchaseRate — float
TB_GoodsHidden
- Part_Num — varchar(32) — Primary key — NOT NULL
- Goods_NM — varchar(255) — NOT NULL
- Net — money
- PP — money
- ERP — money
- isDisplay — varchar(1) — NOT NULL
- register — varchar(50)
- regdate — smalldatetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_History
- History_SE — int — Primary key — NOT NULL
- History_Action — varchar(200) — NOT NULL
- History_User_SE — int — NOT NULL
- History_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Order
- Order_SE — int — Primary key — NOT NULL
- User_SE — int — Foreign key → TB_User.User_SE — NOT NULL
- Dmoa_Busi_SE — int — NOT NULL
- Busi_SE — int — NOT NULL
- Customer_User_SE — int — NOT NULL
- Customer_Permit_Num — varchar(12) — NOT NULL
- Customer_Company_NM — varchar(100) — NOT NULL
- Customer_Eng_Company_NM — varchar(100) — NOT NULL
- Customer_Ceo_NM — varchar(20) — NOT NULL
- Customer_Eng_Ceo_NM — varchar(20) — NOT NULL
- Customer_Phone — varchar(30) — NOT NULL
- Customer_Fax — varchar(30) — NOT NULL
- Customer_Email — varchar(40) — NOT NULL
- Customer_Hompage — varchar(300) — NOT NULL
- Customer_Zip — varchar(7) — NOT NULL
- Customer_Address1 — varchar(300)
- Customer_Address2 — varchar(300)
- Customer_Address3 — varchar(300)
- Customer_Eng_Address1 — varchar(300)
- Customer_Eng_Address2 — varchar(300)
- Customer_Eng_Address3 — varchar(300)
- Customer_Street_Address1 — varchar(300)
- Destination — varchar(20) — NOT NULL
- Order_NM — varchar(20) — NOT NULL
- Order_Phone — varchar(30) — NOT NULL
- Order_Zip — varchar(7) — NOT NULL
- Order_Address1 — varchar(300)
- Order_Address2 — varchar(300)
- Order_Address3 — varchar(300)
- Order_StreetAddress1 — varchar(300)
- Order_EngAddress1 — varchar(300)
- Order_EngAddress2 — varchar(300)
- Order_EngAddress3 — varchar(300)
- Order_Memo — text
- Order_Message — text
- State_CD — int — NOT NULL
- State_User_SE — int
- State_DT — datetime
- Register_User_SE — int — NOT NULL
- Register_DT — datetime — NOT NULL
- Update_User_SE — int
- Update_DT — datetime — NOT NULL
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — datetime
- MailKey — varchar(100)
- MailKey_User_SE — int
- MailKey_DT — datetime
- PobisCheck — char(1)
- Sellin — int
- Sellin_Manager — int
- Busi_Memo — varchar(max)
- Admin_Type — varchar(20)
- Admin_Status — varchar(20) — NOT NULL
- Admin_Memo — varchar(max)
- IndustrialGroup — varchar(300)
- IsApproval — char(1)
- Return_Momo — varchar(max)
- HappyMall_Memo — varchar(max)
- tierAgreeYN — nvarchar(1)
- … +19
TB_OrderAgg
- Order_SE — int — Primary key — NOT NULL
- purchaseAmount — decimal(13, 0)
- sellAmount — decimal(13, 0)
- directSellAmount — decimal(13, 0)
- DCpct — decimal(13, 2)
- marginPct — decimal(13, 2)
- lastAction — varchar(10) — NOT NULL
- regdate — smalldatetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- FILLFACTOR — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_OrderFile
- OrderFile_SE — int — Primary key — NOT NULL
- Order_SE — int — Primary key — NOT NULL
- File_NM — varchar(100) — NOT NULL
- File_PH — varchar(300) — NOT NULL
- File_SZ — int
- File_Type — varchar(50)
- File_Kind — char(1) — NOT NULL
TB_OrderGood
- OrderGood_SE — int — Primary key — NOT NULL
- Order_SE — int — Foreign key → TB_Order.Order_SE — NOT NULL
- Goods_SE — int — Foreign key → TB_Goods.Goods_SE — NOT NULL
- Goods_Cnt — int — NOT NULL
- Sellin_Price — money — NOT NULL
- Unit_Price — money
- Complate_Price — money — NOT NULL
- DisCount_Per — float
- Type_CD — int — NOT NULL
- Goods_NM — varchar(255)
- Part_Num — varchar(100)
- PurchaseRate — float
- termType — nvarchar(10)
- termYear — int
- User_SE (User_SE2) — int — Foreign key → TB_Order.User_SE — NOT NULL
TB_OrderHistory
- OrderHistory_SE — int — Primary key — NOT NULL
- Order_SE — int — Primary key — NOT NULL
- Register_User_SE — int — NOT NULL
- Registor_DT — datetime — NOT NULL
- Action — char(2) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_OrderOpt
- Order_SE — int — Primary key — NOT NULL
- vendor — nvarchar(100) — NOT NULL
- purpose — nvarchar(100)
- industry — nvarchar(100)
- lowrankindustry — nvarchar(100)
- homepage — nvarchar(100)
- organizationnm — varchar(100)
- contractedperiodstartdt — varchar(10)
- contractedperiodenddt — varchar(10)
TB_OrderRenewal
- Order_SE — int — Primary key — NOT NULL
- inputDate — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_PriceList
- PriceList_SE — int — Primary key — NOT NULL
- YearMonth — varchar(6) — NOT NULL
- Title — varchar(200) — NOT NULL
- File_NM — varchar(100) — NOT NULL
- File_PH — varchar(300) — NOT NULL
- File_SZ — int
- File_Type — varchar(50)
- Register_User_SE — int — NOT NULL
- Register_DT — datetime — NOT NULL
- vendor — varchar(50) — NOT NULL
- market — varchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Section
- SECTION_CD — varchar(20) — Primary key — NOT NULL
- SECTION_NM — varchar(30) — NOT NULL
- UseYN — char(1) — NOT NULL
- RegisterUserSE — int — NOT NULL
- RegisterDT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Segment
- Permit_Num — varchar(12) — Primary key — NOT NULL
- Company_NM — varchar(250) — NOT NULL
- Segment_CODE — varchar(20) — NOT NULL
- Area_CODE — varchar(20) — NOT NULL
- Register_DT — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- FILLFACTOR — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Staff
- Staff_SE — int — Primary key — NOT NULL
- User_SE — int — NOT NULL
- Staff_NM — varchar(20) — NOT NULL
- Staff_Pos — varchar(50)
- Staff_Dept — varchar(50)
- Phone — varchar(20)
- Hp — varchar(20) — NOT NULL
- Email — varchar(255) — NOT NULL
- UseYN — char(1) — NOT NULL
- RegisterUserSE — int — NOT NULL
- Register_DT — smalldatetime — NOT NULL
- Update_User_SE — int
- Update_DT — smalldatetime
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — smalldatetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_TechnicalSupport
- TechnicalSupport_SE — smallint — Primary key — NOT NULL
- Process — char(10) — NOT NULL
- SupportNM — nvarchar(100)
- SupportType — char(4)
- CustomerCompanyNM — nvarchar(100) — NOT NULL
- CustomerNM — nvarchar(100) — NOT NULL
- CustomerEmail — nvarchar(100) — NOT NULL
- CustomerArea — nvarchar(100)
- CustomerPN — nvarchar(100)
- PartnerCompanyNM — nvarchar(100) — NOT NULL
- PartnerNM — nvarchar(100) — NOT NULL
- PartnerEmail — nvarchar(100) — NOT NULL
- PartnerType — nvarchar(15) — NOT NULL
- PartnerOSType — nvarchar(50)
- PartnerTitle — nvarchar(200) — NOT NULL
- ProductNM — nvarchar(100) — NOT NULL
- LicenseNum — nvarchar(100) — NOT NULL
- ErrorContents — nvarchar(max) — NOT NULL
- HWContents — nvarchar(max)
- Comment — nvarchar(max) — varchar(max) NUL
- RegisterDT — datetime — NOT NULL
- Register_UserSE — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_TechnicalSupportFile
- TechnicalSupport_SE — smallint — Primary key — NOT NULL
- TechnicalSupportFile_SE — smallint — Primary key — NOT NULL
- File_NM — varchar(100) — NOT NULL
- File_PH — varchar(300) — NOT NULL
- File_SZ — int
- File_Type — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Tmp_Order
- Order_SE — int — Primary key — NOT NULL
- User_SE — int — NOT NULL
- Dmoa_Busi_SE — int — NOT NULL
- Busi_SE — int — NOT NULL
- Customer_User_SE — int
- Customer_Permit_Num — varchar(12)
- Customer_Company_NM — varchar(100)
- Customer_Eng_Company_NM — varchar(100)
- Customer_Ceo_NM — varchar(20)
- Customer_Eng_Ceo_NM — varchar(20)
- Customer_Phone — varchar(30)
- Customer_Fax — varchar(30)
- Customer_Email — varchar(30)
- Customer_Hompage — varchar(300)
- Customer_Zip — varchar(7)
- Customer_Address1 — varchar(300)
- Customer_Address2 — varchar(300)
- Customer_Address3 — varchar(300)
- Customer_Eng_Address1 — varchar(300)
- Customer_Eng_Address2 — varchar(300)
- Customer_Eng_Address3 — varchar(300)
- Customer_Street_Address1 — varchar(300)
- Destination — varchar(20)
- Order_NM — varchar(20)
- Order_Phone — varchar(30)
- Order_Zip — varchar(7)
- Order_Address1 — varchar(300)
- Order_Address2 — varchar(300)
- Order_Address3 — varchar(300)
- Order_StreetAddress1 — varchar(300)
- Order_EngAddress1 — varchar(300)
- Order_EngAddress2 — varchar(300)
- Order_EngAddress3 — varchar(300)
- Order_Memo — text
- Order_Message — text
- State_CD — int — NOT NULL
- State_User_SE — int
- State_DT — datetime
- Register_User_SE — int — NOT NULL
- Register_DT — datetime — NOT NULL
- Update_User_SE — int
- Update_DT — datetime
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — datetime
- Order_Company_NM — varchar(100)
- Admin_Type — varchar(20)
- Admin_Status — varchar(20)
- Admin_Memo — varchar(max)
- IndustrialGroup — varchar(300)
- MpnID — varchar(50)
- Domain1 — varchar(50)
- Domain2 — varchar(50)
- Domain3 — varchar(50)
- HanPLTPartner — varchar(100)
- EngPLTPartner — varchar(100)
- CSPLicenseYn — nchar(1)
- VerificationCode — nvarchar(20)
- AdobeVip — varchar(100)
- AdobePo — varchar(100)
- … +8
TB_Tmp_OrderFile
- OrderFile_SE — int — Primary key — NOT NULL
- Order_SE — int — Primary key — NOT NULL
- File_NM — varchar(100) — NOT NULL
- File_PH — varchar(300) — NOT NULL
- File_SZ — int
- File_Type — varchar(50)
- File_Kind — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Tmp_OrderGood
- Order_SE — int — Primary key — NOT NULL
- OrderGood_SE — int — Primary key — NOT NULL
- Goods_SE — int — NOT NULL
- Goods_Cnt — int — NOT NULL
- Sellin_Price — money — NOT NULL
- Unit_Price — money
- Complate_Price — money — NOT NULL
- DisCount_Per — float
- Type_CD — int — NOT NULL
- Goods_NM — varchar(255)
- Part_Num — varchar(100)
- PurchaseRate — float
- termType — nvarchar(10)
- termYear — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_Tmp_OrderOpt
- Order_SE — int — NOT NULL
- vendor — nvarchar(100) — NOT NULL
- purpose — nvarchar(100)
- industry — nvarchar(100)
- lowrankindustry — nvarchar(100)
- homepage — nvarchar(100)
- organizationnm — varchar(100)
- contractedperiodstartdt — varchar(10)
- contractedperiodenddt — varchar(10)
TB_User
- User_SE — int — Primary key — NOT NULL
- Ref_User_SE — int — NOT NULL
- User_ID — varchar(100) — NOT NULL
- User_PW — varchar(100) — NOT NULL
- Type_CD — int — NOT NULL — 2:디모아직원, 3파트너사, 17:고객사
- Company_NM — varchar(100) — NOT NULL
- Eng_Company_NM — varchar(100)
- Permit_Num — varchar(12) — NOT NULL
- MemberCnt — int
- Ceo_NM — varchar(20)
- Eng_Ceo_NM — varchar(20)
- Phone — varchar(30)
- Fax — varchar(30)
- Email — varchar(300)
- HomePage — varchar(300)
- Zip — varchar(7)
- Address1 — varchar(300)
- Address2 — varchar(300)
- Address3 — varchar(300)
- Eng_Address1 — varchar(300)
- Eng_Address2 — varchar(300)
- Eng_Address3 — varchar(300)
- Street_Address1 — varchar(300)
- Memo — varchar(300)
- Dmoa_Busi_SE — int
- Dmoa_Busi_User_SE — int
- Dmoa_Busi_DT — datetime
- State_CD — int — NOT NULL
- State_User_SE — int
- State_DT — datetime
- Register_User_SE — int — NOT NULL
- Register_DT — datetime — NOT NULL
- Update_User_SE — int
- Update_DT — datetime
- Delete_YN — char(1) — NOT NULL
- Delete_User_SE — int
- Delete_DT — datetime
- MpnID — varchar(50)
- Domain1 — varchar(50)
- Domain2 — varchar(50)
- Domain3 — varchar(50)
- sign_owner — nvarchar(50)
- sign_owner_e — nvarchar(50)
- sign_email — nvarchar(100)
- pwd — varbinary(255)
- enc — varbinary(255)
- pwdChDT — smalldatetime
TB_User_loginPwHst
- User_SE — int — NOT NULL
- User_PW — varchar(100)
- typePW — varchar(100)
- procName — varchar(100)
- regdate — smalldatetime — NOT NULL
- chkEqual — AS
TB_ZipCode_FullText
- ZipCode_SE — int — Primary key — NOT NULL
- 법정동코드 — varchar(10) — NOT NULL
- 시도명 — varchar(20) — NOT NULL
- 영문시도명 — varchar(40)
- 시군구명 — varchar(20) — NOT NULL
- 영문시군구명 — varchar(40)
- 법정읍면동명 — varchar(20) — NOT NULL
- 영문읍면동명 — varchar(40)
- 법정리명 — varchar(20) — NOT NULL
- 산여부 — varchar(1) — NOT NULL
- 지번본번 — varchar(4) — NOT NULL
- 지번부번 — varchar(4) — NOT NULL
- 도로명코드 — varchar(12) — NOT NULL
- 도로명 — varchar(80) — NOT NULL
- 영문도로명 — varchar(80)
- 지하여부 — varchar(1) — NOT NULL
- 건물본번 — varchar(5) — NOT NULL
- 건물부번 — varchar(5) — NOT NULL
- 건물명 — varchar(40) — NOT NULL
- 상세건물명 — varchar(100) — NOT NULL
- 건물관리번호 — varchar(25) — NOT NULL
- 읍면동일련번호 — varchar(2) — NOT NULL
- 행정동코드 — varchar(10) — NOT NULL
- 행정동명 — varchar(20) — NOT NULL
- 우편번호 — varchar(6) — NOT NULL
- 우편일련번호 — varchar(3) — NOT NULL
- 다량배달처명 — varchar(40) — NOT NULL
- SearchValue — AS
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TapproveRights
- Vendor — varchar(50) — Primary key — NOT NULL
- managerName — varchar(50) — Primary key — NOT NULL
- DCpctMin — decimal(9, 6) — NOT NULL
- DCpctMax — decimal(9, 6) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TloginHst
- seq — int — Primary key — NOT NULL
- userid — varchar(20) — NOT NULL
- ipstr — varchar(50)
- regdate — smalldatetime — NOT NULL
- ret — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TmassStateChange
- mscNo — int — Primary key — NOT NULL
- adminName — varchar(50) — NOT NULL
- massMsg — varchar(100) — NOT NULL
- prevState — int — NOT NULL
- postState — int — NOT NULL
- totalCnt — int — NOT NULL
- successCnt — int — NOT NULL
- regdate — smalldatetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TmassStateChangeDtl
- mscNo — int — Primary key — NOT NULL
- Order_SE — int — Primary key — NOT NULL
- customerName — varchar(500) — NOT NULL
- partnerName — varchar(200) — NOT NULL
- AMname — varchar(50) — NOT NULL
- prevState — int — NOT NULL
- postState — int — NOT NULL
- resultmsg — varchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TvendorAM
- vendor — varchar(50) — Primary key — NOT NULL
- Busi_SE — int — Primary key — NOT NULL
- regdate — smalldatetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
파트너사
- 업체번호 — int — Primary key — NOT NULL
- 업체명 — nvarchar(50) — NOT NULL
- 업체이름 — nvarchar(50) — NOT NULL
- 담당팀 — nvarchar(20) — NOT NULL
- 영업담당자 — nvarchar(10)
- 업체영문명 — nvarchar(100)
- Tier — nvarchar(10) — NOT NULL
- Tier_Adobe — nvarchar(10)
- Tier_Ahnlab — nvarchar(10)
- 사업자번호 — nvarchar(15)
- 회사전화 — nvarchar(100)
- 지역 — nvarchar(10)
- 세부주소 — nvarchar(100)
- SW비중 — tinyint
- HW비중 — tinyint
- 주력벤더 — nvarchar(100)
- 설립일자 — nvarchar(10)
- 적용일자 — nvarchar(10)
- 등록일시 — smalldatetime — NOT NULL
- 수정일시 — smalldatetime — NOT NULL
- 수정자명 — nvarchar(10)
- 사업자번호2 — AS
- Release — char(1)
- Renewal — char(1)
- ReceiptDay — nvarchar(50)
- Note — nvarchar(max)
- Limit_Amt — money
- 여신가능시작일 — date — NOT NULL
- 여신가능종료일 — date — NOT NULL
- 여신가능최종여부 — AS
- 담당AM(user_se) (evgNo) — int
- acvetting — nchar(1) — NOT NULL
- acvettingSDay — date — NOT NULL
- acvettingEDay — date — NOT NULL
- acvetting최종여부 — AS
- AEPid — nvarchar(50)
- AEPexpireDT — nvarchar(50)
- mpn_id — nvarchar(50)
- engCity — varchar(100)
- engState — varchar(100)
- AdobePartnerID — varchar(20)
- MSallow — varchar(1) — NOT NULL
파트너사인원
- 업체번호 — int — Primary key — NOT NULL
- 이름 — nvarchar(50) — Primary key — NOT NULL
- 업체명 — nvarchar(50) — NOT NULL
- 직함 — nvarchar(20)
- 의사결정자여부 — nvarchar(1)
- keyman여부 — nvarchar(1)
- 부서 — nvarchar(50)
- 휴대전화 — nvarchar(20)
- 메일 — nvarchar(50)
- 비고 — nvarchar(1000)
- 등록일시 — smalldatetime — NOT NULL
- 수정일시 — smalldatetime — NOT NULL
- 수정자명 — nvarchar(10)
- 내선번호 — nvarchar(30)
현물재고
- 상품코드 — varchar(50) — Primary key — NOT NULL
- 벤더 — varchar(50) — NOT NULL
- 상품명 — varchar(100) — NOT NULL
- 기준코드 — varchar(50) — NOT NULL
- 매입일 — date
- 입고일 — date — NOT NULL
- 매입처 — varchar(100) — NOT NULL
- 재고수량 — int — NOT NULL
- 매입가 — int — NOT NULL
- 입고총량 — int — NOT NULL
- 매입USD — decimal(7, 2)
- 기타 — varchar(1000)
- 등록일 — smalldatetime — NOT NULL
- 수정일 — smalldatetime — NOT NULL
- 매입계산서여부 — AS
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
현물출고
- 출고일련번호 — int — Primary key — NOT NULL
- 주문번호 — int
- 매출일 — date
- 납품일 — date — NOT NULL
- 상품코드 — varchar(50) — NOT NULL
- 벤더 — varchar(50) — NOT NULL
- 상품명 — varchar(100) — NOT NULL
- 매출처 — varchar(100) — NOT NULL
- 담당자 — varchar(100)
- 연락처 — varchar(100)
- 최종고객 — varchar(200)
- 수량 — int — NOT NULL
- 매입가 — int — NOT NULL
- 매출가 — int — NOT NULL
- 매입액 — int — NOT NULL
- 매출액 — int — NOT NULL
- 재고형태 — varchar(100) — NOT NULL
- 비고 — varchar(1000)
- 기타 — varchar(1000)
- 등록일 — smalldatetime — NOT NULL
- 수정일 — smalldatetime — NOT NULL
- 회수출고번호 — int
- 매출계산서발행여부 — AS
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =