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