RDM_BANK_EFS_CHART_OF_ACCOUNTS_V
Description
Synonyms
SDSNZP02_BANK..EFS_RDM_BANK_EFS_CHART_OF_ACCOUNTS_V
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | INTEGER | 4 |
| 2 | MUID | CHARACTER VARYING(4000) | 4000 |
| 3 | VERSIONNAME | NATIONAL CHARACTER VARYING(50) | 50 |
| 4 | VERSIONNUMBER | INTEGER | 4 |
| 5 | VERSION_ID | INTEGER | 4 |
| 6 | VERSIONFLAG | NATIONAL CHARACTER VARYING(50) | 50 |
| 7 | NAME | NATIONAL CHARACTER VARYING(250) | 250 |
| 8 | CODE | NATIONAL CHARACTER VARYING(250) | 250 |
| 9 | CHANGETRACKINGMASK | INTEGER | 4 |
| 10 | SOURCE_SYSTEM_CODE | NATIONAL CHARACTER VARYING(250) | 250 |
| 11 | SOURCE_SYSTEM_NAME | NATIONAL CHARACTER VARYING(250) | 250 |
| 12 | SOURCE_SYSTEM_ID | INTEGER | 4 |
| 13 | ENTITY | NUMERIC(31,0) | 19 |
| 14 | DEAL_ID | NATIONAL CHARACTER VARYING(100) | 100 |
| 15 | ACCOUNT_CODE | NUMERIC(31,0) | 19 |
| 16 | BOOK_CODE_CODE | NATIONAL CHARACTER VARYING(250) | 250 |
| 17 | BOOK_CODE_NAME | NATIONAL CHARACTER VARYING(250) | 250 |
| 18 | BOOK_CODE_ID | INTEGER | 4 |
| 19 | RELATED_PARTY_CODE | NATIONAL CHARACTER VARYING(250) | 250 |
| 20 | RELATED_PARTY_NAME | NATIONAL CHARACTER VARYING(250) | 250 |
| 21 | RELATED_PARTY_ID | INTEGER | 4 |
| 22 | ELEMENT4 | NATIONAL CHARACTER VARYING(100) | 100 |
| 23 | INTRA_GROUP_DEPOSITS | NATIONAL CHARACTER VARYING(20) | 20 |
| 24 | INTRA_GROUP_NETTING | NATIONAL CHARACTER VARYING(20) | 20 |
| 25 | IS_SECURITIZED_CODE | NATIONAL CHARACTER VARYING(250) | 250 |
| 26 | IS_SECURITIZED_NAME | NATIONAL CHARACTER VARYING(250) | 250 |
| 27 | IS_SECURITIZED_ID | INTEGER | 4 |
| 28 | FUNDING_CENTRE | NATIONAL CHARACTER VARYING(170) | 170 |
| 29 | CHAR_CUST_ELEMENT3 | NATIONAL CHARACTER VARYING(100) | 100 |
| 30 | CHAR_CUST_ELEMENT4 | NATIONAL CHARACTER VARYING(100) | 100 |
| 31 | RV_COA | NATIONAL CHARACTER VARYING(100) | 100 |
| 32 | INTERNAL_FRC_REFERENCE | NATIONAL CHARACTER VARYING(115) | 115 |
| 33 | ENTERDATETIME | TIMESTAMP | 8 |
| 34 | ENTERUSERNAME | NATIONAL CHARACTER VARYING(100) | 100 |
| 35 | ENTERVERSIONNUMBER | INTEGER | 4 |
| 36 | LASTCHGDATETIME | TIMESTAMP | 8 |
| 37 | LASTCHGUSERNAME | NATIONAL CHARACTER VARYING(100) | 100 |
| 38 | LASTCHGVERSIONNUMBER | INTEGER | 4 |
| 39 | VALIDATIONSTATUS | NATIONAL CHARACTER VARYING(250) | 250 |
| 40 | CDC_SRC_SYSTEM_CODE | CHARACTER(4) | 4 |
| 41 | CDC_RECORD_TYPE | CHARACTER(14) | 14 |
| 42 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 43 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |