EM_AGING_STATUS1=Invoices - Approved
2=Invoices - Not Approved
3=Credit Note
4=Disputed Invoices
5=Prepaid Not Applied
1=Over 60 Days
2=60 - 31 Days
3=30 - 1 Days
4=0 - 30 Days
5=31 - 60 Days
6=Above 60 Days
EM_MTRCPA_VW1S(SQL View) |
Index Back |
|---|---|
Receivables Aging - RegularReturns a summary of the number of regular vouchers. Used in the Seller Receivables Aging Balance metric. |
| SELECT ' ' , ' ' , 0 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EM_AGING_STATUS |
Character(2) | VARCHAR2(2) NOT NULL |
Used to display the status of vouchers within eSettlements. Used in metrics charts.
1=Invoices - Approved 2=Invoices - Not Approved 3=Credit Note 4=Disputed Invoices 5=Prepaid Not Applied |
| 2 | EM_AGING_PERIOD2 | Character(1) | VARCHAR2(1) NOT NULL |
Shows various pre-defined periods, or ranges of days, to be used in metrics charts.
1=Over 60 Days 2=60 - 31 Days 3=30 - 1 Days 4=0 - 30 Days 5=31 - 60 Days 6=Above 60 Days |
| 3 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |