FCT_BNK_OSX_T_BACK_OFFICE_BALANCE_SUN_PREP

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BNK_OSX_T_BACK_OFFICE_BALANCE_SUN_PREP_V

Columns
# Name Data Type Length
1 BALANCE_DATE DATE 4
2 ENTITY NATIONAL CHARACTER VARYING(24) 24
3 AMOUNT_CLASS NATIONAL CHARACTER VARYING(20) 20
4 CUSTOMER_NR NATIONAL CHARACTER VARYING(60) 60
5 ACCOUNT_CODE NATIONAL CHARACTER VARYING(40) 40
6 DEAL_ID NATIONAL CHARACTER VARYING(80) 80
7 PROFIT_CENTRE NATIONAL CHARACTER VARYING(24) 24
8 MEASUREMENT_CATEGORY NATIONAL CHARACTER VARYING(12) 12
9 SOURCE_SYSTEM NATIONAL CHARACTER VARYING(80) 80
10 BOOK_CODE NATIONAL CHARACTER VARYING(20) 20
11 RV_INT_RATE_TYPE NATIONAL CHARACTER VARYING(80) 80
12 RV_PURPOSE NATIONAL CHARACTER VARYING(40) 40
13 RV_OFFSET NATIONAL CHARACTER VARYING(80) 80
14 IS_SECURITISED BYTEINT 1
15 SYNDICATION_ROLE NATIONAL CHARACTER VARYING(40) 40
16 RV_IMPAIRED NATIONAL CHARACTER VARYING(80) 80
17 RV_REVOLVING_FAC NATIONAL CHARACTER VARYING(80) 80
18 RV_SETT_CREDIT NATIONAL CHARACTER VARYING(80) 80
19 RV_SECURED_RES NATIONAL CHARACTER VARYING(80) 80
20 RV_SECURED_BY_RES_PROP NATIONAL CHARACTER VARYING(80) 80
21 RV_STATE_PROPLOC_UF NATIONAL CHARACTER VARYING(80) 80
22 RV_COMM_PROP_EXP NATIONAL CHARACTER VARYING(80) 80
23 ELEMENT1 NATIONAL CHARACTER VARYING(60) 60
24 ELEMENT2 NATIONAL CHARACTER VARYING(60) 60
25 ELEMENT3 NATIONAL CHARACTER VARYING(60) 60
26 ELEMENT4 NATIONAL CHARACTER VARYING(40) 40
27 ELEMENT5 NATIONAL CHARACTER VARYING(40) 40
28 ACCOUNT_TYPE_CONVERSION NATIONAL CHARACTER VARYING(40) 40
29 ELEMENT6 NATIONAL CHARACTER VARYING(40) 40
30 ELEMENT7 NATIONAL CHARACTER VARYING(40) 40
31 ELEMENT8 NATIONAL CHARACTER VARYING(40) 40
32 ELEMENT9 NATIONAL CHARACTER VARYING(40) 40
33 DOMAIN_ID INTEGER 4
34 CURRENCY NATIONAL CHARACTER VARYING(6) 6
35 LEDGER_BALANCE NUMERIC(25,8) 19
36 LEDGER_BALANCE_SIGNED NUMERIC(25,8) 19
37 CLEARED_BALANCE NUMERIC(25,8) 19
38 LAST_MODIFIED DATE 4
39 MODIFIED_BY NATIONAL CHARACTER VARYING(510) 510