PSI

Tables (9)

Bza01 (Untitled)

  • empcode (Key) — Primary key — NOT NULL

Copy Of Untitled (CopyOfUntitled2)

  • Key — Primary key — NOT NULL

DEPTMASTER (CopyOfUntitled)

  • DEPTCODE (Key) — Primary key — NOT NULL
  • DEPTNAME (Key2) — Primary key — NOT NULL

FORECAST_PRODMASTER (Untitled3)

  • version (버전) — Primary key — NOT NULL
  • YYYY (년도) — Primary key — NOT NULL
  • MM (달) — Primary key — NOT NULL
  • WW (주) — Primary key — NOT NULL
  • SAUPBU (사업부코드) — Primary key — NOT NULL
  • HDDEPT (본부코드) — Primary key — NOT NULL
  • DEPT (지점코드) — Primary key — NOT NULL
  • EMPCODE (담당자) — Primary key — NOT NULL
  • SUPPLIERCODE (거래처) — Primary key — NOT NULL
  • PRODGRPCD (품목군코드) — Primary key — NOT NULL
  • PRODCD (품목코드)
  • OPDISCON (운영단종)
  • RECENTYN (최근여부)
  • USEYN (반영유무_CHECK) — X:N:마스터 반영Y
  • SAVEPERSON (접속자)

FORECAST_PRODSALE (실적/실소진)

  • version (Key) — Primary key — NOT NULL
  • KEYYYYY (Key2) — Primary key — NOT NULL
  • YYYY (Key3) — Primary key — NOT NULL
  • MM (Key4) — Primary key — NOT NULL
  • WW (Key5) — Primary key — NOT NULL
  • SAUPBU (Key6) — Primary key — NOT NULL
  • PART (Key7) — Primary key — NOT NULL
  • HDDEPT (Key8) — Primary key — NOT NULL
  • DEPT (Key9) — Primary key — NOT NULL
  • EMPCODE (Key10) — Primary key — NOT NULL
  • SUPPLIERCODE (Key11) — Primary key — NOT NULL
  • PRODGRPCD (Key12) — Primary key — NOT NULL
  • PRODCD (Key13) — Primary key — NOT NULL
  • T_QTSTOCKBASE (기초재고)
  • T_QTSTOCKLAST (기말재고)
  • T_AMSTOCKBASE (기초금액)
  • T_AMSTOCKLAST (기말금액)
  • T_AMSALE (실적)
  • T_QTSALE (판매)
  • T_AMSALERETURN (환불금액)
  • T_QTSALERETURN (환불수량)
  • T_ACTUALSALE (Field9)
  • T_ACTUALQTSALE (Field10)
  • USEYN (Field11)
  • CREATEDATE (Field12)
  • MODYDATE (Field13)
  • USEYN (Field14) — N:
  • Field

empmaster (Untitled2)

  • empcode (Key) — Primary key — NOT NULL

inno_f0005 (Untitled4)

  • DRSY (Key) — Primary key — NOT NULL
  • DRRT (Key2) — Primary key — NOT NULL
  • DRKY (품목코드) — Primary key — NOT NULL
  • DRDL01 (품목군명)

zz90 (메뉴)

    zz92 (메뉴권한)