GL_Account GL Account Master Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_Account_bus,BM_ProductionRegister_upd,BM_DisassemblyRegister_upd Mirror: GL_AccountHistory SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_Account.M4T"
KPRIMARY: AccountKey KACCOUNT: Account(u) KRAWACCOUNT: RawAccount KACCOUNTGROUP: AccountGroup+Account KMAINACCOUNTCODE: MainAccountCode+Account KROLLUPCODE1: RollupCode1+Account KROLLUPCODE2: RollupCode2+Account KROLLUPCODE3: RollupCode3+Account KROLLUPCODE4: RollupCode4+Account KSTATUS: Status+Account
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT Read Only:Y 2 AccountDesc . . . . . . . . . 50 SNN Account Description . . . . . . 3 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number. 4 RawAccount. . . . . . . . . . 32 SYY Unformatted Account Number. . . Read Only:Y 5 MainAccountCode . . . . . . . 15 SYY Main Account. . . . . . . . . .MAINACCOUNT Read Only:Y FmtType:ALPHANUM Notes: Validated against 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 . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: Y=Year end, N=Never* 10 AccountType . . . . . . . . . 2 SYY Account Type. . . . . . . . . .ACCOUNTTYPE Read Only:Y Mask:00 FmtType:ZEROFILL Notes: from GL_MainAccount 11 CashFlowsType . . . . . . . . 1 SYY Cash Flows Type . . . . . . . .CASHFLOW DfltVal:N Valid:C,F,I,N,O Notes: Defaults from GL_MainAccount. C=Cash, F=Financing, I=Investment, N=None* , O=Operations 12 RollupCode1 . . . . . . . . . 20 SNN Rollup Code 1 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "1"+RollupCo de1 13 RollupCode2 . . . . . . . . . 20 SNN Rollup Code 2 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "2"+RollupCo de2 14 RollupCode3 . . . . . . . . . 20 SNN Rollup Code 3 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "3"+RollupCo de3 15 RollupCode4 . . . . . . . . . 20 SNN Rollup Code 4 . . . . . . . . .ROLLUPCODE Notes: Validated against GL_Rollup. Key: "4"+RollupCo de4 16 AccountGroup. . . . . . . . . 15 SYY Account Group . . . . . . . . .ACCOUNTGROUP Read Only:Y Notes: from GL_MainAccount 17 AccountCategory . . . . . . . 1 SYY Account Category. . . . . . . .ACCOUNTCATEGORY Read Only:Y Notes: from GL_MainAccount 18 CompanyCode . . . . . . . . . 3 SYY Company Code. . . . . . . . . . DfltVal: Notes: Used to "join" Crystal Tables. 19 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y 20 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 21 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 22 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y 23 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 24 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL