Dynamics GP Table Reference - COMPANY..CN00600 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 CN tables CN00600

You are currently viewing the COMPANY database.
Change

COMPANY..CN00600 Table Definition

(COMPANY..Collections - Query Master)

Field Definitions:

What is the 'source' column?

Column Name	Data Type Default Value
Query_ID	char(15) ''

Query_Description	char(31) ''

STCUSTID	char(15) ''

STCUSTNM	char(65) ''

STTCLSID	char(15) ''

STTUDEF1	char(21) ''

STSPRSID	char(15) ''

STSLSTER	char(15) ''

StartPrefContactMethod	smallint 0

CNStartTimeZone	smallint 0

STRTUDEF	char(21) ''

STUDDAT1	datetime '1/1/1900'

STUDTAB1	char(21) ''

ENCUSTID	char(15) ''

ENCSTNAM	char(65) ''

ENDCLSID	char(15) ''

ENUSRDF1	char(21) ''

ENSPSNID	char(15) ''

ENSLSTER	char(15) ''

CNEndTimeZone	smallint 0

EndPrefContactMethod	smallint 0

ENUSRDEF	char(21) ''

ENDUDDT1	datetime '1/1/1900'

ENDUDTBL	char(21) ''

StartCreditControlCycle	smallint 0

EndCreditControlCyle	smallint 0

CONNAACT	tinyint 0

DateSelection	smallint 0

QRYSTCDTPER	smallint 0

QryEndCrLimitPeriod	smallint 0

QRYSTCDTAMT	numeric(19,5) 0.00

QryEndCreditLimitAmt	numeric(19,5) 0.00

QryStartDateToken	smallint 0

QryEndDateToken	smallint 0

STRTNGDT	datetime '1/1/1900'

ENDINGDT	datetime '1/1/1900'

Starting_Trx_Days	smallint 0

Ending_Trx_Days	smallint 0

Start_Caller_ID	char(15) ''

Start_Contact_Date	datetime '1/1/1900'

Start_Action_Assigned_To	char(15) ''

Start_Action_Promised	char(17) ''

Start_Action_Date	datetime '1/1/1900'

SNOTPRTY	smallint 0

QRYACTCOM	smallint 0

End_Caller_ID	char(15) ''

End_Contact_Date	datetime '1/1/1900'

End_Action_Assigned_To	char(15) ''

End_Action_Promised	char(17) ''

End_Action_Date	datetime '1/1/1900'

ENOTPRTY	smallint 0

QCMFLAG	tinyint 0

Start_Credit_Manager	char(15) ''

End_Credit_Manager	char(15) ''

CUSTCSTS	smallint 0

QueryBalanceReturned	smallint 0

QueryExcludeOlderBalance	tinyint 0

QryExcludeifPaymentMade	tinyint 0

QueryNumberofDays	smallint 0

QueryNoteExists	smallint 0

STUDTAB2	char(21) ''

ENDUDTBL2	char(21) ''

USERLANG	smallint 0

CN_Credit_LevelStart	smallint 0

CN_Credit_LevelEnd	smallint 0

Query_Exclude_Partial_Pa	tinyint 0

CN_BalanceOverCreditLim	tinyint 0

StartNoteStatus	smallint

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

EndNoteStatus	smallint

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

Field Definitions: