UpdateSLSCase
Sales Ledger Services
UpdateSLSCase file
Version 1.8
Document history
The Update SLS Case entry file
Why XML
Conventions in the UpdateSLSCase.xml entry file
Filename is always set to “updates.nnn” (nnn=sequence number)
UppdateSLSCase
Diagram
Identification
Element
Attributes
Ledger
Element
Attributes
Customer
Element
Attributes
Invoice
Element
Attributes
InvoiceHeader
Element
Attributes
Payment
Element
Attributes
The Update SLS Case entry file
This document describes the structure and limitations of the Update SLS Case entry file (UpdateSLSCase.xml).
Why XML
Intrum has chosen XML for the following reasons
Flexibility
With XML Intrum have the ability to adapt the entry file to specific customer needs without having to change anything at our current clients environments. Clients will be able to use a range of tools to produce (both export and import) the XML file, since all major manufacturers of databases and ERP systems already incorporate XML-support in their systems.
Quality
With XML Intrum can offer the client a way to test their own files before sending them to Intrum. Also Intrum will be able to “parse” or validate the file without having to build advanced validation software for each involved system.
Client demand
From our experience with the Sales Ledger Services in the Scandinavian countries we have learned that many of our clients would like to use XML as an interface to our system.
Conventions in the UpdateSLSCase.xml entry file
Amounts
All decimal values must have two (2) fractal digit and a “.” (dot) as separator.
Examples:Your payment amount is 4600. In the UpdateSLSCase file you must specify 4600.00 as the payment amount
Your payment amount is 54.1. In the UpdateSLSCase file you must specify 54.10 as the payment amount
Dates
All dates must follow the ISO standard with year, month, and day separated by “-“ (hyphens).
Example:The 15th of November 2001 would be 2001-11-15 in the XML file.
Reserved XML-Syntax characters
The W3C XML standard doesn’t allow you to use 5 syntax-reserved characters in your data. In order to make use of this characters possible have the W3C created new characters for them.
CharacterNew character
=&
‘=apos;
=gt;
=lt;
“=quot;
Filename is always set to “updates.nnn” (nnn=sequence number)
UpdateSLSCase
Diagram
/Identification
Element
/Attributes
/ Name / Type / Use / Restrictions / Description / Table / Column / Rec / From / ToHubNo / String / Required / Length 1 - 100 / Client communications ID set and delivered by Intrum Justitia
ClientNo / Integer / Required / 1 – 999999 (5 digits) / Clients customer number at Intrum Justitia
ClientBatchNo / String / Optional / 1 – 9999999 (7 digits) / Unique file ID number / 01 / 5 / 11
IJBatchNo / Integer / Optional / 1 – 9999999 (7 digits) / Unique file ID number
ClientEmailAddress1 / String / Optional / Length 1 - 50 / Client email address1 for handling of receipts
ClientEmailAddress2 / String / Optional / Length 1 - 50 / Client email address2 for handling of receipts
Ledger
Element
/Attributes
/ Name / Type / Use / Restrictions / Description / Table / Column / Rec / From / ToProductionUnit / string / required / Length 2 / Specific Database handling code given to client by Intrum Justitia. / 01 / 3 / 4
LedgerNo / Integer / Required / 1 – 99999999 (8 digits) / Client ledger number. Ledger number = one currency ex: Norwegian kroner NOK / 06,12,1450,75,
76 / 3 / 10
Customer
Element
/Attributes
/ Name / Type / Use / Restrictions / Description / Table / Column / Rec / From / ToNo / String / Required / Length 1 - 20 / Customer number set by client, uniquely identifies the customer / 06 / 11 / 30
Name / String / Required / Length 1 - 60 / Name of Customer (First Name + Last Name or Company Name) / 06 / 31 / 90
ReferenceName / String / Optional / Length 0 - 60 / Name of Reference at Company / 06 / 91 / 150
Address1 / String / Required / Length 1 - 60 / Customer address1. Field must contain information for customer entry to be valid / 06 / 151 / 210
Address2 / String / Optional / Length 0 - 60 / Customer address2 / 06 / 211 / 270
Address3 / String / Optional / Length 0 - 60 / Customer address3 / 06 / 271 / 330
Address4 / String / Optional / Length 0 - 60 / Customer address4 / 06 / 331 / 390
Address5 / String / Optional / Length 0 - 60 / Customer address5 / 06 / 391 / 450
ZipCode / String / Required / Length 1 - 10 / Customer Postal address area code / 06 / 451 / 460
City / String / Required / Length 1 - 40 / Customer city name / 06 / 461 / 500
CountryCode / String / Required / Length 2 / Customer habitat country code ( ISO 3166 standard) / 06 / 501 / 502
LanguageCode / String / Required / Length 3 / Customer language code ( ISO 639 standard) / 06 / 503 / 505
VATNo / String / Optional / Length 0 - 18 / Customer VAT number / 06 / 506 / 523
PhoneNo / String / Optional / Length 0 - 30 / Customer telephone number / 06 / 524 / 553
FaxNo / String / Optional / Length 0 - 30 / Customer fax number / 06 / 554 / 583
EmailAddress / String / Optional / Length 0 - 50 / Customer email address / 06 / 584 / 633
Category / String / Optional / Length 0 - 10 / Customer category code / 06 / 634 / 643
Region / String / Optional / Length 0 - 10 / Customer region code / 06 / 644 / 653
District / String / Optional / Length 0 - 10 / Customer district code / 06 / 654 / 663
TypeCode / String / Optional / Length 0 – 1, Value B or C / Customer type code (Business or Consumer) / 06 / 664 / 664
PaymentTerms / Integer / Optional / Null - 9999 / Customer general payment term (day’s of credit) / 06 / 665 / 668
DirectDebet / String / Optional / Length 0 – 1, Value Y or N / Customer direct debet activity code (Y=activate or N=deactivate)
Is not valid if no date is entered in attribute: DirectDebetNoBG or attribute: DirectDebetNoPG.
DirectDebet can’t be used if EInvoice is set to Y. / 06 / 669 / 669
DirectDebetNoBG / Integer / Optional / Null– 999999999999999999999999999999 (30 digits) / Customer direct debet bank agreement number. Delivered to Client by bank / 06 / 670 / 699
DirectDebetNoPG / Integer / Optional / Null– 999999999999999999999999999999 (30 digits) / Customer direct debet postgiro agreement number / 06 / 700 / 729
DirectDebetBankAccountNo / String / Optional / Length 0 - 30 / Customer direct debet account number to be displayed on invoice as information to the customer / 06 / 730 / 759
DirectDebetBankAccountPidNo / String / Optional / Length 0-8 / Identification number for DirectDebetBankAccountNO. Number set by the bank and given to the client. / 06 / 760 / 767
EInvoice / String / Optional / Length 0 – 1, Value Y or N / EInvoice activation/deactivation code.Einvoice can never by used if DirectDebit is set to Y. EInvoice is fore the time being only used for invoicing in Sweden. / 06 / 669 / 669
EInvoiceBankCode / String / Optional / Length 0-10 / Bank identification code. Given to the client by their EInvoice Bank. / 06 / 768 / 777
CreditLimit / Decimal / Optional / -9999999999999999.99 – 999999999999999999.99 (18 digits) / Amount for credit limit. / 06 / 778 / 795
PrintReminders / String / Optional / Length 0 - 1, Value Y or N / Reminder print activation/deactivation code. / 06 / 796 / 796
CreateInterestInvoice / String / Optional / Length 0 - 1, Value Y or N / Interest invoice activation/deactivation code. / 06 / 797 / 797
Invoice
Element
/Attributes
/ Name / Type / Use / Restrictions / Description / Table / Column / Rec / From / ToInvoiceNo / Integer / Required / 1 - 99999999999999999999 (20 digits) / Invoice number set by the client. An invoice number can only be used once in a ledger / 12,14,
75 / 11 / 30
InvoiceHeader
Element
/Attributes
/ Name / Type / Use / Restrictions / Description / Table / Column / Rec / From / ToInvoiceCustomerNo / String / Required / Length 1 - 20 / Customer number. Data is used to link the invoice information whit the customer information. / 12, 14 / 31 / 50
AdjustedDueDate / Date / Optional / Date Format YYYY-MM-DD / New Invoice Due Date. / 75 / 31 / 38
ReminderBlockCode / String / Optional / Length 0 – 1, Value Y or N / Invoice Remainder activity code (Y=activate or N=deactivate). / 75 / 39 / 39
ReminderBlockValidUntilDate / Date / Optional / Date Format YYYY-MM-DD / Invoice Reminder block valid until given date.
/ 75 / 57 / 64
DCNoticeBlockCode / Date / Optional / Length 0 – 1, Value Y or N / Invoice DC Notice activity code (Y=activate or N=deactivate). / 75 / 40 / 40
DCNoticeBlockValidUntilDate / Date / Optional / Date Format YYYY-MM-DD / DC Notice block valid until given date.
/ 75 / 65 / 72
DCBlockCode / String / Optional / Length 0 – 1, Value Y or N / Invoice Debt Collection activity code (Y=activate or N=deactivate). / 75 / 41 / 41
DCBlockValidUntilDate / Date / Optional / Date Format YYYY-MM-DD / DC block valid until given date.
/ 75 / 73 / 80
DCReleaseCode / Date / Optional / Length 0 – 1, Value F / Debt Collection transferee code (F=transferee invoice to Debt Collection).
DCReleaseDate / Date / Optional / Date Format YYYY-MM-DD / Debt collection transferee date.
/ 75 / 44 / 49
DCClosedCase / String / Optional / Length 0 – 1, Value A / Invoice Debt Collection cancelation code
A=Cancel / 75 / 52 / 52
InterestBlockCode / String / Optional / Length 0 – 1, Value Y or N / Invoice interest activity code (Y=activate or N=deactivate). / 75 / 51 / 51
CreditLossType / String / Optional / Length 1 – 4 / Credit loss type. 0000 = Remove credit loss type / 75 / 53 / 56
ReferenceText3 / String / Optional / Length 0 – 60 / Invoice reference text3. / 76 / 31 / 90
ReferenceText4 / String / Optional / Length 0 – 60 / Invoice reference text4. / 76 / 91 / 150
ReferenceText5 / String / Optional / Length 0 – 60 / Invoice reference text5. / 76 / 151 / 210
ReferenceText6 / String / Optional / Length 0 – 60 / Invoice reference text6. / 76 / 211 / 270
ReferenceText7 / String / Optional / Length 0 – 60 / Invoice reference text7. / 76 / 27 / 330
ReferenceText8 / String / Optional / Length 0 – 60 / Invoice reference text8. / 76 / 331 / 390
ReferenceText9 / String / Optional / Length 0 – 60 / Invoice reference text9 / 76 / 391 / 450
ReferenceText10 / String / Optional / Length 0 – 60 / Invoice reference text10. / 76 / 451 / 510
ReferenceText11 / String / Optional / Length 0 – 60 / Invoice reference text11 / 76 / 511 / 570
ReferenceText12 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText13 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText14 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText15 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText16 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText17 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText18 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText19 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText20 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText21 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
ReferenceText22 / String / Optional / Length 0 – 60 / Invoice reference text12. / 76 / 571 / 630
Payment
Element
/Attributes
/ Name / Type / Use / Restrictions / Description / Table / Column / Rec / From / ToPaymentAccount / String / Required / Length 1 - 30 / 50 / 31 / 60
PaymentDate / Date / Optional / Date Format YYYY-MM-DD / Payment booking date. / 50 / 61 / 68
PaymentAmount / Decimal / Optional / -9999999999999999.99 – 999999999999999999.99 (18 digits) / Total paid amount. / 50 / 69 / 86
PaymentDedutionAmount / Decimal / Optional / -9999999999999999.99 – 999999999999999999.99 (18 digits) / Total deducted amount. / 50 / 87 / 104
PaymentHandlingCode / String / Optional / Length 1,Value D or S / Payment handling code
D=partly paid, differences in paid amount and remaining invoice amount is accepted. The invoice remains open.
S=Fully paid, differences in paid amount and remaining invoice amount is to be accepted and invoice status is set to fully paid. / 50 / 105 / 105
Author: Icecon ABPage 1 of 13