GP Tables

AF40103 - Financials Column Setup

Dynamics GP table AF40103 (Financials Column Setup) contains 80 columns including REPORTID, COLNUM, CLTKNCNT....

SQL Query Builder

80 Columns

Column Description Type Length
REPORTID Report ID Integer 2
COLNUM COL NUM Integer 2
CLTKNCNT CALC Token CNT Integer 2
COLTYPE COL Type Integer 2
COLSIZE COL Size Integer 2
COLOMCNT COL Offset Mark CNT Integer 2
COLOFMRK_1 COL Offset Marks[1] Integer 2
COLOFMRK_2 COL Offset Marks[2] Integer 2
COLOFMRK_3 COL Offset Marks[3] Integer 2
COLOFMRK_4 COL Offset Marks[4] Integer 2
HIDEFLAG Hide Flag Integer 2
TEXTVALU Text Value String 52
STPERIOD Start Period Integer 2
ENDPEROD End Period Integer 2
AMNTFROM Amount From Integer 2
HISTYEAR HIST Year Integer 2
BUDID BUD ID String 16
PRTSIGN PRT Sign Integer 2
PRTCOMMA PRT Comma Integer 2
PRTPCENT PRT Percent Integer 2
PRTTEXT PRT Text Integer 2
ROUNDOPT Round OPT Integer 2
HEADALIN Head Align Integer 2
HDFTFMLY Head Font Family Integer 2
HDFTSIZE Head Font Size Integer 2
HEDSTYLE_1 Head Style[1] Integer 2
HEDSTYLE_2 Head Style[2] Integer 2
HEDSTYLE_3 Head Style[3] Integer 2
HEDSTYLE_4 Head Style[4] Integer 2
HEDSTYLE_5 Head Style[5] Integer 2
HEDSTYLE_6 Head Style[6] Integer 2
HEADTYPE_1 Head Type[1] Integer 2
HEADTYPE_2 Head Type[2] Integer 2
HEADTYPE_3 Head Type[3] Integer 2
HEADTYPE_4 Head Type[4] Integer 2
HEADTYPE_5 Head Type[5] Integer 2
HEADTYPE_6 Head Type[6] Integer 2
HEDFRMAT_1 Head Format[1] Integer 2
HEDFRMAT_2 Head Format[2] Integer 2
HEDFRMAT_3 Head Format[3] Integer 2
HEDFRMAT_4 Head Format[4] Integer 2
HEDFRMAT_5 Head Format[5] Integer 2
HEDFRMAT_6 Head Format[6] Integer 2
HEADOPT_1 Head OPT[1] Integer 2
HEADOPT_2 Head OPT[2] Integer 2
HEADOPT_3 Head OPT[3] Integer 2
HEADOPT_4 Head OPT[4] Integer 2
HEADOPT_5 Head OPT[5] Integer 2
HEADOPT_6 Head OPT[6] Integer 2
HEADOPT2_1 Head OPT2[1] Integer 2
HEADOPT2_2 Head OPT2[2] Integer 2
HEADOPT2_3 Head OPT2[3] Integer 2
HEADOPT2_4 Head OPT2[4] Integer 2
HEADOPT2_5 Head OPT2[5] Integer 2
HEADOPT2_6 Head OPT2[6] Integer 2
COLHDNG_1 COL Heading[1] String 52
COLHDNG_2 COL Heading[2] String 52
COLHDNG_3 COL Heading[3] String 52
COLHDNG_4 COL Heading[4] String 52
COLHDNG_5 COL Heading[5] String 52
COLHDNG_6 COL Heading[6] String 52
COLHDNG2_1 COL Heading2[1] String 52
COLHDNG2_2 COL Heading2[2] String 52
COLHDNG2_3 COL Heading2[3] String 52
COLHDNG2_4 COL Heading2[4] String 52
COLHDNG2_5 COL Heading2[5] String 52
COLHDNG2_6 COL Heading2[6] String 52
ALGNOFST Alignment Offset Integer 2
COLEXPER COL Expression Error Boolean 2
NOTEINDX Note Index Currency 10
SEGFROM_1 SEG From:Account_Segment_Pool1 String 10
SEGFROM_2 SEG From:Account_Segment_Pool2 String 10
SEGFROM_3 SEG From:Account_Segment_Pool3 String 10
SEGFROM_4 SEG From:Account_Segment_Pool4 String 10
SEGFROM_5 SEG From:Account_Segment_Pool5 String 10
SEGTO_1 SEG To:Account_Segment_Pool1 String 10
SEGTO_2 SEG To:Account_Segment_Pool2 String 10
SEGTO_3 SEG To:Account_Segment_Pool3 String 10
SEGTO_4 SEG To:Account_Segment_Pool4 String 10
SEGTO_5 SEG To:Account_Segment_Pool5 String 10

Related Tables

Tables that share columns with AF40103. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40106 ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04

REPORTID

AF40100 AF40101 AF40102 AF40104 AF40105 AF40106 AF40107 AF40108

PRTSIGN

AF40106