JC_Union_Transaction_OPEN (JC20601)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Union_Transaction_OPEN (JC20601)

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

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

Display Name: JC_Union_Transaction_OPEN
Physical Name: JC20601
Technical Name: JC_Union_Transaction_OPEN

Group Display Name: Job Cost
Group Technical Name: Job Cost

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

Click to show/hide

SELECT
       ['JC_Union_Transaction_OPEN'].ACTINDX AS 'JC_Union_Transaction_OPEN-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       JC20601 AS ['JC_Union_Transaction_OPEN']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['JC_Union_Transaction_OPEN'].ACTINDX = ['Account Index Master'].ACTINDX
40UNIONCD SearchUnion CodeSTR6String86
41RATECLSS SearchRate ClassSTR15String1615
42DAYSWRDK SearchDays WorkedLI6_S2Long Integer46
43WKSWRKD SearchWeeks WorkedLI6_S2Long Integer46
44DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
45JOBTITLE SearchJob TitleSTR6_Payroll_CodeString86
46STATECD SearchState CodeSTR2_State_CodeString42
47LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString86
48SUTASTAT SearchSuta StateSTR2_State_CodeString42
49WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
50FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString1210
51WS_Cost_Type SearchWS Cost TypeDDLInteger20
52Production_Actual_Qty SearchProduction Actual QtyDLR14_TSCurrency1014
53Est_Pct_Complete_to_Date SearchEst % Complete to DateINT5%Integer25
54Overhead_Group_Code SearchOverhead Group CodeSTR51String65
55Labor_Fixed_OH SearchLabor Fixed OHDLR14_RBS0_UTR$Currency1014
56User_Define_2 SearchUser Define 2STR30String3230
57USERDEF1 SearchUser Defined 1STR20String2220
58USERDEF2 SearchUser Defined 2STR20String2220
59User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer46
60User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer46
61User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer46
62User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer46
63User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency1014
64User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency1014
65User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency1014
66User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency1014
67USRDAT01 SearchUser Defined Date 1DTDate48
68USRDAT02 SearchUser Defined Date 2DTDate48
69User_Defined_Date_3 SearchWS User Defined Date 3DATEDate46
70User_Defined_Date_4 SearchWS User Defined Date 4DATEDate46
71User_Defined_CB_1 SearchUser Defined CB 1CBBoolean20
72User_Defined_CB_2 SearchUser Defined CB 2CBBoolean20
73User_Defined_CB_3 SearchUser Defined CB 3CBBoolean20
74User_Defined_CB_4 SearchUser Defined CB 4CBBoolean20
75Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
76Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
77Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
78MODIFDT SearchModified DateDTDate48
79Modified_Time SearchModified TimeTM6Time46
80MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['JC_Union_Transaction_OPEN'].MDFUSRID AS 'JC_Union_Transaction_OPEN-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       JC20601 AS ['JC_Union_Transaction_OPEN']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['JC_Union_Transaction_OPEN'].MDFUSRID = ['Users Master'].USERID
81SV_Language_ID SearchSV Language IDINT2Integer22
82Time_Zone SearchTime ZoneSTR3String43
83WSReserved_CB1 SearchWSReserved CB1CBBoolean20
84WSReserved_CB2 SearchWSReserved CB2CBBoolean20
85WSReserved_CB3 SearchWSReserved CB3CBBoolean20
86WSReserved_CB4 SearchWSReserved CB4CBBoolean20
87WSReserved_CB5 SearchWSReserved CB5CBBoolean20
88WSReserved_CB6 SearchWSReserved CB6CBBoolean20
89WSReserved_CB7 SearchWSReserved CB7CBBoolean20
90WSReserved_CB8 SearchWSReserved CB8CBBoolean20
91WSReserved_CB9 SearchWSReserved CB9CBBoolean20
92WSReserved_CB10 SearchWSReserved CB10CBBoolean20
93WSReserved_STR1 SearchWSReserved STR1STR10String1210
94WSReserved_STR2 SearchWSReserved STR2STR10String1210
95BasePayRateAmount SearchBase Pay Rate AmountDLR11_$S2Currency1014
96EmployeeFringe SearchEmployee FringeDLR11_$S2Currency1014
97PrevailingFringe SearchPrevailing FringeDLR11_$S2Currency1014
98CashFringe SearchCash FringeDLR11_$S2Currency1014
99EmployeeRate SearchEmployee RateDLR11_$S2Currency1014
100EmployeeHomeRCRate SearchEmployee Home Rate Class RateDLR11_$S2Currency1014
101JobTransactionRCRate SearchJob Transaction Rate Class RateDLR11_$S2Currency1014
102PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer48
103VOIDPYADNMBR SearchVoid Payment/Adjustment NumberLI8_U0Long Integer48
azurecurveProductsWennSoft Products (131)3rd PartyJC_Union_Transaction_OPEN (JC20601)

Leave a Reply

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