dpcompvaloragre
[ID]
NUMERO=2511
NOMBRE=DPCOMPVALORAGRE
DESCRIPCION=Composición del Valor Agregado
CONFIG=F
SINGUL=Composición
APLICA=01
PRIMARY_KEY=”
[END_ID]
[FIELDS]
C001=CVA_CODDEP ,’C’,008,0,”,’Código de Departamento’,0
C002=CVA_CODFOR ,’C’,020,0,”,’Código de Fórmula’,0
C003=CVA_CODINV ,’C’,020,0,”,’Código del Producto’,0
C004=CVA_CODVAL ,’C’,008,0,”,’Valor Agregado’,0
C005=CVA_MODO ,’C’,001,0,”,’Absoluto o Relativo’,0
C006=CVA_MONTO ,’N’,014,2,”,’Monto del Valor Agregado’,0
C007=CVA_UNDMED ,’C’,008,0,”,’Unidad de Medida’,0
[END_FIELDS]
[TABLE_MAIN]
T001=DPVALAGREGADO , CVA_CODVAL=VAA_CODIGO <UPDATE> <RUN>
[END_TABLE_MAIN]
[INNER_JOIN]
SELECT * FROM DPCOMPVALORAGRE INNER JOIN DPVALAGREGADO ON CVA_CODVAL=VAA_CODIGO
[END_INNER_JOIN]
[OPTIONS]
C001=CVA_MODO ,Absoluto
C002=CVA_MODO ,Relativo
[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]