OMPB_BOOK_VW (SQL View)	Index Back
Customer Price Book Instance Customer Price Book Instance

OMPB_BOOK_VW

(SQL View)

Customer Price Book Instance

SELECT I.BUSINESS_UNIT , I.OMPB_BOOK_DEFN_ID , I.OMPB_BOOK_ID , I.OMPB_INSTANCE , %subrec(OMPB_DEFN_SBR, D) , %subrec(OMPB_BOOK_SBR, B) , %subrec(OMPB_INST_SBR, I) FROM PS_OMPB_BOOK_DEFN D , PS_OMPB_BOOK B , PS_OMPB_INSTANCE I WHERE %Join(COMMON_KEYS, OMPB_BOOK_DEFN D, OMPB_BOOK B) AND %Join(COMMON_KEYS, OMPB_BOOK B, OMPB_INSTANCE I)

Related Language Record: OMPB_BOOK_LVW

Parent Record Of OMPB_COND_VW OMPB_LSTPRC_VW OMPB_PRCADJ_VW

# 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 OMPB_DEFN_DESCR Character(100) VARCHAR2(100) NOT NULL Defintion description

6 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

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

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

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

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

11 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).
Prompt Table: %EDITTABLE2

12 OMPB_BOOK_DESCR Character(100) VARCHAR2(100) NOT NULL Price book description

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

14 RATE_DATE Date(10) DATE Exchange Rate Date

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

16 START_DT Date(10) DATE NOT NULL Start Date

17 END_DATE Date(10) DATE NOT NULL End Date

18 OMPB_NOVALMCH_FLG Character(1) VARCHAR2(1) NOT NULL Missing value meaning flag
M=Assume Matching
N=Assume Not Matching

19 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

20 OMPB_COMMON_FLG Character(1) VARCHAR2(1) NOT NULL Show the list price in common date and quantity ranges.
N=No
Y=Yes

21 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

22 OMPB_PRICELST_VAL Character(128) VARCHAR2(128) NOT NULL Price list id
Prompt Table: %EDITTABLE12

23 OMPB_PRICELST_TO Character(128) VARCHAR2(128) NOT NULL Price list id
Prompt Table: %EDITTABLE12

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

25 OMPB_INBU_VAL Character(128) VARCHAR2(128) NOT NULL Inventory business unit
Prompt Table: SP_BUIN_NONVW

26 OMPB_INBU_TO Character(128) VARCHAR2(128) NOT NULL Inventory business unit
Prompt Table: SP_BUIN_NONVW

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

28 OMPB_SCON_VAL Character(128) VARCHAR2(128) NOT NULL Buying agreement IDs
Prompt Table: %EDITTABLE14

29 OMPB_SCON_TO Character(128) VARCHAR2(128) NOT NULL Buying agreement IDs
Prompt Table: %EDITTABLE14

30 OMPB_PRODUCT_FLG Character(1) VARCHAR2(1) NOT NULL Product selection by
C=Product Catalog
G=Product Group
P=Product
Default Value: P

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

32 OMPB_EFFDT Date(10) DATE Effective Date

33 OMPB_PRODUCT_VAL Character(128) VARCHAR2(128) NOT NULL Product/product group
Prompt Table: %EDITTABLE13

34 OMPB_PRODUCT_TO Character(128) VARCHAR2(128) NOT NULL Product/product group
Prompt Table: %EDITTABLE13

35 OMPB_INACTPRD_FLG Character(1) VARCHAR2(1) NOT NULL Include inactive products
N=No
Y=Yes

36 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

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

38 EFFDT_CATALOG Date(10) DATE Catalog Effective Date

39 OMPB_CATALOG_VAL Character(128) VARCHAR2(128) NOT NULL Product catalog value
Prompt Table: %EDITTABLE10

40 OMPB_CATALOG_TO Character(128) VARCHAR2(128) NOT NULL Product catalog value
Prompt Table: %EDITTABLE10

41 OMPB_DELTA_BK_FLG Character(1) VARCHAR2(1) NOT NULL Price delta book flag
N=No
Y=Yes

42 OMPB_SRC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Source instance

43 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

44 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time

#	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	OMPB_DEFN_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Defintion description
6	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
7	OMPB_BOOK_FOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Customer Price Book For Flag C=Customer G=Customer Group Default Value: C
8	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: =
9	OMPB_BOOK_FOR_VAL	Character(128)	VARCHAR2(128) NOT NULL	Customer/Customer Group Prompt Table: %EDITTABLE
10	OMPB_BOOK_FOR_TO	Character(128)	VARCHAR2(128) NOT NULL	Customer/Customer Group Prompt Table: %EDITTABLE
11	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN). Prompt Table: %EDITTABLE2
12	OMPB_BOOK_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Price book description
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
14	RATE_DATE	Date(10)	DATE	Exchange Rate Date
15	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.
16	START_DT	Date(10)	DATE NOT NULL	Start Date
17	END_DATE	Date(10)	DATE NOT NULL	End Date
18	OMPB_NOVALMCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Missing value meaning flag M=Assume Matching N=Assume Not Matching
19	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
20	OMPB_COMMON_FLG	Character(1)	VARCHAR2(1) NOT NULL	Show the list price in common date and quantity ranges. N=No Y=Yes
21	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
22	OMPB_PRICELST_VAL	Character(128)	VARCHAR2(128) NOT NULL	Price list id Prompt Table: %EDITTABLE12
23	OMPB_PRICELST_TO	Character(128)	VARCHAR2(128) NOT NULL	Price list id Prompt Table: %EDITTABLE12
24	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: =
25	OMPB_INBU_VAL	Character(128)	VARCHAR2(128) NOT NULL	Inventory business unit Prompt Table: SP_BUIN_NONVW
26	OMPB_INBU_TO	Character(128)	VARCHAR2(128) NOT NULL	Inventory business unit Prompt Table: SP_BUIN_NONVW
27	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: =
28	OMPB_SCON_VAL	Character(128)	VARCHAR2(128) NOT NULL	Buying agreement IDs Prompt Table: %EDITTABLE14
29	OMPB_SCON_TO	Character(128)	VARCHAR2(128) NOT NULL	Buying agreement IDs Prompt Table: %EDITTABLE14
30	OMPB_PRODUCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Product selection by C=Product Catalog G=Product Group P=Product Default Value: P
31	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: =
32	OMPB_EFFDT	Date(10)	DATE	Effective Date
33	OMPB_PRODUCT_VAL	Character(128)	VARCHAR2(128) NOT NULL	Product/product group Prompt Table: %EDITTABLE13
34	OMPB_PRODUCT_TO	Character(128)	VARCHAR2(128) NOT NULL	Product/product group Prompt Table: %EDITTABLE13
35	OMPB_INACTPRD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include inactive products N=No Y=Yes
36	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
37	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: =
38	EFFDT_CATALOG	Date(10)	DATE	Catalog Effective Date
39	OMPB_CATALOG_VAL	Character(128)	VARCHAR2(128) NOT NULL	Product catalog value Prompt Table: %EDITTABLE10
40	OMPB_CATALOG_TO	Character(128)	VARCHAR2(128) NOT NULL	Product catalog value Prompt Table: %EDITTABLE10
41	OMPB_DELTA_BK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price delta book flag N=No Y=Yes
42	OMPB_SRC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Source instance
43	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
44	RUN_DTTM	DateTime(26)	TIMESTAMP	Run Date and Time