FXCX

1562 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCONCILCARTAOTRANS.CODCOLXCX FKFCONCILCARTAOTRANS_FXCXR
FCONCILCARTAOTRANS.CODCOLXCXDEPTRANSF FKFCONCILCARTAOTRANSDEP_FXCXR
FCONCILCARTAOTRANS.CODCOLXCXSAQUETAXAS FKFCONCILCARTAOTRANSTAXAS_FXCXR
FCONCILCARTAOTRANS.CODCOLXCXSAQUETRANSF FKFCONCILCARTAOTRANSSAQUE_FXCXR
FINTEGRACAOXCX.CODCOLXCX FKFINTEGRACAOXCX_FXCXR
FLAN.CODCOLXCX FKFLAN_FXCXR
FLANANTECIPAXCX.CODCOLXCX FKFLANANTECIPAXCX_FXCXR
FLANBAIXA.CODCOLXCX FXLANBAIXAXCXR
FRECONCILRELAC.CODCOLIGADA FKFRECONCILRELAC_FXCXR
FXCX.CODCOLIGADA FKFXCX_FXCXCPMFR
FXCX.CODCOLXCXTRANSF FKFXCX_FXCXTRANSFR
FXCXCOMPL.CODCOLIGADA FKFXCXCOMPL_FXCXR
FXCXCONTOLD.CODCOLIGADA FKFXCXCONTOLD_FXCXR
FXCXRELACORCAMENTO.CODCOLIGADA FKFXCXRELACORCAMENTO_FXCXR
GCCUSTO.CODCOLIGADA FKFXCX_GCCUSTOR
CPDIARIOPTG.CODCOLIGADA FKFXCX_CPDIARIOPTGR
GCOLIGADA.CODCOLIGADA FKFXCX_GCOLIGADAR
COPERACAO.CODCOLIGADA FKFXCX_COPERACAOR
FTB4.CODCOLIGADA FKFXCX_FTB4FLXR
TTBGRUPOORCAMENTO.CODCOLIGADA FKFXCX_TTBGRUPOORCAMENTOR
FAPLFIN.CODCOLIGADA FKFXCX_FAPLFINR
TEVENTOSCONT.CODCOLIGADA FKFXCX_TEVENTOSCONTR
FTB2.CODCOLIGADA FKFXCX_FTB2FLXR
GDEPTO.CODCOLIGADA FKFXCX_GDEPTOR
FXCX.CODCOLIGADA FKFXCX_FXCXCPMFR
FTB3.CODCOLIGADA FKFXCX_FTB3FLXR
FLAN.CODCOLIGADA FKFXCX_FLANR
FLOGSESSAOCAIXA.CODCOLIGADA FKFXCX_FLOGSESSAOCAIXAR
FTB1.CODCOLIGADA FKFXCX_FTB1FLXR
TFORMAPAGTO.CODCOLIGADA FKFXCX_TFORMAPAGTOR
FCONVENIO.CODCOLIGADA FKFXCX_FCONVENIOR
GFILIAL.CODCOLIGADA FXCX_GFILIALR
FTB5.CODCOLIGADA FKFXCX_FTB5FLXR
IDXCX int 4 null
FCONCILCARTAOTRANS.IDXCX FKFCONCILCARTAOTRANS_FXCXR
FCONCILCARTAOTRANS.IDXCXDEPTRANSF FKFCONCILCARTAOTRANSDEP_FXCXR
FCONCILCARTAOTRANS.IDXCXSAQUETAXAS FKFCONCILCARTAOTRANSTAXAS_FXCXR
FCONCILCARTAOTRANS.IDXCXSAQUETRANSF FKFCONCILCARTAOTRANSSAQUE_FXCXR
FINTEGRACAOXCX.IDXCX FKFINTEGRACAOXCX_FXCXR
FLAN.IDXCX FKFLAN_FXCXR
FLANANTECIPAXCX.IDXCX FKFLANANTECIPAXCX_FXCXR
FLANBAIXA.IDXCX FXLANBAIXAXCXR
FRECONCILRELAC.IDXCX FKFRECONCILRELAC_FXCXR
FXCX.IDCPMF FKFXCX_FXCXCPMFR
FXCX.IDXCXTRANSF FKFXCX_FXCXTRANSFR
FXCXCOMPL.IDXCX FKFXCXCOMPL_FXCXR
FXCXCONTOLD.IDXCX FKFXCXCONTOLD_FXCXR
FXCXRELACORCAMENTO.IDXCX FKFXCXRELACORCAMENTO_FXCXR
NUMERODOCUMENTO varchar 20 null
TIPO smallint 2 null
TCODIGO.TIPO Implied ConstraintR
COMPENSADO smallint 2 null
RECONCILIADO smallint 2 null
STATUSEXPORTACAO smallint 2 null
HISTORICO varchar 255 √ null
CODCXA varchar 10 null
FCXA.CODCXA FKFXCX_FCXAR
CODCOLCXA smallint 2 null
FCXA.CODCOLIGADA FKFXCX_FCXAR
CODCOLCXATRANSF smallint 2 √ null
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKFXCX_GCCUSTOR
CODFILIAL smallint 2 null
GDEPTO.CODFILIAL FKFXCX_GDEPTOR
GFILIAL.CODFILIAL FXCX_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKFXCX_GDEPTOR
VALOR RMDVALOR4 17,4 null
VALORCONTABIL RMDVALOR4 17,4 √ null
VALOREMREAIS RMDVALOR4 17,4 √ null
DATA datetime 16,3 null
DATAVENCIMENTO datetime 16,3 √ null
DATACOMPENSACAO datetime 16,3 √ null
DATACANCELAMENTO datetime 16,3 √ null
DATAESTORNO datetime 16,3 √ null
DATACONTABILIZ datetime 16,3 √ null
DATARECONCILIACAO datetime 16,3 √ null
DATAPRORROGACAO datetime 16,3 √ null
DATACUSTODIAFILIAL datetime 16,3 √ null
DATACUSTODIABANCO datetime 16,3 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFXCX_TEVENTOSCONTR
NUMCONTABIL varchar 20 √ null
IDLAN int 4 √ null
FLAN.IDLAN FKFXCX_FLANR
IDSESSAO int 4 √ null
FLOGSESSAOCAIXA.IDSESSAO FKFXCX_FLOGSESSAOCAIXAR
IDCPMF int 4 √ null
FXCX.IDXCX FKFXCX_FXCXCPMFR
CODCOLXCXTRANSF smallint 2 √ null
FXCX.CODCOLIGADA FKFXCX_FXCXTRANSFR
IDXCXTRANSF int 4 √ null
FXCX.IDXCX FKFXCX_FXCXTRANSFR
CODCXATRANSF varchar 10 √ null
IDAPLFIN int 4 √ null
FAPLFIN.IDAPLFIN FKFXCX_FAPLFINR
CONTABIL smallint 2 null
FILIALCONTABIL smallint 2 √ null
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKFXCX_FTB1FLXR
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKFXCX_FTB2FLXR
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKFXCX_FTB3FLXR
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKFXCX_FTB4FLXR
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKFXCX_FTB5FLXR
ECHEQUE smallint 2 null
CODIGOBANCO varchar 3 √ null
CODIGOAGENCIA varchar 6 √ null
CODAGENCIACUSTODIA varchar 6 √ null
CODBANCOCUSTODIA varchar 3 √ null
CONTACORRENTE varchar 15 √ null
NOMINAL varchar 100 √ null
PREDATADO smallint 2 √ null
NOMEEMITENTE varchar 40 √ null
CHEQUEIMPRESSO smallint 2 √ null
PRACACHEQUE varchar 32 √ null
TELEMITENTE varchar 15 √ null
TIPOCUSTODIA smallint 2 null
CODFILIALCUSTODIA smallint 2 √ null
GFILIAL.CODFILIAL FKXCX_GFILCUSTR
COTACAOINCLUSAO RMDVALOR1 17,1 √ null
IDFORMAPAGTO int 4 √ null
TFORMAPAGTO.IDFORMAPAGTO FKFXCX_TFORMAPAGTOR
IDOPERACAO int 4 √ null
FLOGSESSAOCAIXA.IDOPERACAO FKFXCX_FLOGSESSAOCAIXAR
ESTORNADO smallint 2 √ null
IDLANHIST int 4 √ null
NUMLOTECONTABIL int 4 √ null
CMCCH varchar 34 √ null
TIPOINSCRICAOCH varchar 2 √ null
NUMINSCRICAOCH varchar 20 √ null
DATACAPTURACH datetime 16,3 √ null
DATADEPOSITOCH datetime 16,3 √ null
DATAPREVISTACH datetime 16,3 √ null
AGENCIADEVCH varchar 6 √ null
CONTADEVCH varchar 12 √ null
TIPOMOVCH varchar 2 √ null
CODDIARIO varchar 5 √ null
CPDIARIOPTG.CODDIARIO FKFXCX_CPDIARIOPTGR
SEQDIARIO varchar 9 √ null
SEQDIARIOESTORNO varchar 9 √ null
LIBERACAOAUTORIZADA smallint 2 null
USUARIOCRIACAO varchar 20 √ null
GUSUARIO.CODUSUARIO FKFXCX_GUSUARIOR
DATACRIACAO datetime 16,3 √ null
CODCOLNATFINANCEIRA DCODCOLIGADANULL 2 √ null
TTBORCAMENTO.CODCOLIGADA FKFXCX_TTBORCAMENTOR
CODNATFINANCEIRA varchar 40 √ null
TTBORCAMENTO.CODTBORCAMENTO FKFXCX_TTBORCAMENTOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
MODELOCONTABILIZACAO smallint 2 ((0))
IDOPERACAOCONT int 4 √ null
COPERACAO.IDOPERACAO FKFXCX_COPERACAOR
IDCONVENIO int 4 √ null
FCONVENIO.IDCONVENIO FKFXCX_FCONVENIOR
CODTBGRUPOORC varchar 40 √ null
TTBGRUPOORCAMENTO.CODTBGRUPOORC FKFXCX_TTBGRUPOORCAMENTOR
EFEITOSALDOORCAMENTO varchar 1 √ null
STATUSORCAMENTO smallint 2 √ null
STSCONCILCARTAO smallint 2 √ null
CARTAOOPERADORA int 4 √ null
CARTAOBANDEIRA int 4 √ null
CARTAONSU varchar 50 √ null
CARTAOAUTORIZACAO varchar 50 √ null
CARTAOTID varchar 50 √ null
CARTAONUMPARCELA int 4 √ null
CLASSELCDPR smallint 2 √ null
TIPOLCDPR smallint 2 √ null
CPFCNPJLCDPR varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFXCX Primary key Asc/Asc CODCOLIGADA + IDXCX
FXFXCXIDCPMF Performance Asc/Asc CODCOLIGADA + IDCPMF
FXFXCXLAN Performance Asc/Asc IDLAN + CODCOLIGADA
FXFXCXMODELOCONTABILIZACAO Performance Asc MODELOCONTABILIZACAO
FXXCXCOLCXA Performance Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODCXA + DATA + NUMERODOCUMENTO + TIPO
FXXCXCOLDAT Performance Asc/Asc DATA + CODCOLIGADA
FXXCXDATAVENC Performance Asc DATAVENCIMENTO
FXXCXIDOPERACAO Performance Asc/Asc/Asc IDOPERACAO + IDSESSAO + CODCOLIGADA
FXXCXIDSESSAO Performance Asc IDSESSAO
FXXCXIDXCXTRANSF Performance Asc IDXCXTRANSF
FXXCXNUMCHEQUE Performance Asc/Asc/Asc/Asc CODIGOBANCO + CODIGOAGENCIA + CONTACORRENTE + NUMERODOCUMENTO
IDX_FXCX_IDOPERACAOCONT Performance Asc/Asc CODCOLIGADA + IDOPERACAOCONT
IXFXCX Performance Asc/Asc CODCOLXCXTRANSF + IDXCXTRANSF
IXFXCX_CXA Performance Asc/Asc CODCOLCXA + CODCXA

Relationships

Close relationships within degrees of separation