dpcbte_prog
[ID]
NUMERO=1101
NOMBRE=DPCBTE_PROG
DESCRIPCION=Comprobante Contable Histórico
CONFIG=F
SINGUL=Comprobante
APLICA=05
PRIMARY_KEY=’CBT_CODSUC,CBT_ACTUAL,CBT_FECHA,CBT_NUMERO’
[END_ID]
[FIELDS]
C001=CBT_ACTUAL ,’C’,001,0,”,’Actualizado’,0
C002=CBT_CODEMP ,’C’,004,0,”,’Código de Empresa’,0
C003=CBT_CODMON ,’C’,003,0,”,’Código Divisa’,0
C004=CBT_CODSUC ,’C’,006,0,”,’Sucursal’,0
C005=CBT_COMEN1 ,’C’,060,0,”,’Comentario’,0
C006=CBT_COMEN2 ,’C’,060,0,”,’Comentario Línea 2′,0
C007=CBT_FECHA ,’D’,008,0,”,’Fecha’,0
C008=CBT_FILMAI ,’N’,007,0,”,’Digitalización’,0
C009=CBT_NUMEJE ,’C’,004,0,”,’Número del Ejercicio’,0
C010=CBT_NUMERO ,’C’,008,0,”,’Número’,0
C011=CBT_NUMMEM ,’N’,006,0,”,’Número del Memo’,0
C012=CBT_ORIGEN ,’C’,003,0,”,’Origen’,0
C013=CBT_REGAUD ,’N’,008,0,”,’Registro de Auditoría’,0
C014=CBT_VALCAM ,’N’,017,2,”,’Valor Cambiario’,0
[END_FIELDS]
[INNER_JOIN]
[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]