GL_ExchangeAccountWrk GL Exchange Account Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_ExchangeAccountWrk"+%S$+".M4T"
KPRIMARY: Account
Fld Column Name M/L TUR Description/Notes Class
1 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number. 2 MainAccountCode . . . . . . . 15 SNN Main Account Code . . . . . . .MAINACCOUNT 3 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 4 AccountType . . . . . . . . . 2 SYY Account Type. . . . . . . . . .ACCOUNTTYPE Read Only:Y Mask:00 FmtType:ZEROFILL Notes: from GL_MainAccount 5 AccountGroup. . . . . . . . . 15 SYY Account Group . . . . . . . . .ACCOUNTGROUP Read Only:Y Notes: from GL_MainAccount 6 DateStart . . . . . . . . . . 8 SNN Start Date. . . . . . . . . . .DATE Notes: YYYYMMDD 7 DateEnd . . . . . . . . . . . 8 SNN End Date. . . . . . . . . . . .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,N Notes: Y=Year end, N=Never* 10 RollupCode1 . . . . . . . . . 20 SNN Rollup Code 1 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "1"+RollupCo de1 11 RollupCode2 . . . . . . . . . 20 SNN Rollup Code 2 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "2"+RollupCo de2 12 RollupCode3 . . . . . . . . . 20 SNN Rollup Code 3 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "3"+RollupCo de3 13 RollupCode4 . . . . . . . . . 20 SNN Rollup Code 4 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "4"+RollupCo de4 14 SkipRecord. . . . . . . . . . 1 SYY Skip Record . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 15 SkipReason. . . . . . . . . . 1024 SNN Skip Reason . . . . . . . . . .