ํ๋ชฉ/์ ํ
์ญํ : ์ฐธ์กฐ (์นดํ ๊ณ ๋ฆฌ๋ณ ์นดํ๋ก๊ทธ)
๋์ ๋ ์: DBA ยท ์ด์ ๋ด๋น ยท ์ ๋ฌด ๋ถ์
ํ๋ชฉ ๋ง์คํฐ, ์ ํ ๋จ๊ฐ
์ด ์นดํ ๊ณ ๋ฆฌ๋ ๋ฌด์์ ๋ด๋นํ๋
๊ฐ์ โ ํ๋ชฉ ๋ง์คํฐ, ์ ํ ๋จ๊ฐ
๊ตฌ์ฑ โ ์ด์ ํ ์ด๋ธ 8๊ฐ
์ฃผ์ ํ ์ด๋ธ (ํ ์ ๊ธฐ์ค Top 3)
QC_LOT_0812โ 4465ํ ยท (์ถ์ ) ๋ฐํ/๊ตํ LOT ๊ณ์ดPRODUCT_CODEโ 2207ํ ยท (์ถ์ ) ์ ํ์ค๋ช ํ ๊ณ์ดITEM_PRICE_RPTโ 1817ํ ยท ์์ฐ๋ณด๊ณ ์/์์ถํ๋จ๊ฐ
์ฃผ์ PK ํจํด โ ITEM_CODE (5) ยท PRICE_CLASS (2) ยท CURRENCY_CODE (1) ยท STRT_DATE (1)
์์ฝ
| ํญ๋ชฉ | ๊ฐ |
|---|---|
| ํ ์ด๋ธ ์ | 8 |
| ์ด ์ปฌ๋ผ ์ | 223 |
| PK ์์ | 5 |
| FK ๊ด๊ณ | 0 |
๊ด๊ณ๋
PK ์ปฌ๋ผ๋ช ๋งค์นญ ๊ธฐ๋ฐ ์ถ์ ๊ด๊ณ ยท ์ด 6๊ฐ ยท ์ค/ํฌ/๋ ธ๋ ๋๋๊ทธ/ํด๋ฆญ ํ์ด๋ผ์ดํธ
๊ด๊ณ๋ ๋ก๋ฉ ์ค...
ํ ์ด๋ธ ๋ชฉ๋ก
| # | ์ํ | ํ ์ด๋ธ๋ช | ์ปฌ๋ผ ์ | ํ ์ | PK | ์ค๋ช |
|---|---|---|---|---|---|---|
| 1 | ITEM_1 | 44 | 895 | โ | ํ๋ชฉ๋ง์คํฐ | |
| 2 | ITEM_PRICE | 11 | 429 | โ | ์์ ๊ด๋ฆฌ/ํ๋ชฉ๋จ๊ฐ | |
| 3 | ITEM_PRICE_RPT | 11 | 1,817 | โ | ์์ฐ๋ณด๊ณ ์/์์ถํ๋จ๊ฐ | |
| 4 | ITEM_PRICE_BAK | 11 | 347 | โ | (์ถ์ ) ์์ ๊ด๋ฆฌ/ํ๋ชฉ๋จ๊ฐ ๊ณ์ด | |
| 5 | ITEM_HISTORY | 42 | 10 | - | (์ถ์ ) ํ๋ชฉ๋ง์คํฐ ๊ณ์ด | |
| 6 | ITEM_1BACK | 44 | 1,627 | โ | (์ถ์ ) ํ๋ชฉ๋ง์คํฐ ๊ณ์ด | |
| 7 | PRODUCT_CODE | 38 | 2,207 | - | (์ถ์ ) ์ ํ์ค๋ช ํ ๊ณ์ด | |
| 8 | QC_LOT_0812 | 22 | 4,465 | - | (์ถ์ ) ๋ฐํ/๊ตํ LOT ๊ณ์ด |
์์ธ ๋ช ์ธ
ITEM_1
ํ๋ชฉ๋ง์คํฐ
PK: ITEM_CODE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ITEM_CODE | VARCHAR2(9) | N | ํ๋ชฉ์ฝ๋ |
| 2 | ITEM_HNAME | VARCHAR2(40) | N | ํ๋ชฉ๋ช (ํ๊ธ) |
| 3 | ITEM_ENAME | VARCHAR2(30) | Y | ํ๋ชฉ๋ช (์๋ฌธ) |
| 4 | ITEM_HFGOOD_CODE | VARCHAR2(10) | Y | ๋ฐ์ ํ์ฝ๋ |
| 5 | ITEM_HFGOOD_TYPE | VARCHAR2(2) | Y | ์ ํ๊ตฌ๋ถ (S001) |
| 6 | ITEM_PACKING_TYPE | VARCHAR2(3) | Y | ํฌ์ฅํํ (M081) |
| 7 | ITEM_STD_CODE | VARCHAR2(13) | Y | ํ์ค์ฝ๋(KPIS.๋ฐ์ฝ๋) |
| 8 | ITEM_BOX_QTY | NUMBER(6,0) | Y | ํฌ์ฅ์๋ |
| 9 | BUSINESS_GUBUN | VARCHAR2(1) | Y | ์ฌ์ ๊ตฌ๋ถ (S002) |
| 10 | ITEM_TYPE | VARCHAR2(1) | Y | ํ๋ชฉ๊ตฌ๋ถ (S004) |
| 11 | ITEM_CLASS | VARCHAR2(2) | Y | ํ๋ชฉ๋ถ๋ฅ (S019) |
| 12 | ITEM_GROUP | VARCHAR2(3) | Y | ํ๋ชฉ๊ทธ๋ฃน (S005) |
| 13 | ITEM_GUBUN | VARCHAR2(1) | Y | ํ๋ชฉ์ฉ๋(S055;1 ํ๋งค/2 ์ํ/3 ๊ตฐ๋ฉ/4 ์์ถ) |
| 14 | FIRST_SALES_DATE | DATE | Y | ์ํ์ผ์ |
| 15 | SALES_END_GUBUN | VARCHAR2(1) | Y | ํ๋งค์ค์ง์ฌ๋ถ |
| 16 | SALES_END_DATE | DATE | Y | ํ๋งค์ค์ง์ผ์ |
| 17 | USE_YN | VARCHAR2(1) | Y | ์ฌ์ฉ์ฌ๋ถ |
| 18 | ADD_QTY_YN | VARCHAR2(1) | Y | ์ ์ฑ ํ๋ชฉ์ฌ๋ถ |
| 19 | MAIN_ITEM | VARCHAR2(1) | Y | ์ฃผ๋ ฅํ๋ชฉ์ฌ๋ถ |
| 20 | COMP_GUBUN | VARCHAR2(1) | Y | ํ๋ชฉํต์ ์ฌ๋ถ(์ฌ์ฉ์ํจ) |
| 21 | TARGET_APPLY_YN | VARCHAR2(1) | Y | ์์ ๋ชฉํ์ ์ฉ์ฌ๋ถ |
| 22 | WHOL_SALE_YN | VARCHAR2(1) | Y | ๊ตฌ๋ถ(1:์ฃผ์ฌ์ ,2:PO์ ,3:๊ธฐํ) |
| 23 | VAT_GUBUN | VARCHAR2(1) | Y | ๊ณผ์ธ/๋น๊ณผ์ธ์ฌ๋ถ |
| 24 | ATTENTION_GUBUN | VARCHAR2(1) | Y | PMSํ๋ชฉ์ฌ๋ถ |
| 25 | SUM_ITEM_CODE | VARCHAR2(9) | Y | ์ง๊ณํ๋ชฉ์ฝ๋ |
| 26 | MEDICAL_GUBUN | VARCHAR2(1) | Y | ์๋ณด์ ์ฉ์ฌ๋ถ |
| 27 | ITEM_SHEET_YN | VARCHAR2(1) | Y | ์ฒ๋ฐฉํ๋ชฉ์ฌ๋ถ |
| 28 | PM_ITEM | VARCHAR2(1) | Y | PMํ๋ชฉ์ฌ๋ถ |
| 29 | PM_EMP | VARCHAR2(6) | Y | PM๋ด๋น์ |
| 30 | ITEM_WIDTH | NUMBER(4,1) | Y | ๊ฐ๋ก(ํฌ์ฅ๊ท๊ฒฉ;CM) |
| 31 | ITEM_LENGTH | NUMBER(4,1) | Y | ์ธ๋ก(ํฌ์ฅ๊ท๊ฒฉ;CM) |
| 32 | ITEM_HIGHT | NUMBER(4,1) | Y | ๋์ด(ํฌ์ฅ๊ท๊ฒฉ;CM) |
| 33 | ITEM_WEIGHT | NUMBER(6,3) | Y | ์ค๋(ํฌ์ฅ๊ท๊ฒฉ;KG) |
| 34 | DELIVERY_WORK | VARCHAR2(2) | Y | ๋ฐฐ์ก์์ ์ค (S038) |
| 35 | STANDARD_BOX | VARCHAR2(3) | Y | ๊ธฐ์คํฌ์ฅ (S008) |
| 36 | DELIVERY_PACKING | VARCHAR2(2) | Y | ํฌ์ฅ๊ตฌ๋ถ (S007) |
| 37 | SAFETY_YN | VARCHAR2(1) | Y | ์์ ์ฌ๊ณ ํต์ ์ฌ๋ถ |
| 38 | OLD_ITEM_CODE | VARCHAR2(9) | Y | ๊ตฌ ํ๋ชฉ์ฝ๋ |
| 39 | FIRSTEMP | VARCHAR2(6) | Y | |
| 40 | FIRSTYMD | DATE | Y | |
| 41 | LASTEMP | VARCHAR2(6) | Y | |
| 42 | LASTYMD | DATE | Y | |
| 43 | ITEM_STD_CODE1 | VARCHAR2(13) | Y | |
| 44 | WHOLESALE_GUBUN | VARCHAR2(1) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ITEM_1 | โ | ITEM_CODE |
ITEM_PRICE
์์ ๊ด๋ฆฌ/ํ๋ชฉ๋จ๊ฐ
PK: ITEM_CODE, PRICE_CLASS
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ITEM_CODE | VARCHAR2(9) | N | ํ๋ชฉ์ฝ๋ |
| 2 | PRICE_CLASS | VARCHAR2(2) | N | ๋จ๊ฐ๊ตฌ๋ถ (์ฝ๋์ง S009) |
| 3 | PRICE | NUMBER(9,0) | Y | ๋จ๊ฐ |
| 4 | CURRENCY_CODE | VARCHAR2(3) | Y | ํํ๋จ์ (์ฝ๋์ง S010) |
| 5 | APPLICATION_DATE | DATE | Y | ๊ฐ์์ผ์ |
| 6 | END_DATE | DATE | Y | ์ข ๋ฃ์ผ์ |
| 7 | USE_YN | VARCHAR2(1) | Y | ์ฌ์ฉ์ฌ๋ถ (Y/N) |
| 8 | FIRSTEMP | VARCHAR2(6) | Y | ์ต์ด์ ๋ ฅ์ |
| 9 | FIRSTYMD | DATE | Y | ์ต์ด์ ๋ ฅ์ผ์ |
| 10 | LASTEMP | VARCHAR2(6) | Y | ๋ง์ง๋ง์ ๋ ฅ์ |
| 11 | LASTYMD | DATE | Y | ๋ง์ง๋ง์ ๋ ฅ์ผ์ |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ITEM_PRICE | โ | ITEM_CODE, PRICE_CLASS |
ITEM_PRICE_RPT
์์ฐ๋ณด๊ณ ์/์์ถํ๋จ๊ฐ
PK: ITEM_CODE, CURRENCY_CODE, STRT_DATE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ITEM_CODE | VARCHAR2(9) | N | ํ๋ชฉ์ฝ๋ |
| 2 | CURRENCY_CODE | VARCHAR2(3) | N | ํตํ๊ตฌ๋ถ |
| 3 | PRICE | NUMBER(16,4) | Y | ๋จ๊ฐ |
| 4 | STRT_DATE | DATE | N | ์ ์ฉ์์์ผ(๋งค์์ฒซ์งธ์ผ) |
| 5 | END_DATE | DATE | N | ์ ์ฉ์ข ๋ฃ์ผ(๋งค์๋ง์ผ) |
| 6 | FIRSTEMP | VARCHAR2(10) | Y | ์ต์ด์ ๋ ฅ์ |
| 7 | FIRSTYMD | DATE | Y | ์ต์ด์ ๋ ฅ์ผ์ |
| 8 | LASTEMP | VARCHAR2(10) | Y | ์ต์ข ์์ ์ |
| 9 | LASTYMD | DATE | Y | ์ต์ข ์์ ์ผ์ |
| 10 | EXT1_CD | VARCHAR2(20) | Y | ์๋น์ฝ๋1 |
| 11 | EXT1_AMT | NUMBER(16,4) | Y | ์๋น๊ธ์ก1 |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ITEM_PRICE_RPT | โ | ITEM_CODE, CURRENCY_CODE, STRT_DATE |
ITEM_PRICE_BAK
(์ถ์ ) ์์ ๊ด๋ฆฌ/ํ๋ชฉ๋จ๊ฐ ๊ณ์ด
PK: ITEM_CODE, PRICE_CLASS
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ITEM_CODE | VARCHAR2(9) | N | |
| 2 | PRICE_CLASS | VARCHAR2(2) | N | |
| 3 | PRICE | NUMBER(9,0) | Y | |
| 4 | CURRENCY_CODE | VARCHAR2(3) | Y | |
| 5 | APPLICATION_DATE | DATE | Y | |
| 6 | END_DATE | DATE | Y | |
| 7 | USE_YN | VARCHAR2(1) | Y | |
| 8 | FIRSTEMP | VARCHAR2(6) | Y | |
| 9 | FIRSTYMD | DATE | Y | |
| 10 | LASTEMP | VARCHAR2(6) | Y | |
| 11 | LASTYMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ITEM_PRICE_BAK | โ | ITEM_CODE, PRICE_CLASS |
ITEM_HISTORY
(์ถ์ ) ํ๋ชฉ๋ง์คํฐ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ITEM_CODE | VARCHAR2(9) | N | |
| 2 | ITEM_HNAME | VARCHAR2(40) | N | |
| 3 | ITEM_ENAME | VARCHAR2(30) | Y | |
| 4 | ITEM_HFGOOD_CODE | VARCHAR2(10) | Y | |
| 5 | ITEM_HFGOOD_TYPE | VARCHAR2(2) | Y | |
| 6 | ITEM_PACKING_TYPE | VARCHAR2(3) | Y | |
| 7 | ITEM_STD_CODE | VARCHAR2(13) | Y | |
| 8 | ITEM_BOX_QTY | NUMBER(6,0) | Y | |
| 9 | BUSINESS_GUBUN | VARCHAR2(1) | Y | |
| 10 | ITEM_TYPE | VARCHAR2(1) | Y | |
| 11 | ITEM_CLASS | VARCHAR2(2) | Y | |
| 12 | ITEM_GROUP | VARCHAR2(3) | Y | |
| 13 | ITEM_GUBUN | VARCHAR2(1) | Y | |
| 14 | FIRST_SALES_DATE | DATE | Y | |
| 15 | SALES_END_GUBUN | VARCHAR2(1) | Y | |
| 16 | SALES_END_DATE | DATE | Y | |
| 17 | USE_YN | VARCHAR2(1) | Y | |
| 18 | ADD_QTY_YN | VARCHAR2(1) | Y | |
| 19 | MAIN_ITEM | VARCHAR2(1) | Y | |
| 20 | COMP_GUBUN | VARCHAR2(1) | Y | |
| 21 | TARGET_APPLY_YN | VARCHAR2(1) | Y | |
| 22 | WHOL_SALE_YN | VARCHAR2(1) | Y | |
| 23 | VAT_GUBUN | VARCHAR2(1) | Y | |
| 24 | ATTENTION_GUBUN | VARCHAR2(1) | Y | |
| 25 | SUM_ITEM_CODE | VARCHAR2(9) | Y | |
| 26 | MEDICAL_GUBUN | VARCHAR2(1) | Y | |
| 27 | ITEM_SHEET_YN | VARCHAR2(1) | Y | |
| 28 | PM_ITEM | VARCHAR2(1) | Y | |
| 29 | PM_EMP | VARCHAR2(6) | Y | |
| 30 | ITEM_WIDTH | NUMBER(4,1) | Y | |
| 31 | ITEM_LENGTH | NUMBER(4,1) | Y | |
| 32 | ITEM_HIGHT | NUMBER(4,1) | Y | |
| 33 | ITEM_WEIGHT | NUMBER(6,3) | Y | |
| 34 | DELIVERY_WORK | VARCHAR2(2) | Y | |
| 35 | STANDARD_BOX | VARCHAR2(3) | Y | |
| 36 | DELIVERY_PACKING | VARCHAR2(2) | Y | |
| 37 | SAFETY_YN | VARCHAR2(1) | Y | |
| 38 | OLD_ITEM_CODE | VARCHAR2(9) | Y | |
| 39 | FIRSTEMP | VARCHAR2(6) | Y | |
| 40 | FIRSTYMD | DATE | Y | |
| 41 | LASTEMP | VARCHAR2(6) | Y | |
| 42 | LASTYMD | DATE | Y |
ITEM_1BACK
(์ถ์ ) ํ๋ชฉ๋ง์คํฐ ๊ณ์ด
PK: ITEM_CODE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | ITEM_CODE | VARCHAR2(9) | N | |
| 2 | ITEM_HNAME | VARCHAR2(40) | N | |
| 3 | ITEM_ENAME | VARCHAR2(30) | Y | |
| 4 | ITEM_HFGOOD_CODE | VARCHAR2(10) | Y | |
| 5 | ITEM_HFGOOD_TYPE | VARCHAR2(2) | Y | |
| 6 | ITEM_PACKING_TYPE | VARCHAR2(3) | Y | |
| 7 | ITEM_STD_CODE | VARCHAR2(13) | Y | |
| 8 | ITEM_BOX_QTY | NUMBER(6,0) | Y | |
| 9 | BUSINESS_GUBUN | VARCHAR2(1) | Y | |
| 10 | ITEM_TYPE | VARCHAR2(1) | Y | |
| 11 | ITEM_CLASS | VARCHAR2(2) | Y | |
| 12 | ITEM_GROUP | VARCHAR2(3) | Y | |
| 13 | ITEM_GUBUN | VARCHAR2(1) | Y | |
| 14 | FIRST_SALES_DATE | DATE | Y | |
| 15 | SALES_END_GUBUN | VARCHAR2(1) | Y | |
| 16 | SALES_END_DATE | DATE | Y | |
| 17 | USE_YN | VARCHAR2(1) | Y | |
| 18 | ADD_QTY_YN | VARCHAR2(1) | Y | |
| 19 | MAIN_ITEM | VARCHAR2(1) | Y | |
| 20 | COMP_GUBUN | VARCHAR2(1) | Y | |
| 21 | TARGET_APPLY_YN | VARCHAR2(1) | Y | |
| 22 | WHOL_SALE_YN | VARCHAR2(1) | Y | |
| 23 | VAT_GUBUN | VARCHAR2(1) | Y | |
| 24 | ATTENTION_GUBUN | VARCHAR2(1) | Y | |
| 25 | SUM_ITEM_CODE | VARCHAR2(9) | Y | |
| 26 | MEDICAL_GUBUN | VARCHAR2(1) | Y | |
| 27 | ITEM_SHEET_YN | VARCHAR2(1) | Y | |
| 28 | PM_ITEM | VARCHAR2(1) | Y | |
| 29 | PM_EMP | VARCHAR2(6) | Y | |
| 30 | ITEM_WIDTH | NUMBER(4,1) | Y | |
| 31 | ITEM_LENGTH | NUMBER(4,1) | Y | |
| 32 | ITEM_HIGHT | NUMBER(4,1) | Y | |
| 33 | ITEM_WEIGHT | NUMBER(6,3) | Y | |
| 34 | DELIVERY_WORK | VARCHAR2(2) | Y | |
| 35 | STANDARD_BOX | VARCHAR2(3) | Y | |
| 36 | DELIVERY_PACKING | VARCHAR2(2) | Y | |
| 37 | SAFETY_YN | VARCHAR2(1) | Y | |
| 38 | OLD_ITEM_CODE | VARCHAR2(9) | Y | |
| 39 | FIRSTEMP | VARCHAR2(6) | Y | |
| 40 | FIRSTYMD | DATE | Y | |
| 41 | LASTEMP | VARCHAR2(6) | Y | |
| 42 | LASTYMD | DATE | Y | |
| 43 | ITEM_STD_CODE1 | VARCHAR2(13) | Y | |
| 44 | WHOLESALE_GUBUN | VARCHAR2(1) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_ITEM_1BACK | โ | ITEM_CODE |
PRODUCT_CODE
(์ถ์ ) ์ ํ์ค๋ช ํ ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | PRODUCT_CODE | VARCHAR2(7) | Y | |
| 2 | PRODUCT_NAME | VARCHAR2(50) | Y | |
| 3 | P_SHORTEN_NAME | VARCHAR2(25) | Y | |
| 4 | PRODUCT_SIZE | VARCHAR2(50) | Y | |
| 5 | PRODUCT_SHAPE | VARCHAR2(10) | Y | |
| 6 | PRODUCT_PACKING | NUMBER(18,0) | Y | |
| 7 | PRODUCT_UOM | VARCHAR2(6) | Y | |
| 8 | PRODUCT_GUBUN | VARCHAR2(2) | Y | |
| 9 | INSURANCE_CODE | VARCHAR2(10) | Y | |
| 10 | INSURANCE_GUBUN | VARCHAR2(2) | Y | |
| 11 | PRODUCE_GUBUN | VARCHAR2(1) | Y | |
| 12 | PRODUCE_YN | VARCHAR2(1) | Y | |
| 13 | KEEPING_POSITION | VARCHAR2(1) | Y | |
| 14 | EFFECT_MEDICINE | VARCHAR2(10) | Y | |
| 15 | PRODUCT_DANGA | NUMBER(18,0) | Y | |
| 16 | PRODUCT_DOMAE | NUMBER(18,0) | Y | |
| 17 | PRODUCT_HOSPITAL | NUMBER(18,0) | Y | |
| 18 | PRODUCT_INSURANCE | NUMBER(18,0) | Y | |
| 19 | PRODUCT_MAX_HAL | NUMBER(18,0) | Y | |
| 20 | GROUP_PRODUCT_CODE | VARCHAR2(7) | Y | |
| 21 | GROUP_PRODUCT_CODE_FLAG | VARCHAR2(1) | Y | |
| 22 | GROUP_PRODUCT_CONVERT | NUMBER(18,0) | Y | |
| 23 | INSERT_DATE | DATE | Y | |
| 24 | INSERT_EMPLOYE | VARCHAR2(6) | Y | |
| 25 | RESOURCE_TYPE | VARCHAR2(1) | Y | |
| 26 | COMMODITY | VARCHAR2(8) | Y | |
| 27 | SAWON_DANGA | NUMBER(18,0) | Y | |
| 28 | UOM | VARCHAR2(6) | Y | |
| 29 | UNIT | VARCHAR2(6) | Y | |
| 30 | BIGO | VARCHAR2(500) | Y | |
| 31 | LOT_CONTROL_FLAG | VARCHAR2(1) | Y | |
| 32 | ON_HAND_CONTROL_FLAG | VARCHAR2(1) | Y | |
| 33 | MATL_TYPE | VARCHAR2(1) | Y | |
| 34 | ACNT_CODE | VARCHAR2(7) | Y | |
| 35 | MEDICAL_CODE | VARCHAR2(10) | Y | |
| 36 | MEDICAL_PRODUCT_SIZE | VARCHAR2(10) | Y | |
| 37 | MEDICAL_UOM | VARCHAR2(10) | Y | |
| 38 | STANDARD_CODE | VARCHAR2(13) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PRODUCT_CODE_X | โ | PRODUCT_CODE |
QC_LOT_0812
(์ถ์ ) ๋ฐํ/๊ตํ LOT ๊ณ์ด
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | QC_DATE | VARCHAR2(8) | N | |
| 2 | QC_NO | NUMBER(4,0) | N | |
| 3 | QC_SEQ | NUMBER(2,0) | N | |
| 4 | QC_LOT | VARCHAR2(10) | N | |
| 5 | RETRN_QTY | NUMBER(7,0) | Y | |
| 6 | RETRN_BULK | NUMBER(7,0) | Y | |
| 7 | STOCK_QTY | NUMBER(7,0) | Y | |
| 8 | PACKING_QTY | NUMBER(7,0) | Y | |
| 9 | EXPRICE_QTY | NUMBER(7,0) | Y | |
| 10 | QUALITY_QTY | NUMBER(7,0) | Y | |
| 11 | DESTROY_QTY | NUMBER(7,0) | Y | |
| 12 | TEST_QTY | NUMBER(7,0) | Y | |
| 13 | DELETE_YN | VARCHAR2(1) | Y | |
| 14 | EMP_TQTY | NUMBER(9,0) | Y | |
| 15 | BASIC_PRICE | NUMBER(9,0) | Y | |
| 16 | RETRN_ITEM | VARCHAR2(9) | Y | |
| 17 | MANUFAC_DATE | VARCHAR2(8) | Y | |
| 18 | SLIP_IP | VARCHAR2(2) | Y | |
| 19 | LOT_SEQ | NUMBER(2,0) | Y | |
| 20 | RDATE | VARCHAR2(8) | Y | |
| 21 | RNO | NUMBER(4,0) | Y | |
| 22 | RSEQ | NUMBER(2,0) | Y |
๊ด๋ จ ๋ฌธ์
๊ฒ์ ํค์๋: UNION_ERP, Oracle, undefined, ํ๋ชฉ/์ ํ, ํ ์ด๋ธ ์นดํ๋ก๊ทธ, schema reference
Last updated on