ORDENT_SCONH_VW

(SQL View)
 Index Back

Ord ent Sales Contract Header

Order entry view on sales contract header

SELECT setid , cntrct_id , scon_status , descr , cci_req_exp , contract_type_id , coo_req_exp , currency_cd , cur_rt_type , start_dt , end_dt , grace_days , grace_end_dt , sold_to_cust_id , prod_id_src , customer_group , cntct_seq_num , amt_cntrct_max , min_order_amt , nafta_req_exp , del_ord_restricted , payment_method , pref_carrier_flag , price_can_change , pct_over_amt , pymnt_terms_cd , carrier_id , carrier_id_exp , ship_type_id , ship_type_id_exp , freight_terms , freight_terms_exp , frt_chrg_method , sed_req_exp , ship_priority_id , ship_priority_exp , ship_partial_ord , ship_partial_flag , ship_prior_flag , single_ship_flag , bckordr_cncl_flag , in_line_bo_rule , default_cntrct , adjust_baprc_flg , customer_po FROM PS_SCON_HDR

  • Related Language Record: SCON_HDR_LNG

    • # 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 SCON_STATUS Character(1) VARCHAR2(1) NOT NULL Sales Contract Status
    A=Active
    C=Closed
    H=Hold
    X=Cancelled
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    10 START_DT Date(10) DATE NOT NULL Start Date
    11 END_DT Date(10) DATE NOT NULL End Date
    12 GRACE_DAYS Number(3,0) SMALLINT NOT NULL Grace Days
    13 GRACE_END_DT Date(10) DATE Grace End Date
    14 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    15 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal
    16 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
    17 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    18 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
    19 MIN_ORDER_AMT Number(16,2) DECIMAL(15,2) NOT NULL Minimum Order Amount
    20 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
    N=No
    Y=Yes
    21 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
    N=Deliveries Not Restricted
    Y=Deliveries Restricted to Order
    22 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
    23 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
    N=No Preferred Carrier
    Y=Preferred Carrier
    24 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
    N=No
    Y=Yes

    Y/N Table Edit

    25 PCT_OVER_AMT Number(3,0) SMALLINT NOT NULL % Over Amount
    26 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.
    27 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    28 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
    29 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    30 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
    31 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    32 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
    33 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity
    34 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
    N=No
    Y=Yes
    35 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
    36 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
    37 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes
    38 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
    N=Ship Partial No
    Y=Ship Partial Yes
    39 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
    N=Ship Prior No
    Y=Ship Prior Yes
    40 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    41 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
    N=Cancel Backorder No
    Y=Cancel Backorder Yes
    42 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule
    43 DEFAULT_CNTRCT Character(1) VARCHAR2(1) NOT NULL Default Contract

    Y/N Table Edit

    44 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag
    N=No
    Y=Yes
    45 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO