ORD_SSRCREQ_DVW

(SQL View)
 Index Back

Supply Source Req. Dtl view

Supply Source Requisitions Detail view

SELECT BUSINESS_UNIT ,ORDER_NO ,SSRC_BUS_UNIT ,TRFT_SRC_TYPE ,SSRC_KEY2 ,SSRC_LINE_NBR ,VNDR_LOC ,DUE_DT ,BUYER_ID ,TRFT_DISPOSITION ,SHIP_TYPE_ID ,FREIGHT_TERMS ,CARRIER_ID ,INV_ITEM_ID ,PRICE_PO ,PRICE_PO_BSE ,COST ,COST_BASIS_LIMIT ,QTY_PO ,CURRENCY_CD ,CURRENCY_CD_BASE ,UNIT_OF_MEASURE FROM PS_ORD_SSRC_DTL 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
Set Control Field: SSRC_BUS_UNIT

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

6 SSRC_LINE_NBR Number(5,0) INTEGER NOT NULL Supply Source line number

Default Value: 1

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

Prompt Table: VNDR_LOC_VW1
Set Control Field: SSRC_BUS_UNIT

8 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

9 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
10 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt
11 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
12 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
13 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
16 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
17 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
18 COST_BASIS_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost Basis Limit
19 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
22 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INVITM_UOM_OVW
Set Control Field: SSRC_BUS_UNIT