     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