| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 9999
|
| 5 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 6 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
Default Value: N
|
| 7 |
ABORT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Process Flag
|
| 8 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 9 |
MSGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
|
| 10 |
PRICING_DATA_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Pricing Data to Load
A=Arbitration Plan
E=All
L=Price List
R=Price Rule
|
| 11 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 12 |
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
|
| 13 |
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
|
| 14 |
EOEP_APP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table:
EOEP_APPCD_VW
|
| 15 |
EOEP_ARB_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Arbitration Plan
|
| 16 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 17 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
Prompt Table:
EOEP_RULE
|
| 18 |
EOEP_COND_SEQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
Price Condition Sequence
|
| 19 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 20 |
UOM_PROMO |
Character(4) |
VARCHAR2(4) NOT NULL |
Unit of Measure (promo prod)
|
| 21 |
RECURRING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicated if a list price is a regular price or a reccurring price. THe recurring price will also require a frequency.
N=No
Y=Yes
|
| 22 |
PW_FREQUENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Recurring Frequency
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually
|
| 23 |
EOEP_CONDCONJ_FK |
Number(10,0) |
DECIMAL(10) NOT NULL |
Condition Conjunction Foreign Key
|
| 24 |
EOEP_CONDCONJ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Condition Conjunction ID
|
| 25 |
EOEP_FORMULA_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pricing Formula ID
|
| 26 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
EOEP_BU_VW
|
| 27 |
DST_ID_DIS |
Character(10) |
VARCHAR2(10) NOT NULL |
Discount Dist Code
|
| 28 |
DST_ID_REV |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Dist Code
|
| 29 |
DST_ID_SUR |
Character(10) |
VARCHAR2(10) NOT NULL |
Surcharge Dist Code
|
| 30 |
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
|
| 31 |
PRICE_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price List ID
|
| 32 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 33 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PRICSET_PROD_VW
|
| 34 |
PRODUCT_ID_PROMO |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID Promotion
|
| 35 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 36 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 37 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 38 |
FIELDNAME0 |
Character(18) |
VARCHAR2(18) NOT NULL |
Name of Field
|
| 39 |
EOEP_CHAR |
Character(254) |
VARCHAR2(254) NOT NULL |
Long field
|
| 40 |
EOEP_LOGICAL_OPER |
Character(3) |
VARCHAR2(3) NOT NULL |
Logical Operator
AND=And
OR=Or
|
| 41 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 42 |
EOEP_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of pricing data
1=Enterprise Pricer
2=Promotion Management
|
| 43 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 44 |
PRC_BREAK_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Break Date Type
A=Requested Arrival Date
O=Order Date
S=Schedule Ship Date
|
| 45 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 46 |
EOEP_ARB_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Arbitration Type
1=Action Type
2=Price Type
3=Decision
4=Pricing Key
5=Price Rule
6=Cascading/Summed
7=Date Range
8=Price Rule Source
9=Price Rule Type
F=[Folder]
|
| 47 |
EOEP_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Operator
<=Less than
<==Less than or equal to
<>=Not equal to
==Equal to
>=Greater than
>==Greater than or equal to
IN=Includes
NI=Does not include
|
| 48 |
EOEP_FREEBIE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Pricing giveaway type.
LINE=Per Line
ORD=Per Order
|
| 49 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=Free Period Promotion
11=Product Add
12=Price Base
13=Rollup Only Rule
14=Min/Max Margin
15=Recurring Discount/Surcharge
2=Price Override
3=Giveaway / Product Add
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Related Busines Objects
9=Price List Only Condition
99=Standard Discount
|
| 50 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
|
| 51 |
EOEP_ORD_DT_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Arbitration Date
1=Defined on Arbitration Plan
2=All Order Dates
|
| 52 |
EOEP_PTD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Period To Date flag
N=No
R=By Rule
Y=By Customer
|
| 53 |
EOEP_RULE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Status
D=Deployed
I=Inactive
P=Pending
R=Ready To Test
|
| 54 |
EOEP_STOP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Stop Processing
N=No
Y=Yes
|
| 55 |
EOEP_USE_GRC_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Grace Days
N=No
Y=Yes
|
| 56 |
PRICE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
|
| 57 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 58 |
CURRENT_DTTM |
DateTime(26) |
TIMESTAMP |
08/27/01 EGS (CN#PL900-1.0): Added
|
| 59 |
PROCESS_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is used to represent the process option
B=Flat File/Purge
C=Flat File
P=Purge
|
| 60 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 61 |
WHERE_CLAUSE_AE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause AE
|
| 62 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist
|
| 63 |
FIELDNAME_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Line Descr
|
| 64 |
EIP_PROGRAM |
Character(10) |
VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
|
| 65 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 66 |
SEQNUM_NEXT |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 67 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 68 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 69 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 70 |
EDITVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Edit Value
|
| 71 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
|
| 72 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 73 |
DEFAULT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is a flag field to indicate default or not.
N=No
Y=Yes
|
| 74 |
START_DT |
Date(10) |
DATE |
Start date field to store start date value.
|
| 75 |
END_DATE |
Date(10) |
DATE |
End date field to store an end date.
|
| 76 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 77 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 78 |
COUNT_LINES |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Lines
|
| 79 |
MINIMUM |
Number(3,0) |
SMALLINT NOT NULL |
Field used for storing Maximal quantity in integer format
|
| 80 |
MAXIMUM |
Number(3,0) |
SMALLINT NOT NULL |
Field used for storing Maximal quantity in integer format
|
| 81 |
MAX_SEQ_HOLD |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Seq Hold Number
|
| 82 |
TEMPORARY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary
|
| 83 |
UPDATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Prior Operations
N=No
Y=Yes
|
| 84 |
KEY_FIELD_NAME_01 |
Character(18) |
VARCHAR2(18) NOT NULL |
Key Field Name 01 storing the table column name for the first key
|
| 85 |
FULL_SYNC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Sync Indicator.
|
| 86 |
FULL_SYNC_ERR |
Character(1) |
VARCHAR2(1) NOT NULL |
Full Sync Error Oprtions.
L=Valid Rows Will Be Loaded
R=No Data Will Be Loaded
|
| 87 |
VALIDATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Validate Flag
|
| 88 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 89 |
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.
|
| 90 |
LAST_DTTM_UPDATE |
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.
|
| 91 |
COUNT_PAIRS |
Number(2,0) |
SMALLINT NOT NULL |
Count of Rate Pairs
|
| 92 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 93 |
TEXT80 |
Character(80) |
VARCHAR2(80) NOT NULL |
Generic 80 Char text field. Not much more to say about that.
|
| 94 |
REC_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Record Name
|
| 95 |
REC_PARENT |
Character(18) |
VARCHAR2(18) NOT NULL |
Field used in Record EO_ERD_REL for ERD_REL.sqr, an SQR Process to extract Table Relationships in PeopleSoft. This Field is used to store "Parent Record" Name of a given record in PeopleSoft.
|
| 96 |
REC_CHILD |
Character(18) |
VARCHAR2(18) NOT NULL |
Field used in Record EO_ERD_REL for ERD_REL.sqr, an SQR Process to extract Table Relationships in PeopleSoft. This Field is used to store "Child Record" Name of a given parent/child records pair in PeopleSoft.
|
| 97 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 98 |
REPLACE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Replace flag.
|
| 99 |
FIELDNUM |
Number(4,0) |
SMALLINT NOT NULL |
Field Number
|
| 100 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 1 Name
|
| 101 |
RECNAME_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 2 Name
|
| 102 |
RECNAME_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Used to describe Level 3 record names.
|
| 103 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
|
| 104 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
|
| 105 |
TAO_TBL_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Base TAO Table Name
|
| 106 |
TAO_TBL_NAME2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Base TAO Table Name
|
| 107 |
TAO_TBL_NAME3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Base TAO Table Name
|
| 108 |
SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
|
| 109 |
SQLID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 110 |
SQLID3 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 111 |
SQLID4 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL OBJECT WORK FIELD
|
| 112 |
EOEP_ROUND_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rouding Flag
0=None
1=Net Price
2=Adjustment
3=Both
|
| 113 |
EOEP_ONETIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
One-Time Flag
1=No
2=Per Customer
3=Per Rule
|
| 114 |
EOEP_ROLLUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rollup By Flag
1=Transaction
2=Line
3=Schedule
4=Rollup Rule
|
| 115 |
EOEP_PRCBASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pricing Base Flag
1=List Price
2=Cost
3=Buying Agreement
4=Alternate Cost
|
| 116 |
EOEP_TIERED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tiered Pricing Flag
N=No
Y=Yes
|
| 117 |
EOEP_MEPR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mutually Exclusive Pricing Rule
N=No
Y=Yes
|
| 118 |
EOEP_RULEXCL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Exclude
1=None
2=KVI Products
3=NDP Products
4=KVI & NDP Products
|
| 119 |
EOEP_LISTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use list price.
N=No
Y=Yes
|
| 120 |
EOEP_BAUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use with buying agreement.
N=No
Y=Yes
|
| 121 |
EOEP_COSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use cost.
N=No
Y=Yes
|
| 122 |
EOEP_ALTCSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to apply to alternate cost base.
N=No
Y=Yes
|
| 123 |
EOEP_UOMROLLUP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether the rollup is by UOM
N=No
Y=Yes
|
| 124 |
EOEP_ADJST_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjustment Flag
01=Amount
02=Percentage
03=Price
04=External Class
05=Math Expression
06=Quantity
07=BOGO Factor
08=Quantity with Price
09=BOGO with Price
10=Quantity Expression
11=Amount And Math Expression
12=Percentage And Math Expression
13=Price And Math Expression
|
| 125 |
EOEP_SELSMLG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Small or Large
1=Smaller
2=Larger
|
| 126 |
EOEP_MRGBASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Margin Base
1=Cost
2=Alternate Cost
|
| 127 |
EOEP_ROLLUP_RULE |
Character(30) |
VARCHAR2(30) NOT NULL |
Rollup Rule ID
|
| 128 |
EOEP_ROUND_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rounding ID
|
| 129 |
EOEP_DATE_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Date Name
|
| 130 |
BREAK_QTY_LOW |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Low Quantity/Amount
|
| 131 |
EOEP_MAXQTY_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Max Quantity UOM
|
| 132 |
EOEP_MAX_QUANTITY |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Max Quantity
|
| 133 |
EOEP_NUM_VALUE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Numeric Value
|
| 134 |
EOEP_TEXT_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Text Value
|
| 135 |
EOEP_MAX_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Maximum Amount
|
| 136 |
EOEP_MIN_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Minimum Amount
|
| 137 |
EOEP_DATE_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Date Break
|
| 138 |
EOEP_FORM_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Formula Break
|
| 139 |
DATE_BEGIN |
Date(10) |
DATE |
Start Date
|
| 140 |
DATE_END |
Date(10) |
DATE |
End Date
|
| 141 |
EOEP_RANGE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Range ID
|