Documentação de software

Essa é uma revisão anterior do documento!

Domínios

Todos os Domínios criados pela Intelliware deve iniciar coma a letra T, abreviação de Tipo, pois os domínios são criados para serem utilizado como tipos de dados dos campos.

TALPHA100	VARCHAR	100		0
TALPHA100N	VARCHAR	100		0	X
TALPHA12	VARCHAR	12		0
TALPHA12N	VARCHAR	12		0	X
TALPHA13N	VARCHAR	13		0	X
TALPHA15N	VARCHAR	15		0	X
TALPHA20N	VARCHAR	20		0	X
TALPHA255	VARCHAR	255		0
TALPHA255N	VARCHAR	255		0	X
TALPHA2N	VARCHAR	2		0	X
TALPHA3	CHAR	3		0
TALPHA30	VARCHAR	30		0
TALPHA30N	VARCHAR	30		0	X
TALPHA3N	CHAR	3		0	X
TALPHA4N	CHAR	4		0	X
TALPHA50	VARCHAR	50		0
TALPHA50N	VARCHAR	50		0	X
TALPHA512	VARCHAR	512		0
TALPHA5N	VARCHAR	5		0	X
TALPHA60N	VARCHAR	60		0	X
TCHAR	CHAR	1		0
TCHARN	CHAR	1		0	X
TDATAHORA	TIMESTAMP	8		0
TDATAHORAN	TIMESTAMP	8		0	X		DEFAULT CURRENT_TIMESTAMP
TDATE	DATE	4		0
TDIAMES	INTEGER	4	0	0		CHECK ¹⁾
TFATORES	INTEGER	4	0	0	X	CHECK(VALUE BETWEEN -1 AND 1)
TFLOAT3		8	18	3
TFLOAT3N		8	18	3	X
THOJE	DATE	4		0	X		DEFAULT CURRENT_DATE
TINT64	BIGINT	8	0	0
TINTBOOL0	SMALLINT	2	0	0	X	CHECK(VALUE IN (0,1))	DEFAULT 0
TINTBOOL1	SMALLINT	2	0	0	X	CHECK(VALUE IN (0,1))	DEFAULT 1
TINTEGER	INTEGER	4	0	0
TINTEGERN	INTEGER	4	0	0	X
TMONEY2		8	18	2
TMONEY2N		8	18	2	X
TMONEY3		8	18	3
TMONEY3N		8	18	3	X
TPERCENT		8	18	8	X		DEFAULT 0
TPERCENTNL		8	18	8
TPICTURE	BLOB	8		0
TPKEY	BIGINT	8	0	0	X
TSEXO	CHAR	1		0	X	CHECK(VALUE IN ('M','F', ' '))	DEFAULT 'M'
TSMALLINT	SMALLINT	2	0	0
TSMALLINTN	SMALLINT	2	0	0	X		DEFAULT 1
TTEXTO	BLOB	8		0
TTIPOACAON	VARCHAR	1		0	X	CHECK (VALUE IN ('U', 'D', 'I'))
TTIPOPESSOAN	CHAR	1		0	X	CHECK (VALUE IN ('F','J'))
TFLOAT4		8	18	4
TALPHA1024	VARCHAR	1024		0
TALPHA2	CHAR	2		0
TFLOAT5N		8	18	5	X
TALPHA20	VARCHAR	20		0
TALPHA4	CHAR	4		0
TALPHA15	CHAR	15		0
TALPHA6	CHAR	6		0
TALPHA150N	VARCHAR	150		0	X
TALPHA2048	VARCHAR	2048		0
THORAN		4		0	X
TALPHA5	VARCHAR	5		0
TALPHA6N	VARCHAR	6		0	X
TCHAR12	CHAR	12		0
TCHAR126	CHAR	126		0
TCHAR16	CHAR	16		0
TCHAR37	CHAR	37		0
TCHAR79	CHAR	79		0
TNUMERONFE	VARCHAR	10		0
TTIPOTURNON	CHAR	3		0	X	CHECK(VALUE IN ('T1','T2', 'T3'))
TDIA	INTEGER	4	0	0
THORA		4		0
TNUMERONF	VARCHAR	7		0	X
TCHAR18	CHAR	18		0
TCHAR26	CHAR	26		0
TCHAR7	CHAR	7		0
TALPHA1	CHAR	1		0
TCHAR53	CHAR	53		0
TFLOAT4N		8	18	4	X
TALPHA14N	VARCHAR	14		0	X
TALPHA14	VARCHAR	14		0
TCHAR10	CHAR	10		0
TCHAR13	CHAR	13		0
TCHAR14	CHAR	14		0
TCHAR14N	CHAR	14		0	X
TALPHA60	VARCHAR	60		0
TCHAR2	CHAR	2		0
TCHAR20	CHAR	20		0
TCHAR20N	CHAR	20		0	X
TCHAR2N	CHAR	2		0	X
TCHAR3	CHAR	3		0
TCHAR3N	CHAR	3		0	X
TCHAR4	CHAR	4		0
TCHAR4N	CHAR	4		0	X
TCHAR53N	CHAR	53		0	X
TCHAR6	CHAR	6		0
TCHAR6N	CHAR	6		0	X
TCHAR8	CHAR	8		0
TCHAR22	CHAR	22		0
TCHAR28	CHAR	28		0
TCHAR30	CHAR	29		0
TALPHA7N	VARCHAR	7		0	X
TCTBCONTROLE	VARCHAR	3		0	X	CHECK(VALUE IN ('F', 'G', 'F/G'))
TALPHA5120	VARCHAR	5120		0
TCTBESPECIE	CHAR	1		0	X	CHECK(VALUE IN ('A', 'S'))
TBINARY	BLOB	8		0
TCTBNATUREZA	CHAR	1		0	X	CHECK(VALUE IN ('C', 'D'))
TALPHA10	VARCHAR	10		0
TCTBORIGEMLANCTO	CHAR	1		0		CHECK(VALUE IN ('C', 'F', 'P', 'R', 'M'))	DEFAULT 'M'
TCTBTIPOLANC	CHAR	1		0	X	CHECK(VALUE IN ('R', 'P', 'A', 'N'))
TCUSTO		8	18	6
TCUSTON		8	18	6	X
TALPHA120	VARCHAR	120		0
TALPHA25	VARCHAR	25		0
TALPHA8	VARCHAR	8		0
TFLOAT5		8	18	5
TALPHA40	VARCHAR	40		0
TALPHA40N	VARCHAR	40		0	X
TALPHA9N	VARCHAR	9		0	X
TCHASSI	VARCHAR	17		0	X
TINTEGER0	INTEGER	4	0	0	X		DEFAULT 0
TINTEGER1	INTEGER	4	0	0	X		DEFAULT 1
TNUM2N	INTEGER	4	6	2	X
TFLOATN	FLOAT	4		0	X
TCHAR8N	CHAR	8		0	X
TFLOAT	FLOAT	4		0
TALPHA10N	VARCHAR	10		0
TALPHA1N	CHAR	1		0
TBIGINT	BIGINT	8	0	0
TBIGINTN	BIGINT	8	0	0	X
THOJEN	DATE	4		0	X		DEFAULT CURRENT_DATE
TMONEYUNID10N		8	18	10	X
TQTDEPESO3N		8	18	3	X

¹⁾ VALUE IS NULL) OR (VALUE BETWEEN 1 AND 31

Documentação de software

Ferramentas do usuário

Ferramentas do site

Domínios

Ferramentas da página