APS_SO_HDR_VW

(SQL View)
 Index Back

APS Integ SO Header View

10/2003 Created for APS Integration.

SELECT HED.BUSINESS_UNIT , HED.ORDER_NO , HED.ORDER_TYPE_CD , HED.SHIP_TO_CUST_ID , HED.SOLD_TO_CUST_ID , HED.BILL_TO_CUST_ID , HED.SOURCE_CD , HED.SUCCESS_PCT , HED.ORDER_DATE , HED.LASTUPDDTTM , HED.DATETIME_ADDED , CST.SETID , CST.NAME1 , CST.ADDRESS1 , CST.ADDRESS2 , CST.ADDRESS3 , CST.CITY , CST.STATE , CST.COUNTRY , CST.POSTAL FROM PS_ORD_HEADER HED , PS_SET_CNTRL_REC S , PS_APS_CUSTOMER_VW CST WHERE HED.ORDER_STATUS = 'O' AND S.SETCNTRLVALUE = HED.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER' AND S.SETID = CST.SETID AND HED.SHIP_TO_CUST_ID = CST.CUST_ID AND %EffdtCheck(APS_CUSTOMER_VW, CST, HED.ORDER_DATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 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
3 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
4 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
5 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
6 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
7 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
8 SUCCESS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Success Percent
9 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
10 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.
11 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
12 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
13 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 CITY Character(30) VARCHAR2(30) NOT NULL City
18 STATE Character(6) VARCHAR2(6) NOT NULL State
19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal