OMEC_OUT_TMP (SQL Table)	Index Back
OM Outbound Order/Quote Temp

OMEC_OUT_TMP

(SQL Table)

OM Outbound Order/Quote Temp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

4 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order

5 REVISION_NUMBER Number(3,0) SMALLINT NOT NULL Revision

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

7 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.

8 CUST_TYPE_LBL Character(1) VARCHAR2(1) NOT NULL Customer Type
B=Broker Id
S=Sold To Id

9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

10 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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
4	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
5	REVISION_NUMBER	Number(3,0)	SMALLINT NOT NULL	Revision
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	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.
8	CUST_TYPE_LBL	Character(1)	VARCHAR2(1) NOT NULL	Customer Type B=Broker Id S=Sold To Id
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
10	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.