XConnector Import Definition Recipies


	XConnector Import Definition Recipies

Items;Startline;
Items;Sourcetype;
Items;Itemcode;
Items;ItemType;
--S=Standard, B=Bulk, C=Contract, L=Labor hours, M=Machine hours, P=Phantom
Items;SearchCode
Items;Decimalseparator
Items;Delimiter
Items;Options
Items;Textqualifier
Items;Description
Items;MultiDescription1
Items;MultiDescription2
Items;MultiDescription3
Items;MultiDescription4
Items;Itemgroup
--refers to the itemassorment number (ItemAssortment.Assortment field)
Items;ItemgroupCode
--refers to the itemassortment code (ItemAssortment.Code field)
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;StockMin
Items;StockMax
Items;StatisticalNumber
Items;StatisticalUnits
Items;Extratextcode1
Items;Extratext1
Items;Extratextcode2
Items;Extratext2
Items;Extratextcode3
Items;Extratext3
Items;TaxItemClassification;
--ICP (ESL) Classification: 10 - Goods, 20 - Services
Items;Itemcategory1
Items;Itemcategory2
Items;Itemcategory3
Items;Itemcategory4
Items;Itemcategory5
Items;Itemcategory6
Items;Itemcategory7
Items;Itemcategory8
Items;Itemcategory9
Items;Itemcategory10
Items;Warehouse
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;Deliverytimeindays
items;BOMversionnumber;
items;BOMDescription;
items;BOMMainversion;
items;BOMPositionnumber;
items;BOMCondition;
items;BOMEffectiveDate;
items;BOMEffectiveDateFormat;
items;BOMDrawingNo;
items;BOMCostPrice;
items;BOMQuantity;
items;BOMLineType;

items;BOMLineSequenceNumber;

--- BOMLineSequenceNumber is mandatory

items;BOMLineItemcode;
items;BOMLineCondition;

items;BOMLineBackFlush;

--- BOMLLineBackFlush is mandatory "0" or "1"

items;BOMLineEffectiveDate;
items;BOMLineEffectiveDateFormat;
items;BOMLineExpiryDate;
items;BOMLineExpiryDateFormat;
items;BOMLineCostPrice;
items;BOMLineQuantity;
items;BOMLineOperation;
items;BOMLineStep;
items;BOMLineManualCostPrice;
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;FreeYesNo1
Items;FreeYesNo2
Items;FreeYesNo3
Items;FreeYesNo4
Items;FreeYesNo5
-------Shortened version--------
Items;ItemType;"S"
--S=Standard, B=Bulk, C=Contract, L=Labor hours, M=Machine hours, P=Phantom
Items;SearchCode
Items;Decimalseparator
Items;Delimiter
Items;Options
Items;Textqualifier
Items;Description;
Items;MultiDescription1
Items;MultiDescription2
Items;MultiDescription3
Items;MultiDescription4
Items;Itemgroup
--refers to the itemassorment number (ItemAssortment.Assortment field)
Items;BOMversionnumber;"1"
Items;BOMDescription;"Version 1"
Items;BOMMainversion;"1"
Items;BOMPositionnumber
Items;BOMCondition
Items;BOMEffectiveDate;
Items;BOMEffectiveDateFormat
Items;BOMDrawingNo
Items;BOMCostPrice;
Items;BOMQuantity;
Items;BOMLineType;
Items;BOMLineSequenceNumber;
Items;BOMLineItemcode;
Items;BOMLineCondition
Items;BOMLineBackFlush;
Items;BOMLineEffectiveDate
Items;BOMLineEffectiveDateFormat
Items;BOMLineExpiryDate
Items;BOMLineExpiryDateFormat
Items;BOMLineCostPrice;
Items;BOMLineQuantity;
Items;BOMLineOperation
Items;BOMLineStep;
Items;BOMLineManualCostPrice

Doc id: 00.004.763