....
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