Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC_NotGL
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_JCTransactionNotInGL
Physical Name: JC_NotGL
Technical Name: JC_JCTransactionNotInGLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 OPENYEAR 
Open Year INT4_S0 Integer 4 2 WS_Job_Number WS Job Number STR17_LBAU String 17 3 Divisions Divisions STR15_LBAU String 15 4 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 5 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 6 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 7 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 8 Cost_Element Cost Element INT3_RB0_U Integer 3 9 Job_TRX_Number Job TRX Number STR20 String 20 10 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 11 GLPOSTDT GL Posting Date DT Date 8 12 Cost_Code_Act_Cost_TTD Cost Code Actual Cost TTD DLR14_STR Currency 14 13 Document_Source Document Source STR3 String 3 14 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['JC_JCTransactionNotInGL'].ACTINDX AS 'JC_JCTransactionNotInGL-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
JC_NotGL AS ['JC_JCTransactionNotInGL']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['JC_JCTransactionNotInGL'].ACTINDX = ['Account Index Master'].ACTINDX15 ACTNUMST Account Number String STR128_LBU String 128 16 Cost_Element_Desc Cost Element Description STR15 String 15 17 POSTED Posted True/False Boolean 0