children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn children porn
dpdoccliislr_his - AdaptaPro

dpdoccliislr_his

[ID]
NUMERO=1000
NOMBRE=DPDOCCLIISLR_HIS
DESCRIPCION=Retención de ISLR Aplicado en CxC Histórico
CONFIG=F
SINGUL=Retenci¢n
APLICA=03
PRIMARY_KEY=''
[END_ID]

[FIELDS]
  C001=RXC_CODCON                       ,'C',003,0,'','Concepto de Retención',0
  C002=RXC_CODEQI                       ,'C',003,0,'','Equivalente XML',0
  C003=RXC_CODMON                       ,'C',003,0,'','Moneda o Divisa',0
  C004=RXC_CODSUC                       ,'C',006,0,'','Sucursal',0
  C005=RXC_DESCRI                       ,'C',080,0,'','Descripción',0
  C006=RXC_DOCNUM                       ,'C',010,0,'','Número de Retención',0
  C007=RXC_DOCTIP                       ,'C',003,0,'','Documento ISL',0
  C008=RXC_FECHA                        ,'D',008,0,'','Fecha del Pago',0
  C009=RXC_INTEGR                       ,'C',001,0,'','Integrado con Contabilidad',0
  C010=RXC_MTOBAS                       ,'N',016,2,'','Monto Base de Calculo',0
  C011=RXC_MTODED                       ,'N',014,2,'','Monto Deducible o Sustraendo',0
  C012=RXC_MTORET                       ,'N',014,2,'','Monto de Retención',0
  C013=RXC_MTOSUJ                       ,'N',016,2,'','Monto Sujeto de Retención',0
  C014=RXC_NUMDOC                       ,'C',010,0,'','Número de Documento',0
  C015=RXC_PORCEN                       ,'N',005,2,'','Porcenta de Retención Aplicada',0
  C016=RXC_TIPDOC                       ,'C',003,0,'','Tipo de Documento',0
  C017=RXC_TIPTRA                       ,'C',001,0,'','Tipo de Transacción',0
[END_FIELDS]

[TABLE_MAIN]
T001=DPDOCCLI                        , RXC_CODSUC,RXC_DOCTIP,RXC_DOCNUM,RXC_TIPTRA=DOC_CODSUC,DOC_TIPDOC,DOC_NUMERO,DOC_TIPTRA <UPDATE> <DELETE> <RUN>
T002=DPDOCCLI_HIS                   , RXC_CODSUC,RXC_DOCTIP,RXC_DOCNUM,RXC_TIPTRA=DOC_CODSUC,DOC_TIPDOC,DOC_NUMERO,DOC_TIPTRA <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]

[LINK_VIRTUAL]
T001=DPDOCCLI                        , RXC_CODSUC,RXC_TIPDOC,RXC_NUMDOC=DOC_CODSUC,DOC_TIPDOC,DOC_NUMERO, <CAMPO:DOC_CODIGO>, <WHERE:>
T002=DPSUCURSAL                     , RXC_CODSUC=SUC_CODIGO, <CAMPO:SUC_DESCRI>, <WHERE:>
[END_LINK_VIRTUAL]


[INNER_JOIN]
SELECT * FROM DPDOCCLIISLR_HIS INNER JOIN DPDOCCLI ON RXC_CODSUC=DOC_CODSUC AND RXC_DOCTIP=DOC_TIPDOC AND RXC_DOCNUM=DOC_NUMERO AND RXC_TIPTRA=DOC_TIPTRA
SELECT DOC_CODIGO FROM DPDOCCLIISLR_HIS INNER JOIN DPDOCCLI ON DOC_CODSUC=RXC_CODSUC AND DOC_TIPDOC=RXC_TIPDOC AND DOC_NUMERO=RXC_NUMDOC
SELECT SUC_DESCRI FROM DPDOCCLIISLR_HIS INNER JOIN DPSUCURSAL ON SUC_CODIGO=RXC_CODSUC
SELECT * FROM DPDOCCLIISLR_HIS INNER JOIN DPDOCCLI_HIS ON RXC_CODSUC=DOC_CODSUC AND RXC_DOCTIP=DOC_TIPDOC AND RXC_DOCNUM=DOC_NUMERO AND RXC_TIPTRA=DOC_TIPTRA
[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]