WSWHSE - WS Time Sheet TRX WORK Warehouse

SQL Query Builder

SELECT * FROM WSWHSE

137 Columns

Select all

Column	Description	Type	Shared With
COMPTRNM		int	9 tables
BACHNUMB		char(15)	122 tables
BCHSOURC		char(15)	104 tables
Document_Source		char(3)	22 tables
EMPLOYID		char(15)	63 tables
WS_Transaction_Type		char(11)	4 tables
WS_Cost_Type		smallint	5 tables
Payroll_Pay_Type		smallint	7 tables
WS_Job_Number		char(17)	90 tables
Project_Number		char(17)	52 tables
Appointment		char(25)	7 tables
Cost_Code_Number_1		char(7)	38 tables
Cost_Code_Number_2		char(7)	38 tables
Cost_Code_Number_3		char(7)	38 tables
Cost_Code_Number_4		char(7)	38 tables
WS_Cost_Code		int	21 tables
Cost_Element		smallint	45 tables
LNSEQNBR		numeric(19,5) 0	34 tables
Profit_Type_Number		smallint	25 tables
Profit_Amount		numeric(19,5)	24 tables
COMPTRTP		smallint	6 tables
UPRTRXCD		char(7)	9 tables
TRXHRUNT		int	9 tables
Billing_Amount		numeric(19,5)	7 tables
PAYRTAMT		numeric(19,5)	9 tables
VARDBAMT		numeric(19,5)	6 tables
Transaction_Pay_Period		smallint	5 tables
Cost_Code_Act_Cost_TTD		numeric(19,5)	14 tables
TRXBEGDT		datetime	9 tables
TRXENDDT		datetime	9 tables
WS_Transaction_Date		datetime	6 tables
TRXDSCRN		char(31)	37 tables
Unit_Decimal_Places		smallint	5 tables
Cost_Decimal_Places		smallint	5 tables
TRX_QTY_PR		int	5 tables
TRXQTY		numeric(19,5)	25 tables
Cost_Per_Unit		numeric(19,5)	5 tables
Ovrhd_1_Unit_Dec_Places		smallint	5 tables
Overhead_1_Cst_Dec_Plcs		smallint	5 tables
Overhead_Units_1		numeric(19,5)	5 tables
Overhead_1_Cst_Per_Unit		numeric(19,5)	5 tables
Overhead_1_Percent		tinyint	5 tables
Overhead_1_Pct_Rate		numeric(19,5)	5 tables
OH_Amount		numeric(19,5)	6 tables
ACTINDX	Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules.	int	91 tables
UNIONCD		char(7)	14 tables
RATECLSS		char(15)	14 tables
DAYSWRDK		int	8 tables
WKSWRKD		int	8 tables
DEPRTMNT		char(7)	12 tables
JOBTITLE		char(7)	15 tables
STATECD		char(3)	16 tables
LOCALTAX		char(7)	12 tables
SUTASTAT		char(3)	19 tables
WRKRCOMP		char(7)	22 tables
FEDCLSSCD		char(11)	12 tables
Production_Actual_Qty		numeric(19,5)	9 tables
Est_Pct_Complete_to_Date		smallint	7 tables
Overhead_Group_Code		char(5)	7 tables
Labor_Fixed_OH		numeric(19,5)	8 tables
Labor_OH_Percentage		int	7 tables
Certified_Payroll		tinyint	7 tables
Monday		int	4 tables
Tuesday		int	4 tables
Wednesday		int	4 tables
Thursday		int	4 tables
Friday		int	4 tables
Saturday		int	4 tables
Sunday		int	4 tables
PSTGSTUS		smallint	50 tables
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
USERID		char(15)	338 tables
WS_Module		char(3)	5 tables
Equipment_ID		char(31)	54 tables
Task_Code		char(11)	39 tables
DYOFWEEK		char(21)	5 tables
ADRSCODE		char(15)	164 tables
CUSTNMBR		char(15)	230 tables
ASSETID		char(15)	11 tables
ASSETIDSUF		smallint	6 tables
ASSETINDEX		int	15 tables
ITEMNMBR		char(31)	87 tables
ITEMDESC		char(101)	42 tables
UOFM		char(9)	47 tables
WS_Extended_Cost		numeric(19,5)	6 tables
VENDORID		char(15)	107 tables
LOCNCODE		char(11)	51 tables
SHFTCODE		char(7)	7 tables
SHFTPREM		numeric(19,5)	7 tables
Time_In		datetime	4 tables
Time_In_Date		datetime	4 tables
Time_Out		datetime	4 tables
Time_Out_Date		datetime	4 tables
WO_Task_ID		char(15)	3 tables
SEQNUMBR		int	86 tables
EQSEQUIPID		char(31)	3 tables
EQS_Cost_Code		char(15)	3 tables
Time_Zone		char(3)	273 tables
SV_Language_ID		smallint	245 tables
Wennsoft_Affiliate		char(15)	289 tables
Wennsoft_Branch		char(15)	288 tables
Wennsoft_Region		char(15)	289 tables
MODIFDT		datetime	394 tables
Modified_Time		datetime	326 tables
MDFUSRID		char(15)	349 tables
Warehouse_Note_String		char(255)	-
Warehouse_Note_String2		char(255)	-
User_Define_1		char(31)	103 tables
User_Define_2		char(31)	104 tables
USERDEF1		char(21)	138 tables
USERDEF2		char(21)	138 tables
User_Def_Integer_1		int	97 tables
User_Def_Integer_2		int	97 tables
User_Defined_Integer_3		int	92 tables
User_Defined_Integer_4		int	92 tables
User_Defined_Dollar_1		numeric(19,5)	97 tables
User_Defined_Dollar_2		numeric(19,5)	97 tables
User_Defined_Dollar_3		numeric(19,5)	92 tables
User_Defined_Dollar_4		numeric(19,5)	92 tables
USRDAT01		datetime	100 tables
USRDAT02		datetime	98 tables
User_Defined_Date_3		datetime	87 tables
User_Defined_Date_4		datetime	87 tables
User_Defined_CB_1		tinyint	97 tables
User_Defined_CB_2		tinyint	97 tables
User_Defined_CB_3		tinyint	92 tables
User_Defined_CB_4		tinyint	92 tables
WSReserved_CB1		tinyint	326 tables
WSReserved_CB2		tinyint	325 tables
WSReserved_CB3		tinyint	320 tables
WSReserved_CB4		tinyint	317 tables
WSReserved_CB5		tinyint	318 tables
WSReserved_CB6		tinyint	172 tables
WSReserved_CB7		tinyint	172 tables
WSReserved_CB8		tinyint	169 tables
WSReserved_CB9		tinyint	169 tables
WSReserved_CB10		tinyint	172 tables
DEX_ROW_ID		int auto number (1,1)	608 tables