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