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