| # |
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_BOOK_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Price book description
|
| 5 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
|
| 6 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
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.
Prompt Table:
RT_TYPE_TBL
|
| 9 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 10 |
OMPB_NOVALMCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Missing value meaning flag
M=Assume Matching
N=Assume Not Matching
Default Value: M
|
| 11 |
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
Default Value: PL
|
| 12 |
OMPB_COMMON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show the list price in common date and quantity ranges.
N=No
Y=Yes
Default Value: N
|
| 13 |
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
Default Value: =
|
| 14 |
OMPB_PRICELST_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Price list id
Prompt Table:
%EDITTABLE12
|
| 15 |
OMPB_PRICELST_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Price list id
Prompt Table:
%EDITTABLE12
|
| 16 |
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: =
|
| 17 |
OMPB_INBU_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Inventory business unit
Prompt Table:
SP_BUIN_NONVW
|
| 18 |
OMPB_INBU_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Inventory business unit
Prompt Table:
SP_BUIN_NONVW
|
| 19 |
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: =
|
| 20 |
OMPB_SCON_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Buying agreement IDs
Prompt Table:
%EDITTABLE14
|
| 21 |
OMPB_SCON_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Buying agreement IDs
Prompt Table:
%EDITTABLE14
|
| 22 |
OMPB_PRODUCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product selection by
C=Product Catalog
G=Product Group
P=Product
Default Value: P
|
| 23 |
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: =
|
| 24 |
OMPB_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 25 |
OMPB_PRODUCT_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Product/product group
Prompt Table:
%EDITTABLE13
|
| 26 |
OMPB_PRODUCT_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Product/product group
Prompt Table:
%EDITTABLE13
|
| 27 |
OMPB_INACTPRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include inactive products
N=No
Y=Yes
Default Value: N
|
| 28 |
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: N
|
| 29 |
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: ALL
|
| 30 |
EFFDT_CATALOG |
Date(10) |
DATE |
Catalog Effective Date
|
| 31 |
OMPB_CATALOG_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Product catalog value
Prompt Table:
%EDITTABLE10
|
| 32 |
OMPB_CATALOG_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Product catalog value
Prompt Table:
%EDITTABLE10
|
| 33 |
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
|
| 34 |
DATETIME_ADDED |
DateTime(26) |
TIMESTAMP |
DateTime Added
|
| 35 |
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.
|
| 36 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|