GL_MainAccount GL Main Account Master Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_MainAccount_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_MainAccount.M4T"
KPRIMARY: SegmentNo+MainAccountCode
KMAINACCOUNTCODE: MainAccountCode
KROLLUPCODE1: RollupCode1+MainAccountCode
KROLLUPCODE2: RollupCode2+MainAccountCode
KROLLUPCODE3: RollupCode3+MainAccountCode
KROLLUPCODE4: RollupCode4+MainAccountCode
KACCOUNTGROUP: AccountGroup+SegmentNo+MainAccountCode
KSTATUS: Status+MainAccountCode
Fld Column Name M/L TUR Description/Notes Class
1 SegmentNo . . . . . . . . . . 2 SYY Segment Number. . . . . . . . .
DfltVal:01 Mask:00 Valid:01
FmtType:ZEROFILL Notes:
Validated against GL_AccountS
tructure
2 MainAccountCode . . . . . . . 15 SYY Main Account Code . . . . . . .MAINACCOUNT
FmtType:ALPHANUM
3 MainAccountDesc . . . . . . . 40 SNN Main Account Description. . . .
4 MainAccountShortDesc. . . . . 20 SNN Main Account Short Description.
5 DateStart . . . . . . . . . . 8 SNN Start Date. . . . . . . . . . .DATE
Notes: YYYYMMDD
6 DateEnd . . . . . . . . . . . 8 SNN End Date. . . . . . . . . . . .DATE
Notes: YYYYMMDD
7 Status. . . . . . . . . . . . 1 SYY Status. . . . . . . . . . . . .
DfltVal:A Valid:A,I,D Notes:
A=Active*, I=Inactive,
D=Deleted
8 ClearBalance. . . . . . . . . 1 SYY Clear Balance . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
Y=Year end, N=Never*
9 AccountGroup. . . . . . . . . 15 SYY Account Group . . . . . . . . .ACCOUNTGROUP
Notes: Validated against
GL_AccountGroup
10 AccountCategory . . . . . . . 1 SYY Account Category. . . . . . . .ACCOUNTCATEGORY
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, 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 RollupCode2 . . . . . . . . . 20 SNN Rollup Code 2 . . . . . . . . .ROLLUPCODE
Notes: Validated against
GL_Rollup. Key: "2"+RollupCo
de2
15 RollupCode3 . . . . . . . . . 20 SNN Rollup Code 3 . . . . . . . . .ROLLUPCODE
Notes: Validated against
GL_Rollup. Key: "3"+RollupCo
de3
16 RollupCode4 . . . . . . . . . 20 SNN Rollup Code 4 . . . . . . . . .ROLLUPCODE
Notes: Validated against
GL_Rollup. Key: "4"+RollupCo
de4
17 CompanyCode . . . . . . . . . 3 SYY Company Code. . . . . . . . . .
DfltVal: Notes:
Used to "join" Crystal
Tables.
18 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y
19 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
20 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
21 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y
22 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
23 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL