APARAM

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKAPARAM_GCOLIGADAR
INICIOPERMES datetime 16,3 null
FIMPERMES datetime 16,3 null
INICIOPERSEM datetime 16,3 null
FIMPERSEM datetime 16,3 null
INICIOPERNOT int 4 null
TIPOINICIOPERNOT smallint 2 √ null
FIMPERNOT int 4 null
TIPOFIMPERNOT smallint 2 √ null
MESCOMP smallint 2 √ null
ANOCOMP int 4 √ null
FORAPADRAO smallint 2 √ null
BACKUPJAFEITO smallint 2 √ null
BACKUPOBRIGATORIO smallint 2 √ null
UTILIZACOLETOR smallint 2 √ null
CONTROLAREFEICOES smallint 2 √ null
CALCULASEMMOVTO smallint 2 √ null
GERAANORMAL smallint 2 √ null
CONTROLAACESSO smallint 2 √ null
RECALCULAR smallint 2 √ null
IMPRIMECALCULA smallint 2 √ null
TEMDIASEMCALCULO smallint 2 √ null
TEMMOVTOSEMANA smallint 2 √ null
TEMMOVTOMES smallint 2 √ null
INICIOPERQUI datetime 16,3 null
FIMPERQUI datetime 16,3 null
DESCRICAOPERSEM varchar 40 √ null
DESCRICAOPERQUI varchar 40 √ null
DESCRICAOPERMES varchar 40 √ null
ULTMODCALCULODATA datetime 16,3 √ null
ULTMODCALCULOHORA datetime 16,3 √ null
USACONTROLEREL smallint 2 √ null
USAJUSTEXCECAO smallint 2 √ null
JUSTEXCECAOQUIOSQUE smallint 2 √ null
FREQEXCECAOQUIOSQUE smallint 2 √ null
LIMDIASCOMPENSACAO int 4 √ null
IMPBATAUTOMATICO smallint 2 √ null
CONSPRIMBATHORARIO smallint 2 √ null
INICIOPERIMPBAT datetime 16,3 √ null
FIMPERIMPBAT datetime 16,3 √ null
DATAHORATRAVIMPBAT datetime 16,3 √ null
COMPUTTRAVIMPBAT varchar 30 √ null
TRAVIMPBAT smallint 2 √ null
TEMPOENTREIMPBAT int 4 √ null
CONTRPRESQUIOSQUE smallint 2 √ null
ESPELHOQUIOSQUE smallint 2 √ null
CADCHEFESUPQUIOSQUE smallint 2 √ null
RELSALDOBANCOPERQUIOSQUE smallint 2 √ null
ALTHLEQUIOSQUE smallint 2 √ null
ENTBATQUIOSQUE smallint 2 √ null
APROVBATQUIOSQUE smallint 2 √ null
OCORQUIOSQUE smallint 2 √ null
ALTNATUREZABATQUIOSQUE smallint 2 √ null
INSEREBATDIGQUIOSQUE smallint 2 √ null
PROJETADIASFECHAMENTO smallint 2 √ null
DATAINICIOPROJECAO datetime 16,3 √ null
FILTROFUNCOBRIG smallint 2 √ null
CONSABONOHORA smallint 2 √ null
ESPELHOLIN smallint 2 √ null
INICIOPERMESHOR datetime 16,3 √ null
FIMPERMESHOR datetime 16,3 √ null
NAOPERMITEALTHORAANT smallint 2 √ null
VISTEMPOMINJOR smallint 2 √ null
DESCDTTRANSFERENCIA smallint 2 √ null
CONSPEREXTRAAUTO smallint 2 √ null
CONSHORLIMABONO smallint 2 √ null
USAMASCARAVIS smallint 2 √ null
CODFORMULA varchar 16 √ null
MOVFUNDIA smallint 2 √ null
FIMPERDTATUAL smallint 2 √ null
TEMPPARAM smallint 2 √ null
CONSSEGREF smallint 2 √ null
HORALTERSEMBAT smallint 2 √ null
VISMOVCONFJOR smallint 2 √ (0)
USAPARAM smallint 2 √ (0)
COLIGADAACESSO varchar 50 √ null
USAPARAVANC smallint 2 √ null
MESCOMPATUAL smallint 2 √ null
ANOCOMPATUAL int 4 √ null
INICIOPERMESATUAL datetime 16,3 √ null
FIMPERMESATUAL datetime 16,3 √ null
MESCOMPFUT smallint 2 √ null
ANOCOMPFUT int 4 √ null
INICIOPERMESFUT datetime 16,3 √ null
FIMPERMESFUT datetime 16,3 √ null
DESCRICAOPERMESFUT varchar 40 √ null
USANOVOCALCULO smallint 2 √ null
CODABONOATESTADOLABORE varchar 4 √ null
UTILIZALOGIMPORTACAO smallint 2 √ ((1))
INTEGRACAOTSREP smallint 2 √ null
INTEGRACAOTSA smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
LOGAJUSTFUN int 4 √ ((0))
CRC int 4 √ null
LIBERAMENUMOVIMENTO smallint 2 √ null
NUMEROPERIODOARQUIVOMORTO int 4 √ ((6))
CONSIDERANATUREZAALTERADA smallint 2 ((0))
USANOVAGESTAOABONO smallint 2 ((0))
REALIZARECALCULOEDICAOBATIDAS smallint 2 ((0))
SOBREPOEEXTRASPARAMETRIZADAS smallint 2 ((1))
INTEGRACAOCAROL smallint 2 ((0))
NOMETENANTCAROL varchar 50 √ null
NOMEUSUARIOTENANTCAROL varchar 100 √ null
SENHATENANTCAROL varchar 2147483647 √ null
CONNECTORIDTENANTCAROL varchar 2147483647 √ null
BLOQUEIABATIDASCOLETADAS smallint 2 ((0))
CONSVERBASLANCXCALC smallint 2 ((0))
CONSFUNCELEGIVEISLANCFOLHA smallint 2 ((0))
BLOQRECAPOSLANCFOLHA smallint 2 √ ((0))
CONSFUNCLANCADODESBLOQ smallint 2 √ ((0))
CONSDATAREFERENCIAALTERADA smallint 2 ((0))
NOMEORGANIZACAOCAROL varchar 50 √ null
USAJUSTPREDEFINIDA smallint 2 ((0))
SERVIDORAPI varchar 50 √ null
PORTAAPI varchar 10 √ null
USAHTTPSAPI smallint 2 √ null
SERVIDORAPP varchar 50 √ null
PORTAAPP varchar 10 √ null
USAHTTPSAPP smallint 2 √ null
IMPORTABATIDASFORAPERIM smallint 2 ((1))
IMPORTARBATIDASAPI smallint 2 ((0))
EMAILDASHBOARD varchar 60 √ null

Indexes

Constraint Name Type Sort Column(s)
PKAPARAM Primary key Asc CODCOLIGADA

Relationships

Close relationships within degrees of separation