JC_WIPReconciliation (JC_WIP)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC_WIP

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_WIPReconciliation
Physical Name: JC_WIP
Technical Name: JC_WIPReconciliation

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1OPENYEAR SearchOpen YearINT4_S0Integer24
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
3Divisions SearchDivisionsSTR15_LBAUString1615
4Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
5Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
6Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
7Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
8Cost_Element SearchCost ElementINT3_RB0_UInteger23
9Job_TRX_Number SearchJob TRX NumberSTR20String2220
10LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
11GLPOSTDT SearchGL Posting DateDTDate48
12Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency1014
13Document_Source SearchDocument SourceSTR3String43
14ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['JC_WIPReconciliation'].ACTINDX AS 'JC_WIPReconciliation-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       JC_WIP AS ['JC_WIPReconciliation']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['JC_WIPReconciliation'].ACTINDX = ['Account Index Master'].ACTINDX
15ACTNUMST SearchAccount Number StringSTR128_LBUString130128
16Cost_Element_Desc SearchCost Element DescriptionSTR15String1615
17ACTDESCR SearchAccount DescriptionSTR50String5250
18Cost_Code_Description SearchCost Code DescriptionSTR30String3230
19POSTED SearchPostedTrue/FalseBoolean20

Leave a Reply

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