...
Diccionario de Datos
Relacionamientos (SX9)
| Estado | País | Tabla (X9_CDOM) | Dominio (X9_DOM) | Exp. Dominio (X9_EXPDOM) | Exp. CDominio (X9_EXPCDOM) | Tp. Lig. Dom. (X9_LIGDOM) | Tp. Lig. Cdom. (X9_LIGCDOM) | Usa Filial (X9_USEFIL) | Cond. SQL (X9_CONDSQL) | Habilitado (X9_ENABLE) |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM | RBA | RBA | RBA_CODRES | RBA_CODSUP | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM | SQ3 | RB6 | RB6_TABELA+RB6_NIVEL+RB6_CLASSE | Q3_TABELA+Q3_TABNIVE+Q3_CLASSE | 1 | N | S |
| S |
| Se agrega | ARG, PER, DOM, PAR, CHI, COL | RC0 | SA2 | A2_COD+A2_LOJA | RC0_FORNEC+RC0_LOJA | 1 | N | S |
| S |
| Se agrega | PER, DOM, PAR, CHI, COL | RC0 | SX5 | X5_TABELA+X5_CHAVE | '05'+RC0_TIPO | 1 | N | S |
| S |
| Se agrega | PER, DOM, CHI,COL | RC1 | RC0 | RC0_CODTIT | RC1_CODTIT | 1 | N | S |
| S |
| Se agrega | PER, DOM, PAR, CHI, COL | RCE | SWY | WY_CODIGO | RCE_CCT | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | RCH | RCJ | RCJ_CODIGO | RCH_PROCES | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM | RCH | RG5 | RG5_PDPERI | RCH_PDPERI | 1 | N | S |
| S |
| Se sustituye | COL | RCJ | RCH | RCH_PER | RCJ_PERPRI | 1 | N | S |
| N |
| Se sustituye | COL | RCJ | RCH | RCH_NUMPAG | RCJ_PAGPRI | 1 | N | S |
| N |
| Se agrega | COL | RCJ | RCH | RCH_PROCES+RCH_PER+RCH_NUMPAG | RCJ_CODIGO+RCJ_PERPRI+RCJ_PAGPRI | 1 | N | S |
| S |
| Se |
agrega, DOMRCKSRVRVCODRCKPDJURO agregaCOL, , PER, DOMRCKSRYRYCALCULORCKCALCULCOLRCLRGC | RGC_KEYLOC | | RCO | RCO_ATIVID+RCO_CODIGO | '5'+RCJ_CCAF |
RCL_LOCPAGPER, DOM, COLCC2 | CC2_CODMUN | | RCO_ATIVID+RCO_CODIGO | '4'+RCJ_MUTUAL |
RCO_MUNICCOL PARRCPRGCRGCKEYLOCRCPKEYLOC| PDJURO | 1 | N | S |
| S |
| Se agrega | COL, CHI, PER, DOM |
RCYSRVRVCODRCYPD, CHI, PAR, PER, DOM | RCL | RGC | RGC_KEYLOC | RCL_LOCPAG |
RE0 | RE1 | RE1_COMAR+RE1_VARA | RE0_COMAR+RE0_VARACHI | RE0 | RE1 | RE1_VARA | | PER, DOM, COL | RCO | CC2 | CC2_CODMUN | RCO_MUNIC |
RE0_VARA CHI, , PER, DOMREARD0RD0CODIGOREAADRDACCOL, , PAR, PER, DOM | RCY | SRV | RV_COD | RCY_PD | 1 | N | S |
| S |
| Se deshabilita | ALL | RE0 | RE1 | RE1_CARA | RE0_VARA |
REA | RD0 | RD0_CODIGO | REA_ADRTEC | 1 | N | S |
| N |
| Se agrega | COL, CHI, PAR, PER, DOM |
REARD0 | RD0_CODIGO | | RE1 | RE1_COMAR+RE1_VARA | RE0_COMAR+RE0_VARA |
REA_PRECOD sustituyeMEX, ARGREARE5RE5_TABELA+RE5_CODIGO | 'REA'+REA_TIPOARG, MEX, | COL, CHI, PAR, PER, DOM | REA |
RE5 | RE5_TABELA+RE5' '+REATIPOARG, MEX, | COL, CHI, PAR, PER, DOM | REA |
RE5RE5TABELA+RE5_'REF '+FASECD| ADRTEC | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
REBSWYWYREBCODCCT agregaCOL, CHI, PAR, PER, DOM | REL | RD0 | RD0_CODIGO | | MEX, ARG | REA | RE5 | RE5_TABELA+RE5_CODIGO | 'REA'+REA_TIPO |
REL_PARAD1 | 1 | N | S |
| N |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
RELRD0 | RD0REL_PARAD2| 'REA '+REA_TIPO | 1 | N | S |
| S |
| Se agrega |
COL| ARG, MEX, COL, CHI, PAR, PER, DOM |
RELRD0 | RD0REL_PARAD3| 'REF '+REA_FASECD | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RELRD0RD0RELRECLAM sustituye| agrega | COL, CHI, PAR, PER, DOM |
ARG, MEXRE5 | RE5_TABELA+RE5'RE0'+PROGNARG MEX, COL, RE5RE5TABELA+RE5_'RE0 '+PROGN sustituye| agrega | COL, CHI, PAR, PER, DOM |
ARG, MEXRE5RE5TABELA+RE5_'RSP'+RESULT sustituyeMEX| agrega | COL, CHI, PAR, PER, DOM | REL |
RE5RE5_TABELA+RE5_CODIGO | 'RSP'+REL_TPPLTP agrega, COL, CHI, PAR, PER, DOM | REL | RE5 | RE5_TABELA+RE5_CODIGO | ' |
RSP RESULT| PROGN | 1 | N | S |
| N |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
REORD0 | RD0REO_CODADV agregaREORD0Se agrega | COL, CHI, PAR, PER, DOM | REO | RE5 | RD0_CODIGO | REO_CODADV | 1 | N | S | REO_FASECD agregaCHIREO| REL | RE5 | RE5_TABELA+RE5_CODIGO |
REO_TIPO| 'RSP'+REL_TPPLTP | 1 | N | S |
| N |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
REO| REL | RE5 | RE5_TABELA+RE5_CODIGO | ' |
REF REOFASECD agregaCOL, CHI, PAR, PER, DOMRE5_TABELA+'REO '+ agregaCOL, CHI, PAR, PER, DOM | RES | RD0 | RD0_CODIGO | | ARG, MEX | REO | RE4 | RE4_CODADV | REO_CODADV |
RES_PERITO | 1 | N | S |
| N |
| Se agrega | COL, CHI, PAR, PER, DOM, ARG, MEX |
RESRE5RE5RESFASECD| CODADV | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RESTABELA+RE5_'REF '+RESCOL, , PAR, PER, DOMRFQ | RCJ | RCJRFQPROCES| TIPO | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RG1| REO | RE5 | RE5_TABELA+RE5_CODIGO | ' |
S001RG1TPBLEG| FASECD | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RG1| REO | RE5 | RE5_TABELA+RE5_CODIGO | ' |
S002RG1TPDATO| TIPO | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RG1RG0RG0_NRBLEG+RG0_TPBLEG | RG1_NRBLEG+RG1_TPBLEG| RD0_CODIGO | RES_PERITO | 1 | N | S |
| S |
| Se |
agregaRG1 | SA6 | A6_COD+A6_AGENCIA | RG1_BCODEP+RG1_BCODEP| , CHI, PAR, PER, DOM | RES | RE5 | RE5_CODIGO | RES_FASECD | 1 | N | S |
| N |
| Se agrega | COL, CHI, PAR, PER, DOM |
RG3RFQRFQPROCESRFQPERIODRG3_PROCES+RG3_PERIOD | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RG7RG9RG9CODCRIRG7CODCRICHI | RG8 | RCH | RCH_PROCES | | COL, PAR, DOM | RG1 | RE5 | RE5_TABELA+RE5_CODIGO | 'S001'+RG1_TPBLEG |
RG8_PERORI CHI, PAR, PER, DOM| DOM | RG1 | RE5 | RE5_TABELA+RE5_CODIGO | 'S002'+RG1_TPDATO |
RGB | RCH | RCH_PROCES | RGB_PERIOD CHI PERRGBSQB | QB_DEPTO | | RG0 | RG0_NRBLEG+RG0_TPBLEG | RG1_NRBLEG+RG1_TPBLEG |
RGB_DEPTO, CHI, PAR, PER | RG1 | SA6 | A6_COD+A6_AGENCIA | RG1_BCODEP+RG1_BCODEP |
RGB | SRA | RA_MAT | RGB_MAT | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RGFSRV | RV_COD | | RFQ | RFQ_PROCES+RFQ_PERIOD | RG3_PROCES+RG3_PERIOD |
RGF_BASVER | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
RGFSRVRVCODRGFCODVERRGVCTTCTTCUSTORGVCC| PERORI | 1 | N | S |
| S |
| Se agrega | COL, CHI |
RGV | SRV | RV_COD | | , PAR, PER, DOM | RGB | RCH | RCH_PROCES | RGB_PERIOD |
RGV_PD, PAR, DOMRH3RDKRDKCODIGORH3VISAO| DEPTO | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER |
, DOMRI4SWYWYCODIGORI4CODCCT CHI, PAR, , DOMRJ1RCJRCJCODIGORJ1PROCESSe agrega | ALL | RJ2 | SRA | RA_FILIAL+RA_MAT | RJ2_FILSUB+RJ2_MATSUB | 1 | N | N | ARG, MEX, , CHI, PAR, DOMRUERUEPDADIARG, MEX, COL, , PAR, PER, DOMRUE | SRV | RV_COD | RUE_PDRESARG, MEX, COL, , PAR, PER, DOMRUERUEVERBAARG, MEX, SP7RCHRCH_PROCES+RCH_PER | RA_PROCES+P7_PERIOD | | RDK_CODIGO | RH3_VISAO | 1 | N | S |
| S |
| Se agrega | COL |
SQZ | SA6 | A6_COD+A6_AGENCIA | | , CHI, PAR, PER, DOM | RI4 | SWY | WY_CODIGO | RI4_CODCCT |
QZ_BCOAGENARG, MEX, SR0RCHRCH_PROCES+RCH_PER+RCH_NUMPAG | RA_PROCES+R0_PERIOD+R0_NROPGT agregaCOL, PER, DOM | SR8 | RCO | RCO_CODIGO | | deshabilita | ALL | RJ2 | SRA | RA_MAT | RJ2_MATSUB |
R8_CODRPATARG, MEX, COL, CHI, PAR, DOMCC2CC2 | ESTCC2CODMUNRAESTADORAMUNICIP| MATSUB | 1 | N | N |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SRAN12N12CGCRACIC| PDADI | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SRARCHRCH_PROCES+RCH_PER | RA_PROCES+RA_PERADM| RV_COD | RUE_PDRES | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SRARCHRCH_PROCES+RCH_PER+RCH_NUMPAG | RA_PROCES+RA_PERADM+RA_PAGADM | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI |
SRA | RCO | RCO_ATIVID+RCO_CODIGO | '1'+RA_AFP| , PAR, PER, DOM | SP7 | RCH | RCH_PROCES+RCH_PER | RA_PROCES+P7_PERIOD | 1 | N | S |
Se agrega | CHI | SRARCO | RCO_ATIVID+RCO_CODIGO | '2'+RA_OBRASOC | 1 | N | SRARABCOEMPL| BCOAGEN | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SRASA6 | A6_COD+A6_AGENCIA | | RCH | RCH_PROCES+RCH_PER+RCH_NUMPAG | RA_PROCES+R0_PERIOD+R0_NROPGT |
RA_BCOHAB agrega DOMSRASQBQBDEPTORADEPTOARG, | , DOM, CHI, PAR | SR8 | RCO | RCO_CODIGO | R8_CODRPAT |
SRA | SRV | RV_COD | RA_OBRASOC agrega, PAR, PER, DOM | SRA | CC2 | CC2_CODMUN | RA_MUNICIP |
SRC | CVL | CVL_COD | RC_DIACTB | 1 | N | S |
| N |
| Se agrega | ARG, MEX, COL, CHI, PAR, DOM |
SRCRCO | RCO_CODIGO | | CC2 | CC2_EST+CC2_CODMUN | RA_ESTADO+RA_MUNICIP |
RC_ENTIDAD | 1 | N | S |
| S |
| Se agrega | MEX, COL, CHI, PAR, PER, DOM |
SRCRHIRHI_MAT+RHI_PROCES+RHI_ROTEIR+RHI_PERIOD+RHI_NUMPAG+RHI_DTINI | RC_MAT+RC_PROCES+RC_ROTEIR+RC_PERIODO+RC_SEMANA+RC_DTREF| N12_CGC | RA_CIC | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SRCSRARA_MAT | RC_MAT | 1 | N | S | Se agrega | COL, CHI, PAR, PER, DOM | SRC | SRG | RG_MAT+RG_DTPAGO | RC_MAT+RC_DTREF | | RCH_PROCES+RCH_PER | RA_PROCES+RA_PERADM | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SRD| SRA | RCH | RCH_PROCES+RCH_PER+RCH_NUMPAG |
+RCHRCH_ROTEIRRD_PERIODO+RD_SEMANA+RD_PROCES+RD_ROTEIR| RA_PERADM+RA_PAGADM | 1 | N | S |
| S |
| Se agrega |
COL, , PAR, PER, DOM | SRA | RCO | RCO_ATIVID+RCO_CODIGO | '1'+RA_AFP |
SRE | CTT | CTT_CUSTO | RE_CCDSRERCJ | RCJREPROCESDCHISRERCJ | RCJ_CODIGO | +RE_PROCESP| SA6 | A6_COD+A6_AGENCIA | RA_BCOEMPL | 1 | N | S |
| S |
| Se agrega |
CHI ARGSRGRCHRCHPROCESRCH_PER+RCH_DTFECHRG_PROCES+RG_PERIODO+''| A6_AGENCIA | RA_BCOHAB | 1 | N | S |
| S |
| Se agrega |
ARG, MEX, COL, , PAR, PERSRGRCHRCH_PROCES+RCH_PER+RCH_NUMPAG+RCH_ROTEIR | RG_PROCES+RG_PERIODO+RG_SEMANA+RG_ROTEIRCHI PAR DOMSRHSRYRYCALCULORHROTEIR| OBRASOC | 1 | N | S |
| S |
| Se agrega | MEX, COL, CHI, PAR, PER, DOM |
SRICTTCTT_CUSTO | | RCH_PROCES+RCH_PER+RCH_NUMPAG | RA_PROCES+RA_PERAUM+RA_PAGAUM |
RI_CC| , CHI, PAR, PER, DOM | SRC | CVL | CVL_COD | RC_DIACTB |
SRJ | SRJ | RJ_FUNCAO | RJ_FUNCAOSRMRC2 | RC2_ORIGEM+RC2RM_FORMULA+RC2_ORIGEM+RC2_CODIGO | 1 | NCOL, , DOMSRRRCH | RCH_PROCES | | RHI | RHI_MAT+RHI_PROCES+RHI_ROTEIR+RHI_PERIOD+RHI_NUMPAG+RHI_DTINI | RC_MAT+RC_PROCES+RC_ROTEIR+RC_PERIODO+RC_SEMANA+RC_DTREF |
RR_PERIODO PERSRVRCNRCNCODIGORVCODFOLSe agrega | CHI | SRV | SRV | RV_COD | RV_CODCOM_ | 1N |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
SRZCTT | CTT_CUSTO | | SRG | RG_MAT+RG_DTPAGO | RC_MAT+RC_DTREF |
RZ_CC | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM |
SV6CC2 | CC2_EST+CC2_CODMUN | V6_ESTAD+V6_CODMU| RCH | RCH_PER+RCH_NUMPAG+RCH_PROCES+RCH_ROTEIR | RD_PERIODO+RD_SEMANA+RD_PROCES+RD_ROTEIR | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM |
SYYSWYWYCODIGOYYCODIGO| CCD | 1 | N | S |
| S |
| Se agrega | MEX, COL, CHI, |
PAR, TIRTIRTIRCODTIQTIRCODIGO agregaCOL, CHI, PAR, PER, DOM | TIU | TIT | TIT_CODIGO | | deshabilita | MEX | SRG | RCH | RCH_PROCES+RCH_PER | RG_PROCES+RG_PERIODO |
TIU_CODTITCampos (SX3)
| Estatus | Tabla | País | Campo | Picture | Título | Inic. Padrao | Consulta | Usado | Contexto |
|---|
Se actualiza | RGB, DOM| , PAR, PER, DOM | SRG | RCH | RCH_PROCES+RCH_PER+RCH_NUMPAG+RCH_ROTEIR | RG_PROCES+RG_PERIODO+RG_SEMANA+RG_ROTEIR | 1 | N | S |
| S |
| Se agrega | CHI, PAR, DOM | SRH | SRY | RY_CALCULO | RH_ROTEIR | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | SRI | CTT | CTT_CUSTO | RI_CC | 1 | N | S |
| S |
| Se agrega | COL | SRJ | SRJ | RJ_FUNCAO | RJ_FUNCAO | 1 | N | S |
| S |
| Se agrega | CHI | SRM | RC2 | RC2_ORIGEM+RC2_CODIGO | RM_FORMULA+RC2_ORIGEM+RC2_CODIGO | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | SRR | RCH | RCH_PROCES | RR_PERIODO | 1 | N | S |
| S |
| Se agrega | COL, PER, DOM | SRV | RCN | RCN_CODIGO | RV_CODFOL | 1 | N | S |
| S |
| Se agrega | CHI | SRV | SRV | RV_COD | RV_CODCOM_ | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | SRZ | CTT | CTT_CUSTO | RZ_CC | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | SV6 | CC2 | CC2_EST+CC2_CODMUN | V6_ESTAD+V6_CODMU | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | SYY | SWY | WY_CODIGO | YY_CODIGO | 1 | N | S |
| S |
| Se agrega | MEX, COL, CHI, PAR, PER, DOM | TIR | TIR | TIR_CODTIQ | TIR_CODIGO | 1 | N | S |
| S |
| Se agrega | COL, CHI, PAR, PER, DOM | TIU | TIT | TIT_CODIGO | TIU_CODTIT | 1 | N | S |
| S |
| Se agrega | MEX | RBT | RGC | RGC_KEYLOC | RBT_LOCPAG | 1 | N | S |
| S |
| Se agrega | ARG, MEX, COL, CHI, PAR, PER, DOM | SQG | CC2 | CC2_EST+CC2_CODMUN | QG_NATURAL+QG_CODMUNN | 1 | N | S |
| S |
| Se agrega | COL | SRJ | SRJ | RJ_FUNCAO | RJ_FUNCAO | 1 | N | S |
| S |
Campos (SX3)
| Estatus | Tabla | País | Campo | Picture | Título | Valid | Inic. Padrao | Consulta | Usado | Contexto |
|---|
| Se actualiza | RGB | ARG, CHI, DOM, MEX | RGB_PD | @! | Cod Concepto | RGBVALIDPD(M->RGB_PD,cCodRoteiro,cCodProcesso,aIndexSRV) .and. gp520PreencheDesc("DESC_VERBA", M->RGB_PD, NIL, NIL, NIL,"F3") |
| SRV-LI | Si | Real |
| Se actualiza | RGB | COL, DOM | RGB_PD | @! | Cod Concepto | ExistCpo("SRV") .and. gp520PreencheDesc("DESC_VERBA", M->RGB_PD, NIL, NIL, NIL, "F3") |
| SRV-LI | Si | Real |
| Se agrega | RGC | PAR | RGC_DESMUN | @! | Desc.Mun |
| If(Inclui,"",fDesc("CC2",RGC->RGC_MUNIC,"CC2_MUNIC")) | SRV-LI | Si | Real |
| Se actualiza | SR8 | CHI | R8_PER | @! | Cod.Per.Inic |
| gp240PERCHI("RCH",1,xFilial("RCH")+cProcesso,"RCH_PER","Empty(RCH->RCH_DTFECH) .AND. (RCH->RCH_PROCES == cProcesso) ") | RCHAUS | Si | Real |
| Se actualiza | SRE | CHI | RE_PROCESD | @! | Suc Orig |
|
|
| Si | Real |
| Se actualiza | SRE | CHI | RE_PROCESP | @! | Duc Des |
|
|
| Si | Real |
| Se actualiza | SRG | ARG, CHI | RG_PERIODO | @! | Periodo | fVPerRes() .And. EXISTCPO("RCH", M->RG_PROCES + M->RG_PERIODO, 2) |
| RCHRES | Si | Real |
| Se actualiza | RGJ | ANG, AUS, BOL, BRA, DOM, EQU, EUA, HAI, PAD, PAN, POR, PTG, RUS | RGJ_CODRPA | @! | Reg. Pat | ExistCpo("RCO") |
| RCO | Si | Real |
| Se actualiza | RGJ | ARG, CHI, COL, COS, MEX, PAR, PER | RGJ_CODRPA | @! | Reg. Pat | ExistCpo("RCO") | SRA->RA_CODRPAT | RCO |
RGB_PD | @! | Cod C | SRV-LI | Si | Virtual | Se agrega | RGC | PAR | RGC_DESMUN | @! | Desc.Mun | If(Inclui,"",fDesc("CC2",RGC->RGC_MUNIC,"CC2_MUNIC"))
| Informações |
|---|
| title | Paquete de uso interno |
|---|
|
Los ajustes al Diccionario de Datos estándar, se realizaron en el siguiente paquetelos siguientes paquetes de actualización: Código: 015391 Descripción: - 015391 - MI - DNOMI-3188 - DÉBITOS RELAC. (SX9)
- 015511 - MI - DNOMI-3313 - DÉBITOS TÉCNICOS (SX9) - GPE
|
| Card documentos |
|---|
| Informacao | Los cambios realizados al Diccionario de Datos, serán reflejados en el Release 12.1.2510 de Protheus. |
|---|
| Titulo | ¡IMPORTANTE! |
|---|
|
...