AR_Analysis AR Analysis Data Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_Analysis.M4T"
KPRIMARY: CompanyCode
Fld Column Name M/L TUR Description/Notes Class
1 CompanyCode . . . . . . . . . 3 SYN Company Code. . . . . . . . . .COMPANYCODE 2 LastUpdateDate. . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Notes: {ARX$(1,6)} 3 Period1EndingDate . . . . . . 8 SNN Period 1 Ending Date. . . . . .DATE Notes: {ARX$(7,6)} 4 Period2EndingDate . . . . . . 8 SNN Period 2 Ending Date. . . . . .DATE Notes: {ARX$(13,6)} 5 Period3EndingDate . . . . . . 8 SNN Period 3 Ending Date. . . . . .DATE Notes: {ARX$(19,6)} 6 Period4EndingDate . . . . . . 8 SNN Period 4 Ending Date. . . . . .DATE Notes: {ARX$(25,6)} 7 Period5EndingDate . . . . . . 8 SNN Period 5 Ending Date. . . . . .DATE Notes: {ARX$(31,6)} 8 Period6EndingDate . . . . . . 8 SNN Period 6 Ending Date. . . . . .DATE Notes: {ARX$(37,6)} 9 CurrentNoOfInvs . . . . . . . 5.0 NNN Current Number Of Invoices. . . Mask:####0 Notes: {ARX[0]} 10 CurrentTotalRcvbls. . . . . . 13.2 NNN Current Total Receivables Amoun Mask:###,###,###.00- Notes: {ARX[1]} 11 CurrentOver30Days . . . . . . 13.2 NNN Current Over 30 Days Amount . . Mask:###,###,###.00- Notes: {ARX[2]} 12 CurrentOver60Days . . . . . . 13.2 NNN Current Over 60 Days Amount . . Mask:###,###,###.00- Notes: {ARX[3]} 13 Period1NoOfInvs . . . . . . . 7.0 NNN Period 1 Number Of Invoices . . Mask:####0 Notes: {ARX[4]} 14 Period1TotalRcvbls. . . . . . 13.2 NNN Period 1 Total Receivables Amou Mask:###,###,###.00- Notes: {ARX[5]} 15 Period1Over30Days . . . . . . 13.2 NNN Period 1 Over 30 Days Amount. . Mask:###,###,###.00- Notes: {ARX[6]} 16 Period1Over60Days . . . . . . 13.2 NNN Period 1 Over 60 Days Amount. . Mask:###,###,###.00- Notes: {ARX[7]} 17 Period2NoOfInvs . . . . . . . 7.0 NNN Period 2 Number Of Invoices . . Mask:####0 Notes: {ARX[8]} 18 Period2TotalRcvbls. . . . . . 13.2 NNN Period 2 Total Receivables Amou Mask:###,###,###.00- Notes: {ARX[9]} 19 Period2Over30Days . . . . . . 13.2 NNN Period 2 Over 30 Days Amount. . Mask:###,###,###.00- Notes: {ARX[10]} 20 Period2Over60Days . . . . . . 13.2 NNN Period 2 Over 60 Days Amount. . Mask:###,###,###.00- Notes: {ARX[11]} 21 Period3NoOfInvs . . . . . . . 7.0 NNN Period 3 Number Of Invoices . . Mask:####0 Notes: {ARX[12]} 22 Period3TotalRcvbls. . . . . . 13.2 NNN Period 3 Total Receivables Amou Mask:###,###,###.00- Notes: {ARX[13]} 23 Period3Over30Days . . . . . . 13.2 NNN Period 3 Over 30 Days Amount. . Mask:###,###,###.00- Notes: {ARX[14]} 24 Period3Over60Days . . . . . . 13.2 NNN Period 3 Over 60 Days Amount. . Mask:###,###,###.00- Notes: {ARX[15]} 25 Period4NoOfInvs . . . . . . . 7.0 NNN Period 4 Number Of Invoices . . Mask:####0 Notes: {ARX[16]} 26 Period4TotalRcvbls. . . . . . 13.2 NNN Period 4 Total Receivables Amou Mask:###,###,###.00- Notes: {ARX[17]} 27 Period4Over30Days . . . . . . 13.2 NNN Period 4 Over 30 Days Amount. . Mask:###,###,###.00- Notes: {ARX[18]} 28 Period4Over60Days . . . . . . 13.2 NNN Period 4 Over 60 Days Amount. . Mask:###,###,###.00- Notes: {ARX[19]} 29 Period5NoOfInvs . . . . . . . 7.0 NNN Period 5 Number Of Invoices . . Mask:####0 Notes: {ARX[20]} 30 Period5TotalRcvbls. . . . . . 13.2 NNN Period 5 Total Receivables Amou Mask:###,###,###.00- Notes: {ARX[21]} 31 Period5Over30Days . . . . . . 13.2 NNN Period 5 Over 30 Days Amount. . Mask:###,###,###.00- Notes: {ARX[22]} 32 Period5Over60Days . . . . . . 13.2 NNN Period 5 Over 60 Days Amount. . Mask:###,###,###.00- Notes: {ARX[23]} 33 Period6NoOfInvs . . . . . . . 7.0 NNN Period 6 Number Of Invoices . . Mask:####0 Notes: {ARX[24]} 34 Period6TotalRcvbls. . . . . . 13.2 NNN Period 6 Total Receivables Amou Mask:###,###,###.00- Notes: {ARX[25]} 35 Period6Over30Days . . . . . . 13.2 NNN Period 6 Over 30 Days Amount. . Mask:###,###,###.00- Notes: {ARX[26]} 36 Period6Over60Days . . . . . . 13.2 NNN Period 6 Over 60 Days Amount. . Mask:###,###,###.00- Notes: {ARX[27]} 37 TotalNoOfDaysOld. . . . . . . 13.2 NNN Total Number Of Days Old - Non Mask:###,###,###.00- Notes: {ARX[28]} 38 TotalOfOriginalInvAmounts . . 13.2 NNN Total Of Original Invoice Amoun Mask:###,###,###.00- Notes: {ARX[29)} 39 TotalNoOfInvs . . . . . . . . 13.2 NNN Total Number Of Invoices - Non Mask:###,###,###.00- Notes: {ARX[30]} 40 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 41 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 42 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL