Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT41201
Product: Extender (3107)
Series: Project
Display Name: Extender Invoice Distributions
Physical Name: EXT41201
Technical Name: PT_Extender_Invoice_DistributionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Invoice_ID 
Extender Invoice 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 Invoice Distributions'].ACTINDX AS 'Extender Invoice Distributions-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
EXT41201 AS ['Extender Invoice Distributions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Extender Invoice 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