CRS_ATO_INDV_REPORT
Description
Synonyms
SDSNZP02_BANK..AS516_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..ATOCRS_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..BNKFRC_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..BNKNIC_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..EFS_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..ESTAT_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..QRMCGN_CRS_ATO_INDV_REPORT
SDSNZP02_BANK..UBAR_CRS_ATO_INDV_REPORT
SDSNZP05_BANK..CBP_CRS_ATO_INDV_REPORT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | VERSION | CHARACTER VARYING(7) | 7 |
| 2 | SENDINGCOMPANYIN | CHARACTER VARYING(50) | 50 |
| 3 | TRANSMITTINGCOUNTRY | CHARACTER VARYING(5) | 5 |
| 4 | RECEIVINGCOUNTRY | CHARACTER VARYING(5) | 5 |
| 5 | MESSAGETYPE | CHARACTER VARYING(100) | 100 |
| 6 | MESSAGEREFID | CHARACTER VARYING(100) | 100 |
| 7 | CORRMESSAGEREFID | CHARACTER VARYING(100) | 100 |
| 8 | REPORTINGPERIOD | CHARACTER VARYING(15) | 15 |
| 9 | TIMESTAMP | CHARACTER VARYING(25) | 25 |
| 10 | RFI_RESCOUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 11 | RFI_TIN | CHARACTER VARYING(40) | 40 |
| 12 | RFI_ISSUEDBY | CHARACTER VARYING(24) | 24 |
| 13 | RFI_NAME | CHARACTER VARYING(100) | 100 |
| 14 | RFI_COUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 15 | RFI_ADDRESSFREE | CHARACTER VARYING(500) | 500 |
| 16 | RFI_POSTCODE | CHARACTER VARYING(20) | 20 |
| 17 | RFI_CITY | CHARACTER VARYING(50) | 50 |
| 18 | RFI_COUNTRYSUBENTITY | CHARACTER VARYING(24) | 24 |
| 19 | RFI_CONTACT_NAME | CHARACTER VARYING(100) | 100 |
| 20 | RFI_CONTACT_EMAIL | CHARACTER VARYING(100) | 100 |
| 21 | RFI_DOCTYPEINDIC | CHARACTER VARYING(10) | 10 |
| 22 | RFI_DOCREFID | CHARACTER VARYING(100) | 100 |
| 23 | RFI_CORRMESSAGEREFID | CHARACTER VARYING(100) | 100 |
| 24 | RFI_CORRDOCREFID | CHARACTER VARYING(100) | 100 |
| 25 | ACCTRPT_DOCTYPEINDIC | CHARACTER VARYING(10) | 10 |
| 26 | ACCTRPT_DOCREFID | CHARACTER VARYING(200) | 200 |
| 27 | ACCTRPT_CORRMESSAGEREFID | CHARACTER VARYING(100) | 100 |
| 28 | ACCTRPT_CORRDOCREFID | CHARACTER VARYING(100) | 100 |
| 29 | ACCOUNT_NUMBER | CHARACTER VARYING(50) | 50 |
| 30 | ACCOUNT_BALANCE | NUMERIC(31,8) | 19 |
| 31 | ACCOUNT_BALANCE_CURRCODE | CHARACTER VARYING(5) | 5 |
| 32 | ACCTNUMBER_TYPE | CHARACTER VARYING(10) | 10 |
| 33 | ACCOUNT_CLOSED_FLAG | CHARACTER VARYING(5) | 5 |
| 34 | CUSTOMER_TYPE | CHARACTER VARYING(20) | 20 |
| 35 | CUSTOMER_ID | CHARACTER VARYING(20) | 20 |
| 36 | INDIVIDUAL_TAX_RESCOUNTRYCODE | CHARACTER VARYING(255) | 255 |
| 37 | INDIVIDUAL_TIN | CHARACTER VARYING(50) | 50 |
| 38 | INDIVIDUAL_TITLE | CHARACTER VARYING(30) | 30 |
| 39 | INDIVIDUAL_FIRSTNAME | CHARACTER VARYING(1014) | 1014 |
| 40 | INDIVIDUAL_MIDDLENAME | CHARACTER VARYING(100) | 100 |
| 41 | INDIVIDUAL_LASTNAME | CHARACTER VARYING(100) | 100 |
| 42 | INDIVIDUAL_SUFFIX | CHARACTER VARYING(50) | 50 |
| 43 | INDIVIDUAL_ADDRCOUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 44 | INDIVIDUAL_ADDRESSFREE | CHARACTER VARYING(1014) | 1014 |
| 45 | INDIVIDUAL_POSTCODE | CHARACTER VARYING(20) | 20 |
| 46 | INDIVIDUAL_CITY | CHARACTER VARYING(50) | 50 |
| 47 | INDIVIDUAL_COUNTRYSUBENTITY | CHARACTER VARYING(50) | 50 |
| 48 | INDIVIDUAL_BIRTHDATE | CHARACTER VARYING(15) | 15 |
| 49 | INDIVIDUAL_DECEASED_IND | CHARACTER VARYING(3) | 3 |
| 50 | ORGANISATION_CRSACCOUNTHOLDERTYPE | CHARACTER VARYING(15) | 15 |
| 51 | ORG_CRS_ACCOUNT_HOLDER_TYPE_DESC | CHARACTER VARYING(100) | 100 |
| 52 | ORGANISATION_TAX_RESCOUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 53 | ORGANISATION_TIN | CHARACTER VARYING(40) | 40 |
| 54 | ORGANISATION_NAME | CHARACTER VARYING(250) | 250 |
| 55 | ORGANISATION_ADDRCOUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 56 | ORGANISATION_ADDRESSFREE | CHARACTER VARYING(1014) | 1014 |
| 57 | ORGANISATION_POSTCODE | CHARACTER VARYING(20) | 20 |
| 58 | ORGANISATION_CITY | CHARACTER VARYING(50) | 50 |
| 59 | ORGANISATION_COUNTRYSUBENTITY | CHARACTER VARYING(24) | 24 |
| 60 | CUST_TAX_LIABLE_STATUS | CHARACTER VARYING(40) | 40 |
| 61 | CUST_RESPONSE_CRS_ENTITY_TYPE | CHARACTER VARYING(100) | 100 |
| 62 | INTEREST_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 63 | INTEREST_PAYMENTAMNT | NUMERIC(31,8) | 19 |
| 64 | INTEREST_CURRCODE | CHARACTER VARYING(5) | 5 |
| 65 | DIVIDEND_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 66 | DIVIDEND_PAYMENTAMNT | NUMERIC(31,8) | 19 |
| 67 | DIVIDEND_CURRCODE | CHARACTER VARYING(5) | 5 |
| 68 | GROSS_PROCEED_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 69 | GROSS_PROCEED_PAYMENTAMNT | NUMERIC(31,8) | 19 |
| 70 | GROSS_PROCEED_CURRCODE | CHARACTER VARYING(5) | 5 |
| 71 | OTHER_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 72 | OTHER_PAYMENTAMNT | NUMERIC(31,8) | 19 |
| 73 | OTHER_CURRCODE | CHARACTER VARYING(5) | 5 |
| 74 | CTRLGPERSON_TYPE | CHARACTER VARYING(20) | 20 |
| 75 | CTRLGPERSON_TAX_RESCOUNTRYCODE | CHARACTER VARYING(255) | 255 |
| 76 | CTRLGPERSON_TIN | CHARACTER VARYING(40) | 40 |
| 77 | CTRLGPERSON_TITLE | CHARACTER VARYING(30) | 30 |
| 78 | CTRLGPERSON_FIRSTNAME | CHARACTER VARYING(1014) | 1014 |
| 79 | CTRLGPERSON_MIDDLENAME | CHARACTER VARYING(100) | 100 |
| 80 | CTRLGPERSON_LASTNAME | CHARACTER VARYING(100) | 100 |
| 81 | CTRLGPERSON_SUFFIX | CHARACTER VARYING(50) | 50 |
| 82 | CTRLGPERSON_ADDRCOUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 83 | CTRLGPERSON_ADDRESSFREE | CHARACTER VARYING(1014) | 1014 |
| 84 | CTRLGPERSON_POSTCODE | CHARACTER VARYING(20) | 20 |
| 85 | CTRLGPERSON_CITY | CHARACTER VARYING(50) | 50 |
| 86 | CTRLGPERSON_COUNTRYSUBENTITY | CHARACTER VARYING(24) | 24 |
| 87 | CTRLGPERSON_BIRTHDATE | CHARACTER VARYING(15) | 15 |
| 88 | CTRLGPERSON_DECEASED_IND | CHARACTER VARYING(3) | 3 |
| 89 | CTRLGPERSON_ID | CHARACTER VARYING(20) | 20 |
| 90 | MESSAGETYPEINDICATOR | CHARACTER VARYING(6) | 6 |
| 91 | DATA_DATE | TIMESTAMP | 8 |
| 92 | LOAD_ID | INTEGER | 4 |
| 93 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 94 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 95 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 96 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |