C360_ORDSUM_VW (SQL View)	Index Back
Comprehensive Customer View

C360_ORDSUM_VW

(SQL View)

Comprehensive Customer View

SELECT R.SETID ,H.SOLD_TO_CUST_ID , H.BUSINESS_UNIT , H.ORDER_NO , H.ORDER_DATE ,H.QUOTE_NBR , H.ORDER_STATUS , H.CUSTOMER_PO , H.SHIP_TO_CUST_ID ,H.ORDER_CATEGORY ,H.ORDER_GRP ,H.COUNTRY_SHIP_TO ,H.PAYMENT_METHOD ,H.PYMNT_TERMS_CD 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

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

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_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

6 QUOTE_NBR Character(15) VARCHAR2(15) NOT NULL Quotation Number

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

8 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

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

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

12 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

13 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

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

#	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
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_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
6	QUOTE_NBR	Character(15)	VARCHAR2(15) NOT NULL	Quotation Number
7	ORDER_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Order Status C=Closed O=Open P=Pending X=Canceled
8	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
9	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
10	ORDER_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Order Category 0=Normal Sales Transactions 1=Counter Sale
11	ORDER_GRP	Character(6)	VARCHAR2(6) NOT NULL	Order Group
12	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
13	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
14	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.