ORDENT_LN_SCONH(SQL View) |
Index Back |
---|---|
Ordent scon headersSales 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 |