PA – Account Transaction History Archive Temp (paglt001)

azurecurveProductsCompany Archive (1755)CompanyPA - Account Transaction History Archive Temp (paglt001)

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: paGLAccountTrxHistTEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1HSTYEAR SearchHistory YearINT4_S0Integer24
2JRNENTRY SearchJournal EntryLI8_U0Long Integer48
3RCTRXSEQ SearchRecurring TRX SequenceDLR19_$S2Currency1019
4TRXDATE SearchTRX DateDT_DateDate46
5ACTINDX SearchAccount IndexLI_14Long Integer414
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'].ACTINDX
6PERIODID SearchPeriod IDINT3Integer23
7DEBITAMT SearchDebit AmountDLR19_$S2Currency1019
8CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
9DSCRIPTN SearchDescriptionSTR30String3230
azurecurveProductsCompany Archive (1755)CompanyPA - Account Transaction History Archive Temp (paglt001)

Leave a Reply

Your email address will not be published. Required fields are marked *