OMPB_COND_OUT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	OMPB_BOOK_DEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Customer Price Book Definition ID
5	OMPB_BOOK_ID	Character(30)	VARCHAR2(30) NOT NULL	Customer Price Book ID
6	OMPB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	price book instance
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: OMPB_CNDFLD_DVW
9	FIELDNAME_ALIAS	Character(30)	VARCHAR2(30) NOT NULL	Field Name Alias
10	OMPB_COND_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
11	OMPB_COND_VAL	Character(128)	VARCHAR2(128) NOT NULL	Conditon value Prompt Table: %EDITTABLE20
12	OMPB_COND_TO	Character(128)	VARCHAR2(128) NOT NULL	Conditon value Prompt Table: %EDITTABLE20
13	OMPB_COND_OPRX	Character(30)	VARCHAR2(30) NOT NULL	Criteria used to build query/sql where conditions.
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	PROCESS_NAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
16	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
17	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