     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