OMEC_CP_OPT_DET

#	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 Prompt Table: BUS_UNIT_TBL_OM
4	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
5	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
6	CP_MODE	Character(1)	VARCHAR2(1) NOT NULL	Rule Processing Modes Field A=CRM Internal C=Model Tester M=Direct Production Order R=Direct Requisition Order S=Sales Order W=CRM External Default Value: S
7	CP_COMP_SEQ	Number(3,0)	SMALLINT NOT NULL	Component Sequence Field
8	OPTION_NAME	Character(18)	VARCHAR2(18) NOT NULL	Option Name
9	OPTION_VALUE	Character(18)	VARCHAR2(18) NOT NULL	Option Value
10	OPTION_DESC	Character(25)	VARCHAR2(25) NOT NULL	Description
11	VAR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Variable Type C=Character N=Numeric
12	VAR_LENGTH	Number(2,0)	SMALLINT NOT NULL	Variable Length
13	VAR_DECIMAL	Number(1,0)	SMALLINT NOT NULL	Varaible Decimal Field
14	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
15	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
16	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
17	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Default Value: N