drop_customer

Tables (6)

Drop_Cp_CouponList (Untitled6)

  • CpSerialNo (Key) — Primary key — NOT NULL
  • ShoplinkCouponNo (Field)
  • CpIdx (Field2)
  • CustNo (Field3)
  • OrderNo (Field4)
  • ShoplinkSaleNo (Field5)
  • ShoplinkSaleDate (Field6)
  • UsedYn (Field7)
  • UseableSDate (Field8)
  • UseableEDate (Field9)
  • UseableYn (Field10)
  • InsNo (Field11)
  • InsDate (Field12)
  • UptNo (Field13)
  • UptDate (Field14)

Drop_Cu_Customer (Untitled)

  • CustNo (Key) — Primary key — NOT NULL
  • InsDate (Field)
  • InsNo (Field4)
  • UptDate (Field2)
  • Status (Field3) — 'Y', 'N'

Drop_OrderDlvy (Untitled4)

    Drop_OrderDtl (Untitled3)

    • Key — Primary key — NOT NULL

    Drop_OrderMst (Untitled2)

      Drop_OrderPay (Untitled5)

      • OrderNo (Key) — Primary key — NOT NULL
      • PaySeq (Key2) — Primary key — NOT NULL
      • claimIdx (Field)