T_SAIDA_NF


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NR_CUPOM DOUBLE PRECISION 15 null
CD_EMPRESA DOUBLE PRECISION 15 √ null
T_EMPRESA.CD_EMPRESA Implied Constraint R
DT_EMISSAO TIMESTAMP 24 √ null
NR_RPS DOUBLE PRECISION 15 √ null
NR_SERIE DOUBLE PRECISION 15 √ null
DT_DIA INTEGER 10 √ null
DT_MES INTEGER 10 √ null
DT_ANO INTEGER 10 √ null
VL_ALIQUOTA DOUBLE PRECISION 15 √ 0
TP_ALIQUOTA INTEGER 10 √ null
DS_CHAVE VARCHAR 200 √ null
DS_INFORMACOES VARCHAR 20000 √ null
DS_DISCRIMINACAO VARCHAR 20000 √ null
DS_TOMADOR VARCHAR 10000 √ null
DS_PRESTADOR VARCHAR 10000 √ null
ID_SITUACAO CHAR 1 √ null
DS_LINK_NFSE VARCHAR 600 √ null
NR_NOTA_GERADA DOUBLE PRECISION 15 √ null
CD_LOCALPRESTACAO DOUBLE PRECISION 15 √ null
CD_NAT_OPERACAO DOUBLE PRECISION 15 √ null
TP_OPERACAO CHAR 1 √ null
NR_PROCESSO_JUD DOUBLE PRECISION 15 √ null
CD_STATUS_RPS DOUBLE PRECISION 15 √ null
CD_EXIGIBILIDADE_ISS DOUBLE PRECISION 15 √ null
CD_ISS_RETIDO DOUBLE PRECISION 15 √ null
CD_RESP_RET DOUBLE PRECISION 15 √ null
CD_RESP_RECOLHIMENTO DOUBLE PRECISION 15 √ null
NM_CLIENTE VARCHAR 40 √ null
NR_DOC VARCHAR 20 √ null
NR_TELEFONE VARCHAR 50 √ null
NM_BAIRRO VARCHAR 30 √ null
NR_CEP DOUBLE PRECISION 15 √ null
DS_TIPO_ENDERECO VARCHAR 30 √ null
DS_ENDERECO VARCHAR 50 √ null
NR_ENDERECO VARCHAR 20 √ null
CD_MUNICIPIO DOUBLE PRECISION 15 √ null
NM_CIDADE VARCHAR 30 √ null
NM_UF CHAR 2 √ null
DS_EMAIL VARCHAR 80 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_SAI_NF Primary key Asc NR_CUPOM

Relationships

Close relationships within degrees of separation