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. . . . . . . .