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