EXT_FCT_ATOCRS_CRS_ATO_ENTITY_QUALIFICATION
Description
Target Objects (CTAS)
INSNZP02_BANK..EXT_FCT_ATOCRS_CRS_ATO_ENTITY_QUALIFICATION_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | RUN_YEAR | BIGINT | 8 |
| 2 | REPORTING_YEAR | BIGINT | 8 |
| 3 | GCIS_CUSTOMER_NUMBER | INTEGER | 4 |
| 4 | PRODUCT_SYSTEM_COMPANY_CODE | CHARACTER VARYING(12) | 12 |
| 5 | PRODUCT_SYSTEM_CUSTOMER_NUMBER | CHARACTER VARYING(50) | 50 |
| 6 | CUSTOMER_TYPE | CHARACTER VARYING(20) | 20 |
| 7 | PROFILE_STATUS | CHARACTER VARYING(8) | 8 |
| 8 | NEW_GCIS_CUSTOMER_NUMBER_1 | INTEGER | 4 |
| 9 | NEW_GCIS_CUSTOMER_NUMBER_2 | INTEGER | 4 |
| 10 | GCIS_AUDIT_DESCRIPTION | CHARACTER VARYING(300) | 300 |
| 11 | ENTITY_NAME | CHARACTER VARYING(1014) | 1014 |
| 12 | ADDRESS_LINE_1 | CHARACTER VARYING(120) | 120 |
| 13 | ADDRESS_LINE_2 | CHARACTER VARYING(120) | 120 |
| 14 | ADDRESS_LINE_3 | CHARACTER VARYING(120) | 120 |
| 15 | CITY_TWN_SUBURB | CHARACTER VARYING(70) | 70 |
| 16 | STATE | CHARACTER VARYING(70) | 70 |
| 17 | POST_CODE | CHARACTER VARYING(30) | 30 |
| 18 | COUNTRY | CHARACTER VARYING(24) | 24 |
| 19 | BANK_PRODUCT_HOLDING_NUMBER | CHARACTER VARYING(45) | 45 |
| 20 | CUST_PRDT_RSHIP_TYP_CODE | CHARACTER VARYING(24) | 24 |
| 21 | CUST_PRDT_RSHIP_TYP_DESC | CHARACTER VARYING(256) | 256 |
| 22 | FATCA_RELATIONSHIP_TYPE | CHARACTER VARYING(100) | 100 |
| 23 | FATCA_SELF_CERTIFICATION_FLAG | CHARACTER VARYING(50) | 50 |
| 24 | DERIVED_ROLE_EFF_DATE | CHARACTER VARYING(200) | 200 |
| 25 | DERIVED_ROLE_EXPIRY_DATE | CHARACTER VARYING(200) | 200 |
| 26 | TAX_LIABLE | CHARACTER VARYING(255) | 255 |
| 27 | TAX_LIABLE_COUNTRY | CHARACTER VARYING(255) | 255 |
| 28 | EFFECTIVE_DATE_CREST | CHARACTER VARYING(200) | 200 |
| 29 | CUSTOMER_TYPE_CREST | CHARACTER VARYING(255) | 255 |
| 30 | STATUS | CHARACTER VARYING(255) | 255 |
| 31 | DELETION_FLAG | CHARACTER VARYING(255) | 255 |
| 32 | DELETION_REASON | CHARACTER VARYING(255) | 255 |
| 33 | TIN | CHARACTER VARYING(255) | 255 |
| 34 | GIIN | CHARACTER VARYING(255) | 255 |
| 35 | BO_CP_TAX_LIABLE | CHARACTER VARYING(255) | 255 |
| 36 | CRS_ENTITY_TYPE | CHARACTER VARYING(255) | 255 |
| 37 | CRS_PRODUCT_TYPE | CHARACTER VARYING(30) | 30 |
| 38 | CRS_PRODUCT_CODE | CHARACTER VARYING(10) | 10 |
| 39 | CRS_PRODUCT_DESCRIPTION | CHARACTER VARYING(256) | 256 |
| 40 | CRS_REFERENCE_PRODUCT_TYPE | CHARACTER VARYING(50) | 50 |
| 41 | CRS_IN_SCOPE | CHARACTER VARYING(1) | 1 |
| 42 | DATE_OPEN | CHARACTER VARYING(200) | 200 |
| 43 | DATE_CLOSED | CHARACTER VARYING(200) | 200 |
| 44 | MATURITY_DATE | CHARACTER VARYING(200) | 200 |
| 45 | MIGRATED_ACCOUNT_FLAG | CHARACTER VARYING(1) | 1 |
| 46 | MIGRATION_STATUS | CHARACTER VARYING(3) | 3 |
| 47 | MIGRATED_DATE | CHARACTER VARYING(200) | 200 |
| 48 | MIGRATED_FROM | CHARACTER VARYING(3) | 3 |
| 49 | MIGRATED_TO | CHARACTER VARYING(3) | 3 |
| 50 | RENEWED_FLAG | CHARACTER VARYING(1) | 1 |
| 51 | RENEWED_FROM_PRODUCT_HOLDING_NUMBER | CHARACTER VARYING(45) | 45 |
| 52 | CRS_YTD_ACCOUNT_STATUS | CHARACTER VARYING(6) | 6 |
| 53 | SOURCE_CURRENCY_CODE | CHARACTER VARYING(24) | 24 |
| 54 | YTD_DATE | CHARACTER VARYING(200) | 200 |
| 55 | PRE_CRS_BALANCE | NUMERIC(31,8) | 19 |
| 56 | PRE_CRS_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 57 | PRE_CRS_BALANCE_USD | NUMERIC(31,8) | 19 |
| 58 | OPEN_BALANCE_YTD | NUMERIC(31,8) | 19 |
| 59 | OPEN_BALANCE_YTD_AUD | NUMERIC(31,8) | 19 |
| 60 | OPEN_BALANCE_YTD_USD | NUMERIC(31,8) | 19 |
| 61 | CRS_CLOSED_BALANCE_YTD | NUMERIC(31,8) | 19 |
| 62 | CRS_CLOSED_BALANCE_YTD_AUD | NUMERIC(31,8) | 19 |
| 63 | CRS_CLOSED_BALANCE_YTD_USD | NUMERIC(31,8) | 19 |
| 64 | CRS_ATO_REPORTABLE_YTD_BALANCE | NUMERIC(31,8) | 19 |
| 65 | CRS_ATO_REPORTABLE_YTD_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 66 | CRS_ATO_REPORTABLE_YTD_BALANCE_USD | NUMERIC(31,8) | 19 |
| 67 | CREDIT_INTEREST_CALENDAR_YTD | NUMERIC(31,8) | 19 |
| 68 | CREDIT_INTEREST_CALENDAR_YTD_AUD | NUMERIC(31,8) | 19 |
| 69 | CREDIT_INTEREST_CALENDAR_YTD_USD | NUMERIC(31,8) | 19 |
| 70 | AGG_PRE_CRS_BALANCE | NUMERIC(31,8) | 19 |
| 71 | AGG_PRE_CRS_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 72 | AGG_PRE_CRS_BALANCE_USD | NUMERIC(31,8) | 19 |
| 73 | AGG_CRS_ATO_REPORTABLE_YTD_BALANCE | NUMERIC(31,8) | 19 |
| 74 | AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_AUD | NUMERIC(31,8) | 19 |
| 75 | AGG_CRS_ATO_REPORTABLE_YTD_BALANCE_USD | NUMERIC(31,8) | 19 |
| 76 | FATCA_FLAG | CHARACTER VARYING(1) | 1 |
| 77 | CRS_FLAG | CHARACTER VARYING(1) | 1 |
| 78 | BENOWNER_GCIS_ID | INTEGER | 4 |
| 79 | BENOWNER_TAX_LIABLE_COUNTRY | CHARACTER VARYING(255) | 255 |
| 80 | BOCP_EFFECTIVE_DATE | CHARACTER VARYING(200) | 200 |
| 81 | DERIVED_CRS_FLAG | CHARACTER VARYING(1) | 1 |