Dynamics GP Table Reference - COMPANY..SchedSum fields

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

These are our SOP scripts. All of our scripts for Dynamics GP can be found here

	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 SchedSum

You are currently viewing the COMPANY database.
Change

COMPANY..SchedSum Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	EMPLOYID	char ''	Employee I...(more) Join Now	PA11801.EMPLOYID
join ... more text available
	LASTNAME	char ''	Last Name:...(more) Join Now	WC010300.LASTNAME

	FRSTNAME	char ''

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

	PAYCODE	char ''

	TB_Schedule_Code	char ''

	TB_Schedule_DateStart	datetime '1/1/1900'

	TB_Schedule_CodeMonday_1	char ''

	TB_Schedule_TimeMonday_1	numeric 0.00

	TB_Actual_TimeMonday_1st	numeric 0.00

	TB_Schedule_CodeTuesday1	char ''

	TB_Schedule_TimeTues1	numeric 0.00

	TB_Actual_TimeTuesday_1s	numeric 0.00

	TB_Schedule_CodeWednes1	char ''

	TB_Schedule_TimeWed1	numeric 0.00

	TB_Actual_TimeWed1	numeric 0.00

	TB_Schedule_CodeThurs1	char ''

	TB_Schedule_TimeThur1	numeric 0.00

	TB_Actual_TimeThursday_1	numeric 0.00

	TB_Schedule_CodeFriday_1	char ''

	TB_Schedule_TimeFriday1	numeric 0.00

	TB_Actual_TimeFriday_1st	numeric 0.00

	TB_Schedule_CodeSat1	char ''

	TB_Schedule_TimeSat1	numeric 0.00

	TB_Actual_TimeSaturday_1	numeric 0.00

	TB_Schedule_CodeSunday_1	char ''

	TB_Schedule_TimeSund1	numeric 0.00

	TB_Actual_TimeSunday_1st	numeric 0.00

	TB_Schedule_CodeMonday_2	char ''

	TB_Schedule_TimeMonday_2	numeric 0.00

	TB_Actual_TimeMonday_2nd	numeric 0.00

	TB_Schedule_CodeTuesday2	char ''

	TB_Schedule_TimeTues2	numeric 0.00

	TB_Actual_TimeTuesday_2n	numeric 0.00

	TB_Schedule_CodeWednes2	char ''

	TB_Schedule_TimeWed2	numeric 0.00

	TB_Actual_TimeWed2	numeric 0.00

	TB_Schedule_CodeThurs2	char ''

	TB_Schedule_TimeThurs2	numeric 0.00

	TB_Actual_TimeThurs2	numeric 0.00

	TB_Schedule_CodeFriday_2	char ''

	TB_Schedule_TimeFriday2	numeric 0.00

	TB_Actual_TimeFriday_2nd	numeric 0.00

	TB_Schedule_CodeSat2	char ''

	TB_Schedule_TimeSat2	numeric 0.00

	TB_Actual_TimeSaturday_2	numeric 0.00

	TB_Schedule_CodeSunday_2	char ''

	TB_Schedule_TimeSun2	numeric 0.00

	TB_Actual_TimeSunday_2nd	numeric 0.00

	TB_Schedule_TimeTotal	numeric 0.00

	TB_Actual_TimeTotal	numeric 0.00

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

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables

DynDeveloper.com

COMPANY..SchedSum Table Definition

Field Definitions: