Dynamics GP Table Reference - COMPANY..ASI25851 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 ASI tables ASI25851

You are currently viewing the COMPANY database.
Change

COMPANY..ASI25851 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	USERID	char	The user t...(more) Join Now
join ... more text available
	CUSTNMBR	char	Customer N...(more) Join Now	PA01101.CUSTNMBR
join ... more text available
	DOCNUMBR	char	Document N...(more) Join Now	RM20102.DOCNUMBR

	RMDTYPAL	smallint	RM Documen...(more) Join Now	RM20102.RMDTYPAL

	BACHNUMB	char	Batch Numb...(more) Join Now
join ... more text available
	TAXDTLID	char	Tax Detail...(more) Join Now	PM30300.TAXDTLID

	TXDTLDSC	char

	TAXAMNT	numeric	Tax Amount...(more) Join Now	PA11801.TAXAMNT

	STAXAMNT	numeric

	FRTTXAMT	numeric	Freight Ta...(more) Join Now	PTE30500.FRTTXAMT

	MSCTXAMT	numeric	Misc Tax A...(more) Join Now	PTE30500.MSCTXAMT

	TAXDTSLS	numeric

	TDTTXSLS	numeric

	ORTAXAMT	numeric	Originatin...(more) Join Now	PTE30501.ORTAXAMT

	ORSLSTAX	numeric

	ORFRTTAX	numeric	Originatin...(more) Join Now	PTE30500.ORFRTTAX

	ORMSCTAX	numeric	Originatin...(more) Join Now	PTE30500.ORMSCTAX

	ORTOTSLS	numeric

	ORTXSLS	numeric

	DISPTAXAMNT	numeric

	DISPSLSTAX	numeric

	DISPFRTTAX	numeric

	DISPMSCTAX	numeric

	DISPTOTSLS	numeric

	DISPTXSLS	numeric

	TXDTLPCH	char

	ACTINDX	int	Account In...(more) Join Now	WO010702.ACTINDX
join ... more text available
	CURRNIDX	smallint	Currency I...(more) Join Now	RM20102.CURRNIDX
join ... more text available
	TRXSORCE	char	Transactio...(more) Join Now

	BKOUTTAX	tinyint

	POSTED	tinyint

	SEQNUMBR	int	Sequence N...(more) Join Now	HR2EMP02.SEQNUMBR

	TXDETRTP	char

	TTAXSSTR	char

	DCTTSSTR	char

	TXAMTSTR	char

	DCTXASTR	char

	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

3