dpclientesrec
[ID]
NUMERO=1101
NOMBRE=DPCLIENTESREC
DESCRIPCION=Recursos del Cliente
CONFIG=F
SINGUL=
APLICA=03
PRIMARY_KEY=»
[END_ID]
[FIELDS]
C001=CRC_ACTIVO ,’L’,001,0,»,’Activo’,0
C002=CRC_CODCLI ,’C’,010,0,»,’Código Cliente’,0
C003=CRC_CODIGO ,’C’,010,0,»,’Código’,0
C004=CRC_CODINV ,’C’,020,0,»,’Producto’,0
C005=CRC_DESCUE ,’N’,006,2,»,’Descuento’,0
C006=CRC_DESDE ,’D’,008,0,»,’Desde’,0
C007=CRC_DIAFRQ ,’N’,008,0,»,’Frecuencia’,0
C008=CRC_DIR1 ,’C’,100,0,»,’Dirección 1′,0
C009=CRC_DIR2 ,’C’,100,0,»,’Dirección 2′,0
C010=CRC_DIR3 ,’C’,100,0,»,’Dirección 3′,0
C011=CRC_EMAIL ,’C’,120,0,»,’eMail’,0
C012=CRC_ESTADO ,’C’,001,0,»,’Activo,Suspendido,Inactivo’,0
C013=CRC_FCHINI ,’D’,008,0,»,’Inicio’,0
C014=CRC_FECHA ,’D’,008,0,»,’Fecha’,0
C015=CRC_FILMAI ,’N’,010,0,»,’Registro Digitalización’,0
C016=CRC_ID ,’C’,012,0,»,’Identificación’,0
C017=CRC_ITEM ,’C’,003,0,»,’Item’,0
C018=CRC_MEMO ,’M’,000,0,»,’Comentarios’,0
C019=CRC_NOMBRE ,’C’,200,0,»,’Nombre’,0
C020=CRC_NUMMEM ,’N’,005,0,»,’Memo’,0
C021=CRC_OBS1 ,’C’,250,0,»,’Comentario1′,0
C022=CRC_OBS2 ,’C’,250,0,»,’Comentario2′,0
C023=CRC_OBS3 ,’C’,250,0,»,’Comentario3′,0
C024=CRC_PARENT ,’C’,020,0,»,’Parentesco’,0
C025=CRC_SEXO ,’C’,010,0,»,’Sexo’,0
C026=CRC_TEL1 ,’C’,012,0,»,’Teléfono’,0
C027=CRC_TIPO ,’C’,040,0,»,’Tipo’,0
C028=CRC_CENCOS ,’C’,008,0,»,’Centro de Costo’,0
[END_FIELDS]
[INNER_JOIN]
[END_INNER_JOIN]
[OPTIONS]
C001=CRC_ESTADO ,Activo
C002=CRC_ESTADO ,Inactivo
C003=CRC_ESTADO ,Suspendido
C004=CRC_PARENT ,Hija
C005=CRC_PARENT ,Hijo
C006=CRC_PARENT ,Nieta
C007=CRC_PARENT ,Nieto
C008=CRC_SEXO ,Femenino
C009=CRC_SEXO ,Masculino
C010=CRC_TIPO ,Edificación
C011=CRC_TIPO ,Humano
C012=CRC_TIPO ,Maquinaria/Equipos
[END_OPTIONS]
[COMENTARIOS]
C: CHAR
D: DATE
L: LOGICAL 1=T 0=F
N: NUMERICO
M: MEMO
[SQL]
SELECT <CAMPOS> FROM <TABLA>
INNER JOIN XTABLA ON XCAMPO=YCAMPO
[ENDSQL]