Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT40060
Product: Extender (3107)
Series: Project
Display Name: Extender Interface Accounts
Physical Name: EXT40060
Technical Name: PT_Extender_Interface_AccountsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Type 
Extender Type INT5 Integer 4 2 Extender_ID Extender ID STR15_LBAU String 15 3 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 4 Interface_Account Interface Account Interface Account From Integer 0 5 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Extender Interface Accounts'].ACTINDX AS 'Extender Interface Accounts-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
EXT40060 AS ['Extender Interface Accounts']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Extender Interface Accounts'].ACTINDX = ['Account Index Master'].ACTINDX6 Extender_Field_Position_1 Extender Field Position:Record Type INT1 Integer 1 7 Extender_Field_Position_2 Extender Field Position:Window Number INT5 Integer 4 8 Extender_Field_Position_3 Extender Field Position:Field Number INT2 Integer 2 9 Extender_Field_Position_4 Extender Field Position:Field Type Long Int Long Integer 8 10 Extender_Field_Position_5 Extender Field Position:Lookup Number Long_10U Long Integer 10