1212
테이블 (8)
고객 (ZTCL3_T3_CUST)
- CUST_ID (ZE_T3_CUST_ID) — CHAR(40) — 기본 키 — NOT NULL
- CUST_NAME (ZE_T3_CUSTNAME) — CHAR(30)
- PHONE (ZE_T3_PHONE) — CHAR(20)
- ADDRESS (ZE_T3_ADDRESS) — CHAR(50)
- CUST_TYPE (CHAR1) — CHAR(1)
매출마감 (ZTSALES_27)
- VBELN — CHAR(10) — 기본 키 — NOT NULL
- BUKRS — CHAR(4)
- BUPLA — CHAR(4)
- KUNNR — CHAR(10)
- KUNTX (ZE_KUNTX) — CHAR(35)
- ERDAT — DATS(8)
- BUDAT — DATS(8)
- MATNR — CHAR(40)
- MAKTX (MAKT) — CHAR(40)
- NETWR — CURR(15)
- WAERK — CUKY(5)
- ICON (CHAR1) — CHAR(1)
- INVNR (CHAR10) — CHAR(10)
- CHECK (XFELD) — CHAR(1)
미결전표 (TCL3_T3_ACCT)
- BELNR (BELNR_D) — CHAR(10) — 기본 키 — NOT NULL
- MATNR (MATNR2) — CHAR(40) — 외래 키 → 재고.MATNR — NOT NULL
- ORDR_NO (ZE_T3_PURC) — NUMC(6) — 외래 키 → 발주.ORDR_NO — NOT NULL
- PURC_NO (ZE_T3_PURC2) — NUMC(6) — 외래 키 → 입고.PURC_NO — NOT NULL
- GJAHR — NUMC(4)
- BUZEI — NUMC(3)
- BLART — CHAR(2)
- SHKZG — CHAR(1)
- HKONT — CHAR(10)
- DMBTR — CURR(23)
- WAERS (PRICE) — CUKY(5)
- LFIMG — QUAN(13)
- VRKME — UNIT(3)
- MATNR — CHAR(40)
- T3_DESC (CHAR50) — CHAR(50)
발주 (ZTCL3_T3_ORDR)
- ORDR_NO (ZE_T3_PURC) — NUMC(6) — 기본 키 — NOT NULL
- VENDER_ID (ZE_T3_VENDER) — CHAR(10)
- MATNR — CHAR(40)
- QUANTITY (LFIMG) — QUAN(13)
- UNIT (VRKME) — UNIT(3)
- PRICE (ZE_T3_PRICE) — CURR(13)
- WAERS — CUKY(5)
- DATE (ZE_T3_DATE) — DATS(8)
세금계산서 (ZTTAX_27)
- ZINVNR (CHAR10) — CHAR(10) — 기본 키 — NOT NULL
- BUKRS — CHAR(4) — 기본 키 — NOT NULL
- KUNNR — CHAR(10) — 기본 키 — NOT NULL
- DATE (DATUM) — DATS(8)
- TYPE (CHAR1) — CHAR(1)
- TOTAL_AMT (NETWR) — CURR(15)
- NETWR (NETWR_D) — CURR(15)
- BIGO (Z_BIGO) — CHAR(60)
- BIGO2 (Z_BIGO2) — CHAR(60)
- VAT_AMT (NETWR_N) — CURR(15)
- WAERS — CUKY(5)
- S_EMAIL (AD_SMTPADR) — CHAR(241)
- S_STCD1 (STCD1) — CHAR(16)
- S_CEO (NAME1_GP) — CHAR(35)
- S_ADDR (ZAD_ADDR1) — CHAR(40)
- S_NAME1 (NAME1) — CHAR(30)
- R_STCD1 (STCD2) — CHAR(16)
- R_CEO (NAME2_GP) — CHAR(35)
- R_ADDR (ZAD_ADDR2) — CHAR(40)
- R_EMAIL (AZ_SMTPADR) — CHAR(241)
- R_NAME1 (NAME2) — CHAR(30)
입고 (ZTCL3_T3_PURC)
- PURC_NO (ZE_T3_PURC) — NUMC(6) — 기본 키 — NOT NULL
- VENDER_ID (ZE_T3_VENDER) — CHAR(10)
- MATNR — CHAR(40)
- QUANTITY (LFIMG) — QUAN(13)
- UNIT (VRKME) — UNIT(3)
- IN_PRICE (ZE_T3_PRICE) — CURR(13)
- WAERS — CUKY(5)
- DATE (ZE_T3_DATE) — DATS(8)
재고 (ZTCL3_T3_MAST)
- MATNR — CHAR(40) — 기본 키 — NOT NULL
- MAKTX — CHAR(40)
- MTART — CHAR(4)
- COLOR (ZE_T3_COLOR) — CHAR(10)
- SIZE1 (ZE_T3_SIZE1) — CHAR(10)
- LABST — QUAN(13)
- MEINS — UNIT(3)
- PRICE — CURR(15)
- WAERS — CUKY(5)
판매 (ZTCL3_T3_DELV)
- DELV_NO (ZE_T3_DELV_NO) — NUMC(10) — 기본 키 — NOT NULL
- CUST_ID (ZE_T3_CUST_ID2) — CHAR(40) — 외래 키 → 고객.CUST_ID — NOT NULL
- CUST_ID (ZE_T3_CUST_ID) — CHAR(10)
- QUANTITY (LFIMG) — QUAN(13)
- UNIT (VRKME) — UNIT(3)
- PRICE (ZE_T3_PRICE) — CURR(13)
- WAERS — CUKY(5)
- DATE (ZE_T3_DATE) — DATS(8)
- MATNR — CHAR(40)