bofeel-unierp

Tables (4)

WEB_SE130MA1_S_REF (Untitled)

  • SO_NO (Key) — Primary key — NOT NULL
  • SO_SEQ (Key2) — Primary key — NOT NULL
  • YYMM (Field)
  • PLANT_CD (Field2)
  • SL_CD (Field3)
  • BP_CD (Field4)
  • DVLY_PARTY (Field5)
  • ITEM_CD (Field6)
  • SO_QTY (Field7)
  • SO_PRICE (Field8)
  • VAT_INC_FLAG (Field9)
  • VAT_TYPE (Field10)
  • VAT_RATE (Field11)
  • VAT_AMT (Field12)
  • VAT_AMT_LOC (Field13)
  • NET_AMT (Field14)
  • NET_AMT_LOC (Field15)
  • DN_NO (Field16)
  • DN_SEQ (Field17)
  • INSRT_USER_ID (Field18)
  • INSRT_DT (Field19)
  • UPDT_USER_ID (Field20)
  • UPDP_DT (Field21)

WEB_S_CART_ITEM (장바구니)

  • NO (Key) — Primary key — NOT NULL
  • UID (Key2) — Primary key — NOT NULL
  • BP_CD (Key3) — Primary key — NOT NULL
  • ITEM_CD (Key4) — Primary key — NOT NULL
  • SO_DT (Field)
  • SO_QTY (Field2)
  • SO_PRICE (Field3)
  • NET_AMT_LOC (Field4)
  • VAT_AMT_LOC (Field5)
  • NET_AMT (Field6)
  • VAT_AMT (Field7)
  • VAT_TYPE (Field8)
  • VAT_RATE (Field9)
  • VAT_INC_FLAG (Field10)
  • INSRT_USER_ID (Field11)
  • INSRT_DT (Field12)
  • UPDT_USER_ID (Field13)
  • UPDT_DT (Field14)

WEB_S_SO_DTL (주문정보)

  • SO_NO (Key) — Primary key — NOT NULL
  • SO_SEQ (Key2) — Primary key — NOT NULL
  • SO_DT (Field)
  • CFM_FLAG (Field2)
  • CFM_DT (Field3)
  • DLVY_DT (Field4)
  • SO_STATUS (Field5)
  • BP_CD (Field6)
  • PLANT_CD (Field7)
  • ITEM_CD (Field8)
  • SL_CD (Field9)
  • ITEM_ACCT (Field10)
  • SO_QTY (Field11)
  • SO_PRICE (Field12)
  • NET_AMT (Field13)
  • NET_AMT_LOC (Field14)
  • VAT_TYPE (Field15)
  • VAT_RATE (Field16)
  • VAT_AMT (Field17)
  • VAT_AMT_LOC (Field18)
  • DVLY_PARTY (Field19)
  • DLVY_TEL (Field20)
  • CLVY_CP (Field21)
  • DLVY_POST_NO (Field22)
  • DLVY_ADDR1 (Field23)
  • DLVY_ADDR2 (Field24)
  • DLVY_COST_TYPE (Field25)
  • DLVY_COST (Field26)
  • DLVY_REMARK (Field27)
  • CFM_QTY (Field28)
  • SO_UNIT (Field29)
  • GI_QTY (Field30)
  • BILL_QTY (Field31)
  • BILL_PRICE (Field32)
  • CLOSE_FLAG (Field33)
  • REMARK (Field34)
  • REMARK2 (Field35)
  • REMARK3 (Field36)
  • INSRT_USER_ID (Field37)
  • INSRT_DT (Field38)
  • UPDT_USER_ID (Field39)
  • UPDT_DT (Field40)
  • EXT1_CD (Field41)
  • EXT2_CD (Field42)
  • EXT3_CD (Field43)
  • EXT1_AMT (Field44)
  • EXT2_AMT (Field45)
  • EXT3_AMT (Field46)
  • EXT1_CD (Field47)
  • EXT2_CD (Field48)
  • EXT3_CD (Field49)
  • VAT_INC_FLAG (Field50)
  • BILL_YN (Field51)
  • BILL_YYMM (Field52)
  • KGB_DT (Field53)
  • RTN_FLAG (Field54)
  • RTN_REQ_DT (Field55)
  • RTN_END_DT (Field56)
  • RTN_QTY (Field57)
  • RTN_DN_NO (Field58)
  • … +5

WEB_S_SO_DTL_BARCODE (바코드정보)

  • SO_NO (Key) — Primary key — NOT NULL
  • SO_SEQ (Key2) — Primary key — NOT NULL
  • PK_SEQ (Key3) — Primary key — NOT NULL
  • ITEM_CD (Field)
  • BARCODE (송장번호)
  • REMARK (Field2)
  • INSRT_USER_ID (Field3)
  • INSRT_DT (Field4)
  • UPDT_USER_ID (Field5)
  • UPDT_DT (Field6)
  • EXT1_QTY (Field7)
  • EXT2_QTY (Field8)
  • EXT3_QTY (Field9)
  • EXT1_AMT (Field10)
  • EXT2_AMT (Field11)
  • EXT3_AMT (Field12)
  • EXT1_CD (Field13)
  • EXT2_CD (Field14)
  • EXT3_CD (Field15)
  • CLOSE_YN (Field16)