Lookup type seznam

Lookup type seznam

V spodnjem besedilu je seznam vseh obstoječih lookup type, privzeta polja in ustrezna tabela.

ltAcctTransItemDocs Key=acDoc SQL=select distinct acDoc from tHE_AcctTransItem order by acDoc
acDoc;150;;Dokument;10

ltAcctTransItemStatus Key=anStatus SQL=select anStatus, acName from tHE_SetTransItemStatus where anStatus <> 0 order by anStatus
acName;100;;Naziv;10
anStatus;30;;Status;20

ltBanka Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acSWIFTCode, acCountry from tHE_SetSubj WHERE acBank = 'T' ORDER BY acSubject
acSubject;210;;Banka;10
acAddress;420;;Naslov;20
acPost;77;;Pošta;30
acPhone;140;;Telefon;40

ltBankaAct Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acSWIFTCode, acCountry from tHE_SetSubj WHERE acBank = 'T' and acActive = 'T' ORDER BY acSubject
acSubject;210;;Banka;10
acAddress;420;;Naslov;20
acPost;77;;Pošta;30
acPhone;140;;Telefon;40

ltBankaDelavec Key= SQL=

ltBCPurpose Key=acIDBCPurpose SQL=Select acIDBCPurpose, acNote from tHE_BCPurpose order by acIDBCPurpose
acIDBCPurpose;80;;Šifra;10
acNote;300;;Namen;20

ltBilanca Key=acBalanceOfAcct SQL=select acBalanceOfAcct, acName from tHE_FinReport order by acBalanceOfAcct
acBalanceOfAcct;48;;Bilanca;10
acName;250;;Naziv;20

ltBudget Key= SQL=

ltCarECL Key=acKey SQL=select acKeyView, acKey, adDate, acCurrency, acDocType, acSupplier from vHE_SAD order by acKey
acKey;100;;Ključ;10
adDate;70;;Datum;20
acCurrency;50;;Valuta;30

ltCarECLView Key=acKeyView SQL=select acKeyView, acKey, adDate, acCurrency, acDocType, acSupplier from vHE_SAD order by acKey
acKeyView;100;;Ključ;10
adDate;70;;Datum;20
acCurrency;50;;Valuta;30

ltCarinarnica Key=acCustomHouse SQL=select acCustomHouse, acName from vHE_SetCustOff order by acCustomHouse
acCustomHouse;70;;Carinarnica;10
acName;210;;Naziv;20

ltCarPariteta Key=acParity SQL=select acParity, acType, acName from vHE_SetDelTerm order by acParity
acParity;77;;Šifra;10
acType;60;;Tip;20
acName;210;;Naziv;30

ltCarPostopek Key=acProc SQL=select acProc, acName from vHE_SetCustProc order by acProc
acProc;35;;Post.;10
acName;210;;Naziv;20

ltCarSifHR Key=acPost SQL=SELECT acPost, acName, acTaxOfficeCro FROM vHE_SetPostCode ORDER BY acPost
acPost;49;;Pošta;10
acName;231;;Kraj;20
acTaxOfficeCro;49;;Davčna izpostava;30

ltCarStrosek Key=acCost SQL=select acCost, acName from vHE_SetCostAtt order by acCost
acCost;30;;Strošek;10
acName;210;;Naziv;20

ltCarTarifa Key=acCustTariff SQL=select acCustTariff, acName, anRate from vHE_SetCustTariff order by acCustTariff
acCustTariff;77;;Šifra;10
acName;210;;Naziv;20
anRate;35;#,##0.00;Stopnja;30

ltCarTipPoreklo Key=acType SQL=select acType, acName from vHE_SetDeclarOrig order by acType
acType;28;;Tip;10
acName;210;;Naziv;20

ltCarVrstDaj Key=acSetOfTax SQL=select acSetOfTax, acName, acDutyType from vHE_SetDuty order by acSetOfTax
acSetOfTax;77;;Šifra;10
acName;210;;Naziv;20
acDutyType;15;;Tip;30

ltCarVrstPosla Key=acSetOfDuty SQL=select acSetOfDuty, acName from vHE_SetNatureTran order by acSetOfDuty
acSetOfDuty;40;;Šifra;10
acName;200;;Naziv;20

ltCity Key=acCity SQL=select acCity from vHE_LookCity order by acCity
acCity;210;;Kraj;10

ltDBStatus Key=acIDBCState SQL=select acIDBCState, acNote from tHE_BCState order by acIDBCState
acIDBCState;80;;Šifra;10
acNote;150;;Status;20

ltDelovnoRazmerje Key= SQL=

ltDobavitelj Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj WHERE acSupplier = 'T' ORDER BY acSubject
acSubject;200;;Dobavitelj;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50
acCode;120;;Davčna Št.;60

ltDobaviteljNaziv2 Key=acName2 SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj WHERE acActive <> 'F' and acSupplier = 'T' ORDER BY acName2
acName2;200;;Naziv 2;10
acSubject;200;;Dobavitelj;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50
acCode;120;;Davčna Št.;60

ltDokumentBC Key=acKey SQL=select acKey, adDate from tHE_BCDocument where anState & 64 = 0 and acDirection = '2'
acKey;120;;Dokument;10
adDate;80;;Datum;20

ltDrzava Key=acCountry SQL=select acCountry, acCurrency, acISOCode, acVATCodePrefix from vHE_SetCountry order by acCountry
acCountry;200;;Država;10
acCurrency;50;;Valuta;20

ltDrzavaISO Key=acISOCode SQL=select acISOCode, acCountry, acCurrency, acVATCodePrefix from vHE_SetCountry order by acISOCode
acISOCode;45;;Koda;10
acCountry;200;;Država;20

ltDrzavaSifraIntra Key=acISOCode SQL=select acISOCode, acIntrastatCode, acVATCodePrefix,  acCountry from vHE_SetCountry order by acIntrastatCode
acIntrastatCode;45;;Intrastat Koda;10
acVATCodePrefix;45;;Šifra;20
acCountry;210;;Država;30

ltDrzavaSifraISO Key=acVATCodePrefix SQL=select acVATCodePrefix, acISOCode,  acCountry, acCurrency from vHE_SetCountry order by acVATCodePrefix
acVATCodePrefix;45;;Šifra;10
acCountry;210;;Država;20

ltEEOprema Key=acEEEquipment SQL=select acEEEquipment, acName from vHE_SetEEEquipment order by acEEEquipment
acEEEquipment;60;;Razred EE opreme;10
acName;300;;Naziv;20

ltEM Key=acUM SQL=select acUM, acName from vHE_SetUM order by acUM
acUM;40;;EM;10
acName;300;;Naziv;20

ltEmbal Key=acPacking SQL=select acPacking from vHE_SetPack order by acPacking
acPacking;100;;Embalaža;10

ltEmbalSLOPAK Key=acPackSLOPAK SQL=select acPackSLOPAK, acName from vHE_SetPackSLOPAK order by acPackSLOPAK
acPackSLOPAK;60;;Šifra;10
acName;150;;Naziv;20

ltEmbalVrsta Key=acSetOfPacking SQL=select acSetOfPacking, acPackingTypeName from vHE_SetPackWTLook order by acSetOfPacking
acSetOfPacking;30;;Šifra;10
acPackingTypeName;210;;Naziv;20

ltFrekvenca Key=acIDBCFrequency SQL=select acIDBCFrequency, acNote from vHE_BCFrequency order by acIDBCFrequency
acIDBCFrequency;80;;Šifra;10
acNote;150;;Frekvenca;20

ltGarnishmentPerson Key=acSubject SQL=select acSubject, acName, acLastName, acVATCode, acID, acStreetName, acStreetNo, acPostalArea, acPlace, acCountry from tHE_SetGarnishmentPerson
acSubject;160;;Naziv;10
acName;80;;Naziv;20
acLastName;80;;Priimek;30
acVATCode;100;;Davčna Št.;40
acID;100;;Matična Št./EMŠO;50
acStreetName;100;;Naslov;60
acPostalArea;50;;Pošta;70
acCountry;100;;Država;80

ltHEdebtCollCont Key=acContact SQL=SELECT acContact, acPhone, acFunction FROM vHE_DebtCollContacts order by acContact,acPhone
acContact;200;;Kontaktna oseba;10
acPhone;150;;Tel.:;20
acFunction;300;;Funkcija v podjetju;30

ltHefTehnoAlt Key=anVariant SQL=select anVariant, acName, acIdent from tHF_SetPrStVariants order by acIdent
anVariant;33;;Alt.;10
acName;70;;Naziv;20

ltHESetSubjBC Key=acContractNo SQL=select acSubject, anNo, acContractNo, anBankAcctNo, acIDBCFrequency, acSeqNo, acPayMethod, adDateFrom, adDateTo from tHE_SetSubjBC order by acSubject, anNo
acContractNo;120;;Št.pogodbe;10
anNo;45;;Zap.št.;20
acIDBCFrequency;70;;Frekvenca;30
acPayMethod;75;;Nač.plač.;40

ltHFBuyOrder Key=acKey SQL=SELECT acKeyView, acKey, adDate, acDocTypeView, acDocType, acConsignee, acReceiver FROM vHF_BuyOrd ORDER BY acKey
acKeyView;100;;Naročilo;10
acDocTypeView;30;;VD;20
adDate;80;dd.mm.yyyy;Datum;30
acConsignee;90;;Naročnik;40
acReceiver;100;;Prejemnik;50

ltHFBuyOrdWO Key=acKey SQL=select acKeyView,acKey,adDate,acDocType,acConsignee,acReceiver,acDocTypeView from vHF_BuyOrdWO order by acKey
acKeyView;100;;Naročilo/DN;10
acDocTypeView;30;;VD;20
adDate;80;dd.mm.yyyy;Datum;30
acConsignee;90;;Naročnik;40
acReceiver;100;;Prejemnik;50

ltHFCalendar Key=acCalendarID SQL=select acCalendarID,acName from vHF_SetCalendar order by acCalendarID
acCalendarID;35;;Koledar;10
acName;100;;Naziv;20

ltHFCalendarEntryType Key=acSetOf SQL=select acSetOf, acName, anUsagePrc from tHF_SetCalendarEntryType where acType = 'K' order by acSetOf
acSetOf;60;;Vrsta;10
acName;250;;Naziv;20
anUsagePrc;250;;Izkoristek %;30

ltHFCostDrv Key=acCostDrv SQL=select acCostDrv, acName, acClassif, acStatus, acDept from vHE_CostDrvLook  ORDER BY acCostDrv
acCostDrv;160;;Str.nos.;10
acName;400;;Naziv;20
acClassif;100;;Skupina;30
acStatus;60;;Status;40

ltHFDept Key=acSubject SQL=select acSubject, acName2, acName3 from vHE_SubjDeptLook  ORDER BY acSubject
acSubject;200;;Oddelek;10
acName2;150;;Naziv 2;20
acName3;150;;Naziv 3;30

ltHFDocTypPlan Key=acDocTypeView SQL=select acDocTypeView,acDocType,acName from vPA_SetDocType where acSetOf='H' order by acDocType
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltHFDocTypSupp Key=acDocTypeView SQL=select acDocTypeView,acDocType,acName from vPA_SetDocType where acSetOf='N' and acType='I' order by acDocType
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltHFDocTypWO Key=acDocTypeView SQL=select acDocTypeView,acDocType,acName from vPA_SetDocType where acSetOf='D' order by acDocType
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltHFDocTypWOSupp Key=acDocTypeView SQL=select acDocTypeView,acDocType,acName from vPA_SetDocType where (acSetOf='D' and acProdWOType<>'S') or (acSetOf='N' and acType='I') order by acDocType
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltHFFormula Key=acCode SQL=select acCode, acName, acFormula from vHE_SetItemFormula order by acCode
acCode;90;;Koda;10
acName;300;;Naziv;20
acFormula;300;;Formula;30

ltHFHoldUps Key=acKey SQL=select acKey,acName from vHF_SetHoldUps order by acKey
acKey;30;;Vrsta;10
acName;300;;Naziv;20

ltHFIncomeGroup Key=acIGroup SQL=select acIGroup, anFactor from vHR_SetSlryIncomeGroup order by acIGroup
acIGroup;50;;Razred;10
anFactor;80;#,##0.000;Faktor;20

ltHFPlan Key=acKeyView SQL=select acKeyView,acKey,adDate,adSchedStartTime,adSchedEndTime from vHF_Plan order by acKey
acKeyView;100;;Plan;10
adDate;80;dd.mm.yyyy;Datum;20
adSchedStartTime;80;dd.mm.yyyy hh:mm;Zač.Term.;30
adSchedEndTime;80;dd.mm.yyyy hh:mm;Kon.Term.;40

ltHFPlanItem Key=acKeyView SQL=select acKeyView,anNo,acIdent,acName,anQty,acUM,adSchedEndTime from vHF_PlanItemSI order by acKey,anNo
acKeyView;100;;Plan;10
anNo;30;;Poz;20
acIdent;90;;Koda;30
acName;300;;Naziv;40
anQty;80;#,##0.00;Količina;50
acUM;30;;EM;60
adSchedEndTime;80;dd.mm.yyyy hh:mm;Kon.Term.;70

ltHFPrstHistIdent Key=acIdent SQL=SELECT acIdent,adHistDate FROM tHF_SetPrstHistMain order by acIdent, adHistDate desc
acIdent;100;;Ident;10
adHistDate;120;;Datum;20

ltHFPrstStatus Key=acStatus SQL=select acStatus, acDescr  from tHF_SetPrStStatus order by acStatus
acStatus;33;;Status;10
acDescr;70;;Opis;20

ltHFRegOperAdd Key=acIdent SQL=select acIdent,acName,acType from vhf_WOExRegOperOper order by acIdent
acIdent;100;;Ident;10
acName;120;;Naziv;20

ltHFRegWrkrAdd Key=acWorker SQL=select acWorker, acRegno from vHF_WOExRegOperWrkr order by acWorker
acWorker;210;;Delavec;10
acRegNo;56;;Os. Št.;20

ltHFResurs Key=acKey SQL=select acKey,acName,acParent,acType,acIGroup from vHF_SetResurs order by acKey
acKey;90;;Resurs;10
acName;200;;Naziv;20
acParent;200;;Nadrejeni;30
acType;20;;Tip;40
acIGroup;30;;Plač.raz.;50

ltHFResursType Key=acSetOfResurs SQL=select acSetOfResurs,acName from vHF_SetResursType order by acSetOfResurs
acSetOfResurs;40;;VR;10
acName;200;;Naziv;20

ltHFResursWorker Key=acWorker SQL=select distinct acWorker,acRegNo,acKey from vHF_WOExItemResursWorkers order by acWorker
acWorker;210;;Delavec;10
acRegNo;56;;Os. Št.;20

ltHFResursWorkerRegNo Key=acRegNo SQL=select acRegNo,acWorker,acKey from vHF_WOExItemResursWorkers order by acRegNo
acRegNo;56;;Os. Št.;10
acWorker;210;;Delavec;20

ltHFRules Key=acKey SQL=select acKey,acName,adDate,acResponsible from vHF_SetRules order by acKey
acKey;90;;Predpis;10
acName;200;;Naziv;20
adDate;80;dd.mm.yyyy;Datum;30
acResponsible;300;;Odgovoren(a);40

ltHFRulesType Key=acRuleTypeID SQL=select acRuleTypeID, acName FROM vHF_SetRuleTypes ORDER BY acRuleTypeID
acRuleTypeID;40;;Vrsta;10
acName;100;;Naziv;20

ltHFScraps Key=acKey SQL=select acKey, acName  from vHF_SetScraps order by acKey
acKey;33;;Šifra;10
acName;70;;Naziv;20

ltHFSetItemProduct Key=acIdent SQL=select acIdent,acName,acSISetOfItem,acSIClassif,acSIClassif2 from vHF_FindMSProduct order by acIdent
acIdent;100;;Ident;10
acName;300;;Koda;20
acSiSetOfItem;50;;VID;30
acSiClassif;100;;Prim.klas.;40
acSiClassif2;100;;Sek.klas.;50

ltHFSetItemPrst Key=acIdent SQL=select acIdent,acName,acSISetOfItem,acSIClassif,acSIClassif2 from vHF_SetItemSetsPrSt order by acIdent
acIdent;100;;Ident;10
acName;300;;Naziv;20

ltHFSIMat Key=acIdent SQL=select acIdent,acName,acUM from vHF_SetItemMat order by acIdent
acIdent;100;;Ident;10
acName;120;;Naziv;20
acUM;30;;EM;30

ltHFSIOper Key=acIdent SQL=select acIdent,acName,acUM from vHF_SetItemOper order by acIdent
acIdent;100;;Ident;10
acName;120;;Naziv;20
acUM;30;;EM;30

ltHFSlryET Key=acET SQL=select acET,acName from vHR_SetSlryET order by acET
acET;40;;VZ;10
acName;100;;Naziv;20

ltHFTools Key=acToolID SQL=select acToolID,acName,acIsScheduled from vHF_Tool order by acToolID
acToolID;90;;Orodje;10
acName;200;;Naziv;20
acIsScheduled;20;;Term.;30

ltHFWOExGetAllItem Key=acIdent SQL=select acIdent,acName,acUM,acActive from vHF_WOExGetItemMat order by acIdent
acIdent;100;;Izdelek;10
acName;120;;Naziv;20
acUM;30;;EM;30

ltHFWOExGetWOItem Key=acIdent SQL=select acKey, acIdent, acDescr, anVariant, anNo from vHF_WOItemSISOI order by acIdent
acIdent;100;;Izdelek;10
acDescr;120;;Naziv;20
anVariant;20;;A;30
anNo;20;;Poz;40

ltHFWOMF Key=acKey SQL=select acKeyView,acKey,acDocTypeView,acDocType,adDate,adSchedStartTime,adSchedEndTime,acPlanID,acIdent,acName,anPlanQty,acUM,acConsignee,acReceiver,acStatusMF from vHF_WOExLkpKey where acProdWOType<>'S' order by acKey
acKeyView;100;;DN;10
acDocTypeView;30;;VD;20
adDate;80;dd.mm.yyyy;Datum;30
acStatusMF;10;;S;40
acIdent;90;;Izdelek;50
acName;100;;Naziv;60
anPlanQty;80;#,##0.00;Količina;70
acUM;30;;EM;80
adSchedStartTime;80;dd.mm.yyyy hh:mm;Zač.Term.;90
adSchedEndTime;80;dd.mm.yyyy hh:mm;Kon.Term.;100
acPlanID;80;;Plan;110

ltHFWOMF_RDEI Key=acKey SQL=select acKeyView,acKey,adDate,acDocTypeView,acIdent,acName,anPlanQty,acUM,acStatusMF from vHF_WOExLkpKey WHERE acStatusMF in ('R','D','E','I') and acReversal<>'D' and acProdWOType<>'S' order by acKey
acKeyView;100;;DN;10
adDate;80;dd.mm.yyyy;Datum;20
acDocTypeView;30;;VD;30
acStatusMF;10;;S;40
acIdent;90;;Izdelek;50
acName;100;;Naziv;60
anPlanQty;80;#,##0.00;Količina;70
acUM;30;;EM;80

ltHFWorkEquip Key=acWorkEquip SQL=select acWorkEquip,acName,acIsScheduled,acSetOf,acSetOfName from vHF_WorkEquip order by acWorkEquip
acWorkEquip;90;;Del. naprava;10
acName;200;;Naziv;20
acSetOf;30;;Vrsta;30
acSetOfName;200;;Naziv V.;40
acIsScheduled;20;;Term.;50

ltHFWorker Key=acWorker SQL=select distinct acWorker,acRegNo,acDept from vHR_Prsn where (adDateExit is null or adDateExit >= GetDate()) order by acWorker
acWorker;210;;Delavec;10
acRegNo;56;;Os. Št.;20
acDept;210;;Oddelek;30

ltHFWorkerRegNo Key=acRegNo SQL=select distinct acRegNo,acWorker,acDept from vHR_Prsn where (adDateExit is null or adDateExit >= GetDate()) order by acRegNo
acRegNo;56;;Os. Št.;10
acWorker;210;;Delavec;20
acDept;210;;Oddelek;30

ltHFWorkProcess Key=acName SQL=select acName,acDept,acJob from vHR_SetWorkProces order by acName
acName;100;;Del. proces;10
acDept;100;;Oddelek;20
acJob;100;;Del.mesto;30

ltHFWOSE Key=acKey SQL=select acKeyView,acKey,acDocTypeView,acDocType,adDate,acIdent,acName,anPlanQty,acUM,acConsignee,acReceiver,acStatus from vHF_WOExLkpKey where acProdWOType<>'M' order by acKey
acKeyView;100;;DN;10
acDocTypeView;30;;VD;20
adDate;80;dd.mm.yyyy;Datum;30
acStatus;10;;S;40
acIdent;90;;Izdelek;50
acName;100;;Naziv;60
anPlanQty;80;#,##0.00;Količina;70
acUM;30;;EM;80

ltHFWOSEMF Key=acKey SQL=select acKeyView,acKey,acDocTypeView,acDocType,adDate,acIdent,acName,anPlanQty,acUM,acConsignee,acReceiver,acStatus from vHF_WOExLkpKey order by acKey
acKeyView;100;;DN;10
acDocTypeView;30;;VD;20
adDate;80;dd.mm.yyyy;Datum;30
acStatus;10;;S;40
acIdent;90;;Izdelek;50
acName;100;;Naziv;60
anPlanQty;80;#,##0.00;Količina;70
acUM;30;;EM;80

ltHRBankaDelavecAct Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acSWIFTCode, acCountry, acBank, acWorker from tHE_SetSubj WHERE acBank = 'T' and acActive = 'T' ORDER BY acSubject
acSubject;300;;Naziv;10
acAddress;300;;Naslov;20
acPost;110;;Pošta;30
acPhone;200;;Telefon;40

ltHRBankaDelavecSam Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acSWIFTCode, acCountry, acBank, acWorker from tHE_SetSubj WHERE acBank = 'T' ORDER BY acSubject
acSubject;300;;Naziv;10
acAddress;300;;Naslov;20
acPost;110;;Pošta;30
acPhone;200;;Telefon;40

ltHRBeneDoba Key=acBeneLOS SQL=select acBeneLOS, anIncrease, acName from vHR_SetBenLOS order by acBeneLOS
acBeneLOS;28;;Bene.doba;10
acName;210;;Naziv;20
anIncrease;70;;Povečanje;30

ltHRBooklets Key=acType SQL=select acType, acName from vHR_SetBooklets order by acType
acType;35;;Tip;10
acName;210;;Naziv;20

ltHRCalendarETTrvl Key=acSetOf SQL=select acSetOf, acName from vHR_SetCalendarEntryType where acType = 'T' order by acSetOf
acSetOf;60;;Kategorija;10
acName;250;;Naziv;20

ltHRCantons Key=acSubject SQL=select acSubject, acRegNo from tHE_SetSubj WHERE acRegion='T' ORDER BY acSubject
acSubject;280;;Kanton;10

ltHRCitizenship Key=acCitizenship SQL=select acCitizenship, acCountry, acCurrency from vHE_SetCountry where acCitizenship <> ' ' order by acCitizenship
acCitizenship;200;;Državljanstvo;10
acCountry;200;;Država;20
acCurrency;50;;Valuta;30

ltHRCommAgree Key=acCode SQL=select acCode,acName from vHR_SetCommAgre Order by acCode
acCode;70;;Šifra;10
acName;500;;Naziv;20

ltHRCountry Key=acCountry SQL=select acCountry, acCitizenship, acCurrency, acOrigin from vHE_SetCountry order by acCountry
acCountry;200;;Država;10
acCitizenship;200;;Državljanstvo;20
acCurrency;50;;Valuta;30
acOrigin;50;;Poreklo;40

ltHRDavcnaIzpostava Key=acTaxOffice SQL=select acTaxOffice, acName from vHR_SetTaxOffice order by acTaxOffice
acTaxOffice;42;;Šifra;10
acName;350;;Davčna izpostava;20

ltHRDavcnaVDC Key=acTaxId SQL=select acWorker, acTaxId, acName, acSurname, acUCN from tHR_PrsnFamilyMember
acTaxId;80;;Davčna Št.;10
acName;100;;Ime;20
acSurname;100;;Priimek;30
acUCN;100;;EMŠO;40

ltHRDejavnost Key=acActivityCode SQL=select acActivityCode, acName from vHE_SetSubjNACE order by acActivityCode
acActivityCode;105;;Dejavnost;10
acName;700;;Naziv;20

ltHRDelavec Key=acWorker SQL=SELECT acWorker, acRegNo, acSurname, acName, acUCN, acTaxId, acJob, acDept, adDateBirth FROM vHR_Prsn ORDER BY acWorker
acWorker;160;;Šifra;10
acRegNo;100;;Matična Št.;20
acSurname;140;;Priimek;30
acName;140;;Ime;40
acUCN;100;;EMŠO;50
acTaxId;80;;Davčna Št.;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80
adDateBirth;70;;Rojen;90

ltHRDelavec2 Key=acWorker SQL=SELECT acWorker, acRegNo, acSurname, acName, acUCN, acTaxId, acJob, acDept FROM vHR_Prsn ORDER BY acWorker
acWorker;160;;Šifra;10
acRegNo;100;;Matična Št.;20
acSurname;140;;Priimek;30
acName;140;;Ime;40
acUCN;100;;EMŠO;50
acTaxId;80;;Davčna Št.;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80

ltHRDelavecOD Key=acWorker SQL=SELECT distinct acWorker, acRegNo, acSurname, acName, acUCN,  acTaxId, acJob, acDept FROM vHR_LookWorkerSlry  ORDER BY acWorker
acWorker;160;;Šifra;10
acRegNo;100;;Matična Št.;20
acSurname;140;;Priimek;30
acName;140;;Ime;40
acUCN;100;;EMŠO;50
acTaxId;80;;Davčna Št.;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80

ltHRDelavecOD1 Key=acWorker SQL=SELECT distinct acWorker, acRegNo, acSurname, acName, acUCN,  acTaxId, Ackey FROM vHR_PrsnOD
acWorker;160;;Šifra;10
acRegNo;100;;Matična Št.;20
acSurname;140;;Priimek;30
acName;140;;Ime;40
acUCN;100;;EMŠO;50
acTaxId;80;;Davčna Št.;60

ltHRDelovniCas Key=acCode SQL=select distinct acCode,   case     when acShiftType = '1' then 'Delo v eni izmeni'     when acShiftType = '2' then 'Delo v dveh izmenah'     when acShiftType = '3' then 'Delo v treh izmenah'     when acShiftType = '4' then 'Delo v več izmenah'     when acShiftType = '5' then 'Delo v turnusih'   end as acName from tHR_SetHourWork order by acCode
acCode;28;;Šifra;10
acName;140;;Naziv formule;20

ltHRDelovnoMesto Key=acName SQL=select acName, acName2, acDeptId, acLeader, acIGroup, anMedExam, acMedExamName, anOccupHazardExam, acOccupHazardExamTitle, acBeneLOS from vHR_Job  where acActive = 'T' order by acName
acName;224;;Delovno mesto;10
acName2;300;;Delovno mesto - daljši naziv;20
acDeptId;300;;Oddelek;30

ltHRDelovnoRazmerje Key=acName SQL=select acName, acCode,   case acWorkingHours    when 'T' then 'Polni'     when 'F' then 'Krajši'     when 'V' then 'Vajenec'     when 'N' then 'Nepolni'     when 'R' then 'Nepolni'     when 'S' then 'Krajši polni'   end as acWorkingHoursCap from vHR_SetEmployType order by acName
acName;140;;Naziv;10
acWorkingHoursCap;80;;Delovni čas;20

ltHRDiseasesClassif Key=acCode SQL=select acCode, acName from vHR_SetDiseasesClassif order by acCode
acCode;28;;Šifra;10
acName;310;;Naziv;20

ltHRDMIDDelMesto Key=anId SQL=select acWorker, anId, adDate, adDateEnd, acJob, acDept, acEmploymentContract from tHR_Prsnjob order by anId
anId;21;;ID;10
acJob;147;;Delovno mesto;20
acDept;147;;Oddelek;30
adDate;63;;Začetek;40
adDateEnd;63;;Konec;50
acEmploymentContract;161;;Pogodba o zaposlitvi;60

ltHRDnevnica Key=acDailyAllow SQL=select acDailyAllow, acName from vHR_SetTrvl order by acDailyAllow
acDailyAllow;33;;Dnev.;10
acName;140;;Naziv;20

ltHRDopustLeto Key=anYear SQL=select distinct anYear from tHR_PrsnVacation order by anYear
anYear;70;;Leto;10

ltHRDopustTip Key=acSetOf SQL=select acSetOf, acName from tHR_SetCalendarEntryType where acType = '0' order by acSetOf
acSetOf;35;;Vrsta;10
acName;210;Naziv;;20

ltHREvidencaTip Key=acCode SQL=select acCode, acType, anDirection, acDescr from vHR_SetAccessType order by acCode
acCode;35;;Šifra;10
acType;35;;Tip;20
acDescr;350;;Opis;30

ltHREvidencaTip_Vsi Key= SQL=

ltHRFormuleDopust Key=acName SQL=select acName from vHR_SetVacationFormula order by acName
acName;140;;Naziv formule;10

ltHRIdentifikator Key=acId SQL=select R.acId, R.acPayTypeHR, O.acKeyView, O.acKey, O.acName, O.acPeriod from tHR_Slry_L_FormRS R, vHR_SlryPrepView O where R.acKey = O.acKey
acId;70;;Identifikator;10
acPayTypeHR;75;;Vrsta vplačila;20
acKeyView;100;;Obračun;30
acName;210;;Naziv;40
acPeriod;60;;Obdobje;50

ltHRIncomeTypesREK Key=acKey SQL=select acKey, acName from vHR_IncomeTypesREK order by acKey
acKey;60;;Šifra;10
acName;255;;Naziv;20

ltHRInspect Key=acName SQL=select acName, acPerformer, anPeriodical, acType, acSetOf from tHR_SetInspect
acName;210;;Naziv;10
anPeriodical;45;;Per;20
acPerformer;210;;Izvajalec;30

ltHRInspect1 Key=acName SQL=select acName, acPerformer, anPeriodical, acType, acSetOf from tHR_SetInspect Where acType = '1'
acName;210;;Naziv;10
anPeriodical;45;;Per;20
acPerformer;210;;Izvajalec;30

ltHRInspect23 Key=acName SQL=select acName, acPerformer, anPeriodical, acType, acSetOf from tHR_SetInspect Where acType in ('2', '3') Order by acName
acName;210;;Naziv;10
acType;45;;Tip;20
anPeriodical;45;;Per;30
acPerformer;210;;Izvajalec;40

ltHRInspect3 Key=acName SQL=select acName, acPerformer, anPeriodical, acType, acSetOf from tHR_SetInspect Where acType = '3' Order by acName
acName;210;;Naziv;10
anPeriodical;45;;Per;20
acPerformer;210;;Izvajalec;30

ltHRIzdajDelDov Key=acIssuer SQL=select acIssuer, acName from vHR_SetWorkPermitIssuer order by acIssuer
acIssuer;35;;Izdajatelj;10
acName;490;;Naziv;20

ltHRIzobIzobrazba Key=acName SQL=select distinct acName from tHR_SetSubjEducation order by acName
acName;210;;Naziv;10

ltHRIzobIzvajalec Key=acPerformer SQL=select distinct acPerformer from tHR_SetSubjEducation order by acPerformer
acPerformer;210;;Izvajalec;10

ltHRIzobrazba Key=acName SQL=select acName, acPerformer from tHR_SetSubjEducation order by acCode
acName;210;;Naziv;10
acPerformer;210;;Izvajalec;20

ltHRIzpMesta Key=acKey SQL=select acKey, acName from vHR_PrsnjobPayUpLoc order by acName
acKey;30;;Šifra;10
acName;300;;Naziv;20

ltHRJobDangerMean Key=acCode SQL=select acCode, acName, acChemicalName, acUNnumber, acADRnumbr, acRIDnumber from vHR_SetDangerMean order by acCode
acCode;30;;Šifra;10
acName;150;;Naziv;20
acChemicalName;150;;Kemično ime;30
acUNnumber;30;;UN št.;40
acADRnumbr;30;;ADR;50
acRIDnumber;30;;RID;60

ltHRJobRisks Key=acCode SQL=select acCode, acName from vHR_JobRisks order by acCode
acCode;30;;Šifra;10
acName;600;;Naziv;20

ltHRKadriPotreba Key=acPDRegNo SQL=select acPDRegNo, acJob, adDateAccepted, acJobDesc from vHR_Prsn_L_FormPD1 order by acPDRegNo
acPDRegNo;77;;Reg.št.prij.;10
adDateAccepted;77;;Sprej.prijave;20
acJob;245;;Del.mesto;30

ltHRKandidati Key=acApplicant SQL=select acApplicant, acSurname, acName from vHR_Applicant order by acApplicant
acApplicant;210;;Kandidat;10
acSurname;140;;Priimek;20
acName;70;;Ime;30

ltHRKartica Key=CARD_NO SQL=select CARD_NO, CARD_ID from RIS_IDCA order by CARD_NO
CARD_NO;35;;Št. kartice;10
CARD_ID;77;;ID koda;20

ltHRKlasifikacijaSol Key=acClassification SQL=select acClassification, acName from vHR_SetSchoolClass order by acClassification
acClassification;50;;Klas.;10
acName;280;;Naziv;20

ltHRKoledar Key=acCalendarID SQL=select distinct acCalendarID from tHR_PrsnCalendar order by acCalendarID
acCalendarID;35;;Šifra;10

ltHRKoledarSif Key=acCalendarID SQL=select acCalendarID, acName from tPA_SetCalendar order by acCalendarID
acCalendarID;35;;Šifra;10
acName;280;;Naziv;20

ltHRKoledarSif_Vsi Key= SQL=

ltHRKoledarVZ Key=acSetOf SQL=select acSetOf, acName from tHR_SetCalendarEntryType order by acSetOf
acSetOf;28;;Vrsta;10
acName;280;;Naziv;20

ltHRKoledarVZUra Key=acSetOf SQL=select acSetOf, acName from tHR_SetCalendarEntryType where acType = '6' order by acSetOf
acSetOf;60;;Kategorija;10
acName;250;;Naziv;20

ltHRKoledarVZUra_Vsi Key= SQL=

ltHRLeader Key=acLeader SQL=select distinct acLeader from tHR_Prsnjob where coalesce(acLeader,' ') <> ' ' order by acLeader
acLeader;240;;Vodja;10

ltHRMaticnaNasePodjetje Key=acRegNo SQL=select acRegNo, acSubject from tHE_SetSubj WHERE acSubject = (select acOurCompany from tPA_SysParam)
acRegNo;91;;Matična številka;10
acName;210;;Naziv podjetja;20

ltHRNastanPoskodbe Key=acInjuryCreatId SQL=select acInjuryCreatId, acName from vHR_SetInjuryCurc order by acInjuryCreatId
acInjuryCreatId;60;;Šifra;10
acName;350;;Nastanek poškodbe;20

ltHRObcinaSamo Key=acSubject SQL=select acSubject from tHE_SetSubj WHERE acMunicipality = 'T' and acRegion <> 'T' ORDER BY acSubject
acSubject;280;;Občina;10

ltHRObdobje Key=acPeriod SQL=select acPeriod from vHR_LookPeriod order by acPeriod
acPeriod;56;;Obdobje;10

ltHRObdobje_Desc Key=acPeriod SQL=select acPeriod from vHR_LookPeriod order by acPeriod desc
acPeriod;56;;Obdobje;10

ltHRObdobjeIzplacila Key=Leto_Mesec SQL=select Leto_Mesec from vHR_LookPeriodPay order by Leto_Mesec
Leto_Mesec;56;;Leto-mesec;10

ltHRObdobjeOd Key=acPeriod SQL=select acPeriod from vHR_ClockPeriodFrom order by acPeriod
acPeriod;56;;Obdobje;10

ltHROblikePoskodbe Key=acInjuryFormId SQL=select acInjuryFormId, acName from vHR_SetInjuryType order by acInjuryFormId
acInjuryFormId;60;;Šifra;10
acName;350;;Oblika poškodbe;20

ltHRObmocje Key=acSubject SQL=select acSubject from tHE_SetSubj WHERE acMunicipality = 'T' and acRegion = 'T' ORDER BY acSubject
acSubject;210;;Naziv;10

ltHRObracun Key=acKey SQL=select acKeyView, acKey, acName, acPeriod from vHR_SlryPrepView order by acKey
acKeyView;100;;Obračun;10
acName;300;;Naziv;20
acPeriod;50;;Obdobje;30

ltHRObracunNotEvi Key=acKey SQL=select acKeyView, acKey, P.acName, acPeriod from vHR_SlryPrepView P join tPA_SetDocType DT ON DT.acDocType = P.acDocType and DT.acEvidence <> 'T' order by acKey
acKeyView;100;;Obračun;10
acName;300;;Naziv;20
acPeriod;50;;Obdobje;30

ltHRObracunNotPost Key=acKey SQL=select acKeyView, acKey, P.acName, acPeriod from vHR_SlryPrepView P join tPA_SetDocType DT ON DT.acDocType = P.acDocType and DT.acEvidence <> 'T' where acPosted <> 'T' order by acKey
acKeyView;100;;Obračun;10
acName;300;;Naziv;20
acPeriod;50;;Obdobje;30

ltHROdDelZaposlen Key=acWorker SQL=SELECT acWorker, acRegNo, acSurname, acName, acUCN, acTaxId, acJob, acDept, adDateExit FROM vHR_LookEmployedFrom ORDER BY acWorker
acWorker;160;;Šifra;10
acRegNo;100;;Matična Št.;20
acSurname;140;;Priimek;30
acName;140;;Ime;40
acUCN;100;;EMŠO;50
acTaxId;80;;Davčna Št.;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80

ltHROdDnevnik Key= SQL=

ltHROdFazaObr_L Key=acPhase SQL=select acPhase, acName from vHR_LookFromPhaseL order by acPhase
acPhase;42;;Faza;10
acName;210;;Naziv;20

ltHROdObrKonacni Key=acKey SQL=select acKeyView, acKey, acName, acPeriod, adPaymentDate from vHR_LookSlryCalcEnd order by acKey
acKeyView;100;;Obračun;10
acName;300;;Naziv;20
acPeriod;60;;Obdobje;30

ltHROdObrPromAr Key=acKey SQL=select acKeyView, acKey, acName, acPeriod, adPaymentDate, acId from vHR_LookSlryCalcSum order by acKey
acKeyView;100;;Obračun;10
acName;300;;Naziv;20
acPeriod;60;;Obdobje;30
acId;70;;Identifikator;40

ltHRODRazred Key=acIGroup SQL=select acIGroup, anFactor from vHR_SetSlryIncomeGroup order by acIGroup
acIGroup;42;;Tarifni razred;10
anFactor;70;;Indeksno razmerje;20

ltHROdsotnost Key=acSetOf SQL=select acSetOf, acName from vHR_SetCalendarAbsence order by acSetOf
acSetOf;60;;Kategorija;10
acName;250;;Naziv;20

ltHRODTipKredita Key=acLoanType SQL=select acLoanType from vHR_SetLoanType order by acLoanType
acLoanType;210;;Tip kredita;10

ltHRODVrstZas Key= SQL=

ltHROptSubj Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj   ORDER BY acSubject
acSubject;200;;Subjekt;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;150;;Telefon;50

ltHROriginCitizenship Key=acOrigin SQL=select acOrigin, acCitizenship from tHE_SetCountry where acOrigin <> ' ' and acCitizenship <> ' ' order by acOrigin
acOrigin;50;;Poreklo;10
acCitizenship;200;;Državljanstvo;20

ltHROriginCountry Key=acOrigin SQL=select acOrigin, acCountry from vHE_SetCountry where acOrigin <> ' ' order by acOrigin
acOrigin;50;;Poreklo;10
acCountry;200;;Država;20

ltHROsnSreDrobInv Key=acInventNum SQL=select acType, acInventNum, acName from vHE_FA Where acType <> 'V' order by acType, acInventNum
acInventNum;80;;Invent.št.;10
acType;50;;Tip;20
acName;300;;Naziv;30

ltHROsSre Key=acCarRegNo SQL=select acCarRegNo, acName, acCompanyCar from vHR_SetTrvlVehicle order by acName
acCarRegNo;140;;Registrska številka;10
acName;280;;Naziv;20

ltHROsSre_Tip Key= SQL=

ltHROsSreDB Key=acCarRegNo SQL=select acCarRegNo, acName, acCompanyCar from vHR_SetTrvlVehicle order by acName
acCarRegNo;140;;Registrska številka;10
acName;280;;Naziv;20

ltHROSSrePomVozila Key=acCarRegNo SQL=select acCarRegNo, acName, acInventNum from vHR_SetTrvlSuppVehicle order by acCarRegNo
acCarRegNo;80;;Registrska številka;10
acInventNum;80;;Invent.št.;20
acName;300;;Naziv;30

ltHRPodEnota Key=acSubUnit SQL=select distinct acSubUnit from vHR_DeptSubUnit order by acSubUnit
acSubUnit;280;;Naziv;10

ltHRPodlagaZavarovanja Key=acInsureType SQL=select acInsureType, anWorkingHours, acFragWorkHour, acName from vHR_Set_L_InsurType order by acInsureType
acInsureType;28;;Šifra;10
acName;210;;Naziv;20

ltHRPoklic Key=acOccup SQL=select acOccup, acEducation, acName from vHR_SetOccup order by acOccup
acOccup;70;;Poklic;10
acEducation;70;;Izobrazba;20
acName;280;;Naziv;30

ltHRPoklicNPK Key=acOccup SQL=select acOccup, acName from vHR_SetOccupNPK order by acOccup
acOccup;91;;Poklic;10
acName;280;;Naziv;20

ltHRPoklicSKP Key=acOccup SQL=select acOccup, acName from vHR_SetOccupSKP order by acOccup
acOccup;70;;Poklic;10
acName;420;;Naziv;20

ltHRPoslDogBlgIzd Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'B' and acType = 'I' order by acDocType
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltHRPoslDogBlgPre Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'B' and acType = 'P' order by acDocType
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltHRPoslDogPotNal Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'S' order by acDocType
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltHRPosta Key=acPost SQL=select acPost, acName, anKm, acRegion from vHE_SetPostCode order by acPost
acPost;77;;Pošta;10
acName;210;;Kraj;20
anKm;70;;KM;30
acRegion;210;;Regija;40

ltHRPotNal Key=acKey SQL=select acKeyView, acKey, adDate, acWorker from vHR_Trvl order by acKey
acKeyView;100;;Obračun;10
adDate;84;;Datum;20
acWorker;210;;Šifra;30

ltHRPrefix Key=acPrefix SQL=select acPrefix from vHR_LookPrefix order by acPrefix
acPrefix;70;;Prefix;10

ltHRProtectEquip Key=acInventNum SQL=select acInventNum, acName, anPeriodical, anQty from VHR_LOOKPROTECTEQUIP order by acInventNum
acInventNum;80;;Šifra;10
acName;300;;Naziv;20
anPeriodical;45;;Per;30
anQty;90;;Količina;40

ltHRPrsnAddDoc Key=acNumber SQL=Select acNumber, acSerialNo, acIssuer, adDateIssue, adDateValid, acWorker,  acActive, acType,  CASE when acType = '1' then 'Osebna izkaznica'  when acType = '2' then 'Delovna knjižica'  when acType = '3' then 'Potna listina'  when acType = '4' then 'Zdravstvena izkaznica'  when acType = '5' then 'Vozniško dovoljenje'  when acType = '6' then 'Drugo'  when acType = '7' then 'Evropska zdravstvena izkaznica'  else '' end as acTypeName from tHR_PrsnAddDoc
acNumber;80;;Številka;10
acSerialNo;80;;Serijska številka;20
acActive;30;;Aktiven;30
acType;20;;Tip;40
acTypeName;300;;Naziv;50
acIssuer;300;;Izdajatelj;60
adDateIssue;60;;Datum izdaje;70
adDateValid;60;;Datum veljavnosti;80

ltHRPrsnStatusRegB Key=acName SQL=select acName from vHR_SetPrsnStatusRegB order by acName
acName;200;;Status v matični knjigi;10

ltHRReasonTrain Key=acCode SQL=select acCode, acName from vHR_SetReasonTrain order by acCode
acCode;30;;Šifra;10
acName;300;;Naziv;20

ltHRRelacija Key=acRoute SQL=select acRoute, acName from vHR_SetRoute order by acRoute
acRoute;56;;Relacija;10
acName;350;;Naziv;20

ltHRSetEval1 Key=acSetEval SQL=select acSetEval, acType, anValue, acDescription from tHR_SetEval where acType = '1'
acSetEval;240;;Naziv;10
anValue;80;;Vrednost;20
acDescription;120;;Opomba;30

ltHRSetEval2 Key=acSetEval SQL=select acSetEval, acType, anValue, acDescription from tHR_SetEval where acType = '2'
acSetEval;240;;Naziv;10
anValue;80;;Vrednost;20
acDescription;120;;Opomba;30

ltHRSetJobCompet Key=acJobCompet SQL=select acJobCompet, acName from vHR_SetJobCompet order by acJobCompet
acJobCompet;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetJobFulfilm Key=acJobFulfilm SQL=select acJobFulfilm, acName from vHR_SetJobFulfilm order by acJobFulfilm
acJobFulfilm;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetJobImportan Key=acJobImportan SQL=select acJobImportan, acName from vHR_SetJobImportan order by acJobImportan
acJobImportan;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetJobStand Key=acJobStand SQL=select acJobStand, acName, acDesc, acJobStandType, StandTypeName, StandTypeDesc from vHR_SetJobStand order by acJobStand
acJobStand;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetJobStandType Key=acJobStandType SQL=select acJobStandType, acName from vHR_SetJobStandType order by acJobStandType
acJobStandType;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetJobTask Key=acJobTask SQL=select acJobTask, acName, acDesc, acJobTaskType, TaskTypeName, TaskTypeDesc from vHR_SetJobTask order by acJobTask
acJobTask;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetJobTaskType Key=acJobTaskType SQL=select acJobTaskType, acName from vHR_SetJobTaskType order by acJobTaskType
acJobTaskType;60;;Šifra;10
acName;255;;Naziv;20

ltHRSetProfEduc Key=acCode SQL=select acCode, acProfEducLvl, acName from vHR_SetProfEduc order by acProfEducLvl
acCode;30;;Šifra;10
acProfEducLvl;30;;Stopnja;20
acName;110;;Naziv;30

ltHRSetVSPIPremClass Key=anPremClass SQL=select anPremClass, anAddYears, anMinBonus, anAddBonus, anSumBonus from vHR_SetVSPIPremClass order by anPremClass
anPremClass;100;;Premijski razred;10
anAddYears;100;;Leta delovne dobe;20
anMinBonus;95;#,##0.00;Minimalna premija;30
anAddBonus;90;#,##0.00;Dodatna premija;40
anSumBonus;85;#,##0.00;Skupna premija;50

ltHRSifraKoledar Key= SQL=

ltHRSifraObcine Key=acMunicipCode SQL=select acMunicipCode, acSubject from tHE_SetSubj WHERE acMunicipality = 'T' and acRegion <> 'T' ORDER BY acSubject
acMunicipCode;28;;Šifra občine;10
acSubject;210;;Naziv;20

ltHRSindikat Key=acCode SQL=select acCode, acSubject, acET, anPrcBase, anPrcFactor, acBank, anBnkAcctNo from tHR_SetSubjUnion order by acCode
acCode;70;;Šifra;10
acSubject;210;;Naziv;20

ltHRSlry_L_IncomeType Key=acIncomeType SQL=select acIncomeType, acName from vHR_SetSlry_L_IncomeType order by acIncomeType
acIncomeType;45;;Dogodek;10
acName;210;;Naziv;20

ltHRSlryBaseCG Key=acCode SQL=select acCode, acName from vHR_SetSlryCalcBaseCG order by acCode
acCode;28;;Šifra;10
acName;310;;Naziv;20

ltHRSlryET Key=acET SQL=select acET, acPhase, acName from vHR_SetSlryET order by acET
acET;56;;Vrst.zas.;10
acPhase;35;;Faza;20
acName;210;;Naziv;30

ltHRSlryETAct Key=acET SQL=select acET, acPhase, acName from vHR_SetSlryET Where acActive = 'T' order by acET
acET;56;;Vrst.zas.;10
acPhase;35;;Faza;20
acName;210;;Naziv;30

ltHRSlryWorkType Key=acWorkType SQL=select acWorkType, acName from vHR_SetSlryWorkType order by acWorkType
acWorkType;45;;Vrst.dela;10
acName;210;;Naziv;20

ltHRStatus Key=acName SQL=select acName from vHR_SetPrsnStatus order by acName
acName;140;;Status;10

ltHRSubjektBanka Key=anNo SQL=select acType, anNo, acBank, acBnkAcctNo1, acBnkAcctNo2, acBnkAcctNo3, acBnkAcctNo23, acBlocked from tHE_SetSubjBank order by acType, anNo
anNo;28;;Poz;10
acType;42;;Tip;20
acBank;175;;Banka;30
acBnkAcctNo1;147;;Račun;40
acBnkAcctNo2;21;;Mod.;50
acBnkAcctNo3;168;;Sklic 3;60
acBnkAcctNo23;21;;Tip;70

ltHRSubjektSindikat Key=acSubject SQL=select distinct acSubject from tHR_SetSubjUnion order by acSubject
acSubject;210;;Sindikat;10

ltHRSubjRacDom Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone from vHR_LookSubjAcctDom order by acSubject
acSubject;210;;Naziv;10
acAddress;420;;Naslov;20
acPost;77;;Pošta;30
acPhone;140;;Telefon;40

ltHRTemeStev Key=acKey SQL=select acKeyView, acKey, adDate, anClerk from vHE_AcctTrans order by acKey
acKeyView;100;;Temeljnica;10
adDate;70;;Datum;20
anClerk;60;;Referent;30

ltHRTrvlCurrency Key=acCurrency SQL=select acCurrency, acName from vHR_LookTrvlCurrency order by acSequence
acCurrency;30;;Valuta;10
acName;300;;Naziv;20

ltHRTrvlItem Key=anNo SQL= select anNo, acKey, acSubject, acCity from tHR_TrvlItem order by anNo
anNo;70;;Poz;10
acSubject;210;;Subjekt;20
acCity;150;;Kraj;30

ltHRTrvlStatus Key=acName SQL=select acName from vHR_SetTrvlStatus order by acName
acName;280;;Naziv;10

ltHRTrvlTypeOtherCost Key=acName SQL=select distinct acName from vHR_TrvlOtherCostType order by acName
acName;280;;Tip stroška;10

ltHRVzrokiPoskodbe Key=acInjuryCauseId SQL=select acInjuryCauseId, acName from vHR_SetInjuryCause order by acInjuryCauseId
acInjuryCauseId;60;;Šifra;10
acName;350;;Vzroki za poškodbo;20

ltHRVzrokPrenehanja Key=acName SQL=select acCode, acName from tHR_SetTermType order by acCode, acName
acName;280;;Naziv;10

ltHRVzrokPrenehanja2 Key=acCode SQL=select acCode, acName from tHR_SetTermType order by acCode, acName
acCode;50;;Šifra;10
acName;280;;Naziv;20

ltHRVzrokVstopa Key=acKey SQL=select acKey from vHR_EntranceCauses order by acName
acKey;300;;Šifra;10

ltHRWorkerOIB Key=acTaxId SQL=SELECT acTaxId, acWorker, acUCN, acRegNo, acSurname, acName, acJob, acDept FROM vHR_Prsn ORDER BY acWorker
acTaxId;80;;Davčna Št.;10
acUCN;100;;EMŠO;20
acWorker;160;;Šifra;30
acRegNo;100;;Matična Št.;40
acSurname;140;;Priimek;50
acName;140;;Ime;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80

ltHRWorkerUCN Key=acUCN SQL=SELECT acUCN, acWorker, acRegNo, acSurname, acName, acTaxId, acJob, acDept FROM vHR_Prsn ORDER BY acWorker
acUCN;100;;EMŠO;10
acWorker;160;;Šifra;20
acRegNo;100;;Matična Št.;30
acSurname;140;;Priimek;40
acName;140;;Ime;50
acTaxId;80;;Davčna Št.;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80

ltInstrPlac Key=acPaymentDevice SQL=select acPaymentDevice, acName, acLocalization from vHE_SetPayDevice order by acPaymentDevice
acPaymentDevice;56;;Instr.plač.;10
acName;210;;Naziv;20

ltIzrGume Key=acUsedTyre SQL=select acUsedTyre, acName from vHE_SetItemUsedTyre order by acUsedTyre
acUsedTyre;80;;Šifra;10
acName;300;;Naziv;20

ltIzvrPlac Key=acPayImp SQL=select acPayImp, acName from vHE_SetPayImp order by acPayImp
acPayImp;56;;Način izvršitve plačila;10
acName;210;;Naziv;20

ltKlasif Key=acClassif SQL=select acClassif, acName from vHE_SetItemCateg order by acClassif
acClassif;150;;Klasifik.;10
acName;350;;Naziv;20

ltKlasifPrim Key=acClassif SQL=select acClassif, acName from vHE_SetItemCateg where acType in ('P', 'O') order by acClassif
acClassif;150;;Klasifik.;10
acName;350;;Naziv;20

ltKlasifSek Key=acClassif SQL=select acClassif, acName from vHE_SetItemCateg where acType in ('S', 'O') order by acClassif
acClassif;150;;Klasifik.;10
acName;350;;Naziv;20

ltKnjKljuc Key=acCode SQL=select acCode, acName from vHE_SetPostDistKey order by acCode
acCode;100;;Šifra;10
acName;250;;Naziv;20

ltKoda Key=acCode SQL=select acKljuc, acVATCodePrefix, acCode, acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acActivityCode, acCity from vHE_SetSubjCode order by acCode
acCode;200;;Šifra;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltKoledarVZ Key=acSetOf SQL=select acSetOf, acName from tHR_SetCalendarEntryType where acType = '2'
acSetOf;35;;Vrsta;10
acName;210;;Naziv;20

ltKonto Key=acAcct SQL=select acAcct, acName, acPermitPost from vHE_SetAccount order by acAcct
acAcct;100;;Konto;10
acPermitPost;10;;;20
acName;500;;Naziv;30

ltKontoLT Key=anEventTypeID SQL=select acName, acAcct, acType, anEventTypeID from tHE_SetEventType order by anEventTypeID
acName;300;;Naziv;10
acType;10;;T;20
acAcct;100;;Konto;30

ltKontoObv Key=acAcct SQL=select acAcct, acName, acPermitPost from vHE_SetAccount order by acAcct
acAcct;90;;Konto;10
acPermitPost;10;;;20
acName;500;;Naziv;30

ltKontoObvLT Key=anEventTypeID SQL=select acName, acAcct, acType, anEventTypeID from tHE_SetEventType order by anEventTypeID
acName;300;;Naziv;10
acType;10;;T;20
acAcct;100;;Konto;30

ltKontoOs Key= SQL=

ltKontOs Key=acContactPrsn SQL=select acContactPrsn, acPhone, acNote, anNo from vHE_LookContactPerson order by acContactPrsn
acContactPrsn;210;;Kontaktna oseba;10
acPhone;140;;Telefon;20
acNote;210;;Opomba;30

ltKontOsUser Key=anUserID SQL=select anUserID, acContactPrsn, acPhone, acNote, anNo from vHE_LookContactPerson order by acContactPrsn
acContactPrsn;210;;Kontaktna oseba;10
acPhone;140;;Telefon;20
acNote;210;;Opomba;30

ltKontOsUserEmail Key=acEmail SQL=select acEmail, acContactPrsn, anNo, MAX(acNote) as acNote from vHE_SetSubjContPersonEmail group by acContactPrsn, acEmail, anNo having anNo=MIN(anNo) order by anNo
acEmail;140;;e-Mail;10
acContactPrsn;210;;Kontaktna oseba;20
acNote;210;;Opomba;30

ltKupDob Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj WHERE acSupplier = 'T' or acBuyer = 'T' ORDER BY acSubject
acSubject;200;;Kupec;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltKupec Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj WHERE acBuyer = 'T' ORDER BY acSubject
acSubject;200;;Kupec;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltKupecKoda Key=acCode SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj WHERE acBuyer = 'T' ORDER BY acSubject
acCode;200;;Šifra;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltKupecNaziv2 Key=acName2 SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj WHERE acActive <> 'F' and acBuyer = 'T' ORDER BY acname2
acName2;200;;Naziv 2;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltKupecNaziv3 Key=acName3 SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj WHERE acBuyer = 'T' ORDER BY acSubject
acName3;200;;Naziv 3;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltKupecOIB Key=acPin SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acPin, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj WHERE acBuyer = 'T' ORDER BY acSubject
acPin;200;;OIB broj;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltMoveCosts Key=anNo SQL=SELECT anNo, acName from tPA_SysParamCosts order by anNo
anNo;60;;Šifra;10
acName;150;;Naziv;20

ltMS Key=acIdent SQL=select acIdent, acName, anRTPrice, acActive, acSetOfItem from vHE_SetItem  ORDER BY acIdent
acIdent;90;;Koda;10
acName;300;;Naziv;20
anRTPrice;80;#,##0.00;Cena;30

ltMSA Key=acIdent SQL=select acIdent, acName, anRTPrice, acActive, acSetOfItem from vHE_SetItem WHERE acActive = 'T' ORDER BY acIdent
acIdent;90;;Koda;10
acName;300;;Naziv;20
anRTPrice;80;#,##0.00;Cena;30

ltMSForm Key=acCode SQL=select acCode, acName, acFormula from vHE_SetItemFormula order by acCode
acCode;90;;Koda;10
acName;300;;Naziv;20
acFormula;300;;Formula;30

ltMSK Key=acCode SQL=select acCode, acSupplier, acIdent, acName, acClassif, acActive, acSetOfItem from vHE_SetItem  ORDER BY acCode
acCode;90;;Dob.šifra;10
acSupplier;210;;Dobavitelj;20

ltMSN Key=acName SQL=select acName, acIdent, anRTPrice, acActive, acSetOfItem from vHE_SetItem  ORDER BY acName
acName;300;;Naziv;10
acIdent;90;;Koda;20
anRTPrice;80;#,##0.00;Cena;30

ltMSNA Key=acName SQL=select acName, acIdent, anRTPrice, acActive, acSetOfItem from vHE_SetItem WHERE acActive = 'T' ORDER BY acName
acName;300;;Naziv;10
acIdent;90;;Koda;20
anRTPrice;80;#,##0.00;Cena;30

ltMSStolpci Key=acColumn SQL=select acColumn, acName from vHE_SetItemSNT order by acColumn
acColumn;50;;Stolpec;10
acName;210;;Naziv;20

ltMunicip Key=acMunicipCode SQL=select acMunicipCode,acName from vHR_SetMunicip Order by acMunicipCode
acMunicipCode;70;;Šifra;10
acName;200;;Naziv;20

ltNacDost Key=acDelivery SQL=select acDelivery, acName from vHE_SetDelMet where acActive = 'T' order by acDelivery
acDelivery;70;;Dostava;10
acName;200;;Naziv;20

ltNacDostAll Key=acDelivery SQL=select acDelivery, acName from vHE_SetDelMet where order by acDelivery
acDelivery;70;;Dostava;10
acName;200;;Naziv;20

ltNacPlac Key=acPayMethod SQL=select acPayMethod, acName, acSetOf from vHE_SetPayMet order by acPayMethod
acPayMethod;56;;Nač.plač.;10
acName;210;;Naziv;20
acSetOf;21;;V.;30

ltNacPlac2 Key=acPayMethod SQL=select acPayMethod, acName, acSetOf from vHE_SetPayMet  WHERE acSetOf = 'G' AND 1=1 ORDER BY acPayMethod
acPayMethod;56;;Nač.plač.;10
acName;210;;Naziv;20
acSetOf;21;;V.;30

ltNacPlacZbirCen Key=acPayMethod SQL=select acPayMethod, acName, acSetOf from vHE_SetPayMet where acSetOf = 'Z' order by acPayMethod
acPayMethod;56;;Nač.plač.;10
acName;210;;Naziv;20
acSetOf;21;;V.;30

ltNarocIsci Key=acKey SQL=SELECT acKey, acKeyView, acConsignee, adDate, acReceiver, adDeliveryDeadline, acDocType FROM vHE_Order ORDER BY acKey
acKeyView;90;;Ključ;10
acConsignee;200;;Naročnik;20
adDate;60;;Datum;30
acReceiver;200;;Prejemnik;40
aDeliveryDeadline;60;;Rok dobave;50

ltNarocIsciView Key=acKeyView SQL=SELECT acKey, acKeyView, acConsignee, adDate, acReceiver, adDeliveryDeadline, acDocType FROM vHE_Order ORDER BY acKey
acKeyView;90;;Ključ;10
acConsignee;200;;Naročnik;20
adDate;60;;Datum;30
acReceiver;200;;Prejemnik;40
aDeliveryDeadline;60;;Rok dobave;50

ltNarocStatus Key= SQL=

ltObcina Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acName3  from tHE_SetSubj WHERE acMunicipality = 'T' ORDER BY acSubject
acSubject;200;;Občina;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltObrMera Key=acSetOf SQL=select acSetOf, acName from vHE_SetIntrestRate order by acSetOf
acSetOf;45;;Vrsta;10
acName;210;;Naziv;20

ltOdDel Key=acWorker SQL=SELECT acWorker, acRegNo, acSurname, acName, acUCN, acTaxId, acJob, acDept FROM vHR_Prsn ORDER BY acWorker
acWorker;160;;Šifra;10
acRegNo;100;;Matična Št.;20
acSurname;140;;Priimek;30
acName;140;;Ime;40
acUCN;100;;EMŠO;50
acTaxId;80;;Davčna Št.;60
acJob;140;;Delovno mesto;70
acDept;120;;Oddelek;80

ltOddelek Key=acSubject SQL=select acSubject, acName2, acName3 from vHE_SubjDeptLook  ORDER BY acSubject
acSubject;200;;Oddelek;10
acName2;150;;Naziv 2;20
acName3;150;;Naziv 3;30

ltOddelekAct Key=acSubject SQL=select acSubject, acName2, acName3 from vHE_SubjDeptLook WHERE acActive = 'T' ORDER BY acSubject
acSubject;200;;Oddelek;10
acName2;150;;Naziv 2;20
acName3;150;;Naziv 3;30

ltOdFazaObr Key= SQL=

ltOdpadEEOprem Key=acWstEEEquip SQL=select acWstEEEquip from tHE_SetItemWstEEEquip order by acWstEEEquip
acWstEEEquip;150;;Razred EE opreme;10

ltOdpadEmbal Key=acWastePack SQL=select acWastePack, acName from vHE_SetItemWastePack order by acWastePack
acWastePack;60;;Šifra;10
acName;300;;Naziv;20

ltOdPrisp Key=acContribution SQL=select acContribution, acName, acPayer, acMunicipType, acValuePercent, acAcctDB, acAcctCR from vHR_SetSlryContr order by acContribution
acContribution;60;;Prispevek;10
acName;170;;Naziv prispevka;20
acPayer;60;;Plačnik;30
acMunicipType;60;;Vrst.nak.;40
acValuePercent;60;;Vrst.obrač.;50
acAcctDB;70;;KontoDB;60
acAcctCR;70;;KontoCR;70

ltOdRazred Key= SQL=

ltOdSifraVirman Key=acCode SQL=select acCode, acName, acCode1, acCode2, acCode3 from vHR_SetPayOrdType order by acCode
acCode;80;;Šifra virmana;10
acName;200;;Naziv;20
acCode1;60;;Šifra 1;30
acCode2;60;;Šifra 2;40
acCode3;60;;Šifra 3;50

ltOdVrstaDela Key= SQL=

ltOdVrstDoh Key= SQL=

ltOdVrstZas Key= SQL=

ltOSAmortSk Key=acDeprecGrp SQL=select acDeprecGrp, acName, anMinRate, anAcclRate from vHE_SetFADeprecGroup order by acDeprecGrp
acDeprecGrp;8;;Amort.sk.;10
acName;200;;Naziv;20
anMinRate;8;;Min.stopnja;30
acAcclRate;8;;Pos.stopnja;40

ltOSKlasif Key=acClassif SQL=select acClassif, acName from vHE_SetFAClassif order by acClassif
acClassif;33;;Skupina;10
acName;210;;Naziv;20

ltOSLokacije Key=acLocID SQL=select acLocID, acName, acCompany, acDept, acCostDrv from vHE_SetFALocation where acActive = 'T' order by acLocID
acLocID;50;;Lokacija;10
acName;200;;Naziv;20
acCompany;200;;Podjetje;30
acDept;200;;Oddelek;40
acCostDrv;140;;Str.nos.;50

ltOSProm Key=acKey SQL=select acKey, acPeriodStart, acPeriodEnd, acKeyView from vHE_FADeprec order by acKey
acKeyView;110;;Številka;10
acPeriodStart;70;;Obdobje od;20
acPeriodEnd;70;;Obdobje do;30

ltOSSre Key=acInventNum SQL=select acInventNum, acName from vHE_FA order by anLenInventNum, acInventNum
acInventNum;80;;Invent.št.;10
acName;300;;Naziv;20

ltOSSreNaziv2 Key=acName2 SQL=select acName2, acInventNum from vHE_FA order by acName2
acName2;350;;Naziv 2;10
acInventNum;16;;Invent.št.;20

ltOSSreProm Key=acInventNum SQL=select acInventNum, acName, acLocID from tHE_FA order by acInventNum
acInventNum;60;;Invent.št.;10
acName;300;;Naziv;20
acLocID;40;;Lokacija;30

ltOSStatus Key=acStatus SQL=select acStatus, acName from vHE_SetFAStatus order by acStatus
acStatus;50;;Status;10
acName;200;;Naziv;20

ltOSVrsta Key=acSetOf SQL=select acSetOf, acName from vHE_SetFATypes order by acSetOf
acSetOf;8;;Vrsta;10
acName;40;;Naziv;20

ltPAKoledarVZ Key=acSetOf SQL=select acSetOf, acName from tPA_SetCalendarEntryType where acType = 'C' order by acSetOf
acSetOf;28;;Vrsta;10
acName;280;;Naziv;20

ltPASetDocTypeStat Key=acStatus SQL=select acDocType,acStatus,acName from tPA_SetDocTypeStat
acStatus;20;;Status;10
acName;110;;Naziv;20

ltPASetDocTypeStatP Key=acStatus SQL=select acStatus,acName,acVerified from tPA_SetDocTypeStatP
acStatus;20;;Status;10
acName;110;;Naziv;20

ltPoljubnoPolje Key=acFieldName SQL=Select A.acField as acField, A.acFieldName as acFieldName from
(Select acFieldSA as acField, 'acFieldSA' as acFieldName from vPA_SysParam union all Select acFieldSB as acField, 'acFieldSB' as acFieldName from vPA_SysParam union all
Select acFieldSC as acField, 'acFieldSC' as acFieldName from vPA_SysParam union all Select acFieldSD as acField, 'acFieldSD' as acFieldName from vPA_SysParam union all
Select acFieldSE as acField, 'acFieldSE' as acFieldName from vPA_SysParam union all Select acFieldSF as acField, 'acFieldSF' as acFieldName from vPA_SysParam union all
Select acFieldSG as acField, 'acFieldSG' as acFieldName from vPA_SysParam union all Select acFieldSH as acField, 'acFieldSH' as acFieldName from vPA_SysParam union all
Select acFieldSI as acField, 'acFieldSI' as acFieldName from vPA_SysParam union all Select acFieldSJ as acField, 'acFieldSJ' as acFieldName from vPA_SysParam) A
where IsNull(acField, '') <> ''
order by 2
acFieldName;10;;Polje;10
acField;20;;Naziv polja;20

ltPoljubnoPoljeValue Key= SQL=

ltPoreklo Key=acOrigin SQL=select acOrigin, acDutyCommunity, acCountry from vHE_SetCountry where acOrigin <> ' ' order by acOrigin
acOrigin;60;;Poreklo;10
acDutyCommunity;25;;CS;20
acCountry;210;;Država;30

ltPoslDog Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPoslDogAvans Key= SQL=

ltPoslDogBlg Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'B' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogCarIzd Key=acDocType SQL=SELECT acDocTypeView, acDocType, acName, acSetOf, acType FROM vPA_SetDocType WHERE acSetOf = 'C' AND acTypeOfDoc = 'M' AND acType = 'I' ORDER BY acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogCarIzdKV Key=acDocType SQL=select acDocTypeView, acDocType,acName from vPA_SetDocType where acSetOf = 'C' AND acTypeOfDoc = 'Z' AND acType = 'I' order by acDocTypeView
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltPoslDogECL Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'E' AND acType = 'L' order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPoslDogGK Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'K' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogIS Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'J' AND acType = 'L' order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPoslDogLik Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'L' and acType = 'P' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogLikTuj Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'L' and acType = 'T' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogNarDob Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf='N' and acType='I' order by acDocTypeView
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltPoslDogNarKup Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf='N' and acType='P' order by acDocTypeView
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltPoslDogOD Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'O' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogPer Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf ='N' or (acSetOf = 'F' and acType = 'I') order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogPlan Key=acDocType SQL=select acDocTypeView, acDocType,acName from vPA_SetDocType where acSetOf='H' order by acDocTypeView
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltPoslDogPOS Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' AND acType = 'M' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogProiz Key=acDocType SQL=select acDocTypeView, acDocType,acName from vPA_SetDocType where acSetOf='D' order by acDocTypeView
acDocTypeView;30;;VD;10
acName;300;;Naziv;20

ltPoslDogPromet Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogPrometIzd Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' AND (acType = 'I' or acType = 'M') order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogPrometIzdPOS Key= SQL=

ltPoslDogPrometIzdPrn Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' AND (acType = 'E' or acType = 'I') order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogPrometPre Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' AND acType = 'P' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogPrometPreIzd Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' AND (acType = 'P' or acType = 'I') order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogReval Key=acDocType SQL=select acDocTypeView, acDocType, acName, acSetOf, acType from vPA_SetDocType where acSetOf = 'F' AND acType = 'P' and acIsValueBasedPost = 'T' order by acDocTypeView
acDocTypeView;49;;Pos.dog.;10
acName;231;;Naziv;20

ltPoslDogRMAIzd Key=acDocTypeView SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'F' AND (acType = 'E' or acType = 'I') and acIsBuyerRMA = 'T' order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPoslDogSC Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'F' AND acType = 'C' order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPoslDogTD Key=acDocType SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'W' AND acType = 'L' order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPoslDogTip Key=acTypeDocType SQL=select acTypeDocType, acDescription from vHE_SetTypeDocType order by acTypeDocType
acTypeDocType;49;;Tip;10
acDescription;231;;Opis;20

ltPoslDogVrstaDejavnosti Key=acActivityType SQL=select acActivityType, acName from vHE_SetActivityType order by acActivityType
acActivityType;56;;Vrsta;10
acName;400;;Opis;20

ltPoslDogZaracIzd Key=acDocTypeView SQL=select acDocTypeView, acDocType, acName from vPA_SetDocType where acSetOf = 'F' AND (acType = 'I' or acType = 'M') and acTypeOfDoc <> 'A' and acIsBuyerRMA = 'F' order by acDocTypeView
acDocTypeView;30;;P.D.;10
acName;300;;Naziv;20

ltPosta Key=acPost SQL=select acPost, acName, anKm from vHE_SetPostCode order by acPost
acPost;77;;Pošta;10
acName;210;;Kraj;20
anKm;70;;KM;30

ltPostaISO Key=acPost SQL=select acPost, acName, anKm from vHE_LookPostCode order by acOrder
acPost;77;;Pošta;10
acName;210;;Kraj;20
anKm;70;;KM;30

ltPrimValuta Key=acCurrency SQL=select distinct V.acCurrency, V.acName from vHE_SetCurrency V, tPA_SysParamPrimCurr S where V.acCurrency = S.acPrimCurrency order by V.acCurrency
acCurrency;30;;VD;10
acName;300;;Naziv;20

ltPrometHRNKView Key=acKeyView SQL=SELECT acKey, acKeyView, adDate, acSupplier FROM vHE_MoveHRCB ORDER BY acKey
acKeyView;90;;Ključ;10
adDate;60;;Datum;20
acSupplier;300;;Dobavitelj;30

ltPrometIsci Key=acKey SQL=SELECT acKey, acKeyView, adDate, adDateVAT, acIssuer, acReceiver, acDept, anForPay, anValue, anVAT, acContactPrsn, acDocType FROM vHE_Move ORDER BY acKey
ackeyView;90;;Ključ;10
adDate;60;;Datum;20
acIssuer;300;;Izdajatelj;30
acReceiver;300;;Prejemnik;40
anForPay;80;#,##0.00;Za plačilo;50

ltPrometIsciIzd Key=acKey SQL=SELECT acKey, acKeyView, adDate, adDateVAT, acIssuer, acReceiver, acPrsn3, acDept, anForPay, anValue, anVAT, acContactPrsn, acDocType FROM vHE_Move ORDER BY acKey
ackeyView;90;;Ključ;10
adDate;60;;Datum;20
acReceiver;300;;Prejemnik;30
acPrsn3;300;;3. oseba;40
anForPay;80;#,##0.00;Za plačilo;50

ltPrometIsciPre Key=acKey SQL=SELECT acKey, acKeyView, adDate, adDateVAT, acIssuer, acReceiver, acPrsn3, acDept, anForPay, anValue, anVAT, acContactPrsn, acDocType FROM vHE_Move ORDER BY acKey
ackeyView;90;;Ključ;10
adDate;60;;Datum;20
acIssuer;300;;Izdajatelj;30
acPrsn3;300;;3. oseba;40
anForPay;80;#,##0.00;Za plačilo;50

ltPrometIsciView Key=acKeyView SQL=SELECT acKey, acKeyView, adDate, adDateVAT, acIssuer, acReceiver, acDept, anForPay, anValue, anVAT, acContactPrsn, acDocType FROM vHE_Move ORDER BY acKey
ackeyView;90;;Ključ;10
adDate;60;;Datum;20
acIssuer;300;;Izdajatelj;30
acReceiver;300;;Prejemnik;40
anForPay;80;#,##0.00;Za plačilo;50

ltPrometIsciZbirIntView Key=acKeyView SQL=SELECT acKey, acKeyView, adDate, adDateVAT, acIssuer, acReceiver, acDept, anForPay, anValue, anVAT, acContactPrsn, acDocType FROM vHE_Move where acDocType in  ( select acDocType from tPa_SetDocType where acTypeofDoc='Z' or acIsInternalMOvmnt ='T') ORDER BY acKey
ackeyView;90;;Ključ;10
adDate;60;;Datum;20
acIssuer;300;;Izdajatelj;30
acReceiver;300;;Prejemnik;40
anForPay;80;#,##0.00;Za plačilo;50

ltRegija Key=acRegion SQL=SELECT DISTINCT acRegion FROM vHE_SetPostCode ORDER BY acRegion
acRegion;80;;Regija;10

ltReport Key=acReport SQL=SELECT acReport, acFormName, acName FROM tPA_Reports ORDER BY acReport
acReport;80;;Report;10
acFormname;150;;Forma;20
acName;200;;Naziv;30

ltRMAclose Key=acKeyView SQL=select KljucPoz, acKey, acKeyView, anNo, acIdent, acName, anQty, anPrice from vHE_MoveItemRMAclose order by acKeyView, anNo
acKeyView;150;;Dokument;10
anNo;50;;Pozicija;20
acIdent;150;;Ident;30
acName;200;;Naziv;40
anQty;90;;Količina;50
anPrice;90;;Cena;60

ltRMANapaka Key=acRMAFault SQL=select acRMAFault, acName from vHE_SetRMAFault order by acRMAFault
acRMAFault;30;;Šifra;10
acName;210;;Naziv;20

ltRunSQL Key= SQL=

ltRunSQLPost Key= SQL=

ltSDKIP Key=acID SQL=select acID, acName from tHE_SetPayCodes2_3 order by acID
acID;35;;Šifra;10
acName;210;;Naziv;20

ltSDKModel Key=acCode SQL=select acCode, acName from vHE_SetPayRefTemplate order by acCode
acCode;35;;Šifra;10
acName;210;;Naziv;20

ltSDKNamen Key=acPurpose SQL=select acPurpose from tHE_SetPayPurpose order by acPurpose
acPurpose;300;;Namen;10

ltSDKOZ Key=acID SQL=select acID, acName from tHE_SetPayCodes1 order by acID
acID;35;;Šifra;10
acName;210;;Naziv;20

ltSDKSedez Key=acHQ SQL=select acHQ, acName from tHE_SetPayBankBranch order by acHQ
acHQ;60;;Sedež;10
acName;210;;Naziv;20

ltSerijskaP Key=acSerialNo SQL=SELECT acColumn, acName , acSerialNo FROM vHE_SetItemsSerialNopView
acSerialNo;120;;Serijska št.;10
acColumn;45;;Stolpec;20

ltSifDejavnost Key=acActivityCode SQL=select acActivityCode, acName from vHE_SetSubjNACE order by acActivityCode
acActivityCode;105;;Šifra;10
acName;350;;Naziv;20

ltSifraValuta Key=acCode SQL=select acCode, acCurrency, acName from vHE_SetCurrency order by acCode
acCode;30;;Šifra;10
acCurrency;30;;Valuta;20
acName;300;;Naziv;30

ltSklad Key=acSubject SQL=select acSubject from tHE_SetSubj WHERE acStockManage = 'R' ORDER BY acSubject
acSubject;350;;Skladišče;10

ltSkladLocKalk Key=acSubject SQL=select acSubject from tHE_SetSubj WHERE acStockManage = 'R' and acSeparSaleCalc = 'T' ORDER BY acSubject
acSubject;350;;Skladišče;10

ltSkladNaziv2 Key=acName2 SQL=select acSubject, acName2 from tHE_SetSubj WHERE acStockManage = 'R' ORDER BY acName2
acName2;200;;Naziv 2;10
acSubject;200;;Skladišče;20

ltSkladSklad Key=acSubject SQL=select acSubject from tHE_SetSubj WHERE acWarehouse = 'T' ORDER BY acSubject
acSubject;350;;Skladišče;10

ltSQLI Key=acKey SQL=SELECT acKey, acName FROM tPA_SQLI ORDER BY acKey
acKey;40;;Šifra;10
acName;200;;Naziv;20

ltSTRN Key=acCostDrv SQL=select acCostDrv, acName, acClassif, acStatus, acDept from vHE_CostDrvActive  ORDER BY acCostDrv
acCostDrv;160;;Str.nos.;10
acName;400;;Naziv;20
acClassif;100;;Skupina;30
acStatus;60;;Status;40

ltSTRNKlasif Key=acClassif SQL=SELECT acClassif, acName FROM vHE_CostDrvClasif ORDER BY acClassif
acClassif;100;;Skupina;10
acName;150;;Naziv;20

ltSTRNN Key=acName SQL=select acCostDrv, acName, acClassif, acStatus, acDept from vHE_CostDrvActive  ORDER BY acCostDrv
acName;400;;Naziv;10
acCostDrv;160;;Str.nos.;20
acClassif;100;;Skupina;30
acStatus;60;;Status;40

ltSTRNO Key=acCostDrv SQL=select acCostDrv, acName, acClassif, acStatus, acDept from vHE_CostDrvActive  ORDER BY acCostDrv
acCostDrv;160;;Str.nos.;10
acName;400;;Naziv;20
acClassif;100;;Skupina;30
acStatus;60;;Status;40

ltSTRNOOdd Key=acCostDrv SQL=select acCostDrv, acName, acClassif, acStatus, acDept from vHE_CostDrvActive  ORDER BY acCostDrv
acCostDrv;160;;Str.nos.;10
acName;400;;Naziv;20
acClassif;100;;Skupina;30
acStatus;60;;Status;40

ltSTRNStatus Key=acStatus SQL=SELECT acStatus, acName, acActive FROM vHE_CostDrvStatus ORDER BY acStatus
acStatus;60;;Status;10
acName;150;;Naziv;20
acActive;60;;Aktiven;30

ltSubj Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj   ORDER BY acSubject
acSubject;200;;Subjekt;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;150;;Telefon;50

ltSubjAct Key=acSubject SQL=select acSubject, acAddress, acPost, acPhone, acName2, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity, acName3 from vHE_SetSubj WHERE acActive = 'T' ORDER BY acSubject
acSubject;200;;Subjekt;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;150;;Telefon;50

ltSubjectOIB Key=acPin SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acPin, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj order by acPin
acPin;200;;OIB broj;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltSubjektBankaDom Key=anNo SQL=select anNo,(case acDefault when 'F' then ' ' else acDefault end),acBank,acBnkAcctNo1,acBnkAcctNo2,acBnkAcctNo3,acBnkAcctNo23,acNote,acBlocked  from tHE_SetSubjBank where acType = 'D' and acSubject = (select acOurCompany from tPA_SysParam) order by anNo
anNo;24;;Poz;10
acDefault;30;;Def.;20
acBank;120;;Banka;30
acBnkAcctNo1;120;;Račun;40
acBnkAcctNo2;32;;Mod;50
acBnkAcctNo3;80;;Sklic;60
acBnkAcctNo23;24;;Tip;70
acNote;120;;Opomba;80

ltSubjektBankaDomObv Key=anNo SQL=select anNo, (case acDefault when 'F' then ' ' else acDefault end), acBank, acBnkAcctNo1, acBnkAcctNo2, acBnkAcctNo3, acBnkAcctNo23, acNote, acBlocked  from tHE_SetSubjBank where acType = 'D' and acSubject = (select acOurCompany from tPA_SysParam) order by anNo
anNo;24;;Poz;10
acDefault;30;;Def.;20
acBank;120;;Banka;30
acBnkAcctNo1;120;;Račun;40
acBnkAcctNo2;32;;Mod;50
acBnkAcctNo3;80;;Sklic;60
acBnkAcctNo23;24;;Tip;70
acNote;120;;Opomba;80

ltSubjektBankaRacun Key=acBnkAcctNo1 SQL=select anNo, (case acDefault when 'F' then ' ' else acDefault end), acBank, acBnkAcctNo1, acBnkAcctNo2, acBnkAcctNo3,       acBnkAcctNo23, acNote, acBlocked from tHE_SetSubjBank where acType = 'D' and acSubject = (select acOurCompany from tPA_SysParam) order by anNo
acBnkAcctNo1;120;;Račun;10
acBnkAcctNo2;32;;Mod;20
acBnkAcctNo3;80;;Sklic;30
acBnkAcctNo23;24;;Tip;40
acBank;120;;Banka;50
anNo;24;;Poz;60
acDefault;30;;Def.;70
acNote;120;;Opomba;80

ltSubjektBankaTuj Key=anNo SQL=select anNo, (case acDefault when 'F' then ' ' else acDefault end), acBank, acBnkAcctNo1, acBnkAcctNo2, acBnkAcctNo3, acBnkAcctNo23, acNote, acBlocked  from tHE_SetSubjBank where acType = 'T' and acSubject = (select acOurCompany from tPA_SysParam) order by anNo
anNo;24;;Poz;10
acDefault;30;;Def.;20
acBank;120;;Banka;30
acBnkAcctNo1;120;;Račun;40
acBnkAcctNo2;32;;Mod;50
acBnkAcctNo3;80;;Sklic;60
acBnkAcctNo23;24;;Tip;70
acNote;120;;Opomba;80

ltSubjNaziv2 Key=acName2 SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj   ORDER BY acSubject
acName2;200;;Naziv 2;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltSubjNaziv3 Key=acName3 SQL=select acSubject, acName2, acName3, acAddress, acPost, acPhone, acCountry, acRegNo, acCode, acVATCodePrefix, acActivityCode, acCity from vHE_SetSubj   ORDER BY acSubject
acName3;200;;Naziv 3;10
acSubject;200;;Kupec;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50

ltSubjPerInv Key=acPerInv SQL=select acPerInv, acName from vHE_SetSubjPerInv order by acPerInv
acPerInv;40;;Šifra;10
acName;200;;Naziv;20

ltSubjSkis Key=acSKIS SQL=select acSKIS, acName from vHE_SetSubjCIS order by acSKIS
acSKIS;56;;SKIS;10
acName;300;;Naziv;20

ltTable Key=acTableName SQL=SELECT acTableName, acName FROM tPA_SysTables ORDER BY acTableName
acTableName;80;;Tabela;10
acName;200;;Naziv;20

ltTarSt Key=acVATCode SQL=select acVATCode, acVATNoCode, acName, anVAT from vHE_SetTax order by acVATCode
acVATCode;33;;TŠ;10
acVATNoCode;55;;Tar.št.;20
acName;300;;Naziv;30
anVAT;100;;Davek;40

ltTekstIzj Key=acStatement SQL=select acStatement, acName from vHE_SetDocTextsLook order by acStatement
acStatement;45;;Vrsta;10
acName;300;;Naziv;20

ltTekstIzjNaz Key= SQL=

ltTemeFormKnj Key=acForm SQL=SELECT acForm, acName FROM tHE_SetCustPost ORDER BY acForm
acForm;80;;Forma;10
acName;200;;Naziv;20

ltTemeStev Key=acKeyView SQL=select acKeyView, adDate, anClerk from vHE_AcctTrans order by acKeyView
acKeyView;110;;Temeljnica;10
adDate;70;;Datum;20
anClerk;60;;Referent;30

ltTipPart Key=acSubjType SQL=select acSubjType, acType, acName from vHE_SetSubjType  ORDER BY acSubjType
acSubjType;70;;Tip;10
acType;40;;Vrsta;20
acName;300;;Naziv;30

ltTipPartDob Key=acSubjType SQL=select acSubjType, acType, acName from vHE_SetSubjType WHERE acType = 'P' ORDER BY acSubjType
acSubjType;70;;Tip;10
acType;40;;Vrsta;20
acName;300;;Naziv;30

ltTipPartKup Key=acSubjType SQL=select acSubjType, acType, acName from vHE_SetSubjType WHERE acType = 'I' ORDER BY acSubjType
acSubjType;70;;Tip;10
acType;40;;Vrsta;20
acName;300;;Naziv;30

ltTouchProfile Key=acProfile SQL=select acProfile, acName from tpa_touchprofiles order by acProfile
acProfile;110;;Profil;10
acName;350;;Naziv;20

ltTRRBC Key=anNo SQL=SELECT anNo, (case acDefault when 'F' then ' ' else acDefault end) as acDefault, acBank, acBnkAcctNo1, acBnkAcctNo2, acBnkAcctNo3, acBnkAcctNo23, acNote, acActive, acBlocked FROM tHE_SetSubjBank WHERE acType = 'D' ORDER BY anNo
anNo;30;;Poz;10
acDefault;30;;Def.;20
acBank;120;;Banka;30
acBnkAcctNo1;100;;Račun;40
acBnkAcctNo2;30;;Mod.;50
acBnkAcctNo3;100;;Sklic;60

ltTRRBCN Key=acBank SQL=SELECT acBank, anNo, (case acDefault when 'F' then ' ' else acDefault end) as acDefault, acBnkAcctNo1, acBnkAcctNo2, acBnkAcctNo3, acBnkAcctNo23, acNote, acActive, acBlocked FROM tHE_SetSubjBank WHERE acType = 'D' ORDER BY anNo
acBank;120;;Banka;10
anNo;30;;Poz;20
acDefault;30;;Def.;30
acBnkAcctNo1;100;;Račun;40
acBnkAcctNo2;30;;Mod.;50
acBnkAcctNo3;100;;Sklic;60

ltTujPriOdl Key=acInFlowOutFlow SQL=select acInFlowOutFlow, acName from vHE_SetForeTrans order by acInFlowOutFlow
acInFlowOutFlow;35;;Šifra;10
acName;350;;Naziv;20

ltUpnRFCodes Key=acCode SQL=select acCode, acName, acDescription, acCategory from tDE_UPNPurpCodes WHERE acActive = 'T' and acCode<>'' ORDER BY acCode
acCode;40;;Koda;10
acName;100;;Naziv;20
acDescription;160;;Opis;30
acCategory;100;;Kategorija;40
acActive;40;;A;50

ltUprEnota Key=acAdmUnit SQL=SELECT DISTINCT acAdmUnit FROM vHE_SetPostCode ORDER BY acAdmUnit
acAdmUnit;100;;Upravna enota;10

ltUserGroup Key=anUserGroup SQL=SELECT anUserGroup, acName FROM vPA_UserGroup ORDER BY anUserGroup
anUserGroup;40;;Šifra;10
acName;200;;Naziv;20

ltUstanova Key=acSubject SQL=SELECT acSubject FROM vHE_SetSubj WHERE acInstitution <> 'F' ORDER BY acSubject
acSubject;200;;Dobavitelj;10
acName2;200;;Naziv 2;20
acAddress;200;;Naslov;30
acPost;80;;Pošta;40
acPhone;100;;Telefon;50
acCode;120;;Davčna Št.;60

ltUstanovaAct Key=acSubject SQL=SELECT acSubject, acInstitution FROM vHE_SetSubj WHERE acInstitution <> 'F' and acInstitution <> ' ' and acActive = 'T' ORDER BY acSubject
acSubject;200;;Izvajalec;10

ltValuta Key=acCurrency SQL=select acCurrency, acName from vHE_SetCurrency order by acCurrency
acCurrency;30;;Valuta;10
acName;300;;Naziv;20

ltValutaSifra Key= SQL=

ltVPD Key=acKey SQL=SELECT acLnkKey, acKey, acLnkKeyView, acKeyView FROM vHE_MoveRetVAT ORDER BY acKey
acKeyView;100;;DDV-VP;10
acLnkKeyView;100;;Račun;20

ltVrstaBlgPI Key=acCashReceipt SQL=select acCashReceipt,acAcct,acDept,acCostDrv,acSetOf from vHE_SetCashReceipt
acCashReceipt;200;;Vrsta;10
acAcct;90;;Konto;20
acDept;200;;Oddelek;30
acCostDrv;160;;Stroškovni nosilec;40

ltVrstaMS Key=acSetOfItem SQL=select acSetOfItem, acName, acType from vHE_SetItemType order by acSetOfItem
acSetOfItem;40;;VID;10
acName;300;;Naziv;20
acType;30;;Tip;30

ltZaposlen Key=anUserId SQL=select anUserId, acWorker from vPA_SysUsersSelect order by anUserId
acWorker;250;;Uporabnik;10

ltZaposlenID Key=anUserId SQL=select anUserId, acUserID, acWorker from vPA_SysUsersSelect order by acUserId
acUserID;30;;ID;10
acWorker;250;;Uporabnik;20

ltZCVrstaPosla Key=acIDBCTypeBussines SQL=select acIDBCTypeBussines, acNote from vHE_BCTypeBussines order by acIDBCTypeBussines
acIDBCTypeBussines;80;;Šifra;10
acNote;150;;Vrsta posla;20