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 (재고수량)