One moment please...
 

Item import IDF

 

Items;Startline
Items;Sourcetype
Items;Decimalseparator
Items;Delimiter
items;Options
items;Textqualifier
Items;Itemcode
Items;ItemType
--S=Standard, B=Bulk, C=Contract, L=Labor hours, M=Machine hours, P=Phantom
Items;SearchCode
Items;Description
Items;MultiDescription0
Items;MultiDescription1
Items;MultiDescription2
Items;MultiDescription3
Items;MultiDescription4
Items;Itemgroup
--refers to the itemassorment number (ItemAssortment.Assortment field), this is the Item Group code shown in the Item maintenance
Items;ItemgroupCode
--refers to the itemassortment code (ItemAssortment.Code field), this is the alphanumeric code shown in the Item Group maintenance
Items;ItemgroupDescription
Items;ItemgroupGLRevenue
Items;ItemgroupGLCosts
Items;ItemgroupGLPurchase
Items;ItemgroupGLPriceDifferences
Items;ItemgroupGLItemsToBeReceived
Items;ItemgroupCostunit
Items;Longdescription
Items;DateStart
Items;DateStartFormat
Items;DateEnd
Items;DateEndFormat
Items;Condition
--A=Active, B=Blocked, D=Discontinued, E=Inactive, F=Future
Items;SalesItem
Items;PurchaseItem
Items;SerialnumberItem
Items;BatchItem
Items;SubAssemblyItem
Items;AssembledItem
Items;StockItem;
Items;BackOrderItem
Items;FractionAllowed
Items;PriceRegulation
Items;DiscountItem
Items;ExplodeItem
Items;TextItem
Items;GlRevenue
Items;GlCosts
Items;GlPurchase
Items;SalesPrice
Items;SalesUnit
Items;SalesCur
Items;SalesVATcode
Items;CostPrice;
Items;CostCurrency
Items;WeightNet
Items;WeightGross
Items;IntrastatEnabled
Items;StatisticalNumber
Items;StatisticalUnits
Items;ValuationMethod
Items;Extratextcode1
Items;Extratext1
Items;Extratextcode2
Items;Extratext2
Items;Extratextcode3
Items;Extratext3
Items;Extratextcode4
Items;Extratext4
Items;Extratextcode5
Items;Extratext5
Items;TaxItemClassification;
--ICP (ESL) Classification: 10 - Goods, 20 - Services
--These are the Item assortments as shown in the Item maintenance.
--The ItemcategoryDescription is needed to create a new Itemcategory (assortment)
Items;Itemcategory1 
Items;ItemcategoryDescription1
Items;Itemcategory2
Items;ItemcategoryDescription2
Items;Itemcategory3
Items;ItemcategoryDescription3
Items;Itemcategory4
Items;ItemcategoryDescription4
Items;Itemcategory5
Items;ItemcategoryDescription5
Items;Itemcategory6
Items;ItemcategoryDescription6
Items;Itemcategory7
Items;ItemcategoryDescription7
Items;Itemcategory8
Items;ItemcategoryDescription8
Items;Itemcategory9
Items;ItemcategoryDescription9
Items;Itemcategory10
Items;ItemcategoryDescription10
Items;Warehouse
Items;WarehouseDefault
Items;WarehouseLocation
Items;WarehouseCostprice
Items;StockMin
Items;StockMax
Items;OrderPolicyCode
--F Fixed, L Lot for lot, P Period order, R Reorder point
Items;WarehousePeriod
Items;CountingCycle
Items;Supplieraccountcode
Items;Supplierdefaultyn
Items;Supplieritemcode
Items;Supplierapprovedyn
Items;Suppliereancode
Items;Supplierwarranty-not available in exact
Items;Purchaseprice
Items;Purchasecurrency
Items;Purchasevatcode
Items;Purchaseunit
Items;Purchasepackage
Items;Slspkgsperpurpkg
Items;Purchaseordersize
Items;Deliverablefromstock
Items;DropShip
Items;Deliverytimeindays
Items;ShelfLife
Items;Warrenty
Items;IsServiceItem
Items;ItemRelationItemCode
Items;ItemRelationType
--0 Standard included, 100 Mandatory, 200 Optional, 300 Illegal
Items;ItemRelationState
--0 default, 10 Mandatory, 11 Mandatory one of set, 12 Mandatory at least one, 13 Mandatory one Or none, 20 Optional, 21 Optional one of set, 30 Replacement, 40 Trade in, 90 Invalid
Items;ItemRelationQuantity
Items;BOMversionnumber
Items;BOMDescription
Items;BOMMainversion
Items;BOMPositionnumber
Items;BOMCondition
Items;BOMEffectiveDate
Items;BOMEffectiveDateFormat
Items;BOMLineExpiryDate
Items;BOMLineExpiryDateFormat
Items;BOMDrawingNo
Items;BOMCostPrice
Items;BOMQuantity
Items;BOMWarehouse

Items;BOMFREETEXT1
Items;BOMFREETEXT2
Items;BOMFREETEXT3
Items;BOMFREETEXT4
Items;BOMFREETEXT5
Items;BOMFREETEXT6
Items;BOMFREETEXT7
Items;BOMFREETEXT8
Items;BOMFREETEXT9
Items;BOMFREETEXT10
Items;BOMFREETEXT11
Items;BOMFREETEXT12
Items;BOMFREETEXT13
Items;BOMFREETEXT14
Items;BOMFREETEXT15
Items;BOMFREETEXT16
Items;BOMFREETEXT17
Items;BOMFREETEXT18
Items;BOMFREETEXT19
Items;BOMFREETEXT20
Items;BOMFREETEXT21
Items;BOMFREETEXT22
Items;BOMFREETEXT23
Items;BOMFREETEXT24
Items;BOMFREETEXT25
Items;BOMFREETEXT26
Items;BOMFREETEXT27
Items;BOMFREETEXT28
Items;BOMFREETEXT29
Items;BOMFREETEXT30
Items;BOMFREEDATE1
Items;BOMFREEDATE2
Items;BOMFREEDATE3
Items;BOMFREEDATE4
Items;BOMFREEDATE5
Items;BOMFREEDATE1FORMAT
Items;BOMFREEDATE2FORMAT
Items;BOMFREEDATE3FORMAT
Items;BOMFREEDATE4FORMAT
Items;BOMFREEDATE5FORMAT
Items;BOMFREENUMBER1
Items;BOMFREENUMBER2
Items;BOMFREENUMBER3
Items;BOMFREENUMBER4
Items;BOMFREENUMBER5
Items;BOMFREENUMBER6
Items;BOMFREENUMBER7
Items;BOMFREENUMBER8
Items;BOMFREENUMBER9
Items;BOMFREENUMBER10
Items;BOMFREENUMBER11
Items;BOMFREENUMBER12
Items;BOMFREENUMBER13
Items;BOMFREENUMBER14
Items;BOMFREENUMBER15
Items;BOMFREENUMBER16
Items;BOMFREENUMBER17
Items;BOMFREENUMBER18
Items;BOMFREENUMBER19
Items;BOMFREENUMBER20
Items;BOMFREEAMOUNT1
Items;BOMFREEAMOUNT2
Items;BOMFREEAMOUNT3
Items;BOMFREEAMOUNT4
Items;BOMFREEAMOUNT5
Items;BOMFREEAMOUNT6
Items;BOMFREEYESNO16
Items;BOMFREEYESNO17
Items;BOMFREEYESNO18
Items;BOMFREEYESNO19
Items;BOMFREEYESNO20

Items;BOMLineType
--B = By-product, I = Item, L = Labor hour, M = Machine hour, T = Text
Items;BOMLineSequenceNumber
Items;BOMLineItemcode
Items;BOMLineCondition
--F = Phantom, N = Always, O = Optional, P = Packaging, S = Once per delivery, U = Once per debtor, W = Waste, Z = Phantom zero lead time
Items;BOMLineBackFlush
Items;BOMLineEffectiveDate
Items;BOMLineEffectiveDateFormat
Items;BOMLineExpiryDate
Items;BOMLineExpiryDateFormat
Items;BOMLineCostPrice
Items;BOMLineQuantity
Items;BOMLineWarehouse
Items;BOMLineOperation
Items;BOMLineStep
Items;BOMLineManualCostPrice
Items;BOMLineNote

Items;BOMLINEFREETEXT1
Items;BOMLINEFREETEXT2
Items;BOMLINEFREETEXT3
Items;BOMLINEFREETEXT4
Items;BOMLINEFREETEXT5
Items;BOMLINEFREETEXT6
Items;BOMLINEFREETEXT7
Items;BOMLINEFREETEXT8
Items;BOMLINEFREETEXT9
Items;BOMLINEFREETEXT10
Items;BOMLINEFREETEXT11
Items;BOMLINEFREETEXT12
Items;BOMLINEFREETEXT13
Items;BOMLINEFREETEXT14
Items;BOMLINEFREETEXT15
Items;BOMLINEFREETEXT16
Items;BOMLINEFREETEXT17
Items;BOMLINEFREETEXT18
Items;BOMLINEFREETEXT19
Items;BOMLINEFREETEXT20
Items;BOMLINEFREETEXT21
Items;BOMLINEFREETEXT22
Items;BOMLINEFREETEXT23
Items;BOMLINEFREETEXT24
Items;BOMLINEFREETEXT25
Items;BOMLINEFREETEXT26
Items;BOMLINEFREETEXT27
Items;BOMLINEFREETEXT28
Items;BOMLINEFREETEXT29
Items;BOMLINEFREETEXT30
Items;BOMLINEFREEDATE1
Items;BOMLINEFREEDATE2
Items;BOMLINEFREEDATE3
Items;BOMLINEFREEDATE4
Items;BOMLINEFREEDATE5
Items;BOMLINEFREEDATE1FORMAT
Items;BOMLINEFREEDATE2FORMAT
Items;BOMLINEFREEDATE3FORMAT
Items;BOMLINEFREEDATE4FORMAT
Items;BOMLINEFREEDATE5FORMAT
Items;BOMLINEFREENUMBER1
Items;BOMLINEFREENUMBER2
Items;BOMLINEFREENUMBER3
Items;BOMLINEFREENUMBER4
Items;BOMLINEFREENUMBER5
Items;BOMLINEFREENUMBER6
Items;BOMLINEFREENUMBER7
Items;BOMLINEFREENUMBER8
Items;BOMLINEFREENUMBER9
Items;BOMLINEFREENUMBER10
Items;BOMLINEFREENUMBER11
Items;BOMLINEFREENUMBER12
Items;BOMLINEFREENUMBER13
Items;BOMLINEFREENUMBER14
Items;BOMLINEFREENUMBER15
Items;BOMLINEFREENUMBER16
Items;BOMLINEFREENUMBER17
Items;BOMLINEFREENUMBER18
Items;BOMLINEFREENUMBER19
Items;BOMLINEFREENUMBER20
Items;BOMLINEFREEAMOUNT1
Items;BOMLINEFREEAMOUNT2
Items;BOMLINEFREEAMOUNT3
Items;BOMLINEFREEAMOUNT4
Items;BOMLINEFREEAMOUNT5
Items;BOMLINEFREEAMOUNT6
Items;BOMLINEFREEYESNO1
Items;BOMLINEFREEYESNO2
Items;BOMLINEFREEYESNO3
Items;BOMLINEFREEYESNO4
Items;BOMLINEFREEYESNO5

Items;Freetext1
Items;Freetext2
Items;Freetext3
Items;Freetext4
Items;Freetext5
Items;Freetext6
Items;Freetext7
Items;Freetext8
Items;Freetext9
Items;Freetext10
Items;Freedate1
Items;Freedate2
Items;Freedate3
Items;Freedate4
Items;Freedate5
Items;Freenumber1
Items;Freenumber2
Items;Freenumber3
Items;Freenumber4
Items;Freenumber5
Items;Freenumber6
Items;Freenumber7
Items;Freenumber8
Items;Freenumber9
Items;Freenumber10
Items;Freenumber11
Items;Freenumber12
Items;Freenumber13
Items;FreeYesNo1
Items;FreeYesNo2
Items;FreeYesNo3
Items;FreeYesNo4
Items;FreeYesNo5


Doc id: 00.000.843