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