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]