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.