| tPA_SysParam |
| |
Naziv |
Tip |
Null |
Privzeto |
Opis |
| adGLDateOpen | smalldatetime | 1 | | |
| acGLAcctBuy | varchar(255) | 1 | ('1200') | |
| acGLAcctSup | varchar(255) | 1 | ('2200') | |
| acBankPrimaryPrefix | char(1) | 1 | ('M') | |
| acBankPrimarySufix | char(30) | 1 | ('') | |
| anRoundT | decimal(9,4) | 0 | (1) | |
| acPrimCurrency | char(3) | 1 | ('EUR') | |
| acCountry | char(20) | 1 | ('') | |
| acVATCodeWithoutTaxInc | char(2) | 0 | ('') | |
| acVATCodeWithoutTaxOut | char(2) | 1 | ('') | |
| anDefDaysForOrderValid | smallint | 0 | (0) | |
| adTimeChg | datetime | 1 | | |
| anUserChg | smallint | 1 | | |
| acOurCompany | char(30) | 1 | ('') | |
| anDirectCost | money | 0 | (0) | |
| acBankPricePrefix | char(1) | 1 | ('M') | |
| acBankPriceSufix | char(30) | 1 | ('') | |
| acMakeCalc | char(1) | 1 | ('C') | |
| acRewOfCalcSalePrice | char(1) | 1 | ('F') | |
| acOrderPricePrStCalc | char(1) | 1 | ('F') | |
| acCalcPriceItemPrSt | char(1) | 1 | ('F') | |
| anPerVATForDeviaInPrice | decimal(6,2) | 0 | (0) | |
| acModel | char(5) | 1 | ('') | |
| acConsig | char(5) | 1 | ('') | |
| anRoundPOSItem | decimal(9,4) | 0 | (0.01) | |
| acPrice0 | varchar(16) | 1 | ('Maloprod.cena') | |
| acPrice1 | varchar(16) | 1 | ('Prodajna cena') | |
| acPrice2 | varchar(16) | 1 | ('Veleprod. cena 1') | |
| acPrice3 | varchar(16) | 1 | ('Veleprod. cena 2') | |
| acPrice4 | varchar(16) | 1 | ('Sestavnica') | |
| acFormulaProdSt | varchar(255) | 1 | ('[#CenRazred#=1:#Sestavnica# * #MpCena# / #VpCena2#] [#CenRazred#=2:#Sestavnica# * #VpCena1# / #VpCena2#] #Sestavnica#') | |
| acFormulaPriceRate | varchar(255) | 1 | ('[#CenRazred#=1:#MpCena#] [#CenRazred#=2:#VpCena1#] #VpCena2#') | |
| acFormulaBuyPrice | varchar(255) | 1 | ('#NabaCena#') | |
| acIsClerkChangble | char(1) | 1 | ('') | |
| acStockForMadeItems | char(30) | 1 | ('') | |
| acSPCalcBase | char(1) | 1 | ('P') | |
| adAuthorDateIn | smalldatetime | 1 | | |
| acAutoDateCtrlOnEntry | char(1) | 1 | ('F') | |
| acFillRefFromSubj | char(1) | 1 | ('F') | |
| acWayOfCalcDist | char(1) | 1 | ('S') | |
| acWODocType | char(4) | 1 | ('') | |
| acSetOfItem | char(3) | 1 | ('') | |
| acBankDutyPrefix | char(1) | 1 | ('M') | |
| acBankDutySufix | char(30) | 1 | ('') | |
| acFieldSA | varchar(20) | 1 | ('') | |
| acFieldSB | varchar(20) | 1 | ('') | |
| acFieldSC | varchar(20) | 1 | ('') | |
| acFieldNA | varchar(20) | 1 | ('') | |
| acFieldNB | varchar(20) | 1 | ('') | |
| acPOPayPurpose1 | varchar(30) | 1 | ('') | |
| acPOPayPurpose2 | varchar(40) | 1 | ('') | |
| acPOPayPurpose3 | varchar(40) | 1 | ('') | |
| acPOCreditr1 | varchar(30) | 1 | ('') | |
| acPOCreditr2 | varchar(40) | 1 | ('') | |
| acPOCode1 | char(2) | 1 | ('') | |
| acPOCode2 | char(2) | 1 | ('') | |
| acPOCode3 | char(2) | 1 | ('') | |
| acPOBankAcctCreditr1 | varchar(22) | 1 | ('') | |
| acPOBankAcctCreditr2 | char(2) | 1 | ('') | |
| acPOBankAcctCreditr3 | varchar(25) | 1 | ('') | |
| acPOWrtPayrPost | char(1) | 1 | ('F') | |
| acPOFillIntDocToRef | char(1) | 1 | ('F') | |
| acSeparSaleCalc | char(1) | 1 | ('F') | |
| anDecPlacesValue | smallint | 1 | (2) | |
| anQtyInCodeLen | smallint | 0 | (0) | |
| acQtyInCodeCont | char(1) | 1 | ('N') | |
| acPrnSubjAdressOrder | varchar(255) | 1 | ('KontOs;Naziv;Naziv2;Naslov;;Posta') | |
| acItemCalcPrStPrice | char(3) | 1 | ('0') | |
| acSetsItemSrchSubjCode | char(1) | 1 | ('N') | |
| acDutySerialNo | char(1) | 1 | ('S') | |
| anDecPlacesPrice | smallint | 0 | (2) | |
| anDecPlacesQty | smallint | 0 | (2) | |
| acItemContFaktor | char(1) | 1 | ('N') | |
| acWayOfCalcDistSum | char(1) | 1 | ('T') | |
| acItemMethCalcUM2Qntty | char(1) | 1 | ('2') | |
| acItemUM2QnttyRound | char(1) | 1 | ('F') | |
| acGLAutoWrtInvoInConf | char(1) | 1 | ('T') | |
| acGLAutoWrtInvoOutConf | char(1) | 1 | ('F') | |
| acSetsItemPrnSubjCode | char(1) | 1 | ('P') | |
| acGLAcctAdv | char(8) | 1 | ('') | |
| anRoundFA | decimal(9,4) | 0 | (1) | |
| anRoundValue | decimal(9,4) | 0 | (1) | |
| anRoundQntty | decimal(9,4) | 0 | (1) | |
| anRoundPrice | decimal(9,4) | 0 | (0) | |
| anMinLenOfPassword | smallint | 0 | (0) | |
| acFieldSD | varchar(20) | 1 | ('') | |
| acFieldSE | varchar(20) | 1 | ('') | |
| acFieldNC | varchar(20) | 1 | ('') | |
| acFieldND | varchar(20) | 1 | ('') | |
| acFieldNE | varchar(20) | 1 | ('') | |
| anGenerItemNoLen | smallint | 0 | (0) | |
| acGenerItemNoConst | varchar(16) | 1 | ('') | |
| acGenerItemNoField | varchar(30) | 1 | ('') | |
| anGenerItemNoFieldLen | smallint | 0 | (0) | |
| anGenerSubjNoLen | smallint | 0 | (0) | |
| acGenerSubjNoConst | varchar(30) | 1 | ('') | |
| acGenerSubjNoField | varchar(30) | 1 | ('') | |
| anGenerSubjNoFieldLen | smallint | 0 | (0) | |
| acCalcInvoInFallDue | char(1) | 1 | ('R') | |
| acCalcInvoOutFallDue | char(1) | 1 | ('R') | |
| acAutoPostDateDocInvoOut | char(1) | 1 | ('R') | |
| acAutoPostDateDocInvoIn | char(1) | 1 | ('R') | |
| anLastSetOff | smallint | 0 | (0) | |
| acChaPrStIdent | char(1) | 1 | ('F') | |
| acDutyCalcMeth | char(1) | 1 | ('P') | |
| anRoundDim | decimal(9,4) | 0 | (1) | |
| acItemEANField | varchar(30) | 1 | ('') | |
| acItemEANConst | varchar(13) | 1 | ('') | |
| acItemEANCheck | char(1) | 1 | ('F') | |
| acItemEANType | smallint | 0 | (0) | |
| acItemCodeEANConst | varchar(13) | 1 | ('') | |
| acItemCodeEANField | varchar(30) | 1 | ('') | |
| acItemCodeEANCheck | char(1) | 1 | ('F') | |
| acItemCodeEANType | smallint | 0 | (0) | |
| acOrderPrStIsRound | char(1) | 1 | ('T') | |
| acCalcInvoInFXRate | char(1) | 1 | ('D') | |
| acOrderFillMethClerk | char(1) | 1 | ('F') | |
| acLinkDoc1FillCtrl | char(1) | 1 | ('F') | |
| acLinkDoc2FilCtrl | char(1) | 1 | ('F') | |
| adMoveOpenDate | smalldatetime | 1 | | |
| adGLDateClose | smalldatetime | 1 | | |
| acComment | char(1) | 1 | ('') | |
| acOrderContStock | char(1) | 1 | ('F') | |
| acWOOwnPriceType | char(1) | 1 | ('S') | |
| anAcctMinProfMargin | decimal(6,3) | 0 | ((-1)) | |
| acProdToSlryDBName | varchar(30) | 1 | ('') | |
| acGLDocTypeClose | char(4) | 1 | ('') | |
| acGLDocTypeOpen | char(4) | 1 | ('') | |
| anMaxMinKey | smallint | 0 | ((-1)) | |
| acAcctOpenState | char(1) | 1 | ('D') | |
| acMovePOSApprClose | char(1) | 1 | ('F') | |
| acRMASrchBuyerOnSN | char(1) | 1 | ('F') | |
| acFieldSF | varchar(20) | 1 | ('') | |
| acFieldSG | varchar(20) | 1 | ('') | |
| acFieldNF | varchar(20) | 1 | ('') | |
| acFieldNG | varchar(20) | 1 | ('') | |
| acIdentAnySelectSrch | varchar(255) | 1 | ('SELECT Ident, Koda, EM, Aktivno, Klasif, Naziv, VrstaMS FROM MS ORDER BY Ident') | |
| acIdentLookUpSelectIdent | varchar(255) | 1 | ('SELECT Ident, Aktivno, Naziv, MPCena, VPCena, VPCena2, Sestavnica FROM MS ORDER BY Ident') | |
| acIdentLookUpSelectName | varchar(255) | 1 | ('SELECT Ident, Aktivno, Naziv, MPCena, VPCena, VPCena2, Sestavnica FROM MS ORDER BY Naziv') | |
| acFieldSALookUp | varchar(255) | 1 | ('') | |
| acFieldSBLookUp | varchar(255) | 1 | ('') | |
| acFieldSCLookUp | varchar(255) | 1 | ('') | |
| acFieldSDLookUp | varchar(255) | 1 | ('') | |
| acFieldSELookUp | varchar(255) | 1 | ('') | |
| acFieldSFLookUp | varchar(255) | 1 | ('') | |
| acFieldSGLookUp | varchar(255) | 1 | ('') | |
| acGLRecOfDebtSetOfWork | char(3) | 1 | ('') | |
| acGLRecOfDebtSetOfWorkCall | char(3) | 1 | ('') | |
| acGLRecOfDebtSetOfDoc | char(3) | 1 | ('') | |
| anFieldPNA | decimal(19,6) | 0 | (0) | |
| anContBuyUnsettled | smallint | 0 | (0) | |
| anFieldPNB | decimal(19,6) | 0 | (0) | |
| acFieldNH | varchar(20) | 1 | ('') | |
| acFieldNI | varchar(20) | 1 | ('') | |
| acFieldNJ | varchar(20) | 1 | ('') | |
| acFieldSI | varchar(20) | 1 | ('') | |
| acFieldSH | varchar(20) | 1 | ('') | |
| acFieldSJ | varchar(20) | 1 | ('') | |
| acFieldSHLookUp | varchar(255) | 1 | ('') | |
| acFieldSILookUp | varchar(255) | 1 | ('') | |
| acFieldSJLookUp | varchar(255) | 1 | ('') | |
| anMaxNoOfInstall | smallint | 0 | ((-1)) | |
| anInstallDefDelay | smallint | 0 | (0) | |
| anInstallDefType | smallint | 0 | (0) | |
| acOrderStatusToDispDoc | varchar(50) | 1 | ('') | |
| acOrderToDispDocDefStatus | char(2) | 1 | ('') | |
| acGLTrvlOrdPostSett | char(1) | 1 | ('F') | |
| acVATCodeDefault | char(2) | 1 | ('') | |
| acInputWithoutSPCtrl | char(1) | 1 | ('N') | |
| adInputWithoutSPCtrlDate | smalldatetime | 1 | | |
| acAutoPostSellDeptCostDrv | char(1) | 1 | ('0') | |
| acAutoPostRecvDeptCostDrv | char(1) | 1 | ('0') | |
| acSetsItemChRTPrice | char(1) | 1 | ('T') | |
| acWOFromBuyOrdType | char(1) | 1 | ('1') | |
| acMovePOSPricePOCR | char(1) | 1 | ('F') | |
| acCalcInvoOutFXRate | char(1) | 1 | ('I') | |
| anRoundPOS | decimal(9,4) | 0 | (1) | |
| acPrnPostCodesCountryDelim | char(1) | 1 | ('-') | |
| acPrnPostCodesSeqNoDelim | char(1) | 1 | ('') | |
| acPrnPostCodeType | char(1) | 1 | ('V') | |
| acGLCloseOnDeptCostDrv | char(1) | 1 | ('F') | |
| acGLAutoWrtConfInvoCons | char(1) | 1 | ('F') | |
| acOrderReserv | char(1) | 0 | ('F') | |
| acFillSalesCond | char(1) | 1 | ('1') | |
| acAutoKnjFADeptCostDr | char(1) | 1 | ('0') | |
| anDocKeyLenYear | tinyint | 1 | (2) | |
| anDocKeyLenDocType | tinyint | 1 | (3) | |
| anDocKeyLenNumber | tinyint | 1 | (6) | |
| acFirstRun | char(1) | 1 | ('F') | |
| anGenerPMNoLen | smallint | 1 | ('') | |
| acGenerPMNoConst | varchar(13) | 1 | | |
| acGenerPMNoField | varchar(13) | 1 | | |
| anGenerPMNoFieldLen | smallint | 1 | ('') | |
| acRefNoType | char(1) | 1 | ('I') | |
| acRefNoFormat | char(15) | 1 | ('111110001111111') | |
| anUserIns | smallint | 1 | | |
| adTimeIns | datetime | 1 | | |
| acCompanyImage | image | 1 | | |
| acIdentLookUpName | text | 1 | | |
| acIdentLookUpIdent | text | 1 | | |
| acIdentAnySrch | text | 1 | | |
| acCompanyPrtTextB | text | 1 | | |
| acCompanyPrtTextA | text | 1 | | |