Table DBBANC specification   

Table name: DBBANC 
DBBANC needs conversion 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

  Bco_cod Numeric (3)Not null  DBBANC.Bco_cod 
 
  Bco_des Character (25)  DBBANC.Bco_des 
 
  BcoIntCard Numeric (5.2)  DBBANC.BcoIntCard 
 
  BcoBIC Character (11)  DBBANC.BcoBIC 
 
  BcoEmpr Character (2)  DBBANC.BcoEmpr 
 
  BcoConv Numeric (6)  DBBANC.BcoConv 
 
New   BcoRefe Character (25)  Null 
 
 

 
 
Indexes  

  Name Definition Composition  

  BANC primary key Clustered  Bco_cod  
 
  
 
  BANCDES duplicate   Bco_des  
 
  
 
 
 
 

Table CONTRAT specification   

Table name: CONTRAT 
CONTRAT needs conversion 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

  CarpTipo Character (4)Not null  CONTRAT.CarpTipo 
 
  CarpNro Numeric (9)Not null  CONTRAT.CarpNro 
 
  FldSubCli Numeric (4)Not null  CONTRAT.FldSubCli 
 
New   FCliStatus Numeric (2)  Null 
 
New   FCliTitula Numeric (1)  Null 
 
 

 
 
Indexes  

  Name Definition Composition  

  CONTSC primary key Clustered  CarpTipo  
 CarpNro  
 FldSubCli  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  FOLDER CarpTipo  
CarpNro  
 
  
 
 

Table ESCALA specification   

Table name: ESCALA 
ESCALA is new 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

  EscaCod Numeric (4)Not null   
 
  EscaDes Character (30)   
 
  EscaDFech Date    
 
  EscaHFech Date    
 
 

 
 
Indexes  

  Name Definition Composition  

  IESCALA primary key Clustered  EscaCod  
 
  
 
 
 
 

Table ESCALON specification   

Table name: ESCALON 
ESCALON is new 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

  EscaCod Numeric (4)Not null   
 
  Escalon Numeric (10.2)Not null   
 
  EscaPct Numeric (5.2)   
 
 

 
 
Indexes  

  Name Definition Composition  

  ESCA primary key Clustered  EscaCod  
 Escalon  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  ESCALA EscaCod  
 
  
 
 

Table SUPERV specification   

Table name: SUPERV 
SUPERV is new 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

  SPerCod Numeric (4)Not null   
 
  SPerNom Character (30)   
 
  SperComisi Numeric (6.2)   
 
  SperPiso Numeric (6)   
 
  SPerFBaja Date    
 
  SPerCedula Numeric (7)   
 
 

 
 
Indexes  

  Name Definition Composition  

  ISUPERV primary key Clustered  SPerCod  
 
  
 
 
 
 

Table SPERCORR specification   

Table name: SPERCORR 
SPERCORR is new 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

  SPerCod Numeric (4)Not null   
 
  Cod_corred Numeric (3)Not null   
 
  SPerAlta Date    
 
  SPerBaja Date    
 
 

 
 
Indexes  

  Name Definition Composition  

  SCOR primary key Clustered  SPerCod  
 Cod_corred  
 
  
 
  SCORCORR duplicate   Cod_corred  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  CORRED Cod_corred  
 
  
 
  SUPERV SPerCod  
 
  
 
 

 
