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

 KPRIMARY: CompanyCode

 Fld  Column Name                     M/L TUR  Description/Notes              Class

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