dpclientesdivxtip
[ID]
NUMERO=0335
NOMBRE=DPCLIENTESDIVXTIP
DESCRIPCION=Divisa x Tipo de Documento del Cliente
CONFIG=F
SINGUL=Divisa x Cliente
APLICA=03
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=DXC_CODCLI ,’C’,010,0,”,’Cliente’,1
C002=DXC_CODMON ,’C’,003,0,”,’Divisa’,0
C003=DXC_SELECT ,’L’,001,0,”,’Seleccionado’,0
C004=DXC_TIPDOC ,’C’,003,0,”,’Tipo de Documento’,0
[END_FIELDS]
[TABLE_MAIN]
T001=DPCLIENTES , DXC_CODCLI=CLI_CODIGO <UPDATE> <DELETE> <RUN>
T002=DPTABMON , DXC_CODMON=MON_CODIGO <UPDATE> <DELETE> <RUN>
T003=DPTIPDOCCLI , DXC_TIPDOC=TDC_TIPO <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]
[INNER_JOIN]
SELECT * FROM DPCLIENTESDIVXTIP INNER JOIN DPCLIENTES ON DXC_CODCLI=CLI_CODIGO
SELECT * FROM DPCLIENTESDIVXTIP INNER JOIN DPTABMON ON DXC_CODMON=MON_CODIGO
SELECT * FROM DPCLIENTESDIVXTIP INNER JOIN DPTIPDOCCLI ON DXC_TIPDOC=TDC_TIPO
[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]