ORDENT_SCONL_VW

(SQL View)
 Index Back

ordentry scon line view

Order entry sales contract line view Date Initials Issue Description 081601 dms DI-MVANWINK-3 Add fields from ordent_sconl_wk

SELECT setid , cntrct_id , line_nbr , prod_id_src , prod_id_entered , product_id , prod_grp_type , customer_item_nbr , product_group , amt_cntrct_max , pct_over_amt , qty_max , qty_min , pct_over_qty , unit_of_measure , rebate_id , pymnt_terms_cd , payment_method , penalty_id , price_program , list_price , price , business_unit , std_discount , ship_to_cust_id , ds_network_code , ship_from_bu , 0 , 0 , 0 , upc_id , upn_id , customer_po , customer_po_line FROM PS_SCON_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
5 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
7 PROD_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Product Group Type
ACCT=Accounting
BO=Backorder/Reservations
CA=Contract
CLMB=Claimback Contract
CTLG=Product Catalogs
FCST=Forecast
FRT=Freight
PRC=Pricing
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources of Supply
TAX=Tax
TRPT=Transportations
VAT=VAT
WEB=WEB Order Entry
8 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
9 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
10 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
11 PCT_OVER_AMT Number(3,0) SMALLINT NOT NULL % Over Amount
12 QTY_MAX Number(16,4) DECIMAL(15,4) NOT NULL Maximum Quantity
13 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
14 PCT_OVER_QTY Number(3,0) SMALLINT NOT NULL % Over Quantity
15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
16 REBATE_ID Character(6) VARCHAR2(6) NOT NULL Rebate ID
17 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
18 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
19 PENALTY_ID Character(6) VARCHAR2(6) NOT NULL Penalty ID
20 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
21 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
22 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
24 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount
25 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
26 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
27 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
28 MAX_SCN_LN_AMT Number(3,0) SMALLINT NOT NULL Max Contract Line Amount
29 QTY_MIN_MAX_EXCEED Signed Number(2,0) DECIMAL(1) NOT NULL Min/Max Quantity Exceeded
30 TOT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
31 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
32 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
33 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
34 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line