Salve salve, blz?
Tabela NJU. #NJU
SX2 - TABELA
| X2_CHAVE | X2_PATH | X2_ARQUIVO | X2_NOME | X2_NOMESPA | X2_NOMEENG | X2_ROTINA | X2_MODO | X2_MODOUN | X2_MODOEMP | X2_DELET | X2_TTS | X2_UNICO | X2_PYME | X2_MODULO | X2_DISPLAY | X2_SYSOBJ | X2_USROBJ | X2_POSLGT | X2_CLOB | X2_AUTREC | X2_TAMFIL | X2_TAMUN | X2_TAMEMP | X2_STAMP | X2_INSDT |
| NJU | DATA | NJU990 | Safra | Cosecha | Crop | | C | C | C | 0 | | NJU_FILIAL+NJU_CODSAF | S | 67 | | | | 1 | 2 | 2 | 2 | 0 | 0 |
SX3 - CAMPOS
| X3_ARQUIVO | X3_ORDEM | X3_CAMPO | X3_TIPO | X3_TAMANHO | X3_DECIMAL | X3_TITULO | X3_DESCRIC | X3_PICTURE | X3_VALID | X3_RELACAO | X3_F3 | X3_NIVEL | X3_TRIGGER | X3_BROWSE | X3_VISUAL | X3_CONTEXT | X3_OBRIGAT | X3_CBOX | X3_PICTVAR | X3_WHEN | X3_INIBRW | X3_GRPSXG | X3_FOLDER |
| NJU | 01 | NJU_FILIAL | C | 2 | 0 | Filial | Filial | | | | | 1 | | | | | | | | | | 033 | |
| NJU | 02 | NJU_CODSAF | C | 15 | 0 | Safra | Código Safra | @! | ExistChav('NJU',M->NJU_CODSAF) | | | 1 | | S | A | R | | | | INCLUI | | 130 | |
| NJU | 03 | NJU_DESCRI | C | 40 | 0 | Descricao | Descricao da Safra | @! | | | | 1 | | S | A | R | | | | | | | |
| NJU | 06 | NJU_UPOAGR | C | 1 | 0 | Portal Agro | Utiliza Portal Agro | @! | Pertence('12') | '1' | | 1 | | S | A | R | | 1=Não Utiliza;2=Libera Portal | | SuperGetMV("MV_AGRO024",.F.,.T.) | '1' | | |
| NJU | 07 | NJU_OPELOG | C | 10 | 0 | Oper. Logíst | Operação Logística | @! | Vazio() .OR. GFEExistC("GV4", 1, M->NJU_OPELOG,"GV4->GV4_SIT=='1'") | | GV4 | 1 | S | N | A | R | | | | | | | |
| NJU | 08 | NJU_DOPLOG | C | 50 | 0 | Des. Op. Log | Descrição Oper. Logística | @! | | IIF(!INCLUI,ALLTRIM(POSICIONE("GV4",1,XFILIAL("GV4")+NJU->NJU_OPELOG,"GV4_DSTPOP")),"") | | 1 | | N | V | V | | | | | | | |
| NJU | 09 | NJU_IDSAFR | C | 15 | 0 | Safra INDEA | Safra INDEA | @! | | | | 1 | | | | | | | | | | 130 | |
| NJU | 04 | NJU_ATIVO | C | 1 | 0 | Ativo? | Registro ativo | | Pertence('12') | '1' | | 1 | | N | V | R | | 1=Sim;2=Não | | | | | 1 |
| NJU | 05 | NJU_ID | C | 136 | 0 | InternalID | InternalID IntegraçãoPIMS | | | | | 1 | | N | V | R | | | | | | | 1 |
SIX - INDICES
| INDICE | ORDEM | CHAVE | DESCRICAO | DESCSPA | DESCENG | PROPRI | F3 | NICKNAME | SHOWPESQ | IX_VIRTUAL | IX_VIRCUST |
| NJU | 1 | NJU_FILIAL+NJU_CODSAF | Safra | Cosecha | Crop | S | | | S | 2 | 3 |
| NJU | 2 | NJU_FILIAL+NJU_ID | InternalID | InternalID | InternalID | S | | | S | 2 | 3 |
SX7 - GATILHOS
| X7_CAMPO | X7_SEQUENC | X7_REGRA | X7_CDOMIN | X7_TIPO | X7_SEEK | X7_ALIAS | X7_ORDEM | X7_CHAVE | X7_CONDIC | X7_PROPRI |
| NJU_OPELOG | 001 | GV4->GV4_DSTPOP | NJU_DOPLOG | P | S | GV4 | 1 | XFILIAL("GV4")+M->NJU_OPELOG | | S |
SX9 - Relacionamento entre Tabelas
| X9_DOM | X9_IDENT | X9_CDOM | X9_EXPDOM | X9_EXPCDOM | X9_PROPRI | X9_LIGDOM | X9_LIGCDOM | X9_CONDSQL | X9_USEFIL | X9_ENABLE | X9_VINFIL | X9_CHVFOR |
| NJU | 092 | NJR | NJU_CODSAF | NJR_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 091 | NPE | NJU_CODSAF | NPE_CODSAF | S | 1 | N | | | S | 2 | 2 |
| NJU | 090 | NP9 | NJU_CODSAF | NP9_CODSAF | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 089 | NNO | NJU_CODSAF | NNO_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 088 | NJF | NJU_CODSAF | NJF_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 087 | NKT | NJU_CODSAF | NKT_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 086 | DXN | NJU_CODSAF | DXN_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 085 | DX7 | NJU_CODSAF | DX7_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 084 | N9B | NJU_CODSAF | N9B_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 083 | N8Y | NJU_CODSAF | N8Y_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 082 | N8X | NJU_CODSAF | N8X_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 081 | N8N | NJU_CODSAF | N8N_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 080 | N83 | NJU_CODSAF | N83_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 079 | NPK | NJU_CODSAF | NPK_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 078 | NPD | NJU_CODSAF | NPD_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 077 | NP9 | NJU_CODSAF | NP9_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 076 | N72 | NJU_CODSAF | N72_SAFRA | S | 1 | N | | | S | 2 | 2 |
| NJU | 075 | N71 | NJU_CODSAF | N71_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 074 | N9N | NJU_CODSAF | N9N_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 073 | NL0 | NJU_CODSAF | NL0_CODSAF | S | N | N | | S | S | 2 | 2 |
| NJU | 072 | N9D | NJU_CODSAF | N9D_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 071 | ND5 | NJU_CODSAF | ND5_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 070 | NCX | NJU_CODSAF | NCX_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 069 | NLP | NJU_CODSAF | NLP_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 068 | ND3 | NJU_CODSAF | ND3_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 067 | NK2 | NJU_CODSAF | NK2_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 066 | NKG | NJU_CODSAF | NKG_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 065 | ND6 | NJU_CODSAF | ND6_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 064 | N8L | NJU_CODSAF | N8L_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 063 | NQF | NJU_CODSAF | NQF_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 062 | NPO | NJU_CODSAF | NPO_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 061 | NPC | NJU_CODSAF | NPC_CODSAF | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 060 | NP1 | NJU_CODSAF | NP1_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 059 | NO1 | NJU_CODSAF | NO1_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 058 | NNM | NJU_CODSAF | NNM_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 057 | NCS | NJU_CODSAF | NCS_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 056 | N79 | NJU_CODSAF | N79_CODSAF | S | N | N | | S | S | 2 | 2 |
| NJU | 055 | N73 | NJU_CODSAF | N73_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 054 | N8W | NJU_CODSAF | N8W_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 053 | N8V | NJU_CODSAF | N8V_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 052 | N7P | NJU_CODSAF | N7P_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 051 | DXT | NJU_CODSAF | DXT_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 050 | DXS | NJU_CODSAF | DXS_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 049 | DXQ | NJU_CODSAF | DXQ_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 048 | DXM | NJU_CODSAF | DXM_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 047 | NJA | NJU_CODSAF | NJA_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 046 | DXJ | NJU_CODSAF | DXJ_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 045 | SD1 | NJU_CODSAF | D1_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 044 | NCW | NJU_CODSAF | NCW_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 043 | NCV | NJU_CODSAF | NCV_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 042 | N8Q | NJU_CODSAF | N8Q_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 041 | DXP | NJU_CODSAF | DXP_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 040 | DXO | NJU_CODSAF | DXO_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 039 | N9C | NJU_CODSAF | N9C_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 038 | N8Z | NJU_CODSAF | N8Z_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 037 | N8P | NJU_CODSAF | N8P_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 036 | NPX | NJU_CODSAF | NPX_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 035 | NPR | NJU_CODSAF | NPR_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 034 | NPL | NJU_CODSAF | NPL_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 033 | NN3 | NJU_CODSAF | NN3_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 032 | NPX | NJU_CODSAF | NPX_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 031 | NPF | NJU_CODSAF | NPF_CODSAF | S | 1 | N | | | S | 2 | 2 |
| NJU | 030 | NJX | NJU_CODSAF | NJX_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 029 | NJJ | NJU_CODSAF | NJJ_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 028 | ADA | NJU_CODSAF | ADA_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 027 | NLO | NJU_CODSAF | NLO_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 026 | NJY | NJU_CODSAF | NJY_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 025 | NJM | NJU_CODSAF | NJM_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 024 | SC2 | NJU_CODSAF | C2_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 023 | NQD | NJU_CODSAF | NQD_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 022 | NPI | NJU_CODSAF | NPI_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 021 | NPA | NJU_CODSAF | NPA_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 020 | NN4 | NJU_CODSAF | NN4_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 019 | NJB | NJU_CODSAF | NJB_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 018 | N9H | NJU_CODSAF | N9H_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 017 | N7Q | NJU_CODSAF | N7Q_CODSAF | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 016 | DXL | NJU_CODSAF | DXL_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 015 | DXI | NJU_CODSAF | DXI_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 014 | DXD | NJU_CODSAF | DXD_SAFRA | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 013 | N87 | NJU_CODSAF | N87_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 012 | NN1 | NJU_CODSAF | NN1_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 011 | NCU | NJU_CODSAF | NCU_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 010 | DX0 | NJU_CODSAF | DX0_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 009 | SC5 | NJU_CODSAF | C5_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 008 | N8M | NJU_CODSAF | N8M_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 007 | NNN | NJU_CODSAF | NNN_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 006 | NJU | NJU_CODSAF | NJU_IDSAFR | S | 1 | N | | S | S | 2 | 2 |
| NJU | 005 | NJ5 | NJU_CODSAF | NJ5_CODSAF | S | 1 | N | | S | S | 2 | 2 |
| NJU | 004 | N8K | NJU_CODSAF | N8K_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 003 | N8I | NJU_CODSAF | N8I_SAFRA | S | 1 | N | | S | S | 2 | 2 |
| NJU | 002 | NJH | NJU_CODSAF | NJH_CODSAF | S | 1 | 1 | | S | S | 2 | 2 |
| NJU | 001 | SD3 | NJU_CODSAF | D3_CODSAF | S | 1 | N | | S | S | 2 | 2 |
SXG - Grupo de Campos
| XG_GRUPO | XG_DESCRI | XG_DESSPA | XG_DESENG | XG_SIZEMAX | XG_SIZEMIN | XG_SIZE | XG_PICTURE |
| 033 | Tamanho da Filial | Tamano de la Sucursal | Branch Size | 12 | 2 | 2 | |
| 130 | Safra | Cosecha | Crop | 20 | 6 | 15 | @! |
Gostou? Compartilhe com seus amigos e deixe um comentário! ??
Um abraço, e até a próxima
