Dynamics GP Table Reference - COMPANY..POP10170 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 POP tables POP10170

You are currently viewing the COMPANY database.
Change

COMPANY..POP10170 Table Definition

(COMPANY..)

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	PONUMBER	char ''	PO Number ...(more) Join Now	SEE30303.PONUMBER

	PMNTNMBR	char ''

	PrepaymentSource	smallint 0

	PYENTTYP	smallint 0

	PrepaymentAmount	numeric 0.00

	OriginatingPrepaymentAmt	numeric 0.00

	APPLDAMT	numeric 0.00

	ORAPPAMT	numeric 0.00

	CURTRXAM	numeric 0.00

	ORCTRXAM	numeric 0.00

	DISTKNAM	numeric 0.00	Discount T...(more) Join Now

	ORDISTKN	numeric 0.00	Orig Disco...(more) Join Now	RM20102.ORDISTKN

	CHEKBKID	char ''	Checkbook ID Checkbook this transaction affects	SY30500.CHEKBKID
join ... more text available
	CARDNAME	char ''

	CHEKNMBR	char ''

	DOCNUMBR	char ''	Document N...(more) Join Now	RM20102.DOCNUMBR

	CNTRLTYP	smallint 0

	PrepaymentAccountIndex	int 0

	Cash_Account_Index	int 0

	PAY_ACCT_IDX	int 0

	GLPOSTDT	datetime '1/1/1900'	Date that ...(more) Join Now	RM20101.GLPOSTDT

	BACHNUMB	char ''	Batch Numb...(more) Join Now
join ... more text available
	BCHSOURC	char ''	Batch Sour...(more) Join Now

	TRXSORCE	char ''	Transactio...(more) Join Now

	PSTGSTUS	smallint 0	Posting St...(more) Join Now

	VOIDED	tinyint 0

	CURNCYID	char ''	Currency I...(more) Join Now	RM20102.CURNCYID
join ... more text available
	CURRNIDX	smallint 0	Currency I...(more) Join Now	RM20102.CURRNIDX
join ... more text available
	RATETPID	char ''

	EXGTBLID	char ''	Exchange T...(more) Join Now	MC00100.EXGTBLID

	XCHGRATE	numeric 0.00	Exchange R...(more) Join Now	MC00100.XCHGRATE

	EXCHDATE	datetime '1/1/1900'	Exchange D...(more) Join Now	MC00100.EXCHDATE

	TIME1	datetime '1/1/1900'	Time Time...(more) Join Now	WO010213.TIME1

	RATECALC	smallint 0	Rate Calc ...(more) Join Now	PM20100.RATECALC

	DENXRATE	numeric 0.00	Exchange R...(more) Join Now	PTE30501.DENXRATE

	MCTRXSTT	smallint 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..POP10170 Table Definition

Field Definitions: