Tofu - Baza

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


Naziv	Tip	Null	Privzeto	Opis
acSubject	char(30)	0	('')
acBuyer	char(1)	1	('T')
acSupplier	char(1)	1	('T')
acBank	char(1)	1	('F')
acMunicipality	char(1)	1	('F')
acLocComm	char(1)	1	('F')
acWarehouse	char(1)	1	('F')
acWorker	char(1)	1	('F')
acUser	char(1)	1	('F')
acDept	char(1)	1	('F')
acSchool	char(1)	1	('F')
acInstitution	char(1)	1	('F')
acAddress	varchar(60)	1	('')
acName2	varchar(255)	1	('')
acName3	varchar(255)	1	('')
acPost	char(13)	1	('')
acCountry	char(20)	1	('')
anKm	smallint	0	(0)
acVATCodePrefix	char(3)	1	('')
acCode	char(20)	1	('')
acRegion	char(1)	1	('F')
acSuprCommune	char(30)	1	('')
acPhone	char(20)	1	('')
acFax	char(20)	1	('')
acSubUnit	char(1)	1	('F')
acPriceRate	char(1)	1	('1')
anDaysForPayment	smallint	0	(0)
acYearStatement	char(10)	1	('')
adDateState	smalldatetime	1
acStatement	char(2)	1	('')
anLimit	money	0	(0)
adDateLimit	smalldatetime	1
acSubjTypeSupp	char(16)	1	('')
acSubjTypeBuyer	char(16)	1	('')
acStockManage	char(1)	1	('0')
acStockValue	char(1)	1	('0')
acStockInMinus	char(1)	1	('F')
adDateInvent	smalldatetime	1
anClerk	smallint	1	(0)
anRebate	decimal(8,4)	0	(0)
acWayOfSale	char(1)	1	('Z')
acCurrency	char(3)	1	('EUR')
acPriceCalcMethod	char(1)	1	('0')
acPayMethod	char(3)	1	('')
acDelivery	char(2)	1	('')
acRegNo	char(13)	1	('')
acPayer	char(30)	1	('')
acActivityCode	char(15)	1	('')
acSeparSaleCalc	char(1)	1	('F')
acSuppPriceCalcMet	char(1)	1	('0')
anSuppDiscount	decimal(19,6)	0	(0)
acSuppSaleMet	char(1)	1	('D')
acSuppYearStatement	char(10)	1	('')
adSuppDateSta	smalldatetime	1
anSuppPayDays	smallint	0	(0)
acSuppPayMet	char(3)	1	('')
acSuppStatement	char(2)	1	('')
anSuppLimit	money	0	(0)
adSuppDateLim	smalldatetime	1
acSuppDelivery	char(2)	1	('')
acSuppCurr	char(3)	1	('EUR')
anSuppClerk	smallint	1	(0)
acPayOrdPriorty	char(2)	1	('9')
acSWIFTCode	char(12)	1	('')
acATWarehouse	char(1)	1	('F')
acMunicipCode	char(4)	1	('')
acDispDoc	char(1)	1	('F')
acSetOfInterestRates	char(2)	1	('')
acStockRetailValue	char(1)	1	('0')
acParity	char(3)	1	('')
acParityPost	char(13)	1	('')
acSuppParity	char(3)	1	('')
acSuppParityPost	char(13)	1	('')
acFieldSA	varchar(255)	1	('')
acFieldSB	varchar(255)	1	('')
acFieldSC	varchar(255)	1	('')
acFieldSD	varchar(255)	1	('')
acFieldSE	varchar(255)	1	('')
acFieldSF	varchar(255)	1	('')
acFieldSG	varchar(255)	1	('')
acFieldSH	varchar(255)	1	('')
acFieldSI	varchar(255)	1	('')
acFieldSJ	varchar(255)	1	('')
anFieldNA	decimal(19,6)	0	(0)
anFieldNB	decimal(19,6)	0	(0)
anFieldNC	decimal(19,6)	0	(0)
anFieldND	decimal(19,6)	0	(0)
anFieldNE	decimal(19,6)	0	(0)
anFieldNF	decimal(19,6)	0	(0)
anFieldNG	decimal(19,6)	0	(0)
anFieldNH	decimal(19,6)	0	(0)
anFieldNI	decimal(19,6)	0	(0)
anFieldNJ	decimal(19,6)	0	(0)
adFieldDA	datetime	1
adFieldDB	datetime	1
adFieldDC	datetime	1
adFieldDD	datetime	1
acSKIS	char(7)	1	('')
acXMLDocType	char(1)	1	('P')
acXMLDocCript	char(1)	1	('F')
acXMLDocSign	char(1)	1	('F')
acCreatePayOrd	char(1)	1	('T')
acXMLGLNNo	varchar(35)	1	('')
acIntrstsBuyer	char(1)	1	('T')
acIntrstsSupplier	char(1)	1	('T')
acRSBAInDistrikt	char(1)	1	('K')
acHTTPPath	varchar(255)	1	('')
acIBANprefix	char(2)	1	('')
acSuprDept	char(30)	1	('')
anSubjVar1	decimal(19,6)	1	(0)
anSubjVar2	decimal(19,6)	1	(0)
anSubjVar3	decimal(19,6)	1	(0)
anSubjVar4	decimal(19,6)	1	(0)
anSubjVar5	decimal(19,6)	1	(0)
anSubjVar6	decimal(19,6)	1	(0)
anSubjVar7	decimal(19,6)	1	(0)
anSubjVar8	decimal(19,6)	1	(0)
anSubjVar9	decimal(19,6)	1	(0)
anSubjVar10	decimal(19,6)	1	(0)
adTimeIns	datetime	1
anUserIns	smallint	1
adTimeChg	datetime	1
anUserChg	smallint	1
acNote	text	1

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me