CA_PPD_UPD_TA1
(SQL Table) |
Index Back |
|---|
CA_PPD_UPD Temp Table
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 3 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 4 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 5 |
COMMITTED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Committed Assets
|
| 6 |
REMAINING_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Remaining Amount
|