| Company |
|
| RegistrationNumber |
CompanyInformation.CompanyNo |
| Name |
Company.Name |
| Address |
|
| StreetName |
Associate.AddressLine1 |
| AdditionalAddressDetail |
Associate.AddressLine2 |
| City |
Associate.PostalArea |
| PostalCode |
Associate.PostCode |
| Country |
Country.IsoCode |
| AddressType |
"StreetAddress" |
| Address |
|
| StreetName |
CompanyInformation.AddressLine1 |
| AdditionalAddressDetail |
CompanyInformation.AddressLine2 |
| PostalCode |
CompanyInformation.PostCode |
| Country |
Country.IsoCode |
| AddressType |
"PostalAddress" |
| Contact |
|
| ContactPerson |
|
| FirstName |
"Not Used" |
| LastName |
CompanyInformation.AccountantsName |
| Telephone |
CompanyInformation.Phone |
| Fax |
CompanyInformation.Fax |
| Email |
CompanyInformation.AccountantsEmailAddress if stated, else
C.CompanyInformation.EmailAddress |
| Website |
CompanyInformation.WebPage |
| TaxRegistration |
|
| TaxRegistrationNumber |
CompanyInformation.CompanyNo & "MVA" |
| TaxAuthority |
"Skatteetaten" |
| BankAccount |
|
| IBANNumber |
CompanyInformation.IbanBic |
| BankAccountNumber |
CompanyInformation.BankAccount |
| DefaultCurrencyCode |
Currency.IsoCode on the Currency row referred to by
CompanyInformation.CurrencyNo |
| SelectionCriteria |
|
| SelectionStartDate |
From date |
| SelectionEndDate |
To date |
| TaxAccountingBasis |
"A" |
| UserID |
User.UserName |
| MasterFiles |
|
| GeneralLedgerAccounts |
|
| AccountID |
GeneralLedgerAccount.AccountNo |
| AccountDescription |
GeneralLedgerAccount.Name |
| StandardAccountID |
GeneralLedgerAccount.SaftAccountId |
| GroupingCategory |
GeneralLedgerAccount.GroupingCategory |
| GroupingCode |
GeneralLedgerAccount.GroupingCode |
| AccountType |
"GL" |
| OpeningCreditBalance |
-Opening balance |
| OpeningDebitBalance |
Opening balance |
| ClosingCreditBalance |
-Closing balance |
| ClosingDebitBalance |
Closing balance |
| Customers |
|
| Customer |
|
| RegistrationNumber |
Associate.CompanyNo |
| Name |
Associate.Name |
| Address |
|
| StreetName |
Associate.AddressLine1 |
| AdditionalAddressDetail |
Associate.AddressLine2 |
| City |
Associate.PostalArea |
| PostalCode |
Associate.PostCode |
| Country |
Country.IsoCode |
| Contact |
|
| ContactPerson |
|
| FirstName |
"Not used" |
| LastName |
Associate.Name |
| Telephone |
Associate.Phone if stated, else Associate.PrivatePhone |
| Fax |
Associate.Fax1 |
| Email |
Associate.EmailAddress |
| Website |
Associate.WebPage1 |
| MobilePhone |
Associate.MobilePhone |
| TaxRegistration |
|
| TaxRegistrationNumber |
Associate.CompanyNo & "MVA" |
| TaxAuthority |
"Skatteetaten" |
| BankAccount |
|
| IBANNumber |
Associate.Iban |
| BankAccountNumber |
Associate.BankAccount |
| CustomerID |
Associate.CustomerNo |
| AccountID |
Associate.GeneralLedgerAccountNoForCustomer |
| OpeningCreditBalance |
-Opening balance |
| OpeningDebitBalance |
Opening balance |
| ClosingCreditBalance |
-Closing balance |
| ClosingDebitBalance |
Closing balance |
| PartyInfo |
|
| PaymentTerms |
|
| Days |
PaymentTerms.CreditDays |
| Months |
PaymentTerms.CreditMonths |
| CashDiscountDays |
PaymentTerms.DiscountDays |
| CashDiscountRate |
PaymentTerms.CashDiscountPercent |
| CurrencyCode |
Currency.IsoCode |
| Type |
"Private" |
| Analysis |
|
| AnalysisType |
"OrgUnit" & Organisational unit class number |
| AnalysisID |
Associate.OrgUnit & Organisational unit class number |
| Supplier |
|
| RegistrationNumber |
Associate.CompanyNo |
| Name |
Associate.Name |
| Address |
|
| StreetName |
Associate.AddressLine1 |
| AdditionalAddressDetail |
Associate.AddressLine2 |
| City |
Associate.PostalArea |
| PostalCode |
Associate.PostCode |
| Country |
Country.IsoCode |
| Contact |
|
| ContactPerson |
|
| FirstName |
"Not used" |
| LastName |
Associate.Name |
| Telephone |
Associate.Phone if stated, else Associate.PrivatePhone |
| Fax |
Associate.Fax1 |
| Email |
Associate.EmailAddress |
| Website |
Associate.WebPage1 |
| MobilePhone |
Associate.MobilePhone |
| TaxRegistration |
|
| TaxRegistrationNumber |
Associate.CompanyNo & "MVA" |
| TaxAuthority |
"Skatteetaten" |
| BankAccount |
|
| IBANNumber |
Associate.Iban |
| BankAccountNumber |
Associate.BankAccount |
| SupplierID |
Associate.SupplierNo |
| AccountID |
Associate.GeneralLedgerAccountNoForSupplier |
| OpeningCreditBalance |
-Opening balance |
| OpeningDebitBalance |
Opening balance |
| ClosingCreditBalance |
-Closing balance |
| ClosingDebitBalance |
Closing balance |
| PartyInfo |
|
| PaymentTerms |
|
| Days |
PaymentTerms.CreditDays |
| Months |
PaymentTerms.CreditMonths |
| CashDiscountDays |
PaymentTerms.DiscountDays |
| CashDiscountRate |
PaymentTerms.CashDiscountPercent |
| CurrencyCode |
Currency.IsoCode |
| Analysis |
|
| AnalysisType |
"OrgUnit" & Organisational unit class number |
| AnalysisID |
Associate.OrgUnit & Organisational unit class number |
| TaxTable |
|
| TaxTableEntry |
|
| TaxType |
"MVA" |
| Description |
"Merverdiavgift" |
| TaxCodeDetails |
|
| TaxCode |
TaxCode.TaxCode |
| EffectiveDate |
Vat.FromDate |
| ExpirationDate |
Vat.FromDate |
| Description |
TaxCode.Description |
| TaxPercentage |
Vat.NewRate |
| TaxPercentage |
Vat.Rate |
| Country |
"NO" |
| StandardTaxCode |
VatProcessing.UseVatCompensation |
| Compensation |
"true" |
| BaseRate |
100 - TaxCode.CostPercent |
| AnalysisTypeTable |
|
| AnalysisTypeTableEntry |
|
| AnalysisType |
"VoTp" |
| AnalysisTypeDescription |
The actual translated name of the VoucherType table, e.g. "Voucher type" |
| AnalysisID |
VoucherType.VoucherType |
| AnalysisIDDescription |
VoucherType.DefaultText |
| Analysis |
|
| AnalysisType |
"OrgUnit" & Organisational unit class number |
| AnalysisID |
VoucherType.OrgUnit & Organisational unit class number |
| AnalysisType |
"OrgUnit" & Organisational unit class number |
| AnalysisTypeDescription |
CompanyInformation.OrgUnit & Organisational unit class number &
Name |
| AnalysisID |
OrgUnit & Organisational unit class number & OrgUnit & Organisational
unit class number & No |
| AnalysisIDDescription |
OrgUnit & Organisational unit class number & Name |
| StartDate |
OrgUnit & Organisational unit class number & ActualStartDate |
| EndDate |
OrgUnit & Organisational unit class number & ActualEndDate |
| Analysis |
|
| AnalysisType |
Ansvarsenhet 1 or other
Organisational unit class number |
| AnalysisID |
Ansvarsenhet 1 or other
Organisational unit class number & MainUnit} |
| Analysis |
|
| AnalysisType |
"OrgUnit" & Organisational unit class number |
| AnalysisID |
OrgUnit & Organisational unit class number & OrgUnit & Organisational
unit class number |
| GeneralLedgerEntries |
|
| NumberOfEntries |
Number of GeneralLedgerTransaction rows with GeneralLedgerTransaction.ValueDate
between From date and To date, sorted on GeneralLedgerTransaction.VoucherJournalNo and
GeneralLedgerTransaction.AuditNo, where GeneralLedgerTransaction.VoucherJournalNo or
GeneralLedgerTransaction.VoucherNo are not the same as on the previous row |
| TotalDebit |
Sum GeneralLedgerTransaction.PostedAmountDomestic where
GeneralLedgerTransaction.ValueDate is between From date and To date, and
GeneralLedgerTransaction.Credit is false |
| TotalCredit |
-Sum C.GeneralLedgerTransaction.PostedAmountDomestic where
GeneralLedgerTransaction.ValueDate is between From date and To date, and
GeneralLedgerTransaction.Credit is true |
| Journal |
|
| JournalID |
GeneralLedgerTransaction.VoucherJournalNo |
| Description |
GeneralLedgerTransaction.VoucherJournalNo |
| Type |
"A" |
| Transaction |
|
| TransactionID |
GeneralLedgerTransaction.VoucherNo |
| Period |
GeneralLedgerTransaction.Period |
| PeriodYear |
GeneralLedgerTransaction.Year |
| TransactionDate |
GeneralLedgerTransaction.VoucherDate |
| SourceID |
GeneralLedgerTransaction.CreatedByUser |
| TransactionType |
GeneralLedgerTransaction.Origin |
| Description |
GeneralLedgerTransaction.Text |
| BatchID |
GeneralLedgerTransaction.UpdatedBatchNo |
| SystemEntryDate |
GeneralLedgerTransaction.VoucherDate |
| GLPostingDate |
GeneralLedgerTransaction.ValueDate |
| Line |
|
| RecordID |
GeneralLedgerTransaction.AuditNo |
| AccountID |
GeneralLedgerTransaction.AccountNo |
| Analysis |
|
| AnalysisType |
"VoTp" |
| AnalysisID |
GeneralLedgerTransaction.VoucherType |
| Analysis |
|
| AnalysisType |
"OrgUnit" & Organisational unit class number |
| AnalysisID |
GeneralLedgerTransaction. & Organisational unit class number |
| ValueDate |
GeneralLedgerTransaction.ValueDate |
| SourceDocumentID |
GeneralLedgerTransaction.ScanDocumentNo |
| SourceDocumentID |
GeneralLedgerTransaction.VismaId |
| CustomerID |
GeneralLedgerTransaction.CustomerNo |
| SupplierID |
GeneralLedgerTransaction.SupplierNo |
| Description |
GeneralLedgerTransaction.Text |
| CreditAmount |
|
| Amount |
-GeneralLedgerTransaction.PostedAmountDomestic |
| CurrencyCode |
Currency.IsoCode} |
| CurrencyAmount |
-GeneralLedgerTransaction.AmountInCurrency |
| ExchangeRate |
GeneralLedgerTransaction.ExchangeRate |
| DebitAmount |
|
| Amount |
GeneralLedgerTransaction.PostedAmountDomestic |
| CurrencyCode |
Currency.IsoCode |
| CurrencyAmount |
GeneralLedgerTransaction.AmountInCurrency |
| ExchangeRate |
GeneralLedgerTransaction.ExchangeRate |
| TaxInformation |
|
| TaxType |
"MVA" |
| TaxCode |
GeneralLedgerTransaction.TaxCode if stated, else empty string |
| TaxPercentage |
GeneralLedgerTransaction.VatRate |
| TaxBase |
GeneralLedgerTransaction.BasisDomestic, multiplied with -1 if
GeneralLedgerTransaction.Credit is true |
| TaxAmount |
|
| Amount |
GeneralLedgerTransaction.VatAmountDomestic, multiplied with -1 if
GeneralLedgerTransaction.Credit is true |
| ReferenceNumber |
GeneralLedgerTransaction.InvoiceNo |
| Quantity |
GeneralLedgerTransaction.Quantity |