Dynamics GP Table Reference - COMPANY..TimeCard fields

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module TM tables TimeCard

You are currently viewing the COMPANY database.
Change

COMPANY..TimeCard Table Definition

(COMPANY..)

Field Definitions:

	Column Name	Data Type Default Value		Source
	TB_Time_Card_#	char ''

	TB_TC_Wk_Beg_Date	datetime '1/1/1900'

	TB_Contract_#	char ''

	CUSTNMBR	char ''	Customer N...(more) Join Now	PA01101.CUSTNMBR
join ... more text available
	EMPLOYID	char ''	Employee I...(more) Join Now	PA11801.EMPLOYID
join ... more text available
	Emp_ID_Approval_1	char ''

	Emp_ID_Approval_2	char ''

	DEPRTMNT	char ''	Department...(more) Join Now	WC010931.DEPRTMNT
join ... more text available
	JOBTITLE	char ''

	TB_Cont_Reg_Bill	numeric 0.00

	TB_Cont_Reg_Time	char ''

	TB_Cont_Reg_Rate	numeric 0.00

	TB_TC_Reg_Mon_Hrs	numeric 0.00

	TB_TC_Reg_Tue_Hrs	numeric 0.00

	TB_TC_Reg_Wed_Hrs	numeric 0.00

	TB_TC_Reg_Thu_Hrs	numeric 0.00

	TB_TC_Reg_Fri_Hrs	numeric 0.00

	TB_TC_Reg_Sat_Hrs	numeric 0.00

	TB_TC_Reg_Sun_Hrs	numeric 0.00

	TB_TC_Reg_Hrs	numeric 0.00

	TB_TC_Reg_Bill_Hrs	numeric 0.00

	TB_Cont_OT_Daily	tinyint 0

	TB_Cont_OT_Bill	numeric 0.00

	TB_Cont_OT_Pay_Code	char ''

	TB_Cont_OT_Pay_Rate	numeric 0.00

	TB_TC_OT_Daily_Mon	numeric 0.00

	TB_TC_OT_Daily_Tues	numeric 0.00

	TB_TC_OT_Daily_Wed	numeric 0.00

	TB_TC_OT_Daily_Thur	numeric 0.00

	TB_TC_OT_Daily_Fri	numeric 0.00

	TB_TC_OT_Daily_Sat	numeric 0.00

	TB_TC_OT_Daily_Sun	numeric 0.00

	TB_TC_OT_Daily_Hrs	numeric 0.00

	TB_TC_OT_Daily_Bill	numeric 0.00

	TB_Cont_OT_Wk_Paid	tinyint 0

	TB_Cont_OT_Wkly_Act	numeric 0.00

	TB_Cont_OT_Wk_Bill	numeric 0.00

	TB_Cont_OT_Wk_Code	char ''

	TB_Cont_OT_Wk_Rate	numeric 0.00

	TB_TC_OT_Wk_Hrs	numeric 0.00

	TB_TC_OT_Wk_Bill_Hr	numeric 0.00

	TB_Cont_Other_Paid	tinyint 0

	TB_Cont_Other_Act	numeric 0.00

	TB_Cont_Other_Bill	numeric 0.00

	TB_Cont_Other_Code	char ''

	TB_Cont_Other_Rate	numeric 0.00

	TB_TC_Other_Hrs	numeric 0.00

	TB_TC_Other_Bill	numeric 0.00

	TB_TC_Hrs	numeric 0.00

	TB_TC_Bill_Hrs	numeric 0.00

	TB_TC_Desc_Mon	char ''

	TB_TC_Desc_Tues	char ''

	TB_TC_Desc_Wed	char ''

	TB_TC_Desc_Thur	char ''

	TB_TC_Desc_Fri	char ''

	TB_TC_Desc_Sat	char ''

	TB_TC_Desc_Sun	char ''

	TB_TC_Posted	tinyint 0

	TB_TC_Mon_Start_1	datetime '1/1/1900'

	TB_TC_Mon_Start_2	datetime '1/1/1900'

	TB_TC_Mon_Start_3	datetime '1/1/1900'

	TB_TC_Mon_End_1	datetime '1/1/1900'

	TB_TC_Mon_End_2	datetime '1/1/1900'

	TB_TC_Mon_End_3	datetime '1/1/1900'

	TB_TC_Tue_Start_1	datetime '1/1/1900'

	TB_TC_Tue_Start_2	datetime '1/1/1900'

	TB_TC_Tue_Start_3	datetime '1/1/1900'

	TB_TC_Tue_End_1	datetime '1/1/1900'

	TB_TC_Tue_End_2	datetime '1/1/1900'

	TB_TC_Tue_End_3	datetime '1/1/1900'

	TB_TC_Wed_Start_1	datetime '1/1/1900'

	TB_TC_Wed_Start_2	datetime '1/1/1900'

	TB_TC_Wed_Start_3	datetime '1/1/1900'

	TB_TC_Wed_End_1	datetime '1/1/1900'

	TB_TC_Wed_End_2	datetime '1/1/1900'

	TB_TC_Wed_End_3	datetime '1/1/1900'

	TB_TC_Thu_Start_1	datetime '1/1/1900'

	TB_TC_Thu_Start_2	datetime '1/1/1900'

	TB_TC_Thu_Start_3	datetime '1/1/1900'

	TB_TC_Thu_End_1	datetime '1/1/1900'

	TB_TC_Thu_End_2	datetime '1/1/1900'

	TB_TC_Thu_End_3	datetime '1/1/1900'

	TB_TC_Fri_Start_1	datetime '1/1/1900'

	TB_TC_Fri_Start_2	datetime '1/1/1900'

	TB_TC_Fri_Start_3	datetime '1/1/1900'

	TB_TC_Fri_End_1	datetime '1/1/1900'

	TB_TC_Fri_End_2	datetime '1/1/1900'

	TB_TC_Fri_End_3	datetime '1/1/1900'

	TB_TC_Sat_Start_1	datetime '1/1/1900'

	TB_TC_Sat_Start_2	datetime '1/1/1900'

	TB_TC_Sat_Start_3	datetime '1/1/1900'

	TB_TC_Sat_End_1	datetime '1/1/1900'

	TB_TC_Sat_End_2	datetime '1/1/1900'

	TB_TC_Sat_End_3	datetime '1/1/1900'

	TB_TC_Sun_Start_1	datetime '1/1/1900'

	TB_TC_Sun_Start_2	datetime '1/1/1900'

	TB_TC_Sun_Start_3	datetime '1/1/1900'

	TB_TC_Sun_End_1	datetime '1/1/1900'

	TB_TC_Sun_End_2	datetime '1/1/1900'

	TB_TC_Sun_End_3	datetime '1/1/1900'

	TB_TC_Detail_Logbk	tinyint 0

	AA_Focus_Field	char ''

	MDFUSRID	char ''	User that ...(more) Join Now
join ... more text available
	AA_Modify_Date	datetime '1/1/1900'

	AA_Modify_Time	datetime '1/1/1900'

	TB_TC_Hol_Hrs	numeric 0.00

	TB_TC_Hol_Fri_Hrs	numeric 0.00

	TB_TC_Hol_Mon_Hrs	numeric 0.00

	TB_TC_Hol_Sat_Hrs	numeric 0.00

	TB_TC_Hol_Sun_Hrs	numeric 0.00

	TB_TC_Hol_Thu_Hrs	numeric 0.00

	TB_TC_Hol_Tue_Hrs	numeric 0.00

	TB_TC_Hol_Wed_Hrs	numeric 0.00

	TB_TC_Sick_Hrs	numeric 0.00

	TB_TC_Sick_Fri_Hrs	numeric 0.00

	TB_TC_Sick_Mon_Hrs	numeric 0.00

	TB_TC_Sick_Sat_Hrs	numeric 0.00

	TB_TC_Sick_Sun_Hrs	numeric 0.00

	TB_TC_Sick_Thu_Hrs	numeric 0.00

	TB_TC_Sick_Tue_Hrs	numeric 0.00

	TB_TC_Sick_Wed_Hrs	numeric 0.00

	TB_TC_Vac_Hrs	numeric 0.00

	TB_TC_Vac_Fri_Hrs	numeric 0.00

	TB_TC_Vac_Mon_Hrs	numeric 0.00

	TB_TC_Vac_Sat_Hrs	numeric 0.00

	TB_TC_Vac_Sun_Hrs	numeric 0.00

	TB_TC_Vac_Thu_Hrs	numeric 0.00

	TB_TC_Vac_Tue_Hrs	numeric 0.00

	TB_TC_Vac_Wed_Hrs	numeric 0.00

	TB_Other1_Mon	numeric 0.00

	TB_Other1_Tues	numeric 0.00

	TB_Other1_Wed	numeric 0.00

	TB_Other1_Thur	numeric 0.00

	TB_Other1_Fri	numeric 0.00

	TB_Other1_Sat	numeric 0.00

	TB_Other1_Sun	numeric 0.00

	TB_Other1_Hrs	numeric 0.00

	TB_Other2_Mon	numeric 0.00

	TB_Other2_Tues	numeric 0.00

	TB_Other2_Wed	numeric 0.00

	TB_Other2_Thurs	numeric 0.00

	TB_Other2_Fri	numeric 0.00

	TB_Other2_Sat	numeric 0.00

	TB_Other2_Sun	numeric 0.00

	TB_Other2_Hrs	numeric 0.00

	TB_Other3_Mon	numeric 0.00

	TB_Other3_Tues	numeric 0.00

	TB_Other3_Wed	numeric 0.00

	TB_Other3_Thurs	numeric 0.00

	TB_Other3_Fri	numeric 0.00

	TB_Other3_Sat	numeric 0.00

	TB_Other3_Sun	numeric 0.00

	TB_Other3_Hrs	numeric 0.00

	TB_Other4_Mon	numeric 0.00

	TB_Other4_Tues	numeric 0.00

	TB_Other4_Wed	numeric 0.00

	TB_Other4_Thurs	numeric 0.00

	TB_Other4_Fri	numeric 0.00

	TB_Other4_Sat	numeric 0.00

	TB_Other4_Sun	numeric 0.00

	TB_Other4_Hrs	numeric 0.00

	TB_Other5_Mon	numeric 0.00

	TB_Other5_Tues	numeric 0.00

	TB_Other5_Wed	numeric 0.00

	TB_Other5_Thurs	numeric 0.00

	TB_Other5_Fri	numeric 0.00

	TB_Other5_Sat	numeric 0.00

	TB_Other5_Sun	numeric 0.00

	TB_Other5_Hrs	numeric 0.00

	TB_Other6_Mon	numeric 0.00

	TB_Other6_Tues	numeric 0.00

	TB_Other6_Wed	numeric 0.00

	TB_Other6_Thur	numeric 0.00

	TB_Other6_Fri	numeric 0.00

	TB_Other6_Sat	numeric 0.00

	TB_Other6_Sun	numeric 0.00

	TB_Other6_Hrs	numeric 0.00

	TB_Time_Card_Reg_Des	char ''

	TB_Time_Card_Sick_Des	char ''

	TB_Time_Card_Vac_Des	char ''

	TB_Time_Card_Holiday_Des	char ''

	TB_Time_Card_OT_Des	char ''

	TB_Time_Card_Oth1_Des	char ''

	TB_Time_Card_Oth2_Des	char ''

	TB_Time_Card_Oth3_Des	char ''

	TB_Time_Card_Oth4_Des	char ''

	TB_Time_Card_Oth5_Des	char ''

	TB_Time_Card_Oth6_Des	char ''

	TB_Pay_Code_Holiday	char ''

	TB_Pay_Code_Regular	char ''

	TB_Pay_Code_Sick	char ''

	TB_Pay_Code_Vacation	char ''

	TB_Pay_Code_Over_Time	char ''

	TB_Pay_Code_Other_1	char ''

	TB_Pay_Code_Other_2	char ''

	TB_Pay_Code_Other_3	char ''

	TB_Pay_Code_Other_4	char ''

	TB_Pay_Code_Other_5	char ''

	TB_Pay_Code_Other_6	char ''

	TB_TC_Sub_1_CB	tinyint 0

	TB_TC_App_1_CB	tinyint 0

	TB_TC_Sub_2_CB	tinyint 0

	TB_TC_App_2_CB	tinyint 0

	DEX_ROW_ID	int auto number (1,1)	Unique ide...(more) Join Now

DynDeveloper.com

COMPANY..TimeCard Table Definition

Field Definitions: