OPRID01=Payment
02=Principal
Default Value: 01
Default Value: 100000
Default Value: 7
Default Value: 30
Default Value: 12
Y/N Table Edit
Default Value: N
SDK_AMORT_PREF(SQL Table) |
Index Back |
|---|---|
SDK Amortization Pagelet PrefSDK Amortization Pagelet Preference |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SDK_AMORT_CALC | Character(2) | VARCHAR2(2) NOT NULL |
SDK Amort Calculation
01=Payment 02=Principal Default Value: 01 |
| 3 | SDK_AMORT_PAYMENT | Number(12,2) | DECIMAL(11,2) NOT NULL |
Regular Payment
Default Value: 100000 |
| 4 | SDK_AMORT_PRINCIPL | Number(12,2) | DECIMAL(11,2) NOT NULL | Original Principal |
| 5 | SDK_AMORT_INTEREST | Number(8,4) | DECIMAL(7,4) NOT NULL |
Interest
Default Value: 7 |
| 6 | SDK_AMORT_YEARS | Number(8,4) | DECIMAL(7,4) NOT NULL |
Loan Length in Years
Default Value: 30 |
| 7 | SDK_AMORT_FREQUNCY | Number(2,0) | SMALLINT NOT NULL |
Frequency
Default Value: 12 |
| 8 | SDK_AMORT_SCHEDULE | Character(1) | VARCHAR2(1) NOT NULL |
SDK Amort Schedule
Y/N Table Edit Default Value: N |