GL_AllocationSelectionDetail Allocation Selection Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_AllocationSelectionDetail.M4T"
KPRIMARY: AllocationNo+LineKey+LineSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 AllocationNo. . . . . . . . . 7 SYY Allocation Number . . . . . . .
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
Notes: Validated against
GL_Account
5 Account . . . . . . . . . . . 41 SYY Fully Formatted Account Number.
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
Notes: Validated against
GL_Account
10 LinkedAccount . . . . . . . . 41 SYN Linked Account. . . . . . . . .
Notes: Fully formatted
account
11 TemplateLinkedAcct. . . . . . 1 SYY Template Linked Acct. . . . . .YESNO
DfltVal:N Valid:Y,N
12 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT
13 Quantity. . . . . . . . . . . 13.2 NYN 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 Debit Amount. . . . . . . . . .TRANSACTIONAMT
Mask:###,###,###.00-
17 OriginalLineKey . . . . . . . 6 SNY Original Line Key . . . . . . .
Mask:000000 FmtType:ZEROFILL
Notes: This field is placed
at the end to allow 1 to 1
composite string assignments
with the fields in GL_Allocat
ion Detail.