Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00303
Product: VAT Daybook (3096)
Series:
Display Name: taxReturnGLException
Physical Name: TX00303
Technical Name: taxReturnGLExceptionSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Tax_Return_ID 
Tax Return ID String STR20_LBAU 20 2 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['taxReturnGLException'].ACTINDX AS 'taxReturnGLException-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
TX00303 AS ['taxReturnGLException']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['taxReturnGLException'].ACTINDX = ['Account Index Master'].ACTINDX3 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['taxReturnGLException'].SOURCDOC AS 'taxReturnGLException-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
TX00303 AS ['taxReturnGLException']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['taxReturnGLException'].SOURCDOC = ['Source Document Master'].SOURCDOC4 SDOCDSCR Source Document Description String STR30 30 5 JRNENTRY Journal Entry Long Integer LI8_U0 8 6 TRXDATE TRX Date Date DT_Date 6 7 ORDOCNUM Originating Document Number String STR20 20 8 ORPSTDDT Originating Posted Date Date DT_Date 6 9 DEBITAMT Debit Amount Currency DLR19_$S2 19 10 CRDTAMNT Credit Amount Currency DLR19_$S2 19