DIM_BNK_OSX_T_ENTITY_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ENTITY | CHARACTER VARYING(12) | 12 |
| 2 | NAME | CHARACTER VARYING(128) | 128 |
| 3 | DESCRIPTION | CHARACTER VARYING(1024) | 1024 |
| 4 | CALENDAR | CHARACTER VARYING(10) | 10 |
| 5 | ACCOUNT_CATEGORY | CHARACTER VARYING(8) | 8 |
| 6 | PREV_COB_DATE | DATE | 4 |
| 7 | COB_DATE | DATE | 4 |
| 8 | NEXT_COB_DATE | DATE | 4 |
| 9 | CURRENT_YEAR | INTEGER | 4 |
| 10 | CURRENT_PERIOD | INTEGER | 4 |
| 11 | REPORTING_YEAR | INTEGER | 4 |
| 12 | REPORTING_PERIOD | INTEGER | 4 |
| 13 | ED_NUM_PERIODS_FORWARD | INTEGER | 4 |
| 14 | ED_NUM_PERIODS_BACK | INTEGER | 4 |
| 15 | VD_NUM_PERIODS_FORWARD | INTEGER | 4 |
| 16 | VD_NUM_PERIODS_BACK | INTEGER | 4 |
| 17 | LCL_CURRENCY | CHARACTER VARYING(3) | 3 |
| 18 | RPT_CURRENCY | CHARACTER VARYING(3) | 3 |
| 19 | TYP_LGE_TYPE | INTEGER | 4 |
| 20 | CHAR_CUST_ELEMENT1 | CHARACTER VARYING(40) | 40 |
| 21 | CHAR_CUST_ELEMENT2 | CHARACTER VARYING(40) | 40 |
| 22 | CHAR_CUST_ELEMENT3 | CHARACTER VARYING(40) | 40 |
| 23 | CHAR_CUST_ELEMENT4 | CHARACTER VARYING(40) | 40 |
| 24 | CHAR_CUST_ELEMENT5 | CHARACTER VARYING(40) | 40 |
| 25 | NUM_CUST_ELEMENT1 | NUMERIC(25,8) | 19 |
| 26 | NUM_CUST_ELEMENT2 | NUMERIC(25,8) | 19 |
| 27 | NUM_CUST_ELEMENT3 | NUMERIC(25,8) | 19 |
| 28 | NUM_CUST_ELEMENT4 | NUMERIC(25,8) | 19 |
| 29 | NUM_CUST_ELEMENT5 | NUMERIC(25,8) | 19 |
| 30 | LAST_MODIFIED | CHARACTER VARYING(1) | 1 |
| 31 | MODIFIED_BY | CHARACTER VARYING(255) | 255 |