FACTORY 마감

테이블 (4)

STYLE_END_BASE (스타일 마감 MST)

  • END_BASE_NO (Key) — 기본 키 — NOT NULL
  • RATE_NO (Key2) — 외래 키 → STYLE_END_RATE.RATE_NO — NOT NULL
  • YEAR (Field2)
  • MONTH (Field3)
  • END_DT (Field4)
  • END_YN (Field5)
  • DEL_YN (Field6)
  • INPUT_ID (Field8)
  • INPUT_DT (Field9)
  • MODIFY_ID (Field10)
  • MODIFY_DT (Field11)

STYLE_END_DTL (스타일 마감 상세)

  • END_DTL_NO (Key) — 외래 키 → STYLE_END_DTL_INFO.END_DTL_NO — NOT NULL
  • QUANTITY (Field)
  • AMOUNT (Field2)
  • CUTTING_QTY (Field3)
  • CUTTING_AMT (Field4)
  • SEWING_QTY (Field5)
  • SEWING_AMT (Field6)
  • OUTPUT_QTY (Field7)
  • OUTPUT_AMT (Field8)
  • IRON_QTY (Field9)
  • IRON_AMT (Field10)
  • FOLDING_QTY (Field11)
  • FOLDING_AMT (Field12)
  • IN_BOX_QTY (Field13)
  • IN_BOX_AMT (Field14)
  • UNUSED_QTY (Field15)
  • UNUSED_AMT (Field16)

STYLE_END_DTL_INFO (스타일 마감 상세 정보)

  • END_DTL_NO (Key) — 기본 키 — NOT NULL
  • END_BASE_NO (Key2) — 외래 키 → STYLE_END_BASE.END_BASE_NO — NOT NULL
  • ORD_SNO (Field)
  • STYLE_NO (Field2)
  • PO_SNO (Field3)
  • PO_NO (Field4)
  • BUYER (Field8)
  • BUYER_CODE (Field11)
  • BRAND (Field7)
  • DIVISION (Field12)
  • STY_COLOR_SNO (Field5)
  • STYLE_COLOR (Field6)
  • SIZE_CODE (Field9)
  • PRODUCT_SIZE (Field10)
  • VENDOR_ID (Field13)
  • FACTORY_ID (Field14)
  • FACTORY (Field15)
  • DCD_DT (Field16)
  • CM_UC (Field17)

STYLE_END_RATE (마감 공임 비율)

  • RATE_NO (Key) — 기본 키 — NOT NULL
  • CUTTING_CM (Field2)
  • SEWING_CM (Field3)
  • OUTPUT_CM (Field4)
  • IRON_CM (Field5)
  • FOLDING_CM (Field6)
  • IN_BOX_CM (Field7)
  • UNUSED_CM (Field8)
  • DEL_YN (Field13)
  • INPUT_ID (Field9)
  • INPUT_DT (Field10)
  • MODIFY_ID (Field11)
  • MODIFY_DT (Field12)