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)