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 — =