SCON_HDR_VW

(SQL View)
 Index Back

Sales Contract Header

Note: Any field changes made to this record should also be made to record OMB_SCNH_TAO

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 , PAYMENT_METHOD , PRICE_CAN_CHANGE , PCT_OVER_AMT , PYMNT_TERMS_CD , PREF_CARRIER_FLAG , 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 , SINGLE_SHIP_RES , BCKORDR_CNCL_FLAG , IN_LINE_BO_RULE , DEFAULT_CNTRCT , DEL_ORD_RESTRICTED , ADJUST_BAPRC_FLG , CUSTOMER_PO , CUSTOMER_PO_LINE , DATETIME_ADDED , LASTUPDDTTM , LAST_MAINT_OPRID 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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 SCON_STATUS Character(1) VARCHAR2(1) NOT NULL Buying Agreement Status
    A=Active
    C=Closed
    H=Hold
    X=Cancelled

    Default Value: A

    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

    Prompt Table: CONTRACT_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

    Prompt Table: CURRENCY_CD_TBL

    9 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Prompt Table: RT_TYPE_TBL

    10 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: %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

    Prompt Table: CUST_SLD1_VW

    15 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal

    Default Value: S

    16 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

    Prompt Table: CUSTGP_SCON_VW

    17 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CNCT_SL_VW

    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 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
    22 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    23 PCT_OVER_AMT Number(3,0) SMALLINT NOT NULL % Over Amount
    24 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.

    Prompt Table: AR_TRMS_VW

    25 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
    N=No Preferred Carrier
    Y=Preferred Carrier
    26 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: CARRIER_ID

    27 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

    Prompt Table: CARRIER_ID

    28 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    29 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

    Prompt Table: SHIP_METHOD

    30 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    31 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    32 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
    01=Order Value
    02=Weight
    03=Volume
    04=Order Quantity
    33 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
    N=No
    Y=Yes
    34 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

    Prompt Table: SHIP_PRIORITY

    35 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

    Prompt Table: SHIP_PRIORITY

    36 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes
    37 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
    N=Ship Partial No
    Y=Ship Partial Yes
    38 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
    N=Ship Prior No
    Y=Ship Prior Yes
    39 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
    N=No
    Y=Yes
    40 SINGLE_SHIP_RES Number(3,0) SMALLINT NOT NULL Single Ship Reserve
    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

    Prompt Table: IN_RULE_B_VW

    43 DEFAULT_CNTRCT Character(1) VARCHAR2(1) NOT NULL Default Contract

    Y/N Table Edit

    Default Value: N

    44 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
    N=Deliveries Not Restricted
    Y=Deliveries Restricted to Order
    45 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag
    N=No
    Y=Yes
    46 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
    47 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
    48 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    49 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.
    50 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID