| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EONE_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Enterprise One Company
|
| 2 |
EONE_DOC_ID |
Number(8,0) |
INTEGER NOT NULL |
Enterprise One Document ID
|
| 3 |
EONE_DOC_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Enterprise One Doc Type
|
| 4 |
EONE_DOC_PAY_ITEM |
Character(3) |
VARCHAR2(3) NOT NULL |
Enterprise One Doc Pay Item
|
| 5 |
EONE_PAY_ITEM_EXT |
Number(2,0) |
SMALLINT NOT NULL |
Enterprise One Pay Item Ext
|
| 6 |
EONE_BU |
Character(12) |
VARCHAR2(12) NOT NULL |
Stores the Enterprise One Business Unit field.
|
| 7 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 9 |
BUSINESS_DATE |
Date(10) |
DATE |
Represents a date upon which business is conducted within a given company in a given country.
|
| 10 |
REFERENCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field to show when a variable is a reference variable.
|