Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO10900
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_Non_Stock_Items
Physical Name: PO10900
Technical Name: PO_Non_Stock_ItemsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITMNUM 
Item_Number_STR STR30_Item_Number String 30 2 ITMDESC Item_Description_STR STR50 String 50 3 QYORD Quantity_Ordered_DOL DLR17_RBS0_STR Currency 17 4 UOM Unit_Of_Measure_STR U_Of_M String 8 5 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 6 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PO_Non_Stock_Items'].ACTINDX AS 'PO_Non_Stock_Items-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PO10900 AS ['PO_Non_Stock_Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PO_Non_Stock_Items'].ACTINDX = ['Account Index Master'].ACTINDX