| # |
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_TRANS_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Code
|
| 4 |
ES_RPT_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Report Source
|
| 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_MODEL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Model
|
| 23 |
ES_KEY_ID |
Number(9,0) |
DECIMAL(9) NOT NULL |
Key ID Number of Country
|
| 24 |
ES_BOOK_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Book Type code
|
| 25 |
ES_TRANS_DATE |
Date(10) |
DATE |
Transaction Date
|
| 26 |
ES_ISSUE_DATE |
Date(10) |
DATE |
Issue Date
|
| 27 |
ES_TAX_RATE |
Number(6,0) |
INTEGER NOT NULL |
Tax Rate
|
| 28 |
ES_TAXABLE_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Taxable Amt
|
| 29 |
ES_TAX_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Tax Amt
|
| 30 |
ES_INV_TOTAL_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Invoice Total Amt
|
| 31 |
ES_COST_TAX_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Cost Tax Amt
|
| 32 |
ES_INVOICE_IDENT |
Character(40) |
VARCHAR2(40) NOT NULL |
Invoice Identification
|
| 33 |
ES_REGISTER_NUMBER |
Character(20) |
VARCHAR2(20) NOT NULL |
Register Number
|
| 34 |
ES_NUM_OF_INVOICES |
Number(20,0) |
DECIMAL(20) NOT NULL |
Number of Invoices
|
| 35 |
ES_NUM_OF_RECORDS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of Records
|
| 36 |
ES_ACCUM_INT_IDENT |
Character(80) |
VARCHAR2(80) NOT NULL |
Ident Interval Accumulation
|
| 37 |
ES_RECT_INV_IDENT |
Character(40) |
VARCHAR2(40) NOT NULL |
Rectified Inv Identification
|
| 38 |
ES_SURCHG_EQ_TYPE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Type of Surcharge Equivalence
|
| 39 |
ES_SURCHG_EQ_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Surcharge of Equivalence Amt
|
| 40 |
ES_PROP_LOC_CODE |
Number(1,0) |
SMALLINT NOT NULL |
Property Location Code
|
| 41 |
ES_LAND_REG_REF |
Character(25) |
VARCHAR2(25) NOT NULL |
Land Registry Reference
|
| 42 |
ES_CASH_AMT_RECVD |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Cash Amount Received
|
| 43 |
ES_YR_AMT_RCV_CASH |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Year Amount Received in Cash
|
| 44 |
ES_DEDUCTABLE_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Deductable Amt
|
| 45 |
ES_TRMSSN_PROP |
Character(20) |
VARCHAR2(20) NOT NULL |
Transmission Property
|
| 46 |
ES_DEF_ANL_PRORATE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Definitive Annual Prorate
|
| 47 |
ES_ANL_REG_DED_AMT |
Signed Number(33,3) |
DECIMAL(31,3) NOT NULL |
Annual Regulariztion Deduction
|
| 48 |
ES_DATE_USG_COM |
Date(10) |
DATE |
Date Usage Commences
|
| 49 |
ES_IDENT_OF_GOODS |
Character(7) |
VARCHAR2(7) NOT NULL |
Identification of Goods
|
| 50 |
ES_INTRA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Intra Community Trans
|
| 51 |
ES_KEY_OF_DECLARED |
Character(1) |
VARCHAR2(1) NOT NULL |
Key of Declared
|
| 52 |
ES_MEM_STATE_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Code of Member state
|
| 53 |
ES_TRANS_DEADLINE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Transaction Deadline
|
| 54 |
ES_DESC_GOODS |
Character(40) |
VARCHAR2(40) NOT NULL |
Description of Goods
|
| 55 |
ES_INTRA_PRTY_ADDR |
Character(40) |
VARCHAR2(40) NOT NULL |
Address Intracommunity Party
|
| 56 |
ES_INTRA_PRTY_CITY |
Character(40) |
VARCHAR2(40) NOT NULL |
City of the intracomm Party
|
| 57 |
ES_INTRA_PRTY_ZIP |
Character(10) |
VARCHAR2(10) NOT NULL |
Intracommunity zip code
|
| 58 |
ES_OTH_INV_DOC |
Character(40) |
VARCHAR2(40) NOT NULL |
Other Invoices Documentatiion
|
| 59 |
RUNDTTM |
DateTime(26) |
TIMESTAMP |
Run Date/Time
|