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 TypeLength
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
3Divisions SearchDivisionsSTR15_LBAUString15
4Project_Number SearchWS Project NumberSTR170String17
5WS_Job_Name SearchWS Job NameSTR30String30
6TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
7UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
8Overhead_1_Cst_Per_Unit SearchOverhead 1 Cost Per UnitDLR8_RBUCurrency8
9Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency14
10WS_Labor_Cost SearchWS Labor CostDLR14_TSCurrency14
11USERID SearchUser IDSTR15_User_IDString15
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 *