ERP
Tables (39)
CZ_COUPON (쿠폰)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MAN_COUPON (쿠폰관리번호) — NVARCHAR(15) — Primary key — NOT NULL
- NM_COUPON (쿠폰명) — NVARCHAR(200)
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_TYPE_COUPON (쿠폰구분코드) — NVARCHAR(4)
- DT_ISSUE (발급일자) — NVARCHAR(8)
- NO_STR_COUPON (쿠폰시작번호) — NVARCHAR(20)
- NO_END_COUPON (쿠폰종료번호) — NVARCHAR(20)
- CD_TYPE_DAY_EXP (유효기간구분코드) — NVARCHAR(4)
- DT_STR_EXP (유효시작일자) — NVARCHAR(8)
- DT_END_EXP (유효종료일자) — NVARCHAR(8)
- DS_MON_EXP (유효개월수) — NVARCHAR(2)
- TX_COUPON (쿠폰내역) — NVARCHAR(400)
- RT_DISC (할인율) — NUMERIC(19,4)
- CD_STAT_COUPON (쿠폰상태코드) — NVARCHAR(4)
- CD_DEPT (담당부서코드) — NVARCHAR(12)
- ID_RESPON (담당자) — NVARCHAR(15)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- AM_DISC (할인금액) — NUMERIC(19,0)
CZ_ITEM (품목)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9) — Primary key — NOT NULL
- NM_ITEM_KOR (품목명_한글) — NVARCHAR(200)
- NM_ITEM_ENG (품목명_영문) — NVARCHAR(200)
- NM_ITEM_SHO (품목명_약어) — NVARCHAR(200)
- CD_DESIGN (디자인코드) — NVARCHAR(7)
- CD_PROTO (시제품코드) — NVARCHAR(9)
- CD_BARCODE (바코드) — NVARCHAR(200)
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_CLAS_ACCT_ITEM (품목계정분류코드) — NVARCHAR(10)
- CD_CLAS_GROP_ITEM (품목군분류코드) — NVARCHAR(4)
- CD_CLAS_LARG_CATE (카테고리대분류코드) — NVARCHAR(6)
- CD_CLAS_MEDI_CATE (카테고리중분류코드) — NVARCHAR(6)
- CD_CLAS_SMAL_CATE (카테고리소분류코드) — NVARCHAR(6)
- CD_CLAS_LARG_ITEM (품목대분류코드) — NVARCHAR(6)
- CD_CLAS_MEDI_ITEM (품목중분류코드) — NVARCHAR(6)
- CD_CLAS_SMAL_ITEM (품목소분류코드) — NVARCHAR(6)
- CD_SEX (성별코드) — NVARCHAR(4)
- CD_PARTNER (거래처코드) — NVARCHAR(100)
- CD_ORIGIN (원산지코드) — NVARCHAR(4)
- TX_STANDARD (규격) — NVARCHAR(100)
- CD_UNIT (단위) — NVARCHAR(4)
- NU_WEIGHT (중량) — NUMERIC(19,4)
- CD_QUAL_METAL (재질금속코드) — NVARCHAR(4)
- CD_COLOR_METAL (재질칼라코드) — NVARCHAR(4)
- AM_APPL_METAL (금속1g당적용가) — NUMERIC(19,4)
- RT_HARRY (해리율) — NUMERIC(19,4)
- YN_ORD_ADVICE (권고발주유무) — NVARCHAR(2)
- QT_STOCK_SAVE (안전재고수량) — NUMERIC(19,4)
- CD_COLOR (COLOR) — NVARCHAR(4)
- CD_CLARITY (CLARITY) — NVARCHAR(4)
- CD_CUT (CUT) — NVARCHAR(4)
- CD_SHAPE (SHAPE) — NVARCHAR(4)
- CD_SCOPE_WEIGHT (중량범위) — NVARCHAR(4)
- NU_WEIGHT_STON (스톤중량) — NVARCHAR(4)
- TX_SIZE (규격(SIZE)) — NVARCHAR(20)
- CD_GRADE_PEARL (진주등급코드) — NVARCHAR(4)
- AM_PLATING (도금비) — NUMERIC(19,4)
- ID_DESIGNER (디자이너) — NVARCHAR(10)
- YN_USE (사용유무) — NVARCHAR(2)
- DT_STOP (정지일자) — NVARCHAR(8)
- TX_REMARK (비고) — NVARCHAR(400)
- TX_PATH_FILE_IMAGE (이미지파일경로) — NVARCHAR(100)
- NM_FILE_IMAGE (이미지파일명) — NVARCHAR(100)
- DS_MAKE (제작일수) — NUMERIC(19,4)
- DS_MAKE_ADD (추가제작일수) — NUMERIC(19,4)
- DS_MAKE_SPE (특수제작일수) — NUMERIC(19,4)
- SZ_WIDTH_MAIN_RING (반지메인폭사이즈) — NUMERIC(19,4)
- DS_MAKE_EXCEP_BASIC (기본외제작일수) — NUMERIC(19,4)
- SZ_WIDTH_BAND_RING (반지밴드폭사이즈) — NUMERIC(19,4)
- SZ_HEIGHT_RING (반지높이사이즈) — NUMERIC(19,4)
- SZ_LENG_NECK_ANKL (발찌목걸이길이사이즈) — NUMERIC(19,4)
- SZ_WIDTH (가로사이즈) — NUMERIC(19,4)
- SZ_VERTICAL (세로사이즈) — NUMERIC(19,4)
- SZ_HEIGHT (높이사이즈) — NUMERIC(19,4)
- SZ_DIAM_CIRC_HEAD (머리둘레지름사이즈) — NUMERIC(19,4)
- SZ_MINI_RING (반지최소호수) — NUMERIC(19,4)
- SZ_MAX_RING (반지최대호수) — NUMERIC(19,4)
- YN_ORD_05_RING (반지05호주문유무) — NVARCHAR(2)
- SZ_DEC_ADJUST_RING (반지조정줄임호수) — NUMERIC(19,4)
- … +88
CZ_ITEM_MAT (품목자재)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9) — Primary key — NOT NULL
- NO_SEQ_MATR_ITEM (품목자재일련번호) — INT — Primary key — NOT NULL
- CD_MATR_ITEM (품목자재코드) — NVARCHAR(9)
- QT_MATR (품목자재수량) — NUMERIC(19,4)
- NU_WEIGHT_MATR (품목자재중량) — NUMERIC(19,4)
- UP_COST (품목자재원단가) — NUMERIC(19,4)
- UP_RETAIL (품목자재소비자단가) — NUMERIC(19,4)
- AM_COST (품목자재원가금액) — NUMERIC(19,4)
- AM_RETAIL (품목자재소비자금액) — NUMERIC(19,4)
- SZ_SCOPE_MINI (사이즈범위최소) — NUMERIC(19,4)
- SZ_SCOPE_MAX (사이즈범위최대) — NUMERIC(19,4)
- TX_NECESSARY (소요내역) — NVARCHAR(200)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- PRINT_ORDER (출력순서) — INT
- YN_MAIN_STON (메인스톤여부) — NVARCHAR(2)
CZ_MAKE_REQ (제작의뢰)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SAL_ORD (주문번호) — NVARCHAR(15) — Foreign key → CZ_SAL_ORD.NO_SAL_ORD — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_PARTNER (거래처코드) — NVARCHAR(20)
- CD_DEPT (제작의뢰부서코드) — NVARCHAR(12)
- ID_REQ_MAKE (제작의뢰자) — NVARCHAR(15)
- DT_REQ_MAKE (제작의뢰일자) — NVARCHAR(8)
- CD_TYPE_REQ_MAKE (제작의뢰구분코드) — NVARCHAR(4)
- CD_SHAP_REQ_MAKE (제작의뢰형태코드) — NVARCHAR(4)
- CD_STAT_REQ_MAKE (제작의뢰상태코드) — NVARCHAR(4)
- CD_ITEM (품목코드) — NVARCHAR(9)
- QT_REQ_MAKE (제작의뢰수량) — NUMERIC(19,4)
- QT_COMP_MAKE (제작완료수량) — NUMERIC(19,4)
- DT_PROC_REQ_MAKE (제작의뢰처리일자) — NVARCHAR(8)
- DT_COMP_REQ_MAKE (제작의뢰완료일자) — NVARCHAR(8)
- YN_COMP_PROC_CAD (CAD공정완료유무) — NVARCHAR(2)
- DT_COMP_PROC_CAD (CAD공정완료일자) — NVARCHAR(8)
- YN_COMP_PROC_RP (RP출력공정완료유무) — NVARCHAR(2)
- DT_COMP_PROC_RP (RP출력공정완료일자) — NVARCHAR(8)
- YN_COMP_PROC_ORI_SILVER (은원본공정완료유무) — NVARCHAR(2)
- DT_COMP_PROC_ORI_SILVER (은원본공정완료일자) — NVARCHAR(8)
- YN_COMP_PROC_CAST (주조공정완료유무) — NVARCHAR(2)
- DT_COMP_PROC_CAST (주조공정완료일자) — NVARCHAR(8)
- YN_COMP_PROC_SET_STON (스톤세팅공정완료유무) — NVARCHAR(2)
- DT_COMP_PROC_SET_STON (스톤세팅공정완료일자) — NVARCHAR(8)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- QT_SUP (납품중량) — NUMERIC(19,4)
- NO_SAL_ORD_OLD (구주문번호) — NVARCHAR(25)
- NO_SEQ_SAL_ORD_OLD (구주문번호순번) — NVARCHAR(20)
- CD_OLD_ITEM (구품목번호) — NVARCHAR(20)
- NO_REQ_MAKE_OLD (구제작의뢰번호) — NVARCHAR(25)
- NO_CERTIFICATE (감정서번호) — NVARCHAR(20)
CZ_MAKE_REQ_LABOR (제작의뢰공임)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SEQ_REQ_MAKE (제작의뢰일련번호) — INT — Primary key — NOT NULL
- CD_LABOR (공임코드) — NVARCHAR(6)
- QT_REQ_MAKE (제작의뢰수량) — NUMERIC(19,4)
- UP_LABOR (공임단가) — NUMERIC(19,4)
- AM_LABOR (공임금액) — NUMERIC(19,4)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- AM_REPAIR (수선비) — NUMERIC(19,4)
- NO_REQ_MAKE_OLD (구제작의뢰번호) — NVARCHAR(25)
- NO_SAL_ORD_OLD (구주문번호) — NVARCHAR(25)
- NO_SEQ_SAL_ORD_OLD (구주문번호순번) — NVARCHAR(25)
CZ_MAKE_REQ_MAT (제작의뢰자재)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15) — Foreign key → CZ_MAKE_REQ.NO_REQ_MAKE — NOT NULL
- NO_SEQ_REQ_MAKE (제작의뢰일련번호) — INT
- CD_MATR_ITEM (품목자재코드) — NVARCHAR(9)
- QT_MATR (자재수량) — NUMERIC(19,4)
- NU_WEIGHT_MATR (자재중량) — NUMERIC(19,4)
- UP_COST_MATR (자재원단가) — NUMERIC(19,4)
- UP_RETAIL_MATR (자재소비자단가) — NUMERIC(19,4)
- AM_COST_MATR (자재원가금액) — NUMERIC(19,4)
- AM_RETAIL_MATR (자재소비자금액) — NUMERIC(19,4)
- SZ_SCOPE_MINI (사이즈범위최소) — NUMERIC(19,4)
- SZ_SCOPE_MAX (사이즈범위최대) — NUMERIC(19,4)
- TX_NECESSARY (소요내역) — NVARCHAR(200)
- NO_CERTIFICATE (감정서번호) — NVARCHAR(20)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_INSERT (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- QT_SUP (납품중량) — NUMBERIC(19,4)
- QT_IN (입고중량) — NUIMBERIC(19,4)
- YN_MAIN_STON (메인스톤여부) — NVARCHAR(4)
- NO_REQ_MAKE_OLD (구제작의뢰번호) — NVARCHAR(25)
- NO_SAL_ORD_OLD (구주문번호) — NVARCHAR(25)
- NO_SEQ_SAL_ORD_OLD (구주문번호순번) — NVARCHAR(25)
- CD_OLD_ITEM (구품목코드) — NVARCHAR(25)
- STONE_OUT_GB (구소요자재출고여부) — NVARCHAR(2)
CZ_MAKE_RET (제작실적)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_RET (제작실적번호) — NVARCHAR(20) — Primary key — NOT NULL
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15) — Foreign key → CZ_MAKE_REQ.NO_REQ_MAKE — NOT NULL
- CD_ITEM (품목) — NVARCHAR(9)
- QT (실적수량) — NUMERIC(19,4)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_SAL_ORD (주문번호) — VARCHAR(20)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- DT_RET (제작실적일자) — VARCHAR(8)
- CD_SL (S/L코드) — NVARCHAR(20)
CZ_MAKE_RET_MATR (제작실적자재)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_RET (제작실적번호) — NVARCHAR(20)
- NO_SEQ_RET (제작실적자재순번) — INT
- CD_ITEM_MATR (자재코드) — NVARCHAR(20)
- NU_WEIGHT (중량/수량) — NUMERIC(19,4)
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15)
- NO_SEQ_REQ_MAKE (제작의뢰일련번호) — INT
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- CD_FLAG (기타) — VARCHAR(2)
- YN_MAIN_STON (메인스톤여부) — NVARCHAR(4)
- STONE_CD (스톤코드(미사용)) — NVARCHAR(30)
- UNIT_PRICE (단위당가격(미사용)) — NUMERIC(19,4)
- AMT (금액(미사용)) — NVARCHAR(19,4)
- REMARK (비고) — NVARCHAR(400)
CZ_MAN_PUR (생산입고)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_PUR_MAN (생산입고번호) — NVARCHAR(15) — Primary key — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_PARTNER (제작공방코드) — NVARCHAR(20)
- CD_DEPT (입고부서코드) — NVARCHAR(12)
- ID_PUR (입고자) — NVARCHAR(15)
- DT_PUR (입고일자) — NVARCHAR(8)
- CD_TYPE_PUR (입고구분코드) — NVARCHAR(4)
- CD_STAT_PUR (입고상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MAN_PUR_DTL (생산입고상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_PUR_MAN (생산입고번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SEQ_PUR_MAN (생산입고일련번호) — INT — Primary key — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9)
- SZ_RING (사이즈) — NUMERIC(19,4)
- QT_STOCK (재고수량) — NUMERIC(19,4)
- QT_SAL_ORD (주문수량) — NUMERIC(19,4)
- QT_SUP (납품수량) — NUMERIC(19,4)
- QT_PUR (입고수량) — NUMERIC(19,4)
- QT_RTN (반품수량) — NUMERIC(19,4)
- QT_PUR_OUTS (미입고수량) — NUMERIC(19,4)
- NU_WEIGHT_SUP (납품중량) — NUMERIC(19,4)
- NU_WEIGHT_PUR (입고중량) — NUMERIC(19,4)
- UP_PUR (입고단가) — NUMERIC(19,4)
- AM_PUR (입고금액) — NUMERIC(19,4)
- CD_STAT_DTL_PUR (입고상세상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15)
- NO_SUP (납품번호) — NVARCHAR(15)
- NO_SEQ_SUP (납품일련번호) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_PUR_MAN_ORG (원생산입고번호) — NVARCHAR(15)
- NO_SEQ_PUR_MAN_ORG (원생산입고일련번호) — INT
- NO_RET (생산실적번호) — NVARCHAR(15)
- NO_SEQ_RET (생산실적번호순번) — NVARCHAR(15)
CZ_MBR (회원)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- NM_MBR_KOR (회원성명_한글) — NVARCHAR(50)
- NM_MBR_ENG (회원성명_영문) — NVARCHAR(50)
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_STAT_MBR (회원상태코드) — NVARCHAR(4)
- CD_TYPE_JOIN_MBR (회원가입구분코드) — NVARCHAR(4)
- CD_TYPE_MBR (회원구분코드) — NVARCHAR(4)
- CD_GRADE_MBR (회원등급코드) — NVARCHAR(4)
- CD_ACTI_MBR (회원활동코드) — NVARCHAR(4)
- ID_USER (온라인사용자ID) — NVARCHAR(20)
- PW_USER (온라인비밀번호) — NVARCHAR(10)
- CD_STORE_REGI (등록매장코드) — NVARCHAR(20)
- CD_STORE_MANA (관리매장코드) — NVARCHAR(20)
- NO_RESIDENT1 (주민등록번호1) — NVARCHAR(6)
- NO_RESIDENT2 (주민등록번호2) — NVARCHAR(7)
- NO_POST_HOME1 (자택우편번호1) — NVARCHAR(4)
- NO_POST_HOME2 (자택우편번호2) — NVARCHAR(4)
- TX_ADDR_HOME1 (자택주소1) — NVARCHAR(200)
- TX_ADDR_HOME2 (자택주소2) — NVARCHAR(200)
- NO_TEL_HOME1 (자택전화번호1) — NVARCHAR(100)
- NO_TEL_HOME2 (자택전화번호2) — NVARCHAR(4)
- NO_TEL_HOME3 (자택전화번호3) — NVARCHAR(4)
- NO_CELLPHONE1 (휴대전화번호1) — NVARCHAR(20)
- NO_CELLPHONE2 (휴대전화번호2) — NVARCHAR(4)
- NO_CELLPHONE3 (휴대전화번호3) — NVARCHAR(4)
- CD_SEX (성별코드) — NVARCHAR(2)
- DT_BIRTH (생년월일) — NVARCHAR(8)
- YN_LUNAR (음력유무) — NVARCHAR(2)
- YN_MARRY (결혼유무) — NVARCHAR(2)
- DT_MARRY (결혼기념일자) — NVARCHAR(8)
- TX_EMAIL (Email) — NVARCHAR(50)
- CD_RECE_DM (DM수령지코드) — NVARCHAR(4)
- YN_RECEIVE_EMAIL (Email수신거부여부) — NVARCHAR(2)
- YN_RECEIVE_SMS (SMS수신거부여부) — NVARCHAR(2)
- YN_RECEIVE_DM (DM수신거부여부) — NVARCHAR(2)
- YN_RECEIVE_TM (TM수신거부여부) — NVARCHAR(2)
- YN_VISIT (방문유무) — NVARCHAR(2)
- YN_ERR_EMAIL (Email오류유무) — NVARCHAR(2)
- YN_ERR_CELLPHONE (휴대폰오류유무) — NVARCHAR(2)
- YN_ERR_ADDR_HOME (자택주소오류유무) — NVARCHAR(2)
- YN_ERR_TEL_HOME (자택전화오류유무) — NVARCHAR(2)
- YN_ERR_ADDR_OFFICE (직장주소오류유무) — NVARCHAR(2)
- YN_ERR_TEL_OFFICE (직장전화오류유무) — NVARCHAR(2)
- NM_OFFICE (직장명) — NVARCHAR(100)
- NM_DEPT (부서명/직위명) — NVARCHAR(50)
- NO_POST_OFFICE1 (직장우편번호1) — NVARCHAR(4)
- NO_POST_OFFICE2 (직장우편번호2) — NVARCHAR(4)
- TX_ADDR_OFFICE1 (직장주소1) — NVARCHAR(200)
- TX_ADDR_OFFICE2 (직장주소2) — NVARCHAR(200)
- NO_TEL_OFFICE1 (직장전화번호1) — NVARCHAR(20)
- NO_TEL_OFFICE2 (직장전화번호2) — NVARCHAR(4)
- NO_TEL_OFFICE3 (직장전화번호3) — NVARCHAR(4)
- DT_JOIN_MBR (회원가입일자) — NVARCHAR(8)
- DT_DROP_MBR (회원탈퇴일자) — NVARCHAR(8)
- TX_MEMO (메모) — NVARCHAR(2000)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- … +8
CZ_MBR_ADVICE (회원상담)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- NO_SEQ_ADVICE (상담일자) — NVARCHAR(8) — Primary key — NOT NULL
- NO_SEQ_ADVICE (상담일련번호) — INT — Primary key — NOT NULL
- CD_STORE (매장코드) — NVARCHAR(20)
- CD_TYPE_ADVICE (상담구분코드) — NVARCHAR(4)
- TX_ADVICE (상담내용) — NVARCHAR(200)
- TX_DEMAND_CUST (고객요구내역) — NVARCHAR(200)
- TX_REST_PROC_ADVICE (상담처리결과) — NVARCHAR(200)
- AM_PROC_ADVICE (상담처리비용) — NUMERIC(19,4)
- NO_SEQ_ADVICE_ENT (등록상담일련번호) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MBR_BUY (회원구매내역)
- IDX (회원구매내역일련번호) — BIGINT — Primary key — NOT NULL
- CD_COMPANY (회사코드) — NVARCHAR(7)
- NO_MBR (회원번호) — NVARCHAR(20)
- DT_BUY (구매일자) — NVARCHAR(8)
- NO_SEQ_BUY (구매일련번호) — INT
- CD_TYPE_BUY (구매구분코드) — NVARCHAR(4)
- CD_STORE (매장코드) — NVARCHAR(20)
- CD_ITEM (품목코드) — NVARCHAR(9)
- SZ_RING (반지호수) — NUMERIC(19,4)
- QT_BUY (구매수량) — NUMERIC(19,4)
- RT_DISC (할인율) — NUMERIC(19,4)
- UP_BUY (구매단가) — NUMERIC(19,4)
- AM_BUY (구매금액) — NUMERIC(19,4)
- PT_BUY (구매포인트) — NUMERIC(19,4)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_SAL (판매번호) — NVARCHAR(15)
- NO_SEQ_SAL (판매일련번호) — INT
- PT_BUY_PLAN (적립예정포인트) — NUMERIC(19,4)
CZ_MBR_BUY_SUM (회원구매집계)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- CNT_BUY (구매전표수) — INT
- CNT_RETURN (반품전표수) — INT
- DT_BUY_LAST (최종구매일) — NVARCHAR(8)
- QT_BUY (구매수량) — NUMERIC(19,4)
- QT_RETURN (반품수량) — NUMERIC(19,4)
- QT_BUY_TOTAL (구매합계수량) — NUMERIC(19,4)
- AM_BUY (구매금액) — NUMERIC(19,4)
- AM_RETURN (반품금액) — NUMERIC(19,4)
- AM_BUY_TOTAL (구매합계금액) — NUMERIC(19,4)
- DTS_INSERT (생성일시) — NVARCHAR(14)
- DT_BUY_FIRST (최초구매일) — NVARCHAR(8)
- NO_SAL_FIRST (최초판매번호) — NVARCHAR(20)
- CD_REPAIR (수선내역코드) — NVARCHAR(100)
CZ_MBR_COUPON (회원쿠폰)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MAN_COUPON (쿠폰관리번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- NO_COUPON (쿠폰번호) — NVARCHAR(20)
- DT_ISSUE (발급일자) — NVARCHAR(8)
- DT_USE (사용일자) — NVARCHAR(8)
- CD_STORE (매장코드) — NVARCHAR(20)
- NO_SAL (판매번호) — NVARCHAR(15)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- CD_STAT_COUPON (쿠폰상태) — NVARCHAR(4)
- DT_DISCARD (할인일자) — NVARCHAR(8)
- ID_DISCARD (할인자) — NVARCHAR(15)
- DT_END_EXP_MBR (종료일자) — NVARCHAR(8)
- RESERVATION_STORE (예약매장) — NVARCHAR(50)
CZ_MBR_CS (회원 CS내역)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- DT_CS (CS일자) — NVARCHAR(8) — Primary key — NOT NULL
- NO_SEQ_CS (순번) — INT — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- CD_STORE (매장코드) — NVARCHAR(20)
- CD_TYPE_CS (CS구분) — NVARCHAR(4)
- CD_STAT_CS (CS내역) — NVARCHAR(4)
- TX_DTL (세부내역) — NVARCHAR(400)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (작성일) — NVARCHAR(14)
- ID_INSERT (작성자) — NVARCHAR(15)
- DTS_UPDATE (수정일) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제여부) — NVARCHAR(2)
- DTS_DELETE (삭제일) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MBR_DM_SEND (회원DM)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_PUR_DM (DM발행번호) — NVARCHAR(15) — Primary key — NOT NULL
- CD_BRAND (브랜드) — NVARCHAR(4)
- DT_PUB (발행일자) — NVARCHAR(8)
- CD_TYPE_PUB (발행구분) — NVARCHAR(4)
- CD_DEPT (발행부서) — NVARCHAR(12)
- ID_RESPON (담당자) — NVARCHAR(15)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제여부) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MBR_DM_SEND_DTL (회원DM상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_PUR_DM (DM발행번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- NM_MBR_KOR (회원명) — NVARCHAR(50)
- NO_TEL1 (전화번호1) — NVARCHAR(40)
- NO_TEL2 (전화번호2) — NVARCHAR(4)
- NO_TEL3 (전화번호3) — NVARCHAR(4)
- NO_POST1 (우편번호1) — NVARCHAR(3)
- NO_POST2 (우편번호2) — NVARCHAR(3)
- TX_ADDR1 (주소1) — NVARCHAR(200)
- TX_ADDR2 (주소2) — NVARCHAR(200)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제여부) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MBR_GIFT (회원사은품)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- DT_PROV_GIFT (사은품지급일자) — NVARCHAR(8) — Primary key — NOT NULL
- NO_SEQ_PROV_GIFT (사은품지급일련번호) — INT — Primary key — NOT NULL
- CD_STORE (매장코드) — NVARCHAR(20)
- CD_ITEM_GIFT (사은품코드) — NVARCHAR(9)
- QT_PROV_GIFT (사은품지급수량) — NUMERIC(19,4)
- UP_GIFT (사은품단가) — NUMERIC(19,4)
- AM_GIFT (사은품금액) — NUMERIC(19,4)
- PT_DEDUC (차감포인트) — NUMERIC(19,4)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- CD_TP_PROV (지급구분) — NVARCHAR(4)
- DT_PROV_GIFT_ORG (원사은품지급일자(반품)) — NVARCHAR(8)
- NO_SEQ_PROV_ORG (원사은품지급순번(반품)) — INT
CZ_MBR_HIS (회원변경내역)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- DT_CHANGE (변경일자) — NVARCHAR(8) — Primary key — NOT NULL
- NO_SEQ_CHANGE (변경일련번호) — INT — Primary key — NOT NULL
- CD_TYPE_CHANGE (변경구분코드) — NVARCHAR(4)
- CD_STORE (변경매장코드) — NVARCHAR(20)
- TX_BEFORE_CHANGE (변경전내역) — NVARCHAR(200)
- TX_AFTER_CHANGE (변경후내역) — NVARCHAR(200)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- CHANGE_TYPE (변경유형) — NVARCHAR(100)
CZ_MBR_POINT (회원포인트)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- CD_TYPE_POINT (포인트구분코드) — NVARCHAR(2) — Primary key — NOT NULL
- YY_SAVE_POINT (포인트적립년도) — NVARCHAR(4) — Primary key — NOT NULL
- PT_CARR (이월포인트) — NUMERIC(19,4)
- PT_BUY (구매포인트) — NUMERIC(19,4)
- PT_ACCUM (누적포인트) — NUMERIC(19,4)
- PT_DEDUC (차감포인트) — NUMERIC(19,4)
- PT_BALAN (잔여포인트) — NUMERIC(19,4)
- PT_FUSIB (가용포인트) — NUMERIC(19,4)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MBR_POINT_DTL (회원포인트상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- CD_TYPE_POINT (포인트구분코드) — NVARCHAR(2) — Primary key — NOT NULL
- DT_SAVE_POINT (포인트적립일자) — NVARCHAR(8) — Primary key — NOT NULL
- NO_SEQ_SAVE_POINT (포인트적립일련번호) — INT — Primary key — NOT NULL
- CD_STORE (매장코드) — NVARCHAR(20)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- NO_SAL (판매번호) — NVARCHAR(15)
- CD_ITEM (품목코드) — NVARCHAR(9)
- PT_OCCUR (발생포인트) — NUMERIC(19,4)
- PT_DEDUC (차감포인트) — NUMERIC(19,4)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_MBR_POINT_SAVE (회원포인트적립내역)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- YM_CREATE (발생년월) — NVARCHAR(6) — Primary key — NOT NULL
- NO_SEQ_CREATE (발생순번) — INT — Primary key — NOT NULL
- CD_TYPE_POINT (포인트구분) — NVARCHAR(4)
- DT_CREATE (발생일자) — NVARCHAR(8)
- NO_MBR (회원번호) — NVARCHAR(15)
- NO_SAL (판매번호) — NVARCHAR(15)
- AM_SAL (판매금액) — NUMERIC(19,4)
- PT_TARGET (적립대상포인트) — INT
- PT_USE_SALE (판매시 사용한 포인트) — INT
- DT_SAVE_PLAN (포인트적립예정일) — NVARCHAR(8)
- PT_SAVE_PLAN (적립예정포인트) — INT
- DT_SAVE (적립일자) — NVARCHAR(8)
- PT_SAVE (적립포인트) — INT
- PT_USE (사용포인트(합계)) — INT
- PT_DESTROY (소멸포인트(합계)) — INT
- DT_LIMIT_START (포인트유효기간.시작일) — NVARCHAR(8)
- DT_LIMIT_END (포인트유효기간.종료일) — NVARCHAR(8)
- DT_DESTROY_PLAN (소멸예정일) — NVARCHAR(8)
- DT_DESTROY_DEL_SALE (판매삭제소멸일) — NVARCHAR(8)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- CD_TYPE_SAVE (적립구분) — NVARCHAR(4)
- NO_GRADE_ADVAN (승급번호) — NVARCHAR(15)
- NO_PROM_MBR (회원포인트프로모션 번호) — NVARCHAR(15)
- TX_REMARK (비고) — NVARCHAR(1000)
CZ_MBR_POINT_USE_DESTROY (회원포인트소멸사용내역)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- YM_CREATE (발생년월) — NVARCHAR(6) — Primary key — NOT NULL
- NO_SEQ_CREATE (발생순번) — INT — Primary key — NOT NULL
- CD_TYPE_POINT (포인트구분) — NVARCHAR(4)
- CD_RESON (포인트소진구분) — NVARCHAR(4)
- DT_USE (발생일자) — NVARCHAR(8)
- NO_MBR (회원번호) — NVARCHAR(15)
- NO_SAL (판매번호) — NVARCHAR(15)
- AM_SAL (판매금액) — NUMERIC(19,4)
- PT_USE (사용/소멸포인트) — INT
- NO_SAL_SAVE (적립 판매번호) — NVARCHAR(15)
- DT_SAVE (적립일자) — NVARCHAR(8)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- NO_SAL_RTN (반품판매번호) — NVARCHAR(15)
CZ_MBR_REP (회원수선내역)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Primary key — NOT NULL
- DT_REPAIR (수선일자) — NVARCHAR(8) — Primary key — NOT NULL
- NO_SEQ_REPAIR (수선일련번호) — INT — Primary key — NOT NULL
- CD_STORE (매장코드) — NVARCHAR(20)
- CD_ITEM (품목코드) — NVARCHAR(9)
- SZ_RING (반지호수) — NUMERIC(19,4)
- CD_KIND_REPAIR (수선종류코드) — NVARCHAR(4)
- CD_ARTI_REPAIR (수선항목코드) — NVARCHAR(28)
- AM_REPAIR (수선비) — NUMERIC(19,4)
- TX_DTL_REPAIR (수선상세내역) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_SAL (판매번호) — NVARCHAR(15)
- NO_SEQ_SAL (판매일련번호) — INT
CZ_MBR_SMS_SEND (회원SMS)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SEND_SMS (SMS발송번호) — NVARCHAR(15) — Primary key — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- DT_SEND (발송일자) — NVARCHAR(8)
- CD_DEPT (발송부서코드) — NVARCHAR(12)
- ID_RESPON (담당자) — NVARCHAR(15)
- NO_TEL_SEND1 (발송전화번호1) — NVARCHAR(20)
- NO_TEL_SEND2 (발송전화번호2) — NVARCHAR(4)
- NO_TEL_SEND3 (발송전화번호3) — NVARCHAR(4)
- TX_SEND (발송내역) — VARCHAR(1600)
- CD_TYPE_SEND_SMS (발송구분코드) — NVARCHAR(4)
- CD_STAT_SEND_SMS (발송상태코드) — NVARCHAR(4)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_SEND_SMS_KEY (발송번호KEY(MSG_DATA와 연결용)) — INT
- TP_MSG (메시지구분(CZ_50033)) — NVARCHAR(4)
CZ_MBR_SMS_SEND_DTL (SMS발송내역)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SEND_SMS (SMS발송번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SEQ (순번) — INT — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20)
- NM_MBR (고객명) — NVARCHAR(50)
- NO_TEL (전화번호) — NVARCHAR(20)
- CD_RES_SEND_SMS (발송결과코드) — NVARCHAR(4)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_PROTO (시제품)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- CD_PROTO (시제품코드) — NVARCHAR(9) — Primary key — NOT NULL
- NM_PROTO (시제품명) — NVARCHAR(200)
- CD_CLAS_LARG_CATE (카테고리대분류코드) — NVARCHAR(6)
- CD_CLAS_MEDI_CATE (카테고리중분류코드) — NVARCHAR(6)
- CD_CLAS_SMAL_CATE (카테고리소분류코드) — NVARCHAR(6)
- CD_CLAS_LARG_ITEM (품목대분류코드) — NVARCHAR(6)
- CD_CLAS_MEDI_ITEM (품목중분류코드) — NVARCHAR(6)
- CD_CLAS_SMAL_ITEM (품목소분류코드) — NVARCHAR(6)
- CD_DESIGN (디자인코드) — NVARCHAR(7)
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_PARTNER (제작공방코드) — NVARCHAR(20)
- ID_DESIGNER (디자이너) — NVARCHAR(15)
- TX_TECH_CAD (CAD테크니션) — NVARCHAR(50)
- CD_KIND_STON_MAIN (메인스톤종류코드) — NVARCHAR(4)
- TX_SIZE_STON_MAIN (메인스톤부대) — NVARCHAR(20)
- CD_QUAL_METAL (재질금속코드) — NVARCHAR(4)
- CD_COLOR_METAL (재질칼라코드) — NVARCHAR(4)
- CD_SEX (성별코드) — NVARCHAR(4)
- CD_TYPE_STAT_PROTO (시제품상태구분코드) — NVARCHAR(4)
- DT_REQ_MAKE (제작의뢰일자) — NVARCHAR(8)
- DT_COMP_MAKE (제작완료일자) — NVARCHAR(8)
- NM_PROJECT (프로젝트명) — NVARCHAR(200)
- TX_REMARK (비고) — NVARCHAR(400)
- TX_PATH_FILE_IMAGE (이미지파일경로) — NVARCHAR(100)
- NM_FILE_IMAGE (이미지파일명) — NVARCHAR(100)
- AM_CAST_COMP_COST (원가_완전빈틀) — NUMERIC(19,4)
- AM_CAST_COST (원가_빈틀) — NUMERIC(19,4)
- AM_ITEM_COST (원가_제품) — NUMERIC(19,4)
- RT_MARGIN_RETL_STAN (표준소비자가_마진율) — NUMERIC(19,4)
- AM_CAST_COMP_RETL_STAN (표준소비자가_완전빈틀) — NUMERIC(19,4)
- AM_CAST_RETL_STAN (표준소비자가_빈틀) — NUMERIC(19,4)
- AM_ITEM_RETL_STAN (표준소비자가_제품) — NUMERIC(19,4)
- RT_COST_RETL_STAN (표준소비자가_원가율) — NUMERIC(19,4)
- TX_REMARK_RETL_STAN (표준소비자가_비고) — NVARCHAR(400)
- RT_MARGIN_RETL_ADJU (조정소비자가_마진율) — NUMERIC(19,4)
- AM_CAST_COMP_RETL_ADJU (조정소비자가_완전빈틀) — NUMERIC(19,4)
- AM_CAST_RETL_ADJU (조정소비자가_빈틀) — NUMERIC(19,4)
- AM_ITEM_RETL_ADJU (조정소비자가_제품) — NUMERIC(19,4)
- RT_COST_RETL_ADJU (조정소비자가_원가율) — NUMERIC(19,4)
- TX_REMARK_RETL_ADJU (조정소비자가_비고) — NVARCHAR(400)
- AM_CAST_COMP_RETL_FINI (최종소비자가_완전빈틀) — NUMERIC(19,4)
- AM_CAST_RETL_FINI (최종소비자가_빈틀) — NUMERIC(19,4)
- AM_ITEM_RETL_FINI (최종소비자가_제품) — NUMERIC(19,4)
- RT_COST_RETL_FINI (최종소비자가_원가율) — NUMERIC(19,4)
- TX_REMARK_RETL_FINI (최종소비자가_비고) — NVARCHAR(400)
- DS_MAKE (제작일수) — NUMERIC(19,4)
- CD_CLAS_GROP_ITEM (품목군분류코드) — NVARCHAR(4)
- SZ_WIDTH_MAIN_RING (반지메인폭사이즈) — NUMERIC(19,4)
- SZ_WIDTH_BAND_RING (반지밴드폭사이즈) — NUMERIC(19,4)
- SZ_HEIGHT_RING (반지높이사이즈) — NUMERIC(19,4)
- SZ_LENG_NECK_ANKL (발찌목걸이길이사이즈) — NUMERIC(19,4)
- SZ_WIDTH (가로사이즈) — NUMERIC(19,4)
- SZ_VERTICAL (세로사이즈) — NUMERIC(19,4)
- SZ_HEIGHT (높이사이즈) — NUMERIC(19,4)
- SZ_DIAM_CIRC_HEAD (머리둘레지름사이즈) — NUMERIC(19,4)
- SZ_MINI_RING (반지최소호수) — NUMERIC(19,4)
- SZ_MAX_RING (반지최대호수) — NUMERIC(19,4)
- YN_ORD_05_RING (반지05호주문유무) — NVARCHAR(2)
- SZ_DEC_ADJUST_RING (반지조정줄임호수) — NUMERIC(19,4)
- … +46
CZ_PROTO_MAT (시제품자재)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- CD_PROTO (시제품코드) — NVARCHAR(9) — Primary key — NOT NULL
- NO_SEQ_MATR_PROTO (시제품자재일련번호) — INT — Primary key — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9)
- QT_MATR (자재수량) — NUMERIC(19,4)
- NU_WEIGHT_MATR (자재중량) — NUMERIC(19,4)
- UP_COST (원단가) — NUMERIC(19,4)
- UP_RETAIL (소비자단가) — NUMERIC(19,4)
- Field
CZ_REL (출고)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_REL (출고번호) — NVARCHAR(15) — Primary key — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_STORE (매장코드) — NVARCHAR(20)
- CD_DEPT (출고부서코드) — NVARCHAR(12)
- ID_REL (출고자) — NVARCHAR(15)
- DT_REL (출고일자) — NVARCHAR(8)
- CD_TYPE_REL (출고구분코드) — NVARCHAR(4)
- CD_STAT_REL (출고상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_REL_DTL (출고상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_REL (출고번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SEQ_REL (출고일련번호) — INT — Primary key — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9)
- QT_STOCK (재고수량) — NUMERIC(19,4)
- QT_SAL_ORD (주문수량) — NUMERIC(19,4)
- QT_REL (출고수량) — NUMERIC(19,4)
- QT_RTN (반품수량) — NUMERIC(19,4)
- QT_REL_OUTS (미출고수량) — NUMERIC(19,4)
- UP_REL (출고단가) — NUMERIC(19,4)
- AM_REL (출고금액) — NUMERIC(19,4)
- CD_STAT_DTL_REL (출고상세상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15)
- NO_PUR_STO (입고번호_반품) — NVARCHAR(15)
- NO_SEQ_PUR_STO (입고일련번호_반품) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_PUR (삭제대상FIELD) — NVARCHAR(15)
- NO_SEQ_PUR (삭제대상FIELD2) — INT
- NO_REL_ORG (원 출고번호(반품)) — NVARCHAR(15)
- NO_SEQ_REL_ORG (월 출고순번(반품)) — INT
- SZ_RING (반지호수) — NUMERIC(19,4)
- NO_PUR_MAN (생산입고번호) — NVARCHAR(15)
- NO_SEQ_PUR_MAN (생산입고일련번호) — INT
- NO_OUT_OLD (과거출고번호) — NVARCHAR(30)
CZ_SAL (판매)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SAL (판매번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SAL_ORD (주문번호) — NVARCHAR(15) — Foreign key → CZ_SAL_ORD.NO_SAL_ORD — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Foreign key → CZ_SAL_ORD.NO_MBR — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_STORE_SAL (판매매장코드) — NVARCHAR(20)
- DT_SAL (판매일자) — NVARCHAR(9)
- ID_RESPON (담당자) — NVARCHAR(50)
- CD_TYPE_SAL (판매구분코드) — NVARCHAR(4)
- CD_ROUTE_VISIT (방문경로코드) — NVARCHAR(4)
- CD_USE_PUR (구매용도코드) — NVARCHAR(4)
- CD_AGE (연령대코드) — NVARCHAR(4)
- YN_MBR (회원유무) — NVARCHAR(2)
- NM_KOR (성명) — NVARCHAR(50)
- CD_SEX (성별코드) — NVARCHAR(4)
- NO_TEL_HOME1 (자택전화번호1) — NVARCHAR(20)
- NO_TEL_HOME2 (자택전화번호2) — NVARCHAR(4)
- NO_TEL_HOME3 (자택전화번호3) — NVARCHAR(4)
- NO_CELLPHONE1 (휴대전화번호1) — NVARCHAR(20)
- NO_CELLPHONE2 (휴대전화번호2) — NVARCHAR(4)
- NO_CELLPHONE3 (휴대전화번호3) — NVARCHAR(4)
- NO_POST_HOME1 (자택우편번호1) — NVARCHAR(20)
- NO_POST_HOME2 (자택우편번호2) — NVARCHAR(4)
- TX_ADDR_HOME1 (자택주소1) — NVARCHAR(200)
- TX_ADDR_HOME2 (자택주소2) — NVARCHAR(200)
- NO_COUPON (쿠폰번호) — NVARCHAR(30)
- RT_DISC_COUPON (쿠폰할인율) — NUMERIC(19,4)
- AM_DISC_COUPON (쿠폰할인금액) — NUMERIC(19,4)
- AM_RETAIL (소비자금액) — NUMERIC(19,4)
- AM_DISCOUNT (행사금액) — NUMERIC(19,4)
- AM_SAL (판매금액) — NUMERIC(19,4)
- NO_SAL_ORI (원판매번호) — NVARCHAR(15)
- DT_SAL_ORI (원판매일자) — NVARCHAR(15)
- YN_RETN (반품여부) — NVARCHAR(2)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- CD_CAUSE_RETN (반품사유코드) — NVARCHAR(4)
- TX_REMARK_RETN (반품사유비고) — NVARCHAR(400)
- YN_TARGET_RETN (반납대상) — NVARCHAR(4)
- NO_SLIP (전표번호) — NVARCHAR(20)
- NO_PROM (프로모션번호) — NVARCHAR(15)
- NO_SAL_OLD (구판매번호) — NVARCHAR(25)
- CD_PARTNER (거래처코드) — NVARCHAR(20)
- CD_SL (출고창고) — NVARCHAR(20)
- NO_PROM_MBR (회원포인트 프로모션번호) — NVARCHAR(15)
- YN_CHECK (사은품지급체크코드) — NVARCHAR(10)
- CASE_NON (사은품미지급수량) — NUMERIC(19,4)
- EVENT_POINT (이벤트포인트) — NUMERIC(19,4)
- YN_DC (할인여부) — NVARCHAR(10)
CZ_SAL_DTL (판매상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- NO_SAL (판매번호) — NVARCHAR(15)
- NO_SEQ_SAL (판매일련번호) — INT
- CD_ITEM (품목코드) — NVARCHAR(9)
- SZ_RING (반지호수) — NUMERIC(19,4)
- QT_SAL (판매수량) — NUMERIC(19,4)
- UP_RETAIL (소비자단가) — NUMERIC(19,4)
- RT_DISC (할인율) — NUMERIC(19,4)
- UP_SAL (판매단가) — NUMERIC(19,4)
- AM_SAL (판매금액) — NUMERIC(19,4)
- RT_COMMISSION (수수료율) — NUMERIC(19,4)
- CD_TYPE_SPEC (특수구분코드) — NVARCHAR(4)
- CD_REPAIR (수선내역코드) — NVARCHAR(28)
- CD_TYPE_AMT_REPAIR (수선비구분코드) — NVARCHAR(4)
- SZ_DEC_ADJUST_RING (반지조정줄임호수) — NUMERIC(19,4)
- SZ_INC_ADJUST_RING (반지조정늘림호수) — NUMERIC(19,4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_SHIP (출하번호) — NVARCHAR(15)
- NO_SEQ_SHIP (출하순번) — INT
- NO_SET (세트번호) — NVARCHAR(10)
- YN_RETURN (반품여부) — NVARCHAR(2)
- QT_RETURN (반품수량) — NUMERIC(19,4)
- NO_SAL_OLD (구판매번호) — NVARCHAR(25)
- NO_SEQ_SAL_OLD (구판매번호순번) — INT
- NO_SAL_ORD_OLD (구주문번호) — NVARCHAR(25)
- NO_SEQ_ORD_SAL_OLD (구주문번호순번) — INT
- CD_OLD_ITEM (구품목코드) — NVARCHAR(20)
- NO_SAL_ORI (원판매번호(거래처)) — NVARCHAR(15)
- NO_SEQ_SAL_ORI (원판매순번(거래처)) — INT
- TX_ENGRAVE1 (각인(사용안함)) — NVARCHAR(20)
- TX_ENGRAVE2 (영업비고) — NVARCHAR(250)
CZ_SAL_ORD (주문)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SAL_ORD (주문번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_MBR (회원번호) — NVARCHAR(20) — Foreign key → CZ_MBR.NO_MBR — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- DT_SAL_ORD (주문일자) — NVARCHAR(8)
- CD_STORE_SAL_ORD (주문매장코드) — NVARCHAR(20)
- CD_STORE_DELV (인도매장코드) — NVARCHAR(20)
- ID_RESPON (담당자사번) — NVARCHAR(15)
- CD_TYPE_SAL_ORD (주문구분코드) — NVARCHAR(4)
- CD_TYPE_EMER (긴급구분코드(미사용)) — NVARCHAR(4)
- DT_SCHE_DELV (인도예정일자(미사용)) — NVARCHAR(8)
- CD_STAT_SAL_ORD (주문상태코드) — NVARCHAR(4)
- CD_ROUTE_VISIT (방문경로코드) — NVARCHAR(4)
- CD_USE_PUR (구매용도코드) — NVARCHAR(4)
- CD_AGE (연령대코드) — NVARCHAR(4)
- YN_MBR (회원여부) — NVARCHAR(2)
- NM_KOR (고객명) — NVARCHAR(50)
- CD_SEX (성별코드) — NVARCHAR(4)
- NO_TEL_HOME1 (자택전화번호1) — NVARCHAR(20)
- NO_TEL_HOME2 (자택전화번호2) — NVARCHAR(4)
- NO_TEL_HOME3 (자택전화번호3) — NVARCHAR(4)
- NO_CELLPHONE1 (휴대전화번호1) — NVARCHAR(20)
- NO_CELLPHONE2 (휴대전화번호2) — NVARCHAR(4)
- NO_CELLPHONE3 (휴대전화번호3) — NVARCHAR(4)
- NO_POST_HOME1 (자택우편번호1) — NVARCHAR(20)
- NO_POST_HOME2 (자택우편번호2) — NVARCHAR(4)
- TX_ADDR_HOME1 (자택주소1) — NVARCHAR(200)
- TX_ADDR_HOME2 (자택주소2) — NVARCHAR(200)
- NO_COUPON (쿠폰번호) — NVARCHAR(30)
- RT_DISC_COUPON (쿠폰할인율) — NUMERIC(19,4)
- AM_DISC_COUPON (쿠폰할인금액) — NUMERIC(19,4)
- AM_RETAIL (소비자금액) — NUMERIC(19,4)
- AM_SAL (판매금액) — NUMERIC(19,4)
- AM_ADVANCE (선수금) — NUMERIC(19,4)
- AM_BALANCE (잔금) — NUMERIC(19,4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL (판매번호) — NVARCHAR(15)
- YN_ORD_BATCH (일괄주문여부) — NVARCHAR(2)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제여부) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- YN_MAKE_BATCH (제작의뢰일괄여부) — NVARCHAR(2)
- CD_PARTNER (거래처코드) — NVARCHAR(20)
- NO_OBT_ORD (수주번호) — NVARCHAR(15)
- DT_CANCEL (취소일자) — NVARCHAR(8)
- ID_CANCEL (취소자) — NVARCHAR(15)
- NO_PROM (프로모션번호) — NVARCHAR(15)
- NO_SAL_ORD_OLD (구주문번호) — NVARCHAR(25)
- DT_SCHE_CUS_DELV (인도예정일) — NVARCHAR(8)
CZ_SAL_ORD_DTL (주문상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SEQ_SAL_ORD (주문일련번호) — INT — Primary key — NOT NULL
- NO_SAL_ORD (주문번호) — NVARCHAR(15) — Foreign key → CZ_SAL_ORD.NO_SAL_ORD — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9)
- SZ_RING (반지호수) — NUMERIC(19,4)
- QT_SAL_ORD (주문수량) — NUMERIC(19,4)
- QT_DELV (납품수량) — NUMERIC(19,4)
- UP_RETAIL (소비자단가) — NUMERIC(19,4)
- RT_DISC (할인율) — NUMERIC(19,4)
- UP_SAL (판매단가) — NUMERIC(19,4)
- AM_SAL (판매금액) — NUMERIC(19,4)
- RT_COMMISSION (수수료율) — NUMERIC(19,4)
- CD_TYPE_SPEC (특수구분코드) — NVARCHAR(4)
- CD_TYPE_EMER (긴급구분코드) — NVARCHAR(4)
- DT_SCHE_DELV (인도예정일자) — NVARCHAR(8)
- CD_REPAIR (수선내역코드) — NVARCHAR(14)
- CD_TYPE_AMT_REPAIR (수선비구분코드) — NVARCHAR(8)
- SZ_DEC_ADJUST_RING (반지조정줄임호수) — NUMERIC(19,4)
- SZ_INC_ADJUST_RING (반지늘림조정호수) — NUMERIC(19,4)
- CD_STAT_DTL_SAL_ORD (주문상세상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL (판매번호) — NVARCHAR(15)
- NO_SEQ_SAL (판매일련번호) — INT
- DT_DELV (인도일자) — NVARCHAR(8)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제여부) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_OBT_ORD (수주번호) — NVARCHAR(15)
- NO_SEQ_OBT_ORD (수주일련번호) — INT
- NO_SET (세트번호(ODD용)) — NVARCHAR(10)
- QT_SAL_ORD_REG (진열주문요청수량) — NUMERIC(19,4)
- NO_SAL_ORD_OLD (구주문번호) — NVARCHAR(25)
- NO_SEQ_SAL_ORD_OLD (구주문번호순번) — NVARCHAR(20)
- DT_CONFIRM (진열주문승인일시) — NVARCHAR(14)
- ID_CONFIRM (진열주문승인자) — NVARCHAR(15)
- TX_ENGRAVE1 (각인) — NVARCHAR(100)
- TX_ENGRAVE2 (영업비고) — NVARCHAR(250)
- DT_SCHE_CUS_DELV (인도예정일) — NVARCHAR(8)
- CD_QUAL_METAL (금속구분) — NVARCHAR(4)
- CD_VENDER (구매처) — NVARCHAR(4)
- WG_QUAL_METAL (WG 금속재질) — NVARCHAR(2)
- WG_PLATING_YN (WG 도금유무) — NVARCHAR(2)
- WG_PLATING_TYPE (도금구분) — NVARCHAR(8)
- AM_LABOR (공임금액) — NUMERIC(19,4)
- DT_SCHE_DELV_WORK (납품예정일(공방)) — NVARCHAR(8)
CZ_STO_PUR (매장입고)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_PUR_STO (매장입고번호) — NVARCHAR(15) — Primary key — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_STORE (매장코드) — NVARCHAR(20)
- ID_PUR (입고자) — NVARCHAR(15)
- DT_PUR (입고일자) — NVARCHAR(8)
- CD_TYPE_PUR (입고구분코드) — NVARCHAR(4)
- CD_STAT_PUR (입고상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- CD_SL (S/L코드) — NVARCHAR(20)
CZ_STO_PUR_DTL (매장입고상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_PUR_STO (매장입고번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SEQ_PUR_STO (매장입고일련번호) — INT — Primary key — NOT NULL
- CD_ITEM (품목코드) — NVARCHAR(9)
- QT_STOCK (재고수량) — NUMERIC(19,4)
- QT_SAL_ORD (주문수량) — NUMERIC(19,4)
- QT_REL (출고수량) — NUMERIC(19,4)
- QT_PUR (입고수량) — NUMERIC(19,4)
- QT_RTN (반품수량) — NUMERIC(19,4)
- QT_PUR_OUTS (미입고수량) — NUMERIC(19,4)
- UP_PUR (입고단가) — NUMERIC(19,4)
- AM_PUR (입고금액) — NUMERIC(19,4)
- CD_STAT_DTL_PUR (입고상세상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15)
- NO_REL (출고번호) — NVARCHAR(15)
- NO_SEQ_REL (출고일련번호) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_PUR_STO_ORG (원매장입고번호(반품)) — NVARCHAR(15)
- NO_SEQ_PUR_STO_ORG (원매장입고번호순번(반품)) — INT
- NO_OUT_OLD (과거출고번호) — NVARCHAR(30)
CZ_SUP (납품)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SUP (납품번호) — NVARCHAR(15) — Primary key — NOT NULL
- CD_BRAND (브랜드코드) — NVARCHAR(4)
- CD_PARTNER (거래처코드) — NVARCHAR(20)
- CD_DEPT (납품부서코드) — NVARCHAR(12)
- ID_SUP (납품자) — NVARCHAR(15)
- DT_SUP (납품일자) — NVARCHAR(8)
- CD_TYPE_SUP (납품구분코드) — NVARCHAR(4)
- CD_STAT_SUP (납품상태코드) — NVARCHAR(4)
- TX_REMAKE (비고) — NVARCHAR(400)
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
CZ_SUP_DTL (납품상세)
- CD_COMPANY (회사코드) — NVARCHAR(7) — Primary key — NOT NULL
- NO_SUP (납품번호) — NVARCHAR(15) — Primary key — NOT NULL
- NO_SEQ_SUP (납품일련번호) — INT — Primary key — NOT NULL
- NO_REQ_MAKE (제작의뢰번호) — NVARCHAR(15)
- CD_ITEM (품목코드) — NVARCHAR(9)
- QT_STOCK (재고수량) — NUMERIC(19,4)
- QT_COMP_MAKE (제작완료수량) — NUMERIC(19,4)
- QT_SUP (납품수량) — NUMERIC(19,4)
- QT_RTN (반품수량) — NUMERIC(19,4)
- QT_SUP_OUTS (미납품수량) — NUMERIC(19,4)
- NU_WEIGHT_SUP (납품중량) — NUMERIC(19,4)
- UP_SUP (납품단가) — NUMERIC(19,4)
- AM_SUP (납품금액) — NUMERIC(19,4)
- CD_STAT_DTL_SUP (납품상세상태코드) — NVARCHAR(4)
- TX_REMARK (비고) — NVARCHAR(400)
- NO_SAL_ORD (주문번호) — NVARCHAR(15)
- NO_SEQ_SAL_ORD (주문일련번호) — INT
- DTS_INSERT (등록일자) — NVARCHAR(14)
- ID_INSERT (등록자) — NVARCHAR(15)
- DTS_UPDATE (수정일자) — NVARCHAR(14)
- ID_UPDATE (수정자) — NVARCHAR(15)
- YN_DELETE (삭제유무) — NVARCHAR(2)
- DTS_DELETE (삭제일자) — NVARCHAR(14)
- ID_DELETE (삭제자) — NVARCHAR(15)
- NO_PUR_MAN (원생산입고번호(반품)) — NVARCHAR(15)
- NO_SEQ_PUR_MAN (원생산입고순번(반품)) — INT
- NO_RECP_DISB_MAN (수불번호(공방생산입고)) — NVARCHAR(20)
- NO_SEQ_RECP_DISB_MAN (수불순번(공방생산입고)) — INT
- QT_RE_MAKE_CMPL (재제작완료수량) — NUMERIC(19,4)
- STONE_CD (스톤코드(미사용)) — NVARCHAR(25)