Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC30523
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Invoice_Schedule_Bill_Codes_HIST
Physical Name: JC30523
Technical Name: JC_Invoice_Schedule_Bill_Codes_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RMDNUMWK 
RM Document Number-WORK STR17_LBAU String 17 2 WS_Job_Number WS Job Number STR17_LBAU String 17 3 Cost_Element Cost Element INT3_RB0_U Integer 3 4 Bill_Code_Number Bill Code Number STR26 String 26 5 Bill_Code_Description Bill Code Description STR30 String 30 6 Bill_Pct Bill % INT5% Integer 5 7 Bill_Amount Bill Amount DLR19_TS Currency 19 8 Billed_Amount_TTD Billed Amount TTD DLR19_TS Currency 19 9 Total_Billable_Amount Total Billable Amount DLR19_TS Currency 19 10 Orig_Tot_Billable_Amt Originating Total Billable Amount DLR19_RBS0_STR$ Currency 19 11 Orig_Bill_Amt Originating Bill Amount DLR19_RBS0_STR$ Currency 19 12 OrigBilledAmtTTD Originating Billed Amount TTD DLR19_RBS0_STR$ Currency 19 13 Retention_Billed_TTD Retention Billed TTD DLR14_TS Currency 14 14 OrigRetentionBilledTTD Originating Retention Billed TTD DLR14_TS Currency 14 15 OrigRetentionAmtTTD Originating Retention Amount TTD DLR14_TS Currency 14 16 Added_By_CO_Module Added By CO Module Boolean Boolean 0 17 Change_Order_Nbr Change Order # STR14 String 14 18 Units_Billable Units Billable DLR14_TS Currency 14 19 Units_Billed_TTD Units Billed TTD DLR14_TS Currency 14 20 Units_Billing_Rate Units Billing Rate DLR14_TS Currency 14 21 Retention_Amount_TTD Retention Amount TTD DLR14_TS Currency 14 22 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['JC_Invoice_Schedule_Bill_Codes_HIST'].ACTINDX AS 'JC_Invoice_Schedule_Bill_Codes_HIST-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
JC30523 AS ['JC_Invoice_Schedule_Bill_Codes_HIST']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['JC_Invoice_Schedule_Bill_Codes_HIST'].ACTINDX = ['Account Index Master'].ACTINDX23 Profit_Type_Number Profit Type Number INT2 Integer 2 24 Profit_Amount Profit Amount DLR14_TS Currency 14 25 Work_In_Place Work In Place DLR14_TS Currency 14 26 Stored_To_Date Stored To Date DLR14_TS Currency 14 27 Bill_Code_Alias Bill Code Alias STR30 String 30 28 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_Invoice_Schedule_Bill_Codes_HIST'].USERID AS 'JC_Invoice_Schedule_Bill_Codes_HIST-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC30523 AS ['JC_Invoice_Schedule_Bill_Codes_HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_Invoice_Schedule_Bill_Codes_HIST'].USERID = ['Users Master'].USERID29 User_Define_1 User Define 1 STR30 String 30 30 User_Define_2 User Define 2 STR30 String 30 31 USERDEF1 User Defined 1 STR20 String 20 32 USERDEF2 User Defined 2 STR20 String 20 33 User_Defined_Dollar_1 User Defined Dollar 1 DLR14_RBS0_STR$ Currency 14 34 User_Defined_Dollar_2 User Defined Dollar 2 DLR14_RBS0_STR$ Currency 14 35 User_Defined_Dollar_3 User Defined Dollar 3 DLR14_RBS0_STR$ Currency 14 36 User_Defined_Dollar_4 User Defined Dollar 4 DLR14_RBS0_STR$ Currency 14 37 User_Def_Integer_1 User Defined Integer 1 LI6_S2 Long Integer 6 38 User_Def_Integer_2 User Defined Integer 2 LI6_S2 Long Integer 6 39 User_Defined_Integer_3 User Defined Integer 3 LI6_S2 Long Integer 6 40 User_Defined_Integer_4 User Defined Integer 4 LI6_S2 Long Integer 6 41 USRDAT01 User Defined Date 1 DT Date 8 42 USRDAT02 User Defined Date 2 DT Date 8 43 User_Defined_Date_3 WS User Defined Date 3 DATE Date 6 44 User_Defined_Date_4 WS User Defined Date 4 DATE Date 6 45 User_Defined_CB_1 User Defined CB 1 CB Boolean 0 46 User_Defined_CB_2 User Defined CB 2 CB Boolean 0 47 User_Defined_CB_3 User Defined CB 3 CB Boolean 0 48 User_Defined_CB_4 User Defined CB 4 CB Boolean 0 49 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC_Invoice_Schedule_Bill_Codes_HIST'].MDFUSRID AS 'JC_Invoice_Schedule_Bill_Codes_HIST-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC30523 AS ['JC_Invoice_Schedule_Bill_Codes_HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC_Invoice_Schedule_Bill_Codes_HIST'].MDFUSRID = ['Users Master'].USERID50 MODIFDT Modified Date DT Date 8 51 Modified_Time Modified Time TM6 Time 6 52 SV_Language_ID SV Language ID INT2 Integer 2 53 Time_Zone Time Zone STR3 String 3 54 Wennsoft_Affiliate Wennsoft Affiliate STR15_LBAU String 15 55 Wennsoft_Branch Wennsoft Branch STR15_LBAU String 15 56 Wennsoft_Region Wennsoft Region STR15_LBAU String 15 57 WSReserved_CB1 WSReserved CB1 CB Boolean 0 58 WSReserved_CB2 WSReserved CB2 CB Boolean 0 59 WSReserved_CB3 WSReserved CB3 CB Boolean 0 60 WSReserved_CB4 WSReserved CB4 CB Boolean 0 61 WSReserved_CB5 WSReserved CB5 CB Boolean 0 62 WSReserved_CB6 WSReserved CB6 CB Boolean 0 63 WSReserved_CB7 WSReserved CB7 CB Boolean 0 64 WSReserved_CB8 WSReserved CB8 CB Boolean 0 65 WSReserved_CB9 WSReserved CB9 CB Boolean 0 66 WSReserved_CB10 WSReserved CB10 CB Boolean 0 67 WSReserved_STR1 WSReserved STR1 STR10 String 10 68 WSReserved_STR2 WSReserved STR2 STR10 String 10 69 Allocated_Percent Allocated Percent DLR14_RBS0_STR$ Currency 14 70 Revenue_Allocated Revenue Allocated DLR19_TS Currency 19 71 Percent_Complete Percent Complete DLR14_RBS0_STR$ Currency 14 72 Est_Hr_to_Complete Est Hr to Complete DLR14_TS2 Currency 14 73 Estimate_Date Estimate Date DT Date 8 74 WS_Inactive WS Inactive CB Boolean 0 75 Reimbursable Reimbursable CB_Reimbursable Boolean 0 76 Project_Number WS Project Number STR170 String 17