EM_AGING_STATUS1=Invoices - Approved
2=Invoices - Not Approved
3=Credit Note
4=Disputed Invoices
5=Prepaid Not Applied
EM_AGING_PERIOD1=Over 30 Days
2=30 - 16 Days
3=15 - 1 Days
4=0 - 15 Days
5=16 - 30 Days
6=31- 60 Days
7=Over 60 Days
EM_MTRCRA_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_PERIOD |
Character(1) | VARCHAR2(1) NOT NULL |
Shows various pre-defined periods, or ranges of days, to be used in metrics charts.
1=Over 30 Days 2=30 - 16 Days 3=15 - 1 Days 4=0 - 15 Days 5=16 - 30 Days 6=31- 60 Days 7=Over 60 Days |
| 3 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |