Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/paglt001
Product: Company Archive (1755)
Series: Company
Display Name: PA - Account Transaction History Archive Temp
Physical Name: paglt001
Technical Name: paGLAccountTrxHistTEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 HSTYEAR 
History Year INT4_S0 Integer 4 2 JRNENTRY Journal Entry LI8_U0 Long Integer 8 3 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 4 TRXDATE TRX Date DT_Date Date 6 5 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['PA - Account Transaction History Archive Temp'].ACTINDX AS 'PA - Account Transaction History Archive Temp-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
paglt001 AS ['PA - Account Transaction History Archive Temp']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PA - Account Transaction History Archive Temp'].ACTINDX = ['Account Index Master'].ACTINDX6 PERIODID Period ID INT3 Integer 3 7 DEBITAMT Debit Amount DLR19_$S2 Currency 19 8 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 9 DSCRIPTN Description STR30 String 30