| # |
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).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_OM_NONVW
|
| 6 |
OMPB_BOOK_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book Definition ID
|
| 7 |
OMPB_BOOK_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book ID
|
| 8 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 9 |
OMPB_DEFN_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Defintion description
|
| 10 |
OMPB_BOOK_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Book Type
A=Adjustments Only
B=List Price and Adjustments
L=List Price Only
Default Value: L
|
| 11 |
OMPB_BOOK_FOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Price Book For Flag
C=Customer
G=Customer Group
Default Value: C
|
| 12 |
OMPB_BOOK_FOR_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
IN=in
Default Value: =
|
| 13 |
OMPB_BOOK_FOR_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Customer/Customer Group
Prompt Table:
%EDITTABLE
|
| 14 |
OMPB_BOOK_FOR_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Customer/Customer Group
Prompt Table:
%EDITTABLE
|
| 15 |
TMPLDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table:
%EDITTABLE2
|
| 16 |
OMPB_BOOK_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Price book description
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 18 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 19 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 20 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
|
| 21 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
|
| 22 |
OMPB_NOVALMCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Missing value meaning flag
M=Assume Matching
N=Assume Not Matching
|
| 23 |
OMPB_LISTPRC_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
List price option
AR=Price List by All Conditions
BA=Buying Agreement
BC=Price List by Rule Conditions
BO=Price List by Related Bus Objs
PE=Sales Order Pricing Logic
PL=Specified Price List
PP=Product List Price
|
| 24 |
OMPB_COMMON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show the list price in common date and quantity ranges.
N=No
Y=Yes
|
| 25 |
OMPB_PRICELST_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
IN=in
|
| 26 |
OMPB_PRICELST_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Price list id
Prompt Table:
%EDITTABLE12
|
| 27 |
OMPB_PRICELST_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Price list id
Prompt Table:
%EDITTABLE12
|
| 28 |
OMPB_INBU_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
IN=in
Default Value: =
|
| 29 |
OMPB_INBU_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Inventory business unit
Prompt Table:
SP_BUIN_NONVW
|
| 30 |
OMPB_INBU_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Inventory business unit
Prompt Table:
SP_BUIN_NONVW
|
| 31 |
OMPB_SCON_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
IN=in
Default Value: =
|
| 32 |
OMPB_SCON_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Buying agreement IDs
Prompt Table:
%EDITTABLE14
|
| 33 |
OMPB_SCON_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Buying agreement IDs
Prompt Table:
%EDITTABLE14
|
| 34 |
OMPB_PRODUCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product selection by
C=Product Catalog
G=Product Group
P=Product
Default Value: P
|
| 35 |
OMPB_PRODUCT_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
BEG=begins with
BET=between
CON=contains
IN=in
Default Value: =
|
| 36 |
OMPB_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 37 |
OMPB_PRODUCT_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Product/product group
Prompt Table:
%EDITTABLE13
|
| 38 |
OMPB_PRODUCT_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Product/product group
Prompt Table:
%EDITTABLE13
|
| 39 |
OMPB_INACTPRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include inactive products
N=No
Y=Yes
|
| 40 |
OMPB_CATALOG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product catalog option
A=All Product Catalogs
N=No Product Catalogs
S=Selected Product Catalog
Default Value: A
|
| 41 |
OMPB_CATALOG_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
ALL=all
BEG=begins with
BET=between
CON=contains
IN=in
Default Value: =
|
| 42 |
EFFDT_CATALOG |
Date(10) |
DATE |
Catalog Effective Date
|
| 43 |
OMPB_CATALOG_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Product catalog value
Prompt Table:
%EDITTABLE10
|
| 44 |
OMPB_CATALOG_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Product catalog value
Prompt Table:
%EDITTABLE10
|
| 45 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
OMPB_CNDFLD_DVW
|
| 46 |
OMPB_COND_OPR |
Character(4) |
VARCHAR2(4) NOT NULL |
Criteria used to build query/sql where conditions.
<=<
<==<=
<>=not =
===
>=>
>==>=
ALL=all
BEG=begins with
BET=between
CON=contains
IN=in
|
| 47 |
OMPB_COND_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Conditon value
Prompt Table:
%EDITTABLE20
|
| 48 |
OMPB_COND_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Conditon value
Prompt Table:
%EDITTABLE20
|
| 49 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 50 |
DATETIME_ADDED |
DateTime(26) |
TIMESTAMP |
DateTime Added
|
| 51 |
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.
|
| 52 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 53 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 54 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 55 |
DATE1 |
Date(10) |
DATE |
Date
|
| 56 |
DATE2 |
Date(10) |
DATE |
Date
|
| 57 |
DELETE_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
DELETE_CONTROL
|
| 58 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=CRM Free Period Promotion
11=CRM Product Add
12=Pricing Base
13=Rollup Only Rule
14=Min/Max Margin
2=Price Override
3=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
|
| 59 |
OM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OM Work Flag
|
| 60 |
OMPB_DELTA_BK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price delta book flag
N=No
Y=Yes
|
| 61 |
OMPB_GENPUB_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate and publish price book
|
| 62 |
OMPB_LISTPRC_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
List price source
B=Buying Agreement Price
L=Price List
P=Product List Price
|
| 63 |
OMPB_PROC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process option
L=Later
N=Now
Default Value: L
|
| 64 |
OMPB_SRC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Source instance
|
| 65 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 66 |
PRICE_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price List ID
|
| 67 |
QTY_MAX |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Maximum Quantity
|
| 68 |
QTY_MAX_OLD |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Maximum Quantity
|
| 69 |
QTY_MIN |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Minimum Quantity
|
| 70 |
QTY_MIN_OLD |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Minimum Quantity
|
| 71 |
QTY_PRECISION |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal
W=Whole Nbr
|
| 72 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 73 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 74 |
SETID_CATALOG |
Character(5) |
VARCHAR2(5) NOT NULL |
Catalog SetID
|
| 75 |
SETID_CONTRACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Contract Setid
|
| 76 |
SETID_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 77 |
SETID_CUST_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer Group SetID
|
| 78 |
SETID_PRICE_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Price Rule Setid
|
| 79 |
SETID_PROD_ITEM |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 80 |
SETID_PROD_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
|
| 81 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 82 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 83 |
SQL_STATEMENT |
Long Character |
CLOB |
SQL Statement
|
| 84 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|