SDW_TSLNF_BUDGET

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSLNF_BUDGET

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 PERIOD_TYPE CHARACTER VARYING(12) 12
3 OWNER_OCCUPIED_INVESTMENT_IND CHARACTER VARYING(24) 24
4 COST_CENTRE_CODE CHARACTER VARYING(24) 24
5 SOURCE_PRODUCT_LVLS_DIM_ID BIGINT 8
6 SALES_MEASURE_CODE CHARACTER VARYING(50) 50
7 BDGT_AMOUNT_WK NUMERIC(38,0) 19
8 BDGT_AMOUNT_MTD NUMERIC(38,0) 19
9 BDGT_AMOUNT_QTD NUMERIC(38,0) 19
10 BDGT_AMOUNT_FIN_YTD NUMERIC(38,0) 19
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8