dpdesincorpact
[ID]
NUMERO=0525
NOMBRE=DPDESINCORPACT
DESCRIPCION=Desincorporación de Activos
CONFIG=F
SINGUL=Desincorporación
APLICA=06
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=DAC_CODIGO ,’C’,015,0,”,’Código de Activo’,0
C002=DAC_CODSUC ,’C’,006,0,”,’Código de Sucursal’,0
C003=DAC_COMENT ,’C’,040,0,”,’Comentarios’,0
C004=DAC_CONTAB ,’C’,001,0,”,’Contabilizado’,0
C005=DAC_FECHA ,’D’,008,0,”,’Fecha’,0
C006=DAC_NUMCBT ,’C’,008,0,”,’Comprobante Contable’,1
C007=DAC_NUMERO ,’C’,008,0,”,’Número’,1
C008=DAC_TIPO ,’C’,001,0,”,’Total o Parcial’,0
[END_FIELDS]
[TABLE_MAIN]
T001=DPACTIVOS , DAC_CODIGO=ATV_CODIGO <UPDATE> <DELETE> <RUN>
T002=DPACTIVOS , DAC_CODSUC,DAC_CODIGO=ATV_CODSUC,ATV_CODIGO <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]
[LINK_VIRTUAL]
T001=DPACTIVOS , DAC_CODIGO=ATV_CODIGO, <CAMPO:ATV_DESCRI>, <WHERE:>
T002=DPDEPRECIAACT , DAC_NUMERO=DEP_NUMDES, <CAMPO:DEP_NUMERO>, <WHERE:>
[END_LINK_VIRTUAL]
[INNER_JOIN]
SELECT * FROM DPDESINCORPACT INNER JOIN DPACTIVOS ON DAC_CODIGO=ATV_CODIGO
SELECT * FROM DPDESINCORPACT INNER JOIN DPACTIVOS ON DAC_CODSUC=ATV_CODSUC AND DAC_CODIGO=ATV_CODIGO
SELECT ATV_DESCRI FROM DPDESINCORPACT INNER JOIN DPACTIVOS ON ATV_CODIGO=DAC_CODIGO
SELECT DEP_NUMERO FROM DPDESINCORPACT INNER JOIN DPDEPRECIAACT ON DEP_NUMDES=DAC_NUMERO
[END_INNER_JOIN]
[OPTIONS]
[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]