ORD_SLD_UPLN_VW

(SQL View)
Index Back

Order lines to copy

Date Initials Issue Description 011503 dms F-CJORGENS-43 Copy of ord_sld_line_vw to include product catalogs

SELECT S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.PROD_ID_ENTERED , S.QTY_ORDERED , S.UNIT_OF_MEASURE , S.SOLD_TO_CUST_ID , S.PRICE , S.CURRENCY_CD , S.ORD_LINE_TAG , S.EFF_STATUS , P.PRODUCT_ID , S.PRODUCT_ID , S.PROD_ID_SRC , S.CONFIG_CODE FROM PS_ORD_SLD_PROD_VW S , PS_PROD_UPC_VW P WHERE P.SETID(+) = S.SETID_PRODUCT AND P.UPC_ID(+) = S.PROD_ID_ENTERED AND P.PRODUCT_ID(+) = S.PRODUCT_ID AND S.PROD_ID_SRC = 'P'

# 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_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
5 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
7 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
8 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 ORD_LINE_TAG Number(5,0) INTEGER NOT NULL Order Line tag line nbr
11 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
12 PRODUCT_ID_TEMP Character(18) VARCHAR2(18) NOT NULL Product Id Temp
13 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
14 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
15 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator