Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AF50300
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Report Column Temporary
Physical Name: AF50300
Technical Name: AF_Report_Column_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Report Column Temporary'].USERID AS 'Report Column Temporary-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AF50300 AS ['Report Column Temporary']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Report Column Temporary'].USERID = ['Users Master'].USERID2 REPORTID Report ID Integer INT_STORAGE 0 3 RPTGRIND Report Group Index Integer INT 0 4 RTPACHIN Report Palette Choice Index Integer INT 0 5 RTGRSBIN Report Group Sub Index Currency DLR14 14 6 COLNUM COL NUM Integer INT_STORAGE 0 7 CLTKNCNT CALC Token CNT Integer INT_STORAGE 0 8 COLTYPE COL Type Integer INT_STORAGE 0 9 COLSIZE COL Size Integer INT_STORAGE 0 10 COLOFMRK_1 COL Offset Marks[1] Integer INT 0 11 COLOFMRK_2 COL Offset Marks[2] Integer INT 0 12 COLOFMRK_3 COL Offset Marks[3] Integer INT 0 13 COLOFMRK_4 COL Offset Marks[4] Integer INT 0 14 COLOMCNT COL Offset Mark CNT Integer INT 0 15 HIDEFLAG Hide Flag Integer INT_STORAGE 0 16 TEXTVALU Text Value String STR50 50 17 STPERIOD Start Period Integer INT_STORAGE 0 18 ENDPEROD End Period Integer INT_STORAGE 0 19 SEGFROM_1 SEG From:Account_Segment_Pool1 String Account_Segment_Pool1 6 20 SEGFROM_2 SEG From:Account_Segment_Pool2 String Account_Segment_Pool2 6 21 SEGFROM_3 SEG From:Account_Segment_Pool3 String Account_Segment_Pool3 6 22 SEGFROM_4 SEG From:Account_Segment_Pool4 String Account_Segment_Pool4 6 23 SEGFROM_5 SEG From:Account_Segment_Pool5 String Account_Segment_Pool5 6 24 SEGFROM_6 SEG From:Account_Segment_Pool6 String Account_Segment_Pool6 6 25 SEGFROM_7 SEG From:Account_Segment_Pool7 String Account_Segment_Pool7 6 26 SEGFROM_8 SEG From:Account_Segment_Pool8 String Account_Segment_Pool8 6 27 SEGFROM_9 SEG From:Account_Segment_Pool9 String Account_Segment_Pool9 6 28 SEGFROM_10 SEG From:Account_Segment_Pool10 String Account_Segment_Pool10 6 29 SEGTO_1 SEG To:Account_Segment_Pool1 String Account_Segment_Pool1 6 30 SEGTO_2 SEG To:Account_Segment_Pool2 String Account_Segment_Pool2 6 31 SEGTO_3 SEG To:Account_Segment_Pool3 String Account_Segment_Pool3 6 32 SEGTO_4 SEG To:Account_Segment_Pool4 String Account_Segment_Pool4 6 33 SEGTO_5 SEG To:Account_Segment_Pool5 String Account_Segment_Pool5 6 34 SEGTO_6 SEG To:Account_Segment_Pool6 String Account_Segment_Pool6 6 35 SEGTO_7 SEG To:Account_Segment_Pool7 String Account_Segment_Pool7 6 36 SEGTO_8 SEG To:Account_Segment_Pool8 String Account_Segment_Pool8 6 37 SEGTO_9 SEG To:Account_Segment_Pool9 String Account_Segment_Pool9 6 38 SEGTO_10 SEG To:Account_Segment_Pool10 String Account_Segment_Pool10 6 39 AMNTFROM Amount From Integer INT_STORAGE 0 40 HISTYEAR HIST Year Integer INT_STORAGE 0 41 BUDID BUD ID String STR15_LBAU 15 42 PRTSIGN PRT Sign Integer INT 0 43 PRTCOMMA PRT Comma Integer INT_STORAGE 0 44 PRTPCENT PRT Percent Integer INT_STORAGE 0 45 PRTTEXT PRT Text Integer INT_STORAGE 0 46 ROUNDOPT Round OPT Integer INT_STORAGE 0 47 HEADALIN Head Align Integer INT_STORAGE 0 48 HDFTFMLY Head Font Family Integer INT 0 49 HDFTSIZE Head Font Size Integer INT 0 50 HEDSTYLE_1 Head Style[1] Integer INT_STORAGE 0 51 HEDSTYLE_2 Head Style[2] Integer INT_STORAGE 0 52 HEDSTYLE_3 Head Style[3] Integer INT_STORAGE 0 53 HEDSTYLE_4 Head Style[4] Integer INT_STORAGE 0 54 HEDSTYLE_5 Head Style[5] Integer INT_STORAGE 0 55 HEDSTYLE_6 Head Style[6] Integer INT_STORAGE 0 56 HEADTYPE_1 Head Type[1] Integer INT_STORAGE 0 57 HEADTYPE_2 Head Type[2] Integer INT_STORAGE 0 58 HEADTYPE_3 Head Type[3] Integer INT_STORAGE 0 59 HEADTYPE_4 Head Type[4] Integer INT_STORAGE 0 60 HEADTYPE_5 Head Type[5] Integer INT_STORAGE 0 61 HEADTYPE_6 Head Type[6] Integer INT_STORAGE 0 62 HEDFRMAT_1 Head Format[1] Integer INT_STORAGE 0 63 HEDFRMAT_2 Head Format[2] Integer INT_STORAGE 0 64 HEDFRMAT_3 Head Format[3] Integer INT_STORAGE 0 65 HEDFRMAT_4 Head Format[4] Integer INT_STORAGE 0 66 HEDFRMAT_5 Head Format[5] Integer INT_STORAGE 0 67 HEDFRMAT_6 Head Format[6] Integer INT_STORAGE 0 68 HEADOPT_1 Head OPT[1] Integer INT_STORAGE 0 69 HEADOPT_2 Head OPT[2] Integer INT_STORAGE 0 70 HEADOPT_3 Head OPT[3] Integer INT_STORAGE 0 71 HEADOPT_4 Head OPT[4] Integer INT_STORAGE 0 72 HEADOPT_5 Head OPT[5] Integer INT_STORAGE 0 73 HEADOPT_6 Head OPT[6] Integer INT_STORAGE 0 74 HEADOPT2_1 Head OPT2[1] Integer INT_STORAGE 0 75 HEADOPT2_2 Head OPT2[2] Integer INT_STORAGE 0 76 HEADOPT2_3 Head OPT2[3] Integer INT_STORAGE 0 77 HEADOPT2_4 Head OPT2[4] Integer INT_STORAGE 0 78 HEADOPT2_5 Head OPT2[5] Integer INT_STORAGE 0 79 HEADOPT2_6 Head OPT2[6] Integer INT_STORAGE 0 80 COLHDNG_1 COL Heading[1] String STR50 50 81 COLHDNG_2 COL Heading[2] String STR50 50 82 COLHDNG_3 COL Heading[3] String STR50 50 83 COLHDNG_4 COL Heading[4] String STR50 50 84 COLHDNG_5 COL Heading[5] String STR50 50 85 COLHDNG_6 COL Heading[6] String STR50 50 86 COLHDNG2_1 COL Heading2[1] String STR50 50 87 COLHDNG2_2 COL Heading2[2] String STR50 50 88 COLHDNG2_3 COL Heading2[3] String STR50 50 89 COLHDNG2_4 COL Heading2[4] String STR50 50 90 COLHDNG2_5 COL Heading2[5] String STR50 50 91 COLHDNG2_6 COL Heading2[6] String STR50 50 92 ALGNOFST Alignment Offset Integer INT 0 93 COLEXPER COL Expression Error Boolean Boolean 0 94 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Report Column Temporary'].NOTEINDX AS 'Report Column Temporary-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
AF50300 AS ['Report Column Temporary']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Report Column Temporary'].NOTEINDX = ['Record Notes Master'].NOTEINDX