GL_CompanyActiveBatch GL Company Active Batch Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_CompanyActiveBatch.M4T"
KPRIMARY: ModuleCode+BatchType+BatchNo
KBATCHGROUP: BatchGroup+ModuleCode+BatchType+BatchNo
Fld Column Name M/L TUR Description/Notes Class
1 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE
2 BatchType . . . . . . . . . . 2 SYY Batch Type. . . . . . . . . . .
3 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM
4 BatchSubType. . . . . . . . . 1 SNN Batch Sub Type. . . . . . . . .
5 PrivateBatch. . . . . . . . . 1 SYY Private Batch . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
6 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
7 BatchStatus . . . . . . . . . 1 SYN Batch Status. . . . . . . . . .
8 BatchGroup. . . . . . . . . . 14 SYN Batch Group Sequence Number . .
Mask:00000000000000
FmtType:ZEROFILL
9 RegisterNo. . . . . . . . . . 6 SYN Register Number . . . . . . . .
Mask:000000 FmtType:ZEROFILL
10 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
11 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
Read Only:Y
12 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
13 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
14 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .
Read Only:Y
15 UserUpdatedKey. . . . . . . . 10 SYN User Updated Key. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
16 RecordCount . . . . . . . . . 6.0 NNN Record Count. . . . . . . . . .
Mask:###,##0
17 BatchTotal01. . . . . . . . . 16.2 NNN Batch Total 01. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
18 BatchTotal02. . . . . . . . . 16.2 NNN Batch Total 02. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
19 BatchTotal03. . . . . . . . . 16.2 NNN Batch Total 03. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
20 BatchTotal04. . . . . . . . . 16.2 NNN Batch Total 04. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
21 BatchTotal05. . . . . . . . . 16.2 NNN Batch Total 05. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
22 BatchTotal06. . . . . . . . . 16.2 NNN Batch Total 06. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
23 BatchTotal07. . . . . . . . . 16.2 NNN Batch Total 07. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
24 BatchTotal08. . . . . . . . . 16.2 NNN Batch Total 08. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
25 BatchTotal09. . . . . . . . . 16.2 NNN Batch Total 09. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
26 BatchTotal10. . . . . . . . . 16.2 NNN Batch Total 10. . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-