OMPB_BOOK_DEFN (SQL Table)	Index Back
Customer Price Book Header Customer Price Book Header

OMPB_BOOK_DEFN

(SQL Table)

Customer Price Book Header

Related Language Record: OMPB_BOOK_DEF_L

Parent Record Of OMPB_BOOK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT
Prompt Table: SP_BU_OM_NONVW

2 OMPB_BOOK_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book Definition ID

3 OMPB_DEFN_DESCR Character(100) VARCHAR2(100) NOT NULL Defintion description

4 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

5 OMPB_BOOK_FOR_FLG Character(1) VARCHAR2(1) NOT NULL Customer Price Book For Flag
C=Customer
G=Customer Group
Default Value: C

6 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: =

7 OMPB_BOOK_FOR_VAL Character(128) VARCHAR2(128) NOT NULL Customer/Customer Group
Prompt Table: %EDITTABLE

8 OMPB_BOOK_FOR_TO Character(128) VARCHAR2(128) NOT NULL Customer/Customer Group
Prompt Table: %EDITTABLE

9 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
Prompt Table: OM_XPRPTTMPL_VW

10 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

11 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

12 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.

13 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW
2	OMPB_BOOK_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Customer Price Book Definition ID
3	OMPB_DEFN_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Defintion description
4	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
5	OMPB_BOOK_FOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Customer Price Book For Flag C=Customer G=Customer Group Default Value: C
6	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: =
7	OMPB_BOOK_FOR_VAL	Character(128)	VARCHAR2(128) NOT NULL	Customer/Customer Group Prompt Table: %EDITTABLE
8	OMPB_BOOK_FOR_TO	Character(128)	VARCHAR2(128) NOT NULL	Customer/Customer Group Prompt Table: %EDITTABLE
9	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN). Prompt Table: OM_XPRPTTMPL_VW
10	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
11	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
12	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.
13	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID