RUN_OM_OMPB_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
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 Prompt Table: OMPB_BOOK
7	OMPB_BOOK_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Price book description
8	OMPB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	price book instance
9	OMPB_BOOK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Price Book Type A=Adjustments Only B=List Price and Adjustments L=List Price Only
10	OMPB_DELTA_BK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Price delta book flag N=No Y=Yes
11	OMPB_DISPDELTA_FLG	Character(1)	VARCHAR2(1) NOT NULL	Display changed only 1=Current Data 2=Changed Data 3=Deleted Data 4=All Data
12	OMPB_SRC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Source instance
13	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.
14	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
15	PT_FORMAT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Format Type HTM=HTML PDF=PDF RTF=RTF TXT=TXT XLS=XLS Default Value: PDF
16	EMAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	When the email flag is checked, the user will notified a specific user regarding an activity. N=No Y=Yes
17	DELETE_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	DELETE_CONTROL Default Value: Y