# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
3 |
CF_ATTRIB_VALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
ChartField Attribute Value
|
4 |
SPS_TAS |
Character(27) |
VARCHAR2(27) NOT NULL |
Sender Treasury Account Symbol
|
5 |
SPS_BETC |
Character(8) |
VARCHAR2(8) NOT NULL |
Sender Business Event Type
|
6 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
7 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
8 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
|
9 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
10 |
LINE_VCHR_PCT |
Signed Number(29,20) |
DECIMAL(27,20) NOT NULL |
Line Voucher Ratio
|
11 |
LATE_CHRG_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Late Charge Amount Base
|