Customer invoice
The document serves as a description of the document format and data in which Extend Commerce is able to export customer invoice data.
Target audience
The suggested target audience of this document is IT staff working with system integrations. Basic understanding of XML is assumed.
he document serves as a description of the document format and data in which Lxir is able to export customer invoice data
Document will be encoded using UTF-8.
A scheduled service (Lxir XTS Service) sends the message containing invoices matching the following prerequisites:
1) Invoice status is Invoice sent OR Prepaid
2) Exported = false
A number of options exist regarding the physical transmission of the actual file to the receiving system. This is agreed for each setup.
Export of changes to an invoice is not possible. Once exported, it cannot be exported again.
The export of an LxirOrderInvoice message does not mean that an LxirOrderInvoiceResponse message will have to be received containing all the invoices in the original LxirOrderInvoice message. Payments can occur at any time, any amount etc.
Invoices are always created/started from the order handling system.
Products and customer data sent in the LxirOrderInvoice export does not have to be present in the receiving system.
LxirOrderInvoice
XMLStructure
LxirOrderInvoice (1)
LxirOrderInvoice\OrderInvoice (1-∞)
Attribute | Code | Mand. | Description |
Number | Y | Invoice number | |
OrderNumber | N | Ordernumber if CustomerInvoiceType = OrderDebit, alt. receivingNumber in case CustomerInvoiceType = ReturnOrderCredit. Others -> attribute are not created. | |
CreateDate | Y | Time when the message was created (YY-MM-DD hh: mm) | |
InvoiceDate | Y | Time when the invoice was created (YY-MM-DD hh: mm) | |
DueDate | Y | Due date (YY-MM-DD hh: mm) | |
PaymentTermsNoOfDays | N | Number of payment days on the invoice, for example 30 days. DueDate-Create Date. | |
OrderDate | N | Time when the order (OrderDate) all. Receiving (ReceivingCreateDate) was created (YY-MM-DD hh: mm). If order / reception is missing -> Attributes are not created. | |
PaymentType | N | 1 = Invoice, 2 = Autogiro, 4 = Advance Payment, 8 = Factoring, 16 = Cash, 32 = Manual Autogiro (Load Sheet), 64 = Credit Card, 256 Invoice Me, 516 COD | |
OCRNumber | N | OCR/(KID) no | |
ShippingMark | N | ShippingMark order header | |
OrderNumberExternal | N | External reference, mandatory for card payment | |
SalesAccount | N | Sales account | |
Text 1 | N | Example: Payment info on normal invoice | |
Text 2 | N | Example: Payment info for sold invoice | |
Text 3 | N | Example: ”Invoice is prepaid” | |
Number1 | N | ||
Number2 | N | ||
Number3 | N | ||
InvoiceAmount | Y | Invoice amount | |
FreightAmount | Y | Freight amount | |
VatAmount | Y | Vat amount | |
InvoiceAmountTotal | Y | Total amount (invoice amount + shipping fee + VAT amount) | |
Currency | ISO 4217 | N | Currency |
BaseCurrency | ISO 4217 | N | Client base currency |
ExchangeRate | N | Exchange rate based on Base Currency | |
CurrencyDate | N | Currency date | |
InvoiceAmountBaseCurrency | N | Invoice sum in base currency | |
FreightAmountBaseCurrency | N | Shipping amount in base currency | |
VatAmountBaseCurrency | N | VAT amount in base currency | |
InvoiceAmountTotalBaseCurrency | N | Total amount (invoice amount + shipping amount + VAT amount) in base currency | |
YourReference | N | Your reference | |
OurReference | N | Our reference | |
TransportMode | N | Mode of transportation | |
SupplierAgreementNumber | N | Supplier agreement no | |
AuthorizationNumber | N | ||
SupplierAgreementName | N | Supplier agreement name | |
RoundingAmountBaseCurrency | Y | ||
GLN | N | Global Location Number, tClient.GLN | |
CustomerInvoiceType | Y | Invoice Type, Card Name. Valid values: ROC = Return Order Credit (credit invoice based on return order) CD = Custom Debit (manual invoice) CC = Custom Credit (manual credit invoice) ROD = Return Order Debit (Invoice based on return orders. | |
Notes | N | Notes invoice | |
Reference | N | Reference invoice | |
OrderNotes | N | Order notes |
LxirOrderInvoice\OrderInvoice\Customer (1)
Attribute | Code | Mand. | Description | Type |
Number | Y | Customer no | 50 | |
Name | Y | Customer name | 180 | |
LastName | N | Surname | 180 | |
Phone | N | Telephone no | 50 | |
Fax | N | Fax no | 50 | |
N | tOrder.Email | 100 | ||
BankAccount | N | Bank account number | 50 | |
OrganizationNumber | N | Corporate no | 50 | |
VatNumber | N | VAT no | 50 | |
Salesman | N | Salesman | 140 | |
PayingCustomerNumber | N | Paying customer no | 50 | |
CustomerFinancialCategoryExternalId | N | External ID, Financial category on customer | 100 | |
AgreementNumber | N | Contract number customer | 100 |
LxirOrderInvoice\OrderInvoice\Customer\InvoiceAddress(1)
Attribute | Code | Man | Description | Comment | Type |
Name | J | Billing Name | 90 | ||
Address1 | J | Invoice Address 1 | 60 | ||
Address2 | N | Invoice Address 2 | 60 | ||
Address3 | N | Invoice Address 3 | 60 | ||
PostalCode | J | Postal code | 20 | ||
City | J | City | 40 | ||
State | N | State | 40 | ||
Country | Enligt ISO | J | Country | If SE, then the invoice template must be in Swedish in other cases, English invoice template is used. | 4 |
EAN | N | EAN code | 50 |
LxirOrderInvoice\OrderInvoice\Customer\DeliveryAddress(0-1)
Data is read from different locations depending on customerInvoiceType:
1) OrderDebit: tOrder delivery address, exception: EAN is picked from tCustomer
2) ReturnOrderCredit: Sender addresses, exception: EAN is picked from tCustomer
3) Others: No addresses at all printed! (* see below)
Attribute | Code | Mand. | Description | Type |
Name | J* | Shipping name | 90 | |
Address1 | J* | Delivery name 1 | 60 | |
Address2 | N | Delivery adress 2 | 60 | |
Address3 | N | Delivery adress 3 | 60 | |
PostalCode | J* | Zip code | 20 | |
City | J* | City | 40 | |
State | N | State | 40 | |
Country | Enligt ISO | J* | Country | 4 |
EAN | N | EAN code | 50 |
LxirOrderInvoice\OrderInvoice\Agent(0-1)
Attribute | Code | Mand. | Description | Type |
Number | Y | Agent no | 50 | |
Name | J | Agent name | 180 | |
ContactName | N | Contact name | 180 | |
Phone | N | Telephone no | 50 | |
Fax | N | Fax no | 50 | |
N | 100 | |||
AgentType | N | Agent type | 50 | |
SalesPlace | N | Point of sale | 50 | |
OrganizationNumber | N | Corporate | 50 | |
Chain | N | Chain of sales | 140 |
LxirOrderInvoice\OrderInvoice\Agent\Address (1)
Attribute | Code | Man | Description | Comment | Type |
Address1 | N | Address 1 | 60 | ||
Address2 | N | Address 2 | 60 | ||
Address3 | N | Address 3 | 60 | ||
PostalCode | N | Postal Code | 20 | ||
City | N | City | 40 | ||
State | N | State | 40 | ||
Country | Enligt ISO | N | Country | 4 |
LxirOrderInvoice\OrderInvoice\OrderInvoiceRows (1)
LxirOrderInvoice\OrderInvoice\OrderInvoiceRows\OrderInvoiceRow (1-∞)
Attribute | Code | Mand. | Description | Type |
Position | Y | Row position on the invoice | ||
SubPosition | Y | Subposition to line position | ||
Quantity | Y | Ordered quantity | ||
Price | Y | Price | ||
Vat | Y | VAT in percentage | ||
ProductUnit | Y | Product unit | 50 | |
SalesAccount | N | Optional account for recipients | 4 | |
VatAccount | N | VAT Account for the row | ||
IsFreight< |