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