SE000401 - Account Rollups Account Period Detail
Dynamics GP table SE000401 (Account Rollups Account Period Detail) contains 18 columns including USERID, ACTNUMBR_1, ACTNUMBR_2....
SQL Query Builder
18 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| USERID | User ID | String | 16 | |
| ACTNUMBR_1 | Account Number:Account_Segment_Pool1 | String | 10 | |
| ACTNUMBR_2 | Account Number:Account_Segment_Pool2 | String | 10 | |
| ACTNUMBR_3 | Account Number:Account_Segment_Pool3 | String | 10 | |
| ACTNUMBR_4 | Account Number:Account_Segment_Pool4 | String | 10 | |
| ACTNUMBR_5 | Account Number:Account_Segment_Pool5 | String | 10 | |
| PERIODID | Period ID | Integer | 2 | |
| SESORNO1 | SE Segment No Sort1 | Integer | 2 | |
| SESORT1 | SE Segment Sort1 | String | 12 | |
| SE_Zero_NM | SE Zero NM | Integer | 2 | |
| SE_Zero_PB | SE Zero PB | Integer | 2 | |
| NETAMNT | Net Amount | Currency | 10 | |
| PERDBLNC | Period Balance | Currency | 10 | |
| OPENYEAR | Open Year | Integer | 2 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| SEBUDDET | SE Budget Detail | Integer | 2 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| ACTNUMST | Account Number String | String | 130 |
Related Tables
Tables that share columns with SE000401. Click "Join" to add to your query.