Component: SIE

 Show all Hide all

SIE (type 4) export component.

File mode: Download

The user downloads the file.
Supported modes: Download | Save | Save and download

SQL

SQL Call: Export (mandatory)

Supports custom errors: No
May modify database: No

Resultset: Account information

Result set providing the names of the accounts.
Repeat mode: repeated zero or one time
Row count: zero or more rows

Columns:

account mandatory int
Account number.
name mandatory string
The name of the account.

Resultset: Balance information.

Repeat mode: repeated zero or one time
Row count: zero or more rows

Columns:

account mandatory int
The account the balance information relates to.
inbalance mandatory decimal
In balance for the specified year and account.
inquantity optional decimal
In quantity for the specified year and account.
outbalance mandatory decimal
Out balance for the specified year and account.
outquantity optional decimal
Out quantity for the specified year and account.
resbalance mandatory decimal
Result balance for the specified year and account.
resquantity optional decimal
Result quantity for the specified year and account.
yearnumber mandatory int
The year that the balance information relates to.
Possible value Description
0 Current year.
-1 Previous year.

Resultset: Export data

The rows to export. Rows belonging to the same journal entry must be grouped together and have the same exportid. The journal entry information is taken from the first row of each journal entry.
Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

account mandatory int
The account.
amount mandatory decimal
The amount. Positive for debit, and negative for credit.
costcenter optional string
Cost center dimension value.
costunit optional string
Cost unit dimension value.
customer optional string
Customer dimension value.
date mandatory datetime
Transaction date. Journalentrydate is assumed if date is not specified.
dimension[1..N] optional string
Dimension M dimension value, where M is a number from 1 to N.
employee optional string
Employee dimension value.
exportid mandatory int
Number identifying the journal entry.
invoice optional string
Invoice dimension value.
journalentrydate mandatory datetime
The journal entry date.
journalentrynumber optional int
The number.
journalentryregistrationdate optional datetime
The journal entry registration date.
journalentryseries optional string
The series. Should either be a letter starting from 'A' or a number starting from 1.
journalentrytext optional string
Journal entry text.
project optional string
Project dimension value.
quantity optional decimal
The quantity.
supplier optional string
Supplier dimension value.
text optional string
Ledger entry text.

Resultset: Export information

Information about the exported data.
Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

companyname mandatory string
Name of the company to be exported.
costcenter optional string
The name of the cost center (kostnadsställe) dimension. Should be included if it is used by the export data.
costunit optional string
The name of the cost unit (kostnadsbärare) dimension. Cost unit is a subdimension of cost center. Should be included if it is used by the export data.
customer optional string
The name of the customer dimension. Should be included if it is used by the export data.
dimension[1..N] optional string
The name of dimension M where M is a number from 1 to N.
employee optional string
The name of the employee dimension. Should be included if it is used by the export data.
filename optional string
The name of the file to generate.
Defaults to "SIEYYYYMMDDHHMM.001".
invoice optional string
The name of the invoice dimension. Should be included if it is used by the export data.
organizationnumber optional string
Organization number of the company to be exported. There should be a hyphen after the sixth digit.
plan optional string
The account plan.
Possible value Description
BAS95
BAS96
EUBAS97
programname optional string
Meta information stored in the generated file. Should be the name of the program generating the file.
Defaults to the value of the "Application Name" language phrase.
project optional string
The name of the project dimension. Should be included if it is used by the export data.
supplier optional string
The name of the supplier dimension. Should be included if it is used by the export data.
username optional string
Name of the user who generated the file.

Resultset: Fiscal year information

Result set containg the fiscal years from which the exported data have been fetched.
Repeat mode: repeated zero or one time
Row count: zero or more rows

Columns:

enddate mandatory datetime
End date of the fiscal year.
startdate mandatory datetime
Start date of the fiscal year.
yearnumber mandatory int
0 for current year, -1 for previous year, and so on.

SQL Call: Store generated document (mandatory)

SQL to pass the document back to the database when disposition is file.
Supports custom errors: No
May modify database: Yes

Parameters:

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