RINNIS
Tables (50)
ACTION_HIS
- ADMID — VARCHAR2(50)
- ADMIP — VARCHAR2(20) — 유저접속
- ADMURL — VARCHAR2(100) — 유저
- SERVER_IP — VARCHAR2(20) — 서버
- INPUTDATE — TIMESTAMP — NOT NULL — 활동시간
- REQ_PARAM — VARCHAR2(4000) — 파라미터
ACTION_HIS_PRIVACY
- SEQ — NUMBER — Primary key — NOT NULL — 기준번호
- ADMID — VARCHAR2(50)
- ADMIP — VARCHAR2(20) — 유저접속
- ADMURL — VARCHAR2(100) — 유저
- SERVER_IP — VARCHAR2(20) — 서버
- INPUTDATE — TIMESTAMP — NOT NULL — 활동시간
- REQ_PARAM — VARCHAR2(4000) — 파라미터
- EXCEL_YN — CHAR(1) — NOT NULL — 엑셀다운여부
- REASON — VARCHAR2(4000) — 사유
ADDRGPS
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- ORDERNO — VARCHAR2(30) — Primary key — NOT NULL — �ŷ�ó�ֹ���ȣ
- NATIONCODE — VARCHAR2(10) — NOT NULL — �����ڵ�
- ADDR — VARCHAR2(500) — NOT NULL — �ּ�
- LAT — VARCHAR2(50) — ����
- LNG — VARCHAR2(50) — �浵
ADMINMAN
- ADMID — VARCHAR2(20) — Primary key — NOT NULL
- COMPCODE — VARCHAR2(4) — NOT NULL — �ŷ�ó�ڵ�
- PASSWD — VARCHAR2(65) — NOT NULL — �н�����
- ADMNAM — VARCHAR2(50) — NOT NULL — �̸�
- ADMPHONUM — VARCHAR2(30) — ��ȭ��ȣ
- ADMHPNUM — VARCHAR2(30) — �ڵ�����ȣ
- ADMDEP — VARCHAR2(100) — �μ�
- ADMINSDAT — DATE — ������
- OUTYN — CHAR(1) — �ܺ��������뿩��
- STATUS — CHAR(1) — ����(1:����
- ADMEMAIL — VARCHAR2(100) — �̸���
- COMPGBN — VARCHAR2(20) — �ŷ�ó����
- LOCKCOUNT — NUMBER(9,0) — NOT NULL — 비밀번호
- LASTPWDCHANGEDATE — DATE — NOT NULL — 마지막
- AUTHEXCEL — CHAR(1) — NOT NULL — 엑셀다운로드
ADMINMANPRINT
- ADMID — VARCHAR2(20) — Primary key — NOT NULL
- PORTCODE — VARCHAR2(10) — Primary key — NOT NULL — 포트코드
- COMPCODE — VARCHAR2(4) — NOT NULL — 거래처코드
- PRINTNAME — VARCHAR2(100) — 프린트명
- USEYN — CHAR(1) — NOT NULL — 사용여부
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자
- INPUTDATE — DATE — NOT NULL — 등록일시
- UPDATEID — VARCHAR2(20) — 수정자
- UPDATEDATE — DATE — 수정일시
ADMMAILMNG
- MAILGB — VARCHAR2(10) — Primary key — NOT NULL — ���������ڵ�(SYSA00)
- ADMID — VARCHAR2(20) — Foreign key → ADMINMAN.ADMID — NOT NULL
- USEYN — CHAR(1) — ���ſ���
ADMMENMAN
- MNUCOD — VARCHAR2(8) — Primary key — NOT NULL — ���ڵ�
- ADMID — VARCHAR2(20) — Foreign key → ADMINMAN.ADMID — NOT NULL
- INSDAT — DATE — ������
AIRLINECODE
- GBN — VARCHAR2(5) — Primary key — NOT NULL
- CODE — VARCHAR2(10) — Primary key — NOT NULL — A:�װ���
- NAME_K — VARCHAR2(200) — NAME_K
- NAME_E — VARCHAR2(200) — NAME_E
APEXWAYBILLNO
- CNCOURIER — VARCHAR2(10) — Primary key — NOT NULL
- SEQ — NUMBER — Primary key — NOT NULL — SEQ
- CURNUM — VARCHAR2(20) — Primary key — NOT NULL — ������ȣ
- NOTICE — VARCHAR2(300) — ����
- USEYN — CHAR(1) — ��������
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
APIKEYMNG
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- API_GBN — VARCHAR2(20) — Primary key — NOT NULL — API
- SEQ — NUMBER — Primary key — NOT NULL — 순번
- API_KEY — VARCHAR2(500) — API
- API_URL — VARCHAR2(200) — API
- API_TOKEN — VARCHAR2(500) — API
- API_AUTHKEY — VARCHAR2(500) — API
- API_ID — VARCHAR2(50) — API
- API_PW — VARCHAR2(50) — API
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자아이디
- INPUTDATE — DATE — NOT NULL — 등록일시
- NOTICE — VARCHAR2(200)
- BRAND_NAME — VARCHAR2(100)
B2BDETAIL
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- EXORDERNO — VARCHAR2(20) — Primary key — NOT NULL — ��ü�ֹ���ȣ
- SEQ — NUMBER — Primary key — NOT NULL — ����
- DAYTIME — VARCHAR2(20) — NOT NULL — ó���Ͻ�
- DNOTICE — VARCHAR2(1000) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- PRICE — NUMBER — �ݾ�
- VATPRICE — NUMBER — VAT
- PAYTYPE — VARCHAR2(10) — ���걸��
B2BMASTER
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- EXORDERNO — VARCHAR2(20) — Primary key — NOT NULL — ��ü�ֹ���ȣ
- TITLE — VARCHAR2(100) — NOT NULL — ����
- STATUS — VARCHAR2(10) — NOT NULL — ó������(B2BA00)
- PRICE — NUMBER — ���۱ݾ�(���θ�)
- VATPRICE — NUMBER — VAT
- COMADMNAME — VARCHAR2(50) — �����ڸ�
- COMPTELL — VARCHAR2(30) — ��������ȭ
- NOTICE — VARCHAR2(1000) — ����
- CANCELYN — CHAR(1) — NOT NULL — ���ҿ���
- CANCELDATE — DATE — �����Ͻ�
- CANCELID — VARCHAR2(20) — �����ھ��̵�
- CANCELREASON — VARCHAR2(1000) — ���һ���
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — NOT NULL — ���������ھ��̵�
- UPDATEDATE — DATE — NOT NULL — ���������Ͻ�
- STRDATE — DATE — ����������
- ENDDATE — DATE — ����������
B2CHSCODEBLOCK
- HSCODE — VARCHAR2(10) — Primary key — NOT NULL
- INPUTDATE — DATE — NOT NULL — 등록일시
- UPDATEDATE — DATE — 수정일시
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자아이디
- UPDATEID — VARCHAR2(20) — 최종수정자아이디
B2CLABELINFO
- NATION3CODE — VARCHAR2(3) — Primary key — NOT NULL
- SUPPLIER — VARCHAR2(30) — Primary key — NOT NULL — 제공사
- CARRIER — VARCHAR2(30) — Primary key — NOT NULL — 배송사
- NATIONNAME — VARCHAR2(100) — 바뀐값
- LABELSIZE — VARCHAR2(30) — 라벨사이즈
- HOVE — VARCHAR2(30) — 가로/세로
- NOTE — VARCHAR2(100) — 비고
BOARD_QA
- BOANUM — NUMBER — Primary key — NOT NULL
- PARNUM — NUMBER — �����۹�ȣ(��������
- CATCOD — VARCHAR2(10) — �Խ���ī�װ���(BOAA00)
- TITLE — VARCHAR2(100) — NOT NULL — ������
- VIEWCNT — NUMBER — NOT NULL — ����Ƚ��
- SORTNUM — NUMBER — ���ļ���
- SUBCATCOD — VARCHAR2(10) — ����ī�װ���(BOAB00)
- ATTFILE — BLOB — ÷������
- ATTFILENAM — VARCHAR2(100) — ÷�����ϸ�
- POPUPYN — CHAR(1) — �˾�����
- DELYN — CHAR(1) — ��������
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- WRITER — VARCHAR2(50) — NOT NULL — �����ڸ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- PASSWD — VARCHAR2(50) — ���й�ȣ
- TELNO — VARCHAR2(30) — ����ó
- EMAIL — VARCHAR2(200) — �̸���
- LANG — VARCHAR2(10) — �����ڵ�
- COTEXT — CLOB
- IMG — VARCHAR2(200) — 이미지
- THUMIMG — VARCHAR2(200) — 썸네일이미지
- ATTFILE2 — BLOB — 첨부파일2
- ATTFILENAM2 — VARCHAR2(100) — 첨부파일2명
- IMPORTANT_YN — CHAR(1) — 중요여부
- TITLE_EN — VARCHAR2(100) — 글제목(영문)
- COTEXT_EN — CLOB — 글내용(영문)
BOARD_REPLY
- REPLY_ID — NUMBER(10,0) — Primary key — NOT NULL
- BOARD_ID — NUMBER(10,0)
- PARENT_ID — NUMBER(10,0)
- DEPTH — NUMBER(10,0)
- REPLY_CONTENT — CLOB
- REPLY_WRITER — VARCHAR2(100) — NOT NULL
- REPLY_PASSWORD — VARCHAR2(300) — NOT NULL
- REGISTER_DATETIME — DATE
BOARD_TBL
- BNO — NUMBER(10,0)
- TITLE — VARCHAR2(200) — NOT NULL
- CONTENT — VARCHAR2(50)
- WRITER — VARCHAR2(50) — NOT NULL
- REGDATE — DATE
- VIEWCNT — NUMBER(10,0)
BOXINFO
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- PORDERNO — NUMBER — Primary key — NOT NULL — 접수번호
- SEQ — NUMBER — Primary key — NOT NULL — 순번
- BOXSIZE — VARCHAR2(10) — 세금담당자이름
- PPRICE — VARCHAR2(10) — 세금담당자전화
- STANDARD — VARCHAR2(10) — 세금담당자이메일
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자아이디
- INPUTDATE — DATE — NOT NULL — 등록일시
- BOXCOUNT — NUMBER
BUSINESS_FILE
- BOANUM — NUMBER — Primary key — NOT NULL
- ATTFILE — BLOB — 첨부파일
- ATTFILENAM — VARCHAR2(100) — 파일명
B_BOARD
- BOARDNO — NUMBER
- BOARDTITLE — VARCHAR2(50) — NOT NULL
- BOARDCONTENT — VARCHAR2(2000) — NOT NULL
- BOARDWRITER — VARCHAR2(30)
- BOARDRDATE — DATE
B_MEMBER
- MEMBERID — VARCHAR2(30)
- MEMBERPW — VARCHAR2(30) — NOT NULL
- MEMBERNAME — VARCHAR2(30)
- MEMBERNO — NUMBER(*,0)
CAFE24MST
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- EXC_DATE — VARCHAR2(10) — Primary key — NOT NULL — 주문연동일
- EXC_CNT — NUMBER(*,0) — Primary key — NOT NULL — 연동차수
- STRDATE — DATE — NOT NULL — 수집시작시간
- ENDDATE — DATE — NOT NULL — 수집종료시간
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자아이디
- INPUTDATE — DATE — NOT NULL — 등록일시
- MASSEQ — NUMBER — NOT NULL — 기준번호
CAFE24_API_LOG
- INPUTID — VARCHAR2(20) — NOT NULL
- INPUTDATE — TIMESTAMP — NOT NULL — 등록일시
- REQ_PARAM — VARCHAR2(4000) — NOT NULL — 입력
- RES_MSG — CLOB — NOT NULL — 응답
- CALL_METHOD — VARCHAR2(100) — NOT NULL — 호출
- RESULT_MSG — CHAR(1) — NOT NULL — 결과
- COMPCODE — VARCHAR2(4) — NOT NULL — 거래처코드
- MALLID — VARCHAR2(100) — NOT NULL — CAFE24
- CAFE24_API_VERSION — VARCHAR2(20) — NOT NULL — CAFE24
- RES_HEADMSG — VARCHAR2(4000) — 응답
CAFE24_COMPINFO
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- MALLID — VARCHAR2(100) — Primary key — NOT NULL — CAFE24
- CLIENT_ID — VARCHAR2(100) — NOT NULL — API
- CLIENT_SECRET — VARCHAR2(100) — NOT NULL — API
- AUTH_CODE — VARCHAR2(100) — API
- REFRESH_TOKEN — VARCHAR2(100) — API
- INPUTDATE — DATE — NOT NULL — 등록일자
- UPDATEDATE — DATE — 수정일자
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자
- UPDATEID — VARCHAR2(20) — 수정자
- USEYN — CHAR(1) — NOT NULL — 사용여부
- REFRESH_TOKEN_EXPIRES_DATE — DATE — 리프레시토큰
- MALLPW — VARCHAR2(100) — NOT NULL — CAFE24
CAFE24_ORDER
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- MALLID — VARCHAR2(100) — Primary key — NOT NULL — CAFE24
- ORDER_ID — VARCHAR2(30) — Primary key — NOT NULL — 주문번호
- SHOP_NO — NUMBER — 멀티쇼핑몰번호
- CURRENCY — VARCHAR2(10) — NOT NULL — 화폐단위
- MARKET_ID — VARCHAR2(100) — 마켓
- MEMBER_ID — VARCHAR2(100) — 회원아이디
- MEMBER_EMAIL — VARCHAR2(100) — 회원
- PAID — CHAR(1) — 결제
- CANCELED — CHAR(1) — 취소
- ORDER_DATE — VARCHAR2(26) — 주문일
- PAYMENT_DATE — VARCHAR2(26) — 결제일
- PAYMENT_AMOUNT — NUMBER — 최종
- CANCEL_DATE — VARCHAR2(26) — 주문취소일
- COMMISSION — NUMBER — 결제
- POSTPAY — CHAR(1) — 후불결제여부
- ADMIN_ADDITIONAL_AMOUNT — NUMBER — 관리자
- ADDITIONAL_SHIPPING_FEE — NUMBER — 추가
- ADDITIONAL_HANDLING_FEE — NUMBER — 해외배송
- SHIPPING_TYPE — CHAR(1) — 배송
- SHIPPING_TYPE_TEXT — VARCHAR2(100) — 배송
- SHIPPING_STATUS — CHAR(1) — 배송상태
- TOTAL_SUPPLY_PRICE — NUMBER — 총
- MULTIPLE_ADDRESSES — CHAR(1) — 멀티
- EXCHANGE_RATE — VARCHAR2(100) — 결제
- TOTAL_DISCOUNT_AMOUNT — NUMBER — 총
- PROCESS_STATUS — VARCHAR2(10) — 주문상태
- RECEIVERS_NAME — VARCHAR2(100) — NOT NULL — 수령자명
- RECEIVERS_NAME_FURIGANA — VARCHAR2(100) — NOT NULL — 수령자명
- RECEIVERS_PHONE — VARCHAR2(100) — NOT NULL — 전화번호
- RECEIVERS_CELLPHONE — VARCHAR2(100) — 수령자
- RECEIVERS_VIRTUAL_PHONE_NO — VARCHAR2(100) — 수령자
- RECEIVERS_ZIPCODE — VARCHAR2(30) — NOT NULL — 수령자
- RECEIVERS_ADDRESS1 — VARCHAR2(300) — NOT NULL — 수령자
- RECEIVERS_ADDRESS2 — VARCHAR2(300) — 수령자
- RECEIVERS_ADDRESS_STATE — VARCHAR2(100) — 주/도
- RECEIVERS_ADDRESS_CITY — VARCHAR2(100) — 시/군/도시
- RECEIVERS_ADDRESS_STREET — VARCHAR2(100) — 도로명
- RECEIVERS_ADDRESS_FULL — VARCHAR2(500) — NOT NULL — 전체주소
- RECEIVERS_NAME_EN — VARCHAR2(100) — 수령자명
- RECEIVERS_CITY_EN — VARCHAR2(100) — 수령자
- RECEIVERS_STATE_EN — VARCHAR2(100) — 수령자
- RECEIVERS_STREET_EN — VARCHAR2(100) — 수령자
- RECEIVERS_COUNTRY_CODE — CHAR(2) — NOT NULL — 국가코드
- RECEIVERS_COUNTRY_NAME — VARCHAR2(100) — 국가명
- RECEIVERS_COUNTRY_NAME_EN — VARCHAR2(100) — 국가명
- RECEIVERS_INFORMATION_TYPE — CHAR(1) — 통관정보
- RECEIVERS_INFORMATION — VARCHAR2(100) — 통관정보
- RECEIVERS_SHIPPING_CODE — VARCHAR2(100) — 배송번호
- API_VER — VARCHAR2(10) — NOT NULL — API
- BUYER_MEMBER_ID — VARCHAR2(100) — 회원아이디
- BUYER_MEMBER_GROUP_NO — VARCHAR2(100) — 주문당시
- BUYER_NAME — VARCHAR2(100) — NOT NULL — 주문자명
- BUYER_NAMES_FURIGANA — VARCHAR2(100) — 주문자
- BUYER_EMAIL — VARCHAR2(100) — 주문자
- BUYER_PHONE — VARCHAR2(20) — NOT NULL — 주문자
- BUYER_CELLPHONE — VARCHAR2(20) — NOT NULL — 주문자
- BUYER_CUSTOMER_NOTIFICATION — VARCHAR2(100) — 고객
- BUYER_UPDATED_DATE — VARCHAR2(26) — 수정일
- BUYER_USER_ID — VARCHAR2(100) — 주문자
- … +9
CAFE24_ORDER_ITEM
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- ORDER_ID — VARCHAR2(30) — Primary key — NOT NULL — 주문번호
- MALLID — VARCHAR2(100) — Primary key — NOT NULL — CAFE24
- ITEM_NO — NUMBER(38,0) — 품주
- ORDER_ITEM_CODE — VARCHAR2(30) — 품주코드
- VARIANT_CODE — VARCHAR2(30) — NOT NULL — 품목코드
- PRODUCT_NO — NUMBER(38,0) — NOT NULL — 상품번호
- PRODUCT_CODE — VARCHAR2(30) — NOT NULL — 상품코드
- CUSTOM_PRODUCT_CODE — VARCHAR2(120) — NOT NULL — 자체상품
- CUSTOM_VARIANT_CODE — VARCHAR2(100) — 자체
- ENG_PRODUCT_NAME — VARCHAR2(400) — 영문
- PRODUCT_NAME — VARCHAR2(800) — NOT NULL — 상품명
- PRODUCT_NAME_DEFAULT — VARCHAR2(800) — NOT NULL — 기본
- PRODUCT_PRICE — NUMBER(38,0) — NOT NULL — 상품
- OPTION_PRICE — NUMBER(38,0) — NOT NULL — 옵션
- QUANTITY — NUMBER — NOT NULL — 수량
- PRODUCT_TAX_TYPE — CHAR(1) — 상품
- TAX_RATE — NUMBER — 과세율
- SUPPLIER_PRODUCT_NAME — VARCHAR2(100) — 공급사
- SUPPLIER_TRANSACTION_TYPE — CHAR(1) — 공급사
- ORDER_STATUS — VARCHAR2(100) — 주문상태
- STATUS_CODE — CHAR(2) — 현재
- STATUS_TEXT — VARCHAR2(100) — 현재
- BUNDLED_SHIPPING_TYPE — CHAR(1) — 묶음배송
- STORE_PICKUP — VARCHAR2(100) — 매장수령여부
- ORDERED_DATE — VARCHAR2(26) — 주문일
- PRODUCT_MATERIAL — VARCHAR2(100) — 상품소재
- PRODUCT_MATERIAL_ENG — VARCHAR2(100) — 영문
- CLOTH_FABRIC — VARCHAR2(100) — 옷감
- PRODUCT_WEIGHT — VARCHAR2(100) — 상품의
- VOLUME_SIZE — VARCHAR2(100) — 상품
- VOLUME_SIZE_WEIGHT — VARCHAR2(100) — 상품
- CLEARANCE_CATEGORY — VARCHAR2(100) — 해외통관용
- CLEARANCE_CATEGORY_INFO — VARCHAR2(100) — 해외통관용
- CLEARANCE_CATEGORY_CODE — VARCHAR2(100) — 해외통관코드
- HS_CODE — VARCHAR2(100) — NOT NULL — HS코드
- ONE_PLUS_N_EVENT — VARCHAR2(100) — 1+N이벤트
- ORIGIN_PLACE — VARCHAR2(100) — 원산지정보
- ORIGIN_PLACE_NO — VARCHAR2(100) — 원산지
- MADE_IN_CODE — VARCHAR2(100) — 원산지
- ORIGIN_PLACE_VALUE — VARCHAR2(100) — 원산지기타정보
- GIFT — CHAR(1) — 사은품
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자ID
- INPUTDATE — DATE — NOT NULL — 등록일시
- PAYMENT_AMOUNT — NUMBER — 최종결제금액
- FINAL_PAYMENT_AMOUNT — NUMBER — NOT NULL — 최종결제금액(할인
- ADDITIONAL_DISCOUNT_PRICE — NUMBER — 상품추가할인액
- COUPON_DISCOUNT_PRICE — NUMBER — 상품별
- APP_ITEM_DISCOUNT_AMOUNT — NUMBER — 앱
CAFE24_SHOP
- COMPCODE — VARCHAR2(20) — Primary key — NOT NULL
- MALLID — VARCHAR2(100) — Primary key — NOT NULL — CAFE24
- SHOP_NO — NUMBER — Primary key — NOT NULL — 멀티쇼핑몰
- DEFAULT_TF — CHAR(1) — 기본샵
- SHOP_NAME — VARCHAR2(765) — NOT NULL — 쇼핑몰명
- BUSINESS_COUNTRY_CODE — CHAR(2) — 사업자
- LANGUAGE_CODE — VARCHAR2(10) — 언어
- LANGUAGE_NAME — VARCHAR2(60) — 기본
- CURRENCY_CODE — VARCHAR2(4) — 결제
- CURRENCY_NAME — VARCHAR2(100) — 결제
- REFERENCE_CURRENCY_CODE — VARCHAR2(100) — 참조
- REFERENCE_CURRENCY_NAME — VARCHAR2(100) — 참조
- BASE_DOMAIN — VARCHAR2(189) — 기본제공
- PRIMARY_DOMAIN — VARCHAR2(189) — 대표도메인
- ACTIVE — CHAR(1) — 활성화
- USE_REFERENCE_CURRENCY — CHAR(1) — 참조화폐
- INPUTID — VARCHAR2(20) — NOT NULL — 등록자ID
- INPUTDATE — DATE — NOT NULL — 등록일자
- UPDATEID — VARCHAR2(20) — 최종수정자ID
- UPDATEDATE — DATE — 최종수정일자
CAS_BARCODE_IN
- SEQ — NUMBER — Primary key — NOT NULL
- BARCODE1 — VARCHAR2(50) — Primary key — NOT NULL
- BARCODE2 — VARCHAR2(50) — Primary key — NOT NULL
- BARCODE3 — VARCHAR2(50) — Primary key — NOT NULL
- BARCODE4 — VARCHAR2(50) — Primary key — NOT NULL
- BARCODE5 — VARCHAR2(50) — Primary key — NOT NULL
- BLENGTH — NUMBER(10,3) — NOT NULL
- WLENGTH — NUMBER(10,3) — NOT NULL
- HLENGTH — NUMBER(10,3) — NOT NULL
- REALWEIGHT — NUMBER(10,3) — NOT NULL
- ETC1 — VARCHAR2(50)
- ETC2 — VARCHAR2(50)
- ETC3 — VARCHAR2(50)
- EXORDERNOYN — CHAR(1) — NOT NULL
- INPUTDATE — DATE — NOT NULL
CAS_BARCODE_INPUT
- EXORDERNO — VARCHAR2(20) — Primary key — NOT NULL — 자체
- BARCODE1 — VARCHAR2(50) — NOT NULL — 바코드1
- BARCODE2 — VARCHAR2(50) — NOT NULL — 바코드2
- BARCODE3 — VARCHAR2(50) — NOT NULL — 바코드3
- BARCODE4 — VARCHAR2(50) — NOT NULL — 바코드4
- BARCODE5 — VARCHAR2(50) — NOT NULL — 바코드5
- BLENGTH — NUMBER(10,3) — NOT NULL — 높이
- WLENGTH — NUMBER(10,3) — NOT NULL — 세로
- HLENGTH — NUMBER(10,3) — NOT NULL — 가로
- REALWEIGHT — NUMBER(10,3) — NOT NULL — 실중량
- INPUTDATE — DATE — NOT NULL — 등록일시
- UPDATEDATE — DATE — 수정일시
CATEGORYMASTER
- CATEGORYCODE — VARCHAR2(10) — Primary key — NOT NULL
- CATEGORYKNM — VARCHAR2(50) — NOT NULL — ī�װ�����(��)
- CATEGORYENM — VARCHAR2(50) — ī�װ�����(��)
- CATEGORYCNM — VARCHAR2(50) — ī�װ�����(��)
- DUTYRATIO — VARCHAR2(10) — ������
- LIMITAMT — VARCHAR2(10) — ���Ѵܰ�
- USEYN — CHAR(1) — ��������
- NOTICE — VARCHAR2(200) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
CHANGEADDR
- WAYBILLNO — VARCHAR2(20) — Primary key — NOT NULL
- INPUTID — VARCHAR2(20) — �����ھ��̵�
- INPUTDATE — DATE — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
CLEARANCEMST
- EXORDERNO — VARCHAR2(20) — Primary key — NOT NULL
- STATUS — VARCHAR2(10) — NOT NULL — ��������
- TRACKCODE — VARCHAR2(20) — ���Ϲ�ȣ
- CUSTMOSDUTY — VARCHAR2(20) — ����
- RETCODE — VARCHAR2(20) — NOT NULL — �����ڵ�
- RETMSG — VARCHAR2(300) — ��������
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
CLEARANCETRC
- TRACKCODE — VARCHAR2(20) — Primary key — NOT NULL
- DAYTIME — VARCHAR2(20) — Primary key — NOT NULL — �����ð�
- TRACE — VARCHAR2(500) — ���۳���
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
CNNATIONMST
- CSCODE — VARCHAR2(5) — Primary key — NOT NULL
- NSCODE — VARCHAR2(5) — ��ǰ�˻��ڵ�
- ISOCODE — VARCHAR2(5) — ISOCODE
- CNAME — VARCHAR2(200) — �߹���
- KNAME — VARCHAR2(200) — �ѱ۸�
- ENAME — VARCHAR2(200) — ������
CNTAXERROR
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- EXORDERNO — VARCHAR2(20) — Primary key — NOT NULL — ��ü�ֹ���ȣ
- MVIEW — CHAR(1) — NOT NULL — ����Ȯ�ο���
- ACTYN — CHAR(1) — NOT NULL — ó������
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
CNTAXMASTER
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- TAMT — NUMBER — ������Ʈ
CNTAXSAVE
- INSEQ — NUMBER — Primary key — NOT NULL
- COMPCODE — VARCHAR2(4) — Foreign key → CNTAXMASTER.COMPCODE — NOT NULL — �ŷ�ó�ڵ�
- SAVEAMT — NUMBER — NOT NULL — �Աݾ�
- SAVEDATE — DATE — NOT NULL — �����Ͻ�
- SAVEGBN — VARCHAR2(10) — ��������(PNTA00)
- SAVENAME — VARCHAR2(20) — �Ա��ڸ�
- FINCOMP — VARCHAR2(30) — ��������
- FINNUMBER — VARCHAR2(30) — ī��
- ACCOUNTNUMBER — VARCHAR2(30) — ���ι�ȣ
- PGNUMBER — VARCHAR2(30) — PG�ڵ�
- ACCOUNTDATE — VARCHAR2(20) — �����Ͻ�
- NOTICE — VARCHAR2(1000) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- PAYSEQ — VARCHAR2(20)
CNTAXUSE
- USESEQ — NUMBER — Primary key — NOT NULL
- COMPCODE — VARCHAR2(4) — Foreign key → CNTAXMASTER.COMPCODE — NOT NULL — �ŷ�ó�ڵ�
- PRICE — NUMBER — NOT NULL — �ֹ��ݾ�
- USEAMT — NUMBER — ���μ���
- USEDATE — DATE — NOT NULL — �����Ͻ�
- EXORDERNO — VARCHAR2(20) — ��ü�ֹ���ȣ
- NOTICE — VARCHAR2(1000) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
COMCODMAN
- COD — VARCHAR2(6) — Primary key — NOT NULL
- PARCOD — VARCHAR2(6) — �����ڵ�
- CODKNM — VARCHAR2(200) — NOT NULL — �ڵ��̸�
- ORDNUM — NUMBER(*,0) — ����
- CODDES — VARCHAR2(200) — �ڵ弳��
- CODENM — VARCHAR2(200)
- CODCNM — VARCHAR2(200)
COMPEXCEL
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- FORMSEQ — NUMBER — Primary key — NOT NULL — ������
- COLSEQ — NUMBER(*,0) — Primary key — NOT NULL — �÷�����
- FORMNAME — VARCHAR2(50) — NOT NULL — ����Ī
- CELLID — VARCHAR2(5) — ��ID
- CELLNUM — NUMBER(*,0) — ������
- CELLNAME — VARCHAR2(100) — NOT NULL — ����Ī
- CELLVALUE — VARCHAR2(20) — NOT NULL — DB
- DEFVALUE — VARCHAR2(50) — �⺻��
- REQUIED — CHAR(1) — NOT NULL — �ʼ�����
- NOTICE — VARCHAR2(200) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- CELLNAMEC — VARCHAR2(100) — ����Ī(��)
- CELLNAMEE — VARCHAR2(100) — ����Ī(��)
COMPMASTER
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- COMPNAME — VARCHAR2(50) — NOT NULL — �ŷ�ó��
- COMPGBN — VARCHAR2(10) — NOT NULL — �ŷ�ó�����ڵ�(COPA00)
- PARCOMP — VARCHAR2(4) — �����ŷ�ó�ִ°���
- COPREGNUM — VARCHAR2(20) — NOT NULL — �����ڹ�ȣ
- COMADMNAME — VARCHAR2(50) — NOT NULL — �����ڸ�
- CEONAME — VARCHAR2(50) — NOT NULL — ��ǥ�ڸ�
- COMPHONE — VARCHAR2(30) — NOT NULL — ��ǥ��ȭ
- COMPTELL — VARCHAR2(30) — ��������ȭ
- COMPFAX — VARCHAR2(30) — FAX
- COMPZIP — VARCHAR2(10) — ������������ȣ
- COMPADDR1 — VARCHAR2(300) — �������ּ�1
- COMPADDR2 — VARCHAR2(300) — �������ּ�2
- PACKZIP — VARCHAR2(10) — ����ó������ȣ
- PACKADDR1 — VARCHAR2(300) — ����ó�ּ�1
- PACKADDR2 — VARCHAR2(300) — ����ó�ּ�2
- CONZIP — VARCHAR2(10) — ���꼭������ȣ
- CONADDR1 — VARCHAR2(300) — ���꼭�ּ�1
- CONADDR2 — VARCHAR2(300) — ���꼭�ּ�2
- USEYN — CHAR(1) — ���뿩��
- STRDATE — DATE — NOT NULL — ����������
- ENDDATE — DATE — ��������������
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- NOTICE — VARCHAR2(1000)
- EMSRATIO — NUMBER
- DHLRATIO — NUMBER
- PAYPERIOD — VARCHAR2(10) — ������������(COPB00)
- COMPEMAIL — VARCHAR2(100) — �������̸���
- LO_PRICE1 — VARCHAR2(20) — ����
- LO_PRICE2 — VARCHAR2(20) — ����
- LO_PRICE3 — VARCHAR2(20) — ����
- COMPENAME — VARCHAR2(50) — �ŷ�ó��(��)
- COMPINGBN — VARCHAR2(10) — ���Ա���(COPD00)
- MEMNUM — VARCHAR2(10) — ȸ���ڵ�
- HANDPHONE — VARCHAR2(30) — �ڵ�����ȣ
- HOMEPAGEURL — VARCHAR2(200) — Ȩ�������ּ�
- SALERCODE — VARCHAR2(10) — ������
- SALERATIO — NUMBER(4,2) — �������ΰ���
- TNTRATIO — NUMBER — TNT������
- CURRENCY — VARCHAR2(10)
- SETTLECOMPCODE — VARCHAR2(20) — �����ŷ�ó�ڵ�
- SETTLEGBN — VARCHAR2(10) — ����/���Ա���
- SETTLECOST — VARCHAR2(10) — �����ڵ�
- CONCITY — VARCHAR2(100) — ���ø�
- CORPHAND — VARCHAR2(70)
- LINE — VARCHAR2(40)
- EVENT — VARCHAR2(40)
- SALESMAN — VARCHAR2(30)
- PAYMENTCOD — VARCHAR2(10)
- B2CWEIGHT — VARCHAR2(10)
- B2BWEIGHT — VARCHAR2(10)
- KOREAYN — VARCHAR2(2)
- CUSTYN — CHAR(1)
- ERPCODE — VARCHAR2(20)
- COMPCOPCOD — VARCHAR2(10)
- SELLERID — VARCHAR2(50)
- Q10USERID — VARCHAR2(50)
- … +5
COMPPAYMENT
- SEQ — NUMBER — Primary key — NOT NULL — ����
- COMPCODE — VARCHAR2(4) — Foreign key → COMPMASTER.COMPCODE — NOT NULL
- PAYMETHOD — VARCHAR2(10) — NOT NULL — ��������(COPE00)
- PAYCOMP — VARCHAR2(10) — ī����(CARD00)
- PAYCOMPNAME — VARCHAR2(30) — ī������
- ACCNUM — VARCHAR2(20) — ī����ȣ
- CARDRY — VARCHAR2(4) — ��ȣ����
- CARDRM — VARCHAR2(2) — ��ȿ��
- CARDCVC — VARCHAR2(5) — cvc
- PAYNOTICE — VARCHAR2(200) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
COMPSERVICE
- SERVICECODE — VARCHAR2(10) — Primary key — NOT NULL — �������ڵ�
- COMPCODE — VARCHAR2(4) — Foreign key → COMPMASTER.COMPCODE — NOT NULL
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- DISRATE — NUMBER
- UPRATE — NUMBER — FSC(����������)
- MAPPINGTXT — VARCHAR2(100) — �ֹ����θ�
- WEIGHTCKYN — CHAR(1) — NOT NULL
COMPTAMNG
- SEQ — NUMBER — Primary key — NOT NULL — ����
- COMPCODE — VARCHAR2(4) — Foreign key → COMPMASTER.COMPCODE — NOT NULL
- TAXNAME — VARCHAR2(50) — ���ݴ������̸�
- TAXPHONE — VARCHAR2(30) — ���ݴ�������ȭ
- TAXEMAIL — VARCHAR2(100) — ���ݴ������̸���
- TAXNOTICE — VARCHAR2(200) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
COMPWMSEXCEL
- FORMSEQ — NUMBER — Primary key — NOT NULL — ������
- COLSEQ — NUMBER(*,0) — Primary key — NOT NULL — �÷�����
- COMPCODE — VARCHAR2(4) — Foreign key → COMPMASTER.COMPCODE — NOT NULL
- FORMNAME — VARCHAR2(50) — NOT NULL — ����Ī
- CELLID — VARCHAR2(5) — ��ID
- CELLNUM — NUMBER(*,0) — ������
- CELLNAME — VARCHAR2(100) — NOT NULL — ����Ī(��)
- CELLNAMEC — VARCHAR2(100) — ����Ī(��)
- CELLNAMEE — VARCHAR2(100) — ����Ī(��)
- CELLVALUE — VARCHAR2(20) — NOT NULL — DB
- DEFVALUE — VARCHAR2(50) — �⺻��
- REQUIED — CHAR(1) — NOT NULL — �ʼ�����
- NOTICE — VARCHAR2(200) — ����
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
COSBRAND
- COMPCODE — VARCHAR2(4) — Primary key — NOT NULL
- BRANDCODE — VARCHAR2(20) — Primary key — NOT NULL — �ŷ�ó���귣���ڵ�
- BRANDCNM — VARCHAR2(100) — �귣����(��)
- BRANDENM — VARCHAR2(100) — �귣����(��)
- K_INYN — CHAR(1) — KTNET
- K_INDATE — DATE — KTNET
- C_BRANDCODE — VARCHAR2(20) — �ذ����Ϻ귣���ڵ�
- C_INYN — CHAR(1) — �ذ����Ͽ���
- C_INDATE — DATE — �ذ������Ͻ�
- C_RCODE — VARCHAR2(20) — �ذ���û�����ڵ�
- C_RMENT — VARCHAR2(300) — �ذ���û������Ʈ
- USEYN — CHAR(1) — ���뿩��
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- C_RMSG — VARCHAR2(300)
COSCOMPMST
- COMPCODE — VARCHAR2(4) — Foreign key → COMPMASTER.COMPCODE — NOT NULL
- TRCOMPCODE — VARCHAR2(20) — NOT NULL — ������ü�ڵ�
- TRADECODE — VARCHAR2(10) — �����÷����ο��ѱ��������ڵ�
- ABROADCONAME — VARCHAR2(200) — ������Ī
- ABROADLOWMAN — VARCHAR2(50) — ���δ�ǥ
- ABROADADDR — VARCHAR2(500) — �ּ�
- LAWMAN — VARCHAR2(20) — ��ǥ�ڸ�
- LAWMANTEL — VARCHAR2(20) — ��ǥ��ȭ
- ORGNO — VARCHAR2(20) — �ſ�����ȣ
- SITENAME — VARCHAR2(50) — ����Ʈ��Ī
- URL — VARCHAR2(200) — ����ƮURL
- EBUSIFOODTYPE — CHAR(2) — ��ǰ����
- BUSSCOPE — VARCHAR2(500) — �ֿ���ǰ����
- C_INYN — CHAR(1) — �ذ����Ͽ���
- C_INDATE — DATE — �ذ������Ͻ�
- C_RCODE — VARCHAR2(20) — �ذ���û�����ڵ�
- C_RMENT — VARCHAR2(300) — �ذ���û������Ʈ
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- C_RMSG — VARCHAR2(300)
COSITEMMST
- ITEMCODE — VARCHAR2(30) — Primary key — NOT NULL — ��ü����ǰ�ڵ�
- COMPCODE — VARCHAR2(4) — Foreign key → COSBRAND.COMPCODE — NOT NULL
- BRANDCODE — VARCHAR2(20) — Foreign key → COSBRAND.BRANDCODE — NOT NULL — �귣���ڵ�
- ITEM_NM — VARCHAR2(400) — ��ǰ��(��)
- ITEM_NM_CN — VARCHAR2(400) — NOT NULL — ��ǰ��(��)
- ITEM_NM_EN — VARCHAR2(400) — NOT NULL — ��ǰ��(��)
- MODEL_NM — VARCHAR2(400) — NOT NULL — ��(��)
- STANDARD — VARCHAR2(50) — NOT NULL — ��
- PRDNOTI — VARCHAR2(400) — NOT NULL — ��ǰ���ܼ���
- ORIGINNATION — VARCHAR2(5) — NOT NULL — ������(iso�ڵ�)
- FUNCTION — VARCHAR2(400) — NOT NULL — ��ǰ����
- PURPOSE — VARCHAR2(400) — NOT NULL — ��ǰ�뵵
- INGREDIENT — VARCHAR2(400) — NOT NULL — ��ǰ����
- HSCOD — VARCHAR2(20) — NOT NULL — HS�ڵ�
- WUNIT — VARCHAR2(10) — NOT NULL — �߷�����
- CUNIT — VARCHAR2(10) — NOT NULL — ��������
- PRICE_RMB — VARCHAR2(20) — NOT NULL — �ܰ�
- V_WEIGHT — VARCHAR2(10) — NOT NULL — ��������
- WEIGHT — VARCHAR2(7) — NOT NULL — ���߷�
- K_INYN — CHAR(1) — NOT NULL — KTNET
- K_INDATE — DATE — KTNET
- C_INYN — CHAR(1) — NOT NULL — �ذ����Ͽ���
- C_INDATE — DATE — �ذ������Ͻ�
- C_RCODE — VARCHAR2(20) — �ذ���û�����ڵ�
- C_RMENT — VARCHAR2(300) — �ذ���û������Ʈ
- C_DECLARENO — VARCHAR2(50) — �ذ������ڵ�
- C_CUSTRATIO — VARCHAR2(10) — �ذ�����
- USEYN — CHAR(1) — ���뿩��
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
- UPDATEID — VARCHAR2(20) — ���������ھ��̵�
- UPDATEDATE — DATE — ���������Ͻ�
- C_RMSG — VARCHAR2(300)
- H_DECLARENO — VARCHAR2(50) — ���ذ��������ڵ�
- H_INYN — CHAR(1) — ���ذ������Ͽ���
- H_RMSG — VARCHAR2(300) — ���ذ����ɻ�����
- CARGOCODE — NUMBER — ���ذ����Ű���ȣ
COSRECVHIS
- SEQ — NUMBER — Primary key — NOT NULL
- VERSION — VARCHAR2(10) — ��������
- COMMITTIME — VARCHAR2(20) — �����ð�
- SERIALNUMBER — VARCHAR2(32) — �Ϸù�ȣ
- COCODE — VARCHAR2(10) — �����ڵ�
- APPRMAN — VARCHAR2(50) — �ɻ���
- ORGCODE — VARCHAR2(20) — ���������ڵ�
- APPRTYPE — VARCHAR2(10) — �ɻ繮������
- TRADECODE — VARCHAR2(20) — ���������ڵ�
- BRANDID — VARCHAR2(10) — �귣�����Ϲ�ȣ(C_BRANDCODE)
- CARGOCROSSID — VARCHAR2(30) — ��ǰ���Ϲ�ȣ
- BRANDCODE — VARCHAR2(30) — �귣���ڵ�
- CODEID — VARCHAR2(30) — ��ü����ǰ�ڵ�(ITEMCODE)
- APPRRTN — VARCHAR2(10) — �ɻ�����
- APPRADVICE — VARCHAR2(300) — �ɻ��ǰ�
- APPRTIME — VARCHAR2(20) — �ɻ��ð�
- SP1 — VARCHAR2(255) — Ȯ��1
- SP2 — VARCHAR2(255) — Ȯ��2
- SP3 — VARCHAR2(255) — Ȯ��3
- EDATA — CLOB — ��������
- SIGNMSG — VARCHAR2(100) — ��������
- INPUTDATE — DATE — NOT NULL — �����Ͻ�
COSSENDHIS
- SERIALNUMBER — VARCHAR2(30) — Primary key — NOT NULL
- COMPCODE — VARCHAR2(4) — �ŷ�ó�ڵ�
- BRANDCODE — VARCHAR2(20) — �귣���ڵ�
- ITEMCODE — VARCHAR2(30) — ��ü����ǰ�ڵ�
- APPRTYPE — VARCHAR2(10) — �ɻ繮������
- EDATA — CLOB — �۽�����
- SIGNMSG — VARCHAR2(100) — ��������
- INPUTID — VARCHAR2(20) — NOT NULL — �����ھ��̵�
- INPUTDATE — DATE — NOT NULL — �����Ͻ�