| # |
Name |
Data Type |
Length |
| 1 |
ACCOUNT_DIM_ID |
CHARACTER VARYING(301) |
301 |
| 2 |
ACCOUNT_CODE |
CHARACTER VARYING(301) |
301 |
| 3 |
ACCOUNT_NAME |
CHARACTER VARYING(240) |
240 |
| 4 |
EFFECTIVE_FROM_DATE |
TIMESTAMP |
8 |
| 5 |
EFFECTIVE_TO_DATE |
TIMESTAMP |
8 |
| 6 |
CREATED_DATE |
TIMESTAMP |
8 |
| 7 |
CHANGED_DATE |
TIMESTAMP |
8 |
| 8 |
ACCOUNT_LEVEL_01_CODE |
CHARACTER VARYING(301) |
301 |
| 9 |
ACCOUNT_LEVEL_01_NAME |
CHARACTER VARYING(240) |
240 |
| 10 |
ACCOUNT_LEVEL_02_CODE |
CHARACTER VARYING(150) |
150 |
| 11 |
ACCOUNT_LEVEL_02_NAME |
CHARACTER VARYING(240) |
240 |
| 12 |
ACCOUNT_LEVEL_03_CODE |
CHARACTER VARYING(150) |
150 |
| 13 |
ACCOUNT_LEVEL_03_NAME |
CHARACTER VARYING(240) |
240 |
| 14 |
ACCOUNT_LEVEL_04_CODE |
CHARACTER VARYING(150) |
150 |
| 15 |
ACCOUNT_LEVEL_04_NAME |
CHARACTER VARYING(240) |
240 |
| 16 |
ACCOUNT_LEVEL_05_CODE |
CHARACTER VARYING(150) |
150 |
| 17 |
ACCOUNT_LEVEL_05_NAME |
CHARACTER VARYING(240) |
240 |
| 18 |
ACCOUNT_LEVEL_06_CODE |
CHARACTER VARYING(150) |
150 |
| 19 |
ACCOUNT_LEVEL_06_NAME |
CHARACTER VARYING(240) |
240 |
| 20 |
ACCOUNT_LEVEL_07_CODE |
CHARACTER VARYING(150) |
150 |
| 21 |
ACCOUNT_LEVEL_07_NAME |
CHARACTER VARYING(240) |
240 |
| 22 |
ACCOUNT_LEVEL_08_CODE |
CHARACTER VARYING(150) |
150 |
| 23 |
ACCOUNT_LEVEL_08_NAME |
CHARACTER VARYING(240) |
240 |
| 24 |
ACCOUNT_LEVEL_09_CODE |
CHARACTER VARYING(150) |
150 |
| 25 |
ACCOUNT_LEVEL_09_NAME |
CHARACTER VARYING(240) |
240 |
| 26 |
ACCOUNT_LEVEL_10_CODE |
CHARACTER VARYING(150) |
150 |
| 27 |
ACCOUNT_LEVEL_10_NAME |
CHARACTER VARYING(240) |
240 |