EM_BUY_AGE_BAL(SQL Table) |
Index Back |
|---|---|
Buyer Aging BalanceThis is use to provide the Past Due Aging Balance portion of the EM_BUY_AGING_BAL page for the buyer's aging balance screen. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EM_STATUS | Character(25) | VARCHAR2(25) NOT NULL | Status |
| 2 | EM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | EBPP-Added 2000/10/01-Last Mod 2000/10/19 by Matthias Davet |
| 3 | EM_AGING_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Over 3 Months |
| 4 | EM_AGING_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 0 To 3 Months |
| 5 | EM_AGING_AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 0 To 15 Days |
| 6 | EM_AGING_AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 15 To 30 Days |
| 7 | EM_AGING_AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 30 To 60 Days |
| 8 | EM_AGING_AMT6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 60 To 90 Days |
| 9 | EM_AGING_AMT7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Over 90 Days |
| 10 | EM_AGING_AMT1_PB | Character(1) | VARCHAR2(1) NOT NULL | Over 60 Days |
| 11 | EM_AGING_AMT2_PB | Character(1) | VARCHAR2(1) NOT NULL | 60 to 31 Days |
| 12 | EM_AGING_AMT3_PB | Character(1) | VARCHAR2(1) NOT NULL | 30 to 1 Days |
| 13 | EM_AGING_AMT4_PB | Character(1) | VARCHAR2(1) NOT NULL | 0 To 15 Days |
| 14 | EM_AGING_AMT5_PB | Character(1) | VARCHAR2(1) NOT NULL | 31 To 60 Days |
| 15 | EM_AGING_AMT6_PB | Character(1) | VARCHAR2(1) NOT NULL | 61 To 90 Days |
| 16 | EM_AGING_AMT7_PB | Character(1) | VARCHAR2(1) NOT NULL | Over 91 Days |
| 17 | EM_AGING_TOT_PB | Character(1) | VARCHAR2(1) NOT NULL | Total |