LS_KEYREFUND_KEYDEDUCTION_ID1=Deduction
2=Interest
Default Value: 2
Default Value: RE_LS.CURRENCY_CD
RE_DEDUCTION(SQL Table) |
Index Back |
|---|---|
RE_DEDUCTIONDeductions for a refund |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | REFUND_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Refund_id |
| 3 | DEDUCTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Deduction Id |
| 4 | DEDUCTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Type
1=Deduction 2=Interest Default Value: 2 |
| 5 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 6 | DEDUCTION_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Deduction Amount |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: RE_LS.CURRENCY_CD |