ORD_AN_SRCH (SQL View)	Index Back
Sales Orders AutoNum Add Srch Date Initials Issue # Description 01/23/01 mc SP2-DI-EDWONG-3 Change prmpt tbl for sld to cust 06/10/02 ll F-CJORGENS-56 Change prompt table for sold-to use %EDITTABLE. Add code in BUSINESS_UNIT to set it.

ORD_AN_SRCH

(SQL View)

Sales Orders AutoNum Add Srch

Date Initials Issue # Description 01/23/01 mc SP2-DI-EDWONG-3 Change prmpt tbl for sld to cust 06/10/02 ll F-CJORGENS-56 Change prompt table for sold-to use %EDITTABLE. Add code in BUSINESS_UNIT to set it.

SELECT business_unit , order_no , sold_to_cust_id , ' ' , 'N' , bill_to_cust_id , customer_po FROM PS_ORD_HEADER WHERE order_type_cd = 'SO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT
Prompt Table: SP_BU_OM2_NONVW

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
Default Value: NEXT
Prompt Table: ORD_AN_VW

3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
Prompt Table: %EDITTABLE
Set Control Field: BUSINESS_UNIT

4 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
Prompt Table: SP_BUIN_NONVW

5 STCUST_FLAG Character(1) VARCHAR2(1) NOT NULL Short-Term Customer
Y/N Table Edit
Default Value: N

6 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
Prompt Table: CUST_BLL_VW
Set Control Field: BUSINESS_UNIT

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT Prompt Table: SP_BU_OM2_NONVW
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 Default Value: NEXT Prompt Table: ORD_AN_VW
3	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: %EDITTABLE Set Control Field: BUSINESS_UNIT
4	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU Prompt Table: SP_BUIN_NONVW
5	STCUST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Short-Term Customer Y/N Table Edit Default Value: N
6	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CUST_BLL_VW Set Control Field: BUSINESS_UNIT
7	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO