ATO_FATCA_ENTITY_REPORT
Description
Synonyms
SDSNZP02_BANK..AS516_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..ATOCRS_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..BNKFRC_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..BNKNIC_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..EFS_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..ESTAT_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..QRMCGN_ATO_FATCA_ENTITY_REPORT
SDSNZP02_BANK..UBAR_ATO_FATCA_ENTITY_REPORT
SDSNZP05_BANK..CBP_ATO_FATCA_ENTITY_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(10) | 10 |
| 8 | REPORTINGPERIOD | CHARACTER VARYING(15) | 15 |
| 9 | TIMESTAMP | CHARACTER VARYING(25) | 25 |
| 10 | RFI_RESCOUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 11 | RFI_TIN | CHARACTER VARYING(25) | 25 |
| 12 | RFI_ISSUEDBY | CHARACTER VARYING(24) | 24 |
| 13 | RFI_NAME | CHARACTER VARYING(1014) | 1014 |
| 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(10) | 10 |
| 24 | RFI_CORRDOCREFID | CHARACTER VARYING(10) | 10 |
| 25 | RFI_FILER_CATEGORY | CHARACTER VARYING(30) | 30 |
| 26 | ACCTRPT_DOCTYPEINDIC | CHARACTER VARYING(10) | 10 |
| 27 | ACCTRPT_DOCREFID | CHARACTER VARYING(200) | 200 |
| 28 | ACCTRPT_CORRMESSAGEREFID | CHARACTER VARYING(10) | 10 |
| 29 | ACCTRPT_CORRDOCREFID | CHARACTER VARYING(10) | 10 |
| 30 | ACCOUNT_NUMBER | CHARACTER VARYING(50) | 50 |
| 31 | ACCOUNT_BALANCE | CHARACTER VARYING(31) | 31 |
| 32 | ACCOUNT_BALANCE_CURRCODE | CHARACTER VARYING(5) | 5 |
| 33 | ACCOUNT_CLOSED_FLAG | CHARACTER VARYING(5) | 5 |
| 34 | CUSTOMER_TYPE | CHARACTER VARYING(20) | 20 |
| 35 | INDIVIDUAL_TIN | CHARACTER VARYING(50) | 50 |
| 36 | INDIVIDUAL_TITLE | CHARACTER VARYING(30) | 30 |
| 37 | INDIVIDUAL_FIRSTNAME | CHARACTER VARYING(1014) | 1014 |
| 38 | INDIVIDUAL_MIDDLENAME | CHARACTER VARYING(100) | 100 |
| 39 | INDIVIDUAL_LASTNAME | CHARACTER VARYING(100) | 100 |
| 40 | INDIVIDUAL_SUFFIX | CHARACTER VARYING(50) | 50 |
| 41 | INDIVIDUAL_COUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 42 | INDIVIDUAL_ADDRESSFREE | CHARACTER VARYING(1014) | 1014 |
| 43 | INDIVIDUAL_POSTCODE | CHARACTER VARYING(20) | 20 |
| 44 | INDIVIDUAL_CITY | CHARACTER VARYING(50) | 50 |
| 45 | INDIVIDUAL_COUNTRYSUBENTITY | CHARACTER VARYING(50) | 50 |
| 46 | INDIVIDUAL_BIRTHDATE | CHARACTER VARYING(15) | 15 |
| 47 | ORGANISATION_ACCTHOLDERTYPE | CHARACTER VARYING(15) | 15 |
| 48 | ORGANISATION_TIN | CHARACTER VARYING(15) | 15 |
| 49 | ORGANISATION_NAME | CHARACTER VARYING(250) | 250 |
| 50 | ORGANISATION_COUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 51 | ORGANISATION_ADDRESSFREE | CHARACTER VARYING(1014) | 1014 |
| 52 | ORGANISATION_POSTCODE | CHARACTER VARYING(20) | 20 |
| 53 | ORGANISATION_CITY | CHARACTER VARYING(50) | 50 |
| 54 | ORGANISATION_COUNTRYSUBENTITY | CHARACTER VARYING(24) | 24 |
| 55 | CRM_TAX_LIABLE_STATUS | CHARACTER VARYING(40) | 40 |
| 56 | INTEREST_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 57 | INTEREST_PAYMENTAMNT | CHARACTER VARYING(31) | 31 |
| 58 | INTEREST_CURRCODE | CHARACTER VARYING(5) | 5 |
| 59 | DIVIDEND_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 60 | DIVIDEND_PAYMENTAMNT | CHARACTER VARYING(31) | 31 |
| 61 | DIVIDEND_CURRCODE | CHARACTER VARYING(5) | 5 |
| 62 | GROSS_PROCEED_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 63 | GROSS_PROCEED_PAYMENTAMNT | CHARACTER VARYING(31) | 31 |
| 64 | GROSS_PROCEED_CURRCODE | CHARACTER VARYING(5) | 5 |
| 65 | OTHER_PAYMENTTYPE | CHARACTER VARYING(20) | 20 |
| 66 | OTHER_PAYMENTAMNT | CHARACTER VARYING(31) | 31 |
| 67 | OTHER_CURRCODE | CHARACTER VARYING(5) | 5 |
| 68 | ORG_ACCOUNT_HOLDER_TYPE_DESC | CHARACTER VARYING(100) | 100 |
| 69 | SUBOWNER_TYPE | CHARACTER VARYING(20) | 20 |
| 70 | SUBOWNER_TIN | CHARACTER VARYING(40) | 40 |
| 71 | SUBOWNER_TITLE | CHARACTER VARYING(30) | 30 |
| 72 | SUBOWNER_FIRSTNAME | CHARACTER VARYING(1014) | 1014 |
| 73 | SUBOWNER_MIDDLENAME | CHARACTER VARYING(100) | 100 |
| 74 | SUBOWNER_LASTNAME | CHARACTER VARYING(100) | 100 |
| 75 | SUBOWNER_SUFFIX | CHARACTER VARYING(50) | 50 |
| 76 | SUBOWNER_ORGANISATION_NAME | CHARACTER VARYING(50) | 50 |
| 77 | SUBOWNER_COUNTRYCODE | CHARACTER VARYING(24) | 24 |
| 78 | SUBOWNER_ADDRESSFREE | CHARACTER VARYING(1014) | 1014 |
| 79 | SUBOWNER_POSTCODE | CHARACTER VARYING(20) | 20 |
| 80 | SUBOWNER_CITY | CHARACTER VARYING(50) | 50 |
| 81 | SUBOWNER_COUNTRYSUBENTITY | CHARACTER VARYING(24) | 24 |
| 82 | SUBOWNER_BIRTHDATE | CHARACTER VARYING(15) | 15 |
| 83 | CUST_RESPONSE_FATCA_STATUS | CHARACTER VARYING(100) | 100 |
| 84 | RFI_ABN | CHARACTER VARYING(30) | 30 |
| 85 | RFI_ABN_ISSUED_BY | CHARACTER VARYING(10) | 10 |
| 86 | INDIVIDUAL_TAX_RESCOUNTRYCODE | CHARACTER VARYING(50) | 50 |
| 87 | ORGANISATION_TAX_RESCOUNTRYCODE | CHARACTER VARYING(50) | 50 |
| 88 | SUBOWNER_TAX_RESCOUNTRYCODE | CHARACTER VARYING(50) | 50 |
| 89 | DATA_DATE | TIMESTAMP | 8 |
| 90 | LOAD_ID | INTEGER | 4 |
| 91 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 92 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 93 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 94 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |