GL_Exchange                             GL Exchange                   Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: Y  SysDB: N                                           "MAS_"+%C$+"/GL"+%C$+"/GL_Exchange.M4T"

 KPRIMARY: ExchangeName

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ExchangeName. . . . . . . . .    20 SNY  Exchange Name . . . . . . . . .
   2  ExchangeDesc. . . . . . . . .    40 SNN  Exchange Desc . . . . . . . . .
   3  ExchangeMethod. . . . . . . .     1 SYY  Exchange Method . . . . . . . .
                                                DfltVal:E Valid:I,E Notes:
                                                I=Import, E=Export
   4  ExchangeType. . . . . . . . .     1 SYY  Exchange Type . . . . . . . . .
                                                DfltVal:A Valid:A,B,T Notes:
                                                A=Accounts, B=Budgets,
                                                T=Transactions
   5  BudgetCode. . . . . . . . . .    10 SNN  Budget Code . . . . . . . . . .BUDGETCODE
   6  FiscalYear. . . . . . . . . .     4 SNN  Fiscal Year . . . . . . . . . .YEAR
                                                Mask:0000
   7  IncludeActive . . . . . . . .     1 SYY  Include Active. . . . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
   8  IncludeInactive . . . . . . .     1 SYY  Include Inactive. . . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
   9  IncludeDeleted. . . . . . . .     1 SYY  Include Deleted . . . . . . . .YESNO
                                                DfltVal:Y Valid:Y,N
  10  ExcludeExpired. . . . . . . .     1 SYY  Exclude Expired . . . . . . . .
                                                DfltVal:N Valid:A,N,S Notes:
                                                A=byAccounting date, N=Never,
                                                 S=by System
  11  CreateMainAccounts. . . . . .     1 SYY  Create Main Accounts. . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  12  CreateSubAccounts . . . . . .     1 SYY  Create Sub Accounts . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  13  AllowOutOfBalance . . . . . .     1 SYY  Allow Out of Balance. . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  14  CreateSourceJournal . . . . .     1 SYY  Create Source Journal . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  15  DuplicateTransaction. . . . .     1 SYN  Duplicate Transaction . . . . .
                                                DfltVal:M Valid:M,D,R,I
                                                Notes: M=Merge imported
                                                entry with existing entry,
                                                D=Do not import entry,
                                                R=Replace entry with
                                                imported entry, I=Import
                                                entry using the next journal
                                                number
  16  FileType. . . . . . . . . . .     1 SYY  File Type . . . . . . . . . . .
                                                DfltVal:A Valid:A,C,D,E,L,P,
                                                S,W,X,3,5,7 Notes: A=ASCII,
                                                C=CSV, D=DIF, E=Excel 8,
                                                L=Lotus, P=PDF, S=Lotus WKS,
                                                W=MS Word, X=XML, 3=LosusWK3,
                                                 5=Excel 5, 7=Excel 7
  17  FileName. . . . . . . . . . .   250 SNN  File Name . . . . . . . . . . .
  18  FileLayout. . . . . . . . . .     1 SYY  File Layout . . . . . . . . . .
                                                DfltVal:S Valid:A,S Notes:
                                                A=Alternate, S=Standard