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

 KPRIMARY: AccountKey
 KACCOUNT: Account
 KRAWACCOUNT: RawAccount
 KACCOUNTGROUP: AccountGroup+Account
 KMAINACCOUNTCODE: MainAccountCode+Account
 KROLLUPCODE1: RollupCode1+Account
 KROLLUPCODE2: RollupCode2+Account
 KROLLUPCODE3: RollupCode3+Account
 KROLLUPCODE4: RollupCode4+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. . .
   5  MainAccountCode . . . . . . .    15 SYY  Main Account Code . . . . . . .MAINACCOUNT
                                                FmtType:ALPHANUM Notes:
                                                Validated against GL_MainAcco
                                                unt
   6  DateStart . . . . . . . . . .     8 SNN  Date Start. . . . . . . . . . .DATE
                                                Notes: YYYYMMDD
   7  DateEnd . . . . . . . . . . .     8 SNN  Date End. . . . . . . . . . . .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 . . . . . . . . .
                                                DfltVal:N Valid:Y,P,N Notes:
                                                Y=Year end, P=Period 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
                                                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
  12  RollupCode1 . . . . . . . . .    20 SNN  Rollup Code 1 . . . . . . . . .ROLLUPCODE
                                                Notes: Validated against
                                                GL_Rollup.  Key: "1"+RollupCo
                                                de1
  13  RollupCode2 . . . . . . . . .    20 SNN  Rollup Code . . . . . . . . . .ROLLUPCODE
                                                Notes: Validated against
                                                GL_Rollup.  Key: "2"+RollupCo
                                                de2
  14  RollupCode3 . . . . . . . . .    20 SNN  Rollup Code . . . . . . . . . .ROLLUPCODE
                                                Notes: Validated against
                                                GL_Rollup.  Key: "3"+RollupCo
                                                de3
  15  RollupCode4 . . . . . . . . .    20 SNN  Rollup Code . . . . . . . . . .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  Date Created. . . . . . . . . .DATE
                                                Read Only:Y
  20  TimeCreated . . . . . . . . .     8 SNY  Time Created. . . . . . . . . .
                                                Read Only:Y
  21  UserCreatedKey. . . . . . . .    10 SYY  User Created Key. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL
  22  DateDeleted . . . . . . . . .     8 SNN  Date Deleted. . . . . . . . . .DATE
  23  TimeDeleted . . . . . . . . .     8 SNN  Time Deleted. . . . . . . . . .
  24  UserDeletedKey. . . . . . . .    10 SYN  User Deleted Key. . . . . . . .USER
                                                Mask:0000000000 FmtType:ZEROF
                                                ILL