WinBooks on Web allows you to import logistics documents of any type (sales or purchase quotations, orders, delivery notes, invoices & CN).
The field names in red can also be used for compatibility reason with Logistics Classic (Windows version).
| Field name | Logistics Classic | Type | Length | Dec. | Man-datory | Description | Example |
|---|---|---|---|---|---|---|---|
| LocalizedCodeLanguage | C | 2 | Yes | Language used in this file for the localized codes like Vat Code. | "fr" | ||
| Header fields | |||||||
JournalLogCode | jnl | C | 10 | Yes | Code of the invoicing journal (Logistics). | "INVCUST" | |
Number | number | N | 12 | 0 | Yes | Document number. | 1 |
Renumber | L | 1 | True (T) if the number must be renumbered (continuing the numbering of the journal in the logistics package). If Wow has to renumber your documents, start your numbering to 1 and Wow will add the last number of the journal to your numbers. The default value is F. | T | |||
| Date | date | D | 10 | Yes | Document date (YYYY/MM/DD). | 2016/04/30 | |
ThirdCode | thirdgroup | C | 10 | Yes | Customer or supplier code. | "BEBOP" | |
| ThirdReference | yourref | C | 256 | Reference for the third party | "Order 16053" | ||
| ThirdReference2 | C | 256 | For Vietnamese legislation only. Reference for the third party translated in the second language of the folder. | ||||
| ThirdComment | C | 2048 | Comment for the third party. It could be printed on the layout of the document. (field ThirdPartyComment) | ||||
| Reference | C | 256 | For Vietnamese legislation only. Field use to save the invoicing book serial number. | ||||
| CurrencyCode | currid | C | 3 | Currency code. | "USD" | ||
| CurrencyRate | currrate | N | 28 | 18 | Rate of the currency. The amount of the document / this currency rate = the amount in the folder currency. | 1.14 | |
| CurrencyRate2 | N | 28 | 18 | Rate of the alternative currency. Only if the folder manages an alternative currency. | |||
| PayCode | C | 10 | Payment terms. For example "30 days end of month". If not provided, the payment terms will be 1) the payment terms of the third party, 2) the settings of the folder. | "30EOM" | |||
| DueDate | datepay | D | 10 | Due date for payment (YYYY/MM/DD). | 2016/05/31 | ||
| PayMode | C | 10 | Mode of payment like Cash, Bank transfer, ... | "CASH" | |||
| DeliveryTerm | C | 10 | Dilevery terms like CIF, FOB, EXW, ... It's required for the intrastat statement. | "FOB" | |||
| DeliveryDateFrom | dlvdate1 | D | 10 | Date from which the delivery will start | 2016/05/15 | ||
| DeliveryDateTo | dlvdate2 | D | 10 | Date at which the delivery should be finished | 2016/05/21 | ||
| BookPeriodRelatedYear | N | 4 | invoice | Calendar year corresponding to the book period This field is required for invoice or credit note | 2016 | ||
| BookPeriodRelatedMonth | N | 2 | invoice | Month corresponding to the book period (1 = January, ..., 12 = December) This field is required for invoice or credit note | 4 | ||
| AgentCode | C | 10 | Code of the agent (salesman) | "JOHN" | |||
| Warehouse | C | 10 | This field can be filled only for JournalLog.Type = "STK.TRF" (stock transfer). It's the warehouse from where the goods are transferred. | ||||
| Warehouse2 | C | 10 | This field can be filled only for JournalLog.Type = "STK.TRF" (stock transfer). | ||||
| GlobalDiscountRate | L | 1 | Percentage of the global discount. Global discount has to be activated in the settings of the invoicing | ||||
| IsVatIncluded | L | 1 | Is the unit price VAT included If not specified, this field comes from JournalLog.IsVatIncluded | F | |||
| ConditionalDiscountRate | N | 5 | 2 | Percentage of the discount for a quick payment | |||
| ConditionalDiscountDueDate | D | 10 | Due date for the quick payment | ||||
| ConditionalDiscountCurrencyAmount | N | 12 | 2 | Amount of the discount in the currency of the document for a quick payment (ConditionalDiscountAmount and ConditionalDiscountAmount2 are computed) | |||
| SubscriptionIndexInitial | N | 12 | 2 | Only if JournalLog.Subscription = true Index of the cost of life at the date of the start of subscription | |||
| SubscriptionDateNext | D | 10 | Date of the next generation for the subscription | ||||
| SubscriptionDateEnd | D | 10 | Last date of the subscription | ||||
| IsClosed | L | 1 | Is the document closed? It means that the document does not need any action more. | F | |||
| IntrastatTransaction | N | 1 | Transaction type for intrastat statement. Value between 1 and 9 | 1 | |||
| IntrastatRegion | N | 1 | For Belgium only: 1 - Flemish region 2 - Walloon region 3 - Brussels region | 3 | |||
| IntrastatTransport | N | 1 | Transport used to move the goods. Value between 1 and 9 except 6. For example, 3 = Road | 3 | |||
| InvoicingAddressName * | C | 256 | Name of the company at this address The fields marked with a * in the name are key fields to identify an existing address. If none is found for the third party, a new address is created. Other fields are updated. | ||||
| InvoicingAddressAddress1 * | C | 256 | Street | ||||
| InvoicingAddressAddress2 * | C | 256 | Street 2 | ||||
| InvoicingAddressNumber * | C | 50 | Number in the street | ||||
| InvoicingAddressBox | C | 50 | box number if any | ||||
| InvoicingAddressCountryCode * | C | 3 | ISO 2 country code ("BE", "FR", "UK", ...) | ||||
| InvoicingAddressZip * | C | 50 | Zip code | ||||
| InvoicingAddressTown * | C | 256 | Name of the Town/City | ||||
| InvoicingAddressPhoneNo | C | 50 | Phone number | ||||
| InvoicingAddressFaxNo | C | 50 | Fax number | ||||
| DeliveringAddressXxxxxxxxx | Xxxxxxxx are the same fields as for InvoicingAddress | ||||||
| ContactTitle * | C | 50 | Contact for the document (if the option is activated). | ||||
| ContactFirstName * | C | 100 | First name of the contact | ||||
| ContactMiddleName * | C | 100 | Middle name | ||||
| ContactLastName * | C | 100 | Last name | ||||
| ContactSalutation * | C | 100 | Salutation is how we address the person when starting an email. For exampe "Dear John". | ||||
| ContactLanguageCode | C | 2 | Language code. For example "en" or "fr" or "nl". | ||||
| ContactMobilePhoneNumber | C | 1022 | Mobile phone number with the country prefix. For example "+32475123456". | ||||
| ContactBusinessPhoneNumber | C | 1022 | Fix phone number with the country prefix. For example "+3210451244". | ||||
| ContactBusinessEmailAddress | C | 1022 | Email address. For example "invoicing@mycompany.com". | ||||
| ContactSkypeIMAddress | C | 1022 | Skype ID. | ||||
| ToOutput | L | 1 | Does the system has to generate the PDF? | ||||
| ToSendByEmail | L | 1 | ToOutput has to be at true (T) to be able to activate this option. Does the system has to send the PDF by email? | ||||
| Custom[CustomFieldName] | ? | Custom field of the Document header | |||||
| Detail fields | |||||||
| ItemCode | artid | C | 20 | Code of the item. If the quantity or the unit price or the unit price vat included is specified, the item code or the name has to be provided. | "1001" | ||
| Quantity | qty | N | 12 | 4 | Quantity. | 1.00 | |
| UnitPrice | unitprice | N | 18 | 8 | Unit price VAT excluded. If IsVatIncluded = T (true), this field will be computed: = UnitPriceVatIncluded / (1 + Vat.Rate/100). | 95.00 | |
| UnitPriceVatIncluded | N | 18 | 8 | Unit price VAT included. If IsVatIncluded = T (true), this field will be computed: = UnitPrice * (1 + Vat.Rate/100). | |||
| Name | artname | C | 256 | Description of the row. By default it's the name of the item in the language of the third party. | "Helpdesk" | ||
| Name2 | For Vietnamese legislation only. Description in the alternative language. | ||||||
| DiscountRate | discount | N | 5 | 2 | Percentage of discount. | ||
| VatCode | vatid | C | 10 | Localized code for the VAT (see field LanguageLocalizedCode) or internal code for the VAT | "21" | ||
| Custom[CustomFieldName] | ? | Custom field of the Document detail | |||||
| LinkParentDocumentDetail_Id | docdetid2 | guid | Id of the linked document detail (source document) | ||||
| LinkType | N | 1 | Type of link. 1 - Previous (delivery -> order) 2 - NextCumulative (order client -> order supplier) | ||||
| LinkQuantity | N | 18 | 8 | Quantity for the link | |||
| StockTransactionWarehouseCode | stkid | C | 10 | Code of the warehouse | |||
| StockTransactionItemBatchSerialCode | lotserid | C | 20 | Batch or serial number of the item | |||
| StockTransactionType | N | 1 | Adjustement Consumed Input InternalTransfer Inventory None Output Reservation | ||||
| StockTransactionQuantity | qty | N | 18 | 8 | Quantity for stock (usually = Quantity) |
The file can be provided in CSV or in JSON.
If it is in CSV, the header fields have to be specified only on the first row of the document. If they are specified on the subsequent rows, they are ignored.
