| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
EO_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 3 |
RECEIPT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Receipt Number
|
| 4 |
RECEIPT_NBR_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Receipt Number Sequence
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 6 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
|
| 7 |
REF_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 8 |
REF_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference
|
| 9 |
PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 10 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 11 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 12 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 13 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 14 |
EO_FROM_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|