AP_AnalysisWrk AP Analysis Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_Analysis_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_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 AgingCategoriesToUseForInv. . 1 SNN Aging Categories To Use For Inv 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 CurrentTotalPayables. . . . . 16.2 NNN Current Total Payables Amount . 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 Period1TotalPayables. . . . . 16.2 NNN Period 1 Total Payables Amount. 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 Period2TotalPayables. . . . . 16.2 NNN Period 2 Total Payables Amount. 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 Period3TotalPayables. . . . . 16.2 NNN Period 3 Total Payables Amount. 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 Period4TotalPayables. . . . . 16.2 NNN Period 4 Total Payables Amount. 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 Period5TotalPayables. . . . . 16.2 NNN Period 5 Total Payables Amount. 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 Period6TotalPayables. . . . . 16.2 NNN Period 6 Total Payables Amount. 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