WS Time Sheet TRX WORK (WS10702)

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

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

Display Name: WS Time Sheet TRX WORK
Physical Name: WS10702
Technical Name: WS_Time_Sheet_TRX_WORK

Group Display Name: TimeTrack
Group Technical Name: TimeTrack

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1COMPTRNM SearchComputer TRX NumberLI8_U0Long Integer48
2BACHNUMB SearchBatch NumberSTR15_LBAUString1615
3BCHSOURC SearchBatch SourceSTR15String1615
4Document_Source SearchDocument SourceSTR3String43
5EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
6WS_Transaction_Type SearchWS Transaction TypeSTR10_LBAUString1210
7WS_Transaction_Status SearchWS Transaction StatusDDL_TRX_StatusInteger20
8WS_Cost_Type SearchWS Cost TypeDDLInteger20
9Payroll_Pay_Type SearchPayroll Pay TypeINT2_U0Integer22
10WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
11Project_Number SearchWS Project NumberSTR170String1817
12Appointment SearchAppointmentSTR25String2625
13Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString86
14Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString86
15Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString86
16Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString86
17WS_Cost_Code SearchWS Cost CodeLI8_U0Long Integer48
18Cost_Element SearchCost ElementINT3_RB0_UInteger23
19LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
20Profit_Type_Number SearchProfit Type NumberINT2Integer22
21Profit_Amount SearchProfit AmountDLR14_TSCurrency1014
22COMPTRTP SearchComputer TRX TypeDDL_TRX_TypeInteger20
23UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString86
24TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer46
25Billing_Amount SearchBilling AmountDLR14_RBS0_STR$Currency1014
26PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency1014
27VARDBAMT SearchVariable Ded/Ben AmountDLR11_$S2Currency1014
28Transaction_Pay_Period SearchTransaction Pay PeriodINT2_U0Integer22
29Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency1014
30TRXBEGDT SearchTRX Beginning DateDTDate48
31TRXENDDT SearchTRX Ending DateDTDate48
32WS_Transaction_Date SearchWS Transaction DateDTDate48
33TRXDSCRN SearchTransaction DescriptionSTR30String3230
34Unit_Decimal_Places SearchUnit Decimal PlacesINT1_U0Integer21
35Cost_Decimal_Places SearchCost Decimal PlacesINT1_U0Integer21
36TRX_QTY_PR SearchTRX QTY PRLI6_S2Long Integer46
37TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
38Cost_Per_Unit SearchCost Per UnitDLR8_RBUCurrency108
39Ovrhd_1_Unit_Dec_Places SearchOverhead 1 Unit Decimal PlacesINT1_U0Integer21
40Overhead_1_Cst_Dec_Plcs SearchOverhead 1 Cost Decimal PlacesINT1_U0Integer21
41Overhead_Units_1 SearchOverhead Units 1DLR14_TS2Currency1014
42Overhead_1_Cst_Per_Unit SearchOverhead 1 Cost Per UnitDLR8_RBUCurrency108
43Overhead_1_Percent SearchOverhead 1 PercentBooleanBoolean20
44Overhead_1_Pct_Rate SearchOverhead 1 % RateDLR8_U2Currency108
45OH_Amount SearchOH AmountDLR14_RBS0_STR$Currency1014
46ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].ACTINDX AS 'WS Time Sheet TRX WORK-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['WS Time Sheet TRX WORK'].ACTINDX = ['Account Index Master'].ACTINDX
47UNIONCD SearchUnion CodeSTR6String86
48RATECLSS SearchRate ClassSTR15String1615
49DAYSWRDK SearchDays WorkedLI6_S2Long Integer46
50WKSWRKD SearchWeeks WorkedLI6_S2Long Integer46
51DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
52JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
53STATECD SearchState CodeSTR2_State_CodeString42
54LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
55SUTASTAT SearchSuta StateSTR2_State_CodeString42
56WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
57FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString1210
58Production_Actual_Qty SearchProduction Actual QtyDLR14_TSCurrency1014
59Est_Pct_Complete_to_Date SearchEst % Complete to DateINT5%Integer25
60Overhead_Group_Code SearchOverhead Group CodeSTR51String65
61Labor_Fixed_OH SearchLabor Fixed OHDLR14_RBS0_UTR$Currency1014
62Labor_OH_Percentage SearchLabor OH PercentageLI6_U2%Long Integer46
63Certified_Payroll SearchCertified PayrollCB_CertifiedBoolean20
64Monday SearchMondayLI6_S2Long Integer46
65Tuesday SearchTuesdayLI6_S2Long Integer46
66Wednesday SearchWednesdayLI6_S2Long Integer46
67Thursday SearchThursdayLI6_S2Long Integer46
68Friday SearchFridayLI6_S2Long Integer46
69Saturday SearchSaturdayLI6_S2Long Integer46
70Sunday SearchSundayLI6_S2Long Integer46
71PSTGSTUS SearchPosting StatusINTInteger20
72USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].USERID AS 'WS Time Sheet TRX WORK-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS Time Sheet TRX WORK'].USERID = ['Users Master'].USERID
73WS_Module SearchWS ModuleSTR2String42
74Equipment_ID SearchEquipment IDSTR30String3230
75Task_Code SearchTask CodeSTR10String1210
76DYOFWEEK SearchDay of WeekSTR20String2220
77ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
78CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].CUSTNMBR AS 'WS Time Sheet TRX WORK-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['WS Time Sheet TRX WORK'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
79ASSETID SearchAsset IDSTR15_Asset_IDString1615
80ASSETIDSUF SearchAsset ID SuffixINT3_U0Integer23
81ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer49
Key to the Asset General Information Master (FA00100).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].ASSETINDEX AS 'WS Time Sheet TRX WORK-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['WS Time Sheet TRX WORK'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
82ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].ITEMNMBR AS 'WS Time Sheet TRX WORK-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['WS Time Sheet TRX WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
83ITEMDESC SearchItem DescriptionSTR100String102100
84UOFM SearchU Of MU_Of_MString108
85WS_Extended_Cost SearchWS Extended CostDLR14_RBS0_STR$Currency1014
86VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].VENDORID AS 'WS Time Sheet TRX WORK-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['WS Time Sheet TRX WORK'].VENDORID = ['PM Vendor Master File'].VENDORID
87LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].LOCNCODE AS 'WS Time Sheet TRX WORK-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['WS Time Sheet TRX WORK'].LOCNCODE = ['Site Setup'].LOCNCODE
88SHFTCODE SearchShift CodeSTR6_Payroll_CodeString86
89SHFTPREM SearchShift PremiumDLR11_$S2Currency1014
90TRX_Verified SearchTRX VerifiedBooleanBoolean20
91TRX_Origin SearchTRX OriginSTR13String1413
92Time_In SearchTime InTM6Time46
93Time_In_Date SearchTime In DateDATEDate46
94Time_Out SearchTime OutTM6Time46
95Time_Out_Date SearchTime Out DateDATEDate46
96WO_Task_ID SearchEQS WO Task IDSTR15_LBAUString1615
97SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
98EQSEQUIPID SearchEQS Equipment IDSTR30_LBAUString3230
99EQS_Cost_Code SearchEQS Cost CodeSTR15_LBAUString1615
100Time_Zone SearchTime ZoneSTR3String43
101SV_Language_ID SearchSV Language IDINT2Integer22
102Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
103Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
104Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
105GRPCOMPTRNM SearchGroup Computer TRX NumberLI8_U0Long Integer48
106WS_Manager_Comment SearchWS Manager CommentSTR30String3230
107MODIFDT SearchModified DateDTDate48
108Modified_Time SearchModified TimeTM6Time46
109MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['WS Time Sheet TRX WORK'].MDFUSRID AS 'WS Time Sheet TRX WORK-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WS10702 AS ['WS Time Sheet TRX WORK']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS Time Sheet TRX WORK'].MDFUSRID = ['Users Master'].USERID
110User_Define_1 SearchUser Define 1STR30String3230
111User_Define_2 SearchUser Define 2STR30String3230
112USERDEF1 SearchUser Defined 1STR20String2220
113USERDEF2 SearchUser Defined 2STR20String2220
114User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
115User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
116User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
117User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
118User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
119User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
120User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
121User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
122USRDAT01 SearchUser Defined Date 1DTDate48
123USRDAT02 SearchUser Defined Date 2DTDate48
124User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
125User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
126User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
127User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
128User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
129User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
130WSReserved_CB1 SearchWSReserved CB1CBBoolean20
131WSReserved_CB2 SearchWSReserved CB2CBBoolean20
132WSReserved_CB3 SearchWSReserved CB3CBBoolean20
133WSReserved_CB4 SearchWSReserved CB4CBBoolean20
134WSReserved_CB5 SearchWSReserved CB5CBBoolean20
135WSReserved_CB6 SearchWSReserved CB6CBBoolean20
136WSReserved_CB7 SearchWSReserved CB7CBBoolean20
137WSReserved_CB8 SearchWSReserved CB8CBBoolean20
138WSReserved_CB9 SearchWSReserved CB9CBBoolean20
139WSReserved_CB10 SearchWSReserved CB10CBBoolean20
140BasePayRateAmount SearchBase Pay Rate AmountDLR11_$S2Currency1014
141EmployeeFringe SearchEmployee FringeDLR11_$S2Currency1014
142PrevailingFringe SearchPrevailing FringeDLR11_$S2Currency1014
143CashFringe SearchCash FringeDLR11_$S2Currency1014
144EmployeeRate SearchEmployee RateDLR11_$S2Currency1014
145EmployeeHomeRCRate SearchEmployee Home Rate Class RateDLR11_$S2Currency1014
146JobTransactionRCRate SearchJob Transaction Rate Class RateDLR11_$S2Currency1014
147WS_Posting_Status SearchWS Posting StatuslongLong Integer48

Leave a Reply

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