Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL01201
Display Name: GL_Budget_SUM_MSTR_View 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.
Physical Name: GL01201
Technical Name: GL_Budget_SUM_MSTR_View
Seq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BUDGETID Budget ID STR15_LBAU String 15 Key to the Budget Master (GL00200).
2 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 3 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 4 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 5 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 6 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 7 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 8 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 9 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 10 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 11 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 12 PERIODID Period ID INT3 Integer 3 13 BUDGETAMT Budget Amount DLR19_$S2 Currency 19 14 ACCATNUM Account Category Number INT2_U0 Integer 2 Key to the Account Category Master (GL00102).
15 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
16 ACTALIAS Account Alias STR20_Account_Alias String 20 17 MNACSGMT Main Account Segment STR66_Seg_ID String 66 18 ACCTTYPE Account Type DDL_Account_Type Integer 0 19 ACTDESCR Account Description STR50 String 50 20 PSTNGTYP Posting Type GB Integer 0 21 ACTIVE Active CB_Active Boolean 0 22 TPCLBLNC Typical Balance GB Integer 0 23 DECPLACS Decimal Places DDL_Decimal_Places Integer 0 24 FXDORVAR Fixed Or Variable LB_Fixed_Or_Variable Integer 0 25 BALFRCLC Balance For Calculation GB Integer 0 26 DSPLKUPS Display In Lookups ML_Display_In_Lookups Long Integer 0 27 CNVRMTHD Conversion Method DDL_Conversion_Method Integer 0 28 HSTRCLRT Historical Rate DLR14_Exchange_Rate Currency (Variable) 14 29 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
30 CREATDDT Created Date DT Date 8 31 MODIFDT Modified Date DT Date 8 32 USERDEF1 User Defined 1 STR20 String 20 33 USERDEF2 User Defined 2 STR20 String 20 34 DEX_ROW_TS datetime datetime 3 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. 35 DEX_ROW_ID int int 10
Display Name: GL_Budget_SUM_MSTR_View
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.