AR_AnalysisWrk AR Analysis Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_Analysis_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_AnalysisWrk"+%S$+".M4T"
KPRIMARY: CompanyCode
Fld Column Name M/L TUR Description/Notes Class
1 CompanyCode . . . . . . . . . 3 SNN Company Code. . . . . . . . . . 2 LastUpdateDate. . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE 3 Period1EndingDate . . . . . . 8 SNN Period 1 Ending Date. . . . . .DATE 4 Period2EndingDate . . . . . . 8 SNN Period 2 Ending Date. . . . . .DATE 5 Period3EndingDate . . . . . . 8 SNN Period 3 Ending Date. . . . . .DATE 6 Period4EndingDate . . . . . . 8 SNN Period 4 Ending Date. . . . . .DATE 7 Period5EndingDate . . . . . . 8 SNN Period 5 Ending Date. . . . . .DATE 8 Period6EndingDate . . . . . . 8 SNN Period 6 Ending Date. . . . . .DATE 9 AgingCategory . . . . . . . . 1 SNN Aging Category To Use . . . . . 10 AgingCategory1. . . . . . . . 3.0 NNN Aging Category 1. . . . . . . . 11 AgingCategory2. . . . . . . . 3.0 NNN Aging Category 2. . . . . . . . 12 CurrentNoOfInvs . . . . . . . 5.0 NNN Current Number Of Invoices. . . 13 CurrentTotalRcvbls. . . . . . 16.2 NNN Current Total Receivables Amoun 14 CurrentAgingCategory1 . . . . 16.2 NNN Current Aging Category 1 Amount 15 CurrentAgingCategory2 . . . . 16.2 NNN Current Aging Category 2 Amount 16 Period1NoOfInvs . . . . . . . 7.0 NNN Period 1 Number Of Invoices . . 17 Period1TotalRcvbls. . . . . . 16.2 NNN Period 1 Total Receivables Amou 18 Period1AgingCategory1 . . . . 16.2 NNN Period 1 Aging Category 1 Amoun 19 Period1AgingCategory2 . . . . 16.2 NNN Period 1 Aging Category 2 Amoun 20 Period2NoOfInvs . . . . . . . 7.0 NNN Period 2 Number Of Invoices . . 21 Period2TotalRcvbls. . . . . . 16.2 NNN Period 2 Total Receivables Amou 22 Period2AgingCategory1 . . . . 16.2 NNN Period 2 Aging Category 1 Amoun 23 Period2AgingCategory2 . . . . 16.2 NNN Period 2 Aging Category 2 Amoun 24 Period3NoOfInvs . . . . . . . 7.0 NNN Period 3 Number Of Invoices . . 25 Period3TotalRcvbls. . . . . . 16.2 NNN Period 3 Total Receivables Amou 26 Period3AgingCategory1 . . . . 16.2 NNN Period 3 Aging Category 1 Amoun 27 Period3AgingCategory2 . . . . 16.2 NNN Period 3 Aging Category 2 Amoun 28 Period4NoOfInvs . . . . . . . 7.0 NNN Period 4 Number Of Invoices . . 29 Period4TotalRcvbls. . . . . . 16.2 NNN Period 4 Total Receivables Amou 30 Period4AgingCategory1 . . . . 16.2 NNN Period 4 Aging Category 1 Amoun 31 Period4AgingCategory2 . . . . 16.2 NNN Period 4 Aging Category 2 Amoun 32 Period5NoOfInvs . . . . . . . 7.0 NNN Period 5 Number Of Invoices . . 33 Period5TotalRcvbls. . . . . . 16.2 NNN Period 5 Total Receivables Amou 34 Period5AgingCategory1 . . . . 16.2 NNN Period 5 Aging Category 1 Amoun 35 Period5AgingCategory2 . . . . 16.2 NNN Period 5 Aging Category 2 Amoun 36 Period6NoOfInvs . . . . . . . 7.0 NNN Period 6 Number Of Invoices . . 37 Period6TotalRcvbls. . . . . . 16.2 NNN Period 6 Total Receivables Amou 38 Period6AgingCategory1 . . . . 16.2 NNN Period 6 Aging Category 1 Amoun 39 Period6AgingCategory2 . . . . 16.2 NNN Period 6 Aging Category 2 Amoun 40 TotalNoOfDaysOld. . . . . . . 16.2 NNN Total Number Of Days Old. . . . 41 TotalOfOriginalInvAmounts . . 16.2 NNN Total Of Original Invoice Amoun 42 TotalNoOfInvs . . . . . . . . 16.2 NNN Total Number Of Invoices. . . .