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 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_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_LBUString128
16Cost_Element_Desc SearchCost Element DescriptionSTR15String15
17ACTDESCR SearchAccount DescriptionSTR50String50
18Cost_Code_Description SearchCost Code DescriptionSTR30String30
19POSTED SearchPostedTrue/FalseBoolean0

Leave a Reply

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