์ฑ๊ถ/์๊ธ
์ญํ : ์ฐธ์กฐ (์นดํ ๊ณ ๋ฆฌ๋ณ ์นดํ๋ก๊ทธ)
๋์ ๋ ์: DBA ยท ์ด์ ๋ด๋น ยท ์ ๋ฌด ๋ถ์
์ธ์๋งค์ถ๊ธ, ๋ฏธ์๊ธ, ์ฑ๊ถ ๊ด๋ฆฌ
์ด ์นดํ ๊ณ ๋ฆฌ๋ ๋ฌด์์ ๋ด๋นํ๋
๊ฐ์ โ ์ธ์๋งค์ถ๊ธ, ๋ฏธ์๊ธ, ์ฑ๊ถ ๊ด๋ฆฌ
๊ตฌ์ฑ โ ์ด์ ํ ์ด๋ธ 5๊ฐ ยท ๋ฐฑ์ /์ด๋ ฅ 1๊ฐ (๋ง์ด๊ทธ๋ ์ด์ ์ ์ธ ํ๋ณด)
์ฃผ์ ํ ์ด๋ธ (ํ ์ ๊ธฐ์ค Top 3)
CREDIT_SALES_DAILYโ 4463097ํ ยท ์ผ์ผ๋ง๊ฐํํฉ_๊ฑฐ๋์ฒCREDIT_SALESโ 285229ํ ยท ๋งค์ถ์ฑ๊ถ_๊ฑฐ๋์ฒ(ํตํฉ)CREDIT_SALES_DAILY_Aโ 192901ํ ยท (์ถ์ ) ์ผ์ผ๋ง๊ฐํํฉ_๊ฑฐ๋์ฒ ๊ณ์ด
์ฃผ์ PK ํจํด โ CREDIT_DATE (4) ยท SALES_CODE (4) ยท DEPT_CODE (1) ยท EMP_NO (1)
์์ฝ
| ํญ๋ชฉ | ๊ฐ |
|---|---|
| ํ ์ด๋ธ ์ | 6 |
| ์ด ์ปฌ๋ผ ์ | 257 |
| PK ์์ | 5 |
| FK ๊ด๊ณ | 0 |
๊ด๊ณ๋
PK ์ปฌ๋ผ๋ช ๋งค์นญ ๊ธฐ๋ฐ ์ถ์ ๊ด๊ณ ยท ์ด 11๊ฐ ยท ์ค/ํฌ/๋ ธ๋ ๋๋๊ทธ/ํด๋ฆญ ํ์ด๋ผ์ดํธ
๊ด๊ณ๋ ๋ก๋ฉ ์ค...
ํ ์ด๋ธ ๋ชฉ๋ก
๐ฆ ๋ฐฑ์ /๋ฒ์ ํ ์ด๋ธ 1๊ฐ ํฌํจ ยท ๐ฅ 1๋งํ ์ด์ ยท โ ๏ธ ๋น ํ ์ด๋ธ
| # | ์ํ | ํ ์ด๋ธ๋ช | ์ปฌ๋ผ ์ | ํ ์ | PK | ์ค๋ช |
|---|---|---|---|---|---|---|
| 1 | ๐ฅ | CREDIT_SALES | 70 | 285,229 | โ | ๋งค์ถ์ฑ๊ถ_๊ฑฐ๋์ฒ(ํตํฉ) |
| 2 | ๐ฅ | CREDIT_SALES_DAILY | 21 | 4,463,097 | โ | ์ผ์ผ๋ง๊ฐํํฉ_๊ฑฐ๋์ฒ |
| 3 | ๐ฅ | CREDIT_SALES_DAILY_A | 24 | 192,901 | โ | (์ถ์ ) ์ผ์ผ๋ง๊ฐํํฉ_๊ฑฐ๋์ฒ ๊ณ์ด |
| 4 | ๐ฅ | CREDIT_SALES2 | 39 | 27,442 | โ | ์์ ๋ถ์ํ |
| 5 | ๐ฆ | CREDIT_SALES_20180410 | 70 | 757,823 | โ | ๐ฆ ๋งค์ถ์ฑ๊ถ_๊ฑฐ๋์ฒ(ํตํฉ)์ ๋ฐฑ์ |
| 6 | CONV_CREDIT | 33 | 7,295 | - | ์ธ๋งค์๊ณ ์ด๊ด์๋ฃ(๊ตฌERP SALES_CODE_SUM_MONTH) |
์์ธ ๋ช ์ธ
CREDIT_SALES
๋งค์ถ์ฑ๊ถ_๊ฑฐ๋์ฒ(ํตํฉ)
PK: CREDIT_DATE, SALES_CODE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | CREDIT_DATE | VARCHAR2(6) | N | ๋ ์ |
| 2 | SALES_CODE | VARCHAR2(6) | N | ๊ฑฐ๋์ฒ |
| 3 | BUSINESS_GUBUN | VARCHAR2(1) | Y | ์ฌ์ ๊ตฌ๋ถ(โS002โ) |
| 4 | DEPT_CODE | VARCHAR2(6) | Y | ์์ ์(๊ฑฐ๋์ฒ) |
| 5 | EMP_NO | VARCHAR2(6) | Y | ๋ด๋น์(๊ฑฐ๋์ฒ) |
| 6 | FLOW | VARCHAR2(1) | Y | ์ ํต๊ตฌ๋ถ |
| 7 | LM_REMAIN_AMT | NUMBER(11,0) | Y | ์ ์์ธ๋งค์์ก-๊ฑฐ๋์ฒ(์นด๋์๊ณ ) |
| 8 | LM_REMAIN_NET | NUMBER(11,0) | Y | ์ ์Net์์ก(์นด๋+๋ณด์ ์ด์) |
| 9 | LM_COREMAIN_AMT | NUMBER(11,0) | Y | ์ ์์ธ๋งค์์ก-ํ์ฌ(์ค์๊ณ ) |
| 10 | LM_DISHONOR_AMT | NUMBER(11,0) | Y | ์ ์๋ถ๋์ด์์์ก |
| 11 | LM_REMAIN_UNDECIDED | NUMBER(11,0) | Y | ์ ์๋ฏธ๊ฒฐ์์ก |
| 12 | SALES_AMT | NUMBER(11,0) | Y | ๊ณต๊ธ๊ฐ์ก(์ฃผ๋ฌธ์) |
| 13 | VAT_AMT | NUMBER(11,0) | Y | ๋ถ๊ฐ์ธ(์ฃผ๋ฌธ์) |
| 14 | REIN_AMT | NUMBER(11,0) | Y | ๋ฐํ๊ณต๊ธ๊ฐ์ก(์ฃผ๋ฌธ์) |
| 15 | REIN_VAT | NUMBER(11,0) | Y | ๋ฐํ๋ถ๊ฐ์ธ(์ฃผ๋ฌธ์) |
| 16 | UNDECIDED_AMT | NUMBER(11,0) | Y | ๊ณต๊ธ๊ฐ์ก(๊ณ์ฐ์) |
| 17 | UNDECIDED_VAT | NUMBER(11,0) | Y | ๋ถ๊ฐ์ธ(๊ณ์ฐ์) |
| 18 | REIN_UNDECIDED_AMT | NUMBER(11,0) | Y | ๋ฐํ๊ณต๊ธ๊ฐ์ก(๊ณ์ฐ์) |
| 19 | REIN_UNDECIDED_VAT | NUMBER(11,0) | Y | ๋ฐํ๋ถ๊ฐ์ธ(๊ณ์ฐ์) |
| 20 | CASH_AMT | NUMBER(11,0) | Y | ์๊ธ/ํ๊ธ |
| 21 | CARD_AMT | NUMBER(11,0) | Y | ์๊ธ/์นด๋ |
| 22 | ACCURENCE_AMT | NUMBER(11,0) | Y | ์๊ธ/ํ ๋ถ์์๋ฃ |
| 23 | BILL_AMT | NUMBER(11,0) | Y | ์๊ธ/์ด์ |
| 24 | DIS_AMT | NUMBER(11,0) | Y | ๋ถ๋ํ์๊ธ์ก |
| 25 | DISHONOR_AMT | NUMBER(11,0) | Y | ๋ถ๋๋ฐ์๊ธ์ก |
| 26 | SAL_DISC_AMT1 | NUMBER(11,0) | Y | ๋งค์ถํ ์ธ์งํ์ก(๊ฑฐ๋์ฒ) |
| 27 | SAL_DISC_AMT2 | NUMBER(11,0) | Y | ๋งค์ถํ ์ธ์งํ์ก(ํ์ฌ) |
| 28 | COL_DISC_AMT1 | NUMBER(11,0) | Y | ์ ๊ธ์ ๋ฆฌ(๊ฑฐ๋์ฒ) |
| 29 | COL_DISC_AMT2 | NUMBER(11,0) | Y | ์ ๊ธ์ ๋ฆฌ(ํ์ฌ) |
| 30 | RDISC_AMT1 | NUMBER(11,0) | Y | ํ๋งค์ฅ๋ ค๊ธ(๊ฑฐ๋์ฒ) |
| 31 | RDISC_AMT2 | NUMBER(11,0) | Y | ํ๋งค์ฅ๋ ค๊ธ(ํ์ฌ) |
| 32 | TRANSFER_REMAIN_1 | NUMBER(11,0) | Y | ์๊ณ ๋์ฒด+ |
| 33 | TRANSFER_REMAIN_2 | NUMBER(11,0) | Y | ์๊ณ ๋์ฒด- |
| 34 | TM_REMAIN_AMT | NUMBER(11,0) | Y | ๋น์์ธ๋งค์์ก-๊ฑฐ๋์ฒ(์นด๋์๊ณ ) |
| 35 | TM_COREMAIN_AMT | NUMBER(11,0) | Y | ๋น์์ธ๋งค์์ก-ํ์ฌ(์ค์๊ณ ) |
| 36 | TM_REVOLUTION | NUMBER(3,0) | Y | ํ์ ์ผ-๊ฑฐ๋์ฒ |
| 37 | TM_COREVOLUTION | NUMBER(3,0) | Y | ํ์ ์ผ-ํ์ฌ |
| 38 | TM_REMAIN_BILL | NUMBER(11,0) | Y | ๋น์๋ฏธ๋๋์ด์์์ก |
| 39 | TM_REMAIN_NET | NUMBER(11,0) | Y | ๋น์NET์์ก |
| 40 | TM_REVOLUTION_NET | NUMBER(3,0) | Y | ๋น์NETํ์ ์ผ-๊ฑฐ๋์ฒ |
| 41 | TM_DISHONOR_AMT | NUMBER(11,0) | Y | ๋น์๋ถ๋์ด์์์ก |
| 42 | GUARANTEE_AMT | NUMBER(11,0) | Y | ์ฌ์ ๊ธ์ก |
| 43 | NON_SALES | NUMBER(2,0) | Y | ๋ฌดํ๋งค์์ |
| 44 | NON_COLL | NUMBER(2,0) | Y | ๋ฌด์๊ธ์์ |
| 45 | BOOK_CLOSING_YN | VARCHAR2(1) | Y | ๋ง๊ฐ์ฌ๋ถ |
| 46 | BOOK_CLOSING_DATE | DATE | Y | ๋ง๊ฐ์ผ์ |
| 47 | UN_DISC_C_AMT | NUMBER(11,0) | Y | ํ๊ธ์ ๋ฆฌ |
| 48 | UN_DISC_G_AMT | NUMBER(11,0) | Y | ์ฝํ๋ณด์ |
| 49 | UN_DISC_T_AMT | NUMBER(11,0) | Y | ์ํ๊ถ |
| 50 | ACC_IM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 51 | ACC_TM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 52 | UN_DISC_VAT | NUMBER(11,0) | Y | |
| 53 | TAX_DEPTNO | VARCHAR2(6) | Y | |
| 54 | TAX_LINESEQ | NUMBER(4,0) | Y | |
| 55 | TAX_PRINT_DATE | DATE | Y | |
| 56 | TAX_PRINT_EMP | VARCHAR2(6) | Y | |
| 57 | ACC_DATA_NO | VARCHAR2(16) | Y | |
| 58 | CARD_AMT_01 | NUMBER(13,0) | Y | 1๊ฐ์์ด๋ด |
| 59 | CARD_AMT_02 | NUMBER(13,0) | Y | 2๊ฐ์์ด๋ด |
| 60 | CARD_AMT_03 | NUMBER(13,0) | Y | 3๊ฐ์์ด๋ด |
| 61 | CARD_AMT_04 | NUMBER(13,0) | Y | 4๊ฐ์์ด๋ด |
| 62 | CARD_AMT_05 | NUMBER(13,0) | Y | 5๊ฐ์์ด๋ด |
| 63 | CARD_AMT_06 | NUMBER(13,0) | Y | 6๊ฐ์์ด๋ด |
| 64 | CARD_AMT_07 | NUMBER(13,0) | Y | 7๊ฐ์์ด๋ด |
| 65 | CARD_AMT_08 | NUMBER(13,0) | Y | 8๊ฐ์์ด๋ด |
| 66 | CARD_AMT_09 | NUMBER(13,0) | Y | 9๊ฐ์์ด๋ด |
| 67 | CARD_AMT_10 | NUMBER(13,0) | Y | 10๊ฐ์์ด๋ด |
| 68 | CARD_AMT_11 | NUMBER(13,0) | Y | 11๊ฐ์์ด๋ด |
| 69 | CARD_AMT_12 | NUMBER(13,0) | Y | 12๊ฐ์์ด๋ด |
| 70 | CARD_AMT_13 | NUMBER(13,0) | Y | 12๊ฐ์์ดํ |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CREDIT_SALES | โ | CREDIT_DATE, SALES_CODE |
CREDIT_SALES_DAILY
์ผ์ผ๋ง๊ฐํํฉ_๊ฑฐ๋์ฒ
PK: CREDIT_DATE, SALES_CODE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | CREDIT_DATE | VARCHAR2(8) | N | ๋ ์์ผ |
| 2 | SALES_CODE | VARCHAR2(6) | N | ๊ฑฐ๋์ฒ |
| 3 | BUSINESS_GUBUN | VARCHAR2(1) | Y | |
| 4 | DEPT_CODE | VARCHAR2(6) | Y | ์์ ์ง์ |
| 5 | EMP_NO | VARCHAR2(6) | Y | ๋ด๋น์ |
| 6 | FLOW | VARCHAR2(1) | Y | ์ ํต๊ตฌ๋ถ |
| 7 | LM_COREMAIN_AMT | NUMBER(11,0) | Y | ์ ์ผ ์ค์๊ณ |
| 8 | UNDECIDED_AMT | NUMBER(11,0) | Y | ๋งค์ถ์ก(๊ณ์ฐ์) |
| 9 | UNDECIDED_VAT | NUMBER(11,0) | Y | ๋ถ๊ฐ์ธ(๊ณ์ฐ์) |
| 10 | REIN_UNDECIDED_AMT | NUMBER(11,0) | Y | ๋ฐํ๋งค์ถ(๊ณ์ฐ์) |
| 11 | REIN_UNDECIDED_VAT | NUMBER(11,0) | Y | ๋ฐํ๋ถ๊ฐ์ธ(๊ณ์ฐ์) |
| 12 | COLLECT_AMT | NUMBER(11,0) | Y | ์๊ธ(์นด๋,ํ๊ธ,๋ณดํต์๊ธ ํฉ๊ณ) |
| 13 | TM_COREMAIN_AMT | NUMBER(11,0) | Y | ๋น์ผ ์ค์๊ณ |
| 14 | TM_COREVOLUTION | NUMBER(3,0) | Y | ํ์ ์ผ |
| 15 | CARD_AMT_01 | NUMBER(13,0) | Y | ~31์ผ์ด๋ด ๋งค์ถ์ก |
| 16 | CARD_AMT_02 | NUMBER(13,0) | Y | ~62์ผ์ด๋ด ๋งค์ถ์ก |
| 17 | CARD_AMT_03 | NUMBER(13,0) | Y | ~92์ผ์ด๋ด ๋งค์ถ์ก |
| 18 | FIRST_EMP | VARCHAR2(6) | Y | |
| 19 | FIRST_YMD | DATE | Y | |
| 20 | LAST_EMP | VARCHAR2(6) | Y | |
| 21 | LAST_YMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CREDIT_SALES_DAILY | โ | CREDIT_DATE, SALES_CODE |
CREDIT_SALES_DAILY_A
(์ถ์ ) ์ผ์ผ๋ง๊ฐํํฉ_๊ฑฐ๋์ฒ ๊ณ์ด
PK: CREDIT_DATE, SALES_CODE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | CREDIT_DATE | VARCHAR2(8) | N | |
| 2 | SALES_CODE | VARCHAR2(6) | N | |
| 3 | BUSINESS_GUBUN | VARCHAR2(1) | Y | |
| 4 | DEPT_CODE | VARCHAR2(6) | Y | |
| 5 | EMP_NO | VARCHAR2(6) | Y | |
| 6 | FLOW | VARCHAR2(1) | Y | |
| 7 | LM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 8 | UNDECIDED_AMT | NUMBER(11,0) | Y | |
| 9 | UNDECIDED_VAT | NUMBER(11,0) | Y | |
| 10 | REIN_UNDECIDED_AMT | NUMBER(11,0) | Y | |
| 11 | REIN_UNDECIDED_VAT | NUMBER(11,0) | Y | |
| 12 | COLLECT_AMT | NUMBER(11,0) | Y | |
| 13 | TM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 14 | TM_COREVOLUTION | NUMBER(3,0) | Y | |
| 15 | CARD_AMT_01 | NUMBER(13,0) | Y | |
| 16 | CARD_AMT_02 | NUMBER(13,0) | Y | |
| 17 | CARD_AMT_03 | NUMBER(13,0) | Y | |
| 18 | COLLECT_AMT_01 | NUMBER(13,0) | Y | |
| 19 | COLLECT_AMT_02 | NUMBER(13,0) | Y | |
| 20 | COLLECT_AMT_03 | NUMBER(13,0) | Y | |
| 21 | FIRST_EMP | VARCHAR2(6) | Y | |
| 22 | FIRST_YMD | DATE | Y | |
| 23 | LAST_EMP | VARCHAR2(6) | Y | |
| 24 | LAST_YMD | DATE | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CREDIT_SALES_DAILY_A | โ | CREDIT_DATE, SALES_CODE |
CREDIT_SALES2
์์ ๋ถ์ํ
PK: SALES_CODE, CREDIT_DATE, DEPT_CODE, EMP_NO
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | SALES_CODE | CHAR(6) | N | ๊ฑฐ๋์ฒ์ฝ๋ |
| 2 | CREDIT_DATE | CHAR(6) | N | ํ๋งค์๊ธ์ผ์ |
| 3 | DEPT_CODE | CHAR(6) | N | ์์ ์์ฝ๋ |
| 4 | EMP_NO | CHAR(6) | N | ๋ด๋น์์ฝ๋ |
| 5 | B_CARD_AMT | NUMBER(13,0) | Y | ์ ์ผ์นด๋์๊ณ |
| 6 | B_REAL_AMT | NUMBER(13,0) | Y | ์ ์ผ์ค์๊ณ |
| 7 | B_OUTB_AMT | NUMBER(13,0) | Y | ์ ์ผ์นด๋์๊ณ (๋ฏธ๋๋์ด์ํฌํจ) |
| 8 | SUPPLY_SUM | NUMBER(13,0) | Y | ์นด๋๋งค์ถ์ก |
| 9 | TAX_SUM | NUMBER(13,0) | Y | ์ค๋งค์ถ์ก |
| 10 | RETURN_SUPPLY_SUM | NUMBER(13,0) | Y | ์นด๋๋ฐํ์ก |
| 11 | RETURN_TAX_SUM | NUMBER(13,0) | Y | ์ค๋ฐํ์ก |
| 12 | COLLECT_AMT_1 | NUMBER(13,0) | Y | ์๊ธ์ก(ํ๊ธ) |
| 13 | COLLECT_AMT_2 | NUMBER(13,0) | Y | ์๊ธ์ก(๋ณดํต์๊ธ) |
| 14 | COLLECT_AMT_3 | NUMBER(13,0) | Y | ์๊ธ์ก(์ด์) |
| 15 | COLLECT_AMT_4 | NUMBER(13,0) | Y | ์๊ธ์ก(์นด๋) |
| 16 | CONTRACT_01 | NUMBER(13,0) | Y | ๋งค์ถํ ์ธ(์์ฐ) |
| 17 | CONTRACT_02 | NUMBER(13,0) | Y | ์ ๊ธ์ ๋ฆฌ(์์ฐ) |
| 18 | CONTRACT_03 | NUMBER(13,0) | Y | ํ๋งค์ฅ๋ ค๊ธ(์์ฐ) |
| 19 | CONTRACT_04 | NUMBER(13,0) | Y | ์ํ๊ถ(์์ฐ) |
| 20 | CONTRACT_05 | NUMBER(13,0) | Y | ํ๊ธ์ ๋ฆฌ(์์ฐ) |
| 21 | CONTRACT_06 | NUMBER(13,0) | Y | ์ฝํ๋ณด์(์์ฐ) |
| 22 | COLLECT_01 | NUMBER(13,0) | Y | ๋งค์ถํ ์ธ์งํ์ก |
| 23 | COLLECT_02 | NUMBER(13,0) | Y | ์ ๊ธ์ ๋ฆฌ์งํ์ก |
| 24 | COLLECT_03 | NUMBER(13,0) | Y | ํ๋งค์ฅ๋ ค๊ธ์งํ์ก |
| 25 | COLLECT_04 | NUMBER(13,0) | Y | ์ํ๊ถ์งํ์ก |
| 26 | COLLECT_05 | NUMBER(13,0) | Y | ํ๊ธ์ ๋ฆฌ์งํ์ก |
| 27 | COLLECT_06 | NUMBER(13,0) | Y | ์ฝํ๋ณด์์งํ์ก |
| 28 | COLLECT_07 | NUMBER(13,0) | Y | ์๊ธํ ์ธ-๋งค์ถํ ์ธ์งํ์ก |
| 29 | COLLECT_08 | NUMBER(13,0) | Y | ์๊ธํ ์ธ-์ ๊ธ์ ๋ฆฌ์งํ์ก |
| 30 | COLLECT_09 | NUMBER(13,0) | Y | ์๊ธํ ์ธ-ํ๋งค์ฅ๋ ค๊ธ์งํ์ก |
| 31 | COLLECT_10 | NUMBER(13,0) | Y | ์๊ณ ์ด์ฒด์ ๊ธ |
| 32 | COLLECT_11 | NUMBER(13,0) | Y | ์๊ณ ์ด์ฒด์ถ๊ธ |
| 33 | OUTBILL_SUM | NUMBER(13,0) | Y | ๋ฏธ๋๋์ด์ |
| 34 | CARD_AMT | NUMBER(13,0) | Y | ์นด๋์๊ณ |
| 35 | REAL_AMT | NUMBER(13,0) | Y | ์ค์๊ณ |
| 36 | OUTB_AMT | NUMBER(13,0) | Y | ์นด๋์๊ณ (๋ฏธ๋๋์ด์ํฌํจ) |
| 37 | CARD_CYCLE | NUMBER(5,0) | Y | ์นด๋ํ์ ์ผ |
| 38 | REAL_CYCLE | NUMBER(5,0) | Y | ์คํ์ ์ผ |
| 39 | OUTB_CYCLE | NUMBER(5,0) | Y | ์นด๋(๋ฏธ๋๋์ด์ํฌํจ)ํ์ ์ผ |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CREDIT_SALES2 | โ | SALES_CODE, CREDIT_DATE, DEPT_CODE, EMP_NO |
CREDIT_SALES_20180410
๐ฆ ๋ฐฑ์ ํ ์ด๋ธ โ
CREDIT_SALES์ ์์ ๋ณต์ฌ๋ณธ. ๋ง์ด๊ทธ๋ ์ด์ ๋์์์ ์ ์ธ ๊ฒํ .
PK: CREDIT_DATE, SALES_CODE
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | CREDIT_DATE | VARCHAR2(6) | N | |
| 2 | SALES_CODE | VARCHAR2(6) | N | |
| 3 | BUSINESS_GUBUN | VARCHAR2(1) | Y | |
| 4 | DEPT_CODE | VARCHAR2(6) | Y | |
| 5 | EMP_NO | VARCHAR2(6) | Y | |
| 6 | FLOW | VARCHAR2(1) | Y | |
| 7 | LM_REMAIN_AMT | NUMBER(11,0) | Y | |
| 8 | LM_REMAIN_NET | NUMBER(11,0) | Y | |
| 9 | LM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 10 | LM_DISHONOR_AMT | NUMBER(11,0) | Y | |
| 11 | LM_REMAIN_UNDECIDED | NUMBER(11,0) | Y | |
| 12 | SALES_AMT | NUMBER(11,0) | Y | |
| 13 | VAT_AMT | NUMBER(11,0) | Y | |
| 14 | REIN_AMT | NUMBER(11,0) | Y | |
| 15 | REIN_VAT | NUMBER(11,0) | Y | |
| 16 | UNDECIDED_AMT | NUMBER(11,0) | Y | |
| 17 | UNDECIDED_VAT | NUMBER(11,0) | Y | |
| 18 | REIN_UNDECIDED_AMT | NUMBER(11,0) | Y | |
| 19 | REIN_UNDECIDED_VAT | NUMBER(11,0) | Y | |
| 20 | CASH_AMT | NUMBER(11,0) | Y | |
| 21 | CARD_AMT | NUMBER(11,0) | Y | |
| 22 | ACCURENCE_AMT | NUMBER(11,0) | Y | |
| 23 | BILL_AMT | NUMBER(11,0) | Y | |
| 24 | DIS_AMT | NUMBER(11,0) | Y | |
| 25 | DISHONOR_AMT | NUMBER(11,0) | Y | |
| 26 | SAL_DISC_AMT1 | NUMBER(11,0) | Y | |
| 27 | SAL_DISC_AMT2 | NUMBER(11,0) | Y | |
| 28 | COL_DISC_AMT1 | NUMBER(11,0) | Y | |
| 29 | COL_DISC_AMT2 | NUMBER(11,0) | Y | |
| 30 | RDISC_AMT1 | NUMBER(11,0) | Y | |
| 31 | RDISC_AMT2 | NUMBER(11,0) | Y | |
| 32 | TRANSFER_REMAIN_1 | NUMBER(11,0) | Y | |
| 33 | TRANSFER_REMAIN_2 | NUMBER(11,0) | Y | |
| 34 | TM_REMAIN_AMT | NUMBER(11,0) | Y | |
| 35 | TM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 36 | TM_REVOLUTION | NUMBER(3,0) | Y | |
| 37 | TM_COREVOLUTION | NUMBER(3,0) | Y | |
| 38 | TM_REMAIN_BILL | NUMBER(11,0) | Y | |
| 39 | TM_REMAIN_NET | NUMBER(11,0) | Y | |
| 40 | TM_REVOLUTION_NET | NUMBER(3,0) | Y | |
| 41 | TM_DISHONOR_AMT | NUMBER(11,0) | Y | |
| 42 | GUARANTEE_AMT | NUMBER(11,0) | Y | |
| 43 | NON_SALES | NUMBER(2,0) | Y | |
| 44 | NON_COLL | NUMBER(2,0) | Y | |
| 45 | BOOK_CLOSING_YN | VARCHAR2(1) | Y | |
| 46 | BOOK_CLOSING_DATE | DATE | Y | |
| 47 | UN_DISC_C_AMT | NUMBER(11,0) | Y | |
| 48 | UN_DISC_G_AMT | NUMBER(11,0) | Y | |
| 49 | UN_DISC_T_AMT | NUMBER(11,0) | Y | |
| 50 | ACC_IM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 51 | ACC_TM_COREMAIN_AMT | NUMBER(11,0) | Y | |
| 52 | UN_DISC_VAT | NUMBER(11,0) | Y | |
| 53 | TAX_DEPTNO | VARCHAR2(6) | Y | |
| 54 | TAX_LINESEQ | NUMBER(4,0) | Y | |
| 55 | TAX_PRINT_DATE | DATE | Y | |
| 56 | TAX_PRINT_EMP | VARCHAR2(6) | Y | |
| 57 | ACC_DATA_NO | VARCHAR2(16) | Y | |
| 58 | CARD_AMT_01 | NUMBER(13,0) | Y | |
| 59 | CARD_AMT_02 | NUMBER(13,0) | Y | |
| 60 | CARD_AMT_03 | NUMBER(13,0) | Y | |
| 61 | CARD_AMT_04 | NUMBER(13,0) | Y | |
| 62 | CARD_AMT_05 | NUMBER(13,0) | Y | |
| 63 | CARD_AMT_06 | NUMBER(13,0) | Y | |
| 64 | CARD_AMT_07 | NUMBER(13,0) | Y | |
| 65 | CARD_AMT_08 | NUMBER(13,0) | Y | |
| 66 | CARD_AMT_09 | NUMBER(13,0) | Y | |
| 67 | CARD_AMT_10 | NUMBER(13,0) | Y | |
| 68 | CARD_AMT_11 | NUMBER(13,0) | Y | |
| 69 | CARD_AMT_12 | NUMBER(13,0) | Y | |
| 70 | CARD_AMT_13 | NUMBER(13,0) | Y |
์ธ๋ฑ์ค (1๊ฐ)
| ์ธ๋ฑ์ค๋ช | ์ ๋ํฌ | ์ปฌ๋ผ |
|---|---|---|
| PK_CREDIT_SALES_20180410 | โ | CREDIT_DATE, SALES_CODE |
CONV_CREDIT
์ธ๋งค์๊ณ ์ด๊ด์๋ฃ(๊ตฌERP SALES_CODE_SUM_MONTH)
| # | ์ปฌ๋ผ๋ช | ํ์ | Null | ์ค๋ช |
|---|---|---|---|---|
| 1 | YEAR | VARCHAR2(4) | Y | |
| 2 | MONTH | VARCHAR2(2) | Y | |
| 3 | SALES_CODE | VARCHAR2(7) | Y | |
| 4 | EMP_CODE | VARCHAR2(5) | Y | |
| 5 | OFFICE_CODE | VARCHAR2(5) | Y | |
| 6 | SALES_NAME | VARCHAR2(60) | Y | |
| 7 | EMP_NAME | VARCHAR2(25) | Y | |
| 8 | OFFICE_NAME | VARCHAR2(20) | Y | |
| 9 | IWOL_AMOUNT | NUMBER(11,0) | Y | |
| 10 | IWOL_PENDING_BILL_AMOUNT | NUMBER(11,0) | Y | |
| 11 | IWOL_CHULGO_AMOUNT | NUMBER(11,0) | Y | |
| 12 | DANGIWOL_AMOUNT | NUMBER(11,0) | Y | |
| 13 | DANGIWOL_PENDING_BILL_AMOUNT | NUMBER(11,0) | Y | |
| 14 | DANGIWOL_CHULGO_AMOUNT | NUMBER(11,0) | Y | |
| 15 | ORDER_AMOUNT | NUMBER(11,0) | Y | |
| 16 | ORDER_VAT | NUMBER(11,0) | Y | |
| 17 | ORDER_DISCOUNT | NUMBER(11,0) | Y | |
| 18 | ORDER_CHULGO_AMOUNT | NUMBER(11,0) | Y | |
| 19 | ORDER_CHULGO_VAT | NUMBER(11,0) | Y | |
| 20 | ORDER_RETURN_AMOUNT | NUMBER(11,0) | Y | |
| 21 | ORDER_RETURN_VAT | NUMBER(11,0) | Y | |
| 22 | ORDER_RETURN_TOT_AMOUNT | NUMBER(11,0) | Y | |
| 23 | ORDER_RETURN_TOT_VAT | NUMBER(11,0) | Y | |
| 24 | COLLECT_CASH | NUMBER(11,0) | Y | |
| 25 | COLLECT_BILL | NUMBER(11,0) | Y | |
| 26 | COLLECT_CARD | NUMBER(11,0) | Y | |
| 27 | COLLECT_DEPOSIT | NUMBER(11,0) | Y | |
| 28 | COLLECT_OTHERS | NUMBER(11,0) | Y | |
| 29 | COLLECT_SALE_DISCOUNT | NUMBER(11,0) | Y | |
| 30 | COLLECT_COLLECT_DISCOUNT | NUMBER(11,0) | Y | |
| 31 | EXPIRE_BILL | NUMBER(11,0) | Y | |
| 32 | LAST_SALE_DATE | DATE | Y | |
| 33 | LAST_COLLECT_DATE | DATE | Y |
๊ด๋ จ ๋ฌธ์
๊ฒ์ ํค์๋: UNION_ERP, Oracle, undefined, ์ฑ๊ถ/์๊ธ, ํ ์ด๋ธ ์นดํ๋ก๊ทธ, schema reference
Last updated on