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.

Domínio	Tipo	Tamanho	Precisão	Decimais	Not Null	Check	Valor Padrão
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( (VALUE IS NULL) OR (VALUE BETWEEN 1 AND 31) )
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

Documentação de software

Ferramentas do usuário

Ferramentas do site

Domínios

Ferramentas da página