Table CDOCUM specification   

Table name: CDOCUM 
CDOCUM needs conversion 
 
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   CDOCUM.CDocuFchEm 
 
  CDocuAfcTi Character (7)  CDOCUM.CDocuAfcTi 
 
  CDocuAfcNr Numeric (7)  CDOCUM.CDocuAfcNr 
 
  CDocuAfcFc Date   CDOCUM.CDocuAfcFc 
 
  CDocuMoned Numeric (2)  CDOCUM.CDocuMoned 
 
  CDocuDepos Numeric (3)  CDOCUM.CDocuDepos 
 
  CDocuUltLi Numeric (3)  CDOCUM.CDocuUltLi 
 
  CDocuDto1 Numeric (5.2)  CDOCUM.CDocuDto1 
 
  CDocuDto2 Numeric (5.2)  CDOCUM.CDocuDto2 
 
  CDocuNeto Numeric (12.2)  CDOCUM.CDocuNeto 
 
  CDocuIva Numeric (12.2)  CDOCUM.CDocuIva 
 
  CDocuMerca Numeric (12.2)  CDOCUM.CDocuMerca 
 
  CDocuStatu Numeric (2)  CDOCUM.CDocuStatu 
 
  CDocuComen Character (60)  CDOCUM.CDocuComen 
 
  CDocuPend Numeric (12.2)  CDOCUM.CDocuPend 
 
  CDocuTotal Numeric (12.2)  CDOCUM.CDocuTotal 
 
  C_NCRF_Des Numeric (6.2)  CDOCUM.C_NCRF_Des 
 
  CDocuComet Numeric (7.2)  CDOCUM.CDocuComet 
 
  CLinTUltNr Numeric (3)  CDOCUM.CLinTUltNr 
 
  SucuCod Numeric (3)  CDOCUM.SucuCod 
 
  C_NCRF_Nro Numeric (6)  CDOCUM.C_NCRF_Nro 
 
  CDocuCodIv Numeric (3)  CDOCUM.CDocuCodIv 
 
  CDocuPorIv Numeric (5.2)  CDOCUM.CDocuPorIv 
 
  Cod_sector Numeric (3)  CDOCUM.Cod_sector 
 
  Cod_seccio Numeric (3)  CDOCUM.Cod_seccio 
 
  CarpTipo Character (4)  CDOCUM.CarpTipo 
 
  CarpNro Numeric (9)  CDOCUM.CarpNro 
 
  CDocuFcCot Date   CDOCUM.CDocuFcCot 
 
  CDocuAfFcC Date   CDOCUM.CDocuAfFcC 
 
  CDocuVale Character (1)  CDOCUM.CDocuVale 
 
  CDocuStatD Numeric (2)  CDOCUM.CDocuStatD 
 
New   CDocuApUsu Numeric (3)  Null 
 
New   CDocuApFec Datetime   Null 
 
New   CDocuCoUsu Numeric (3)  Null 
 
New   CDocuCoFec Datetime   Null 
 
New   CDocuPreSt Numeric (2)  Null 
 
 

 
 
Indexes  

  Name Definition Composition  

  CDOC primary key Clustered  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 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

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

 
 
Indexes  

  Name Definition Composition  

  PRFC primary key Clustered  CPrefCod  
 
  
 
 

New   PRFCESCA duplicate   CPrefEScal  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
New   ESCALA CPrefEScal  
 
  
 
 

Table USUARI specification   

Table name: USUARI 
USUARI needs conversion 
 
Table Structure  

  Attribute Definition Previous values Takes value from  

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

 
 
Indexes  

  Name Definition Composition  

  USUA primary key Clustered  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 
 
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)  ESCALON.EscaPct 
 
New   EscaMontoM Numeric (12)  Null 
 
New   EscaMontoU Numeric (12)  Null 
 
 

 
 
Indexes  

  Name Definition Composition  

  ESCA primary key Clustered  EscaCod  
 Escalon  
 
  
 
 
 
Foreign key constraints  

  Referenced table Attributes  
  ESCALA EscaCod  
 
  
 
 

 
