WS Time Sheet TRX WORK_AUDIT (WSAUDT)

azurecurve Products WennSoft Products (131)3rd PartyWS Time Sheet TRX WORK_AUDIT (WSAUDT)

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

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

Display Name: WS Time Sheet TRX WORK_AUDIT
Physical Name: WSAUDT
Technical Name: WS_Time_Sheet_TRX_WORK_AUDIT

Group Display Name: TimeTrack
Group Technical Name: TimeTrack

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	WS_Transaction_Type	WS Transaction Type	STR10_LBAU	String	10
7	WS_Cost_Type	WS Cost Type	DDL	Integer	0
8	Payroll_Pay_Type	Payroll Pay Type	INT2_U0	Integer	2
9	WS_Job_Number	WS Job Number	STR17_LBAU	String	17
10	Project_Number	WS Project Number	STR170	String	17
11	Appointment	Appointment	STR25	String	25
12	Cost_Code_Number_1	Cost Code Number:CC_Phase	STR6_CC_Phase	String	6
13	Cost_Code_Number_2	Cost Code Number:CC_Step	STR6_CC_Steps	String	6
14	Cost_Code_Number_3	Cost Code Number:CC_Detail	STR6_CC_Detail	String	6
15	Cost_Code_Number_4	Cost Code Number:CC_Component	STR6_CC_Component	String	6
16	WS_Cost_Code	WS Cost Code	LI8_U0	Long Integer	8
17	Cost_Element	Cost Element	INT3_RB0_U	Integer	3
18	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	19
19	Profit_Type_Number	Profit Type Number	INT2	Integer	2
20	Profit_Amount	Profit Amount	DLR14_TS	Currency	14
21	COMPTRTP	Computer TRX Type	DDL_TRX_Type	Integer	0
22	UPRTRXCD	UPR TRX Code	STR6_Payroll_Code	String	6
23	TRXHRUNT	TRX Hours/Units	LI6_S2	Long Integer	6
24	Billing_Amount	Billing Amount	DLR14_RBS0_STR$	Currency	14
25	PAYRTAMT	Pay Rate Amount	DLR11_$S2	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	TRX_QTY_PR	TRX QTY PR	LI6_S2	Long Integer	6
36	TRXQTY	TRX QTY	DLR17_QTY_RBS0_STR	Currency	17
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	OH_Amount	OH Amount	DLR14_RBS0_STR$	Currency	14
45	ACTINDX	Account Index	LI_14	Long Integer	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].ACTINDX AS 'WS Time Sheet TRX WORK_AUDIT-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['WS Time Sheet TRX WORK_AUDIT'].ACTINDX = ['Account Index Master'].ACTINDX
46	UNIONCD	Union Code	STR6	String	6
47	RATECLSS	Rate Class	STR15	String	15
48	DAYSWRDK	Days Worked	LI6_S2	Long Integer	6
49	WKSWRKD	Weeks Worked	LI6_S2	Long Integer	6
50	DEPRTMNT	Department	STR6_Payroll_Code	String	6
51	JOBTITLE	Job Title	STR6_Payroll_Code	String	6
52	STATECD	State Code	STR2_State_Code	String	2
53	LOCALTAX	Local Tax	STR6_Payroll_Code	String	6
54	SUTASTAT	Suta State	STR2_State_Code	String	2
55	WRKRCOMP	Workers Comp	STR6_Payroll_Code	String	6
56	FEDCLSSCD	Federal Classification Code	STR10_LBAU	String	10
57	Production_Actual_Qty	Production Actual Qty	DLR14_TS	Currency	14
58	Est_Pct_Complete_to_Date	Est % Complete to Date	INT5%	Integer	5
59	Overhead_Group_Code	Overhead Group Code	STR51	String	5
60	Labor_Fixed_OH	Labor Fixed OH	DLR14_RBS0_UTR$	Currency	14
61	Labor_OH_Percentage	Labor OH Percentage	LI6_U2%	Long Integer	6
62	Certified_Payroll	Certified Payroll	CB_Certified	Boolean	0
63	Monday	Monday	LI6_S2	Long Integer	6
64	Tuesday	Tuesday	LI6_S2	Long Integer	6
65	Wednesday	Wednesday	LI6_S2	Long Integer	6
66	Thursday	Thursday	LI6_S2	Long Integer	6
67	Friday	Friday	LI6_S2	Long Integer	6
68	Saturday	Saturday	LI6_S2	Long Integer	6
69	Sunday	Sunday	LI6_S2	Long Integer	6
70	PSTGSTUS	Posting Status	INT	Integer	0
71	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].USERID AS 'WS Time Sheet TRX WORK_AUDIT-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['WS Time Sheet TRX WORK_AUDIT'].USERID = ['Users Master'].USERID
72	WS_Module	WS Module	STR2	String	2
73	Equipment_ID	Equipment ID	STR30	String	30
74	Task_Code	Task Code	STR10	String	10
75	DYOFWEEK	Day of Week	STR20	String	20
76	ADRSCODE	Address Code	STR15_Address_Code	String	15
77	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].CUSTNMBR AS 'WS Time Sheet TRX WORK_AUDIT-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['WS Time Sheet TRX WORK_AUDIT'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
78	ASSETID	Asset ID	STR15_Asset_ID	String	15
79	ASSETIDSUF	Asset ID Suffix	INT3_U0	Integer	3
80	ASSETINDEX	Asset Index	LI9_Asset_Index	Long Integer	9
	Key to the Asset General Information Master (FA00100). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].ASSETINDEX AS 'WS Time Sheet TRX WORK_AUDIT-Asset Index' ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN FA00100 AS ['Asset General Information Master'] ON ['WS Time Sheet TRX WORK_AUDIT'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
81	ITEMNMBR	Item Number	STR30_Item_Number	String	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].ITEMNMBR AS 'WS Time Sheet TRX WORK_AUDIT-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN IV00101 AS ['Item Master'] ON ['WS Time Sheet TRX WORK_AUDIT'].ITEMNMBR = ['Item Master'].ITEMNMBR
82	ITEMDESC	Item Description	STR100	String	100
83	UOFM	U Of M	U_Of_M	String	8
84	WS_Extended_Cost	WS Extended Cost	DLR14_RBS0_STR$	Currency	14
85	VENDORID	Vendor ID	STR_15_Vendor_ID	String	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].VENDORID AS 'WS Time Sheet TRX WORK_AUDIT-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['WS Time Sheet TRX WORK_AUDIT'].VENDORID = ['PM Vendor Master File'].VENDORID
86	LOCNCODE	Location Code	STR10_Location_Code	String	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].LOCNCODE AS 'WS Time Sheet TRX WORK_AUDIT-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN IV40700 AS ['Site Setup'] ON ['WS Time Sheet TRX WORK_AUDIT'].LOCNCODE = ['Site Setup'].LOCNCODE
87	SHFTCODE	Shift Code	STR6_Payroll_Code	String	6
88	SHFTPREM	Shift Premium	DLR11_$S2	Currency	14
89	TRX_Verified	TRX Verified	Boolean	Boolean	0
90	TRX_Origin	TRX Origin	STR13	String	13
91	Time_In	Time In	TM6	Time	6
92	Time_In_Date	Time In Date	DATE	Date	6
93	Time_Out	Time Out	TM6	Time	6
94	Time_Out_Date	Time Out Date	DATE	Date	6
95	WO_Task_ID	EQS WO Task ID	STR15_LBAU	String	15
96	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
97	EQSEQUIPID	EQS Equipment ID	STR30_LBAU	String	30
98	EQS_Cost_Code	EQS Cost Code	STR15_LBAU	String	15
99	Time_Zone	Time Zone	STR3	String	3
100	SV_Language_ID	SV Language ID	INT2	Integer	2
101	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
102	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
103	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
104	MODIFDT	Modified Date	DT	Date	8
105	Modified_Time	Modified Time	TM6	Time	6
106	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['WS Time Sheet TRX WORK_AUDIT'].MDFUSRID AS 'WS Time Sheet TRX WORK_AUDIT-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM WSAUDT AS ['WS Time Sheet TRX WORK_AUDIT'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['WS Time Sheet TRX WORK_AUDIT'].MDFUSRID = ['Users Master'].USERID
107	User_Define_1	User Define 1	STR30	String	30
108	User_Define_2	User Define 2	STR30	String	30
109	USERDEF1	User Defined 1	STR20	String	20
110	USERDEF2	User Defined 2	STR20	String	20
111	User_Def_Integer_1	User Defined Integer 1	LI6_S2	Long Integer	6
112	User_Def_Integer_2	User Defined Integer 2	LI6_S2	Long Integer	6
113	User_Defined_Integer_3	User Defined Integer 3	LI6_S2	Long Integer	6
114	User_Defined_Integer_4	User Defined Integer 4	LI6_S2	Long Integer	6
115	User_Defined_Dollar_1	User Defined Dollar 1	DLR14_RBS0_STR$	Currency	14
116	User_Defined_Dollar_2	User Defined Dollar 2	DLR14_RBS0_STR$	Currency	14
117	User_Defined_Dollar_3	User Defined Dollar 3	DLR14_RBS0_STR$	Currency	14
118	User_Defined_Dollar_4	User Defined Dollar 4	DLR14_RBS0_STR$	Currency	14
119	USRDAT01	User Defined Date 1	DT	Date	8
120	USRDAT02	User Defined Date 2	DT	Date	8
121	User_Defined_Date_3	WS User Defined Date 3	DATE	Date	6
122	User_Defined_Date_4	WS User Defined Date 4	DATE	Date	6
123	User_Defined_CB_1	User Defined CB 1	CB	Boolean	0
124	User_Defined_CB_2	User Defined CB 2	CB	Boolean	0
125	User_Defined_CB_3	User Defined CB 3	CB	Boolean	0
126	User_Defined_CB_4	User Defined CB 4	CB	Boolean	0
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_CB6	WSReserved CB6	CB	Boolean	0
133	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
134	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
135	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
136	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
137	ERMSGTXT	Error Message Text	STR255	String	255
138	BasePayRateAmount	Base Pay Rate Amount	DLR11_$S2	Currency	14
139	EmployeeFringe	Employee Fringe	DLR11_$S2	Currency	14
140	PrevailingFringe	Prevailing Fringe	DLR11_$S2	Currency	14
141	CashFringe	Cash Fringe	DLR11_$S2	Currency	14
142	EmployeeRate	Employee Rate	DLR11_$S2	Currency	14
143	EmployeeHomeRCRate	Employee Home Rate Class Rate	DLR11_$S2	Currency	14
144	JobTransactionRCRate	Job Transaction Rate Class Rate	DLR11_$S2	Currency	14
145	WS_Posting_Status	WS Posting Status	long	Long Integer	8

azurecurve Products WennSoft Products (131)3rd PartyWS Time Sheet TRX WORK_AUDIT (WSAUDT)

Leave a Reply Cancel reply