Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT41101
Product: Extender (3107)
Series: Project
Display Name: Extender Journal Accounts
Physical Name: EXT41101
Technical Name: PT_Extender_Journal_AccountsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PT_Journal_ID 
PT Journal ID STR15_LBAU String 15 2 DSTSQNUM Distribution Sequence Number Long Int Long Integer 8 3 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Extender Journal Accounts'].ACTINDX AS 'Extender Journal Accounts-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
EXT41101 AS ['Extender Journal Accounts']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Extender Journal Accounts'].ACTINDX = ['Account Index Master'].ACTINDX4 DebitCredit Debit / Credit Debit / Credit Integer 0 5 DISTAMNT Distribution Amount DLR17_RBSO_STR$ Currency 17 6 DistRef Distribution Reference STR30 String 30 7 Ext_Account_From Ext_Account_From Extender Account From Integer 0 8 Ext_Amount_From Ext_Amount_From Extender Amount From Integer 0 9 Ext_Reference_From Ext_Reference_From Extender Reference From Integer 0 10 Form_Field_Number_1 Form Field Number[1] INT5 Integer 4 11 Form_Field_Number_2 Form Field Number[2] INT5 Integer 4 12 Form_Field_Number_3 Form Field Number[3] INT5 Integer 4 13 Form_Field_Number_4 Form Field Number[4] INT5 Integer 4 14 Form_Field_Number_5 Form Field Number[5] INT5 Integer 4 15 Form_Field_Number_6 Form Field Number[6] INT5 Integer 4 16 Form_Field_Number_7 Form Field Number[7] INT5 Integer 4 17 Form_Field_Number_8 Form Field Number[8] INT5 Integer 4 18 Form_Field_Number_9 Form Field Number[9] INT5 Integer 4 19 Form_Field_Number_10 Form Field Number[10] INT5 Integer 4 20 Form_Field_Number_11 Form Field Number[11] INT5 Integer 4 21 Form_Field_Number_12 Form Field Number[12] INT5 Integer 4 22 Form_Field_Number_13 Form Field Number[13] INT5 Integer 4 23 Form_Field_Number_14 Form Field Number[14] INT5 Integer 4 24 Form_Field_Number_15 Form Field Number[15] INT5 Integer 4 25 Form_Field_Number_16 Form Field Number[16] INT5 Integer 4 26 Form_Field_Number_17 Form Field Number[17] INT5 Integer 4 27 Form_Field_Number_18 Form Field Number[18] INT5 Integer 4 28 Form_Field_Number_19 Form Field Number[19] INT5 Integer 4 29 Form_Field_Number_20 Form Field Number[20] INT5 Integer 4