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