GL_AllocationDetail GL Allocation Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_AllocationDetail_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_AllocationDetail.M4T"
KPRIMARY: AllocationNo+LineKey
KDISPLAY: AllocationNo+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 AllocationNo. . . . . . . . . 7 SYY Allocation Number . . . . . . .ALLOCATIONNO
Read Only:Y FmtType:CHARNUM
Notes: Tag Field
2 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . .
Read Only:Y Mask:000000
FmtType:ZEROFILL Notes:
Unique For This Tag
3 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . .
Read Only:Y Mask:000000000000
00 FmtType:ZEROFILL
4 AccountKey. . . . . . . . . . 9 SYN Account Number. . . . . . . . .ACCOUNT
Read Only:Y Notes: Validated
against GL_Account
5 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number.
SetValIndex:kACCOUNT
6 TemplateAccount . . . . . . . 1 SYY Template Account. . . . . . . .YESNO
DfltVal:N Valid:Y,N
7 MaskedAccount . . . . . . . . 1 SYY Masked Account. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
8 LinkedValue . . . . . . . . . 1 SYY Linked Value. . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
9 LinkedAccountKey. . . . . . . 9 SYN Linked Account Number . . . . .ACCOUNT
Read Only:Y Notes: Validated
against GL_Account
10 LinkedAccount . . . . . . . . 41 SNN Linked Account. . . . . . . . .
Notes: Fully Formatted
11 TemplateLinkedAcct. . . . . . 1 SYY Template Linked Account . . . .YESNO
DfltVal:N Valid:Y,N
12 PostingComment. . . . . . . . 2048 SNN Comment . . . . . . . . . . . .COMMENT
13 Quantity. . . . . . . . . . . 13.2 NNN Quantity. . . . . . . . . . . .QUANTITY
Mask:###,###,###.00-
14 AllocationPercent . . . . . . 10.4 NNY Percentage. . . . . . . . . . .PERCENTAGE
Mask:-###.0000%
15 CreditAmount. . . . . . . . . 16.2 NNN Credit Amount . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
16 DebitAmount . . . . . . . . . 16.2 NNN Transaction Amount. . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-