ERP

Tables (12)

ACCOUNTS (거래처)

  • ACCOUNTS (거래처 ID) — Primary key — NOT NULL
  • Field (거래처)
  • Field (거래처 번호)
  • Field (상호)
  • Field (거래처종류)
  • Field (국가)
  • Field (웹발주통화구분)
  • Field2 (부가세구분)
  • Field3 (B2C/B2B구분)

DIRECT_OUTBOUNDS (직출고(국내업체))

  • Key (직출고 ID) — Primary key — NOT NULL
  • WHS_ID (창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • ACCOUNTS (거래처 ID) — Foreign key → ACCOUNTS.ACCOUNTS — NOT NULL
  • Field (거래명세서번호)
  • Field2 (거래명세서일)
  • Field3 (Local구분)
  • Field (출고구분)
  • Field2 (부서)
  • Field3 (담당자)
  • Field (판매기준가)
  • Field (수량)
  • Field2 (부가세포함)
  • Field (통화)
  • Field2 (환율)
  • Field (판매단가)
  • Field2 (판매금액)

ETC_OUTBOUND_ITEMS (기타출고품목조회(결산)_craver)

  • Key — Primary key — NOT NULL
  • WHS_ID (창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • ACCOUNTS (거래처 ID) — Foreign key → ACCOUNTS.ACCOUNTS — NOT NULL
  • Field (출고번호)
  • Field2 (출고일)
  • Field3 (수량)
  • Field4 (기타출고구분)
  • Field5 (처리부서)
  • Field (담당자)
  • Field2 (사용부서)

EXPORT_INVOICE_ITEMS (수출Invoice품목조회_craver)

  • Key — Primary key — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • WHS_ID (창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • Field (출고처리)
  • Field (Invoice No.)
  • Field2 (Invoice관리번호)
  • Field3 (Invoice Date)
  • Field4 (수출구분)
  • Field (출고구분)
  • Field (가격조건)
  • Field (부서)
  • Field2 (담당자)
  • Field (Buyer)
  • Field2 (Agent)
  • Field (통화)
  • Field (환율)
  • Field2 (판매기준가)
  • Field (판매단가)
  • Field2 (수량)
  • Field (판매금액)
  • Field2 (원화판매금액)
  • Field (기타출고구분)
  • Field2 (진행상태)
  • Field (매출진행상태)
  • Field2 (매출대상)
  • Field (매출금액계)
  • Field2 (미매출금액)
  • Field (반품)
  • Field2 (P/O No.)

MATERIALS (자재조회)

  • MATERIAL_ID (자재 ID) — Primary key — NOT NULL
  • Field (자재명)
  • Field2 (자재번호)
  • Field3 (규격)
  • Field4 (품목자산분류)
  • Field5 (기준단위)
  • Field6 (자재상태)
  • Field7 (내외자구분)
  • Field8 (중요도)
  • Field9 (관리부서)
  • Field10 (관리자)
  • Field11 (자재대분류)
  • Field (자재중분류)
  • Field2 (자재소분류)
  • Field3 (영문명)
  • Field (출고구분)
  • Field2 (대표자재)
  • Field3 (BOM등록)
  • Field (제품별공정소요자재)
  • Field (Lot 관리)
  • Field2 (Serial 관리)
  • Field3 (단가등록여부)
  • Field4 (유통기한구분)
  • Field (유통기간)
  • Field (부가세구분)
  • Field2 (판매단가에 부가세포함여부)
  • Field (舊 SCM코드)
  • Field2 (바코드(88코드)(소모품류))
  • Field4 (OEM코드)

OUTSOURCING_MATERIAL_USAGES (외주자재투입조회)

  • Key (외주자재투입 ID) — Primary key — NOT NULL
  • Field (외주입고번호)
  • Field2 (외주입고일)
  • Field3 (외주거래처)
  • Field4 (납품반품구분)
  • Field5 (작업지시번호)
  • Field (외주품명)
  • Field2 (외주품번호)
  • Field (자재명)
  • Field2 (자재번호)
  • Field (자재규격)
  • Field (단위)
  • Field (투입수량)
  • MATERIAL_ID (자재 ID) — Foreign key → MATERIALS.MATERIAL_ID — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL

PRODUCTS (품목조회)

  • PROD_ID (상품 ID) — BIGINT(11) — Primary key — NOT NULL
  • PROD_NAME (품명) — VARCHAR(255)
  • PROD_NUM (품번) — VARCHAR(255)
  • Field (규격)
  • Field (품목자산분류)
  • Field (기준단위)
  • Field (품목상태)
  • Field (내외자구분)
  • Field (중요도)
  • Field (관리부서)
  • Field2 (관리자)
  • Field (품목대분류)
  • Field2 (품목중분류)
  • Field3 (품목소분류)
  • Field (영문명)
  • Field (출고구분)
  • Field (대표품목)
  • Field (세트품목)
  • Field2 (BOM등록)
  • Field3 (제품별공정소요자재)
  • Field4 (Lot 관리)
  • Field (Serial 관리)
  • Field (유통기한구분)
  • Field2 (유통기간)
  • Field (부가세구분)
  • Field (판매단가에 부가세포함여부)
  • Field (유통기한(개월수))
  • Field (바코드(88코드))
  • Field2 (브랜드)
  • Field (인박스 입수량)
  • Field2 (아웃박스 입수량)
  • Field (대표품목(조회물용))
  • Field (舊 SCM코드)
  • Field (88파생코드)
  • Field (MASTER)
  • Field (HSCODE)

SET_ITEMS (세트구성품조회)

  • Key — Primary key — NOT NULL
  • PROD_ID (세트 상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • PROD_ID (구성품 상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • Field (구성품수량)
  • Field2 (단가 비율)
  • Field3 (기본창고)

STOCK_LEVELS (가용재고조회_craver)

  • Key — Primary key — NOT NULL
  • WHS_ID (창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • Field (현재고)
  • Field2 (입고예정)
  • Field3 (출고예정)
  • Field4 (안전재고)
  • Field (가용재고)
  • Field2 (통합재고)
  • Field3 (표준원가)
  • Field (가용재고금액)
  • Field2 (통합재고금액)
  • Field3 (입고예정_구매발주)
  • Field (입고예정_적송요청)
  • Field2 (입고예정_기타입고요청)
  • Field3 (입고예정_외주발주)
  • Field4 (입고예정_입고예정계)
  • Field5 (출고예정_출하의뢰/수출출하의뢰)
  • Field6 (출고예정_적송요청)
  • Field (출고예정_기타출고요청)
  • Field2 (출고예정_출고예정계)

WAREHOUSE (창고)

  • WHS_ID (창고 ID) — Primary key — NOT NULL
  • WHS_NAME (창고명)
  • WHS_CODE (창고코드)
  • Field (칭고그룹)
  • Field (현장부서)
  • Field (외주거래처)
  • Field (위탁거래처)
  • Field (창고구분)
  • Field (사용안함)

WAREHOUSE_MOVE (이동품목조회)

  • Key — Primary key — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • WHS_ID (입고창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • WHS_ID (출고창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • Field (이동일)
  • Field (이동번호)
  • Field2 (이동적송구분)
  • Field3 (이동수량)
  • Field4 (이동구분)
  • Field5 (처리구분)
  • Field6 (담당자)

WAREHOUSE_SNAPSHOT (창고별재고)

  • Key (창고별재고 ID) — Primary key — NOT NULL
  • WHS_ID (창고 ID) — Foreign key → WAREHOUSE.WHS_ID — NOT NULL
  • PROD_ID (상품 ID) — BIGINT(11) — Foreign key → PRODUCTS.PROD_ID — NOT NULL
  • BASE_DATE (기준일)
  • QTY (재고수량)