Dynamics GP Table Reference - COMPANY..GL10000 fields

	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 GL tables GL10000

You are currently viewing the COMPANY database.
Change

COMPANY..GL10000 Table Definition

(COMPANY..Transaction Work)

Physical Name: GL10000
Display Name: Transaction Work

This table contains transaction header information for transactions entered in transaction and clearing entry windows in General Ledger. Line detail is stored in the GL_TRX_LINE_WORK table for transactions and the GL_TRX_Clearing_WORK table for clearing transactions.

Required fields:
Batch Number
Batch Source
Journal Entry
Source Document
Reference
TRX Date
Reversing Date
Balance For Calculation
Posting Status
Transaction Type
Series
Ledger ID

Optional:
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro Triangulation.
Document Date

Comments:
The following fields are assigned values only for specific transaction types:
Reversing Date: reversing transactions only
Balance For Calculation: clearing transactions only

The following fields are used to store transaction information when posting transactions from subsidiary modules to General Ledger:
DTA Control Number
DTA TRX Type
DTA Index
Originating Posted Date
Originating TRX Source

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	BACHNUMB	char(15) ''	Batch Numb...(more) Join Now
join ... more text available
	BCHSOURC	char(15) ''	Batch Sour...(more) Join Now

	JRNENTRY	int 0	Journal En...(more) Join Now

	RCTRXSEQ	numeric(19,5) 0.00	Recurring ...(more) Join Now

	SOURCDOC	char(11) ''	span style...(more) Join Now

	REFRENCE	char(31) ''	Reference:...(more) Join Now

	TRXDATE	datetime '1/1/1900'	TRX Date: ...(more) Join Now

	RVRSNGDT	datetime '1/1/1900'	Reversing ...(more) Join Now

	RCRNGTRX	tinyint 0	Recurring ...(more) Join Now

	BALFRCLC	smallint 0	Balance Fo...(more) Join Now

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

	LASTUSER	char(15) ''	Last User:...(more) Join Now

	LSTDTEDT	datetime '1/1/1900'	Last Date ...(more) Join Now

	USWHPSTD	char(15) ''	User Who P...(more) Join Now

	TRXTYPE	smallint 0	Transactio...(more) Join Now

	SQNCLINE	numeric(19,5) 0.00	Sequence L...(more) Join Now

	GLHDRMSG	binary(4) 0	GL HDR Mes...(more) Join Now

	GLHDRMS2	binary(4) 0	GL HDR Mes...(more) Join Now

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

	RVTRXSRC	char(13) ''	Reversing ...(more) Join Now

	SERIES	smallint 0	Seriesbr /...(more) Join Now

	ORPSTDDT	datetime '1/1/1900'	Originatio...(more) Join Now

	ORTRXSRC	char(13) 0	Originatin...(more) Join Now

	OrigDTASeries	smallint 0	Originatin...(more) Join Now

	DTAControlNum	char(21) ''	DTA Contro...(more) Join Now

	DTATRXType	smallint 0	DTA TRX Ty...(more) Join Now

	DTA_Index	numeric(19,5) 0.00	DTA Index:...(more) Join Now

	CURNCYID	char(15) ''	Currency I...(more) Join Now	CM20000
join ... more text available
	CURRNIDX	smallint 0	Currency I...(more) Join Now
join ... more text available
	RATETPID	char(15) ''	Rate Type ...(more) Join Now

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

	XCHGRATE	numeric(19,7) 0.00	Exchange R...(more) Join Now

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

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

	RTCLCMTD	smallint 0	Rate Calcu...(more) Join Now

	NOTEINDX	numeric(19,5) 0.00	Note Index...(more) Join Now
join ... more text available
	GLHDRVAL	binary(4) 0	GL Header ...(more) Join Now

	PERIODID	smallint 0	Period ID:...(more) Join Now

	OPENYEAR	smallint 0	Open Year:...(more) Join Now

	CLOSEDYR	smallint 0	Closed Yea...(more) Join Now

	HISTRX	tinyint 0	History TR...(more) Join Now

	REVPRDID	smallint 0	Reversing ...(more) Join Now

	REVYEAR	smallint 0	Reversing ...(more) Join Now

	REVCLYR	smallint 0	Reversing ...(more) Join Now

	REVHIST	tinyint 0	Reversing ...(more) Join Now

	ERRSTATE	int 0	Error Stat...(more) Join Now

	ICTRX	tinyint 0	IC TRX: T...(more) Join Now

	ORCOMID	char(5) ''	Originatin...(more) Join Now

	ORIGINJE	int 0	Originatin...(more) Join Now

	ICDISTS	tinyint 0	ICDists: T...(more) Join Now

	PRNTSTUS	smallint 0	Printing S...(more) Join Now

	DENXRATE	numeric(19,7) 0.00	Denominati...(more) Join Now

	MCTRXSTT	smallint 0	MC Transac...(more) Join Now

	DOCDATE	datetime '1/1/1900'	Document D...(more) Join Now

	Tax_Date	datetime '1/1/1900'	Tax Date: ...(more) Join Now

	VOIDED	tinyint 0	Voided: ...(more) Join Now

	Original_JE	int 0	Original J...(more) Join Now

	Original_JE_Year	smallint 0	Original J...(more) Join Now

	Original_JE_Seq_Num	numeric(19,5) 0.00	Original J...(more) Join Now

	Correcting_Trx_Type	smallint 0	Correcting...(more) Join Now

	Ledger_ID	smallint 0	Ledger ID:...(more) Join Now

	Adjustment_Transaction	tinyint 0	Adjustment...(more) Join Now

	DEX_ROW_TS	datetime (getutcdate())	Time Stamp...(more) Join Now

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

DynDeveloper.com

COMPANY..GL10000 Table Definition

Field Definitions: