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