| # |
Name |
Data Type |
Length |
| 1 |
CALENDAR_PERIOD_END_DATE |
TIMESTAMP |
8 |
| 2 |
BEC_COMBINED_PRODUCT |
CHARACTER VARYING(100) |
100 |
| 3 |
COST_CENTRE_CODE |
CHARACTER VARYING(240) |
240 |
| 4 |
CATEGORY |
CHARACTER VARYING(100) |
100 |
| 5 |
EXPENSE_TYPE |
CHARACTER VARYING(100) |
100 |
| 6 |
CC_L1 |
CHARACTER VARYING(240) |
240 |
| 7 |
CC_L2 |
CHARACTER VARYING(240) |
240 |
| 8 |
CUSTOMER_L2 |
CHARACTER VARYING(240) |
240 |
| 9 |
PRODUCT_L2 |
CHARACTER VARYING(240) |
240 |
| 10 |
ORG_REF |
CHARACTER VARYING(1000) |
1000 |
| 11 |
CSPD_REF |
CHARACTER VARYING(1000) |
1000 |
| 12 |
ALL_TIME_SID |
BIGINT |
8 |
| 13 |
LOOKUP_TYPE |
CHARACTER VARYING(2) |
2 |
| 14 |
MTD_ACTUAL |
NUMERIC(38,19) |
19 |
| 15 |
YTD_ACTUAL |
NUMERIC(38,19) |
19 |
| 16 |
PB_SPC_COMB_PRODUCT_AVG |
NUMERIC(38,2) |
19 |