[ID]
NUMERO=0331
NOMBRE=DPCLIENTESCERO
DESCRIPCION=Clientes Genéricos o Código Cero
CONFIG=F
SINGUL=Cliente Genérico
APLICA=03
PRIMARY_KEY=''
[END_ID]
[FIELDS]
C001=CCG_ACTECO ,'C',200,0,'','',0
C002=CCG_ACTIVI ,'C',006,0,'','',0
C003=CCG_AM_F ,'C',005,0,'','',0
C004=CCG_AM_I ,'C',005,0,'','',0
C005=CCG_AREA ,'C',004,0,'','Cód. Area',0
C006=CCG_CAPPAG ,'N',019,2,'','',0
C007=CCG_CAPSUS ,'N',019,2,'','',0
C008=CCG_CATEGO ,'C',001,0,'','',0
C009=CCG_CDESC ,'C',030,0,'','',0
C010=CCG_CELUL1 ,'C',015,0,'','Celular (Movil)',0
C011=CCG_CELUL2 ,'C',015,0,'','',0
C012=CCG_CLAVE ,'C',010,0,'','',0
C013=CCG_CODCLA ,'C',006,0,'','',0
C014=CCG_CODCOB ,'C',006,0,'','',0
C015=CCG_CODIGO ,'C',010,0,'','',0
C016=CCG_CODMON ,'C',003,0,'','',0
C017=CCG_CODPER ,'C',006,0,'','',0
C018=CCG_CODSUC ,'C',006,0,'','Sucursal',1
C019=CCG_CODVEN ,'C',006,0,'','',0
C020=CCG_CONDIC ,'C',030,0,'','',0
C021=CCG_CONESP ,'C',001,0,'','',0
C022=CCG_CONTRI ,'C',001,0,'','',0
C023=CCG_CORPRY ,'C',006,0,'','',0
C024=CCG_CUENTA ,'C',020,0,'','',0
C025=CCG_DESCUE ,'N',019,2,'','',0
C026=CCG_DIACAJ ,'C',010,0,'','',0
C027=CCG_DIAFIN ,'N',019,0,'','',0
C028=CCG_DIAINI ,'N',019,0,'','',0
C029=CCG_DIAS ,'N',019,0,'','',0
C030=CCG_DIAVEN ,'N',000,0,'','',0
C031=CCG_DIR1 ,'C',050,0,'','Dirección Línea 1',0
C032=CCG_DIR2 ,'C',050,0,'','Dirección Línea 2',0
C033=CCG_DIR3 ,'C',050,0,'','Dirección Línea 3',0
C034=CCG_DIR4 ,'C',050,0,'','Dirección Línea 4',0
C035=CCG_DIR5 ,'C',050,0,'','Dirección 5',0
C036=CCG_EMAIL ,'C',070,0,'','',0
C037=CCG_ENOTRA ,'C',001,0,'','',0
C038=CCG_ESTADO ,'C',020,0,'','',0
C039=CCG_FCHCIE ,'D',008,0,'','',0
C040=CCG_FCHUPD ,'D',008,0,'','',0
C041=CCG_FECHA ,'D',000,0,'','',0
C042=CCG_FILBMP ,'C',030,0,'','',0
C043=CCG_FILMAI ,'N',019,0,'','',0
C044=CCG_GACETA ,'C',006,0,'','',0
C045=CCG_GACFCH ,'D',008,0,'','',0
C046=CCG_HORACJ ,'C',008,0,'','',0
C047=CCG_INVMON ,'C',003,0,'','',0
C048=CCG_LIMITE ,'N',019,2,'','',0
C049=CCG_LISTA ,'C',001,0,'','',0
C050=CCG_LOGIN ,'C',015,0,'','',0
C051=CCG_LOPTI ,'C',001,0,'','',0
C052=CCG_MARCA ,'C',080,0,'','',0
C053=CCG_MESCIE ,'C',012,0,'','',0
C054=CCG_MTOVEN ,'N',019,2,'','',0
C055=CCG_MUNICI ,'C',020,0,'','',0
C056=CCG_NIT ,'C',015,0,'','NIT',0
C057=CCG_NOMBRE ,'C',060,0,'','Nombre',0
C058=CCG_NUMDOC ,'C',010,0,'','Número de Documento',1
C059=CCG_NUMMEM ,'N',019,0,'','',0
C060=CCG_OBS1 ,'C',025,0,'','',0
C061=CCG_OBS2 ,'C',025,0,'','',0
C062=CCG_PAGDOM ,'L',001,0,'','',0
C063=CCG_PAGJUE ,'L',001,0,'','',0
C064=CCG_PAGLUN ,'L',001,0,'','',0
C065=CCG_PAGMAR ,'L',001,0,'','',0
C066=CCG_PAGMIE ,'L',001,0,'','',0
C067=CCG_PAGSAB ,'L',001,0,'','',0
C068=CCG_PAGVIE ,'L',001,0,'','',0
C069=CCG_PAIS ,'C',020,0,'','',0
C070=CCG_PARROQ ,'C',020,0,'','',0
C071=CCG_PM_F ,'C',005,0,'','',0
C072=CCG_PM_I ,'C',005,0,'','',0
C073=CCG_PRECIO ,'C',001,0,'','',0
C074=CCG_REGMER ,'C',030,0,'','',0
C075=CCG_RESIDE ,'C',001,0,'','',0
C076=CCG_RETIVA ,'N',019,2,'','',0
C077=CCG_RIF ,'C',015,0,'','RIF',0
C078=CCG_RIFVAL ,'L',001,0,'','',0
C079=CCG_SITUAC ,'C',001,0,'','',0
C080=CCG_TEL1 ,'C',012,0,'','Teléfono 1',0
C081=CCG_TEL2 ,'C',012,0,'','Teléfono 2',0
C082=CCG_TEL3 ,'C',012,0,'','Teléfono 3',0
C083=CCG_TEL4 ,'C',012,0,'','',0
C084=CCG_TEL5 ,'C',012,0,'','',0
C085=CCG_TEL6 ,'C',012,0,'','',0
C086=CCG_TERCER ,'C',001,0,'','',0
C087=CCG_TIPDOC ,'C',003,0,'','Tipo de Documento',0
C088=CCG_TIPPER ,'C',001,0,'','',0
C089=CCG_TIPTRA ,'C',001,0,'','Tipo de Transacción',0
C090=CCG_TRANSP ,'N',019,2,'','',0
C091=CCG_USUARI ,'C',003,0,'','',0
C092=CCG_VACFIN ,'D',008,0,'','',0
C093=CCG_VACINI ,'D',008,0,'','',0
C094=CCG_VALRIF ,'L',001,0,'','',0
C095=CCG_WEB ,'C',050,0,'','',0
C096=CCG_ZONANL ,'C',001,0,'','',0
C097=CCG_PAGELE ,'L',001,0,'','Pago Electrónico',0
[END_FIELDS]
[TABLE_MAIN]
T001=DPDOCCLI , CCG_CODSUC,CCG_TIPDOC,CCG_NUMDOC,CCG_TIPTRA=DOC_CODSUC,DOC_TIPDOC,DOC_NUMERO,DOC_TIPTRA <UPDATE> <DELETE> <RUN>
[END_TABLE_MAIN]
[INNER_JOIN]
SELECT * FROM DPCLIENTESCERO INNER JOIN DPDOCCLI ON CCG_CODSUC=DOC_CODSUC AND CCG_TIPDOC=DOC_TIPDOC AND CCG_NUMDOC=DOC_NUMERO AND CCG_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]
