GL_MainAccountListingWrk GL Main Account Listing Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_MainAccount_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_MainAccountListingWrk"+%S$+".M4T"
KPRIMARY: MainAccountCode
Fld Column Name M/L TUR Description/Notes Class
1 MainAccountCode . . . . . . . 15 SYY Main Account Code . . . . . . .MAINACCOUNT
Valid:0-9,A-Z FmtType:ALPHANU
M
2 MainAccountDesc . . . . . . . 40 SNN Main Account Description. . . .
3 MainAccountShortDesc. . . . . 20 SNN Main Account Short Description.
4 DateStart . . . . . . . . . . 8 SNN Start Date. . . . . . . . . . .DATE
Notes: YYYYMMDD
5 DateEnd . . . . . . . . . . . 8 SNN End Date. . . . . . . . . . . .DATE
Notes: YYYYMMDD
6 Status. . . . . . . . . . . . 1 SYY Status. . . . . . . . . . . . .
DfltVal:A Valid:A,I,D Notes:
A=Active*, I=Inactive,
D=Deleted
7 ClearBalance. . . . . . . . . 1 SYY Clear Balance . . . . . . . . .
DfltVal:N Valid:N,Y,P Notes:
Y=Year end, P=Period end,
N=Never*
8 AccountGroup. . . . . . . . . 15 SYY Account Group . . . . . . . . .ACCOUNTGROUP
Notes: Validated against
GL_AccountGroup
9 AccountGroupDesc. . . . . . . 40 SNN Account Group Description . . .
10 AccountCategory . . . . . . . 1 SYY Account Category. . . . . . . .
Read Only:Y Notes: from
GL_AccountGroup
11 AccountType . . . . . . . . . 2 SYY Account Type. . . . . . . . . .ACCOUNTTYPE
Mask:00 FmtType:ZEROFILL
Notes: Validated against
GL_AccountType
12 CashFlowsType . . . . . . . . 1 SYY Cash Flows Type . . . . . . . .CASHFLOW
DfltVal:N Valid:C,F,N,I,O
Notes: C=Cash, N=None,
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 . . . . . . . . .