Control Edge API

Using the Control Edge API, you can easily create integrations between Control Edge, IM and other accounting applications and BI systems. The Control Edge API allows integrators to create, read, and update various data from Control Edge and IM, including accounts, fixed assets, invoices, vouchers, and more.

Version 3.6

Using the Control Edge API, you can easily create integrations between Control Edge, IM and other accounting applications and BI systems. The Control Edge API allows integrators to create, read, and update various data from Control Edge and IM, including accounts, fixed assets, invoices, vouchers, and more.

Notifications

See separate documentation on Visma Community for how to activate notifications via the Developer Portal.

TypeComment
ArticlesNotifications when changes are done to the register in Control.
CustomerNotifications when changes are done to the register in Control.
SupplierNotifications when changes are done to the register in Control.
AccountNotifications when changes are done to the register in Control.

Authentication

  1. Signup for api access on https://oauth.developers.visma.com/. Details

(https://docs.connect.visma.com/v1/docs/developer-portal)

  1. Obtain an Api access token using the clientId and clientSecret generated at the

previous step. https://oauth.developers.visma.com/service-registry/documentation/authentication POST /connect/token HTTP/1.1 Host: connect.visma.com Content-Type: application/x-www-form-urlencoded Content-Length: 187 client_id=ApplicationId - created on developers.visma.com client_secret=yyyyyyyyyyyyyyyyyy grant_type=client_credentials tenant_id=xxxxxxxxxxxxx

  1. Find the desired endpoint. https://controlapi.control.visma.com/swagger/index.html
  2. Make the call to the endpoint passing the obtained access token. The token must be sent

in the HTTP header of every subsequent call and it has a validity of one hour. After one hour a new token must be requested. GET /api/account/get-accounts HTTP/1.1 Host: controlapi.control.visma.com StorageSpaceId: xxxxxxxxxxxxxxx Authorization: Bearer 9

Swaggerpage

Staging URL https://stage-controlapi.control.visma.com/swagger Production URL https://controlapi.control.visma.com/swagger 10

Control Edge endpoints

This section describes endpoints for Control Edge. 11

Account

Get method : /api/account/get-accounts

This method will return a list of the accounts

FieldDatatypeSizeComment
nameString30Accountname
accountNumberString6Accountnumber
accClassString1Accountclass
accTypeIntAccounttype. 1=Acquiring account, 2=Debt account, 3=Revenue account, 4=Expense account
standardByteAccount function
userGroup1String64From usergroups of type ACCOUNT1
userGroup2String64From usergroups of type ACCOUNT2
userGroup3String64From usergroups of type ACCOUNT3
userGroup4String64From usergroups of type ACCOUNT4
userGroup5String64From usergroups of type ACCOUNT5
userGroup6String64From usergroups of type ACCOUNT6
userGroup7String64From usergroups of type ACCOUNT7
userGroup8String64From usergroups of type ACCOUNT8
userGroup9String64From usergroups of type ACCOUNT9
userGroup10String64From usergroups of type ACCOUNT10
userGroup11String64From usergroups of type ACCOUNT11
userGroup12String64From usergroups of type ACCOUNT12
userGroup13String64From usergroups of type ACCOUNT13
userGroup14String64From usergroups of type ACCOUNT14
userGroup15String64From usergroups of type ACCOUNT15
userGroup16String64From usergroups of type ACCOUNT16
userGroup17String64From usergroups of type ACCOUNT17
userGroup18String64From usergroups of type ACCOUNT18
userGroup19String64From usergroups of type ACCOUNT19
userGroup20String64From usergroups of type ACCOUNT20
vatCodeByteVatcode that is used for account
accGroupString2Accountgroup
useCurrencyByte0=Never use currency, 1=Can use currency, 2=Must use currency
currencyString3Currency used for account
replaceAccString6Account that is used if account is disabled
signByte0=Can use both -/+, 1=debet, 2=kredit
createdDatetimeWhen the account was created
disabledDateDatetimeWhen the account was disabled
o1Int0=Never use object type 1, 1=Can use object type 1, 2=Must use object type 1
o2Int0=Never use object type 2, 1=Can use object type 2, 2=Must use object type 2
o3Int0=Never use object type 3, 1=Can use object type 3, 2=Must use object type 3
o4Int0=Never use object type 4, 1=Can use object type 4, 2=Must use object type 4
o5Int0=Never use object type 5, 1=Can use object type 5, 2=Must use object type 5
o6Int0=Never use object type 6, 1=Can use object type 6, 2=Must use object type 6
o7Int0=Never use object type 7, 1=Can use object type 7, 2=Must use object type 7
o8Int0=Never use object type 8, 1=Can use object type 8, 2=Must use object type 8
useO1String64Use this object of type 1
useO2String64Use this object of type 2
useO3String64Use this object of type 3
useO4String64Use this object of type 4
useO5String64Use this object of type 5
useO6String64Use this object of type 6
useO7String64Use this object of type 7
useO8String64Use this object of type 8
useNumByte0=Never use quantity, 1=Can use quantity, 2=Always use quantity
propIntBit field. 1)
uacintUser Access Code

1)

ValueComment
0If account is used for assets
1If account is used for supplierledgers
2If account is used for customerledgers
3If account is used for manual bookings
4If account is used for budget
5If account is used for currencyevaluation

Get method : /api/account/get-by-id

This method will return one account

InputfieldDatatypeSizeComment
accountnumberString6Account number
FieldDatatypeSizeComment
nameString30Accountname
accountNumberString6Accountnumber
accClassString1Accountclass
accTypeIntAccounttype. 1=Acquiring account, 2=Debt account, 3=Revenue account, 4=Expense account
standardByteAccount function
userGroup1String64From usergroups of type ACCOUNT1
userGroup2String64From usergroups of type ACCOUNT2
userGroup3String64From usergroups of type ACCOUNT3
userGroup4String64From usergroups of type ACCOUNT4
userGroup5String64From usergroups of type ACCOUNT5
userGroup6String64From usergroups of type ACCOUNT6
userGroup7String64From usergroups of type ACCOUNT7
userGroup8String64From usergroups of type ACCOUNT8
userGroup9String64From usergroups of type ACCOUNT9
userGroup10String64From usergroups of type ACCOUNT10
userGroup11String64From usergroups of type ACCOUNT11
userGroup12String64From usergroups of type ACCOUNT12
userGroup13String64From usergroups of type ACCOUNT13
userGroup14String64From usergroups of type ACCOUNT14
userGroup15String64From usergroups of type ACCOUNT15
userGroup16String64From usergroups of type ACCOUNT16
userGroup17String64From usergroups of type ACCOUNT17
userGroup18String64From usergroups of type ACCOUNT18
userGroup19String64From usergroups of type ACCOUNT19
userGroup20String64From usergroups of type ACCOUNT20
vatCodeByteVatcode that is used for account
accGroupString2Accountgroup
useCurrencyByte0=Never use currency, 1=Can use currency, 2=Must use currency
currencyString3Currency used for account
replaceAccString6Account that is used if account is disabled
signByte0=Can use both -/+, 1=debet, 2=kredit
createdDatetimeWhen the account was created
disabledDateDatetimeWhen the account was disabled
o1Int0=Never use object type 1, 1=Can use object type 1, 2=Must use object type 1
o2Int0=Never use object type 2, 1=Can use object type 2, 2=Must use object type 2
o3Int0=Never use object type 3, 1=Can use object type 3, 2=Must use object type 3
o4Int0=Never use object type 4, 1=Can use object type 4, 2=Must use object type 4
o5Int0=Never use object type 5, 1=Can use object type 5, 2=Must use object type 5
o6Int0=Never use object type 6, 1=Can use object type 6, 2=Must use object type 6
o7Int0=Never use object type 7, 1=Can use object type 7, 2=Must use object type 7
o8Int0=Never use object type 8, 1=Can use object type 8, 2=Must use object type 8
useO1String64Use this object of type 1
useO2String64Use this object of type 2
useO3String64Use this object of type 3
useO4String64Use this object of type 4
useO5String64Use this object of type 5
useO6String64Use this object of type 6
useO7String64Use this object of type 7
useO8String64Use this object of type 8
useNumByte0=Never use quantity, 1=Can use quantity, 2=Always use quantity
propIntBit field. 1)
uacintUser Access Code

1)

ValueComment
0If account is used for assets
1If account is used for supplierledgers
2If account is used for customerledgers
3If account is used for manual bookings
4If account is used for budget
5If account is used for currencyevaluation

Post method : /api/account/createorupdate

This method will create or update an account

InputfieldDatatypeSizeComment
nameString30Accountname
accountNumberString6Accountnumber
accClassString1Accountclass
accTypeIntAccounttype. 1=Acquiring account, 2=Debt account, 3=Revenue account, 4=Expense account
userGroup1String64From usergroups of type ACCOUNT1
userGroup2String64From usergroups of type ACCOUNT2
userGroup3String64From usergroups of type ACCOUNT3
userGroup4String64From usergroups of type ACCOUNT4
userGroup5String64From usergroups of type ACCOUNT5
userGroup6String64From usergroups of type ACCOUNT6
userGroup7String64From usergroups of type ACCOUNT7
userGroup8String64From usergroups of type ACCOUNT8
userGroup9String64From usergroups of type ACCOUNT9
userGroup10String64From usergroups of type ACCOUNT10
accGroupString2Accountgroup
currencyString3Currency used for account
replaceAccString6Account that is used if account is disabled
createdDatetimeWhen the account was created
disabledDateDatetimeWhen the account was disabled
o1Int0=Never use object type 1, 1=Can use object type 1, 2=Must use object type 1
o2Int0=Never use object type 2, 1=Can use object type 2, 2=Must use object type 2
o3Int0=Never use object type 3, 1=Can use object type 3, 2=Must use object type 3
o4Int0=Never use object type 4, 1=Can use object type 4, 2=Must use object type 4
o5Int0=Never use object type 5, 1=Can use object type 5, 2=Must use object type 5
o6Int0=Never use object type 6, 1= Can use object type 6, 2=Must use object type 6
o7Int0=Never use object type 7, 1=Can use object type 7, 2=Must use object type 7
o8Int0=Never use object type 8, 1=Can use object type 8, 2=Must use object type 8
useO1String64Use this object of type 1
useO2String64Use this object of type 2
useO3String64Use this object of type 3
useO4String64Use this object of type 4
useO5String64Use this object of type 5
useO6String64Use this object of type 6
useO7String64Use this object of type 7
useO8String64Use this object of type 8

Note

If fields are not filed, then the value will be overwritten with blank value

FieldDatatypeComment
BoolTrue / False

Get method : /api/account/vat/get-vats

This method will return all the vat codes

FieldDatatypeSizeComment
vatcodeByteVatcode. Id used in Visma Control
vatnameString255Description
vataccountString6Account. Must exist in account register
vattransferString6Clearing account. Must exist in account register
vatpercent1Numeric28,8Vat before vatswap
vatpercent2Numeric28,8Vat after vatswap
vatswapDatetimeDate when vat is changed
group1String64From usergroups of type VAT1
group2String64From usergroups of type VAT2
group3String64From usergroups of type VAT3
group4String64From usergroups of type VAT4
langtextString8Language id for translation. Refers to languagetext.id

Agreement

Post method : /api/agreement

This method will create an agreement

InputfieldDatatypeSizeComment
cidString8Business unit ID
custidString12Customer ID to whom the invoice on account applies. Refers to customer.custid
accountString6Account receivable. Refers to account.account
idString8ID of the invoice on account. Defined as a group of group type “INVSCR”
xtopString8Terms of payment. Refers to xtop.id
feeDecimal28,8Invoice fee
freightDecimal28,8Freight
extrafeeDecimal28,8Administration fee
advanceByte1)
intervalByteInvoicing period, months
differenceDecimal28,8Difference
fixedexchangeDecimal28,82)
subtypeByte3)
isforamountByte4)
periodicmonthsShortNumber of periods for periodic allocation of the invoice row
startmonthShortRelative start month for performing periodic allocations
indexnoIntSequential number. Incremented for each repetitive use of the same id-custid pair
payerString12Payer. Refers to customer.custid
payeeString12Payee. Refers to customer.custid
receiverString12Receiver. Refers to customer.custid
startdateDatetimeStart date of the invoice on account
blockedByte5)
cashdiscountString40Cash discount. Refers to cashdiscount.id
interestString40Interest procedure. Refers to relinterest.id
yourordernoString40Their order number
ourordernoString40Our order number
yourreferenceString40Their reference
yourreferencenumberString40Reference number
ourreferenceString40Our reference
enddateDatetimeEnd date of the invoice on account
LastdoneDatetimeMost recent invoicing date
firstinvdateDatetimeFirst date when the invoicing can be performed
donetoDatetimeUsed only internally. Specifies until which date the auto-invoicing has been
performed
currencyString3Currency for invoicing. Refers to currency.currency
xfreetextString255Free text for invoice header
nameString30Name of the invoice on account
address1String40Address line 1
address2String40Address line 2
address3String40Address line 3
address4String40Address line 4
address5String40Address line 5
address6String40Address line 6
address7String40Address line 7
address8String40Address line 8
modString8Method of delivery of group type “MOD”
todString8Terms of delivery of group type “TOD”
extraidString30Extra ID
bankcodeString8National bank code of group type “BANKCODE”
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of type “LEDGER1”
group2String64Free group of type “LEDGER2”
languageString8Language code of group type “LANGID”
tradecodeByteCommercial code
mopString8Mode of payment. Refers to mop.id
invoicingperiodstartDatetimeInvoicing period start
invoicingperiodendDatetimeInvoicing period end
vattypeInt6)
rows
accountString6Sale account
articleString20Provided article
typeByte7)
vatcodebyteVAT code
numberDecimal28,8Number
amountDecimal28,8Amount for each invoicing
firstamountDecimal28,8First amount
lastamountDecimal28,8Last amount
o1String64Object of object type 1
o2String64Object of object type 2
o3String64Object of object type 3
o4String64Object of object type 4
o5String64Object of object type 5
o6String64Object of object type 6
o7String64Object of object type 7
o8String64Object of object type 8
group1String64Free group of type “VOUROW1”
group2String64Free group of type “VOUROW2”
group3String64Free group of type “VOUROW3”
group4String64Free group of type “VOUROW4”
xfreetextString80Free text for row
unitString8Unit

1)

ValueComment
0invoicing is performed afterwards
1invoicing is performed in advance

2)

ValueComment
0if fixed exchange rate is not to be used for payment
1if fixed exchange rate is to be used for payment

3)

ValueComment
0for ordinary invoice
1for candidate for summary invoice

4)

ValueComment
0all amounts are in domestic currency
1all amounts are in foreign currency

5)

ValueComment
0not blocked
1blocked (no invoices will be created)

6)

ValueComment
0
1Standard
2Vat free
3Reverse charge

7)

ValueComment
0ordinary row
1total row, partial sum
2total row
3blank row
FieldDatatypeSizeComment
idString
successBool
errorsList of Strings
validationErrorsList of Strings
additionalProp1
additionalProp2
additionalProp3
dataString

Get method : /api/agreement/{id}/{indexno}/{custid}

This method will get an agreement with rows based on id, index number and customer id

InputfieldDatatypeSizeComment
idString8ID of the invoice on account. Defined as a group of group type “INVSCR”
indexnoInt6Account receivable. Refers to account.account
custidString12Customer ID to whom the invoice on account applies. Refers to customer.custid
FieldDatatypeSizeComment
cidString8Business unit ID
custidString12Customer ID to whom the invoice on account applies. Refers to customer.custid
accountString6Account receivable. Refers to account.account
idString8ID of the invoice on account. Defined as a group of group type “INVSCR”
indexnoIntSequential number. Incremented for each repetitive use of the same id-custid pair
xtopString8Terms of payment. Refers to xtop.id
feeDecimal28,8Invoice fee
freightDecimal28,8Freight
extrafeeDecimal28,8Administration fee
advanceByte1)
intervalByteInvoicing period, months
differenceDecimal28,8Difference
fixedexchangeDecimal28,82)
subtypeByte3)
isforamountByte4)
periodicmonthsShortNumber of periods for periodic allocation of the invoice row
startmonthShortRelative start month for performing periodic allocations
payerString12Payer. Refers to customer.custid
payeeString12Payee. Refers to customer.custid
receiverString12Receiver. Refers to customer.custid
startdateDatetimeStart date of the invoice on account
blockedByte5)
cashdiscountString40Cash discount. Refers to cashdiscount.id
interestString40Interest procedure. Refers to relinterest.id
yourordernoString40Their order number
ourordernoString40Our order number
yourreferenceString40Their reference
yourreferencenumberString40Reference number
ourreferenceString40Our reference
enddateDatetimeEnd date of the invoice on account
lastdoneDatetimeMost recent invoicing date
firstinvdateDatetimeFirst date when the invoicing can be performed
donetoDatetimeUsed only internally. Specifies until which date the auto-invoicing has been
performed
currencyString3Currency for invoicing. Refers to currency.currency
xfreetextString255Free text for invoice header
nameString30Name of the invoice on account
address1String40Address line 1
address2String40Address line 2
address3String40Address line 3
address4String40Address line 4
address5String40Address line 5
address6String40Address line 6
address7String40Address line 7
address8String40Address line 8
modString8Method of delivery of group type “MOD”
todString8Terms of delivery of group type “TOD”
extraidString30Extra ID
bankcodeString8National bank code of group type “BANKCODE”
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of type “LEDGER1”
group2String64Free group of type “LEDGER2”
languageString8Language code of group type “LANGID”
tradecodeByteCommercial code
mopString8Mode of payment. Refers to mop.id
invoicingperiodstartDatetimeInvoicing period start
invoicingperiodendDatetimeInvoicing period end
vattypeInt6)
rows
cidString8Business unit ID
idString8ID of the invoice on account. Defined as a group of group type “INVSCR”
indexnoIntSequential number. Incremented for each repetitive use of the same id-custid pair
custidString12Customer ID to whom the invoice on account applies. Refers to customer.custid
rowIntRow number. First row has number 0
articleString20Provided article
accountString6Sale account
vatcodeByteVAT code
numberDecimal28,8Number
amountDecimal28,8Amount for each invoicing
firstamountDecimal28,8First amount
lastamountDecimal28,8Last amount
o1String64Object of object type 1
o2String64Object of object type 2
o3String64Object of object type 3
o4String64Object of object type 4
o5String64Object of object type 5
o6String64Object of object type 6
o7String64Object of object type 7
o8String64Object of object type 8
group1String64Free group of type “VOUROW1”
group2String64Free group of type “VOUROW2”
group3String64Free group of type “VOUROW3”
group4String64Free group of type “VOUROW4”
xfreetextString80Free text for row
unitString8Unit
type7)

1)

ValueComment
0invoicing is performed afterwards
1invoicing is performed in advance

2)

ValueComment
0if fixed exchange rate is not to be used for payment
1if fixed exchange rate is to be used for payment

3)

ValueComment
0for ordinary invoice
1for candidate for summary invoice

4)

ValueComment
0all amounts are in domestic currency
1all amounts are in foreign currency

5)

ValueComment
0not blocked
1blocked (no invoices will be created)

6)

ValueComment
0
1Standard
2Vat free
3Reverse charge

7)

ValueComment
0ordinary row
1total row, partial sum
2total row
3blank row

Article

Get method : /api/article/get-articles

This method will return all the articles

FieldDatatypeSizeComment
idString20Id of article
NameString80Name
ArtgroupString20Articlegroup
CalcpriceNumeric28,8Calculatedprice
UnitString8Unit
account1String6Account
account2String6Account
account3String6Account
account4String6Account
account5String6Account
account6String6Account
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
supplierString30Supplierid
supplierartnoString30Supplier articleno
group1String64From usergroups of type vourow1
group2String64From usergroups of type vourow2
group3String64From usergroups of type vourow4
group4String64From usergroups of type vourow5
discountrowIntDiscount
art1String8From usergroups of type art1
art2String8From usergroups of type art2
art3String8From usergroups of type art3
art4String8From usergroups of type art4
disabledByte0 = not disable, 1 = disable
uacIntUser Access Code

Get method : /api/article/get-article-by-id

This method will return one article

InputfieldDatatypeSizeComment
articleidString20Id of article
FieldDatatypeSizeComment
idString20Id of article
NameString80Name
ArtgroupString20Articlegroup
CalcpriceNumeric28,8Calculatedprice
UnitString8Unit
account1String6Account
account2String6Account
account3String6Account
account4String6Account
account5String6Account
account6String6Account
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
supplierString30Supplierid
supplierartnoString30Supplier articleno
group1String64From usergroups of type vourow1
group2String64From usergroups of type vourow2
group3String64From usergroups of type vourow4
group4String64From usergroups of type vourow5
discountrowIntDiscount
art1String8From usergroups of type art1
art2String8From usergroups of type art2
art3String8From usergroups of type art3
art4String8From usergroups of type art4
disabledByte0 = not disable, 1 = disable
uacIntUser Access Code

Get method : /api/article/prices/{articleid}

This method will return article price list

InputfieldDatatypeSizeComment
articleidString20Article Id
FieldDatatypeSizeComment
idString20Article Id
currencyString3Currency
Price1Numeric28,8Price including tax for category 1
Price2Numeric28,8Price including tax for category 2
Price3Numeric28,8Price including tax for category 3
Price4Numeric28,8Price including tax for category 4
Price5Numeric28,8Price including tax for category 5
Price6Numeric28,8Price including tax for category 6
Price7Numeric28,8Price including tax for category 7
Price8Numeric28,8Price including tax for category 8
swapDateDateTimeDate when price list price1 – price8 switches to price list swap1 – swap8
swap1Numeric28,8Price including tax for category 1, after swap date
swap2Numeric28,8Price including tax for category 2, after swap date
swap3Numeric28,8Price including tax for category 3, after swap date
swap4Numeric28,8Price including tax for category 4, after swap date
swap5Numeric28,8Price including tax for category 5, after swap date
swap6Numeric28,8Price including tax for category 6, after swap date
swap7Numeric28,8Price including tax for category 7, after swap date
swap8Numeric28,8Price including tax for category 8, after swap date

Get method : /api/article/price

This method will return article price list

InputfieldDatatypeSizeComment
articleidString20Article Id
customeridString12Customer Id
FieldDatatypeSizeComment
idString20Article Id
currencyString3Currency
priceNumeric28,8Article price
swapPriceNumeric28,8Swap price depending on customer setting
swapDateDateTimeSwap date

Post method : /api/article/price

This method will create or updates one article pris identified by article price id and currency

InputfieldDatatypeSizeComment
idString20Article Id
currencyString3Currency. If currency is domestic then set currency = [*]
Price1Numeric28,8Price including tax for category 1
Price2Numeric28,8Price including tax for category 2
Price3Numeric28,8Price including tax for category 3
Price4Numeric28,8Price including tax for category 4
Price5Numeric28,8Price including tax for category 5
Price6Numeric28,8Price including tax for category 6
Price7Numeric28,8Price including tax for category 7
Price8Numeric28,8Price including tax for category 8
swapDateDateTimeDate when price list price1 – price8 switches to price list swap1 – swap8
swap1Numeric28,8Price including tax for category 1, after swap date
swap2Numeric28,8Price including tax for category 2, after swap date
swap3Numeric28,8Price including tax for category 3, after swap date
swap4Numeric28,8Price including tax for category 4, after swap date
swap5Numeric28,8Price including tax for category 5, after swap date
swap6Numeric28,8Price including tax for category 6, after swap date
swap7Numeric28,8Price including tax for category 7, after swap date
swap8Numeric28,8Price including tax for category 8, after swap date
FieldDatatypeSizeComment
BoolTrue/False

Get method : /api/article/all

This method will return all article prices

InputfieldDatatypeSizeComment
pageIntPage to fetch. First page = 0
FieldDatatypeSizeComment
idString20Article Id
currencyString3Currency
Price1Numeric28,8Price including tax for category 1
Price2Numeric28,8Price including tax for category 2
Price3Numeric28,8Price including tax for category 3
Price4Numeric28,8Price including tax for category 4
Price5Numeric28,8Price including tax for category 5
Price6Numeric28,8Price including tax for category 6
Price7Numeric28,8Price including tax for category 7
Price8Numeric28,8Price including tax for category 8
swapDateDateTimeDate when price list price1 – price8 switches to price list swap1 – swap8
swap1Numeric28,8Price including tax for category 1, after swap date
swap2Numeric28,8Price including tax for category 2, after swap date
swap3Numeric28,8Price including tax for category 3, after swap date
swap4Numeric28,8Price including tax for category 4, after swap date
swap5Numeric28,8Price including tax for category 5, after swap date
swap6Numeric28,8Price including tax for category 6, after swap date
swap7Numeric28,8Price including tax for category 7, after swap date
swap8Numeric28,8Price including tax for category 8, after swap date

Post method : /api/article/create-or-update-article

This method will create or update an article

InputfieldDatatypeSizeComment
idString20Id of article
NameString80Name
ArtgroupString20Articlegroup
CalcpriceNumeric28,8Calculatedprice
UnitString8Unit
account1String6Account
account2String6Account
account3String6Account
account4String6Account
account5String6Account
account6String6Account
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
supplierString30Supplierid
supplierartnoString30Supplier articleno
group1String64From usergroups of type vourow1
group2String64From usergroups of type vourow2
group3String64From usergroups of type vourow4
group4String64From usergroups of type vourow5
discountrowIntDiscount
art1String8From usergroups of type art1
art2String8From usergroups of type art2
art3String8From usergroups of type art3
art4String8From usergroups of type art4
disabledByte0 = not disable, 1 = disable
uacIntUser Access Code

Attachment

Get method : /api/attachment/download-attachment

This method will return the binarydata of the file

InputfieldDatatypeComment
idStringAttachment internal id
fileNameStringFilename
FieldDatatypeComment
ContentByte[]File content
ContentTypeStringFiletype

Post method : /api/attachment/invoice/{invserie}/{invnumber}

This method uploads an invoice attachment

InputfieldDatatypeComment
invserieStringInvoice serie
invnumberIntInvoice number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Post method : /api/attachment/invoice-log/{invserie}/{invnumber}

This method uploads an invoice log attachment

InputfieldDatatypeSizeComment
invserieString8Invoice log serie
invnumberIntInvoice log number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/invoice-log/{invserie}/{invnumber}

This method returns the attachment file name and attachment Id of an invoice log

InputfieldDatatypeSizeComment
invserieString8Invoice log serie
invnumberIntInvoice log number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/sales-ledger/{enumerator}/{invno}

This method uploads a sales ledger attachment

InputfieldDatatypeSizeComment
enumeratorString8Ledger serie
invnoIntLedger number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/sales-ledger/{enumerator}/{invno}

This method returns the attachment file name and attachment Id of a sales ledger

InputfieldDatatypeSizeComment
enumeratorString8Ledger serie
invnoIntLedger number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/sales-ledger-log/{enumerator}/{invno}

This method uploads a sales ledger log attachment

InputfieldDatatypeSizeComment
enumeratorString8Ledger serie
invnoIntLedger number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/sales-ledger-log/{enumerator}/{invno}

This method returns the attachment file name and attachment Id of a sales ledger log

InputfieldDatatypeSizeComment
enumeratorString8Ledger log serie
invnoIntLedger log number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/supplier-ledger/{enumerator}/{invno}

This method uploads a sales ledger attachment

InputfieldDatatypeSizeComment
enumeratorString8Ledger serie
invnoIntLedger number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/supplier-ledger/{enumerator}/{invno}

This method returns the attachment file name and attachment Id of a supplier ledger

InputfieldDatatypeSizeComment
enumeratorString8Ledger log serie
invnoIntLedger log number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/supplier-ledger-log/{enumerator}/{invno}

This method uploads a sales ledger log attachment

InputfieldDatatypeSizeComment
enumeratorString8Ledger log serie
invnoIntLedger log number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/supplier-ledger-log/{enumerator}/{invno}

This method returns the attachment file name and attachment Id of a sales ledger log

InputfieldDatatypeSizeComment
enumeratorString8Ledger log serie
invnoIntLedger log number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/voucher/{vouno}/{serie}/{year}

This method uploads a voucher attachment

InputfieldDatatypeSizeComment
vounoIntVoucher number
serieString8Voucher serie
yearIntVoucher year
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Post method : /api/attachment/voucher-log/{logno}

This method uploads a voucher log attachment

InputfieldDatatypeComment
lognoIntVoucher log number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/voucher-log/{logno}

This method returns a list with attachment filenames and attachment Ids for voucher logs

InputfieldDatatypeComment
lognoIntVoucher log number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/asset/{assetno}

This method uploads an asset attachment

InputfieldDatatypeComment
assetnoIntAsset number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/asset/{assetno}

This method returns the attachment file name and attachment Id of an asset

InputfieldDatatypeComment
assetnoIntAsset number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/voucher-row/{vouno}/{serie}/{year}/{rowno}

This method uploads a voucher row attachment

InputfieldDatatypeComment
vounoIntVoucher number
serieStringVoucher serie
yearIntVoucher year
rownoIntVoucher row number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Post method : /api/attachment/voucher-row-log/{logno}/{logrow}

This method uploads a voucher row attachment

InputfieldDatatypeComment
lognoIntVoucher row log number
logrowIntVoucher row log row number
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message succesfull

Get method : /api/attachment/voucher-row-log/{logno}/{logrow}

This method returns a list with attachment file names and attachment Ids for voucher row logs

InputfieldDatatypeComment
lognoIntVoucher row log number
logrowIntVoucher row log row number
FieldDatatypeComment
filenameStringName of file
idStringId of file

Get method : /api/attachment/get-voucher-attachments

This method returns a list with attachment file names and attachment Ids of a voucher

InputfieldDatatypeSizeComment
vounoIntVoucher number
serieString8Voucher serie
yearnoIntVoucher year
FieldDatatypeComment
filenameStringName of file
idStringId of file

Get method : /api/attachment/get-voucher-row-attachments

This method returns a list with attachment file names and attachment Ids for voucher rows

InputfieldDatatypeSizeComment
vounoIntVoucher number
serieString8Voucher serie
yearnoIntVoucher year
rownoIntVoucher row number(0,1,2…)
FieldDatatypeComment
filenameStringName of file
idStringId of file

Get method : /api/attachment/get-invoice-attachment

This method returns the attachment file name and attachment Id of an invoice

InputfieldDatatypeSizeComment
invnumberIntInvoice number
invserieString8Invoice serie
FieldDatatypeComment
filenameStringName of file
idStringId of file

Post method : /api/attachment/agreement/{agreementid}/{custid}/{indexno}

This method uploads a agreement attachment

InputfieldDatatypeComment
agreementidStringID of the invoice on account. Defined as a group of group type “INVSCR”
custidStringCustomer ID to whom the invoice on account applies. Refers to customer.custid
indexnoIntSequential number. Incremented for each repetitive use of the same id-custid pair
fileByte[]Filecontent
FieldDatatypeComment
MessageStringIf succesfull then a message successful

Get method : /api/attachment/agreement/{agreementid}/{custid}/{indexno}

This method returns the attachment file name and attachment Id of an agreement

InputfieldDatatypeSizeComment
agreementidString8ID of the invoice on account. Defined as a group of group type “INVSCR”
custidString12Customer ID to whom the invoice on account applies. Refers to customer.custid
indexnoIntSequential number. Incremented for each repetitive use of the same id-custid pair
FieldDatatypeComment
filenameStringName of file
idStringId of file

Budget

Post method: /api/budget/create-budget

This method creates a new budget entry

InputfieldDatatypeSizeComment
businessUnitString8Business unit ID
YearShortYear
periodBytePeriod
budgetTypeShort1)
amountNumeric28,8Amount
foreignAmountNumeric28,8Foreign amount
numberNumeric28,8Number
accountString6Account
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
distributionKeyString8Distribution key that is used for the budget. Value is set to NULL for balance container

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget

Get method: /api/budget

This method retrieves budget details based on business unit, budget type, year, start period and end

period

FieldDatatypeSizeComment
businessUnitString8Business unit ID
typeInt1)
yearIntYear
periodFromIntStart period
periodToIntEnd period
showPreviusYearOutcomeBoolTrue/False

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget
FieldDatatypeSizeComment
YearShortYear
periodBytePeriod
accountString6Account
currencyString3Currency
foreignAmountNumeric28,8Foreign amount
numberNumeric28,8Number
amountNumeric28,8Amount
baseCurrencyNumeric28,8Alternative currency
baseAmountNumeric28,8Amount in alternative currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
serieString8Voucher serie. Specified only for simulation vouchers, otherwise the value is set to NULL
distibutionKeyStringDistribution key that is used for the budget. Value is set to NULL for
balance container
recalculationFactorNumeric28,8Factor for budget amount. From xsys
previousYearAmountNumeric28,8Amount
previousYearForAmountNumeric28,8Amount
previousYearNumberNumeric28,8Year

Get method: /api/budget/year

This method retrieves budget items per year

FieldDatatypeSizeComment
List:
businessUnitString8Business unit ID
yearIntYear
amountNumeric28,8Amount
budgetTypeIdString8Budget Id
budgetTypeNameString30Name

Budgettype

Get method: /api/budgettype/get-budgettype-by-physical-number

This method gets the budgettype based on the physical number

InputfieldDatatypeSizeComment
numberIntBudgettype number
FieldDatatypeComment
budgettypeIDStringBudget number
budgettypeNameStringBudget type name
distributionKeyStringDefault distribution key
yearIDIntYear for which the budget is used

BusinessUnit

Get method : /api/businessunit/get-businessunits

This method will return a list of Companies

FieldDatatypeSizeComment
noString8Companyid
nameString30Name of company
address1String40Address field 1
address2String40Address field 2
address3String40Address field 3
address4String40Address field 4
phone1String30Phone field 1
phone2String30Phone field 2
phone3String30Phone field 3
numberString30Company regnumber
vatnoString30Vatregistrationnumber
companytypeString20Type of business
missiontypeString20Task type
branchtypeString20Branch of industry
firstregDatetimeFirst action
lastregDatetimeLatest action
endperiodString8Period when the accounting year ends
vatperiodsByteNumber of periods in each VAT reporting block
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Group of type CLIENT1
group2String64Group of type CLIENT2
group3String64Group of type CLIENT3
group4String64Group of type CLIENT4
group5String64Group of type CLIENT5
group6String64Group of type CLIENT6
group7String64Group of type CLIENT7
group8String64Group of type CLIENT8
group9String64Group of type CLIENT9
group10String64Group of type CLIENT10
group11String64Group of type CLIENT11
group12String64Group of type CLIENT12
group13String64Group of type CLIENT13
group14String64Group of type CLIENT14
group15String64Group of type CLIENT15
group16String64Group of type CLIENT16
group17String64Group of type CLIENT17
group18String64Group of type CLIENT18
group19String64Group of type CLIENT19
group20String64Group of type CLIENT20
disabledDatetimeWhen company is disabled from
basecurrencyString3Alternative currency
countrycodeString8Country code

Get method : /api/bank/businessunit/{businessUnitId}

This method will return a list of banks based on businessUnitId

InputfieldDatatypeSizeComment
businessUnitIdString8Companyid
FieldDatatypeSizeComment
idString8Bank ID.
typeInt1)
mopString8Associated mode of payment. Refers to mop.id.
ownerString12Bank owner ID.
bankTypeString8Bank type of group “BANKTYPE”.
numberString40Account number.
swiftString30Swift address.
clearingString30Clearing number.
bankNameString30Bank name.
freeTextString255Free text.
address1String40First address.
address1String40Second address.
address1String40Third address.
address1String40Fourth address.
group1String64Group of group type “BANK1”.
Group2String64Group of group type “BANK2”.
Group3String64Group of group type “BANK3”.
Group4String64Group of group type “BANK4”.
defBankByte12)
paymentaccountString6Payment account. Refers to account.account. This paymentaccount is used for paymenet with Autopay i.e mode of payment VOP
currencyString8Currency

1)

ValueComment
1Customer (not used)
-1Supplier
0Company

2)

ValueComment
1bank is not a default bank
0bank is a default bank

Cashflow

Get method : /api/cashflow/{id}

This method will retrieve cashflow details based on the provided cashflow ID

InputfieldDatatypeSizeComment
idIntCashflow item id
FieldDatatypeSizeComment
businessUnitString8Business Unit Id
dateDatetimeDuedate
typeByteType of cashflow item
currencyString3Currency
amountNumeric28,8Amount
foramountNumeric28,8Foregin amount
nameString80Name
idIntCashflow item id

Patch method : /api/cashflow/{id}

This method updates a cashflow item

InputfieldDatatypeSizeComment
idIntCashflow item id

Post method : /api/cashflow/no-recurrence This method creates a cashflow item with no recurrence. Post method : /api/cashflow/weekly-recurrence This method creates a cashflow item with weekly recurrence. 45

Post method : /api/cashflow/monthly-recurrence-by-day This method creates/updates a monthly cashflow for the X-th day of every Y month. Post method : /api/cashflow/monthly-recurrence This method creates/updates a monthly cashflow item for the N-th occurrence of [Weekday] in every Y month. 46

Container

Get method : /api/container/get-byyear

This method returns a list of containers for a year with start and end periods

InputfieldDatatypeComment
yearIntYear number
startPeriodIntStart period number
endPeriodIntEnd period number
pageInt0 is first page
FieldDatatypeSizeComment
idIntDummy used for indexing
baseamountDecimal28,8Alternativ amount
periodBytePeriod (1 – 12)
typeShort1)
accountString6Account. Must exist in accountx
cidString8Company
yearShortYear. Same as yearno in periodx
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
basecurrencyString3Alternative currency
modelString8Distribution key used for budget
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
serieString8Voucherserie
flagByte2)
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget
5Range is used for varius budget types

2)

ValueComment
0Budget doesn’t update the year balance
1Budget updates the year balance

Get method : /api/container/get-byyeartype

This method returns a list of containers based on the year number and type

InputfieldDatatypeComment
yearIntYear number
typeInt1)
pageInt0 is first page
FieldDatatypeSizeComment
idIntDummy used for indexing
baseamountDecimal28,8Alternativ amount
periodBytePeriod (1 – 12)
typeShort1)
accountString6Account. Must exist in accountx
cidString8Company
yearShortYear. Same as yearno in periodx
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
basecurrencyString3Alternative currency
modelString8Distribution key used for budget
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
serieString8Voucherserie
flagByte2)
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget
5Range is used for varius budget types

2)

ValueComment
0Budget doesn’t update the year balance
1Budget updates the year balance

Get method : /api/container/get-byyeartypeperiod

This method returns a list of containers based on the year number, type, start period and end period

InputfieldDatatypeComment
yearIntYear number
typeInt1)
startPeriodIntStart period number
endPeriodIntEnd period number
pageInt0 is first page
FieldDatatypeSizeComment
idIntDummy used for indexing
baseamountDecimal28,8Alternativ amount
periodBytePeriod (1 – 12)
typeShort1)
accountString6Account. Must exist in accountx
cidString8Company
yearShortYear. Same as yearno in periodx
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
basecurrencyString3Alternative currency
modelString8Distribution key used for budget
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
serieString8Voucherserie
flagByte2)
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget
5Range is used for varius budget types

2)

ValueComment
0Budget doesn’t update the year balance
1Budget updates the year balance

Get method : /api/container/get-container-by-budgettype

This method returns a list of containers based on the type

InputfieldDatatypeComment
typeInt1)
pageInt0 is first page
FieldDatatypeSizeComment
idIntDummy used for indexing
baseamountDecimal28,8Alternativ amount
periodBytePeriod (1 – 12)
typeShort1)
accountString6Account. Must exist in accountx
cidString8Company
yearShortYear. Same as yearno in periodx
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
basecurrencyString3Alternative currency
modelString8Distribution key used for budget
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
serieString8Voucherserie
flagByte2)
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget
5Range is used for varius budget types

2)

ValueComment
0Budget doesn’t update the year balance
1Budget updates the year balance

Post method : /api/container/filter

This method returns a list of containers based on filter

Filter

InputDatatypeComment
filters:
fieldNameString1)
operatorEnum2)
valueString
secondValueString
pageIntPage to fetch. First page = 0

1) Field Period Type Account Cid Amount Foramount Model Currency O1 O2 O3 O4 O5 O6 O7 O8 Serie 2)

OperatorComment
EqualExact match
IncludeIn operation with comma-seperated values
BetweenRange between two values (requires secondvalue)
GreaterThanGreater than comparison
LessThanLess than comparison
FieldDatatypeSizeComment
list:
idIntDummy used for indexing
baseamountDecimal28,8Alternativ amount
periodBytePeriod (1 – 12)
typeShort1)
accountString6Account. Must exist in accountx
cidString8Company
yearShortYear. Same as yearno in periodx
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
basecurrencyString3Alternative currency
modelString8Distribution key used for budget
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
serieString8Voucherserie
flagByte2)
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch
totalNumberOfRecordsString

1)

ValueComment
0Previus year result
1Opening balance
9Period balance
10Simulation vouchers
100 - 30000If account is used for budget
5Range is used for varius budget types

2)

ValueComment
0Budget doesn’t update the year balance
1Budget updates the year balance

Currency

Get method : /api/currency/get-currencies

This method returns a list of all currencies

FieldDatatypeSizeComment
currencyIdString3Id
descriptionString30Description
recalc1Decimal28,8Purchase price, first recalculation
recalc2Decimal28,8Purchase price, second recalculation
recalc3Decimal28,8Sales price, first recalculation
recalc4Decimal28,8Sales price, second recalculation
changedDatetimeDate of last modification
recalcAccountString6Account. Must exist in accountx
linkedString3Currency linked to the current one

Get method : /api/currency/get-currencies-with-rates

This method returns a list of all currencies with exchangerates

FieldDatatypeSizeComment
currencyIdString3Id
descriptionString30Description
recalc1Decimal28,8Purchase price, first recalculation
recalc2Decimal28,8Purchase price, second recalculation
recalc3Decimal28,8Sales price, first recalculation
recalc4Decimal28,8Sales price, second recalculation
ChangedDatetimeDate of last modification
recalcAccountString6Account. Must exist in account
LinkedString3Currency linked to the current one
sellExchangeDecimal28,8Sale price
buyExchangeDecimal28,8Purchase price
validFromDatetimeExchange rate start date

Post method : /api/currency-rate

This method adds an exchange rate for currency

InputfieldDatatypeSizeComment
currencyString3Currency
validfromDatetimeValid from date
buyexchangeDecimal28,8Purchase price
sellexchangeDecimal28,8Sale price
FieldDatatypeSizeComment
entityIdStringCurrency Id
entityTypeStringType of entity

FixedAsset

Get method : /api/asset/get-assets

This method will return a list of fixed assets

FieldDatatypeComment
noapartmentsInt
assetcategoryByteAssetcategory
assetstatusByte1)
cidString8Company
ownerassetnoIntOwner assetno, or -1 if there is no owner
assetnoIntAssetid
buyamountDecimal28,8Purchase amount
extraamount1Decimal28,8Extra amount
extraamount2Decimal28,8Extra amount
sellvounoIntVouchernumber if asset sold
insuranceamountDecimal28,8Insurance amount
replacementvalueDecimal28,8Replacement value
estsellamountDecimal28,8Estimated sell amount
taxvalueyearShortYear of valuation
taxvaluedwellingDecimal28,8Tax value for buildings
taxvaluepremesisDecimal28,8Tax value for premises
taxvaluehouseDecimal28,8Tax value
taxvaluehouselandDecimal28,8Tax value
taxvalueapartmentlandDecimal28,8Tax value
taxvaluefacilityDecimal28,8Tax value
uacIntTax value for facility
buyforamountDecimal28,8Purchase forign amount
sellamountDecimal28,8Sell amount
sellvoutypeString8Voucherserie for sell voucher
selldateDatetimeDate for asset sale/discarding
o1debitString64Debet object 1 for internal interest
o2debitString64Debet object 2 for internal interest
o3debitString64Debet object 3 for internal interest
o4debitString64Debet object 4 for internal interest
o5debitString64Debet object 5 for internal interest
o6debitString64Debet object 6 for internal interest
o7debitString64Debet object 7 for internal interest
o8debitString64Debet object 8 for internal interest
o1creditString64Credit object 1 for internal interest
o2creditString64Credit object 2 for internal interest
o3creditString64Credit object 3 for internal interest
o4creditString64Credit object 4 for internal interest
o5creditString64Credit object 5 for internal interest
o6creditString64Credit object 6 for internal interest
o7creditString64Credit object 7 for internal interest
o8creditString64Credit object 8 for internal interest
intdebitaccString6Debet account for internal interest
intcreditaccString6Credit account for internal interest
intidString8Interest procedure for internal interest
propownString8Type of ownership for real estate. Group of type ASSOWNER
propcodeString8Type for real estate. Group of type ASSBUILD
intintstartdateDatetimeStartdate for internal rate calculation
intintlatestuseDatetimeMost recent date of internal interest rate booking
changedDatetimeDate of latest change of asset
statuschangedDatetimeDate of lastest change of status
suppidString12Supplier id. Must exist in person table
supplierString80Name of supplier
labelString30Marking
responsibleString8Administrator
location1String30Location (eg room). Group of type ASSLOC1
location2String30Location (eg buildning). Group of type ASSLOC2
group1String64Group of type ASSET1
group2String64Group of type ASSET3
group3String64Group of type ASSET3
group4String64Group of type ASSET4
freetext1String30Free text 1
freetext2String30Free text 2
freetext3String30Free text 3
freetext4String30Free text 4
o1String64Object 1 for assets
o2String64Object 2 for assets
o3String64Object 3 for assets
o4String64Object 4 for assets
o5String64Object 5 for assets
o6String64Object 61 for assets
o7String64Object 7 for assets
o8String64Object 8 for assets
buycurrencyString3Purchase currency
assettypeString8Assettype. Refers to assettype.assettype
nameString30Name of asset
descriptionString30Description of asset
buydateDatetimePurchase date

1)

ValueComment
1Preliminary
10Owned, for use
11Owned, not for use
12Owned, non-accountable
50Not owned, borrowed/insured
51Not owned, leased/insured
90Owned, fully depricated
91Sold
92Missing
93Stolen
94Returned back
99Counter-booked

Get method : /api/asset/get-history

This method returns a list of history for an asset

InputfieldDatatypeComment
assetidIntAsset id
FieldDatatypeSizeComment
idIntIdentity column
assetnoIntId of asset
actiondateDatetimeDate of log entry
actiontypeByte1)
vounoIntVouchernumber
amountDecimal28,8Amount
bookdateDatetimeAccountingdate
infoString80Event information
voutypeString8Voucherserie

1)

ValueComment
1Asset creation/purchase
2Depreciation
3Edit of depreciation
4Property tax booking
5Edit of property tax
6Write up/down
7Sale of fixed asset
8Discard of fixed asset
9Internal interest booking
10Edit of internal interest
11Split of fixed asset
12Merge of fixed asset
13Registration of previous depreciations

Get method : /api/asset/get-all-history-by-year

This method returns a list of history for assets based on year

InputfieldDatatypeComment
yearIntYear number
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
idIntIdentity column
assetnoIntId of asset
actiondateDatetimeDate of log entry
actiontypeByte1)
vounoIntVouchernumber
amountDecimal28,8Amount
bookdateDatetimeAccountingdate
infoString80Event information
voutypeString8Voucherserie
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
1Asset creation/purchase
2Depreciation
3Edit of depreciation
4Property tax booking
5Edit of property tax
6Write up/down
7Sale of fixed asset
8Discard of fixed asset
9Internal interest booking
10Edit of internal interest
11Split of fixed asset
12Merge of fixed asset
13Registration of previous depreciations

Get method : /api/asset/get-all-history

This method returns a list of history for assets

InputfieldDatatypeComment
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
idIntIdentity column
assetnoIntId of asset
actiondateDatetimeDate of log entry
actiontypeByte1)
vounoIntVouchernumber
amountDecimal28,8Amount
bookdateDatetimeAccountingdate
infoString80Event information
voutypeString8Voucherserie
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
1Asset creation/purchase
2Depreciation
3Edit of depreciation
4Property tax booking
5Edit of property tax
6Write up/down
7Sale of fixed asset
8Discard of fixed asset
9Internal interest booking
10Edit of internal interest
11Split of fixed asset
12Merge of fixed asset
13Registration of previous depreciations

Get method : /api/asset/get-history-by-changedate

This method returns a list of history for assets

InputfieldDatatypeComment
changeDateDatetimeAsset changedate
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
idIntIdentity column
assetnoIntId of asset
actiondateDatetimeDate of log entry
actiontypeByte1)
vounoIntVouchernumber
amountDecimal28,8Amount
bookdateDatetieAccountingdate
infoString80Event information
voutypeString8Voucherserie
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
1Asset creation/purchase
2Depreciation
3Edit of depreciation
4Property tax booking
5Edit of property tax
6Write up/down
7Sale of fixed asset
8Discard of fixed asset
9Internal interest booking
10Edit of internal interest
11Split of fixed asset
12Merge of fixed asset
13Registration of previous depreciations

Get method : /api/asset/get-categories

This method returns a list of asset categories

FieldDatatypeSizeComment
depreciatableByte1)
taxdepreciatableByte2)
taxableByte3)
assetcategory1Byte4)
nameString40Category name

1)

ValueComment
1Depreciatable inventory
2Non-depreciatable inventory
3Real estate / building
4Real estate / markanläggning
5Real estate / mark

2)

ValueComment
0if assets of the category cannot be depreciated
1if assets of the category can be depreciated

3)

ValueComment
0if assets of the category aren’t subject to tax depreciations
1if assets of the category are subject to tax depreciations

4)

ValueComment
0if assets of the category aren’t subject to property taxes
1if assets of the category are subject to property taxes

Get method : /api/asset/get-types

This method returns a list of asset types

FieldDatatypeSizeComment
assettype1String8Asset type id
assetcategoryByte1)
nameString30Asset type name
buyaccountString6Purchase account
salesaccountString6Sales account
profitaccountString6Profit account
lossaccountString6Loss account
upaccountString6Write-up account
downaccountString6Write-down account
updownoffsetaccountString6Contra account write-up/write-down
o1debitString64Debet object 1 for internal interest
o2debitString64Debet object 2 for internal interest
o3debitString64Debet object 3 for internal interest
o4debitString64Debet object 4 for internal interest
o5debitString64Debet object 5 for internal interest
o6debitString64Debet object 6 for internal interest
o7debitString64Debet object 7 for internal interest
o8debitString64Debet object 8 for internal interest
o1creditString64Credit object 1 for internal interest
o2creditString64Credit object 2 for internal interest
o3creditString64Credit object 3 for internal interest
o4creditString64Credit object 4 for internal interest
o5creditString64Credit object 5 for internal interest
o6creditString64Credit object 6 for internal interest
o7creditString64Credit object 7 for internal interest
o8creditString64Credit object 8 for internal interest
intdebitaccString6Debet account for internal interest
intcreditaccString6Credit account for internal interests
intidString8Interest procedure for internal interests

1)

ValueComment
1Depreciatable inventory
2Non-depreciatable inventory
3Real estate / building
4Real estate / markanläggning
5Real estate / mark

Get method : /api/asset/get-statuses

This method returns a list of asset status

FieldDatatypeSizeComment
assetstatus1Byte1)
nameString40Name

1)

ValueComment
1Preliminary
10Owned, for use
11Owned, not for use
12Owned, non-accountable
50Not owned, borrowed/insured
51Not owned, leased/insured
90Owned, fully depricated
91Sold
92Missing
93Stolen
94Returned back
99Counter-booked

Get method : /api/asset/get-deprecproc

This method returns a list of asset depreciation procedures

FieldDatatypeSizeComment
deprecproc1Byte1)
classByte2)
calctypeByte3)
daybasedByte4)
storedprocString80Name of the stored procedure for user-defined methods of depreciation
nameString40Name

1)

ValueComment
1depreciation according to plan / period
2depreciation according to plan / date
3percentage depreciation / period
4percentage depreciation / date
5end date depreciation / period
6end date depreciation / date
7tax depreciation / period
8tax depreciation / date
User-defined depreciation methods should start with ID = 100

2)

ValueComment
1accounting depreciation
2tax depreciation

3)

ValueComment
1according to plan
2percentage
3end date
4no parameters (e.g. 30/20-rule)

4)

ValueComment
0if calculation is based on whole periods
1calculation is day-based

Get method : /api/asset/get-deprectypes

This method returns a list of asset depreciation types

FieldDatatypeSizeComment
deprectype1String8Depreciation type id
deprecprocByteDepreciation method
yearsIntNumber of years for the depreciation methods according to plan
percentageDecimal28,8Percentage for percentage-depreciation methohs
nameString30Name

Get method : /api/asset/get-deprecrules

This method returns a list of asset depreciation rules

FieldDatatypeSizeComment
deprecproc1ByteDepreciation method of the depreciation type. Refers to deprectype.deprecproc
assetNoIntAsset id
deprectypeString8Depreciation type ID to which the rule belongs. Refers to deprectype.deprectype
startdateDatetimeStart date for depreciation
balanceaccountString6Balance account for the created vouchers
balanceo1String64Balance object 1 for the created vouchers
balanceo2String64Balance object 2 for the created vouchers
balanceo3String64Balance object 3 for the created vouchers
balanceo4String64Balance object 4 for the created vouchers
balanceo5String64Balance object 5 for the created vouchers
balanceo6String64Balance object 6 for the created vouchers
balanceo7String64Balance object 7 for the created vouchers
balanceo8String64Balance object 8 for the created vouchers
resultaccountString6Profit/loss account for the created vouchers
resulto1String64Profit/loss object 1 for the created vouchers
resulto2String64Profit/loss object 2 for the created vouchers
resulto3String64Profit/loss object 3 for the created vouchers
resulto4String64Profit/loss object 4 for the created vouchers
resulto5String64Profit/loss object 5 for the created vouchers
resulto6String64Profit/loss object 6 for the created vouchers
resulto7String64Profit/loss object 7 for the created vouchers
resulto8String64Profit/loss object 8 for the created vouchers
latestuseDatetimeMost recent use of the depreciation rule
percentageFloatPercentage for percentage-type depreciation rules
enddateDatetimeEnd date for the end-date-type depreciation rules
minresidualFloatMinimal residual value
prevdeprecstartDatetimeDate of the previous depreciation
prevdeprecamountFloatAmount of the previous depreciation
ruledoneInt0 – rule is done. 1 – rule is active

GroupType

Get method : /api/grouptype/get-grouptypes

This method will return a list of usergroups

InputfieldDatatypeComment
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typenameString10Group type
groupnameString8Group id
uacIntUser Access Code
groupdescString20Description
textString80Freetext for group
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

Invoice

Get method : /api/invoice/get-types

This method will return a list of invoice types

FieldDatatypeSizeComment
typeShort1)
usertypeString2Name
interestByte2)
sortByteIternal sort item
descriptionString20Description

1)

ValueComment
1invoice, customer invoice
2credit, customer invoice
3interest invoice, customer invoice
4interest credit, customer invoice
5on account, customer invoice
6advance, customer invoice
10final payment, customer invoice
11partial payment, customer invoice
12difference, customer invoice
13cash discount, customer invoice
14fee, customer invoice
15matching, customer invoice
16currency profit, customer invoice
17currency loss, customer invoice
-1invoice, supplier ledger
-2credit, supplier ledger
-3on account, supplier ledger
-4advance, supplier ledger
-10final payment, supplier ledger
-11partial payment, supplier ledger
-12difference, supplier ledger
-13cash discount, supplier ledger
-14matching, supplier ledger
-15currency profit, supplier ledger
-16currency loss, supplier ledger

2)

ValueComment
0invoice type does not trigger generation of interests
1invoice type can trigger generation of interests

Get method : /api/invoice/get-invoicestatus

Returns the invoice statuses that were changes since the last time the endpoint was called

FieldDatatypeComment
invoiceSerieString8Invoive serie
invoiceNumberStringInvoice number
statusInt1)

1)

ValueComment
0preliminary invoice
1booked invoice
2printed invoice

Get method : /api/invoice/get-paidstatus

Returns the invoice statuses that were changes since the last time the endpoint was called

InputfieldDatatypeComment
startDateDatetime
FieldDatatypeSizeComment
invoiceSerieString8Invoive serie
invoiceNumberStringInvoice number
statusInt1)

1)

ValueComment
0preliminary invoice
1booked invoice
2printed invoice

Get method : /api/invoice/list

Returns a list of invoices between two invoice dates. The list can be filtered by status

InputfieldDatatypeComment
fromInvoiceDateDatetTimeFrom date
toInvoiceDateDateTimeTo date
statusInt1)

1)

ValueComment
0preliminary invoice
1booked invoice
2printed invoice
FieldDatatypeSizeComment
businessUnitString8Company. Refers to client.no
invoiceSerieString8Invoice serie
invoiceNumberInt12Invoicenumber
customerString40Customer id. Refers to person.id
payerString12Payer ID, refers to person.id.
payeeString12Payee ID, refers to person.id.
receiverString12Receiver ID, refers to person.id.
address1String40Address line 1
address2String40Address line 2
address3String40Address line 3
address4String40Address line 4
address5String40Address line 5
address6String40Address line 6
address7String40Address line 7
address8String40Address line 8
xTopString8Terms of payment, refers to xtop.id.
mopString8Mode of payment, refers to mop.id.
invoiceDateDatetimeInvoicing date.
dueDateDatetimeDue date.
invoiceTypeByte1)
subTypeByte2)
feeDecimal28,8Invoice fee in foreign amount, including tax.
freightDecimal28,8Invoice fee in foreign amount, including tax.
extraFeeDecimal28,8Administration fee in foreign amount, including tax.
vFeeDecimal28,8Tax in invoice fee in foreign amount.
vFreightDecimal28,8Tax in freight in foreign amount.
vExtraFeeDecimal28,8Tax in administration fee in foreign amount.
vFeeCodeByteVAT code for invoice fee.
vFreightCodeByteVAT code for freight.
vExtraFeeCodeByteVAT for administration.
accountString6Account receivable, refers to account.account.
differenceNumeric28,8Difference.
roundingNumeric28,8Rounding.
statusByte3)
amountNumeric28,8Total foreign amount for invoice.
vatNumeric28,8Total tax in foreign amount for invoice.
exchangeNumeric28,8Exchange rate for currency.
fixedExchangeByteSet to 1 if fixed exchange rate should be used for payment.
usernameString30User who created the invoice.
periodicMonthsIntNumber of periods over which the invoice should be periodically allocated.
startMonthIntRelative start month for periodic allocation.
tradeCodeByteCommercial code.
modString8Method of delivery of group type “MOD”.
todString8Terms of delivery of group type “TOD”.
extraIdString30Extra ID.
bankCodeString8Central bank code of group type “BANKCODE”.
languageString8Language code of group type “LANGID”.
interestString8Interest procedure, refers to relinterest.id.
cashDiscountString8Cash discount, refers to cashdiscount.id.
currencyString3Currency, refers to currency.currency.
feeAccountString6Account for invoice fee.
freightAccountString6Account for freight.
xFeeAccountString6Account for administration fee.
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
yourOrderNoString30Their order number
ourOrderNoString30Our order number
group1String64Group type LEDGER1
group2String64Group type LEDGER2
xFreeTextString255Freetext on head
ourReferenceString30Our reference
yourReferenceString30Their reference
invoicingPeriodStartDatetimeInvoicing period start
invoicingPeriodEndDatetimeInvoicing period end

1)

ValueComment
1Ordinary invoice
2Credit invoice

2)

ValueComment
0Ordinary invoice
1Credit invoice

3)

ValueComment
0preliminary invoice
1booked invoice
2printed invoice

Get method : /api/invoice/{invoiceserie}/{invoicenumber}

Retrieves an invoice based on the invoice number and invoice serie

InputfieldDatatypeComment
invoiceNumberIntInvoice number
invoiceSerieStringInvoice serie
FieldDatatypeSizeComment
Head
businessUnitString8Company. Refers to client.no
serieString8Invoice serie
invoiceNumberInt12Invoicenumber
customerIDString40Customer id. Refers to person.id
payerString12Payer ID, refers to person.id.
payeeString12Payee, refers to person.id.
receiverString12Receiver, refers to person.id.
address1String40Address line 1
address2String40Address line 2
address3String40Address line 3
address4String40Address line 4
address5String40Address line 5
address6String40Address line 6
address7String40Address line 7
address8String40Address line 8
termsOfPaymentString8Terms of payment
modofPaymentString8Mode of payment
invoiceDateDatetimeInvoiceing date
dueDateDatetimeDue date (Can be NULL)
invoiceTypeByte1 – ordinary invoice, 2 – credit invoice
subTypeByte0 – ordinary invoice, 1 – summary invoice
freeTextString255Freetext on head
ourreferenceString30Our reference
yourreferenceString30Their reference
accountString6Account payable
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
yourOrderNoString30Their order number
ourOrderNoString30Our order number
group1String64Group type LEDGER1
group2String64Group type LEDGER2
interestString8Interest procedure
languageString8Language code of group type LANGID
modOfDeliveryString8Method of delivery of group type MOD
termsOfDeliveryString8Method of delivery of group type TOD
periodicMonthsIntNumber of periods over which the invoice amount should be periodically allocated
startMonthIntRelativ start month for periodic allocation
invoiceReferenceString128Invoice reference
yourReferenceNumberString128Reference number
invoicingPeriodStartDatetimeInvoicing period start
invoicingPeriodEndDatetimeInvoicing period end
Rows
articleString30Articel id
freeTextString80Freetext for the row
accountString6Sales account
vatCodebyteVat code for the row. 0-30
vatDecimal28,8Vat amount in foreign amount
quantityDecimal28,8Quantity
apriceDecimal28,8Price per unit
amountDecimal28,8Amount in domestic currency incluing tax
forAmountDecimal28,8Amount in foreign currency incluing tax
extraAmountDecimal28,8Extra amount
discountDecimal28,8Discount in foreign amount
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Group of group type VOUROW1
group2String64Group of group type VOUROW2
group3String64Group of group type VOUROW3
group4String64Group of group type VOUROW4
typeByte1)
unitString8Unit of group type UNIT

1)

ValueComment
0normal row
1total row, partial sum
2total row
3empty row

Get method : /api/invoice/invoicereference/{invSerie}/{invoiceNumber}

Retrieves the invoice reference based on the invoice serie and invoice number

InputfieldDatatypeComment
invoiceSerieStringInvoice serie
invoiceNumberIntInvoice number
FieldDatatypeSizeComment
invReferenceString128Invoice reference
yourReferenceNumberString128Reference number

InvoiceLog

Get method : /api/invoicelog/get-invoicelog-by-Id

This method will return a invoicelog

InputfieldDatatypeSizeComment
invnumberIntInvoice number
invseriestring8Invoice serie
FieldDatatypeSizeComment
Head
businessUnitString8Company. Refers to client.no
serieString8Invoice serie
invoiceNumberInt12Invoicenumber
customerIDString40Customer id. Refers to person.id
payerString12Payer ID, refers to person.id.
payeeString12Payee, refers to person.id.
receiverString12Receiver, refers to person.id.
address1String40Address line 1
address2String40Address line 2
address3String40Address line 3
address4String40Address line 4
address5String40Address line 5
address6String40Address line 6
address7String40Address line 7
address8String40Address line 8
termsOfPaymentString8Terms of payment
modofPaymentString8Mode of payment
invoiceDateDatetimeInvoiceing date
dueDateDatetimeDue date (Can be NULL)
invoiceTypeByte1 – ordinary invoice, 2 – credit invoice
subTypeByte0 – ordinary invoice, 1 – summary invoice
freeTextString255Freetext on head
ourreferenceString30Our reference
yourreferenceString30Their reference
accountString6Account payable
currencyString3Currency
feeDecimal28,8Invoice fee in foreign currency, including tax
freightDecimal28,8Freight in foreign currency, including tax
extraFeeDecimal28,8Administration fee in foreign currency, including tax
vFeeDecimal28,8VAT in invoice fee in foreign currency
vFreightDecimal28,8VAT in freight in foreign currency
vExtraFeeDecimal28,8VAT in administration fee in foreign currency
vFeeCodeShortVAT code for invoice fee
vFreightCodeShortVAT code for freight
vExtraFeeCodeShortVAT code for administration fee
feeAccountString6Account for invoice fee
freightAccountString6Account for freight
xFeeAccountString6Account for administration
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
yourOrderNoString30Their order number
ourOrderNoString30Our order number
group1String64Group type LEDGER1
group2String64Group type LEDGER2
interestString8Interest procedure
languageString8Language code of group type LANGID
modOfDeliveryString8Method of delivery of group type MOD
termsOfDeliveryString8Method of delivery of group type TOD
periodicMonthsIntNumber of periods over which the invoice amount should be periodically allocated
startMonthIntRelativ start month for periodic allocation
invoiceReferenceString128Invoice reference
yourReferenceNumberString128Reference number
invoicingPeriodStartDatetimeInvoicing period start
invoicingPeriodEndDatetimeInvoicing period end
Rows
articleString30Articel id
freeTextString80Freetext for the row
accountString6Sales account
vatCodebyteVat code for the row. 0-30
vatDecimal28,8Vat amount in foreign amount
quantityDecimal28,8Quantity
apriceDecimal28,8Price per unit
amountDecimal28,8Amount in domestic currency incluing tax
forAmountDecimal28,8Amount in foreign currency incluing tax
extraAmountDecimal28,8Extra amount
discountDecimal28,8Discount in foreign amount
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Group of group type VOUROW1
group2String64Group of group type VOUROW2
group3String64Group of group type VOUROW3
group4String64Group of group type VOUROW4
typeByte1)
unitString8Unit of group type UNIT

1)

ValueComment
0normal row
1total row, partial sum
2total row
3empty row

Post method : /api/invoicelog/create-invoicelog

This method will create an invoicelog

Creates an invoicelog. Customer details, address, terms of payment, due date, objects and account

automatically filled from the customer register when not provided in the request. Article data (price

objects, description, account, unit), amounts and VAT are automatically calculated when not

provided. If data is provided in the request it takes precedence over auto-filled data

InputfieldDatatypeSizeComment
Head
businessUnitString8Company. Refers to client.no
serieString8Invoice serie
invoiceNumberIntInvoicenumber
customerIDString12Customer id. Refers to person.id
payerString12Payer ID, refers to person.id.
payeeString12Payee, refers to person.id.
receiverString12Receiver, refers to person.id.
address1String40Address line 1
address2String40Address line 2
address3String40Address line 3
address4String40Address line 4
address5String40Address line 5
address6String40Address line 6
address7String40Address line 7
address8String40Address line 8
termsOfPaymentString8Terms of payment
modofPaymentString8Mode of payment
invoiceDateDatetimeInvoiceing date
dueDateDatetimeDue date (Can be NULL)
invoiceTypeByte1 – ordinary invoice, 2 – credit invoice
subTypeByte0 – ordinary invoice, 1 – summary invoice
freeTextString255Freetext on head
ourreferenceString30Our reference
yourreferenceString30Their reference
accountString6Account payable
currencyString3Currency
feeDecimal28,8Invoice fee in foreign currency, including tax
freightDecimal28,8Freight in foreign currency, including tax
extraFeeDecimal28,8Administration fee in foreign currency, including tax
vFeeDecimal28,8VAT in invoice fee in foreign currency
vFreightDecimal28,8VAT in freight in foreign currency
vExtraFeeDecimal28,8VAT in administration fee in foreign currency
vFeeCodeShortVAT code for invoice fee
vFreightCodeShortVAT code for freight
vExtraFeeCodeShortVAT code for administration fee
feeAccountString6Account for invoice fee
freightAccountString6Account for freight
xFeeAccountString6Account for administration
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
yourOrderNoString30Their order number
ourOrderNoString30Our order number
group1String64Group type LEDGER1
group2String64Group type LEDGER2
interestString8Interest procedure
languageString8Language code of group type LANGID
modOfDeliveryString8Method of delivery of group type MOD
termsOfDeliveryString8Method of delivery of group type TOD
periodicMonthsIntNumber of periods over which the invoice amount should be periodically allocated
startMonthIntRelativ start month for periodic allocation
transferBoolTransfer from log to invoice after creation
checkRuleByteCheck rules during transfer
invoiceReferenceString128Invoice reference
yourReferenceNumberString128Reference number
deleteAfterTransferBoolDelete invoicelog after transfer if log is transferred ok
invoicingPeriodStartDatetimeInvoicing period start
invoicingPeriodEndDatetimeInvoicing period end
extraIdString30Extra ID
Rows
articleString20Articel id
freeTextString80Freetext for the row
accountString6Sales account
vatCodeByteVat code for the row. 0-30
vatDecimal28,8Vat amount in foreign amount
quantityDecimal28,8Quantity
apriceDecimal28,8Price per unit
amountDecimal28,8Amount in domestic currency incluing tax
forAmountDecimal28,8Amount in foreign currency incluing tax
extraAmountDecimal28,8Extra amount
discountDecimal28,8Discount in foreign amount
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Group of group type VOUROW1
group2String64Group of group type VOUROW2
group3String64Group of group type VOUROW3
group4String64Group of group type VOUROW4
typeByte1)
unitstring8Unit of group type UNIT

1)

ValueComment
0normal row
1total row, partial sum
2total row
3empty row
FieldDatatypeComment
invoiceNumberIntInvoice number of created invoice
errorNoIntError number
errorDescriptionStringError message

Post method : /api/invoicelog/create-invoicelog-customer-details

This method will create an invoicelog. Customer details will be copied to the invoicelog

InputfieldDatatypeSizeComment
Head
businessUnitString8Company. Refers to client.no
serieString8Invoice serie
invoiceNumberIntInvoicenumber
customerIDString12Customer id. Refers to person.id
payerString12Payer ID, refers to person.id.
payeeString12Payee, refers to person.id.
receiverString12Receiver, refers to person.id.
invoiceDateDatetimeInvoiceing date
invoiceTypeByte1 – ordinary invoice, 2 – credit invoice
freeTextString255Freetext on head
ourreferenceString30Our reference
yourreferenceString30Their reference
currencyString3Currency
transferInvoiceLogBoolTransfer from log to invoice after creation
invoiceReferenceString128Invoice reference
yourReferenceNumberString128Reference number
deleteAfterTransferBoolTrue – Delete log after successful transfer, False – keep log after transfer
invoicingPeriodStartDatetimeInvoicing period start
invoicingPeriodEndDatetimeInvoicing period end
Rows
freeTextString80Freetext for the row
accountString6Sales account
vatCodeByteVat code for the row. 0-30
vatDecimal28,8Vat amount in foreign amount
quantityDecimal28,8Quantity
apriceDecimal28,8Price per unit
amountDecimal28,8Amount in domestic currency incluing tax
forAmountDecimal28,8Amount in foreign currency incluing tax
articleString20Id of article
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
typeByte1)
group1String64Group of group type VOUROW1
group2String64Group of group type VOUROW2
group3String64Group of group type VOUROW3
group4String64Group of group type VOUROW4
discountDecimal28,8Discount in foreign amount.
unitString8Unit of group type ”UNIT”

1)

ValueComment
0normal row
1total row, partial sum
2total row
3empty row

Return values

FieldDatatypeComment
invoiceNumberIntInvoice number of created invoice
errorNoIntError number
errorDescriptionStringError message

Ledger

Get method : /api/ledger/get-supplierledger

This method will return a supplier ledger

InputfieldDatatypeSizeComment
serieString8Ledger serie
invnoIntLedger number
FieldDatatypeSizeComment
vatcodeByteVat code
serieString8Voucher serie
ocrString100Ocr number
yearShortYear
remfeeDecimal28,8Reminder fee for ledger
accountStringAccount recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
usedcdDecimal28,8Used cash discount
statusByte0 – open, 1 – printed, 2 – ready for autopayment
codeByte0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelByteReminder level for sales ledgers
blockedByteBlocked for reminders / payments
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
typeShortLedger type. See method /api/invoice/get-types
itypeShortInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqByteSequential number. The header record is always 0. Sub records have 1-255
fixedexchangeByte0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
interestblockedByte1)
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
orgString30Original invoice number
extraidString30Extra id
duedateDatetimeDue date
interestduedateDatetimeInterest due date
paydateDatetimeFinal payment date
lastinterestDatetimeLast interest calculation date
lastinternalDatetimeLast internal interest calculation date
claimdateDatetimeLast reminders booking date for sales ledgers / arrival date for supplier ledgers
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
noteString255Internal note for ledger
interestString8Interest procedure
vounoIntVoucher number
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
discountString8Cash discount
cidString8Company

1)

ValueComment
0interest can be calculated for the ledger
1interest can not be calculated for the ledger

Get method : /api/ledger/get-salesledger

This method will return a sales ledger

InputfieldDatatypeSizeComment
serieString8Ledger serie
invno IntInvoice number
FieldDatatypeSizeComment
vatcodeByteVat code
serieString8Voucher serie
ocrString100Ocr number
yearShortYear
remfeeDecimal28,8Reminder fee for ledger
accountStringAccount recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
usedcdDecimal28,8Used cash discount
statusByte0 – open, 1 – printed, 2 – ready for autopayment
codeByte0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelByteReminder level for sales ledgers
blockedByteBlocked for reminders / payments
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
typeShortLedger type. See method /api/invoice/get-types
itypeShortInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqByteSequential number. The header record is always 0. Sub records have 1-255
fixedexchangeByte0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
interestblockedByte1)
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
foramountDecmal28,8Foreign amount
vatDecimal28,8Vat amount
orgString30Original invoice number
extraidString30Extra id
duedateDatetimeDue date
interestduedateDatetimeInterest due date
paydateDatetimeFinal payment date
lastinterestDatetimeLast interest calculation date
lastinternalDatetimeLast internal interest calculation date
claimdateDatetimeLast reminders booking date for sales ledgers / arrival date for supplier ledgers
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
noteString255Internal note for ledger
interestString8Interest procedure
vounoIntVoucher number
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
discountString8Cash discount
cidString8Company

1)

ValueComment
0interest can be calculated for the ledger
1interest can not be calculated for the ledger

Get method : /api/ledger/get-ledgers

This method will return a list of ledgers

InputfieldDatatypeComment
lastUpdatedDateDatetime1)
includePreliminaryBool
pageint0 is first page

1)

Where voucher.voucounter >= lastUpdatedDate

FieldDatatypeSizeComment
vatcodeByteVat code
serieString8Voucher serie
ocrString100Ocr number
yearShortYear
remfeeDecimal28,8Reminder fee for ledger
accountStringAccount recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
usedcdDecimal28,8Used cash discount
statusByte0 – open, 1 – printed, 2 – ready for autopayment
codeByte0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelByteReminder level for sales ledgers
blockedByteBlocked for reminders / payments
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
typeShortLedger type. See method /api/invoice/get-types
itypeShortInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqByteSequential number. The header record is always 0. Sub records have 1-255
fixedexchangeByte0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
interestblockedByte1)
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
foramountDecmal28,8Foreign amount
vatDecimal28,8Vat amount
orgString30Original invoice number
extraidString30Extra id
duedateDatetimeDue date
interestduedateDatetimeInterest due date
paydateDatetimeFinal payment date
lastinterestDatetimeLast interest calculation date
lastinternalDatetimeLast internal interest calculation date
claimdateDatetimeLast reminders booking date for sales ledgers / arrival date for supplier ledgers
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
noteString255Internal note for ledger
interestString8Interest procedure
vounoIntVoucher number
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
discountString8Cash discount
cidString8Company

1)

ValueComment
0interest can be calculated for the ledger
1interest can not be calculated for the ledger

Get method : /api/ledger/get-ledgers-by-dates

This method will return a list of ledgers

InputfieldDatatypeComment
bookingDateFromDatetimeAccounting date from. 1)
bookingDateTodatetimeAccounting date to. 1)
includePreliminaryBoolFlag to include preliminary ledgers
onlyUnpaidBoolFlag to include only unpaid ledgers
pageint0 is first page

1)

Where ledger.bookdate between bookingDateFrom and bookingDateTo

FieldDatatypeSizeComment
vatcodeByteVat code
serieString8Voucher serie
ocrString100Ocr number
yearShortYear
remfeeDecimal28,8Reminder fee for ledger
accountStringAccount recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
usedcdDecimal28,8Used cash discount
statusByte0 – open, 1 – printed, 2 – ready for autopayment
codeByte0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelByteReminder level for sales ledgers
blockedByteBlocked for reminders / payments
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
typeShortLedger type. See method /api/invoice/get-types
itypeShortInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqByteSequential number. The header record is always 0. Sub records have 1-255
fixedexchangeByte0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
interestblockedByte1)
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
foramountDecmal28,8Foreign amount
vatDecimal28,8Vat amount
orgString30Original invoice number
extraidString30Extra id
duedateDatetimeDue date
interestduedateDatetimeInterest due date
paydateDatetimeFinal payment date
lastinterestDatetimeLast interest calculation date
lastinternalDatetimeLast internal interest calculation date
claimdateDatetimeLast reminders booking date for sales ledgers / arrival date for supplier ledgers
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
noteString255Internal note for ledger
interestString8Interest procedure
vounoIntVoucher number
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
discountString8Cash discount
cidString8Company

1)

ValueComment
0interest can be calculated for the ledger
1interest can not be calculated for the ledger

Get method : /api/ledger/get-nextinvoicenumber

This method returns next invoicenumber

InputfieldDatatypeSizeComment
enumeratorString8Invoice serie
invoicedateDatetimeInvoiceing date
ledgertypeShort-1 – supplier invoices, 1 – customer invoices
FieldDatatypeComment
IntNext invoice number

Get method : /api/ledger/get-ledgerlog-by-Id

This method returns a ledgerlog

InputfieldDatatypeSizeComment
invnoIntInvoice number
enumeratorstring8Ledger serie
FieldDatatypeSizeComment
businessUnitString8Company
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
typeIntLedger type. See method /api/invoice/get-types
itypeIntInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqIntSequential number. The header record is always 0. Sub records have 1-255
orgString30Original invoice number
extraidString30Extra id
codeInt0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment
proposal
xlevelIntReminder level for sales ledgers
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
duedateDatetimeDue date
interestduedateDatetimeInterest due date
currencyString3Currency
fixedexchangeInt0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
vatcodeIntVat code
discountString8Cash discount
accountString6Account recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
interestString8Interest procedure
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
vounoIntVoucher number
voucherSerieString8Voucher serie
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
noteString255Internal note for ledger
yearIntYear
usedcdDecimal28,8Used cash discount
ocrString100Ocr number

Post method : /api/ledgerlog/customer

This method creates a customer ledgerlog

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
businessUnitString8Company
personString12Customer. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
typeIntLedger type. See method /api/invoice/get-types
itypeIntInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqIntSequential number. The header record is always 0. Sub records have 1-255
orgString30Original invoice number
extraidString30Extra id
codeInt0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelIntReminder level for sales ledgers
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
duedateDatetimeDue date
interestduedateDatetimeInterest due date
currencyString3Currency
fixedexchangeInt0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
vatcodeIntVat code
discountString8Cash discount
accountString6Account recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
interestString8Interest procedure
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
vounoIntVoucher number
voucherSerieString8Voucher serie
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
noteString255Internal note for ledger
yearIntYear
usedcdDecimalUsed cash discount
ocrString100Ocr number
transferLogboolFalse – no automatic transfer, true – automatic transfer
deleteaftertransferboolFalse – No delete, true – delete
FieldDatatypeComment
ledgerSerieStringLedger serie
invnoIntInvoice number
lognoIntLog number for ledger. Refers to voulog.logno
messageString

Post method : /api/ledgerlog/supplier

This method creates a supplier ledgerlog

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
businessUnitString8Company
personString12Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
typeIntLedger type. See method /api/invoice/get-types
itypeIntInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqIntSequential number. The header record is always 0. Sub records have 1-255
orgString30Original invoice number
extraidString30Extra id
codeInt0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelIntReminder level for sales ledgers
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
duedateDatetimeDue date
interestduedateDatetimeInterest due date
currencyString3Currency
fixedexchangeInt0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
vatcodeIntVat code
discountString8Cash discount
accountString6Account recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
vounoIntVoucher number
voucherSerieString8Voucher serie
bankcodeString8Central bank code of group type BANKCODE
tradecodeInt8Commercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
noteString255Internal note for ledger
yearIntYear
usedcdDecimal28,8Used cash discount
ocrString100Ocr number
transferLogboolFalse – no automatic transfer, true – automatic transfer
deleteaftertransferboolFalse – No delete, True = delete after transfer
FieldDatatypeComment
ledgerSerieStringLedger serie
invnoIntInvoice number
lognoIntLog number for ledger. Refers to voulog.logno
messageString

Post method : /api/ledgerlog-withvoucher/customer

This method creates a customer ledgerlog with voucherlog

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
Ledgerlog:
businessUnitString8Company
personString12Customer. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
typeIntLedger type. See method /api/invoice/get-types
itypeIntInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqIntSequential number. The header record is always 0. Sub records have 1-255
orgString30Original invoice number
extraidString30Extra id
codeInt0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelIntReminder level for sales ledgers
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
duedateDatetimeDue date
interestduedateDatetimeInterest due date
currencyString3Currency
fixedexchangeInt0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
vatcodeIntVat code
discountString8Cash discount
accountString6Account recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
interestString8Interest procedure
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
vounoIntVoucher number
voucherSerieString8Voucher serie
bankcodeString8Central bank code of group type BANKCODE
tradecodeInt8Commercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
noteString255Internal note for ledger
yearIntYear
usedcdDecimal28,8Used cash discount
ocrString100Ocr number
transferLogboolFalse – no automatic transfer, true – automatic transfer
deleteaftertransferboolFalse – No delete, True = delete after transfer
VoucherLog:
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeIntLedger type. See method /api/invoice/get-types
enumeratorString8Invoice serie
invnoIntInvoice number
voucherDateDatetimeAccounting date
useridString255User creating the voucher
userGroup1String128Group of type VOUCHER1
userGroup2String128Group of type VOUCHER2
freeTextString80Free text
transferLogBoolTrue – transferlog, false – do not transfer log
checkRuleIntCheck business rules on transfer
Rows:
accountString6Account
amountDecimalAmount
foramountDecimalForeign amount
currencyString3Currency
numberDecimal28,8Quantity
freeTextString80Free text on row
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
vatCodeIntVat code
FieldDatatypeSizeComment
ledgerSerieString8Ledger serie
invnoIntInvoice number
voucherSerieString8Voucher serie
voucherNumberIntVouncher number
lognoIntVoucher logno
messageString

Post method : /api/ledgerlog-withvoucher/supplier

This method creates a supplier ledgerlog with voucherlog

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
Ledgerlog:
businessUnitString8Company
personString12Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
typeIntLedger type. See method /api/invoice/get-types
itypeIntInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqIntSequential number. The header record is always 0. Sub records have 1-255
orgString30Original invoice number
extraidString30Extra id
codeInt0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelIntReminder level for sales ledgers
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
duedateDatetimeDue date
interestduedateDatetimeInterest due date
currencyString3Currency
fixedexchangeInt0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
vatcodeIntVat code
discountString8Cash discount
accountString6Account recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
vounoIntVoucher number
voucherSerieString8Voucher serie
bankcodeString8Central bank code of group type BANKCODE
tradecodeInt8Commercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
noteString255Internal note for ledger
yearIntYear
usedcdDecimal28,8Used cash discount
ocrString100Ocr number
transferLogboolFalse – no automatic transfer, true – automatic transfer
deleteaftertransferboolFalse – No delete, True = delete after transfer
VoucherLog:
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeIntLedger type. See method /api/invoice/get-types
enumeratorString8Invoice serie
invnoIntInvoice number
voucherDateDatetimeAccounting date
useridString255User creating the voucher
userGroup1String128Group of type VOUCHER1
userGroup2String128Group of type VOUCHER2
freeTextString80Free text
transferLogBoolTrue – transferlog, false – do not transfer log
checkRuleIntCheck business rules on transfer
Rows:
accountString6Account
amountDecimalAmount
foramountDecimalForeign amount
currencyString3Currency
numberDecimal28,8Quantity
freeTextString80Free text on row
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
vatCodeIntVat code
FieldDatatypeSizeComment
ledgerSerieString8Ledger serie
invnoIntInvoice number
voucherSerieString8Voucher serie
voucherNumberIntVouncher number
lognoIntVoucher logno
messageString

Post method : /api/ledger/create-supplier-ledger

Creates a supplier ledger with the default (autogenerated) accounting data, creates period

allocations for rows and preliminary fixed assets if a fixed asset is used. For changing an existing

supplier ledger Invno parameter must have a greater than 0 value

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
serieString8Ledger serie
invnoIntInvoice number
voucherSerieString8Voucher serie
vatCodeIntVat code
invoiceTypeIntLedger type. See method /api/invoice/get-types
amountDecimal28,8Amount
foreignAmountDecimal28,8Foreign amount
currencyString3Currency
extraidString30Extra ID
cidString8Company
personIdString12Supplier id
contraAccountString6Account
bookDateDatetimeAccounting date
invoiceDateDatetimeInvoice date
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
doPeriodAllocationBoolTrue – create period allocation, false – do not create period allocation
periodAllocationStartDateDatetimePeriod allocation start date
periodAllocationEndDateDatetimePeriod allocation end date
periodAllocationAccountString6Periodic allocation account
definitiveBookedBoolTrue – invoice is definitive, false – invoice is arrival booked
FieldDatatypeSizeComment
successBoolTrue – successful, false – not successful
result:
ledgerSerieString8Invoice serie
invnoIntInvoice number
voucherSerieString8Voucher serie
voucherNumberIntVoucher number
reversedVoucherSerieString8Reversed voucher serie
reversedVoucherNumberIntReversed voucher number
preliminaryAssetBoolTrue – preliminary asset was created, false - preliminary asset was not created
periodicAllocationIntPeriodic Allocation

Post method : /api/ledger/create-supplier-ledger-with-voucherrows

Creates a supplier ledger with the provided accounting data (check the parameters- Voucher rows)

creates period allocations for rows and preliminary fixed assets if a fixed asset is used. For changing

an existing supplier ledger Invno parameter must have a greater than 0 value

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
serieString8Ledger serie
invnoIntInvoice number
voucherSerieString8Voucher serie
vatCodeByteVat code
vatAmountDecimal28,8Vat amount
originalInvoiceNumberString30Original invoice number
ocrNumberString100Ocr number
invoiceTypeShortLedger type. See method /api/invoice/get-types
AmountDecimal28,8Amount
foreignAmountDecimal28,8Foreign amount
CurrencyString3Currency
extraidString30Extra ID
cidString8Company
personIdString12Supplier id
contraAccountString6Account
bookDateDatetimeAccounting date
invoiceDateDatetimeInvoice date
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
definitiveBookedBoolTrue – invoice is definitive, false – invoice is arrival booked
dueDateDatetimeDue date
group2String64Free group of group type “LEDGER2”
group1String64Free group of group type “LEDGER1”
noteString255Internal note for ledger
freeTextString80Freetext
voucherRows
accountString6Account
amountDecimalAmount
foramountDecimalForeign amount
currencyString3Currency
numberDecimalQuantity
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
doPeriodAllocationBoolTrue – create period allocation, false – do not create period allocation
periodAllocationStartDateDatetimePeriod allocation start date
periodAllocationEndDateDatetimePeriod allocation end date
periodAllocationAccountString6Periodic allocation account
FieldDatatypeSizeComment
successBoolTrue – successful, false – not successful
result:
ledgerSerieString8Invoice serie
invnoIntInvoice number
voucherSerieString8Voucher serie
voucherNumberIntVoucher number
reversedVoucherSerieString8Reversed voucher serie
reversedVoucherNumberIntReversed voucher number
preliminaryAssetBoolTrue – preliminary asset was created, false - preliminary asset was not created
periodicAllocationIntPeriodic Allocation

Post method : /api/ledger/create-customer-ledger-with-voucherrows

Creates a customer ledger with the provided accounting data (check the parameters- Voucher rows)

creates period allocations for rows and preliminary fixed assets if a fixed asset is used. For changing

an existing supplier ledger Invno parameter must have a greater than 0 value

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation

ss

InputfieldDatatypeSizeComment
serieString8Ledger serie
invnoIntInvoice number
voucherSerieString8Voucher serie
vatCodeByteVat code
vatAmountDecimal28,8Vat amount
originalInvoiceNumberString30Original invoice number
ocrNumberString100Ocr number
invoiceTypeShortLedger type. See method /api/invoice/get-types
AmountDecimal28,8Amount
foreignAmountDecimal28,8Foreign amount
CurrencyString3Currency
cidString8Company
personIdString12Customer id
contraAccountString6Account
bookDateDatetimeAccounting date
invoiceDateDatetimeInvoice date
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
definitiveBookedBoolTrue – invoice is definitive, false – invoice is arrival booked
dueDateDatetimeDue date
interestString8Interest procedure, refers to relinterest.id.
group1String64Free group of group type “LEDGER2”
group2String64Free group of group type “LEDGER1”
noteString255Internal note for ledger
freeTextString80Freetext
voucherRows
accountString6Account
amountDecimalAmount
foramountDecimalForeign amount
currencyString3Currency
numberDecimalQuantity
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
doPeriodAllocationBoolTrue – create period allocation, false – do not create period allocation
periodAllocationStartDateDatetimePeriod allocation start date
periodAllocationEndDateDatetimePeriod allocation end date
periodAllocationAccountString6Periodic allocation account
FieldDatatypeSizeComment
successBoolTrue – successful, false – not successful
result:
ledgerSerieString8Invoice serie
invnoIntInvoice number
voucherSerieString8Voucher serie
voucherNumberIntVoucher number
periodicAllocationIntPeriodic Allocation

Post method : /api/ledger/create-customer-ledger

Creates a customer ledger with the default (autogenerated) accounting data

Example of calculation of amounts

CurrencyAmountForamountComment
EUR120Foramount will be calculated based on currency EUR
EUR012Amount will be calculated based on currency EUR
null120Foramount will be set as amount. No calculation
null012Amount will be set as amount. No calculation
InputfieldDatatypeSizeComment
LedgerSerieString8Ledger serie
InvnoIntInvoice number
VoucherSerieString8Voucher serie
VatCodeByteVat code
VataccountVat account
AmountDecimal28,8Vat amount
ForeignAmountDecimal28,8Foreign amount
CurrencyString3Currency
CidString8Company
CustomeridString12Customer id
IncomeAccountString6Account
CustomerAccountAccount
BookDateDatetimeAccounting date
InvoiceDateDatetimeInvoice date
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
interestString8Interest procedure, refers to relinterest.id
noteString255Internal note for ledger
freeTextString80Free text
LedgerRow
amountDecimalAmount
foramountDecimalForeign amount
VatAccountString6Account
VatCodeByteVat code
FieldDatatypeSizeComment
LedgerSerieString8Ledger serie
InvnoIntInvoice number
VoucherSerieString8Voucher serie
VoucherNumberIntVoucher number
PeriodicAllocationInt

Post method : /api/ledger/block-supplier-ledger

This method will block a ledger record for payments

InputfieldDatatypeSizeComment
InvoiceSerieString8Ledger serie
InvoiceNumberIntInvoice number
BlockedBoolBlocked = true; Not blocked = false

Get method : /api/ledger/get-paid-ledgers

This method returns a list of lerdgers

InputfieldDatatypeComment
payDateStartDatetimeGets ledgers greater then or equal to startdate. 1)

1)

Where ledger.paydate >= payDateStart and ledger.seq = 0

FieldDatatypeSizeComment
vatcodeByteVat code
serieString8Invoice serie
ocrString100Ocr number
yearShortYear
remfeeDecimal28,8Reminder fee for ledger
accountStringAccount recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
usedcdDecimal28,8Used cash discount
statusByte0 – open, 1 – printed, 2 – ready for autopayment
codeByte0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelByteReminder level for sales ledgers
blockedByteBlocked for reminders / payments
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
typeShortLedger type. See method /api/invoice/get-types
itypeShortInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqByteSequential number. The header record is always 0. Sub records have 1-255
fixedexchangeByte0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
interestblockedByte1)
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
orgString30Original invoice number
extraidString30Extra id
duedateDatetimeDue date
interestduedateDatetimeInterest due date
paydateDatetimeFinal payment date
lastinterestDatetimeLast interest calculation date
lastinternalDatetimeLast internal interest calculation date
claimdateDatetimeLast reminders booking date for sales ledgers / arrival date for supplier ledgers
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
noteString255Internal note for ledger
interestString8Interest procedure
vounoIntVoucher number
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
discountString8Cash discount
cidString8Company

Get method : /api/ledger/get-paid-ledgers-daterange

This method returns a list of ledgers

InputfieldDatatypeComment
payDateStartDatetimeStartdate. 1)
payDateEndDatetimeEnddate. 1)
ledgerTypePersonEnumType2)

1)

Where ledger.paydate >= paydateStart and ledger.paydate <= payDateEnd and ledger.seq = 0

2)

ValueComment
-1Supplier
1Customer
3FixedAsset
FieldDatatypeSizeComment
vatcodeByteVat code
serieString8Invoice serie
ocrString100Ocr number
yearShortYear
remfeeDecimal28,8Reminder fee for ledger
accountStringAccount recivable for sales ledger / account payable for supplier ledgers
differensDecimal28,8Difference
usedcdDecimal28,8Used cash discount
statusByte0 – open, 1 – printed, 2 – ready for autopayment
codeByte0 – normal ledger, 1 – arrival registered, 2 – to be reported back, 3 – payment proposal
xlevelByteReminder level for sales ledgers
blockedByteBlocked for reminders / payments
bookdateDatetimeAccounting date
invdateDatetimeInvoicing date
typeShortLedger type. See method /api/invoice/get-types
itypeShortInternal type. -1 for supplier ledgers / 1 for customer ledgers
enumeratorString8Ledger serie
invnoIntInvoice number
seqByteSequential number. The header record is always 0. Sub records have 1-255
fixedexchangeByte0 – variable exchange rate, 1 – fixed exchange rate
amountDecimal28,8Amount
interestblockedByte1)
personString12Customer / Supplier. Must exist in person table
payerString12Payer
payeeString12Payee
receiveString12Invoice recipient
mopString8Mode of payment
ropString8Payee mode of payment
group1String64Free group of group type LEDGER1
group2String64Free group of group type LEDGER2
freetextString80Free text
approval1String8First approval. Refers to signature
approval2String8Second approval. Refers to signature
lognoIntLog number for ledger. Refers to voulog.logno
foramountDecimal28,8Foreign amount
vatDecimal28,8Vat amount
orgString30Original invoice number
extraidString30Extra id
duedateDatetimeDue date
interestduedateDatetimeInterest due date
paydateDatetimeFinal payment date
lastinterestDatetimeLast interest calculation date
lastinternalDatetimeLast internal interest calculation date
claimdateDatetimeLast reminders booking date for sales ledgers / arrival date for supplier ledgers
currencyString3Currency
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
noteString255Internal note for ledger
interestString8Interest procedure
vounoIntVoucher number
bankcodeString8Central bank code of group type BANKCODE
tradecodeIntCommercial code
payformString8Pay form of group type PAYFORM
feecodeString8Fee code of group type FEECODE
discountString8Cash discount
cidString8Company

Delete method : /api/ledger/delete-ledger

This method deletes a ledger based on serie, invoicenumber and ledgertype

InputfieldDatatypeSizeComment
serieString8Ledger serie.
invnoIntInvoice number
ledgerTypePersonEnumType1)
accountingDateDateTimeAccountingdate

1)

ValueComment
-1Supplier
1Customer
3FixedAsset
FieldDatatypeComment
successBooltrue – succesful, false – not succesful
resultInt
errorMessageStringErrormessage

Get method : /api/ledger/supplier-ledgers-by-dates

This method returns a list of supplier ledgers based on a date range

InputfieldDatatypeSizeComment
fromDateDatetimeStartdate. 1)
toDateDatetimeEnddate. 1)
pageIntPage to fetch.
FieldDatatypeSizeComment
invoiceNumberIntInvoice number
invoiceSerieStringLedger serie
bookDateDatetimeAccounting date
lastChangedDateDatetimeVoucounter on conneted voucher
typeShort2)
amountNumeric28,8Amount
foreignAmountNumeric28,8Foreign amount
vatAmountNumeric28,8VAT amount
currencyString3Currency
supplierIdString12Supplier Id
voucherNumberIntVoucher number
voucherRows:
businessUnitString8Company
vouNoIntVoucher number
accountString6Account
amountNumeric28,8Amount
foramountNumeric28,8Foreign amount
currencyString3Currency
numberNumeric28,8Number
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
alteredByte0 – no change, 1 – added row, 2 – deleted row
bookDateDatetimeAccounting date
serieStringVoucher serie
rowNoIntRow number
yearByteYear number
periodBytePeriod number
resaccountString6Profit/loss account if one of the objects is balanced
extraAmountNumeric28,8Extra amount
vatCodeByteVAT code
crTypeByte3)
creatorString30Creator
baseCurrencyString3Alternative currency
baseAmountbaseAmountNumeric28,8Amount in alternative currency
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

Where ledger.bookdate between fromDate and toDate and ledger.seq = 0 and ledger.itype = -1

2)

typeDescription
-1Invoice
-2Credit
-3On account
-4Advance
-10Final payment
-11Partial payment
-12Difference
-13Cash discount
-14Matching
-15Currency profit
-16Currency loss

3)

ValueComment
0not specified
1asset
2periodic allocation
3autocoding
4supplier
5customer

Post method : /api/ledger/register-customer-payment

This method creates a customer payment

InputfieldDatatypeSizeComment
serieString8Ledgerserie
invoiceNumberIntInvoicenumber
amountNumeric28,8Amount
foramountNumeric28,8Foreign amount
feeNumeric28,8Invoice fee in foreign amount, including tax
bookdateDateTimeAccounting date
modeOfPaymentString8Mod of payment
ibanString34International Bank Account Number
currencyString3Currency
FieldDatatypeSizeComment
voucherSerieStringVoucher serie
voucherNumberIntVoucher number
voucherRows:
accountString6Account
currencyString3Currency
amountDecimal28,8Amount
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
Ledgers:
typeInt1)
currencyString3Currency
invoiceNumberIntInvoicenumber
invoiceSerrieStringLedgerserie
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount

1)

ValueComment
1invoice, customer invoice
2credit, customer invoice
3interest invoice, customer invoice
4interest credit, customer invoice
5on account, customer invoice
6advance, customer invoice
10final payment, customer invoice
11partial payment, customer invoice
12difference, customer invoice
13cash discount, customer invoice
14fee, customer invoice
15matching, customer invoice
16currency profit, customer invoice
17currency loss, customer invoice

Post method : /api/ledger/register-supplier-payment

This method creates a supplier payment

InputfieldDatatypeSizeComment
serieString8Ledgerserie
invoiceNumberIntInvoicenumber
amountNumeric28,8Amount
foramountNumeric28,8Foreign amount
feeNumeric28,8Invoice fee in foreign amount, including tax
bookdateDateTimeAccounting date
modeOfPaymentString8Mod of payment
ibanString34International Bank Account Number
currencyString3Currency
sequenceIntSequential number. The header record always has number 0, sub-records have numbers in range: 1 – 255.
FieldDatatypeSizeComment
voucherSerieStringVoucher serie
voucherNumberIntVoucher number
voucherRows:
accountString6Account
currencyString3Currency
amountDecimal28,8Amount
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
Ledgers:
typeInt1)
currencyString3Currency
invoiceNumberIntInvoicenumber
invoiceSerrieStringLedgerserie
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount

1)

ValueComment
-1Invoice
-2Credit
-3On account
-4Advance
-10Final payment
-11Partial payment
-12Difference
-13Cash discount
-14Matching
-15Currency profit
-16Currency loss

LedgerSerie

Get method : /api/ledgerserie

This method will return a list of all ledger series

FieldDatatypeSizeComment
typeShort1)
nextNoIntNext number
newNoIntNew number after the swap date
enumeratorIdString8Id
lockedByte2)
freeUseByte3)
lockedByString255User who locked the serie
cidString8Business unit that uses the serie. NULL in case the serie is used by all business units
descriptionString30Description
swapDateDatetimeDate when to switch to new number

1)

ValueComment
1for sales ledgers and invoicing
-1for supplier ledgers

2)

ValueComment
0enumeration serie is not locked
1enumeration serie is locked

3)

ValueComment
0only one user can use the serie
1many users can use the serie

Get method : /api/ledgerserie/{businessUnitId}

This method will return a list of ledger series filtered by business unit

InputfieldDatatypeSizeComment
businessUnitIdString8Companyid
FieldDatatypeSizeComment
typeShort1)
nextNoIntNext number
newNoIntNew number after the swap date
enumeratorIdString8Id
lockedByte2)
freeUseByte3)
lockedByString255User who locked the serie
cidString8Business unit that uses the serie. NULL in case the serie is used by all business units
descriptionString30Description
swapDateDatetimeDate when to switch to new number

1)

ValueComment
1for sales ledgers and invoicing
-1for supplier ledgers

2)

ValueComment
0enumeration serie is not locked
1enumeration serie is locked

3)

ValueComment
0only one user can use the serie
1many users can use the serie

Misc

Get method : /api/misc/get-labels

This method will return a list of labels. Used for accountclasses and accountgroups

FieldDatatypeSizeComment
labelNoString4Label id
labelCaptionString80Name

Get method : /api/misc/get-imsettings

This method will return a list of DCE settings

FieldDatatypeSizeComment
idString20Settings id
valueString 200 Setting

Get method : /api/misc/get-controlsettings

This method will return Control settings

FieldDatatypeSizeComment
defaultCompanyString8Default company
baseCurrencyString3Domestic currency
countryCodeString8Country code
amountPrecisionByteNumber of digits after the amounts
exchangePrecisionByteNumber of digits after the exchange rates
numberPrecisionByteNumber of digits after the numbers
customerDifferenceNumeric28,8Minimum difference in amounts for customer invoice to be considered fully
paid
supplierDifferenceNumeric28,8Minimum difference in amounts for supplier ledger to be considered fully paid

Get method : /api/misc/get-coderelations

This method returns a list of coderelations

FieldDatatypeSizeComment
cidString8The company the rule applies to
accountString6Rule applies to this selection of accounts
o1String4096Rule applies to this selection of objects of type 1
o2String4096Rule applies to this selection of objects of type 2
o3String4096Rule applies to this selection of objects of type 3
o4String4096Rule applies to this selection of objects of type 4
o5String4096Rule applies to this selection of objects of type 5
o6String4096Rule applies to this selection of objects of type 6
o7String4096Rule applies to this selection of objects of type 7
o8String4096Rule applies to this selection of objects of type 8
lockedByte0 – allowed combination, 1 – locked combination
fromdateDatetimeRule applies from this date
todateDatetimeRule applies up to this date
errortextString255Message to be shown when the locked combination is invoked

Get method : /api/misc/get-calendar

This method returns a list of calendar items. The calendar is used to list the days that can’t be used as

banking days

FieldDatatypeSizeComment
yearShortCalendar year
monthByteMounth
DayShortDay
NameString100Name of the holiday

Get method : /api/tenant/abbreviation

This method returns the tenant abbreviation

FieldDatatypeSizeComment
StringTenant abbreviation

Note

Get method : /api/note/supplier/{supplierid}

This method returns a list of notes for the specified supplierid

InputfieldDatatypeSizeComment
supplieridString12Supplier id
FieldDatatypeSizeComment
notetypeShort20Type of note. Refers to user groups of group type “NOTES”
noteobjectString15Object to which the note belongs
notenameString8Note’s name
notedateDatetimeDate of note
noteStringmaxNote text

Post method : /api/note/supplier/{supplierid}

This method creates a note for the specified supplierid

InputfieldDatatypeSizeComment
supplieridString12Supplier id

Request body

Delete method : /api/note/{noteid}/supplier/{supplierid}

This method deletes a note for the specified supplierid

InputfieldDatatypeSizeComment
supplieridString12Supplier id
noteidString8Note’s name

Object

Get method : /api/object/get-objects

This method returns a list of objects

InputfieldDatatypeComment
noIntObject type. 1 – 8
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
noByteObject type. 1 – 8
nameString30Object name
objectIdString64Object id
businessUnitString8Company. Can be null
userGroup1String64Free group of group type OBJECT{no}-1
userGroup2String64Free group of group type OBJECT{no}-2
userGroup3String64Free group of group type OBJECT{no}-3
userGroup4String64Free group of group type OBJECT{no}-4
userGroup5String64Free group of group type OBJECT{no}-5
userGroup6String64Free group of group type OBJECT{no}-6
userGroup7String64Free group of group type OBJECT{no}-7
userGroup8String64Free group of group type OBJECT{no}-8
userGroup9String64Free group of group type OBJECT{no}-9
userGroup10String64Free group of group type OBJECT{no}-10
userGroup11String64Free group of group type OBJECT{no}-11
userGroup12String64Free group of group type OBJECT{no}-12
userGroup13String64Free group of group type OBJECT{no}-13
userGroup14String64Free group of group type OBJECT{no}-14
userGroup15String64Free group of group type OBJECT{no}-15
userGroup16String64Free group of group type OBJECT{no}-16
userGroup17String64Free group of group type OBJECT{no}-17
userGroup18String64Free group of group type OBJECT{no}-18
userGroup19String64Free group of group type OBJECT{no}-19
userGroup20String64Free group of group type OBJECT{no}-20
o1String64Standard object of type 1
o2String64Standard object of type 2
o3String64Standard object of type 3
o4String64Standard object of type 4
o5String64Standard object of type 5
o6String64Standard object of type 6
o7String64Standard object of type 7
o8String64Standard object of type 8
objectBeginDatetimeValid from date
objectEndDatetimeValid to date
balancedByte0 – object is not balanced, 1 – object is balanced
balancedDirectByte0 – object is not directly balanced, 1 – object is directly balanced
actionDatetimeChange date
o1RelationInt1)
o2RelationInt1)
o3RelationInt1)
o4RelationInt1)
o5RelationInt1)
o6RelationInt1)
o7RelationInt1)
o8Relationint1)
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1) 119

ValueComment
00 – object can never be used with objects of type 1.
11 – object can be used with objects of type 1.
22 – object must be used with objects of type 1.

Get method : /api/object/get-object-by-id

This method returns an object

InputfieldDatatypeSizeComment
noIntObject id
objectNameString30Object name
FieldDatatypeSizeComment
noIntObject type. 1 – 8
nameString30Object name
objectIdString64Object id
businessUnitString8Company. Can be null
userGroup1String64Free group of group type OBJECT{no}-1
userGroup2String64Free group of group type OBJECT{no}-2
userGroup3String64Free group of group type OBJECT{no}-3
userGroup4String64Free group of group type OBJECT{no}-4
userGroup5String64Free group of group type OBJECT{no}-5
userGroup6String64Free group of group type OBJECT{no}-6
userGroup7String64Free group of group type OBJECT{no}-7
userGroup8String64Free group of group type OBJECT{no}-8
userGroup9String64Free group of group type OBJECT{no}-9
userGroup10String64Free group of group type OBJECT{no}-10
userGroup11String64Free group of group type OBJECT{no}-11
userGroup12String64Free group of group type OBJECT{no}-12
userGroup13String64Free group of group type OBJECT{no}-13
userGroup14String64Free group of group type OBJECT{no}-14
userGroup15String64Free group of group type OBJECT{no}-15
userGroup16String64Free group of group type OBJECT{no}-16
userGroup17String64Free group of group type OBJECT{no}-17
userGroup18String64Free group of group type OBJECT{no}-18
userGroup19String64Free group of group type OBJECT{no}-19
userGroup20String64Free group of group type OBJECT{no}-20
o1String64Standard object of type 1
o2String64Standard object of type 2
o3String64Standard object of type 3
o4String64Standard object of type 4
o5String64Standard object of type 5
o6String64Standard object of type 6
o7String64Standard object of type 7
o8String64Standard object of type 8
objectBeginDatetimeValid from date
objectEndDatetimeValid to date
balancedByte0 – object is not balanced, 1 – object is balanced
balancedDirectByte0 – object is not directly balanced, 1 – object is directly balanced
actionDatetimeChange date
o1RelationInt1)
o2RelationInt1)
o3RelationInt1)
o4RelationInt1)
o5RelationInt1)
o6RelationInt1)
o7RelationInt1)
o8Relationint1)

1)

ValueComment
00 – object can never be used with objects of type 1.
11 – object can be used with objects of type 1.
22 – object must be used with objects of type 1.

Get method : /api/object/get-types

This method returns a list of objecttypes

FieldDatatypeSizeComment
noIntObject type. 1 – 8
projectInt1)
containerInt2)
nameString10Object type name

1)

ValueComment
0If objects are to be used as expense objects
1If objects are to be used as project objects

2)

ValueComment
0if objects are not included in balancing (container.o{1-8})
1if objects are included in balancing (container.o{1-8})

Get method : /api/object/get-objects-by-date

This method returns a list of objects

InputfieldDatatypeComment
startDateDatetimeObject startdate
endDateDatetimeObject enddate
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
noIntObject type. 1 – 8
nameString30Object name
objectIdString64Object id
businessUnitString8Company. Can be null
userGroup1String64Free group of group type OBJECT{no}-1
userGroup2String64Free group of group type OBJECT{no}-2
userGroup3String64Free group of group type OBJECT{no}-3
userGroup4String64Free group of group type OBJECT{no}-4
userGroup5String64Free group of group type OBJECT{no}-5
userGroup6String64Free group of group type OBJECT{no}-6
userGroup7String64Free group of group type OBJECT{no}-7
userGroup8String64Free group of group type OBJECT{no}-8
userGroup9String64Free group of group type OBJECT{no}-9
userGroup10String64Free group of group type OBJECT{no}-10
userGroup11String64Free group of group type OBJECT{no}-11
userGroup12String64Free group of group type OBJECT{no}-12
userGroup13String64Free group of group type OBJECT{no}-13
userGroup14String64Free group of group type OBJECT{no}-14
userGroup15String64Free group of group type OBJECT{no}-15
userGroup16String64Free group of group type OBJECT{no}-16
userGroup17String64Free group of group type OBJECT{no}-17
userGroup18String64Free group of group type OBJECT{no}-18
userGroup19String64Free group of group type OBJECT{no}-19
userGroup20String64Free group of group type OBJECT{no}-20
o1String64Standard object of type 1
o2String64Standard object of type 2
o3String64Standard object of type 3
o4String64Standard object of type 4
o5String64Standard object of type 5
o6String64Standard object of type 6
o7String64Standard object of type 7
o8String64Standard object of type 8
objectBeginDatetimeValid from date
objectEndDatetimeValid to date
balancedByte0 – object is not balanced, 1 – object is balanced
balancedDirectByte0 – object is not directly balanced, 1 – object is directly balanced
actionDatetimeChange date
o1RelationInt1)
o2RelationInt1)
o3RelationInt1)
o4RelationInt1)
o5RelationInt1)
o6RelationInt1)
o7RelationInt1)
o8Relationint1)
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

ValueComment
00 – object can never be used with objects of type 1.
11 – object can be used with objects of type 1.
22 – object must be used with objects of type 1.

Get method : /api/object/get-objects-by-changedate

This method returns a list of objects

InputfieldDatatypeComment
changeDateDatetimeObject startdate
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
noIntObject type. 1 – 8
nameString30Object name
objectIdString64Object id
businessUnitString8Company. Can be null
userGroup1String64Free group of group type OBJECT{no}-1
userGroup2String64Free group of group type OBJECT{no}-2
userGroup3String64Free group of group type OBJECT{no}-3
userGroup4String64Free group of group type OBJECT{no}-4
userGroup5String64Free group of group type OBJECT{no}-5
userGroup6String64Free group of group type OBJECT{no}-6
userGroup7String64Free group of group type OBJECT{no}-7
userGroup8String64Free group of group type OBJECT{no}-8
userGroup9String64Free group of group type OBJECT{no}-9
userGroup10String64Free group of group type OBJECT{no}-10
userGroup11String64Free group of group type OBJECT{no}-11
userGroup12String64Free group of group type OBJECT{no}-12
userGroup13String64Free group of group type OBJECT{no}-13
userGroup14String64Free group of group type OBJECT{no}-14
userGroup15String64Free group of group type OBJECT{no}-15
userGroup16String64Free group of group type OBJECT{no}-16
userGroup17String64Free group of group type OBJECT{no}-17
userGroup18String64Free group of group type OBJECT{no}-18
userGroup19String64Free group of group type OBJECT{no}-19
userGroup20String64Free group of group type OBJECT{no}-20
o1String64Standard object of type 1
o2String64Standard object of type 2
o3String64Standard object of type 3
o4String64Standard object of type 4
o5String64Standard object of type 5
o6String64Standard object of type 6
o7String64Standard object of type 7
o8String64Standard object of type 8
objectBeginDatetimeValid from date
objectEndDatetimeValid to date
balancedByte0 – object is not balanced, 1 – object is balanced
balancedDirectByte0 – object is not directly balanced, 1 – object is directly balanced
actionDatetimeChange date
o1RelationInt1)
o2RelationInt1)
o3RelationInt1)
o4RelationInt1)
o5RelationInt1)
o6RelationInt1)
o7RelationInt1)
o8Relationint1)
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

ValueComment
00 – object can never be used with objects of type 1.
11 – object can be used with objects of type 1.
22 – object must be used with objects of type 1.

Post method: /api/object/create-update-object

This method creates or updates an object. Provide all the values if this method is used for updating

an object

InputfieldDatatypeSizeComment
noIntObject type. 1 – 8
nameString30Object name
objectIdString64Object id
businessUnitString8Company. Can be null
userGroup1String64Free group of group type OBJECT{no}-1
userGroup2String64Free group of group type OBJECT{no}-2
userGroup3String64Free group of group type OBJECT{no}-3
userGroup4String64Free group of group type OBJECT{no}-4
userGroup5String64Free group of group type OBJECT{no}-5
userGroup6String64Free group of group type OBJECT{no}-6
userGroup7String64Free group of group type OBJECT{no}-7
userGroup8String64Free group of group type OBJECT{no}-8
userGroup9String64Free group of group type OBJECT{no}-9
userGroup10String64Free group of group type OBJECT{no}-10
userGroup11String64Free group of group type OBJECT{no}-11
userGroup12String64Free group of group type OBJECT{no}-12
userGroup13String64Free group of group type OBJECT{no}-13
userGroup14String64Free group of group type OBJECT{no}-14
userGroup15String64Free group of group type OBJECT{no}-15
userGroup16String64Free group of group type OBJECT{no}-16
userGroup17String64Free group of group type OBJECT{no}-17
userGroup18String64Free group of group type OBJECT{no}-18
userGroup19String64Free group of group type OBJECT{no}-19
userGroup20String64Free group of group type OBJECT{no}-20
objectBeginDatetimeValid from date
objectEndDatetimeValid to date
balancedByte0 – object is not balanced, 1 – object is balanced
balancedDirectByte0 – object is not directly balanced, 1 – object is directly balanced
o1String64Standard object of type 1
o2String64Standard object of type 2
o3String64Standard object of type 3
o4String64Standard object of type 4
o5String64Standard object of type 5
o6String64Standard object of type 6
o7String64Standard object of type 7
o8String64Standard object of type 8
o1RelationInt1)
o2RelationInt1)
o3RelationInt1)
o4RelationInt1)
o5RelationInt1)
o6RelationInt1)
o7RelationInt1)
o8Relationint1)

1)

ValueComment
00 – object can never be used with objects of type 1.
11 – object can be used with objects of type 1.
22 – object must be used with objects of type 1.

Patch method: /api/object/{objno}/{objId}

This method will update an object

InputfieldDatatypeSizeComment
objNoIntObject type. 1 – 8
objIdString64Object Id

The following fields can be used

FieldDatatypeSizeComment
cidString8Company. Can be null
nameString30Object name
usergroup1String64Free group of group type OBJECT{no}-1
usergroup2String64Free group of group type OBJECT{no}-2
usergroup3String64Free group of group type OBJECT{no}-3
usergroup4String64Free group of group type OBJECT{no}-4
usergroup5String64Free group of group type OBJECT{no}-5
usergroup6String64Free group of group type OBJECT{no}-6
usergroup7String64Free group of group type OBJECT{no}-7
usergroup8String64Free group of group type OBJECT{no}-8
usergroup9String64Free group of group type OBJECT{no}-9
usergroup10String64Free group of group type OBJECT{no}-10
usergroup11String64Free group of group type OBJECT{no}-11
usergroup12String64Free group of group type OBJECT{no}-12
usergroup13String64Free group of group type OBJECT{no}-13
usergroup14String64Free group of group type OBJECT{no}-14
usergroup15String64Free group of group type OBJECT{no}-15
usergroup16String64Free group of group type OBJECT{no}-16
usergroup17String64Free group of group type OBJECT{no}-17
usergroup18String64Free group of group type OBJECT{no}-18
usergroup19String64Free group of group type OBJECT{no}-19
usergroup20String64Free group of group type OBJECT{no}-20
objectbeginDatetimeValid from date
objectendDatetimeValid to date
BalancedByte0 – object is not balanced, 1 – object is balanced
balanceddirectByte0 – object is not directly balanced, 1 – object is directly balanced

Request body

Period

Get method : /api/period/get-years

This method returns a list of years and numbers of periods

FieldDatatypeSizeComment
yearnoShortYear id (index). First year’s index is 1
periodbeginDatetimeStart date of period
periodendDatetimeEnd date of period
lockedByte0 – period is unlocked, 1 – period is locked
NameString8Period name

Get method : /api/period/get-periods

This method returns a list of period information

FieldDatatypeSizeComment
yearnoShortYear id (index). First year’s index is 1
period1BytePeriod number. (0 – for the whole financial year record)
periodbeginDatetimeStart date of period
periodendDatetimeEnd date of period
lockedByte0 – period is unlocked, 1 – period is locked
nameString8Period name

PeriodAllocation

Get method : /api/periodallocation/get-periodallocation

This method returns a periodic allocation

InputfieldDatatypeComment
periodAllocationIdIntPeriod allocation id
FieldDatatypeSizeComment
businessUnitString8Company
enumeratorIntInternal batch number to identify the periodic allocation
describeString30Description
baseAccountString6Base account
startDateDatetimeStart date
endDateDatetimeEnd date
accountStringAccount
amountDecimal28,8Amount for allocation
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
currencyString3Currency
o1String64Object of objkect type 1
o2String64Object of objkect type 2
o3String64Object of objkect type 3
o4String64Object of objkect type 4
o5String64Object of objkect type 5
o6String64Object of objkect type 6
o7String64Object of objkect type 7
o8String64Object of objkect type 8
xFreeTextString30Free text
periodicRows
businessUnitString8Company
enumeratorIntInternal batch number to identify the periodic allocation
yearShortYear
periodBytePeriod
amountDecimal28,8Allocated amount
foramountDecimal28,8Allocated foreign amount
numberDecimal28,8Allocated number
doneByte0 – allocation is not yet done, 1 – allocation is done

Get method : /api/periodallocation/{businessUnitId}/{page}

This method returns the periodic allocation list for a business unit with pagination

InputfieldDatatypeSizeComment
businessUnitIdString8Company
page intPage to get. Default page is 0
FieldDatatypeSizeComment
businessUnitString8Company
enumeratorIntInternal batch number to identify the periodic allocation
describeString30Description
baseAccountString6Base account
startDateDatetimeStart date
endDateDatetimeEnd date
accountStringAccount
amountDecimal28,8Amount for allocation
foramountDecimal28,8Foreign amount
numberDecimal28,8Number
currencyString3Currency
o1String64Object of objkect type 1
o2String64Object of objkect type 2
o3String64Object of objkect type 3
o4String64Object of objkect type 4
o5String64Object of objkect type 5
o6String64Object of objkect type 6
o7String64Object of objkect type 7
o8String64Object of objkect type 8
xFreeTextString30Free text
periodicRows
businessUnitString8Company
enumeratorIntInternal batch number to identify the periodic allocation
yearShortYear
periodBytePeriod
amountDecimal28,8Allocated amount
foramountDecimal28,8Allocated foreign amount
numberDecimal28,8Allocated number
doneByte0 – allocation is not yet done, 1 – allocation is done
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch
totalNumberOfRecordsString

Person

Get method : /api/person/get-customers

This method returns a list of customers

InputfieldDatatypeComment
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProperty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Get method : /api/person/get-customers-by-changedate

This method returns a list of customers

InputfieldDatatypeComment
changedateDatetimeChange date greater or equal
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Get method : /api/person/get-suppliers

This method returns a list of suppliers

InputfieldDatatypeComment
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Get method : /api/person/get-suppliers-by-changedate

This method returns a list of suppliers

InputfieldDatatypeComment
changedateDatetimeChange date greater or equal
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
pageNumberIntPage to fetch. First page = 0
isCompleteBoolTrue – more pages to fetch

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Get method : /api/person/get-addresses

This method returns a list of addresses

InputfieldDatatypeComment
typeInt-1 – supplier, 1 – customer
FieldDatatypeSizeComment
typeInt-1 – supplier, 1 – customer
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Webaddress
emailString255e-mail address
uacIntUser Access Code

Get method : /api/person/get-address

This method returns a list of addresses

InputfieldDatatypeSizeComment
ownerString12Supplier/Customer Id
typeIntType. -1 – supplier, 1 – customer
FieldDatatypeSizeComment
typeInt-1 – supplier, 1 – customer
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Webaddress
emailString255e-mail address
uacIntUser Access Code

Get method : /api/person/get-customer-additionaldata-by-id

This method returns a customer with address, payment terms and contacts

InputfieldDatatypeSizeComment
customerIdString12Customer id
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
address:
typeInt-1 – supplier, 1 – customer
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
uacIntUser Access Code
daysShortNumber of days before the due date
contacts:
idString8Contact id
ownerString12Owner of the contact. Refers to person.id
typeShortOwner type. -1 – supplier / 1 – customer
nameString30Name of contact
titleString15Title
phone1String30First number
phone2String30Second number
wwwString255Webaddress
emailString255e-mail address

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Get method : /api/person/get-suppliers-additionaldata

This method returns a supplier with address, payment terms, contacts and banks

InputfieldDatatypeComment
changedateDatetimeChange date greater or equal
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
address:
typeInt-1 – supplier, 1 – customer
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
uacIntUser Access Code
daysShortNumber of days before the due date
contacts:
idString8Contact id
ownerString12Owner of the contact. Refers to person.id
typeShortOwner type. -1 – supplier / 1 – customer
nameString30Name of contact
titleString15Title
phone1String30First number
phone2String30Second number
wwwString255Webaddress
emailString255e-mail address
banks:
idString8Bank id
typeShort-1 – supplier, 0 – company
mopString8Mode of payment
ownerString12Bank owner id.
bankTypeString8Type of group BANKTYPE
numberString40Account number
swiftString30Swift address
clearingString30Clearing number
bankNameString30Bank name
freeTextString255Free text
address1String40First address
address2String40Second address
address3String40Third address
address4String40Fourth address
group1String64Group of group type BANK1
group2String64Group of group type BANK2
group3String64Group of group type BANK3
group4String64Group of group type BANK4
defBankInt0 – not a default bank, 1 – default bank
paymentaccountString6Account. This account is used for payment with Autopay
currencyString3currency
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Get method : /api/person/get-supplier-additionaldata-by-id

This method returns a supplier with address, payment terms, contacts and banks

InputfieldDatatypeSizeComment
supplierIdString12Id of supplier
FieldDatatypeSizeComment
typeShortPerson type, 1 – customer, -1 – supplier
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
address:
typeInt-1 – supplier, 1 – customer
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
uacIntUser Access Code
daysIntNumber of days before the due date
contacts:
idString8Contact id
ownerString12Owner of the contact. Refers to person.id
typeShortOwner type. -1 – supplier / 1 – customer
nameString30Name of contact
titleString15Title
phone1String30First number
phone2String30Second number
wwwString255Webaddress
emailString255e-mail address
banks:
idString8Bank id
typeShort-1 – supplier, 0 – company
mopString8Mode of payment
ownerString12Bank owner id.
bankTypeString8Type of group BANKTYPE
numberString40Account number
swiftString30Swift address
clearingString30Clearing number
bankNameString30Bank name
freeTextString255Free text
address1String40First address
address2String40Second address
address3String40Third address
address4String40Fourth address
group1String64Group of group type BANK1
group2String64Group of group type BANK2
group3String64Group of group type BANK3
group4String64Group of group type BANK4
defBankInt0 – not a default bank, 1 – default bank
paymentaccountString6Account. This account is used for payment with Autopay
currencyString3currency

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template

Post method : /api/person/create-customer

This method creates a customer

InputfieldDatatypeSizeComment
customer:
typeShort1
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
address:
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
deliveryaddress:
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
contact:
idString8Contact id
ownerString12Owner of the contact. Refers to person.id
typeShortOwner type. -1 – supplier / 1 – customer
nameString30Name of contact
titleString15Title
phone1String30First number
phone2String30Second number
wwwString255Webaddress
emailString255e-mail address
eInvoiceIdStringNot used yet

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template
FieldDatatypeComment
SuccessBooltrue – succesful, false – not succesful
ResultInt
errorMessageStringErrormessage

Patch method : /api/customer/{custid} This method will update a customer.

InputfieldDatatypeSizeComment
custidString12Person id

The fields that can be updated can be found in endpoint Post method : /api/person/create-customer in section “customer” Request body 153

Patch method : /api/supplier/{supplierid} This method will update a supplier.

InputfieldDatatypeSizeComment
supplieridString12Person id

The fields that can be updated can be found in endpoint Post method : /api/person/create-supplier in section “supplier” Request body 154

Post method : /api/person/create-supplier

This method creates a supplier

InputfieldDatatypeSizeComment
customer:
typeShort-1
idString12Person id
globaltypeByte1)
internaltypeByte2)
createdDatetimeDate of creation
changedDatetimeDate of last modification
noclaimByteSet to 1 if reminders should not be generated
nointerestByteSet to 1 if interests should not be calculated
blockedByteSet to 1 if the customer/supplier is blocked
statementByteSet to 1 for the account statement
creditlimitDecimal28,8Credit limit
creditlimitoffDecimal28,8Allowed overdraft for credit limit
extradaysShortWait days after the due date within which the invoice can still be paid
fixedexchangeByteSet to 1 if fixed exchange should be used for payments
disabledByteSet to 1 if customer/supplier should not be used
ignoreorginvnoByteSetting for original invoice number
glnString40Global Location Number
propIntProerty bitmask
uacIntUser Access Code
totalsaldoDecimal28,8Total balance
pricelistBytePrice list that should be used
invdiscountDecimal28,8Invoice discount
accounttypeByteAccount that should be used for invoicing
groupinvoiceByteSet to 1 if summary invoice is to be used
invoicefeeDecimal28,8Invoice fee
extrafeeDecimal28,8Administration fee
usefeeByteSet to 1 if local invoice fee should be used
useextrafeeByteSet to 1 if administration fee should be used
useintfeeByteSet to 1 if local interest fee shoud be used
intfeeDecimal28,8Interest fee
useremfeeByteSet to 1 if reminder fee should be charged from customer
remfeeDecimal28,8Reminder fee
discountcolIntDiscount column for invoicing
modString8Method of delivery of group type MOD
todString8Terms of delivery of group type TOD
bankcodeString8Central bank code of group type BANKCODE
cashdiscountString8Default cash distount
interestString8Default interest procedure
payerByteSet to 1 if customer is a payer
defpayerString12Default payer
payeeByteSet to 1 if customer is a payee
defpayeeString12Default payee
receiveByteSet to 1 if customer is an invoice recipient
defreceiveString12Default invoice resipient
o1String8Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
currencyString3Currency
acctabrecString8Account receivable for customer / account payable for supplier
acctabsaleString8Sale account / purchase account
contactString8Default contact person
group1String64Group of type CUST1 or SUPP1
group2String64Group of type CUST2 or SUPP2
group3String64Group of type CUST3 or SUPP3
group4String64Group of type CUST4 or SUPP4
group5String64Group of type CUST5 or SUPP5
group6String64Group of type CUST6 or SUPP6
approval1String8Approval 1
approval2String8Approval 2
payformString8Payform of group type PAYFORM
feecodeString8Fee code of group type FEECODE
factoringString8Bank that is used for factoring
claimdateDatetimeLatest reminder date
intdateDatetimeLastes calculation of interest
creditresponseString8Credit administrator
actionDatetimeLatest action upon the customer/supplier
xtopString8Default terms of payment
mopString8Default mode of payment
claimString8Reminder code to create reminders for customer
responseString8Administrator
codeString30Customer / supplier code
countrycodeString8Country code of group type COUNTRY
languagecodeString8Language code of group type LANGID
nameString80Name of person
alphaString80Search name
vatnoString30VAT registration number
extraidString40Extra id
countrytypeString8Country type of group type CNTTYPE
numberofempoyeesStringNumber of employees
address:
idString12Customer/suppier id
sidString12Empty for main address, DLV for delivery address
lA1String40First long address
lA2String40Second long address
lA3String40Fhird long address
lA4String40Fourth long address
sA1String40First short address
sA2String40Second short address
sA3String40Fhird short address
sA4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
bank
idString8Bank id
typeShort-1
mopString8Mode of payment
ownerString12Bank owner id.
bankTypeString8Type of group BANKTYPE
numberString40Account number
swiftString30Swift address
clearingString30Clearing number
bankNameString30Bank name
freeTextString255Free text
address1String40First address
address2String40Second address
address3String40Third address
address4String40Fourth address
group1String64Group of group type BANK1
group2String64Group of group type BANK2
group3String64Group of group type BANK3
group4String64Group of group type BANK4
defBankInt0 – not a default bank, 1 – default bank
paymentaccountString6Account. This account is used for payment with Autopay
currencyString3currency

1)

ValueComment
0external customer/supplier
1concern customer/supplier
2internal customer/supplier

2)

ValueComment
0ordinary customer/supplier
1prospect
2template
FieldDatatypeComment
successBooltrue – succesful, false – not succesful
resultInt
errorMessageStringErrormessage

Delete method : /api/person/delete-supplier-bank

This method deletes a bank from a supplier

InputfieldDatatypeSizeComment
bankidString8The id of the bank
bankOwnerString12The owner of the bank
FieldDatatypeSizeComment
responseBoolTrue/False

Patch method: /api/address/{addressType}/customer/{custId}

This method will update a customer address. The following fields can be used

FieldDatatypeSizeComment
la1String40First long address
la2String40Second long address
la3String40Fhird long address
la4String40Fourth long address
sa1String40First short address
sa2String40Second short address
sa3String40Fhird short address
sa4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
InputfieldDatatypeSizeComment
addressTypeString3DLV, INV
custidString12Person id

Request body

Patch method: /api/address/supplier/{supplierId}

This method will update a supplier address. The following fields can be used

FieldDatatypeSizeComment
la1String40First long address
la2String40Second long address
la3String40Fhird long address
la4String40Fourth long address
sa1String40First short address
sa2String40Second short address
sa3String40Fhird short address
sa4String40Fourth short address
phone1String30First number
phone2String30Second number
phone3String30Fhird number
wwwString255Internet address
emailString255e-mail address
InputfieldDatatypeSizeComment
supplieridString12Person id

Request body

Patch method: /api/contact/{owner}/customer/{custId}

This method will update a customer contact. The following fields can be used

FieldDatatypeSizeComment
nameString30Name of contact
titleString15Title of contact
phone1String30First number
phone2String30Second number
wwwString255Internet address
emailString255e-mail address
InputfieldDatatypeSizeComment
ownerString12Owner of the contact
supplieridString12Person id

Request body

Patch method: /api/contact/{owner}/supplier/{supplierId}

This method will update a supplier contact. The following fields can be used

FieldDatatypeSizeComment
nameString30Name of contact
titleString15Title of contact
phone1String30First number
phone2String30Second number
wwwString255Internet address
emailString255e-mail address
InputfieldDatatypeSizeComment
ownerString12Owner of the contact
supplieridString12Supplier id

Request body

Patch method: /api/bank/{bankId}/supplier/{supplierId}

This method will update a supplier bank. The following fields can be used

FieldDatatypeSizeComment
mopString8Mode of payment
banktypeShortBank type of group “BANKTYPE”.
numberString40Account number
swiftString30Swift address
clearingString30Clearing number
banknameString30Bank name
address1String40First address
address2String40Second address
address3String40Third address
address4String40Fourth address
xfreetextString255Free text
group1String64Group of group type BANK1
group2String64Group of group type BANK2
group3String64Group of group type BANK3
group4String64Group of group type BANK4
defbankByte0 – not a default bank, 1 – default bank
InputfieldDatatypeSizeComment
bankidString8Bank ID
supplieridString12Bank owner ID

Request body

Patch method: /api/bank/{bankId}/businessunit/{businessunitId}

This method will update a supplier bank. The following fields can be used

FieldDatatypeSizeComment
mopString8Mode of payment
banktypeShortBank type of group “BANKTYPE”.
numberString40Account number
swiftString30Swift address
clearingString30Clearing number
banknameString30Bank name
address1String40First address
address2String40Second address
address3String40Third address
address4String40Fourth address
xfreetextString255Free text
group1String64Group of group type BANK1
group2String64Group of group type BANK2
group3String64Group of group type BANK3
group4String64Group of group type BANK4
defbankByte0 – not a default bank, 1 – default bank
InputfieldDatatypeSizeComment
bankidString8Bank ID
businessunitString12Bank owner ID

Request body

StorageSpace

Get method : /api/storage/control

This method returns the list of Control storages associated with the current tenant

FieldDatatypeSizeComment
databaseNameStringName of database
storageSpaceIdStringDatabase Id

Get method : /api/storage/control/{userId}

This method returns the list of Control storages associated with the specified userId

InputfieldDatatypeSizeComment
useridStringUserid from Connect
FieldDatatypeSizeComment
databaseNameStringName of database
storageSpaceIdStringDatabase Id

TermsOfPayment

Get method : /api/termsofpayment/{id}

This method returns terms of payment based on Id

InputfieldDatatypeSizeComment
idString8Terms of payment id
FieldDatatypeSizeComment
idString8Term of payment id.
descriptionString30Description.
langtextString8Language dependent text id. Refers to languagetext id.
daysIntNumbers of days before the due date.
intdaysIntNumbers of days before the interest starts being calculated.
daysinterestIntNumber of days before the due date for interast invoices.
freemonthInt0 = not freemonth, 1 = free month.

Post method : /api/termsofpayment

This method creates terms of payment

InputfieldDatatypeSizeComment
idString8Terms of payment id
descriptionString30Description.
langtextString8Language dependent text id. Refers to languagetext id.
daysIntNumbers of days before the due date.
intdaysIntNumbers of days before the interest starts being calculated.
daysinterestIntNumber of days before the due date for interast invoices.
freemonthInt0 = not freemonth, 1 = free month.

UserGroup

Get method : /api/usergroup/get-usergroups

This method returns a list of usergroups

InputfieldDatatypeSizeComment
pageIntPage to get. Default page is 0
FieldDatatypeSizeComment
typenameString10Group type
groupnameString8Group id
groupdescString20Description
textString80Free text
uacIntUser Access Code
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

Get method : /api/usergroup/{typename}/{groupname}

This method returns a usergroup based on typename and groupname

InputfieldDatatypeSizeComment
typenameString10Group type
groupnameString20Group id
FieldDatatypeSizeComment
typenameString10Group type
groupnameString8Group id
groupdescString20Description
textString80Free text
uacIntUser Access Code

Put method : /api/usergroup/{typename}/{groupname}

This method edits an user group based on typename and groupname. Request body is the data to be

saved

InputfieldDatatypeSizeComment
typenameString10Group type
groupnameString20Group id
Request body
typenameString10Group type
groupnameString8Group id
groupdescString20Description
textString80Free text
FieldDatatypeSizeComment
entityIdString
entityTypeString

Get method : /api/usergroup/get-usergroupbytype

This method returns a user group

InputfieldDatatypeSizeComment
typenameString10Group type
FieldDatatypeSizeComment
typenameString10Group type
groupnameString8Group id
uacIntUser Access Code
groupdescString20Description
textString80Free text

Post method : /api/usergroup

This method adds an user group

InputfieldDatatypeSizeComment
Request body
typenameString10Group type
groupnameString8Group id
groupdescString20Description
textString80Free text
FieldDatatypeSizeComment
entityIdString
entityTypeString

Voucher

Post method : /api/voucher/create-voucher

This method creates a voucher

InputfieldDatatypeSizeComment
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeIntLedger type
enumeratorString8Invoice serie
invnoIntInvoive number
voucherDateDatetimeVoucher date
useridString30User id
userGroup1String128Group type of type VOUCHER1
userGroup2String128Group type of type VOUCHER2
freeTextString80Free text
rows:
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Quantity
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of type VOUROW1
group2String64Free group of type VOUROW2
group3String64Free group of type VOUROW3
group4String64Free group of type VOUROW4
FieldDatatypeSizeComment
successBooltrue – succesful, false – not succesful
result:
businessUnitString8Company
SerieString8Voucher serie
vouNoIntVoucher number
TypeShortLedger type
enumeratorString8Invoice serie
InvnoIntInvoive number
voucherDateDatetimeVoucher date
UseridString30User id
userGroup1String8Group type of type VOUCHER1
userGroup2String8Group type of type VOUCHER2
freeTextString80Free text
rows:
businessUnitString8Company
vouNoIntVoucher number
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Number
freeTextString80Free text
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
alteredByte0 – no change, 1 – added row, 2 – deleted row
bookDateDatetimeAccounting date
serieString8Voucher serie
rowNoShortRow number
yearByteYear number
periodBytePeriod number
resaccountString6Profit/loss account if one of the objects is balanced
extraAmountDecimal28,8Extra amount
vatCodeShortVAT code
crTypeByte1)
creatorString30Creator
baseCurrencyString3Alternative currency
baseAmountDecimal28,8Amount in alternative currency
hasAttachmentBoolNot used here
errorMessageStringErrormessage if not successful

1)

ValueComment
0not specified
1asset
2periodic allocation
3autocoding
4supplier
5customer

Get method : /api/voucher/{voucherSerie}/{voucherNumber}/{year}

This method returns a voucher and it’s voucherrows

InputfieldDatatypeSizeComment
voucherSerieString8Voucher serie
voucherNumberIntVoucher number
yearIntYear
FieldDatatypeSizeComment
successBoolTrue/false
result:
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeshortLedger type
enumeratorString8Invoice serie
invnoIntInvoive number
voucherDateDatetimeVoucher date
updatedOnDatetimeDate when the voucher has been saved
useridString30User id
userGroup1String8Group type of type VOUCHER1
userGroup2String8Group type of type VOUCHER2
freeTextString80Free text
transferlogBoolNot use here
rows:
businessUnitString8Company
vouNoIntVoucher number
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Quantity
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of type VOUROW1
group2String64Free group of type VOUROW2
group3String64Free group of type VOUROW3
group4String64Free group of type VOUROW4
alteredByte1)
bookDateDatetimeBookingdate
serieString8Voucher serie
rowNoShortRow number starting with 0
yearShortYear
periodPeriod
resaccountString6Profit/loss account if one of the objects is balanced.
extraAmountNumeric28,8Extra amount
vatCodeShortVat code
crTypeByte2)
creatorString30Creator
baseCurrencyString3Alternative currency
baseAmountNumeric28,8Amount in alternative currency
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
errorMessageString
operionInt

1)

ValueComment
0No change
1Row added
2Row is deleted

2)

ValueComment
0not specified
1asset
2periodic allocation
3autocoding
4supplier
5customer

Get method : /api/voucher/get-voucherrows

This method returns a list of voucherrows

InputfieldDatatypeComment
dateDatetimeReturn rows created or updated on input date and after. (1)
pageIntPage to get. Default page is 0

(1)

Where voucher.voucounter >= date (voucounter is modification date – when voucher rows where

last changed)

FieldDatatypeSizeComment
businessUnitString8Company
vouNoIntVoucher number
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Number
freeTextString80Free text
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
alteredByte0 – no change, 1 – added row, 2 – deleted row
bookDateDatetimeAccounting date
serieString8Voucher serie
rowNoShortRow number
yearByteYear number
periodBytePeriod number
resaccountString6Profit/loss account if one of the objects is balanced
extraAmountNumeric28,8Extra amount
vatCodeShortVAT code
crTypeByte1)
creatorString30Creator
baseCurrencyString3Alternative currency
baseAmountDecimal28,8Amount in alternative currency
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0not specified
1asset
2periodic allocation
3autocoding
4supplier
5customer

Get method : /api/voucher/get-vouchers

This method returns a list of vouchers

InputfieldDatatypeComment
dateDatetimeReturn voucgers created or upated on input date and after. (1)
pageIntPage to get. Default page is 0

(1)

Where voucher.voucounter >= date (voucounter is modification date – when voucher rows where

last changed)

FieldDatatypeSizeComment
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeShortLedger type
enumeratorString8Invoice serie
invnoIntInvoive number
voucherDateDatetimeVoucher date
useridString30User id
userGroup1String8Group type of type VOUCHER1
userGroup2String8Group type of type VOUCHER2
freeTextString80Free text
yeaNoByteYear number
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

Get method : /api/voucher/get-voucher-by-dates

This method returns a list of vouchers

InputfieldDatatypeComment
bookingDateFromDatetimeStart date. (1)
bookingDateToDatetimeEnd date. (1)
pageIntPage to get. Default page is 0

(1)

Where voucher.date between bookingDateFrom and bookingDateTo

FieldDatatypeSizeComment
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeShortLedger type
enumeratorString8Invoice serie
invnoIntInvoive number
voucherDateDatetimeVoucher date
useridString30User id
userGroup1String128Group type of type VOUCHER1
userGroup2String128Group type of type VOUCHER2
freeTextString80Free text
yeaNoByteYear number
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

Get method : /api/voucher/get-voucherrow-by-dates

This method returns a list of voucherrows

InputfieldDatatypeComment
bookingDateFromDatetimeStart date. (1)
bookingDateToDatetimeEnd date, (1)
pageIntPage to get. Default page is 0

(1)

Where voucher.date between bookingDateFrom and bookingDateTo

FieldDatatypeSizeComment
businessUnitString8Company
vouNoIntVoucher number
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Number
freeTextString80Free text
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
alteredByte0 – no change, 1 – added row, 2 – deleted row
bookDateDatetimeAccounting date
serieString8Voucher serie
rowNoShortRow number
yearByteYear number
periodBytePeriod number
resaccountString6Profit/loss account if one of the objects is balanced
extraAmountDecimal28,8Extra amount
vatCodeShortVAT code
crTypeByte1)
creatorString30Creator
baseCurrencyString3Alternative currency
baseAmountDecimal28,8Amount in alternative currency
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch

1)

ValueComment
0not specified
1asset
2periodic allocation
3autocoding
4supplier
5customer

Post method : /api/voucher/voucherrows/filter

This method returns a list of voucherrows based on filter

Filter

InputDatatypeComment
filters:
fieldNameString1)
operatorEnum2)
valueString
secondValueString
pageIntPage to fetch. First page = 0

1) Field BusinessUnit Vouno Account Amount Foramount Currency Number O1 O2 O3 O4 O5 O6 O7 O8 2)

OperatorComment
EqualExact match
IncludeIn operation with comma-seperated values
BetweenRange between two values (requires secondvalue)
GreaterThanGreater than comparison
LessThanLess than comparison
FieldDatatypeSizeComment
list:
businessUnitString8Company
vouNoIntVoucher number
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Number
freeTextString80Free text
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of group type VOUROW1
group2String64Free group of group type VOUROW2
group3String64Free group of group type VOUROW3
group4String64Free group of group type VOUROW4
alteredByte0 – no change, 1 – added row, 2 – deleted row
bookDateDatetimeAccounting date
serieString8Voucher serie
rowNoShortRow number
yearByteYear number
periodBytePeriod number
resaccountString6Profit/loss account if one of the objects is balanced
extraAmountDecimal28,8Extra amount
vatCodeShortVAT code
crTypeByte1)
creatorString30Creator
baseCurrencyString3Alternative currency
baseAmountDecimal28,8Amount in alternative currency
hasAttachmentBoolTrue – has a saved attachment, false – has no attachment
pageNumberIntPage to fetch. First page = 0
isCompletedBoolTrue – more pages to fetch
totalNumberOfRecordsString

1)

ValueComment
0not specified
1asset
2periodic allocation
3autocoding
4supplier
5customer

VoucherLog

Get method : /api/voucherlog/get-voucherlog-by-Id

This method returns a voucher log

InputfieldDatatypeSizeComment
vounoIntVoucher number
serieString8Voucher serie
yearIntYear number
FieldDatatypeSizeComment
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
TypeshortLedger type
enumeratorString8Invoice serie
invnoIntInvoive number
voucherDateDatetimeVoucher date
useridString30User id
userGroup1String128Group type of type VOUCHER1
userGroup2String128Group type of type VOUCHER2
freeTextString80Free text
transferlogBoolNot use here
checkRuleByteNot used here
rows:
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal2838Quantity
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of type VOUROW1
group2String64Free group of type VOUROW2
group3String64Free group of type VOUROW3
group4String64Free group of type VOUROW4
vatCodeShortVat code

Post method : /api/voucherlog/create-voucherlog

This method creates a voucher log

InputfieldDatatypeSizeComment
businessUnitString8Company
serieString8Voucher serie
vouNoIntVoucher number
typeShortLedger type
enumeratorString8Invoice serie
invnoIntInvoive number
voucherDateDatetimeVoucher date
useridString30User id
userGroup1String128Group type of type VOUCHER1
userGroup2String128Group type of type VOUCHER2
freeTextString80Free text
transferlogBoolTrue – transfer, false – do not transfer
checkRuleByte0 – do not check rules on transfer, 1 – check rules on transfer
deleteaftertransferBoolFalse – No delete, True = delete after transfer
rows:
accountString6Account
amountDecimal28,8Amount
foramountDecimal28,8Foreign amount
currencyString3Currency
numberDecimal28,8Quantity
freeTextString80Freetext
o1String64Object of type 1
o2String64Object of type 2
o3String64Object of type 3
o4String64Object of type 4
o5String64Object of type 5
o6String64Object of type 6
o7String64Object of type 7
o8String64Object of type 8
group1String64Free group of type VOUROW1
group2String64Free group of type VOUROW2
group3String64Free group of type VOUROW3
group4String64Free group of type VOUROW4
vatCodeShortVat code
FieldDatatypeSizeComment
lognoIntLog number
logtypeShort1)
logdateDatetimeAccounting date
typeShortLedger type
invnoIntInvoice number
seqByteLedger sequential number
yearShortYear number
periodBytePeriod number
serieString8Voucher serie
packByteSet to 1 if identical rows should be bundled together
timestampTimestampTimestamp
vounoIntVoucher number
groupnoIntBatch number
xfreetextString80Free text
group1String128Group type of type VOUCHER1
group2String128Group type of type VOUCHER2
useridString30User id
enumeratorString8Invoice serie
cidString8Company
statusShort0 – voucherlog, 1 – transfered to voucher, 2 – error
userserieByteVoucher serie

1)

ValueComment
1user-defined
2accounting
3sales ledger
4supplier ledger
5external system
6arrival registration

Note:

  1. This method will create the voucherlog in one transaction and then after it’s imported try to

transfer the imported log. If the transfer of the log is not ok the log will still be created and a user can then correct and transfer manually.

  1. Do not send many logs at the same time, wait for the result and then send the next one.

180

VoucherSerie

Get method : /api/serie/get-series

This method returns a list of voucherseries

InputfieldDatatypeComment
yearnoIntYear number
FieldDatatypeSizeComment
nextnoIntNext number for voucher serie
disabledByte0 – if serie is not locked, 1 – 40 – period until serie is locked
dmyByte1)
freeuseByteSerie does not lock when it is being used
lockedByte0 – unlocked, 1 – locked
yearShortYear number
serie1String8Serie id
typeShortContainer to which vouchers with this serie are aggregated. Used only if dmy value is 3. If dmy is 0, vouchers are aggregated into container 9 (container.type)
nosaldoByte2)
uacIntUser Access Code
cidString8Company
describeString30Description
useridString30User who can use the voucher serie. NULL if the voucher serie can be used by all users
lockedbyString30User who locked the serie
usergroup1String64Free group of group type VOUCHER1
usergroup2String64Free group of group type VOUCHER2

1)

ValueComment
0serie for vouchers
1serie for templates
2serie for simulations
3serie for budget

2)

ValueComment
0vouchers of this serie must be balanced
1vouchers of this serie do not require balancing. Used only if dmy value is 3

Get method : /api/serie/get-userseries

This method returns a list of userseries

InputfieldDatatypeSizeComment
typeInt1 – voucher series, 2 – ledger/invoice series
companyString8Company
userNameString255User id. Login id
FieldDatatypeSizeComment
typeByte1 – voucher series, 2 – ledger/invoice series
companyString8Company
userNameString30User id. Login id
serie0String8Default voucher serie, or ledger serie for invoicing
serie1String8Voucher serie for invoicing, or ledger serie for sales ledgers
serie2String8Voucher serie for customer payments, or ledger serie for supplier ledgers
serie3String8Voucher serie for supplier payments, or ledger serie for interest invoices
serie4String8Voucher serie for arrival registrations
serie5String8Voucher serie for counter-bookings
serie6String8Voucher serie for offsetting balance for objects
serie7String8Voucher serie for periodic allocations
serie8String8Voucher serie for budget
serie9String8Voucher serie for sales ledgers
serie10String8Voucher serie for supplier ledgers
serie11String8Voucher serie for interests
serie12String8Voucher serie for depreciations

IM endpoints

This section describes endpoints for IM 183

CaseHistory

Get method : /api/case-history/{caseId}

This method retrieves the case history records for a specific case ID

InputfieldDatatypeSizeComment
caseIdIntUnique identifier of a case Id
FieldDatatypeSizeComment
caseIdIntUnique identifier of a case
eventTimeDatetimeTime at which the event happened
fromStepIdString255From step – id
toStepIdString255To step – Id
senderIdString255Sender Id
recipientIdString255Recipient Id

Get method : /api/case-history

This method retrieves paginated and filtered case history records

InputfieldDatatypeSizeComment
caseIdIntOptional: Filter by a specific CaseId
fromDateString255Optional: Start date for EventTime filter (e.g., YYYY-MM-DD)
toDateString255Optional: End date for EventTime filter (e.g., YYYY-MM-DD)
pageNumberIntThe current page number (1-based, default 1)
pageSizeIntThe number of records per page (default 1000)
FieldDatatypeSizeComment
data:
caseIdIntUnique identifier of a case Id
eventTimeDatetimeTime at which the event happened
fromStepIdString255From step - id
toStepIdString255To step - Id
senderIdString255Sender Id
recipientIdString255Recipient Id
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page.
True when the current page number is greater than or equal to TotalPages

Message

Get method : /api/messages

This method retrieves messages with optional filtering and pagination

InputfieldDatatypeSizeComment
CreatedAfterStringMessage created after date
MessageIdIntMessageId
PageNumberIntPage to fetch. First page = 1
PageSizeIntRows to fetch
FieldDatatypeSizeComment
data:
messageIdInt
rowNumberInt
messageTextString
creationDateDateTime
signatureString
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

RecurringTemplate

Get method : /api/recurring-templates

This method retrieves the recurring invoice template

InputfieldDatatypeSizeComment
UnitIdString8The identifier of the unit that the recurring template belongs to
SupplierIdString32The identifier of the supplier of the invoice
StartDateString8The template start date
EndDateString8The template end date
IncludeAccountingRowsBoolTrue/False
PageNumberIntPage to fetch. First page = 1
PageSizeIntNumber of pages to get
FieldDatatypeSizeComment
data:
idIntUnique identifier of the recurring template
unitIdString32The identifier of the unit that the invoice belongs to
nameString255Name of the recurring template
supplierIdString32The identifier of the supplier of the invoice
startDateDatetimeStart date for when the template is valid
endDateDatetimeEnd date for when the template is valid
originalInvoiceNumberString255Invoice number to which the template should match
orderNumberString32Order number to which Invoice template should match
foreignAmountFromDecimal28,8The foreign amount of the invoice to which recurring template should match
foreignAmountToDecimal28,8The foreign amount of the invoice to which recurring template should match
checkSignatureString32The check signature to use
attestSignatureString32The attest signature to use
numberImportedIntNumber of imported invoices matching this template
maxNumberImportedIntMaximum allowed number of imported invoices matching this template
referenceString255Optional Reference of the invoice to which the recurring template should match
addVatCodingBoolIndicates whether VAT coding should be added automatically by the system, or
not, when the template is applied
allocateGrossAmountBoolIndicates whether the gross or net invoice amount should be allocated when creating accounting rows according this template
supplierNameString255The name of the supplier of the recurring template
codingReferenceString255Optional CodingReference of the invoice to which the recurring template should match
lastUsageDateDatetimeThe date when this template was last used
stopInCheckBoolIndicates whether the invoice should stop in the Check step, when being automatically processed
stopInAttestBoolIndicates whether the invoice should stop in the Attest step, when being
automatically processed
createdByString32The user id of the user who created the template
createdUtcDatetimeThe date and time at which the template was created
accountingRows:
templateIdIntUnique identifier of the recurring template
rowNumberIntThe number of the the template row.
accountString32The Account.
object1String32Dimension 1.
object2String32Dimension 2.
object3String32Dimension 3.
object4String32Dimension 4.
object5String32Dimension 5.
object6String32Dimension 6.
object7String32Dimension 7.
object8String32Dimension 8.
quantityDecimal28,8Quantity
percentageDecimal28,8Percentage of the total amount to allocate on this row
userTextString255Free text
propertyVatAllocationString255
useSpecificPropVatAllocInt
orderIdInt
accrualString32
accrualRefDateString32
accrualRelativeStartInt
accrualNbOfPeriodsInt
checkSignatureString32
attestSignatureString32
equalAmountsPerPeriodInt
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page.
True when the current page number is greater than or equal to TotalPages

Reference

Post method : /api/references

This method creates a reference addressee

InputfieldDatatypeSizeComment
idIntThe identifier or the reference
unitIdString32The identifier of the unit that the reference belongs to
textString255The reference text
descriptionString255The reference description
object1String32Dimension 1
object2String32Dimension 2
object3String32Dimension 3
object4String32Dimension 4
object5String32Dimension 5
object6String32Dimension 6
object7String32Dimension 7
object8String32Dimension 8
arrivalGroupStringOptional id of the arrival queue to send the invoice to
refAccountString32Account
addressees:
addresseeString32User id representing the recipient to send the invoice to
FieldDatatypeSizeComment
resultIntReference id of updated or created record
successBoolTrue or false to represent if the operation of update or create is successful or not
messageString255Summary of the operation

Get method : /api/references

This method retrieves references based on the specific request

InputfieldDatatypeSizeComment
UnitIdString32The identifier of the unit that the reference belongs to
PageNumber IntPage to fetch. First page = 1
PageSize IntNumber of pages to get
FieldDatatypeSizeComment
unitIdString32The identifier of the unit that the reference belongs to
idString8The identifier of the reference
textString255The reference text
descriptionString255The reference description
object1String32Dimension 1
object2String32Dimension 2
object3String32Dimension 3
object4String32Dimension 4
object5String32Dimension 5
object6String32Dimension 6
object7String32Dimension 7
object8String32Dimension 8
arrivalGroupString32Optional id of the arrival queue to send the invoice to
refAccountString32The reference account
addressees:
unitIdString32The identifier of the unit that the invoice belongs to
referenceIdIntThe identifier of reference
addresseeString32The Addressee
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page.
True when the current page number is greater than or equal to TotalPages

SupplierInvoice

Get method : /api/supplier-invoices

This method retrieves the list of invoices

InputfieldDatatypeSizeComment
UnitIdString8The identifier of the unit that the invoice belongs to
SupplierIdString32The identifier of the supplier of the invoice
InvoiceDateFromDatetimeThe invoice date. Depending on unit parameters this can be used in the calculations of
TInvoice.BookDate and TInvoice.DueDate
InvoiceDateToDatetimeThe invoice date. Depending on unit parameters this can be used in the calculations of TInvoice.BookDate and TInvoice.DueDate
BookDateFromDatetimeThe bookkeeping date of the invoice to send to the external business system
BookDateToDatetimeThe bookkeeping date of the invoice to send to the external business system
IncludeInvoiceRowsBoolTrue/False
PageNumberIntPage to fetch. First page = 1
PageSizeIntNumber of pages to get
FieldDatatypeSizeComment
data:
idIntThe identifier of the invoice. This is an autogenerated number that is unique in the system over all units
unitIdString8The identifier of the unit that the invoice belongs to
supplierIdString32The identifier of the supplier of the invoice
supplierNameString255The name of the supplier of the invoice
amountDecimal28,8The amount of the invoice
foreignAmountDecimal28,8The foreign amount of the invoice
foreignVATAmountDecimal28,8The foreign VAT amount of the invoice
currencyString32The currency of the invoice
referenceString255The reference of the invoice. This field is used for searching the TReference table for reference users that will receive the invoice
caseIdIntThe identifier of the workflow case assigned to the invoice. This identifier is only
assigned once for an invoice
externalInvoiceNumberString32The identifier of the invoice in the external business system
dueDateDatetimeThe due date of the invoice
invoiceDateDatetimeThe invoice date. Depending on unit parameters this can be used in the calculations of TInvoice.BookDate and TInvoice.DueDate
arrivalDateDatetimeThe arrival date of the invoice. Depending on unit parameters this can be used
in the calculations of TInvoice.BookDate and TInvoice.DueDate
bookDateDatetimeThe bookkeeping date of the invoice to send to the external business system
payDateDatetimeThe payment date of the invoice
importDateDatetimeThe import date of the invoice, set to the current date at the time of import. Depending on unit parameters this can be used in the calculations of TInvoice.BookDate
preliminaryBookingDateDatetimeThe date of preliminary registration in the external business system for the
invoice
definitiveBookingDateDatetimeThe date of final registration in the external business system for the invoice
statusInt1)
approvalSignatureString32If the invoice has been approved, a separate functionality in the CHECK step, this will hold the user identity of the user that has approved the invoice
assetCopyBoolDetermines if the invoice shall pass the COPY step (1) or not (0)
blockPaymentBoolDetermines if payment shall be blocked in the external business system for the invoice (1) or not (0)
awaitCreditBoolDetermines if the invoice shall pass the COPY step (1) or not (0)
originalInvoiceNumberString255The number printed on the scanned invoice. This is used in the calculations that determine if the invoice already exists in the system or not
voucherIdString32The identifier of the voucher created in the external business system. This will
be set in the preliminary and final registrations of the invoice
cancelDateDatetimeThe date of cancellation for the invoice, or NULL if the invoice has not been cancelled
payOKSignatureString32If the PAYOK step is used (determined by unit parameters) this will hold the
identifier of the user that approved the payment of the invoice
secrecyInvoiceBoolDetermines if the invoice is a secrecy invoice (1) or not (0). For secrecy invoices, search access is determined by the TInvoice.SecrecyGroup identifier
watchedBoolDetermines if the invoice is watched (1) or not (0)
orderNumberString32Will contain the connected order number (TOrder.Id) if the invoice has been matched against an order
kidNumberString255The OCR number on the invoice. This will be sent to the external business
system when the invoice is registered preliminary or finally
templateIdIntIf the invoice has been matched to a TInvoiceTemplate at import, this will be the identifier of that template
originalBookDateDatetimeThe bookkeeping date of the invoice at the time of preliminary registration
authorizedBoolThe invoice has been authorized in the attest or payok step
invoiceCategoryIdIntCategory of the invoice. Optional
ordermatchedBoolHas this invoiced been ordermatched
fixedVATAmountIntThe fixed VAT amount of the invoice
vatCurrencyString32The identifier of the VATCurrency of the invoice
exchangeRateDecimal28,8The exchange rate of the invoice
codingReferenceString255The coding reference of the invoice. This field is used for searching the TReference table for reference coding for the invoice
supplierInvoiceRow:
invoiceIdIntThe identifier of the invoice. This is an autogenerated number that is unique in
the system over all units
rowNumberIntThe row number for this row. Can be an imported value or an enumerated number starting by 1
articleIdString32Id of the article
supplierArticleNumberString32The supplier’s article number
descriptionString255Description
quantityIntQuantity
quantityUnitString32Unit (st, kg etc)
pricePerUnitDecimal28,8The price per unit of the item ordered
amountDecimal28,8Amount
discountDecimal28,8Discount percentage
orderIdIntThe number of the order object connected to this row
orderRowNumberIntThe row number of the order row connected to this row
supplierOrderNumberString32The supplier order number connected to the invoice row
supplierOrderRowNumberString4The supplier row number connected to this row
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

1)

ValueComment
0An imported archive invoice
1The invoice has not yet been preliminary registered
2The invoice has been preliminary registered
3The invoice has been finally registered
4The invoice has been paid
5The invoice has been cancelled
6The invoice has been destroyed
7The invoice has been terminated

Get method : /api/supplier-invoices/status/{status}

This method retrieves the list of invoices by status

InputfieldDatatypeSizeComment
statusInt0-7
UnitIdString32The identifier of the unit that the invoice belongs to
SupplierIdString32The identifier of the supplier of the invoice
InvoiceDateFromDatetimeThe invoice date. Depending on unit parameters this can be used in the calculations of TInvoice.BookDate and TInvoice.DueDate
InvoiceDateToDatetimeThe invoice date. Depending on unit parameters this can be used in the calculations
of TInvoice.BookDate and TInvoice.DueDate
BookDateFromDatetimeThe bookkeeping date of the invoice to send to the external business system
BookDateToDatetimeThe bookkeeping date of the invoice to send to the external business system
InvoiceCategoryIdIntCategory of the invoice
IncludeAccountingRowsBoolTrue/False
IncludeMessagesBoolTrue/False
PageNumberIntPage to fetch. First page = 1
PageSizeIntNumber of pages to get
FieldDatatypeSizeComment
data:
idInt
supplierIdString32The identifier of the supplier of the invoice
supplierNameString255The name of the supplier of the invoice
currencyString32The currency of the invoice
invoiceDateDatetimeThe invoice date. Depending on unit parameters this can be used in the calculations of TInvoice.BookDate and TInvoice.DueDate
bookDateDatetimeThe bookkeeping date of the invoice to send to the external business system
definitiveBookingDateDatetimeThe date of definitive booking
invoiceCategoryIdIntCategory of the invoice
statusInt1)
messageIdIntThe identifier in the TMessage table for the user messages for this invoice. Will
be 0 if the invoice does not contain any user messages
originalInvoiceNumberString255The number printed on the scanned invoice. This is used in the calculations that determine if the invoice already exists in the system or not
voucherIdString32The identifier of the voucher created in the external business system. This will
be set in the preliminary and final registrations of the invoice
invoiceAccRows:
accountString32??
invoiceIdIntThe identifier of the Invoice owning this object. This is a foreign key to the Id
column of the TInvoice table
rowNumberIntThe number of the row within the Invoice object, starting by 1
object1String32Dimension 1
object2String32Dimension 2
object3String32Dimension 3
object4String32Dimension 4
object5String32Dimension 5
object6String32Dimension 6
object7String32Dimension 7
object8String32Dimension 8
amountDecimal28,8The row amount in domestic currency
foreignAmountDecimal28,8The row amount in the currency of the invoice
messages:
messageIdIntThe message id referring to the messageId on the invoice
rowNumberIntThe row number. For each new MessageId starting on 1
messageTextString255The message text
creationDateDatetimeThe date at which the message was created
signatureString32??
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page.
True when the current page number is greater than or equal to TotalPages

1)

ValueComment
0An imported archive invoice
1The invoice has not yet been preliminary registered
2The invoice has been preliminary registered
3The invoice has been finally registered
4The invoice has been paid
5The invoice has been cancelled
6The invoice has been destroyed
7The invoice has been terminated

Unit

Get method : /api/units

This method retrieves a list of units that are not templates with pagination support

InputfieldDatatypeSizeComment
pageNumberIntPage to fetch (1-based)
pageSizeIntRecords per page
FieldDatatypeSizeComment
data:
idString32The unique identifier for the unit (e.g., “AB1”)
nameString255Name of the unit
organizationNumberString255The Organization number
vatNumberString255The VAT number
countryCodeString32
arrivalGroupString255The arrival group name
glnString255The unique identifier of the unit
pageNumberIntPage to fetch. First page = 1
pageSizeIntTrue – more pages to fetch
totalRecordsIntTotal number of records
totalPagesIntIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
IsCompletedBoolIndicates whether the current page is the final (or only) page.
True when the current page number is greater than or equal to TotalPages

UnitParameter

Get method : /api/unit-parameter/{unitParameter-Id}

This method retrieves a specific unit parameter by its ID for a given UnitId

InputfieldDatatypeSizeComment
unitParameterIdString255The ID of the specific unit parameter (e.g., “AttestDeadlinePercentage”)
unitIdString255The Unit ID (e.g., “AB1”)
FieldDatatypeSizeComment
idString255The unit parameter key
valueString255Value of unit parameter

UnitUser

Get method : /api/unit-users

This method retrieves a list of users by unit ID with pagination support

InputfieldDatatypeSizeComment
unitIdString255Unique identifier of a Unit
pageNumberString255Page to fetch. First page = 1
pageSizeNumber of items on each page
FieldDatatypeSizeComment
data:
unitIdString32The unique identifier for the unit (e.g., “AB1”)
userIdString32The unique identifier for the user (e.g., “akhusi”)
supervisorString32The user id of supervisor
supervisorCopyString32The user id of supervisor copy
attestAmountDecimalThe attested financial amount
attestInvoiceAmountDecimalThe attested amount for an invoice
codeComplObjectString255Object for coding supplements - Object value to be suggested when user adds accounting row
pageNumberIntPage to fetch. First page = 1
pageSizeIntTrue – more pages to fetch
totalRecordsIntTotal number of records
totalPagesIntIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
IsCompletedBoolIndicates whether the current page is the final (or only) page.
True when the current page number is greater than or equal to TotalPages

User

Patch method : /api/im/users/supervisor

This method updates supervisor and supervisor copy

InputfieldDatatypeSizeComment
unitIdString32The identifier of the unit that the user belongs to.
userIdString32The users unique identifier.
SupervisorString32The user id of supervisor.
supervisorCopyString32The user id of supervisor copy.
FieldDatatypeSizeComment
resultIntUser id of the updated record
successBoolTrue or false to represent if the operation of update or create is successful or not
messageString255Summary of the operation

Get method : /api/im/users

This method gets users from Invoice Manager

InputfieldDatatypeSizeComment
UserIdString32Unique identifier of a User.
PageSizeIntNumber of items on each page.
PageNumberIntPage to fetch. First page = 1
FieldDatatypeSizeComment
data:
idString32Unique User Id.
firstNameString255First Name of the user.
lastNameString255Last Name of the user.
emailString255Email address of the user
descriptionString255User description
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page
totalRecordsIntTotal number of records
totalPagesIntTotal pages
hasNextPageBoolIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
isCompleteBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

UserObject

Get method : /api/user-objects

This method gets all user objects with optional filtering and pagination

InputfieldDatatypeSizeComment
UserIdString32Unique identifier of a User.
UnitIdString32Unit identifier
ObjectTypeIdIntThe object type identifier
EffectiveDateDateOptional filter by effective date. Returns records where the date falls between ValidFrom and ValidTo
PageSizeIntNumber of items on each page.
PageNumberIntPage to fetch. First page = 1
FieldDatatypeSizeComment
data:
unitIdString32The unique identifier for the unit (e.g., “AB1”)
userIdString32The unique identifier for the user (e.g., “akhusi”)
objectTypeIdInt32The object type identifier
objectValueString32The object type value
attestAmountDoubleThe Attest amount
validFromDateUser object valid from date
validToDateUser object valid to date
categoryString255Row type category - search/accounting/authorization
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page.
totalRecordsIntTotal number of records
totalPagesIntIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
IsCompletedBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

Get method : /api/user-objects/search

This method gets all user objects (RowType = 0) with optional filtering and pagination

InputfieldDatatypeSizeComment
UserIdString32Unique identifier of a User.
UnitIdString32Unit identifier
ObjectTypeIdIntThe object type identifier
EffectiveDateDateOptional filter by effective date. Returns records where the date falls between ValidFrom and ValidTo
PageSizeIntNumber of items on each page.
PageNumberIntPage to fetch. First page = 1
FieldDatatypeSizeComment
data:
unitIdString32The unique identifier for the unit (e.g., “AB1”)
userIdString32The unique identifier for the user (e.g., “akhusi”)
objectTypeIdInt32The object type identifier
objectValueString32The object type value
attestAmountDoubleThe Attest amount
validFromDateUser object valid from date
validToDateUser object valid to date
categoryString255Row type category - search
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page.
totalRecordsIntTotal number of records
totalPagesIntIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
IsCompletedBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

Get method : /api/user-objects/accounting

This method gets accounting user objects (RowType = 1) with optional filtering and pagination

InputfieldDatatypeSizeComment
UserIdString32Unique identifier of a User.
UnitIdString32Unit identifier
ObjectTypeIdIntThe object type identifier
EffectiveDateDateOptional filter by effective date. Returns records where the date falls between ValidFrom and ValidTo
PageSizeIntNumber of items on each page.
PageNumberIntPage to fetch. First page = 1
FieldDatatypeSizeComment
data:
unitIdString32The unique identifier for the unit (e.g., “AB1”)
userIdString32The unique identifier for the user (e.g., “akhusi”)
objectTypeIdInt32The object type identifier
objectValueString32The object type value
attestAmountDoubleThe Attest amount
validFromDateUser object valid from date
validToDateUser object valid to date
categoryString255Row type category - accounting
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page.
totalRecordsIntTotal number of records
totalPagesIntIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
IsCompletedBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

Get method : /api/user-objects/authorization

This method gets authorization user objects (RowType = 2) with optional filtering and pagination

InputfieldDatatypeSizeComment
UserIdString32Unique identifier of a User.
UnitIdString32Unit identifier
ObjectTypeIdIntThe object type identifier
EffectiveDateDateOptional filter by effective date. Returns records where the date falls between ValidFrom and ValidTo
PageSizeIntNumber of items on each page.
PageNumberIntPage to fetch. First page = 1
FieldDatatypeSizeComment
data:
unitIdString32The unique identifier for the unit (e.g., “AB1”)
userIdString32The unique identifier for the user (e.g., “akhusi”)
objectTypeIdInt32The object type identifier
objectValueString32The object type value
attestAmountDoubleThe Attest amount
validFromDateUser object valid from date
validToDateUser object valid to date
categoryString255Row type category - authorization
pageNumberIntPage to fetch. First page = 1
pageSizeIntNumber of items on each page.
totalRecordsIntTotal number of records
totalPagesIntIndicates if there is a subsequent page of results
hasPreviousPageBoolIndicates if there is a preceding page of results
IsCompletedBoolIndicates whether the current page is the final (or only) page. True when the current page number is greater than or equal to TotalPages

Post method : /api/user-objects/authorization

This method create/update authorization on user level

InputfieldDatatypeSizeComment
userIdString32The unique user identifier
unitIdString32The unique unit identifier
typeIdIntThe Object type identifier
objectValueString255The object value
attestAmountDoubleThe Attest amount
validFromDatetimeThe valid from date
validToDatetimeThe valid to date
FieldDatatypeSizeComment
resultIntUser id of the updated record
successBoolTrue or false to represent if the operation of update or create is successful or not
messageString255Summary of the operation
Senast ändrad 30.06.2026