AP_AGING_STATUSA=Approved Vouchers
D=Drafts Issued
H=Payments On Hold
N=Negative Vouchers
P=Pending Approval
PP=Prepaid Vouchers
AP_AGING_PERIOD0=0 to 30 Days
1=1 to 30 Days
2=31 to 60 Days
3=Over 60 Days
4=61
MTRC_SDUE_VW1(SQL View) |
Index Back |
|---|---|
Sched Aging by Status Summary |
| SELECT ' ' , ' ' , 0 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AP_AGING_STATUS |
Character(2) | VARCHAR2(2) NOT NULL |
Status
A=Approved Vouchers D=Drafts Issued H=Payments On Hold N=Negative Vouchers P=Pending Approval PP=Prepaid Vouchers |
| 2 | AP_AGING_PERIOD |
Character(1) | VARCHAR2(1) NOT NULL |
Aging Period
0=0 to 30 Days 1=1 to 30 Days 2=31 to 60 Days 3=Over 60 Days 4=61 |
| 3 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |