General Ledger Setup (GL40000)

Easily find this page again using the shortlink: http://gpt.azrcrv.co.uk/GL40000

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: General Ledger Setup
Physical Name: GL40000
Technical Name: GL_SETP

Group Display Name: General Ledger Setup
Group Technical Name: General Ledger Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1UNIQKEYKeySTR1String21
2NJRNLENTNext Journal EntryLI8_S0Long Integer48
3RERINDXRetained Earnings Account IndexLI_14Long Integer414
4LSTCLSDTLast Closing DateDT_DateDate46
5TRERCLSGTrue Retained Earnings ClosingCB_True_Retained_Earnings_ClosingBoolean20
6DIVACTSGDivisional Account SegmentDDL_Divisional_Account_SegmentInteger20
7BLNCDSPLBalance DisplayGBInteger20
8KPGACHSTKeeping Account HistoryCB_Keeping_Account_HistoryBoolean20
9KPGTRXHSKeeping TRX HistoryCB_Keeping_TRX_HistoryBoolean20
10AHSTPSTGAllow History PostingCB_Allow_History_PostingBoolean20
11USRDFPR1User Defined Prompt 1STR15String1615
12USRDRPR2User Defined Prompt 2STR15String1615
13USRDRPR3User Defined Prompt 3STR15String1615
14USRDRPR4User Defined Prompt 4STR15String1615
15UPDTACCELUpdate AcceleratorCB_Update_Accelerator_InformationBoolean20
16Posting_Number_TypePosting Number TypeGBInteger20
17Delete_Saved_TrxDelete Saved TrxCB_Delete_Saved_TrxBoolean20
18Void_Sub_TrxVoid Sub TrxCB_Void_Sub_TrxBoolean20
19Correct_IC_TrxCorrect IC TrxCB_CORRECT_IC_TRXBoolean20
20Allow_Reporting_LedgersAllow Reporting LedgersCB_ReportingLedgersBoolean20
21UseLedgersForAcctBalanceUse Ledgers For Account BalanceML_MultiSelectListBoxLong Integer40
22NXTBUDJRLENTNext Budget Journal EntryLI8_S0Long Integer48
23KPBUDTRXHISTKeep Budget Transaction HistoryCB_Keep_Budget_TRX_HistoryBoolean20
24NextReconciliationNumberNext Reconciliation NumberLI8_U0Long Integer48
25DEX_ROW_TSdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
26DEX_ROW_IDintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *