FBANCOLAYOUTS

23 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NUMBANCO varchar 3 null
GBANCO.NUMBANCO FKFBANCOLAYOUTS_GBANCOR
CODBARRAPOSININOSSONUMERO int 4 √ null
CODBARRATAMNOSSONUMERO int 4 √ null
RETCOBCODCXARETORNO varchar 10 √ null
RETCOBPOSINICHAVELAN smallint 2 √ null
RETCOBPOSFIMCHAVELAN smallint 2 √ null
RETCOBPOSINIDATABAIXA smallint 2 √ null
RETCOBPOSFIMDATABAIXA smallint 2 √ null
RETCOBPOSINIVALORBAIXA smallint 2 √ null
RETCOBPOSFIMVALORBAIXA smallint 2 √ null
RETCOBPOSINIERROS smallint 2 √ null
RETCOBPOSFIMERROS smallint 2 √ null
RETCOBTAMERRO smallint 2 √ null
RETCOBPOSININOSSONUM smallint 2 √ null
RETCOBPOSFIMNOSSONUM smallint 2 √ null
RETCOBPOSINICODRETORNO smallint 2 √ null
RETCOBPOSFIMCODRETORNO smallint 2 √ null
RETCOBPOSINICHAVELAN2 smallint 2 √ null
RETCOBPOSFIMCHAVELAN2 smallint 2 √ null
RETCOBPOSINIDESCONTO smallint 2 √ null
RETCOBPOSFIMDESCONTO smallint 2 √ null
RETCOBPOSINIJUROS smallint 2 √ null
RETCOBPOSFIMJUROS smallint 2 √ null
RETCOBPOSINIMULTA smallint 2 √ null
RETCOBPOSFIMMULTA smallint 2 √ null
RETCOBCODBAIXA varchar 80 √ null
RETCOBCODREGISTRADO varchar 80 √ null
RETCOBCODRECUSADO varchar 80 √ null
RETCOBPOSCODBANCO int 4 √ null
RETCOBCOMANDOINCLUSAO smallint 2 √ null
RETCOBPOSINIDATACOMP int 4 √ null
RETCOBPOSFIMDATACOMP int 4 √ null
RETCOBPOSINIVALORORIG smallint 2 √ null
RETCOBPOSFIMVALORORIG smallint 2 √ null
RETCOBPOSININUMDOC smallint 2 √ null
RETCOBPOSFIMNUMDOC smallint 2 √ null
RETCOBPOSINIVALOROP1 smallint 2 √ null
RETCOBPOSINIVALOROP2 smallint 2 √ null
RETCOBPOSINIVALOROP3 smallint 2 √ null
RETCOBPOSINIVALOROP4 smallint 2 √ null
RETCOBPOSINIVALOROP5 smallint 2 √ null
RETCOBPOSINIVALOROP6 smallint 2 √ null
RETCOBPOSINIVALOROP7 smallint 2 √ null
RETCOBPOSINIVALOROP8 smallint 2 √ null
RETCOBPOSFIMVALOROP1 smallint 2 √ null
RETCOBPOSFIMVALOROP2 smallint 2 √ null
RETCOBPOSFIMVALOROP3 smallint 2 √ null
RETCOBPOSFIMVALOROP4 smallint 2 √ null
RETCOBPOSFIMVALOROP5 smallint 2 √ null
RETCOBPOSFIMVALOROP6 smallint 2 √ null
RETCOBPOSFIMVALOROP7 smallint 2 √ null
RETCOBPOSFIMVALOROP8 smallint 2 √ null
RETCOBPOSINIAUTENTIC smallint 2 √ null
RETCOBPOSFIMAUTENTIC smallint 2 √ null
FORMATODATARETBAIXA varchar 8 √ ('DDMMAAAA')
FORMATODATARETCOMP varchar 8 √ ('DDMMAAAA')
RETCUSTPOSINIBANCOHEADER smallint 2 √ null
RETCUSTPOSINICODHEADER smallint 2 √ null
FORMATODTDEPCUSTCH varchar 8 √ null
RETCUSTPOSFIMDTDEP smallint 2 √ null
RETCUSTPOSINIDTDEP smallint 2 √ null
RETCUSTPOSFIMVALORCH smallint 2 √ null
RETCUSTPOSINIVALORCH smallint 2 √ null
RETCUSTCODCUST varchar 20 √ null
RETCUSTCODREC varchar 20 √ null
RETCUSTCODCOMP varchar 20 √ null
RETCUSTPOSFIMCODRET smallint 2 √ null
RETCUSTPOSINICODRET smallint 2 √ null
RETCUSTPOSFIMCAMPOCH smallint 2 √ null
RETCUSTPOSINICAMPOCH smallint 2 √ null
RETCOBPOSFIMCAMPOCOMPL smallint 2 √ null
RETCOBPOSINICAMPOCOMPL smallint 2 √ null
RETCOBCAMPOCOMPLRET varchar 20 √ null
RETRECCODREGISTROHEADE varchar 2 √ null
RETRECPOSCODBANCO smallint 2 √ null
RETRECCODREGISTRO varchar 2 √ null
RETRECPOSCODREGISTRODET smallint 2 √ null
RETRECPOSINICONTAC smallint 2 √ null
RETRECPOSFIMCONTAC smallint 2 √ null
RETRECCODTIPOINSCCNPJ char 1 √ null
RETRECCODTIPOINSCCPF char 1 √ null
RETRECPOSTIPOINSC smallint 2 √ null
RETRECPOSINIINSC smallint 2 √ null
RETRECPOSFIMINSC smallint 2 √ null
RETRECPOSINIAGENCIA smallint 2 √ null
RETRECPOSFIMAGENCIA smallint 2 √ null
RETRECPOSINIDV smallint 2 √ null
RETRECPOSFIMDV smallint 2 √ null
RETRECCODSALDODEB char 1 √ null
RETRECCODSALDOCRE char 1 √ null
RETRECPOSTIPOREGISTRO smallint 2 √ null
RETRECCODREGSALDOANT char 1 √ null
RETRECCODREGLANC char 1 √ null
RETRECCODREGSALDOATUAL char 1 √ null
RETRECPOSINIDTSALDOANT smallint 2 √ null
RETRECPOSFIMDTSALDOANT smallint 2 √ null
RETRECFORMATODTSALDOANT varchar 8 √ null
RETRECPOSINISALDOANT smallint 2 √ null
RETRECPOSFIMSALDOANT smallint 2 √ null
RETRECPOSSTATUSSALDOANT smallint 2 √ null
RETRECPOSINICATLANC smallint 2 √ null
RETRECPOSFIMCATLANC smallint 2 √ null
RETRECCODCATDEB varchar 255 √ null
RETRECCODCATCRE varchar 255 √ null
RETRECPOSININUMDOCLANC smallint 2 √ null
RETRECPOSFIMNUMDOCLANC smallint 2 √ null
RETRECPOSINIDTLANC smallint 2 √ null
RETRECPOSFIMDTLANC smallint 2 √ null
RETRECFORMATODTLANC varchar 8 √ null
RETRECPOSINIVRLANC smallint 2 √ null
RETRECPOSFIMVRLANC smallint 2 √ null
RETRECPOSINIHIST smallint 2 √ null
RETRECPOSFIMHIST smallint 2 √ null
RETRECPOSINIDTSALDOATUAL smallint 2 √ null
RETRECPOSFIMDTSALDOATUAL smallint 2 √ null
RETRECFORMATODTSALDOATUAL varchar 8 √ null
RETRECPOSINISALDOATUAL smallint 2 √ null
RETRECPOSFIMSALDOATUAL smallint 2 √ null
RETRECPOSSTATUSSALDOATUAL smallint 2 √ null
RETRECCODREGISTROTRAILER varchar 2 √ null
RETRECPOSCODREGISTRO smallint 2 √ null
RETCOBPOSINIDTBXHEADER smallint 2 √ null
RETCOBPOSFIMDTBXHEADER smallint 2 √ null
RETCOBFORMATODTBXHEADER varchar 8 √ null
RETCOBPOSINIDTCOMPLHEADER smallint 2 √ null
RETCOBPOSFIMDTCOMPLHEADER smallint 2 √ null
RETCOBFORMATODTCOMPLHEADER varchar 8 √ null
RETCOBPOSINIDTRETHEADER smallint 2 √ null
RETCOBPOSFIMDTRETHEADER smallint 2 √ null
RETCOBFORMATODTRETHEADER varchar 8 √ null
RETCOBCAMPODTRETHEADER varchar 20 √ null
RETCOBPOSINIDATACOMPL smallint 2 √ null
RETCOBPOSFIMDATACOMPL smallint 2 √ null
FORMATODATARETCOMPL varchar 8 √ null
RETCOBDATACOMPLRET varchar 20 √ null
RETRECPOSFIMTIPOREGISTRO smallint 2 √ null
RETRECPOSFIMSTATUSSALDOANT smallint 2 √ null
RETRECPOSINISTATUSLANC smallint 2 √ null
RETRECPOSFIMSTATUSLANC smallint 2 √ null
RETRECPOSFIMSTATUSSALDOATUAL smallint 2 √ null
RETRECUSAFORMATOSWIFT smallint 2 √ null
VALORCODBARRAS smallint 2 √ null
TAMCHAVELANDEBAUTCNAB150 int 4 √ null
TAMCHAVELANDEBAUTCNAB240 int 4 √ null
DDACODREGISTRODETALHE varchar 2 √ null
DDACODSEGOBRIG varchar 2 √ null
DDACODSEGOPCIONAL varchar 2 √ null
DDACODREGISTRODETALHEINI smallint 2 √ null
DDACODREGISTRODETALHEFIM smallint 2 √ null
DDACODSEGINI smallint 2 √ null
DDACODSEGFIM smallint 2 √ null
DDABANCOCEDENTEINI smallint 2 √ null
DDABANCOCEDENTEFIM smallint 2 √ null
DDAMOEDAINI smallint 2 √ null
DDAMOEDAFIM smallint 2 √ null
DDADGCODBARRASINI smallint 2 √ null
DDADGCODBARRASFIM smallint 2 √ null
DDAFATORVENCINI smallint 2 √ null
DDAFATORVENCFIM smallint 2 √ null
DDAVALORCODBARRASINI smallint 2 √ null
DDAVALORCODBARRASFIM smallint 2 √ null
DDACAMPOLIVREINI smallint 2 √ null
DDACAMPOLIVREFIM smallint 2 √ null
DDADTEMISSAOINI smallint 2 √ null
DDADTEMISSAOFIM smallint 2 √ null
DDADTVENCIMENTOINI smallint 2 √ null
DDADTVENCIMENTOFIM smallint 2 √ null
DDANUMDOCINI smallint 2 √ null
DDANUMDOCFIM smallint 2 √ null
DDATIPOINSCCEDENTEINI smallint 2 √ null
DDATIPOINSCCEDENTEFIM smallint 2 √ null
DDAINSCCEDENTEINI smallint 2 √ null
DDAINSCCEDENTEFIM smallint 2 √ null
DDAVALORINI smallint 2 √ null
DDAVALORFIM smallint 2 √ null
DDANUMREGDETALHEINI smallint 2 √ null
DDANUMREGDETALHEFIM smallint 2 √ null
DDAINSCCEDENTESEGOPCIONALINI smallint 2 √ null
DDAINSCCEDENTESEGOPCIONALFIM smallint 2 √ null
DDADTEMISSAOFORMAT varchar 8 √ null
DDADTVENCIMENTOFORMAT varchar 8 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
RETRECCNAB240 smallint 2 √ ((0))
DDANOMEFORNECEDORINI smallint 2 √ null
DDANOMEFORNECEDORFIM smallint 2 √ null
RETCOBCODCANCELAMENTO char 80 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFBANCOLAYOUTS Primary key Asc NUMBANCO

Relationships

Close relationships within degrees of separation