GL_ChartOfAccountsWrk                 GL Chart of Accounts Work       Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: GL_ChartOfAccounts_rpt
 SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/GL"+%C$+"/GL_ChartOfAccountsWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  GroupField. . . . . . . . . .    20 SNN  Group Field . . . . . . . . . .
   3  GroupFieldDesc. . . . . . . .    75 SNN  Group Field Description . . . .
   4  AccountKey. . . . . . . . . .     9 SYY  Account Number. . . . . . . . .ACCOUNT
   5  Account . . . . . . . . . . .    41 SYY  Fully Formatted Account Number.
   6  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
   7  DateStart . . . . . . . . . .     8 SNN  Start Date. . . . . . . . . . .DATE
                                                Notes: YYYYMMDD
   8  DateEnd . . . . . . . . . . .     8 SNN  End Date. . . . . . . . . . . .DATE
                                                Notes: YYYYMMDD
   9  Status. . . . . . . . . . . .     1 SYY  Status. . . . . . . . . . . . .
                                                DfltVal:A Valid:A,I,D Notes:
                                                A=Active, I=Inactive,
                                                D=Deleted
  10  ClearBalance. . . . . . . . .     1 SYY  Clear Balance . . . . . . . . .
                                                DfltVal:N Valid:Y,P,N Notes:
                                                Y=Year end, P=Period end,
                                                N=Never*
  11  AccountType . . . . . . . . .     2 SYY  Account Type. . . . . . . . . .ACCOUNTTYPE
                                                Read Only:Y Mask:00
                                                FmtType:ZEROFILL Notes: from
                                                 GL_MainAccount
  12  CashFlowsType . . . . . . . .     1 SYY  Cash Flows Type . . . . . . . .CASHFLOW
                                                Read Only:Y DfltVal:N
                                                Valid:C,F,I,N,O Notes: from
                                                GL_MainAccount.  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  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 . . . . . . . . .
  21  AccountGroup. . . . . . . . .    15 SNN  Account Group . . . . . . . . .
  22  AccountGroupDesc. . . . . . .    40 SNN  Account Group Description . . .
  23  AccountCategory . . . . . . .     1 SYN  Account Category. . . . . . . .