AR_AnalysisReportWrk AR Analysis Report Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_AnalysisReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_AnalysisReportWrk"+%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 . . . 14 CurrentAgingCategory1 . . . . 16.2 NNN Current Aging Category 1. . . . 15 CurrentAgingCategory2 . . . . 16.2 NNN Current Aging Category 2. . . . 16 Period1NoOfInvs . . . . . . . 7.0 NNN Period 1 Number Of Invoices . . 17 Period1TotalRcvbls. . . . . . 16.2 NNN Period 1 Total Receivables. . . 18 Period1AgingCategory1 . . . . 16.2 NNN Period 1 Aging Category 1 . . . 19 Period1AgingCategory2 . . . . 16.2 NNN Period 1 Aging Category 2 . . . 20 Period2NoOfInvs . . . . . . . 7.0 NNN Period 2 Number Of Invoices . . 21 Period2TotalRcvbls. . . . . . 16.2 NNN Period 2 Total Receivables. . . 22 Period2AgingCategory1 . . . . 16.2 NNN Period 2 Aging Category 1 . . . 23 Period2AgingCategory2 . . . . 16.2 NNN Period 2 Aging Category 2 . . . 24 Period3NoOfInvs . . . . . . . 7.0 NNN Period 3 Number Of Invoices . . 25 Period3TotalRcvbls. . . . . . 16.2 NNN Period 3 Total Receivables. . . 26 Period3AgingCategory1 . . . . 16.2 NNN Period 3 Aging Category 1 . . . 27 Period3AgingCategory2 . . . . 16.2 NNN Period 3 Aging Category 2 . . . 28 Period4NoOfInvs . . . . . . . 7.0 NNN Period 4 Number Of Invoices . . 29 Period4TotalRcvbls. . . . . . 16.2 NNN Period 4 Total Receivables. . . 30 Period4AgingCategory1 . . . . 16.2 NNN Period 4 Aging Category 1 . . . 31 Period4AgingCategory2 . . . . 16.2 NNN Period 4 Aging Category 2 . . . 32 Period5NoOfInvs . . . . . . . 7.0 NNN Period 5 Number Of Invoices . . 33 Period5TotalRcvbls. . . . . . 16.2 NNN Period 5 Total Receivables. . . 34 Period5AgingCategory1 . . . . 16.2 NNN Period 5 Aging Category 1 . . . 35 Period5AgingCategory2 . . . . 16.2 NNN Period 5 Aging Category 2 . . . 36 Period6NoOfInvs . . . . . . . 7.0 NNN Period 6 Number Of Invoices . . 37 Period6TotalRcvbls. . . . . . 16.2 NNN Period 6 Total Receivables. . . 38 Period6AgingCategory1 . . . . 16.2 NNN Period 6 Aging Category 1 . . . 39 Period6AgingCategory2 . . . . 16.2 NNN Period 6 Aging Category 2 . . . 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. . . .