SE00400 - Account Rollups Account Detail
Dynamics GP table SE00400 (Account Rollups Account Detail) contains 14 columns including USERID, ACTNUMBR_1, ACTNUMBR_2....
SQL Query Builder
14 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 | |
| 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 | |
| SESORNO1 | SE Segment No Sort1 | Integer | 2 | |
| SESORT1 | SE Segment Sort1 | String | 12 | |
| OPENYEAR | Open Year | 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 |
Related Tables
Tables that share columns with SE00400. Click "Join" to add to your query.