| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
PAY_PRIORITY_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment Overall Priority
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
SORT_PAY1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Payment Field 1
1=Charge Tree Node
2=Term, Current Term First
3=Term, Payment Term First
4=Term, Oldest First
5=Academic Year, Current First
6=Academic Year
7=Item Charge Due Date
8=Oldest Invoice Date
Prompt Table:
XL_SORT_PAY_VW
|
| 8 |
SORT_PAY2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Payment Field 2
Prompt Table:
XL_SORT_PAY_VW
|
| 9 |
SORT_PAY3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Payment Field 3
Prompt Table:
XL_SORT_PAY_VW
|
| 10 |
SORT_PAY4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Payment Field 4
Prompt Table:
XL_SORT_PAY_VW
|
| 11 |
SORT_PAY5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Payment Field 5
Prompt Table:
XL_SORT_PAY_VW
|
| 12 |
ALLOCATION_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Method
1=By Oldest First
2=Equal Percentages
Default Value: 1
|
| 13 |
SF_PAY_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Proportionate % Tax
Y/N Table Edit
Default Value: N
|