ORD_SCN_LN_VW(SQL View) |
Index Back |
|---|---|
Sales Cntrct Line Vw for ProdDate Init. Issue # Description 01/03/01 JJM R-SGATIG-ZV65C Changed SQL to use new tables |
| SELECT DISTINCT C.SETID ,C.SOLD_TO_CUST_ID ,C.CNTRCT_ID ,D.PRODUCT_ID ,D.LINE_NBR ,D.PRODUCT_GROUP ,B.UNIT_OF_MEASURE ,D.BUSINESS_UNIT ,B.AMT_CNTRCT_MAX ,B.PCT_OVER_AMT ,B.QTY_MAX ,B.QTY_MIN ,B.PCT_OVER_QTY ,B.PRICE_PROGRAM ,B.LIST_PRICE ,B.PRICE ,B.SHIP_TO_CUST_ID ,B.DS_NETWORK_CODE ,B.SHIP_FROM_BU FROM PS_SCON_HDR A , PS_SCON_LINE B , PS_SCON_CUST_CGRP C , PS_SCON_PROD_PGRP D WHERE A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND B.SETID = C.SETID AND B.CNTRCT_ID = C.CNTRCT_ID AND C.SETID = D.SETID AND C.CNTRCT_ID = D.CNTRCT_ID AND B.LINE_NBR = D.LINE_NBR AND A.SCON_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 3 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: SCON_HDR |
| 4 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: %EDITTABLE |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 6 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Product Group
Prompt Table: %EDITTABLE2 |
| 7 | 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: PROD_UOM |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_OBUSET_NONVW |
| 9 | AMT_CNTRCT_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Amount of Contract. |
| 10 | PCT_OVER_AMT | Number(3,0) | SMALLINT NOT NULL | % Over Amount |
| 11 | QTY_MAX | Number(16,4) | DECIMAL(15,4) NOT NULL | Maximum Quantity |
| 12 | QTY_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 13 | PCT_OVER_QTY | Number(3,0) | SMALLINT NOT NULL | % Over Quantity |
| 14 | PRICE_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL |
Date Initials Issue Description
111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
Prompt Table: EOEP_ARB_ID_VW |
| 15 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |
| 16 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 17 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: CUST_SLDSHP_VW |
| 18 | DS_NETWORK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code |
| 19 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL |
Ship from INV BU
Prompt Table: %EDITTABLE4 |