| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
PP_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
PP_USAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Usage
1=First...
2=Any Overpayment
3=Overpayment Exceeds
4=Overpayment Is Less Than
5=Any Underpayment
6=Underpayment Exceeds
7=Underpayment Is Less Than
|
| 6 |
PP_MAIN_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Main use
A=Execute Algorithm Group
C=Apply To Control Customer
I=Generate An Item
M=Execute Custom Algorithm
N=Release The Payment
W=Generate A Worksheet
Default Value: N
|
| 7 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
Prompt Table:
PP_AE_ALGR_VW
|
| 8 |
PP_MAIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Main Control Account BU
Prompt Table:
BUS_UNIT_TBL_AR
|
| 9 |
PP_MAIN_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Main Control Account Custid
Prompt Table:
CUST_BU_PP_VW
|
| 10 |
PP_MAIN_SYSFUNC |
Character(5) |
VARCHAR2(5) NOT NULL |
Main system function Id
Prompt Table:
PP_SYSFUNC_VW
|
| 11 |
PP_MAIN_TOL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Tolerance Amount
|
| 12 |
PP_REVIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Review
Y/N Table Edit
Default Value: N
|
| 13 |
PP_TAG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Items
Y/N Table Edit
Default Value: Y
|
| 14 |
PP_MODULE |
Character(15) |
VARCHAR2(15) NOT NULL |
External Module Name
Prompt Table:
PP_MODULE_TBL
|
| 15 |
PP_MAIN_TOL_PER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Tolerance Percent
|
| 16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_OPT_AR.FORMAT_CURRENCY
|