OM_CC_SRCH_TMP

#	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	OM_SRCH_ORDER	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= BT=between CT=contains EN=ends with LK=begins with NL=not like Default Value: =
3	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop Prompt Table: INTFC_OM_CST_VW
4	ORDER_NO_TO	Character(10)	VARCHAR2(10) NOT NULL	To Order No Prompt Table: INTFC_OM_CST_VW
5	OM_SRCH_LIST1	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= CT=contains EN=ends with LK=begins with NL=not like Default Value: =
6	CR_CARD_AUTH_STAT	Character(1)	VARCHAR2(1) NOT NULL	Credit Card Auth Status A=Authorized B=Billed C=Credited D=Denied E=Validation Errors F=Auth Reversal G=Validated H=Auth Reversal Denied J=Reauthorize K=No Action L=Credit Card Not In Group M=Manually Approved/Settled N=Change to Terms P=Authorized and Billed R=Processing T=Cancel Order U=Unprocessed/Retry V=Pending Approval W=Deleted after Settlement X=Deleted Y=Cancelled Z=Zero Payment for Maintenance
7	OM_SRCH_CHAR1	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= CT=contains EN=ends with LK=begins with NL=not like Default Value: LK
8	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: INTFC_OM_SLD_VW
9	OM_SRCH_CHAR2	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= CT=contains EN=ends with LK=begins with NL=not like Default Value: LK
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	OM_SRCH_CHAR3	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= CT=contains EN=ends with LK=begins with NL=not like Default Value: LK
12	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: INTFC_OM_BLL_VW
13	OM_SRCH_CHAR4	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= CT=contains EN=ends with LK=begins with NL=not like Default Value: LK
14	NAME2	Character(40)	VARCHAR2(40) NOT NULL	Name 2
15	OM_SRCH_NUM1	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= BT=between Default Value: >
16	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
17	AMOUNT_1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Work Field
18	OM_SRCH_CHAR5	Character(2)	VARCHAR2(2) NOT NULL	Search Condition <=< <==<= <>=not = === >=> >==>= CT=contains EN=ends with LK=begins with NL=not like Default Value: =
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
20	PROC_CR_CARD	Character(2)	VARCHAR2(2) NOT NULL	Process Credit Card Authorization Online Date Init. Issue # Description 08/14/01 JJM F-CJORGENS-6 Credit Card Enhancements - Created Field NO=Not Enabled OL=Enabled
21	HOLD_CREDIT_CRD	Character(6)	VARCHAR2(6) NOT NULL	Credit Card Hold
22	CASEINSSEARCH	Character(1)	VARCHAR2(1) NOT NULL	Case Insensitive seach option in PSOPTIONS N=Off S=On - CaseSensitive Default On Y=On - CaseSensitive Default Off
23	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
24	CLEAR_PB	Character(1)	VARCHAR2(1) NOT NULL	Description Date Initials Issue ------------------ ------- ---------- -------- Modified field by adding a label 032105 SR 533368003 so that the mouse over text appears correctly on the price list maintenance page.
25	SEARCH_PB	Character(1)	VARCHAR2(1) NOT NULL	Search
26	SAVE_PB	Character(1)	VARCHAR2(1) NOT NULL	&Save
27	RETURN_TO_SRCH	Character(1)	VARCHAR2(1) NOT NULL	Date Initials Issue Description 022101 dms SP2 (DI-EDWONG-8) Deferred mode
28	SEND_WF_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Send WF Notification