GP Tables

GL40200 - Segment Description Master

Contains descriptions for each segment value in the account structure (e.g., department names, division names).

SQL Query Builder

6 Columns

Column Description Type Length
SGMTNUMB smallint 0
SGMNTID char(67) ''
DSCRIPTN char(31) ''
SEGCOUNT int 0
NOTEINDX numeric(19,5) 0.00
DEX_ROW_ID int auto number (1,1)

Reporting Tips

  • - Join on SGMTNMBR and SGMNTID to get segment descriptions for reporting

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

NOTEINDX

AAG00201 AAG00300 AAG00400 AAG00401 AF40100 AF40103 AF40106 APR_BLM42100

SGMTNUMB