ORD_SSRC_REQ_VW

(SQL View)
 Index Back

Supply source Header Req view

Supply source Header Requisition view

SELECT BUSINESS_UNIT , ORDER_NO , SSRC_BUS_UNIT , TRFT_SRC_TYPE , SSRC_KEY2 , VNDR_LOC , DUE_DT , BUYER_ID , TRFT_DISPOSITION , SHIP_TYPE_ID , FREIGHT_TERMS , CARRIER_ID FROM PS_ORD_SSRC_HDR WHERE TRFT_SRC_TYPE = '3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

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 SSRC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Supply Source business unit

Default Value: ORD_SSRC_HDR.SSRC_BUS_UNIT

Prompt Table: SP_BU_PM_NONVW

4 TRFT_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order
5 SSRC_KEY2 Character(30) VARCHAR2(30) NOT NULL Supply Source key

Default Value: ORD_SSRC_HDR.SSRC_KEY2

Prompt Table: VENDOR_VW4
Set Control Field: SSRC_BUS_UNIT

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_OM_VW
Set Control Field: SSRC_BUS_UNIT

7 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

Default Value: %date

8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: %EDIT_BUYER
Set Control Field: SSRC_BUS_UNIT

9 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt
10 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
11 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
12 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID