JC_JCTransactionNotInGL (JC_NotGL)

azurecurveProductsWennSoft Products (131)3rd PartyJC_JCTransactionNotInGL (JC_NotGL)

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_JCTransactionNotInGL

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1OPENYEAR SearchOpen YearINT4_S0Integer4
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
3Divisions SearchDivisionsSTR15_LBAUString15
4Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString6
5Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString6
6Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString6
7Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString6
8Cost_Element SearchCost ElementINT3_RB0_UInteger3
9Job_TRX_Number SearchJob TRX NumberSTR20String20
10LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
11GLPOSTDT SearchGL Posting DateDTDate8
12Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency14
13Document_Source SearchDocument SourceSTR3String3
14ACTINDX SearchAccount IndexLI_14Long Integer14
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'].ACTINDX
15ACTNUMST SearchAccount Number StringSTR128_LBUString128
16Cost_Element_Desc SearchCost Element DescriptionSTR15String15
17POSTED SearchPostedTrue/FalseBoolean0
azurecurveProductsWennSoft Products (131)3rd PartyJC_JCTransactionNotInGL (JC_NotGL)

Leave a Reply

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