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)