Tofu - Baza

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


Naziv	Tip	Null	Privzeto	Opis
acIdent	char(16)	0	('')
acName	varchar(80)	1	('')
acClassif	char(16)	1	('')
anSubClassif	float	0	(0)
acClassif2	char(16)	1	('')
acCode	char(13)	1	('')
acSetOfItem	char(3)	1	('')
acSupplier	char(30)	1	('')
acFormula	char(3)	1	('')
anVAT	decimal(6,2)	0	(0)
acCurrency	char(3)	1	('EUR')
anSalePrice	money	0	(0)
anRTPrice	float	0	(0)
anWSPrice	float	0	(0)
anWSPrice2	float	0	(0)
anPrStPrice	float	0	(0)
anBuyPrice	float	0	(0)
anProdPrice	float	1	(0)
acUM	char(3)	1	('')
anUMToUM2	decimal(19,6)	0	(1)
acUM2	char(3)	1	('')
acVATCode	char(2)	1	('')
acVATCodeLow	char(2)	1	('')
anDiscount	decimal(8,4)	0	(0)
anWarrenty	smallint	0	(0)
acSerialNo	char(1)	1	('N')
acActive	char(1)	1	('T')
acHTTPPath	varchar(255)	1	('')
acMakeCalc	char(1)	1	('C')
anPrice	float	0	(0)
anRebate	float	0	(0)
anTransport	float	0	(0)
anDuty	float	0	(0)
anDirectCost	float	0	(0)
anIncTax	float	0	(0)
anWSPrice2P	float	0	(0)
anWSPriceP	float	0	(0)
anRTPriceP	float	0	(0)
anMinStock	decimal(19,6)	0	(0)
acStandardize	char(1)	1	('F')
acDocTypeProd	char(4)	1	('')
acDocTypeOrdSupp	char(4)	1	('')
anDimHeight	decimal(19,6)	0	(0)
anDimWidth	decimal(19,6)	0	(0)
anDimDepth	decimal(19,6)	0	(0)
anDimWeight	decimal(19,6)	0	(0)
anDimWeightBrutto	decimal(19,6)	0	(0)
acCustTariff	char(12)	1	('')
anPriceSupp	float	0	(0)
anPrStPriceP	float	0	(0)
acPurchCurr	char(3)	1	('EUR')
acOrderTransInMF	char(1)	1	('K')
acOrigin	char(3)	1	('')
acDeclarForOriginType	char(3)	1	('')
acAcct	char(8)	1	('')
acFieldSA	varchar(255)	1	('')
acFieldSB	varchar(255)	1	('')
acFieldSC	varchar(255)	1	('')
anFieldNA	decimal(19,6)	0	(0)
anFieldNB	decimal(19,6)	0	(0)
acEvidence	char(1)	1	('F')
anExcise	float	0	(0)
anExciseP	float	0	(0)
anMaxStock	decimal(19,6)	0	(0)
anOptStock	decimal(19,6)	0	(0)
acDeclarForOrigin	char(30)	1	('')
acDept	char(30)	1	('')
acQtyInCode	char(1)	1	('F')
acUMDim1	char(3)	1	('')
acUMDim2	char(3)	1	('')
anWasteQty	decimal(19,6)	0	(0)
acUMSeries	char(3)	1	('')
anQtySeries	decimal(19,6)	0	(1)
acColumn	char(3)	1	('')
anUMToUM3	decimal(19,6)	0	(1)
acUM3	char(3)	1	('')
anUMToDeclarReport	decimal(19,6)	0	(1)
acReportDeclar	char(1)	1	('T')
anFieldNC	decimal(19,6)	0	(0)
anFieldND	decimal(19,6)	0	(0)
anFieldNE	decimal(19,6)	0	(0)
acFieldSD	varchar(255)	1	('')
acFieldSE	varchar(255)	1	('')
anPrstTime	float	1	(0)
acPrstUMTime	char(1)	1	('H')
anPrStInsertUserID	smallint	1	(0)
adPrStInsertTime	smalldatetime	1
anPrStUpdateUserID	smallint	1	(0)
adPrStUpdateTime	smalldatetime	1
anPrStCheckUserID	smallint	1	(0)
adPrStCheckTime	smalldatetime	1
anPrStVariantValid	tinyint	0	(0)
anPrStOptimalQty	decimal(19,6)	0	(1)
anPrStDailyQty	decimal(19,6)	0	(1)
anUnionDeadline	smallint	0	(0)
anDeliveryDeadline	smallint	0	(0)
anPOSQty	decimal(19,6)	0	(1)
acShowAtena	char(1)	1	('F')
acAcctIncome	char(8)	1	('')
acInFlowOutFlow	char(3)	1	('')
anFieldNF	decimal(19,6)	0	(0)
anFieldNG	decimal(19,6)	0	(0)
acFieldSF	varchar(255)	1	('')
acFieldSG	varchar(255)	1	('')
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)
anFixPriceDiff	float	0	(0)
anQtyInCodeDecPlace	smallint	0	(0)
anOrderMinQty	decimal(19,6)	0	(0)
anOrderOptQty	decimal(19,6)	0	(0)
acCostDrv	char(16)	1	('')
acPacking	char(1)	1	('F')
anPurExciseE	float	0	(0)
anPurExciseA	float	0	(0)
anPurExciseT	float	0	(0)
anBeatShare	float	0	(1)
adTimeIns	datetime	1
anUserIns	smallint	1
adTimeChg	datetime	1
anUserChg	smallint	1
acIsReturnPack	char(1)	1	('F')
acEnvrmntCost	char(1)	1	('F')
acWastePack	char(4)	1	('')
acWstEEEquip	char(16)	1	('')
acUsedTyre	char(16)	1	('')
acVehiclePart	char(1)	1	('F')
acPackSLOPAK	char(3)	1	('')
acPackSLOPAKType	char(1)	1	('')
acTechProcedure	text	1
acPicture	image	1
acDescr	text	1

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me