Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC10704
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Payroll_Detail_For_Summary
Physical Name: JC10704
Technical Name: JC_Payroll_Detail_For_SummarySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 COMPTRNM 
Computer TRX Number LI8_U0 Long Integer 8 2 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['JC_Payroll_Detail_For_Summary'].ACTINDX AS 'JC_Payroll_Detail_For_Summary-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
JC10704 AS ['JC_Payroll_Detail_For_Summary']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['JC_Payroll_Detail_For_Summary'].ACTINDX = ['Account Index Master'].ACTINDX3 WS_Job_Number WS Job Number STR17_LBAU String 17 4 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 5 DEBITAMT Debit Amount DLR19_$S2 Currency 19 6 ORCRDAMT Originating Credit Amount DLR19_$S2 Currency 19 7 ORDBTAMT Originating Debit Amount DLR19_$S2 Currency 19