Page tree
Paskaidrojumu kolonnaformat
Remove this column before import146100000
codepageUTF-8
HansaVersion
8.0 2015-05-22 (build 80020602)
ORVc2
Column number0123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
EnglishNo.DateClientNameInvoice address 1 rowInvoice address 2 rowInvoice address 3 rowOur ContactContact nameIncluded in exportPayment termsPrice listObjectsOrder StatusSalesManSignDelivery addressDelivery addressCurrencyLanguageOrder ClassPrice listSubtotalVATTotalVAT NrTelephoneFaxBaseSum4Base Currency 1Base Currency 2Total GPGP %Despatch DateDespatch TimeSales GroupTotal QTYTotal WeightTotal VolumeTotal Inc. Com.Invoice addressInvoice addressAdress code (Delivery)
Technical nameSerNrOrdDateCustCodeAddr0Addr1Addr2Addr3OurContactCustContactExportFlagInvFlagShipFlagPrntdfPayDealCustCatInvMarkShipMarkObjectsShipModeOrderStatusPlanShipSalesManSignShipDealShipAddr0ShipAddr1ShipAddr2ShipAddr3CurncyCodeLangCodeInvoiceToCodeClosedToRateB1BuildOnPRCodeCommentInvOnlyOnFullDownPaySentDownPayRedcdOrderClassCustOrdNrPriceListInclVATSum0Sum1Sum2Sum3Sum4ReservedOSFlagLocationCustVATCodeRebCodeVATNrPhoneFaxExportedFlagBaseSum4FrRateToRateB2BaseRate1BaseRate2DiscPercDiscSumTotGPProbabilityCreditCardAuthorizationCodeGPProcDespatchDateDespatchTimeSalesGroupSortingTotQtyTotWeightTotVolumeCommisionSumIncComFrPriceFrBaseFrItemFrVATCodeFrObjectsInvAddr3InvAddr4DelAddr3DelAddr4DelAddrCodeTAX1SumQuoteNrInvBeforeShipcolnrOKFlagPlanShipDatePrepaidAmountRegionRefStrGroupOrdNrNoDeliveryNoInvoiceTAX2SumNoTax1NoTax2BranchIDNoTAXonVATTotalwoTAXOrderTypeAcceptanceStatusCustTaxTemplateCodeTaxMatrixTerminalIDOfficialSerNrHashHashKeyVersionRegDateRegTimeLocalMachineCodeInvCountryDelCountryTREONrTREOExpDateORCONrAcceptanceByAcceptanceFYIBankCodeInvCountryNameDelCountryNameOfficialSerNrSerieRecipientGLNDelRecipientGLNIntrastatTransCode
Data typeM4Long,0M4Date,0M4Code,20M4Str,60M4Str,60M4Str,60M4Str,60M4Str,20M4Str,60M4Int,0M4Int,0M4Int,0M4Int,0M4Code,2M4Code,5M4Mark,0M4Mark,0M4UStr,60M4Code,5M4Int,0M4Str,10M4UStr,60M4Code,10M4Code,5M4Str,60M4Str,60M4Str,60M4Str,60M4Code,5M4Code,5M4Code,20M4Mark,0M4Rate,0M4Int,0M4Code,20M4Str,60M4Int,0M4Val,0M4Val,0M4Code,5M4Str,60M4Code,5M4Int,0M4Val,0M4Val,0M4Val,0M4Val,0M4Val,0M4Int,0M4Int,0M4Code,10M4Code,10M4Code,5M4Str,20M4PhoneNo,20M4Str,20M4Int,0M4Val,0M4Rate,0M4Rate,0M4Rate,0M4Rate,0M4Qty,0M4Val,0M4Val,0M41Val,0M4UStr,20M4UStr,10M41Val,0M4Date,0M4Time,0M4UStr,30M4Str,20M4Qty,0M4Qty,0M4Qty,0M4Val,0M4Val,0M4Val,0M4Val,0M4Code,20M4Code,10M4UStr,60M4Str,60M4Str,60M4Str,60M4Str,60M4Code,20M4Val,0M4Long,0M4Int,0M4Set,46M4Mark,0M4Date,0M4Val,0M4Code,20M4Str,60M4Long,0M4Int,0M4Int,0M4Val,0M4Int,0M4Int,0M4Code,20M4Long,0M4Int,0M4Set,433M4Int,0M4Code,10M4PackedMatrix,0M4Str,60M4Str,100M4Str,255M4Int,0M4Date,0M4Time,0M4Code,20M4Code,5M4Code,5M4Long,0M4Date,0M4Long,0M4List,200M4List,200M4Code,10M4Str,100M4Str,100M4Str,30M4Str,20M4Str,20M4Code,20
Matrix column number0123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130
Matrix definitionItemsQTYUnit priceSumma%A/CDelDel. OkInvoicedObjectsBase PriceGPDescriptionVat codeSerual numberLocation
Technical namestpArtCodeQuantPriceSumvRebateSalesAccShipd1Shipd2InvdObjectsBasePricerowGPSpecVATCodeRecepySerialNrPriceFactorVARListLocationSourcePickingDatePickingTimeInloadingDateInloadingTimeDespatchRowDateDespatchRowTimePlanShipRowShipNoteUnitCodeUnitFactQuantUnitFactPriceUnitXvalUnitYvalUnitZvalCoefficientVECodeProductionGroupOrdRowTAX2CodeTAX2PrcTAX2RebTAX1RebTAX2AccPlanShipRowDateCUServiceHistNrCUServiceUntilDatePositionRowOrderTypeTaxTemplateCodeTaxMatrix
Data typeM4Int,0M4Code,20M4UVal,0M423Val,0M4Val,0M41Val,0M4Code,10M4UVal,0M4UVal,0M4UVal,0M4UStr,60M423Val,0M4Val,0M4Str,100M4Code,10M4Code,20M4Str,30M45Val,0M4UStr,30M4Code,10M4Code,10M4Date,0M4Str,20M4Date,0M4Str,20M4Date,0M4Str,20M4Str,10M4Str,60M4Code,5M4UVal,0M423Val,0M4UVal,0M4UVal,0M4UVal,0M45Val,0M4Code,20M4Code,20M4Long,0M4Code,5M423Val,0M4Val,0M4Val,0M4Code,10M4Date,0M4Long,0M4Date,0M4Code,20M4Set,433M4UStr,60M4PackedMatrix,0
Order example2300014.10.200310101Dūrējs SIADaugavgrīvas iela 5Rīga, LV-1022LATVIJAJānis Cirpējs021010MAZ1818AB,D101010ABABMazās salas iela 3, RīgaLVL0000MAZ0139.5225.11164.6300726262672525250234.2510070.2804108.9132.200:00:00164.63Hansabanka HABA22LV1405462313000000000000VGF4TWF0cml4VmMJDQoxCQkNCg==0
Order matrix row11001231H221.54361102221020.7719.64HEMPEL špahtele plastmasas jahtām 750ml1GAB00VGF4TWF0cml4VmMJDQoxCQkNCg==00
Order matrix row11035651H419.6378.5261104441018.8736.25HEMPEL klāja krāsa 750ml1GAB00VGF4TWF0cml4VmMJDQoxCQkNCg==00
Order matrix row116X20DAL36186110333305.858.07160x200mm DAL masta sekcija1M00VGF4TWF0cml4VmMJDQoxCQkNCg==00
Empty row separating multiple orders
Order example300000222.02.201010101Dūrējs SIADaugavgrīvas iela 5, Rīga, LV-1022Jānis Cirpējs020010MAZ180D10101,LK0LKABDūrējs SIADaugavgrīvas iela 5, RīgaLVLLAT000WEBMAZ00101.1321.24122.37011LV 40009876542726262672525250174.1210070.280476.2231.1RIGA922502250122.37Hansabanka HABA22LVLV01HABA014054623100100100000000VGF4TWF0cml4VmMJDQoxCQkNCg==0
Order matrix row11001231H321.564.561113331020.7729.45HEMPEL špahtele plastmasas jahtām 750ml1GAB0VGF4TWF0cml4VmMJDQoxCQkNCg==00
Order matrix row11065941I217.5335.0661112221017.8614.17INTERNATIONAL Interdeck klāja krāsa 750ml1GAB0VGF4TWF0cml4VmMJDQoxCQkNCg==00
Order matrix row17X9NT430.421.266110200.30.94mm 7x9 nerūsošā tērauda trose1M0VGF4TWF0cml4VmMJDQoxCQkNCg==00
0
725252501110.4810070.2804501.5332.1RIGA302250022500780.45Hansabanka HABA22LVLV01HABA014054623100100100000000VGF4TWF0cml4VmMJDQoxCQkNCg==0
0
027.7210070.280416.7943RIGA300019.48Hansabanka HABA22LVLV44HABA014080434561200100000010VGF4TWF0cml4VmMJDQoxCQkNCg==0
1
7252525010070.280400RIGALatvija00000000000VGF4TWF0cml4VmMJDQoxCQkNCg==027.08.201410:56:39LV3Latvija