GL_DataExchange GL Data Exchange Defaults Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_DataExchange.M4T"
KPRIMARY: DataType+CompanyCode
Fld Column Name M/L TUR Description/Notes Class
1 DataType. . . . . . . . . . . 1 SNY Data Type . . . . . . . . . . .
Notes: 1=Export Account Data,
2=Export Transaction Data,
3=Import Account Data,
4=Import Transaction Data
2 CompanyCode . . . . . . . . . 3 SNY Company Code. . . . . . . . . .COMPANYCODE
3 AccountKeyStart . . . . . . . 9 SNY Starting G/L Acct Key . . . . .ACCOUNT
Notes: Validated against
GL_Account
4 AccountKeyEnd . . . . . . . . 9 SNY Ending G/L Acct Key . . . . . .ACCOUNT
Notes: Validated against
GL_Account
5 Segment1Start . . . . . . . . 15 SNY Starting Segment 1 Value. . . .
Notes: Validated against
GL_SubAccount
6 Segment1End . . . . . . . . . 15 SNY Ending Segment 1 Value. . . . .
Notes: Validated against
GL_SubAccount
7 Segment2Start . . . . . . . . 15 SNY Starting Segment 2 Value. . . .
Notes: Validated against
GL_SubAccount
8 Segment2End . . . . . . . . . 15 SNY Ending Segment 2 Value. . . . .
Notes: Validated against
GL_SubAccount
9 Segment3Start . . . . . . . . 15 SNY Starting Segment 3 Value. . . .
Notes: Validated against
GL_SubAccount
10 Segment3End . . . . . . . . . 15 SNY Ending Segment 3 Value. . . . .
Notes: Validated against
GL_SubAccount
11 Segment4Start . . . . . . . . 15 SNY Starting Segment 4 Value. . . .
Notes: Validated against
GL_SubAccount
12 Segment4End . . . . . . . . . 15 SNY Ending Segment 4 Value. . . . .
Notes: Validated against
GL_SubAccount
13 Segment5Start . . . . . . . . 15 SNY Starting Segment 5 Value. . . .
Notes: Validated against
GL_SubAccount
14 Segment5End . . . . . . . . . 15 SNY Ending Segment 5 Value. . . . .
Notes: Validated against
GL_SubAccount
15 Segment6Start . . . . . . . . 15 SNY Starting Segment 6 Value. . . .
Notes: Validated against
GL_SubAccount
16 Segment6End . . . . . . . . . 15 SNY Ending Segment 6 Value. . . . .
Notes: Validated against
GL_SubAccount
17 Segment7Start . . . . . . . . 15 SNY Starting Segment 7 Value. . . .
Notes: Validated against
GL_SubAccount
18 Segment7End . . . . . . . . . 15 SNY Ending Segment 7 Value. . . . .
Notes: Validated against
GL_SubAccount
19 Segment8Start . . . . . . . . 15 SNY Starting Segment 8 Value. . . .
Notes: Validated against
GL_SubAccount
20 Segment8End . . . . . . . . . 15 SNY Ending Segment 8 Value. . . . .
Notes: Validated against
GL_SubAccount
21 Segment9Start . . . . . . . . 15 SNY Starting Segment 9 Value. . . .
Notes: Validated against
GL_SubAccount
22 Segment9End . . . . . . . . . 15 SNY Ending Segment 9 Value. . . . .
Notes: Validated against
GL_SubAccount
23 Segment10Start. . . . . . . . 15 SNY Starting Segment 10 Value . . .
Notes: Validated against
GL_SubAccount
24 Segment10End. . . . . . . . . 15 SNY Ending Segment 10 Value . . . .
Notes: Validated against
GL_SubAccount
25 DateStart . . . . . . . . . . 8 SNY Starting Date . . . . . . . . .DATE
Notes: YYYYMMDD - Data Types
2 & 4 only
26 DateEnd . . . . . . . . . . . 8 SNY Ending Date . . . . . . . . . .DATE
Notes: Data Types 2 & 4 only
27 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL
Notes: GL, AP, AR... Data
Types 2 & 4 only
28 FileName. . . . . . . . . . . 256 SNY File Name . . . . . . . . . . .
29 FileType. . . . . . . . . . . 1 SNY File Type . . . . . . . . . . .
30 OutputType. . . . . . . . . . 1 SNY Output Type . . . . . . . . . .
Notes: Data Types 1 & 3 only