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