Connectivity Manual C/S - Sales orders
Sales orders
Import file: orders.csv
| 1
| linenr_lsosl
| INT
| N4
| B
| -
| Order line
| -
| -
|
| 2
| debtor
| INT
| N8
| H
| debtor
| Debtor
| -
| -
|
| 3
| item_code
| CHAR
| A20
| S
| llitem
| Item
| -
| -
|
| 4
| textline
| CHAR
| A2000
| S
| -
| Text line
| -
| -
|
| 5
| acc_nr or itemgroup-code
| INT/CHAR
| N8/A9
| S
| ledger/lligrp
| Account number/Item group
| -
| -
|
| 6
| quantity
| DEC
| N9,3
| S
| lsrep
| Quantity
| -
| -
|
| 7
| price
| DEC
| N9,3
| S
| -
| Price
| -
| ?=Price defined in maintenance items
|
| 8
| seqnr_lsohl
| INT
| N8
| B
| -
| Order number
| Setting
| -
|
| 9
| invoice_debtor
| INT
| N8
| H
| debtor
| Invoice debtor
| -
| *
|
| 10
| delivery_debtor
| INT
| N8
| H
| debtor
| Delivery debtor
| -
| -
|
| 11
| delivery_method
| CHAR
| A8
| H
| lldome
| Delivery method
| -
| *
|
| 12
| delivery_address
| CHAR
| A8
| H
| delnac
| Delivery address
| -
| -
|
| 13
| representative
| CHAR
| A8
| H
| lsrep
| Representative
| -
| *
|
| 14
| order_date
| DATE
| DD/MM/YYYY
| H
| -
| Order date
| -
| Current date
|
| 15
| delivery_date
| DATE
| DD/MM/YYYY
| H
| -
| Delivery date
| -
| *
|
| 16
| reference
| CHAR
| A30
| H
| -
| Reference
| -
| -
|
| 17
| reference_1
| CHAR
| A30
| H
| -
| Reference 1
| -
| -
|
| 18
| reference_2
| CHAR
| A30
| H
| -
| Reference 2
| -
| -
|
| 19
| reference_3
| CHAR
| A30
| H
| -
| Reference 3
| -
| -
|
| 20
| text_code
| CHAR
| A8
| H
| lltext
| Text code
| -
| -
|
| 21
| exdescr_code
| CHAR
| A2
| H
| lldesc
| Extra description code
| -
| -
|
| 22
| curr_code
| CHAR
| A3
| H
| curren
| Currency code
| -
| *
|
| 23
| exch_rate
| DEC
| N5,6
| H
| -
| Exchange rate
| -
| *
|
| 24
| pay_condition
| CHAR
| A4
| H
| paycon
| Payment condition
| -
| *
|
| 25
| sel_code
| CHAR
| A2
| H
| -
| Selection code
| -
| -
|
| 26
| order_discount_perc
| DEC
| N3,2
| H
| -
| Order discount
| -
| -
|
| 27
| cost_code
| CHAR
| A8
| H
| llcoc
| Cost code
| -
| *
|
| 28
| freight_costs
| DEC
| N15,2
| H
| -
| Freight costs
| -
| -
|
| 29
| vat_code_freight_cost
| CHAR
| A3
| H
| vattrs
| VAT code freight costs
| -
| -
|
| 30
| order_costs
| DEC
| N15,2
| H
| -
| Order costs
| -
| -
|
| 31
| vat_code_order_costs
| CHAR
| A3
| H
| vattrs
| VAT code freight costs
| -
| -
|
| 32
| amt_inc_vat_inc_disc
| DEC
| N15,2
| H
| -
| Order amount
| -
| -
|
| 33
| approved
| LOG
| Y/N
| H
| -
| Approved
| -
| -
|
| 34
| userid_approve
| CHAR
| A12
| H
| euser
| Approved by
| -
| Current date
|
| 35
| on_hold
| LOG
| Y/N
| H
| -
| On hold
| -
| No
|
| 36
| descr
| CHAR
| A40
| S
| -
| Description
| -
| -
|
| 37
| quantity_backorder
| DEC
| N9,3
| S
| -
| Quantity backorder
| -
| -
|
| 38
| vat_code
| CHAR
| A3
| S
| vattrs
| VAT code
| -
| *
|
| 39
| cost_center
| CHAR
| A8
| S
| ccent
| Cost center
| -
| *
|
| 40
| cost_unit
| CHAR
| A8
| S
| cunit
| Cost unit
| -
| *
|
| 41
| pricelist_code
| CHAR
| A3
| S
| llplst
| Price list code
| -
| *
|
| 42
| discount_type
| INT
| N6
| S
| -
| Discount type
| 11501/11502
| ?=11501
|
| 43
| line_discount
| DEC
| N15,2
| S
| -
| Line discount
| -
| -
|
| 44
| discount_calculation
| INT
| N6
| S
| -
| Discount calculation
| 10201/10202/10203
| ?=10201
|
| 45
| EXTRA-calc_rate
| CHAR
| A1
| H
| -
| Exchange rate type
| 0/1
| Setting
|
| 46
| PRO-project_code
| CHAR
| A10
| S
| prmst
| Project code
| -
| -
|
| 47
| PRO-cost_cat_code
| CHAR
| A8
| S
| prcat
| Project cost category
| -
| -
|
| 48
| PRO-project_cost_center
| CHAR
| A8
| S
| ccent
| Project cost center
| -
| -
|
| 49
| PRO-project_descr
| CHAR
| A30
| S
| -
| Project description
| -
| - |
General remarks:
If the setting 'Change debtor data' in the sales settings is not activated, the following fields needs to be filled with a "?", to retrieve the default data:
| 9
| Invoice debtor
|
| 10
| Delivery debtor
|
| 11
| Delivery method
|
| 13
| Representative
|
| 22
| Currency code
|
| 24
| Payment condition
|
| 27
| Cost code
|
| 38
| VAT code
|
| 41
| Price list code |
If the setting 'Change item data' in the sales settings is not activated, the following fields needs to be filled with a "?", to retrieve the default data:
| 7
| Sales price
|
| 36
| Description |
Clarification of the fields:
| 1
| 0 for headers, ? for sublines (the first available line number will be taken.)
|
| 3
| This item should be marked as 'Sales' item or 'Both'.
|
| 5
| This line is only used when you want to enter a sales order for a text line. In the sales settings in [File, Company settings, Sales settings], you can indicate whether you want to keep revenue statistics of text lines. If you have activated this option, an item group should be entered in this field. If you did not activate this option, a ledger account should be entered here.
|
| 9
| The invoice debtor linked to the debtor (field 3) is used as default. If no invoice debtor is linked to the debtor, the debtor will be used.
|
| 11
| If a "?" is entered, the delivery method linked to the debtor will be used.
|
| 13
| If a "?" is entered, the representative linked to the debtor will be used. If no representative is linked to the debtor, the representative defined in the sales settings will be used.
|
| 15
| Delivery date = order date + number of delivery days defined in Sales settings.
|
| 22
| When entering a "?", the currency code linked to the invoice debtor will be used as default. In case no default code is linked, the currency code defined in the settings will be used.
|
| 23
| When entering a "?" the current exchange rate will be used.
|
| 24
| When entering a "?", the payment condition linked to the invoice debtor will be used as default, if no payment condition is linked, the payment condition defined in the settings will be used.
|
| 27
| When entering a "?", the cost code linked to the invoice debtor, will be used as default. If no cost code is linked and you enter, the cost code defined in the settings will be used.
|
| 28-31
| If you have entered a cost code in field 28 and you enter a "?" in these fields, the fields will automatically be calculated. If the field 'Cost code' is left empty these fields can be filled manually. Please mind that the VAT codes should be of the type 'Sales' or 'Both'.
|
| 33
| If the setting 'Approve sales order' is disabled, this field will be ignored.
|
| 34
| If you enter a "?", the current user will be the approver of the invoice.
|
| 37
| If the quantity entered in field 6, quantity, is larger than the quantity that is on stock, the quantity ordered that is not in stock will automatically be put in backorder.
|
| 38
| If "?" is entered, the VAT code linked to the invoice debtor will be used as default.
|
| 39
| If "?" is entered, the cost center linked to the representatives will be used as default. If no cost center is linked to the representative, the cost center defined in the sales settings will be used as default.
|
| 40
| If "?" is entered, the cost unit linked to the item group will be used as default.
|
| 41
| If "?" is entered, the price list linked to the debtor will be used as default.
|
| 42
| 11501 = Discount is percentage (Used as default
when "?" is entered.)
11502 = Discount is amount
|
| 44
| 10201 = Price list discount over line
discount(Used as default when "?" is entered.)
10202 = Line discount
over price list discount
10203 = Price list discount plus line discount
|
| 45
| If you want to use Anglo-Saxon notation (Euro notation) for exchange rates you should enter 1, if you want to use the 'old' exchange rate enter 0. If this field is left empty, the settings you defined in the financial preferences in [File, Company settings, Financial preferences] on the 'Miscellaneous' tab.
|
| 46-49
| These fields will only be filled if you defined in [File, Company settings, Financial preferences] that a project link is optional or mandatory and the
ledger account involved is marked as a project account. In case you have
set this option to 'Optional' it is possible to import project data. In
case you have set this option to 'Mandatory' the entry will be rejected if
you do not enter project data. |
Connectivity Manual C/S - Contents
> Data import > Exact Sales C/S
> Sales orders
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
01.642.834 |
| Assortment: |
Exact Financials (v3)
|
Date: |
09-09-2005 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|