Table CDOCUM specification   

Table name: CDOCUM 
CDOCUM needs conversion 
 
Warnings  

 rgz0007 Attribute  CDocuApUsu does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  CDocuApFec does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  CDocuCoUsu does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  CDocuCoFec does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  CDocuPreSt 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  

  CDocuTip Character (7)Not null  CDOCUM.CDocuTip 
 
  CDocuNro Numeric (7)Not null  CDOCUM.CDocuNro 
 
  Nro_acreed Numeric (6)Not null  CDOCUM.Nro_acreed 
 
  CDocuFchEm Date Not null  CDOCUM.CDocuFchEm 
 
  CDocuAfcTi Character (7)Not null  CDOCUM.CDocuAfcTi 
 
  CDocuAfcNr Numeric (7)Not null  CDOCUM.CDocuAfcNr 
 
  CDocuAfcFc Date Not null  CDOCUM.CDocuAfcFc 
 
  CDocuMoned Numeric (2)Not null  CDOCUM.CDocuMoned 
 
  CDocuDepos Numeric (3)Not null  CDOCUM.CDocuDepos 
 
  CDocuUltLi Numeric (3)Not null  CDOCUM.CDocuUltLi 
 
  CDocuDto1 Numeric (5.2)Not null  CDOCUM.CDocuDto1 
 
  CDocuDto2 Numeric (5.2)Not null  CDOCUM.CDocuDto2 
 
  CDocuNeto Numeric (12.2)Not null  CDOCUM.CDocuNeto 
 
  CDocuIva Numeric (12.2)Not null  CDOCUM.CDocuIva 
 
  CDocuMerca Numeric (12.2)Not null  CDOCUM.CDocuMerca 
 
  CDocuStatu Numeric (2)Not null  CDOCUM.CDocuStatu 
 
  CDocuComen Character (60)Not null  CDOCUM.CDocuComen 
 
  CDocuPend Numeric (12.2)Not null  CDOCUM.CDocuPend 
 
  CDocuTotal Numeric (12.2)Not null  CDOCUM.CDocuTotal 
 
  C_NCRF_Des Numeric (6.2)Not null  CDOCUM.C_NCRF_Des 
 
  CDocuComet Numeric (7.2)Not null  CDOCUM.CDocuComet 
 
  CLinTUltNr Numeric (3)Not null  CDOCUM.CLinTUltNr 
 
  SucuCod Numeric (3)Not null  CDOCUM.SucuCod 
 
  C_NCRF_Nro Numeric (6)Not null  CDOCUM.C_NCRF_Nro 
 
  CDocuCodIv Numeric (3)Not null  CDOCUM.CDocuCodIv 
 
  CDocuPorIv Numeric (5.2)Not null  CDOCUM.CDocuPorIv 
 
  Cod_sector Numeric (3)Not null  CDOCUM.Cod_sector 
 
  Cod_seccio Numeric (3)Not null  CDOCUM.Cod_seccio 
 
  CarpTipo Character (4)Not null  CDOCUM.CarpTipo 
 
  CarpNro Numeric (9)Not null  CDOCUM.CarpNro 
 
  CDocuFcCot Date Not null  CDOCUM.CDocuFcCot 
 
  CDocuAfFcC Date Not null  CDOCUM.CDocuAfFcC 
 
  CDocuVale Character (1)Not null  CDOCUM.CDocuVale 
 
  CDocuStatD Numeric (2)Not null  CDOCUM.CDocuStatD 
 
New   CDocuApUsu Numeric (3)Not null  0 
 
New   CDocuApFec Datetime Not null  ymdtod(0001,1,1) 
 
New   CDocuCoUsu Numeric (3)Not null  0 
 
New   CDocuCoFec Datetime Not null  ymdtod(0001,1,1) 
 
New   CDocuPreSt Numeric (2)Not null  0 
 
 

 
 
Indexes  

  Name Definition Composition  

  CDOC primary key   CDocuTip  
 CDocuNro  
 Nro_acreed  
 
  
 
  CDOCIVAS duplicate   CDocuCodIv  
 
  
 
  CDOCMONE duplicate   CDocuMoned  
 
  
 
  CDOCCDSU duplicate   CDocuTip  
 SucuCod  
 
  
 
  ACRFECH duplicate   Nro_acreed  
 CDocuFchEm  
 
  
 
  CDOCFECH duplicate   CDocuFchEm  
 CDocuTip  
 CDocuNro  
 
  
 
  CDOCAFEC duplicate   CDocuAfcTi  
 CDocuAfcNr  
 
  
 
  CDOCCARP duplicate   CarpTipo  
 CarpNro  
 
  
 
  CDOCSESE duplicate   Cod_sector  
 Cod_seccio  
 
  
 
  CDOCAKTI duplicate   Nro_acreed  
 CDocuTip  
 
  
 
  CDOCSTFE duplicate   CDocuStatu  
 CDocuFchEm  
 
  
 
 

New   CDOCAPUS duplicate   CDocuApUsu  
 
  
 
New   CDOCCOUS duplicate   CDocuCoUsu  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  IVAS CDocuCodIv  
 
  
 
  MONEDA CDocuMoned  
 
  
 
  FOLDER CarpTipo  
CarpNro  
 
  
 
  SEKSEC Cod_sector  
Cod_seccio  
 
  
 
  CDSUC CDocuTip  
SucuCod  
 
  
 
  ACREED Nro_acreed  
 
  
 
  SUCU SucuCod  
 
  
 
  CDOCUT CDocuTip  
 
  
 
  SECCIO Cod_seccio  
 
  
 
  SECTOR Cod_sector  
 
  
 
  CARPTI CarpTipo  
 
  
 
New   USUARI CDocuApUsu  
 
  
 
New   USUARI CDocuCoUsu  
 
  
 
 

Table PREFCO specification   

Table name: PREFCO 
PREFCO needs conversion 
 
Warnings  

 rgz0007 Attribute  CPrefEScal 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  

  CPrefCod Numeric (1)Not null  PREFCO.CPrefCod 
 
  CPrefCAuto Character (1)Not null  PREFCO.CPrefCAuto 
 
  CPrefMaxLi Numeric (3)Not null  PREFCO.CPrefMaxLi 
 
  CPrefViaUn Character (30)Not null  PREFCO.CPrefViaUn 
 
  CPrefCantV Numeric (1)Not null  PREFCO.CPrefCantV 
 
  CPrefCtrlC Character (1)Not null  PREFCO.CPrefCtrlC 
 
  CPrefAsien Character (1)Not null  PREFCO.CPrefAsien 
 
  CPrefCPrec Character (1)Not null  PREFCO.CPrefCPrec 
 
  CPrefCarpA Character (1)Not null  PREFCO.CPrefCarpA 
 
  CPrefSectA Character (1)Not null  PREFCO.CPrefSectA 
 
  CPrefBltsA Character (1)Not null  PREFCO.CPrefBltsA 
 
  CPrefDtoLA Character (1)Not null  PREFCO.CPrefDtoLA 
 
  CPrefVenci Character (1)Not null  PREFCO.CPrefVenci 
 
  CPrefEntre Character (1)Not null  PREFCO.CPrefEntre 
 
  CPrefTexto Character (1)Not null  PREFCO.CPrefTexto 
 
  CPrefMemo Long varchar Not null  PREFCO.CPrefMemo 
 
  CPrefCriPV Character (1)Not null  PREFCO.CPrefCriPV 
 
  CPrefStock Character (1)Not null  PREFCO.CPrefStock 
 
  CPrefDepoA Character (1)Not null  PREFCO.CPrefDepoA 
 
  CPrefORDCM Character (1)Not null  PREFCO.CPrefORDCM 
 
  CPrefFcCot Character (1)Not null  PREFCO.CPrefFcCot 
 
New   CPrefEScal Numeric (4)Not null  0 
 
 

 
 
Indexes  

  Name Definition Composition  

  PRFC primary key   CPrefCod  
 
  
 
 

New   PRFCESCA duplicate   CPrefEScal  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
New   ESCALA CPrefEScal  
 
  
 
 

Table USUARI specification   

Table name: USUARI 
USUARI needs conversion 
 
Warnings  

 rgz0007 Attribute  EscaCod does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  Escalon 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  

  UsuaCod Numeric (3)Not null  USUARI.UsuaCod 
 
  UsuaNom Character (10)Not null  USUARI.UsuaNom 
 
  UsuaPwd Character (10)Not null  USUARI.UsuaPwd 
 
  UsuaNoLogi Character (1)Not null  USUARI.UsuaNoLogi 
 
  UsuaFecBaj Date Not null  USUARI.UsuaFecBaj 
 
  UsuaPwdFec Date Not null  USUARI.UsuaPwdFec 
 
New   EscaCod Numeric (4)Not null  0 
 
New   Escalon Numeric (10.2)Not null  0 
 
 

 
 
Indexes  

  Name Definition Composition  

  USUA primary key   UsuaCod  
 
  
 
  USUANOMB duplicate   UsuaNom  
 
  
 
 

New   USUAESCA duplicate   EscaCod  
 Escalon  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
New   ESCALON EscaCod  
Escalon  
 
  
 
New   ESCALA EscaCod  
 
  
 
 

Table ESCALON specification   

Table name: ESCALON 
ESCALON needs conversion 
 
Warnings  

 rgz0007 Attribute  EscaMontoM does not allow nulls and has not a Initial Value. An empty default value will be used. 
 
 rgz0007 Attribute  EscaMontoU 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  

  EscaCod Numeric (4)Not null  ESCALON.EscaCod 
 
  Escalon Numeric (10.2)Not null  ESCALON.Escalon 
 
  EscaPct Numeric (5.2)Not null  ESCALON.EscaPct 
 
New   EscaMontoM Numeric (12)Not null  0 
 
New   EscaMontoU Numeric (12)Not null  0 
 
 

 
 
Indexes  

  Name Definition Composition  

  ESCA primary key   EscaCod  
 Escalon  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  ESCALA EscaCod  
 
  
 
 

 
