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 TypeLength
1COMPTRNM SearchComputer TRX NumberLI8_U0Long Integer8
2BCHSOURC SearchBatch SourceSTR15String15
3Document_Source SearchDocument SourceSTR3String3
4EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
5Payroll_Pay_Type SearchPayroll Pay TypeINT2_U0Integer2
6WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
7Project_Number SearchWS Project NumberSTR170String17
8Cost_Code_Number_1 SearchCost Code Number:CC_PhaseSTR6_CC_PhaseString6
9Cost_Code_Number_2 SearchCost Code Number:CC_StepSTR6_CC_StepsString6
10Cost_Code_Number_3 SearchCost Code Number:CC_DetailSTR6_CC_DetailString6
11Cost_Code_Number_4 SearchCost Code Number:CC_ComponentSTR6_CC_ComponentString6
12Cost_Code_Description SearchCost Code DescriptionSTR30String30
13Cost_Element SearchCost ElementINT3_RB0_UInteger3
14LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
15Profit_Type_Number SearchProfit Type NumberINT2Integer2
16Profit_Amount SearchProfit AmountDLR14_TSCurrency14
17COMPTRTP SearchComputer TRX TypeDDL_TRX_TypeInteger0
18UPRTRXCD SearchUPR TRX CodeSTR6_Payroll_CodeString6
19TRXHRUNT SearchTRX Hours/UnitsLI6_S2Long Integer6
20PAYRTAMT SearchPay Rate AmountDLR11_$S2Currency14
21VARDBAMT SearchVariable Ded/Ben AmountDLR11_$S2Currency14
22Transaction_Pay_Period SearchTransaction Pay PeriodINT2_U0Integer2
23Cost_Code_Act_Cost_TTD SearchCost Code Actual Cost TTDDLR14_STRCurrency14
24TRXBEGDT SearchTRX Beginning DateDTDate8
25TRXENDDT SearchTRX Ending DateDTDate8
26WS_Transaction_Date SearchWS Transaction DateDTDate8
27TRXDSCRN SearchTransaction DescriptionSTR30String30
28Unit_Decimal_Places SearchUnit Decimal PlacesINT1_U0Integer1
29Cost_Decimal_Places SearchCost Decimal PlacesINT1_U0Integer1
30TRX_QTY_PR SearchTRX QTY PRLI6_S2Long Integer6
31TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
32Cost_Per_Unit SearchCost Per UnitDLR8_RBUCurrency8
33Ovrhd_1_Unit_Dec_Places SearchOverhead 1 Unit Decimal PlacesINT1_U0Integer1
34Overhead_1_Cst_Dec_Plcs SearchOverhead 1 Cost Decimal PlacesINT1_U0Integer1
35Overhead_Units_1 SearchOverhead Units 1DLR14_TS2Currency14
36Overhead_1_Cst_Per_Unit SearchOverhead 1 Cost Per UnitDLR8_RBUCurrency8
37Overhead_1_Percent SearchOverhead 1 PercentBooleanBoolean0
38Overhead_1_Pct_Rate SearchOverhead 1 % RateDLR8_U2Currency8
39ACTINDX SearchAccount IndexLI_14Long Integer14
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 CodeSTR6String6
41RATECLSS SearchRate ClassSTR15String15
42DAYSWRDK SearchDays WorkedLI6_S2Long Integer6
43WKSWRKD SearchWeeks WorkedLI6_S2Long Integer6
44DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
45JOBTITLE SearchJob TitleSTR6_Payroll_CodeString6
46STATECD SearchState CodeSTR2_State_CodeString2
47LOCALTAX SearchLocal TaxSTR6_Payroll_CodeString6
48SUTASTAT SearchSuta StateSTR2_State_CodeString2
49WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
50FEDCLSSCD SearchFederal Classification CodeSTR10_LBAUString10
51WS_Cost_Type SearchWS Cost TypeDDLInteger0
52Production_Actual_Qty SearchProduction Actual QtyDLR14_TSCurrency14
53Est_Pct_Complete_to_Date SearchEst % Complete to DateINT5%Integer5
54Overhead_Group_Code SearchOverhead Group CodeSTR51String5
55Labor_Fixed_OH SearchLabor Fixed OHDLR14_RBS0_UTR$Currency14
56User_Define_2 SearchUser Define 2STR30String30
57USERDEF1 SearchUser Defined 1STR20String20
58USERDEF2 SearchUser Defined 2STR20String20
59User_Def_Integer_1 SearchUser Defined Integer 1LI6_S2Long Integer6
60User_Def_Integer_2 SearchUser Defined Integer 2LI6_S2Long Integer6
61User_Defined_Integer_3 SearchUser Defined Integer 3LI6_S2Long Integer6
62User_Defined_Integer_4 SearchUser Defined Integer 4LI6_S2Long Integer6
63User_Defined_Dollar_1 SearchUser Defined Dollar 1DLR14_RBS0_STR$Currency14
64User_Defined_Dollar_2 SearchUser Defined Dollar 2DLR14_RBS0_STR$Currency14
65User_Defined_Dollar_3 SearchUser Defined Dollar 3DLR14_RBS0_STR$Currency14
66User_Defined_Dollar_4 SearchUser Defined Dollar 4DLR14_RBS0_STR$Currency14
67USRDAT01 SearchUser Defined Date 1DTDate8
68USRDAT02 SearchUser Defined Date 2DTDate8
69User_Defined_Date_3 SearchWS User Defined Date 3DATEDate6
70User_Defined_Date_4 SearchWS User Defined Date 4DATEDate6
71User_Defined_CB_1 SearchUser Defined CB 1CBBoolean0
72User_Defined_CB_2 SearchUser Defined CB 2CBBoolean0
73User_Defined_CB_3 SearchUser Defined CB 3CBBoolean0
74User_Defined_CB_4 SearchUser Defined CB 4CBBoolean0
75Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
76Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
77Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
78MODIFDT SearchModified DateDTDate8
79Modified_Time SearchModified TimeTM6Time6
80MDFUSRID SearchModified User IDSTR15String15
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 IDINT2Integer2
82Time_Zone SearchTime ZoneSTR3String3
83WSReserved_CB1 SearchWSReserved CB1CBBoolean0
84WSReserved_CB2 SearchWSReserved CB2CBBoolean0
85WSReserved_CB3 SearchWSReserved CB3CBBoolean0
86WSReserved_CB4 SearchWSReserved CB4CBBoolean0
87WSReserved_CB5 SearchWSReserved CB5CBBoolean0
88WSReserved_CB6 SearchWSReserved CB6CBBoolean0
89WSReserved_CB7 SearchWSReserved CB7CBBoolean0
90WSReserved_CB8 SearchWSReserved CB8CBBoolean0
91WSReserved_CB9 SearchWSReserved CB9CBBoolean0
92WSReserved_CB10 SearchWSReserved CB10CBBoolean0
93WSReserved_STR1 SearchWSReserved STR1STR10String10
94WSReserved_STR2 SearchWSReserved STR2STR10String10
95BasePayRateAmount SearchBase Pay Rate AmountDLR11_$S2Currency14
96EmployeeFringe SearchEmployee FringeDLR11_$S2Currency14
97PrevailingFringe SearchPrevailing FringeDLR11_$S2Currency14
98CashFringe SearchCash FringeDLR11_$S2Currency14
99EmployeeRate SearchEmployee RateDLR11_$S2Currency14
100EmployeeHomeRCRate SearchEmployee Home Rate Class RateDLR11_$S2Currency14
101JobTransactionRCRate SearchJob Transaction Rate Class RateDLR11_$S2Currency14
102PYADNMBR SearchPayment/Adjustment NumberLI8_U0Long Integer8
103VOIDPYADNMBR SearchVoid Payment/Adjustment NumberLI8_U0Long Integer8
azurecurveProductsWennSoft Products (131)3rd PartyJC_Union_Transaction_OPEN (JC20601)

Leave a Reply

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