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