Dynamics GP Table Reference - COMPANY..TimeOly 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 TimeOly

You are currently viewing the COMPANY database.
Change

COMPANY..TimeOly Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	zProjectID	char ''

	zTaskID	char ''

	zTransactionNumber	int 0

	zTransactionDate	datetime '1/1/1900'

	zUserID	char ''

	zCostCategoryDDL	smallint 0	Incomplete...(more) Join Now

	zCostCategoryString	char ''

	zSubCostCategory	smallint 0

	zSubCostCategoryString	char ''

	zDepartmentID	char ''

	zJournalEntry	int 0

	zPostingDate	datetime '1/1/1900'

	zSalesPostingDate	datetime '1/1/1900'

	zPeriodNumber	int 0

	zTransactionDescription	char ''

	zBillingDescriptionLine1	char ''

	zBillingDescriptionLine2	char ''

	zBillingDescriptionLine3	char ''

	zBillingDescriptionLine4	char ''

	zSalesAccountIndex	int 0

	zSalesAccountString	char ''

	zDistDocumentTypeDDL	smallint 0

	zDistDocumentNumber	char ''

	zDistSequenceNumber	int 0

	zSalesDocumentTypeDDL	smallint 0

	zSalesDocumentNumber	char ''

	zSalesLineNumber	int 0

	zDistHistoryYear	smallint 0

	zSeriesDDL	smallint 0

	zSourceDoc	char ''

	zWebSource	smallint 0

	zOrigDocumentNumber	char ''

	zOrigDocumentDate	datetime '1/1/1900'

	zOrigID	char ''

	zOrigName	char ''

	zExpenseStatusDDL	smallint 0

	zApprovalUserIDCost	char ''

	zAccountIndex	int 0

	zAccountNumberString	char ''

	zBillingStatusDDL	smallint 0

	zApprovalUserIDBilling	char ''

	zBillingWorkQty	numeric 0.00

	zBillingWorkAmt	numeric 0.00

	zQty	numeric 0.00

	zQtyBilled	numeric 0.00

	zUnitCost	numeric 0.00

	zUnitPrice	numeric 0.00

	zRevenueAmt	numeric 0.00

	zOriginatingRevenueAmt	numeric 0.00

	zCostAmtEntered	numeric 0.00

	zCostAmt	numeric 0.00

	zOriginatingCostAmt	numeric 0.00

	zPayGroupID	char ''

	zPayrollStatusDDL	smallint 0

	zTotalTimeStatusDDL	smallint 0

	zEmployeeID	char ''

	zHoursEntered	numeric 0.00

	zHoursPaid	numeric 0.00

	zPayRecord	char ''

	zItemID	char ''

	zItemDescription	char ''

	zUofM	char ''
See I... more text available
	zItemQty	numeric 0.00

	zBurdenStatusDDL	smallint 0

	zUserDefinedDate	datetime '1/1/1900'

	zUserDefinedDate2	datetime '1/1/1900'

	zUserDefinedString	char ''

	zUserDefinedString2	char ''

	zUserDefinedCurrency	numeric 0.00

	zUserDefinedCurrency2	numeric 0.00

	zNoteIndex	numeric 0.00

	zImportType	smallint 0

	TB_Logbook_Index	numeric 0.00

	CUSTNMBR	char ''	Customer N...(more) Join Now	PA01101.CUSTNMBR
join ... more text available
	ADRSCODE	char ''	Address Co...(more) Join Now	PA01101.ADRSCODE

	TB_LogType	char ''

	TB_Log_Date	datetime '1/1/1900'

	TB_DateClock_In	datetime '1/1/1900'

	TB_DateClock_Out	datetime '1/1/1900'

	FRSTNAME	char ''

	LASTNAME	char ''	Last Name:...(more) Join Now	WC010300.LASTNAME

	EMPLOYID	char ''	Employee I...(more) Join Now	PA11801.EMPLOYID
join ... more text available
	DEPRTMNT	char ''	Department...(more) Join Now	WC010931.DEPRTMNT
join ... more text available
	JOBTITLE	char ''

	UPRTRXCD	char ''

	Contact_Method_ID	char ''

	TB_Log_Starting_Time	datetime '1/1/1900'

	TB_Log_Ending_Time	datetime '1/1/1900'

	TB_Log_Billable_Time	numeric 0.00

	TB_Log_Billing_Rate	numeric 0.00

	TB_Log_Extended_Billing	numeric 0.00

	TB_Logbook_Commission_Ti	numeric 0.00

	TB_Log_Commission_Rate	numeric 0.00

	TB_Log_Extend_Commission	numeric 0.00

	TB_Log_Comm_Paid_Date	datetime '1/1/1900'

	TB_Logbook_Posted	tinyint 0

	TB_Logbook_Posted_to_PR	tinyint 0

	AA_Focus_Field	char ''

	TB_Time_Approved	tinyint 0

	TB_Time_Approved_by	char ''

	TRXSOURC	char ''

	TB_Pieces_Completed	int 0

	TB_Pieces_Rejected	int 0

	TB_Pieces_Scrapped	int 0

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

	TB_Logbook_Description_T	text

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..TimeOly Table Definition

Field Definitions: