Artikelinfo (txt import formaat): erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
(Uus lehekülg: 'Veerud vasakult paremale {| class="wikitable" |Code |- |Name |- |Unittext |- |MinLevel |- |Objects |- |SalesAcc |- |UPrice1 |- |ItemType |- |Group |- |"" |- |"" |- |InPrice |- |I...') |
Resümee puudub |
||
| 1. rida: | 1. rida: | ||
Artikelinfo on lihtsustatud Artiklite eksport-import formaat, mis hõlbustab artiklite info massilist uuendamist. | |||
Näide failist: | |||
[[Fail:Artikelinfo.png|tühi|pisi|1008x1008px]] | |||
Veerud vasakult paremale | Veerud vasakult paremale | ||
{| class="wikitable" | {| class="wikitable" | ||
!Välja tehniline nimi | |||
!Nimetus aknas | |||
|- | |||
|Code | |Code | ||
|Kood | |||
|- | |- | ||
|Name | |Name | ||
|Nimetus | |||
|- | |- | ||
|Unittext | |Unittext | ||
|Ühik | |||
|- | |- | ||
|MinLevel | |MinLevel | ||
|Minimaaltase | |||
|- | |- | ||
|Objects | |Objects | ||
|Objektid | |||
|- | |- | ||
|SalesAcc | |SalesAcc | ||
|Müük Eestis | |||
|- | |- | ||
|UPrice1 | |UPrice1 | ||
|Baasmüügihind | |||
|- | |- | ||
|ItemType | |ItemType | ||
|Artikli tüüp | |||
|- | |- | ||
|Group | |Group | ||
|Klass | |||
|- | |- | ||
|"" | |"" | ||
|''tühi'' | |||
|- | |- | ||
|"" | |"" | ||
|''tühi'' | |||
|- | |- | ||
|InPrice | |InPrice | ||
|Ostuhind | |||
|- | |- | ||
|InvCode | |InvCode | ||
|Riiulikood | |||
|- | |- | ||
|ExtraCost | |ExtraCost | ||
|Lisakulu | |||
|- | |- | ||
|SerNrf | |SerNrf | ||
|seerianumbri jälgimine | |||
|- | |- | ||
|Department | |Department | ||
|Osakond | |||
|- | |- | ||
|Weight | |Weight | ||
|Kaal | |||
|- | |- | ||
|Volume | |Volume | ||
|Maht | |||
|- | |- | ||
|EUCodex | |EUCodex | ||
|EAN | |||
|- | |- | ||
|InCurncyCode | |InCurncyCode | ||
|''[ei kasutata eestis]'' | |||
|- | |- | ||
|Bonus | |Bonus | ||
|Preemia % | |||
|- | |- | ||
|Recepy | |Recepy | ||
|Retsept | |||
|- | |- | ||
|Markup | |Markup | ||
|Juurdehindluse % | |||
|- | |- | ||
|"" | |"" | ||
|''tühi'' | |||
|- | |- | ||
|BarCode | |BarCode | ||
|Ribakood | |||
|- | |- | ||
|UpdateCost | |UpdateCost | ||
|Uuenda Ostuhinda | |||
|- | |- | ||
|LastPriceChange | |LastPriceChange | ||
|Hinnamuutus | |||
|- | |- | ||
|CalcPrice | |CalcPrice | ||
|Arvutusvalem | |||
|- | |- | ||
|VATCode | |VATCode | ||
|KM kood | |||
|- | |- | ||
|PriceFactor | |PriceFactor | ||
|Hinnafaktor | |||
|- | |- | ||
|Terminated | |Terminated | ||
|Suletud | |||
|- | |- | ||
|AvgMarkup | |AvgMarkup | ||
|''[ei kasutata eestis]'' | |||
|- | |- | ||
|LastPurchPrice | |LastPurchPrice | ||
|Viimane ostuhind | |||
|- | |- | ||
|LastPurchCurncyCode | |LastPurchCurncyCode | ||
|Viimane ostuvaluuta | |||
|- | |- | ||
|WeighedAvPrice | |WeighedAvPrice | ||
|Kaalutud keskmine | |||
|- | |- | ||
|Conversion1 | |Conversion1 | ||
|Ühikumuutus 1 | |||
|- | |- | ||
|Conversion2 | |Conversion2 | ||
|Ühikumuutus 2 | |||
|- | |- | ||
|WarrantyLength | |WarrantyLength | ||
|Garantiikuude arv | |||
|- | |- | ||
|InvRecepy | |InvRecepy | ||
|Arve retsept | |||
|- | |- | ||
|EUSalesAcc | |EUSalesAcc | ||
|Müük EL | |||
|- | |- | ||
|ExpSalesAcc | |ExpSalesAcc | ||
|Müük mitte-EL | |||
|- | |- | ||
|VATCodeEU | |VATCodeEU | ||
|EL KM-kood | |||
|- | |- | ||
|VATCodeExp | |VATCodeExp | ||
|KM-kood, mitte EL | |||
|- | |- | ||
|ChangePrice | |ChangePrice | ||
|''[ei kasutata eestis]'' | |||
|- | |- | ||
|RebCode | |RebCode | ||
|Hinnaalandusmaatriks | |||
|- | |- | ||
|ExplodeRec | |ExplodeRec | ||
|Aseta sisestamisel komponendid | |||
|- | |- | ||
|Unittext2 | |Unittext2 | ||
|Ühik 2 | |||
|- | |- | ||
|UnitCoefficient | |UnitCoefficient | ||
|Ühiku koefitsent | |||
|- | |- | ||
|WarnText1 | |WarnText1 | ||
| | |||
|- | |- | ||
|VARList | |VARList | ||
| | |||
|- | |- | ||
|ItemMaterial | |ItemMaterial | ||
| | |||
|- | |- | ||
|AlcPrc,M4UVal | |AlcPrc,M4UVal | ||
| | |||
|- | |- | ||
|DefaultSource | |DefaultSource | ||
| | |||
|- | |- | ||
|AlternativeCode | |AlternativeCode | ||
| | |||
|- | |- | ||
|CostAcc | |CostAcc | ||
| | |||
|- | |- | ||
|DefLocation | |DefLocation | ||
| | |||
|- | |- | ||
|LastBasePriceChange | |LastBasePriceChange | ||
| | |||
|- | |- | ||
|MaxLevel | |MaxLevel | ||
| | |||
|- | |- | ||
|LastPurchPrice2 | |LastPurchPrice2 | ||
| | |||
|- | |- | ||
|Width,M4UVal | |Width,M4UVal | ||
| | |||
|- | |- | ||
|Height,M4UVal | |Height,M4UVal | ||
| | |||
|- | |- | ||
|Depth,M4UVal | |Depth,M4UVal | ||
| | |||
|- | |- | ||
|ContractItem | |ContractItem | ||
| | |||
|- | |- | ||
|Internal | |Internal | ||
| | |||
|- | |- | ||
|InclItemFreight | |InclItemFreight | ||
| | |||
|- | |- | ||
|FixedFreight | |FixedFreight | ||
| | |||
|- | |- | ||
|DispGroups | |DispGroups | ||
| | |||
|- | |- | ||
|HazLevCode | |HazLevCode | ||
| | |||
|- | |- | ||
|Density | |Density | ||
| | |||
|- | |- | ||
|xClassification | |xClassification | ||
| | |||
|- | |- | ||
|CredSalesAcc | |CredSalesAcc | ||
| | |||
|- | |- | ||
|CredEUSalesAcc | |CredEUSalesAcc | ||
| | |||
|- | |- | ||
|CredExpSalesAcc | |CredExpSalesAcc | ||
| | |||
|- | |- | ||
|CredVATCode | |CredVATCode | ||
| | |||
|- | |- | ||
|CredVATCodeEU | |CredVATCodeEU | ||
| | |||
|- | |- | ||
|CredVATCodeExp | |CredVATCodeExp | ||
| | |||
|- | |- | ||
|RentalItem | |RentalItem | ||
| | |||
|} | |} | ||
Redaktsioon: 22. veebruar 2021, kell 12:13
Artikelinfo on lihtsustatud Artiklite eksport-import formaat, mis hõlbustab artiklite info massilist uuendamist.
Näide failist:
Veerud vasakult paremale
| Välja tehniline nimi | Nimetus aknas |
|---|---|
| Code | Kood |
| Name | Nimetus |
| Unittext | Ühik |
| MinLevel | Minimaaltase |
| Objects | Objektid |
| SalesAcc | Müük Eestis |
| UPrice1 | Baasmüügihind |
| ItemType | Artikli tüüp |
| Group | Klass |
| "" | tühi |
| "" | tühi |
| InPrice | Ostuhind |
| InvCode | Riiulikood |
| ExtraCost | Lisakulu |
| SerNrf | seerianumbri jälgimine |
| Department | Osakond |
| Weight | Kaal |
| Volume | Maht |
| EUCodex | EAN |
| InCurncyCode | [ei kasutata eestis] |
| Bonus | Preemia % |
| Recepy | Retsept |
| Markup | Juurdehindluse % |
| "" | tühi |
| BarCode | Ribakood |
| UpdateCost | Uuenda Ostuhinda |
| LastPriceChange | Hinnamuutus |
| CalcPrice | Arvutusvalem |
| VATCode | KM kood |
| PriceFactor | Hinnafaktor |
| Terminated | Suletud |
| AvgMarkup | [ei kasutata eestis] |
| LastPurchPrice | Viimane ostuhind |
| LastPurchCurncyCode | Viimane ostuvaluuta |
| WeighedAvPrice | Kaalutud keskmine |
| Conversion1 | Ühikumuutus 1 |
| Conversion2 | Ühikumuutus 2 |
| WarrantyLength | Garantiikuude arv |
| InvRecepy | Arve retsept |
| EUSalesAcc | Müük EL |
| ExpSalesAcc | Müük mitte-EL |
| VATCodeEU | EL KM-kood |
| VATCodeExp | KM-kood, mitte EL |
| ChangePrice | [ei kasutata eestis] |
| RebCode | Hinnaalandusmaatriks |
| ExplodeRec | Aseta sisestamisel komponendid |
| Unittext2 | Ühik 2 |
| UnitCoefficient | Ühiku koefitsent |
| WarnText1 | |
| VARList | |
| ItemMaterial | |
| AlcPrc,M4UVal | |
| DefaultSource | |
| AlternativeCode | |
| CostAcc | |
| DefLocation | |
| LastBasePriceChange | |
| MaxLevel | |
| LastPurchPrice2 | |
| Width,M4UVal | |
| Height,M4UVal | |
| Depth,M4UVal | |
| ContractItem | |
| Internal | |
| InclItemFreight | |
| FixedFreight | |
| DispGroups | |
| HazLevCode | |
| Density | |
| xClassification | |
| CredSalesAcc | |
| CredEUSalesAcc | |
| CredExpSalesAcc | |
| CredVATCode | |
| CredVATCodeEU | |
| CredVATCodeExp | |
| RentalItem |