Tofu - Baza

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


Naziv	Tip	Null	Privzeto	Opis
acClassif	char(16)	0	('')
acName	varchar(40)	1	('')
acVATCode	char(2)	1	('')
acVATCodeLow	char(2)	1	('')
acSerialNo	char(1)	1	('N')
anWarrenty	smallint	0	(0)
acWayBillDescr	char(10)	1	('')
acSetOfItem	char(3)	1	('')
acCurrency	char(3)	1	('EUR')
acUM	char(3)	1	('')
anUMToUM2	float	1	(1)
acUM2	char(3)	1	('')
anMINStock	decimal(19,6)	0	(0)
anDiscount	decimal(8,4)	0	(0)
acFormula	char(3)	1	('')
acCustTariff	char(12)	1	('')
anPOSQty	decimal(19,6)	0	(1)
anRebate	decimal(8,4)	0	(0)
anTransport	decimal(6,3)	0	(0)
anDuty	decimal(6,3)	0	(0)
anDirectCost	decimal(6,3)	0	(0)
anIncTax	decimal(6,3)	0	(0)
anRTPriceP	decimal(6,3)	0	(0)
anWSPriceP	decimal(6,3)	0	(0)
anWSPrice2P	decimal(6,3)	0	(0)
anPrStPriceP	decimal(6,3)	0	(0)
acMakeCalc	char(1)	1	('C')
acPriceCalcMethod	char(1)	1	('M')
acRRebate	char(1)	1	('T')
acRTransport	char(1)	1	('T')
acRDuty	char(1)	1	('T')
acRNEPSTR	char(1)	1	('T')
acRVRDAVEK	char(1)	1	('T')
acRRTPriceP	char(1)	1	('T')
acRWSPriceP	char(1)	1	('T')
acRWSPrice2P	char(1)	1	('T')
acRPrStPriceP	char(1)	1	('T')
acClassFillMethod	char(1)	1	('T')
acPurchCurr	char(3)	1	('EUR')
acAcct	char(8)	1	('')
anMAXStock	decimal(19,6)	0	(0)
anOptStock	decimal(19,6)	0	(0)
acFieldSA	varchar(255)	1	('')
acFieldSB	varchar(255)	1	('')
acFieldSC	varchar(255)	1	('')
acFieldSD	varchar(255)	1	('')
acFieldSE	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)
acShowAtena	char(1)	1	('F')
acShowAtenaDesc	char(1)	1	('F')
acATDescPOS	char(1)	1	('B')
acATOrder	char(1)	1	('')
acAcctIncome	char(8)	1	('')
acFieldSF	varchar(255)	1	('')
acFieldSG	varchar(255)	1	('')
anFieldNF	decimal(19,6)	0	(0)
anFieldNG	decimal(19,6)	0	(0)
acFieldSH	varchar(255)	1	('')
acFieldSI	varchar(255)	1	('')
acFieldSJ	varchar(255)	1	('')
anFieldNH	decimal(19,6)	0	(0)
anFieldNI	decimal(19,6)	0	(0)
anFieldNJ	decimal(19,6)	0	(0)
anDeliveryDeadline	smallint	0	(0)
acColumn	char(3)	1	('')
adTimeIns	datetime	1
adTimeChg	datetime	1
anUserIns	smallint	1
anUserChg	smallint	1
acType	char(1)	1	('O')
anPrStMatVariantSubLvl	tinyint	1	(253)
anPrStMatQty1	float	1	(0)
anPrStMatBatch	float	1	(1)
anPrStMatQtyBase	smallint	1	(0)
acPrStMatQtyFormula	char(3)	1	('')
acPrStMatUM	char(3)	1	('')
acPrStMatScrapIdent	char(16)	1	('')
anPrStMatScrapQty	float	1	(0)
anPrStMatScrapPrc	float	1	(0)
anPrStMatWasteQty	float	1	(0)
anPrStMatWastePrc	float	1	(0)
anPrStOprQty1	float	1	(0)
anPrStOprQty2	float	1	(0)
anPrStOprBatch	float	1	(1)
anPrStOprQtyBase	smallint	1	(0)
acPrStOprQtyFormula	char(3)	1	('')
acPrStOprUM	char(3)	1	('')
acPrStOprUMTime	char(3)	1	('')
anPrStOprQty3	float	1	(0)
anPrStOprQtyBase3	smallint	1	(0)
acPrStOprUM3	char(3)	1	('')
acPrStOprResursID	char(16)	1	('')
acPrStOprRuleID	char(16)	1	('')
acPrStOprIncomeGrp	char(6)	1	('')
acPrStOprETAdditive	char(3)	1	('')
anPrStOprNoOfWrk	smallint	1	(0)
acPrStOprOperationType	char(1)	1	('')
acPrStOprDelayType	char(1)	1	('')
anPrStOprOptimalQty	float	1	(0)
acPrStC1	char(30)	1	('')
acPrStC2	char(30)	1	('')
acPrStC3	char(30)	1	('')
acPrStC4	char(30)	1	('')
anPrStC5	float	1	(0)
anPrStC6	float	1	(0)
anPrStC7	float	1	(0)
acPrStC8	varchar(2000)	1	('')
acPicture	image	1
acDescr	text	1	('')
anBeatShare	float	0	(0)
anPurExciseE	float	0	(0)
anPurExciseA	float	0	(0)
anPurExciseT	float	0	(0)

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me