Exact Financials

 

Connectivity Manual - IFALL - Purchase invoices

Purchase invoices

As of version 3.23 it is possible to import purchase invoices via EDIS. For this purpose tables have been added the the EDIS script for application EXACT. Those tables are LPEIH for the purchase invoice headers and LPEIL for the purchase invoice lines.

In the table below you see the fields that are available in those tables in applicaton EXACT, including their data types and field lengths. If you would like to make use of these new fields you need to update your EDIS script, information on this can be found here.

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
	Header (LPEIH)
1	ADM_NR	Integer	6	admdat	Company	Mandatory
2	INVOICE_NUMBER	Integer	8	lpeih	Purchase invoice number	Default: first free number from setting
3	INVOICE_STATUS	Integer	6	-	Status	Possible values: 32001 Entered (Default value for new purchase invoices; only valid value for new purchase invoices) 32005 Reentered (Value for updating existing purchase invoices that were set back to author)
4	CREDITOR	Integer	8	credit	Creditor	Mandatory
5	EXTERNAL_INVOICE_NUMBER	Character	10	-	External invoice number	Mandatory or not, depending on financial preference; must be unique per creditor. Default: from incoming invoice
6	INVOICE_CODE	Integer	3	llinvc	Invoice code	Mandatory; default from purchase setting
7	DESCRIPTION	Character	25	-	Description	Default: from incoming invoice
8	REFERENCE_1	Character	30	-	Reference 1	-
9	REFERENCE_2	Character	30	-	Reference 2	-
10	REFERENCE_3	Character	30	-	Reference 3	-
11	INVOICE_DATE	Date	8	-	Invoice date	Default: from incoming invoice; if not available then current date
12	INVOICE_OWNER	Character	8	iiown	Invoice owner	Mandatory; default from purchase setting
13	SELECTION_CODE	Character	2	-	Selection code	-
14	CURR_CODE	Character	3	curren	Currency	Default: from incoming invoice; if not available then from creditor; if no currency, then from default currency
15	EXCHANGE_RATE	Decimal	11	-	Exchange rate	Default: exchange rate of given currency on given invoice date
16	PAYMENT_CONDITION	Character	4	paycon	Payment condition	Default: from creditor; if no payment condition then from financial preferences
17	PAYMENT_REFERENCE	Character	20	-	Payment reference	Default: customer number of creditor + "/" + external invoice number + reference 1 + reference 2 + reference 3 + description (as long as the field length allows)
18	PAYMENT_METHOD	Integer	6	-	Payment method	Default: from creditor
19	DUE_DATE	Date	8	-	Due date	Default: calculated using payment condition and invoice date
20	PERCENTAGE_1	Decimal	5	-	Percentage 1	Default: calculated from payment condition
21	DUE_DATE_1	Date	8	-	Due date 1	Default: calculated from payment condition
22	AMOUNT_1	Decimal	17	-	Amount 1	Default: calculated from payment condition
23	PERCENTAGE_2	Decimal	5	-	Percentage 2	Default: calculated from payment condition
24	DUE_DATE_2	Date	8	-	Due date 2	Default: calculated from payment condition
25	AMOUNT_2	Decimal	17	-	Amount 2	Default: calculated from payment condition
26	PERCENTAGE_3	Decimal	5	-	Percentage 3	Default: calculated from payment condition
27	DUE_DATE_3	Date	8	-	Due date 3	Default: calculated from payment condition
28	AMOUNT_3	Decimal	17	-	Amount 3	Default: calculated from payment condition
29	PERCENTAGE_4	Decimal	5	-	Percentage 4	Default: calculated from payment condition
30	DUE_DATE_4	Date	8	-	Due date 4	Default: calculated from payment condition
31	AMOUNT_4	Decimal	17	-	Amount 4	Default: calculated from payment condition
32	PERCENTAGE_5	Decimal	5	-	Percentage 5	Default: calculated from payment condition
33	DUE_DATE_5	Date	8	-	Due date 5	Default: calculated from payment condition
34	AMOUNT_5	Decimal	17	-	Amount 5	Default: calculated from payment condition
35	INVOICE_DISCOUNT_PERC	Decimal	5	-	Invoice discount	Default: from creditor
36	COST_CODE	Character	8	llcoc	Cost code	Default: from creditor
37	ORDER_COSTS	Decimal	17	-	Order costs	Default: from cost code
38	VAT_CODE_ORDER_COSTS	Character	3	vattrs	VAT code	Default: from creditor; if no VAT code then from cost code
39	FREIGHT_COSTS	Decimal	17	-	Freight costs	Default: from cost code
40	VAT_CODE_FREIGHT_COSTS	Character	3	vattrs	VAT code	Default: from creditor; if no VAT code then from cost code
41	PAYMENT_DIFFERENCE	Decimal	17	-	Payment difference	-
42	AMT_INC_VAT_INC_DISC	Decimal	17	-	Purchase invoice amount	Default: calculated from other amounts
43	USERID_APPROVE	Character	12	euser	Approved by	When status that still needs approval, the field needs to be empty; otherwise default: userid of user currently logged in.
44	INVOICE_ORIGIN	Integer	6	-	Origin	Default: 32101 (Unknown). You can use 32103, which will show up in reports as 'Import'.
45	AMT_INC_VAT_INC_DISC_BLOCK	Decimal	17	-	Amount blocked account	-
46	EXTERNAL_SALES_ORDER_NUMBER	Character	8	-	External sales order number	-
47	EXTRA_DESCRIPTION_CODE	Character	2	lldesc	Extra description code	Default: from creditor
48	DELIVERY_DATE	Date	8	-	Required delivery date	-
49	DELIVERY_METHOD	Character	8	lldome	Delivery method	-
50	DELIVERY_ADDRESS	Character	8	admnac	Delivery address	-
51	NOTES	Character	1000	-	Notes	-
	Lines (LPEIL)
1	ADM_NR	Integer	6	admdat	Company	-
2	INVOICE_NUMBER	Integer	8	lpeih	Purchase invoice number	-
3	INVOICE_LINE_NUMBER	Integer	4	-	Purchase invoice line	Default: first free line number
4	ORDER_NUMBER	Integer	8	lpech	Purchase order number	Purchase order on which the purchase invoice line is based
5	ORDER_LINE_NUMBER	Integer	4	lpecl	Purchase order line	Line number of the purchase order on which the purchase invoice line is based
6	RECEIPT_NUMBER	Integer	8	lpecrh	Receipt number	Receipt on which the purchase invoice line is based
7	RECEIPT_LINE_NUMBER	Integer	4	lpecrl	Receipt line	Line number of the receipt on which the purchase invoice line is based
8	ITEM_CODE	Character	20	llitem	Item	If empty, the purchase invoice line will be handled as a text line
9	EXTERNAL_ITEM_CODE	Character	20	-	External item code	Default: from the combination of the item and the extra description code (from the header)
10	DESCRIPTION_LINE	Character	40	-	Description	Default: - For item line, from the item - For text line, from the text line field
11	TEXTLINE	Character	1000	-	Text line	Text for text item or text line. For a text item, the text must match the given template; for other items, this field should be left empty.
12	ITEMGROUP_CODE	Character	8	lligrp	Item group	Only for text lines; for item lines the field should be left empty
13	QUANTITY_INVOICED	Decimal	12	-	Quantity	-
14	VAT_CODE	Character	3	vattrs	VAT code	Default from creditor; if empty then from item; if empty then from goods account of item group
15	PRICE_EX_DISC	Decimal	12	-	Price	Default: from item. The price is excluding or including VAT depending on VAT code
16	PRICE_SURCHARGE	Decimal	12	-	Surcharge	Default: from item
17	COST_CENTER	Character	8	ccent	Cost center	Default: from purchase setting
18	COST_UNIT	Character	8	cunit	Cost unit	Default: from item group (as given or from given item); if empty then from purchase setting
19	MULTIDIM_CODE_1	Character	8	mdim1	Multi dimension 1	Default: from purchase setting
20	MULTIDIM_CODE_2	Character	8	mdim2	Multi dimension 2	Default: from purchase setting
21	MULTIDIM_CODE_3	Character	8	mdim3	Multi dimension 3	Default: from purchase setting
22	MULTIDIM_CODE_4	Character	8	mdim4	Multi dimension 4	Default: from purchase setting
23	MULTIDIM_CODE_5	Character	8	mdim5	Multi dimension 5	Default: from purchase setting
24	PROJECT_CODE	Character	10	prmst	Project	-
25	COST_CAT_CODE	Character	8	prccat	Cost category	If project field is filled, then this field is mandatory, otherwise it should be left empty
26	PROJECT_COST_CENTER	Character	8	ccent	Cost center	If project field is filled, then this field is mandatory and default filled from project master card or, if not available, from the receipt line cost center; otherwise it should be empty
27	PROJECT_DESCRIPTION	Character	30	-	Description project	If project is filled, default is the receipt number with the reference; otherwise it should be empty
28	ASSET_CODE	Character	12	fas_ast	Asset	If filled, it should be a new asset. Note that when the asset quantity is greater than 1, the given asset code will be extended with numbers, indicating the separate assets, created for this receipt line
29	ASSET_SET	Character	8	fas_mast	Asset set	Mandatory if the asset code has been filled; otherwise it should be left empty
30	ASSET_QUANTITY	Decimal	12	-	Quantity asset	Mandatory if the asset code has been filled; otherwise it should be left empty. It indicates the number of assets that will be created.
31	ASSET_DESCRIPTION	Character	30	-	Description asset	If asset code is filled, default from receipt line description; otherwise it should be left empty
32	DISCOUNT_TYPE	Integer	6	-	Discount type	Possible values: 11501 Percentage (Default value) 11502 Amount
33	LINE_DISCOUNT_PERC	Decimal	5	-	Line discount percentage	If discount type is amount, it should (if filled) correspond to the value calculated from the given line discount amount
34	LINE_DISCOUNT_AMT	Decimal	17	-	Line discount amount	If discount type is percentage, it should (if filled) correspond to the value calculated from the given line discount percentage
35	GET_RECEIPT	Logical	1	-	Receipt	Default: from item (if given) or from purchase setting (for text lines); if setting is optional, then default FALSE
36	DELIVERY_DATE_LINE	Date	8	-	Required delivery date	Default: delivery date from header
37	LOCATION_CODE	Character	8	fas_loc	Location	Default: from item; if empty then from purchase setting.
38	PRICELIST_CODE	Character	3	llplst	Price list	Default: from creditor
39	DISCOUNT_CALCULATION	Integer	6	-	Discount calculation	Possible values: 10201 Price list discount over line discount (Default value) 10202 Line discount over price list discount 10203 Price list discount plus line discount

 

Note that when a purchase order or a receipt has been filled, together with a line number, the defaults for all fields available in that purchase order or receipt, will be taken from that entity.

---

Connectivity Manual > Contents > IFALL > Logistic > Purchase 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.230
Assortment:	Exact Financials	Date:	03-12-2008
Release:		Attachment:
Disclaimer