| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ES_RECORD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type
|
| 3 |
ES_RPT_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Report Source
|
| 4 |
ES_TRANS_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Code
|
| 5 |
ES_GL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 6 |
ES_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
ES_CUST_VNDR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer Vendor SET ID
|
| 8 |
ES_CUST_VNDR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer/Vendor ID
|
| 9 |
ES_CUST_VNDR_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Customer/Vendor Name
|
| 10 |
ES_CUS_VND_VAT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Cust/Vnd VAT Registration ID
|
| 11 |
ES_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year
|
| 12 |
ES_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Period
|
| 13 |
ES_PERIOD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
From Period
|
| 14 |
ES_PERIOD_TO |
Number(3,0) |
SMALLINT NOT NULL |
To Period
|
| 15 |
ES_VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Entity
|
| 16 |
ES_VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Registration ID
|
| 17 |
ES_FORM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Form Type
|
| 18 |
ES_COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 19 |
ES_CURRENCY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Currency Code
|
| 20 |
ES_SET_OF_BOOK_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Set of Book ID
|
| 21 |
ES_ORG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Origin ID
|
| 22 |
ES_TRANS_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Amount of Transactions
|
| 23 |
ES_TRANS_AMT_Q1 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Transaction Amt for Q1
|
| 24 |
ES_TRANS_AMT_Q2 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Transaction Amt for Q2
|
| 25 |
ES_TRANS_AMT_Q3 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Transaction Amt for Q3
|
| 26 |
ES_TRANS_AMT_Q4 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Transaction Amt for Q4
|
| 27 |
ES_CASH_AMT_RECVD |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Cash Amount Received
|
| 28 |
ES_YR_AMT_RCV_CASH |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Year Amount Received in Cash
|
| 29 |
ES_TRN_PROP_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Amount Recvd Transmission prop
|
| 30 |
ES_TRN_PROP_AMT_Q1 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
VAT Amt Recvd Trans prop Q1
|
| 31 |
ES_TRN_PROP_AMT_Q2 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
VATVAT Amt Recvd Trans prop Q2
|
| 32 |
ES_TRN_PROP_AMT_Q3 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
VAT Amt Recvd Trans prop Q3
|
| 33 |
ES_TRN_PROP_AMT_Q4 |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
VAT Amt Recvd Trans prop Q4
|
| 34 |
ES_PROP_LOC_CODE |
Number(1,0) |
SMALLINT NOT NULL |
Property Location Code
|
| 35 |
ES_LAND_REG_REF |
Character(25) |
VARCHAR2(25) NOT NULL |
Land Registry Reference
|
| 36 |
ES_STREET_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Street Type
|
| 37 |
ES_STREET_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Street Name
|
| 38 |
ES_NUMBER_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Number Type
|
| 39 |
ES_HOUSE_NUM |
Character(5) |
VARCHAR2(5) NOT NULL |
House Number
|
| 40 |
ES_BLOCK |
Character(3) |
VARCHAR2(3) NOT NULL |
Block
|
| 41 |
ES_PORTAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Portal
|
| 42 |
ES_STAIR_CASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Stair Case
|
| 43 |
ES_FLOOR_APARTMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Floor or Apartment
|
| 44 |
ES_DOOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Door
|
| 45 |
ES_COMPLEMENT |
Character(40) |
VARCHAR2(40) NOT NULL |
Complement
|
| 46 |
ES_LOCALITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Locality
|
| 47 |
ES_MUNCIPLTY_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Municipality City
|
| 48 |
ES_MUNCIPLTY_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Municipality Code
|
| 49 |
ES_PROVINCE_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Province
|
| 50 |
ES_POSTAL_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Postal Code
|
| 51 |
RUNDTTM |
DateTime(26) |
TIMESTAMP |
Run Date/Time
|