ABATFUN

8138 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AJORNADACALCULADA.CODCOLIGADA FKABATFUN_AJORNADACALCULADAR
APORTARIA373.CODCOLIGADA FKABATFUN_APORTARIA373R
APARFUN.CODCOLIGADA FKABATFUN_APARFUNR
ARELCOL.CODCOLIGADA FKABATFUN_ARELCOLR
AAFDT.CODCOLIGADA FKABATFUN_AAFDTR
CHAPA DCHAPA 16 null
APARFUN.CHAPA FKABATFUN_APARFUNR
AJORNADACALCULADA.CHAPA FKABATFUN_AJORNADACALCULADAR
DATA datetime 16,3 null
BATIDA int 4 null
STATUS varchar 1 √ null
NATUREZA smallint 2 √ null
CODIGOTERMCOL varchar 10 √ null
ARELCOL.CODIGO FKABATFUN_ARELCOLR
DATAINSERCAO datetime 16,3 √ null
DATAAPROV datetime 16,3 √ null
COLIGADARESP DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKABATFUN_PFUNCR
CHAPARESP DCHAPANULL 16 √ null
PFUNC.CHAPA FKABATFUN_PFUNCR
DATAREFERENCIA datetime 16,3 √ null
AJORNADACALCULADA.DATAREFERENCIA FKABATFUN_AJORNADACALCULADAR
IDJORNADA int 4 √ null
AJORNADACALCULADA.IDJORNADA FKABATFUN_AJORNADACALCULADAR
IDAAFDT int 4 √ null
AAFDT.ID FKABATFUN_AAFDTR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOBATIDA int 4 √ null
NATUREZAALTERADA smallint 2 √ null
IDAPORTARIA373 int 4 √ null
APORTARIA373.ID FKABATFUN_APORTARIA373R
DATAREFERENCIAALTERADA smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKABATFUN Primary key Asc/Asc/Asc/Asc CHAPA + CODCOLIGADA + DATA + BATIDA
IDX_ABATFUN_IDAAFDT Performance Asc IDAAFDT

Relationships

Close relationships within degrees of separation