     GL_MainAccount                      GL Main Account Master            Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: GL_MainAccount_bus
     SQL Def: Y  SysDB: N                                        "MAS_"+%C$+"/GL"+%C$+"/GL_MainAccount.M4T"

     KPRIMARY: SegmentNo+MainAccountCode
     KMAINACCOUNTCODE: MainAccountCode
     KROLLUPCODE1: RollupCode1+MainAccountCode
     KROLLUPCODE2: RollupCode2+MainAccountCode
     KROLLUPCODE3: RollupCode3+MainAccountCode
     KROLLUPCODE4: RollupCode4+MainAccountCode
     KACCOUNTGROUP: AccountGroup+SegmentNo+MainAccountCode
     KSTATUS: Status+MainAccountCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SegmentNo . . . . . . . . . .     2 SYY  Segment Number. . . . . . . . .
                                                    DfltVal:01 Mask:00 Valid:01
                                                    FmtType:ZEROFILL Notes:
                                                    Validated against GL_AccountS
                                                    tructure
       2  MainAccountCode . . . . . . .    15 SYY  Main Account Code . . . . . . .MAINACCOUNT
                                                    FmtType:ALPHANUM
       3  MainAccountDesc . . . . . . .    40 SNN  Main Account Description. . . .
       4  MainAccountShortDesc. . . . .    20 SNN  Main Account Short Description.
       5  DateStart . . . . . . . . . .     8 SNN  Start Date. . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       6  DateEnd . . . . . . . . . . .     8 SNN  End Date. . . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       7  Status. . . . . . . . . . . .     1 SYY  Status. . . . . . . . . . . . .
                                                    DfltVal:A Valid:A,I,D Notes:
                                                    A=Active*, I=Inactive,
                                                    D=Deleted
       8  ClearBalance. . . . . . . . .     1 SYY  Clear Balance . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Y=Year end, N=Never*
       9  AccountGroup. . . . . . . . .    15 SYY  Account Group . . . . . . . . .ACCOUNTGROUP
                                                    Notes: Validated against
                                                    GL_AccountGroup
      10  AccountCategory . . . . . . .     1 SYY  Account Category. . . . . . . .ACCOUNTCATEGORY
                                                    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, 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  RollupCode2 . . . . . . . . .    20 SNN  Rollup Code 2 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "2"+RollupCo
                                                    de2
      15  RollupCode3 . . . . . . . . .    20 SNN  Rollup Code 3 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "3"+RollupCo
                                                    de3
      16  RollupCode4 . . . . . . . . .    20 SNN  Rollup Code 4 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "4"+RollupCo
                                                    de4
      17  CompanyCode . . . . . . . . .     3 SYY  Company Code. . . . . . . . . .
                                                    DfltVal: Notes:
                                                    Used to "join" Crystal
                                                    Tables.
      18  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y
      19  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      20  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL
      21  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y
      22  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      23  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL