| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID
|
| 2 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 3 |
EOEP_FORMULA_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pricing Formula ID
|
| 4 |
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
|
| 5 |
EOEP_NUM_VALUE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Numeric Value
|
| 6 |
EOEP_TEXT_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Text Value
|
| 7 |
EOEP_DATE_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Date Break
|
| 8 |
EOEP_FORM_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Formula Break
|
| 9 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
Prompt Table:
RT_INDEX_EI_VW
|
| 10 |
EOEP_SELSMLG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Small or Large
1=Smaller
2=Larger
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
PRODUCT_ID_PROMO |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID Promotion
Prompt Table:
PROD_ITEM
|
| 13 |
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.
Prompt Table:
%EDITTABLE
|
| 14 |
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
Default Value: OI
Prompt Table:
EOEP_FATVAL_VW
|
| 15 |
EOEP_FREEBIE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Pricing giveaway type.
LINE=Per Line
ORD=Per Order
|
| 16 |
EOEP_MAX_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Maximum Amount
|
| 17 |
EOEP_MIN_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Minimum Amount
|
| 18 |
EOEP_MRGBASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Margin Base
1=Cost
2=Alternate Cost
|
| 19 |
EOEP_RECURRENCE |
Number(2,0) |
SMALLINT NOT NULL |
Recurrence of Discount, etc
|
| 20 |
PW_FREQUENCY |
Character(2) |
VARCHAR2(2) NOT NULL |
Recurring Frequency
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually
|
| 21 |
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
Prompt Table:
%EDITTABLE2
|
| 22 |
UOM_PROMO |
Character(4) |
VARCHAR2(4) NOT NULL |
Unit of Measure (promo prod)
Prompt Table:
PROD_UOM_PRC_VW
|
| 23 |
DTTIME_ADDED |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 24 |
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.
|
| 25 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field determines the last user or operator that last changed this item.
|