Page tree
Paskaidrojumu kolonnaformat
(Kolonnu nepieciešams izdzēst pirms importa)14610000.
codepageUTF-8
HansaVersion
7.2 2014-10-31 (build 72250742)
commentstring
QTVc
Rindas Nr.123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
LatviskiNumursDatumsKlientsKlienta nosaukumsAdresePasta indekssValstsKontaktpersonaIekļaujams eksportāSamaksas termiņšCenu LapaObjektiPiegādāšans veidsAģentsApstiprinājuma aģentsSaņēmējsSaņēmēja adresePilsētaValūtaValūta2AizvērtsDerīgs līdzPiestādīt rēķinu tikai pilnā apmērāCenu lapaIekļauts PvnStarpsummaPVNKopsummaPiedāvājuma klaseAtlaižu matricaPVN reģ. nr.Telefona nr.FakssSazinātiesPamatsummaBāzes valūtaBāzes valūta 2Kopējā BPVarbūtībaBP%VietaVietaKop. DaudzumsKop. SvarsKop. TilpumsRēķ. AdreseRēķ. AdreseNoraidītsLēmuma pieņ dat.Pirkumi kopāNol. Artikuli kopāAtsk. NodoklisIzveidošanas datumsIzveidošanas laiksBankas kodsNosūt valsts
EnglishNumberDateCustomerCustomer nameAddressPostal codeCountryContact nameIncluded in exportPayment duePricing listObjectsShipment modeAgentSigning agentRecipientRecipient addressCityCurrencyCurrency2ClosedValid untilInvoice only on Full paymentPricing listVAT includedSubtotalVatTotalOffer clasificationDiscount Vat reg. No.Telephone no.FaxMake contact onBase amountBase currency Base currency 2Total BPProbabilityBP%PlacePlaceTot. AmountTot. WeightTot. VolumeBilling adressBilling address RejectedDecision dateBuyin totalWarehouse amount sum. Rem. TaxRegister dateRegister timeBank CodeCcountry
SerNrQTDateCustCodeAddr0Addr1Addr2Addr3OurContactCustContactExportFlagPayDealCustCatObjectsShipModePlanShipSalesManSignShipDealShipAddr0ShipAddr1ShipAddr2ShipAddr3CurncyCodeLangCodeInvoiceToCodeToRateB1ClosedBuildOnPRCodeCommentOrderNrValidUntilDateInvOnlyOnFullPriceListInclVATSum0Sum1Sum2Sum3Sum4QuoteClassCustVATCodeRebCodeVATNrPhoneFaxMakeContactDateBaseSum4FrRateToRateB2BaseRate1BaseRate2DiscPercDiscSumTotGPDaysToDeliveryProbabilityGPProcSalesGroupSortingLocationTotQtyTotWeightTotVolumeFrPriceFrBaseFrItemFrVATCodeFrObjectsInvAddr3InvAddr4DelAddr3DelAddr4DelAddrCodeRejectedRejectDateMarkupBudTimeSumTimeBudOtherSumOtherBudStockedSumStockedBudMaterialSumMaterialTAX1SumAcceptDatePriorityPlanShipDateRegionRefStrTAX2SumNoTax1NoTax2BranchIDNoTAXonVATTotalwoTAXOrgCustAcceptanceStatusCustTaxTemplateCodeTaxMatrixInvCountryDelCountryAcceptanceByDisallowInvoicemorethanQuotedProformaOfficialSerNrHashHashKeyVersionRegDateRegTimeLocalMachineCodeAcceptanceFYIBankCodeSVOSerNrComment2Comment3Comment4InvCountryNameDelCountryNameProformaOfficialSerNrSerieRecipientGLNDelRecipientGLNIntrastatTransCodeContractStartDate
M4Long,0M4Date,0M4Code,20M4Str,60M4Str,60M4Str,60M4Str,60M4Str,20M4Str,60M4Int,0M4Code,2M4Code,5M4UStr,60M4Code,5M4Str,10M4UStr,60M4Code,10M4Code,5M4Str,60M4Str,60M4Str,60M4Str,60M4Code,5M4Code,5M4Code,20M4Rate,0M4Int,0M4Int,0M4Code,20M4Str,60M4Long,0M4Str,20M4Int,0M4Code,5M4Int,0M4Val,0M4Val,0M4Val,0M4Val,0M4Val,0M4Code,5M4Code,10M4Code,5M4Str,20M4PhoneNo,20M4Str,20M4Str,20M4Val,0M4Rate,0M4Rate,0M4Rate,0M4Rate,0M4Qty,0M4Val,0M4Val,0M4Long,0M41Val,0M41Val,0M4UStr,30M4Str,20M4Code,10M4Qty,0M4Qty,0M4Qty,0M4Val,0M4Val,0M4Code,20M4Code,10M4UStr,60M4Str,60M4Str,60M4Str,60M4Str,60M4Code,20M4Int,0M4Date,0,10M4Int,0M4Val,0M4Int,0M4Val,0M4Int,0M4Val,0M4Int,0M4Val,0M4Val,0M4Date,0M4Long,0M4Date,0M4Code,20M4Str,60M4Val,0M4Int,0M4Int,0M4Code,20M4Long,0M4Int,0M4Code,20M4Int,0M4Code,10M4PackedMatrix,0M4Code,5M4Code,5M4List,200M4Int,0M4Str,100M4Str,255M4Int,0M4Date,0M4Time,0M4Code,20M4List,200M4Code,10M4Long,0M4Str,100M4Str,100M4Str,100M4Str,100M4Str,100M4Str,30M4Str,20M4Str,20M4Code,20M4Date,0
Matricas Rindas Nr.12.345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
Matricas nos. LatviskiArtikulsDaudzumsCena par vienībuSumma par artikulu%KontsObjektiPašizmaksaBPAprakstsMērvienībaVienību daudzumsVienibas cena ar koeficientu
Matrix definitionItemAmountUnit priceUnit Sum%AccountObjectsProduct costBPNameUnit typeUnit amountUnit cost with factoring
stpArtCodeQuantPriceSumvRebateSalesAccObjectsBasePricerowGPVATCodePlanShipSerialNrPriceFactorSpecVARListRecepyUnitCodeUnitFactQuantUnitFactPriceUnitXvalUnitYvalUnitZvalVECodeEMCodeMarkupTimeClassInvAfterInvoicedInvDateItemTypeRowTypeBudTypeJobGroupTAX2CodeTAX2PrcTAX2RebTAX1RebTAX2AccPRStageTaxTemplateCodeTaxMatrixRegionPerceptionsMotherArtCodeRecipeQuantInvdCustArtCodeSalesmenUnitCommentDiscApprovedBy
M4Int,0M4Code,20M4Qty,0M4Val,0M4Val,0M41Val,0M4Code,10M4UStr,60M4Val,0M4Val,0M4Code,10M4Str,10M4Str,30M45Val,0M4Str,100M4UStr,30M4Code,20M4Code,5M4UVal,0M423Val,0M4UVal,0M4UVal,0M4UVal,0M4Code,20M4Code,10,10M4Code,5M4Date,0M4Long,0M4Date,0M4Int,0M4Set,12M4Set,13M4Code,5M4Code,5M423Val,0M4Val,0M4Val,0M4Code,10M4Code,10M4UStr,60M4PackedMatrix,0M4Code,20M4Int,0M4Code,20M4Qty,0M4Qty,0M4Code,20M4UStr,60M4Str,200M4Code,10
Piedāvājuma piemērs240001/15/200410109Latvian Windsurfing AssociationSīļa iela 11, RīgaRīga, LV-1023Bārts Bartušēvičš Bartušāns030MAZAB,D10109ABABLatvian Windsurfing AssociationSīļa iela 11, RīgaLVLLAT000MAZ0581.97104.75686.7211LV 40003461289977.1110070.2804579.37100.099.6Hansabanka HABA22LV1408054316000297.600284.3700.0000000VGF4TWF0cml4VmMJDQoxCQkNCg==00
Piedāvājuma matricas ieraksts17X9NT4130.424.37.20.06110200.28Feb-5214mm 7x9 nerūsošā tērauda troseM0.00100VGF4TWF0cml4VmMJDQoxCQkNCg==0
Piedāvājuma matricas ieraksts1T4201350.00280.0020.0611080398.401Takelāžas komplekts 420 klases jahtaiGAB1350.00100VGF4TWF0cml4VmMJDQoxCQkNCg==0
Piedāvājuma matricas ieraksts1--------------------------000VGF4TWF0cml4VmMJDQoxCQkNCg==0
Piedāvājuma matricas ieraksts1PIEG3112.00297.6020.06110TRANS423.451Preču piegāde000VGF4TWF0cml4VmMJDQoxCQkNCg==0
Supply Offer example340007/12/201410102Regate SIATallinas iela 83, Rīga, LV-1053Jaromirs Jagris010VAIRD10102,LKLKABRegate SIATallinas iela 83,RīgaLVLLAT007/25/20140VAIR0251.3452.78304.1231LV 4000392873629112031432.7210070.2804120.0933.6RIGARIGA30900090000000251.34000000VGF4TWF0cml4VmMJDQoxCQkNCg==LV007/4/20149:48:253Latvija
Supply Offer matrix field11035651H1219.63235.5661111018.87108.731HT klāja krāsa 750mlGAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
Supply Offer matrix field122C460.613.66.6110220.43Feb-631C veida uzgalis 4mm GAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
Supply Offer matrix field122T61201.00.12.12.6110220.71Aug-731T veida uzgalis 6mm GAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
340017/13/201410107Jahtklubs Latvijas JahtaVikingu iela 6,Jūrmala, LV-1089Imants Zaļais010MAZD10107,GTGTABJahtklubs Latvijas JahtaVikingu iela 6,JūrmalaLVLLAT007/25/20140MAZ0337.2270.82408.0431101LV 40003516984580.5910070.2804134.9728-JanRIGARIGA271200012000Latvija0000337.22000000VGF4TWF0cml4VmMJDQoxCQkNCg==LV007/4/20149:49:50Latvija
17X9CT580.342.72.6110210.21Feb-1915mm 7x9 cinkotā tērauda troseM100VGF4TWF0cml4VmMJDQoxCQkNCg==0Metri
1TX1200110.20.10.20.611031.97-17.461Audums neilona burām TX 1200M2100VGF4TWF0cml4VmMJDQoxCQkNCg==0Kvadrātmetri
11035651H1619.63314.0861111018.87144.981HT klāja krāsa 750mlGAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
114X18DAL205.11.10.22.611030Apr-64May-261140x180mm DAL masta sekcijaM100VGF4TWF0cml4VmMJDQoxCQkNCg==0Metri
340027/16/201410107Jahtklubs Latvijas JahtaVikingu iela 6,Jūrmala, LV-1089Imants Zaļais010MAZD10107,GTGTABJahtklubs Latvijas JahtaVikingu iela 6,JūrmalaLVLLAT007/25/20140MAZ0810.00170.10980.1031101LV 400035169841394.5610070.28041152.53100.0RIGARIGA2Latvija0000810.00000000VGF4TWF0cml4VmMJDQoxCQkNCg==LV007/4/20149:49:43Latvija
1T4201350.00350.00611280498.011Takelāžas komplekts 420 klases jahtaiGAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
1T4701460.00460.00611280654.521Takelāžas komplekts 470 klases jahtaiGAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
340037/4/201410107Jahtklubs Latvijas JahtaVikingu iela 6,Jūrmala, LV-1089Imants Zaļais010MAZD10107,GTGTABJahtklubs Latvijas JahtaVikingu iela 6,JūrmalaLVLLAT007/25/20140MAZ073.0015.3388.3331101LV 40003516984125.6810070.280461.8759.6RIGARIGA200Latvija000073.00000000VGF4TWF0cml4VmMJDQoxCQkNCg==LV007/4/20149:50:12Latvija
17X9CT51000.3434.006110210.2127.3815mm 7x9 cinkotā tērauda troseM100VGF4TWF0cml4VmMJDQoxCQkNCg==0Metri
17X9CT61000.3939.006110210.2134.4916mm 7x9 cinkotā tērauda troseM100VGF4TWF0cml4VmMJDQoxCQkNCg==0Metri
340047/2/201410107Jahtklubs Latvijas JahtaVikingu iela 6,Jūrmala, LV-1089Imants Zaļais010MAZD10107,GTGTABJahtklubs Latvijas JahtaVikingu iela 6,JūrmalaLVLLAT007/25/20140MAZ090.9019-Sep109.9931101LV 40003516984156.5010070.280465.4450.6RIGARIGA90Latvija000090.90000000VGF4TWF0cml4VmMJDQoxCQkNCg==LV007/4/20149:50:43Latvija
122T6901-Jan90.906110220.7165.441T veida uzgalis 6mm GAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
340057/1/201410107Jahtklubs Latvijas JahtaVikingu iela 6,Jūrmala, LV-1089Imants Zaļais010MAZD10107,GTGTABJahtklubs Latvijas JahtaVikingu iela 6,JūrmalaLVLLAT007/25/20140MAZ0358.5675.30433.8641101LV 40003516984617.3310070.280486.5917.0RIGARIGA36Latvija0000358.56000000VGF4TWF0cml4VmMJDQoxCQkNCg==LV007/4/20149:58:05Latvija
116X20DAL126.0072.00611030May-8532.251160x200mm DAL masta sekcijaM100VGF4TWF0cml4VmMJDQoxCQkNCg==0Metri
11071115I1217.53210.3661111025.18-2.841INTERNATIONAL špahtele koka jahtām 750mlGAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali
12250012Jun-3576.20611022Apr-2757.181Masta stiprinājumiGAB100VGF4TWF0cml4VmMJDQoxCQkNCg==0Gabali