Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC10702
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC Time Sheet TRX WORK
Physical Name: JC10702
Technical Name: JC_Time_Sheet_TRX_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 COMPTRNM 
Computer TRX Number LI8_U0 Long Integer 8 2 BACHNUMB Batch Number STR15_LBAU String 15 3 BCHSOURC Batch Source STR15 String 15 4 Document_Source Document Source STR3 String 3 5 EMPLOYID Employee ID STR15_Employee_ID String 15 6 Payroll_Pay_Type Payroll Pay Type INT2_U0 Integer 2 7 WS_Job_Number WS Job Number STR17_LBAU String 17 8 Project_Number WS Project Number STR170 String 17 9 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 10 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 11 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 12 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 13 Cost_Code_Description Cost Code Description STR30 String 30 14 Cost_Element Cost Element INT3_RB0_U Integer 3 15 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 16 Profit_Type_Number Profit Type Number INT2 Integer 2 17 Profit_Amount Profit Amount DLR14_TS Currency 14 18 COMPTRTP Computer TRX Type DDL_TRX_Type Integer 0 19 UPRTRXCD UPR TRX Code STR6_Payroll_Code String 6 20 TRXHRUNT TRX Hours/Units LI6_S2 Long Integer 6 21 PAYRTAMT Pay Rate Amount DLR11_$S2 Currency 14 22 VARDBAMT Variable Ded/Ben Amount DLR11_$S2 Currency 14 23 Transaction_Pay_Period Transaction Pay Period INT2_U0 Integer 2 24 Cost_Code_Act_Cost_TTD Cost Code Actual Cost TTD DLR14_STR Currency 14 25 TRXBEGDT TRX Beginning Date DT Date 8 26 TRXENDDT TRX Ending Date DT Date 8 27 TRXDSCRN Transaction Description STR30 String 30 28 Unit_Decimal_Places Unit Decimal Places INT1_U0 Integer 1 29 Cost_Decimal_Places Cost Decimal Places INT1_U0 Integer 1 30 TRX_QTY_PR TRX QTY PR LI6_S2 Long Integer 6 31 Cost_Per_Unit Cost Per Unit DLR8_RBU Currency 8 32 Ovrhd_1_Unit_Dec_Places Overhead 1 Unit Decimal Places INT1_U0 Integer 1 33 Overhead_1_Cst_Dec_Plcs Overhead 1 Cost Decimal Places INT1_U0 Integer 1 34 Overhead_Units_1 Overhead Units 1 DLR14_TS2 Currency 14 35 Overhead_1_Cst_Per_Unit Overhead 1 Cost Per Unit DLR8_RBU Currency 8 36 Overhead_1_Percent Overhead 1 Percent Boolean Boolean 0 37 Overhead_1_Pct_Rate Overhead 1 % Rate DLR8_U2 Currency 8 38 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['JC Time Sheet TRX WORK'].ACTINDX AS 'JC Time Sheet TRX WORK-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
JC10702 AS ['JC Time Sheet TRX WORK']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['JC Time Sheet TRX WORK'].ACTINDX = ['Account Index Master'].ACTINDX39 UNIONCD Union Code STR6 String 6 40 DAYSWRDK Days Worked LI6_S2 Long Integer 6 41 DEPRTMNT Department STR6_Payroll_Code String 6 42 JOBTITLE Job Title STR6_Payroll_Code String 6 43 STATECD State Code STR2_State_Code String 2 44 LOCALTAX Local Tax STR6_Payroll_Code String 6 45 SUTASTAT Suta State STR2_State_Code String 2 46 WRKRCOMP Workers Comp STR6_Payroll_Code String 6 47 FEDCLSSCD Federal Classification Code STR10_LBAU String 10 48 Production_Actual_Qty Production Actual Qty DLR14_TS Currency 14 49 Est_Pct_Complete_to_Date Est % Complete to Date INT5% Integer 5 50 Overhead_Group_Code Overhead Group Code STR51 String 5 51 Fixed_Portion_Total Fixed Portion Total DLR11_USR Currency 11 52 Ovrhd_Det_Pct_Prtn_Tot Overhead Det % Portion Total INT5_%2 Integer 5 53 Certified_Payroll Certified Payroll CB_Certified Boolean 0 54 Monday Monday LI6_S2 Long Integer 6 55 Tuesday Tuesday LI6_S2 Long Integer 6 56 Wednesday Wednesday LI6_S2 Long Integer 6 57 Thursday Thursday LI6_S2 Long Integer 6 58 Friday Friday LI6_S2 Long Integer 6 59 Saturday Saturday LI6_S2 Long Integer 6 60 Sunday Sunday LI6_S2 Long Integer 6 61 PSTGSTUS Posting Status INT Integer 0 62 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC Time Sheet TRX WORK'].USERID AS 'JC Time Sheet TRX WORK-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC10702 AS ['JC Time Sheet TRX WORK']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC Time Sheet TRX WORK'].USERID = ['Users Master'].USERID63 User_Define_1 User Define 1 STR30 String 30 64 User_Define_2 User Define 2 STR30 String 30 65 USERDEF1 User Defined 1 STR20 String 20 66 USERDEF2 User Defined 2 STR20 String 20 67 User_Def_Integer_1 User Defined Integer 1 LI6_S2 Long Integer 6 68 User_Def_Integer_2 User Defined Integer 2 LI6_S2 Long Integer 6 69 User_Defined_Integer_3 User Defined Integer 3 LI6_S2 Long Integer 6 70 User_Defined_Integer_4 User Defined Integer 4 LI6_S2 Long Integer 6 71 User_Defined_Dollar_1 User Defined Dollar 1 DLR14_RBS0_STR$ Currency 14 72 User_Defined_Dollar_2 User Defined Dollar 2 DLR14_RBS0_STR$ Currency 14 73 User_Defined_Dollar_3 User Defined Dollar 3 DLR14_RBS0_STR$ Currency 14 74 User_Defined_Dollar_4 User Defined Dollar 4 DLR14_RBS0_STR$ Currency 14 75 USRDAT01 User Defined Date 1 DT Date 8 76 USRDAT02 User Defined Date 2 DT Date 8 77 User_Defined_Date_3 WS User Defined Date 3 DATE Date 6 78 User_Defined_Date_4 WS User Defined Date 4 DATE Date 6 79 User_Defined_CB_1 User Defined CB 1 CB Boolean 0 80 User_Defined_CB_2 User Defined CB 2 CB Boolean 0 81 User_Defined_CB_3 User Defined CB 3 CB Boolean 0 82 User_Defined_CB_4 User Defined CB 4 CB Boolean 0 83 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 84 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 85 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 86 MODIFDT Modified Date DT Date 8 87 Modified_Time Modified Time TM6 Time 6 88 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC Time Sheet TRX WORK'].MDFUSRID AS 'JC Time Sheet TRX WORK-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC10702 AS ['JC Time Sheet TRX WORK']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC Time Sheet TRX WORK'].MDFUSRID = ['Users Master'].USERID89 SV_Language_ID SV Language ID INT2 Integer 2 90 Time_Zone Time Zone STR3 String 3 91 WSReserved_CB1 WSReserved CB1 CB Boolean 0 92 WSReserved_CB2 WSReserved CB2 CB Boolean 0 93 WSReserved_CB3 WSReserved CB3 CB Boolean 0 94 WSReserved_CB4 WSReserved CB4 CB Boolean 0 95 WSReserved_CB5 WSReserved CB5 CB Boolean 0 96 WSReserved_CB6 WSReserved CB6 CB Boolean 0 97 WSReserved_CB7 WSReserved CB7 CB Boolean 0 98 WSReserved_CB8 WSReserved CB8 CB Boolean 0 99 WSReserved_CB9 WSReserved CB9 CB Boolean 0 100 WSReserved_CB10 WSReserved CB10 CB Boolean 0 101 WSReserved_STR1 WSReserved STR1 STR10 String 10 102 WSReserved_STR2 WSReserved STR2 STR10 String 10