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: Save and download

The file is saved in the database and the user downloads a copy.

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'.

Optional when IsEntry = 1.

CertificateThumbprint mandatory string

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

Optional when IsEntry = 1.

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.

Optional when IsEntry = 1.

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'.
IsEntry optional bit

Set to 1 to generate an entry file ("Bokföringsorder").

Multiple optional int

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

OmitDimensions optional bit

If set, omits the <Dimensions> element from the resulting file. Some receiving programs do not expect <Dimensions> to be present.

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.
ValidateXml optional bit

Set to 0 to omit XML schema validation of the generated file.

Resultset: Fiscal years

The fiscal years to include.

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

Starting with Softadmin® version 8.3, this result set should not be included when IsEntry = 1.

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.

Starting with Softadmin® version 8.3, this result set is optional when IsEntry = 1.

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 any

The name of the dimension.

Optional when IsEntry = 1.

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.

Optional when IsEntry = 1.

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.

Optional when IsEntry = 1.

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.

Optional when IsEntry = 1.

DueDate optional date

The due date of the invoice.

EntryDate mandatory date

Date of entry.

Optional when IsEntry = 1.

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.

Optional when IsEntry = 1.

EntryDate mandatory date

Date of entry.

Optional when IsEntry = 1.

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.

Optional when IsEntry = 1.

EntryDate mandatory date

Date of entry.

Optional when IsEntry = 1.

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.

Not allowed when IsEntry = 1.

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.

Not allowed when `IsEntry` = `1`.
Opening Opening balance.

Not allowed when `IsEntry` = `1`.
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.

Not allowed when IsEntry = 1.

Series mandatory string

The journal series.

Optional when IsEntry = 1.

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.

Not allowed when IsEntry = 1.

EntryDate mandatory date

The date when the entry was made.

Not allowed when IsEntry = 1.

JournalDate mandatory date

The journal date.

JournalEntryNumber mandatory int

The journal entry number.

Optional when IsEntry = 1.

LockedBy optional string

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

Not allowed when IsEntry = 1.

LockedDate optional date

The date when the entry was locked.

Not allowed when IsEntry = 1.

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.

Mandatory when IsEntry = 1.

OriginalEntryDate optional date

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

Mandatory when IsEntry = 1.

ReferenceId optional string

Reference to an object in a pre-processing system.

Text optional string

Journal entry text.

Resultset: Journal entry corrections (optional)

Starting with Softadmin® version 8.3, this result set should not be included when IsEntry = 1.

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.

Not allowed when IsEntry = 1.

EntryDate optional date

The date when the entry was made.

Not allowed when IsEntry = 1.

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.

Not allowed when IsEntry = 1.

LockedDate optional date

The date when the entry was locked.

Not allowed when IsEntry = 1.

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.

Not allowed when IsEntry = 1.

RemovedDate optional date

The date when the entry was removed.

Not allowed when IsEntry = 1.

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.

SQL Call: Store generated document (mandatory)

SQL to pass the document back to the database when disposition is file.

May modify database: Yes

Parameters

@SieFile binary
Contains the newly created document.
@SieFileContentType string
Content type of the newly created document.