JC_Payroll_Transaction_WORK (JC10701)

azurecurve Products WennSoft Products (131)3rd PartyJC_Payroll_Transaction_WORK (JC10701)

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

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

Display Name: JC_Payroll_Transaction_WORK
Physical Name: JC10701
Technical Name: JC_Payroll_Transaction_WORK

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	COMPTRNM	Computer TRX Number	LI8_U0	Long Integer	8
2	BACHNUMB	Batch Number	STR15_LBAU	String	15
3	BCHSOURC	Batch Source	STR15	String	15
4	Document_Source	Document Source	STR3	String	3
5	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
6	Payroll_Pay_Type	Payroll Pay Type	INT2_U0	Integer	2
7	Product_Indicator	Product Indicator	DDL_Product_Indicator	Integer	0
8	WS_Job_Number	WS Job Number	STR17_LBAU	String	17
9	Project_Number	WS Project Number	STR170	String	17
10	Cost_Code_Number_1	Cost Code Number:CC_Phase	STR6_CC_Phase	String	6
11	Cost_Code_Number_2	Cost Code Number:CC_Step	STR6_CC_Steps	String	6
12	Cost_Code_Number_3	Cost Code Number:CC_Detail	STR6_CC_Detail	String	6
13	Cost_Code_Number_4	Cost Code Number:CC_Component	STR6_CC_Component	String	6
14	Cost_Code_Description	Cost Code Description	STR30	String	30
15	Cost_Element	Cost Element	INT3_RB0_U	Integer	3
16	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	19
17	Profit_Type_Number	Profit Type Number	INT2	Integer	2
18	Profit_Amount	Profit Amount	DLR14_TS	Currency	14
19	COMPTRTP	Computer TRX Type	DDL_TRX_Type	Integer	0
20	UPRTRXCD	UPR TRX Code	STR6_Payroll_Code	String	6
21	TRXHRUNT	TRX Hours/Units	LI6_S2	Long Integer	6
22	PAYRTAMT	Pay Rate Amount	DLR11_$S2	Currency	14
23	Billing_Amount	Billing Amount	DLR14_RBS0_STR$	Currency	14
24	WS_Extended_Cost	WS Extended Cost	DLR14_RBS0_STR$	Currency	14
25	OH_Amount	OH Amount	DLR14_RBS0_STR$	Currency	14
26	VARDBAMT	Variable Ded/Ben Amount	DLR11_$S2	Currency	14
27	Transaction_Pay_Period	Transaction Pay Period	INT2_U0	Integer	2
28	Cost_Code_Act_Cost_TTD	Cost Code Actual Cost TTD	DLR14_STR	Currency	14
29	TRXBEGDT	TRX Beginning Date	DT	Date	8
30	TRXENDDT	TRX Ending Date	DT	Date	8
31	WS_Transaction_Date	WS Transaction Date	DT	Date	8
32	TRXDSCRN	Transaction Description	STR30	String	30
33	Unit_Decimal_Places	Unit Decimal Places	INT1_U0	Integer	1
34	Cost_Decimal_Places	Cost Decimal Places	INT1_U0	Integer	1
35	TRXQTY	TRX QTY	DLR17_QTY_RBS0_STR	Currency	17
36	TRX_QTY_PR	TRX QTY PR	LI6_S2	Long Integer	6
37	Cost_Per_Unit	Cost Per Unit	DLR8_RBU	Currency	8
38	Ovrhd_1_Unit_Dec_Places	Overhead 1 Unit Decimal Places	INT1_U0	Integer	1
39	Overhead_1_Cst_Dec_Plcs	Overhead 1 Cost Decimal Places	INT1_U0	Integer	1
40	Overhead_Units_1	Overhead Units 1	DLR14_TS2	Currency	14
41	Overhead_1_Cst_Per_Unit	Overhead 1 Cost Per Unit	DLR8_RBU	Currency	8
42	Overhead_1_Percent	Overhead 1 Percent	Boolean	Boolean	0
43	Overhead_1_Pct_Rate	Overhead 1 % Rate	DLR8_U2	Currency	8
44	ACTINDX	Account Index	LI_14	Long Integer	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['JC_Payroll_Transaction_WORK'].ACTINDX AS 'JC_Payroll_Transaction_WORK-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM JC10701 AS ['JC_Payroll_Transaction_WORK'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['JC_Payroll_Transaction_WORK'].ACTINDX = ['Account Index Master'].ACTINDX
45	UNIONCD	Union Code	STR6	String	6
46	DAYSWRDK	Days Worked	LI6_S2	Long Integer	6
47	WKSWRKD	Weeks Worked	LI6_S2	Long Integer	6
48	DEPRTMNT	Department	STR6_Payroll_Code	String	6
49	JOBTITLE	Job Title	STR6_Payroll_Code	String	6
50	STATECD	State Code	STR2_State_Code	String	2
51	LOCALTAX	Local Tax	STR6_Payroll_Code	String	6
52	SUTASTAT	Suta State	STR2_State_Code	String	2
53	WRKRCOMP	Workers Comp	STR6_Payroll_Code	String	6
54	FEDCLSSCD	Federal Classification Code	STR10_LBAU	String	10
55	Production_Actual_Qty	Production Actual Qty	DLR14_TS	Currency	14
56	Est_Pct_Complete_to_Date	Est % Complete to Date	INT5%	Integer	5
57	Overhead_Group_Code	Overhead Group Code	STR51	String	5
58	Labor_Fixed_OH	Labor Fixed OH	DLR14_RBS0_UTR$	Currency	14
59	Labor_OH_Percentage	Labor OH Percentage	LI6_U2%	Long Integer	6
60	Certified_Payroll	Certified Payroll	CB_Certified	Boolean	0
61	DYOFWEEK	Day of Week	STR20	String	20
62	Monday	Monday	LI6_S2	Long Integer	6
63	Tuesday	Tuesday	LI6_S2	Long Integer	6
64	Wednesday	Wednesday	LI6_S2	Long Integer	6
65	Thursday	Thursday	LI6_S2	Long Integer	6
66	Friday	Friday	LI6_S2	Long Integer	6
67	Saturday	Saturday	LI6_S2	Long Integer	6
68	Sunday	Sunday	LI6_S2	Long Integer	6
69	PSTGSTUS	Posting Status	INT	Integer	0
70	RATECLSS	Rate Class	STR15	String	15
71	WS_Cost_Type	WS Cost Type	DDL	Integer	0
72	WS_Cost_Code	WS Cost Code	LI8_U0	Long Integer	8
73	WS_Transaction_Type	WS Transaction Type	STR10_LBAU	String	10
74	Task_Code	Task Code	STR10	String	10
75	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['JC_Payroll_Transaction_WORK'].CUSTNMBR AS 'JC_Payroll_Transaction_WORK-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM JC10701 AS ['JC_Payroll_Transaction_WORK'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['JC_Payroll_Transaction_WORK'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
76	ADRSCODE	Address Code	STR15_Address_Code	String	15
77	Equipment_ID	Equipment ID	STR30	String	30
78	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['JC_Payroll_Transaction_WORK'].VENDORID AS 'JC_Payroll_Transaction_WORK-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM JC10701 AS ['JC_Payroll_Transaction_WORK'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['JC_Payroll_Transaction_WORK'].VENDORID = ['PM Vendor Master File'].VENDORID
79	ITEMNMBR	Item Number	STR30_Item_Number	String	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['JC_Payroll_Transaction_WORK'].ITEMNMBR AS 'JC_Payroll_Transaction_WORK-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM JC10701 AS ['JC_Payroll_Transaction_WORK'] INNER JOIN IV00101 AS ['Item Master'] ON ['JC_Payroll_Transaction_WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
80	ITEMDESC	Item Description	STR100	String	100
81	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
82	ASSETID	Asset ID	STR15_Asset_ID	String	15
83	SHFTCODE	Shift Code	STR6_Payroll_Code	String	6
84	SHFTPREM	Shift Premium	DLR11_$S2	Currency	14
85	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Payroll_Transaction_WORK'].USERID AS 'JC_Payroll_Transaction_WORK-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC10701 AS ['JC_Payroll_Transaction_WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Payroll_Transaction_WORK'].USERID = ['Users Master'].USERID
86	User_Define_1	User Define 1	STR30	String	30
87	User_Define_2	User Define 2	STR30	String	30
88	USERDEF1	User Defined 1	STR20	String	20
89	USERDEF2	User Defined 2	STR20	String	20
90	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
91	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
92	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
93	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
94	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
95	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
96	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
97	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
98	USRDAT01	User Defined Date 1	DT	Date	8
99	USRDAT02	User Defined Date 2	DT	Date	8
100	User_Defined_Date_3	WS User Defined Date 3	DATE	Date	6
101	User_Defined_Date_4	WS User Defined Date 4	DATE	Date	6
102	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
103	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
104	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
105	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
106	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
107	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
108	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
109	MODIFDT	Modified Date	DT	Date	8
110	Modified_Time	Modified Time	TM6	Time	6
111	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['JC_Payroll_Transaction_WORK'].MDFUSRID AS 'JC_Payroll_Transaction_WORK-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM JC10701 AS ['JC_Payroll_Transaction_WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['JC_Payroll_Transaction_WORK'].MDFUSRID = ['Users Master'].USERID
112	SV_Language_ID	SV Language ID	INT2	Integer	2
113	Time_Zone	Time Zone	STR3	String	3
114	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
115	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
116	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
117	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
118	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
119	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
120	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
121	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
122	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
123	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
124	WSReserved_STR1	WSReserved STR1	STR10	String	10
125	WSReserved_STR2	WSReserved STR2	STR10	String	10
126	BasePayRateAmount	Base Pay Rate Amount	DLR11_$S2	Currency	14
127	EmployeeFringe	Employee Fringe	DLR11_$S2	Currency	14
128	PrevailingFringe	Prevailing Fringe	DLR11_$S2	Currency	14
129	CashFringe	Cash Fringe	DLR11_$S2	Currency	14
130	EmployeeRate	Employee Rate	DLR11_$S2	Currency	14
131	EmployeeHomeRCRate	Employee Home Rate Class Rate	DLR11_$S2	Currency	14
132	JobTransactionRCRate	Job Transaction Rate Class Rate	DLR11_$S2	Currency	14

azurecurve Products WennSoft Products (131)3rd PartyJC_Payroll_Transaction_WORK (JC10701)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply