pcc
Tables (5)
PCC_BOM_HEAD (Untitled)
- FACTORY (Key) — Primary key — NOT NULL
- WS_NO (Key2) — Primary key — NOT NULL
- DPA (Field)
- BOM_ID (Field2)
- BOM_REV (Field3)
- ST_CD (Field4)
- SUB_ST_CD (Field5)
- SR_NO (Field6)
- SEASON_CD (Field7)
- PCC_ORG (Field8)
- CATEGORY (Field9)
- DEV_NAME (Field10)
- STYLE_CD (Field11)
- SAMPLE_ETS (Field12)
- SAMPLE_QTY (Field13)
- SAMPLE_SIZE (Field14)
- PROD_FACTORY (Field15)
- GENDER (Field16)
- TD (Field17)
- COLOR_VER (Field18)
- MODEL_ID (Field19)
- PATTERN_ID (Field20)
- LAST_CD (Field21)
- LAST_DIM (Field22)
- MIDSOLE_METHOD (Field23)
- OUTSOLE_METHOD (Field24)
- PCC_PM (Field25)
- BOM_LOAD_DATE (Field26)
- BOM_CFM_DATE (Field27)
- BOM_ISSUE_DATE (Field28)
- MTO_ACCOUNT (Field29)
- WHQ_DEV (Field30)
- STL_FILE (Field31)
- SAMPLE_WEIGHT (Field32)
- COLLAR_HEIGHT (Field33)
- HEEL_HEIGHT (Field34)
- MEDIAL_HEIGHT (Field35)
- LATERAL_HEIGHT (Field36)
- MS_HARDNESS (Field37)
- IDS_LENGTH (Field38)
- LACE_LENGTH (Field39)
- IPW (Field40)
- UPPER_MATERIAL (Field41)
- REQ_DATE (Field42)
- NIKE_DEV (Field43)
- NIKE_SEND_QTY (Field44)
- WATER_JET_YN (Field45)
- REWORK_YN (Field46)
- REWORK_COMMENT (Field47)
- XML_UPLOAD (Field48)
- WS_QTY (Field49)
- REQ_BOM_YN (Field50)
- CS_BOM_CFM (Field51)
- CBD_YN (Field52)
- PER_CD (Field53)
- TEMP_KEY (Field54)
- STATUS (Field55)
- UPD_USER (Field56)
- UPD_YMD (Field57)
- PROTO_YN (Field58)
- … +31
PCC_PUR_REQ (Untitled2)
- REQ_NO (Key) — Primary key — NOT NULL
- REQ_SEQ (Key2) — Primary key — NOT NULL
- FACTORY (Field)
- WS_NO (Field2)
- SEASON_CD (Field3)
- DEV_NAME (Field4)
- BOM_ID (Field5)
- ST_CD (Field6)
- GENDER (Field7)
- SAMPLE_SIZE (Field8)
- SAMPLE_QTY (Field9)
- PCC_PM (Field10)
- BOM_LOAD_DATE (Field11)
- SAMPLE_ETS (Field12)
- LAST_CD (Field13)
- PART_SEQ (Field14)
- PART_NO (Field15)
- PART_NAME (Field16)
- PART_TYPE (Field17)
- PART_COMMENT (Field18)
- MXSXL_NUMBER (Field19)
- CS_CD (Field20)
- MAT_CD (Field21)
- MAT_NAME (Field22)
- MAT_COMMENT (Field23)
- COLOR_CD (Field24)
- COLOR_NAME (Field25)
- COLOR_COMMENT (Field26)
- PUR_USER (Field27)
- PUR_STATUS (Field28)
- REQ_YMD (Field29)
- CFM_YMD (Field30)
- LATEST_YN (Field31)
- DEV_COLORWAY_ID (Field32)
- MANULA_ADD (Field33)
- PCX_SUPP_MAT_ID (Field34)
- PCX_MAT_ID (Field35)
- PCX_COLOR_ID (Field36)
- SUB_ST_CD (Field37)
- CANCEL_USER (Field38)
- CANCEL_DATE (Field39)
PCX_CBD_HEAD (Untitled4)
- CBD_KEY (Key) — Primary key — NOT NULL
- CBD_VER (Key2) — Primary key — NOT NULL
- REF_PCX_KEY (Field)
- REF_HEAD_SEQ (Field2)
- REF_BOL_KEY (Field3)
- COMMENTS (Field4)
- UPD_USER (Field5)
- UPD_YMD (Field6)
- REF_KEY (Field7)
- NCC_VER (Field8)
- BOL_NAME (Field9)
PCX_CBD_SUMMARY (Untitled3)
- CBD_KEY (Key) — Primary key — NOT NULL
- CBD_VER (Key2) — Primary key — NOT NULL
- COST_ST_ID (Field)
- COST_ST_VER_NUM (Field2)
- BOM_NAME (Field3)
- BOM_VER_NUM (Field4)
- MODEL (Field5)
- PRODUCT_CODE (Field6)
- GENDER (Field7)
- AGE (Field8)
- COSTING_SIZE (Field9)
- DEV_TEAM (Field10)
- SMP_REQ_ID (Field11)
- RETAIL (Field12)
- SIZE_RUN (Field13)
- OBS_ID (Field14)
- OBS_TYPE (Field15)
- FORECAST (Field16)
- MAT_UP_CBD (Field17)
- MAT_MS_CBD (Field18)
- MAT_OS_CBD (Field19)
- MAT_AB_CBD (Field20)
- MAT_PK_CBD (Field21)
- MAT_TOT_CBD (Field22)
- LB_UP_CBD (Field23)
- LB_UC_CBD (Field24)
- LB_UE_CBD (Field25)
- LB_BM_CBD (Field26)
- DEV_STYLE (Field27)
- COLORWAY (Field28)
- PCC (Field29)
- PROD_FACTORY (Field30)
- DEV_SEASON (Field31)
- COSTING_SEASON (Field32)
- PLANNING_SEASON (Field33)
- MCS_SEASON (Field34)
- ROUND (Field35)
- MILESTONE (Field36)
- QUOTE_STATE (Field37)
- QUOTE_DATE (Field38)
Untitled5
- FACTORY (Key) — Primary key — NOT NULL
- WS_NO (Key2) — Primary key — NOT NULL
- OP_CD (Key3) — Primary key — NOT NULL
- OP_QTY (Field)
- OP_CHK (Field2)
- OP_YMD (Field3)
- PASSCARD (Field4)
- REMARK (Field5)
- UPD_USER (Field6)
- UPD_YMD (Field7)
- OP_REMARKS (Field8)
- CHANGE_YN (Field9)