Dynamics GP Table Reference - COMPANY..SY70501 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 Company/System tables SY70501

You are currently viewing the COMPANY database.
Change

COMPANY..SY70501 Table Definition

(COMPANY..Company Report Options)

Field Definitions:

What is the 'source' column?

Column Name	Data Type Default Value		Source
ORIGINGB	smallint 0

STRTYEAR	smallint 0

ENDYEAR	smallint 0

STICID	char(5) ''

ENDICID	char(5) ''

FINRPTNM	char(31) ''

SJRNTPRT	tinyint 0

PRNTNOTS	tinyint 0

PRNTTYPE	smallint 0

ASKECHTM	tinyint 0

PRNTOFIL	tinyint 0

PRTOPRTR	tinyint 0

PRTOSCRN	tinyint 0

INCLGNDS	tinyint 0

IFFILXST	smallint 0

FILEXPNM	char(255) ''

EXPTTYPE	smallint 0

RPTGRIND	smallint 0

RTPACHIN	smallint 0

RTGRSBIN	numeric(19,5) 0.00

SORTBY	smallint 0

STTLOCID	char(15) ''

STTLOCNM	char(31) ''

STADDCTT	char(61) ''

SSRCEDOC	char(11) ''

SSDOCDSC	char(31) ''

STTSTATE	char(29) ''

STRTZPCD	char(11) ''

STTFLSRS	smallint 0

STARTSRS	smallint 0

STTRXSRC	char(25) ''

STTNOTNM	char(45) ''

SRPTGRNM	char(21) ''

STTPALNM	char(31) ''

STTUSRID	char(15) ''

STENDTYP	smallint 0

STTCRDNM	char(15) ''

STTPYTID	char(21) ''

STTSHMTH	char(15) ''

SRTCOMSR	smallint 0

SRTCOMID	char(15) ''

ENDLOCID	char(15) ''

ENDLOCNM	char(31) ''

ENDADDCT	char(61) ''

ENDSRCDC	char(11) ''

ENDSDDSC	char(31) ''

ENDSTATE	char(29) ''

ENDZIPCD	char(11) ''

ENDFLSRS	smallint 0

ENDSERIS	smallint 0

ENDTRXSR	char(25) ''

ENDNOTNM	char(45) ''

ENDRPGNM	char(21) ''

ENDPALNM	char(31) ''

ENDUSRID	char(15) ''

ENDENDTY	smallint 0

ENDCRDNM	char(15) ''

ENDPYTID	char(21) ''

ENDSHMTH	char(15) ''

ENDCOMID	char(15) ''

ENDCOMSR	smallint 0

ENDNAME	char(65) ''

ENDID	char(15) ''

STARTID	char(15) ''

STRTNAME	char(65) ''

STRTCITY	char(35) ''

ENDCITY	char(35) ''

ENDCNTRY	char(61) ''

STTCNTRY	char(61) ''

LBLFRMAT	smallint 0

NUMOCPIS	smallint 0

NUMACROS	smallint 0

INCADADR	tinyint 0

INCCNTCT	tinyint 0

FRCEUPCS	tinyint 0

YEAR1	smallint 0	Year...(more) Join Now

PRNTDTLD	tinyint 0

ENTXDDSC	char(31) ''

ETXDTLID	char(15) ''

ETXSCHDS	char(31) ''

ETXSCHID	char(15) ''

STTXDDSC	char(31) ''

STTXDTID	char(15) ''

STXSCDSC	char(31) ''

STXSCHID	char(15) ''

ENDPEROD	smallint 0

STPERIOD	smallint 0

STDTLTYP	smallint 0

ENDETTYP	smallint 0

STXIDNUM	char(15) ''

ETXIDNBR	char(15) ''

HISTTYPE	smallint 0	History Ty...(more) Join Now	PM00202.HISTTYPE

STBCHNUM	char(15) ''

STRTDATE	datetime '1/1/1900'	Start Date...(more) Join Now	UPR00100.STRTDATE

STDOCNUM	char(21) ''

ENDBNMBR	char(15) ''

ENDOCNUM	char(21) ''

ENDDATE	datetime '1/1/1900'	End Date: ...(more) Join Now	SOP00300.ENDDATE

PRNSHPTO	tinyint 0

PRTBLLTO	tinyint 0

ARVLDEPART	smallint 0

STCUSTID	char(15) ''

ENCUSTID	char(15) ''

STSOPTYP	smallint 0

EDSOPTYP	smallint 0

UPSIDNBR	char(15) ''

STTDOCDT	datetime '1/1/1900'	Field Type...(more) Join Now	SVC00670.STTDOCDT

ENDDOCDT	datetime '1/1/1900'	Field Type...(more) Join Now	SVC00670.ENDDOCDT

STDOCTYP	smallint 0

ENDOCTYP	smallint 0

STVNDRID	char(15) ''

ENDVNDID	char(15) ''

STRMTKDT	smallint 0

ENRMTKDT	smallint 0

STTXUSR1	char(21) ''

ENTXUSR1	char(21) ''

STTOKNDT	smallint 0

ENDTKNDT	smallint 0

STTXPYDT	datetime '1/1/1900'

ENTXPYDT	datetime '1/1/1900'

STTPSTDT	datetime '1/1/1900'

ENDPSTDT	datetime '1/1/1900'

STGENINT1	smallint 0

STDECLID	char(15) ''

ENDDECLID	char(15) ''

STINTRSTTRTRNID	char(21) ''

ENDINTRSTTRTRNID	char(21) ''

STTCC	char(31) ''

ENDTCC	char(31) ''

STTXRGNNUM	char(25) ''

ENDTXRGNNUM	char(25) ''

STRTAMNT	numeric(19,5) 0.00

ENDAMNT	numeric(19,5) 0.00

GROUPBOX	smallint 0

GROUPBX2	smallint 0

EXCLVOID	tinyint 0

PRNTCSV	tinyint 0

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

Field Definitions: