JC_Labor_Summary_VIEW (JC90100)

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

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

Display Name: JC_Labor_Summary_VIEW
Physical Name: JC90100
Technical Name: JC_Labor_Summary_VIEW

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
3Divisions SearchDivisionsSTR15_LBAUString1615
4Project_Number SearchWS Project NumberSTR170String1817
5WS_Job_Name SearchWS Job NameSTR30String3230
6TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
7UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
8Overhead_1_Cst_Per_Unit SearchOverhead 1 Cost Per UnitDLR8_RBUCurrency108
9Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency1014
10WS_Labor_Cost SearchWS Labor CostDLR14_TSCurrency1014
11USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Labor_Summary_VIEW'].USERID AS 'JC_Labor_Summary_VIEW-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC90100 AS ['JC_Labor_Summary_VIEW']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Labor_Summary_VIEW'].USERID = ['Users Master'].USERID

Leave a Reply

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