SCN_LINE_VW(SQL View) |
Index Back |
|---|---|
Sales Contract Line View |
| SELECT A.SETID ,A.CNTRCT_ID ,A.LINE_NBR ,A.PRODUCT_ID ,A.PRODUCT_GROUP ,A.CUSTOMER_ITEM_NBR ,A.UPC_ID ,A.UPN_ID ,A.AMT_CNTRCT_MAX ,A.PCT_OVER_AMT ,A.QTY_MAX ,A.PCT_OVER_QTY ,A.UNIT_OF_MEASURE ,A.REBATE_ID ,A.PENALTY_ID ,A.PRICE_PROGRAM ,A.BUSINESS_UNIT ,A.DATETIME_ADDED ,A.LASTUPDDTTM ,A.LAST_MAINT_OPRID FROM PS_SCON_LINE A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: SCON_HDR |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: %EDITTABLE |
| 5 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Product Group
Prompt Table: %EDITTABLE2 |
| 6 | CUSTOMER_ITEM_NBR | Character(18) | VARCHAR2(18) NOT NULL | Customer Item Number |
| 7 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 8 | UPN_ID | Character(20) | VARCHAR2(20) NOT NULL | Universal Product Number |
| 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 | PCT_OVER_QTY | Number(3,0) | SMALLINT NOT NULL | % Over Quantity |
| 13 | 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 |
| 14 | REBATE_ID | Character(6) | VARCHAR2(6) NOT NULL | Rebate ID |
| 15 | PENALTY_ID | Character(6) | VARCHAR2(6) NOT NULL | Penalty ID |
| 16 | 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 |
| 17 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_OBUSET_NONVW |
| 18 | DATETIME_ADDED | DateTime(26) | TIMESTAMP | DateTime Added |
| 19 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 20 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |