One moment please...
 
 
Exact Financials   
 

Connectivity Manual - IFALL - Sales orders

Sales orders

As of version 3.27 sales orders can be imported using the Exact Data Interface System.

The table below lists the fields available in application 'EXACT' including their data types and field lengths. To use these new fields you need to update your EDIS script, information can be found here.

Sales orders - LSOHL

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company number -
2 ORDER_NUMBER Integer 8 - Order number -
3 ORDER_STATUS Integer 6 1 Order status -
4 INTERNAL_ORDER Logical 1 - Internal order -
5 REFERENCE Character 30 - Reference -
6 REFERENCE_1 Character 30 - Reference 1 -
7 REFERENCE_2 Character 30 - Reference 2 -
8 REFERENCE_3 Character 30 - Reference 3 -
9 DEBTOR Integer 8 debtor Debtor -
10 INVOICE_DEBTOR Integer 8 debtor Invoice debtor -
11 REPRESENTATIVE Character 8 - Representative -
12 ORDER_DATE Date 10 - Order date -
13 SELECTION_CODE Character 2 - Selection code -
14 EXTRA_DESCRIPTION_CODE Character 2 lldesc Extra description code -
15 TEXT_CODE Character 8 lltext Text code -
16 CURR_CODE Character 3 curren Currency code -
17 EXCHANGE_RATE Decimal 13 - Exchange rate -
18 DELIVERY_DEBTOR Integer 8 debtor Delivery debtor -
19 DELIVERY_DATE Date 10 - Delivery date -
20 DELIVERY_METHOD Character 8 lldome Delivery method -
21 DELIVERY_ADDRESS Character 8 delnac Delivery address -
22 PAYMENT_CONDITION Character 4 paycon Payment condition -
23 PAYMENT_METHOD Integer 6 2 Payment method -
24 ORDER_DISCOUNT_PERC Decimal 7 - Order discount percentage -
25 COST_CODE Character 8 llcoc Cost code -
26 VAT_CODE_ORDER_COSTS Character 3 vattrs VAT code order costs -
27 LINE_AMT_EX_VAT_INC_LDISC Decimal 23 - Line amount ex VAT incl disc -
28 ORDER_COSTS Decimal 23 - Order costs -
29 VAT_CODE_FREIGHT_COSTS Character 3 vattrs VAT code freight costs -
30 FREIGHT_COSTS Decimal 23 - Freight costs -
31 ORDER_COSTS_EX_VAT_INC_DISC Decimal 23 - Order costs ex VAT inc discoun -
32 FREIGHT_COSTS_EX_VAT_INC_DISC Decimal 23 - Freight costs ex VAT incl disc -
33 ORDER_DISCOUNT_AMT Decimal 23 - Order discount amount -
34 ORDER_COSTS_VAT Decimal 23 - Order costs VAT -
35 FREIGHT_COSTS_VAT Decimal 23 - Freight costs VAT -
36 AMT_INC_VAT_INC_DISC Decimal 23 - Amount incl VAT incl discount -
37 USERID_APPROVE Character 12 euser User ID approve -
38 ON_HOLD Logical 1 - On hold -
  1. 21401: entered
    21402: confirmed
    21403: back order
    21404: in entry
    21405: placed
    21406: approved
  2. 1: cash
    2: bank
    3: giro
    4: collect

Sales order lines - LSOSL

Nr Field name Data type Field length Ref Description Check/Action
1 ORDER_LINE_NUMBER Integer 4 - Order line number -
2 ITEM_CODE Character 20 llitem Item code -
3 DESCRIPTION Character 40 - Description -
4 QUANTITY Decimal 16 - Quantity -
5 QUANTITY_BACKORDER Decimal 16 - Quantity back order -
6 ITEMGROUP_CODE Character 8 lligrp Item group code -
7 ACC_NR Character 9 ledger G/L account number -
8 VAT_CODE Character 3 vattrs VAT code -
9 PRICE_SURCHARGE Decimal 16 - Price surcharge -
10 PRICE Decimal 16 - Price -
11 COST_CENTER Character 8 ccent Cost center -
12 COST_UNIT Character 8 cunit Cost unit -
13 MULTIDIM_CODE_1 Character 8 - Multi dimension code 1 -
14 MULTIDIM_CODE_2 Character 8 - Multi dimension code 2 -
15 MULTIDIM_CODE_3 Character 8 - Multi dimension code 3 -
16 MULTIDIM_CODE_4 Character 8 - Multi dimension code 4 -
17 MULTIDIM_CODE_5 Character 8 - Multi dimension code 5 -
18 PROJECT_CODE Character 10 prmst Project code -
19 COST_CAT_CODE Character 8 prccat Cost category code -
20 PROJECT_COST_CENTER Character 8 ccent Project cost center -
21 PROJECT_DESCRIPTION Character 30 - Project description -
22 AMT_EX_VAT_EX_DISC Decimal 23 - Amount ex VAT ex discount -
23 PRICELIST_CODE Character 3 llplst Price list code -
24 DISCOUNT_TYPE Integer 6 1 Discount type -
25 LINE_DISCOUNT Decimal 23 - Line discount -
26 DISCOUNT_CALCULATION Integer 6 2 Discount calculation -
27 AMT_EX_VAT_INC_DISC Decimal 23 - Amount ex VAT incl discount -
28 AMT_INC_VAT_INC_DISC_LINE Decimal 23 - Amount inc VAT inc line discou -
29 LINE_VAT_AMT_INC_DISC Decimal 23 - Line VAT amount incl discount -
30 LINE_DISC_AMT_EX_VAT Decimal 23 - Line discount amount ex VAT -
31 PRICE_EX_VAT_EX_DISC Decimal 16 - Price ex VAT ex discount -
32 PRICE_EX_VAT_INC_DISC Decimal 16 - Price ex VAT incl discount -
33 LINE_STATUS Integer 6 3 Line status -
34 TEXTLINE Character 1500 - Text line -
  1. 11501: percentage
    11502: amount
  2. 10201: price list discount over line discount
    10202: line discount over price list discount
    10203: price list discount plus line discount
  3. 21601: entered
    21602: back order
    21603: final
Connectivity Manual > Contents > IFALL > Logistic > 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: 18.330.068
 Assortment: Exact Financials  Date: 03-12-2008
 Release:  Attachment:
 Disclaimer