AF40201 - Financials Accelerator Options
Dynamics GP table AF40201 (Financials Accelerator Options) contains 40 columns including REPORTID, RptOptID, ROWNMBR....
SQL Query Builder
40 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| REPORTID | Report ID | Integer | 2 | |
| RptOptID | Report Option ID | Currency | 10 | |
| ROWNMBR | Row Number | Integer | 2 | |
| SEQNUMBR | Sequence Number | Long Integer | 4 | |
| ACTARR1_1_1 | Account Information Array1[1]:Account_Segment_Pool1 | String | 10 | |
| ACTARR1_1_2 | Account Information Array1[1]:Account_Segment_Pool2 | String | 10 | |
| ACTARR1_1_3 | Account Information Array1[1]:Account_Segment_Pool3 | String | 10 | |
| ACTARR1_1_4 | Account Information Array1[1]:Account_Segment_Pool4 | String | 10 | |
| ACTARR1_1_5 | Account Information Array1[1]:Account_Segment_Pool5 | String | 10 | |
| ACTARR1_2_1 | Account Information Array1[2]:Account_Segment_Pool1 | String | 10 | |
| ACTARR1_2_2 | Account Information Array1[2]:Account_Segment_Pool2 | String | 10 | |
| ACTARR1_2_3 | Account Information Array1[2]:Account_Segment_Pool3 | String | 10 | |
| ACTARR1_2_4 | Account Information Array1[2]:Account_Segment_Pool4 | String | 10 | |
| ACTARR1_2_5 | Account Information Array1[2]:Account_Segment_Pool5 | String | 10 | |
| ACTARR1_3_1 | Account Information Array1[3]:Account_Segment_Pool1 | String | 10 | |
| ACTARR1_3_2 | Account Information Array1[3]:Account_Segment_Pool2 | String | 10 | |
| ACTARR1_3_3 | Account Information Array1[3]:Account_Segment_Pool3 | String | 10 | |
| ACTARR1_3_4 | Account Information Array1[3]:Account_Segment_Pool4 | String | 10 | |
| ACTARR1_3_5 | Account Information Array1[3]:Account_Segment_Pool5 | String | 10 | |
| ACTARR1_4_1 | Account Information Array1[4]:Account_Segment_Pool1 | String | 10 | |
| ACTARR1_4_2 | Account Information Array1[4]:Account_Segment_Pool2 | String | 10 | |
| ACTARR1_4_3 | Account Information Array1[4]:Account_Segment_Pool3 | String | 10 | |
| ACTARR1_4_4 | Account Information Array1[4]:Account_Segment_Pool4 | String | 10 | |
| ACTARR1_4_5 | Account Information Array1[4]:Account_Segment_Pool5 | String | 10 | |
| ACTARR2_1_1 | Account Information Array2[1]:Account Description | String | 52 | |
| ACTARR2_1_2 | Account Information Array2[1]:Typical Balance | Integer | 2 | |
| ACTARR2_1_3 | Account Information Array2[1]:Account Type | Integer | 2 | |
| ACTARR2_1_4 | Account Information Array2[1]:Account Index | Long Integer | 4 | |
| ACTARR2_2_1 | Account Information Array2[2]:Account Description | String | 52 | |
| ACTARR2_2_2 | Account Information Array2[2]:Typical Balance | Integer | 2 | |
| ACTARR2_2_3 | Account Information Array2[2]:Account Type | Integer | 2 | |
| ACTARR2_2_4 | Account Information Array2[2]:Account Index | Long Integer | 4 | |
| ACTARR2_3_1 | Account Information Array2[3]:Account Description | String | 52 | |
| ACTARR2_3_2 | Account Information Array2[3]:Typical Balance | Integer | 2 | |
| ACTARR2_3_3 | Account Information Array2[3]:Account Type | Integer | 2 | |
| ACTARR2_3_4 | Account Information Array2[3]:Account Index | Long Integer | 4 | |
| ACTARR2_4_1 | Account Information Array2[4]:Account Description | String | 52 | |
| ACTARR2_4_2 | Account Information Array2[4]:Typical Balance | Integer | 2 | |
| ACTARR2_4_3 | Account Information Array2[4]:Account Type | Integer | 2 | |
| ACTARR2_4_4 | Account Information Array2[4]:Account Index | Long Integer | 4 |