OMEC_ORDSCDT_VW (SQL View)	Index Back
Customer's Internal data-Sched This record contains the customer's internal system data. The data stored in this table is passed in from the customer. There is no processing against the data stored in this record. It is used primarily as 'pass-thru' data only. Date Initials Issue Description 031501 dms SP2 (DI-EDWONG-14) CRM Integration

OMEC_ORDSCDT_VW

(SQL View)

Customer's Internal data-Sched

This record contains the customer's internal system data. The data stored in this table is passed in from the customer. There is no processing against the data stored in this record. It is used primarily as 'pass-thru' data only. Date Initials Issue Description 031501 dms SP2 (DI-EDWONG-14) CRM Integration

SELECT A.SOURCE_CD , A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.SEQ_NUM , A.SETID , A.CUST_ID , A.REFERENCE_ID , A.TEXT80 , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_OMEC_ORD_CDATA A WHERE A.ORDER_INT_LINE_NO <> 0 AND A.SCHED_LINE_NBR <> 0

Related Language Record: OMEC_ORDSCD_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

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_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

5 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

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

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

9 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID

10 TEXT80 Character(80) VARCHAR2(80) NOT NULL 80 Char text field

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

12 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
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_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
5	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	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.
9	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID
10	TEXT80	Character(80)	VARCHAR2(80) NOT NULL	80 Char text field
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	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
13	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag