Connectivity Manual - IFALL - Items
Items
As of version 3.21 items can be imported items via EDIS. The table llitem has been added to the script for application 'EXACT'. In the table below you see the fields that have been added to application 'EXACT' including their data types and field lengths. The new EDIS script is automatically imported when upgrading to version 3.21.
| 1 |
ADM_NR |
Integer |
6 |
admdat |
Company number |
- |
| 2 |
ITEM_CODE |
Character |
20 |
- |
Item code |
- |
| 3 |
ITEM_TYPE |
Integer |
6 |
1 |
Item type |
Default: 23903 (Both) |
| 4 |
ITEMGROUP_CODE |
Character |
8 |
lligrp |
Item group code |
- |
| 5 |
DESCR |
Character |
40 |
- |
Description |
- |
| 6 |
SHORT_DESCR |
Character |
13 |
- |
Short description |
- |
| 7 |
SALES_PRICE |
Decimal |
14 |
- |
Sales price |
Can only be filled for items of types sales and both |
| 8 |
PURCHASE_PRICE |
Decimal |
14 |
- |
Purchase price |
Can only be filled for items of types purchase and both |
| 9 |
STANDARD_COST_PRICE |
Decimal |
14 |
- |
Standard cost price |
- |
| 10 |
PRICE_SURCHARGE |
Decimal |
14 |
- |
Surcharge price |
Can only be filled, if the item group has a surcharge account |
| 11 |
VAT_CODE_SALES |
Character |
3 |
vattrs |
VAT code sales |
- |
| 12 |
VAT_CODE_PURCHASE |
Character |
3 |
vattrs |
VAT code purchase |
- |
| 13 |
UNIT_CODE |
Character |
8 |
units |
Unit code |
- |
| 14 |
LOCATION_CODE |
Character |
8 |
fas_loc |
Location code |
- |
| 15 |
REVENUE_STATISTICS |
Logical |
1 |
- |
Revenue statistics |
Default: TRUE |
| 16 |
STOCK_ITEM |
Logical |
1 |
- |
Stock item |
Default FALSE |
| 17 |
TEXT_ITEM |
Logical |
1 |
- |
Text item |
Default: FALSE |
| 18 |
DISCONTINUED_ITEM |
Logical |
1 |
- |
Discountinued item |
Default: FALSE |
| 19 |
GET_RECEIPT |
Logical |
1 |
- |
Get receipt |
Default: FALSE; can only be filled for items of type purchase and both |
| 20 |
DESCR_ML_1 |
Character |
40 |
- |
Multi language description 1 |
|
| 21 |
DESCR_ML_2 |
Character |
40 |
- |
Multi language description 2 |
- |
| 22 |
ITEM_TEXT |
Character |
1024 |
- |
Item text |
Can only be filled for text items. |
| 23 |
DESCR_ML_3 |
Character |
40 |
- |
Multi language description 3 |
- |
| 24 |
DESCR_ML_4 |
Character |
40 |
- |
Multi language description 4 |
- |
| 25 |
DESCR_ML_5 |
Character |
40 |
- |
Multi language description 5 |
- |
| 26 |
EXTRA_DESCRIPTION_CODE |
Character |
2 |
lldesc |
Extra description code |
|
| 27 |
EXTRA_DESCRIPTION_TEXT |
Character |
512 |
- |
Extra description text |
It is possible to define one extra item description per item. This description is stored in table llides. To establish a link with table llides a second link rule needs to be defined. |
| 28 |
EXTERNAL_ITEM_CODE |
Character |
20 |
- |
External item code |
Can only be filled, when an extra description code has been entered |
- 23901: purchase
23902: sales
23903: both
Connectivity Manual >
Contents >
IFALL > Logistic >
Items
| 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.045 |
| Assortment: |
Exact Financials
|
Date: |
03-12-2008 |
| Release: |
|
Attachment: |
|
| Disclaimer |