SIE

SIE export component.

The SIE format is a Swedish standard for transferring accounting data. For more information, see www.sie.se.

Component modes: SIE 5 | SIE 4

Component mode: SIE 5

File modes: Download | Save | Save and download

File mode: Download

The user downloads the file.

SQL

SQL Call: SIE (mandatory)

May modify database: No

Resultset: File information

Table count: repeated exactly once
Row count: exactly one row
Columns
AccountingCurrency mandatory string

Three letter currency code (ISO 4217), e.g. 'SEK'.

CertificateThumbprint mandatory string

The thumbprint of the certificate to sign the generated document with.

The certificate can be placed in either Current User or Local Machine.

Check the menu item Admin > Softadmin® system information > Installed certificates to see which certificates are accessible from Softadmin®.

ClientId optional string

An internal identification in the accounting system, e.g. client number.

CompanyName mandatory string

The name of the company.

CreatedBy mandatory string

Meta information stored in the generated file. The name of the person or routine that created the file.

FileCreationDatetime optional datetime

Meta information stored in the generated file. The date and time when the file was created.

Default: Defaults to the current date and time. The main reason to override this is to get deterministic file contents for testing.
Filename optional string

The name of the file to generate.

Default: Defaults to 'SIEYYYYMMDDHHMM.sie'.
Multiple optional int

A sequence number for distinquishing between different sole proprietorships for the same person.

OrganizationId mandatory string

The company's organization number. There should be a hyphen before the last four digits: XXXXXX-XXXX (or XXXXXXXX-XXXX).

SoftwareName optional string

Meta information stored in the generated file. Should be the name of the program generating the file.

Default: Defaults to the value of the "Application Name" language phrase.
SoftwareVersion optional string

Meta information stored in the generated file. The version of the program that generated the file.

Default: Defaults to the Softadmin® version.

Resultset: Fiscal years

The fiscal years to include.

Should typically include the primary fiscal year to export and the preceding year.

Table count: repeated exactly once
Row count: one or more rows
Columns
FiscalYearEndMonth mandatory int

The month (1-12) the fiscal year ends.

FiscalYearEndYear mandatory int

The year (YYYY) the fiscal year ends.

FiscalYearStartMonth mandatory int

The month (1-12) the fiscal year starts.

FiscalYearStartYear mandatory int

The year (YYYY) the fiscal year starts.

HasLedgerEntries optional bit

Indicates whether the file contains ledger entries for this fiscal year.

Default: If omitted, it defaults to 1 for the primary fiscal year, and 0 for the other fiscal years.
HasSubordinateAccounts optional any

Indicates whether the file contains subdivided accounts for this fiscal year.

Default: If omitted, it defaults to 1 for the primary fiscal year, and 0 for the other fiscal years.
IsClosed optional bit

Set to 1 to indicate that the fiscal year is closed.

IsPrimary mandatory bit

Set to 1 to indicate that this is the primary fiscal year for which the data has been exported. Exactly one fiscal year should be marked as primary.

LastCoveredDate optional date

Indicates that information after this date for this fiscal year is not complete or reliable.

Resultset: Accounts

The chart of accounts.

Table count: repeated exactly once
Row count: zero or more rows
Columns
Account mandatory int

The account number.

AccountName mandatory string

The name of the account.

AccountType mandatory string

The type of account.

Possible value Description
Asset
Cost
Income
Liability
Unit optional string

The unit used for quantities for this account, if any.

Resultset: Dimensions (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
DimensionId mandatory int

The dimension number. Either use one of the predefined values listed below, or use 20 or above for custom dimensions.

Possible value Description
1 Kostnadsställe/resultatenhet
2 Kostnadsbärare
3 Filial/butik
4 Verksamhetsgren
6 Projekt
7 Anställd
DimensionName mandatory string

The name of the dimension.

Resultset: Dimension values (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
DimensionValueId mandatory string

The dimension value ID.

DimensionId mandatory int

The dimension that this dimension value belongs to.

DimensionValueName mandatory string

The name of the dimension value.

Resultset: Customers (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
CustomerId mandatory string

A value that uniquely identifies the customer, typically the customer number.

Address1 optional string

Address line 1.

Address2 optional string

Address line 2.

City optional string

The customer's city.

Country optional string

The customer's country.

CustomerName mandatory string

The customer's name.

OrganizationId optional string

The customer's organization id. Should use the format XXXXXX-XXXX (or XXXXXXXX-XXXX).

VatNumber optional string

The customer's VAT number.

ZipCode optional string

The customer's zip code.

Resultset: Suppliers (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
SupplierId mandatory string

A value that uniquely identifies the supplier, typically the supplier number.

Address1 optional string

Address line 1.

Address2 optional string

Address line 2.

City optional string

The supplier's city.

Country optional string

The supplier's country.

OrganizationId optional string

The supplier's organization id. Should use the format XXXXXX-XXXX (or XXXXXXXX-XXXX).

SupplierName mandatory string

The supplier's name.

VatNumber optional string

The supplier's VAT number.

ZipCode optional string

The supplier's zip code.

Resultset: Subdivided account groups (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
PrimaryAccount mandatory int

The primary account. Uniquely identifies this group. Could e.g. be 1510 for a group of customer invoices.

AccountName optional string

The name of the account.

SubdividedAccountType mandatory string

The type of objects the group contains.

Possible value Description
CustomerInvoice
FixedAsset
GeneralObject General object that does not fit in any of the other categories.
SupplierInvoice

Resultset: Secondary accounts (optional)

Additional accounts included in subdivided account groups. Commonly used for fixed assets.

Table count: repeated zero or one time
Row count: zero or more rows
Columns
PrimaryAccount mandatory int

The primary account of the group.

SecondaryAccount mandatory int

An additional account included in the group.

Resultset: Customer invoices (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
CustomerInvoiceId mandatory string

A value uniquely identifying this customer invoice within the group. Could e.g. be the invoice number (if it is unique).

PrimaryAccount mandatory int

The primary account of the account group that this customer invoice belongs to.

Amount mandatory decimal

The original amount in the accounting currency.

Use at most two decimal digits to the right of the decimal point.

CustomerId mandatory string

The customer as specified in the Customers result set.

CustomerInvoiceName optional string

The name of the customer invoice.

Default: If omitted, the receiving program will likely use the customer's name.
DueDate optional date

The due date of the invoice.

EntryDate mandatory date

Date of entry.

ForeignCurrency optional string

Three letter currency code (ISO 4217), e.g. 'SEK'.
Used together with ForeignCurrencyAmount.

ForeignCurrencyAmount optional decimal

The foreign currency amount in the currency specified by ForeignCurrency.

Use at most two decimal digits to the right of the decimal point.

InvoiceNumber mandatory string

The invoice number.

Resultset: Supplier invoices (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
SupplierInvoiceId mandatory string

A value uniquely identifying this supplier invoice within the group. Could e.g. be the invoice number (if it is unique).

PrimaryAccount mandatory int

The primary account of the account group that this supplier invoice belongs to.

Amount mandatory decimal

The original amount in the accounting currency.

Use at most two decimal digits to the right of the decimal point.

DueDate optional date

The due date of the invoice.

EntryDate mandatory date

Date of entry.

ForeignCurrency optional string

Three letter currency code (ISO 4217), e.g. 'SEK'.
Used together with ForeignCurrencyAmount.

ForeignCurrencyAmount optional decimal

The foreign currency amount in the currency specified by ForeignCurrency.

Use at most two decimal digits to the right of the decimal point.

InvoiceNumber mandatory string

The invoice number.

SupplierId mandatory string

The supplier as specified in the Suppliers result set.

SupplierInvoiceName optional string

The name of the supplier invoice.

Default: If omitted, the receiving program will likely use the supplier's name.

Resultset: Fixed assets (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
FixedAssetId mandatory string

A value uniquely identifying this fixed asset within the group.

PrimaryAccount mandatory int

The primary account of the account group that this fixed asset belongs to.

Amount mandatory decimal

The original amount in the accounting currency.

Use at most two decimal digits to the right of the decimal point.

EntryDate mandatory datetime

Date of entry.

FixedAssetName mandatory string

The name of the fixed asset.

ForeignCurrency optional string

Three letter currency code (ISO 4217), e.g. 'SEK'.
Used together with ForeignCurrencyAmount.

ForeignCurrencyAmount optional decimal

The foreign currency amount in the currency specified by ForeignCurrency.

Use at most two decimal digits to the right of the decimal point.

Resultset: General objects (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
GeneralObjectId mandatory string

A value uniquely identifying this general object within the group.

PrimaryAccount mandatory int

The primary account of the account group that this general object belongs to.

Amount mandatory decimal

The original amount in the accounting currency.

Use at most two decimal digits to the right of the decimal point.

EntryDate mandatory datetime

Date of entry.

ForeignCurrency optional string

Three letter currency code (ISO 4217), e.g. 'SEK'.
Used together with ForeignCurrencyAmount.

ForeignCurrencyAmount optional decimal

The foreign currency amount in the currency specified by ForeignCurrency.

Use at most two decimal digits to the right of the decimal point.

GeneralObjectName mandatory string

The name of the general object.

Resultset: Balances

Should typically contain balances (for the balance accounts) for the primary fiscal year and the preceding year, and budget for the primary fiscal year (if available).

Table count: repeated exactly once
Row count: zero or more rows
Columns
Account mandatory int

The account number. If ObjectId is also specified, then Account should refer to a primary or secondary account of the object's group.

ObjectId optional string

CustomerInvoiceId, SupplierInvoiceId, FixedAssetId, or GeneralObjectId.

Default: If omitted, the balance is for the specified account only.
DimensionValueId optional string

The dimension value that the balance applies to.
Used together with DimensionId.

DimensionId optional int

The dimension that the dimension value belongs to.
Used together with DimensionValueId.

Amount mandatory decimal

The balance in the accounting currency.

Use at most two decimal digits to the right of the decimal point.

BalanceType mandatory string

The type of balance.

Possible value Description
Budget Budget
Closing Closing balance
Opening Opening balance
ForeignCurrency optional string

Three letter currency code (ISO 4217), e.g. 'SEK'.
Used together with ForeignCurrencyAmount.

ForeignCurrencyAmount optional decimal

The foreign currency amount in the currency specified by ForeignCurrency.

Use at most two decimal digits to the right of the decimal point.

Month mandatory int
  • For opening balances, this should be the start month of the fiscal year.
  • For closing balances, this should be the end month of the fiscal year.
  • For budgets, this can be omitted for the primary fiscal year, or be used to specify a specific month.

Used together with Year.

Quantity optional decimal

The quantity.

Year mandatory int
  • For opening balances, this should be the start year of the fiscal year.
  • For closing balances, this should be the end year of the fiscal year.
  • For budgets, this can be omitted for the primary fiscal year, or be used to specify a specific year.

Used together with Month.

Resultset: Journals

Table count: repeated exactly once
Row count: zero or more rows
Columns
JournalInternalId mandatory int

A surrogate key used by other result sets to refer to this journal.

JournalName mandatory string

The name of the journal.

Series mandatory string

The journal series.

Resultset: Journal entries

Table count: repeated exactly once
Row count: zero or more rows
Columns
JournalEntryInternalId mandatory int

A surrogate key used by other result sets to refer to this journal entry.

JournalInternalId mandatory int

The journal this journal entry belongs to.

EntryBy mandatory string

The name of the person or routine who registered the entry.

EntryDate mandatory date

The date when the entry was made.

JournalDate mandatory date

The journal date.

JournalEntryNumber mandatory int

The journal entry number.

LockedBy optional string

The name of the person or routine who locked the entry.

LockedDate optional date

The date when the entry was locked.

OriginalEntryBy optional string

The name of the person or routine who made the entry in a pre-processing system, if the entry originates from a pre-processing system.

OriginalEntryDate optional date

The date when the entry was made in a pre-processing system, if the entry originates from a pre-processing system.

ReferenceId optional string

Reference to an object in a pre-processing system.

Text optional string

Journal entry text.

Resultset: Journal entry corrections (optional)

Table count: repeated zero or one time
Row count: zero or more rows
Columns
JournalEntryInternalId mandatory int

The journal entry to correct.

CorrectedByJournalEntryInternalId mandatory int

The journal entry that corrects the other journal entry.

Resultset: Ledger entries

Table count: repeated exactly once
Row count: zero or more rows
Columns
LedgerEntryInternalId mandatory int

A surrogate key used by other result sets to refer to this ledger entry.

JournalEntryInternalId mandatory int

The journal entry this ledger entry belongs to.

Account mandatory int

The account number.

Amount mandatory decimal

The amount in the accounting currency.

Use at most two decimal digits to the right of the decimal point.

The ledger entries (excluding removed ledger entries) for each journal entry should sum to 0.

Dimension[1..N] optional string

Dimension values can be connected either by using columns named 'Dimension' suffixed by the dimension number (when the dimensions are known beforehand) or by the Ledger entry dimension values result set, but not both.

EntryBy optional string

The name of the person or routine who registered the entry.

EntryDate optional date

The date when the entry was made.

ForeignCurrency optional string

Three letter currency code (ISO 4217), e.g. 'SEK'.
Used together with ForeignCurrencyAmount.

ForeignCurrencyAmount optional decimal

The foreign currency amount in the currency specified by ForeignCurrency.

Use at most two decimal digits to the right of the decimal point.

LedgerDate optional date

The ledger date, if different from the journal date.

LockedBy optional string

The name of the person or routine who locked the entry.

LockedDate optional date

The date when the entry was locked.

ObjectId optional string

CustomerInvoiceId, SupplierInvoiceId, FixedAssetId, or GeneralObjectId.

Quantity optional decimal

The quantity.

RemovedBy optional string

The name of the person or routine who removed the entry.

RemovedDate optional date

The date when the entry was removed.

Text optional string

Ledger entry text.

Resultset: Ledger entry dimension values (optional)

Connects dimension values to ledger entries.

If the dimensions are fixed it might be simpler to use the DimensionNNN columns in the Ledger entries result set.

Table count: repeated zero or one time
Row count: zero or more rows
Columns
LedgerEntryInternalId mandatory int

The ledger entry that the dimension value is connected to.

DimensionValueId mandatory string

The dimension value.

DimensionId mandatory int

The dimension that the dimension value belongs to.