Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT41301
Product: Extender (3107)
Series: Project
Display Name: Extender Voucher Distributions
Physical Name: EXT41301
Technical Name: PT_Extender_Voucher_DistributionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Voucher_ID 
Extender Voucher ID STR15_LBAU String 15 2 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 3 DebitCredit Debit / Credit Debit / Credit Integer 0 4 Ext_Account_From Ext_Account_From Extender 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 Voucher Distributions'].ACTINDX AS 'Extender Voucher Distributions-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
EXT41301 AS ['Extender Voucher Distributions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Extender Voucher Distributions'].ACTINDX = ['Account Index Master'].ACTINDX6 Ext_Amount_From Ext_Amount_From Extender Amount From Integer 0 7 DISTAMNT Distribution Amount DLR17_RBSO_STR$ Currency 17 8 Ext_Reference_From Ext_Reference_From Extender Reference From Integer 0 9 REFRENCE Reference STR30 String 30