|
SELECT X.EIP_PROGRAM , X.SETID , X.CUST_ID , X.BUSINESS_UNIT , X.OMPB_BOOK_DEFN_ID , X.OMPB_BOOK_ID , X.OMPB_INSTANCE , X.NAME1 , %subrec(OMPB_DEFN_SBR, B) , %subrec(OMPB_DEFN_X_SBR, B) , %subrec(OMPB_BOOK_SBR, B) , %subrec(OMPB_BOOK_X_SBR, B) , %subrec(OMPB_INST_SBR, B) , %subrec(OMPB_INST_X_SBR, B) , X.PROCESS_INSTANCE , X.EIP_PROGRAM , X.IN_PROCESS_FLG , 'A' FROM PS_OMPB_OUT_TMP X , PS_OMPB_BOOK_INT B WHERE %Join(COMMON_KEYS, OMPB_OUT_TMP X , OMPB_BOOK_INT B)
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_PROGRAM |
Character(10) |
VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
OMPB_BOOK_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book Definition ID
|
| 6 |
OMPB_BOOK_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book ID
|
| 7 |
OMPB_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
price book instance
|
| 8 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 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_FOR_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Customer Price Book For Flag
|
| 17 |
OMPB_BOOK_FOR_OPRX |
Character(30) |
VARCHAR2(30) NOT NULL |
Criteria used to build query/sql where conditions.
|
| 18 |
OMPB_BOOK_TYPEX |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Book Type
|
| 19 |
OMPB_BOOK_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Price book description
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 21 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 22 |
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.
|
| 23 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
|
| 24 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
|
| 25 |
OMPB_NOVALMCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Missing value meaning flag
M=Assume Matching
N=Assume Not Matching
|
| 26 |
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
|
| 27 |
OMPB_COMMON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show the list price in common date and quantity ranges.
N=No
Y=Yes
|
| 28 |
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
|
| 29 |
OMPB_PRICELST_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Price list id
Prompt Table:
%EDITTABLE12
|
| 30 |
OMPB_PRICELST_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Price list id
Prompt Table:
%EDITTABLE12
|
| 31 |
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: =
|
| 32 |
OMPB_INBU_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Inventory business unit
Prompt Table:
SP_BUIN_NONVW
|
| 33 |
OMPB_INBU_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Inventory business unit
Prompt Table:
SP_BUIN_NONVW
|
| 34 |
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: =
|
| 35 |
OMPB_SCON_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Buying agreement IDs
Prompt Table:
%EDITTABLE14
|
| 36 |
OMPB_SCON_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Buying agreement IDs
Prompt Table:
%EDITTABLE14
|
| 37 |
OMPB_PRODUCT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product selection by
C=Product Catalog
G=Product Group
P=Product
Default Value: P
|
| 38 |
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: =
|
| 39 |
OMPB_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 40 |
OMPB_PRODUCT_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Product/product group
Prompt Table:
%EDITTABLE13
|
| 41 |
OMPB_PRODUCT_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Product/product group
Prompt Table:
%EDITTABLE13
|
| 42 |
OMPB_INACTPRD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include inactive products
N=No
Y=Yes
|
| 43 |
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
|
| 44 |
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: =
|
| 45 |
EFFDT_CATALOG |
Date(10) |
DATE |
Catalog Effective Date
|
| 46 |
OMPB_CATALOG_VAL |
Character(128) |
VARCHAR2(128) NOT NULL |
Product catalog value
Prompt Table:
%EDITTABLE10
|
| 47 |
OMPB_CATALOG_TO |
Character(128) |
VARCHAR2(128) NOT NULL |
Product catalog value
Prompt Table:
%EDITTABLE10
|
| 48 |
OMPB_NOVALMCH_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Missing value meaning flag
|
| 49 |
OMPB_LISTPRC_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
List price option
|
| 50 |
OMPB_COMMON_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Show the list price in common date and quantity ranges.
|
| 51 |
OMPB_PRICELST_OPRX |
Character(30) |
VARCHAR2(30) NOT NULL |
Criteria used to build query/sql where conditions.
|
| 52 |
OMPB_INBU_OPRX |
Character(30) |
VARCHAR2(30) NOT NULL |
Criteria used to build query/sql where conditions.
|
| 53 |
OMPB_SCON_OPRX |
Character(30) |
VARCHAR2(30) NOT NULL |
Criteria used to build query/sql where conditions.
|
| 54 |
OMPB_PRODUCT_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Product selection by
|
| 55 |
OMPB_PRODUCT_OPRX |
Character(30) |
VARCHAR2(30) NOT NULL |
Criteria used to build query/sql where conditions.
|
| 56 |
OMPB_INACTPRD_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Include inactive products
|
| 57 |
OMPB_CATALOG_OPRX |
Character(30) |
VARCHAR2(30) NOT NULL |
Criteria used to build query/sql where conditions.
|
| 58 |
OMPB_CATALOG_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Product catalog option
A=All Product Catalogs
N=No Product Catalogs
S=Selected Product Catalog
|
| 59 |
OMPB_DELTA_BK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price delta book flag
N=No
Y=Yes
|
| 60 |
OMPB_SRC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Source instance
|
| 61 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 62 |
RUN_DTTM |
DateTime(26) |
TIMESTAMP |
Run Date and Time
|
| 63 |
OMPB_DELTA_BK_FLGX |
Character(30) |
VARCHAR2(30) NOT NULL |
Price delta book flag
|
| 64 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 65 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 66 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|
| 67 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|