| Consulta Padrao(SXB): EC8 - Consulta Inv/Proc/PO | |||||
| XB_ALIAS | XB_TIPO | XB_SEQ | XB_COLUNA | XB_DESCRI | XB_CONTEM |
| EC8 | 1 | 01 | DB | Consulta Inv/Proc/PO | EC8 |
| EC8 | 2 | 01 | 02 | Invoice | |
| EC8 | 2 | 02 | 03 | Processo | |
| EC8 | 2 | 03 | 04 | Nr. P.O. | |
| EC8 | 4 | 01 | 01 | Invoice | EC8->EC8_INVOIC |
| EC8 | 4 | 01 | 02 | Processo | EC8->EC8_HAWB |
| EC8 | 4 | 01 | 03 | Nr. P.O. | EC8->EC8_PO_NUM |
| EC8 | 4 | 02 | 01 | Processo | EC8->EC8_HAWB |
| EC8 | 4 | 02 | 02 | Nr. P.O. | EC8->EC8_PO_NUM |
| EC8 | 4 | 02 | 03 | Invoice | EC8->EC8_INVOIC |
| EC8 | 4 | 03 | 01 | Nr. P.O. | EC8->EC8_PO_NUM |
| EC8 | 4 | 03 | 02 | Invoice | EC8->EC8_INVOIC |
| EC8 | 4 | 03 | 03 | Processo | EC8->EC8_HAWB |
| EC8 | 5 | 01 | IF(nTipo=1,EC8->EC8_INVOIC,IF(nTipo=2,EC8->EC8_HAWB,EC8->EC8_PO_NUM)) | ||