Søgning » Global Informationsudveksling » CrsPartyAccountTRDim
Tabel

CrsPartyAccountTRDim


Beskrivelse ?

This data element contains detailed information on the accounts or payments required to be reported. AccountReport is mandatory under CRS (except where the MessageTypeIndic CRS703 is used to indicate that there is no data to report). In all other instances AccountReport must be completed.

Størrelse (Antal rækker) ?

3236932

Indhold (Kolonner/variable) ?

Navn Indhold
fp_id Column generated by Formpipe, and only used for archiving purposes
indberetningARDimRid Hjælpetekst ikke defineret af Skattestyrelsen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningARHistKey Hjælpetekst ikke defineret af Skattestyrelsen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningARCorrKey Hjælpetekst ikke defineret af Skattestyrelsen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
indberetningAROrgKey A unique identifier for this document (i.e. one record and all its children data elements). A correction (or deletion) must have a new unique DocRefID for future reference.
BK_IndberetningArId The CorrDocRefID references the DocRefID of the element to be corrected/deleted. It must always refer to the latest reference of this Accountreport (DocRefID) that was sent. In this way, a series of corrections or amendments can be handled as each correction completely replaces the previous version. The CRS Correction examples below show how this works in practice
BK_corrIndberetningArId Original DocRefId
BK_orgIndberetningArId This data element is a free text field capturing the sender’s unique identifying number (created by the sender) that identifies the particular message being sent. The identifier allows both the sender and receiver to identify the specific message later if questions or corrections arise
BK_MessageRefIdAR Hvorvidt indberetning er national eller international modtaget. Objektet indeholder følgende værdier: - NAT - INT
indberetningsType Viser hvorvidt indberetning er national eller international modtaget. Objektet indeholder følgende værdier: - nationale - oecd
indberetningsARArt Reference til dataopslag indberetningsARArt_Opslag
docTypeIndicAR Reference til dataopslag CRS_Fatca_Opslag
indberetningFIHistKey The account number used by the financial institution to identify the account. If the financial institution does not have an account number, then provide the functional equivalent unique identifier used by the financial institution to identify the account. Mandatory for financial institutions that have an account number (including alpha numeric identifiers), If exceptionally there is no account numbering system use NANUM for no account number as this is a Validation element. This format for account number is the same as FATCA and can be used for structured account numbers as well as free format; a non-standard account identifier or an insurance contract number could be included here.
accountNumber There is an option to include information about the account number type as an enumeration. The possible values are: , OECD601 = IBAN International Bank Account Number (follows a known structure) , OECD602 = OBAN Other Bank Account Number , OECD603 = ISIN International Securities Information Number (follows a known structure) , OECD604 = OSIN Other Securities Information Number , OECD605 = Other Any other type of account number e.g. insurance contract Where an IBAN or ISIN is available, it should be provided and the appropriate information about the account number type supplied
accountNumberType The account balance or value of the reported financial account
accountBalance The account balance or value of the reported financial account
currencyCode Reference til tabel Valutakoder_opslag.
closedAccount Used in CRS reporting to indicate that the account is dormant.
dormantAccount Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
undocumentedAccount Applicable exchange rate for Account Report
exchangeRate This data element identifies the date of birth of the Individual Account Holder. The date of birth may be left empty when it is not required to be reported under the CRS (this may occur for Pre-existing Accounts if the date of birth is not available in the records of the Reporting Financial Institution and is not otherwise required to be collected by such Reporting Financial Institution under domestic law). The data format is YYYY-MM-DD.
birthDate Birth City
birthCity Citysubentity where the person is born
birthCitySubentity This data element provides the country code associated with the birthplace. The country code is a 2-character alphabetic country code specified in the ISO 3166-1 Alpha 2 standard.
birthCountryCode Reference til tabel Landkoder_opslag
birthFormerCountryName Identifier of a Party at the level of the Party entity of the physical data model
partyType Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
sorteringsIdName Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
nameType Preceding Title, Examples: His Excellency, Estateof the late..
precedingTitle This data element is required for CRS reporting. If the reporting FI or tax administration transmitting the message does not have a complete first name for an Individual Account Holder or Controlling Person an initial or NFN (“No First Name”) may be used here.
firstName First name of Controlling Person.
nameTypeFirstName Nameprefix, , Examples: de, van de, von
namePrefix Nameprefix. Examples: de, van de, von. A free text field
nameTypeNamePrefix This data element is required for CRS reporting. The reporting FI or tax administration transmitting the message must provide the Individual Account Holder’s last name. This field can include any prefix or suffix legally used by the Account Holder. As the element is a string it is possible to use this for a free format name or two last names although wherever possible the structured first name and last name should be used
lastName The Individual Account Holder’s last name. This field can include any prefix or suffix legally used by the Account Holder. As the element is a string it is possible to use this for a free format name or two last names although wherever possible the structured first name and last name should be used
nameTypeLastName Generalsuffix Examples: Deceased, retired
generalSuffix Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
sorteringsIdMiddlename This data element allows for the Individual’s Middle Name. The data is optional for CRS reporting; if the Reporting FI holds a Middle Name or initial it may be included here.
middleName The Individual’s Middle Name. The data is optional for CRS reporting; if the Reporting FI holds a Middle Name or initial it may be included here.
nameTypeMiddleName Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
sorteringsIdTitle Greeting title. Examples: Mr., Dr., Ms, Herr. Can have multiple titles
title Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
sorteringsIdSuffix Suffix: Could be compressed initials. PhD, VC, QC
suffix Felt der benyttes til at skelne hvis mere end et navn, adresse, paymenttype mm
sorteringsIdGenerationIdentifier Generationidentifier, Examples: Jnr, Thr, third, III
generationIdentifier Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
sorteringsIdOrganisationName Legal name of the entity that is reporting or being reported on.
organisationName Code that define the type of organisation.
nameTypeOrganisationName Reference til dataopslag CRS_Fatca_Opslag
sorteringsIdTin This data element identifies the Tax Identification Number (TIN) used by the receiving tax administration to identify the Individual Account Holder. The TIN (if available) should be supplied as specified in the CRS.
tin This attribute identifies the jurisdiction that issued the TIN. If the issuing jurisdiction is not known then this may be left blank
issuedBy Reference til tabel Landkoder_opslag
sorteringsIdAddress This is a datatype for an attribute to an address. It serves to indicate the legal character of that address (residential, business etc.) The possible values are: OECD301= residentialOrBusiness OECD302= residential OECD303= business OECD304= registeredOffice OECD305= unspecified
legalAddressType Reference til dataopslag CRS_Fatca_Opslag
countryCode Reference til tabel Landkoder_opslag
addressFree Name of street
street Buildingidentifier
buildingIdentifier SuiteIdentifier
suiteIdentifier FloorIdentifier
floorIdentifier Name of District
districtName Post Office box. 1 to 200 characters.
pob PostCode
postCode Name of City
city CountrySubentity. 1 to 200 characters.
countrySubentity Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
sorteringsIdResCountryCode Data er ikke blevet anvendt af Skatteforvaltningen, Data er derfor ikke dokumenteret efter aftale med Rigsarkivet
in_ This attribute describes the jurisdiction that issued the INPUT. If the issuing jurisdiction is not known then this may be left blank.
inIssuedBy Reference til tabel Landkoder_opslag
inType Kode er ikke dokumenteret efter aftale med Rigsarkivet
resCountryCode Reference til tabel Landkoder_opslag
dwCreatedDts Tidspunkt for oprettelse i Data WareHouse
dwUpdatedDts Tidspunkt for opdatering af berigelsen i Data WareHouse
dwBatchId Id for synkroniseringen i Data WareHouse