ORDENT_LN_SCONH

(SQL View)
Index Back

Ordent scon headers

Sales contract headers associated with an existing order.

select distinct l.business_unit, l.order_no, l.cntrct_id, s.scon_status, s.cci_req_exp, s.contract_type_id, s.coo_req_exp, s.start_dt, s.end_dt, s.grace_days, s.grace_end_dt, s.sold_to_cust_id, s.prod_id_src, s.customer_group, s.cntct_seq_num, s.amt_cntrct_max, s.min_order_amt, s.nafta_req_exp, s.price_can_change, s.pct_over_amt, s.pymnt_terms_cd, s.carrier_id, s.ship_type_id, s.freight_terms, s.sed_req_exp, s.ship_priority_id, s.ship_partial_ord, s.ship_partial_flag, s.ship_prior_flag, s.bckordr_cncl_flag, s.default_cntrct from ps_set_cntrl_rec sc, PS_SCON_HDR s, ps_ord_line l where sc.setcntrlvalue = l.business_unit and sc.recname = 'SCON_HDR' and s.setid = sc.setid and s.cntrct_id = l.cntrct_id

# 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 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
4 SCON_STATUS Character(1) VARCHAR2(1) NOT NULL Sales Contract Status
A=Active
C=Closed
H=Hold
X=Cancelled
5 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
6 CONTRACT_TYPE_ID Character(6) VARCHAR2(6) NOT NULL Buying Agreement Type
7 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
8 START_DT Date(10) DATE NOT NULL Start Date
9 END_DT Date(10) DATE NOT NULL End Date
10 GRACE_DAYS Number(3,0) SMALLINT NOT NULL Grace Days
11 GRACE_END_DT Date(10) DATE Grace End Date
12 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
13 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
14 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
15 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
16 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
17 MIN_ORDER_AMT Number(16,2) DECIMAL(15,2) NOT NULL Minimum Order Amount
18 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
19 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
N=No
Y=Yes

Y/N Table Edit

20 PCT_OVER_AMT Number(3,0) SMALLINT NOT NULL % Over Amount
21 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.
22 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
23 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
24 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
25 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
26 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
27 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes
28 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
29 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
30 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
31 DEFAULT_CNTRCT Character(1) VARCHAR2(1) NOT NULL Default Contract

Y/N Table Edit