Table DBBANC specification   

Table name: DBBANC 
DBBANC needs conversion 
 
Warnings  

 rgz0007 Attribute  BcoRefe does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

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

 
 
Indexes  

  Name Definition Composition  

  BANC primary key   Bco_cod  
 
  
 
  BANCDES duplicate   Bco_des  
 
  
 
 
 
 

Table CONTRAT specification   

Table name: CONTRAT 
CONTRAT needs conversion 
 
Warnings  

 rgz0007 Attribute  FCliStatus does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  FCliTitula does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 
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)Not null  0 
 
New   FCliTitula Numeric (1)Not null  0 
 
 

 
 
Indexes  

  Name Definition Composition  

  CONTSC primary key   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)Not null   
 
  EscaDFech Date Not null   
 
  EscaHFech Date Not null   
 
 

 
 
Indexes  

  Name Definition Composition  

  IESCALA primary key   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)Not null   
 
 

 
 
Indexes  

  Name Definition Composition  

  ESCA primary key   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)Not null   
 
  SperComisi Numeric (6.2)Not null   
 
  SperPiso Numeric (6)Not null   
 
  SPerFBaja Date Not null   
 
  SPerCedula Numeric (7)Not null   
 
 

 
 
Indexes  

  Name Definition Composition  

  ISUPERV primary key   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 Not null   
 
  SPerBaja Date Not null   
 
 

 
 
Indexes  

  Name Definition Composition  

  SCOR primary key   SPerCod  
 Cod_corred  
 
  
 
  SCORCORR duplicate   Cod_corred  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  CORRED Cod_corred  
 
  
 
  SUPERV SPerCod  
 
  
 
 

 
