| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
OMPB_BOOK_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book Definition ID
|
| 3 |
OMPB_BOOK_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book ID
|
| 4 |
OMPB_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
price book instance
|
| 5 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 6 |
EOEP_FORMULA_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pricing Formula ID
|
| 7 |
OMPB_ACTIVE_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the row in the extract table is avtive/valid data. This is not really the same as effective date/status related.
1=Active Row
2=Inactive Row
|
| 8 |
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
|
| 9 |
EOEP_NUM_VALUE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Numeric Value
|
| 10 |
EOEP_TEXT_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Text Value
|
| 11 |
EOEP_DATE_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Date Break
|
| 12 |
EOEP_FORM_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Formula Break
|
| 13 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
Prompt Table:
RT_INDEX_EI_VW
|
| 14 |
EOEP_SELSMLG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Small or Large
1=Smaller
2=Larger
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
PRODUCT_ID_PROMO |
Character(18) |
VARCHAR2(18) NOT NULL |
Promotional Product ID
Prompt Table:
PROD_ITEM
|
| 17 |
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
|
| 18 |
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
|
| 19 |
EOEP_FREEBIE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Pricing giveaway type.
LINE=Per Line
ORD=Per Order
|
| 20 |
EOEP_MAX_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Maximum Amount
|
| 21 |
EOEP_MIN_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Minimum Amount
|
| 22 |
EOEP_MRGBASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Margin Base
1=Cost
2=Alternate
|
| 23 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
%EDITTABLE2
|
| 24 |
UOM_PROMO |
Character(4) |
VARCHAR2(4) NOT NULL |
Unit of Measure (promo prod)
Prompt Table:
PROD_UOM_PRC_VW
|