Consulta Padrao(SXB): QPQ - Caracteristicas Peca | |||||
XB_ALIAS | XB_TIPO | XB_SEQ | XB_COLUNA | XB_DESCRI | XB_CONTEM |
QPQ | 1 | 01 | DB | Caracteristicas Peca | QK2 |
QPQ | 2 | 01 | 01 | Codigo | |
QPQ | 2 | 02 | 01 | Descricao | |
QPQ | 4 | 01 | 01 | Codigo | QK2->QK2_CODCAR |
QPQ | 4 | 01 | 02 | Descricao | QK2->QK2_DESC |
QPQ | 5 | 01 | QK2->QK2_CODCAR | ||
QPQ | 5 | 02 | ALLTRIM(SUBS(QK2->QK2_DESC,1,20))+" - "+ALLTRIM(SUBS(QK2->QK2_ESPE,1,20))+" "+QK2->QK2_UM | ||
QPQ | 6 | 01 | QK2->QK2_PECA+QK2->QK2_REV == M->QKD_PECA+M->QKD_REV .and. QK2->QK2_TPCAR == "2" |