     GL_Account                          GL Account Master                 Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: GL_Account_bus,BM_ProductionRegister_upd,BM_DisassemblyRegister_upd Mirror: GL_AccountHistory
     SQL Def: Y  SysDB: N                                            "MAS_"+%C$+"/GL"+%C$+"/GL_Account.M4T"

     KPRIMARY: AccountKey
     KACCOUNT: Account(u)
     KRAWACCOUNT: RawAccount
     KACCOUNTGROUP: AccountGroup+Account
     KMAINACCOUNTCODE: MainAccountCode+Account
     KROLLUPCODE1: RollupCode1+Account
     KROLLUPCODE2: RollupCode2+Account
     KROLLUPCODE3: RollupCode3+Account
     KROLLUPCODE4: RollupCode4+Account
     KSTATUS: Status+Account

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  AccountKey. . . . . . . . . .     9 SYY  Account Number. . . . . . . . .ACCOUNT
                                                    Read Only:Y
       2  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
       3  Account . . . . . . . . . . .    41 SYY  Fully Formatted Account Number.
       4  RawAccount. . . . . . . . . .    32 SYY  Unformatted Account Number. . .
                                                    Read Only:Y
       5  MainAccountCode . . . . . . .    15 SYY  Main Account. . . . . . . . . .MAINACCOUNT
                                                    Read Only:Y FmtType:ALPHANUM
                                                    Notes: Validated against
                                                    GL_MainAccount
       6  DateStart . . . . . . . . . .     8 SNN  Start Date. . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       7  DateEnd . . . . . . . . . . .     8 SNN  End Date. . . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       8  Status. . . . . . . . . . . .     1 SYY  Status. . . . . . . . . . . . .
                                                    DfltVal:A Valid:A,I,D Notes:
                                                    A=Active, I=Inactive,
                                                    D=Deleted
       9  ClearBalance. . . . . . . . .     1 SYY  Clear Balance . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Y=Year end, N=Never*
      10  AccountType . . . . . . . . .     2 SYY  Account Type. . . . . . . . . .ACCOUNTTYPE
                                                    Read Only:Y Mask:00
                                                    FmtType:ZEROFILL Notes: from
                                                     GL_MainAccount
      11  CashFlowsType . . . . . . . .     1 SYY  Cash Flows Type . . . . . . . .CASHFLOW
                                                    DfltVal:N Valid:C,F,I,N,O
                                                    Notes: Defaults from
                                                    GL_MainAccount.  C=Cash,
                                                    F=Financing, I=Investment,
                                                    N=None* , O=Operations
      12  RollupCode1 . . . . . . . . .    20 SNN  Rollup Code 1 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "1"+RollupCo
                                                    de1
      13  RollupCode2 . . . . . . . . .    20 SNN  Rollup Code 2 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "2"+RollupCo
                                                    de2
      14  RollupCode3 . . . . . . . . .    20 SNN  Rollup Code 3 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "3"+RollupCo
                                                    de3
      15  RollupCode4 . . . . . . . . .    20 SNN  Rollup Code 4 . . . . . . . . .ROLLUPCODE
                                                    Notes: Validated against
                                                    GL_Rollup.  Key: "4"+RollupCo
                                                    de4
      16  AccountGroup. . . . . . . . .    15 SYY  Account Group . . . . . . . . .ACCOUNTGROUP
                                                    Read Only:Y Notes: from
                                                    GL_MainAccount
      17  AccountCategory . . . . . . .     1 SYY  Account Category. . . . . . . .ACCOUNTCATEGORY
                                                    Read Only:Y Notes: from
                                                    GL_MainAccount
      18  CompanyCode . . . . . . . . .     3 SYY  Company Code. . . . . . . . . .
                                                    DfltVal: Notes:
                                                    Used to "join" Crystal
                                                    Tables.
      19  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y
      20  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      21  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL
      22  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y
      23  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      24  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL