Denmark
This section describes the Denmark reports appendix.
Denmark Standard Audit File - Tax Tags and Mappings
The Denmark SAFT must comply with a specific XML schema required by Danish tax authorities. In the schema depicted below, we include all the tag names for data values as well as the expected content of data value for that tag. Some tags are included in the XML schema but have no data in Maconomy. For some tags, you can exclude the tags if they do not have any representation in the software system. In order to keep the full overview of the XML schema, we strike through such tags (Sample), thereby emphasizing that even though they are part of the XML schema, they are not part of the XML file produced.
Where possible, we state the database field from where to find the content for the tag in Maconomy. If we indicate universe objects, this means that the value could come from another table, such as a dimension table, or may be the result of a calculation.
| Tags | Attributes | Technical Details |
|---|---|---|
| <AuditFile> | ||
| <Header> | ||
| <AuditFileVesion> | Version of standard audit file being used. It is displayed in an XML annotation in top of the XSD schema file.
Hardcoded: "1.0" |
|
| <AuditFileCountry> | Two-letter country code of the company according to ISO 3166-1 alpha 2 standard.
Country.ISOCode |
|
| <AuditFileRegion> | ||
| <AuditFileDateCreated> | Date of production of the audit file. This is always current date.
Current Date |
|
| <SoftwareCompanyName> | Name of the software company whose product created the audit file.
Hardcoded: "Deltek, Inc." |
|
| <SoftwareID> | Name of the software that generated the audit file.
Hardcoded: "Deltek Maconomy" |
|
| <SoftwareVersion> | Version of the software. This is the internal version number of Maconomy.
SystemMaintenanceLog.MainVersionNumber+ "." +SystemMaintenanceLog.PatchNumber |
|
| <Company> | Company's name and address details. | |
| <RegistrationNumber> | Organization number from the Danish CVR-register.
CompanyInformation.CompanyRegistrationNumber |
|
| <Name> | The name of the company
CompanyInformation.Name1 |
|
| <Address> | ||
| <StreetName> | Streetname in the company address.
Address line 2 CompanyInformation.Name2 |
|
| <Number> | House Number.
Address line 3 CompanyInformation.Name3 |
|
| <AdditionalAddressDetail> | Address Line 4
CompanyInformation.Name4 |
|
| <Building> | ||
| <City> | Name of the city/post district of the company address.
CompanyInformation.PostalDistrict |
|
| <PostalCode> | Postal code for the relevant city/post district of the company address.
CompanyInformation.ZipCode |
|
| <Region> | ||
| <Country> | ISO code of the company's country.
Country.ISOCode |
|
| <AddressType> | ||
| <Contact> | ||
| <ContactPerson> | One tag for each employee in the company information (Employee 1, …, Employee 5). | |
| <Title> | ||
| <FirstName> | First name of the person.
If the name of the person is in an unstructured form, insert "NotUsed" in this element, and enter the full unstructured name in the LastName element. Hardcoded: "NotUsed" |
|
| <Initials> | ||
| <LastNamePrefix> | ||
| <LastName> | This contains the full unstructured name of the person.
Employee.Name1 |
|
| <BirthName> | ||
| <Salutation> | ||
| <OtherTitles> | ||
| <Telephone> | Telephone number of the company.
CompanyInformation.Telephone |
|
| <Fax> | Fax number of the company.
CompanyInformation.Telefax |
|
| <Email> | ||
| <Website> | ||
| <MobilePhone> | ||
| <TaxRegistration> | ||
| <TaxRegistrationNumber> | Company's VAT number.
CompanyInformation.VatNumber |
|
| <TaxType> | ||
| <TaxNumber> | ||
| <TaxAuthority> | Identification of the Revenue Body to which this TaxType refers.
Hardcoded: "Skat" |
|
| <Country> | ||
| <TaxVerificationDate> | ||
| <BankAccount> | ||
| <IBANNumber> OR | International Bank Account Number information of the company.
CompanyInformation.Giro |
|
| <BankAccountNumber> | The number allocated to the account by the company's own bank.
CompanyInformation.BankAccountNumber |
|
| <BankAccountName> | ||
| <SortCode> | ||
| <BIC> | Bank Identifier Code of the company.
EXExternalAccount.SwiftCode |
|
| <CurrencyCode> | Currency ISO Code of the company.
PopupItem.String1 :- PopupItem.PopupTypeName='CurrencyType' |
|
| <AccountID> | ||
| <DefaultCurrencyCode> | Three letter currency code of the company.
EXCompanyInformation.Currency |
|
| <SelectionCriteria> | User specified.
Allows for a choice between selection start/end date or period start/end. |
|
| <TaxReportingJurisdiction> | ||
| <CompanyEntity> | The selected company to run the report for. | |
| <SelectionStartDate> | The start date for the reporting period covered by the SAF. | |
| <SelectionEndDate> OR | The end date for the reporting period covered by the SAF.
Note: Select between <SelectionEndDate> or <PeriodStart>. |
|
| <PeriodStart> | The first month period covered by the report. | |
| <PeriodStartYear> | The year in which the PeriodStart falls. | |
| <PeriodEnd> | The last month period covered by the report. | |
| <PeriodEndYear> | The year in which the PeriodEnd falls. | |
| <DocumentType> | ||
| <OtherCriteria> | ||
| <HeaderComment> | ||
| <TaxAccountingBasis> | ||
| <TaxEntity> | ||
| <UserID> | Name of the user that generated the audit file.
UserInformation.NameOfUser |
|
| </Header> | ||
| <MasterFiles> | ||
| <GeneralLedgerAccounts> | ||
| <NameOfStandardAccount> | ||
| <VersionOfStandardAccount> | ||
| <Account> | ||
| <AccountID> | General ledger account code in chart of account.
Account.AccountNumber LocalAccount.LocalAccountNumber |
|
| <AccountDescription> | Name of the GL account in chart of account.
Account.AccountText LocalAccount.Description |
|
| <StandardAccountID> | ||
| <GroupingCategory> | Category for grouping the accounts.
ReportingStructureLine.Grouping1 |
|
| <GroupingCode> | Subcode for grouping the accounts.
ReportingStructureLine.Grouping2 |
|
| <AccountType> | Type of account - Asset/Liability/Sale/Expense/Other.
If not part of the predefined enumerations then Other. ReportingStructureLine.Grouping3 |
|
| <AccountCreationDate> | Date of when the general ledger account was created.
Account.CreatedDate |
|
| <OpeningDebitBalance> OR | Opening balance at the start date of the selection period in the header's default currency.
Note: Select between <OpeningDebitBalance> or <OpeningCreditBalance> . |
|
| <OpeningCreditBalance> | If the balance is in debit, the tag is <OpeningDebitBalance>.
Otherwise, it is <OpeningCreditBalance> FinancePeriod.DebitOpening - FinancePeriod.CreditOpening - -filtered by Period From |
|
| <ClosingDebitBalance> OR | Closing balance at the end date of the selection period in the header's default currency.
Note: Select between < ClosingDebitBalance> or <ClosingCreditBalance>. |
|
| <ClosingCreditBalance> | If the balance is in debit, the tag is <ClosingDebitBalance>.
Otherwise, it is <ClosingCreditBalance> FinancePeriod.DebitOpening - FinancePeriod.CreditOpening - -filtered by Period To |
|
| <Taxonomies> | ||
| <Taxonomy> | ||
| <TaxonomyReference> | ||
| <TaxonomyElement> | ||
| <TaxonomyCode> | ||
| <TaxonomyClusterID> | ||
| <TaxonomyClusterContextID> | ||
| <AccountID> | ||
| <Customers> | ||
| <Customer> | One tag for each customer in the system. | |
| <RegistrationNumber> | CompanyCustomer.CompanyRegistrationNumber | |
| <EntityType> | ||
| <SENR> | ||
| <Name> | Name of the customer.
CompanyCustomer.Name1 |
|
| <Address> | ||
| <StreetName> | Streetname in the customer's address.
CompanyCustomer.Name2 |
|
| <Number> | House Number of the customer's address.
Address Line 3 CompanyCustomer.Name3 |
|
| <AdditionalAddressDetail> | Address Line 4
CompanyCustomer.Name4 |
|
| <Building> | ||
| <City> | Name of the city/post district of the customer address.
CompanyCustomer.PostalDistrict |
|
| <PostalCode> | Postal code for the relevant city/post district of the customer address.
CompanyCustomer.ZipCode |
|
| <Region> | ||
| <County> | ISO code of the customer's country.
Country.ISOCode |
|
| <AddressType> | ||
| <Contact> | ||
| <ContactPerson> | One tag for each contact person. | |
| <Title> | ||
| <FirstName> | First name of the person. If the name of the person is in an unstructured form, insert "NotUsed" in this element, and enter the full unstructured name in the LastName element.
Hardcoded: "NotUsed" |
|
| <Initials> | ||
| <LastNamePrefix> | ||
| <LastName> | Last name of the person. This contains the full unstructured name of the person.
CompanyCustomer.ContactPerson |
|
| <BirthName> | ||
| <Salutation> | ||
| <OtherTitles> | ||
| <Telephone> | Telephone number of the contact person.
CompanyCustomer.Telephone |
|
| <Fax> | Fax number of the contact person.
CompanyCustomer.Telefax |
|
| <Email> | Email address of the contact person.
CompanyCustomer.ElectronicMailAddress |
|
| <Website> | ||
| <MobilePhone> | ||
| <TaxRegistration> | ||
| <TaxRegistrationNumber> | Company Customer's VAT number.
CompanyCustomer.VatNumber |
|
| <TaxType> | ||
| <TaxNumber> | ||
| <TaxAuthority> | ||
| <Country> | Company Customer's ISO code.
Country.ISOCode |
|
| <TaxVerificationDate> | ||
| <BankAccount> | ||
| <IBANNumber> OR | International Bank Account Number information of the company of the customer.
CompanyCustomer.Giro Note: Select between <IBANNumber> or <BankAccountNumber> . |
|
| <BankAccountNumber> | The number allocated to the account by the company's own bank.
CompanyCustomer.BankAccount |
|
| <BankAccountName> | ||
| <SortCode> | ||
| <BIC> | Bank Identifier Code.
CompanyCustomer.SWIFTCode |
|
| <CurrencyCode> | Currency Code for the bank account.
EXCompanyCustomer.Currency |
|
| <AccountID> | ||
| <CustomerID> | Unique account code/number for the customer.
CompanyCustomer.CustomerNumber |
|
| <SelfBillingIndicator> | ||
| <AccountID> | Link to a GL account.
This is the account code where accounts receivable is consolidated in the balance sheet. CompanyDimbComb.AccountNumber:- PopupItem.PopupTypeName='CustomerControlAccountType' |
|
| <OpeningDebitBalance> OR | Opening balance at the start date of the selection period in the header's default currency. | |
| <OpeningCreditBalance> | If the balance is in debit, the tag is <OpeningDebitBalance>.
Otherwise, it is <OpeningCreditBalance> SUM(CustomerEntry.DebitBase - CustomerEntry.CreditBase) --filtered by Period From Note: Select between <OpeningDebitBalance> or <OpeningCreditBalance>. |
|
| <ClosingDebitBalance> OR | Closing balance at the end date of the selection period in the header's default currency.
Note: Select between <ClosingDebitBalance> or <ClosingCreditBalance>. |
|
| <ClosingCreditBalance> | If the balance is in debit, the tag is <ClosingDebitBalance>.
Otherwise, it is <ClosingCreditBalance> SUM(CustomerEntry.DebitBase - CustomerEntry.CreditBase) --filtered by Period To |
|
| <Suppliers> | ||
| <Supplier> | One tag for each vendor in the system. | |
| <RegistrationNumber> | CompanyVendor
CompanyRegistrationNumber |
|
| <EntityType> | ||
| <SENR> | ||
| <Name> | Name of the vendor.
CompanyVendor.Name1 |
|
| <Address> | ||
| <StreetName> | Streetname in the vendor's address.
CompanyVendor.Name2 |
|
| <Number> | House Number of the vendor's address.
Address Line 3 CompanyVendor.Name3 |
|
| <AdditionalAddressDetail> | Address Line 4
CompanyVendor.Name4 |
|
| <Building> | ||
| <City> | Name of the city/post district of the vendor address.
CompanyVendor.PostalDistrict |
|
| <PostalCode> | Postal code for the relevant city/post district of the vendor address
CompanyVendor.ZipCode |
|
| <Region> | ||
| <Country> | ISO code of the vendor's country.
Country.ISOCode |
|
| <AddressType> | ||
| <Contact> | ||
| <ContactPerson> | One tag for each contact person. | |
| <Title> | ||
| <FirstName> | First name of the person. If the name of the person is in an unstructured form, insert "NotUsed", and enter the full unstructured name in the LastName element.
Hardcoded: "NotUsed" |
|
| <Initials> | ||
| <LastNamePrefix> | ||
| <LastName> | Last name of the person. This contains the full unstructured name of the person.
CompanyVendor.Attention |
|
| <BirthName> | ||
| <Salutation> | ||
| <OtherTitles> | ||
| <Telephone> | Telephone number of the contact person.
CompanyVendor.Telephone |
|
| <Fax> | Fax number of the contact person.
CompanyVendor.Telefax |
|
| <Email> | Email address of the contact person.
CompanyVendor.ElectronicMailAddress |
|
| <Website> | ||
| <MobilePhone> | ||
| <TaxRegistration> | ||
| <TaxRegistrationNumber> | Company's VAT number.
CompanyVendor.VatNumber |
|
| <TaxType> | ||
| <TaxNumber> | ||
| <TaxAuthority> | ||
| <Country> | Company Vendor's ISO code.
Country.ISOCode |
|
| <TaxVerificationDate> | ||
| <BankAccount> | ||
| <IBANNumber> OR | International Bank Account Number information of the company of the vendor.
CompanyVendor.Giro |
|
| <BankAccountNumber> | The number allocated to the account by the company's own bank.
CompanyVendor.BankAccount |
|
| <BankAccountName> | ||
| <SortCode> | ||
| <BIC> | Bank Identifier Code.
CompanyVendor.SWIFTCode |
|
| <CurrencyCode> | Currency Code for the bank account.
EXCompanyVendor.CurrencyISO |
|
| <AccountID> | ||
| <SupplierID> | Unique account code/number for the vendor.
CompanyVendor.VendorNumber |
|
| <SelfBillingIndicator> | ||
| <AccountID> | Link to a GL account.
This is the account where accounts payable is consolidated in the balance sheet. CompanyDimbComb.AccountNumber PopupItem.PopupTypeName='VendorControlAccountType' |
|
| <OpeningDebitBalance> OR | Opening balance at the start date of the selection period in the header's default currency. | |
| <OpeningCreditBalance> | If the balance is in debit, the tag is <OpeningDebitBalance>.
Otherwise, it is <OpeningCreditBalance> SUM(VendorEntry.DebitBase - VendorEntry.CreditBase) --filtered by Period From Note: Select between <OpeningDebitBalance> or <OpeningCreditBalance>. |
|
| <ClosingDebitBalance> OR | Closing balance at the end date of the selection period in the header's default currency.
Note: Select between <ClosingDebitBalance> or <ClosingCreditBalance>. |
|
| <ClosingCreditBalance> | If the balance is in debit, the tag is <ClosingDebitBalance>.
Otherwise, it is <ClosingCreditBalance> SUM(VendorEntry.DebitBase - VendorEntry.CreditBase) --filtered by Period To |
|
| <TaxTable> | ||
| <TaxTableEntry> | ||
| <TaxType> | Tax type for look-up in tables.
Hardcoded: "VAT" |
|
| <Description> | Description of the Tax Type.
Hardcoded: "Moms" |
|
| <TaxCodeDetails> | ||
| <TaxCode> | Tax Code for lookup in tables.
FinanceVATTableLine.FinanceVATCode VATTableLine.VATCode |
|
| <EffectiveDate> | Representing the starting date for this entry. If blank, then:
SystemMaintenanceLog.TheDate FinanceVATTableLine.FromPeriod VATTableLine.FromPeriod |
|
| <ExpirationDate> | Representing the ending date for this entry.
FinanceVATTableLine.ToPeriod VATTableLine.ToPeriod |
|
| <Description> | Description of the Tax Code.
FinanceVATCode.VATType VATCode.VATTypeVATSubj |
|
| <TaxPercentage> | Tax percentage.
FinanceVATCode.VATRate VATCode.VATRate |
|
| <Country> | Two-letter country code according to ISO 3166-1 alpha 2 standard.
Country.CountryISO --derived from VATCode.Country |
|
| <Region> | ||
| <UOMTable> | ||
| <UOMTableEntry> | ||
| <UnitOfMeasure> | ||
| <Description> | ||
| <AnalysisTypeTable > | ||
| <AnalysisTypeTableEntry> | ||
| <AnalysisType> | Analysis type identifier/code for the dimension type:
For Employee No.: "E" For Job: "P" For Location Name: "L" For Entity Name: "EN" For Project Name: "PR" For Purpose Name: "PU" For Spec. 1 Name: "S1" For Spec. 2 Name: "S2" For Spec. 3 Name: "S3" For Spec. 4 Name: "S4" For Spec. 5 Name: "S5" For Spec. 6 Name: "S6" For Spec. 7 Name: "S7" For Spec. 8 Name: "S8" For Spec. 9 Name: "S9" For Spec. 10 Name: "S10" For Local Spec. 1: "LS1" For Local Spec. 2: "LS2" For Local Spec. 3: "LS3" For Local Spec. 4: "LS4" For Local Spec. 5: "LS5" For Local Spec. 6: "LS6" For Local Spec. 7: "LS7" For Local Spec. 8: "LS8" For Local Spec. 9: "LS9" For Local Spec. 10: "LS10" |
|
| <AnalysisTypeDescription> | User specified. The selected analysis table dimensions (for example, LocationName, EntityName, ProjectName, etc.).
Can be overridden by the Override Name in the selection criteria. |
|
| <AnalysisID> |
Analysis ID of the specific dimension entity. For Employee No.: Employee.EmployeeNumber For Job: JobHeader.JobNumber For Location Name: Location.LocationName For Entity Name: Entity.EntityName For Project Name: Project.ProjectName For Purpose Name: Purpose.PurposeName For Spec. 1 Name: Specification1.Specification1Name For Spec. 2 Name: Specification2.Specification2Name For Spec. 3 Name: Specification3.Specification3Name For Spec. 4 Name: Specification4.Specification4Name For Spec. 5 Name: Specification5.Specification5Name For Spec. 6 Name: Specification6.Specification6Name For Spec. 7 Name: Specification7.Specification7Name For Spec. 8 Name: Specification8.Specification8Name For Spec. 9 Name: Specification9.Specification9Name For Spec. 10 Name: Specification10.Specification10Name For Local Spec. 1: CompanyInformation.LocalSpec1Name For Local Spec. 2: CompanyInformation.LocalSpec2Name For Local Spec. 3: CompanyInformation.LocalSpec3Name For Local Spec. 4: CompanyInformation.LocalSpec4Name For Local Spec. 5: CompanyInformation.LocalSpec5Name For Local Spec. 6: CompanyInformation.LocalSpec6Name For Local Spec. 7: CompanyInformation.LocalSpec7Name For Local Spec. 8: CompanyInformation.LocalSpec8Name For Local Spec. 9: CompanyInformation.LocalSpec9Name For Local Spec. 10: CompanyInformation.LocalSpec10Name |
|
| <AnalysisDescription> |
Description of the specific dimension entity. For Employee No.: Employee.Name1 For Job: JobHeader.JobName For Location Name: Location.Description For Entity Name: Entity.Description For Project Name: Project.Description For Purpose Name: Purpose.Description For Spec. 1 Name: Specification1.Description For Spec. 2 Name: Specification2.Description For Spec. 3 Name: Specification3.Description For Spec. 4 Name: Specification4.Description For Spec. 5 Name: Specification5.Description For Spec. 6 Name: Specification6.Description For Spec. 7 Name: Specification7.Description For Spec. 8 Name: Specification8.Description For Spec. 9 Name: Specification9.Description For Spec. 10 Name: Specification10.Description For Local Spec. 1: LocalSpec1Line.Description For Local Spec. 2: LocalSpec2Line.Description For Local Spec. 3: LocalSpec3Line.Description For Local Spec. 4: LocalSpec4Line.Description For Local Spec. 5: LocalSpec5Line.Description For Local Spec. 6: LocalSpec6Line.Description For Local Spec. 7: LocalSpec7Line.Description For Local Spec. 8: LocalSpec8Line.Description For Local Spec. 9: LocalSpec9Line.Description For Local Spec. 10: LocalSpec10Line.Description |
|
| <MovementTypeTable> | ||
| <MovementTypeTableEntry> | ||
| <MovementType> | ||
| <Description> | ||
| <Products> | ||
| <Product> | ||
| <ProductCode> | ||
| <GoodsServicesID> | ||
| <ProductGroup> | ||
| <Description> | ||
| <ProductCommodityCode> | ||
| <ProductNumberCode> | ||
| <ValuationMethod> | ||
| <UOMBase> | ||
| <UOMStandard> | ||
| <UOMToUOMBaseConversionFactor> | ||
| <Tax> | ||
| <TaxType> | ||
| <TaxCode> | ||
| <PhysicalStock> | ||
| <PhysicalStockEntry> | ||
| <WarehouseID> | ||
| <LocationID> | ||
| <ProductCode> | ||
| <StockAccountNo> | ||
| <ProductType> | ||
| <ProductStatus> | ||
| <StockAccountCommodityCode> | ||
| <OwnerID> | ||
| <UOMPhysicalStock> | ||
| <UOMToUOMBaseConversionFactor> | ||
| <UnitPrice> | ||
| <OpeningStockQuantity> | ||
| <OpeningStockValue> | ||
| <ClosingStockQuantity> | ||
| <ClosingStockValue> | ||
| <StockCharacteristics> | ||
| <StockCharacteristic> | ||
| <StockCharacteristicValue> | ||
| <Owners> | ||
| <Owner> | ||
| <RegistrationNumber> | ||
| <EntityType> | ||
| <SENR> | ||
| <Name> | ||
| <Address> | ||
| <StreetName> | ||
| <Number> | ||
| <AdditionalAddressDetail> | ||
| <Building> | ||
| <City> | ||
| <PostalCode> | ||
| <Region> | ||
| <Country> | ||
| <AddressType> | ||
| <Contact> | ||
| <ContactPerson> | ||
| <Title> | ||
| <FirstName> | ||
| <Initials> | ||
| <LastNamePrefix> | ||
| <LastName> | ||
| <BirthName> | ||
| <Salutation> | ||
| <OtherTitles> | ||
| <Telephone> | ||
| <Fax> | ||
| <Email> | ||
| <Website> | ||
| <MobilePhone> | ||
| <TaxRegistration> | ||
| <TaxRegistrationNumber> | ||
| <TaxType> | ||
| <TaxNumber> | ||
| <TaxAuthority> | ||
| <Country> | ||
| <TaxVerificationDate> | ||
| <BankAccount> | ||
| <IBANNumber> | ||
| <BankAccountNumber> | ||
| <BankAccountName> | ||
| <SortCode> | ||
| <BIC> | ||
| <CurrencyCode> | ||
| <AccountID> | ||
| <OwnerID> | ||
| <AccountID> | ||
| <Assets> | ||
| <Asset> | ||
| <AssetID> | ||
| <AccountID> | ||
| <Description> | ||
| <Supplier> | ||
| <SupplierName> | ||
| <SupplierID> | ||
| <PostalAddress> | ||
| <StreetName> | ||
| <Number> | ||
| <City> | ||
| <PostalCode> | ||
| <Country> | ||
| <AddressType> | ||
| <PurchaseOrderDate> | ||
| <DateOfAcquisition> | ||
| <StartUpDate> | ||
| <Valuations> | ||
| <Valuation> | ||
| <AssetValuationType> | ||
| <ValuationClass> | ||
| <AcquisitionAndProductionCostsBegin> | ||
| <AcquisitionAndProductionCostsEnd> | ||
| <InvestmentSupport> | ||
| <AssetLifeYear> | ||
| <AssetAddition> | ||
| <Transfers> | ||
| <AssetDisposal> | ||
| <BookValueBegin> | ||
| <DepreciationMethod> | ||
| <DepreciationPercentage> | ||
| <DepreciationForPeriod> | ||
| <AppreciationForPeriod> | ||
| <ExtraordinaryDepreciationsForPeriod> | ||
| <ExtraordinaryDepreciationForPeriod> | ||
| <ExtraordinaryDepreciationMethod> | ||
| <ExtraordinaryDepreciationForPeriod> | ||
| <AccumulatedDepreciation> | ||
| <BookValueEnd> | ||
| </MasterFiles> | ||
| <GeneralLedgerEntries> | ||
| <NumberOfEntries> | Number of unique transactions (identified by Transaction No.).
COUNT(FinanceEntry) |
|
| <TotalDebit> | The total of all debit amounts in the header's default currency.
SUM(FinanceEntry.DebitBase) |
|
| <TotalCredit> | The total of all credit amounts in the header's default currency.
SUM(FinanceEntry.CreditBase) |
|
| <Journal> | ||
| <JournalID> | Source GL journal identifier, or invoices and payments in single ledger systems.
FinanceEntry.JournalNumber |
|
| <Description> | Description of the Journal.
EXFinanceEntry.JournalType |
|
| <Type> | Grouping mechanism for journals.
EXFinanceEntry.JournalType |
|
| <Transaction> | ||
| <TransactionID> | The number/ID of the accounting document/voucher. FinanceEntry.
TransactionNumber |
|
| <Period> | Accounting Period.
FiscalYearPeriod.Month |
|
| <PeriodYear> | The year of the Accounting Period.
Restriction: 1970-2100. FiscalYearPeriod.Year |
|
| <TransactionDate> | The date of the accounting document/voucher.
FinanceEntry.EntryDate |
|
| <SourceID> | Details of person or application that entered the transaction.
Journal.NameOfUser |
|
| <TransactionType> | ||
| <Description> | Description of Journal Transaction.
FinanceEntry.JournalType |
|
| <BatchID> | ||
| <SystemEntryDate> | The date when the transaction was entered into the system.
Journal.CreatedDate |
|
| <GLPostingDate> | Date posting to the general ledger account.
FinanceEntry.PostingDate |
|
| <CustomerID> | Unique code for the customer.
CustomerEntry.CustomerNumber |
|
| <SupplierID> | Unique code for supplier.
VendorEntry.VendorNumber |
|
| <SystemID> | ||
| <Line> | ||
| <RecordID> | Identifier to trace entry to journal line or posting reference.
Unique Journal Line No. FinanceEntry.CombinedSequenceNumber |
|
| <AccountID> | GL account code.
Account.AccountNumber LocalAccount.LocalAccountNumber |
|
| <Analysis> | ||
| <AnalysisType> | AnalysisTypeEntry (for example, LS1, S1, etc.). | |
| <AnalysisID> | Dimension value (for example, Local Spec 1 Name, Spec 1 Name, etc.). | |
| <AnalysisIDDescription> | ||
| <AnalysisAmount> | ||
| <Amount> | ||
| <CurrencyCode> | ||
| <CurrencyAmount> | ||
| <ExchangeRate> | ||
| <ValueDate> | ||
| <SourceDocumentID> | Source document number to which line relates.
FinanceEntry.JournalNumber |
|
| <CustomerID> | Unique account code/number for the customer.
CustomerEntry.CustomerNumber |
|
| <SupplierID> | Unique account code/number for the supplier/vendor.
VendorEntry.VendorNumber |
|
| <Description> | Description of the Journal Line.
FinanceEntry.EntryText |
|
| <DebitAmount> | If the total amount is in debit, the tag is <DebitAmount>.
Otherwise, it is <CreditAmount> |
|
| <Amount> | Amount in the header's default currency.
FinanceEntry.DebitBase - FinanceEntry.CreditBase |
|
| <CurrencyCode> | Three-letter currency code according to ISO 4217 standard.
Required if CurrencyAmount is used. EXFinanceEntry.OriginalCurrency |
|
| <CurrencyAmount> | Amount in foreign currency.
Required if CurrencyCode is used. FinanceEntry.DebitCurrency - FinanceEntry.CreditCurrency |
|
| <ExchangeRate> | ||
| <TaxInformation> | ||
| <TaxType> | Tax type for look-up in tables.
VATSettlementEntry.VATType |
|
| <TaxCode> | Tax Code for lookup in tables.
VATSettlementEntry.VATCode |
|
| <StandardTaxCode> | ||
| <StandardTaxCodeDescription> | ||
| <Country> | ||
| <TaxPercentage> | Tax percentage.
VATSettlementEntry.VATRate |
|
| <TaxBase> | The base on which the tax is calculated.
VATSettlementEntry.DebitBasisBase - CreditBasisBase |
|
| <TaxBaseDescription> | ||
| <TaxAmount> | ||
| <Amount> | Amount in the header's default currency.
VATSettlementEntry.DebitVATBase - CreditVATBase |
|
| <CurrencyCode> | Three-letter currency code according to ISO 4217 standard.
Required if CurrencyAmount is used. EXVATSettlementEntry.OriginalCurrency |
|
| <CurrencyAmount> | Amount in foreign currency. Required if CurrencyCode is used.
VATSettlementEntry.DebitVATCurrency - VATSettlementEntry.CreditVATCurrency |
|
| <ExchangeRate> | ||
| <TaxExemptionReason> | ||
| <TaxDeclarationPeriod> | ||
| </GeneralLedgerEntries> | ||
| <SourceDocuments> | SourceDocuments tag is optional and will not be included. | |
| </SourceDocuments> | ||
| </AuditFile> |
VAT Return Report — XML Schema
| Tags | Description |
|---|---|
| <ModtagMomsangivelseForeloebig_I> | |
| <HovedOplysninger> | |
| <TransaktionIdentifikator> | Transaction identifier (Used for integration - no mapping in output file). |
| <TransaktionTid> | Transaction time. |
| </HovedOplysninger> | |
| <Angivelse> | |
| <AngiverVirksomhedSENummer> | |
| <VirksomhedSENummerIdentifikator> | Reporting Company number. |
| </AngiverVirksomhedSENummer> | |
| <Angivelsesoplysninger> | |
| <AngivelsePeriodeFraDato> | Starting date "From Date" or "From Period" of the Selection Criteria. |
| <AngivelsePeriodeTilDato> | Ending date "To Date" or "To Period" of the Selection Criteria. |
| </Angivelsesoplysninger> | |
| <Angivelsesafgifter> | |
| <MomsAngivelseAfgiftTilsvarBeloeb> | Total VAT Deductions (Box 1).
Sum of the incoming, outgoing tax and energy tax. Sum of (Box 14, Box 9 and all the Reimbursable Energy Tax). |
| <MomsAngivelseCO2AfgiftBeloeb> | VAT Declaration CO2 Tax Amount "CO2 Tax Amount" from Selection Criteria. |
| <MomsAngivelseEUKoebBeloeb> | Box A - Goods (Box 3).
Value net of VAT of purchases of goods in other EU countries (EU acquisitions). If vendor country is an EU member country and not Denmark; and EU Acquisition tax code is Yes; and Tax Popup 1 is Goods, then: SUM(VATSETTLEMENTENTRY.DEBITBASISBASE - VATSETTLEMENTENTRY.CREDITBASISBASE |
| <MomsAngivelseEUSalgBeloebVarerBeloeb> | Box B - Goods (Box 4).
To be reported to "EU sales excluding VAT". The value of sales of goods excluding VAT to other EU countries. If ship to customer country or customer country is an EU member country and not Denmark; and customer tax number is not empty; and the Tax Popup 1 is Goods, then: SUM(VATSETTLEMENTENTRY.DEBITBASISBASE - VATSETTLEMENTENTRY.CREDITBASISBASE) |
| <MomsAngivelseIkkeEUSalgBeloebVarerBeloeb> | Box B - Goods (Box 5).
To be reported to "EU sales excluding VAT". The value of, for example, installation and assembly, distance selling and new means of transport to non-VAT registered customers without VAT to other EU countries. f ship to customer country or customer country is an EU member country and not Denmark; and customer tax number is empty; the Tax Popup 1 is Goods, then: SUM(VATSETTLEMENTENTRY.DEBITBASISBASE - VATSETTLEMENTENTRY.CREDITBASISBASE) |
| <MomsAngivelseElAfgiftBeloeb> | VAT Declaration Electricity Tax Amount "Electricity Tax Amount" from Selection Criteria. |
| <MomsAngivelseEksportOmsaetningBeloeb> | Box C (Box 7).
Value of other goods and services supplied free of tax in Denmark, in other EU countries and in countries outside the EU. If the Tax Popup 1 is Goods and Services; and Tax rate is 0 percent, then: SUM(VATSETTLEMENTENTRY.DEBITBASISBASE - VATSETTLEMENTENTRY.CREDITBASISBASE) |
| <MomsAngivelseGasAfgiftBeloeb> | Natural gas and city gas tax "Natural Gas Tax Amount" from Selection Criteria. |
| <MomsAngivelseKoebsMomsBeloeb> | (Box 9) Purchase Tax (Incoming Tax).
Summation of VAT Amounts of Boxes 11, 14, 12, 3. |
| <MomsAngivelseKulAfgiftBeloeb> | VAT Declaration Coal Tax Amount "Coal Tax Amount" from Selection Criteria. |
| <MomsAngivelseMomsEUKoebBeloeb> | (Box 11) VAT on purchases of goods abroad (both EU and non- EU).
If Tax Popup 1 is Goods and Vendor Country is not Denmark, then: SUM(VATSETTLEMENTENTRY.DEBITVATBASE - VATSETTLEMENTENTRY.CREDITVATBASE) |
| <MomsAngivelseMomsEUYdelserBeloeb> | (Box 12) VAT on purchases of services abroad (construction services and hiring out of labour).
If Tax Popup 1 is Services and Vendor Country is not Denmark, then: SUM(VATSETTLEMENTENTRY.DEBITVATBASE - VATSETTLEMENTENTRY.CREDITVATBASE) |
| <MomsAngivelseOlieAfgiftBeloeb> | VAT Declaration Oil Tax Amount "Oil Tax Amount" from Selection Criteria. |
| <MomsAngivelseSalgsMomsBeloeb> | (Box 14) Sales VAT (Outgoing VAT) Summation of Tax Amounts of Boxes 4, 5, 7 and 17. |
| <MomsAngivelseVandAfgiftBeloeb> | VAT Declaration Water Tax Amount "Water Tax Amount" from Selection Criteria. |
| <MomsAngivelseEUKoebYdelseBeloeb> | Box A - Benefits (Box 16).
Value net of VAT of purchases of services in other EU countries. If vendor country is an EU member country and not Denmark; and the Tax Popup 1 is Services, then: SUM(VATSETTLEMENTENTRY.DEBITBASISBASE - VATSETTLEMENTENTRY.CREDITBASISBASE) |
| <MomsAngivelseEUSalgYdelseBeloeb> | Box B - Benefits (Box 17).
The value of certain sales of services excluding VAT to other EU countries. To be reported for EU sales without VAT (Box B). If ship to customer country or customer country is an EU member country and not Denmark and the Tax Popup 1 is Services, then: SUM(VATSETTLEMENTENTRY.DEBITBASISBASE - VATSETTLEMENTENTRY.CREDITBASISBASE) |
| </Angivelsesafgifter> | |
| </Angivelse> | |
| </ModtagMomsangivelseForeloebig_I> |
Troubleshooting
Background Task Timeout
Reports with large volumes of records take longer to process and the background task may timeout. To prevent timeout errors, you must change the character stream size to 2000 or higher (on the BO server console), and set the background task duration to more than 24 hours (on Maconomy).
Set Character Stream Size
To prevent timeouts while running the report, you must change the character stream size on the Business Objects (BO) Central Management Console (CMC) prior to running the report.
To change the character stream size:
- On the BO CMC, log in as an Administrator.
- Click Servers and select Server List.
- From the list of server names, click WebIntelligenceProcessingServer.
- Select
Properties then edit the
Maximum Character Stream Size (MB) field value, from 15 to at least 2000 or your preferred value up to 4095.
Note: The recommended value when running the report is 2000.
- Click Save then close the dialog box.
- Right-click WebIntelligenceProcessingServer then select Restart Server.
Set Background Task Maximum Duration
If the default maximum duration time (1440 minutes) is not enough to generate the report, you can change the maximum duration for the background task.
To change the maximum duration:
- Generate a report to start a background task.
Click OK in the prompt.
- Go to
Setup » Background Tasks » Status and locate your task. It should be at the top of the list.
- Select the task and click the Abort action button.
- Click OK in the prompt.
- Right-click the task (the status displays as Failed) and click
Copy as Template.
A new task should display at the top of the list (the status displays as Pending.)
- Go to the Editing tab then locate and double-click the pending task.
Note: You may need to filter the list and show Inactive Pending Tasks.
- Edit the Max. Duration field to a higher value, such as 2880 for 48 hours.
- Click the Save » Activate action.
- Click OK in the prompt.
- Go to the Status tab and click the
Refresh action button.
The task should run and generate a report.
Note: If the background task still fails, you need to adjust the maximum duration time to accommodate the amount of records.