CAL

Tables (11)

PP_CAL_CALC (CopyOfUntitled2)

  • CAL_CALC_SEQ (Key) — Primary key — NOT NULL
  • CAL_IN_ITM_SEQ (Key2) — Foreign key → PP_CAL_ITM.CAL_ITM_SEQ — NOT NULL
  • CAL_OUT_ITM_SEQ (Field4)
  • CAL_CALC_HIST_SEQ (Field)
  • CAL_CALC_CD (Field2)
  • CAL_CALC_FORM (Field5)
  • CAL_CALC_ORDER (Field6)

PP_CAL_ITM (Untitled)

  • CAL_ITM_SEQ (Key) — Primary key — NOT NULL
  • CAL_UP_ITM_SEQ (Field)
  • CAL_ITM_TYPE (Field2)
  • DSPY_RANK (Field3)

PP_CAL_MST (CopyOfCopyOfUntitled2)

  • CAL_MST_SEQ (Key) — Primary key — NOT NULL
  • CAL_MST_STAT (Field4)
  • ICT_DISCOUNT_YN (Field)

PP_CAL_MST_APVL ('')

  • CAL_MST_SEQ (Key2) — Foreign key → PP_CAL_MST.CAL_MST_SEQ — NOT NULL
  • TRX_SEQ (Field4)
  • TRX_STAT (Field)

PP_CAL_MST_MODEL (..)

  • CAL_MODEL_SEQ (Field4) — Primary key
  • CAL_MST_SEQ (Key2) — Foreign key → PP_CAL_MST.CAL_MST_SEQ — NOT NULL
  • BRAND_CD (Field)
  • MODEL_CD (Field2)
  • VARIANT_CD (Field3)
  • SFX_CD (Field5)
  • Field7
  • MY_CD (Key) — Foreign key → PP_CAL_MY_ITM.CAL_MY_CD — NOT NULL

PP_CAL_MST_MODEL_SPEC (;)

  • CAL_MODEL_SEQ (Field) — Primary key
  • CAL_MST_SEQ (Key2) — Foreign key → PP_CAL_MST_MODEL.CAL_MST_SEQ — NOT NULL
  • CAL_MODEL_SEQ (Field4) — Foreign key → PP_CAL_MST_MODEL.CAL_MODEL_SEQ
  • CAL_ITM_SEQ (Key) — Foreign key → PP_CAL_ITM.CAL_ITM_SEQ — NOT NULL
  • CAL_ITM_VALUE (Field3)

PP_CAL_MST_TAB_SALES (.)

  • CAL_MST_TYPE (Field4) — Primary key
  • CAL_SALES_SEQ (Field) — Primary key
  • CAL_MST_SEQ (Key2) — Foreign key → PP_CAL_MST.CAL_MST_SEQ — NOT NULL
  • VISIBLE_CHK (Field2)

PP_CAL_MY_ITM (0)

  • CAL_MY_CD (Key) — Primary key — NOT NULL
  • CAL_ITM_VALUE (Field)
  • CAL_ITM_TYPE (Field2)
  • CAL_ITM_SEQ (Key2) — Foreign key → PP_CAL_ITM.CAL_ITM_SEQ — NOT NULL

PP_CAL_SALES (CopyOfUntitled)

  • CAL_SALES_SEQ (Key) — Primary key — NOT NULL
  • REL_CAL_ITM_SEQ (Key2) — Foreign key → PP_CAL_ITM.CAL_ITM_SEQ — NOT NULL
  • DSPY_RANK (Field2)

PP_CAL_VEHIC_MY_ITM (CopyOf1)

  • MY_SEQ (Key) — Primary key — NOT NULL
  • MODEL_CD (Field4) — Primary key
  • VARIANT_CD (Field) — Primary key
  • MY_CD (Field2) — Primary key
  • CAL_ITM_SEQ (Field3) — Primary key
  • CAL_ITM_TYPE (Field5)
  • CAL_ITM_VALUE (Field6)

PP_CAL_VEHIC_SFX_ITM (1)

  • SFX_SEQ (Key) — Primary key — NOT NULL
  • BRAND_CD (Field4)
  • MODEL_CD (Field)
  • VARIANT_CD (Field2)
  • SFX_CD (Field3)
  • CAL_ITM_SEQ (Field5)
  • CAL_ITM_TYPE (Field6)
  • CAL_ITM_VALUE (Field7)