Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC_NotJC
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_GLTransactionNotInJC
Physical Name: JC_NotJC
Technical Name: JC_GLTransactionNotInJCSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 OPENYEAR Open Year INT4_S0 Integer 4 2 JRNENTRY Journal Entry LI8_U0 Long Integer 8 3 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 4 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['JC_GLTransactionNotInJC'].ACTINDX AS 'JC_GLTransactionNotInJC-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
JC_NotJC AS ['JC_GLTransactionNotInJC']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['JC_GLTransactionNotInJC'].ACTINDX = ['Account Index Master'].ACTINDX
5 TRXDATE TRX Date DT_Date Date 6 6 PERIODID Period ID INT3 Integer 3 7 ORTRXSRC Originating TRX Source STR13 String 13 8 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 9 DEBITAMT Debit Amount DLR19_$S2 Currency 19 10 ACTNUMST Account Number String STR128_LBU String 128 11 ACTDESCR Account Description STR50 String 50 12 REFRENCE Reference STR30 String 30 13 DSCRIPTN Description STR30 String 30 14 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['JC_GLTransactionNotInJC'].SOURCDOC AS 'JC_GLTransactionNotInJC-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
JC_NotJC AS ['JC_GLTransactionNotInJC']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['JC_GLTransactionNotInJC'].SOURCDOC = ['Source Document Master'].SOURCDOC
15 USWHPSTD User Who Posted User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_GLTransactionNotInJC'].USWHPSTD AS 'JC_GLTransactionNotInJC-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC_NotJC AS ['JC_GLTransactionNotInJC']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_GLTransactionNotInJC'].USWHPSTD = ['Users Master'].USERID
16 ORCTRNUM Originating Control Number STR20 String 20