Page tree
Paskaidrojumu kolonnaformat
(Kolonnu nepieciešams izdzēst pirms importa)14610000.
codepageUTF-8
HansaVersion
7.2 2014-10-31 (build 72250742)
artikel5
Kolonnas nr123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
LatviskiUUIDServerSequenceSyncFlagsCodeNameUnittextMinLevelObjectsSalesAccUPrice1ItemTypeGroupx1x2InPriceInvCodeExtraCostSerNrfDepartmentWeightVolumeEUCodexInCurncyCodeBonusRecepyMarkupx3BarCodeUpdateCostLastPriceChangeCalcPriceVATCodePriceFactorTerminatedAvgMarkupLastPurchPriceLastPurchCurncyCodeWeighedAvPriceConversion1Conversion2WarrantyLengthInvRecepyEUSalesAccExpSalesAccVATCodeEUVATCodeExpChangePriceRebCodeExplodeRecUnittext2UnitCoefficientWarnText1VARListItemMaterialAlcPrcDefaultSourceAlternativeCodeCostAccDefLocationLastBasePriceChangeMaxLevelLastPurchPrice2WidthHeightDepthContractItemInternalInclItemFreightFixedFreightDispGroupsHazLevCodeDensityxClassificationCredSalesAccCredEUSalesAccCredExpSalesAccCredVATCodeCredVATCodeEUCredVATCodeExpRentalItemCompUsagecolnrVARMaskVARRepOrderVARSubsetsLocAreaEKNCodeDefPalletItemQtyonPalletPalletWidthPalletHeightPalletDepthBrandBrandTypePickAreaSWWCodeRepaPricePerWeightPalletsInPickAreaDefPosWidthDefPosHeightDefPosDepthInPriceB2WeighedAvPriceB2EUCostAccExpCostAccPalletLayersQtyonPalletLayerUserStr1UserStr2UserStr3UserStr4UserStr5UserVal1UserVal2UserVal3UserDate1UserDate2UserDate3RentGroupFAGroupNetWeightPrimaryCostModelQueuedCostModelCostPercFIFOPerSerialNrFIFOPerLocationWAPerLocationCostPricePerLocationNotForSalesSRUpdateCostSuppSerialNrMajStoneDetColourClarityCertMinStoneDetMetalRowWeightSizeLengthWatchBrandStyleNameWatchMetalMovementBrcStrGenderOtherOther2ReferencePerceptionsWithholdingsTaxTemplateCodeTaxTemplateCodeEUTaxTemplateCodeExpDonotRequireBatchNrOnIVCashHotelWIPAccCPSCodeSVOInvbleSalesAccSVOWarrantySalesAccSVOContractSalesAccSVOGoodwillSalesAccSVOInvbleCostAccSVOWarrantyCostAccSVOContractCostAccSVOGoodwillCostAccHasExcise
EnglishNo.DesriptionUnitMinimum levelObjectsSales A/CBase priceItem typeGroupCost priceShelf codeExtra costSerial number trackingDepartmentWeightItem volumeCommodity codeBonus %RecipeMarkup %BarcodeUpd. Cost Price at Goods ReceiptCost price changeItem formulaDom. VAT codePrice factorClosedLast Pur. Cost (incl. extras)Last Purchase CurrencyWeighted averageConversion 1Conversion 2Warranty monthsInvoice recipeEU sales A/CExport sales A/CEU VAT codeExport VAT codePaste components during entryUnit 2Unit coefficientWarningTreat Item as Material on ProjectAlcohol %Default sourceAlternative codeDom. Cost A/CBase price changeMaximum levelLast Pur. Price (excl. extras)WidthHeightDepthContract itemInclude Item Fixed ChargeFixed freightClassificationHazard levelTihedusRental invoiceingComponents usageColourVariety maskReport orderSubsetsDefault location areaEKN codeDefault pallet itemMax. Qty on palletFull pallet widthHeightDepthPicking areaEnvironment Tax per KiloPallets in picking areaDefault position widthHeightDepthCost price in B2Weighted Av., Base 2EU cost A/CExport cost A/CPallet layersQty per layerNet weightPrimary cost modelQueued Cost Model%Cost price for serial numberQueued Cost Model per LocationWA per LocationNot for salesUpd. Cost Price at Stock RevaluationMajor stone detailColourClarityCertificateMinor stone detailMetalWeightSizeLengthWatch brandStyle nameWatch metalMovementBracelet/StrapGenderOtherOther 2ReferenceCalculate perception taxesCalculate withholding taxesDom. Tax tem.EU tax temp.Export tax temp.Do not Require Batch No. on POS InvoiceHotel WIP A/CClassification of Products and ServicesServ. Invble Sales A/CServ. Warranty Sales A/CServ. Contract Sales A/CServ. Goodwill Sales A/CServ. Invble Cost A/CServ. Warranty Cost A/CServ. Contract Cost A/CServ. Goodwill Cost A/CHas excise0
Datubāzes identifikatorsNr.AprakstsVienība (GAB/KG/..)Min. DaudzObjektiRealizāc. KontsCenaArtikula tipsGrupaPašizmaksaPlaukta nr.Papildizm.Sērijas numursDepartamentsSvarsArtik. TilpumsEAN kodsPrēmijas %SpecifikācijaUzcenojumsSvītru kodsPašizmaksa pie preču saņemšanasPašizm. IzmaiņasCenas formulaViet. PVNkodsCenas faktorsSlēgtsPēd.pašizm.(ar papildizm.)Pēdējā pirkuma valūtaVidējā svērtāDaudzums 1Daudzums 2Garantijas mēnešiRēķina specifikācijaEU realiz. KontsExporta realiz.EU pvn kodsEksporta PVN kodsIevietot sastāvdaļas ievadotVienība 2KoeficientsBrīdinājumsProjektos uzskatīt par nol. artikuluAlkohols %Info par art. IzcelsmiĪsais nosaukumsViet. Izm. KontsCenas izmaiņasMaks. DaudzumsPēd.pašizm.(bez papildizm.)Artik. PlatumsAugstumsBiezumsLīguma artikulsIekļaut artikula piegādes izmaksasPiegādeArtikulu klasePiesārņ. LīmenisBlīvumsNomas rēķiniKomponentesKrāsaVariāciju šablonsSecība atskaitēsApakškomplektsSaņemšanas vietaEKN kodsNokl. Paletes artikulsMaks. Daudz. Uz paletesPaletes platumsAugstumsBiezumsSaņemšanas vietaVides nodoklis par kgPaletes iekraušanas vietāNokl. Pozīcijas platumsAugstumsBiezumsPašizmaksa B2Vidējā svērtā bāzes 2EU izm kontsEksporta izm. KontsKārtas paletēDaudz. KārtāNeto svarsPrimārais izmaksu modelisRindas izmaksu modelisPašizmaksa pa sēriju numuriemRindas izmaksu modelis pa nolikt.Vid. svērtā pa noliktavāmNav paredzēt pārdošanaiAtjaunot pašizm. pie pārvērtēšanasPamatakmensKrāsaTīrībaSertifikātsPapildu akmensMetālsSvarsIzmērsGarumsPulksteņa zīmolsStila nosaukumsPulksteņa metālsIzplatībaSprādzeDzimumaCitsCits 2AtsauksmeAprēķināt ienākuma nodokliAprēķināt ieturētos nodokļusViet. Nod. VeidneEU nod. VeidneĀrpus ES nod. VeidneNeprasīt partijas nr. POS rēķināViesn.nepab.raž.kontsPreču un pakalpojumu klasifikācijaServ.realiz.kontsServ.garantijas realiz.kontsServ.līguma realiz.kontsNemat.vērt.realiz.kontsServ.izm.kontsServ.garantijas izm.kontsServ.līguma izm.kontsNemat.vērt.izm.kontsIr akcīze
Extra comments0 - vienkāršs; 1 - noliktavas; 2 - structured item; 3 - service item0 - none; 1 - unit number; 2 - batch number0 - no; 1 - Last Purchase Cost (incl. extras); 2 - Weighted Average; 3 - Last Purchase Cost (excl. extras)0 vai 10 or 10 or 10 or 10 - default; 1 - cost price; 2 - % of base price; 3 - weighted average; 4 - queued; 5 - none0 - default; 1 - FIFO price; 2 - LIFO price0 - default; 1 - Cost Price not for Serial Number; 2 - Cost Price for Serial Number0 - default; 1 - Queued Cost not per Location; 2 - Queued Cost per Location0 - default; 1 - WA not per Location; 2 - WA per Location0 or 10 - no; 1 - last revaluation cost; 2 - weighted average0 or 10 or 10 or 10 or 1
Lauka tips un garumsUUID,0M4Long,0M4Long,0M4Code,20M4Str,100M4Str,10M4Qty,0M4UStr,60M4Code,10M423Val,0M4Int,0M4Code,5M4Dummy,0M4Dummy,0M45Val,0M4Code,10M4Val,0M4Int,0M4Code,10M45Val,0M45Val,0M4Code,20M4Code,5M4Qty,0M4Code,20M4Qty,0M4Dummy,0M4Code,20M4Int,0M4Date,0M4Code,5M4Code,10M45Val,0M4Int,0M4Val,0M45Val,0M4Code,5M45Val,0M45Val,0M45Val,0M4Qty,0M4Code,20M4Code,10M4Code,10M4Code,10M4Code,10M4Int,0M4Code,5M4Int,0M4Str,10M45Val,0M4Str,255M4UStr,30M4Int,0M4UVal,0M4Code,10M4Str,40M4Code,10M4Code,10M4Date,0M4Qty,0M45Val,0M4UVal,0M4UVal,0M4UVal,0M4Code,20M4Int,0M4Int,0M4Val,0M4UStr,200M4Code,5M45Val,0M4UStr,200M4Code,10M4Code,10M4Code,10M4Code,10M4Code,10M4Code,10M4Code,20M4Code,10M4Set,46M4UStr,60M4UStr,60M4UStr,200M4Code,20M4Code,20M4Code,20M4UVal,0M4UVal,0M4UVal,0M4UVal,0M4Str,60M4Str,60M4Code,20M4Str,60M4Val,0M4UVal,0M4UVal,0M4UVal,0M4UVal,0M45Val,0M45Val,0M4Code,10M4Code,10M4UVal,0M4UVal,0M4Str,255M4Str,255M4Str,255M4Str,255M4Str,255M4UVal,0M4UVal,0M4UVal,0M4Date,0M4Date,0M4Date,0M4Code,5M4Code,5M45Val,0M4Int,0M4Int,0M4Val,0M4Int,0M4Int,0M4Int,0M4Int,0M4Int,0M4Int,0M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,20M4Str,60M4Int,0M4Int,0M4Code,10M4Code,10M4Code,10M4Int,0M4Code,10M4Str,60M4Code,10M4Code,10M4Code,10M4Code,10M4Code,10M4Code,10M4Code,10M4Code,10M4Int,0M4Code,10M4Set,433M4Date,0M4Val,0M4Val,0M4Int,0
Matricas kolonnas nr12
Matricas nosaukums latviskiValodaTeksts
Matrix definitionLanguageText
Matricas lauka datubāzes identifikātorsLangCodeText
Matricas lauka tips un garumsM4Code,5M4Str,100
Artikula piemērsBEB707FD-218055AB-07CD7E08-952B82C7-3E4A901E1103mm 7x9 cinkotā tÄ“rauda trosem210.401210.150025/12/201000.15LVL0.150001/14/20050.15000.00WIRE,RAZ200.070.070000000000000
Artikula matricas ierakstsLATMatricas lauks īsām piezīmēm
Artikula matricas ierakstsENGMatrix field for short notes
Artikula piezīmju lauka ierakstsPiezīmju rinda garākiem ierakstiem. Field for notes (row) for longer texts
Inventory article entry15C55448-4FDE3E9C-5FF5307C-D08DCAD3-056EE48901035651HHT klāja krāsa 750mlGAB1027.9311018.870750.00750.0001000001000325/12/201000.0018.64LVL18.870.000.00000001/30/2001018.64000.00PAINT0Oct-75Oct-750000000000000
Inventory article matrix entryENGHT'S high protect
Inventory article Notes field entryThis field (row) is meant for long notes
58C8008E-41E37672-D0ADA80F-9FEE0D20-79DE1C2601065941IINTERNATIONAL Interdeck klāja krāsa 750mlGAB1024.9411017.8500.000.0001000001000425/12/201000.0018.34GBP17.850.000.00000001/31/2001017-Jul000.00PAINT0Dec-50Dec-500000000000000
D5CF4391-C16E74F4-E30CD6D4-B5ED7ECD-1DCF670A01071115IINTERNATIONAL špahtele koka jahtām 750mlGAB1024.9411025.1800.000.0001000001000525/12/201000.0068.77GBP25.180.000.00000001/31/2001064.03000.00PAINT017.1517.150000000000000
CD496596-D143D1CB-6A669698-B5FBEC0C-DC6D2665014X18DAL140x180mm DAL masta sekcijaM30Jul-27130Apr-6400.000.0001000001000625/12/201000.00Apr-64LVLApr-640.000.00000001/31/20010Apr-64000.00STRIG0Mar-17Mar-170000000000000
0F067792-C8682687-EB882677-144C082F-9E044552016X20DAL160x200mm DAL masta sekcijam30Aug-54130May-8500.000.0001000001000725/12/201000.00May-85LVLMay-850.000.00000001/31/20010May-85000.00STRIG0Mar-82Mar-820000000000000
F9AA5FE8-E62399B0-242408A2-6AA1CAD4-F736F153022500Masta stiprinājumiGAB229-Apr122Apr-2700.000.00025/12/201000.00Apr-58GBPApr-270.000.00000001/31/20010Apr-27000.00WIRE0Feb-98Feb-980000000000000
5BEB6F80-C5BFB0A3-2E66B591-2D857414-AD9223C2022C4C veida uzgalis 4mm GAB220.871220.4300.000.00025/12/201000.000.46LVL0.430.000.00000001/31/200100.46000.00STM00.280.280000000000000
1B381B9D-6D6169E4-242836A8-76206337-573F5CF8022C5C veida uzgalis 5mm GAB22Jan-151220.5800.000.00025/12/201000.000.58LVL0.580.000.00000001/31/200100.58000.00STM00.410.410000000000000
C9A13AA1-DB5541D4-7C334848-C6BAFAFC-4B02BFB2022C6C veida uzgalis 6mm GAB22Jan-441220.7200.000.00025/12/201000.000.73LVL0.720.000.00000001/31/200100.73000.00STM00.450.450000000000000
EC3CEDFC-7F66F723-DD0C7325-A3C6A211-F7EE8203022O4O veida uzgalis 4mm GAB220.871220.4300.000.00025/12/201000.000.43LVL0.430.000.00000001/31/200100.43000.00STM00.300.300000000000000
7A5A573D-C889B1BB-D5EBCD7E-A3137F22-1F1F5EB7022O5O veida uzgalis 5mm GAB22Jan-151220.5900.000.00025/12/201000.000.65LVL0.590.000.00000001/31/200100.65000.00STM00.410.410000000000000
40AC81F0-889263FE-8B090A7F-91D837A6-0C308BF2022O6O veida uzgalis 6mm GAB22Jan-441220.7100.000.00025/12/201000.000.71LVL0.710.000.00000001/31/200100.71000.00STM00.430.430000000000000
CC537C68-B9B9BA70-2C2845C5-81B3EFBB-9E5B08AA022T4T veida uzgalis 4mm GAB220.871220.4300.000.00025/12/201000.000.43LVL0.430.000.00000001/31/200100.43000.00STM00.210.210000000000000
9E6219A6-24CD0447-4EB0C25B-681299F1-BA851E98022T5T veida uzgalis 5mm GAB22Jan-151220.5700.000.00025/12/201000.000.55LVL0.570.000.00000001/31/200100.55000.00STM00.310.310000000000000
94F512BD-584BF975-64DE0A1B-40145529-A54D5552022T6T veida uzgalis 6mm GAB22Jan-441220.7100.000.00025/12/201000.000.71LVL0.710.000.00000001/31/200100.71000.00STM00.350.350000000000000
8A528CDB-E7793B2D-DEDE4BFA-BADEB838-334D020C07X14DAL70x140mm DAL masta sekcijam30Feb-99130Jan-9900.000.00025/12/201000.00Jan-99LVLJan-990.000.00000001/31/20010Jan-99000.00STRIG00.980.980000000000000
17C28284-53C5C1D7-E7469730-76BC810A-3D312F6E07X19CT55mm 7x19 cinkotā tērauda trosem210.631210.2700.000.00021/31/200100.000.27LVL0.270.000.00000001/30/200100.27000.00WIRE00000000000000
A598192B-E1B81CB5-B8D47433-6F13C403-DA2572FA07X19NT44mm 7x19 nerūsošā tērauda trosem200.731200.3700.000.00021/31/200100.000.37LVL0.370.000.00000001/30/200100.37000.00WIRE00000000000000
3D8AF07E-FB363247-9E13D5A2-5B1BA6D8-6067D0AB07X9CT44mm 7x9 cinkotā tērauda trosem210.441210.2000.000.00021/31/200100.000.20LVL0.200.000.00000001/30/200100.20000.00WIRE00000000000000
8C747E37-DC19EA72-46DBA1B6-E680AB72-5909DC8907X9CT55mm 7x9 cinkotā tērauda trosem210.481210.2100.000.00025/12/201000.000.21LVL0.210.000.00000001/30/200100.21000.00WIRE00.150.150000000000000
287077DF-F25A9B2C-D22EF352-4D812190-62E62AC207X9CT66mm 7x9 cinkotā tērauda trosem210.551210.2100.000.00024/13/200100.000.21LVL0.210.000.00000001/30/200100.21000.00WIRE00000000000000
0999E31A-C5F59E4D-9FE77425-BEADB297-9FFD2F9007X9NT44mm 7x9 nerūsošā tērauda trosem200.601200.3000.000.00025/12/201000.000.30LVL0.300.000.00000001/30/200100.30000.00WIRE00.210.210000000000000
E114D859-59A5E157-FBEC392F-066C89FE-2B4543E807X9NT55mm 7x9 nerūsošā tērauda trosem200.681200.4100.000.00025/12/201000.000.41LVL0.410.000.00000001/30/200100.41000.00WIRE00.290.290000000000000
CFFBA7C9-F76585C0-647D2E97-723B7C5D-9989479509X14DAL90x140mm DAL masta sekcijam30Mar-43130Feb-3500.000.00025/12/201000.00Feb-35LVLFeb-350.000.00000001/31/20010Feb-35000.00STRIG0Jan-16Jan-160000000000000
13F1D263-4BB305C1-E49ACD87-8CC72D21-01135AC90AA1TestsGAB17-Jul1AA0211/11/200400.000000AA411/11/200400200000000000000
7967A5D2-C39A36AD-146C18BC-5A1F72CE-11A52D1A0PANProjekta analīzeGAB42.693PK00.000.00022/24/2010100.000.000.000000Sem2/24/20100000.000.00200000000000000
CBED325F-C8599A0D-6081D2E4-C6010E43-88A9234E0PIEGPreču piegādeTRANS0TRANS00.000.00001/30/200100.000.000.000.000.00000001/30/200100.00000.0000000000000000
5FAE5AB7-2A7F08A7-BBF80933-121C5644-A6962D120S1Strādnieku darbs stundasGAB42.693PK00.000.00022/24/2010100.000.000.000000Sem2/24/20100000.000.00200000000000000
F8F42327-52E53692-1E93D04B-FDD79ECC-194B43301S3s3esport00012/12/20140000012/12/201400200000000000000
TEKSTtesksktksktska
TEAasdfas
EAadasiofasidf
LATfasdfasdf
CFE00B88-563611B0-3F2CC30E-78AB3ECE-F6AEE4B00SEMISemināri parH142.29000.000.000210/13/2003100.000.000.000000Sem10/13/20030000.000.0000000000000000
08F85F6A-6D8B9E7B-9BF268D6-9A78D667-FD206CF10T420Takelāžas komplekts 420 klases jahtaiGAB80498.0118000.000.00021/31/200100.000.000.000.000.00000001/31/200100.00000.00TC00000000000000
2942C6AA-A1D52D17-F79B2C87-5E6B4714-529A7A510T470Takelāžas komplekts 470 klases jahtaiGAB80654.5218000.000.00025/12/201000.00LVL0.000.000.00000001/31/20010000.00TC00.000000000000000
341B143D-1EBCF3D3-D88C703D-B9770F39-E1DA75880TTTakelāžas komplekts Tornado klases jahtaiGAB801138.30180996.0100.000.00025/12/201000.00996.01LVL996.010.000.00000001/31/20010996.01000.00TC0491.96491.960000000000000
C17C697F-968F8B79-83D9DB81-32A76CB6-85AAAB400TX1200Audums neilona burām TX 1200M214.5119031.97025/12/2010032.66LVL31.970001/29/200731.45002022.4722.470000000000000