....

Tables (12)

PT_ARROW_HIST (화살표 변경 이력)

  • LOCATION_ID (로케이션 ID) — Primary key — NOT NULL
  • LINE_NO (변경 번호) — Primary key — NOT NULL
  • WAREHOUSE_ID (창고 식별자) — Primary key — NOT NULL
  • START_DT (시작 일자)
  • END_DT (종료 일자)
  • PART_NO (부품 번호)
  • PRINT_YN (프린트 여부)
  • PRINT_DAY (프린트 일자)
  • REG_DT (Field5)
  • REG_USER_ID (Field)
  • UPD_DT (Field2)
  • UPD_USER_ID (Field3)

PT_BIN_HIST (로케이션 변경 이력)

  • SHOP_CD (지점 식별자) — Primary key — NOT NULL
  • PART_NO (부품번호) — Primary key — NOT NULL
  • LINE_NO (변경 번호) — Primary key — NOT NULL
  • WAREHOUSE_ID (창고 식별자) — Primary key — NOT NULL
  • START_DT (시작 일자)
  • END_DT (종료 일자)
  • BIN (PRIMARY 로케이션)
  • RESV_BIN (RESERVE 로케이션)
  • PRINT_YN (프린트 여부)
  • PRINT_DAY (프린트 일자)
  • REG_DT (Field5)
  • REG_USER_ID (Field)
  • UPD_DT (Field2)
  • UPD_USER_ID (Field3)
  • RESV_BIN_02 (Field4)
  • RESV_BIN_03 (Field6)
  • RESV_BIN_04 (Field7)
  • RESV_BIN_05 (Field8)

PT_LOCATION (로케이션 기준정보)

  • LOCATION_ID (로케이션 식별자) — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • Key4 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

PT_LOCATION_ARROW (로케이션 화살표 관리)

  • LOCATION_ID (로케이션 식별자) — Primary key — NOT NULL
  • PART_NO (부품번호) — Primary key — NOT NULL
  • WAREHOUSE_ID (창고 식별자) — Primary key — NOT NULL
  • PARENT_LOCATION_ID (대표 로케이션 ID)
  • LOC_STAT (상태)
  • Field3
  • Field4

PT_PART (부품 마스터)

    PT_PURC (CopyOfUntitled2)

      PT_PURC_DETL (CopyOfCopyOfUntitled2)

        PT_SI (Untitled)

          PT_SI_DETL (CopyOfUntitled)

            PT_STOCK (재고 마스터)

            • SHOP_CD (SHOP 식별자) — Primary key — NOT NULL
            • PART_NO (부품 번호) — Primary key — NOT NULL
            • STOCK_QTY (재고수량)
            • STOCK_AMT (Field2)
            • PURC_QTY_TOTAL (Field3)
            • PURC_QTY_SERV (Field4)
            • PURC_QTY_VOR (Field5)
            • PURC_QTY_EO (Field6)
            • PURC_QTY_SO (Field7)
            • PURC_QTY_FO (Field8)
            • PURC_QTY_BO_AIR (Field9)
            • PURC_QTY_BO_SEA (Field10)
            • PURC_QTY_OTHS (Field11)
            • TRAN_QTY_TOTAL (Field12)
            • TRAN_QTY_SERV (Field13)
            • TRAN_QTY_VOR (Field14)
            • TRAN_QTY_EO (Field15)
            • TRAN_QTY_SO (Field16)
            • TRAN_QTY_FO (Field17)
            • TRAN_QTY_BO_AIR (Field18)
            • TRAN_QTY_BO_SEA (Field19)
            • TRAN_QTY_OTHS (Field)
            • ORDER_QTY_TOTAL (Field20)
            • ORDER_QTY_SERV (Field21)
            • ORDER_QTY_VOR (Field22)
            • ORDER_QTY_EO (Field23)
            • ORDER_QTY_SO (Field24)
            • ORDER_QTY_FO (Field25)
            • ORDER_QTY_BO_AIR (Field26)
            • ORDER_QTY_BO_SEA (Field27)
            • ORDER_QTY_OTHS (Field28)
            • RESV_QTY (Field29)
            • SOUT_WAIT_QTY (Field30)
            • SOUT_WAIT_QTY_CALC (Field31)
            • SOUT_WAIT_AMT_CALC (Field32)
            • SIN_WAIT_QTY (Field33)
            • SIN_WAIT_AMT (Field34)
            • STOCK_ADJT_QTY_PLUS (Field35)
            • STOCK_ADJT_QTY_MINUS (Field36)
            • PURC_CLAIM_QTY (Field37)
            • STND_STOCK_QTY (Field38)
            • STND_STOCK_QTY_TEMP (Field39)
            • STND_STOCK_MNGE_YN (Field40)
            • SAFE_STOCK_QTY (Field41)
            • LATE_PURC_PRICE (Field42)
            • LATE_SIN_DT (Field43)
            • LATE_SOUT_DT (Field44)
            • BIN_LOCA (Field45)
            • RESV_BIN_LOCA (Field46)
            • MAD (Field47)
            • PREV_MAD (Field48)
            • STOCK_QTY_OPEN_YN (Field49)
            • SOQ_CALC_YN (Field50)
            • ICC (Field51)
            • SCC (Field52)
            • SCC_MANU (Field53)
            • MAD_FLUC_WARN_YN (Field54)
            • ABNO_MAD_FLUC_YN (Field55)
            • MAD_FLUC_RATE (Field56)
            • STOCK_SURP_YN (Field57)
            • … +9

            PT_STOCK_WAREHOUSE (창고 별 재고 관리)

            • PART_NO (부품 번호) — Primary key — NOT NULL
            • WAREHOUSE_ID (창고 식별자) — Primary key — NOT NULL
            • STOCK_QTY (재고수량)
            • STOCK_AMT (Field2)
            • PURC_QTY_TOTAL (Field3)
            • PURC_QTY_SERV (Field4)
            • PURC_QTY_VOR (Field5)
            • PURC_QTY_EO (Field6)
            • PURC_QTY_SO (Field7)
            • PURC_QTY_FO (Field8)
            • PURC_QTY_BO_AIR (Field9)
            • PURC_QTY_BO_SEA (Field10)
            • PURC_QTY_OTHS (Field11)
            • TRAN_QTY_TOTAL (Field12)
            • TRAN_QTY_SERV (Field13)
            • TRAN_QTY_VOR (Field14)
            • TRAN_QTY_EO (Field15)
            • TRAN_QTY_SO (Field16)
            • TRAN_QTY_FO (Field17)
            • TRAN_QTY_BO_AIR (Field18)
            • TRAN_QTY_BO_SEA (Field19)
            • TRAN_QTY_OTHS (Field)
            • ORDER_QTY_TOTAL (Field20)
            • ORDER_QTY_SERV (Field21)
            • ORDER_QTY_VOR (Field22)
            • ORDER_QTY_EO (Field23)
            • ORDER_QTY_SO (Field24)
            • ORDER_QTY_BO_AIR (Field25)
            • ORDER_QTY_BO_SEA (Field27)
            • ORDER_QTY_OTHS (Field28)
            • RESV_QTY (Field29)
            • SOUT_WAIT_QTY (Field30)
            • SOUT_WAIT_QTY_CALC (Field31)
            • SOUT_WAIT_AMT_CALC (Field32)
            • SIN_WAIT_QTY (Field33)
            • SIN_WAIT_AMT (Field34)
            • STOCK_ADJT_QTY_PLUS (Field35)
            • STOCK_ADJT_QTY_MINUS (Field36)
            • PURC_CLAIM_QTY (Field37)
            • STND_STOCK_QTY (Field38)
            • STND_STOCK_QTY_TEMP (Field39)
            • STND_STOCK_MNGE_YN (Field40)
            • SAFE_STOCK_QTY (Field41)
            • LATE_PURC_PRICE (Field42)
            • LATE_SIN_DT (Field43)
            • LATE_SOUT_DT (Field44)
            • BIN_LOCA (Field45)
            • MAD (Field47)
            • PREV_MAD (Field48)
            • STOCK_QTY_OPEN_YN (Field49)
            • SOQ_CALC_YN (Field50)
            • ICC (Field51)
            • SCC (Field52)
            • SCC_MANU (Field53)
            • MAD_FLUC_WARN_YN (Field54)
            • ABNO_MAD_FLUC_YN (Field55)
            • MAD_FLUC_RATE (Field56)
            • STOCK_SURP_YN (Field57)
            • SHORT_WARN_QTY (Field58)
            • STOCK_PROT_QTY (Field59)
            • … +14

            PT_WAREHOUSE (Untitled2)

            • WAREHOUSE_ID (창고식별자) — Primary key — NOT NULL
            • NAME (창고이름)
            • ADDRESS (주소)
            • ADDRESS_DETAIL (주소 상세)
            • receive_yn (입고 여부)
            • send_yn (출고 여부)
            • Field5
            • Field6