One moment please...
 
 
Exact Financials   
 

Connectivity Manual - IFALL - Sales invoices

Sales invoices

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

Sales invoice header - LSIHL

Nr Field name Data type Field length Ref Description Check/Action
1 ADM_NR Integer 6 admdat Company number -
2 INVOICE_CODE Integer 8 llinvc Invoice code invoice code type must be sales invoice type 
3 SEQNR_LSIHL Integer 8 - Sequence number -
4 DEBTOR Integer 8 debtor Debtor debtor may not be blocked
5 INVOICE_DEBTOR Integer 8 debtor Invoice debtor debtor may not be blocked
6 REFERENCE Character 30 - Reference -
7 REFERENCE_1 Character 30 - Reference 1 -
8 REFERENCE_2 Character 30 - Reference 2 -
9 REFERENCE_3 Character 30 - Reference 3 -
10 SEQNR_LSOHL Integer 8 - Sales order number -
11 DELIVERY_DATE Date 10 - Delivery date -
12 EXDESCR_CODE Character 2 lldesc Extra description code -
13 REPRESENTATIVE Character 8 lsrep  Representative -
14 SEL_CODE Character 2 - Selection code -
15 CURR_CODE Character 3 curren Currency code currency may not be blocked
16 EXCH_RATE Decimal 12 - Exchange rate -
17 PAY_CONDITION Character 4 paycon  Payment condition -
18 DELIVERY_METHOD Character 8 lldome Delivery method -
19 COST_CODE Character 8 llcoc Cost code -
20 FREIGHT_COSTS Decimal 21 - Freight costs -
21 ORDER_COSTS Decimal 21 - Order costs -
22 VAT_CODE_FREIGHT_COSTS Character 3 vattrs VAT code freight costs VAT code must be sales or both
23 VAT_CODE_ORDER_COSTS Character 3 vattrs VAT code order costs VAT code must be sales or both
24 INVOICE_DISCOUNT_PERC Decimal 9 - Invoice discount percentage -
25 AMT_INC_VAT_INC_DISC Decimal 21 - Amount including VAT including discount -
26 APPROVED Logical 1 - Approved -
27 USERID_APPROVE Character 12 stuser User ID approver -
28 INVOICE_NR Integer 8 - Invoice number -
29 INVOICE_STATUS Integer 6 20401 = entered
20402 = printed
20403 = in entry		 Invoice status -
30 ORIGINAL_INVOICE_NR Integer 8  - Origianl invoice number -
31 DELIVERY_ADDRESS Character 8 delnac Delivery address -
32 DELIVERY_DEBTOR Integer 8 debtor Delivery debtor debtor may not be blocked 
33 TEXT_CODE Character 8 lltext Text code -
34 PAY_METHOD Integer 6 1 = cash
2 = bank
3 = giro
4 = collection 		Payment method -
35 LINE_AMT_EX_VAT_INC_LDISC Decimal 21 - Line amount excluding VAT including line discount -
36 FREIGHT_COSTS_EX_VAT_INC_DISC Decimal 21 - Freight costs excluding VAT including discount -
37 ORDER_COSTS_EX_VAT_INC_DISC Decimal 21 - Order cost excluding VAT including discount -
38 ORDER_COSTS_VAT Decimal 21 - Order costs VAT -
39 FREIGHT_COSTS_VAT Decimal 21 - Freight costs VAT -
40 INVOICE_DISCOUNT_AMT Decimal 21 - Invoice discount amount -
41 NR_PERIODS_ALLOCATION Integer 3 - Period allocation: Number of periods -
42 START_YEAR_ALLOCATION Integer 4 - Period allocation: Starting year Period allocation: Number of periods > 0 
43 START_PERIOD_ALLOCATION Integer 3 - Period allocation: Starting period Period allocation: Number of periods > 0
44 IMMEDIATE_PROCESSING Logical 1 - Immediate processing -
45 BANK_ACC_NR Character 34 curren Bank account -
46 CURR_CODE_BANK_ACC_NR Character 3 bnklnk Bank account currency -

Sales invoice lines - LSISL

Nr Field name Data type Field length Ref Description Check/Action
1 LINENR_LSISL Integer 4 - Line number -
2 ITEM_CODE Character 20 llitem Item code item type must be sales or both
3 DESCR Character 40 - Description -
4 QUANTITY Decimal 18 - Quantity -
5 LINENR_HORITM Integer 4 - Sales order line -
6 VAT_CODE Character 3 vattrs VAT code -
7 PRICELIST_CODE Character 3 llplst  Price list code price list type must be sales or both
8 PRICE Decimal 21 - Price -
9 LINE_DISCOUNT Decimal 21 - Line discount -
10 DISCOUNT_TYPE Integer 6 11501 = percentage
11502 = amount 		Discount type -
11 COST_CENTER Character 8 ccent Cost center -
12 COST_UNIT Character 8 cunit Cost unit -
13 DISCOUNT_CALCULATION Integer 6 10201 = calculate price list over line
10202 = calculate line over price list
10203 = calculate price list + line 		Discount calculation -
14 ACC_NR Character 8 ledger G/L account -
15 DELIVERY_DATE Date 10 - Delivery date -
16 TEXTLINE Character 1024 - Text line -
17 ITEMGROUP_CODE Character 8 lligrp  Item group -
18 PRO_PROJECT_CODE Character 10 prmst Project code -
19 PRO_COST_CAT_CODE Character 8 prccat Project cost cat code -
20 PRO_COST_CENTER Character 8 ccent Project cost center -
21 PRO_DESCRIPTION Character 30 - Project description -
22 SCP Decimal 18 - Standard costprice code -
23 PRICE_EX_VAT_EX_DISC Decimal 21 - Price ex vat ex disc -
24 AMT_EX_VAT_EX_DISC Decimal 21 - Amt ex vat ex disc -
25 LINE_DISC_AMT_EX_VAT Decimal 21 - Line disc amt ex vat -
26 AMT_EX_VAT_INC_DISC Decimal 21 - Amt ex vat inc disc -
27 PRICE_EX_VAT_INC_DISC Decimal 21 - Price ex vat inc disc -
28 LINE_VAT_AMT_INC_DISC Decimal 21 - Line vat amt inc disc -
29 AMT_INC_VAT_INC_DISC Decimal 21 - Amt inc vat inc disc -
30 MCODE1 Character 8 mdim1  Mdim code 1 -
31 MCODE2 Character 8 mdim2 Mdim code 2 -
32 MCODE3 Character 8 mdim3 Mdim code 3 -
33 MCODE4 Character 8 mdim4 Mdim code 4 -
34 MCODE5 Character 8 mdim5 Mdim code 5 -
Connectivity Manual > Contents > IFALL > Logistic > Sales invoices

     
 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.093
 Assortment: Exact Financials  Date: 03-12-2008
 Release:  Attachment:
 Disclaimer