Salve salve, blz?
Tabela SWJ. #SWJ
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 |
| SWJ | DATA | SWJ990 | Histórico de Itens | Historial de Items | Items History | | E | E | E | 0 | | | N | 17 | WJ_CODIGO+WJ_FORN | EICAP100R3 | | 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 |
| SWJ | 43 | WJ_CUS_12 | N | 15 | 2 | Cus_12 | Cus_12 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 42 | WJ_CUS_11 | N | 15 | 2 | Cus_11 | Cus_11 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 41 | WJ_CUS_10 | N | 15 | 2 | Cus_10 | Cus_10 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 40 | WJ_CUS_09 | N | 15 | 2 | Cus_09 | Cus_09 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 39 | WJ_CUS_08 | N | 15 | 2 | Cus_08 | Cus_08 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 38 | WJ_CUS_07 | N | 15 | 2 | Cus_07 | Cus_07 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 37 | WJ_CUS_06 | N | 15 | 2 | Cus_06 | Cus_06 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 36 | WJ_CUS_05 | N | 15 | 2 | Cus_05 | Cus_05 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 35 | WJ_CUS_04 | N | 15 | 2 | Cus_04 | Cus_04 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 34 | WJ_CUS_03 | N | 15 | 2 | Cus_03 | Cus_03 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 33 | WJ_CUS_02 | N | 15 | 2 | Cus_02 | Cus_02 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 32 | WJ_CUS_01 | N | 15 | 2 | Cus_01 | Cus_01 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 31 | WJ_FOB_12 | N | 15 | 2 | Fob_12 | Fob_12 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 30 | WJ_FOB_11 | N | 15 | 2 | Fob_11 | Fob_11 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 29 | WJ_FOB_10 | N | 15 | 2 | Fob_10 | Fob_10 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 28 | WJ_FOB_09 | N | 15 | 2 | Fob_09 | Fob_09 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 27 | WJ_FOB_08 | N | 15 | 2 | Fob_08 | Fob_08 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 26 | WJ_FOB_07 | N | 15 | 2 | Fob_07 | Fob_07 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 25 | WJ_FOB_06 | N | 15 | 2 | Fob_06 | Fob_06 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 24 | WJ_FOB_05 | N | 15 | 2 | Fob_05 | Fob_05 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 23 | WJ_FOB_04 | N | 15 | 2 | Fob_04 | Fob_04 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 22 | WJ_FOB_03 | N | 15 | 2 | Fob_03 | Fob_03 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 21 | WJ_FOB_02 | N | 15 | 2 | Fob_02 | Fob_02 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 20 | WJ_FOB_01 | N | 15 | 2 | Fob_01 | Fob_01 | | | | | 1 | | S | | | | | | | | | |
| SWJ | 19 | WJ_QTD_12 | N | 14 | 5 | Qtd_12 | Qtd_12 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 18 | WJ_QTD_11 | N | 14 | 5 | Qtd_11 | Qtd_11 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 17 | WJ_QTD_10 | N | 14 | 5 | Qtd_10 | Qtd_10 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 16 | WJ_QTD_09 | N | 14 | 5 | Qtd_09 | Qtd_09 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 15 | WJ_QTD_08 | N | 14 | 5 | Qtd_08 | Qtd_08 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 14 | WJ_QTD_07 | N | 14 | 5 | Qtd_07 | Qtd_07 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 13 | WJ_QTD_06 | N | 14 | 5 | Qtd_06 | Qtd_06 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 12 | WJ_QTD_05 | N | 14 | 5 | Qtd_05 | Qtd_05 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 11 | WJ_QTD_04 | N | 14 | 5 | Qtd_04 | Qtd_04 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 10 | WJ_QTD_03 | N | 14 | 5 | Qtd_03 | Qtd_03 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 09 | WJ_QTD_02 | N | 14 | 5 | Qtd_02 | Qtd_02 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 08 | WJ_QTD_01 | N | 14 | 5 | Qtd_01 | Qtd_01 | @E 99,999,999.99999 | | | | 1 | | S | | | | | | | | | |
| SWJ | 07 | WJ_MOEDA | C | 3 | 0 | Moeda | Moeda | @! | | | | 1 | | S | | | | | | | | | |
| SWJ | 06 | WJ_FORLOJ | C | 2 | 0 | Loja Fo. | Loja Fo. | @! | | | | 1 | | | | | | | | | | 002 | |
| SWJ | 05 | WJ_FORN | C | 6 | 0 | Fornecedor | Fornecedor | @! | | | SA2 | 1 | S | S | | | | | | | | 001 | |
| SWJ | 04 | WJ_CODIGO | C | 15 | 0 | Codigo | Codigo | @! | | | | 1 | | S | | | | | | | | 030 | |
| SWJ | 03 | WJ_ANO | C | 4 | 0 | Ano | Ano | @! | | | | 1 | | S | | | | | | | | | |
| SWJ | 02 | WJ_TIPO | C | 1 | 0 | Tipo | Tipo | @! | | | | 1 | | S | | | | | | | | | |
| SWJ | 01 | WJ_FILIAL | C | 2 | 0 | Filial | Filial do Sistema | | | | | 1 | | N | | | | | | | | 033 | |
SIX - INDICES
| INDICE | ORDEM | CHAVE | DESCRICAO | DESCSPA | DESCENG | PROPRI | F3 | NICKNAME | SHOWPESQ | IX_VIRTUAL | IX_VIRCUST |
| SWJ | 1 | WJ_FILIAL+WJ_TIPO+WJ_ANO+WJ_CODIGO+WJ_FORN+WJ_FORLOJ | Tipo + Ano + Codigo + Fornecedor + Loja Fo. | Tipo + Ano + Codigo + Proveedor + Tienda Prov. | Type + Year + Code + Supplier + Unit Fo. | 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 |
| WJ_FORN | 001 | '' | WJ_FORLOJ | P | N | | 0 | | !AvCpo("SA2", WJ_FORN + WJ_FORLOJ) | S |
SXG - Grupo de Campos
| XG_GRUPO | XG_DESCRI | XG_DESSPA | XG_DESENG | XG_SIZEMAX | XG_SIZEMIN | XG_SIZE | XG_PICTURE |
| 001 | Codigo Cliente/Fornecedor | Codigo Cliente/Proveedor | Customer/Supplier Code | 20 | 6 | 6 | @! |
| 002 | Loja Cliente/Fornecedor | Tienda Cliente/Proveedor | Customer/Supplier Unit | 4 | 2 | 2 | @! |
| 030 | Tamanho do Produto | Tamano del Producto | Product Size | 30 | 15 | 15 | @! |
| 033 | Tamanho da Filial | Tamano de la Sucursal | Branch Size | 12 | 2 | 2 | |
Gostou? Compartilhe com seus amigos e deixe um comentário! ??
Um abraço, e até a próxima