     GL_MainAccountListingWrk              GL Main Account Listing Work    Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: GL_MainAccount_rpt
     SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/GL"+%C$+"/GL_MainAccountListingWrk"+%S$+".M4T"

     KPRIMARY: MainAccountCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  MainAccountCode . . . . . . .    15 SYY  Main Account Code . . . . . . .MAINACCOUNT
                                                    Valid:0-9,A-Z FmtType:ALPHANU
                                                    M
       2  MainAccountDesc . . . . . . .    40 SNN  Main Account Description. . . .
       3  MainAccountShortDesc. . . . .    20 SNN  Main Account Short Description.
       4  DateStart . . . . . . . . . .     8 SNN  Start Date. . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       5  DateEnd . . . . . . . . . . .     8 SNN  End Date. . . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       6  Status. . . . . . . . . . . .     1 SYY  Status. . . . . . . . . . . . .
                                                    DfltVal:A Valid:A,I,D Notes:
                                                    A=Active*, I=Inactive,
                                                    D=Deleted
       7  ClearBalance. . . . . . . . .     1 SYY  Clear Balance . . . . . . . . .
                                                    DfltVal:N Valid:N,Y,P Notes:
                                                    Y=Year end, P=Period end,
                                                    N=Never*
       8  AccountGroup. . . . . . . . .    15 SYY  Account Group . . . . . . . . .ACCOUNTGROUP
                                                    Notes: Validated against
                                                    GL_AccountGroup
       9  AccountGroupDesc. . . . . . .    40 SNN  Account Group Description . . .
      10  AccountCategory . . . . . . .     1 SYY  Account Category. . . . . . . .
                                                    Read Only:Y Notes: from
                                                    GL_AccountGroup
      11  AccountType . . . . . . . . .     2 SYY  Account Type. . . . . . . . . .ACCOUNTTYPE
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: Validated against
                                                    GL_AccountType
      12  CashFlowsType . . . . . . . .     1 SYY  Cash Flows Type . . . . . . . .CASHFLOW
                                                    DfltVal:N Valid:C,F,N,I,O
                                                    Notes: C=Cash, N=None,
                                                    F=Financing, I=Investment,
                                                    N=None*, O=Operations
      13  RollupCode1 . . . . . . . . .    20 SNN  Rollup Code 1 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "1"+RollupCo
                                                    de1
      14  RollupType1 . . . . . . . . .    20 SYN  Rollup Type 1 . . . . . . . . .
      15  RollupCode2 . . . . . . . . .    20 SNN  Rollup Code 2 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "2"+RollupCo
                                                    de2
      16  RollupType2 . . . . . . . . .    20 SYN  Rollup Type 2 . . . . . . . . .
      17  RollupCode3 . . . . . . . . .    20 SNN  Rollup Code 3 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "3"+RollupCo
                                                    de3
      18  RollupType3 . . . . . . . . .    20 SYN  Rollup Type 3 . . . . . . . . .
      19  RollupCode4 . . . . . . . . .    20 SNN  Rollup Code 4 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "4"+RollupCo
                                                    de4
      20  RollupType4 . . . . . . . . .    20 SYN  Rollup Type 4 . . . . . . . . .