OM_EC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ACK_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Acknowledgement Status AC=Ack - With Detail and Change AD=Ack - With Detail, No Change AE=Ack - Exception Detail Only AH=Acknowledge - Hold Status AK=Ack - No Detail or Change AT=Accepted BP=Accepted - Partial Shipment DR=Accepted - Date Rescheduled IA=Accepted - Price Pending IB=Backordered IC=Accepted - Changes Made ID=Deleted IF=On Hold-Incomplete Description IH=On Hold IP=Accepted - Price Changed IQ=Accepted - Quantity Changed IS=Accepted - Substitution Made IW=On Hold - Waiver Required RD=Rejected With Detail RF=Rej - Exception Detail Only RJ=Rejected - No Detail RO=Rejected With Counter Offer SP=Accpted-Schedule Date Pending ZZ=Mutually Defined Value
3	ADDR_EC_COUNT	Number(5,0)	INTEGER NOT NULL	Address Count
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	CP	Character(1)	VARCHAR2(1) NOT NULL	Product Configuration Field
6	CP_COMP_SEQ	Number(3,0)	SMALLINT NOT NULL	Component Sequence Field
7	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
8	CUST_COUNT	Number(5,0)	INTEGER NOT NULL	Count of customers
9	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.
10	DELETE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Deletion Flag
11	DOCUMENT_CD	Character(4)	VARCHAR2(4) NOT NULL	Document Code ACKN=Order Acknowledgment ASN=Advance Shipping Notification BOL=Bill of Lading CACK=Order Change Acknowledgement CREN=Buying Agreement Renewal CSTS=Buying Agreement Status INCC=Invoice Courtesy Copy INVC=Invoice INVN=Invoice Notification PACK=Packing List PICK=Picking Plan PPRC=Product Price List PRAD=Payment Remittance Advice QUOT=Quotation RMA=Return Material Authorization
12	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table
13	EFFDT	Date(10)	DATE	Effective Date
14	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
15	EIP_DTA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EIP Dta status 0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Cancelled 7=Hold
16	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
17	ERR_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Error Sequence Number
18	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
19	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
20	FIELDNAME2	Character(18)	VARCHAR2(18) NOT NULL	Fieldname 2
21	INV_EDIT_COUNT	Number(5,0)	INTEGER NOT NULL	12/08/2004 sfc Created
22	IS_PROMPT	Character(1)	VARCHAR2(1) NOT NULL	Prompt Table Edit
23	IS_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required
24	IS_TRANSLATE	Character(1)	VARCHAR2(1) NOT NULL	Translate Edit
25	IS_YES_NO	Character(1)	VARCHAR2(1) NOT NULL	Yes/No
26	LINE_COUNT	Number(5,0)	INTEGER NOT NULL	Line Count
27	LOCK_COUNT	Number(5,0)	INTEGER NOT NULL	12/08/2004 sfc Created
28	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
29	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
30	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.
31	NOTE_COUNT	Number(5,0)	INTEGER NOT NULL	Note Count
32	OM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OM Work Flag
33	RUN_OM_BACKGRND	Character(1)	VARCHAR2(1) NOT NULL	Run Order Completion Y/N Table Edit
34	RUN_OM_PRICING	Character(1)	VARCHAR2(1) NOT NULL	Run Repricing Y/N Table Edit
35	RUN_OMCREDIT	Character(1)	VARCHAR2(1) NOT NULL	Run Credit Checking Y/N Table Edit
36	RUN_OMDEMAND	Character(1)	VARCHAR2(1) NOT NULL	Run Populate Demand Y/N Table Edit
37	RUN_OMHOLD	Character(1)	VARCHAR2(1) NOT NULL	Run Hold Checking Y/N Table Edit
38	RUN_RESERVATIONS	Character(1)	VARCHAR2(1) NOT NULL	Run Reservations Job Y/N Table Edit
39	RUN_DELIVERIES	Character(1)	VARCHAR2(1) NOT NULL	Manage Deliveries Y/N Table Edit
40	RUN_FREIGHT	Character(1)	VARCHAR2(1) NOT NULL	Perform Freight Y/N Table Edit
41	OMEC_BROKER_SQL	Character(50)	VARCHAR2(50) NOT NULL	OMEC Broker SQL
42	OMEC_BU_SQL	Character(254)	VARCHAR2(254) NOT NULL	OMEC Business Unit SQL
43	OMEC_EIP_PGM_SQL	Character(100)	VARCHAR2(100) NOT NULL	OMEC EIP Program
44	OMEC_EIPCTL_ID_SQL	Character(100)	VARCHAR2(100) NOT NULL	OMEC EIP Control ID
45	OMEC_CHUNK_SQL	Character(100)	VARCHAR2(100) NOT NULL	OMEC Chunking SQL
46	OMEC_CHUNK_TBL	Character(30)	VARCHAR2(30) NOT NULL	OMEC Chunking Table
47	OMEC_CUST_FLDNAME	Character(15)	VARCHAR2(15) NOT NULL	OMEC Customer Field Name
48	OMEC_CUST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	OMEC Customer Type
49	OMEC_SRC_CD_SQL	Character(50)	VARCHAR2(50) NOT NULL	OMEC Source Code SQL
50	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
51	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
52	OPT_DETL_COUNT	Number(5,0)	INTEGER NOT NULL	Option Detail Count
53	OPT_HDR_COUNT	Number(5,0)	INTEGER NOT NULL	Option Header Count
54	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
55	ORIG_DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Orig Date Timestamp
56	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
57	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
58	POCHG_COUNT	Number(8,0)	INTEGER NOT NULL	POCHG Count
59	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
60	PROMPT_TABLE	Character(15)	VARCHAR2(15) NOT NULL	Record Name
61	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
62	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
63	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
64	SCHED_COUNT	Number(6,0)	INTEGER NOT NULL	Schedule Count
65	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
66	SETID_CATALOG	Character(5)	VARCHAR2(5) NOT NULL	Catalog SetID
67	SETID_CONTRACT	Character(5)	VARCHAR2(5) NOT NULL	Contract Setid
68	SETID_CUST_SHIPTO	Character(5)	VARCHAR2(5) NOT NULL	Shipto Cust SetID
69	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
70	SETID_DS_NETDET	Character(5)	VARCHAR2(5) NOT NULL	ds netdet
71	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
72	SETID_NOTE	Character(5)	VARCHAR2(5) NOT NULL	SetID
73	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
74	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
75	TOTAL_EXTRACT	Number(8,0)	INTEGER NOT NULL	Extract Total
76	TRANS_ID	Character(50)	VARCHAR2(50) NOT NULL	Transaction ID
77	APPL_ID	Character(10)	VARCHAR2(10) NOT NULL	Application ID
78	OPRID_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Operator id of the owner of a document