Søgning » Global Informationsudveksling » FatcaAccountholderTRDim
Tabel

FatcaAccountholderTRDim


Beskrivelse ?

This data element contains detailed information on the accounts or payments required to be reported. The AccountReport uses the CorrectableAccountReport_Type and contains the account holder, account balance and other related account information.

Størrelse (Antal rækker) ?

577772

Indhold (Kolonner/variable) ?

Navn Indhold
fp_id Column generated by Formpipe, and only used for archiving purposes
indberetningARDimRid Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningARHistKey Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningARCorrKey Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningAROrgKey Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
BK_indberetningARId Senders unique identifier of this document. This data element is an identifier for a specific record and must be unique across all reporting systems and reporting periods. A unique DocRefId must be generated for each Nil Report or Account Report or Pool Report and each Reporting FI, Sponsor and Intermediary (if any). The DocRefId cannot be reused within the scope of FATCA reporting. A message with an invalid or duplicate DocRefId will cause an error notification.
BK_corrIndberetningARId This data element identifies a record to be voided, amended or corrected. It references the DocRefId from a previously filed report and ensures the proper records are updated. The value must match the DocRefId. The CorrDocRefId element is used in combination with DocTypeIndic codes, FATCA2, FATCA3 or FATCA4 (or FATCA12, FATCA13, FATCA14, if test data). Note: Do not use CorrDocRefId when submitting new data (FATCA1).
BK_orgIndberetningARId Original DocRefId.
indberetningsType Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningsARArt Reference til dataopslag CRS_Fatca_Opslag
docTypeIndicAR Reference til dataopslag CRS_Fatca_Opslag
BK_corrMessageRefIdAR This data element is a free text field to capture the unique identifier of a previously filed report. It is used to reference the original message when sending a corrected, amended or voided report. It allows the sender and the receiver to identify and correlate a specific message. When revising a file, it must reference the previous MessageRefId created for the previous message. MessageSpec can contain multiple CorrMessageRefId elements. If the file contains corrections for records from multiple previous files, include the CorMessageRefId element for each original file. Files with new data (FATCA1) should not contain CorrMessageRefId element.
indberetningFIHistKey Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
accountNumberAcc This data element provides the account number assigned by the financial institution to uniquely identify the account holder. ? The account number is a required element and can be any of the following: ? Account number of a custodial account or depository account ? Code (ISIN or other) related to a debt or equity interest (if not held in a custody account) ? Identification code of a cash value insurance contract or annuity contract ? If the financial institution has no account numbering system, then enter “NANUM” for no account number. ? If the reporting FI is a withholding agent reporting a withholdable payment made to a payee that is not an account holder, enter NANUM for no account number. ? If the reporting FI is a Direct Reporting NFFE, enter NANUM for no account number.
acctNumberTypeAcc Reference til dataopslag CRS_Fatca_Opslag
accountClosedAcc This data element indicates the account was closed or transferred in its entirety during the calendar year. If an account holder rolls over the amounts in one account (or type of account) into another account (or another type of account) with the same FFI during the calendar year, do not report the account as closed
birthDateAcc This data element is used only when the message sender is another tax administration that is permitted to provide a date of birth in lieu of a TIN for a preexisting account under an applicable IGA. It may be omitted if the tax administration has not received date of birth information from the financial institution or if a US TIN (if the sender is an HCTA) or a foreign TIN (for reciprocal reports) is provided for the account holder or substantial owner. The data format is YYYY-MM-DD.
cityAcc Birthcity
citySubentityAcc Citysubentity where the person is born
countryCodeAcc Reference til tabel Landekoder_Opslag
formerCountryNameAcc Name of the country where the person is born
acctHolderTypeAcc Reference til dataopslag CRS_Fatca_Opslag
accountbalanceAcc This data element provides the account balance or value of the reported financial account or the value of the equity interest in a Direct Reporting NFFE held by a substantial U.S. owner. The appropriate attribute is the 3-letter currency code
currCodeAcc Reference til Valutakoder_opslag
poolReportReportingFigiinAcc Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
poolReportMessageRefIdAcc Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
poolReportDocRefIdAcc Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
sorteringIdAccIndName Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
nameTypeAccIndName Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
precedingTitleAccInd Preceding Title Examples: His Excellency, Estateof the late..
firstNameAccInd This data element allows for the individual’s first name. It is required for FATCA reporting and cannot be omitted. If the sender does not have complete information or no first name for an individual account holder or substantial owner, you may use an initial here, such J.T. or enter “NFN” (No First Name). The attribute xnlNameType is not required for FATCA reporting and may be omitted.
nameTypeFirstNameAccInd Feltet anvendes ikke
namePrefixAccInd Nameprefix Examples: de, van de, von
nameTypeNamePrefixAccInd Feltet anvendes ikke
lastNameAccInd This data element allows for the individual’s last name. This field may include any prefix or suffix legally used by the account holder or substantial owner. This element is required for FATCA reporting and cannot be omitted. The xnlNameType attribute is not used for FATCA reporting and may be omitted.
nameTypeLastNameAccInd Feltet anvendes ikke
generalSuffixAccInd Generalsuffix Examples: Deceased, retired
sorteringsIdMiddlenameAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
middleNameAccInd This data element allows for the individual’s middle name. If the account holder or substantial owner has a middle name or initial it may be included. The data is optional and the attribute xnlNameType is not used for FATCA and may be omitted.
nameTypeMiddleNameAccInd Feltet anvendes ikke
sorteringsIdTitleAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
titleAccInd Greeting title. Examples: Mr., Dr., Ms, Herr. Can have multiple titles
sorteringsIdSuffixAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
suffixAccInd Suffix Could be compressed initials. PhD, VC, QC
sorteringsIdGenerationIdentifierAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
generationIdentifierAccInd Generationidentifier Examples: Jnr, Thr, third, III
sorteringsIdAccIndAddress Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
legalAddressTypeAccInd Reference til dataopslag CRS_Fatca_Opslag
countryCodeAccInd Reference til tabel Landekoder_Opslag
addressFreeAccInd This data element allows free text input of the address for the individual or organization. AddressFree should only be used if the data cannot be presented in the AddressFix format and the sender cannot define the various parts of the address. ? The address shall be presented as one string of bytes, blank, slash (/) or carriage return line feed used as a delimiter between parts of the address. ? AddressFree can be used as a supplemental element after the AddresFix element and when the AdressFix format is selected for address.
streetAccInd Street
buildingIdentifierAccInd Buildingidentifier
suiteIdentifierAccInd Suiteidentifier
floorIdentifierAccInd Flooridentifier
districtNameAccInd Districtname
pobAccInd Place Office Box
postCodeAccInd Postcode
cityAccInd City
countrySubentityAccInd Countrysubentity
sorteringsIdResCountryCodeAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
resCountryCodeAccInd This data element describes the tax residence country code for the reported individual account holder or substantial owner. The country code is a 2-character alphabetic country code specified in the ISO 3166- 1 Alpha 2 standard.
sorteringsIdTinAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
tinAccInd This data element identifies the U.S. Tax Identification Number (TIN) for the individual account holder or substantial owner and the attribute identifies the jurisdiction that issued the TIN. A U.S. TIN may be a U.S. social security number (SSN) or an individual taxpayer identification number (ITIN) issued by the IRS. For FATCA reporting a blank issuedBy attribute field will be assumed to indicate the issuing jurisdiction is the United States (US).
issuedByAccInd This data element identifies the U.S. Tax Identification Number (TIN) for the individual account holder or substantial owner and the attribute identifies the jurisdiction that issued the TIN. A U.S. TIN may be a U.S. social security number (SSN) or an individual taxpayer identification number (ITIN) issued by the IRS. For FATCA reporting a blank issuedBy attribute field will be assumed to indicate the issuing jurisdiction is the United States (US)
sorteringsIdNationalityAccInd Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
nationalityAccInd This data element is not required for FATCA and may be omitted.
sorteringsIdOrganisationNameAccOrgName Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
organisationNameAccOrg The organization element can have multiple names, but FATCA reporting requires only one name element
nameTypeOrganisationNameAccOrg Feltet anvendes ikke
sorteringsIdAddressAccOrg Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
legalAddressTypeAccOrg Reference til dataopslag CRS_Fatca_Opslag
countryCodeAccOrg Reference til tabel Landekoder_Opslag
addressFreeAccOrg This data element allows free text input of the address for the individual or organization. AddressFree should only be used if the data cannot be presented in the AddressFix format and the sender cannot define the various parts of the address. ? The address shall be presented as one string of bytes, blank, slash (/) or carriage return line feed used as a delimiter between parts of the address. ? AddressFree can be used as a supplemental element after the AddresFix element and when the AdressFix format is selected for address.
streetAccOrg Street
buildingIdentifierAccOrg Buildingidentifier
suiteIdentifierAccOrg Suiteidentifier
floorIdentifierAccOrg Flooridentifier
districtNameAccOrg Districtname
pobAccOrg Place Office Box
postCodeAccOrg Postcode
cityAccOrg City
countrySubentityAccOrg Countrysubentity
sorteringsIdResCountryCodeAccOrg Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
resCountryCodeAccOrg Reference til tabel Landekoder_Opslag
sorteringsIdTinAccOrg Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
tinAccOrg This element identifies the receiving tax administration or U.S. Tax Identification Number (TIN) for the organization. The attribute describes the jurisdiction that issued the TIN and reporting a blank issuedBy attribute field indicates the issuing jurisdiction is the United States (US). The data element can be repeated if a second TIN is present.
issuedByAccOrg Reference til tabel Landekoder_Opslag
tinKonvAccOrg Det SE nr der er forsøgt konverteret til CPR nr.
cprnrKonvAccOrg Det CPR nr der er fremkommet ved konvertering
currency Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
dwCreatedDts Tidspunkt for oprettelse i Data WareHouse
dwUpdatedDts Tidspunkt for opdatering af berigelsen i Data WareHouse
dwBatchId Id for synkroniseringen i Data WareHouse
indberetningARHistKey_dim Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet