AR_Analysis                          AR Analysis Data                 Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: N  SysDB: N                                           "MAS_"+%C$+"/AR"+%C$+"/AR_Analysis.M4T"

 KPRIMARY: CompanyCode

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  CompanyCode . . . . . . . . .     3 SYN  Company Code. . . . . . . . . .COMPANYCODE
   2  LastUpdateDate. . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Notes: {ARX$(1,6)}
   3  Period1EndingDate . . . . . .     8 SNN  Period 1 Ending Date. . . . . .DATE
                                                Notes: {ARX$(7,6)}
   4  Period2EndingDate . . . . . .     8 SNN  Period 2 Ending Date. . . . . .DATE
                                                Notes: {ARX$(13,6)}
   5  Period3EndingDate . . . . . .     8 SNN  Period 3 Ending Date. . . . . .DATE
                                                Notes: {ARX$(19,6)}
   6  Period4EndingDate . . . . . .     8 SNN  Period 4 Ending Date. . . . . .DATE
                                                Notes: {ARX$(25,6)}
   7  Period5EndingDate . . . . . .     8 SNN  Period 5 Ending Date. . . . . .DATE
                                                Notes: {ARX$(31,6)}
   8  Period6EndingDate . . . . . .     8 SNN  Period 6 Ending Date. . . . . .DATE
                                                Notes: {ARX$(37,6)}
   9  CurrentNoOfInvs . . . . . . .  5.0  NNN  Current Number Of Invoices. . .
                                                Mask:####0 Notes: {ARX[0]}
  10  CurrentTotalRcvbls. . . . . . 13.2  NNN  Current Total Receivables Amoun
                                                Mask:###,###,###.00- Notes:
                                                {ARX[1]}
  11  CurrentOver30Days . . . . . . 13.2  NNN  Current Over 30 Days Amount . .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[2]}
  12  CurrentOver60Days . . . . . . 13.2  NNN  Current Over 60 Days Amount . .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[3]}
  13  Period1NoOfInvs . . . . . . .  7.0  NNN  Period 1 Number Of Invoices . .
                                                Mask:####0 Notes: {ARX[4]}
  14  Period1TotalRcvbls. . . . . . 13.2  NNN  Period 1 Total Receivables Amou
                                                Mask:###,###,###.00- Notes:
                                                {ARX[5]}
  15  Period1Over30Days . . . . . . 13.2  NNN  Period 1 Over 30 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[6]}
  16  Period1Over60Days . . . . . . 13.2  NNN  Period 1 Over 60 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[7]}
  17  Period2NoOfInvs . . . . . . .  7.0  NNN  Period 2 Number Of Invoices . .
                                                Mask:####0 Notes: {ARX[8]}
  18  Period2TotalRcvbls. . . . . . 13.2  NNN  Period 2 Total Receivables Amou
                                                Mask:###,###,###.00- Notes:
                                                {ARX[9]}
  19  Period2Over30Days . . . . . . 13.2  NNN  Period 2 Over 30 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[10]}
  20  Period2Over60Days . . . . . . 13.2  NNN  Period 2 Over 60 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[11]}
  21  Period3NoOfInvs . . . . . . .  7.0  NNN  Period 3 Number Of Invoices . .
                                                Mask:####0 Notes: {ARX[12]}
  22  Period3TotalRcvbls. . . . . . 13.2  NNN  Period 3 Total Receivables Amou
                                                Mask:###,###,###.00- Notes:
                                                {ARX[13]}
  23  Period3Over30Days . . . . . . 13.2  NNN  Period 3 Over 30 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[14]}
  24  Period3Over60Days . . . . . . 13.2  NNN  Period 3 Over 60 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[15]}
  25  Period4NoOfInvs . . . . . . .  7.0  NNN  Period 4 Number Of Invoices . .
                                                Mask:####0 Notes: {ARX[16]}
  26  Period4TotalRcvbls. . . . . . 13.2  NNN  Period 4 Total Receivables Amou
                                                Mask:###,###,###.00- Notes:
                                                {ARX[17]}
  27  Period4Over30Days . . . . . . 13.2  NNN  Period 4 Over 30 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[18]}
  28  Period4Over60Days . . . . . . 13.2  NNN  Period 4 Over 60 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[19]}
  29  Period5NoOfInvs . . . . . . .  7.0  NNN  Period 5 Number Of Invoices . .
                                                Mask:####0 Notes: {ARX[20]}
  30  Period5TotalRcvbls. . . . . . 13.2  NNN  Period 5 Total Receivables Amou
                                                Mask:###,###,###.00- Notes:
                                                {ARX[21]}
  31  Period5Over30Days . . . . . . 13.2  NNN  Period 5 Over 30 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[22]}
  32  Period5Over60Days . . . . . . 13.2  NNN  Period 5 Over 60 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[23]}
  33  Period6NoOfInvs . . . . . . .  7.0  NNN  Period 6 Number Of Invoices . .
                                                Mask:####0 Notes: {ARX[24]}
  34  Period6TotalRcvbls. . . . . . 13.2  NNN  Period 6 Total Receivables Amou
                                                Mask:###,###,###.00- Notes:
                                                {ARX[25]}
  35  Period6Over30Days . . . . . . 13.2  NNN  Period 6 Over 30 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[26]}
  36  Period6Over60Days . . . . . . 13.2  NNN  Period 6 Over 60 Days Amount. .
                                                Mask:###,###,###.00- Notes:
                                                {ARX[27]}
  37  TotalNoOfDaysOld. . . . . . . 13.2  NNN  Total Number Of Days Old - Non
                                                Mask:###,###,###.00- Notes:
                                                {ARX[28]}
  38  TotalOfOriginalInvAmounts . . 13.2  NNN  Total Of Original Invoice Amoun
                                                Mask:###,###,###.00- Notes:
                                                {ARX[29)}
  39  TotalNoOfInvs . . . . . . . . 13.2  NNN  Total Number Of Invoices - Non
                                                Mask:###,###,###.00- Notes:
                                                {ARX[30]}
  40  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  41  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  42  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL