Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00200FL
Product: Analytical Accounting (3180)
Series:
Display Name: Analytical Accounts Facelift
Physical Name: AAG00200FL
Technical Name: Analytical Accounts FaceliftSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ACTINDX 
Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Analytical Accounts Facelift'].ACTINDX AS 'Analytical Accounts Facelift-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
AAG00200FL AS ['Analytical Accounts Facelift']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Analytical Accounts Facelift'].ACTINDX = ['Account Index Master'].ACTINDX2 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 3 ACTNUMBR Account Number Account_Number Composite 80 4 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 5 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 6 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 7 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 8 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 9 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 10 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 11 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 12 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 13 strAccountNumber strAccountNumber String STR75 75 14 ACTDESCR Account Description String STR50 50 15 ACCTTYPE Account Type Integer DDL_Account_Type 0 16 ACTIVE Active Boolean CB_Active 0 17 DSCRIPTN Description String STR30 30 18 aaAcctClassID aaAccountClassID Long Integer aaLONG_INT 8 19 aaAccountClass aaAccountClass String aaSTR15_LBAU 15 20 aaAcctClassDescr aaAccountClassDescr String aaSTR50 50 21 aaNode aaNode String aaSTR50 50 22 aaDescr aaDescr String aaSTR50 50 23 aaTreeMain aaTreeMain Boolean aaCB_TreeMain 0 24 PSTNGTYP Posting Type Integer GB 0