Financials Column Postfix Calculation Setup (AF40105)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialFinancials Column Postfix Calculation Setup (AF40105)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AF40105

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Financials Column Postfix Calculation Setup
Physical Name: AF40105
Technical Name: AF_Report_COL_Postfix_SETP

Group Display Name: Financials Setup
Group Technical Name: Financials Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REPORTID SearchReport IDINT_STORAGEInteger20
2CLCOLNUM SearchCALC COL NUMINT_STORAGEInteger20
3TKNODNUM SearchToken Order NUMINT_STORAGEInteger20
4TKNTYPE SearchToken TypeINT_STORAGEInteger20
5TKNVALUE SearchToken ValueINT_STORAGEInteger20
6TKNDLVAL SearchToken Dollar ValueDLR19_RBS5_TRCurrency1019
7TKNUNACT_1 SearchToken Unit ACCT:Account_Segment_Pool1Account_Segment_Pool1String86
8TKNUNACT_2 SearchToken Unit ACCT:Account_Segment_Pool2Account_Segment_Pool2String86
9TKNUNACT_3 SearchToken Unit ACCT:Account_Segment_Pool3Account_Segment_Pool3String86
10TKNUNACT_4 SearchToken Unit ACCT:Account_Segment_Pool4Account_Segment_Pool4String86
11TKNUNACT_5 SearchToken Unit ACCT:Account_Segment_Pool5Account_Segment_Pool5String86
12TKNUNACT_6 SearchToken Unit ACCT:Account_Segment_Pool6Account_Segment_Pool6String86
13TKNUNACT_7 SearchToken Unit ACCT:Account_Segment_Pool7Account_Segment_Pool7String86
14TKNUNACT_8 SearchToken Unit ACCT:Account_Segment_Pool8Account_Segment_Pool8String86
15TKNUNACT_9 SearchToken Unit ACCT:Account_Segment_Pool9Account_Segment_Pool9String86
16TKNUNACT_10 SearchToken Unit ACCT:Account_Segment_Pool10Account_Segment_Pool10String86
17DEX_ROW_ID Searchintint1010

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.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialFinancials Column Postfix Calculation Setup (AF40105)

Leave a Reply

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