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)