Tofu - Baza

Create Declare Cursor Hungarian
Select Update Insert Fancy
Tabela		Suffix
Select	All, None, Invert


Naziv	Tip	Null	Privzeto	Opis
acDocType	char(4)	0	('')
acSetOf	char(1)	1	('X')
acType	char(1)	1	('X')
acIsDoc	char(1)	1	('F')
acIsInternalMovmnt	char(1)	1	('F')
acName	varchar(40)	1	('')
acShortDocName	char(13)	1	('')
acAcctDB	char(8)	1	('')
acAcctCR	char(8)	1	('')
acIssuerName	varchar(100)	1	('')
acReceiverName	varchar(100)	1	('')
acName3	varchar(100)	1	('')
acLinkDocName1	char(20)	1	('')
acLinkDocName2	char(20)	1	('')
acIssuer	char(30)	1	('')
acReceiver	char(30)	1	('')
acPrsn3	char(30)	1	('')
acFillPrice	char(1)	1	('2')
acFillPurPrice	char(1)	1	('F')
acFillRecvCalc	char(1)	1	('T')
acDocTypeCashRegPreePay	char(4)	1	('')
acDocTypeCashRegPay	char(4)	1	('')
acDocTypeRef	char(4)	1	('')
acProdDisAssDocTypeIn	char(4)	1	('')
acProdDisAssDocTypeOut	char(4)	1	('')
acTypeOfDoc	char(1)	1	('M')
acIsSupplRMA	char(1)	1	('F')
acIsBuyerRMA	char(1)	1	('F')
acPayOrdMagSeqNo	char(3)	1	('')
acSADSetOfDocType	char(2)	1	('')
acTrvlDailyAllAcctDB	char(8)	1	('')
acTrvlKMAcctDB	char(8)	1	('')
acSpecRecord56A	char(1)	1	('F')
acFillSalePrice	char(1)	1	('F')
acIsIssueAllowdOpenBills	char(1)	1	('P')
acPhaseA	char(1)	1	('T')
acPhaseC	char(1)	1	('T')
acPhaseD	char(1)	1	('T')
acPhaseF	char(1)	1	('T')
acPhaseG	char(1)	1	('T')
acPhaseH	char(1)	1	('T')
acPhaseK	char(1)	1	('T')
acPhaseR	char(1)	1	('T')
acIsValueBasedPost	char(1)	1	('F')
acTrvlCostsAcctDB	char(8)	1	('')
acSlryCapContrPayWrk	char(20)	1	('PR. IZ OD:')
acEvidence	char(1)	1	('F')
acName2	varchar(60)	1	('')
acSlryCapBnkPayPurpose	char(20)	1	('PLAÄŒA:')
acSlryCapLoanPayPurpose1	char(20)	1	('KREDIT:')
acSlryCapLoanPayPurpose2	char(20)	1	('')
acSlryCapContrPayComp	char(20)	1	('PR: NA OD:')
acDocTypeAssmbly	varchar(255)	1	('')
acPayOrdDocType	char(4)	1	('')
acPayOrdPriorty	char(2)	1	('9')
acPayOrdBankBranch	char(30)	1	('')
acPayOrdPlaceDate	varchar(40)	1	('')
acPayOrdDebitor1	char(20)	1	('')
acPayOrdDebitor2	varchar(36)	1	('')
acPayOrdDebitor3	varchar(36)	1	('')
acPayOrdFillDate	char(1)	1	('F')
acPayOrdBankAcctDebitor1	char(21)	1	('')
acPayOrdBankAcctDebitor2	char(2)	1	('')
acPayOrdBankAcctDebitor3	varchar(35)	1	('')
acPayOrdBankAcctDebitor3Ref	char(1)	1	('N')
acPayOrdPurpose2	varchar(36)	1	('')
acPayOrdPurpose3	varchar(36)	1	('')
acPayOrdPurpose2Ref	char(1)	1	('N')
acPayOrdBankAcctCreditor2	char(2)	1	('')
acPayOrdBankAcctCreditor3	varchar(35)	1	('')
acBankAcctCreditor3Ref	char(1)	1	('N')
acPayOrdCode1	char(2)	1	('')
acPayOrdCode2	char(2)	1	('')
acPayOrdCode3	char(2)	1	('')
acDocTypeWaste	char(4)	1	('')
acDept	char(30)	1	('')
acPostTransDeptCostDrv	char(1)	1	('F')
acPostTransSalePrice	char(1)	1	('F')
acIsObligDoc1	char(1)	1	('F')
acIsObligDoc2	char(1)	1	('F')
acIsObligDept	char(1)	1	('F')
acIsObligReceiver	char(1)	1	('F')
acIsObligIssuer	char(1)	1	('F')
anProdCalcQtyType	tinyint	1	(0)
anProdWOFinishAuto	tinyint	1	(0)
acMoveFA	char(1)	1	('F')
acSideOfBooking	char(1)	1	('')
acMinStockWarning	char(1)	1	('F')
acShowOnlyActiveID	char(1)	1	('F')
acIsClerkChangble	char(1)	1	('F')
acPayOrdDocTypeFgn	char(4)	1	('')
acPayMethod	char(3)	1	('')
acAutoInvoSerialNo	char(1)	1	('F')
adSADDateSimpleProc	smalldatetime	1
acSADNoSimpleProc	char(15)	1	('')
acProdOperPostType	char(1)	1	('R')
acLinkDocFillType	char(1)	1	('N')
acIsAutoConfrm	char(1)	1	('F')
acDocTypeCashReg	char(4)	1	('')
acSetFocusOnNew	char(1)	1	('1')
acIsCooperation	char(1)	1	('F')
acIsObligCostDrv	char(1)	1	('F')
acProdBuyOrd2WOType	char(1)	1	('T')
anPayOrdStrucType	smallint	1	(1)
adTimeIns	datetime	1
anUserIns	smallint	1
adTimeChg	datetime	1
anUserChg	smallint	1
acAccountBuyer	char(20)	1	('')
acSetOffAccountBuyer	char(8)	1	('')
acAccountSupplier	char(20)	1	('')
acSetOffAccountSupplier	char(8)	1	('')
acSetOffDocType	char(4)	1	('')
acRateReal	char(16)	1	('')
acRateReval	char(16)	1	('')
acPayRemindCost	char(16)	1	('')
acDocTypeRate	char(4)	1	('')
adDateFrom	smalldatetime	1
ac1Doc1Item	char(1)	1	('F')
acIntrRateType	char(2)	1	('')
anMinRateValue	money	1	(0)
anMinDaysOver	int	1	(0)
anNominalRate	money	1	(0)
acCalcTypeRate	char(1)	1	('D')
acDocStatus	char(1)	1	('1')
anDaysForPayment	smallint	1	(0)
adDateAcc	smalldatetime	1
acPayerType	char(2)	1	('01')
acSlryIndividWrk	char(1)	1	('N')
acEnterSNS	char(1)	1	('F')
acEnterSNK	char(1)	1	('F')
acEnterSNP	char(1)	1	('F')
acEnterSNE	char(1)	1	('F')
acEnterSNO	char(1)	1	('F')
acIdent	char(16)	1	('')
acIsExpAcct	char(1)	1	('F')
anProdPlanSchdCheck	tinyint	1	(1)
acProdWOType	char(1)	1	('X')
acAllowDocNameChange	char(1)	1	('T')
acWarehouse	char(30)	1	('')
acVATPayReal	char(1)	1	('F')
anLinkDocFillType	int	1	(0)
acCompensation	varchar(30)	1	('')
acCaution	varchar(30)	1	('')
acRest	varchar(30)	1	('')
acClaim	varchar(255)	1	('')
acLiability	varchar(255)	1	('')
anSubjBank	smallint	1	(0)
acDefNote	varchar(2000)	1	('')
acNote	varchar(2000)	1	('')
acDutyProcDeliver	char(2)	1	('')
acDutyProcRequired	char(2)	1	('')
acSADOrgUnit1	char(3)	1	('')
acSADOrgUnit2	char(3)	1	('')
acCostDrv	char(16)	1	('')
anFillConsWO2Move	tinyint	1	(1)
acCashRegRetAcctCR	char(8)	1	('')
acAcctCROfCurr	char(8)	1	('')
anMinRateValueSubj	money	1	((-1))
acRSmId2	char(1)	1	('0')
acFillProdPrice	char(1)	1	('F')
acGenerateRefNo	char(1)	1	('F')
acWorkerTrvl	char(30)	1	('')
acPhaseM	char(1)	1	('F')
acAgreedCompBasis	char(2)	1	('')
acControlPrevCalc	char(1)	1	('T')

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me