SCF - Tax Documentation Validation CSV Ingestion Template Guide

Please see the table below for details on each field of the SCF Tax Documentation Validation Template. The CSV template is also attached to the bottom of this article.

Field	Headers	Format	Example
Account Owner ID	account_owner_id	String	12345678
Name	name	String	Chris P. Bacon
Classification	classification	Enum	INDIVIDUAL
Passive Entity Type	passive_entity_type	Enum	TRUST
Securities Market	securities_market	String	New York Stock Exchange (NYSE)
Related Corporation	related_corporation	String	Alphabet Inc.
Date Of Birth	date_of_birth	M/D/YYY	1/1/1990
City of Birth	city_of_birth	String	Seattle
Country of Birth	country_of_birth	String	US
Country Of Citizenship	country_of_citizenship	String	US
Address First Line	address_first_line	String	123 Bitcoin Way
Address Second Line	address_second_line	String	Apartment 203
Address City	address_city	String	Seattle
Address State Or Province	address_state_or_province	String	WA
Address Postal Code	address_postal_code	String	98101
Address Country	address_country	String	US
Mailing Address Line 1	mailing_address_first_line	String	123 Bitcoin Way
Mailing Address Line 2	mailing_address_second_line	String	Apartment 203
Mailing Address City	mailing_address_city	String	Seattle
Mailing Address State	mailing_address_state_or_province	String	WA
Mailing Address Country	mailing_address_country	String	US
Mailing Address Postal Code	mailing_address_postal_code	String	98101
GIIN	giin	String	29X3X7.99999.SL.832
Country Of Residency 1	country_of_residency_1	String	US
Tin 1	tin_1	String	123-45-6789
TIN Not Required 1	tin_not_required_1	TRUE/FALSE	TRUE
TIN Not Required Reason 1	tin_not_required_reason_1	Enum	NOT_ISSUED
TIN Not Required Reason Other 1	tin_not_required_reason_other_1	String	Jurisdiction does not issue TINs
Country Of Residency 2	country_of_residency_2	String	CA
Tin 2	tin_2	String	123-45-6789
TIN Not Required 2	tin_not_required_2	TRUE/FALSE	TRUE
TIN Not Required Reason 2	tin_not_required_reason_2	Enum	NOT_ISSUED
TIN Not Required Reason Other 2	tin_not_required_reason_other_2	String	Jurisdiction does not issue TINs
Country Of Residency 3	country_of_residency_3	String	CN
Tin 3	tin_3	String	123-45-6789
TIN Not Required 3	tin_not_required_3	TRUE/FALSE	TRUE
TIN Not Required Reason 3	tin_not_required_reason_3	Enum	NOT_ISSUED
TIN Not Required Reason Other 3	tin_not_required_reason_other_3	String	Jurisdiction does not issue TINs
Country Of Residency 4	country_of_residency_4	String	FR
Tin 4	tin_4	String	123-45-6789
TIN Not Required 4	tin_not_required_4	TRUE/FALSE	TRUE
TIN Not Required Reason 4	tin_not_required_reason_4	Enum	NOT_ISSUED
TIN Not Required Reason Other 4	tin_not_required_reason_other_4	String	Jurisdiction does not issue TINs
Country Of Residency 5	country_of_residency_5	String	NO
Tin 5	tin_5	String	123-45-6789
TIN Not Required 5	tin_not_required_5	TRUE/FALSE	TRUE
TIN Not Required Reason 5	tin_not_required_reason_5	Enum	NOT_ISSUED
TIN Not Required Reason Other 5	tin_not_required_reason_other_5	String	Jurisdiction does not issue TINs
Residence By Investment Confirmed	residence_by_investment_confirmed	TRUE/FALSE	TRUE
Signed and Certified	has_signed_and_certified	TRUE/FALSE	TRUE
Signature Date	signature_date	M/D/YYY	1/1/1990
Signature Capacity	signature_capacity	Enum	OWNER
Signature Capacity Other	signature_capacity_other	String	Head of Corporate Finance

Please see below for the enums available for each of the applicable fields.

Header	Enum
classification	INDIVIDUAL
	FINANCIAL_INSTITUTION_DEPOSITORY_INSTITUTION
	FINANCIAL_INSTITUTION_CUSTODIAL_INSTITUTION
	FINANCIAL_INSTITUTION_INSURANCE_COMPANY
	FINANCIAL_INSTITUTION_NON_REPORTING
	FINANCIAL_INSTITUTION_INVESTMENT_ENTITY_MANAGED
	FINANCIAL_INSTITUTION_INVESTMENT_ENTITY_OTHER
	ACTIVE_NFE_GOVERNMENT_ENTITY
	ACTIVE_NFE_CENTRAL_BANK
	ACTIVE_NFE_INTERNATIONAL_ORGANIZATION
	ACTIVE_NFE_PUBLIC_CORPORATION
	ACTIVE_NFE_OTHER
	PASSIVE_NFE
passive_entity_type	TRUST
	SIMILAR_TO_TRUST
	OTHER
tin_not_required_reason	NOT_ISSUED
	NOT_REQUIRED
	OTHER
signature_capacity	OFFICER
	EXECUTOR
	OTHER_CAPACITY

TaxBit - Tax Doc Validation CSV Ingestion Templates - scf.csv