CRS_ATO_ENTITY_REPORT_BKP_CHG0226839

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

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 DATA_DATE TIMESTAMP 8
91 LOAD_ID INTEGER 4
92 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
93 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
94 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
95 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8