Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10120
Product: Encumbrance Management (3258)
Series:
Display Name: Encumbrance Missing POP Line
Physical Name: ENC10120
Technical Name: ENC_MissingPOPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PONUMBER 
PO Number String STR17_POP_Number 17 2 ORD Ord Long Integer LI_Sequence_Number 10 3 POTYPE PO Type Integer DDL_POP_PO_Type 0 4 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 5 QTYCANCE QTY Canceled Currency DLR17_QTY_RBS0_UTR 17 6 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 7 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 8 INVINDX Inventory Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Encumbrance Missing POP Line'].INVINDX AS 'Encumbrance Missing POP Line-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ENC10120 AS ['Encumbrance Missing POP Line']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Encumbrance Missing POP Line'].INVINDX = ['Account Index Master'].ACTINDX9 LINEORIGIN Line Origin Integer DDL_Line_Origin 0