dpconretislr
[ID]
NUMERO=0071
NOMBRE=DPCONRETISLR
DESCRIPCION=Conceptos de Retención I.S.L.R.
CONFIG=Y
SINGUL=Concepto Retención
APLICA=19
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=CTR_ACTIVO ,’L’,001,0,”,’Activo’,0
C002=CTR_APLCLI ,’L’,001,0,”,’Aplica con Clientes’,0
C003=CTR_APLPRO ,’L’,001,0,”,’Aplica con Proveedores’,0
C004=CTR_CODIGO ,’C’,003,0,”,’Código’,1
C005=CTR_DESCRI ,’C’,200,0,”,’Descripción’,0
[END_FIELDS]
[TABLE_REL]
T001=DPTARIFASRET , CTR_CODIGO=TBR_CODCON, <UPDATE> <DELETE> <RUN>
[END_TABLE_REL
[INNER_JOIN]
SELECT * FROM DPCONRETISLR INNER JOIN DPTARIFASRET ON TBR_CODCON=CTR_CODIGO
SELECT CTR_DESCRI FROM DPCONRETISLR INNER JOIN DPCTA ON CTR_CODIGO=CTA_CODCON
SELECT CTR_DESCRI FROM DPCONRETISLR INNER JOIN DPTARIFASRET ON CTR_CODIGO=TBR_CODCON
[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]