Dynamics GP Table Reference - COMPANY..AF40201 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 AF tables AF40201

You are currently viewing the COMPANY database.
Change

COMPANY..AF40201 Table Definition

(COMPANY..Financials Accelerator Options)

4Penny.net

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	REPORTID	smallint 0

	RptOptID	numeric(19,5) 0.00

	ROWNMBR	smallint 0

	SEQNUMBR	int 0	Sequence N...(more) Join Now	DTA10200.SEQNUMBR

	ACTARR1_1_1	char(5) ''

	ACTARR1_1_2	char(5) ''

	ACTARR1_1_3	char(5) ''

	ACTARR1_1_4	char(5) ''

	ACTARR1_1_5	char(5) ''

	ACTARR1_1_6	char ''

	ACTARR1_2_1	char(5) ''

	ACTARR1_1_7	char ''

	ACTARR1_2_2	char(5) ''

	ACTARR1_2_3	char(5) ''

	ACTARR1_1_8	char ''

	ACTARR1_1_9	char ''

	ACTARR1_2_4	char(5) ''

	ACTARR1_2_5	char(5) ''

	ACTARR1_1_10	char ''

	ACTARR1_3_1	char(5) ''

	ACTARR1_3_2	char(5) ''

	ACTARR1_3_3	char(5) ''

	ACTARR1_3_4	char(5) ''

	ACTARR1_3_5	char(5) ''

	ACTARR1_4_1	char(5) ''

	ACTARR1_2_6	char ''

	ACTARR1_2_7	char ''

	ACTARR1_4_2	char(5) ''

	ACTARR1_4_3	char(5) ''

	ACTARR1_2_8	char ''

	ACTARR1_2_9	char ''

	ACTARR1_4_4	char(5) ''

	ACTARR1_4_5	char(5) ''

	ACTARR1_2_10	char ''

	ACTARR2_1_1	char(51) ''

	ACTARR2_1_2	smallint 0

	ACTARR2_1_3	smallint 0

	ACTARR2_1_4	int 0

	ACTARR2_2_1	char(51) ''

	ACTARR2_2_2	smallint 0

	ACTARR1_3_6	char ''

	ACTARR1_3_7	char ''

	ACTARR2_2_3	smallint 0

	ACTARR2_2_4	int 0

	ACTARR1_3_8	char ''

	ACTARR1_3_9	char ''

	ACTARR2_3_1	char(51) ''

	ACTARR2_3_2	smallint 0

	ACTARR1_3_10	char ''

	ACTARR2_3_3	smallint 0

	ACTARR2_3_4	int 0

	ACTARR2_4_1	char(51) ''

	ACTARR2_4_2	smallint 0

	ACTARR2_4_3	smallint 0

	ACTARR2_4_4	int 0

	ACTARR1_4_6	char ''

	ACTARR1_4_7	char ''

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

	ACTARR1_4_8	char ''

	ACTARR1_4_9	char ''

	ACTARR1_4_10	char ''

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