GP Tables

AF40106 - Financials Row Setup

Dynamics GP table AF40106 (Financials Row Setup) contains 74 columns including REPORTID, ROWNUMBR, TOTKNCNT....

SQL Query Builder

74 Columns

Column Description Type Length
REPORTID Report ID Integer 2
ROWNUMBR Row NUM Integer 2
TOTKNCNT Total Token CNT Integer 2
ROWTYPE Row Type Integer 2
ROWSIZE Row Size Integer 2
ROLUPFLG Roll Up Flag Integer 2
ROWDESC Row DESC String 52
SUBSUDID Subsidiary ID String 16
TYPCLBAL Typical BAL Integer 2
CATNUMBR Category NUM Integer 2
PRTSIGN PRT Sign Integer 2
PRTHEDER PRT Header Integer 2
CENTHEDR Center Header Integer 2
ROWFTFAM Row Font Family Integer 2
ROWFTSIZ Row Font Size Integer 2
ROWSTYLE_1 Row Style[1] Integer 2
ROWSTYLE_2 Row Style[2] Integer 2
ROWSTYLE_3 Row Style[3] Integer 2
ROWSTYLE_4 Row Style[4] Integer 2
ROWSTYLE_5 Row Style[5] Integer 2
ROWSTYLE_6 Row Style[6] Integer 2
ROFMRKIN_1 Row Offset Mark Indexes[1] Integer 2
ROFMRKIN_2 Row Offset Mark Indexes[2] Integer 2
ROFMRKIN_3 Row Offset Mark Indexes[3] Integer 2
ROFMRKIN_4 Row Offset Mark Indexes[4] Integer 2
ROFMRKIN_5 Row Offset Mark Indexes[5] Integer 2
ROFMRKIN_6 Row Offset Mark Indexes[6] Integer 2
ROFMRKIN_7 Row Offset Mark Indexes[7] Integer 2
ROFMRKIN_8 Row Offset Mark Indexes[8] Integer 2
ROFMRKIN_9 Row Offset Mark Indexes[9] Integer 2
ROFMRKIN_10 Row Offset Mark Indexes[10] Integer 2
ROFMRKIN_11 Row Offset Mark Indexes[11] Integer 2
ROFMRKIN_12 Row Offset Mark Indexes[12] Integer 2
ROFMRKIN_13 Row Offset Mark Indexes[13] Integer 2
ROFMRKIN_14 Row Offset Mark Indexes[14] Integer 2
ROFMRKIN_15 Row Offset Mark Indexes[15] Integer 2
ROFMRKIN_16 Row Offset Mark Indexes[16] Integer 2
ROFMRKIN_17 Row Offset Mark Indexes[17] Integer 2
ROFMRKIN_18 Row Offset Mark Indexes[18] Integer 2
ROFMRKIN_19 Row Offset Mark Indexes[19] Integer 2
ROFMRKIN_20 Row Offset Mark Indexes[20] Integer 2
ROFMRKIN_21 Row Offset Mark Indexes[21] Integer 2
ROFMRKIN_22 Row Offset Mark Indexes[22] Integer 2
ROFMRKIN_23 Row Offset Mark Indexes[23] Integer 2
ROFMRKIN_24 Row Offset Mark Indexes[24] Integer 2
ROFMRKIN_25 Row Offset Mark Indexes[25] Integer 2
ROFMRKIN_26 Row Offset Mark Indexes[26] Integer 2
ROFMRKIN_27 Row Offset Mark Indexes[27] Integer 2
ROFMRKIN_28 Row Offset Mark Indexes[28] Integer 2
ROFMRKIN_29 Row Offset Mark Indexes[29] Integer 2
ROFMRKIN_30 Row Offset Mark Indexes[30] Integer 2
ROFMRKIN_31 Row Offset Mark Indexes[31] Integer 2
ROFMRKIN_32 Row Offset Mark Indexes[32] Integer 2
ROFMRKIN_33 Row Offset Mark Indexes[33] Integer 2
ROFMRKIN_34 Row Offset Mark Indexes[34] Integer 2
ROFMRKIN_35 Row Offset Mark Indexes[35] Integer 2
ROFMRKIN_36 Row Offset Mark Indexes[36] Integer 2
ROFMRKIN_37 Row Offset Mark Indexes[37] Integer 2
ROFMRKIN_38 Row Offset Mark Indexes[38] Integer 2
ROFMRKIN_39 Row Offset Mark Indexes[39] Integer 2
ROFMRKIN_40 Row Offset Mark Indexes[40] Integer 2
CFLOSCTN Cash Flow Section Integer 2
RWEXPERR Row Expression Error Boolean 2
NOTEINDX Note Index Currency 10
STTACCT_1 Start ACCT:Account_Mask_Pool1 String 10
STTACCT_2 Start ACCT:Account_Mask_Pool2 String 10
STTACCT_3 Start ACCT:Account_Mask_Pool3 String 10
STTACCT_4 Start ACCT:Account_Mask_Pool4 String 10
STTACCT_5 Start ACCT:Account_Mask_Pool5 String 10
ENDACCT_1 End ACCT:Account_Mask_Pool1 String 10
ENDACCT_2 End ACCT:Account_Mask_Pool2 String 10
ENDACCT_3 End ACCT:Account_Mask_Pool3 String 10
ENDACCT_4 End ACCT:Account_Mask_Pool4 String 10
ENDACCT_5 End ACCT:Account_Mask_Pool5 String 10

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04

REPORTID

AF40100 AF40101 AF40102 AF40103 AF40104 AF40105 AF40107 AF40108

PRTSIGN

AF40103