Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC92001
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Job_Transaction_VIEW
Physical Name: JC92001
Technical Name: JC_Job_Transaction_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 WS_Job_Number 
WS Job Number STR17_LBAU String 17 2 Project_Number WS Project Number STR170 String 17 3 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 4 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 5 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 6 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 7 Cost_Code_Description Cost Code Description STR30 String 30 8 Cost_Element Cost Element INT3_RB0_U Integer 3 9 Job_TRX_Number Job TRX Number STR20 String 20 10 Document_Source Document Source STR3 String 3 11 TRXSORCE TRX Source STR13 String 13 12 JRNENTRY Journal Entry LI8_U0 Long Integer 8 13 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].ACTINDX AS 'JC_Job_Transaction_VIEW-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['JC_Job_Transaction_VIEW'].ACTINDX = ['Account Index Master'].ACTINDX14 DISTTYPE Distribution Type DDL Integer 0 15 DOCNUMBR Document Number STR20_Document_Number String 20 16 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 17 PYADNMBR Payment/Adjustment Number LI8_U0 Long Integer 8 18 TRXDSCRN Transaction Description STR30 String 30 19 Cost_Code_Act_Cost_TTD Cost Code Actual Cost TTD DLR14_STR Currency 14 20 Cost_Code_Actual_Org_Cst Cost Code Actual Originating Cost DLR14_STR Currency 14 21 DOCDATE Document Date DT Date 8 22 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 23 DOCTYPE Document Type DDL_Document_Type Integer 0 24 GLPOSTDT GL Posting Date DT Date 8 25 Profit_Type_Number Profit Type Number INT2 Integer 2 26 Profit_Amount Profit Amount DLR14_TS Currency 14 27 Job_Type Job Type STR7_LBAU String 7 28 IVDOCTYP IV Document Type DDL_IV_Document_Type Integer 0 29 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].VENDORID AS 'JC_Job_Transaction_VIEW-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['JC_Job_Transaction_VIEW'].VENDORID = ['PM Vendor Master File'].VENDORID30 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].ITEMNMBR AS 'JC_Job_Transaction_VIEW-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
IV00101 AS ['Item Master']
ON
['JC_Job_Transaction_VIEW'].ITEMNMBR = ['Item Master'].ITEMNMBR31 UOFM U Of M U_Of_M String 8 32 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 17 33 TRX_QTY_PR TRX QTY PR LI6_S2 Long Integer 6 34 TRXLOCTN TRX Location STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].TRXLOCTN AS 'JC_Job_Transaction_VIEW-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['JC_Job_Transaction_VIEW'].TRXLOCTN = ['Site Setup'].LOCNCODE35 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 36 BACHNUMB Batch Number STR15_LBAU String 15 37 BCHSOURC Batch Source STR15 String 15 38 EMPLOYID Employee ID STR15_Employee_ID String 15 39 Payroll_Pay_Type Payroll Pay Type INT2_U0 Integer 2 40 COMPTRTP Computer TRX Type DDL_TRX_Type Integer 0 41 UPRTRXCD UPR TRX Code STR6_Payroll_Code String 6 42 TRXHRUNT TRX Hours/Units LI6_S2 Long Integer 6 43 PAYRTAMT Pay Rate Amount DLR11_$S2 Currency 14 44 VARDBAMT Variable Ded/Ben Amount DLR11_$S2 Currency 14 45 Transaction_Pay_Period Transaction Pay Period INT2_U0 Integer 2 46 TRXBEGDT TRX Beginning Date DT Date 8 47 TRXENDDT TRX Ending Date DT Date 8 48 WS_Transaction_Date WS Transaction Date DT Date 8 49 Unit_Decimal_Places Unit Decimal Places INT1_U0 Integer 1 50 Cost_Decimal_Places Cost Decimal Places INT1_U0 Integer 1 51 Ovrhd_1_Unit_Dec_Places Overhead 1 Unit Decimal Places INT1_U0 Integer 1 52 Overhead_1_Cst_Dec_Plcs Overhead 1 Cost Decimal Places INT1_U0 Integer 1 53 Overhead_Units_1 Overhead Units 1 DLR14_TS2 Currency 14 54 Overhead_1_Cst_Per_Unit Overhead 1 Cost Per Unit DLR8_RBU Currency 8 55 Overhead_1_Pct_Rate Overhead 1 % Rate DLR8_U2 Currency 8 56 UNIONCD Union Code STR6 String 6 57 DAYSWRDK Days Worked LI6_S2 Long Integer 6 58 WKSWRKD Weeks Worked LI6_S2 Long Integer 6 59 DEPRTMNT Department STR6_Payroll_Code String 6 60 JOBTITLE Job Title STR6_Payroll_Code String 6 61 STATECD State Code STR2_State_Code String 2 62 LOCALTAX Local Tax STR6_Payroll_Code String 6 63 SUTASTAT Suta State STR2_State_Code String 2 64 WRKRCOMP Workers Comp STR6_Payroll_Code String 6 65 FEDCLSSCD Federal Classification Code STR10_LBAU String 10 66 Production_Actual_Qty Production Actual Qty DLR14_TS Currency 14 67 Est_Pct_Complete_to_Date Est % Complete to Date INT5% Integer 5 68 Overhead_Group_Code Overhead Group Code STR51 String 5 69 Labor_Fixed_OH Labor Fixed OH DLR14_RBS0_UTR$ Currency 14 70 Labor_OH_Percentage Labor OH Percentage LI6_U2% Long Integer 6 71 Certified_Payroll Certified Payroll CB_Certified Boolean 0 72 Monday Monday LI6_S2 Long Integer 6 73 Tuesday Tuesday LI6_S2 Long Integer 6 74 Wednesday Wednesday LI6_S2 Long Integer 6 75 Thursday Thursday LI6_S2 Long Integer 6 76 Friday Friday LI6_S2 Long Integer 6 77 Saturday Saturday LI6_S2 Long Integer 6 78 Sunday Sunday LI6_S2 Long Integer 6 79 PSTGSTUS Posting Status INT Integer 0 80 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].CURNCYID AS 'JC_Job_Transaction_VIEW-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['JC_Job_Transaction_VIEW'].CURNCYID = ['Currency Setup'].CURNCYID81 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].CURRNIDX AS 'JC_Job_Transaction_VIEW-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['JC_Job_Transaction_VIEW'].CURRNIDX = ['Currency Setup'].CURRNIDX82 PORDNMBR Purchase Order Number Purchase Order Number String 20 83 Rate_Per_Unit Rate Per Unit DLR14_TS Currency 14 84 Billed_Amount Billed Amount DLR19_TS Currency 19 85 Billed_Invoice_Number_1 Billed Invoice Number 1 STR17_LBAU String 17 86 Billed_Invoice_Number_2 Billed Invoice Number 2 STR17_LBAU String 17 87 Billed_Transaction Billed Transaction CB Boolean 0 88 Credit_Memo_Number Credit Memo Number STR17_LBAU String 17 89 Credit_Transaction Credit Transaction CB Boolean 0 90 Unbillable_Transaction Unbillable Transaction CB Boolean 0 91 RATECLSS Rate Class STR15 String 15 92 WS_Cost_Type WS Cost Type DDL Integer 0 93 ICCURRID ICCurrencyID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].ICCURRID AS 'JC_Job_Transaction_VIEW-ICCurrencyID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['JC_Job_Transaction_VIEW'].ICCURRID = ['Currency Setup'].CURNCYID94 ICCURRIX ICCurrencyIndex INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].ICCURRIX AS 'JC_Job_Transaction_VIEW-ICCurrencyIndex'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['JC_Job_Transaction_VIEW'].ICCURRIX = ['Currency Setup'].CURRNIDX95 SHFTCODE Shift Code STR6_Payroll_Code String 6 96 SHFTPREM Shift Premium DLR11_$S2 Currency 14 97 Tax_Date Tax Date DT Date 8 98 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].USERID AS 'JC_Job_Transaction_VIEW-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_Job_Transaction_VIEW'].USERID = ['Users Master'].USERID99 User_Define_1 User Define 1 STR30 String 30 100 User_Define_2 User Define 2 STR30 String 30 101 USERDEF1 User Defined 1 STR20 String 20 102 USERDEF2 User Defined 2 STR20 String 20 103 User_Def_Integer_1 User Defined Integer 1 LI6_S2 Long Integer 6 104 User_Def_Integer_2 User Defined Integer 2 LI6_S2 Long Integer 6 105 User_Defined_Integer_3 User Defined Integer 3 LI6_S2 Long Integer 6 106 User_Defined_Integer_4 User Defined Integer 4 LI6_S2 Long Integer 6 107 User_Defined_Dollar_1 User Defined Dollar 1 DLR14_RBS0_STR$ Currency 14 108 User_Defined_Dollar_2 User Defined Dollar 2 DLR14_RBS0_STR$ Currency 14 109 User_Defined_Dollar_3 User Defined Dollar 3 DLR14_RBS0_STR$ Currency 14 110 User_Defined_Dollar_4 User Defined Dollar 4 DLR14_RBS0_STR$ Currency 14 111 USRDAT01 User Defined Date 1 DT Date 8 112 USRDAT02 User Defined Date 2 DT Date 8 113 User_Defined_Date_3 WS User Defined Date 3 DATE Date 6 114 User_Defined_Date_4 WS User Defined Date 4 DATE Date 6 115 User_Defined_CB_1 User Defined CB 1 CB Boolean 0 116 User_Defined_CB_2 User Defined CB 2 CB Boolean 0 117 User_Defined_CB_3 User Defined CB 3 CB Boolean 0 118 User_Defined_CB_4 User Defined CB 4 CB Boolean 0 119 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 120 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 121 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 122 MODIFDT Modified Date DT Date 8 123 Modified_Time Modified Time TM6 Time 6 124 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_Job_Transaction_VIEW'].MDFUSRID AS 'JC_Job_Transaction_VIEW-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC92001 AS ['JC_Job_Transaction_VIEW']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_Job_Transaction_VIEW'].MDFUSRID = ['Users Master'].USERID125 SV_Language_ID SV Language ID INT2 Integer 2 126 Time_Zone Time Zone STR3 String 3 127 WSReserved_CB1 WSReserved CB1 CB Boolean 0 128 WSReserved_CB2 WSReserved CB2 CB Boolean 0 129 WSReserved_CB3 WSReserved CB3 CB Boolean 0 130 WSReserved_CB4 WSReserved CB4 CB Boolean 0 131 WSReserved_CB5 WSReserved CB5 CB Boolean 0 132 WSReserved_STR1 WSReserved STR1 STR10 String 10 133 WSReserved_STR2 WSReserved STR2 STR10 String 10 134 WS_Manager_ID WS Manager ID STR15_Employee_ID String 15 135 WS_Inactive WS Inactive CB Boolean 0 136 Type_of_Transaction Type of Transaction DDL Integer 0 137 Next_Subdivision_Type Next Subdivision Type DDL_Next_Subdivision Integer 0 138 WS_Account_Index_1 WS Account Index 1 LI_14 Long Integer 14 139 WS_Account_Index_2 WS Account Index 2 LI_14 Long Integer 14 140 Added_By_CO_Module Added By CO Module Boolean Boolean 0 141 Track_Production_Qty Track Production Qty CB Boolean 0 142 Cost_Code_Act_Cost_YTD Cost Code Actual Cost YTD DLR14_RBS0_STR$ Currency 14 143 Actual_Units_TTD Actual Units TTD DLR14_TS Currency 14 144 Cost_Code_Estimated_Cst Cost Code Estimated Cost DLR19_TS Currency 19 145 Change_Order_Est_Cost Change Order Estimated Cost DLR19_TS Currency 19 146 Cost_Code_Rvsd_Est_Cost Cost Code Rvsd Estimated Cost DLR19_TS Currency 19 147 Cost_Code_Forecast_Cost Cost Code Forecasted Cost DLR19_TS Currency 19 148 Cost_Code_Rvsd_Forecast Cost Code Rvsd Forecast DLR19_TS Currency 19 149 Forecasted_Units Forecasted Units DLR14_TS Currency 14 150 Committed_Cost Committed Cost DLR19_TS Currency 19 151 Committed_Units Committed Units DLR14_U2 Currency 14 152 Cost_Code_Est_Unit Cost Code Estimated Units DLR14_TS2 Currency 14 153 Estimated_Amt_Units Estimated Amt/Units DLR19_TS Currency 19 154 Production_Estimate_Qty Production Estimate Qty DLR14_TS Currency 14 155 Production_Qty_Unit Production Qty/Unit DLR14_TS Currency 14 156 Production_Qty_Curr_Per Production Qty Current Period DLR12_TS Currency 12 157 Production_Best_Date Production Best Date DT Date 8 158 Production_Best Production Best DLR12_TS Currency 12 159 Production_Measure_Code Production Measure Code STR6 String 6 160 OVHD1_UOM OVHD1 UOM STR20 String 20 161 OVHD1_Type OVHD1 Type DDL_Overhead_Type Integer 0 162 OVHD1_Estimated_Units OVHD1 Estimated Units DLR14_TS Currency 14 163 OVHD1_Forecasted_Units OVHD1 Forecasted Units DLR14_TS Currency 14 164 OVHD1_Amt_Per_Unit OVHD1 Amt Per Unit DLR14_TS Currency 14 165 OVHD1_Estimated_Amount OVHD1 Estimated Amount DLR14_TS Currency 14 166 OVHD1_Actual_Amount OVHD1 Actual Amount DLR14_TS Currency 14 167 OVHD1_Profit_Type OVHD1 Profit Type DDL_Overhead_Type Integer 0 168 OVHD1_Profit_Amount OVHD1 Profit Amount DLR14_TS Currency 14 169 OVHD2_UOM OVHD2 UOM STR20 String 20 170 OVHD2_Type OVHD2 Type DDL_Overhead_Type Integer 0 171 OVHD2_Percent OVHD2 Percent INT5_%2 Integer 5 172 OVHD2_Estimated_Units OVHD2 Estimated Units DLR14_TS Currency 14 173 OVHD2_Actual_Units OVHD2 Actual Units DLR14_TS Currency 14 174 OVHD2_Forecasted_Units OVHD2 Forecasted Units DLR14_TS Currency 14 175 OVHD2_Amt_Per_Unit OVHD2 Amt Per Unit DLR14_TS Currency 14 176 OVHD2_Estimated_Amount OVHD2 Estimated Amount DLR14_TS Currency 14 177 OVHD2_Actual_Amount OVHD2 Actual Amount DLR14_TS Currency 14 178 OVHD2_Profit_Type OVHD2 Profit Type DDL_Overhead_Type Integer 0 179 OVHD2_Profit_Amount OVHD2 Profit Amount DLR14_TS Currency 14 180 Bill_Type Bill Type DDL_Overhead_Type Integer 0 181 Sched_Completion_Date Scheduled Completion Date DATE Date 6 182 ACTCOMPDATE Actual Completion Date DT Date 8 183 Schedule_Start_Date Schedule Start Date DATE Date 6 184 ACTSTARTDATE Actual Start Date DT Date 8 185 Billing_Schedule_Line Billing Schedule Line STR9 String 9 186 Estimated_Measure_Code Estimated Measure Code STR6 String 6 187 Amount_Pct_Complete Amount % Complete INT5_%2 Integer 5 188 Units_Pct_Complete Units % Complete INT5_%2 Integer 5 189 Production_Pct_Complete Production % Complete INT5_%2 Integer 5 190 Field_Pct_Complete Field % Complete INT5_%2 Integer 5 191 Posted_To Posted To CB Boolean 0 192 Change_Order_Est_Units Change Order Estimated Units DLR14_TS2 Currency 14 193 Labor_Group_Name Labor Group Name STR15_RM_Customer_Number String 15 194 VNDRNMBR Vendor Number Vendor_Number String 25 195 CC_Rvsd_Forecast_Units Cost Code Rvsd Forecast Units DLR14_TS2 Currency 14 196 Original_Estimate_Units Original Estimate Units DLR14_TS2 Currency 14 197 Original_Forecast_Units Original Forecast Units DLR14_TS2 Currency 14