C360_DS_SO_VW (SQL View)	Index Back
Order Detail Vw- All Schedules

C360_DS_SO_VW

(SQL View)

Order Detail Vw- All Schedules

SELECT R.SETID ,H.SOLD_TO_CUST_ID ,H.BUSINESS_UNIT , H.ORDER_NO , H.CUSTOMER_PO ,H.ORDER_GRP ,H.ORDER_DATE ,H.PYMNT_TERMS_CD ,H.ORDER_STATUS ,H.ORDER_CATEGORY FROM PS_ORD_HEADER H ,PS_SET_CNTRL_REC R WHERE H.ORDER_TYPE_CD = 'SO' AND R.SETCNTRLVALUE=H.BUSINESS_UNIT AND R.RECNAME='CUSTOMER' AND R.REC_GROUP_ID='FS_23'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

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: SP_BU_OM_NONVW

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 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

6 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group

7 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

8 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

9 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled

10 ORDER_CATEGORY Character(2) VARCHAR2(2) NOT NULL Order Category
0=Normal Sales Transactions
1=Counter Sale

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
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: SP_BU_OM_NONVW
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	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
6	ORDER_GRP	Character(6)	VARCHAR2(6) NOT NULL	Order Group
7	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
8	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
9	ORDER_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Order Status C=Closed O=Open P=Pending X=Canceled
10	ORDER_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Order Category 0=Normal Sales Transactions 1=Counter Sale