| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 2 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|
| 4 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
Prompt Table:
EOEP_RULE
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
EOEP_BU_VW
|
| 6 |
EOEP_ADJUST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back
AMT=Amount
OI=Off-Invoice
OVR=Price Override
PCT=Percent
|
| 7 |
DST_ID_DIS |
Character(10) |
VARCHAR2(10) NOT NULL |
Discount Dist Code
Prompt Table:
%EDITTABLE3
|
| 8 |
DST_ID_SUR |
Character(10) |
VARCHAR2(10) NOT NULL |
Surcharge Dist Code
Prompt Table:
%EDITTABLE4
|
| 9 |
DST_ID_REV |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Dist Code
Prompt Table:
%EDITTABLE5
|
| 10 |
DST_PCT_DIS |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Discount Dist Percentage
|
| 11 |
DST_PCT_SUR |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Surcharge Dist Percentage
|
| 12 |
DST_PCT_REV |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Revenue Dist Percentage
|
| 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 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 15 |
EIP_DTA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
EIP Dta status
0=New Transaction
1=Error found on the transaction
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold
|