Exact Financials

 

Connectivity Manual - IFALL - Purchase orders

Purchase orders

As of version 3.15 it is possible to import purchase orders via EDIS. For this purpose tables have been added the the EDIS script for application EXACT. Those tables are LPEOH for the purchase order headers and LPEOL for the purchase order 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 . Please find the required file attached to this document.

Nr	Field name	Data type	Field length	Ref table	Description	Check/Action
	Header record (LPEOH)
1	adm_nr	Integer	6	admdat	Company number	Mandatory
2	order_number	Integer	8	-	Purchase order number	Default: next free number from setting
3	order_status	Integer	6	-	Order status	See below for details
4	creditor	Integer	8	credit	Creditor	Mandatory
5	selection_code	Character	2	-	Selection code
6	external_sales_order_number	Character	8	-	External sales order number
7	buyer_code	Character	12	euser	Buyer	Default from creditor; if creditor has no buyer, then user ID of current user.
8	curr_code	Character	3	curren	Currency	Default from creditor; if creditor has no currency, then default currency of financial preferences
9	order_date	Date	2/2/4	-	Order date	Deafult: current date
10	exchange_rate	Decimal	5.6	-	Exchange rate	Default: exchange rate from given currency on given order date
11	payment_condition	Character	4	paycon	Payment condition	Default: from creditor; if creditor has no payment condition, then default payment condition creditor from financial preferences
12	payment_method	Decimal	2	-	Payment method	Default: from creditor. See below for details
13	reference	Character	30	-	Reference
14	reference_1	Character	30	-	Extra reference 1
15	reference_2	Character	30	-	Extra reference 2
16	reference_3	Character	30	-	Extra reference 3
17	extra_description_code	Character	2	lldesc	Extra item description	Deafult: from creditor
18	text_code	Character	8	lltext	General text code	Default: from purchase setting
19	order_method	Character	8	lldome	Order method	Default: from creditor
20	order_address	Character	8	crdnac	Order address
21	delivery_date	Date	2/2/4	-	Delivery date	Default: order date as entered
22	delivery_method	Character	8	lldome	Delivery method	Default: from purchase setting
23	delivery_address	Character	8	admnac	Delivery address
24	line_amt_ex_vat_ex_ldisc	Decimal	15.4	-	Total line amount (excluding VAT and line discount)	When filled, the value should correspond to the value calculated from the given purchase order lines
25	line_discount_amt_ex_vat	Decimal	15.4	-	Line discount amount (excluding VAT)	When filled, the value should correspond to the value calculated from the given purchase order lines
26	cost_code	Character	8	llcoc	Cost code	Default: from creditor; if creditor has no cost code, then from purchase setting
27	vat_code_order_costs	Character	3	vattrs	VAT code for order costs	Default: from cost code; if cost code not filled or has no VAT code, then from creditor
28	invoice_discount_perc	Decimal	3.2	-	Invoice discount percentage	Default: from creditor
29	order_costs	Decimal	15.4	-	Order costs	Default: from cost code (if entered). The amount is excluding or including VAT, depending on VAT code
30	order_costs_ex_vat	Decimal	15.4	-	Order costs excluding VAT	When filled, the value should correspond to the value calculated from given order costs and VAT code
31	vat_code_freight_costs	Character	3	vattrs	VAT code for freight costs	Default: from cost code; if cost code not filled or has no VAT code, then from creditor
32	freight_costs	Decimal	15.4	-	Freight costs	Default: from cost code (if entered). The amount is excluding or including VAT, depending on VAT code
33	freight_costs_ex_vat	Decimal	15.4	-	Freight costs excluding VAT	When filled, the value should correspond to the value calculated from given freight costs and VAT code
34	invoice_discount_amt	Decimal	15.4	-	Invoice discount amount (excluding VAT)	When filled, the value should correspond to the value calculated from given invoice discount percentage
35	line_vat_amount	Decimal	15.4	-	VAT over line amount	When filled, the value should correspond to the value calculated from given line amounts
36	order_costs_vat	Decimal	15.4	-	VAT over order costs	When filled, the value should correspond to the value calculated from given order costs and VAT code
37	freight_costs_vat	Decimal	15.4	-	VAT over freight costs	When filled, the value should correspond to the value calculated from given freight costs and VAT code
38	invoice_discount_vat	Decimal	15.4	-	VAT over invoice discount	When filled, the value should correspond to the value calculated from given invoice discount percentage and line VAT amount
39	amt_inc_vat_inc_disc	Decimal	15.4	-	Total amount including VAT and all discounts	When filled, the value should correspond to the value calculated from the other amounts
40	userid_approve	Character	12	euser	User that approved the purchase order	When status that still needs approval, the field needs to be empty; otherwise default: userid of user currently logged in.
41	order_origin	Integer	6	-	Origin of the order	See below for details
42	notes	Character	2000	-	Notes
	Line record (LPEOL)
1	order_line_number	Integer	4	-	Purchase order line number	Default: first free line number
2	item_code	Character	20	llitem	Item	If left empty, the purchase order line will be handled as a text line.
3	external_item_code	Character	20	-	External item code	Default: from combination of item and extra description code
4	get_receipt	Logical		-	Get receipt	Default: from item (if given) or from purchase setting (for text lines); if setting is optional, then default FALSE
5	textline	Character	2000	-	Text line	Text for text lines and text items; text item texts need to match the template of the item. For 'normal' items it should be empty
6	description	Character	40	-	Description	Default: from given text line if filled, or from item
7	quantity_ordered	Decimal	9.3	-	Quantity
8	vat_code	Character	3	vattrs	VAT code	Default: from item; if empty then from creditor; if empty then '0'
9	itemgroup_code	Character	8	lligrp	Item group	Only used for text lines; mandatory then, otherwise it should be empty
10	amount_surcharge	Decimal	4.2	-	Surcharge	Default: from item
11	price_ex_disc	Decimal	9.4	-	Price excluding line discount	Default: from item. The price is excluding or including VAT depending on VAT code
12	delivery_date_line	Date	2/2/4	-	Delivery date	Default: delivery date from header
13	commitment_number	Integer	8	comhl	Commitment number	Not yet implemented
14	commitment_line	Integer	4	comsl	Commitment line number	Not yet implemented
15	location_code	Character	8	fas_loc	Location	Default: from item; if empty then from purchase setting. This field is mandatory when 'Get receipt' is TRUE
16	cost_center	Character	8	ccent	Cost center	Default: from purchase setting
17	cost_unit	Character	8	cunit	Cost unit	Default: from item group (as given or from given item); if empty then from purchase setting
18	multidim_code_1	Character	8	mdim1	Dimension 1	Default: from purchase setting
19	multidim_code_2	Character	8	mdim2	Dimension 2	Default: from purchase setting
20	multidim_code_3	Character	8	mdim3	Dimension 3	Default: from purchase setting
21	multidim_code_4	Character	8	mdim4	Dimension 4	Default: from purchase setting
22	multidim_code_5	Character	8	mdim5	Dimension 5	Default: from purchase setting
23	project_code	Character	10	prmst	Project
24	cost_cat_code	Character	8	prccat	Cost category	If project filled, then mandatory; otherwise it should be empty
25	project_cost_center	Character	8	ccent	Cost center for project	If project filled, then mandatory (default from project); otherwise it should be empty
26	project_description	Character	30	-	Description for project	If project filled, then default purchase order number + reference; otherwise it should be empty
27	amt_ex_vat_ex_disc	Decimal	15.4	-	Line amount excluding VAT excluding line discount	When filled, the value should correspond to the value calculated from quantity and price
28	pricelist_code	Character	3	llplst	Price list	Default: from creditor
29	discount_type	Integer	6	-	Type of line discount	See below for details
30	line_discount_perc	Decimal	3.2	-	Line discount percentage	If discount type is amount, it should (if filled) correspond to the value calculated from the given line discount amount
31	line_discount_amt	Decimal	15.4	-	Line discount amount	If discount type is percentage, it should (if filled) correspond to the value calculated from the given line discount percentage
32	discount_calculation	Integer	6	-	Discount calculation method	See below for details
33	amt_ex_vat_inc_disc	Decimal	15.4	-	Line amount excluding VAT including line discount	When filled, the value should correspond to the value calculated
34	amt_inc_vat_inc_disc_line	Decimal	15.4	-	Line amount including VAT including line discount	When filled, the value should correspond to the value calculated
35	line_vat_amt_ex_disc	Decimal	15.4	-	VAT over line amount excluding line discount	When filled, the value should correspond to the value calculated
36	standard_cost_price	Decimal	9.4	-	Standard cost price	When filled, the value should correspond to the value of the given item.
37	asset_code	Character	12	fas_ast	Asset	Not yet implemented

Special field handling:

Nr	Remarks
Header record (LPEOH)
3	Possible values: 31601 Entered (Default value for entering new purchase orders; only allowed value for new purchase orders) 31602 Approved (No update allowed; not allowed to set status to the value) 31603 Disapproved (No update allowed; not allowed to set status to the value) 31604 Placed (No update allowed; not allowed to set status to the value) 31605 Confirmed (No update allowed; not allowed to set status to the value) 31606 Rejected (No update allowed; not allowed to set status to the value) 31607 Reentered (Update allowed; value allowed for updating existing purchase orders that were set back to author) 31608 In use (No update allowed; not allowed to set status to the value) 31609 Back to author (Update allowed; only value allowed for updating such a purchase orders is 'reentered')
12	Possible values:  1 Cash  2 Bank  3 Giro  4 Collection  5 Giro collection  6 Cheques  7 BACS  8 Only remittances  9 Bills of exchange 10 Bills of exchange direct to bank
41	Possible values: 31501 Unknown (Default value) 31502 Entry 31503 Import
Line record (LPEOL)
29	Possible values: 11501 Percentage (Default value) 11502 Amount
32	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

 

---

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